daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
55 rows where confirmed = 12232 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-12-13 | US | Maine | Somerset | 23025 | 12232 | 121 | 0 | 45.51229767 | -69.95995554 | 2022-12-14 04:21:04 | Somerset, Maine, US | |
2022-11-09 | US | Arkansas | Independence | 5063 | 12232 | 226 | 0 | 35.74242707 | -91.57001641 | 2022-11-10 04:21:16 | Independence, Arkansas, US | |
2022-09-21 | US | New York | Otsego | 36077 | 12232 | 98 | 0 | 42.63492579 | -75.03151402 | 2022-09-22 04:22:56 | Otsego, New York, US | |
2022-09-20 | US | Texas | Wilson | 48493 | 12232 | 163 | 0 | 29.1732598 | -98.08693082 | 2022-09-21 04:23:22 | Wilson, Texas, US | |
2022-09-19 | US | Texas | Wilson | 48493 | 12232 | 163 | 0 | 29.1732598 | -98.08693082 | 2022-09-20 04:22:48 | Wilson, Texas, US | |
2022-08-30 | US | North Dakota | Morton | 38059 | 12232 | 142 | 0 | 46.71681782 | -101.2822377 | 2022-08-31 04:20:57 | Morton, North Dakota, US | |
2022-07-20 | US | Oklahoma | McClain | 40087 | 12232 | 139 | 0 | 35.01123903 | -97.44572302 | 2022-07-21 04:21:10 | McClain, Oklahoma, US | |
2022-07-19 | US | Oklahoma | McClain | 40087 | 12232 | 139 | 0 | 35.01123903 | -97.44572302 | 2022-07-20 04:20:59 | McClain, Oklahoma, US | |
2022-07-18 | US | Oklahoma | McClain | 40087 | 12232 | 139 | 0 | 35.01123903 | -97.44572302 | 2022-07-19 04:20:58 | McClain, Oklahoma, US | |
2022-07-17 | US | Oklahoma | McClain | 40087 | 12232 | 139 | 0 | 35.01123903 | -97.44572302 | 2022-07-18 04:20:59 | McClain, Oklahoma, US | |
2022-07-16 | US | Oklahoma | McClain | 40087 | 12232 | 139 | 0 | 35.01123903 | -97.44572302 | 2022-07-17 04:21:15 | McClain, Oklahoma, US | |
2022-07-15 | US | Oklahoma | McClain | 40087 | 12232 | 139 | 0 | 35.01123903 | -97.44572302 | 2022-07-16 04:21:05 | McClain, Oklahoma, US | |
2022-07-14 | US | Oklahoma | McClain | 40087 | 12232 | 139 | 0 | 35.01123903 | -97.44572302 | 2022-07-15 04:20:53 | McClain, Oklahoma, US | |
2022-06-13 | US | Wyoming | Campbell | 56005 | 12232 | 149 | 0 | 44.24886082 | -105.5474404 | 2022-06-14 04:20:52 | Campbell, Wyoming, US | |
2022-06-12 | US | Wyoming | Campbell | 56005 | 12232 | 149 | 0 | 44.24886082 | -105.5474404 | 2022-06-13 04:21:14 | Campbell, Wyoming, US | |
2022-06-11 | US | Wyoming | Campbell | 56005 | 12232 | 149 | 0 | 44.24886082 | -105.5474404 | 2022-06-12 04:20:53 | Campbell, Wyoming, US | |
2022-06-10 | US | Wyoming | Campbell | 56005 | 12232 | 149 | 0 | 44.24886082 | -105.5474404 | 2022-06-11 04:21:01 | Campbell, Wyoming, US | |
2022-06-09 | US | Wyoming | Campbell | 56005 | 12232 | 149 | 0 | 44.24886082 | -105.5474404 | 2022-06-10 04:20:55 | Campbell, Wyoming, US | |
2022-06-08 | US | Wyoming | Campbell | 56005 | 12232 | 149 | 0 | 44.24886082 | -105.5474404 | 2022-06-09 04:20:54 | Campbell, Wyoming, US | |
2022-06-07 | US | Wyoming | Campbell | 56005 | 12232 | 149 | 0 | 44.24886082 | -105.5474404 | 2022-06-08 04:20:55 | Campbell, Wyoming, US | |
2022-06-02 | US | Illinois | Clinton | 17027 | 12232 | 113 | 0 | 38.60704876 | -89.42385254 | 2022-06-03 04:20:58 | Clinton, Illinois, US | |
2022-03-29 | US | Texas | Nacogdoches | 48347 | 12232 | 256 | 0 | 31.62017125 | -94.61803994 | 2022-03-30 04:20:45 | Nacogdoches, Texas, US | |
2022-03-14 | Japan | Port Quarantine | 12232 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2022-03-13 | Japan | Port Quarantine | 12232 | 7 | 0 | 2021-11-10 23:21:44 | Port Quarantine, Japan | |||||
2022-03-10 | US | Vermont | Rutland | 50021 | 12232 | 71 | 0 | 43.57723578 | -73.03741676 | 2022-03-11 04:20:50 | Rutland, Vermont, US | |
2022-02-24 | US | Ohio | Washington | 39167 | 12232 | 206 | 0 | 39.45690571 | -81.49121382 | 2022-02-25 04:21:11 | Washington, Ohio, US | |
2022-01-31 | US | Louisiana | Washington | 22117 | 12232 | 230 | 0 | 30.85288548 | -90.03866652 | 2022-02-01 04:21:11 | Washington, Louisiana, US | |
2022-01-03 | US | Minnesota | Crow Wing | 27035 | 12232 | 139 | 0 | 46.48096553 | -94.06755609 | 2022-01-04 04:22:17 | Crow Wing, Minnesota, US | |
2021-12-14 | US | Ohio | Ross | 39141 | 12232 | 242 | 0 | 39.33705391 | -83.06000914 | 2021-12-15 03:22:16 | Ross, Ohio, US | |
2021-10-20 | US | Texas | Coryell | 48099 | 12232 | 154 | 0 | 31.39078397 | -97.79936155 | 2021-10-21 04:21:18 | Coryell, Texas, US | |
2021-09-20 | US | Texas | Walker | 48471 | 12232 | 155 | 0 | 30.73872995 | -95.57440968 | 2021-09-21 04:21:26 | Walker, Texas, US | |
2021-08-08 | US | Tennessee | Putnam | 47141 | 12232 | 182 | 0 | 36.14005459 | -85.50646123 | 2021-08-09 04:21:24 | Putnam, Tennessee, US | |
2021-08-05 | US | Pennsylvania | Lycoming | 42081 | 12232 | 299 | 0 | 41.34310539 | -77.06629984 | 2021-08-06 04:21:18 | Lycoming, Pennsylvania, US | |
2021-08-01 | US | Louisiana | Lafourche | 22057 | 12232 | 209 | 0 | 29.52470226 | -90.40976986 | 2021-08-02 04:21:36 | Lafourche, Louisiana, US | |
2021-07-31 | US | Louisiana | Lafourche | 22057 | 12232 | 209 | 0 | 29.52470226 | -90.40976986 | 2021-08-01 04:21:50 | Lafourche, Louisiana, US | |
2021-07-30 | US | Louisiana | Lafourche | 22057 | 12232 | 209 | 0 | 29.52470226 | -90.40976986 | 2021-07-31 04:21:35 | Lafourche, Louisiana, US | |
2021-06-23 | US | New Mexico | Sandoval | 35043 | 12232 | 241 | 0 | 35.68862401 | -106.8687803 | 2021-06-24 04:21:55 | Sandoval, New Mexico, US | |
2021-05-27 | US | Tennessee | Unassigned | 90047 | 12232 | 132 | 0 | 36.55606529 | 0.0 | 2021-05-28 04:20:36 | Unassigned, Tennessee, US | |
2021-05-11 | US | Alabama | Marshall | 1095 | 12232 | 223 | 0 | 34.36975964 | -86.30486727 | 2021-05-12 04:21:29 | Marshall, Alabama, US | |
2021-04-27 | Japan | Okinawa | 12232 | 134 | 10881 | 1217 | 25.768923 | 126.668016 | 2021-04-28 04:20:32 | Okinawa, Japan | ||
2021-03-25 | US | Minnesota | Olmsted | 27109 | 12232 | 93 | 0 | 44.00374114 | -92.40209944 | 2021-03-26 05:26:55 | Olmsted, Minnesota, US | |
2021-03-02 | US | Missouri | Jasper | 29097 | 12232 | 219 | 0 | 12013 | 37.20351921 | -94.34050458 | 2021-03-03 05:23:28 | Jasper, Missouri, US |
2021-02-21 | US | Maryland | Washington | 24043 | 12232 | 248 | 0 | 11984 | 39.60835778 | -77.82002295 | 2021-02-22 05:24:21 | Washington, Maryland, US |
2021-01-03 | US | Tennessee | Montgomery | 47125 | 12232 | 128 | 0 | 11898 | 36.49609412 | -87.38550661 | 2021-01-04 05:22:02 | Montgomery, Tennessee, US |
2021-01-01 | US | Michigan | Kalamazoo | 26077 | 12232 | 240 | 0 | 11992 | 42.24542231 | -85.53038622 | 2021-01-02 05:22:33 | Kalamazoo, Michigan, US |
2020-12-31 | US | Michigan | Kalamazoo | 26077 | 12232 | 240 | 0 | 11992 | 42.24542231 | -85.53038622 | 2021-01-01 05:23:07 | Kalamazoo, Michigan, US |
2020-12-30 | US | Michigan | Kalamazoo | 26077 | 12232 | 240 | 0 | 11992 | 42.24542231 | -85.53038622 | 2020-12-31 05:22:49 | Kalamazoo, Michigan, US |
2020-12-30 | US | Iowa | Woodbury | 19193 | 12232 | 165 | 0 | 12067 | 42.38979414 | -96.0459439 | 2020-12-31 05:22:49 | Woodbury, Iowa, US |
2020-12-18 | Germany | Bremen | 12232 | 165 | 10378 | 1825 | 53.0793 | 8.8017 | 2020-12-19 05:27:52 | Bremen, Germany | ||
2020-12-01 | US | North Dakota | Burleigh | 38015 | 12232 | 123 | 0 | 11913 | 46.97847375 | -100.4645214 | 2020-12-02 05:27:41 | Burleigh, North Dakota, US |
2020-11-02 | Russia | Orel Oblast | 12232 | 158 | 9056 | 3018 | 52.96854329999999 | 36.0692477 | 2020-11-03 06:00:16 | Orel Oblast, Russia | ||
2020-09-13 | Spain | Navarra | 12232 | 542 | 3905 | 7785 | 42.6954 | -1.6761 | 2020-09-14 04:26:00 | Navarra, Spain | ||
2020-09-12 | Spain | Navarra | 12232 | 542 | 3905 | 7785 | 42.6954 | -1.6761 | 2020-09-13 04:30:52 | Navarra, Spain | ||
2020-09-11 | Spain | Navarra | 12232 | 542 | 3905 | 7785 | 42.6954 | -1.6761 | 2020-09-12 04:25:05 | Navarra, Spain | ||
2020-08-17 | Chile | OHiggins | 12232 | 304 | 11097 | 831 | -34.5755 | -71.0022 | 2020-08-18 04:27:56 | OHiggins, Chile |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;