johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
54 rows where active = 2474 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state 24
- Mississippi 4
- Ohio 4
- Illinois 3
- Indiana 3
- Iowa 3
- Missouri 3
- North Carolina 3
- Tennessee 3
- Texas 3
- Washington 3
- California 2
- Florida 2
- Kansas 2
- Michigan 2
- Minnesota 2
- Pennsylvania 2
- South Dakota 2
- Virginia 2
- Alabama 1
- Arkansas 1
- Louisiana 1
- North Dakota 1
- Oregon 1
- South Carolina 1
country_or_region 1
- US · 54 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2368668 | 2368668 | 2021-02-28 | US | Iowa | Crawford | 19047 | 2509 | 35 | 0 | 2474 | 42.03718237 | -95.3819718 | 2021-03-01 05:23:01 | Crawford, Iowa, US |
2185434 | 2185434 | 2021-02-26 | US | Mississippi | Wayne | 28153 | 2515 | 41 | 0 | 2474 | 31.64135687 | -88.69573913 | 2021-02-27 05:22:28 | Wayne, Mississippi, US |
531851 | 531851 | 2021-02-22 | US | Indiana | Wells | 18179 | 2548 | 74 | 0 | 2474 | 40.72934187 | -85.22132966 | 2021-02-23 05:23:41 | Wells, Indiana, US |
744225 | 744225 | 2021-02-20 | US | Missouri | Lafayette | 29107 | 2527 | 53 | 0 | 2474 | 39.06986886 | -93.78076396 | 2021-02-21 05:24:33 | Lafayette, Missouri, US |
2680314 | 2680314 | 2021-02-13 | US | Ohio | Morrow | 39117 | 2512 | 38 | 0 | 2474 | 40.52363560000001 | -82.7892599 | 2021-02-14 05:23:43 | Morrow, Ohio, US |
1675107 | 1675107 | 2021-02-07 | US | Pennsylvania | Clarion | 42031 | 2550 | 76 | 0 | 2474 | 41.19265812 | -79.42413524 | 2021-02-08 05:22:39 | Clarion, Pennsylvania, US |
1685809 | 1685809 | 2021-02-02 | US | Kansas | Miami | 20121 | 2502 | 28 | 0 | 2474 | 38.56383358 | -94.83832189 | 2021-02-03 05:22:52 | Miami, Kansas, US |
1677779 | 1677779 | 2021-02-01 | US | Kansas | Miami | 20121 | 2502 | 28 | 0 | 2474 | 38.56383358 | -94.83832189 | 2021-02-02 05:22:49 | Miami, Kansas, US |
3154144 | 3154144 | 2021-01-27 | US | California | Glenn | 6021 | 2475 | 14 | 0 | 2474 | 39.59875897 | -122.3938452 | 2021-01-28 05:22:24 | Glenn, California, US |
3155448 | 3155448 | 2021-01-27 | US | Mississippi | Tippah | 28139 | 2526 | 52 | 0 | 2474 | 34.76872156 | -88.90988194 | 2021-01-28 05:22:24 | Tippah, Mississippi, US |
1759988 | 1759988 | 2021-01-24 | US | Florida | Hardee | 12049 | 2496 | 22 | 0 | 2474 | 27.49293939 | -81.80956574 | 2021-01-25 05:22:16 | Hardee, Florida, US |
2430090 | 2430090 | 2021-01-23 | US | Texas | Polk | 48373 | 2586 | 74 | 0 | 2474 | 30.79472531 | -94.8276624 | 2021-01-24 05:22:35 | Polk, Texas, US |
3101985 | 3101985 | 2021-01-16 | US | California | Lake | 6033 | 2504 | 30 | 0 | 2474 | 39.10124298 | -122.7536244 | 2021-01-17 05:22:17 | Lake, California, US |
3103352 | 3103352 | 2021-01-16 | US | Missouri | Lawrence | 29109 | 2534 | 60 | 0 | 2474 | 37.10626634 | -93.83293097 | 2021-01-17 05:22:17 | Lawrence, Missouri, US |
3309226 | 3309226 | 2021-01-13 | US | Illinois | Perry | 17145 | 2526 | 52 | 0 | 2474 | 38.08510853 | -89.36856219 | 2021-01-14 05:22:32 | Perry, Illinois, US |
775335 | 775335 | 2021-01-12 | US | Illinois | Iroquois | 17075 | 2525 | 51 | 0 | 2474 | 40.74717633 | -87.82466784 | 2021-01-13 05:22:15 | Iroquois, Illinois, US |
775508 | 775508 | 2021-01-12 | US | Iowa | Carroll | 19027 | 2507 | 33 | 0 | 2474 | 42.03617207 | -94.86032705 | 2021-01-13 05:22:15 | Carroll, Iowa, US |
3037329 | 3037329 | 2021-01-05 | US | Texas | Caldwell | 48055 | 2985 | 46 | 0 | 2474 | 29.83668859 | -97.61814775 | 2021-01-06 05:22:16 | Caldwell, Texas, US |
3232389 | 3232389 | 2021-01-03 | US | Missouri | Platte | 29165 | 2497 | 23 | 0 | 2474 | 39.38154439 | -94.77068479 | 2021-01-04 05:22:02 | Platte, Missouri, US |
1139720 | 1139720 | 2021-01-01 | US | South Dakota | Beadle | 46005 | 2509 | 35 | 0 | 2474 | 44.41464384 | -98.27858469 | 2021-01-02 05:22:33 | Beadle, South Dakota, US |
3698326 | 3698326 | 2020-12-31 | US | South Dakota | Beadle | 46005 | 2509 | 35 | 0 | 2474 | 44.41464384 | -98.27858469 | 2021-01-01 05:23:07 | Beadle, South Dakota, US |
768133 | 768133 | 2020-12-29 | US | Mississippi | Leflore | 28083 | 2574 | 100 | 0 | 2474 | 33.55545125 | -90.29900733 | 2020-12-30 05:22:34 | Leflore, Mississippi, US |
3781330 | 3781330 | 2020-12-27 | US | Washington | Douglas | 53017 | 2488 | 14 | 0 | 2474 | 47.7361335 | -119.692937 | 2020-12-28 05:22:06 | Douglas, Washington, US |
2226935 | 2226935 | 2020-12-26 | US | Washington | Douglas | 53017 | 2488 | 14 | 0 | 2474 | 47.7361335 | -119.692937 | 2020-12-27 05:22:55 | Douglas, Washington, US |
2409741 | 2409741 | 2020-12-23 | US | Tennessee | Carroll | 47017 | 2532 | 47 | 0 | 2474 | 35.97366108 | -88.45189331 | 2020-12-24 05:23:04 | Carroll, Tennessee, US |
3771569 | 3771569 | 2020-12-22 | US | Minnesota | Carlton | 27017 | 2507 | 33 | 0 | 2474 | 46.59180601 | -92.67601019 | 2020-12-23 05:22:03 | Carlton, Minnesota, US |
1902366 | 1902366 | 2020-12-18 | US | Iowa | Jones | 19105 | 2509 | 35 | 0 | 2474 | 42.12118609 | -91.13139641 | 2020-12-19 05:27:52 | Jones, Iowa, US |
2130630 | 2130630 | 2020-12-17 | US | Pennsylvania | Bedford | 42009 | 2548 | 74 | 0 | 2474 | 40.00522157 | -78.48998442 | 2020-12-18 05:28:18 | Bedford, Pennsylvania, US |
1752363 | 1752363 | 2020-12-14 | US | Indiana | Knox | 18083 | 2530 | 56 | 0 | 2474 | 38.68861576 | -87.4194665 | 2020-12-15 05:26:38 | Knox, Indiana, US |
863991 | 863991 | 2020-12-11 | US | Virginia | Culpeper | 51047 | 2493 | 19 | 0 | 2474 | 38.48199985 | -77.95630870000002 | 2020-12-12 05:26:19 | Culpeper, Virginia, US |
2976246 | 2976246 | 2020-12-09 | US | Illinois | Morgan | 17137 | 2526 | 52 | 0 | 2474 | 39.71654544 | -90.20255104 | 2020-12-10 05:26:19 | Morgan, Illinois, US |
1822244 | 1822244 | 2020-12-08 | US | Washington | Whitman | 53075 | 2494 | 20 | 0 | 2474 | 46.90022523 | -117.5241763 | 2020-12-09 05:28:01 | Whitman, Washington, US |
3838170 | 3838170 | 2020-11-21 | US | Minnesota | Benton | 27009 | 2511 | 37 | 0 | 2474 | 45.69804958 | -93.99514135 | 2020-11-22 05:25:45 | Benton, Minnesota, US |
123229 | 123229 | 2020-11-18 | US | Arkansas | White | 5145 | 2518 | 44 | 0 | 2474 | 35.25688493 | -91.74908296 | 2020-11-19 05:25:23 | White, Arkansas, US |
2917517 | 2917517 | 2020-11-14 | US | North Carolina | Moore | 37125 | 2532 | 58 | 0 | 2474 | 35.30885257 | -79.48474178 | 2020-11-15 05:26:53 | Moore, North Carolina, US |
3443256 | 3443256 | 2020-11-11 | US | Ohio | Columbiana | 39029 | 2569 | 95 | 0 | 2474 | 40.76932373 | -80.78094576 | 2020-11-12 05:25:55 | Columbiana, Ohio, US |
2501417 | 2501417 | 2020-11-03 | US | Virginia | Spotsylvania | 51177 | 2529 | 55 | 0 | 2474 | 38.18574462 | -77.655399 | 2020-11-04 05:25:09 | Spotsylvania, Virginia, US |
3411100 | 3411100 | 2020-11-01 | US | Michigan | Muskegon | 26121 | 2558 | 84 | 0 | 2474 | 43.29123859 | -86.15176712 | 2020-11-02 05:25:04 | Muskegon, Michigan, US |
2081589 | 2081589 | 2020-10-31 | US | Michigan | Muskegon | 26121 | 2558 | 84 | 0 | 2474 | 43.29123859 | -86.15176712 | 2020-11-01 04:36:19 | Muskegon, Michigan, US |
2245699 | 2245699 | 2020-10-30 | US | North Carolina | Henderson | 37089 | 2541 | 67 | 0 | 2474 | 35.33788927 | -82.4766782 | 2020-10-31 04:24:44 | Henderson, North Carolina, US |
2245998 | 2245998 | 2020-10-30 | US | Oregon | Lane | 41039 | 2501 | 27 | 0 | 2474 | 43.93727035 | -122.847753 | 2020-10-31 04:24:44 | Lane, Oregon, US |
8688 | 8688 | 2020-10-25 | US | Alabama | Cullman | 1043 | 2498 | 24 | 0 | 2474 | 34.13020303 | -86.86888037 | 2020-10-26 04:25:02 | Cullman, Alabama, US |
1056261 | 1056261 | 2020-10-23 | US | Ohio | Clermont | 39025 | 2512 | 38 | 0 | 2474 | 39.04847534 | -84.15375786 | 2020-10-24 04:24:46 | Clermont, Ohio, US |
3784268 | 3784268 | 2020-10-13 | US | North Carolina | Wilson | 37195 | 2535 | 61 | 0 | 2474 | 35.70625477 | -77.917978 | 2020-10-14 04:24:05 | Wilson, North Carolina, US |
3804884 | 3804884 | 2020-10-05 | US | Tennessee | Washington | 47179 | 2487 | 38 | 0 | 2474 | 36.29472368 | -82.49454720000001 | 2020-10-06 04:23:33 | Washington, Tennessee, US |
2654869 | 2654869 | 2020-09-23 | US | Indiana | Monroe | 18105 | 2512 | 38 | 0 | 2474 | 39.16130004 | -86.52414358 | 2020-09-24 04:23:00 | Monroe, Indiana, US |
1123395 | 1123395 | 2020-09-17 | US | Mississippi | Lee | 28081 | 2540 | 66 | 0 | 2474 | 34.2918775 | -88.68149954 | 2020-09-18 05:05:00 | Lee, Mississippi, US |
2664261 | 2664261 | 2020-09-04 | US | Ohio | Pickaway | 39129 | 2511 | 37 | 0 | 2474 | 39.64170392 | -83.0243386 | 2020-09-05 04:28:19 | Pickaway, Ohio, US |
1108510 | 1108510 | 2020-09-02 | US | Tennessee | Montgomery | 47125 | 2547 | 30 | 0 | 2474 | 36.49609412 | -87.38550661 | 2020-09-03 04:28:22 | Montgomery, Tennessee, US |
1997313 | 1997313 | 2020-08-26 | US | Florida | Charlotte | 12015 | 2582 | 108 | 0 | 2474 | 26.90131002 | -81.92949121 | 2020-08-27 04:28:15 | Charlotte, Florida, US |
148781 | 148781 | 2020-08-15 | US | South Carolina | Orangeburg | 45075 | 2550 | 76 | 0 | 2474 | 33.4391073 | -80.79886287 | 2020-08-16 04:27:42 | Orangeburg, South Carolina, US |
3184506 | 3184506 | 2020-07-28 | US | Louisiana | Terrebonne | 22109 | 2546 | 72 | 0 | 2474 | 29.37343766 | -90.82626855 | 2020-07-29 04:35:11 | Terrebonne, Louisiana, US |
364444 | 364444 | 2020-07-16 | US | North Dakota | Cass | 38017 | 2590 | 73 | 0 | 2474 | 46.93201724 | -97.2444719 | 2020-07-17 04:34:50 | Cass, North Dakota, US |
2622969 | 2622969 | 2020-06-25 | US | Texas | Hidalgo | 48215 | 2394 | 29 | 0 | 2474 | 26.39418217 | -98.18299696 | 2020-06-26 04:33:43 | Hidalgo, Texas, 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]);