johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where active = 8272 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3242625 | 3242625 | 2021-04-21 | Spain | Melilla | 8485 | 88 | 125 | 8272 | 35.2923 | -2.9381 | 2021-04-22 04:20:53 | Melilla, Spain | ||
3979674 | 3979674 | 2021-02-10 | US | Indiana | Kosciusko | 18085 | 8375 | 103 | 0 | 8272 | 41.24521668 | -85.86312322 | 2021-02-11 05:23:55 | Kosciusko, Indiana, US |
614085 | 614085 | 2021-02-08 | US | Alabama | St. Clair | 1115 | 8458 | 186 | 0 | 8272 | 33.71902176 | -86.31029372 | 2021-02-09 05:23:30 | St. Clair, Alabama, US |
1676520 | 1676520 | 2021-02-01 | Jordan | 328062 | 4326 | 315464 | 8272 | 31.24 | 36.51 | 2021-02-02 05:22:49 | Jordan | |||
12431 | 12431 | 2021-01-26 | Mexico | Nayarit | 9540 | 1268 | 0 | 8272 | 21.7514 | -104.8455 | 2021-01-27 05:23:41 | Nayarit, Mexico | ||
2227486 | 2227486 | 2021-01-02 | India | Tamil Nadu | 819845 | 12146 | 799427 | 8272 | 11.006091 | 78.400624 | 2021-01-03 05:22:52 | Tamil Nadu, India | ||
3772660 | 3772660 | 2020-12-22 | US | Rhode Island | Kent | 44003 | 8436 | 164 | 0 | 8272 | 41.67106337 | -71.57641596 | 2020-12-23 05:22:03 | Kent, Rhode Island, US |
930476 | 930476 | 2020-12-21 | US | Rhode Island | Kent | 44003 | 8436 | 164 | 0 | 8272 | 41.67106337 | -71.57641596 | 2020-12-22 05:22:33 | Kent, Rhode Island, US |
2122497 | 2122497 | 2020-12-20 | US | Rhode Island | Kent | 44003 | 8436 | 164 | 0 | 8272 | 41.67106337 | -71.57641596 | 2020-12-21 05:27:58 | Kent, Rhode Island, US |
2934004 | 2934004 | 2020-12-19 | US | Rhode Island | Kent | 44003 | 8436 | 164 | 0 | 8272 | 41.67106337 | -71.57641596 | 2020-12-20 05:27:32 | Kent, Rhode Island, US |
1903950 | 1903950 | 2020-12-18 | US | Rhode Island | Kent | 44003 | 8436 | 164 | 0 | 8272 | 41.67106337 | -71.57641596 | 2020-12-19 05:27:52 | Kent, Rhode Island, US |
2130776 | 2130776 | 2020-12-17 | US | Rhode Island | Kent | 44003 | 8436 | 164 | 0 | 8272 | 41.67106337 | -71.57641596 | 2020-12-18 05:28:18 | Kent, Rhode Island, US |
3152376 | 3152376 | 2020-12-16 | US | Rhode Island | Kent | 44003 | 8436 | 164 | 0 | 8272 | 41.67106337 | -71.57641596 | 2020-12-17 05:28:12 | Kent, Rhode Island, US |
74840 | 74840 | 2020-12-03 | Brazil | Rondonia | 81733 | 1586 | 71875 | 8272 | -11.5057 | -63.5806 | 2020-12-04 05:27:27 | Rondonia, Brazil | ||
2935354 | 2935354 | 2020-11-28 | Netherlands | Groningen | 8512 | 48 | 0 | 8272 | 53.217922 | 6.741514 | 2020-11-29 05:25:55 | Groningen, Netherlands | ||
823811 | 823811 | 2020-11-19 | US | New York | Onondaga | 36067 | 8494 | 222 | 0 | 8272 | 43.00491923 | -76.19971155 | 2020-11-20 05:26:28 | Onondaga, New York, US |
1730447 | 1730447 | 2020-11-08 | US | Missouri | Unassigned | 90029 | 8272 | 0 | 0 | 8272 | 40.47945588 | 0.0 | 2020-11-09 05:25:45 | Unassigned, Missouri, US |
1729565 | 1729565 | 2020-11-08 | US | Indiana | Hamilton | 18057 | 8418 | 146 | 0 | 8272 | 40.07306535 | -86.05244729 | 2020-11-09 05:25:45 | Hamilton, Indiana, US |
1056126 | 1056126 | 2020-10-23 | US | North Carolina | Forsyth | 37067 | 8388 | 116 | 0 | 8272 | 36.12859861 | -80.25459052 | 2020-10-24 04:24:46 | Forsyth, North Carolina, US |
762917 | 762917 | 2020-10-18 | US | Colorado | El Paso | 8041 | 9782 | 206 | 0 | 8272 | 38.83240149 | -104.5251411 | 2020-10-19 04:24:16 | El Paso, Colorado, US |
1825422 | 1825422 | 2020-10-04 | US | Pennsylvania | Bucks | 42017 | 8889 | 617 | 0 | 8272 | 40.33682119 | -75.10836643 | 2020-10-05 04:23:33 | Bucks, Pennsylvania, US |
1355210 | 1355210 | 2020-09-03 | US | Hawaii | Honolulu | 15003 | 8339 | 67 | 0 | 8272 | 21.45803166 | -157.97121819999995 | 2020-09-04 04:28:26 | Honolulu, Hawaii, US |
3790231 | 3790231 | 2020-08-05 | US | California | Contra Costa | 6013 | 8395 | 122 | 0 | 8272 | 37.91923498 | -121.9289527 | 2020-08-06 04:35:02 | Contra Costa, California, US |
177232 | 177232 | 2020-07-27 | Peru | Loreto | 10721 | 2449 | 0 | 8272 | -4.124847 | -74.424115 | 2020-07-28 04:58:43 | Loreto, Peru | ||
285322 | 285322 | 2020-06-15 | US | Washington | King | 53033 | 8867 | 595 | 0 | 8272 | 47.49137892 | -121.8346131 | 2020-06-16 04:33:09 | King, Washington, US |
1210622 | 1210622 | 2020-06-09 | Spain | Castilla - La Mancha | 17609 | 2945 | 6392 | 8272 | 39.2796 | -3.0977 | 2020-06-10 04:07:00 | Castilla - La Mancha, Spain |
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]);