johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
39 rows where deaths = 3638 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1075882 | 1075882 | 2022-12-28 | US | Missouri | St. Louis | 29189 | 285773 | 3638 | 0 | 38.6377004 | -90.4458375 | 2022-12-29 04:21:01 | St. Louis, Missouri, US | |
1065713 | 1065713 | 2022-07-28 | Colombia | Magdalena | 117031 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-29 04:20:45 | Magdalena, Colombia | |||
2335232 | 2335232 | 2022-07-27 | Colombia | Magdalena | 116584 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-28 04:20:56 | Magdalena, Colombia | |||
1487422 | 1487422 | 2022-07-26 | Colombia | Magdalena | 116584 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-27 04:21:04 | Magdalena, Colombia | |||
2593868 | 2593868 | 2022-07-25 | Colombia | Magdalena | 116584 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-26 04:20:58 | Magdalena, Colombia | |||
895983 | 895983 | 2022-07-24 | Colombia | Magdalena | 116584 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-25 04:20:51 | Magdalena, Colombia | |||
90977 | 90977 | 2022-07-23 | Colombia | Magdalena | 116584 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-24 04:20:47 | Magdalena, Colombia | |||
899999 | 899999 | 2022-07-22 | Colombia | Magdalena | 116584 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-23 04:20:53 | Magdalena, Colombia | |||
670135 | 670135 | 2022-07-21 | Colombia | Magdalena | 116470 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-22 04:21:15 | Magdalena, Colombia | |||
1608098 | 1608098 | 2022-07-20 | Colombia | Magdalena | 116470 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-21 04:21:10 | Magdalena, Colombia | |||
958731 | 958731 | 2022-07-19 | Colombia | Magdalena | 116470 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-20 04:20:59 | Magdalena, Colombia | |||
3210118 | 3210118 | 2022-07-18 | Colombia | Magdalena | 116470 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-19 04:20:58 | Magdalena, Colombia | |||
3405293 | 3405293 | 2022-07-17 | Colombia | Magdalena | 116470 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-18 04:20:59 | Magdalena, Colombia | |||
2151493 | 2151493 | 2022-07-16 | Colombia | Magdalena | 116470 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-17 04:21:15 | Magdalena, Colombia | |||
2418726 | 2418726 | 2022-07-15 | Colombia | Magdalena | 116470 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-16 04:21:05 | Magdalena, Colombia | |||
3428801 | 3428801 | 2022-07-14 | Colombia | Magdalena | 116470 | 3638 | 0 | 10.4113 | -74.4057 | 2022-07-15 04:20:53 | Magdalena, Colombia | |||
1213724 | 1213724 | 2022-07-11 | US | New Jersey | Essex | 34013 | 241851 | 3638 | 0 | 40.78681335 | -74.24657979 | 2022-07-12 04:20:51 | Essex, New Jersey, US | |
3186078 | 3186078 | 2022-05-30 | Mexico | Durango | 68251 | 3638 | 0 | 24.5593 | -104.6588 | 2022-05-31 04:20:51 | Durango, Mexico | |||
3851693 | 3851693 | 2022-04-27 | Finland | 1000472 | 3638 | 0 | 61.92411 | 25.748151 | 2022-04-28 04:20:47 | Finland | ||||
1326123 | 1326123 | 2022-04-26 | Finland | 1000472 | 3638 | 0 | 61.92411 | 25.748151 | 2022-04-27 04:20:52 | Finland | ||||
3722077 | 3722077 | 2022-04-25 | Finland | 1000472 | 3638 | 0 | 61.92411 | 25.748151 | 2022-04-26 04:20:51 | Finland | ||||
2028645 | 2028645 | 2022-04-24 | Finland | 1000472 | 3638 | 0 | 61.92411 | 25.748151 | 2022-04-25 04:20:56 | Finland | ||||
746220 | 746220 | 2022-04-23 | Finland | 1000472 | 3638 | 0 | 61.92411 | 25.748151 | 2022-04-24 04:20:56 | Finland | ||||
3436705 | 3436705 | 2022-04-22 | Finland | 1000472 | 3638 | 0 | 61.92411 | 25.748151 | 2022-04-23 04:20:50 | Finland | ||||
2892290 | 2892290 | 2022-04-21 | Finland | 1000472 | 3638 | 0 | 61.92411 | 25.748151 | 2022-04-22 04:20:45 | Finland | ||||
2478235 | 2478235 | 2022-03-30 | Russia | Vologda Oblast | 184514 | 3638 | 0 | 60.0391461 | 43.1215213 | 2022-03-31 04:20:56 | Vologda Oblast, Russia | |||
2263863 | 2263863 | 2022-03-14 | Italy | Marche | 348565 | 3638 | 0 | 43.61675973 | 13.5188753 | 2022-03-15 04:20:47 | Marche, Italy | |||
1647443 | 1647443 | 2022-03-03 | US | Texas | El Paso | 48141 | 203428 | 3638 | 0 | 31.76980765 | -106.23632749999999 | 2022-03-04 04:21:09 | El Paso, Texas, US | |
2167344 | 2167344 | 2022-01-01 | Chile | Valparaiso | 138453 | 3638 | 0 | -33.0472 | -71.6127 | 2022-01-02 04:20:52 | Valparaiso, Chile | |||
278455 | 278455 | 2021-11-03 | US | New York | Suffolk | 36103 | 242959 | 3638 | 0 | 40.88320119 | -72.8012172 | 2021-11-04 04:22:20 | Suffolk, New York, US | |
3511272 | 3511272 | 2021-11-01 | El Salvador | 113422 | 3638 | 0 | 13.7942 | -88.8965 | 2021-11-02 04:22:03 | El Salvador | ||||
1818447 | 1818447 | 2021-09-19 | Zambia | 208469 | 3638 | 0 | -13.133897 | 27.849332 | 2021-09-20 04:21:22 | Zambia | ||||
20027 | 20027 | 2021-09-18 | Zambia | 208422 | 3638 | 0 | -13.133897 | 27.849332 | 2021-09-19 04:21:34 | Zambia | ||||
1342577 | 1342577 | 2021-08-11 | Spain | Aragon | 152579 | 3638 | 0 | 41.5976 | -0.9057 | 2021-08-12 04:21:25 | Aragon, Spain | |||
3662615 | 3662615 | 2021-07-11 | US | Texas | Bexar | 48029 | 233217 | 3638 | 0 | 29.44928723 | -98.52019748 | 2021-07-12 04:21:34 | Bexar, Texas, US | |
1809433 | 1809433 | 2021-05-27 | US | Pennsylvania | Philadelphia | 42101 | 154656 | 3638 | 0 | 40.00338507 | -75.1379271 | 2021-05-28 04:20:36 | Philadelphia, Pennsylvania, US | |
2259393 | 2259393 | 2021-05-19 | Uruguay | 249365 | 3638 | 216589 | 29138 | -32.5228 | -55.7658 | 2021-05-20 04:21:05 | Uruguay | |||
280334 | 280334 | 2021-02-24 | Peru | Ancash | 41876 | 3638 | 0 | 38238 | -9.407125 | -77.67179499999997 | 2021-02-25 05:24:57 | Ancash, Peru | ||
2119858 | 2119858 | 2020-12-20 | Pakistan | Punjab | 131933 | 3638 | 119998 | 8297 | 30.811346 | 72.13913199999998 | 2020-12-21 05:27:58 | Punjab, Pakistan |
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]);