johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26 rows where confirmed = 22138 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 4
- US 22
- Russia 2
- Chile 1
- Timor-Leste 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2009845 | 2009845 | 2022-08-04 | US | Indiana | Warrick | 18173 | 22138 | 243 | 0 | 38.08922676 | -87.2716085 | 2022-08-05 04:20:52 | Warrick, Indiana, US | |
1099272 | 1099272 | 2022-08-03 | US | Indiana | Warrick | 18173 | 22138 | 243 | 0 | 38.08922676 | -87.2716085 | 2022-08-04 04:20:58 | Warrick, Indiana, US | |
1398229 | 1398229 | 2022-05-06 | US | Arkansas | White | 5145 | 22138 | 292 | 0 | 35.25688493 | -91.74908296 | 2022-05-07 04:21:09 | White, Arkansas, US | |
3630872 | 3630872 | 2022-03-13 | US | Tennessee | Anderson | 47001 | 22138 | 317 | 0 | 36.12684348 | -84.19965764 | 2022-03-14 04:20:46 | Anderson, Tennessee, US | |
2199410 | 2199410 | 2022-03-06 | Chile | Aysen | 22138 | 133 | 0 | -45.9864 | -73.7669 | 2022-03-07 04:20:47 | Aysen, Chile | |||
1298391 | 1298391 | 2022-02-17 | Timor-Leste | 22138 | 125 | 0 | -8.874217 | 125.727539 | 2022-02-18 04:21:04 | Timor-Leste | ||||
3302554 | 3302554 | 2022-01-30 | US | North Carolina | Moore | 37125 | 22138 | 279 | 0 | 35.30885257 | -79.48474178 | 2022-01-31 04:21:09 | Moore, North Carolina, US | |
3064345 | 3064345 | 2022-01-29 | US | North Carolina | Moore | 37125 | 22138 | 279 | 0 | 35.30885257 | -79.48474178 | 2022-01-30 04:21:26 | Moore, North Carolina, US | |
3812279 | 3812279 | 2022-01-28 | US | North Carolina | Moore | 37125 | 22138 | 279 | 0 | 35.30885257 | -79.48474178 | 2022-01-29 04:21:10 | Moore, North Carolina, US | |
1474006 | 1474006 | 2022-01-17 | US | Missouri | Clay | 29047 | 22138 | 290 | 0 | 39.31132056 | -94.41850862 | 2022-01-18 04:21:04 | Clay, Missouri, US | |
556680 | 556680 | 2022-01-16 | US | Missouri | Clay | 29047 | 22138 | 290 | 0 | 39.31132056 | -94.41850862 | 2022-01-17 04:21:08 | Clay, Missouri, US | |
3842401 | 3842401 | 2022-01-15 | US | Missouri | Clay | 29047 | 22138 | 290 | 0 | 39.31132056 | -94.41850862 | 2022-01-16 04:21:12 | Clay, Missouri, US | |
1285403 | 1285403 | 2022-01-05 | US | Virginia | Stafford | 51179 | 22138 | 119 | 0 | 38.41758738 | -77.45917053 | 2022-01-06 04:22:09 | Stafford, Virginia, US | |
1669296 | 1669296 | 2021-12-29 | US | Georgia | Lowndes | 13185 | 22138 | 328 | 0 | 30.83568832 | -83.27056716 | 2021-12-30 04:21:25 | Lowndes, Georgia, US | |
164710 | 164710 | 2021-11-19 | US | Pennsylvania | Lebanon | 42075 | 22138 | 351 | 0 | 40.36680311 | -76.45651841 | 2021-11-20 04:22:17 | Lebanon, Pennsylvania, US | |
3512958 | 3512958 | 2021-11-01 | US | Maine | Cumberland | 23005 | 22138 | 234 | 0 | 43.8370751 | -70.37226999 | 2021-11-02 04:22:03 | Cumberland, Maine, US | |
289549 | 289549 | 2021-10-31 | US | Maine | Cumberland | 23005 | 22138 | 234 | 0 | 43.8370751 | -70.37226999 | 2021-11-01 04:22:01 | Cumberland, Maine, US | |
2722555 | 2722555 | 2021-10-30 | US | Maine | Cumberland | 23005 | 22138 | 234 | 0 | 43.8370751 | -70.37226999 | 2021-10-31 04:22:08 | Cumberland, Maine, US | |
1492504 | 1492504 | 2021-10-12 | US | Georgia | Whitfield | 13313 | 22138 | 321 | 0 | 34.80987459 | -84.96093476 | 2021-10-13 04:20:51 | Whitfield, Georgia, US | |
1495827 | 1495827 | 2021-07-03 | Russia | Mordovia Republic | 22138 | 337 | 19836 | 1965 | 54.4419829 | 44.4661144 | 2021-07-04 04:21:38 | Mordovia Republic, Russia | ||
1569593 | 1569593 | 2021-04-22 | US | Louisiana | Calcasieu | 22019 | 22138 | 418 | 0 | 30.22931235 | -93.35400434 | 2021-04-23 04:20:52 | Calcasieu, Louisiana, US | |
2411053 | 2411053 | 2021-04-19 | Russia | Khakassia Republic | 22138 | 519 | 21383 | 236 | 53.72258845 | 91.44293627 | 2021-04-20 04:20:41 | Khakassia Republic, Russia | ||
3624641 | 3624641 | 2021-03-17 | US | Wisconsin | Outagamie | 55087 | 22138 | 211 | 0 | 44.41578887 | -88.46565023 | 2021-03-18 05:26:22 | Outagamie, Wisconsin, US | |
614232 | 614232 | 2021-02-08 | US | California | Kings | 6031 | 22138 | 195 | 0 | 22040 | 36.07409056 | -119.8159973 | 2021-02-09 05:23:30 | Kings, California, US |
2626575 | 2626575 | 2021-01-10 | US | Florida | Leon | 12073 | 22138 | 184 | 0 | 21954 | 30.45955727 | -84.27491114 | 2021-01-11 05:21:50 | Leon, Florida, US |
2348479 | 2348479 | 2020-12-07 | US | Indiana | Allen | 18003 | 22138 | 362 | 0 | 21776 | 41.09194313 | -85.06800636 | 2020-12-08 05:27:42 | Allen, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);