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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
3832411 | 3832411 | 2021-10-05 | India | Chandigarh | 65247 | 820 | 0 | 30.733839 | 76.76827800000002 | 2021-10-06 04:21:33 | Chandigarh, India | |||
986904 | 986904 | 2021-10-04 | India | Chandigarh | 65243 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-10-05 04:21:27 | Chandigarh, India | |||
1274214 | 1274214 | 2021-10-03 | India | Chandigarh | 65237 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-10-04 04:21:31 | Chandigarh, India | |||
3927967 | 3927967 | 2021-10-02 | India | Chandigarh | 65235 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-10-03 04:21:24 | Chandigarh, India | |||
2131947 | 2131947 | 2021-10-01 | India | Chandigarh | 65232 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-10-02 04:21:25 | Chandigarh, India | |||
2772904 | 2772904 | 2021-09-30 | India | Chandigarh | 65230 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-10-01 04:21:35 | Chandigarh, India | |||
706360 | 706360 | 2021-09-29 | India | Chandigarh | 65224 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-09-30 04:21:20 | Chandigarh, India | |||
1334202 | 1334202 | 2021-09-28 | India | Chandigarh | 65219 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-09-29 04:21:45 | Chandigarh, India | |||
1235571 | 1235571 | 2021-09-27 | India | Chandigarh | 65217 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-09-28 04:21:28 | Chandigarh, India | |||
2075872 | 2075872 | 2021-09-26 | India | Chandigarh | 65210 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-09-27 04:21:16 | Chandigarh, India | |||
1724424 | 1724424 | 2021-09-25 | India | Chandigarh | 65209 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-09-26 04:21:29 | Chandigarh, India | |||
1921144 | 1921144 | 2021-09-24 | India | Chandigarh | 65205 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-09-25 04:21:31 | Chandigarh, India | |||
601615 | 601615 | 2021-09-23 | India | Chandigarh | 65202 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-09-24 04:21:44 | Chandigarh, India | |||
3011276 | 3011276 | 2021-09-22 | India | Chandigarh | 65201 | 819 | 0 | 30.733839 | 76.76827800000002 | 2021-09-23 04:21:43 | Chandigarh, India | |||
3757414 | 3757414 | 2021-09-21 | India | Chandigarh | 65195 | 818 | 0 | 30.733839 | 76.76827800000002 | 2021-09-22 04:21:45 | Chandigarh, India | |||
809517 | 809517 | 2021-09-20 | India | Chandigarh | 65188 | 818 | 0 | 30.733839 | 76.76827800000002 | 2021-09-21 04:21:26 | Chandigarh, India | |||
1814716 | 1814716 | 2021-09-19 | India | Chandigarh | 65181 | 818 | 0 | 30.733839 | 76.76827800000002 | 2021-09-20 04:21:22 | Chandigarh, India | |||
16296 | 16296 | 2021-09-18 | India | Chandigarh | 65176 | 818 | 0 | 30.733839 | 76.76827800000002 | 2021-09-19 04:21:34 | Chandigarh, India | |||
2617981 | 2617981 | 2021-09-17 | India | Chandigarh | 65172 | 818 | 0 | 30.733839 | 76.76827800000002 | 2021-09-18 04:21:24 | Chandigarh, India | |||
2808689 | 2808689 | 2021-09-16 | India | Chandigarh | 65168 | 818 | 0 | 30.733839 | 76.76827800000002 | 2021-09-17 04:21:46 | Chandigarh, India | |||
1374434 | 1374434 | 2021-09-15 | India | Chandigarh | 65164 | 818 | 0 | 30.733839 | 76.76827800000002 | 2021-09-16 04:22:19 | Chandigarh, India | |||
2462733 | 2462733 | 2021-09-14 | India | Chandigarh | 65162 | 818 | 0 | 30.733839 | 76.76827800000002 | 2021-09-15 03:22:37 | Chandigarh, India | |||
1385572 | 1385572 | 2021-09-13 | India | Chandigarh | 65160 | 817 | 0 | 30.733839 | 76.76827800000002 | 2021-09-14 04:21:41 | Chandigarh, India | |||
1884941 | 1884941 | 2021-09-12 | India | Chandigarh | 65154 | 817 | 0 | 30.733839 | 76.76827800000002 | 2021-09-13 04:21:15 | Chandigarh, India | |||
3805844 | 3805844 | 2021-09-11 | India | Chandigarh | 65149 | 816 | 0 | 30.733839 | 76.76827800000002 | 2021-09-12 04:21:13 | Chandigarh, India | |||
3448784 | 3448784 | 2021-09-10 | India | Chandigarh | 65145 | 816 | 0 | 30.733839 | 76.76827800000002 | 2021-09-11 04:21:30 | Chandigarh, India | |||
1262730 | 1262730 | 2021-09-09 | India | Chandigarh | 65142 | 816 | 0 | 30.733839 | 76.76827800000002 | 2021-09-10 04:21:20 | Chandigarh, India | |||
2279100 | 2279100 | 2021-09-08 | India | Chandigarh | 65138 | 815 | 0 | 30.733839 | 76.76827800000002 | 2021-09-09 04:21:27 | Chandigarh, India | |||
641879 | 641879 | 2021-09-07 | India | Chandigarh | 65124 | 815 | 0 | 30.733839 | 76.76827800000002 | 2021-09-08 04:21:31 | Chandigarh, India | |||
3193942 | 3193942 | 2021-09-06 | India | Chandigarh | 65122 | 814 | 0 | 30.733839 | 76.76827800000002 | 2021-09-07 04:21:35 | Chandigarh, India | |||
3280810 | 3280810 | 2021-09-05 | India | Chandigarh | 65121 | 814 | 0 | 30.733839 | 76.76827800000002 | 2021-09-06 04:21:22 | Chandigarh, India | |||
249224 | 249224 | 2021-09-04 | India | Chandigarh | 65119 | 814 | 0 | 30.733839 | 76.76827800000002 | 2021-09-05 04:21:33 | Chandigarh, India | |||
3974505 | 3974505 | 2021-09-03 | India | Chandigarh | 65114 | 814 | 0 | 30.733839 | 76.76827800000002 | 2021-09-04 04:21:28 | Chandigarh, India | |||
177967 | 177967 | 2021-09-02 | India | Chandigarh | 65110 | 814 | 0 | 30.733839 | 76.76827800000002 | 2021-09-03 04:21:20 | Chandigarh, India | |||
67002 | 67002 | 2021-09-01 | India | Chandigarh | 65108 | 814 | 0 | 30.733839 | 76.76827800000002 | 2021-09-02 04:21:15 | Chandigarh, India | |||
2067844 | 2067844 | 2021-08-31 | India | Chandigarh | 65105 | 813 | 0 | 30.733839 | 76.76827800000002 | 2021-09-01 04:21:38 | Chandigarh, India | |||
1775298 | 1775298 | 2021-08-30 | India | Chandigarh | 65099 | 813 | 0 | 30.733839 | 76.76827800000002 | 2021-08-31 04:21:46 | Chandigarh, India | |||
3891872 | 3891872 | 2021-08-29 | India | Chandigarh | 65093 | 813 | 0 | 30.733839 | 76.76827800000002 | 2021-08-30 04:21:23 | Chandigarh, India | |||
2792975 | 2792975 | 2021-08-28 | India | Chandigarh | 65087 | 813 | 0 | 30.733839 | 76.76827800000002 | 2021-08-29 04:21:14 | Chandigarh, India | |||
2923134 | 2923134 | 2021-08-27 | India | Chandigarh | 65084 | 812 | 0 | 30.733839 | 76.76827800000002 | 2021-08-28 04:21:28 | Chandigarh, India | |||
1596148 | 1596148 | 2021-08-26 | India | Chandigarh | 65077 | 812 | 0 | 30.733839 | 76.76827800000002 | 2021-08-27 04:21:37 | Chandigarh, India | |||
32357 | 32357 | 2021-08-25 | India | Chandigarh | 65071 | 812 | 0 | 30.733839 | 76.76827800000002 | 2021-08-26 04:21:28 | Chandigarh, India | |||
3105396 | 3105396 | 2021-08-24 | India | Chandigarh | 65069 | 812 | 0 | 30.733839 | 76.76827800000002 | 2021-08-25 04:21:41 | Chandigarh, India | |||
3165567 | 3165567 | 2021-08-23 | India | Chandigarh | 65068 | 812 | 0 | 30.733839 | 76.76827800000002 | 2021-08-24 04:21:19 | Chandigarh, India | |||
2175494 | 2175494 | 2021-08-22 | India | Chandigarh | 65066 | 812 | 0 | 30.733839 | 76.76827800000002 | 2021-08-23 04:21:27 | Chandigarh, India | |||
3555590 | 3555590 | 2021-08-21 | India | Chandigarh | 62062 | 812 | 0 | 30.733839 | 76.76827800000002 | 2021-08-22 04:21:29 | Chandigarh, India | |||
1853932 | 1853932 | 2021-08-20 | India | Chandigarh | 62056 | 812 | 0 | 30.733839 | 76.76827800000002 | 2021-08-21 04:21:38 | Chandigarh, India | |||
511639 | 511639 | 2021-08-19 | India | Chandigarh | 62051 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-20 04:21:33 | Chandigarh, India | |||
2518118 | 2518118 | 2021-08-18 | India | Chandigarh | 62045 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-19 04:21:15 | Chandigarh, India | |||
245210 | 245210 | 2021-08-17 | India | Chandigarh | 62035 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-18 04:21:35 | Chandigarh, India | |||
1604173 | 1604173 | 2021-08-16 | India | Chandigarh | 62031 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-17 04:21:49 | Chandigarh, India | |||
103267 | 103267 | 2021-08-15 | India | Chandigarh | 62029 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-16 04:21:31 | Chandigarh, India | |||
507625 | 507625 | 2021-08-14 | India | Chandigarh | 62028 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-15 04:21:41 | Chandigarh, India | |||
1483497 | 1483497 | 2021-08-13 | India | Chandigarh | 62024 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-14 04:21:25 | Chandigarh, India | |||
2899627 | 2899627 | 2021-08-12 | India | Chandigarh | 62009 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-13 04:21:24 | Chandigarh, India | |||
1342231 | 1342231 | 2021-08-11 | India | Chandigarh | 61997 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-12 04:21:25 | Chandigarh, India | |||
2351378 | 2351378 | 2021-08-10 | India | Chandigarh | 61992 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-11 04:21:58 | Chandigarh, India | |||
649907 | 649907 | 2021-08-09 | India | Chandigarh | 61984 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-10 04:21:27 | Chandigarh, India | |||
589569 | 589569 | 2021-08-08 | India | Chandigarh | 61978 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-09 04:21:24 | Chandigarh, India | |||
2203581 | 2203581 | 2021-08-07 | India | Chandigarh | 61974 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-08 04:21:33 | Chandigarh, India | |||
1117531 | 1117531 | 2021-08-06 | India | Chandigarh | 61970 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-07 04:21:30 | Chandigarh, India | |||
1956468 | 1956468 | 2021-08-05 | India | Chandigarh | 61966 | 811 | 0 | 30.733839 | 76.76827800000002 | 2021-08-06 04:21:18 | Chandigarh, India | |||
331847 | 331847 | 2021-08-04 | India | Chandigarh | 61965 | 811 | 61123 | 31 | 30.733839 | 76.76827800000002 | 2021-08-05 04:21:51 | Chandigarh, India | ||
3468118 | 3468118 | 2021-08-03 | India | Chandigarh | 61965 | 811 | 61120 | 34 | 30.733839 | 76.76827800000002 | 2021-08-04 04:21:25 | Chandigarh, India | ||
3683392 | 3683392 | 2021-08-02 | India | Chandigarh | 61960 | 811 | 61116 | 33 | 30.733839 | 76.76827800000002 | 2021-08-03 04:21:39 | Chandigarh, India | ||
3015291 | 3015291 | 2021-08-01 | India | Chandigarh | 61954 | 811 | 61113 | 30 | 30.733839 | 76.76827800000002 | 2021-08-02 04:21:36 | Chandigarh, India | ||
3903914 | 3903914 | 2021-07-31 | India | Chandigarh | 61953 | 811 | 61111 | 31 | 30.733839 | 76.76827800000002 | 2021-08-01 04:21:50 | Chandigarh, India | ||
3296119 | 3296119 | 2021-07-30 | India | Chandigarh | 61952 | 810 | 61106 | 36 | 30.733839 | 76.76827800000002 | 2021-07-31 04:21:35 | Chandigarh, India | ||
3385330 | 3385330 | 2021-07-29 | India | Chandigarh | 61948 | 809 | 61102 | 37 | 30.733839 | 76.76827800000002 | 2021-07-30 04:21:34 | Chandigarh, India | ||
408235 | 408235 | 2021-07-28 | India | Chandigarh | 61943 | 809 | 61098 | 36 | 30.733839 | 76.76827800000002 | 2021-07-29 04:21:33 | Chandigarh, India | ||
1306096 | 1306096 | 2021-07-27 | India | Chandigarh | 61938 | 809 | 61092 | 37 | 30.733839 | 76.76827800000002 | 2021-07-28 04:21:39 | Chandigarh, India | ||
3218239 | 3218239 | 2021-07-26 | India | Chandigarh | 61931 | 809 | 61086 | 36 | 30.733839 | 76.76827800000002 | 2021-07-27 04:21:18 | Chandigarh, India | ||
1378448 | 1378448 | 2021-07-25 | India | Chandigarh | 61927 | 809 | 61085 | 33 | 30.733839 | 76.76827800000002 | 2021-07-26 04:21:28 | Chandigarh, India | ||
1330188 | 1330188 | 2021-07-24 | India | Chandigarh | 61922 | 809 | 61081 | 32 | 30.733839 | 76.76827800000002 | 2021-07-25 04:22:12 | Chandigarh, India | ||
3137492 | 3137492 | 2021-07-23 | India | Chandigarh | 61917 | 809 | 61073 | 35 | 30.733839 | 76.76827800000002 | 2021-07-24 00:21:36 | Chandigarh, India | ||
3476252 | 3476252 | 2021-07-22 | India | Chandigarh | 61916 | 809 | 61073 | 34 | 30.733839 | 76.76827800000002 | 2021-07-23 04:21:29 | Chandigarh, India | ||
3331471 | 3331471 | 2021-07-21 | India | Chandigarh | 61914 | 809 | 61064 | 41 | 30.733839 | 76.76827800000002 | 2021-07-22 04:21:19 | Chandigarh, India | ||
2371452 | 2371452 | 2021-07-20 | India | Chandigarh | 61907 | 809 | 61056 | 42 | 30.733839 | 76.76827800000002 | 2021-07-21 04:21:40 | Chandigarh, India | ||
483531 | 483531 | 2021-07-19 | India | Chandigarh | 61893 | 809 | 61038 | 46 | 30.733839 | 76.76827800000002 | 2021-07-20 04:21:48 | Chandigarh, India | ||
2673754 | 2673754 | 2021-07-18 | India | Chandigarh | 61889 | 809 | 61030 | 50 | 30.733839 | 76.76827800000002 | 2021-07-19 04:21:24 | Chandigarh, India | ||
3706066 | 3706066 | 2021-07-17 | India | Chandigarh | 61870 | 809 | 61008 | 53 | 30.733839 | 76.76827800000002 | 2021-07-18 04:22:07 | Chandigarh, India | ||
2947297 | 2947297 | 2021-07-16 | India | Chandigarh | 61862 | 809 | 60995 | 58 | 30.733839 | 76.76827800000002 | 2021-07-17 04:22:22 | Chandigarh, India | ||
295953 | 295953 | 2021-07-15 | India | Chandigarh | 61856 | 809 | 60980 | 67 | 30.733839 | 76.76827800000002 | 2021-07-16 04:21:22 | Chandigarh, India | ||
3631898 | 3631898 | 2021-07-14 | India | Chandigarh | 61851 | 809 | 60970 | 72 | 30.733839 | 76.76827800000002 | 2021-07-15 04:21:48 | Chandigarh, India | ||
578773 | 578773 | 2021-07-13 | India | Chandigarh | 61844 | 809 | 60958 | 77 | 30.733839 | 76.76827800000002 | 2021-07-14 04:21:35 | Chandigarh, India | ||
3741022 | 3741022 | 2021-07-12 | India | Chandigarh | 61841 | 809 | 60939 | 93 | 30.733839 | 76.76827800000002 | 2021-07-13 04:21:18 | Chandigarh, India | ||
3659535 | 3659535 | 2021-07-11 | India | Chandigarh | 61831 | 809 | 60926 | 96 | 30.733839 | 76.76827800000002 | 2021-07-12 04:21:34 | Chandigarh, India | ||
625819 | 625819 | 2021-07-10 | India | Chandigarh | 61823 | 809 | 60914 | 100 | 30.733839 | 76.76827800000002 | 2021-07-11 04:21:43 | Chandigarh, India | ||
829538 | 829538 | 2021-07-09 | India | Chandigarh | 61811 | 809 | 60901 | 101 | 30.733839 | 76.76827800000002 | 2021-07-10 04:21:25 | Chandigarh, India | ||
778302 | 778302 | 2021-07-08 | India | Chandigarh | 61794 | 809 | 60885 | 100 | 30.733839 | 76.76827800000002 | 2021-07-09 04:21:21 | Chandigarh, India | ||
1440524 | 1440524 | 2021-07-07 | India | Chandigarh | 61780 | 809 | 60872 | 99 | 30.733839 | 76.76827800000002 | 2021-07-08 04:21:26 | Chandigarh, India | ||
2693629 | 2693629 | 2021-07-06 | India | Chandigarh | 61752 | 809 | 60837 | 106 | 30.733839 | 76.76827800000002 | 2021-07-07 04:21:20 | Chandigarh, India | ||
1932378 | 1932378 | 2021-07-05 | India | Chandigarh | 61740 | 809 | 60815 | 116 | 30.733839 | 76.76827800000002 | 2021-07-06 04:21:32 | 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]);