daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,573 rows where deaths = 228 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 2,154
- India 188
- Russia 39
- Sweden 28
- Netherlands 24
- Japan 22
- Germany 15
- Zimbabwe 8
- Chile 7
- Nicaragua 7
- Ukraine 7
- France 6
- Mexico 6
- Spain 6
- United Kingdom 5
- Brazil 4
- Colombia 4
- Peru 4
- Belize 3
- Malaysia 3
- Australia 2
- Canada 2
- Morocco 2
- Albania 1
- Angola 1
- Azerbaijan 1
- Bangladesh 1
- Barbados 1
- Cabo Verde 1
- Costa Rica 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Pennsylvania | Bradford | 42015 | 20019 | 228 | 0 | 41.78869215 | -76.51570822 | 2022-12-30 04:21:04 | Bradford, Pennsylvania, US | |
2022-12-29 | US | Oklahoma | Pittsburg | 40121 | 13428 | 228 | 0 | 34.92065823 | -95.7513432 | 2022-12-30 04:21:04 | Pittsburg, Oklahoma, US | |
2022-12-29 | US | New York | Montgomery | 36057 | 14690 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-30 04:21:04 | Montgomery, New York, US | |
2022-12-29 | US | Kentucky | Harlan | 21095 | 12289 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-30 04:21:04 | Harlan, Kentucky, US | |
2022-12-29 | US | Illinois | Adams | 17001 | 27330 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-30 04:21:04 | Adams, Illinois, US | |
2022-12-28 | US | Pennsylvania | Bradford | 42015 | 20019 | 228 | 0 | 41.78869215 | -76.51570822 | 2022-12-29 04:21:01 | Bradford, Pennsylvania, US | |
2022-12-28 | US | New York | Montgomery | 36057 | 14682 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-29 04:21:01 | Montgomery, New York, US | |
2022-12-28 | US | Kentucky | Harlan | 21095 | 12289 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-29 04:21:01 | Harlan, Kentucky, US | |
2022-12-28 | US | Illinois | Adams | 17001 | 27297 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-29 04:21:01 | Adams, Illinois, US | |
2022-12-27 | US | Pennsylvania | Bradford | 42015 | 19931 | 228 | 0 | 41.78869215 | -76.51570822 | 2022-12-28 04:21:04 | Bradford, Pennsylvania, US | |
2022-12-27 | US | New York | Montgomery | 36057 | 14679 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-28 04:21:04 | Montgomery, New York, US | |
2022-12-27 | US | Nevada | Carson City | 32510 | 17064 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-28 04:21:04 | Carson City, Nevada, US | |
2022-12-27 | US | Kentucky | Harlan | 21095 | 12289 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-28 04:21:04 | Harlan, Kentucky, US | |
2022-12-27 | US | Illinois | Adams | 17001 | 27273 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-28 04:21:04 | Adams, Illinois, US | |
2022-12-27 | US | Arkansas | Independence | 5063 | 12547 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-28 04:21:04 | Independence, Arkansas, US | |
2022-12-26 | US | Pennsylvania | Bradford | 42015 | 19931 | 228 | 0 | 41.78869215 | -76.51570822 | 2022-12-27 04:21:07 | Bradford, Pennsylvania, US | |
2022-12-26 | US | New York | Montgomery | 36057 | 14676 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-27 04:21:07 | Montgomery, New York, US | |
2022-12-26 | US | Nevada | Carson City | 32510 | 17064 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-27 04:21:07 | Carson City, Nevada, US | |
2022-12-26 | US | Kentucky | Harlan | 21095 | 12214 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-27 04:21:07 | Harlan, Kentucky, US | |
2022-12-26 | US | Illinois | Adams | 17001 | 27222 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-27 04:21:07 | Adams, Illinois, US | |
2022-12-26 | US | Arkansas | Independence | 5063 | 12538 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-27 04:21:07 | Independence, Arkansas, US | |
2022-12-25 | US | Pennsylvania | Bradford | 42015 | 19931 | 228 | 0 | 41.78869215 | -76.51570822 | 2022-12-26 04:21:06 | Bradford, Pennsylvania, US | |
2022-12-25 | US | New York | Montgomery | 36057 | 14675 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-26 04:21:06 | Montgomery, New York, US | |
2022-12-25 | US | Nevada | Carson City | 32510 | 17064 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-26 04:21:06 | Carson City, Nevada, US | |
2022-12-25 | US | Kentucky | Harlan | 21095 | 12214 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-26 04:21:06 | Harlan, Kentucky, US | |
2022-12-25 | US | Illinois | Adams | 17001 | 27222 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-26 04:21:06 | Adams, Illinois, US | |
2022-12-25 | US | Arkansas | Independence | 5063 | 12535 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-26 04:21:06 | Independence, Arkansas, US | |
2022-12-24 | US | Pennsylvania | Bradford | 42015 | 19931 | 228 | 0 | 41.78869215 | -76.51570822 | 2022-12-25 04:21:04 | Bradford, Pennsylvania, US | |
2022-12-24 | US | New York | Montgomery | 36057 | 14669 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-25 04:21:04 | Montgomery, New York, US | |
2022-12-24 | US | Nevada | Carson City | 32510 | 17064 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-25 04:21:04 | Carson City, Nevada, US | |
2022-12-24 | US | Kentucky | Harlan | 21095 | 12214 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-25 04:21:04 | Harlan, Kentucky, US | |
2022-12-24 | US | Illinois | Adams | 17001 | 27222 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-25 04:21:04 | Adams, Illinois, US | |
2022-12-24 | US | Arkansas | Independence | 5063 | 12535 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-25 04:21:04 | Independence, Arkansas, US | |
2022-12-23 | US | Pennsylvania | Bradford | 42015 | 19931 | 228 | 0 | 41.78869215 | -76.51570822 | 2022-12-24 04:21:02 | Bradford, Pennsylvania, US | |
2022-12-23 | US | New York | Montgomery | 36057 | 14660 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-24 04:21:02 | Montgomery, New York, US | |
2022-12-23 | US | Nevada | Carson City | 32510 | 17064 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-24 04:21:02 | Carson City, Nevada, US | |
2022-12-23 | US | Kentucky | Harlan | 21095 | 12214 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-24 04:21:02 | Harlan, Kentucky, US | |
2022-12-23 | US | Illinois | Adams | 17001 | 27222 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-24 04:21:02 | Adams, Illinois, US | |
2022-12-23 | US | Arkansas | Independence | 5063 | 12535 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-24 04:21:02 | Independence, Arkansas, US | |
2022-12-22 | US | Pennsylvania | Bradford | 42015 | 19931 | 228 | 0 | 41.78869215 | -76.51570822 | 2022-12-23 04:21:04 | Bradford, Pennsylvania, US | |
2022-12-22 | US | New York | Montgomery | 36057 | 14649 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-23 04:21:04 | Montgomery, New York, US | |
2022-12-22 | US | Nevada | Carson City | 32510 | 17064 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-23 04:21:04 | Carson City, Nevada, US | |
2022-12-22 | US | Kentucky | Harlan | 21095 | 12214 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-23 04:21:04 | Harlan, Kentucky, US | |
2022-12-22 | US | Illinois | Adams | 17001 | 27203 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-23 04:21:04 | Adams, Illinois, US | |
2022-12-22 | US | Arkansas | Independence | 5063 | 12533 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-23 04:21:04 | Independence, Arkansas, US | |
2022-12-21 | US | Pennsylvania | Bradford | 42015 | 19931 | 228 | 0 | 41.78869215 | -76.51570822 | 2022-12-22 04:20:56 | Bradford, Pennsylvania, US | |
2022-12-21 | US | New York | Montgomery | 36057 | 14638 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-22 04:20:56 | Montgomery, New York, US | |
2022-12-21 | US | Nevada | Carson City | 32510 | 17064 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-22 04:20:56 | Carson City, Nevada, US | |
2022-12-21 | US | Kentucky | Harlan | 21095 | 12214 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-22 04:20:56 | Harlan, Kentucky, US | |
2022-12-21 | US | Illinois | Adams | 17001 | 27185 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-22 04:20:56 | Adams, Illinois, US | |
2022-12-21 | US | Arkansas | Independence | 5063 | 12523 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-22 04:20:56 | Independence, Arkansas, US | |
2022-12-20 | US | New York | Montgomery | 36057 | 14633 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-21 04:21:03 | Montgomery, New York, US | |
2022-12-20 | US | Nevada | Carson City | 32510 | 17015 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-21 04:21:03 | Carson City, Nevada, US | |
2022-12-20 | US | Kentucky | Harlan | 21095 | 12214 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-21 04:21:03 | Harlan, Kentucky, US | |
2022-12-20 | US | Illinois | Adams | 17001 | 27129 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-21 04:21:03 | Adams, Illinois, US | |
2022-12-20 | US | Arkansas | Mississippi | 5093 | 15894 | 228 | 0 | 35.76271485 | -90.0519437 | 2022-12-21 04:21:03 | Mississippi, Arkansas, US | |
2022-12-20 | US | Arkansas | Independence | 5063 | 12514 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-21 04:21:03 | Independence, Arkansas, US | |
2022-12-19 | US | New York | Montgomery | 36057 | 14627 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-20 04:21:04 | Montgomery, New York, US | |
2022-12-19 | US | Nevada | Carson City | 32510 | 17015 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-20 04:21:04 | Carson City, Nevada, US | |
2022-12-19 | US | Kentucky | Harlan | 21095 | 12214 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-20 04:21:04 | Harlan, Kentucky, US | |
2022-12-19 | US | Illinois | Adams | 17001 | 27102 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-20 04:21:04 | Adams, Illinois, US | |
2022-12-19 | US | Arkansas | Mississippi | 5093 | 15879 | 228 | 0 | 35.76271485 | -90.0519437 | 2022-12-20 04:21:04 | Mississippi, Arkansas, US | |
2022-12-19 | US | Arkansas | Independence | 5063 | 12503 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-20 04:21:04 | Independence, Arkansas, US | |
2022-12-18 | US | New York | Montgomery | 36057 | 14618 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-19 04:21:03 | Montgomery, New York, US | |
2022-12-18 | US | Nevada | Carson City | 32510 | 17015 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-19 04:21:03 | Carson City, Nevada, US | |
2022-12-18 | US | Kentucky | Harlan | 21095 | 12162 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-19 04:21:03 | Harlan, Kentucky, US | |
2022-12-18 | US | Illinois | Adams | 17001 | 27047 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-19 04:21:03 | Adams, Illinois, US | |
2022-12-18 | US | Arkansas | Mississippi | 5093 | 15875 | 228 | 0 | 35.76271485 | -90.0519437 | 2022-12-19 04:21:03 | Mississippi, Arkansas, US | |
2022-12-18 | US | Arkansas | Independence | 5063 | 12502 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-19 04:21:03 | Independence, Arkansas, US | |
2022-12-17 | US | New York | Montgomery | 36057 | 14613 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-18 04:21:03 | Montgomery, New York, US | |
2022-12-17 | US | Nevada | Carson City | 32510 | 17015 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-18 04:21:03 | Carson City, Nevada, US | |
2022-12-17 | US | Kentucky | Harlan | 21095 | 12162 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-18 04:21:03 | Harlan, Kentucky, US | |
2022-12-17 | US | Illinois | Adams | 17001 | 27047 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-18 04:21:03 | Adams, Illinois, US | |
2022-12-17 | US | Arkansas | Mississippi | 5093 | 15874 | 228 | 0 | 35.76271485 | -90.0519437 | 2022-12-18 04:21:03 | Mississippi, Arkansas, US | |
2022-12-17 | US | Arkansas | Independence | 5063 | 12498 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-18 04:21:03 | Independence, Arkansas, US | |
2022-12-16 | US | New York | Montgomery | 36057 | 14600 | 228 | 0 | 42.90123494 | -74.44011632 | 2022-12-17 04:21:04 | Montgomery, New York, US | |
2022-12-16 | US | Nevada | Carson City | 32510 | 17015 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-17 04:21:04 | Carson City, Nevada, US | |
2022-12-16 | US | Kentucky | Harlan | 21095 | 12162 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-17 04:21:04 | Harlan, Kentucky, US | |
2022-12-16 | US | Illinois | Adams | 17001 | 27047 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-17 04:21:04 | Adams, Illinois, US | |
2022-12-16 | US | Arkansas | Mississippi | 5093 | 15870 | 228 | 0 | 35.76271485 | -90.0519437 | 2022-12-17 04:21:04 | Mississippi, Arkansas, US | |
2022-12-16 | US | Arkansas | Independence | 5063 | 12491 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-17 04:21:04 | Independence, Arkansas, US | |
2022-12-15 | US | Nevada | Carson City | 32510 | 17015 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-16 04:21:01 | Carson City, Nevada, US | |
2022-12-15 | US | Kentucky | Harlan | 21095 | 12162 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-16 04:21:01 | Harlan, Kentucky, US | |
2022-12-15 | US | Arkansas | Mississippi | 5093 | 15848 | 228 | 0 | 35.76271485 | -90.0519437 | 2022-12-16 04:21:01 | Mississippi, Arkansas, US | |
2022-12-15 | US | Arkansas | Independence | 5063 | 12485 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-16 04:21:01 | Independence, Arkansas, US | |
2022-12-14 | US | Oklahoma | Kay | 40071 | 14607 | 228 | 0 | 36.81799745 | -97.14421435 | 2022-12-15 04:20:58 | Kay, Oklahoma, US | |
2022-12-14 | US | Nevada | Carson City | 32510 | 17015 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-15 04:20:58 | Carson City, Nevada, US | |
2022-12-14 | US | Kentucky | Harlan | 21095 | 12162 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-15 04:20:58 | Harlan, Kentucky, US | |
2022-12-14 | US | Arkansas | Mississippi | 5093 | 15837 | 228 | 0 | 35.76271485 | -90.0519437 | 2022-12-15 04:20:58 | Mississippi, Arkansas, US | |
2022-12-14 | US | Arkansas | Independence | 5063 | 12479 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-15 04:20:58 | Independence, Arkansas, US | |
2022-12-13 | US | Oklahoma | Kay | 40071 | 14607 | 228 | 0 | 36.81799745 | -97.14421435 | 2022-12-14 04:21:04 | Kay, Oklahoma, US | |
2022-12-13 | US | Nevada | Carson City | 32510 | 16956 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-14 04:21:04 | Carson City, Nevada, US | |
2022-12-13 | US | Kentucky | Harlan | 21095 | 12162 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-14 04:21:04 | Harlan, Kentucky, US | |
2022-12-13 | US | Arkansas | Mississippi | 5093 | 15828 | 228 | 0 | 35.76271485 | -90.0519437 | 2022-12-14 04:21:04 | Mississippi, Arkansas, US | |
2022-12-13 | US | Arkansas | Independence | 5063 | 12470 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-14 04:21:04 | Independence, Arkansas, US | |
2022-12-12 | US | Oklahoma | Kay | 40071 | 14607 | 228 | 0 | 36.81799745 | -97.14421435 | 2022-12-13 04:21:01 | Kay, Oklahoma, US | |
2022-12-12 | US | Nevada | Carson City | 32510 | 16956 | 228 | 0 | 39.15509045 | -119.7480219 | 2022-12-13 04:21:01 | Carson City, Nevada, US | |
2022-12-12 | US | Kentucky | Harlan | 21095 | 12162 | 228 | 0 | 36.85699301 | -83.21899516 | 2022-12-13 04:21:01 | Harlan, Kentucky, US | |
2022-12-12 | US | Arkansas | Mississippi | 5093 | 15820 | 228 | 0 | 35.76271485 | -90.0519437 | 2022-12-13 04:21:01 | Mississippi, Arkansas, US | |
2022-12-12 | US | Arkansas | Independence | 5063 | 12459 | 228 | 0 | 35.74242707 | -91.57001641 | 2022-12-13 04:21:01 | Independence, Arkansas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;