johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
15 rows where confirmed = 33048 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 5
- US 8
- Russia 4
- India 1
- Mexico 1
- Netherlands 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954866 | 2954866 | 2022-12-20 | US | West Virginia | Cabell | 54011 | 33048 | 425 | 0 | 38.42424062 | -82.23855912 | 2022-12-21 04:21:03 | Cabell, West Virginia, US | |
3285958 | 3285958 | 2022-10-31 | US | Illinois | Vermilion | 17183 | 33048 | 308 | 0 | 40.18417171 | -87.73384359 | 2022-11-01 04:22:36 | Vermilion, Illinois, US | |
4430 | 4430 | 2021-10-28 | Mexico | Colima | 33048 | 1985 | 0 | 19.1223 | -104.0072 | 2021-10-29 04:22:03 | Colima, Mexico | |||
1887229 | 1887229 | 2021-09-12 | US | New York | Dutchess | 36027 | 33048 | 478 | 0 | 41.76486060000001 | -73.74356679 | 2021-09-13 04:21:15 | Dutchess, New York, US | |
3894822 | 3894822 | 2021-08-29 | US | South Dakota | Minnehaha | 46099 | 33048 | 366 | 0 | 43.67441641 | -96.7910885 | 2021-08-30 04:21:23 | Minnehaha, South Dakota, US | |
2795925 | 2795925 | 2021-08-28 | US | South Dakota | Minnehaha | 46099 | 33048 | 366 | 0 | 43.67441641 | -96.7910885 | 2021-08-29 04:21:14 | Minnehaha, South Dakota, US | |
2926084 | 2926084 | 2021-08-27 | US | South Dakota | Minnehaha | 46099 | 33048 | 366 | 0 | 43.67441641 | -96.7910885 | 2021-08-28 04:21:28 | Minnehaha, South Dakota, US | |
726617 | 726617 | 2021-05-22 | Netherlands | Drenthe | 33048 | 352 | 0 | 32655 | 52.862485 | 6.618435000000002 | 2021-05-23 04:20:51 | Drenthe, Netherlands | ||
1952770 | 1952770 | 2021-05-21 | Russia | Vladimir Oblast | 33048 | 1165 | 30673 | 1210 | 56.0503336 | 40.6561633 | 2021-05-22 04:20:45 | Vladimir Oblast, Russia | ||
3675838 | 3675838 | 2021-05-04 | Russia | Astrakhan Oblast | 33048 | 736 | 31435 | 877 | 47.1878186 | 47.608851 | 2021-05-05 04:20:43 | Astrakhan Oblast, Russia | ||
36633 | 36633 | 2021-04-12 | Russia | Kaluga Oblast | 33048 | 295 | 30922 | 1831 | 54.4382773 | 35.5272854 | 2021-04-13 04:20:37 | Kaluga Oblast, Russia | ||
3621269 | 3621269 | 2021-03-17 | Russia | Belgorod Oblast | 33048 | 523 | 30619 | 1906 | 50.7080119 | 37.5837615 | 2021-03-18 05:26:22 | Belgorod Oblast, Russia | ||
2430289 | 2430289 | 2021-01-23 | US | Virginia | Prince William | 51153 | 33048 | 285 | 0 | 32763 | 38.70916224 | -77.48713689 | 2021-01-24 05:22:35 | Prince William, Virginia, US |
3847756 | 3847756 | 2020-12-13 | India | Tripura | 33048 | 376 | 32342 | 330 | 23.746783 | 91.743565 | 2020-12-14 05:26:27 | Tripura, India | ||
3785452 | 3785452 | 2020-10-13 | US | Wisconsin | Milwaukee | 55079 | 33048 | 551 | 0 | 32497 | 43.00486062 | -87.96733172 | 2020-10-14 04:24:05 | Milwaukee, Wisconsin, 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]);