johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
34 rows where confirmed = 14290 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 6
- US 28
- Russia 2
- Burkina Faso 1
- Cabo Verde 1
- Colombia 1
- Japan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3648601 | 3648601 | 2022-08-14 | US | Illinois | Macoupin | 17117 | 14290 | 143 | 0 | 39.26119767 | -89.92424028 | 2022-08-15 04:20:59 | Macoupin, Illinois, US | |
1969607 | 1969607 | 2022-08-13 | US | Illinois | Macoupin | 17117 | 14290 | 143 | 0 | 39.26119767 | -89.92424028 | 2022-08-14 04:20:55 | Macoupin, Illinois, US | |
2889416 | 2889416 | 2022-08-12 | US | Illinois | Macoupin | 17117 | 14290 | 143 | 0 | 39.26119767 | -89.92424028 | 2022-08-13 04:20:52 | Macoupin, Illinois, US | |
3113015 | 3113015 | 2022-07-13 | US | Wisconsin | Barron | 55005 | 14290 | 147 | 0 | 45.42372701 | -91.84833627 | 2022-07-14 04:20:57 | Barron, Wisconsin, US | |
1186900 | 1186900 | 2022-05-18 | US | New Hampshire | Belknap | 33001 | 14290 | 181 | 0 | 43.51637314 | -71.41684235 | 2022-05-19 04:20:54 | Belknap, New Hampshire, US | |
3447090 | 3447090 | 2022-05-11 | US | New York | Madison | 36053 | 14290 | 127 | 0 | 42.91653905 | -75.67266639 | 2022-05-12 04:20:54 | Madison, New York, US | |
1400732 | 1400732 | 2022-05-06 | US | Texas | Caldwell | 48055 | 14290 | 176 | 0 | 29.83668859 | -97.61814775 | 2022-05-07 04:21:09 | Caldwell, Texas, US | |
3025519 | 3025519 | 2022-03-23 | US | Texas | Val Verde | 48465 | 14290 | 296 | 0 | 29.89149232 | -101.1525205 | 2022-03-24 04:20:43 | Val Verde, Texas, US | |
1908441 | 1908441 | 2022-03-22 | US | Texas | Val Verde | 48465 | 14290 | 296 | 0 | 29.89149232 | -101.1525205 | 2022-03-23 04:20:48 | Val Verde, Texas, US | |
3241572 | 3241572 | 2022-03-21 | US | Texas | Val Verde | 48465 | 14290 | 295 | 0 | 29.89149232 | -101.1525205 | 2022-03-22 04:20:54 | Val Verde, Texas, US | |
27645 | 27645 | 2022-03-20 | US | Texas | Val Verde | 48465 | 14290 | 295 | 0 | 29.89149232 | -101.1525205 | 2022-03-21 04:20:50 | Val Verde, Texas, US | |
945278 | 945278 | 2022-02-28 | US | Ohio | Athens | 39009 | 14290 | 136 | 0 | 39.33425634 | -82.04278644 | 2022-03-01 04:21:09 | Athens, Ohio, US | |
3522836 | 3522836 | 2022-01-02 | US | Virginia | Roanoke City | 51770 | 14290 | 272 | 0 | 37.27791025 | -79.96189766 | 2022-01-03 02:22:25 | Roanoke City, Virginia, US | |
2170966 | 2170966 | 2022-01-01 | US | Virginia | Roanoke City | 51770 | 14290 | 272 | 0 | 37.27791025 | -79.96189766 | 2022-01-02 04:20:52 | Roanoke City, Virginia, US | |
2780397 | 2780397 | 2021-12-31 | US | Virginia | Roanoke City | 51770 | 14290 | 272 | 0 | 37.27791025 | -79.96189766 | 2022-01-01 04:22:14 | Roanoke City, Virginia, US | |
3751353 | 3751353 | 2021-11-22 | US | New York | Chautauqua | 36013 | 14290 | 187 | 0 | 42.22769210000001 | -79.36691763 | 2021-11-23 04:22:39 | Chautauqua, New York, US | |
1016546 | 1016546 | 2021-11-21 | US | New Mexico | Santa Fe | 35049 | 14290 | 180 | 0 | 35.50708973 | -105.9774716 | 2021-11-22 04:22:20 | Santa Fe, New Mexico, US | |
724710 | 724710 | 2021-11-20 | US | New Mexico | Santa Fe | 35049 | 14290 | 180 | 0 | 35.50708973 | -105.9774716 | 2021-11-21 04:22:13 | Santa Fe, New Mexico, US | |
164240 | 164240 | 2021-11-19 | US | New Mexico | Santa Fe | 35049 | 14290 | 180 | 0 | 35.50708973 | -105.9774716 | 2021-11-20 04:22:17 | Santa Fe, New Mexico, US | |
3928046 | 3928046 | 2021-10-02 | Japan | Kumamoto | 14290 | 135 | 0 | 32.608154 | 130.74523100000002 | 2021-10-03 04:21:24 | Kumamoto, Japan | |||
3927783 | 3927783 | 2021-10-02 | Burkina Faso | 14290 | 187 | 0 | 12.2383 | -1.5616 | 2021-10-03 04:21:24 | Burkina Faso | ||||
3977087 | 3977087 | 2021-09-03 | US | Ohio | Wood | 39173 | 14290 | 209 | 0 | 41.36224827 | -83.62285108 | 2021-09-04 04:21:28 | Wood, Ohio, US | |
2591515 | 2591515 | 2021-06-27 | US | Louisiana | Livingston | 22063 | 14290 | 212 | 0 | 30.44143993 | -90.73061664 | 2021-06-28 04:21:29 | Livingston, Louisiana, US | |
3960019 | 3960019 | 2021-06-26 | US | Louisiana | Livingston | 22063 | 14290 | 212 | 0 | 30.44143993 | -90.73061664 | 2021-06-27 04:21:39 | Livingston, Louisiana, US | |
1713838 | 1713838 | 2021-06-25 | US | Louisiana | Livingston | 22063 | 14290 | 212 | 0 | 30.44143993 | -90.73061664 | 2021-06-26 04:21:43 | Livingston, Louisiana, US | |
3575292 | 3575292 | 2021-05-17 | US | Florida | Hernando | 12053 | 14290 | 473 | 0 | 28.55364461 | -82.42700204 | 2021-05-18 04:20:33 | Hernando, Florida, US | |
170790 | 170790 | 2021-04-16 | US | Georgia | Bartow | 13015 | 14290 | 223 | 0 | 34.23732119 | -84.83887523 | 2021-04-17 04:20:40 | Bartow, Georgia, US | |
2369656 | 2369656 | 2021-02-28 | US | New Jersey | Cumberland | 34011 | 14290 | 369 | 0 | 13921 | 39.37199394 | -75.10712559 | 2021-03-01 05:23:01 | Cumberland, New Jersey, US |
1155918 | 1155918 | 2021-02-18 | US | South Carolina | Berkeley | 45015 | 14290 | 160 | 0 | 14130 | 33.20222596 | -79.94654523 | 2021-02-19 05:24:16 | Berkeley, South Carolina, US |
790144 | 790144 | 2021-02-04 | Cabo Verde | 14290 | 135 | 13513 | 642 | 16.5388 | -23.0418 | 2021-02-05 05:22:38 | Cabo Verde | |||
1462286 | 1462286 | 2021-01-31 | US | Oklahoma | Canadian | 40017 | 14290 | 65 | 0 | 14225 | 35.5426055 | -97.98465569 | 2021-02-01 05:22:53 | Canadian, Oklahoma, US |
1061698 | 1061698 | 2021-01-04 | Colombia | La Guajira | 14290 | 547 | 13269 | 474 | 11.3548 | -72.5205 | 2021-01-05 05:21:49 | La Guajira, Colombia | ||
2514382 | 2514382 | 2020-10-03 | Russia | Krasnodar Krai | 14290 | 289 | 10635 | 3366 | 45.7684014 | 39.0261044 | 2020-10-04 04:23:44 | Krasnodar Krai, Russia | ||
2837039 | 2837039 | 2020-09-21 | Russia | Murmansk Oblast | 14290 | 197 | 11744 | 2349 | 68.0000418 | 33.9999151 | 2020-09-22 04:23:00 | Murmansk Oblast, Russia |
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]);