daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15,511 rows where deaths = 51 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 14,665
- India 183
- Russia 134
- Japan 84
- Sweden 55
- Andorra 31
- Equatorial Guinea 29
- Monaco 23
- Ukraine 21
- Colombia 18
- United Kingdom 17
- Gabon 14
- New Zealand 14
- Dominica 13
- Australia 12
- Canada 12
- Barbados 10
- Chile 10
- Lesotho 10
- Tunisia 10
- Burkina Faso 8
- Togo 8
- Uruguay 8
- Maldives 7
- Netherlands 7
- Sierra Leone 7
- Malaysia 5
- Mexico 5
- Peru 5
- Rwanda 5
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Wisconsin | Washburn | 55129 | 4925 | 51 | 0 | 45.89838588 | -91.79050449 | 2022-12-30 04:21:04 | Washburn, Wisconsin, US | |
2022-12-29 | US | Virginia | King William | 51101 | 4576 | 51 | 0 | 37.70965316 | -77.09384941 | 2022-12-30 04:21:04 | King William, Virginia, US | |
2022-12-29 | US | Utah | San Juan | 49037 | 5042 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-30 04:21:04 | San Juan, Utah, US | |
2022-12-29 | US | Texas | Stephens | 48429 | 2098 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-30 04:21:04 | Stephens, Texas, US | |
2022-12-29 | US | Texas | Dimmit | 48127 | 6156 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-12-30 04:21:04 | Dimmit, Texas, US | |
2022-12-29 | US | South Dakota | Grant | 46051 | 2366 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-12-30 04:21:04 | Grant, South Dakota, US | |
2022-12-29 | US | Oklahoma | Blaine | 40011 | 2844 | 51 | 0 | 35.87518314 | -98.43307003 | 2022-12-30 04:21:04 | Blaine, Oklahoma, US | |
2022-12-29 | US | North Carolina | Warren | 37185 | 5490 | 51 | 0 | 36.39728256 | -78.10652228 | 2022-12-30 04:21:04 | Warren, North Carolina, US | |
2022-12-29 | US | Missouri | Perry | 29157 | 6172 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-30 04:21:04 | Perry, Missouri, US | |
2022-12-29 | US | Missouri | Osage | 29151 | 3674 | 51 | 0 | 38.46036182 | -91.8613635 | 2022-12-30 04:21:04 | Osage, Missouri, US | |
2022-12-29 | US | Mississippi | Noxubee | 28103 | 3469 | 51 | 0 | 33.11009499 | -88.56949061 | 2022-12-30 04:21:04 | Noxubee, Mississippi, US | |
2022-12-29 | US | Mississippi | Kemper | 28069 | 2529 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-12-30 04:21:04 | Kemper, Mississippi, US | |
2022-12-29 | US | Mississippi | Benton | 28009 | 2728 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-12-30 04:21:04 | Benton, Mississippi, US | |
2022-12-29 | US | Kentucky | Martin | 21159 | 4123 | 51 | 0 | 37.79990579 | -82.51247478 | 2022-12-30 04:21:04 | Martin, Kentucky, US | |
2022-12-29 | US | Kentucky | Green | 21087 | 4643 | 51 | 0 | 37.26484328 | -85.5540745 | 2022-12-30 04:21:04 | Green, Kentucky, US | |
2022-12-29 | US | Kansas | Brown | 20013 | 3115 | 51 | 0 | 39.82652589 | -95.56421698 | 2022-12-30 04:21:04 | Brown, Kansas, US | |
2022-12-29 | US | Iowa | Ida | 19093 | 2071 | 51 | 0 | 42.38696136 | -95.51355387 | 2022-12-30 04:21:04 | Ida, Iowa, US | |
2022-12-29 | US | Illinois | Moultrie | 17139 | 4851 | 51 | 0 | 39.64187451 | -88.62099969 | 2022-12-30 04:21:04 | Moultrie, Illinois, US | |
2022-12-29 | US | Illinois | Mercer | 17131 | 4853 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-12-30 04:21:04 | Mercer, Illinois, US | |
2022-12-29 | US | Illinois | Hancock | 17067 | 5228 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-12-30 04:21:04 | Hancock, Illinois, US | |
2022-12-29 | US | Georgia | Taylor | 13269 | 2347 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-12-30 04:21:04 | Taylor, Georgia, US | |
2022-12-29 | US | Colorado | Las Animas | 8071 | 4317 | 51 | 0 | 37.3153406 | -104.0376458 | 2022-12-30 04:21:04 | Las Animas, Colorado, US | |
2022-12-28 | US | Wisconsin | Washburn | 55129 | 4923 | 51 | 0 | 45.89838588 | -91.79050449 | 2022-12-29 04:21:01 | Washburn, Wisconsin, US | |
2022-12-28 | US | Virginia | King William | 51101 | 4576 | 51 | 0 | 37.70965316 | -77.09384941 | 2022-12-29 04:21:01 | King William, Virginia, US | |
2022-12-28 | US | Utah | San Juan | 49037 | 5028 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-29 04:21:01 | San Juan, Utah, US | |
2022-12-28 | US | Texas | Stephens | 48429 | 2098 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-29 04:21:01 | Stephens, Texas, US | |
2022-12-28 | US | Texas | Dimmit | 48127 | 6156 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-12-29 04:21:01 | Dimmit, Texas, US | |
2022-12-28 | US | South Dakota | Grant | 46051 | 2366 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-12-29 04:21:01 | Grant, South Dakota, US | |
2022-12-28 | US | Oklahoma | Blaine | 40011 | 2839 | 51 | 0 | 35.87518314 | -98.43307003 | 2022-12-29 04:21:01 | Blaine, Oklahoma, US | |
2022-12-28 | US | North Carolina | Warren | 37185 | 5490 | 51 | 0 | 36.39728256 | -78.10652228 | 2022-12-29 04:21:01 | Warren, North Carolina, US | |
2022-12-28 | US | Missouri | Perry | 29157 | 6172 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-29 04:21:01 | Perry, Missouri, US | |
2022-12-28 | US | Missouri | Osage | 29151 | 3674 | 51 | 0 | 38.46036182 | -91.8613635 | 2022-12-29 04:21:01 | Osage, Missouri, US | |
2022-12-28 | US | Mississippi | Noxubee | 28103 | 3469 | 51 | 0 | 33.11009499 | -88.56949061 | 2022-12-29 04:21:01 | Noxubee, Mississippi, US | |
2022-12-28 | US | Mississippi | Kemper | 28069 | 2529 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-12-29 04:21:01 | Kemper, Mississippi, US | |
2022-12-28 | US | Mississippi | Benton | 28009 | 2728 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-12-29 04:21:01 | Benton, Mississippi, US | |
2022-12-28 | US | Kentucky | Martin | 21159 | 4123 | 51 | 0 | 37.79990579 | -82.51247478 | 2022-12-29 04:21:01 | Martin, Kentucky, US | |
2022-12-28 | US | Kentucky | Green | 21087 | 4643 | 51 | 0 | 37.26484328 | -85.5540745 | 2022-12-29 04:21:01 | Green, Kentucky, US | |
2022-12-28 | US | Kansas | Brown | 20013 | 3115 | 51 | 0 | 39.82652589 | -95.56421698 | 2022-12-29 04:21:01 | Brown, Kansas, US | |
2022-12-28 | US | Iowa | Ida | 19093 | 2071 | 51 | 0 | 42.38696136 | -95.51355387 | 2022-12-29 04:21:01 | Ida, Iowa, US | |
2022-12-28 | US | Illinois | Moultrie | 17139 | 4849 | 51 | 0 | 39.64187451 | -88.62099969 | 2022-12-29 04:21:01 | Moultrie, Illinois, US | |
2022-12-28 | US | Illinois | Mercer | 17131 | 4852 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-12-29 04:21:01 | Mercer, Illinois, US | |
2022-12-28 | US | Illinois | Hancock | 17067 | 5223 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-12-29 04:21:01 | Hancock, Illinois, US | |
2022-12-28 | US | Georgia | Taylor | 13269 | 2347 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-12-29 04:21:01 | Taylor, Georgia, US | |
2022-12-28 | US | Colorado | Las Animas | 8071 | 4316 | 51 | 0 | 37.3153406 | -104.0376458 | 2022-12-29 04:21:01 | Las Animas, Colorado, US | |
2022-12-27 | US | Wisconsin | Washburn | 55129 | 4923 | 51 | 0 | 45.89838588 | -91.79050449 | 2022-12-28 04:21:04 | Washburn, Wisconsin, US | |
2022-12-27 | US | Virginia | King William | 51101 | 4572 | 51 | 0 | 37.70965316 | -77.09384941 | 2022-12-28 04:21:04 | King William, Virginia, US | |
2022-12-27 | US | Utah | San Juan | 49037 | 5028 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-28 04:21:04 | San Juan, Utah, US | |
2022-12-27 | US | Texas | Stephens | 48429 | 2085 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-28 04:21:04 | Stephens, Texas, US | |
2022-12-27 | US | Texas | Dimmit | 48127 | 6147 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-12-28 04:21:04 | Dimmit, Texas, US | |
2022-12-27 | US | South Dakota | Grant | 46051 | 2356 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-12-28 04:21:04 | Grant, South Dakota, US | |
2022-12-27 | US | Oklahoma | Blaine | 40011 | 2839 | 51 | 0 | 35.87518314 | -98.43307003 | 2022-12-28 04:21:04 | Blaine, Oklahoma, US | |
2022-12-27 | US | North Carolina | Warren | 37185 | 5490 | 51 | 0 | 36.39728256 | -78.10652228 | 2022-12-28 04:21:04 | Warren, North Carolina, US | |
2022-12-27 | US | Missouri | Perry | 29157 | 6172 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-28 04:21:04 | Perry, Missouri, US | |
2022-12-27 | US | Missouri | Osage | 29151 | 3674 | 51 | 0 | 38.46036182 | -91.8613635 | 2022-12-28 04:21:04 | Osage, Missouri, US | |
2022-12-27 | US | Mississippi | Noxubee | 28103 | 3469 | 51 | 0 | 33.11009499 | -88.56949061 | 2022-12-28 04:21:04 | Noxubee, Mississippi, US | |
2022-12-27 | US | Mississippi | Kemper | 28069 | 2529 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-12-28 04:21:04 | Kemper, Mississippi, US | |
2022-12-27 | US | Mississippi | Benton | 28009 | 2728 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-12-28 04:21:04 | Benton, Mississippi, US | |
2022-12-27 | US | Kentucky | Martin | 21159 | 4123 | 51 | 0 | 37.79990579 | -82.51247478 | 2022-12-28 04:21:04 | Martin, Kentucky, US | |
2022-12-27 | US | Kentucky | Green | 21087 | 4643 | 51 | 0 | 37.26484328 | -85.5540745 | 2022-12-28 04:21:04 | Green, Kentucky, US | |
2022-12-27 | US | Kansas | Brown | 20013 | 3113 | 51 | 0 | 39.82652589 | -95.56421698 | 2022-12-28 04:21:04 | Brown, Kansas, US | |
2022-12-27 | US | Iowa | Ida | 19093 | 2070 | 51 | 0 | 42.38696136 | -95.51355387 | 2022-12-28 04:21:04 | Ida, Iowa, US | |
2022-12-27 | US | Illinois | Moultrie | 17139 | 4846 | 51 | 0 | 39.64187451 | -88.62099969 | 2022-12-28 04:21:04 | Moultrie, Illinois, US | |
2022-12-27 | US | Illinois | Mercer | 17131 | 4851 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-12-28 04:21:04 | Mercer, Illinois, US | |
2022-12-27 | US | Illinois | Hancock | 17067 | 5217 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-12-28 04:21:04 | Hancock, Illinois, US | |
2022-12-27 | US | Georgia | Taylor | 13269 | 2338 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-12-28 04:21:04 | Taylor, Georgia, US | |
2022-12-27 | US | Colorado | Las Animas | 8071 | 4315 | 51 | 0 | 37.3153406 | -104.0376458 | 2022-12-28 04:21:04 | Las Animas, Colorado, US | |
2022-12-26 | US | Wisconsin | Washburn | 55129 | 4923 | 51 | 0 | 45.89838588 | -91.79050449 | 2022-12-27 04:21:07 | Washburn, Wisconsin, US | |
2022-12-26 | US | Virginia | King William | 51101 | 4570 | 51 | 0 | 37.70965316 | -77.09384941 | 2022-12-27 04:21:07 | King William, Virginia, US | |
2022-12-26 | US | Utah | San Juan | 49037 | 5028 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-27 04:21:07 | San Juan, Utah, US | |
2022-12-26 | US | Texas | Stephens | 48429 | 2085 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-27 04:21:07 | Stephens, Texas, US | |
2022-12-26 | US | Texas | Dimmit | 48127 | 6147 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-12-27 04:21:07 | Dimmit, Texas, US | |
2022-12-26 | US | South Dakota | Grant | 46051 | 2356 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-12-27 04:21:07 | Grant, South Dakota, US | |
2022-12-26 | US | Oklahoma | Blaine | 40011 | 2839 | 51 | 0 | 35.87518314 | -98.43307003 | 2022-12-27 04:21:07 | Blaine, Oklahoma, US | |
2022-12-26 | US | North Carolina | Warren | 37185 | 5490 | 51 | 0 | 36.39728256 | -78.10652228 | 2022-12-27 04:21:07 | Warren, North Carolina, US | |
2022-12-26 | US | Missouri | Perry | 29157 | 6141 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-27 04:21:07 | Perry, Missouri, US | |
2022-12-26 | US | Missouri | Osage | 29151 | 3666 | 51 | 0 | 38.46036182 | -91.8613635 | 2022-12-27 04:21:07 | Osage, Missouri, US | |
2022-12-26 | US | Mississippi | Noxubee | 28103 | 3447 | 51 | 0 | 33.11009499 | -88.56949061 | 2022-12-27 04:21:07 | Noxubee, Mississippi, US | |
2022-12-26 | US | Mississippi | Kemper | 28069 | 2514 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-12-27 04:21:07 | Kemper, Mississippi, US | |
2022-12-26 | US | Mississippi | Benton | 28009 | 2712 | 51 | 0 | 34.81681228 | -89.18945516 | 2022-12-27 04:21:07 | Benton, Mississippi, US | |
2022-12-26 | US | Kentucky | Martin | 21159 | 4100 | 51 | 0 | 37.79990579 | -82.51247478 | 2022-12-27 04:21:07 | Martin, Kentucky, US | |
2022-12-26 | US | Kentucky | Green | 21087 | 4607 | 51 | 0 | 37.26484328 | -85.5540745 | 2022-12-27 04:21:07 | Green, Kentucky, US | |
2022-12-26 | US | Kansas | Brown | 20013 | 3113 | 51 | 0 | 39.82652589 | -95.56421698 | 2022-12-27 04:21:07 | Brown, Kansas, US | |
2022-12-26 | US | Iowa | Ida | 19093 | 2070 | 51 | 0 | 42.38696136 | -95.51355387 | 2022-12-27 04:21:07 | Ida, Iowa, US | |
2022-12-26 | US | Illinois | Moultrie | 17139 | 4845 | 51 | 0 | 39.64187451 | -88.62099969 | 2022-12-27 04:21:07 | Moultrie, Illinois, US | |
2022-12-26 | US | Illinois | Mercer | 17131 | 4846 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-12-27 04:21:07 | Mercer, Illinois, US | |
2022-12-26 | US | Illinois | Hancock | 17067 | 5209 | 51 | 0 | 40.40423981 | -91.16313899 | 2022-12-27 04:21:07 | Hancock, Illinois, US | |
2022-12-26 | US | Georgia | Taylor | 13269 | 2338 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-12-27 04:21:07 | Taylor, Georgia, US | |
2022-12-26 | US | Colorado | Las Animas | 8071 | 4315 | 51 | 0 | 37.3153406 | -104.0376458 | 2022-12-27 04:21:07 | Las Animas, Colorado, US | |
2022-12-25 | US | Wisconsin | Washburn | 55129 | 4922 | 51 | 0 | 45.89838588 | -91.79050449 | 2022-12-26 04:21:06 | Washburn, Wisconsin, US | |
2022-12-25 | US | Virginia | King William | 51101 | 4564 | 51 | 0 | 37.70965316 | -77.09384941 | 2022-12-26 04:21:06 | King William, Virginia, US | |
2022-12-25 | US | Utah | San Juan | 49037 | 5028 | 51 | 0 | 37.62762978 | -109.8033714 | 2022-12-26 04:21:06 | San Juan, Utah, US | |
2022-12-25 | US | Texas | Stephens | 48429 | 2085 | 51 | 0 | 32.73553157 | -98.83631615 | 2022-12-26 04:21:06 | Stephens, Texas, US | |
2022-12-25 | US | Texas | Dimmit | 48127 | 6147 | 51 | 0 | 28.42270064 | -99.75645095 | 2022-12-26 04:21:06 | Dimmit, Texas, US | |
2022-12-25 | US | South Dakota | Grant | 46051 | 2356 | 51 | 0 | 45.1723937 | -96.77002276 | 2022-12-26 04:21:06 | Grant, South Dakota, US | |
2022-12-25 | US | Oklahoma | Blaine | 40011 | 2839 | 51 | 0 | 35.87518314 | -98.43307003 | 2022-12-26 04:21:06 | Blaine, Oklahoma, US | |
2022-12-25 | US | North Carolina | Warren | 37185 | 5490 | 51 | 0 | 36.39728256 | -78.10652228 | 2022-12-26 04:21:06 | Warren, North Carolina, US | |
2022-12-25 | US | Missouri | Perry | 29157 | 6141 | 51 | 0 | 37.70660776 | -89.82741088 | 2022-12-26 04:21:06 | Perry, Missouri, US | |
2022-12-25 | US | Missouri | Osage | 29151 | 3666 | 51 | 0 | 38.46036182 | -91.8613635 | 2022-12-26 04:21:06 | Osage, Missouri, US | |
2022-12-25 | US | Mississippi | Noxubee | 28103 | 3447 | 51 | 0 | 33.11009499 | -88.56949061 | 2022-12-26 04:21:06 | Noxubee, Mississippi, US | |
2022-12-25 | US | Mississippi | Kemper | 28069 | 2514 | 51 | 0 | 32.75462946 | -88.64105766 | 2022-12-26 04:21:06 | Kemper, Mississippi, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;