johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
69 rows where confirmed = 7692 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753255 | 2753255 | 2022-12-29 | US | Alabama | Bibb | 1007 | 7692 | 108 | 0 | 32.99642064 | -87.1251146 | 2022-12-30 04:21:04 | Bibb, Alabama, US | |
1074261 | 1074261 | 2022-12-28 | US | Alabama | Bibb | 1007 | 7692 | 108 | 0 | 32.99642064 | -87.1251146 | 2022-12-29 04:21:01 | Bibb, Alabama, US | |
328258 | 328258 | 2022-12-27 | US | Alabama | Bibb | 1007 | 7692 | 108 | 0 | 32.99642064 | -87.1251146 | 2022-12-28 04:21:04 | Bibb, Alabama, US | |
218331 | 218331 | 2022-12-26 | US | Alabama | Bibb | 1007 | 7692 | 108 | 0 | 32.99642064 | -87.1251146 | 2022-12-27 04:21:07 | Bibb, Alabama, US | |
3222788 | 3222788 | 2022-12-25 | US | Alabama | Bibb | 1007 | 7692 | 108 | 0 | 32.99642064 | -87.1251146 | 2022-12-26 04:21:06 | Bibb, Alabama, US | |
1018702 | 1018702 | 2022-12-24 | US | Alabama | Bibb | 1007 | 7692 | 108 | 0 | 32.99642064 | -87.1251146 | 2022-12-25 04:21:04 | Bibb, Alabama, US | |
690725 | 690725 | 2022-12-23 | US | Alabama | Bibb | 1007 | 7692 | 108 | 0 | 32.99642064 | -87.1251146 | 2022-12-24 04:21:02 | Bibb, Alabama, US | |
2179935 | 2179935 | 2022-12-22 | US | Alabama | Bibb | 1007 | 7692 | 108 | 0 | 32.99642064 | -87.1251146 | 2022-12-23 04:21:04 | Bibb, Alabama, US | |
451739 | 451739 | 2022-12-21 | US | Alabama | Bibb | 1007 | 7692 | 108 | 0 | 32.99642064 | -87.1251146 | 2022-12-22 04:20:56 | Bibb, Alabama, US | |
1625379 | 1625379 | 2022-09-22 | US | Indiana | Fayette | 18041 | 7692 | 152 | 0 | 39.63684962 | -85.17797541 | 2022-09-23 04:23:13 | Fayette, Indiana, US | |
1371583 | 1371583 | 2022-09-21 | US | Indiana | Fayette | 18041 | 7692 | 152 | 0 | 39.63684962 | -85.17797541 | 2022-09-22 04:22:56 | Fayette, Indiana, US | |
256507 | 256507 | 2022-09-08 | US | Texas | Palo Pinto | 48363 | 7692 | 155 | 0 | 32.75310985 | -98.31319001 | 2022-09-09 04:21:11 | Palo Pinto, Texas, US | |
3774556 | 3774556 | 2022-08-30 | US | Colorado | Pitkin | 8097 | 7692 | 8 | 0 | 39.21720112 | -106.9310027 | 2022-08-31 04:20:57 | Pitkin, Colorado, US | |
2854375 | 2854375 | 2022-08-22 | US | Louisiana | Jefferson Davis | 22053 | 7692 | 166 | 0 | 30.26896765 | -92.81210004 | 2022-08-23 04:20:56 | Jefferson Davis, Louisiana, US | |
1348478 | 1348478 | 2022-08-10 | US | New Hampshire | Coos | 33007 | 7692 | 120 | 0 | 44.69063265 | -71.30633239 | 2022-08-11 04:20:49 | Coos, New Hampshire, US | |
1491128 | 1491128 | 2022-07-26 | US | Wisconsin | Door | 55029 | 7692 | 73 | 0 | 44.95856458 | -87.30002707 | 2022-07-27 04:21:04 | Door, Wisconsin, US | |
950209 | 950209 | 2022-06-14 | US | Virginia | Isle of Wight | 51093 | 7692 | 118 | 0 | 36.90579348 | -76.70842863 | 2022-06-15 04:20:54 | Isle of Wight, Virginia, US | |
232176 | 232176 | 2022-05-31 | US | Tennessee | Hardeman | 47069 | 7692 | 118 | 0 | 35.20772017 | -88.99161161 | 2022-06-01 04:20:55 | Hardeman, Tennessee, US | |
2752008 | 2752008 | 2022-04-04 | US | Texas | Hockley | 48219 | 7692 | 161 | 0 | 33.60771256 | -102.3431676 | 2022-04-05 04:20:48 | Hockley, Texas, US | |
3733354 | 3733354 | 2022-04-03 | US | Texas | Hockley | 48219 | 7692 | 161 | 0 | 33.60771256 | -102.3431676 | 2022-04-04 04:20:51 | Hockley, Texas, US | |
502789 | 502789 | 2022-04-02 | US | Texas | Hockley | 48219 | 7692 | 161 | 0 | 33.60771256 | -102.3431676 | 2022-04-03 04:20:48 | Hockley, Texas, US | |
2200959 | 2200959 | 2022-03-06 | US | Kansas | Miami | 20121 | 7692 | 87 | 0 | 38.56383358 | -94.83832189 | 2022-03-07 04:20:47 | Miami, Kansas, US | |
2093416 | 2093416 | 2022-03-05 | US | Kansas | Miami | 20121 | 7692 | 87 | 0 | 38.56383358 | -94.83832189 | 2022-03-06 04:20:49 | Miami, Kansas, US | |
2667116 | 2667116 | 2022-03-04 | US | Kansas | Miami | 20121 | 7692 | 87 | 0 | 38.56383358 | -94.83832189 | 2022-03-05 04:21:10 | Miami, Kansas, US | |
1645681 | 1645681 | 2022-03-03 | US | Kansas | Miami | 20121 | 7692 | 87 | 0 | 38.56383358 | -94.83832189 | 2022-03-04 04:21:09 | Miami, Kansas, US | |
2526684 | 2526684 | 2022-03-02 | US | Kansas | Miami | 20121 | 7692 | 87 | 0 | 38.56383358 | -94.83832189 | 2022-03-03 04:21:01 | Miami, Kansas, US | |
1059771 | 1059771 | 2022-02-23 | US | Missouri | Lafayette | 29107 | 7692 | 118 | 0 | 39.06986886 | -93.78076396 | 2022-02-24 04:21:14 | Lafayette, Missouri, US | |
1466788 | 1466788 | 2022-02-10 | US | Pennsylvania | Tioga | 42117 | 7692 | 187 | 0 | 41.77255149 | -77.25433032 | 2022-02-11 04:21:09 | Tioga, Pennsylvania, US | |
1295987 | 1295987 | 2022-02-05 | US | Missouri | Polk | 29167 | 7692 | 84 | 0 | 37.616229600000004 | -93.39828174 | 2022-02-06 04:21:00 | Polk, Missouri, US | |
1144482 | 1144482 | 2022-01-23 | US | Wisconsin | Oneida | 55085 | 7692 | 120 | 0 | 45.70677897 | -89.51944105 | 2022-01-24 04:21:12 | Oneida, Wisconsin, US | |
2836400 | 2836400 | 2022-01-22 | US | Wisconsin | Oneida | 55085 | 7692 | 120 | 0 | 45.70677897 | -89.51944105 | 2022-01-23 04:21:13 | Oneida, Wisconsin, US | |
3428518 | 3428518 | 2022-01-21 | US | Wisconsin | Oneida | 55085 | 7692 | 120 | 0 | 45.70677897 | -89.51944105 | 2022-01-22 04:21:13 | Oneida, Wisconsin, US | |
3522468 | 3522468 | 2022-01-02 | US | Texas | Brown | 48049 | 7692 | 176 | 0 | 31.77430356 | -98.99907113 | 2022-01-03 02:22:25 | Brown, Texas, US | |
1669116 | 1669116 | 2021-12-29 | US | Colorado | Summit | 8117 | 7692 | 12 | 0 | 39.63803232 | -106.1150762 | 2021-12-30 04:21:25 | Summit, Colorado, US | |
1255608 | 1255608 | 2021-12-20 | US | Georgia | Liberty | 13179 | 7692 | 132 | 0 | 31.82588896 | -81.49251135 | 2021-12-21 03:21:27 | Liberty, Georgia, US | |
2904530 | 2904530 | 2021-12-19 | US | Georgia | Habersham | 13137 | 7692 | 216 | 0 | 34.63331566 | -83.53094677 | 2021-12-20 04:21:43 | Habersham, Georgia, US | |
1259603 | 1259603 | 2021-12-18 | US | Georgia | Habersham | 13137 | 7692 | 216 | 0 | 34.63331566 | -83.53094677 | 2021-12-19 04:21:11 | Habersham, Georgia, US | |
2399631 | 2399631 | 2021-12-17 | US | Georgia | Habersham | 13137 | 7692 | 216 | 0 | 34.63331566 | -83.53094677 | 2021-12-18 02:22:20 | Habersham, Georgia, US | |
2845346 | 2845346 | 2021-11-10 | US | Arkansas | Hot Spring | 5059 | 7692 | 107 | 0 | 34.31709259 | -92.95396325 | 2021-11-11 04:21:45 | Hot Spring, Arkansas, US | |
2460160 | 2460160 | 2021-10-06 | US | Kentucky | Barren | 21009 | 7692 | 124 | 0 | 36.96469836 | -85.93338945 | 2021-10-07 04:21:36 | Barren, Kentucky, US | |
1275756 | 1275756 | 2021-10-03 | US | Kentucky | Scott | 21209 | 7692 | 42 | 0 | 38.29622293 | -84.5816631 | 2021-10-04 04:21:31 | Scott, Kentucky, US | |
3930564 | 3930564 | 2021-10-02 | US | Ohio | Washington | 39167 | 7692 | 142 | 0 | 39.45690571 | -81.49121382 | 2021-10-03 04:21:24 | Washington, Ohio, US | |
1885613 | 1885613 | 2021-09-12 | US | Colorado | Eagle | 8037 | 7692 | 31 | 0 | 39.62754308 | -106.6933637 | 2021-09-13 04:21:15 | Eagle, Colorado, US | |
2070235 | 2070235 | 2021-08-31 | US | North Carolina | Lee | 37105 | 7692 | 89 | 0 | 35.47623147 | -79.17569362 | 2021-09-01 04:21:38 | Lee, North Carolina, US | |
2923210 | 2923210 | 2021-08-27 | Japan | Kagoshima | 7692 | 44 | 0 | 31.009484000000004 | 130.430665 | 2021-08-28 04:21:28 | Kagoshima, Japan | |||
247519 | 247519 | 2021-08-17 | US | New York | Ontario | 36069 | 7692 | 93 | 0 | 42.85145728 | -77.30874425 | 2021-08-18 04:21:35 | Ontario, New York, US | |
103703 | 103703 | 2021-08-15 | US | Alabama | Jackson | 1071 | 7692 | 122 | 0 | 34.78144169 | -85.99750489 | 2021-08-16 04:21:31 | Jackson, Alabama, US | |
2903257 | 2903257 | 2021-08-12 | US | Wisconsin | Portage | 55097 | 7692 | 77 | 0 | 44.47558711 | -89.50152965 | 2021-08-13 04:21:24 | Portage, Wisconsin, US | |
3478009 | 3478009 | 2021-07-22 | US | Minnesota | Blue Earth | 27013 | 7692 | 44 | 0 | 44.03554215 | -94.06699781 | 2021-07-23 04:21:29 | Blue Earth, Minnesota, US | |
2768203 | 2768203 | 2021-07-01 | US | Utah | Tooele | 49045 | 7692 | 45 | 0 | 40.44862644 | -113.1295715 | 2021-07-02 04:21:47 | Tooele, Utah, US | |
108239 | 108239 | 2021-06-19 | US | Georgia | Dougherty | 13095 | 7692 | 311 | 0 | 31.53328528 | -84.21722377 | 2021-06-20 04:21:48 | Dougherty, Georgia, US | |
2911960 | 2911960 | 2021-06-17 | US | Georgia | Dougherty | 13095 | 7692 | 311 | 0 | 31.53328528 | -84.21722377 | 2021-06-18 04:22:16 | Dougherty, Georgia, US | |
1451609 | 1451609 | 2021-06-03 | US | Texas | Bowie | 48037 | 7692 | 221 | 0 | 33.44626922 | -94.41834132 | 2021-06-04 04:23:37 | Bowie, Texas, US | |
2391849 | 2391849 | 2021-05-18 | US | Indiana | Floyd | 18043 | 7692 | 178 | 0 | 38.32117957 | -85.90385377 | 2021-05-19 04:20:42 | Floyd, Indiana, US | |
2023080 | 2023080 | 2021-04-20 | US | North Carolina | Sampson | 37163 | 7692 | 106 | 0 | 34.98820368 | -78.36914061 | 2021-04-21 04:21:14 | Sampson, North Carolina, US | |
1291063 | 1291063 | 2021-03-29 | US | Indiana | Bartholomew | 18005 | 7692 | 151 | 0 | 39.20744865 | -85.89558181 | 2021-03-30 04:26:23 | Bartholomew, Indiana, US | |
530822 | 530822 | 2021-02-22 | Netherlands | Aruba | 7692 | 71 | 7361 | 260 | 12.5211 | -69.9683 | 2021-02-23 05:23:41 | Aruba, Netherlands | ||
435344 | 435344 | 2021-01-21 | Italy | Molise | 7692 | 243 | 6404 | 1045 | 41.55774754 | 14.65916051 | 2021-01-22 05:22:10 | Molise, Italy | ||
3517971 | 3517971 | 2021-01-15 | US | Oklahoma | Muskogee | 40101 | 7692 | 58 | 0 | 7634 | 35.61318461 | -95.37802952 | 2021-01-16 05:22:40 | Muskogee, Oklahoma, US |
2130313 | 2130313 | 2020-12-17 | US | North Carolina | Iredell | 37097 | 7692 | 61 | 0 | 7631 | 35.80950511 | -80.8743128 | 2020-12-18 05:28:18 | Iredell, North Carolina, US |
846341 | 846341 | 2020-12-12 | US | Georgia | Columbia | 13073 | 7692 | 90 | 0 | 7602 | 33.54534185 | -82.263524 | 2020-12-13 05:27:20 | Columbia, Georgia, US |
2539819 | 2539819 | 2020-12-01 | US | North Dakota | Ward | 38101 | 7692 | 136 | 0 | 7500 | 48.22390169 | -101.5436763 | 2020-12-02 05:27:41 | Ward, North Dakota, US |
3839603 | 3839603 | 2020-11-21 | US | Texas | Jefferson | 48245 | 7692 | 172 | 0 | 9632 | 29.8832777 | -94.16434171 | 2020-11-22 05:25:45 | Jefferson, Texas, US |
1990299 | 1990299 | 2020-11-09 | US | Michigan | Ottawa | 26139 | 7692 | 89 | 0 | 7603 | 42.95996803 | -85.9969107 | 2020-11-10 05:40:07 | Ottawa, Michigan, US |
786623 | 786623 | 2020-10-15 | Russia | Tatarstan Republic | 7692 | 82 | 6579 | 1031 | 55.7648572 | 52.43104273 | 2020-10-16 04:24:01 | Tatarstan Republic, Russia | ||
968593 | 968593 | 2020-09-29 | US | Minnesota | Dakota | 27037 | 7692 | 126 | 0 | 7566 | 44.67172617 | -93.06299363 | 2020-09-30 04:23:33 | Dakota, Minnesota, US |
1354435 | 1354435 | 2020-09-03 | Netherlands | Gelderland | 7692 | 691 | 0 | 6864 | 52.061738 | 5.939114 | 2020-09-04 04:28:26 | Gelderland, Netherlands | ||
2059993 | 2059993 | 2020-09-01 | Namibia | 7692 | 81 | 3379 | 4232 | -22.9576 | 18.4904 | 2020-09-02 04:28:25 | Namibia | |||
2898046 | 2898046 | 2020-05-09 | US | Michigan | Oakland | 26125 | 7692 | 841 | 0 | 6851 | 42.66090111 | -83.38595416 | 2020-05-10 02:32:30 | Oakland, Michigan, 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]);