daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,379 rows where deaths = 225 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,881
- Brunei 203
- Germany 63
- Russia 34
- Japan 29
- Netherlands 20
- Sweden 20
- Chile 11
- Spain 10
- Colombia 8
- India 7
- Nicaragua 7
- Malaysia 6
- Maldives 6
- France 5
- Peru 5
- Australia 4
- Ukraine 4
- Bahamas 3
- Mexico 3
- Zimbabwe 3
- Canada 2
- Congo (Kinshasa) 2
- Grenada 2
- Guyana 2
- Haiti 2
- Jamaica 2
- Lesotho 2
- Mali 2
- Pakistan 2
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-29 | US | Texas | Jim Wells | 48249 | 13799 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-30 04:21:04 | Jim Wells, Texas, US | |
2022-12-29 | US | South Carolina | Colleton | 45029 | 10901 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-30 04:21:04 | Colleton, South Carolina, US | |
2022-12-29 | US | Hawaii | Hawaii | 15001 | 41561 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-30 04:21:04 | Hawaii, Hawaii, US | |
2022-12-29 | US | Arkansas | Pope | 5115 | 20737 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-30 04:21:04 | Pope, Arkansas, US | |
2022-12-29 | Brunei | 266819 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-30 04:21:04 | Brunei | ||||
2022-12-28 | US | Texas | Jim Wells | 48249 | 13799 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-29 04:21:01 | Jim Wells, Texas, US | |
2022-12-28 | US | South Carolina | Colleton | 45029 | 10901 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-29 04:21:01 | Colleton, South Carolina, US | |
2022-12-28 | US | Hawaii | Hawaii | 15001 | 41561 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-29 04:21:01 | Hawaii, Hawaii, US | |
2022-12-28 | US | Arkansas | Pope | 5115 | 20737 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-29 04:21:01 | Pope, Arkansas, US | |
2022-12-28 | Brunei | 266819 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-29 04:21:01 | Brunei | ||||
2022-12-27 | US | Texas | Jim Wells | 48249 | 13723 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-28 04:21:04 | Jim Wells, Texas, US | |
2022-12-27 | US | South Carolina | Colleton | 45029 | 10901 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-28 04:21:04 | Colleton, South Carolina, US | |
2022-12-27 | US | Hawaii | Hawaii | 15001 | 41413 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-28 04:21:04 | Hawaii, Hawaii, US | |
2022-12-27 | US | Arkansas | Pope | 5115 | 20722 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-28 04:21:04 | Pope, Arkansas, US | |
2022-12-27 | Brunei | 266819 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-28 04:21:04 | Brunei | ||||
2022-12-26 | US | Texas | Jim Wells | 48249 | 13723 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-27 04:21:07 | Jim Wells, Texas, US | |
2022-12-26 | US | South Carolina | Colleton | 45029 | 10840 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-27 04:21:07 | Colleton, South Carolina, US | |
2022-12-26 | US | Hawaii | Hawaii | 15001 | 41413 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-27 04:21:07 | Hawaii, Hawaii, US | |
2022-12-26 | US | Arkansas | Pope | 5115 | 20715 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-27 04:21:07 | Pope, Arkansas, US | |
2022-12-26 | Brunei | 266819 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-27 04:21:07 | Brunei | ||||
2022-12-25 | US | Texas | Jim Wells | 48249 | 13723 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-26 04:21:06 | Jim Wells, Texas, US | |
2022-12-25 | US | South Carolina | Colleton | 45029 | 10840 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-26 04:21:06 | Colleton, South Carolina, US | |
2022-12-25 | US | Hawaii | Hawaii | 15001 | 41413 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-26 04:21:06 | Hawaii, Hawaii, US | |
2022-12-25 | US | Arkansas | Pope | 5115 | 20707 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-26 04:21:06 | Pope, Arkansas, US | |
2022-12-25 | Brunei | 266819 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-26 04:21:06 | Brunei | ||||
2022-12-24 | US | Texas | Jim Wells | 48249 | 13723 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-25 04:21:04 | Jim Wells, Texas, US | |
2022-12-24 | US | South Carolina | Colleton | 45029 | 10840 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-25 04:21:04 | Colleton, South Carolina, US | |
2022-12-24 | US | Hawaii | Hawaii | 15001 | 41413 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-25 04:21:04 | Hawaii, Hawaii, US | |
2022-12-24 | US | Arkansas | Pope | 5115 | 20707 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-25 04:21:04 | Pope, Arkansas, US | |
2022-12-24 | Brunei | 266819 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-25 04:21:04 | Brunei | ||||
2022-12-23 | US | Texas | Jim Wells | 48249 | 13723 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-24 04:21:02 | Jim Wells, Texas, US | |
2022-12-23 | US | South Carolina | Colleton | 45029 | 10840 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-24 04:21:02 | Colleton, South Carolina, US | |
2022-12-23 | US | Hawaii | Hawaii | 15001 | 41413 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-24 04:21:02 | Hawaii, Hawaii, US | |
2022-12-23 | US | Arkansas | Pope | 5115 | 20702 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-24 04:21:02 | Pope, Arkansas, US | |
2022-12-23 | Brunei | 266819 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-24 04:21:02 | Brunei | ||||
2022-12-22 | US | Texas | Jim Wells | 48249 | 13723 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-23 04:21:04 | Jim Wells, Texas, US | |
2022-12-22 | US | South Carolina | Colleton | 45029 | 10840 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-23 04:21:04 | Colleton, South Carolina, US | |
2022-12-22 | US | Hawaii | Hawaii | 15001 | 41413 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-23 04:21:04 | Hawaii, Hawaii, US | |
2022-12-22 | US | Arkansas | Pope | 5115 | 20689 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-23 04:21:04 | Pope, Arkansas, US | |
2022-12-22 | Brunei | 266819 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-23 04:21:04 | Brunei | ||||
2022-12-21 | US | Texas | Jim Wells | 48249 | 13723 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-22 04:20:56 | Jim Wells, Texas, US | |
2022-12-21 | US | South Carolina | Colleton | 45029 | 10840 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-22 04:20:56 | Colleton, South Carolina, US | |
2022-12-21 | US | Hawaii | Hawaii | 15001 | 41413 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-22 04:20:56 | Hawaii, Hawaii, US | |
2022-12-21 | US | Arkansas | Pope | 5115 | 20677 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-22 04:20:56 | Pope, Arkansas, US | |
2022-12-21 | Japan | Yamanashi | 145254 | 225 | 0 | 35.612364 | 138.611489 | 2022-12-22 04:20:56 | Yamanashi, Japan | |||
2022-12-21 | Brunei | 266819 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-22 04:20:56 | Brunei | ||||
2022-12-20 | US | Texas | Wharton | 48481 | 11113 | 225 | 0 | 29.27765923 | -96.22319248 | 2022-12-21 04:21:03 | Wharton, Texas, US | |
2022-12-20 | US | Texas | Jim Wells | 48249 | 13662 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-21 04:21:03 | Jim Wells, Texas, US | |
2022-12-20 | US | South Carolina | Colleton | 45029 | 10840 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-21 04:21:03 | Colleton, South Carolina, US | |
2022-12-20 | US | Hawaii | Hawaii | 15001 | 41275 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-21 04:21:03 | Hawaii, Hawaii, US | |
2022-12-20 | US | Arkansas | Pope | 5115 | 20668 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-21 04:21:03 | Pope, Arkansas, US | |
2022-12-20 | Japan | Toyama | 191286 | 225 | 0 | 36.637464 | 137.269346 | 2022-12-21 04:21:03 | Toyama, Japan | |||
2022-12-20 | Brunei | 266819 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-21 04:21:03 | Brunei | ||||
2022-12-19 | US | Texas | Wharton | 48481 | 11113 | 225 | 0 | 29.27765923 | -96.22319248 | 2022-12-20 04:21:04 | Wharton, Texas, US | |
2022-12-19 | US | Texas | Jim Wells | 48249 | 13662 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-20 04:21:04 | Jim Wells, Texas, US | |
2022-12-19 | US | South Carolina | Colleton | 45029 | 10796 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-20 04:21:04 | Colleton, South Carolina, US | |
2022-12-19 | US | Hawaii | Hawaii | 15001 | 41275 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-20 04:21:04 | Hawaii, Hawaii, US | |
2022-12-19 | US | Arkansas | Pope | 5115 | 20648 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-20 04:21:04 | Pope, Arkansas, US | |
2022-12-19 | Brunei | 264490 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-20 04:21:04 | Brunei | ||||
2022-12-18 | US | Texas | Wharton | 48481 | 11113 | 225 | 0 | 29.27765923 | -96.22319248 | 2022-12-19 04:21:03 | Wharton, Texas, US | |
2022-12-18 | US | Texas | Jim Wells | 48249 | 13662 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-19 04:21:03 | Jim Wells, Texas, US | |
2022-12-18 | US | South Carolina | Colleton | 45029 | 10796 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-19 04:21:03 | Colleton, South Carolina, US | |
2022-12-18 | US | Hawaii | Hawaii | 15001 | 41275 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-19 04:21:03 | Hawaii, Hawaii, US | |
2022-12-18 | US | Arkansas | Pope | 5115 | 20643 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-19 04:21:03 | Pope, Arkansas, US | |
2022-12-18 | Brunei | 264490 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-19 04:21:03 | Brunei | ||||
2022-12-17 | US | Texas | Wharton | 48481 | 11113 | 225 | 0 | 29.27765923 | -96.22319248 | 2022-12-18 04:21:03 | Wharton, Texas, US | |
2022-12-17 | US | Texas | Jim Wells | 48249 | 13662 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-18 04:21:03 | Jim Wells, Texas, US | |
2022-12-17 | US | South Carolina | Colleton | 45029 | 10796 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-18 04:21:03 | Colleton, South Carolina, US | |
2022-12-17 | US | Hawaii | Hawaii | 15001 | 41275 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-18 04:21:03 | Hawaii, Hawaii, US | |
2022-12-17 | US | Arkansas | Pope | 5115 | 20640 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-18 04:21:03 | Pope, Arkansas, US | |
2022-12-17 | Brunei | 264490 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-18 04:21:03 | Brunei | ||||
2022-12-16 | US | Texas | Wharton | 48481 | 11113 | 225 | 0 | 29.27765923 | -96.22319248 | 2022-12-17 04:21:04 | Wharton, Texas, US | |
2022-12-16 | US | Texas | Jim Wells | 48249 | 13662 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-17 04:21:04 | Jim Wells, Texas, US | |
2022-12-16 | US | South Carolina | Colleton | 45029 | 10796 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-17 04:21:04 | Colleton, South Carolina, US | |
2022-12-16 | US | Hawaii | Hawaii | 15001 | 41275 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-17 04:21:04 | Hawaii, Hawaii, US | |
2022-12-16 | US | Arkansas | Pope | 5115 | 20635 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-17 04:21:04 | Pope, Arkansas, US | |
2022-12-16 | Brunei | 264490 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-17 04:21:04 | Brunei | ||||
2022-12-15 | US | Texas | Wharton | 48481 | 11113 | 225 | 0 | 29.27765923 | -96.22319248 | 2022-12-16 04:21:01 | Wharton, Texas, US | |
2022-12-15 | US | Texas | Jim Wells | 48249 | 13662 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-16 04:21:01 | Jim Wells, Texas, US | |
2022-12-15 | US | South Carolina | Colleton | 45029 | 10796 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-16 04:21:01 | Colleton, South Carolina, US | |
2022-12-15 | US | Hawaii | Hawaii | 15001 | 41275 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-16 04:21:01 | Hawaii, Hawaii, US | |
2022-12-15 | US | Arkansas | Pope | 5115 | 20626 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-16 04:21:01 | Pope, Arkansas, US | |
2022-12-15 | Brunei | 264490 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-16 04:21:01 | Brunei | ||||
2022-12-14 | US | Texas | Wharton | 48481 | 11113 | 225 | 0 | 29.27765923 | -96.22319248 | 2022-12-15 04:20:58 | Wharton, Texas, US | |
2022-12-14 | US | Texas | Jim Wells | 48249 | 13662 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-15 04:20:58 | Jim Wells, Texas, US | |
2022-12-14 | US | Tennessee | Lawrence | 47099 | 16566 | 225 | 0 | 35.21675201 | -87.39787695 | 2022-12-15 04:20:58 | Lawrence, Tennessee, US | |
2022-12-14 | US | South Carolina | Colleton | 45029 | 10796 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-15 04:20:58 | Colleton, South Carolina, US | |
2022-12-14 | US | Hawaii | Hawaii | 15001 | 41275 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-15 04:20:58 | Hawaii, Hawaii, US | |
2022-12-14 | US | Arkansas | Pope | 5115 | 20621 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-15 04:20:58 | Pope, Arkansas, US | |
2022-12-14 | Brunei | 264490 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-15 04:20:58 | Brunei | ||||
2022-12-13 | US | Texas | Wharton | 48481 | 11067 | 225 | 0 | 29.27765923 | -96.22319248 | 2022-12-14 04:21:04 | Wharton, Texas, US | |
2022-12-13 | US | Texas | Jim Wells | 48249 | 13613 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-14 04:21:04 | Jim Wells, Texas, US | |
2022-12-13 | US | Tennessee | Lawrence | 47099 | 16562 | 225 | 0 | 35.21675201 | -87.39787695 | 2022-12-14 04:21:04 | Lawrence, Tennessee, US | |
2022-12-13 | US | South Carolina | Colleton | 45029 | 10796 | 225 | 0 | 32.87582989 | -80.67641292 | 2022-12-14 04:21:04 | Colleton, South Carolina, US | |
2022-12-13 | US | Illinois | Adams | 17001 | 26914 | 225 | 0 | 39.98815591 | -91.18786813 | 2022-12-14 04:21:04 | Adams, Illinois, US | |
2022-12-13 | US | Hawaii | Hawaii | 15001 | 41140 | 225 | 0 | 19.60121157 | -155.5210167 | 2022-12-14 04:21:04 | Hawaii, Hawaii, US | |
2022-12-13 | US | Arkansas | Pope | 5115 | 20597 | 225 | 0 | 35.44871474 | -93.03212219 | 2022-12-14 04:21:04 | Pope, Arkansas, US | |
2022-12-13 | Brunei | 264490 | 225 | 0 | 4.5353 | 114.7277 | 2022-12-14 04:21:04 | Brunei | ||||
2022-12-12 | US | Texas | Wharton | 48481 | 11067 | 225 | 0 | 29.27765923 | -96.22319248 | 2022-12-13 04:21:01 | Wharton, Texas, US | |
2022-12-12 | US | Texas | Jim Wells | 48249 | 13613 | 225 | 0 | 27.73103938 | -98.0904705 | 2022-12-13 04:21:01 | Jim Wells, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;