johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where confirmed = 33047 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 15
- Russia 2
- Brazil 1
- Colombia 1
- Netherlands 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1150948 | 1150948 | 2022-12-12 | US | Montana | Flathead | 30029 | 33047 | 299 | 0 | 48.29575866 | -114.0520569 | 2022-12-11 23:21:04 | Flathead, Montana, US | |
870802 | 870802 | 2022-12-11 | US | Montana | Flathead | 30029 | 33047 | 299 | 0 | 48.29575866 | -114.0520569 | 2022-12-11 23:21:04 | Flathead, Montana, US | |
259332 | 259332 | 2022-12-10 | US | Montana | Flathead | 30029 | 33047 | 299 | 0 | 48.29575866 | -114.0520569 | 2022-12-11 04:20:50 | Flathead, Montana, US | |
3938046 | 3938046 | 2022-12-09 | US | Montana | Flathead | 30029 | 33047 | 299 | 0 | 48.29575866 | -114.0520569 | 2022-12-10 04:21:02 | Flathead, Montana, US | |
3379378 | 3379378 | 2022-12-08 | US | Montana | Flathead | 30029 | 33047 | 299 | 0 | 48.29575866 | -114.0520569 | 2022-12-09 04:21:05 | Flathead, Montana, US | |
1986649 | 1986649 | 2022-12-07 | US | Montana | Flathead | 30029 | 33047 | 299 | 0 | 48.29575866 | -114.0520569 | 2022-12-08 04:21:07 | Flathead, Montana, US | |
3716172 | 3716172 | 2022-12-06 | US | Montana | Flathead | 30029 | 33047 | 299 | 0 | 48.29575866 | -114.0520569 | 2022-12-07 04:20:58 | Flathead, Montana, US | |
2416877 | 2416877 | 2022-12-05 | US | Montana | Flathead | 30029 | 33047 | 299 | 0 | 48.29575866 | -114.0520569 | 2022-12-06 04:21:03 | Flathead, Montana, US | |
720485 | 720485 | 2022-12-04 | US | Montana | Flathead | 30029 | 33047 | 299 | 0 | 48.29575866 | -114.0520569 | 2022-12-05 04:20:58 | Flathead, Montana, US | |
2818774 | 2818774 | 2022-12-03 | US | Montana | Flathead | 30029 | 33047 | 299 | 0 | 48.29575866 | -114.0520569 | 2022-12-04 04:20:56 | Flathead, Montana, US | |
835630 | 835630 | 2022-12-02 | US | Montana | Flathead | 30029 | 33047 | 299 | 0 | 48.29575866 | -114.0520569 | 2022-12-03 04:21:02 | Flathead, Montana, US | |
433619 | 433619 | 2022-11-03 | US | New York | Oswego | 36075 | 33047 | 215 | 0 | 43.42778894 | -76.14635194 | 2022-11-04 04:22:11 | Oswego, New York, US | |
3888147 | 3888147 | 2022-06-06 | US | Arkansas | Sebastian | 5131 | 33047 | 524 | 0 | 35.19605503 | -94.27162713 | 2022-06-07 04:21:08 | Sebastian, Arkansas, US | |
99535 | 99535 | 2022-01-14 | Russia | Karachay-Cherkess Republic | 33047 | 919 | 0 | 43.7368326 | 41.7267991 | 2022-01-15 04:21:07 | Karachay-Cherkess Republic, Russia | |||
3124483 | 3124483 | 2021-11-05 | US | Tennessee | Montgomery | 47125 | 33047 | 343 | 0 | 36.49609412 | -87.38550661 | 2021-11-06 04:21:51 | Montgomery, Tennessee, US | |
1302173 | 1302173 | 2021-04-01 | Netherlands | Friesland | 33047 | 448 | 0 | 32559 | 53.087337 | 5.7925 | 2021-04-02 04:20:36 | Friesland, Netherlands | ||
1580008 | 1580008 | 2021-03-13 | Colombia | Quindio | 33047 | 985 | 31561 | 501 | 4.461 | -75.6674 | 2021-03-14 05:25:37 | Quindio, Colombia | ||
472096 | 472096 | 2021-02-19 | US | Florida | Escambia | 12033 | 33047 | 607 | 0 | 32440 | 30.67652764 | -87.37284571 | 2021-02-20 05:22:51 | Escambia, Florida, US |
1920609 | 1920609 | 2020-08-10 | Brazil | Tocantins | 33047 | 474 | 19603 | 12225 | -10.1753 | -48.2982 | 2020-08-11 04:35:08 | Tocantins, Brazil | ||
1920552 | 1920552 | 2020-08-10 | Russia | Saint Petersburg | 33047 | 2156 | 24087 | 6804 | 59.960673899999996 | 30.158655100000004 | 2020-08-11 04:35:08 | Saint Petersburg, Russia |
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]);