johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
42 rows where active = 2523 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 42 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2209565 | 2209565 | 2021-03-04 | US | Missouri | Lafayette | 29107 | 2579 | 56 | 0 | 2523 | 39.06986886 | -93.78076396 | 2021-03-05 05:26:29 | Lafayette, Missouri, US |
471930 | 471930 | 2021-02-19 | US | Arkansas | Sevier | 5133 | 2551 | 28 | 0 | 2523 | 33.99780401 | -94.2424869 | 2021-02-20 05:22:51 | Sevier, Arkansas, US |
1341191 | 1341191 | 2021-02-15 | US | Tennessee | Claiborne | 47025 | 2589 | 65 | 0 | 2523 | 36.48319149 | -83.65947309 | 2021-02-16 05:24:38 | Claiborne, Tennessee, US |
2681308 | 2681308 | 2021-02-13 | US | West Virginia | Logan | 54045 | 2595 | 72 | 0 | 2523 | 37.8299889 | -81.93528571 | 2021-02-14 05:23:43 | Logan, West Virginia, US |
1673613 | 1673613 | 2021-02-07 | US | Iowa | Bremer | 19017 | 2575 | 52 | 0 | 2523 | 42.77461496 | -92.31795937 | 2021-02-08 05:22:39 | Bremer, Iowa, US |
1591779 | 1591779 | 2021-02-05 | US | Wyoming | Park | 56029 | 2546 | 23 | 0 | 2523 | 44.52157546 | -109.5852825 | 2021-02-06 05:23:55 | Park, Wyoming, US |
1685576 | 1685576 | 2021-02-02 | US | Indiana | Fayette | 18041 | 2577 | 54 | 0 | 2523 | 39.63684962 | -85.17797541 | 2021-02-03 05:22:52 | Fayette, Indiana, US |
1680074 | 1680074 | 2021-02-01 | US | Wyoming | Park | 56029 | 2543 | 20 | 0 | 2523 | 44.52157546 | -109.5852825 | 2021-02-02 05:22:49 | Park, Wyoming, US |
2482662 | 2482662 | 2021-01-28 | US | Florida | Hardee | 12049 | 2546 | 23 | 0 | 2523 | 27.49293939 | -81.80956574 | 2021-01-29 05:22:23 | Hardee, Florida, US |
2429527 | 2429527 | 2021-01-23 | US | Oregon | Polk | 41053 | 2563 | 40 | 0 | 2523 | 44.90322804 | -123.4128888 | 2021-01-24 05:22:35 | Polk, Oregon, US |
436028 | 436028 | 2021-01-21 | US | Florida | Bradford | 12007 | 2554 | 31 | 0 | 2523 | 29.95079741 | -82.16611613 | 2021-01-22 05:22:10 | Bradford, Florida, US |
908577 | 908577 | 2021-01-19 | US | Alabama | Tallapoosa | 1123 | 2630 | 107 | 0 | 2523 | 32.86698258 | -85.79833053 | 2021-01-20 05:21:54 | Tallapoosa, Alabama, US |
3504345 | 3504345 | 2021-01-17 | US | Illinois | Iroquois | 17075 | 2577 | 54 | 0 | 2523 | 40.74717633 | -87.82466784 | 2021-01-18 05:22:34 | Iroquois, Illinois, US |
2542777 | 2542777 | 2021-01-07 | US | Kentucky | Calloway | 21035 | 2550 | 27 | 0 | 2523 | 36.62093411 | -88.2731593 | 2021-01-08 05:22:42 | Calloway, Kentucky, US |
2866768 | 2866768 | 2021-01-06 | US | Nebraska | Dawson | 31047 | 2547 | 24 | 0 | 2523 | 40.87028216 | -99.8201461 | 2021-01-07 05:22:03 | Dawson, Nebraska, US |
2231062 | 2231062 | 2021-01-02 | US | Wisconsin | Juneau | 55057 | 2533 | 10 | 0 | 2523 | 43.92456975 | -90.11120239 | 2021-01-03 05:22:52 | Juneau, Wisconsin, US |
3697758 | 3697758 | 2020-12-31 | US | New York | Wayne | 36117 | 2559 | 36 | 0 | 2523 | 43.15494365 | -77.02976528 | 2021-01-01 05:23:07 | Wayne, New York, US |
767404 | 767404 | 2020-12-29 | US | Indiana | Harrison | 18061 | 2561 | 38 | 0 | 2523 | 38.19467379 | -86.10948271 | 2020-12-30 05:22:34 | Harrison, Indiana, US |
3762638 | 3762638 | 2020-12-28 | US | Indiana | Adams | 18001 | 2560 | 37 | 0 | 2523 | 40.7457653 | -84.93671406 | 2020-12-29 05:22:37 | Adams, Indiana, US |
3764014 | 3764014 | 2020-12-28 | US | Ohio | Ashland | 39005 | 2592 | 69 | 0 | 2523 | 40.84772277 | -82.27280781 | 2020-12-29 05:22:37 | Ashland, Ohio, US |
3781389 | 3781389 | 2020-12-27 | US | West Virginia | Mercer | 54055 | 2574 | 51 | 0 | 2523 | 37.40481169 | -81.11023142 | 2020-12-28 05:22:06 | Mercer, West Virginia, US |
2410116 | 2410116 | 2020-12-23 | US | Virginia | Albemarle | 51003 | 2552 | 29 | 0 | 2523 | 38.02080697 | -78.55481085 | 2020-12-24 05:23:04 | Albemarle, Virginia, US |
1035442 | 1035442 | 2020-12-15 | US | Indiana | DeKalb | 18033 | 2573 | 50 | 0 | 2523 | 41.39804622 | -84.99906934 | 2020-12-16 05:28:04 | DeKalb, Indiana, US |
1009240 | 1009240 | 2020-12-06 | US | Tennessee | Jefferson | 47089 | 2541 | 35 | 0 | 2523 | 36.04818632 | -83.45148924 | 2020-12-07 05:26:14 | Jefferson, Tennessee, US |
1584700 | 1584700 | 2020-11-30 | US | California | El Dorado | 6017 | 2543 | 4 | 0 | 2523 | 38.77965956 | -120.5233166 | 2020-12-01 05:26:18 | El Dorado, California, US |
924291 | 924291 | 2020-11-26 | US | Colorado | Fremont | 8043 | 3012 | 14 | 0 | 2523 | 38.47362326 | -105.4399667 | 2020-11-27 05:26:53 | Fremont, Colorado, US |
924668 | 924668 | 2020-11-26 | US | Illinois | Henry | 17073 | 2536 | 13 | 0 | 2523 | 41.3533994 | -90.13296166 | 2020-11-27 05:26:53 | Henry, Illinois, US |
1351299 | 1351299 | 2020-11-24 | US | Illinois | Grundy | 17063 | 2539 | 16 | 0 | 2523 | 41.28569601 | -88.41905692 | 2020-11-25 05:27:20 | Grundy, Illinois, US |
2704969 | 2704969 | 2020-11-20 | US | West Virginia | Berkeley | 54003 | 2544 | 21 | 0 | 2523 | 39.46704621 | -78.02414609 | 2020-11-21 05:25:51 | Berkeley, West Virginia, US |
2920277 | 2920277 | 2020-11-04 | US | Indiana | Kosciusko | 18085 | 2555 | 32 | 0 | 2523 | 41.24521668 | -85.86312322 | 2020-11-05 06:05:03 | Kosciusko, Indiana, US |
3304926 | 3304926 | 2020-11-02 | US | Florida | Walton | 12131 | 2553 | 30 | 0 | 2523 | 30.64204028 | -86.16935664 | 2020-11-03 06:00:16 | Walton, Florida, US |
3411250 | 3411250 | 2020-11-01 | US | Mississippi | Lauderdale | 28075 | 2658 | 135 | 0 | 2523 | 32.40419769 | -88.66229662 | 2020-11-02 05:25:04 | Lauderdale, Mississippi, US |
3480667 | 3480667 | 2020-10-26 | US | Alabama | Cullman | 1043 | 2547 | 24 | 0 | 2523 | 34.13020303 | -86.86888037 | 2020-10-27 04:24:45 | Cullman, Alabama, US |
788742 | 788742 | 2020-10-15 | US | North Carolina | Wilson | 37195 | 2585 | 62 | 0 | 2523 | 35.70625477 | -77.917978 | 2020-10-16 04:24:01 | Wilson, North Carolina, US |
819899 | 819899 | 2020-10-09 | US | North Carolina | Onslow | 37133 | 2549 | 26 | 0 | 2523 | 34.72607366 | -77.42908179 | 2020-10-10 04:23:57 | Onslow, North Carolina, US |
2174971 | 2174971 | 2020-09-09 | US | Washington | Grant | 53025 | 2542 | 19 | 0 | 2523 | 47.20753737 | -119.4500749 | 2020-09-10 04:29:01 | Grant, Washington, US |
1558745 | 1558745 | 2020-08-16 | US | South Carolina | Anderson | 45007 | 2599 | 76 | 0 | 2523 | 34.51828081 | -82.63959517 | 2020-08-17 04:27:20 | Anderson, South Carolina, US |
3533619 | 3533619 | 2020-08-12 | US | New Mexico | Dona Ana | 35013 | 2554 | 31 | 0 | 2523 | 32.35275771 | -106.8329387 | 2020-08-13 04:29:15 | Dona Ana, New Mexico, US |
120833 | 120833 | 2020-07-19 | US | Wisconsin | Racine | 55101 | 2589 | 66 | 0 | 2523 | 42.74753117 | -88.05941254 | 2020-07-20 05:34:40 | Racine, Wisconsin, US |
413208 | 413208 | 2020-07-05 | US | Virginia | Henrico | 51087 | 2681 | 158 | 0 | 2523 | 37.53460572 | -77.39326555 | 2020-07-06 04:33:57 | Henrico, Virginia, US |
413463 | 413463 | 2020-07-05 | US | California | Kings | 6031 | 2554 | 31 | 0 | 2523 | 36.07409056 | -119.8159973 | 2020-07-06 04:33:57 | Kings, California, US |
3416328 | 3416328 | 2020-05-17 | US | Puerto Rico | 72 | 2646 | 123 | 0 | 2523 | 18.2208 | -66.5901 | 2020-05-18 02:32:21 | Puerto Rico, 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]);