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 = "Kerala" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3435994 | 3435994 | 2020-07-11 | India | Kerala | 7438 | 29 | 3963 | 3446 | 10.450898 | 76.405749 | 2020-07-12 04:34:30 | Kerala, India | ||
3237492 | 3237492 | 2020-07-10 | India | Kerala | 6950 | 27 | 3820 | 3103 | 10.450898 | 76.405749 | 2020-07-11 04:34:26 | Kerala, India | ||
1005477 | 1005477 | 2020-07-09 | India | Kerala | 6534 | 27 | 3708 | 2799 | 10.450898 | 76.405749 | 2020-07-10 04:34:24 | Kerala, India | ||
2222693 | 2222693 | 2020-07-08 | India | Kerala | 6195 | 27 | 3559 | 2609 | 10.450898 | 76.405749 | 2020-07-09 04:34:23 | Kerala, India | ||
887302 | 887302 | 2020-07-07 | India | Kerala | 5894 | 27 | 3452 | 2415 | 10.450898 | 76.405749 | 2020-07-08 05:33:48 | Kerala, India | ||
2684862 | 2684862 | 2020-07-06 | India | Kerala | 5622 | 27 | 3341 | 2254 | 10.450898 | 76.405749 | 2020-07-07 04:34:00 | Kerala, India | ||
415327 | 415327 | 2020-07-05 | India | Kerala | 5429 | 25 | 3174 | 2230 | 10.450898 | 76.405749 | 2020-07-06 04:33:57 | Kerala, India | ||
529889 | 529889 | 2020-07-04 | India | Kerala | 5204 | 25 | 3048 | 2131 | 10.450898 | 76.405749 | 2020-07-05 04:33:46 | Kerala, India | ||
2234550 | 2234550 | 2020-07-03 | India | Kerala | 4964 | 25 | 2841 | 2098 | 10.450898 | 76.405749 | 2020-07-04 04:33:51 | Kerala, India | ||
3045344 | 3045344 | 2020-07-02 | India | Kerala | 4753 | 25 | 2640 | 2088 | 10.450898 | 76.405749 | 2020-07-03 04:33:54 | Kerala, India | ||
303035 | 303035 | 2020-07-01 | India | Kerala | 4593 | 24 | 2439 | 2130 | 10.450898 | 76.405749 | 2020-07-02 04:33:46 | Kerala, India | ||
2974413 | 2974413 | 2020-06-30 | India | Kerala | 4442 | 24 | 2306 | 2112 | 10.450898 | 76.405749 | 2020-07-01 04:33:52 | Kerala, India | ||
2632890 | 2632890 | 2020-06-29 | India | Kerala | 4189 | 22 | 2152 | 2015 | 10.450898 | 76.405749 | 2020-06-30 04:33:48 | Kerala, India | ||
2306453 | 2306453 | 2020-06-28 | India | Kerala | 4189 | 22 | 2152 | 2015 | 10.450898 | 76.405749 | 2020-06-29 04:33:44 | Kerala, India | ||
2039788 | 2039788 | 2020-06-27 | India | Kerala | 4071 | 22 | 2110 | 1939 | 10.450898 | 76.405749 | 2020-06-28 04:34:04 | Kerala, India | ||
1136069 | 1136069 | 2020-06-26 | India | Kerala | 3876 | 22 | 2008 | 1846 | 10.450898 | 76.405749 | 2020-06-27 04:33:35 | Kerala, India | ||
2625056 | 2625056 | 2020-06-25 | India | Kerala | 3726 | 22 | 1943 | 1761 | 10.450898 | 76.405749 | 2020-06-26 04:33:43 | Kerala, India | ||
2700696 | 2700696 | 2020-06-24 | India | Kerala | 3603 | 22 | 1888 | 1693 | 10.450898 | 76.405749 | 2020-06-25 05:26:54 | Kerala, India | ||
1522381 | 1522381 | 2020-06-23 | India | Kerala | 3451 | 22 | 1809 | 1620 | 10.450898 | 76.405749 | 2020-06-24 04:33:28 | Kerala, India | ||
1510575 | 1510575 | 2020-06-22 | India | Kerala | 3310 | 21 | 1749 | 1540 | 10.450898 | 76.405749 | 2020-06-23 04:33:22 | Kerala, India | ||
3249314 | 3249314 | 2020-06-21 | India | Kerala | 3172 | 21 | 1661 | 1490 | 10.450898 | 76.405749 | 2020-06-22 04:33:20 | Kerala, India | ||
2437907 | 2437907 | 2020-06-20 | India | Kerala | 3039 | 21 | 1568 | 1450 | 10.450898 | 76.405749 | 2020-06-21 04:33:19 | Kerala, India | ||
1691485 | 1691485 | 2020-06-19 | India | Kerala | 2912 | 21 | 1511 | 1380 | 10.450898 | 76.405749 | 2020-06-20 04:33:19 | Kerala, India | ||
3682634 | 3682634 | 2020-06-18 | India | Kerala | 2794 | 21 | 1415 | 1358 | 10.450898 | 76.405749 | 2020-06-19 04:33:17 | Kerala, India | ||
1195837 | 1195837 | 2020-06-17 | India | Kerala | 2697 | 20 | 1326 | 1351 | 10.450898 | 76.405749 | 2020-06-18 04:33:18 | Kerala, India | ||
2386600 | 2386600 | 2020-06-16 | India | Kerala | 2622 | 20 | 1236 | 1366 | 10.450898 | 76.405749 | 2020-06-17 04:33:21 | Kerala, India | ||
287163 | 287163 | 2020-06-15 | India | Kerala | 2543 | 20 | 1175 | 1348 | 10.450898 | 76.405749 | 2020-06-16 04:33:09 | Kerala, India | ||
1837114 | 1837114 | 2020-06-14 | India | Kerala | 2407 | 19 | 1046 | 1342 | 10.450898 | 76.405749 | 2020-06-15 03:33:14 | Kerala, India | ||
3061166 | 3061166 | 2020-06-13 | India | Kerala | 2322 | 19 | 1000 | 1303 | 10.450898 | 76.405749 | 2020-06-14 03:33:15 | Kerala, India | ||
737486 | 737486 | 2020-06-12 | India | Kerala | 2244 | 18 | 968 | 1258 | 10.450898 | 76.405749 | 2020-06-13 03:33:14 | Kerala, India | ||
1273456 | 1273456 | 2020-06-11 | India | Kerala | 2244 | 18 | 968 | 1258 | 10.450898 | 76.405749 | 2020-06-12 05:09:52 | Kerala, India | ||
2863899 | 2863899 | 2020-06-10 | India | Kerala | 2096 | 16 | 848 | 1232 | 10.450898 | 76.405749 | 2020-06-11 03:33:41 | Kerala, 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]);