johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
933 rows where country_or_region = "India" and province_or_state = "Chandigarh" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687406 | 3687406 | 2022-01-13 | India | Chandigarh | 71303 | 1084 | 0 | 30.733839 | 76.76827800000002 | 2022-01-14 04:21:54 | Chandigarh, India | |||
3612990 | 3612990 | 2022-01-12 | India | Chandigarh | 71303 | 1084 | 0 | 30.733839 | 76.76827800000002 | 2022-01-13 08:00:09 | Chandigarh, India | |||
1113515 | 1113515 | 2022-01-11 | India | Chandigarh | 69388 | 1081 | 0 | 30.733839 | 76.76827800000002 | 2022-01-12 04:21:44 | Chandigarh, India | |||
1692243 | 1692243 | 2022-01-10 | India | Chandigarh | 69388 | 1081 | 0 | 30.733839 | 76.76827800000002 | 2022-01-11 04:22:01 | Chandigarh, India | |||
126658 | 126658 | 2022-01-09 | India | Chandigarh | 68421 | 1080 | 0 | 30.733839 | 76.76827800000002 | 2022-01-10 04:22:07 | Chandigarh, India | |||
1215493 | 1215493 | 2022-01-08 | India | Chandigarh | 67755 | 1080 | 0 | 30.733839 | 76.76827800000002 | 2022-01-09 04:21:46 | Chandigarh, India | |||
1389586 | 1389586 | 2022-01-07 | India | Chandigarh | 67214 | 1080 | 0 | 30.733839 | 76.76827800000002 | 2022-01-08 04:21:53 | Chandigarh, India | |||
2609973 | 2609973 | 2022-01-06 | India | Chandigarh | 66824 | 1080 | 0 | 30.733839 | 76.76827800000002 | 2022-01-07 04:22:09 | Chandigarh, India | |||
1281915 | 1281915 | 2022-01-05 | India | Chandigarh | 66493 | 1080 | 0 | 30.733839 | 76.76827800000002 | 2022-01-06 04:22:09 | Chandigarh, India | |||
1285931 | 1285931 | 2022-01-04 | India | Chandigarh | 66264 | 1079 | 0 | 30.733839 | 76.76827800000002 | 2022-01-05 04:21:59 | Chandigarh, India | |||
1700275 | 1700275 | 2022-01-03 | India | Chandigarh | 66136 | 1079 | 0 | 30.733839 | 76.76827800000002 | 2022-01-04 04:22:17 | Chandigarh, India | |||
3519358 | 3519358 | 2022-01-02 | India | Chandigarh | 66061 | 1079 | 0 | 30.733839 | 76.76827800000002 | 2022-01-03 02:22:25 | Chandigarh, India | |||
2167488 | 2167488 | 2022-01-01 | India | Chandigarh | 65965 | 1079 | 0 | 30.733839 | 76.76827800000002 | 2022-01-02 04:20:52 | Chandigarh, India | |||
2776919 | 2776919 | 2021-12-31 | India | Chandigarh | 65895 | 1079 | 0 | 30.733839 | 76.76827800000002 | 2022-01-01 04:22:14 | Chandigarh, India | |||
3998576 | 3998576 | 2021-12-30 | India | Chandigarh | 65846 | 1079 | 0 | 30.733839 | 76.76827800000002 | 2021-12-31 04:21:50 | Chandigarh, India | |||
1668383 | 1668383 | 2021-12-29 | India | Chandigarh | 65829 | 1079 | 0 | 30.733839 | 76.76827800000002 | 2021-12-30 04:21:25 | Chandigarh, India | |||
1432492 | 1432492 | 2021-12-28 | India | Chandigarh | 65796 | 1079 | 0 | 30.733839 | 76.76827800000002 | 2021-12-29 03:21:43 | Chandigarh, India | |||
730453 | 730453 | 2021-12-27 | India | Chandigarh | 65781 | 1078 | 0 | 30.733839 | 76.76827800000002 | 2021-12-28 04:21:47 | Chandigarh, India | |||
2111625 | 2111625 | 2021-12-26 | India | Chandigarh | 65774 | 1078 | 0 | 30.733839 | 76.76827800000002 | 2021-12-27 04:21:58 | Chandigarh, India | |||
3604997 | 3604997 | 2021-12-25 | India | Chandigarh | 65764 | 1078 | 0 | 30.733839 | 76.76827800000002 | 2021-12-26 04:21:50 | Chandigarh, India | |||
2963315 | 2963315 | 2021-12-24 | India | Chandigarh | 65754 | 1078 | 0 | 30.733839 | 76.76827800000002 | 2021-12-25 04:21:37 | Chandigarh, India | |||
3816347 | 3816347 | 2021-12-23 | India | Chandigarh | 65742 | 1078 | 0 | 30.733839 | 76.76827800000002 | 2021-12-24 04:21:34 | Chandigarh, India | |||
798355 | 798355 | 2021-12-22 | India | Chandigarh | 65731 | 1078 | 0 | 30.733839 | 76.76827800000002 | 2021-12-23 04:21:21 | Chandigarh, India | |||
3828395 | 3828395 | 2021-12-21 | India | Chandigarh | 65726 | 1078 | 0 | 30.733839 | 76.76827800000002 | 2021-12-22 04:21:54 | Chandigarh, India | |||
1254698 | 1254698 | 2021-12-20 | India | Chandigarh | 65717 | 1078 | 0 | 30.733839 | 76.76827800000002 | 2021-12-21 03:21:27 | Chandigarh, India | |||
2903641 | 2903641 | 2021-12-19 | India | Chandigarh | 65703 | 1077 | 0 | 30.733839 | 76.76827800000002 | 2021-12-20 04:21:43 | Chandigarh, India | |||
1258714 | 1258714 | 2021-12-18 | India | Chandigarh | 65678 | 1076 | 0 | 30.733839 | 76.76827800000002 | 2021-12-19 04:21:11 | Chandigarh, India | |||
2398742 | 2398742 | 2021-12-17 | India | Chandigarh | 65673 | 1076 | 0 | 30.733839 | 76.76827800000002 | 2021-12-18 02:22:20 | Chandigarh, India | |||
1716280 | 1716280 | 2021-12-16 | India | Chandigarh | 65673 | 1076 | 0 | 30.733839 | 76.76827800000002 | 2021-12-17 04:22:14 | Chandigarh, India | |||
3496114 | 3496114 | 2021-12-15 | India | Chandigarh | 65659 | 1076 | 0 | 30.733839 | 76.76827800000002 | 2021-12-16 04:22:11 | Chandigarh, India | |||
2087899 | 2087899 | 2021-12-14 | India | Chandigarh | 65651 | 1076 | 0 | 30.733839 | 76.76827800000002 | 2021-12-15 03:22:16 | Chandigarh, India | |||
782316 | 782316 | 2021-12-13 | India | Chandigarh | 65645 | 1076 | 0 | 30.733839 | 76.76827800000002 | 2021-12-14 04:22:38 | Chandigarh, India | |||
1660351 | 1660351 | 2021-12-12 | India | Chandigarh | 65633 | 1076 | 0 | 30.733839 | 76.76827800000002 | 2021-12-13 04:22:02 | Chandigarh, India | |||
1664367 | 1664367 | 2021-12-11 | India | Chandigarh | 65623 | 1076 | 0 | 30.733839 | 76.76827800000002 | 2021-12-12 04:22:12 | Chandigarh, India | |||
3655519 | 3655519 | 2021-12-10 | India | Chandigarh | 65515 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-12-11 04:22:45 | Chandigarh, India | |||
1077850 | 1077850 | 2021-12-09 | India | Chandigarh | 65515 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-12-10 04:22:28 | Chandigarh, India | |||
550699 | 550699 | 2021-12-08 | India | Chandigarh | 65515 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-12-09 04:22:49 | Chandigarh, India | |||
404219 | 404219 | 2021-12-07 | India | Chandigarh | 65508 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-12-08 04:22:46 | Chandigarh, India | |||
1030301 | 1030301 | 2021-12-06 | India | Chandigarh | 65500 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-12-07 04:22:34 | Chandigarh, India | |||
1740464 | 1740464 | 2021-12-05 | India | Chandigarh | 65488 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-12-06 04:22:34 | Chandigarh, India | |||
137896 | 137896 | 2021-12-04 | India | Chandigarh | 65478 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-12-05 04:22:25 | Chandigarh, India | |||
2195549 | 2195549 | 2021-12-03 | India | Chandigarh | 65478 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-12-04 04:22:18 | Chandigarh, India | |||
255 | 255 | 2021-12-02 | India | Chandigarh | 65475 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-12-03 04:23:05 | Chandigarh, India | |||
1144854 | 1144854 | 2021-12-01 | India | Chandigarh | 65471 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-12-02 04:22:37 | Chandigarh, India | |||
3401366 | 3401366 | 2021-11-30 | India | Chandigarh | 65465 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-12-01 04:22:29 | Chandigarh, India | |||
149909 | 149909 | 2021-11-29 | India | Chandigarh | 65456 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-30 04:22:53 | Chandigarh, India | |||
1231555 | 1231555 | 2021-11-28 | India | Chandigarh | 65448 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-29 04:22:30 | Chandigarh, India | |||
1358262 | 1358262 | 2021-11-27 | India | Chandigarh | 65443 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-28 04:22:43 | Chandigarh, India | |||
758253 | 758253 | 2021-11-26 | India | Chandigarh | 65438 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-27 04:22:45 | Chandigarh, India | |||
1802670 | 1802670 | 2021-11-25 | India | Chandigarh | 65430 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-26 04:22:33 | Chandigarh, India | |||
904104 | 904104 | 2021-11-24 | India | Chandigarh | 65421 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-25 04:22:33 | Chandigarh, India | |||
3069954 | 3069954 | 2021-11-23 | India | Chandigarh | 65415 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-24 04:22:14 | Chandigarh, India | |||
3749052 | 3749052 | 2021-11-22 | India | Chandigarh | 65410 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-23 04:22:39 | Chandigarh, India | |||
1014259 | 1014259 | 2021-11-21 | India | Chandigarh | 65406 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-22 04:22:20 | Chandigarh, India | |||
722423 | 722423 | 2021-11-20 | India | Chandigarh | 65400 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-21 04:22:13 | Chandigarh, India | |||
161953 | 161953 | 2021-11-19 | India | Chandigarh | 65398 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-20 04:22:17 | Chandigarh, India | |||
3288840 | 3288840 | 2021-11-18 | India | Chandigarh | 65394 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-19 04:21:40 | Chandigarh, India | |||
447296 | 447296 | 2021-11-17 | India | Chandigarh | 65391 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-18 04:21:33 | Chandigarh, India | |||
3342546 | 3342546 | 2021-11-16 | India | Chandigarh | 65390 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-17 04:21:48 | Chandigarh, India | |||
2287382 | 2287382 | 2021-11-15 | India | Chandigarh | 65389 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-16 04:21:10 | Chandigarh, India | |||
1322156 | 1322156 | 2021-11-14 | India | Chandigarh | 65384 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-15 04:21:36 | Chandigarh, India | |||
686282 | 686282 | 2021-11-13 | India | Chandigarh | 65380 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-14 04:21:31 | Chandigarh, India | |||
714391 | 714391 | 2021-11-12 | India | Chandigarh | 65378 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-13 04:21:38 | Chandigarh, India | |||
28341 | 28341 | 2021-11-11 | India | Chandigarh | 65376 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-12 04:22:01 | Chandigarh, India | |||
2844780 | 2844780 | 2021-11-10 | India | Chandigarh | 65373 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-11 04:21:45 | Chandigarh, India | |||
87050 | 87050 | 2021-11-09 | India | Chandigarh | 65371 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-10 04:21:38 | Chandigarh, India | |||
3639478 | 3639478 | 2021-11-08 | India | Chandigarh | 65366 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-09 04:21:36 | Chandigarh, India | |||
2000586 | 2000586 | 2021-11-07 | India | Chandigarh | 65362 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-08 04:21:43 | Chandigarh, India | |||
495577 | 495577 | 2021-11-06 | India | Chandigarh | 65360 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-07 04:21:53 | Chandigarh, India | |||
3121432 | 3121432 | 2021-11-05 | India | Chandigarh | 65359 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-06 04:21:51 | Chandigarh, India | |||
698330 | 698330 | 2021-11-04 | India | Chandigarh | 65357 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-05 04:21:54 | Chandigarh, India | |||
276108 | 276108 | 2021-11-03 | India | Chandigarh | 65356 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-04 04:22:20 | Chandigarh, India | |||
43633 | 43633 | 2021-11-02 | India | Chandigarh | 65355 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-03 06:22:09 | Chandigarh, India | |||
3511329 | 3511329 | 2021-11-01 | India | Chandigarh | 65354 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-02 04:22:03 | Chandigarh, India | |||
287921 | 287921 | 2021-10-31 | India | Chandigarh | 65351 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-11-01 04:22:01 | Chandigarh, India | |||
2720927 | 2720927 | 2021-10-30 | India | Chandigarh | 65346 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-31 04:22:08 | Chandigarh, India | |||
567029 | 567029 | 2021-10-29 | India | Chandigarh | 65340 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-30 04:22:03 | Chandigarh, India | |||
4271 | 4271 | 2021-10-28 | India | Chandigarh | 65335 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-29 04:22:03 | Chandigarh, India | |||
534661 | 534661 | 2021-10-27 | India | Chandigarh | 65331 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-28 04:22:08 | Chandigarh, India | |||
3492098 | 3492098 | 2021-10-26 | India | Chandigarh | 65326 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-27 04:22:32 | Chandigarh, India | |||
3793820 | 3793820 | 2021-10-25 | India | Chandigarh | 65325 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-26 04:22:09 | Chandigarh, India | |||
682266 | 682266 | 2021-10-24 | India | Chandigarh | 65323 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-25 04:22:31 | Chandigarh, India | |||
770274 | 770274 | 2021-10-23 | India | Chandigarh | 65321 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-24 04:21:22 | Chandigarh, India | |||
653921 | 653921 | 2021-10-22 | India | Chandigarh | 65320 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-23 04:21:32 | Chandigarh, India | |||
2123668 | 2123668 | 2021-10-21 | India | Chandigarh | 65315 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-22 04:21:14 | Chandigarh, India | |||
443280 | 443280 | 2021-10-20 | India | Chandigarh | 65312 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-21 04:21:18 | Chandigarh, India | |||
597599 | 597599 | 2021-10-19 | India | Chandigarh | 65310 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-20 04:21:00 | Chandigarh, India | |||
2043776 | 2043776 | 2021-10-18 | India | Chandigarh | 65306 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-19 04:20:54 | Chandigarh, India | |||
1909137 | 1909137 | 2021-10-17 | India | Chandigarh | 65302 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-18 04:21:10 | Chandigarh, India | |||
934726 | 934726 | 2021-10-16 | India | Chandigarh | 65299 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-17 04:21:29 | Chandigarh, India | |||
2943281 | 2943281 | 2021-10-15 | India | Chandigarh | 65297 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-16 04:21:15 | Chandigarh, India | |||
491561 | 491561 | 2021-10-14 | India | Chandigarh | 65295 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-15 04:21:26 | Chandigarh, India | |||
633849 | 633849 | 2021-10-13 | India | Chandigarh | 65285 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-14 04:21:29 | Chandigarh, India | |||
1491527 | 1491527 | 2021-10-12 | India | Chandigarh | 65285 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-13 04:20:51 | Chandigarh, India | |||
3007260 | 3007260 | 2021-10-11 | India | Chandigarh | 65280 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-12 04:21:09 | Chandigarh, India | |||
423276 | 423276 | 2021-10-10 | India | Chandigarh | 65279 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-11 04:21:31 | Chandigarh, India | |||
2876133 | 2876133 | 2021-10-09 | India | Chandigarh | 65277 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-10 04:21:38 | Chandigarh, India | |||
2959299 | 2959299 | 2021-10-08 | India | Chandigarh | 65273 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-09 04:21:34 | Chandigarh, India | |||
467337 | 467337 | 2021-10-07 | India | Chandigarh | 65268 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-08 04:21:25 | Chandigarh, India | |||
2458717 | 2458717 | 2021-10-06 | India | Chandigarh | 65252 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-07 04:21:36 | Chandigarh, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);