johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
45 rows where confirmed = 11300 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2138898 | 2138898 | 2022-12-01 | US | Puerto Rico | Corozal | 72047 | 11300 | 0 | 0 | 18.304264 | -66.327738 | 2022-12-02 04:21:07 | Corozal, Puerto Rico, US | |
1967314 | 1967314 | 2022-11-30 | US | Puerto Rico | Corozal | 72047 | 11300 | 0 | 0 | 18.304264 | -66.327738 | 2022-12-01 04:21:03 | Corozal, Puerto Rico, US | |
856372 | 856372 | 2022-09-30 | US | Puerto Rico | Juncos | 72077 | 11300 | 0 | 0 | 18.223793 | -65.909109 | 2022-10-01 04:23:01 | Juncos, Puerto Rico, US | |
3909953 | 3909953 | 2022-08-11 | US | Missouri | Phelps | 29161 | 11300 | 251 | 0 | 37.87736118 | -91.79351727 | 2022-08-12 04:20:54 | Phelps, Missouri, US | |
1348270 | 1348270 | 2022-08-10 | US | Missouri | Phelps | 29161 | 11300 | 251 | 0 | 37.87736118 | -91.79351727 | 2022-08-11 04:20:49 | Phelps, Missouri, US | |
1088025 | 1088025 | 2022-08-09 | US | Missouri | Phelps | 29161 | 11300 | 251 | 0 | 37.87736118 | -91.79351727 | 2022-08-10 04:20:57 | Phelps, Missouri, US | |
3545440 | 3545440 | 2022-08-08 | US | Missouri | Phelps | 29161 | 11300 | 251 | 0 | 37.87736118 | -91.79351727 | 2022-08-09 04:20:34 | Phelps, Missouri, US | |
1071843 | 1071843 | 2022-08-07 | US | Missouri | Phelps | 29161 | 11300 | 251 | 0 | 37.87736118 | -91.79351727 | 2022-08-08 04:21:08 | Phelps, Missouri, US | |
1942431 | 1942431 | 2022-08-06 | US | Missouri | Phelps | 29161 | 11300 | 251 | 0 | 37.87736118 | -91.79351727 | 2022-08-07 04:20:54 | Phelps, Missouri, US | |
882230 | 882230 | 2022-08-05 | US | Missouri | Phelps | 29161 | 11300 | 251 | 0 | 37.87736118 | -91.79351727 | 2022-08-06 04:20:56 | Phelps, Missouri, US | |
674975 | 674975 | 2022-07-30 | US | Colorado | Summit | 8117 | 11300 | 14 | 0 | 39.63803232 | -106.1150762 | 2022-07-31 04:21:02 | Summit, Colorado, US | |
2236386 | 2236386 | 2022-06-12 | US | Illinois | Jefferson | 17081 | 11300 | 175 | 0 | 38.29980057 | -88.9240025 | 2022-06-13 04:21:14 | Jefferson, Illinois, US | |
3142584 | 3142584 | 2022-06-11 | US | Illinois | Jefferson | 17081 | 11300 | 175 | 0 | 38.29980057 | -88.9240025 | 2022-06-12 04:20:53 | Jefferson, Illinois, US | |
1945500 | 1945500 | 2022-06-10 | US | Illinois | Jefferson | 17081 | 11300 | 175 | 0 | 38.29980057 | -88.9240025 | 2022-06-11 04:21:01 | Jefferson, Illinois, US | |
224227 | 224227 | 2022-05-09 | US | New York | Cortland | 36023 | 11300 | 120 | 0 | 42.59509207 | -76.07048931 | 2022-05-10 04:20:50 | Cortland, New York, US | |
2843546 | 2843546 | 2022-04-30 | US | Pennsylvania | Venango | 42121 | 11300 | 238 | 0 | 41.40323442 | -79.75845449 | 2022-05-01 04:20:57 | Venango, Pennsylvania, US | |
1541579 | 1541579 | 2022-03-31 | US | Michigan | Branch | 26023 | 11300 | 181 | 0 | 41.91600556 | -85.05929476 | 2022-04-01 04:20:28 | Branch, Michigan, US | |
2479592 | 2479592 | 2022-03-30 | US | Michigan | Branch | 26023 | 11300 | 181 | 0 | 41.91600556 | -85.05929476 | 2022-03-31 04:20:56 | Branch, Michigan, US | |
3915561 | 3915561 | 2022-02-20 | US | Wisconsin | Douglas | 55031 | 11300 | 72 | 0 | 46.43222285 | -91.91595768 | 2022-02-21 04:21:05 | Douglas, Wisconsin, US | |
3879119 | 3879119 | 2022-02-19 | US | Wisconsin | Douglas | 55031 | 11300 | 72 | 0 | 46.43222285 | -91.91595768 | 2022-02-20 04:21:00 | Douglas, Wisconsin, US | |
3859375 | 3859375 | 2022-02-18 | US | Wisconsin | Douglas | 55031 | 11300 | 72 | 0 | 46.43222285 | -91.91595768 | 2022-02-19 04:21:11 | Douglas, Wisconsin, US | |
3073906 | 3073906 | 2022-02-09 | Denmark | Greenland | 11300 | 7 | 0 | 71.7069 | -42.6043 | 2022-02-10 04:21:14 | Greenland, Denmark | |||
557828 | 557828 | 2022-01-16 | US | Texas | Caldwell | 48055 | 11300 | 159 | 0 | 29.83668859 | -97.61814775 | 2022-01-17 04:21:08 | Caldwell, Texas, US | |
732752 | 732752 | 2021-12-27 | US | New York | Cattaraugus | 36009 | 11300 | 186 | 0 | 42.24778241 | -78.67923096 | 2021-12-28 04:21:47 | Cattaraugus, New York, US | |
685338 | 685338 | 2021-10-24 | US | Tennessee | Tipton | 47167 | 11300 | 128 | 0 | 35.501942 | -89.73694895 | 2021-10-25 04:22:31 | Tipton, Tennessee, US | |
600177 | 600177 | 2021-10-19 | US | Ohio | Pickaway | 39129 | 11300 | 149 | 0 | 39.64170392 | -83.0243386 | 2021-10-20 04:21:00 | Pickaway, Ohio, US | |
491860 | 491860 | 2021-10-14 | Russia | Magadan Oblast | 11300 | 268 | 0 | 62.48858785 | 153.9903764 | 2021-10-15 04:21:26 | Magadan Oblast, Russia | |||
636752 | 636752 | 2021-10-13 | US | South Carolina | Laurens | 45059 | 11300 | 209 | 0 | 34.48244419 | -82.00490796 | 2021-10-14 04:21:29 | Laurens, South Carolina, US | |
1337102 | 1337102 | 2021-09-28 | US | South Carolina | Kershaw | 45055 | 11300 | 183 | 0 | 34.33988254 | -80.58763164 | 2021-09-29 04:21:45 | Kershaw, South Carolina, US | |
3894187 | 3894187 | 2021-08-29 | US | New York | Putnam | 36079 | 11300 | 94 | 0 | 41.42630093 | -73.74965532 | 2021-08-30 04:21:23 | Putnam, New York, US | |
3126685 | 3126685 | 2021-06-28 | US | Iowa | Dallas | 19049 | 11300 | 99 | 0 | 41.68560356 | -94.04127625 | 2021-06-29 04:21:28 | Dallas, Iowa, US | |
648453 | 648453 | 2021-05-05 | US | Ohio | Richland | 39139 | 11300 | 205 | 0 | 40.77180308 | -82.53799609999999 | 2021-05-06 04:20:38 | Richland, Ohio, US | |
2761679 | 2761679 | 2021-05-03 | US | Georgia | Carroll | 13045 | 11300 | 238 | 0 | 33.58138199 | -85.07976677 | 2021-05-04 04:20:34 | Carroll, Georgia, US | |
1001638 | 1001638 | 2021-03-01 | US | Texas | Rockwall | 48397 | 11300 | 125 | 0 | 10420 | 32.89779518 | -96.40771592 | 2021-03-02 05:23:30 | Rockwall, Texas, US |
2370696 | 2370696 | 2021-02-28 | US | Texas | Rockwall | 48397 | 11300 | 124 | 0 | 10421 | 32.89779518 | -96.40771592 | 2021-03-01 05:23:01 | Rockwall, Texas, US |
3069198 | 3069198 | 2021-02-27 | US | Texas | Rockwall | 48397 | 11300 | 124 | 0 | 10421 | 32.89779518 | -96.40771592 | 2021-02-28 05:22:20 | Rockwall, Texas, US |
3102618 | 3102618 | 2021-01-16 | US | Iowa | Dubuque | 19061 | 11300 | 149 | 0 | 11151 | 42.46815349 | -90.88181925 | 2021-01-17 05:22:17 | Dubuque, Iowa, US |
3901000 | 3901000 | 2021-01-09 | US | Illinois | Tazewell | 17179 | 11300 | 200 | 0 | 11100 | 40.50716185 | -89.51404662 | 2021-01-10 05:22:12 | Tazewell, Illinois, US |
2120439 | 2120439 | 2020-12-20 | US | Florida | St. Johns | 12109 | 11300 | 108 | 0 | 11192 | 29.90096506 | -81.43589967 | 2020-12-21 05:27:58 | St. Johns, Florida, US |
3304809 | 3304809 | 2020-11-02 | US | Colorado | Jefferson | 8059 | 11300 | 359 | 0 | 9460 | 39.58635604 | -105.2517692 | 2020-11-03 06:00:16 | Jefferson, Colorado, US |
8625 | 8625 | 2020-10-25 | Spain | La Rioja | 11300 | 442 | 3107 | 7751 | 42.2871 | -2.5396 | 2020-10-26 04:25:02 | La Rioja, Spain | ||
3651862 | 3651862 | 2020-10-24 | Spain | La Rioja | 11300 | 442 | 3107 | 7751 | 42.2871 | -2.5396 | 2020-10-25 04:24:36 | La Rioja, Spain | ||
1054117 | 1054117 | 2020-10-23 | Spain | La Rioja | 11300 | 442 | 3107 | 7751 | 42.2871 | -2.5396 | 2020-10-24 04:24:46 | La Rioja, Spain | ||
573890 | 573890 | 2020-06-06 | Spain | C. Valenciana | 11300 | 1332 | 9970 | 0 | 39.484 | -0.7533 | 2020-06-07 03:53:30 | C. Valenciana, Spain | ||
2712568 | 2712568 | 2020-05-28 | Serbia | 11300 | 241 | 6438 | 4621 | 44.0165 | 21.0059 | 2020-05-29 02:32:50 | Serbia |
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]);