johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
33 rows where confirmed = 14259 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2405771 | 2405771 | 2022-08-21 | US | Tennessee | Dyer | 47045 | 14259 | 215 | 0 | 36.05931946 | -89.41542855 | 2022-08-22 04:20:38 | Dyer, Tennessee, US | |
2009685 | 2009685 | 2022-08-04 | US | Illinois | Grundy | 17063 | 14259 | 140 | 0 | 41.28569601 | -88.41905692 | 2022-08-05 04:20:52 | Grundy, Illinois, US | |
562230 | 562230 | 2022-06-16 | US | Virginia | Washington | 51191 | 14259 | 217 | 0 | 36.72341572 | -81.95666289 | 2022-06-17 04:20:56 | Washington, Virginia, US | |
3448234 | 3448234 | 2022-05-11 | US | Virginia | Pittsylvania | 51143 | 14259 | 199 | 0 | 36.81980341 | -79.39731264 | 2022-05-12 04:20:54 | Pittsylvania, Virginia, US | |
2843878 | 2843878 | 2022-04-30 | US | Texas | Caldwell | 48055 | 14259 | 175 | 0 | 29.83668859 | -97.61814775 | 2022-05-01 04:20:57 | Caldwell, Texas, US | |
1160191 | 1160191 | 2022-04-29 | US | Texas | Caldwell | 48055 | 14259 | 175 | 0 | 29.83668859 | -97.61814775 | 2022-04-30 04:21:05 | Caldwell, Texas, US | |
3206746 | 3206746 | 2022-04-11 | US | Arkansas | Crittenden | 5035 | 14259 | 226 | 0 | 35.21247318 | -90.30839406 | 2022-04-12 04:20:49 | Crittenden, Arkansas, US | |
1576632 | 1576632 | 2022-04-10 | US | Arkansas | Crittenden | 5035 | 14259 | 226 | 0 | 35.21247318 | -90.30839406 | 2022-04-11 04:21:02 | Crittenden, Arkansas, US | |
1652874 | 1652874 | 2022-04-09 | US | Arkansas | Crittenden | 5035 | 14259 | 226 | 0 | 35.21247318 | -90.30839406 | 2022-04-10 04:20:52 | Crittenden, Arkansas, US | |
2116196 | 2116196 | 2022-04-08 | US | Arkansas | Crittenden | 5035 | 14259 | 226 | 0 | 35.21247318 | -90.30839406 | 2022-04-09 04:20:42 | Crittenden, Arkansas, US | |
3320720 | 3320720 | 2022-04-07 | US | Arkansas | Crittenden | 5035 | 14259 | 226 | 0 | 35.21247318 | -90.30839406 | 2022-04-08 04:20:48 | Crittenden, Arkansas, US | |
954110 | 954110 | 2022-03-12 | US | Texas | Val Verde | 48465 | 14259 | 293 | 0 | 29.89149232 | -101.1525205 | 2022-03-13 04:20:49 | Val Verde, Texas, US | |
359571 | 359571 | 2022-03-11 | US | Texas | Val Verde | 48465 | 14259 | 292 | 0 | 29.89149232 | -101.1525205 | 2022-03-12 04:20:50 | Val Verde, Texas, US | |
1320862 | 1320862 | 2022-01-26 | US | Pennsylvania | Armstrong | 42005 | 14259 | 298 | 0 | 40.81665618 | -79.46290811 | 2022-01-27 04:21:19 | Armstrong, Pennsylvania, US | |
3427878 | 3427878 | 2022-01-21 | US | Tennessee | Coffee | 47031 | 14259 | 218 | 0 | 35.49090731 | -86.07311784 | 2022-01-22 04:21:13 | Coffee, Tennessee, US | |
1695133 | 1695133 | 2022-01-10 | US | South Carolina | Darlington | 45031 | 14259 | 246 | 0 | 34.33358335 | -79.96027485 | 2022-01-11 04:22:01 | Darlington, South Carolina, US | |
496241 | 496241 | 2021-11-06 | US | California | Sutter | 6101 | 14259 | 180 | 0 | 39.03417539 | -121.6945899 | 2021-11-07 04:21:53 | Sutter, California, US | |
2464999 | 2464999 | 2021-09-14 | US | New Mexico | Sandoval | 35043 | 14259 | 252 | 0 | 35.68862401 | -106.86878030000001 | 2021-09-15 03:22:37 | Sandoval, New Mexico, US | |
1119862 | 1119862 | 2021-08-06 | US | New York | Ulster | 36111 | 14259 | 258 | 0 | 41.89027881 | -74.26252104 | 2021-08-07 04:21:30 | Ulster, New York, US | |
1806815 | 1806815 | 2021-05-27 | Mali | 14259 | 514 | 9523 | 4222 | 17.570692 | -3.996166000000001 | 2021-05-28 04:20:36 | Mali | |||
1873507 | 1873507 | 2021-05-15 | US | California | Marin | 6041 | 14259 | 227 | 0 | 38.07122463 | -122.7210631 | 2021-05-16 04:20:49 | Marin, California, US | |
1427750 | 1427750 | 2021-05-09 | US | Pennsylvania | Cambria | 42021 | 14259 | 421 | 0 | 40.49527404 | -78.71377428 | 2021-05-10 04:20:38 | Cambria, Pennsylvania, US | |
957066 | 957066 | 2021-04-25 | US | New Mexico | San Juan | 35045 | 14259 | 466 | 0 | 36.50838318 | -108.320437 | 2021-04-26 04:21:04 | San Juan, New Mexico, US | |
3926213 | 3926213 | 2021-04-24 | US | New Mexico | San Juan | 35045 | 14259 | 466 | 0 | 36.50838318 | -108.320437 | 2021-04-25 04:20:32 | San Juan, New Mexico, US | |
1411244 | 1411244 | 2021-04-23 | US | New Mexico | San Juan | 35045 | 14259 | 466 | 0 | 36.50838318 | -108.320437 | 2021-04-24 04:20:38 | San Juan, New Mexico, US | |
242829 | 242829 | 2021-04-02 | US | Maryland | Harford | 24025 | 14259 | 257 | 0 | 39.55010644 | -76.30775940000002 | 2021-04-03 04:20:44 | Harford, Maryland, US | |
3370574 | 3370574 | 2021-03-21 | US | Iowa | Woodbury | 19193 | 14259 | 216 | 0 | 42.38979414 | -96.0459439 | 2021-03-22 05:25:43 | Woodbury, Iowa, US | |
2701707 | 2701707 | 2020-11-20 | Russia | Ivanovo Oblast | 14259 | 216 | 10133 | 3910 | 56.9167446 | 41.43521370000001 | 2020-11-21 05:25:51 | Ivanovo Oblast, Russia | ||
822135 | 822135 | 2020-11-19 | US | California | San Francisco | 6075 | 14259 | 153 | 0 | 14111 | 37.75215114 | -122.4385672 | 2020-11-20 05:26:28 | San Francisco, California, US |
2605658 | 2605658 | 2020-10-10 | Ukraine | Rivne Oblast | 14259 | 184 | 11294 | 2781 | 50.6199 | 26.2516 | 2020-10-11 04:23:46 | Rivne Oblast, Ukraine | ||
1121442 | 1121442 | 2020-09-17 | Colombia | Magdalena | 14259 | 780 | 11949 | 1530 | 10.4113 | -74.4057 | 2020-09-18 05:05:00 | Magdalena, Colombia | ||
665404 | 665404 | 2020-08-11 | US | Texas | Fort Bend | 48157 | 14259 | 164 | 0 | 10171 | 29.52704478 | -95.77219463 | 2020-08-12 04:27:29 | Fort Bend, Texas, US |
415353 | 415353 | 2020-07-05 | Peru | Lambayeque | 14259 | 2386 | 0 | 11873 | -6.3530489999999995 | -79.824113 | 2020-07-06 04:33:57 | Lambayeque, Peru |
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]);