daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,198 rows where deaths = 227 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 1,946
- Japan 50
- Russia 32
- Netherlands 27
- Chile 17
- Germany 14
- Canada 13
- Colombia 12
- Maldives 11
- Spain 10
- Sweden 10
- Ukraine 6
- Haiti 5
- India 5
- Zimbabwe 5
- United Kingdom 4
- Papua New Guinea 3
- Czechia 2
- Malaysia 2
- Niger 2
- Peru 2
- Togo 2
- Angola 1
- Armenia 1
- Bahrain 1
- China 1
- Croatia 1
- Eswatini 1
- Fiji 1
- France 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Washington | Franklin | 53021 | 36431 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-30 04:21:04 | Franklin, Washington, US | |
2022-12-29 | US | Texas | Coryell | 48099 | 20767 | 227 | 0 | 31.39078397 | -97.79936155 | 2022-12-30 04:21:04 | Coryell, Texas, US | |
2022-12-29 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-30 04:21:04 | Walton, Florida, US | |
2022-12-28 | US | Washington | Franklin | 53021 | 36431 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-29 04:21:01 | Franklin, Washington, US | |
2022-12-28 | US | Texas | Coryell | 48099 | 20767 | 227 | 0 | 31.39078397 | -97.79936155 | 2022-12-29 04:21:01 | Coryell, Texas, US | |
2022-12-28 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-29 04:21:01 | Pittsburg, Oklahoma, US | |
2022-12-28 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-29 04:21:01 | Walton, Florida, US | |
2022-12-27 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-28 04:21:04 | Franklin, Washington, US | |
2022-12-27 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-28 04:21:04 | Pittsburg, Oklahoma, US | |
2022-12-27 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-28 04:21:04 | Walton, Florida, US | |
2022-12-26 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-27 04:21:07 | Franklin, Washington, US | |
2022-12-26 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-27 04:21:07 | Pittsburg, Oklahoma, US | |
2022-12-26 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-27 04:21:07 | Walton, Florida, US | |
2022-12-25 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-26 04:21:06 | Franklin, Washington, US | |
2022-12-25 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-26 04:21:06 | Pittsburg, Oklahoma, US | |
2022-12-25 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-26 04:21:06 | Walton, Florida, US | |
2022-12-24 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-25 04:21:04 | Franklin, Washington, US | |
2022-12-24 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-25 04:21:04 | Pittsburg, Oklahoma, US | |
2022-12-24 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-25 04:21:04 | Walton, Florida, US | |
2022-12-23 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-24 04:21:02 | Franklin, Washington, US | |
2022-12-23 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-24 04:21:02 | Pittsburg, Oklahoma, US | |
2022-12-23 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-24 04:21:02 | Walton, Florida, US | |
2022-12-22 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-23 04:21:04 | Franklin, Washington, US | |
2022-12-22 | US | Oklahoma | Pittsburg | 40121 | 13384 | 227 | 0 | 34.92065823 | -95.7513432 | 2022-12-23 04:21:04 | Pittsburg, Oklahoma, US | |
2022-12-22 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-23 04:21:04 | Walton, Florida, US | |
2022-12-21 | US | Washington | Franklin | 53021 | 36391 | 227 | 0 | 46.53351425 | -118.9018212 | 2022-12-22 04:20:56 | Franklin, Washington, US | |
2022-12-21 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-22 04:20:56 | Walton, Florida, US | |
2022-12-20 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-21 04:21:03 | Bradford, Pennsylvania, US | |
2022-12-20 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-21 04:21:03 | Walton, Florida, US | |
2022-12-19 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-20 04:21:04 | Bradford, Pennsylvania, US | |
2022-12-19 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-20 04:21:04 | Walton, Florida, US | |
2022-12-18 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-19 04:21:03 | Bradford, Pennsylvania, US | |
2022-12-18 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-19 04:21:03 | Walton, Florida, US | |
2022-12-17 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-18 04:21:03 | Bradford, Pennsylvania, US | |
2022-12-17 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-18 04:21:03 | Walton, Florida, US | |
2022-12-16 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-17 04:21:04 | Bradford, Pennsylvania, US | |
2022-12-16 | US | Florida | Walton | 12131 | 19972 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-17 04:21:04 | Walton, Florida, US | |
2022-12-15 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-16 04:21:01 | Bradford, Pennsylvania, US | |
2022-12-15 | US | New York | Montgomery | 36057 | 14597 | 227 | 0 | 42.90123494 | -74.44011632 | 2022-12-16 04:21:01 | Montgomery, New York, US | |
2022-12-15 | US | Illinois | Adams | 17001 | 27031 | 227 | 0 | 39.98815591 | -91.18786813 | 2022-12-16 04:21:01 | Adams, Illinois, US | |
2022-12-15 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-16 04:21:01 | Walton, Florida, US | |
2022-12-14 | US | Pennsylvania | Bradford | 42015 | 19833 | 227 | 0 | 41.78869215 | -76.51570822 | 2022-12-15 04:20:58 | Bradford, Pennsylvania, US | |
2022-12-14 | US | New York | Montgomery | 36057 | 14592 | 227 | 0 | 42.90123494 | -74.44011632 | 2022-12-15 04:20:58 | Montgomery, New York, US | |
2022-12-14 | US | Illinois | Adams | 17001 | 26987 | 227 | 0 | 39.98815591 | -91.18786813 | 2022-12-15 04:20:58 | Adams, Illinois, US | |
2022-12-14 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-15 04:20:58 | Walton, Florida, US | |
2022-12-13 | US | New York | Montgomery | 36057 | 14581 | 227 | 0 | 42.90123494 | -74.44011632 | 2022-12-14 04:21:04 | Montgomery, New York, US | |
2022-12-13 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-14 04:21:04 | Walton, Florida, US | |
2022-12-12 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-13 04:21:01 | Walton, Florida, US | |
2022-12-12 | Japan | Tokushima | 114308 | 227 | 0 | 33.919178 | 134.242091 | 2022-12-13 04:21:01 | Tokushima, Japan | |||
2022-12-11 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-12 04:21:01 | Harlan, Kentucky, US | |
2022-12-11 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-12 04:21:01 | Walton, Florida, US | |
2022-12-11 | Japan | Tokushima | 114072 | 227 | 0 | 33.919178 | 134.242091 | 2022-12-12 04:21:01 | Tokushima, Japan | |||
2022-12-10 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-11 04:20:50 | Harlan, Kentucky, US | |
2022-12-10 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-11 04:20:50 | Walton, Florida, US | |
2022-12-09 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-10 04:21:02 | Harlan, Kentucky, US | |
2022-12-09 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-10 04:21:02 | Walton, Florida, US | |
2022-12-08 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-09 04:21:05 | Harlan, Kentucky, US | |
2022-12-08 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-09 04:21:05 | Walton, Florida, US | |
2022-12-07 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-08 04:21:07 | Harlan, Kentucky, US | |
2022-12-07 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-08 04:21:07 | Walton, Florida, US | |
2022-12-06 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-07 04:20:58 | Harlan, Kentucky, US | |
2022-12-06 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-07 04:20:58 | Walton, Florida, US | |
2022-12-05 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-06 04:21:03 | Isabella, Michigan, US | |
2022-12-05 | US | Kentucky | Harlan | 21095 | 12131 | 227 | 0 | 36.85699301 | -83.21899516 | 2022-12-06 04:21:03 | Harlan, Kentucky, US | |
2022-12-05 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-06 04:21:03 | Walton, Florida, US | |
2022-12-04 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-05 04:20:58 | Isabella, Michigan, US | |
2022-12-04 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-05 04:20:58 | Walton, Florida, US | |
2022-12-03 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-04 04:20:56 | Isabella, Michigan, US | |
2022-12-03 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-04 04:20:56 | Walton, Florida, US | |
2022-12-02 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-03 04:21:02 | Isabella, Michigan, US | |
2022-12-02 | US | Florida | Walton | 12131 | 19926 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-03 04:21:02 | Walton, Florida, US | |
2022-12-02 | US | Arkansas | Independence | 5063 | 12396 | 227 | 0 | 35.74242707 | -91.57001641 | 2022-12-03 04:21:02 | Independence, Arkansas, US | |
2022-12-01 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-02 04:21:07 | Isabella, Michigan, US | |
2022-12-01 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-02 04:21:07 | Walton, Florida, US | |
2022-12-01 | US | Arkansas | Mississippi | 5093 | 15766 | 227 | 0 | 35.76271485 | -90.0519437 | 2022-12-02 04:21:07 | Mississippi, Arkansas, US | |
2022-12-01 | US | Arkansas | Independence | 5063 | 12389 | 227 | 0 | 35.74242707 | -91.57001641 | 2022-12-02 04:21:07 | Independence, Arkansas, US | |
2022-11-30 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-12-01 04:21:03 | Isabella, Michigan, US | |
2022-11-30 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-12-01 04:21:03 | Walton, Florida, US | |
2022-11-30 | US | Arkansas | Independence | 5063 | 12379 | 227 | 0 | 35.74242707 | -91.57001641 | 2022-12-01 04:21:03 | Independence, Arkansas, US | |
2022-11-29 | US | Michigan | Isabella | 26073 | 17579 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-30 04:21:07 | Isabella, Michigan, US | |
2022-11-29 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-30 04:21:07 | Walton, Florida, US | |
2022-11-29 | US | Arkansas | Independence | 5063 | 12352 | 227 | 0 | 35.74242707 | -91.57001641 | 2022-11-30 04:21:07 | Independence, Arkansas, US | |
2022-11-28 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-29 04:21:05 | Isabella, Michigan, US | |
2022-11-28 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-29 04:21:05 | Walton, Florida, US | |
2022-11-27 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-28 04:21:02 | Isabella, Michigan, US | |
2022-11-27 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-28 04:21:02 | Walton, Florida, US | |
2022-11-26 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-27 04:21:05 | Isabella, Michigan, US | |
2022-11-26 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-27 04:21:05 | Walton, Florida, US | |
2022-11-25 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-26 04:21:11 | Isabella, Michigan, US | |
2022-11-25 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-26 04:21:11 | Walton, Florida, US | |
2022-11-24 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-25 04:21:06 | Isabella, Michigan, US | |
2022-11-24 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-25 04:21:06 | Walton, Florida, US | |
2022-11-23 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-24 04:21:09 | Isabella, Michigan, US | |
2022-11-23 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-24 04:21:09 | Walton, Florida, US | |
2022-11-22 | US | Michigan | Isabella | 26073 | 17544 | 227 | 0 | 43.64060976 | -84.84664923 | 2022-11-23 04:21:06 | Isabella, Michigan, US | |
2022-11-22 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-23 04:21:06 | Walton, Florida, US | |
2022-11-21 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-22 04:20:47 | Walton, Florida, US | |
2022-11-20 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-21 04:21:05 | Walton, Florida, US | |
2022-11-19 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-20 04:21:08 | Walton, Florida, US | |
2022-11-18 | US | Florida | Walton | 12131 | 19894 | 227 | 0 | 30.64204028 | -86.16935664 | 2022-11-19 04:21:14 | Walton, Florida, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;