johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
12 rows where confirmed = 30391 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3368302 | 3368302 | 2022-07-02 | US | Tennessee | Maury | 47119 | 30391 | 353 | 0 | 35.6187413 | -87.07462444 | 2022-07-03 04:20:59 | Maury, Tennessee, US | |
2525437 | 2525437 | 2022-03-02 | Mali | 30391 | 722 | 0 | 17.570692 | -3.996166000000001 | 2022-03-03 04:21:01 | Mali | ||||
1362669 | 1362669 | 2022-02-08 | Sweden | Jamtland Harjedalen | 30391 | 145 | 0 | 63.1712 | 14.9592 | 2022-02-09 04:21:04 | Jamtland Harjedalen, Sweden | |||
1016684 | 1016684 | 2021-11-21 | US | North Carolina | Onslow | 37133 | 30391 | 272 | 0 | 34.72607366 | -77.42908179 | 2021-11-22 04:22:20 | Onslow, North Carolina, US | |
724848 | 724848 | 2021-11-20 | US | North Carolina | Onslow | 37133 | 30391 | 272 | 0 | 34.72607366 | -77.42908179 | 2021-11-21 04:22:13 | Onslow, North Carolina, US | |
164378 | 164378 | 2021-11-19 | US | North Carolina | Onslow | 37133 | 30391 | 272 | 0 | 34.72607366 | -77.42908179 | 2021-11-20 04:22:17 | Onslow, North Carolina, US | |
3974012 | 3974012 | 2021-06-11 | US | Washington | Yakima | 53077 | 30391 | 447 | 0 | 46.45738486 | -120.7380126 | 2021-06-12 04:22:22 | Yakima, Washington, US | |
1954676 | 1954676 | 2021-05-21 | US | New Jersey | Gloucester | 34015 | 30391 | 634 | 0 | 39.71581067 | -75.13995546 | 2021-05-22 04:20:45 | Gloucester, New Jersey, US | |
3068648 | 3068648 | 2021-02-27 | US | Pennsylvania | Chester | 42029 | 30391 | 731 | 0 | 29660 | 39.97291773 | -75.74768357 | 2021-02-28 05:22:20 | Chester, Pennsylvania, US |
910132 | 910132 | 2021-01-19 | US | Missouri | St. Charles | 29183 | 30391 | 316 | 0 | 30075 | 38.77875681 | -90.66662425 | 2021-01-20 05:21:54 | St. Charles, Missouri, US |
1751121 | 1751121 | 2020-12-14 | Colombia | Meta | 30391 | 674 | 28655 | 1062 | 3.272 | -73.0877 | 2020-12-15 05:26:38 | Meta, Colombia | ||
1632147 | 1632147 | 2020-12-05 | Colombia | Cesar | 30391 | 926 | 27737 | 1728 | 9.3373 | -73.6536 | 2020-12-06 05:26:18 | Cesar, Colombia |
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]);