johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
60 rows where confirmed = 11761 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
542035 | 542035 | 2022-10-26 | US | Utah | Wasatch | 49051 | 11761 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-10-27 04:22:01 | Wasatch, Utah, US | |
1833436 | 1833436 | 2022-10-25 | US | Utah | Wasatch | 49051 | 11761 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-10-26 04:22:19 | Wasatch, Utah, US | |
797697 | 797697 | 2022-10-24 | US | Utah | Wasatch | 49051 | 11761 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-10-25 04:21:53 | Wasatch, Utah, US | |
3280152 | 3280152 | 2022-10-23 | US | Utah | Wasatch | 49051 | 11761 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-10-24 04:22:29 | Wasatch, Utah, US | |
2271190 | 2271190 | 2022-10-22 | US | Utah | Wasatch | 49051 | 11761 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-10-23 04:22:46 | Wasatch, Utah, US | |
1595490 | 1595490 | 2022-10-21 | US | Utah | Wasatch | 49051 | 11761 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-10-22 04:22:53 | Wasatch, Utah, US | |
2275206 | 2275206 | 2022-10-20 | US | Utah | Wasatch | 49051 | 11761 | 37 | 0 | 40.33110236 | -111.1691419 | 2022-10-21 04:22:23 | Wasatch, Utah, US | |
1073324 | 1073324 | 2022-08-07 | US | Virginia | York | 51199 | 11761 | 114 | 0 | 37.24374789 | -76.54412815 | 2022-08-08 04:21:08 | York, Virginia, US | |
1943912 | 1943912 | 2022-08-06 | US | Virginia | York | 51199 | 11761 | 114 | 0 | 37.24374789 | -76.54412815 | 2022-08-07 04:20:54 | York, Virginia, US | |
883711 | 883711 | 2022-08-05 | US | Virginia | York | 51199 | 11761 | 114 | 0 | 37.24374789 | -76.54412815 | 2022-08-06 04:20:56 | York, Virginia, US | |
1407969 | 1407969 | 2022-08-02 | US | Tennessee | Cheatham | 47021 | 11761 | 129 | 0 | 36.26136216 | -87.08903581 | 2022-08-03 04:20:59 | Cheatham, Tennessee, US | |
593805 | 593805 | 2022-07-01 | Pakistan | Gilgit-Baltistan | 11761 | 191 | 0 | 35.792146 | 74.982138 | 2022-07-02 04:21:16 | Gilgit-Baltistan, Pakistan | |||
3940206 | 3940206 | 2022-06-30 | Pakistan | Gilgit-Baltistan | 11761 | 191 | 0 | 35.792146 | 74.982138 | 2022-07-01 04:21:10 | Gilgit-Baltistan, Pakistan | |||
941954 | 941954 | 2022-06-25 | US | Texas | Jim Wells | 48249 | 11761 | 211 | 0 | 27.73103938 | -98.0904705 | 2022-06-26 04:21:02 | Jim Wells, Texas, US | |
230301 | 230301 | 2022-05-31 | US | Indiana | Cass | 18017 | 11761 | 164 | 0 | 40.76135835 | -86.34830753 | 2022-06-01 04:20:55 | Cass, Indiana, US | |
3187066 | 3187066 | 2022-05-30 | US | Indiana | Cass | 18017 | 11761 | 164 | 0 | 40.76135835 | -86.34830753 | 2022-05-31 04:20:51 | Cass, Indiana, US | |
3199215 | 3199215 | 2022-05-29 | US | Indiana | Cass | 18017 | 11761 | 164 | 0 | 40.76135835 | -86.34830753 | 2022-05-30 04:20:50 | Cass, Indiana, US | |
2726093 | 2726093 | 2022-05-28 | US | Indiana | Cass | 18017 | 11761 | 164 | 0 | 40.76135835 | -86.34830753 | 2022-05-29 04:20:53 | Cass, Indiana, US | |
1315274 | 1315274 | 2022-05-27 | US | Indiana | Cass | 18017 | 11761 | 164 | 0 | 40.76135835 | -86.34830753 | 2022-05-28 04:21:07 | Cass, Indiana, US | |
1951869 | 1951869 | 2022-04-12 | US | Virginia | Henry | 51089 | 11761 | 261 | 0 | 36.68542395 | -79.87634026 | 2022-04-13 04:21:03 | Henry, Virginia, US | |
1646738 | 1646738 | 2022-03-03 | US | North Carolina | Vance | 37181 | 11761 | 112 | 0 | 36.36880673 | -78.40670845 | 2022-03-04 04:21:09 | Vance, North Carolina, US | |
3914299 | 3914299 | 2022-02-20 | US | New York | Washington | 36115 | 11761 | 111 | 0 | 43.31153794 | -73.43043448 | 2022-02-21 04:21:05 | Washington, New York, US | |
1473647 | 1473647 | 2022-01-17 | US | Louisiana | St. Charles | 22089 | 11761 | 129 | 0 | 29.90709658 | -90.35555967 | 2022-01-18 04:21:04 | St. Charles, Louisiana, US | |
556321 | 556321 | 2022-01-16 | US | Louisiana | St. Charles | 22089 | 11761 | 129 | 0 | 29.90709658 | -90.35555967 | 2022-01-17 04:21:08 | St. Charles, Louisiana, US | |
3842042 | 3842042 | 2022-01-15 | US | Louisiana | St. Charles | 22089 | 11761 | 129 | 0 | 29.90709658 | -90.35555967 | 2022-01-16 04:21:12 | St. Charles, Louisiana, US | |
100857 | 100857 | 2022-01-14 | US | Louisiana | St. Charles | 22089 | 11761 | 129 | 0 | 29.90709658 | -90.35555967 | 2022-01-15 04:21:07 | St. Charles, Louisiana, US | |
2400279 | 2400279 | 2021-12-17 | US | Kentucky | Pike | 21195 | 11761 | 220 | 0 | 37.47088263 | -82.39487445 | 2021-12-18 02:22:20 | Pike, Kentucky, US | |
1663357 | 1663357 | 2021-12-12 | US | Tennessee | Cumberland | 47035 | 11761 | 236 | 0 | 35.95271721 | -84.99840585 | 2021-12-13 04:22:02 | Cumberland, Tennessee, US | |
2198622 | 2198622 | 2021-12-03 | US | Tennessee | Tipton | 47167 | 11761 | 146 | 0 | 35.501942 | -89.73694895 | 2021-12-04 04:22:18 | Tipton, Tennessee, US | |
3511628 | 3511628 | 2021-11-01 | Russia | Magadan Oblast | 11761 | 280 | 0 | 62.48858785 | 153.9903764 | 2021-11-02 04:22:03 | Magadan Oblast, Russia | |||
535802 | 535802 | 2021-10-27 | US | Indiana | Bartholomew | 18005 | 11761 | 181 | 0 | 39.20744865 | -85.89558181 | 2021-10-28 04:22:08 | Bartholomew, Indiana, US | |
493014 | 493014 | 2021-10-14 | US | Kentucky | Bullitt | 21029 | 11761 | 118 | 0 | 37.97162523 | -85.68955617 | 2021-10-15 04:21:26 | Bullitt, Kentucky, US | |
708869 | 708869 | 2021-09-29 | US | North Dakota | Ward | 38101 | 11761 | 209 | 0 | 48.22390169 | -101.54367629999999 | 2021-09-30 04:21:20 | Ward, North Dakota, US | |
3893744 | 3893744 | 2021-08-29 | US | Mississippi | Jones | 28067 | 11761 | 188 | 0 | 31.62257767 | -89.16896899999998 | 2021-08-30 04:21:23 | Jones, Mississippi, US | |
2794847 | 2794847 | 2021-08-28 | US | Mississippi | Jones | 28067 | 11761 | 188 | 0 | 31.62257767 | -89.16896899999998 | 2021-08-29 04:21:14 | Jones, Mississippi, US | |
2925006 | 2925006 | 2021-08-27 | US | Mississippi | Jones | 28067 | 11761 | 188 | 0 | 31.62257767 | -89.16896899999998 | 2021-08-28 04:21:28 | Jones, Mississippi, US | |
3296175 | 3296175 | 2021-07-30 | Italy | Valle d'Aosta | 11761 | 473 | 11228 | 60 | 45.73750286 | 7.320149366 | 2021-07-31 04:21:35 | Valle d'Aosta, Italy | ||
411703 | 411703 | 2021-07-28 | US | Virginia | Stafford | 51179 | 11761 | 83 | 0 | 38.41758738 | -77.45917053 | 2021-07-29 04:21:33 | Stafford, Virginia, US | |
2676156 | 2676156 | 2021-07-18 | US | North Carolina | Nash | 37127 | 11761 | 200 | 0 | 35.96575634 | -77.98422508 | 2021-07-19 04:21:24 | Nash, North Carolina, US | |
3708468 | 3708468 | 2021-07-17 | US | North Carolina | Nash | 37127 | 11761 | 200 | 0 | 35.96575634 | -77.98422508 | 2021-07-18 04:22:07 | Nash, North Carolina, US | |
2949699 | 2949699 | 2021-07-16 | US | North Carolina | Nash | 37127 | 11761 | 200 | 0 | 35.96575634 | -77.98422508 | 2021-07-17 04:22:22 | Nash, North Carolina, US | |
3663279 | 3663279 | 2021-07-11 | Malaysia | Terengganu | 11761 | 82 | 11213 | 466 | 5.3117 | 103.1324 | 2021-07-12 04:21:34 | Terengganu, Malaysia | ||
780663 | 780663 | 2021-07-08 | US | North Carolina | Cleveland | 37045 | 11761 | 228 | 0 | 35.33553364 | -81.55204486 | 2021-07-09 04:21:21 | Cleveland, North Carolina, US | |
53769 | 53769 | 2021-05-29 | US | Tennessee | Putnam | 47141 | 11761 | 177 | 0 | 36.14005459 | -85.50646123 | 2021-05-30 04:20:55 | Putnam, Tennessee, US | |
23348 | 23348 | 2021-05-28 | US | Tennessee | Putnam | 47141 | 11761 | 177 | 0 | 36.14005459 | -85.50646123 | 2021-05-29 04:20:41 | Putnam, Tennessee, US | |
1809723 | 1809723 | 2021-05-27 | US | Tennessee | Putnam | 47141 | 11761 | 177 | 0 | 36.14005459 | -85.50646123 | 2021-05-28 04:20:36 | Putnam, Tennessee, US | |
3116713 | 3116713 | 2021-05-06 | US | Texas | Tom Green | 48451 | 11761 | 270 | 0 | 31.40464436 | -100.462443 | 2021-05-07 04:20:40 | Tom Green, Texas, US | |
1636407 | 1636407 | 2021-04-29 | Mexico | Nayarit | 11761 | 1783 | 0 | 9978 | 21.7514 | -104.8455 | 2021-04-30 04:21:03 | Nayarit, Mexico | ||
3393156 | 3393156 | 2021-04-28 | Cambodia | 11761 | 88 | 4698 | 6975 | 11.55 | 104.9167 | 2021-04-29 04:20:55 | Cambodia | |||
1845173 | 1845173 | 2021-04-14 | US | Texas | Tom Green | 48451 | 11761 | 269 | 0 | 31.40464436 | -100.462443 | 2021-04-15 04:20:54 | Tom Green, Texas, US | |
37225 | 37225 | 2021-04-12 | US | Georgia | Floyd | 13115 | 11761 | 215 | 0 | 34.26268279 | -85.21577392 | 2021-04-13 04:20:37 | Floyd, Georgia, US | |
999267 | 999267 | 2021-03-01 | US | Georgia | Lowndes | 13185 | 11761 | 186 | 0 | 11575 | 30.83568832 | -83.27056716 | 2021-03-02 05:23:30 | Lowndes, Georgia, US |
3067739 | 3067739 | 2021-02-27 | US | Minnesota | Olmsted | 27109 | 11761 | 88 | 0 | 11673 | 44.00374114 | -92.40209944 | 2021-02-28 05:22:20 | Olmsted, Minnesota, US |
1686335 | 1686335 | 2021-02-02 | US | Mississippi | Rankin | 28121 | 11761 | 237 | 0 | 11524 | 32.26469147 | -89.94537876 | 2021-02-03 05:22:52 | Rankin, Mississippi, US |
769111 | 769111 | 2020-12-29 | US | South Carolina | Anderson | 45007 | 11761 | 278 | 0 | 11483 | 34.51828081 | -82.63959517 | 2020-12-30 05:22:34 | Anderson, South Carolina, US |
1034334 | 1034334 | 2020-12-15 | India | Nagaland | 11761 | 69 | 11097 | 595 | 26.06702 | 94.470302 | 2020-12-16 05:28:04 | Nagaland, India | ||
1008322 | 1008322 | 2020-12-06 | US | Montana | Yellowstone | 30111 | 11761 | 122 | 0 | 11639 | 45.93955949 | -108.2691486 | 2020-12-07 05:26:14 | Yellowstone, Montana, US |
122951 | 122951 | 2020-11-18 | Russia | Tambov Oblast | 11761 | 70 | 9871 | 1820 | 52.9019574 | 41.3578918 | 2020-11-19 05:25:23 | Tambov Oblast, Russia | ||
3341230 | 3341230 | 2020-11-17 | US | Pennsylvania | Berks | 42011 | 11761 | 441 | 0 | 11320 | 40.41570541 | -75.92457766 | 2020-11-18 05:40:31 | Berks, Pennsylvania, US |
1244745 | 1244745 | 2020-09-08 | US | Illinois | Kane | 17089 | 11761 | 316 | 0 | 11445 | 41.93842729 | -88.42861412 | 2020-09-09 04:28:48 | Kane, Illinois, US |
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]);