johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
77 rows where confirmed = 8536 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
219836 | 219836 | 2022-12-26 | US | Mississippi | Tate | 28137 | 8536 | 155 | 0 | 34.65133709 | -89.94485778 | 2022-12-27 04:21:07 | Tate, Mississippi, US | |
3224293 | 3224293 | 2022-12-25 | US | Mississippi | Tate | 28137 | 8536 | 155 | 0 | 34.65133709 | -89.94485778 | 2022-12-26 04:21:06 | Tate, Mississippi, US | |
1020207 | 1020207 | 2022-12-24 | US | Mississippi | Tate | 28137 | 8536 | 155 | 0 | 34.65133709 | -89.94485778 | 2022-12-25 04:21:04 | Tate, Mississippi, US | |
692230 | 692230 | 2022-12-23 | US | Mississippi | Tate | 28137 | 8536 | 155 | 0 | 34.65133709 | -89.94485778 | 2022-12-24 04:21:02 | Tate, Mississippi, US | |
2181440 | 2181440 | 2022-12-22 | US | Mississippi | Tate | 28137 | 8536 | 155 | 0 | 34.65133709 | -89.94485778 | 2022-12-23 04:21:04 | Tate, Mississippi, US | |
453244 | 453244 | 2022-12-21 | US | Mississippi | Tate | 28137 | 8536 | 155 | 0 | 34.65133709 | -89.94485778 | 2022-12-22 04:20:56 | Tate, Mississippi, US | |
2415877 | 2415877 | 2022-12-05 | US | Illinois | Iroquois | 17075 | 8536 | 128 | 0 | 40.74717633 | -87.82466784 | 2022-12-06 04:21:03 | Iroquois, Illinois, US | |
2509379 | 2509379 | 2022-11-10 | US | Virginia | Caroline | 51033 | 8536 | 92 | 0 | 38.02679129 | -77.34901405 | 2022-11-11 04:21:22 | Caroline, Virginia, US | |
2162894 | 2162894 | 2022-10-16 | US | Virginia | Isle of Wight | 51093 | 8536 | 124 | 0 | 36.90579348 | -76.70842863 | 2022-10-17 04:20:31 | Isle of Wight, Virginia, US | |
519091 | 519091 | 2022-10-15 | US | Virginia | Isle of Wight | 51093 | 8536 | 124 | 0 | 36.90579348 | -76.70842863 | 2022-10-16 04:22:39 | Isle of Wight, Virginia, US | |
2036148 | 2036148 | 2022-10-14 | US | Virginia | Isle of Wight | 51093 | 8536 | 124 | 0 | 36.90579348 | -76.70842863 | 2022-10-15 04:22:00 | Isle of Wight, Virginia, US | |
255943 | 255943 | 2022-09-08 | US | Oregon | Lincoln | 41041 | 8536 | 104 | 0 | 44.64252874 | -123.869912 | 2022-09-09 04:21:11 | Lincoln, Oregon, US | |
3747741 | 3747741 | 2022-09-07 | US | Oregon | Lincoln | 41041 | 8536 | 104 | 0 | 44.64252874 | -123.869912 | 2022-09-08 04:21:02 | Lincoln, Oregon, US | |
3550749 | 3550749 | 2022-09-01 | US | Texas | Upshur | 48459 | 8536 | 189 | 0 | 32.73706798 | -94.93999853 | 2022-09-02 04:21:07 | Upshur, Texas, US | |
1214184 | 1214184 | 2022-07-11 | US | Oregon | Malheur | 41045 | 8536 | 108 | 0 | 43.1937027 | -117.6227395 | 2022-07-12 04:20:51 | Malheur, Oregon, US | |
2790878 | 2790878 | 2022-07-10 | US | Mississippi | Prentiss | 28117 | 8536 | 103 | 0 | 34.61810501 | -88.51986294 | 2022-07-11 04:20:46 | Prentiss, Mississippi, US | |
143831 | 143831 | 2022-07-09 | US | Mississippi | Prentiss | 28117 | 8536 | 103 | 0 | 34.61810501 | -88.51986294 | 2022-07-10 04:20:54 | Prentiss, Mississippi, US | |
1418931 | 1418931 | 2022-07-08 | US | Mississippi | Prentiss | 28117 | 8536 | 103 | 0 | 34.61810501 | -88.51986294 | 2022-07-09 04:20:59 | Prentiss, Mississippi, US | |
2240957 | 2240957 | 2022-06-28 | US | Maine | Hancock | 23009 | 8536 | 90 | 0 | 44.59816444 | -68.38401854 | 2022-06-29 04:20:59 | Hancock, Maine, US | |
3985270 | 3985270 | 2022-06-15 | US | Pennsylvania | Clarion | 42031 | 8536 | 209 | 0 | 41.19265812 | -79.42413524 | 2022-06-16 04:20:55 | Clarion, Pennsylvania, US | |
949511 | 949511 | 2022-06-14 | US | Pennsylvania | Clarion | 42031 | 8536 | 209 | 0 | 41.19265812 | -79.42413524 | 2022-06-15 04:20:54 | Clarion, Pennsylvania, US | |
2981919 | 2981919 | 2022-06-13 | US | Pennsylvania | Clarion | 42031 | 8536 | 209 | 0 | 41.19265812 | -79.42413524 | 2022-06-14 04:20:52 | Clarion, Pennsylvania, US | |
2238045 | 2238045 | 2022-06-12 | US | Pennsylvania | Clarion | 42031 | 8536 | 209 | 0 | 41.19265812 | -79.42413524 | 2022-06-13 04:21:14 | Clarion, Pennsylvania, US | |
3144346 | 3144346 | 2022-06-11 | US | Puerto Rico | Moca | 72099 | 8536 | 0 | 0 | 18.377805 | -67.080952 | 2022-06-12 04:20:53 | Moca, Puerto Rico, US | |
3144243 | 3144243 | 2022-06-11 | US | Pennsylvania | Clarion | 42031 | 8536 | 209 | 0 | 41.19265812 | -79.42413524 | 2022-06-12 04:20:53 | Clarion, Pennsylvania, US | |
1947159 | 1947159 | 2022-06-10 | US | Pennsylvania | Clarion | 42031 | 8536 | 209 | 0 | 41.19265812 | -79.42413524 | 2022-06-11 04:21:01 | Clarion, Pennsylvania, US | |
3160298 | 3160298 | 2022-06-09 | US | Pennsylvania | Clarion | 42031 | 8536 | 209 | 0 | 41.19265812 | -79.42413524 | 2022-06-10 04:20:55 | Clarion, Pennsylvania, US | |
1423765 | 1423765 | 2022-06-08 | US | Pennsylvania | Clarion | 42031 | 8536 | 209 | 0 | 41.19265812 | -79.42413524 | 2022-06-09 04:20:54 | Clarion, Pennsylvania, US | |
3188225 | 3188225 | 2022-05-30 | US | New York | Delaware | 36025 | 8536 | 74 | 0 | 42.19837623 | -74.96709306 | 2022-05-31 04:20:51 | Delaware, New York, US | |
3200374 | 3200374 | 2022-05-29 | US | New York | Delaware | 36025 | 8536 | 74 | 0 | 42.19837623 | -74.96709306 | 2022-05-30 04:20:50 | Delaware, New York, US | |
2727252 | 2727252 | 2022-05-28 | US | New York | Delaware | 36025 | 8536 | 74 | 0 | 42.19837623 | -74.96709306 | 2022-05-29 04:20:53 | Delaware, New York, US | |
1316433 | 1316433 | 2022-05-27 | US | New York | Delaware | 36025 | 8536 | 74 | 0 | 42.19837623 | -74.96709306 | 2022-05-28 04:21:07 | Delaware, New York, US | |
466966 | 466966 | 2022-05-02 | US | Wisconsin | Oneida | 55085 | 8536 | 138 | 0 | 45.70677897 | -89.51944105 | 2022-05-03 04:21:00 | Oneida, Wisconsin, US | |
25787 | 25787 | 2022-03-20 | US | Kentucky | Carter | 21043 | 8536 | 99 | 0 | 38.31690743 | -83.05092385 | 2022-03-21 04:20:50 | Carter, Kentucky, US | |
1657797 | 1657797 | 2022-03-19 | US | Kentucky | Carter | 21043 | 8536 | 99 | 0 | 38.31690743 | -83.05092385 | 2022-03-20 04:20:45 | Carter, Kentucky, US | |
337323 | 337323 | 2022-03-18 | US | Kentucky | Carter | 21043 | 8536 | 99 | 0 | 38.31690743 | -83.05092385 | 2022-03-19 04:20:47 | Carter, Kentucky, US | |
695776 | 695776 | 2022-03-17 | US | Kentucky | Carter | 21043 | 8536 | 99 | 0 | 38.31690743 | -83.05092385 | 2022-03-18 04:20:55 | Carter, Kentucky, US | |
2525830 | 2525830 | 2022-03-02 | US | Arkansas | Baxter | 5005 | 8536 | 232 | 0 | 36.28784385 | -92.33782872 | 2022-03-03 04:21:01 | Baxter, Arkansas, US | |
1299738 | 1299738 | 2022-02-17 | US | Michigan | Sanilac | 26151 | 8536 | 179 | 0 | 43.42406072 | -82.82055898 | 2022-02-18 04:21:04 | Sanilac, Michigan, US | |
3822124 | 3822124 | 2022-02-16 | US | Michigan | Sanilac | 26151 | 8536 | 179 | 0 | 43.42406072 | -82.82055898 | 2022-02-17 04:20:56 | Sanilac, Michigan, US | |
3077554 | 3077554 | 2022-02-09 | US | West Virginia | Preston | 54077 | 8536 | 121 | 0 | 39.46770987 | -79.66712803 | 2022-02-10 04:21:14 | Preston, West Virginia, US | |
2477074 | 2477074 | 2022-02-03 | US | Texas | Hill | 48217 | 8536 | 184 | 0 | 31.99045053 | -97.13423143 | 2022-02-04 04:21:10 | Hill, Texas, US | |
979710 | 979710 | 2022-02-01 | US | Georgia | Bryan | 13029 | 8536 | 80 | 0 | 32.00979311 | -81.44002948 | 2022-02-02 04:21:09 | Bryan, Georgia, US | |
1081109 | 1081109 | 2021-12-09 | US | Texas | Nacogdoches | 48347 | 8536 | 237 | 0 | 31.62017125 | -94.61803994 | 2021-12-10 04:22:28 | Nacogdoches, Texas, US | |
2288540 | 2288540 | 2021-11-15 | US | Indiana | Dubois | 18037 | 8536 | 135 | 0 | 38.36597551 | -86.87924170000002 | 2021-11-16 04:21:10 | Dubois, Indiana, US | |
689020 | 689020 | 2021-11-13 | US | Pennsylvania | Columbia | 42037 | 8536 | 158 | 0 | 41.04821986 | -76.40565017 | 2021-11-14 04:21:31 | Columbia, Pennsylvania, US | |
3641777 | 3641777 | 2021-11-08 | US | New York | Cattaraugus | 36009 | 8536 | 135 | 0 | 42.24778241 | -78.67923096 | 2021-11-09 04:21:36 | Cattaraugus, New York, US | |
5882 | 5882 | 2021-10-28 | US | Louisiana | St. Mary | 22101 | 8536 | 221 | 0 | 29.69262097 | -91.44702164 | 2021-10-29 04:22:03 | St. Mary, Louisiana, US | |
1493736 | 1493736 | 2021-10-12 | US | Nevada | Carson City | 32510 | 8536 | 148 | 0 | 39.15509045 | -119.7480219 | 2021-10-13 04:20:51 | Carson City, Nevada, US | |
1817396 | 1817396 | 2021-09-19 | US | Oregon | Josephine | 41033 | 8536 | 163 | 0 | 42.3665549 | -123.5561938 | 2021-09-20 04:21:22 | Josephine, Oregon, US | |
1817108 | 1817108 | 2021-09-19 | US | North Carolina | Lee | 37105 | 8536 | 97 | 0 | 35.47623147 | -79.17569362 | 2021-09-20 04:21:22 | Lee, North Carolina, US | |
18976 | 18976 | 2021-09-18 | US | Oregon | Josephine | 41033 | 8536 | 163 | 0 | 42.3665549 | -123.5561938 | 2021-09-19 04:21:34 | Josephine, Oregon, US | |
18688 | 18688 | 2021-09-18 | US | North Carolina | Lee | 37105 | 8536 | 97 | 0 | 35.47623147 | -79.17569362 | 2021-09-19 04:21:34 | Lee, North Carolina, US | |
2620661 | 2620661 | 2021-09-17 | US | Oregon | Josephine | 41033 | 8536 | 163 | 0 | 42.3665549 | -123.5561938 | 2021-09-18 04:21:24 | Josephine, Oregon, US | |
2620373 | 2620373 | 2021-09-17 | US | North Carolina | Lee | 37105 | 8536 | 97 | 0 | 35.47623147 | -79.17569362 | 2021-09-18 04:21:24 | Lee, North Carolina, US | |
2793041 | 2793041 | 2021-08-28 | Japan | Fukushima | 8536 | 165 | 0 | 37.378867 | 140.223295 | 2021-08-29 04:21:14 | Fukushima, Japan | |||
410091 | 410091 | 2021-07-28 | US | Mississippi | Forrest | 28035 | 8536 | 159 | 0 | 31.18961454 | -89.25832496 | 2021-07-29 04:21:33 | Forrest, Mississippi, US | |
830000 | 830000 | 2021-07-09 | US | Alabama | Talladega | 1121 | 8536 | 185 | 0 | 33.37823223 | -86.16886178 | 2021-07-10 04:21:25 | Talladega, Alabama, US | |
1499289 | 1499289 | 2021-07-03 | Malaysia | W.P. Labuan | 8536 | 128 | 6844 | 1564 | 5.2831 | 115.2308 | 2021-07-04 04:21:38 | W.P. Labuan, Malaysia | ||
890338 | 890338 | 2021-04-26 | US | New York | Chautauqua | 36013 | 8536 | 137 | 0 | 42.22769210000001 | -79.36691763 | 2021-04-27 04:20:52 | Chautauqua, New York, US | |
37340 | 37340 | 2021-04-12 | US | Idaho | Bannock | 16005 | 8536 | 101 | 0 | 42.67002716 | -112.2233311 | 2021-04-13 04:20:37 | Bannock, Idaho, US | |
244808 | 244808 | 2021-04-02 | US | Wisconsin | Manitowoc | 55071 | 8536 | 86 | 0 | 44.11946801 | -87.80928853 | 2021-04-03 04:20:44 | Manitowoc, Wisconsin, US | |
1290666 | 1290666 | 2021-03-29 | US | Connecticut | Tolland | 9013 | 8536 | 176 | 0 | 41.85853803 | -72.3308481 | 2021-03-30 04:26:23 | Tolland, Connecticut, US | |
1222251 | 1222251 | 2021-03-27 | US | Pennsylvania | Northumberland | 42097 | 8536 | 334 | 0 | 40.84785433 | -76.70798222 | 2021-03-28 05:28:10 | Northumberland, Pennsylvania, US | |
1858427 | 1858427 | 2021-02-25 | US | Alaska | Matanuska-Susitna | 2170 | 8536 | 34 | 0 | 8502 | 62.31305045 | -149.5741743 | 2021-02-26 05:22:40 | Matanuska-Susitna, Alaska, US |
1062846 | 1062846 | 2021-01-04 | US | Illinois | LaSalle | 17099 | 8536 | 186 | 0 | 8350 | 41.34426129999999 | -88.88633881 | 2021-01-05 05:21:49 | LaSalle, Illinois, US |
767825 | 767825 | 2020-12-29 | US | Louisiana | Livingston | 22063 | 8536 | 123 | 0 | 8413 | 30.44143993 | -90.73061664 | 2020-12-30 05:22:34 | Livingston, Louisiana, US |
924492 | 924492 | 2020-11-26 | US | Georgia | Henry | 13151 | 8536 | 135 | 0 | 8401 | 33.4533428 | -84.14814659999998 | 2020-11-27 05:26:53 | Henry, Georgia, US |
821797 | 821797 | 2020-11-19 | Russia | North Ossetia - Alania Republic | 8536 | 73 | 6365 | 2098 | 42.79336110000001 | 44.6324493 | 2020-11-20 05:26:28 | North Ossetia - Alania Republic, Russia | ||
1794588 | 1794588 | 2020-10-19 | India | Meghalaya | 8536 | 75 | 6392 | 2069 | 25.536934 | 91.278882 | 2020-10-20 04:24:22 | Meghalaya, India | ||
2291822 | 2291822 | 2020-10-12 | US | Alabama | Madison | 1089 | 8536 | 83 | 0 | 8453 | 34.76327133 | -86.55069633 | 2020-10-13 04:24:02 | Madison, Alabama, US |
3805136 | 3805136 | 2020-10-05 | US | Texas | Williamson | 48491 | 8536 | 144 | 0 | 8658 | 30.64655664 | -97.6004854 | 2020-10-06 04:23:33 | Williamson, Texas, US |
2455009 | 2455009 | 2020-09-19 | Russia | Sakha (Yakutiya) Republic | 8536 | 93 | 6632 | 1811 | 66.941626 | 129.642371 | 2020-09-20 04:22:00 | Sakha (Yakutiya) Republic, Russia | ||
1355869 | 1355869 | 2020-09-03 | US | Maryland | Anne Arundel | 24003 | 8536 | 238 | 0 | 8298 | 39.00670238 | -76.60329337 | 2020-09-04 04:28:26 | Anne Arundel, Maryland, US |
458047 | 458047 | 2020-08-07 | US | Utah | Utah | 49049 | 8536 | 37 | 0 | 8499 | 40.116672200000004 | -111.66576620000001 | 2020-08-08 04:34:53 | Utah, Utah, US |
844933 | 844933 | 2020-07-22 | Russia | Saratov Oblast | 8536 | 54 | 4956 | 3526 | 51.652055499999996 | 46.86319520000001 | 2020-07-23 05:15:04 | Saratov Oblast, Russia | ||
1790279 | 1790279 | 2020-05-29 | Colombia | Capital District | 8536 | 238 | 2837 | 5461 | 4.711 | -74.0721 | 2020-05-30 02:32:48 | Capital District, Colombia |
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]);