johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
51 rows where confirmed = 14256 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1622657 | 1622657 | 2022-11-22 | US | North Carolina | Watauga | 37189 | 14256 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-11-23 04:21:06 | Watauga, North Carolina, US | |
3462545 | 3462545 | 2022-11-21 | US | North Carolina | Watauga | 37189 | 14256 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-11-22 04:20:47 | Watauga, North Carolina, US | |
1642730 | 1642730 | 2022-11-20 | US | North Carolina | Watauga | 37189 | 14256 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-11-21 04:21:05 | Watauga, North Carolina, US | |
2066287 | 2066287 | 2022-11-19 | US | North Carolina | Watauga | 37189 | 14256 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-11-20 04:21:08 | Watauga, North Carolina, US | |
1757681 | 1757681 | 2022-11-18 | US | North Carolina | Watauga | 37189 | 14256 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-11-19 04:21:14 | Watauga, North Carolina, US | |
3028674 | 3028674 | 2022-11-17 | US | North Carolina | Watauga | 37189 | 14256 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-11-18 04:21:15 | Watauga, North Carolina, US | |
2488385 | 2488385 | 2022-11-16 | US | North Carolina | Watauga | 37189 | 14256 | 78 | 0 | 36.23103603 | -81.70033724 | 2022-11-17 04:21:11 | Watauga, North Carolina, US | |
1373773 | 1373773 | 2022-09-21 | US | Utah | TriCounty | 14256 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-09-22 04:22:56 | TriCounty, Utah, US | ||
2020003 | 2020003 | 2022-09-20 | US | Utah | TriCounty | 14256 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-09-21 04:23:22 | TriCounty, Utah, US | ||
3573876 | 3573876 | 2022-09-19 | US | Utah | TriCounty | 14256 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-09-20 04:22:48 | TriCounty, Utah, US | ||
422615 | 422615 | 2022-09-18 | US | Utah | TriCounty | 14256 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-09-19 04:21:49 | TriCounty, Utah, US | ||
3376639 | 3376639 | 2022-09-17 | US | Utah | TriCounty | 14256 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-09-18 04:22:50 | TriCounty, Utah, US | ||
2358747 | 2358747 | 2022-09-16 | US | Utah | TriCounty | 14256 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-09-17 04:20:19 | TriCounty, Utah, US | ||
3989904 | 3989904 | 2022-09-15 | US | Utah | TriCounty | 14256 | 113 | 0 | 40.12491499 | -109.5174415 | 2022-09-16 04:21:19 | TriCounty, Utah, US | ||
2326897 | 2326897 | 2022-08-24 | US | Wisconsin | Grant | 55043 | 14256 | 153 | 0 | 42.8671731 | -90.7063218 | 2022-08-25 04:21:13 | Grant, Wisconsin, US | |
3213620 | 3213620 | 2022-07-18 | US | Virginia | Fauquier | 51061 | 14256 | 150 | 0 | 38.73564842 | -77.80647472 | 2022-07-19 04:20:58 | Fauquier, Virginia, US | |
2801256 | 2801256 | 2022-04-06 | US | Arkansas | Crittenden | 5035 | 14256 | 226 | 0 | 35.21247318 | -90.30839406 | 2022-04-07 04:20:53 | Crittenden, Arkansas, US | |
3868025 | 3868025 | 2022-04-05 | US | Arkansas | Crittenden | 5035 | 14256 | 226 | 0 | 35.21247318 | -90.30839406 | 2022-04-06 04:20:49 | Crittenden, Arkansas, US | |
1469717 | 1469717 | 2022-03-24 | US | Michigan | Barry | 26015 | 14256 | 166 | 0 | 42.59513984 | -85.30834519 | 2022-03-25 04:20:46 | Barry, Michigan, US | |
3023891 | 3023891 | 2022-03-23 | US | Michigan | Barry | 26015 | 14256 | 166 | 0 | 42.59513984 | -85.30834519 | 2022-03-24 04:20:43 | Barry, Michigan, US | |
3022260 | 3022260 | 2022-03-23 | Japan | Akita | 14256 | 44 | 0 | 39.748678999999996 | 140.408228 | 2022-03-24 04:20:43 | Akita, Japan | |||
1868723 | 1868723 | 2022-03-10 | US | Texas | Val Verde | 48465 | 14256 | 291 | 0 | 29.89149232 | -101.1525205 | 2022-03-11 04:20:50 | Val Verde, Texas, US | |
72479 | 72479 | 2022-02-07 | US | Kentucky | Christian | 21047 | 14256 | 191 | 0 | 36.89267803 | -87.49055367 | 2022-02-08 04:21:15 | Christian, Kentucky, US | |
2053807 | 2053807 | 2022-01-25 | US | Missouri | Lincoln | 29113 | 14256 | 104 | 0 | 39.05345619 | -90.95588181 | 2022-01-26 04:21:07 | Lincoln, Missouri, US | |
1228424 | 1228424 | 2022-01-24 | US | Georgia | Gordon | 13129 | 14256 | 223 | 0 | 34.50487351 | -84.87296253 | 2022-01-25 04:21:05 | Gordon, Georgia, US | |
2613294 | 2613294 | 2022-01-06 | US | Texas | Victoria | 48469 | 14256 | 359 | 0 | 28.79780988 | -96.96813006 | 2022-01-07 04:22:09 | Victoria, Texas, US | |
3521795 | 3521795 | 2022-01-02 | US | North Carolina | Rockingham | 37157 | 14256 | 223 | 0 | 36.39593137 | -79.77504841 | 2022-01-03 02:22:25 | Rockingham, North Carolina, US | |
2169925 | 2169925 | 2022-01-01 | US | North Carolina | Rockingham | 37157 | 14256 | 223 | 0 | 36.39593137 | -79.77504841 | 2022-01-02 04:20:52 | Rockingham, North Carolina, US | |
2779356 | 2779356 | 2021-12-31 | US | North Carolina | Rockingham | 37157 | 14256 | 223 | 0 | 36.39593137 | -79.77504841 | 2022-01-01 04:22:14 | Rockingham, North Carolina, US | |
4001013 | 4001013 | 2021-12-30 | US | North Carolina | Rockingham | 37157 | 14256 | 223 | 0 | 36.39593137 | -79.77504841 | 2021-12-31 04:21:50 | Rockingham, North Carolina, US | |
1257000 | 1257000 | 2021-12-20 | US | New York | Chemung | 36015 | 14256 | 187 | 0 | 42.13891056 | -76.7638805 | 2021-12-21 03:21:27 | Chemung, New York, US | |
1718172 | 1718172 | 2021-12-16 | US | Mississippi | Jones | 28067 | 14256 | 248 | 0 | 31.62257767 | -89.16896899999998 | 2021-12-17 04:22:14 | Jones, Mississippi, US | |
3291544 | 3291544 | 2021-11-18 | US | Oregon | Linn | 41043 | 14256 | 160 | 0 | 44.48899494 | -122.53731540000001 | 2021-11-19 04:21:40 | Linn, Oregon, US | |
698994 | 698994 | 2021-11-04 | US | California | Sutter | 6101 | 14256 | 179 | 0 | 39.03417539 | -121.6945899 | 2021-11-05 04:21:54 | Sutter, California, US | |
526230 | 526230 | 2021-06-09 | US | Virginia | Newport News | 51700 | 14256 | 233 | 0 | 37.08166899 | -76.51754109 | 2021-06-10 04:23:17 | Newport News, Virginia, US | |
1310238 | 1310238 | 2021-05-26 | Mali | 14256 | 514 | 9514 | 4228 | 17.570692 | -3.996166000000001 | 2021-05-27 04:20:59 | Mali | |||
1913370 | 1913370 | 2021-05-20 | Peru | Huancavelica | 14256 | 1029 | 0 | 13227 | -13.023888 | -75.00277 | 2021-05-21 04:20:43 | Huancavelica, Peru | ||
2255764 | 2255764 | 2021-05-19 | Japan | Okinawa | 14256 | 146 | 12413 | 1697 | 25.768923 | 126.668016 | 2021-05-20 04:21:05 | Okinawa, Japan | ||
2986168 | 2986168 | 2021-04-10 | US | Tennessee | Bradley | 47011 | 14256 | 145 | 0 | 35.15739424 | -84.857186 | 2021-04-11 04:20:56 | Bradley, Tennessee, US | |
1617008 | 1617008 | 2021-03-05 | US | Georgia | Clarke | 13059 | 14256 | 123 | 0 | 14133 | 33.95436462 | -83.37124007 | 2021-03-06 04:23:41 | Clarke, Georgia, US |
1001425 | 1001425 | 2021-03-01 | US | Tennessee | Sullivan | 47163 | 14256 | 273 | 0 | 14063 | 36.51240691 | -82.30412917 | 2021-03-02 05:23:30 | Sullivan, Tennessee, US |
3603381 | 3603381 | 2021-02-17 | US | North Carolina | Onslow | 37133 | 14256 | 129 | 0 | 14127 | 34.72607366 | -77.42908179 | 2021-02-18 05:22:58 | Onslow, North Carolina, US |
3516520 | 3516520 | 2021-01-15 | US | Indiana | Porter | 18127 | 14256 | 223 | 0 | 14033 | 41.45986947 | -87.06848888 | 2021-01-16 05:22:40 | Porter, Indiana, US |
2938689 | 2938689 | 2020-11-28 | US | Washington | Yakima | 53077 | 14256 | 292 | 0 | 13964 | 46.45738486 | -120.7380126 | 2020-11-29 05:25:55 | Yakima, Washington, US |
2915694 | 2915694 | 2020-11-14 | US | Arkansas | Pulaski | 5119 | 14256 | 235 | 0 | 14021 | 34.77054088 | -92.31355101 | 2020-11-15 05:26:53 | Pulaski, Arkansas, US |
3443791 | 3443791 | 2020-11-11 | US | Tennessee | Rutherford | 47149 | 14256 | 128 | 0 | 14127 | 35.84591405 | -86.4107263 | 2020-11-12 05:25:55 | Rutherford, Tennessee, US |
3990502 | 3990502 | 2020-10-20 | Finland | 14256 | 345 | 9100 | 4398 | 61.92411 | 25.748151 | 2020-10-21 04:24:14 | Finland | |||
1026735 | 1026735 | 2020-10-17 | US | Alabama | Mobile | 1097 | 14256 | 314 | 0 | 13942 | 30.78472347 | -88.20842409 | 2020-10-18 04:24:25 | Mobile, Alabama, US |
3801758 | 3801758 | 2020-10-05 | Colombia | Sucre | 14256 | 584 | 13201 | 471 | 8.814 | -74.7233 | 2020-10-06 04:23:33 | Sucre, Colombia | ||
3316473 | 3316473 | 2020-09-22 | Russia | Volgograd Oblast | 14256 | 132 | 12509 | 1615 | 49.6048339 | 44.2903582 | 2020-09-23 04:23:00 | Volgograd Oblast, Russia | ||
1523335 | 1523335 | 2020-08-28 | Peru | Cajamarca | 14256 | 1125 | 0 | 13131 | -6.430284 | -78.74559599999998 | 2020-08-29 04:28:19 | Cajamarca, 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]);