johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where confirmed = 16716 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1151103 | 1151103 | 2022-12-12 | US | New Hampshire | Belknap | 33001 | 16716 | 202 | 0 | 43.51637314 | -71.41684235 | 2022-12-13 04:21:01 | Belknap, New Hampshire, US | |
3100638 | 3100638 | 2022-10-09 | US | Texas | Orange | 48361 | 16716 | 370 | 0 | 30.11879481 | -93.89412775 | 2022-10-10 04:22:32 | Orange, Texas, US | |
4005863 | 4005863 | 2022-10-08 | US | Texas | Orange | 48361 | 16716 | 370 | 0 | 30.11879481 | -93.89412775 | 2022-10-09 04:21:16 | Orange, Texas, US | |
399460 | 399460 | 2022-10-07 | US | Texas | Orange | 48361 | 16716 | 370 | 0 | 30.11879481 | -93.89412775 | 2022-10-08 04:22:56 | Orange, Texas, US | |
3769369 | 3769369 | 2022-09-11 | US | West Virginia | Jefferson | 54037 | 16716 | 137 | 0 | 39.30776166 | -77.86014147 | 2022-09-12 04:20:58 | Jefferson, West Virginia, US | |
3768919 | 3768919 | 2022-09-11 | US | Texas | Caldwell | 48055 | 16716 | 183 | 0 | 29.83668859 | -97.61814775 | 2022-09-12 04:20:58 | Caldwell, Texas, US | |
3827944 | 3827944 | 2022-09-10 | US | West Virginia | Jefferson | 54037 | 16716 | 137 | 0 | 39.30776166 | -77.86014147 | 2022-09-11 04:20:50 | Jefferson, West Virginia, US | |
3827494 | 3827494 | 2022-09-10 | US | Texas | Caldwell | 48055 | 16716 | 183 | 0 | 29.83668859 | -97.61814775 | 2022-09-11 04:20:50 | Caldwell, Texas, US | |
966401 | 966401 | 2022-09-09 | US | West Virginia | Jefferson | 54037 | 16716 | 137 | 0 | 39.30776166 | -77.86014147 | 2022-09-10 04:21:10 | Jefferson, West Virginia, US | |
965951 | 965951 | 2022-09-09 | US | Texas | Caldwell | 48055 | 16716 | 183 | 0 | 29.83668859 | -97.61814775 | 2022-09-10 04:21:10 | Caldwell, Texas, US | |
2743949 | 2743949 | 2022-07-07 | US | Tennessee | Dickson | 47043 | 16716 | 245 | 0 | 36.14669837 | -87.35891709 | 2022-07-08 04:20:56 | Dickson, Tennessee, US | |
2151179 | 2151179 | 2022-06-27 | US | Wisconsin | Columbia | 55021 | 16716 | 132 | 0 | 43.46492199 | -89.33589004 | 2022-06-28 04:20:58 | Columbia, Wisconsin, US | |
363315 | 363315 | 2022-05-07 | US | Tennessee | McMinn | 47107 | 16716 | 260 | 0 | 35.42812616 | -84.61520715 | 2022-05-08 04:20:49 | McMinn, Tennessee, US | |
3916653 | 3916653 | 2022-05-01 | US | Colorado | Eagle | 8037 | 16716 | 35 | 0 | 39.62754308 | -106.6933637 | 2022-05-02 04:21:10 | Eagle, Colorado, US | |
2032279 | 2032279 | 2022-04-24 | US | West Virginia | Putnam | 54079 | 16716 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-04-25 04:20:56 | Putnam, West Virginia, US | |
749854 | 749854 | 2022-04-23 | US | West Virginia | Putnam | 54079 | 16716 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-04-24 04:20:56 | Putnam, West Virginia, US | |
3440339 | 3440339 | 2022-04-22 | US | West Virginia | Putnam | 54079 | 16716 | 176 | 0 | 38.50782345 | -81.9082131 | 2022-04-23 04:20:50 | Putnam, West Virginia, US | |
1061110 | 1061110 | 2022-02-23 | US | Texas | Wise | 48497 | 16716 | 253 | 0 | 33.21570665 | -97.65460265 | 2022-02-24 04:21:14 | Wise, Texas, US | |
733221 | 733221 | 2021-12-27 | US | Pennsylvania | Northumberland | 42097 | 16716 | 464 | 0 | 40.84785433 | -76.70798222 | 2021-12-28 04:21:47 | Northumberland, Pennsylvania, US | |
1716473 | 1716473 | 2021-12-16 | Netherlands | Aruba | 16716 | 178 | 0 | 12.5211 | -69.9683 | 2021-12-17 04:22:14 | Aruba, Netherlands | |||
1145944 | 1145944 | 2021-12-01 | US | Illinois | Macon | 17115 | 16716 | 261 | 0 | 39.86064913 | -88.96342505 | 2021-12-02 04:22:37 | Macon, Illinois, US | |
1016596 | 1016596 | 2021-11-21 | US | New York | Rensselaer | 36083 | 16716 | 189 | 0 | 42.71348136 | -73.51089874 | 2021-11-22 04:22:20 | Rensselaer, New York, US | |
3342692 | 3342692 | 2021-11-16 | Mali | 16716 | 589 | 0 | 17.570692 | -3.996166000000001 | 2021-11-17 04:21:48 | Mali | ||||
2675391 | 2675391 | 2021-07-18 | US | Maryland | Harford | 24025 | 16716 | 302 | 0 | 39.55010644 | -76.30775940000002 | 2021-07-19 04:21:24 | Harford, Maryland, US | |
3031939 | 3031939 | 2021-06-16 | US | Michigan | Livingston | 26093 | 16716 | 194 | 0 | 42.60302282 | -83.91297209 | 2021-06-17 04:22:36 | Livingston, Michigan, US | |
3620931 | 3620931 | 2021-03-17 | Colombia | La Guajira | 16716 | 643 | 15787 | 286 | 11.3548 | -72.5205 | 2021-03-18 05:26:22 | La Guajira, Colombia | ||
2368175 | 2368175 | 2021-02-28 | US | Florida | Clay | 12019 | 16716 | 304 | 0 | 16412 | 29.98319144 | -81.85609986 | 2021-03-01 05:23:01 | Clay, Florida, US |
743337 | 743337 | 2021-02-20 | US | Illinois | Peoria | 17143 | 16716 | 258 | 0 | 16458 | 40.78702156 | -89.76078901 | 2021-02-21 05:24:33 | Peoria, Illinois, US |
3603700 | 3603700 | 2021-02-17 | US | Pennsylvania | Erie | 42049 | 16716 | 369 | 0 | 16347 | 41.99253829 | -80.03301954 | 2021-02-18 05:22:58 | Erie, Pennsylvania, US |
3981887 | 3981887 | 2021-02-10 | US | Virginia | Chesapeake | 51550 | 16716 | 143 | 0 | 16573 | 36.67670048 | -76.30545744 | 2021-02-11 05:23:55 | Chesapeake, Virginia, US |
2975946 | 2975946 | 2020-12-09 | US | Florida | Pasco | 12101 | 16716 | 306 | 0 | 16410 | 28.30810945 | -82.40227529 | 2020-12-10 05:26:19 | Pasco, Florida, US |
3304086 | 3304086 | 2020-11-02 | Finland | 16716 | 350 | 11300 | 4741 | 61.92411 | 25.748151 | 2020-11-03 06:00:16 | Finland | |||
1796793 | 1796793 | 2020-10-19 | US | New Jersey | Ocean | 34029 | 16716 | 1054 | 0 | 15662 | 39.8895449 | -74.28089251 | 2020-10-20 04:24:22 | Ocean, New Jersey, US |
1444740 | 1444740 | 2020-09-11 | Peru | Junin | 16716 | 1941 | 0 | 14775 | -11.541783 | -74.876968 | 2020-09-12 04:25:05 | Junin, Peru | ||
1106325 | 1106325 | 2020-09-02 | US | Georgia | DeKalb | 13089 | 16716 | 309 | 0 | 16407 | 33.76944049 | -84.22396017 | 2020-09-03 04:28:22 | DeKalb, Georgia, 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]);