johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
79 rows where confirmed = 6090 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
349342 | 349342 | 2022-12-14 | US | Illinois | Richland | 17159 | 6090 | 77 | 0 | 38.71240969 | -88.08475366 | 2022-12-15 04:20:58 | Richland, Illinois, US | |
836399 | 836399 | 2022-12-02 | US | Puerto Rico | Orocovis | 72107 | 6090 | 0 | 0 | 18.215046 | -66.433604 | 2022-12-03 04:21:02 | Orocovis, Puerto Rico, US | |
3315167 | 3315167 | 2022-11-23 | US | Tennessee | Crockett | 47033 | 6090 | 89 | 0 | 35.81830662 | -89.14916269 | 2022-11-24 04:21:09 | Crockett, Tennessee, US | |
1623752 | 1623752 | 2022-11-22 | US | West Virginia | Brooke | 54009 | 6090 | 108 | 0 | 40.27367263 | -80.57915332 | 2022-11-23 04:21:06 | Brooke, West Virginia, US | |
3463640 | 3463640 | 2022-11-21 | US | West Virginia | Brooke | 54009 | 6090 | 108 | 0 | 40.27367263 | -80.57915332 | 2022-11-22 04:20:47 | Brooke, West Virginia, US | |
434115 | 434115 | 2022-11-03 | US | Puerto Rico | Lajas | 72079 | 6090 | 0 | 0 | 18.011661 | -67.040585 | 2022-11-04 04:22:11 | Lajas, Puerto Rico, US | |
2532976 | 2532976 | 2022-10-06 | US | Wisconsin | Vilas | 55125 | 6090 | 100 | 0 | 46.05467334 | -89.51719204 | 2022-10-07 04:23:08 | Vilas, Wisconsin, US | |
1374057 | 1374057 | 2022-09-21 | US | Wisconsin | Langlade | 55067 | 6090 | 100 | 0 | 45.26271619 | -89.07483625 | 2022-09-22 04:22:56 | Langlade, Wisconsin, US | |
1163899 | 1163899 | 2022-08-18 | US | Puerto Rico | Catano | 72033 | 6090 | 0 | 0 | 18.437269 | -66.143306 | 2022-08-19 04:20:54 | Catano, Puerto Rico, US | |
1089083 | 1089083 | 2022-08-09 | US | Tennessee | Wayne | 47181 | 6090 | 75 | 0 | 35.23868267 | -87.78644456 | 2022-08-10 04:20:57 | Wayne, Tennessee, US | |
881841 | 881841 | 2022-08-05 | US | Maine | Lincoln | 23015 | 6090 | 40 | 0 | 44.05996956 | -69.54227124 | 2022-08-06 04:20:56 | Lincoln, Maine, US | |
2338336 | 2338336 | 2022-07-27 | US | Tennessee | Fentress | 47049 | 6090 | 130 | 0 | 36.38128818 | -84.92870012 | 2022-07-28 04:20:56 | Fentress, Tennessee, US | |
2742604 | 2742604 | 2022-07-07 | US | Maryland | Talbot | 24041 | 6090 | 92 | 0 | 38.76618159 | -76.10882561 | 2022-07-08 04:20:56 | Talbot, Maryland, US | |
3510154 | 3510154 | 2022-06-05 | US | Puerto Rico | Morovis | 72101 | 6090 | 0 | 0 | 18.316963 | -66.420383 | 2022-06-06 04:20:57 | Morovis, Puerto Rico, US | |
2252993 | 2252993 | 2022-04-19 | US | Maine | Waldo | 23027 | 6090 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-04-20 04:20:45 | Waldo, Maine, US | |
1847543 | 1847543 | 2022-04-18 | US | Maine | Waldo | 23027 | 6090 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-04-19 04:21:00 | Waldo, Maine, US | |
3418487 | 3418487 | 2022-04-17 | US | Maine | Waldo | 23027 | 6090 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-04-18 04:21:12 | Waldo, Maine, US | |
305436 | 305436 | 2022-04-16 | US | Maine | Waldo | 23027 | 6090 | 57 | 0 | 44.4858305 | -69.12061935 | 2022-04-17 04:20:59 | Waldo, Maine, US | |
1226974 | 1226974 | 2022-04-14 | US | Virginia | Mecklenburg | 51117 | 6090 | 118 | 0 | 36.67882005 | -78.36131056 | 2022-04-15 04:20:57 | Mecklenburg, Virginia, US | |
2801272 | 2801272 | 2022-04-06 | US | Arkansas | Jackson | 5067 | 6090 | 62 | 0 | 35.59802983 | -91.21494602 | 2022-04-07 04:20:53 | Jackson, Arkansas, US | |
1470034 | 1470034 | 2022-03-24 | US | Missouri | Miller | 29131 | 6090 | 117 | 0 | 38.21450288 | -92.42610898 | 2022-03-25 04:20:46 | Miller, Missouri, US | |
2643221 | 2643221 | 2022-02-14 | US | Kentucky | Rowan | 21205 | 6090 | 52 | 0 | 38.19484205 | -83.42088935 | 2022-02-15 04:21:09 | Rowan, Kentucky, US | |
3075048 | 3075048 | 2022-02-09 | US | Illinois | Jersey | 17083 | 6090 | 65 | 0 | 39.08869046 | -90.35393073 | 2022-02-10 04:21:14 | Jersey, Illinois, US | |
1228769 | 1228769 | 2022-01-24 | US | Indiana | Wells | 18179 | 6090 | 121 | 0 | 40.72934187 | -85.22132966 | 2022-01-25 04:21:05 | Wells, Indiana, US | |
1144040 | 1144040 | 2022-01-23 | US | Texas | Hutchinson | 48233 | 6090 | 120 | 0 | 35.84006574 | -101.3546643 | 2022-01-24 04:21:12 | Hutchinson, Texas, US | |
1288973 | 1288973 | 2022-01-04 | US | Tennessee | Macon | 47111 | 6090 | 118 | 0 | 36.53157855 | -86.00778595 | 2022-01-05 04:21:59 | Macon, Tennessee, US | |
2966437 | 2966437 | 2021-12-24 | US | Texas | Cherokee | 48073 | 6090 | 228 | 0 | 31.837258000000002 | -95.16559897 | 2021-12-25 04:21:37 | Cherokee, Texas, US | |
1663112 | 1663112 | 2021-12-12 | US | Pennsylvania | McKean | 42083 | 6090 | 108 | 0 | 41.80938602 | -78.56478358 | 2021-12-13 04:22:02 | McKean, Pennsylvania, US | |
29118 | 29118 | 2021-11-11 | US | Florida | Hardee | 12049 | 6090 | 45 | 0 | 27.49293939 | -81.80956574 | 2021-11-12 04:22:01 | Hardee, Florida, US | |
2845557 | 2845557 | 2021-11-10 | US | Florida | Hardee | 12049 | 6090 | 45 | 0 | 27.49293939 | -81.80956574 | 2021-11-11 04:21:45 | Hardee, Florida, US | |
87827 | 87827 | 2021-11-09 | US | Florida | Hardee | 12049 | 6090 | 45 | 0 | 27.49293939 | -81.80956574 | 2021-11-10 04:21:38 | Hardee, Florida, US | |
3643005 | 3643005 | 2021-11-08 | US | Washington | Mason | 53045 | 6090 | 73 | 0 | 47.35007586 | -123.1863685 | 2021-11-09 04:21:36 | Mason, Washington, US | |
3640255 | 3640255 | 2021-11-08 | US | Florida | Hardee | 12049 | 6090 | 45 | 0 | 27.49293939 | -81.80956574 | 2021-11-09 04:21:36 | Hardee, Florida, US | |
2001363 | 2001363 | 2021-11-07 | US | Florida | Hardee | 12049 | 6090 | 45 | 0 | 27.49293939 | -81.80956574 | 2021-11-08 04:21:43 | Hardee, Florida, US | |
496354 | 496354 | 2021-11-06 | US | Florida | Hardee | 12049 | 6090 | 45 | 0 | 27.49293939 | -81.80956574 | 2021-11-07 04:21:53 | Hardee, Florida, US | |
3122209 | 3122209 | 2021-11-05 | US | Florida | Hardee | 12049 | 6090 | 45 | 0 | 27.49293939 | -81.80956574 | 2021-11-06 04:21:51 | Hardee, Florida, US | |
7886 | 7886 | 2021-10-28 | US | Wisconsin | Douglas | 55031 | 6090 | 66 | 0 | 46.43222285 | -91.91595768 | 2021-10-29 04:22:03 | Douglas, Wisconsin, US | |
6086 | 6086 | 2021-10-28 | US | Minnesota | McLeod | 27085 | 6090 | 73 | 0 | 44.82367677 | -94.27287017 | 2021-10-29 04:22:03 | McLeod, Minnesota, US | |
443365 | 443365 | 2021-10-20 | Japan | Nagasaki | 6090 | 73 | 0 | 33.235712 | 129.608033 | 2021-10-21 04:21:18 | Nagasaki, Japan | |||
1495010 | 1495010 | 2021-10-12 | US | Virginia | Shenandoah | 51171 | 6090 | 152 | 0 | 38.85905135 | -78.56813762 | 2021-10-13 04:20:51 | Shenandoah, Virginia, US | |
2132941 | 2132941 | 2021-10-01 | US | Idaho | Bingham | 16011 | 6090 | 94 | 0 | 43.21672879999999 | -112.3978437 | 2021-10-02 04:21:25 | Bingham, Idaho, US | |
2775262 | 2775262 | 2021-09-30 | US | North Carolina | Alexander | 37003 | 6090 | 111 | 0 | 35.922379600000006 | -81.17751948 | 2021-10-01 04:21:35 | Alexander, North Carolina, US | |
3451825 | 3451825 | 2021-09-10 | US | Tennessee | Rhea | 47143 | 6090 | 86 | 0 | 35.60536161 | -84.93076643 | 2021-09-11 04:21:30 | Rhea, Tennessee, US | |
2278930 | 2278930 | 2021-09-08 | Canada | Nova Scotia | 6090 | 94 | 0 | 44.681999999999995 | -63.7443 | 2021-09-09 04:21:27 | Nova Scotia, Canada | |||
250685 | 250685 | 2021-09-04 | US | Kentucky | Graves | 21083 | 6090 | 109 | 0 | 36.72292505 | -88.65143315 | 2021-09-05 04:21:33 | Graves, Kentucky, US | |
1599804 | 1599804 | 2021-08-26 | US | Wyoming | Campbell | 56005 | 6090 | 67 | 0 | 44.24886082 | -105.54744040000001 | 2021-08-27 04:21:37 | Campbell, Wyoming, US | |
1606748 | 1606748 | 2021-08-16 | US | Ohio | Union | 39159 | 6090 | 49 | 0 | 40.30016061 | -83.37239023 | 2021-08-17 04:21:49 | Union, Ohio, US | |
1307224 | 1307224 | 2021-07-27 | US | Indiana | Cass | 18017 | 6090 | 111 | 0 | 40.76135835 | -86.34830753 | 2021-07-28 04:21:39 | Cass, Indiana, US | |
565925 | 565925 | 2021-06-22 | US | Tennessee | Lawrence | 47099 | 6090 | 94 | 0 | 35.21675201 | -87.39787695 | 2021-06-23 04:21:46 | Lawrence, Tennessee, US | |
3361627 | 3361627 | 2021-06-21 | US | Tennessee | Lawrence | 47099 | 6090 | 94 | 0 | 35.21675201 | -87.39787695 | 2021-06-22 04:21:34 | Lawrence, Tennessee, US | |
2719145 | 2719145 | 2021-06-10 | US | New Jersey | Salem | 34033 | 6090 | 185 | 0 | 39.58719656 | -75.34696629999998 | 2021-06-11 04:23:20 | Salem, New Jersey, US | |
2317537 | 2317537 | 2021-06-04 | US | New York | Jefferson | 36045 | 6090 | 68 | 0 | 44.04200959 | -75.94653457 | 2021-06-05 04:23:03 | Jefferson, New York, US | |
22809 | 22809 | 2021-05-28 | US | Ohio | Belmont | 39013 | 6090 | 175 | 0 | 40.01625942 | -80.9924051 | 2021-05-29 04:20:41 | Belmont, Ohio, US | |
2940961 | 2940961 | 2021-05-16 | US | Michigan | Ionia | 26067 | 6090 | 79 | 0 | 42.94502238 | -85.07413319 | 2021-05-17 04:20:34 | Ionia, Michigan, US | |
1874591 | 1874591 | 2021-05-15 | US | Michigan | Ionia | 26067 | 6090 | 79 | 0 | 42.94502238 | -85.07413319 | 2021-05-16 04:20:49 | Ionia, Michigan, US | |
1636798 | 1636798 | 2021-04-29 | US | Arkansas | Greene | 5055 | 6090 | 75 | 0 | 36.11735460000001 | -90.55832668 | 2021-04-30 04:21:03 | Greene, Arkansas, US | |
1571056 | 1571056 | 2021-04-22 | US | Tennessee | Jefferson | 47089 | 6090 | 124 | 0 | 36.04818632 | -83.45148924 | 2021-04-23 04:20:52 | Jefferson, Tennessee, US | |
389842 | 389842 | 2021-04-04 | US | Michigan | Clinton | 26037 | 6090 | 75 | 0 | 42.94400871 | -84.60145248 | 2021-04-05 04:20:35 | Clinton, Michigan, US | |
3711758 | 3711758 | 2021-04-03 | US | Michigan | Clinton | 26037 | 6090 | 75 | 0 | 42.94400871 | -84.60145248 | 2021-04-04 04:20:49 | Clinton, Michigan, US | |
2782427 | 2782427 | 2021-03-24 | US | Kentucky | McCracken | 21145 | 6090 | 112 | 0 | 37.05350953 | -88.70445755 | 2021-03-25 05:27:00 | McCracken, Kentucky, US | |
3623986 | 3623986 | 2021-03-17 | US | Tennessee | Bedford | 47003 | 6090 | 122 | 0 | 35.51123746 | -86.45549096 | 2021-03-18 05:26:22 | Bedford, Tennessee, US | |
2058385 | 2058385 | 2021-03-15 | US | Ohio | Scioto | 39145 | 6090 | 100 | 0 | 38.80270163 | -82.98907345 | 2021-03-16 05:25:13 | Scioto, Ohio, US | |
1841454 | 1841454 | 2021-03-12 | US | Wisconsin | Calumet | 55015 | 6090 | 47 | 0 | 44.0816316 | -88.21780273 | 2021-03-13 05:25:15 | Calumet, Wisconsin, US | |
999499 | 999499 | 2021-03-01 | US | Indiana | Boone | 18011 | 6090 | 88 | 0 | 6002 | 40.0509304 | -86.46841646 | 2021-03-02 05:23:30 | Boone, Indiana, US |
1155940 | 1155940 | 2021-02-18 | US | South Carolina | Laurens | 45059 | 6090 | 150 | 0 | 5940 | 34.48244419 | -82.00490796 | 2021-02-19 05:24:16 | Laurens, South Carolina, US |
1154766 | 1154766 | 2021-02-18 | US | Michigan | Lenawee | 26091 | 6090 | 118 | 0 | 5972 | 41.89475156 | -84.06603727 | 2021-02-19 05:24:16 | Lenawee, Michigan, US |
1459724 | 1459724 | 2021-01-31 | India | Sikkim | 6090 | 134 | 5870 | 86 | 27.571671 | 88.472712 | 2021-02-01 05:22:53 | Sikkim, India | ||
2483051 | 2483051 | 2021-01-28 | US | Indiana | Grant | 18053 | 6090 | 145 | 0 | 5945 | 40.51587228 | -85.65468702 | 2021-01-29 05:22:23 | Grant, Indiana, US |
437807 | 437807 | 2021-01-21 | US | Ohio | Erie | 39043 | 6090 | 138 | 0 | 5952 | 41.36796058 | -82.62904521 | 2021-01-22 05:22:10 | Erie, Ohio, US |
2225206 | 2225206 | 2020-12-26 | US | Minnesota | Clay | 27027 | 6090 | 75 | 0 | 6015 | 46.89289518 | -96.48761922 | 2020-12-27 05:22:55 | Clay, Minnesota, US |
10674 | 10674 | 2020-10-25 | US | North Carolina | Pitt | 37147 | 6090 | 38 | 0 | 6052 | 35.59535426 | -77.37353178 | 2020-10-26 04:25:02 | Pitt, North Carolina, US |
9465 | 9465 | 2020-10-25 | US | Indiana | Vanderburgh | 18163 | 6090 | 76 | 0 | 6014 | 38.02658833 | -87.58763124 | 2020-10-26 04:25:02 | Vanderburgh, Indiana, US |
1054022 | 1054022 | 2020-10-23 | Russia | Kaliningrad Oblast | 6090 | 93 | 4156 | 1841 | 54.7293041 | 21.1489473 | 2020-10-24 04:24:46 | Kaliningrad Oblast, Russia | ||
2605256 | 2605256 | 2020-10-10 | US | Texas | Unassigned | 90048 | 6090 | 0 | 0 | 0 | 36.27829105 | -99.97616148 | 2020-10-11 04:23:46 | Unassigned, Texas, US |
2604325 | 2604325 | 2020-10-10 | US | North Carolina | Cumberland | 37051 | 6090 | 81 | 0 | 6009 | 35.04762133 | -78.82623165 | 2020-10-11 04:23:46 | Cumberland, North Carolina, US |
2814912 | 2814912 | 2020-09-25 | US | New Jersey | Somerset | 34035 | 6090 | 573 | 0 | 5517 | 40.56465737 | -74.61683016 | 2020-09-26 04:23:00 | Somerset, New Jersey, US |
2812948 | 2812948 | 2020-09-25 | Russia | Kalmykia Republic | 6090 | 69 | 3564 | 2457 | 46.2313018 | 45.3275745 | 2020-09-26 04:23:00 | Kalmykia Republic, Russia | ||
3093640 | 3093640 | 2020-09-20 | Russia | Mordovia Republic | 6090 | 40 | 5049 | 1001 | 54.4419829 | 44.4661144 | 2020-09-21 04:23:00 | Mordovia Republic, Russia | ||
3178085 | 3178085 | 2020-08-18 | Mexico | Chiapas | 6090 | 978 | 4995 | 117 | 16.7569 | -93.1292 | 2020-08-19 04:27:00 | Chiapas, Mexico |
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]);