johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
25 rows where deaths = 5238 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2967543 | 2967543 | 2022-10-10 | Netherlands | Zuid-Holland | 1773409 | 5238 | 0 | 51.937835 | 4.462114 | 2022-10-11 04:23:05 | Zuid-Holland, Netherlands | |||
3097579 | 3097579 | 2022-10-09 | Netherlands | Zuid-Holland | 1773409 | 5238 | 0 | 51.937835 | 4.462114 | 2022-10-10 04:22:32 | Zuid-Holland, Netherlands | |||
4002804 | 4002804 | 2022-10-08 | Netherlands | Zuid-Holland | 1773409 | 5238 | 0 | 51.937835 | 4.462114 | 2022-10-09 04:21:16 | Zuid-Holland, Netherlands | |||
396401 | 396401 | 2022-10-07 | Netherlands | Zuid-Holland | 1773409 | 5238 | 0 | 51.937835 | 4.462114 | 2022-10-08 04:22:56 | Zuid-Holland, Netherlands | |||
3405714 | 3405714 | 2022-07-17 | Russia | Tula Oblast | 158731 | 5238 | 0 | 53.9570701 | 37.3690909 | 2022-07-18 04:20:59 | Tula Oblast, Russia | |||
3445169 | 3445169 | 2022-05-11 | Sweden | Stockholm | 572466 | 5238 | 0 | 59.6025 | 18.1384 | 2022-05-12 04:20:54 | Stockholm, Sweden | |||
3535786 | 3535786 | 2022-05-10 | Sweden | Stockholm | 572466 | 5238 | 0 | 59.6025 | 18.1384 | 2022-05-11 04:20:48 | Stockholm, Sweden | |||
222321 | 222321 | 2022-05-09 | Sweden | Stockholm | 572466 | 5238 | 0 | 59.6025 | 18.1384 | 2022-05-10 04:20:50 | Stockholm, Sweden | |||
2331706 | 2331706 | 2022-05-08 | Sweden | Stockholm | 572466 | 5238 | 0 | 59.6025 | 18.1384 | 2022-05-09 04:20:54 | Stockholm, Sweden | |||
360668 | 360668 | 2022-05-07 | Sweden | Stockholm | 572466 | 5238 | 0 | 59.6025 | 18.1384 | 2022-05-08 04:20:49 | Stockholm, Sweden | |||
1398019 | 1398019 | 2022-05-06 | Sweden | Stockholm | 572466 | 5238 | 0 | 59.6025 | 18.1384 | 2022-05-07 04:21:09 | Stockholm, Sweden | |||
2598374 | 2598374 | 2022-05-05 | Sweden | Stockholm | 572466 | 5238 | 0 | 59.6025 | 18.1384 | 2022-05-06 04:21:00 | Stockholm, Sweden | |||
463972 | 463972 | 2022-05-02 | US | California | San Diego | 6073 | 814292 | 5238 | 0 | 33.03484597 | -116.7365326 | 2022-05-03 04:21:00 | San Diego, California, US | |
3916611 | 3916611 | 2022-05-01 | US | California | San Diego | 6073 | 814292 | 5238 | 0 | 33.03484597 | -116.7365326 | 2022-05-02 04:21:10 | San Diego, California, US | |
2841415 | 2841415 | 2022-04-30 | US | California | San Diego | 6073 | 814292 | 5238 | 0 | 33.03484597 | -116.7365326 | 2022-05-01 04:20:57 | San Diego, California, US | |
1157728 | 1157728 | 2022-04-29 | US | California | San Diego | 6073 | 814292 | 5238 | 0 | 33.03484597 | -116.7365326 | 2022-04-30 04:21:05 | San Diego, California, US | |
1296286 | 1296286 | 2022-02-05 | US | New York | New York | 36061 | 395372 | 5238 | 0 | 40.76727260000001 | -73.97152637 | 2022-02-06 04:21:00 | New York, New York, US | |
2329614 | 2329614 | 2022-02-04 | US | New York | New York | 36061 | 394835 | 5238 | 0 | 40.76727260000001 | -73.97152637 | 2022-02-05 04:21:05 | New York, New York, US | |
3844187 | 3844187 | 2022-01-15 | Zimbabwe | 225637 | 5238 | 0 | -19.015438 | 29.154857 | 2022-01-16 04:21:12 | Zimbabwe | ||||
103002 | 103002 | 2022-01-14 | Zimbabwe | 225637 | 5238 | 0 | -19.015438 | 29.154857 | 2022-01-15 04:21:07 | Zimbabwe | ||||
2123778 | 2123778 | 2021-10-21 | Kenya | 252375 | 5238 | 0 | -0.0236 | 37.9062 | 2021-10-22 04:21:14 | Kenya | ||||
443390 | 443390 | 2021-10-20 | Kenya | 252308 | 5238 | 0 | -0.0236 | 37.9062 | 2021-10-21 04:21:18 | Kenya | ||||
1235743 | 1235743 | 2021-09-27 | Mexico | Queretaro | 92666 | 5238 | 0 | 20.5888 | -100.3899 | 2021-09-28 04:21:28 | Queretaro, Mexico | |||
335536 | 335536 | 2021-08-04 | Ukraine | Kiev | 219576 | 5238 | 209777 | 4561 | 50.4501 | 30.5234 | 2021-08-05 04:21:51 | Kiev, Ukraine | ||
3978448 | 3978448 | 2021-02-10 | Croatia | 236333 | 5238 | 228499 | 2596 | 45.1 | 15.2 | 2021-02-11 05:23:55 | Croatia |
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]);