daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
48 rows where deaths = 3213 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-15 | US | New Jersey | Ocean | 34029 | 204693 | 3213 | 0 | 39.8895449 | -74.28089251 | 2022-12-16 04:21:01 | Ocean, New Jersey, US | |
2022-12-07 | Russia | Ivanovo Oblast | 130854 | 3213 | 0 | 56.9167446 | 41.4352137 | 2022-12-08 04:21:07 | Ivanovo Oblast, Russia | |||
2022-10-09 | Peru | San Martin | 67193 | 3213 | 0 | -7.039531 | -76.729127 | 2022-10-10 04:22:32 | San Martin, Peru | |||
2022-10-08 | Peru | San Martin | 67193 | 3213 | 0 | -7.039531 | -76.729127 | 2022-10-09 04:21:16 | San Martin, Peru | |||
2022-10-07 | Peru | San Martin | 67193 | 3213 | 0 | -7.039531 | -76.729127 | 2022-10-08 04:22:56 | San Martin, Peru | |||
2022-10-06 | Peru | San Martin | 67193 | 3213 | 0 | -7.039531 | -76.729127 | 2022-10-07 04:23:08 | San Martin, Peru | |||
2022-10-05 | Peru | San Martin | 67193 | 3213 | 0 | -7.039531 | -76.729127 | 2022-10-06 04:21:22 | San Martin, Peru | |||
2022-10-04 | Peru | San Martin | 67193 | 3213 | 0 | -7.039531 | -76.729127 | 2022-10-05 04:23:06 | San Martin, Peru | |||
2022-10-03 | Peru | San Martin | 67193 | 3213 | 0 | -7.039531 | -76.729127 | 2022-10-04 04:22:55 | San Martin, Peru | |||
2022-07-26 | Mexico | Nayarit | 68506 | 3213 | 0 | 21.7514 | -104.8455 | 2022-07-27 04:21:04 | Nayarit, Mexico | |||
2022-07-25 | Mexico | Nayarit | 68506 | 3213 | 0 | 21.7514 | -104.8455 | 2022-07-26 04:20:58 | Nayarit, Mexico | |||
2022-06-02 | Australia | New South Wales | 2604827 | 3213 | 0 | -33.8688 | 151.2093 | 2022-06-03 04:20:58 | New South Wales, Australia | |||
2022-04-29 | Italy | Abruzzo | 372307 | 3213 | 0 | 42.35122196 | 13.39843823 | 2022-04-30 04:21:05 | Abruzzo, Italy | |||
2022-03-13 | US | Tennessee | Shelby | 47157 | 234732 | 3213 | 0 | 35.1864775 | -89.89692423 | 2022-03-14 04:20:46 | Shelby, Tennessee, US | |
2022-03-12 | US | Tennessee | Shelby | 47157 | 234726 | 3213 | 0 | 35.1864775 | -89.89692423 | 2022-03-13 04:20:49 | Shelby, Tennessee, US | |
2022-03-11 | US | Tennessee | Shelby | 47157 | 234715 | 3213 | 0 | 35.1864775 | -89.89692423 | 2022-03-12 04:20:50 | Shelby, Tennessee, US | |
2022-03-06 | US | Missouri | St. Louis | 29189 | 218320 | 3213 | 0 | 38.63770039999999 | -90.4458375 | 2022-03-07 04:20:47 | St. Louis, Missouri, US | |
2022-03-05 | US | Missouri | St. Louis | 29189 | 218320 | 3213 | 0 | 38.63770039999999 | -90.4458375 | 2022-03-06 04:20:49 | St. Louis, Missouri, US | |
2022-02-13 | Netherlands | Noord-Holland | 983642 | 3213 | 0 | 52.60090600000001 | 4.9186879999999995 | 2022-02-14 04:20:51 | Noord-Holland, Netherlands | |||
2022-02-11 | Colombia | Bolivar | 195960 | 3213 | 0 | 8.6704 | -74.03 | 2022-02-12 04:21:06 | Bolivar, Colombia | |||
2022-02-10 | Colombia | Bolivar | 195286 | 3213 | 0 | 8.6704 | -74.03 | 2022-02-11 04:21:09 | Bolivar, Colombia | |||
2022-01-13 | Colombia | Huila | 92103 | 3213 | 0 | 2.5359 | -75.5277 | 2022-01-14 04:21:54 | Huila, Colombia | |||
2022-01-12 | Colombia | Huila | 91750 | 3213 | 0 | 2.5359 | -75.5277 | 2022-01-13 08:00:09 | Huila, Colombia | |||
2022-01-03 | US | New Jersey | Essex | 34013 | 163322 | 3213 | 0 | 40.78681335 | -74.24657979 | 2022-01-04 04:22:17 | Essex, New Jersey, US | |
2021-11-25 | US | Massachusetts | Middlesex | 25017 | 169160 | 3213 | 0 | 42.48607732 | -71.39049229 | 2021-11-26 04:22:33 | Middlesex, Massachusetts, US | |
2021-11-24 | US | Massachusetts | Middlesex | 25017 | 169160 | 3213 | 0 | 42.48607732 | -71.39049229 | 2021-11-25 04:22:33 | Middlesex, Massachusetts, US | |
2021-10-20 | US | Puerto Rico | Unassigned | 72999 | 4103 | 3213 | 0 | 18.459681 | -67.336525 | 2021-10-21 04:21:18 | Unassigned, Puerto Rico, US | |
2021-08-29 | US | New York | Nassau | 36059 | 197786 | 3213 | 0 | 40.74066522 | -73.58941873 | 2021-08-30 04:21:23 | Nassau, New York, US | |
2021-07-15 | Colombia | Tolima | 99512 | 3213 | 94518 | 1781 | 4.0925 | -75.1545 | 2021-07-16 04:21:22 | Tolima, Colombia | ||
2021-07-05 | Libya | 195824 | 3213 | 179398 | 13213 | 26.3351 | 17.228331 | 2021-07-06 04:21:32 | Libya | |||
2021-06-29 | Brazil | Tocantins | 197636 | 3213 | 179090 | 14971 | -10.1753 | -48.2982 | 2021-06-30 04:21:41 | Tocantins, Brazil | ||
2021-05-18 | Burma | 143131 | 3213 | 132135 | 7783 | 21.9162 | 95.956 | 2021-05-19 04:20:42 | Burma | |||
2021-05-17 | Burma | 143097 | 3213 | 132123 | 7761 | 21.9162 | 95.956 | 2021-05-18 04:20:33 | Burma | |||
2021-05-14 | Germany | Sachsen-Anhalt | 95933 | 3213 | 87450 | 5538 | 51.9503 | 11.6923 | 2021-05-15 04:20:58 | Sachsen-Anhalt, Germany | ||
2021-05-02 | Germany | Berlin | 168955 | 3213 | 156500 | 9310 | 52.52 | 13.405 | 2021-05-03 04:20:39 | Berlin, Germany | ||
2021-04-26 | Ukraine | Dnipropetrovsk Oblast | 118176 | 3213 | 92916 | 22047 | 48.4647 | 35.0462 | 2021-04-27 04:20:52 | Dnipropetrovsk Oblast, Ukraine | ||
2021-03-13 | Dominican Republic | 245616 | 3213 | 201379 | 41024 | 18.7357 | -70.1627 | 2021-03-14 05:25:37 | Dominican Republic | |||
2021-03-12 | Dominican Republic | 245452 | 3213 | 200922 | 41317 | 18.7357 | -70.1627 | 2021-03-13 05:25:15 | Dominican Republic | |||
2021-02-26 | Azerbaijan | 233989 | 3213 | 228479 | 2297 | 40.1431 | 47.5769 | 2021-02-27 05:22:28 | Azerbaijan | |||
2021-02-17 | US | Texas | Dallas | 48113 | 251729 | 3213 | 0 | 272570 | 32.76670599 | -96.7779605 | 2021-02-18 05:22:58 | Dallas, Texas, US |
2020-09-27 | Mexico | Jalisco | 26315 | 3213 | 21048 | 2054 | 20.6595 | -103.3494 | 2020-09-28 04:23:00 | Jalisco, Mexico | ||
2020-09-26 | Guatemala | 89702 | 3213 | 78284 | 8205 | 15.7835 | -90.2308 | 2020-09-27 04:23:00 | Guatemala | |||
2020-09-04 | Mexico | Baja California | 17325 | 3213 | 13262 | 850 | 30.8406 | -115.2838 | 2020-09-05 04:28:19 | Baja California, Mexico | ||
2020-08-23 | Peru | Lambayeque | 20932 | 3213 | 0 | 17719 | -6.353049 | -79.824113 | 2020-08-24 04:27:56 | Lambayeque, Peru | ||
2020-08-19 | Mexico | Puebla | 24767 | 3213 | 19973 | 1581 | 19.0414 | -98.2063 | 2020-08-20 04:27:43 | Puebla, Mexico | ||
2020-07-08 | India | Delhi | 104864 | 3213 | 78199 | 23452 | 28.646519 | 77.10898 | 2020-07-09 04:34:23 | Delhi, India | ||
2020-06-22 | Peru | Piura | 15587 | 3213 | 0 | 12374 | -5.133361 | -80.335861 | 2020-06-23 04:33:22 | Piura, Peru | ||
2020-04-08 | China | Hubei | 67803 | 3213 | 64142 | 448 | 30.9756 | 112.2707 | 2020-04-08 00:37:38 | Hubei, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;