johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
45 rows where confirmed = 12559 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- US 37
- Saint Lucia 2
- Burkina Faso 1
- Haiti 1
- Netherlands 1
- Russia 1
- Senegal 1
- Sweden 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2771742 | 2771742 | 2022-09-26 | US | Puerto Rico | Rio Grande | 72119 | 12559 | 0 | 0 | 18.346329 | -65.813742 | 2022-09-27 04:23:01 | Rio Grande, Puerto Rico, US | |
1372967 | 1372967 | 2022-09-21 | US | Ohio | Guernsey | 39059 | 12559 | 159 | 0 | 40.05026529 | -81.49248905 | 2022-09-22 04:22:56 | Guernsey, Ohio, US | |
2019197 | 2019197 | 2022-09-20 | US | Ohio | Guernsey | 39059 | 12559 | 159 | 0 | 40.05026529 | -81.49248905 | 2022-09-21 04:23:22 | Guernsey, Ohio, US | |
3573070 | 3573070 | 2022-09-19 | US | Ohio | Guernsey | 39059 | 12559 | 159 | 0 | 40.05026529 | -81.49248905 | 2022-09-20 04:22:48 | Guernsey, Ohio, US | |
421809 | 421809 | 2022-09-18 | US | Ohio | Guernsey | 39059 | 12559 | 159 | 0 | 40.05026529 | -81.49248905 | 2022-09-19 04:21:49 | Guernsey, Ohio, US | |
3375833 | 3375833 | 2022-09-17 | US | Ohio | Guernsey | 39059 | 12559 | 159 | 0 | 40.05026529 | -81.49248905 | 2022-09-18 04:22:50 | Guernsey, Ohio, US | |
2357941 | 2357941 | 2022-09-16 | US | Ohio | Guernsey | 39059 | 12559 | 159 | 0 | 40.05026529 | -81.49248905 | 2022-09-17 04:20:19 | Guernsey, Ohio, US | |
3989098 | 3989098 | 2022-09-15 | US | Ohio | Guernsey | 39059 | 12559 | 159 | 0 | 40.05026529 | -81.49248905 | 2022-09-16 04:21:19 | Guernsey, Ohio, US | |
3746839 | 3746839 | 2022-09-07 | US | Minnesota | Itasca | 27061 | 12559 | 155 | 0 | 47.51009045 | -93.63092229 | 2022-09-08 04:21:02 | Itasca, Minnesota, US | |
116479 | 116479 | 2022-09-06 | US | Minnesota | Itasca | 27061 | 12559 | 155 | 0 | 47.51009045 | -93.63092229 | 2022-09-07 04:20:59 | Itasca, Minnesota, US | |
2635451 | 2635451 | 2022-09-05 | US | Minnesota | Itasca | 27061 | 12559 | 155 | 0 | 47.51009045 | -93.63092229 | 2022-09-06 04:21:02 | Itasca, Minnesota, US | |
2989015 | 2989015 | 2022-09-04 | US | Minnesota | Itasca | 27061 | 12559 | 155 | 0 | 47.51009045 | -93.63092229 | 2022-09-05 04:21:01 | Itasca, Minnesota, US | |
2714700 | 2714700 | 2022-09-03 | US | Minnesota | Itasca | 27061 | 12559 | 155 | 0 | 47.51009045 | -93.63092229 | 2022-09-04 04:21:22 | Itasca, Minnesota, US | |
1395405 | 1395405 | 2022-09-02 | US | Minnesota | Itasca | 27061 | 12559 | 155 | 0 | 47.51009045 | -93.63092229 | 2022-09-03 04:21:04 | Itasca, Minnesota, US | |
3549234 | 3549234 | 2022-09-01 | US | Minnesota | Itasca | 27061 | 12559 | 155 | 0 | 47.51009045 | -93.63092229 | 2022-09-02 04:21:07 | Itasca, Minnesota, US | |
3911509 | 3911509 | 2022-08-11 | US | West Virginia | Ohio | 54069 | 12559 | 184 | 0 | 40.0955451 | -80.62203992 | 2022-08-12 04:20:54 | Ohio, West Virginia, US | |
1073223 | 1073223 | 2022-08-07 | US | Virginia | Danville | 51590 | 12559 | 285 | 0 | 36.58022376 | -79.40395668 | 2022-08-08 04:21:08 | Danville, Virginia, US | |
1943811 | 1943811 | 2022-08-06 | US | Virginia | Danville | 51590 | 12559 | 285 | 0 | 36.58022376 | -79.40395668 | 2022-08-07 04:20:54 | Danville, Virginia, US | |
883610 | 883610 | 2022-08-05 | US | Virginia | Danville | 51590 | 12559 | 285 | 0 | 36.58022376 | -79.40395668 | 2022-08-06 04:20:56 | Danville, Virginia, US | |
2148197 | 2148197 | 2022-06-27 | US | California | Lake | 6033 | 12559 | 140 | 0 | 39.10124298 | -122.7536244 | 2022-06-28 04:20:58 | Lake, California, US | |
476960 | 476960 | 2022-06-26 | US | Louisiana | Lincoln | 22061 | 12559 | 144 | 0 | 32.6003154 | -92.6659741 | 2022-06-27 04:21:00 | Lincoln, Louisiana, US | |
940335 | 940335 | 2022-06-25 | US | Louisiana | Lincoln | 22061 | 12559 | 144 | 0 | 32.6003154 | -92.6659741 | 2022-06-26 04:21:02 | Lincoln, Louisiana, US | |
3348155 | 3348155 | 2022-06-24 | US | Louisiana | Lincoln | 22061 | 12559 | 144 | 0 | 32.6003154 | -92.6659741 | 2022-06-25 04:20:57 | Lincoln, Louisiana, US | |
1722037 | 1722037 | 2022-03-25 | US | Maine | Aroostook | 23003 | 12559 | 149 | 0 | 46.65926321 | -68.59841248 | 2022-03-26 04:20:23 | Aroostook, Maine, US | |
3721461 | 3721461 | 2022-02-21 | US | Utah | TriCounty | 12559 | 92 | 0 | 40.12491499 | -109.5174415 | 2022-02-22 04:21:01 | TriCounty, Utah, US | ||
3915295 | 3915295 | 2022-02-20 | US | Utah | TriCounty | 12559 | 92 | 0 | 40.12491499 | -109.5174415 | 2022-02-21 04:21:05 | TriCounty, Utah, US | ||
3878853 | 3878853 | 2022-02-19 | US | Utah | TriCounty | 12559 | 92 | 0 | 40.12491499 | -109.5174415 | 2022-02-20 04:21:00 | TriCounty, Utah, US | ||
3859109 | 3859109 | 2022-02-18 | US | Utah | TriCounty | 12559 | 92 | 0 | 40.12491499 | -109.5174415 | 2022-02-19 04:21:11 | TriCounty, Utah, US | ||
3063973 | 3063973 | 2022-01-29 | US | Missouri | Taney | 29213 | 12559 | 187 | 0 | 36.65465345 | -93.04075153 | 2022-01-30 04:21:26 | Taney, Missouri, US | |
1319633 | 1319633 | 2022-01-26 | US | Kentucky | Hopkins | 21107 | 12559 | 226 | 0 | 37.30939025 | -87.54670406 | 2022-01-27 04:21:19 | Hopkins, Kentucky, US | |
1031169 | 1031169 | 2021-12-06 | US | Georgia | Dougherty | 13095 | 12559 | 426 | 0 | 31.53328528 | -84.21722377 | 2021-12-07 04:22:34 | Dougherty, Georgia, US | |
164201 | 164201 | 2021-11-19 | US | New Jersey | Hunterdon | 34019 | 12559 | 193 | 0 | 40.56335249 | -74.91284156 | 2021-11-20 04:22:17 | Hunterdon, New Jersey, US | |
288266 | 288266 | 2021-10-31 | Saint Lucia | 12559 | 255 | 0 | 13.9094 | -60.9789 | 2021-11-01 04:22:01 | Saint Lucia | ||||
2721272 | 2721272 | 2021-10-30 | Saint Lucia | 12559 | 255 | 0 | 13.9094 | -60.9789 | 2021-10-31 04:22:08 | Saint Lucia | ||||
2371826 | 2371826 | 2021-07-20 | Sweden | Jamtland Harjedalen | 12559 | 121 | 0 | 12438 | 63.1712 | 14.9592 | 2021-07-21 04:21:40 | Jamtland Harjedalen, Sweden | ||
957363 | 957363 | 2021-04-25 | US | Ohio | Portage | 39133 | 12559 | 209 | 0 | 41.16793482 | -81.19735782 | 2021-04-26 04:21:04 | Portage, Ohio, US | |
1203564 | 1203564 | 2021-03-22 | Burkina Faso | 12559 | 145 | 12177 | 237 | 12.2383 | -1.5616 | 2021-03-23 05:26:18 | Burkina Faso | |||
1090006 | 1090006 | 2021-03-03 | Haiti | 12559 | 250 | 9828 | 2453 | 18.9712 | -72.2852 | 2021-03-04 05:24:24 | Haiti | |||
2640610 | 2640610 | 2021-02-11 | US | South Dakota | Pennington | 46103 | 12559 | 181 | 0 | 12378 | 44.0025835 | -102.8240777 | 2021-02-12 05:23:29 | Pennington, South Dakota, US |
2469573 | 2469573 | 2021-01-22 | US | Puerto Rico | San Juan | 72127 | 12559 | 0 | 0 | 12559 | 18.386933 | -66.061128 | 2021-01-23 05:22:03 | San Juan, Puerto Rico, US |
3778022 | 3778022 | 2020-12-27 | Netherlands | Drenthe | 12559 | 134 | 0 | 12410 | 52.862485 | 6.618435000000002 | 2020-12-28 05:22:06 | Drenthe, Netherlands | ||
3782131 | 3782131 | 2020-10-13 | Russia | Omsk Oblast | 12559 | 346 | 10733 | 1480 | 56.09352629999999 | 73.5099936 | 2020-10-14 04:24:05 | Omsk Oblast, Russia | ||
1124040 | 1124040 | 2020-09-17 | US | Ohio | Hamilton | 39061 | 12559 | 274 | 0 | 12285 | 39.19673558 | -84.54502924 | 2020-09-18 05:05:00 | Hamilton, Ohio, US |
3565146 | 3565146 | 2020-08-25 | US | Oklahoma | Tulsa | 40143 | 12559 | 127 | 0 | 12432 | 36.11939621 | -95.94013939 | 2020-08-26 04:28:11 | Tulsa, Oklahoma, US |
3484574 | 3484574 | 2020-08-20 | Senegal | 12559 | 261 | 8050 | 4248 | 14.4974 | -14.4524 | 2020-08-21 04:27:41 | Senegal |
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]);