johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
35 rows where confirmed = 16626 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311203 | 311203 | 2022-12-13 | US | Virginia | Campbell | 51031 | 16626 | 233 | 0 | 37.20553386 | -79.09678609 | 2022-12-14 04:21:04 | Campbell, Virginia, US | |
618460 | 618460 | 2022-11-05 | US | California | Tuolumne | 6109 | 16626 | 196 | 0 | 38.02644018 | -119.9525093 | 2022-11-06 04:21:24 | Tuolumne, California, US | |
1022964 | 1022964 | 2022-11-04 | US | California | Tuolumne | 6109 | 16626 | 196 | 0 | 38.02644018 | -119.9525093 | 2022-11-05 04:21:52 | Tuolumne, California, US | |
322950 | 322950 | 2022-10-30 | US | Texas | Angelina | 48005 | 16626 | 496 | 0 | 31.25457347 | -94.60901487 | 2022-10-31 04:21:36 | Angelina, Texas, US | |
915226 | 915226 | 2022-10-29 | US | Texas | Angelina | 48005 | 16626 | 496 | 0 | 31.25457347 | -94.60901487 | 2022-10-30 04:22:14 | Angelina, Texas, US | |
1369495 | 1369495 | 2022-10-28 | US | Texas | Angelina | 48005 | 16626 | 496 | 0 | 31.25457347 | -94.60901487 | 2022-10-29 04:21:13 | Angelina, Texas, US | |
2636763 | 2636763 | 2022-09-05 | US | Texas | Caldwell | 48055 | 16626 | 183 | 0 | 29.83668859 | -97.61814775 | 2022-09-06 04:21:02 | Caldwell, Texas, US | |
2990327 | 2990327 | 2022-09-04 | US | Texas | Caldwell | 48055 | 16626 | 183 | 0 | 29.83668859 | -97.61814775 | 2022-09-05 04:21:01 | Caldwell, Texas, US | |
2716012 | 2716012 | 2022-09-03 | US | Texas | Caldwell | 48055 | 16626 | 183 | 0 | 29.83668859 | -97.61814775 | 2022-09-04 04:21:22 | Caldwell, Texas, US | |
1396717 | 1396717 | 2022-09-02 | US | Texas | Caldwell | 48055 | 16626 | 183 | 0 | 29.83668859 | -97.61814775 | 2022-09-03 04:21:04 | Caldwell, Texas, US | |
3618058 | 3618058 | 2022-08-01 | US | Illinois | Coles | 17029 | 16626 | 174 | 0 | 39.51949084 | -88.22358557 | 2022-08-02 04:20:53 | Coles, Illinois, US | |
3429445 | 3429445 | 2022-07-14 | US | Arkansas | Crawford | 5033 | 16626 | 253 | 0 | 35.58928601 | -94.2446814 | 2022-07-15 04:20:53 | Crawford, Arkansas, US | |
1200869 | 1200869 | 2022-07-06 | US | Illinois | Whiteside | 17195 | 16626 | 230 | 0 | 41.75509713 | -89.91556058 | 2022-07-07 04:20:55 | Whiteside, Illinois, US | |
1506524 | 1506524 | 2022-05-16 | US | Tennessee | Carter | 47019 | 16626 | 336 | 0 | 36.28969086 | -82.12588974 | 2022-05-17 04:20:59 | Carter, Tennessee, US | |
1868785 | 1868785 | 2022-03-10 | US | Virginia | Bedford | 51019 | 16626 | 221 | 0 | 37.3080028 | -79.5281964 | 2022-03-11 04:20:50 | Bedford, Virginia, US | |
2051764 | 2051764 | 2022-01-25 | France | New Caledonia | 16626 | 283 | 0 | -20.904304999999997 | 165.618042 | 2022-01-26 04:21:07 | New Caledonia, France | |||
1031333 | 1031333 | 2021-12-06 | US | Idaho | Twin Falls | 16083 | 16626 | 233 | 0 | 42.35440512 | -114.6685381 | 2021-12-07 04:22:34 | Twin Falls, Idaho, US | |
664 | 664 | 2021-12-02 | Taiwan* | 16626 | 848 | 0 | 23.7 | 121.0 | 2021-12-03 04:23:05 | Taiwan* | ||||
3977552 | 3977552 | 2021-09-03 | US | Tennessee | Sevier | 47155 | 16626 | 199 | 0 | 35.78077323 | -83.52244332 | 2021-09-04 04:21:28 | Sevier, Tennessee, US | |
1856992 | 1856992 | 2021-08-20 | US | Tennessee | Washington | 47179 | 16626 | 261 | 0 | 36.29472368 | -82.49454720000001 | 2021-08-21 04:21:38 | Washington, Tennessee, US | |
335464 | 335464 | 2021-08-04 | US | Wisconsin | Marathon | 55073 | 16626 | 229 | 0 | 44.89792533 | -89.75863384 | 2021-08-05 04:21:51 | Marathon, Wisconsin, US | |
1127171 | 1127171 | 2021-06-18 | US | Maryland | Harford | 24025 | 16626 | 298 | 0 | 39.55010644 | -76.30775940000002 | 2021-06-19 04:22:33 | Harford, Maryland, US | |
2912749 | 2912749 | 2021-06-17 | US | Maryland | Harford | 24025 | 16626 | 297 | 0 | 39.55010644 | -76.30775940000002 | 2021-06-18 04:22:16 | Harford, Maryland, US | |
1412436 | 1412436 | 2021-04-23 | US | Virginia | Richmond City | 51760 | 16626 | 256 | 0 | 37.53255773 | -77.47966921 | 2021-04-24 04:20:38 | Richmond City, Virginia, US | |
3539249 | 3539249 | 2021-02-12 | Chile | Los Rios | 16626 | 190 | 15424 | 1012 | -40.231 | -72.3311 | 2021-02-13 05:22:12 | Los Rios, Chile | ||
1897308 | 1897308 | 2021-01-29 | Peru | Ayacucho | 16626 | 890 | 0 | 15736 | -14.091648 | -74.08344 | 2021-01-30 05:22:49 | Ayacucho, Peru | ||
2482124 | 2482124 | 2021-01-28 | Peru | Ayacucho | 16626 | 885 | 0 | 15741 | -14.091648 | -74.08344 | 2021-01-29 05:22:23 | Ayacucho, Peru | ||
2930914 | 2930914 | 2020-12-19 | Angola | 16626 | 386 | 9518 | 6722 | -11.2027 | 17.8739 | 2020-12-20 05:27:32 | Angola | |||
1006966 | 1006966 | 2020-12-06 | US | Florida | Brevard | 12009 | 16626 | 456 | 0 | 16170 | 28.29409504 | -80.73091022 | 2020-12-07 05:26:14 | Brevard, Florida, US |
1545433 | 1545433 | 2020-11-07 | US | Louisiana | East Baton Rouge | 22033 | 16626 | 461 | 0 | 16165 | 30.53842039 | -91.09777565 | 2020-11-08 05:24:56 | East Baton Rouge, Louisiana, US |
377671 | 377671 | 2020-11-06 | US | Louisiana | East Baton Rouge | 22033 | 16626 | 461 | 0 | 16165 | 30.53842039 | -91.09777565 | 2020-11-07 05:24:52 | East Baton Rouge, Louisiana, US |
765137 | 765137 | 2020-10-18 | US | South Carolina | Richland | 45079 | 16626 | 262 | 0 | 16364 | 34.01791263 | -80.90267209 | 2020-10-19 04:24:16 | Richland, South Carolina, US |
1448201 | 1448201 | 2020-09-11 | Ukraine | Lviv Oblast | 16626 | 462 | 5167 | 10997 | 49.8397 | 24.0297 | 2020-09-12 04:25:05 | Lviv Oblast, Ukraine | ||
2215815 | 2215815 | 2020-08-23 | Peru | Ancash | 16626 | 2166 | 0 | 14460 | -9.407125 | -77.67179499999997 | 2020-08-24 04:27:56 | Ancash, Peru | ||
2436461 | 2436461 | 2020-06-20 | US | New Jersey | Middlesex | 34023 | 16626 | 1100 | 0 | 15526 | 40.43629879 | -74.41426991 | 2020-06-21 04:33:19 | Middlesex, New Jersey, 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]);