johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
19 rows where confirmed = 37497 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 16
- India 1
- Japan 1
- Netherlands 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
293129 | 293129 | 2022-11-15 | US | Indiana | Madison | 18095 | 37497 | 672 | 0 | 40.16143691 | -85.71964711 | 2022-11-16 04:21:09 | Madison, Indiana, US | |
3598159 | 3598159 | 2022-11-14 | US | Indiana | Madison | 18095 | 37497 | 672 | 0 | 40.16143691 | -85.71964711 | 2022-11-15 04:21:16 | Madison, Indiana, US | |
313017 | 313017 | 2022-11-13 | US | Indiana | Madison | 18095 | 37497 | 672 | 0 | 40.16143691 | -85.71964711 | 2022-11-14 04:21:09 | Madison, Indiana, US | |
64178 | 64178 | 2022-11-12 | US | Indiana | Madison | 18095 | 37497 | 672 | 0 | 40.16143691 | -85.71964711 | 2022-11-13 04:21:14 | Madison, Indiana, US | |
2928340 | 2928340 | 2022-11-11 | US | Indiana | Madison | 18095 | 37497 | 672 | 0 | 40.16143691 | -85.71964711 | 2022-11-12 04:20:41 | Madison, Indiana, US | |
2507176 | 2507176 | 2022-11-10 | US | Indiana | Madison | 18095 | 37497 | 672 | 0 | 40.16143691 | -85.71964711 | 2022-11-11 04:21:22 | Madison, Indiana, US | |
2432051 | 2432051 | 2022-11-09 | US | Indiana | Madison | 18095 | 37497 | 672 | 0 | 40.16143691 | -85.71964711 | 2022-11-10 04:21:16 | Madison, Indiana, US | |
2187613 | 2187613 | 2022-06-22 | Japan | Iwate | 37497 | 96 | 0 | 39.593287 | 141.361777 | 2022-06-23 04:20:55 | Iwate, Japan | |||
1766886 | 1766886 | 2022-06-20 | US | Wisconsin | La Crosse | 55063 | 37497 | 188 | 0 | 43.90632465 | -91.11451093 | 2022-06-21 04:20:56 | La Crosse, Wisconsin, US | |
3001089 | 3001089 | 2022-05-24 | US | Minnesota | Wright | 27171 | 37497 | 305 | 0 | 45.17297924 | -93.96234781 | 2022-05-25 04:20:56 | Wright, Minnesota, US | |
1160231 | 1160231 | 2022-04-29 | US | Texas | Ector | 48135 | 37497 | 703 | 0 | 31.86898877 | -102.5429428 | 2022-04-30 04:21:05 | Ector, Texas, US | |
1699413 | 1699413 | 2022-04-28 | US | Texas | Ector | 48135 | 37497 | 702 | 0 | 31.86898877 | -102.5429428 | 2022-04-29 04:20:59 | Ector, Texas, US | |
575217 | 575217 | 2022-02-25 | US | Alabama | Lee | 1081 | 37497 | 308 | 0 | 32.60154883 | -85.35132246 | 2022-02-26 04:21:12 | Lee, Alabama, US | |
1058702 | 1058702 | 2022-02-23 | US | Georgia | Muscogee | 13215 | 37497 | 741 | 0 | 32.50931999 | -84.87142262 | 2022-02-24 04:21:14 | Muscogee, Georgia, US | |
1448711 | 1448711 | 2021-06-03 | Netherlands | Groningen | 37497 | 254 | 0 | 38520 | 53.217922 | 6.741514 | 2021-06-04 04:23:37 | Groningen, Netherlands | ||
38870 | 38870 | 2021-04-12 | US | Ohio | Butler | 39017 | 37497 | 588 | 0 | 39.44012838 | -84.57388716 | 2021-04-13 04:20:37 | Butler, Ohio, US | |
2986279 | 2986279 | 2021-04-10 | US | Texas | Brazoria | 48039 | 37497 | 465 | 0 | 29.18757369 | -95.44563172 | 2021-04-11 04:20:56 | Brazoria, Texas, US | |
55522 | 55522 | 2021-03-07 | US | Florida | Osceola | 12097 | 37497 | 459 | 0 | 28.06312234 | -81.14882926 | 2021-03-08 05:24:48 | Osceola, Florida, US | |
923630 | 923630 | 2020-11-26 | India | Himachal Pradesh | 37497 | 599 | 29020 | 7878 | 31.927213 | 77.233081 | 2020-11-27 05:26:53 | Himachal Pradesh, India |
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]);