johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
60 rows where confirmed = 11483 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3380790 | 3380790 | 2022-12-08 | US | Virginia | Smyth | 51173 | 11483 | 195 | 0 | 36.84455636 | -81.53344948 | 2022-12-09 04:21:05 | Smyth, Virginia, US | |
3039366 | 3039366 | 2022-10-27 | US | Illinois | Morgan | 17137 | 11483 | 134 | 0 | 39.71654544 | -90.20255104 | 2022-10-28 04:22:31 | Morgan, Illinois, US | |
131768 | 131768 | 2022-10-04 | US | Illinois | Logan | 17107 | 11483 | 94 | 0 | 40.12581572 | -89.36638784 | 2022-10-05 04:23:06 | Logan, Illinois, US | |
1684122 | 1684122 | 2022-08-29 | US | Wyoming | Teton | 56039 | 11483 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-08-30 04:21:03 | Teton, Wyoming, US | |
1880606 | 1880606 | 2022-08-28 | US | Wyoming | Teton | 56039 | 11483 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-08-29 04:21:06 | Teton, Wyoming, US | |
2099733 | 2099733 | 2022-08-27 | US | Wyoming | Teton | 56039 | 11483 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-08-28 04:21:02 | Teton, Wyoming, US | |
1535548 | 1535548 | 2022-08-26 | US | Wyoming | Teton | 56039 | 11483 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-08-27 04:20:57 | Teton, Wyoming, US | |
2832435 | 2832435 | 2022-08-25 | US | Wyoming | Teton | 56039 | 11483 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-08-26 04:21:02 | Teton, Wyoming, US | |
2326968 | 2326968 | 2022-08-24 | US | Wyoming | Teton | 56039 | 11483 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-08-25 04:21:13 | Teton, Wyoming, US | |
1254377 | 1254377 | 2022-08-23 | US | Wyoming | Teton | 56039 | 11483 | 16 | 0 | 43.93522482 | -110.5890801 | 2022-08-24 04:20:46 | Teton, Wyoming, US | |
1347362 | 1347362 | 2022-08-10 | US | Illinois | Randolph | 17157 | 11483 | 131 | 0 | 38.05095369 | -89.82512254 | 2022-08-11 04:20:49 | Randolph, Illinois, US | |
593586 | 593586 | 2022-07-01 | India | Dadra and Nagar Haveli and Daman and Diu | 11483 | 4 | 0 | 20.194742 | 73.080901 | 2022-07-02 04:21:16 | Dadra and Nagar Haveli and Daman and Diu, India | |||
230848 | 230848 | 2022-05-31 | US | Michigan | Branch | 26023 | 11483 | 186 | 0 | 41.91600556 | -85.05929476 | 2022-06-01 04:20:55 | Branch, Michigan, US | |
3187613 | 3187613 | 2022-05-30 | US | Michigan | Branch | 26023 | 11483 | 186 | 0 | 41.91600556 | -85.05929476 | 2022-05-31 04:20:51 | Branch, Michigan, US | |
3199762 | 3199762 | 2022-05-29 | US | Michigan | Branch | 26023 | 11483 | 186 | 0 | 41.91600556 | -85.05929476 | 2022-05-30 04:20:50 | Branch, Michigan, US | |
2726640 | 2726640 | 2022-05-28 | US | Michigan | Branch | 26023 | 11483 | 186 | 0 | 41.91600556 | -85.05929476 | 2022-05-29 04:20:53 | Branch, Michigan, US | |
1315821 | 1315821 | 2022-05-27 | US | Michigan | Branch | 26023 | 11483 | 186 | 0 | 41.91600556 | -85.05929476 | 2022-05-28 04:21:07 | Branch, Michigan, US | |
1851613 | 1851613 | 2022-05-26 | US | Michigan | Branch | 26023 | 11483 | 186 | 0 | 41.91600556 | -85.05929476 | 2022-05-27 04:20:56 | Branch, Michigan, US | |
2049489 | 2049489 | 2022-05-25 | US | Michigan | Branch | 26023 | 11483 | 186 | 0 | 41.91600556 | -85.05929476 | 2022-05-26 04:20:50 | Branch, Michigan, US | |
623500 | 623500 | 2022-05-22 | US | Michigan | Branch | 26023 | 11483 | 186 | 0 | 41.91600556 | -85.05929476 | 2022-05-26 04:20:50 | Branch, Michigan, US | |
3870872 | 3870872 | 2022-04-05 | US | Virginia | Culpeper | 51047 | 11483 | 149 | 0 | 38.48199985 | -77.95630870000002 | 2022-04-06 04:20:49 | Culpeper, Virginia, US | |
3733560 | 3733560 | 2022-04-03 | US | Virginia | Culpeper | 51047 | 11483 | 148 | 0 | 38.48199985 | -77.95630870000002 | 2022-04-04 04:20:51 | Culpeper, Virginia, US | |
502995 | 502995 | 2022-04-02 | US | Virginia | Culpeper | 51047 | 11483 | 148 | 0 | 38.48199985 | -77.95630870000002 | 2022-04-03 04:20:48 | Culpeper, Virginia, US | |
3353980 | 3353980 | 2022-04-01 | US | Virginia | Culpeper | 51047 | 11483 | 148 | 0 | 38.48199985 | -77.95630870000002 | 2022-04-02 04:20:47 | Culpeper, Virginia, US | |
161339 | 161339 | 2022-03-29 | US | Virginia | Culpeper | 51047 | 11483 | 148 | 0 | 38.48199985 | -77.95630870000002 | 2022-03-30 04:20:45 | Culpeper, Virginia, US | |
160688 | 160688 | 2022-03-29 | US | Pennsylvania | Huntingdon | 42061 | 11483 | 242 | 0 | 40.42162652 | -77.97673273 | 2022-03-30 04:20:45 | Huntingdon, Pennsylvania, US | |
3025848 | 3025848 | 2022-03-23 | US | Wisconsin | Pierce | 55093 | 11483 | 72 | 0 | 44.71850291 | -92.4224416 | 2022-03-24 04:20:43 | Pierce, Wisconsin, US | |
27756 | 27756 | 2022-03-20 | US | Virginia | Henry | 51089 | 11483 | 254 | 0 | 36.68542395 | -79.87634026 | 2022-03-21 04:20:50 | Henry, Virginia, US | |
1659766 | 1659766 | 2022-03-19 | US | Virginia | Henry | 51089 | 11483 | 254 | 0 | 36.68542395 | -79.87634026 | 2022-03-20 04:20:45 | Henry, Virginia, US | |
339292 | 339292 | 2022-03-18 | US | Virginia | Henry | 51089 | 11483 | 254 | 0 | 36.68542395 | -79.87634026 | 2022-03-19 04:20:47 | Henry, Virginia, US | |
3821929 | 3821929 | 2022-02-16 | US | Louisiana | Avoyelles | 22009 | 11483 | 195 | 0 | 31.07796211 | -92.00079449 | 2022-02-17 04:20:56 | Avoyelles, Louisiana, US | |
3228426 | 3228426 | 2022-01-19 | US | Missouri | Taney | 29213 | 11483 | 186 | 0 | 36.65465345 | -93.04075153 | 2022-01-20 04:21:07 | Taney, Missouri, US | |
3227588 | 3227588 | 2022-01-19 | US | Indiana | Shelby | 18145 | 11483 | 150 | 0 | 39.52305623 | -85.79158570000001 | 2022-01-20 04:21:07 | Shelby, Indiana, US | |
3498570 | 3498570 | 2021-12-15 | US | North Carolina | Wilkes | 37193 | 11483 | 196 | 0 | 36.2084135 | -81.16232895 | 2021-12-16 04:22:11 | Wilkes, North Carolina, US | |
784858 | 784858 | 2021-12-13 | US | Ohio | Geauga | 39055 | 11483 | 206 | 0 | 41.49952319 | -81.17935342 | 2021-12-14 04:22:38 | Geauga, Ohio, US | |
689355 | 689355 | 2021-11-13 | US | Tennessee | Tipton | 47167 | 11483 | 138 | 0 | 35.501942 | -89.73694895 | 2021-11-14 04:21:31 | Tipton, Tennessee, US | |
87551 | 87551 | 2021-11-09 | US | Alaska | Kenai Peninsula | 2122 | 11483 | 65 | 0 | 60.24429722 | -151.53888840000005 | 2021-11-10 04:21:38 | Kenai Peninsula, Alaska, US | |
684852 | 684852 | 2021-10-24 | US | Ohio | Scioto | 39145 | 11483 | 178 | 0 | 38.80270163 | -82.98907345 | 2021-10-25 04:22:31 | Scioto, Ohio, US | |
2462194 | 2462194 | 2021-10-06 | US | Virginia | Roanoke City | 51770 | 11483 | 221 | 0 | 37.27791025 | -79.96189766 | 2021-10-07 04:21:36 | Roanoke City, Virginia, US | |
1921736 | 1921736 | 2021-09-24 | US | Arkansas | Pope | 5115 | 11483 | 148 | 0 | 35.44871474 | -93.03212219 | 2021-09-25 04:21:31 | Pope, Arkansas, US | |
602750 | 602750 | 2021-09-23 | US | Illinois | Williamson | 17199 | 11483 | 159 | 0 | 37.73033511 | -88.92994027 | 2021-09-24 04:21:44 | Williamson, Illinois, US | |
2810906 | 2810906 | 2021-09-16 | US | New Hampshire | Strafford | 33017 | 11483 | 105 | 0 | 43.291833000000004 | -71.02336013 | 2021-09-17 04:21:46 | Strafford, New Hampshire, US | |
1887293 | 1887293 | 2021-09-12 | US | North Carolina | Caldwell | 37027 | 11483 | 111 | 0 | 35.95204977 | -81.54799522 | 2021-09-13 04:21:15 | Caldwell, North Carolina, US | |
3808196 | 3808196 | 2021-09-11 | US | North Carolina | Caldwell | 37027 | 11483 | 111 | 0 | 35.95204977 | -81.54799522 | 2021-09-12 04:21:13 | Caldwell, North Carolina, US | |
3451136 | 3451136 | 2021-09-10 | US | North Carolina | Caldwell | 37027 | 11483 | 111 | 0 | 35.95204977 | -81.54799522 | 2021-09-11 04:21:30 | Caldwell, North Carolina, US | |
3196257 | 3196257 | 2021-09-06 | US | New York | Putnam | 36079 | 11483 | 95 | 0 | 41.42630093 | -73.74965532 | 2021-09-07 04:21:35 | Putnam, New York, US | |
1606120 | 1606120 | 2021-08-16 | US | Missouri | Cole | 29051 | 11483 | 139 | 0 | 38.50455671 | -92.27860244 | 2021-08-17 04:21:49 | Cole, Missouri, US | |
400706 | 400706 | 2021-06-29 | US | Arizona | Apache | 4001 | 11483 | 436 | 0 | 35.39465006 | -109.4892383 | 2021-06-30 04:21:41 | Apache, Arizona, US | |
1709072 | 1709072 | 2021-06-02 | US | Georgia | Carroll | 13045 | 11483 | 243 | 0 | 33.58138199 | -85.07976677 | 2021-06-03 04:23:32 | Carroll, Georgia, US | |
3883680 | 3883680 | 2021-04-11 | Mexico | Nayarit | 11483 | 1758 | 0 | 9725 | 21.7514 | -104.8455 | 2021-04-12 04:21:00 | Nayarit, Mexico | ||
2985247 | 2985247 | 2021-04-10 | US | Montana | Flathead | 30029 | 11483 | 91 | 0 | 48.29575866 | -114.0520569 | 2021-04-11 04:20:56 | Flathead, Montana, US | |
3421059 | 3421059 | 2021-03-19 | Pakistan | Azad Jammu and Kashmir | 11483 | 330 | 10242 | 911 | 34.027401 | 73.947253 | 2021-03-20 05:25:46 | Azad Jammu and Kashmir, Pakistan | ||
3456390 | 3456390 | 2021-03-18 | US | Wisconsin | Eau Claire | 55035 | 11483 | 117 | 0 | 44.726614 | -91.28609183 | 2021-03-19 05:26:09 | Eau Claire, Wisconsin, US | |
864680 | 864680 | 2020-11-12 | Germany | Brandenburg | 11483 | 229 | 8688 | 3559 | 52.4125 | 12.5316 | 2020-11-13 05:25:30 | Brandenburg, Germany | ||
787075 | 787075 | 2020-10-15 | US | Florida | Leon | 12073 | 11483 | 96 | 0 | 11387 | 30.45955727 | -84.27491114 | 2020-10-16 04:24:01 | Leon, Florida, US |
1447253 | 1447253 | 2020-09-11 | US | Pennsylvania | Montgomery | 42091 | 11483 | 867 | 0 | 10616 | 40.21053671 | -75.36652296 | 2020-09-12 04:25:05 | Montgomery, Pennsylvania, US |
838140 | 838140 | 2020-08-17 | US | California | Contra Costa | 6013 | 11483 | 141 | 0 | 11343 | 37.91923498 | -121.9289527 | 2020-08-18 04:27:56 | Contra Costa, California, US |
3205735 | 3205735 | 2020-07-18 | Venezuela | 11483 | 110 | 3972 | 7401 | 6.4238 | -66.5897 | 2020-07-19 04:34:58 | Venezuela | |||
2622928 | 2622928 | 2020-06-25 | US | Connecticut | Hartford | 9003 | 11483 | 1362 | 0 | 10121 | 41.80283011 | -72.73103891 | 2020-06-26 04:33:43 | Hartford, Connecticut, US |
1522354 | 1522354 | 2020-06-23 | Pakistan | Islamabad | 11483 | 108 | 5012 | 6363 | 33.665087 | 73.121219 | 2020-06-24 04:33:28 | Islamabad, 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]);