daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,009 rows where deaths = 188 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 2,565
- Spain 73
- Malaysia 60
- Japan 58
- Russia 52
- Sweden 28
- Chile 20
- Bahamas 15
- Pakistan 15
- Australia 9
- Germany 8
- Niger 8
- Colombia 7
- Nicaragua 7
- India 6
- Ukraine 6
- Canada 5
- Djibouti 5
- Cote d'Ivoire 4
- Gambia 4
- Malawi 4
- Mexico 4
- Morocco 4
- Netherlands 4
- France 3
- Cabo Verde 2
- Italy 2
- Kazakhstan 2
- Libya 2
- Qatar 2
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Michigan | Barry | 26015 | 16611 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-30 04:21:04 | Barry, Michigan, US | |
2022-12-28 | US | Michigan | Barry | 26015 | 16611 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-29 04:21:01 | Barry, Michigan, US | |
2022-12-27 | US | Michigan | Barry | 26015 | 16611 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-28 04:21:04 | Barry, Michigan, US | |
2022-12-26 | US | Michigan | Barry | 26015 | 16554 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-27 04:21:07 | Barry, Michigan, US | |
2022-12-25 | US | Michigan | Barry | 26015 | 16554 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-26 04:21:06 | Barry, Michigan, US | |
2022-12-24 | US | Michigan | Barry | 26015 | 16554 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-25 04:21:04 | Barry, Michigan, US | |
2022-12-23 | US | Michigan | Barry | 26015 | 16554 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-24 04:21:02 | Barry, Michigan, US | |
2022-12-22 | US | Michigan | Barry | 26015 | 16554 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-23 04:21:04 | Barry, Michigan, US | |
2022-12-21 | US | Michigan | Barry | 26015 | 16554 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-22 04:20:56 | Barry, Michigan, US | |
2022-12-20 | US | Texas | Hopkins | 48223 | 8405 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-21 04:21:03 | Hopkins, Texas, US | |
2022-12-20 | US | Michigan | Barry | 26015 | 16554 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-21 04:21:03 | Barry, Michigan, US | |
2022-12-19 | US | Texas | Hopkins | 48223 | 8405 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-20 04:21:04 | Hopkins, Texas, US | |
2022-12-19 | US | Michigan | Barry | 26015 | 16488 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-20 04:21:04 | Barry, Michigan, US | |
2022-12-18 | US | Texas | Hopkins | 48223 | 8405 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-19 04:21:03 | Hopkins, Texas, US | |
2022-12-18 | US | Michigan | Barry | 26015 | 16488 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-19 04:21:03 | Barry, Michigan, US | |
2022-12-17 | US | Texas | Hopkins | 48223 | 8405 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-18 04:21:03 | Hopkins, Texas, US | |
2022-12-17 | US | Michigan | Barry | 26015 | 16488 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-18 04:21:03 | Barry, Michigan, US | |
2022-12-16 | US | Texas | Hopkins | 48223 | 8405 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-17 04:21:04 | Hopkins, Texas, US | |
2022-12-16 | US | Michigan | Barry | 26015 | 16488 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-17 04:21:04 | Barry, Michigan, US | |
2022-12-15 | US | Texas | Hopkins | 48223 | 8405 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-16 04:21:01 | Hopkins, Texas, US | |
2022-12-15 | US | Michigan | Barry | 26015 | 16488 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-16 04:21:01 | Barry, Michigan, US | |
2022-12-14 | US | Texas | Hopkins | 48223 | 8405 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-15 04:20:58 | Hopkins, Texas, US | |
2022-12-14 | US | Ohio | Highland | 39071 | 12896 | 188 | 0 | 39.1839264 | -83.60331456 | 2022-12-15 04:20:58 | Highland, Ohio, US | |
2022-12-14 | US | Michigan | Barry | 26015 | 16488 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-15 04:20:58 | Barry, Michigan, US | |
2022-12-13 | US | Texas | Hopkins | 48223 | 8361 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-14 04:21:04 | Hopkins, Texas, US | |
2022-12-13 | US | Ohio | Highland | 39071 | 12896 | 188 | 0 | 39.1839264 | -83.60331456 | 2022-12-14 04:21:04 | Highland, Ohio, US | |
2022-12-13 | US | Michigan | Barry | 26015 | 16488 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-14 04:21:04 | Barry, Michigan, US | |
2022-12-12 | US | Texas | Hopkins | 48223 | 8361 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-13 04:21:01 | Hopkins, Texas, US | |
2022-12-12 | US | Ohio | Highland | 39071 | 12896 | 188 | 0 | 39.1839264 | -83.60331456 | 2022-12-13 04:21:01 | Highland, Ohio, US | |
2022-12-12 | US | Mississippi | Bolivar | 28011 | 10858 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-13 04:21:01 | Bolivar, Mississippi, US | |
2022-12-12 | US | Michigan | Barry | 26015 | 16433 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-13 04:21:01 | Barry, Michigan, US | |
2022-12-11 | US | Texas | Hopkins | 48223 | 8361 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-12 04:21:01 | Hopkins, Texas, US | |
2022-12-11 | US | Ohio | Highland | 39071 | 12896 | 188 | 0 | 39.1839264 | -83.60331456 | 2022-12-12 04:21:01 | Highland, Ohio, US | |
2022-12-11 | US | Mississippi | Bolivar | 28011 | 10858 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-12 04:21:01 | Bolivar, Mississippi, US | |
2022-12-11 | US | Michigan | Barry | 26015 | 16433 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-12 04:21:01 | Barry, Michigan, US | |
2022-12-10 | US | Texas | Hopkins | 48223 | 8361 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-11 04:20:50 | Hopkins, Texas, US | |
2022-12-10 | US | Ohio | Highland | 39071 | 12896 | 188 | 0 | 39.1839264 | -83.60331456 | 2022-12-11 04:20:50 | Highland, Ohio, US | |
2022-12-10 | US | Mississippi | Bolivar | 28011 | 10858 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-11 04:20:50 | Bolivar, Mississippi, US | |
2022-12-10 | US | Michigan | Barry | 26015 | 16433 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-11 04:20:50 | Barry, Michigan, US | |
2022-12-09 | US | Texas | Hopkins | 48223 | 8361 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-10 04:21:02 | Hopkins, Texas, US | |
2022-12-09 | US | Ohio | Highland | 39071 | 12896 | 188 | 0 | 39.1839264 | -83.60331456 | 2022-12-10 04:21:02 | Highland, Ohio, US | |
2022-12-09 | US | Mississippi | Bolivar | 28011 | 10858 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-10 04:21:02 | Bolivar, Mississippi, US | |
2022-12-09 | US | Michigan | Barry | 26015 | 16433 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-10 04:21:02 | Barry, Michigan, US | |
2022-12-08 | US | Texas | Hopkins | 48223 | 8361 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-09 04:21:05 | Hopkins, Texas, US | |
2022-12-08 | US | Ohio | Highland | 39071 | 12896 | 188 | 0 | 39.1839264 | -83.60331456 | 2022-12-09 04:21:05 | Highland, Ohio, US | |
2022-12-08 | US | Mississippi | Bolivar | 28011 | 10858 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-09 04:21:05 | Bolivar, Mississippi, US | |
2022-12-08 | US | Michigan | Barry | 26015 | 16433 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-09 04:21:05 | Barry, Michigan, US | |
2022-12-08 | Spain | Ceuta | 24454 | 188 | 0 | 35.8894 | -5.3213 | 2022-12-09 04:21:05 | Ceuta, Spain | |||
2022-12-07 | US | Texas | Hopkins | 48223 | 8361 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-08 04:21:07 | Hopkins, Texas, US | |
2022-12-07 | US | Mississippi | Bolivar | 28011 | 10858 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-08 04:21:07 | Bolivar, Mississippi, US | |
2022-12-07 | US | Michigan | Barry | 26015 | 16433 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-08 04:21:07 | Barry, Michigan, US | |
2022-12-07 | US | Georgia | Gilmer | 13123 | 7926 | 188 | 0 | 34.69316688 | -84.45802506 | 2022-12-08 04:21:07 | Gilmer, Georgia, US | |
2022-12-07 | Spain | Ceuta | 24454 | 188 | 0 | 35.8894 | -5.3213 | 2022-12-08 04:21:07 | Ceuta, Spain | |||
2022-12-06 | US | Washington | Chelan | 53007 | 23670 | 188 | 0 | 47.87046092 | -120.6173956 | 2022-12-07 04:20:58 | Chelan, Washington, US | |
2022-12-06 | US | Texas | Hopkins | 48223 | 8304 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-07 04:20:58 | Hopkins, Texas, US | |
2022-12-06 | US | Mississippi | Bolivar | 28011 | 10858 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-07 04:20:58 | Bolivar, Mississippi, US | |
2022-12-06 | US | Michigan | Barry | 26015 | 16433 | 188 | 0 | 42.59513984 | -85.30834519 | 2022-12-07 04:20:58 | Barry, Michigan, US | |
2022-12-06 | US | Georgia | Gilmer | 13123 | 7926 | 188 | 0 | 34.69316688 | -84.45802506 | 2022-12-07 04:20:58 | Gilmer, Georgia, US | |
2022-12-06 | Spain | Ceuta | 24454 | 188 | 0 | 35.8894 | -5.3213 | 2022-12-07 04:20:58 | Ceuta, Spain | |||
2022-12-05 | US | Washington | Chelan | 53007 | 23670 | 188 | 0 | 47.87046092 | -120.6173956 | 2022-12-06 04:21:03 | Chelan, Washington, US | |
2022-12-05 | US | Texas | Hopkins | 48223 | 8304 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-06 04:21:03 | Hopkins, Texas, US | |
2022-12-05 | US | Missouri | Laclede | 29105 | 9333 | 188 | 0 | 37.65896829 | -92.5888493 | 2022-12-06 04:21:03 | Laclede, Missouri, US | |
2022-12-05 | US | Mississippi | Bolivar | 28011 | 10820 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-06 04:21:03 | Bolivar, Mississippi, US | |
2022-12-05 | US | Georgia | Gilmer | 13123 | 7926 | 188 | 0 | 34.69316688 | -84.45802506 | 2022-12-06 04:21:03 | Gilmer, Georgia, US | |
2022-12-05 | Spain | Ceuta | 24454 | 188 | 0 | 35.8894 | -5.3213 | 2022-12-06 04:21:03 | Ceuta, Spain | |||
2022-12-04 | US | Washington | Chelan | 53007 | 23670 | 188 | 0 | 47.87046092 | -120.6173956 | 2022-12-05 04:20:58 | Chelan, Washington, US | |
2022-12-04 | US | Texas | Hopkins | 48223 | 8304 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-05 04:20:58 | Hopkins, Texas, US | |
2022-12-04 | US | Missouri | Laclede | 29105 | 9333 | 188 | 0 | 37.65896829 | -92.5888493 | 2022-12-05 04:20:58 | Laclede, Missouri, US | |
2022-12-04 | US | Mississippi | Bolivar | 28011 | 10820 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-05 04:20:58 | Bolivar, Mississippi, US | |
2022-12-04 | US | Georgia | Gilmer | 13123 | 7926 | 188 | 0 | 34.69316688 | -84.45802506 | 2022-12-05 04:20:58 | Gilmer, Georgia, US | |
2022-12-04 | Spain | Ceuta | 24454 | 188 | 0 | 35.8894 | -5.3213 | 2022-12-05 04:20:58 | Ceuta, Spain | |||
2022-12-03 | US | Washington | Chelan | 53007 | 23670 | 188 | 0 | 47.87046092 | -120.6173956 | 2022-12-04 04:20:56 | Chelan, Washington, US | |
2022-12-03 | US | Texas | Hopkins | 48223 | 8304 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-04 04:20:56 | Hopkins, Texas, US | |
2022-12-03 | US | Missouri | Laclede | 29105 | 9333 | 188 | 0 | 37.65896829 | -92.5888493 | 2022-12-04 04:20:56 | Laclede, Missouri, US | |
2022-12-03 | US | Mississippi | Bolivar | 28011 | 10820 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-04 04:20:56 | Bolivar, Mississippi, US | |
2022-12-03 | US | Georgia | Gilmer | 13123 | 7926 | 188 | 0 | 34.69316688 | -84.45802506 | 2022-12-04 04:20:56 | Gilmer, Georgia, US | |
2022-12-03 | Spain | Ceuta | 24454 | 188 | 0 | 35.8894 | -5.3213 | 2022-12-04 04:20:56 | Ceuta, Spain | |||
2022-12-02 | US | Washington | Chelan | 53007 | 23670 | 188 | 0 | 47.87046092 | -120.6173956 | 2022-12-03 04:21:02 | Chelan, Washington, US | |
2022-12-02 | US | Texas | Hopkins | 48223 | 8304 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-03 04:21:02 | Hopkins, Texas, US | |
2022-12-02 | US | Missouri | Laclede | 29105 | 9333 | 188 | 0 | 37.65896829 | -92.5888493 | 2022-12-03 04:21:02 | Laclede, Missouri, US | |
2022-12-02 | US | Mississippi | Bolivar | 28011 | 10820 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-03 04:21:02 | Bolivar, Mississippi, US | |
2022-12-02 | US | Georgia | Gilmer | 13123 | 7926 | 188 | 0 | 34.69316688 | -84.45802506 | 2022-12-03 04:21:02 | Gilmer, Georgia, US | |
2022-12-02 | Spain | Ceuta | 24454 | 188 | 0 | 35.8894 | -5.3213 | 2022-12-03 04:21:02 | Ceuta, Spain | |||
2022-12-01 | US | Washington | Chelan | 53007 | 23670 | 188 | 0 | 47.87046092 | -120.6173956 | 2022-12-02 04:21:07 | Chelan, Washington, US | |
2022-12-01 | US | Texas | Hopkins | 48223 | 8304 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-02 04:21:07 | Hopkins, Texas, US | |
2022-12-01 | US | Missouri | Laclede | 29105 | 9333 | 188 | 0 | 37.65896829 | -92.5888493 | 2022-12-02 04:21:07 | Laclede, Missouri, US | |
2022-12-01 | US | Mississippi | Bolivar | 28011 | 10820 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-02 04:21:07 | Bolivar, Mississippi, US | |
2022-12-01 | US | Georgia | Gilmer | 13123 | 7926 | 188 | 0 | 34.69316688 | -84.45802506 | 2022-12-02 04:21:07 | Gilmer, Georgia, US | |
2022-12-01 | Spain | Ceuta | 24402 | 188 | 0 | 35.8894 | -5.3213 | 2022-12-02 04:21:07 | Ceuta, Spain | |||
2022-11-30 | US | Washington | Chelan | 53007 | 23670 | 188 | 0 | 47.87046092 | -120.6173956 | 2022-12-01 04:21:03 | Chelan, Washington, US | |
2022-11-30 | US | Texas | Hopkins | 48223 | 8304 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-12-01 04:21:03 | Hopkins, Texas, US | |
2022-11-30 | US | Missouri | Laclede | 29105 | 9333 | 188 | 0 | 37.65896829 | -92.5888493 | 2022-12-01 04:21:03 | Laclede, Missouri, US | |
2022-11-30 | US | Mississippi | Bolivar | 28011 | 10820 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-12-01 04:21:03 | Bolivar, Mississippi, US | |
2022-11-30 | US | Georgia | Gilmer | 13123 | 7926 | 188 | 0 | 34.69316688 | -84.45802506 | 2022-12-01 04:21:03 | Gilmer, Georgia, US | |
2022-11-30 | Sweden | Blekinge | 31004 | 188 | 0 | 56.2784 | 15.018 | 2022-12-01 04:21:03 | Blekinge, Sweden | |||
2022-11-30 | Spain | Ceuta | 24402 | 188 | 0 | 35.8894 | -5.3213 | 2022-12-01 04:21:03 | Ceuta, Spain | |||
2022-11-29 | US | Texas | Hopkins | 48223 | 8297 | 188 | 0 | 33.14875072 | -95.56351139 | 2022-11-30 04:21:07 | Hopkins, Texas, US | |
2022-11-29 | US | Missouri | Laclede | 29105 | 9333 | 188 | 0 | 37.65896829 | -92.5888493 | 2022-11-30 04:21:07 | Laclede, Missouri, US | |
2022-11-29 | US | Mississippi | Bolivar | 28011 | 10820 | 188 | 0 | 33.79696941 | -90.87372121 | 2022-11-30 04:21:07 | Bolivar, Mississippi, US | |
2022-11-29 | US | Louisiana | Franklin | 22041 | 8497 | 188 | 0 | 32.13675181 | -91.67589857 | 2022-11-30 04:21:07 | Franklin, Louisiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;