johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
27 rows where deaths = 3273 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3995305 | 3995305 | 2022-09-27 | US | Connecticut | Hartford | 9003 | 216511 | 3273 | 0 | 41.80283011 | -72.73103891 | 2022-09-28 04:23:01 | Hartford, Connecticut, US | |
3405637 | 3405637 | 2022-07-17 | Peru | Ucayali | 39746 | 3273 | 0 | -9.621718 | -73.444929 | 2022-07-18 04:20:59 | Ucayali, Peru | |||
2151837 | 2151837 | 2022-07-16 | Peru | Ucayali | 39746 | 3273 | 0 | -9.621718 | -73.444929 | 2022-07-17 04:21:15 | Ucayali, Peru | |||
2419070 | 2419070 | 2022-07-15 | Peru | Ucayali | 39746 | 3273 | 0 | -9.621718 | -73.444929 | 2022-07-16 04:21:05 | Ucayali, Peru | |||
3429145 | 3429145 | 2022-07-14 | Peru | Ucayali | 39746 | 3273 | 0 | -9.621718 | -73.444929 | 2022-07-15 04:20:53 | Ucayali, Peru | |||
3109665 | 3109665 | 2022-07-13 | Peru | Ucayali | 39746 | 3273 | 0 | -9.621718 | -73.444929 | 2022-07-14 04:20:57 | Ucayali, Peru | |||
630088 | 630088 | 2022-07-12 | Peru | Ucayali | 39746 | 3273 | 0 | -9.621718 | -73.444929 | 2022-07-13 04:20:58 | Ucayali, Peru | |||
1211732 | 1211732 | 2022-07-11 | Peru | Ucayali | 39746 | 3273 | 0 | -9.621718 | -73.444929 | 2022-07-12 04:20:51 | Ucayali, Peru | |||
3867775 | 3867775 | 2022-04-05 | Russia | Murmansk Oblast | 133699 | 3273 | 0 | 68.00004179999999 | 33.9999151 | 2022-04-06 04:20:49 | Murmansk Oblast, Russia | |||
356588 | 356588 | 2022-03-11 | Russia | Vladimir Oblast | 142155 | 3273 | 0 | 56.0503336 | 40.656163299999996 | 2022-03-12 04:20:50 | Vladimir Oblast, Russia | |||
3875415 | 3875415 | 2022-02-19 | Colombia | Narino | 104057 | 3273 | 0 | 1.2892 | -77.3579 | 2022-02-20 04:21:00 | Narino, Colombia | |||
99585 | 99585 | 2022-01-14 | Russia | Udmurt Republic | 79851 | 3273 | 0 | 57.1961165 | 52.69598320000001 | 2022-01-15 04:21:07 | Udmurt Republic, Russia | |||
3687937 | 3687937 | 2022-01-13 | US | Arizona | Pima | 4019 | 191727 | 3273 | 0 | 32.0971334 | -111.7890033 | 2022-01-14 04:21:54 | Pima, Arizona, US | |
3613521 | 3613521 | 2022-01-12 | US | Arizona | Pima | 4019 | 189543 | 3273 | 0 | 32.0971334 | -111.7890033 | 2022-01-13 08:00:09 | Pima, Arizona, US | |
2907339 | 2907339 | 2021-12-19 | Uganda | 129061 | 3273 | 0 | 1.373333 | 32.290275 | 2021-12-20 04:21:43 | Uganda | ||||
2089577 | 2089577 | 2021-12-14 | US | Massachusetts | Middlesex | 25017 | 183387 | 3273 | 0 | 42.48607732 | -71.39049229 | 2021-12-15 03:22:16 | Middlesex, Massachusetts, US | |
1033161 | 1033161 | 2021-12-06 | US | Puerto Rico | Unassigned | 72999 | 4497 | 3273 | 0 | 18.459681 | -67.336525 | 2021-12-07 04:22:34 | Unassigned, Puerto Rico, US | |
1743324 | 1743324 | 2021-12-05 | US | Puerto Rico | Unassigned | 72999 | 4496 | 3273 | 0 | 18.459681 | -67.336525 | 2021-12-06 04:22:34 | Unassigned, Puerto Rico, US | |
758455 | 758455 | 2021-11-26 | Netherlands | Noord-Brabant | 390409 | 3273 | 0 | 51.561174 | 5.1849419999999995 | 2021-11-27 04:22:45 | Noord-Brabant, Netherlands | |||
2124005 | 2124005 | 2021-10-21 | Russia | Volgograd Oblast | 99883 | 3273 | 0 | 49.604833899999996 | 44.29035820000001 | 2021-10-22 04:21:14 | Volgograd Oblast, Russia | |||
3834733 | 3834733 | 2021-10-05 | US | New York | Nassau | 36059 | 210362 | 3273 | 0 | 40.74066522 | -73.58941873 | 2021-10-06 04:21:33 | Nassau, New York, US | |
32267 | 32267 | 2021-08-25 | Colombia | Magdalena | 91581 | 3273 | 0 | 10.4113 | -74.4057 | 2021-08-26 04:21:28 | Magdalena, Colombia | |||
2255823 | 2255823 | 2021-05-19 | Mexico | Morelos | 33243 | 3273 | 0 | 29970 | 18.6813 | -99.1013 | 2021-05-20 04:21:05 | Morelos, Mexico | ||
2390861 | 2390861 | 2021-05-18 | Mexico | Morelos | 33224 | 3273 | 0 | 29951 | 18.6813 | -99.1013 | 2021-05-19 04:20:42 | Morelos, Mexico | ||
280042 | 280042 | 2021-02-24 | Colombia | Santander | 90280 | 3273 | 84658 | 2349 | 6.6437 | -73.6536 | 2021-02-25 05:24:57 | Santander, Colombia | ||
2567411 | 2567411 | 2021-01-25 | Brazil | Rio Grande do Norte | 137640 | 3273 | 95604 | 37287 | -5.4026 | -36.9541 | 2021-01-26 05:22:02 | Rio Grande do Norte, Brazil | ||
2625805 | 2625805 | 2021-01-10 | Honduras | 127945 | 3273 | 58788 | 65884 | 15.2 | -86.2419 | 2021-01-11 05:21:50 | Honduras |
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]);