daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
24 rows where deaths = 3413 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-26 | Japan | Aichi | 1787352 | 3413 | 0 | 35.035551 | 137.211621 | 2022-12-27 04:21:07 | Aichi, Japan | |||
2022-07-16 | Italy | Abruzzo | 473897 | 3413 | 0 | 42.35122196 | 13.39843823 | 2022-07-17 04:21:15 | Abruzzo, Italy | |||
2022-07-11 | Russia | Ryazan Oblast | 122725 | 3413 | 0 | 54.4226732 | 40.5705246 | 2022-07-12 04:20:51 | Ryazan Oblast, Russia | |||
2022-07-10 | Russia | Ryazan Oblast | 122689 | 3413 | 0 | 54.4226732 | 40.5705246 | 2022-07-11 04:20:46 | Ryazan Oblast, Russia | |||
2022-07-09 | Russia | Ryazan Oblast | 122654 | 3413 | 0 | 54.4226732 | 40.5705246 | 2022-07-10 04:20:54 | Ryazan Oblast, Russia | |||
2022-03-14 | US | New Jersey | Bergen | 34003 | 220183 | 3413 | 0 | 40.96010917 | -74.07164325 | 2022-03-15 04:20:47 | Bergen, New Jersey, US | |
2022-01-19 | Canada | Alberta | 459497 | 3413 | 0 | 53.9333 | -116.5765 | 2022-01-20 04:21:07 | Alberta, Canada | |||
2022-01-10 | US | Massachusetts | Middlesex | 25017 | 254872 | 3413 | 0 | 42.48607732 | -71.39049229 | 2022-01-11 04:22:01 | Middlesex, Massachusetts, US | |
2021-12-04 | Mexico | Zacatecas | 42128 | 3413 | 0 | 22.7709 | -102.5832 | 2021-12-05 04:22:25 | Zacatecas, Mexico | |||
2021-12-03 | Mexico | Zacatecas | 42128 | 3413 | 0 | 22.7709 | -102.5832 | 2021-12-04 04:22:18 | Zacatecas, Mexico | |||
2021-10-18 | US | Texas | Hidalgo | 48215 | 123211 | 3413 | 0 | 26.39418217 | -98.18299696 | 2021-10-19 04:20:54 | Hidalgo, Texas, US | |
2021-10-08 | Malaysia | Johor | 203796 | 3413 | 0 | 1.4854 | 103.7618 | 2021-10-09 04:21:34 | Johor, Malaysia | |||
2021-08-29 | Chile | Valparaiso | 122395 | 3413 | 0 | -33.0472 | -71.6127 | 2021-08-30 04:21:23 | Valparaiso, Chile | |||
2021-07-27 | Belarus | 441881 | 3413 | 435842 | 2626 | 53.7098 | 27.9534 | 2021-07-28 04:21:39 | Belarus | |||
2021-04-21 | US | Pennsylvania | Philadelphia | 42101 | 144229 | 3413 | 0 | 40.00338507 | -75.1379271 | 2021-04-22 04:20:53 | Philadelphia, Pennsylvania, US | |
2021-04-15 | US | Texas | Bexar | 48029 | 215900 | 3413 | 0 | 29.44928723 | -98.52019748 | 2021-04-16 04:20:46 | Bexar, Texas, US | |
2021-03-10 | US | California | San Diego | 6073 | 277250 | 3413 | 0 | 33.03484597 | -116.7365326 | 2021-03-11 05:25:48 | San Diego, California, US | |
2021-02-09 | Peru | Ancash | 39048 | 3413 | 0 | 35635 | -9.407125 | -77.67179499999997 | 2021-02-10 05:22:41 | Ancash, Peru | ||
2021-01-28 | Moldova | 158309 | 3413 | 148432 | 6464 | 47.4116 | 28.3699 | 2021-01-29 05:22:23 | Moldova | |||
2021-01-24 | Mexico | Tabasco | 50966 | 3413 | 0 | 47553 | 17.8409 | -92.6189 | 2021-01-25 05:22:16 | Tabasco, Mexico | ||
2021-01-13 | Spain | C. Valenciana | 183671 | 3413 | 9970 | 170288 | 39.484 | -0.7533 | 2021-01-14 05:22:32 | C. Valenciana, Spain | ||
2020-11-27 | Colombia | Valle del Cauca | 105872 | 3413 | 95980 | 6479 | 3.8009 | -76.6413 | 2020-11-28 05:25:50 | Valle del Cauca, Colombia | ||
2020-10-30 | Peru | Ica | 29597 | 3413 | 0 | 26184 | -14.235097 | -75.574821 | 2020-10-31 04:24:44 | Ica, Peru | ||
2020-08-27 | Mexico | Puebla | 26286 | 3413 | 21391 | 1482 | 19.0414 | -98.2063 | 2020-08-28 04:28:11 | Puebla, Mexico |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;