daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
20 rows where active = 6075 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | Malaysia | Kelantan | 45923 | 284 | 39564 | 6075 | 6.1254 | 102.2381 | 2021-08-05 04:21:51 | Kelantan, Malaysia | ||
2021-08-02 | Spain | Ceuta | 6355 | 117 | 163 | 6075 | 35.8894 | -5.3213 | 2021-08-03 04:21:39 | Ceuta, Spain | ||
2021-03-14 | Panama | 347919 | 5994 | 335850 | 6075 | 8.538 | -80.7821 | 2021-03-15 05:25:51 | Panama | |||
2021-03-06 | US | Indiana | Boone | 18011 | 6166 | 91 | 0 | 6075 | 40.0509304 | -86.46841646 | 2021-03-07 05:21:54 | Boone, Indiana, US |
2021-02-24 | US | Michigan | Eaton | 26045 | 6226 | 151 | 0 | 6075 | 42.59599185 | -84.83740035 | 2021-02-25 05:24:57 | Eaton, Michigan, US |
2021-02-16 | US | Tennessee | Coffee | 47031 | 6181 | 112 | 0 | 6075 | 35.49090731 | -86.07311784 | 2021-02-17 05:23:10 | Coffee, Tennessee, US |
2021-01-22 | Congo (Kinshasa) | 21597 | 647 | 14875 | 6075 | -4.0383 | 21.7587 | 2021-01-23 05:22:03 | Congo (Kinshasa) | |||
2021-01-16 | US | Maryland | Carroll | 24013 | 6255 | 180 | 0 | 6075 | 39.56453592 | -77.02373735 | 2021-01-17 05:22:17 | Carroll, Maryland, US |
2021-01-02 | US | Arizona | Santa Cruz | 4023 | 6176 | 101 | 0 | 6075 | 31.52508998 | -110.8479088 | 2021-01-03 05:22:52 | Santa Cruz, Arizona, US |
2021-01-01 | India | Delhi | 625954 | 10557 | 609322 | 6075 | 28.646519 | 77.10898 | 2021-01-02 05:22:33 | Delhi, India | ||
2020-12-17 | Italy | Basilicata | 9817 | 217 | 3525 | 6075 | 40.63947052 | 15.80514834 | 2020-12-18 05:28:18 | Basilicata, Italy | ||
2020-12-14 | US | South Dakota | Lincoln | 46083 | 6132 | 57 | 0 | 6075 | 43.27841182 | -96.7203905 | 2020-12-15 05:26:38 | Lincoln, South Dakota, US |
2020-12-04 | US | Indiana | Monroe | 18105 | 6139 | 64 | 0 | 6075 | 39.16130004 | -86.52414358 | 2020-12-05 05:27:36 | Monroe, Indiana, US |
2020-12-02 | US | Michigan | Calhoun | 26025 | 6202 | 127 | 0 | 6075 | 42.24633834 | -85.00493569 | 2020-12-03 05:28:22 | Calhoun, Michigan, US |
2020-11-10 | US | Texas | Ellis | 48139 | 5205 | 92 | 0 | 6075 | 32.34894117 | -96.79371841 | 2020-11-11 05:25:30 | Ellis, Texas, US |
2020-11-08 | US | Missouri | Jasper | 29097 | 6159 | 84 | 0 | 6075 | 37.20351921 | -94.34050458 | 2020-11-09 05:25:45 | Jasper, Missouri, US |
2020-11-03 | US | New Jersey | Gloucester | 34015 | 6324 | 249 | 0 | 6075 | 39.71581067 | -75.13995546 | 2020-11-04 05:25:09 | Gloucester, New Jersey, US |
2020-10-27 | US | North Carolina | Pitt | 37147 | 6113 | 38 | 0 | 6075 | 35.59535426 | -77.37353178 | 2020-10-28 04:24:39 | Pitt, North Carolina, US |
2020-10-15 | Spain | Asturias | 7502 | 364 | 1063 | 6075 | 43.3614 | -5.8593 | 2020-10-16 04:24:01 | Asturias, Spain | ||
2020-07-03 | Brazil | Acre | 14112 | 387 | 7650 | 6075 | -9.0238 | -70.812 | 2020-07-04 04:33:51 | Acre, Brazil |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;