johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
32 rows where confirmed = 14527 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1052964 | 1052964 | 2022-11-06 | US | Texas | Hood | 48221 | 14527 | 286 | 0 | 32.42990927 | -97.83242024 | 2022-11-07 04:21:26 | Hood, Texas, US | |
620988 | 620988 | 2022-11-05 | US | Texas | Hood | 48221 | 14527 | 286 | 0 | 32.42990927 | -97.83242024 | 2022-11-06 04:21:24 | Hood, Texas, US | |
1025492 | 1025492 | 2022-11-04 | US | Texas | Hood | 48221 | 14527 | 286 | 0 | 32.42990927 | -97.83242024 | 2022-11-05 04:21:52 | Hood, Texas, US | |
1370606 | 1370606 | 2022-09-21 | Monaco | 14527 | 63 | 0 | 43.7333 | 7.4167 | 2022-09-22 04:22:56 | Monaco | ||||
2829914 | 2829914 | 2022-08-25 | US | Indiana | Henry | 18065 | 14527 | 239 | 0 | 39.93029017 | -85.39625719 | 2022-08-26 04:21:02 | Henry, Indiana, US | |
2324447 | 2324447 | 2022-08-24 | US | Indiana | Henry | 18065 | 14527 | 239 | 0 | 39.93029017 | -85.39625719 | 2022-08-25 04:21:13 | Henry, Indiana, US | |
1407372 | 1407372 | 2022-08-02 | US | North Carolina | Haywood | 37087 | 14527 | 229 | 0 | 35.55269063 | -82.98196486 | 2022-08-03 04:20:59 | Haywood, North Carolina, US | |
3619410 | 3619410 | 2022-08-01 | US | North Carolina | Haywood | 37087 | 14527 | 229 | 0 | 35.55269063 | -82.98196486 | 2022-08-02 04:20:53 | Haywood, North Carolina, US | |
3873890 | 3873890 | 2022-07-31 | US | North Carolina | Haywood | 37087 | 14527 | 229 | 0 | 35.55269063 | -82.98196486 | 2022-08-01 04:21:03 | Haywood, North Carolina, US | |
676644 | 676644 | 2022-07-30 | US | North Carolina | Haywood | 37087 | 14527 | 229 | 0 | 35.55269063 | -82.98196486 | 2022-07-31 04:21:02 | Haywood, North Carolina, US | |
1785843 | 1785843 | 2022-07-29 | US | North Carolina | Haywood | 37087 | 14527 | 229 | 0 | 35.55269063 | -82.98196486 | 2022-07-30 04:20:42 | Haywood, North Carolina, US | |
1068206 | 1068206 | 2022-07-28 | US | North Carolina | Haywood | 37087 | 14527 | 229 | 0 | 35.55269063 | -82.98196486 | 2022-07-29 04:20:45 | Haywood, North Carolina, US | |
2337725 | 2337725 | 2022-07-27 | US | North Carolina | Haywood | 37087 | 14527 | 229 | 0 | 35.55269063 | -82.98196486 | 2022-07-28 04:20:56 | Haywood, North Carolina, US | |
1908172 | 1908172 | 2022-03-22 | US | Tennessee | Monroe | 47123 | 14527 | 235 | 0 | 35.44550387 | -84.24902965 | 2022-03-23 04:20:48 | Monroe, Tennessee, US | |
27367 | 27367 | 2022-03-20 | US | Tennessee | Loudon | 47105 | 14527 | 188 | 0 | 35.73939663 | -84.31145275 | 2022-03-21 04:20:50 | Loudon, Tennessee, US | |
3229109 | 3229109 | 2022-01-19 | US | Pennsylvania | Carbon | 42025 | 14527 | 248 | 0 | 40.91545395 | -75.7068525 | 2022-01-20 04:21:07 | Carbon, Pennsylvania, US | |
3226333 | 3226333 | 2022-01-19 | France | New Caledonia | 14527 | 282 | 0 | -20.904304999999997 | 165.618042 | 2022-01-20 04:21:07 | New Caledonia, France | |||
3615880 | 3615880 | 2022-01-12 | US | South Carolina | Darlington | 45031 | 14527 | 249 | 0 | 34.33358335 | -79.96027485 | 2022-01-13 08:00:09 | Darlington, South Carolina, US | |
2167381 | 2167381 | 2022-01-01 | Colombia | Arauca | 14527 | 485 | 0 | 7.0762 | -70.7105 | 2022-01-02 04:20:52 | Arauca, Colombia | |||
1261453 | 1261453 | 2021-12-18 | US | Pennsylvania | Crawford | 42039 | 14527 | 245 | 0 | 41.68447709 | -80.10760592 | 2021-12-19 04:21:11 | Crawford, Pennsylvania, US | |
3498591 | 3498591 | 2021-12-15 | US | North Dakota | Grand Forks | 38035 | 14527 | 101 | 0 | 47.92093639 | -97.45450447 | 2021-12-16 04:22:11 | Grand Forks, North Dakota, US | |
3072337 | 3072337 | 2021-11-23 | US | North Carolina | Craven | 37049 | 14527 | 159 | 0 | 35.11833364 | -77.08398081 | 2021-11-24 04:22:14 | Craven, North Carolina, US | |
3476381 | 3476381 | 2021-07-22 | Mali | 14527 | 530 | 12868 | 1129 | 17.570692 | -3.996166000000001 | 2021-07-23 04:21:29 | Mali | |||
2674147 | 2674147 | 2021-07-18 | Tajikistan | 14527 | 112 | 13685 | 730 | 38.861 | 71.2761 | 2021-07-19 04:21:24 | Tajikistan | |||
2885984 | 2885984 | 2021-06-20 | US | Michigan | Calhoun | 26025 | 14527 | 314 | 0 | 42.24633834 | -85.00493569 | 2021-06-21 04:21:41 | Calhoun, Michigan, US | |
109067 | 109067 | 2021-06-19 | US | Michigan | Calhoun | 26025 | 14527 | 314 | 0 | 42.24633834 | -85.00493569 | 2021-06-20 04:21:48 | Calhoun, Michigan, US | |
1127210 | 1127210 | 2021-06-18 | US | Michigan | Calhoun | 26025 | 14527 | 314 | 0 | 42.24633834 | -85.00493569 | 2021-06-19 04:22:33 | Calhoun, Michigan, US | |
1425307 | 1425307 | 2021-05-09 | Russia | Kamchatka Krai | 14527 | 230 | 13866 | 431 | 57.1914882 | 160.03838190000005 | 2021-05-10 04:20:38 | Kamchatka Krai, Russia | ||
1034618 | 1034618 | 2020-12-15 | Russia | Smolensk Oblast | 14527 | 299 | 10637 | 3591 | 55.03434960000001 | 33.0192065 | 2020-12-16 05:28:04 | Smolensk Oblast, Russia | ||
738397 | 738397 | 2020-12-02 | Mexico | Quintana Roo | 14527 | 1949 | 0 | 12578 | 19.1817 | -88.4791 | 2020-12-03 05:28:22 | Quintana Roo, Mexico | ||
3170148 | 3170148 | 2020-11-16 | US | Arkansas | Pulaski | 5119 | 14527 | 237 | 0 | 14290 | 34.77054088 | -92.31355101 | 2020-11-17 05:25:54 | Pulaski, Arkansas, US |
2863906 | 2863906 | 2020-06-10 | Pakistan | Khyber Pakhtunkhwa | 14527 | 610 | 3631 | 10286 | 34.485332 | 72.09169 | 2020-06-11 03:33:41 | Khyber Pakhtunkhwa, Pakistan |
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]);