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 = "Chhattisgarh" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3435878 | 3435878 | 2020-07-11 | India | Chhattisgarh | 3897 | 17 | 3070 | 810 | 21.264705 | 82.035366 | 2020-07-12 04:34:30 | Chhattisgarh, India | ||
3237376 | 3237376 | 2020-07-10 | India | Chhattisgarh | 3767 | 17 | 3028 | 722 | 21.264705 | 82.035366 | 2020-07-11 04:34:26 | Chhattisgarh, India | ||
1005361 | 1005361 | 2020-07-09 | India | Chhattisgarh | 3675 | 15 | 2903 | 757 | 21.264705 | 82.035366 | 2020-07-10 04:34:24 | Chhattisgarh, India | ||
2222577 | 2222577 | 2020-07-08 | India | Chhattisgarh | 3525 | 14 | 2835 | 676 | 21.264705 | 82.035366 | 2020-07-09 04:34:23 | Chhattisgarh, India | ||
887186 | 887186 | 2020-07-07 | India | Chhattisgarh | 3415 | 14 | 2751 | 650 | 21.264705 | 82.035366 | 2020-07-08 05:33:48 | Chhattisgarh, India | ||
2684746 | 2684746 | 2020-07-06 | India | Chhattisgarh | 3305 | 14 | 2667 | 624 | 21.264705 | 82.035366 | 2020-07-07 04:34:00 | Chhattisgarh, India | ||
415211 | 415211 | 2020-07-05 | India | Chhattisgarh | 3207 | 14 | 2601 | 592 | 21.264705 | 82.035366 | 2020-07-06 04:33:57 | Chhattisgarh, India | ||
529773 | 529773 | 2020-07-04 | India | Chhattisgarh | 3161 | 14 | 2549 | 598 | 21.264705 | 82.035366 | 2020-07-05 04:33:46 | Chhattisgarh, India | ||
2234434 | 2234434 | 2020-07-03 | India | Chhattisgarh | 3065 | 14 | 2437 | 614 | 21.264705 | 82.035366 | 2020-07-04 04:33:51 | Chhattisgarh, India | ||
3045228 | 3045228 | 2020-07-02 | India | Chhattisgarh | 3013 | 14 | 2385 | 614 | 21.264705 | 82.035366 | 2020-07-03 04:33:54 | Chhattisgarh, India | ||
302919 | 302919 | 2020-07-01 | India | Chhattisgarh | 2940 | 14 | 2303 | 623 | 21.264705 | 82.035366 | 2020-07-02 04:33:46 | Chhattisgarh, India | ||
2974297 | 2974297 | 2020-06-30 | India | Chhattisgarh | 2860 | 13 | 2250 | 597 | 21.264705 | 82.035366 | 2020-07-01 04:33:52 | Chhattisgarh, India | ||
2632774 | 2632774 | 2020-06-29 | India | Chhattisgarh | 2761 | 13 | 2173 | 575 | 21.264705 | 82.035366 | 2020-06-30 04:33:48 | Chhattisgarh, India | ||
2306337 | 2306337 | 2020-06-28 | India | Chhattisgarh | 2662 | 13 | 2091 | 558 | 21.264705 | 82.035366 | 2020-06-29 04:33:44 | Chhattisgarh, India | ||
2039672 | 2039672 | 2020-06-27 | India | Chhattisgarh | 2545 | 13 | 1914 | 618 | 21.264705 | 82.035366 | 2020-06-28 04:34:04 | Chhattisgarh, India | ||
1135953 | 1135953 | 2020-06-26 | India | Chhattisgarh | 2545 | 13 | 1914 | 618 | 21.264705 | 82.035366 | 2020-06-27 04:33:35 | Chhattisgarh, India | ||
2624940 | 2624940 | 2020-06-25 | India | Chhattisgarh | 2452 | 12 | 1755 | 685 | 21.264705 | 82.035366 | 2020-06-26 04:33:43 | Chhattisgarh, India | ||
2700580 | 2700580 | 2020-06-24 | India | Chhattisgarh | 2419 | 12 | 1627 | 780 | 21.264705 | 82.035366 | 2020-06-25 05:26:54 | Chhattisgarh, India | ||
1522265 | 1522265 | 2020-06-23 | India | Chhattisgarh | 2362 | 12 | 1553 | 797 | 21.264705 | 82.035366 | 2020-06-24 04:33:28 | Chhattisgarh, India | ||
1510459 | 1510459 | 2020-06-22 | India | Chhattisgarh | 2303 | 12 | 1513 | 778 | 21.264705 | 82.035366 | 2020-06-23 04:33:22 | Chhattisgarh, India | ||
3249198 | 3249198 | 2020-06-21 | India | Chhattisgarh | 2275 | 11 | 1447 | 817 | 21.264705 | 82.035366 | 2020-06-22 04:33:20 | Chhattisgarh, India | ||
2437791 | 2437791 | 2020-06-20 | India | Chhattisgarh | 2041 | 11 | 1394 | 636 | 21.264705 | 82.035366 | 2020-06-21 04:33:19 | Chhattisgarh, India | ||
1691369 | 1691369 | 2020-06-19 | India | Chhattisgarh | 2028 | 10 | 1331 | 687 | 21.264705 | 82.035366 | 2020-06-20 04:33:19 | Chhattisgarh, India | ||
3682518 | 3682518 | 2020-06-18 | India | Chhattisgarh | 1946 | 10 | 1228 | 708 | 21.264705 | 82.035366 | 2020-06-19 04:33:17 | Chhattisgarh, India | ||
1195721 | 1195721 | 2020-06-17 | India | Chhattisgarh | 1864 | 10 | 1180 | 674 | 21.264705 | 82.035366 | 2020-06-18 04:33:18 | Chhattisgarh, India | ||
2386484 | 2386484 | 2020-06-16 | India | Chhattisgarh | 1781 | 9 | 1036 | 736 | 21.264705 | 82.035366 | 2020-06-17 04:33:21 | Chhattisgarh, India | ||
287047 | 287047 | 2020-06-15 | India | Chhattisgarh | 1756 | 8 | 890 | 858 | 21.264705 | 82.035366 | 2020-06-16 04:33:09 | Chhattisgarh, India | ||
1836998 | 1836998 | 2020-06-14 | India | Chhattisgarh | 1512 | 6 | 631 | 875 | 21.264705 | 82.035366 | 2020-06-15 03:33:14 | Chhattisgarh, India | ||
3061050 | 3061050 | 2020-06-13 | India | Chhattisgarh | 1429 | 6 | 550 | 873 | 21.264705 | 82.035366 | 2020-06-14 03:33:15 | Chhattisgarh, India | ||
737370 | 737370 | 2020-06-12 | India | Chhattisgarh | 1398 | 6 | 447 | 945 | 21.264705 | 82.035366 | 2020-06-13 03:33:14 | Chhattisgarh, India | ||
1273340 | 1273340 | 2020-06-11 | India | Chhattisgarh | 1398 | 6 | 447 | 945 | 21.264705 | 82.035366 | 2020-06-12 05:09:52 | Chhattisgarh, India | ||
2863784 | 2863784 | 2020-06-10 | India | Chhattisgarh | 1240 | 6 | 386 | 848 | 21.264705 | 82.035366 | 2020-06-11 03:33:41 | Chhattisgarh, 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]);