johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
16 rows where confirmed = 30148 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 3
- US 14
- Mali 1
- Netherlands 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1370876 | 1370876 | 2022-09-21 | US | Alabama | Houston | 1069 | 30148 | 522 | 0 | 31.15197924 | -85.29939599 | 2022-09-22 04:22:56 | Houston, Alabama, US | |
2017106 | 2017106 | 2022-09-20 | US | Alabama | Houston | 1069 | 30148 | 522 | 0 | 31.15197924 | -85.29939599 | 2022-09-21 04:23:22 | Houston, Alabama, US | |
3570979 | 3570979 | 2022-09-19 | US | Alabama | Houston | 1069 | 30148 | 522 | 0 | 31.15197924 | -85.29939599 | 2022-09-20 04:22:48 | Houston, Alabama, US | |
419718 | 419718 | 2022-09-18 | US | Alabama | Houston | 1069 | 30148 | 522 | 0 | 31.15197924 | -85.29939599 | 2022-09-19 04:21:49 | Houston, Alabama, US | |
3373742 | 3373742 | 2022-09-17 | US | Alabama | Houston | 1069 | 30148 | 522 | 0 | 31.15197924 | -85.29939599 | 2022-09-18 04:22:50 | Houston, Alabama, US | |
2355850 | 2355850 | 2022-09-16 | US | Alabama | Houston | 1069 | 30148 | 522 | 0 | 31.15197924 | -85.29939599 | 2022-09-17 04:20:19 | Houston, Alabama, US | |
3987007 | 3987007 | 2022-09-15 | US | Alabama | Houston | 1069 | 30148 | 522 | 0 | 31.15197924 | -85.29939599 | 2022-09-16 04:21:19 | Houston, Alabama, US | |
2334179 | 2334179 | 2022-05-08 | US | Rhode Island | Unassigned | 90044 | 30148 | 10 | 0 | 41.87064746 | 0.0 | 2022-05-09 04:20:54 | Unassigned, Rhode Island, US | |
363141 | 363141 | 2022-05-07 | US | Rhode Island | Unassigned | 90044 | 30148 | 10 | 0 | 41.87064746 | 0.0 | 2022-05-08 04:20:49 | Unassigned, Rhode Island, US | |
1400492 | 1400492 | 2022-05-06 | US | Rhode Island | Unassigned | 90044 | 30148 | 10 | 0 | 41.87064746 | 0.0 | 2022-05-07 04:21:09 | Unassigned, Rhode Island, US | |
3076308 | 3076308 | 2022-02-09 | US | New York | Rensselaer | 36083 | 30148 | 240 | 0 | 42.71348136 | -73.51089874 | 2022-02-10 04:21:14 | Rensselaer, New York, US | |
2474026 | 2474026 | 2022-02-03 | Mali | 30148 | 715 | 0 | 17.570692 | -3.996166000000001 | 2022-02-04 04:21:10 | Mali | ||||
3819977 | 3819977 | 2021-12-23 | US | Wisconsin | Kenosha | 55059 | 30148 | 448 | 0 | 42.57639354 | -88.04051686 | 2021-12-24 04:21:34 | Kenosha, Wisconsin, US | |
3759270 | 3759270 | 2021-09-21 | US | Mississippi | DeSoto | 28033 | 30148 | 352 | 0 | 34.87625235 | -89.99091418 | 2021-09-22 04:21:45 | DeSoto, Mississippi, US | |
3085423 | 3085423 | 2021-04-05 | Netherlands | Groningen | 30148 | 225 | 0 | 31173 | 53.217922 | 6.741514 | 2021-04-06 04:20:32 | Groningen, Netherlands | ||
1747044 | 1747044 | 2021-03-20 | US | Ohio | Stark | 39151 | 30148 | 900 | 0 | 40.81482476 | -81.36437305 | 2021-03-21 05:25:44 | Stark, Ohio, US |
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]);