johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
41 rows where confirmed = 11942 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 32
- Brazil 1
- Chile 1
- China 1
- Colombia 1
- Israel 1
- North Macedonia 1
- Russia 1
- Saint Lucia 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2181742 | 2181742 | 2022-12-22 | US | New Hampshire | Carroll | 33003 | 11942 | 71 | 0 | 43.87498583 | -71.20430216 | 2022-12-23 04:21:04 | Carroll, New Hampshire, US | |
2162316 | 2162316 | 2022-10-16 | US | Puerto Rico | San Sebastian | 72131 | 11942 | 0 | 0 | 18.328646 | -66.971214 | 2022-10-17 04:20:31 | San Sebastian, Puerto Rico, US | |
3409027 | 3409027 | 2022-07-17 | US | Wisconsin | Oconto | 55083 | 11942 | 124 | 0 | 45.02715345 | -88.26807503 | 2022-07-18 04:20:59 | Oconto, Wisconsin, US | |
2155227 | 2155227 | 2022-07-16 | US | Wisconsin | Oconto | 55083 | 11942 | 124 | 0 | 45.02715345 | -88.26807503 | 2022-07-17 04:21:15 | Oconto, Wisconsin, US | |
2422460 | 2422460 | 2022-07-15 | US | Wisconsin | Oconto | 55083 | 11942 | 124 | 0 | 45.02715345 | -88.26807503 | 2022-07-16 04:21:05 | Oconto, Wisconsin, US | |
1504619 | 1504619 | 2022-05-16 | US | Illinois | Marion | 17121 | 11942 | 211 | 0 | 38.64963204 | -88.91899208 | 2022-05-17 04:20:59 | Marion, Illinois, US | |
1654643 | 1654643 | 2022-04-09 | US | New York | Montgomery | 36057 | 11942 | 203 | 0 | 42.90123494 | -74.44011632 | 2022-04-10 04:20:52 | Montgomery, New York, US | |
1906896 | 1906896 | 2022-03-22 | US | Minnesota | Beltrami | 27007 | 11942 | 124 | 0 | 47.97373527 | -94.93732139 | 2022-03-23 04:20:48 | Beltrami, Minnesota, US | |
2321612 | 2321612 | 2022-03-16 | US | New York | Washington | 36115 | 11942 | 113 | 0 | 43.31153794 | -73.43043448 | 2022-03-17 04:20:56 | Washington, New York, US | |
1301654 | 1301654 | 2022-02-17 | US | Wyoming | Campbell | 56005 | 11942 | 139 | 0 | 44.24886082 | -105.54744040000001 | 2022-02-18 04:21:04 | Campbell, Wyoming, US | |
3823549 | 3823549 | 2022-02-16 | US | Texas | Hardin | 48199 | 11942 | 234 | 0 | 30.33364686 | -94.38931817 | 2022-02-17 04:20:56 | Hardin, Texas, US | |
3427227 | 3427227 | 2022-01-21 | US | New York | Warren | 36113 | 11942 | 115 | 0 | 43.56173026 | -73.8433699 | 2022-01-22 04:21:13 | Warren, New York, US | |
3688456 | 3688456 | 2022-01-13 | US | Illinois | Coles | 17029 | 11942 | 147 | 0 | 39.51949084 | -88.22358557 | 2022-01-14 04:21:54 | Coles, Illinois, US | |
3616023 | 3616023 | 2022-01-12 | US | Tennessee | Jefferson | 47089 | 11942 | 220 | 0 | 36.04818632 | -83.45148924 | 2022-01-13 08:00:09 | Jefferson, Tennessee, US | |
130314 | 130314 | 2022-01-09 | US | Wisconsin | Sauk | 55111 | 11942 | 84 | 0 | 43.42574087 | -89.94966132 | 2022-01-10 04:22:07 | Sauk, Wisconsin, US | |
1219149 | 1219149 | 2022-01-08 | US | Wisconsin | Sauk | 55111 | 11942 | 84 | 0 | 43.42574087 | -89.94966132 | 2022-01-09 04:21:46 | Sauk, Wisconsin, US | |
1393242 | 1393242 | 2022-01-07 | US | Wisconsin | Sauk | 55111 | 11942 | 84 | 0 | 43.42574087 | -89.94966132 | 2022-01-08 04:21:53 | Sauk, Wisconsin, US | |
3073398 | 3073398 | 2021-11-23 | US | Virginia | Lynchburg | 51680 | 11942 | 195 | 0 | 37.40021399 | -79.19888138 | 2021-11-24 04:22:14 | Lynchburg, Virginia, US | |
3492691 | 3492691 | 2021-10-26 | US | Arkansas | Pope | 5115 | 11942 | 156 | 0 | 35.44871474 | -93.03212219 | 2021-10-27 04:22:32 | Pope, Arkansas, US | |
2959644 | 2959644 | 2021-10-08 | Saint Lucia | 11942 | 222 | 0 | 13.9094 | -60.9789 | 2021-10-09 04:21:34 | Saint Lucia | ||||
1376871 | 1376871 | 2021-09-15 | US | North Carolina | Wilson | 37195 | 11942 | 201 | 0 | 35.70625477 | -77.917978 | 2021-09-16 04:22:19 | Wilson, North Carolina, US | |
1388572 | 1388572 | 2021-09-13 | US | Tennessee | Hamblen | 47063 | 11942 | 183 | 0 | 36.21990035 | -83.26586179 | 2021-09-14 04:21:41 | Hamblen, Tennessee, US | |
299244 | 299244 | 2021-07-15 | US | Texas | Tom Green | 48451 | 11942 | 275 | 0 | 31.40464436 | -100.462443 | 2021-07-16 04:21:22 | Tom Green, Texas, US | |
1164978 | 1164978 | 2021-07-04 | China | Hong Kong | 11942 | 211 | 11637 | 94 | 22.3 | 114.2 | 2021-07-05 04:21:28 | Hong Kong, China | ||
2074354 | 2074354 | 2021-07-02 | US | Ohio | Allen | 39003 | 11942 | 244 | 0 | 40.77285242 | -84.10802343 | 2021-07-03 04:21:37 | Allen, Ohio, US | |
525176 | 525176 | 2021-06-09 | US | North Carolina | Harnett | 37085 | 11942 | 180 | 0 | 35.36731853 | -78.87243571 | 2021-06-10 04:23:17 | Harnett, North Carolina, US | |
1552766 | 1552766 | 2021-05-08 | US | Georgia | Floyd | 13115 | 11942 | 226 | 0 | 34.26268279 | -85.21577392 | 2021-05-09 04:20:35 | Floyd, Georgia, US | |
984510 | 984510 | 2021-04-17 | US | Maine | York | 23031 | 11942 | 128 | 0 | 43.47808377 | -70.71052375 | 2021-04-18 04:20:41 | York, Maine, US | |
3369985 | 3369985 | 2021-03-21 | US | Connecticut | Litchfield | 9005 | 11942 | 284 | 0 | 41.7937534 | -73.2451475 | 2021-03-22 05:25:43 | Litchfield, Connecticut, US | |
1745195 | 1745195 | 2021-03-20 | US | Connecticut | Litchfield | 9005 | 11942 | 284 | 0 | 41.7937534 | -73.2451475 | 2021-03-21 05:25:44 | Litchfield, Connecticut, US | |
3421575 | 3421575 | 2021-03-19 | US | Connecticut | Litchfield | 9005 | 11942 | 284 | 0 | 41.7937534 | -73.2451475 | 2021-03-20 05:25:46 | Litchfield, Connecticut, US | |
1461531 | 1461531 | 2021-01-31 | US | Minnesota | Wright | 27171 | 11942 | 108 | 0 | 11834 | 45.17297924 | -93.96234781 | 2021-02-01 05:22:53 | Wright, Minnesota, US |
2224441 | 2224441 | 2020-12-26 | US | Idaho | Kootenai | 16055 | 11942 | 108 | 0 | 11834 | 47.67282258 | -116.7020872 | 2020-12-27 05:22:55 | Kootenai, Idaho, US |
75290 | 75290 | 2020-12-03 | Russia | Kalmykia Republic | 11942 | 151 | 9932 | 1859 | 46.2313018 | 45.3275745 | 2020-12-04 05:27:27 | Kalmykia Republic, Russia | ||
1181112 | 1181112 | 2020-10-22 | Ukraine | Khmelnytskyi Oblast | 11942 | 191 | 5218 | 6533 | 49.423 | 26.9871 | 2020-10-23 04:24:46 | Khmelnytskyi Oblast, Ukraine | ||
1523036 | 1523036 | 2020-08-28 | Colombia | Magdalena | 11942 | 654 | 9066 | 2222 | 10.4113 | -74.4057 | 2020-08-29 04:28:19 | Magdalena, Colombia | ||
1920796 | 1920796 | 2020-08-10 | North Macedonia | 11942 | 528 | 8087 | 3327 | 41.6086 | 21.7453 | 2020-08-11 04:35:08 | North Macedonia | |||
98127 | 98127 | 2020-08-04 | Chile | Biobio | 11942 | 125 | 10368 | 1449 | -37.4464 | -72.1416 | 2020-08-05 04:34:43 | Biobio, Chile | ||
2631620 | 2631620 | 2020-06-29 | US | Michigan | Oakland | 26125 | 11942 | 1085 | 0 | 10857 | 42.66090111 | -83.38595416 | 2020-06-30 04:33:48 | Oakland, Michigan, US |
268234 | 268234 | 2020-05-21 | Brazil | Bahia | 11942 | 376 | 0 | 11565 | -12.5797 | -41.7007 | 2020-05-22 02:36:51 | Bahia, Brazil | ||
43242 | 43242 | 2020-04-13 | Israel | 11942 | 118 | 2228 | 9596 | 31.046051000000002 | 34.851612 | 2020-04-13 23:07:34 | Israel |
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]);