johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
18 rows where confirmed = 32014 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
690444 | 690444 | 2022-12-23 | Malaysia | W.P. Putrajaya | 32014 | 31 | 0 | 2.9264 | 101.6964 | 2022-12-24 04:21:02 | W.P. Putrajaya, Malaysia | |||
1241556 | 1241556 | 2022-11-28 | US | Missouri | Clay | 29047 | 32014 | 396 | 0 | 39.31132056 | -94.41850862 | 2022-11-29 04:21:05 | Clay, Missouri, US | |
3553544 | 3553544 | 2022-11-27 | US | Missouri | Clay | 29047 | 32014 | 396 | 0 | 39.31132056 | -94.41850862 | 2022-11-28 04:21:02 | Clay, Missouri, US | |
2102024 | 2102024 | 2022-11-26 | US | Missouri | Clay | 29047 | 32014 | 396 | 0 | 39.31132056 | -94.41850862 | 2022-11-27 04:21:05 | Clay, Missouri, US | |
489515 | 489515 | 2022-11-25 | US | Missouri | Clay | 29047 | 32014 | 396 | 0 | 39.31132056 | -94.41850862 | 2022-11-26 04:21:11 | Clay, Missouri, US | |
3525344 | 3525344 | 2022-11-24 | US | Missouri | Clay | 29047 | 32014 | 396 | 0 | 39.31132056 | -94.41850862 | 2022-11-25 04:21:06 | Clay, Missouri, US | |
3314127 | 3314127 | 2022-11-23 | US | Missouri | Clay | 29047 | 32014 | 396 | 0 | 39.31132056 | -94.41850862 | 2022-11-24 04:21:09 | Clay, Missouri, US | |
1622168 | 1622168 | 2022-11-22 | US | Missouri | Clay | 29047 | 32014 | 396 | 0 | 39.31132056 | -94.41850862 | 2022-11-23 04:21:06 | Clay, Missouri, US | |
2287401 | 2287401 | 2021-11-15 | India | Nagaland | 32014 | 694 | 0 | 26.06702 | 94.470302 | 2021-11-16 04:21:10 | Nagaland, India | |||
3797116 | 3797116 | 2021-10-25 | US | Texas | Smith | 48423 | 32014 | 775 | 0 | 32.37474036 | -95.27175679999999 | 2021-10-26 04:22:09 | Smith, Texas, US | |
685562 | 685562 | 2021-10-24 | US | Texas | Smith | 48423 | 32014 | 775 | 0 | 32.37474036 | -95.27175679999999 | 2021-10-25 04:22:31 | Smith, Texas, US | |
1596350 | 1596350 | 2021-08-26 | Pakistan | Balochistan | 32014 | 338 | 0 | 28.328491999999997 | 65.898403 | 2021-08-27 04:21:37 | Balochistan, Pakistan | |||
32559 | 32559 | 2021-08-25 | Pakistan | Balochistan | 32014 | 338 | 0 | 28.328491999999997 | 65.898403 | 2021-08-26 04:21:28 | Balochistan, Pakistan | |||
379980 | 379980 | 2021-04-30 | Chile | Coquimbo | 32014 | 615 | 30303 | 1096 | -29.959 | -71.3389 | 2021-05-01 04:20:47 | Coquimbo, Chile | ||
3770084 | 3770084 | 2020-12-22 | Russia | Khabarovsk Krai | 32014 | 196 | 27266 | 4552 | 51.6312684 | 136.121524 | 2020-12-23 05:22:03 | Khabarovsk Krai, Russia | ||
3769730 | 3769730 | 2020-12-22 | Colombia | Meta | 32014 | 705 | 30234 | 1075 | 3.272 | -73.0877 | 2020-12-23 05:22:03 | Meta, Colombia | ||
1820348 | 1820348 | 2020-12-08 | US | Maryland | Baltimore | 24005 | 32014 | 781 | 0 | 31233 | 39.45784712 | -76.62911955 | 2020-12-09 05:28:01 | Baltimore, Maryland, US |
2701647 | 2701647 | 2020-11-20 | Norway | 32014 | 306 | 17998 | 13710 | 60.472 | 8.4689 | 2020-11-21 05:25:51 | Norway |
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]);