johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
63 rows where confirmed = 10940 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1152444 | 1152444 | 2022-12-12 | US | West Virginia | Marshall | 54051 | 10940 | 166 | 0 | 39.86064362 | -80.66591062 | 2022-12-13 04:21:01 | Marshall, West Virginia, US | |
852130 | 852130 | 2022-11-02 | US | Ohio | Williams | 39171 | 10940 | 169 | 0 | 41.56052014 | -84.58429552 | 2022-11-03 04:22:05 | Williams, Ohio, US | |
712981 | 712981 | 2022-11-01 | US | Ohio | Williams | 39171 | 10940 | 169 | 0 | 41.56052014 | -84.58429552 | 2022-11-02 04:22:09 | Williams, Ohio, US | |
3287430 | 3287430 | 2022-10-31 | US | Ohio | Williams | 39171 | 10940 | 169 | 0 | 41.56052014 | -84.58429552 | 2022-11-01 04:22:36 | Williams, Ohio, US | |
322463 | 322463 | 2022-10-30 | US | Ohio | Williams | 39171 | 10940 | 169 | 0 | 41.56052014 | -84.58429552 | 2022-10-31 04:21:36 | Williams, Ohio, US | |
914739 | 914739 | 2022-10-29 | US | Ohio | Williams | 39171 | 10940 | 169 | 0 | 41.56052014 | -84.58429552 | 2022-10-30 04:22:14 | Williams, Ohio, US | |
1369008 | 1369008 | 2022-10-28 | US | Ohio | Williams | 39171 | 10940 | 169 | 0 | 41.56052014 | -84.58429552 | 2022-10-29 04:21:13 | Williams, Ohio, US | |
3040863 | 3040863 | 2022-10-27 | US | Ohio | Williams | 39171 | 10940 | 169 | 0 | 41.56052014 | -84.58429552 | 2022-10-28 04:22:31 | Williams, Ohio, US | |
2324895 | 2324895 | 2022-08-24 | US | Louisiana | Vernon | 22115 | 10940 | 192 | 0 | 31.10884837 | -93.18153838 | 2022-08-25 04:21:13 | Vernon, Louisiana, US | |
2495064 | 2495064 | 2022-08-15 | US | Illinois | Morgan | 17137 | 10940 | 131 | 0 | 39.71654544 | -90.20255104 | 2022-08-16 04:20:58 | Morgan, Illinois, US | |
1098490 | 1098490 | 2022-08-03 | US | Alabama | Escambia | 1053 | 10940 | 174 | 0 | 31.1256789 | -87.15918694 | 2022-08-04 04:20:58 | Escambia, Alabama, US | |
1405415 | 1405415 | 2022-08-02 | US | Alabama | Escambia | 1053 | 10940 | 174 | 0 | 31.1256789 | -87.15918694 | 2022-08-03 04:20:59 | Escambia, Alabama, US | |
3617453 | 3617453 | 2022-08-01 | US | Alabama | Escambia | 1053 | 10940 | 174 | 0 | 31.1256789 | -87.15918694 | 2022-08-02 04:20:53 | Escambia, Alabama, US | |
3874736 | 3874736 | 2022-07-31 | US | Texas | Medina | 48325 | 10940 | 201 | 0 | 29.3557301 | -99.11030298 | 2022-08-01 04:21:03 | Medina, Texas, US | |
3871933 | 3871933 | 2022-07-31 | US | Alabama | Escambia | 1053 | 10940 | 174 | 0 | 31.1256789 | -87.15918694 | 2022-08-01 04:21:03 | Escambia, Alabama, US | |
677490 | 677490 | 2022-07-30 | US | Texas | Medina | 48325 | 10940 | 201 | 0 | 29.3557301 | -99.11030298 | 2022-07-31 04:21:02 | Medina, Texas, US | |
674687 | 674687 | 2022-07-30 | US | Alabama | Escambia | 1053 | 10940 | 174 | 0 | 31.1256789 | -87.15918694 | 2022-07-31 04:21:02 | Escambia, Alabama, US | |
1786689 | 1786689 | 2022-07-29 | US | Texas | Medina | 48325 | 10940 | 201 | 0 | 29.3557301 | -99.11030298 | 2022-07-30 04:20:42 | Medina, Texas, US | |
1783886 | 1783886 | 2022-07-29 | US | Alabama | Escambia | 1053 | 10940 | 174 | 0 | 31.1256789 | -87.15918694 | 2022-07-30 04:20:42 | Escambia, Alabama, US | |
3447429 | 3447429 | 2022-05-11 | US | Oklahoma | Osage | 40113 | 10940 | 167 | 0 | 36.62888819 | -96.39635704 | 2022-05-12 04:20:54 | Osage, Oklahoma, US | |
3538046 | 3538046 | 2022-05-10 | US | Oklahoma | Osage | 40113 | 10940 | 167 | 0 | 36.62888819 | -96.39635704 | 2022-05-11 04:20:48 | Osage, Oklahoma, US | |
224581 | 224581 | 2022-05-09 | US | Oklahoma | Osage | 40113 | 10940 | 167 | 0 | 36.62888819 | -96.39635704 | 2022-05-10 04:20:50 | Osage, Oklahoma, US | |
2333966 | 2333966 | 2022-05-08 | US | Oklahoma | Osage | 40113 | 10940 | 167 | 0 | 36.62888819 | -96.39635704 | 2022-05-09 04:20:54 | Osage, Oklahoma, US | |
362928 | 362928 | 2022-05-07 | US | Oklahoma | Osage | 40113 | 10940 | 167 | 0 | 36.62888819 | -96.39635704 | 2022-05-08 04:20:49 | Osage, Oklahoma, US | |
1400279 | 1400279 | 2022-05-06 | US | Oklahoma | Osage | 40113 | 10940 | 167 | 0 | 36.62888819 | -96.39635704 | 2022-05-07 04:21:09 | Osage, Oklahoma, US | |
2600634 | 2600634 | 2022-05-05 | US | Oklahoma | Osage | 40113 | 10940 | 167 | 0 | 36.62888819 | -96.39635704 | 2022-05-06 04:21:00 | Osage, Oklahoma, US | |
2804035 | 2804035 | 2022-04-06 | US | Texas | Wilson | 48493 | 10940 | 157 | 0 | 29.1732598 | -98.08693082 | 2022-04-07 04:20:53 | Wilson, Texas, US | |
3870804 | 3870804 | 2022-04-05 | US | Texas | Wilson | 48493 | 10940 | 157 | 0 | 29.1732598 | -98.08693082 | 2022-04-06 04:20:49 | Wilson, Texas, US | |
3025199 | 3025199 | 2022-03-23 | US | Tennessee | Cheatham | 47021 | 10940 | 119 | 0 | 36.26136216 | -87.08903581 | 2022-03-24 04:20:43 | Cheatham, Tennessee, US | |
697039 | 697039 | 2022-03-17 | US | Pennsylvania | Bedford | 42009 | 10940 | 273 | 0 | 40.00522157 | -78.48998442 | 2022-03-18 04:20:55 | Bedford, Pennsylvania, US | |
2143502 | 2143502 | 2022-03-09 | US | Virginia | Danville | 51590 | 10940 | 262 | 0 | 36.58022376 | -79.40395668 | 2022-03-10 04:20:48 | Danville, Virginia, US | |
923013 | 923013 | 2022-03-08 | US | Virginia | Danville | 51590 | 10940 | 262 | 0 | 36.58022376 | -79.40395668 | 2022-03-09 04:20:59 | Danville, Virginia, US | |
1995209 | 1995209 | 2022-03-01 | US | Oklahoma | Delaware | 40041 | 10940 | 190 | 0 | 36.40823634 | -94.80325046 | 2022-03-02 04:21:07 | Delaware, Oklahoma, US | |
945383 | 945383 | 2022-02-28 | US | Oklahoma | Delaware | 40041 | 10940 | 190 | 0 | 36.40823634 | -94.80325046 | 2022-03-01 04:21:09 | Delaware, Oklahoma, US | |
2735574 | 2735574 | 2022-02-27 | US | Oklahoma | Delaware | 40041 | 10940 | 190 | 0 | 36.40823634 | -94.80325046 | 2022-02-28 04:21:05 | Delaware, Oklahoma, US | |
3048727 | 3048727 | 2022-02-26 | US | Oklahoma | Delaware | 40041 | 10940 | 190 | 0 | 36.40823634 | -94.80325046 | 2022-02-27 04:21:04 | Delaware, Oklahoma, US | |
3046669 | 3046669 | 2022-02-26 | US | Arkansas | Hot Spring | 5059 | 10940 | 122 | 0 | 34.31709259 | -92.95396325 | 2022-02-27 04:21:04 | Hot Spring, Arkansas, US | |
577382 | 577382 | 2022-02-25 | US | Oklahoma | Delaware | 40041 | 10940 | 190 | 0 | 36.40823634 | -94.80325046 | 2022-02-26 04:21:12 | Delaware, Oklahoma, US | |
1513958 | 1513958 | 2022-02-24 | US | Oklahoma | Delaware | 40041 | 10940 | 190 | 0 | 36.40823634 | -94.80325046 | 2022-02-25 04:21:11 | Delaware, Oklahoma, US | |
1060399 | 1060399 | 2022-02-23 | US | Oklahoma | Delaware | 40041 | 10940 | 190 | 0 | 36.40823634 | -94.80325046 | 2022-02-24 04:21:14 | Delaware, Oklahoma, US | |
2645044 | 2645044 | 2022-02-14 | US | Vermont | Rutland | 50021 | 10940 | 58 | 0 | 43.57723578 | -73.03741676 | 2022-02-15 04:21:09 | Rutland, Vermont, US | |
1782955 | 1782955 | 2022-01-27 | US | Wisconsin | Oconto | 55083 | 10940 | 94 | 0 | 45.02715345 | -88.26807503 | 2022-01-28 04:21:09 | Oconto, Wisconsin, US | |
3616558 | 3616558 | 2022-01-12 | US | West Virginia | Marion | 54049 | 10940 | 142 | 0 | 39.50984542 | -80.24244659 | 2022-01-13 08:00:09 | Marion, West Virginia, US | |
3613133 | 3613133 | 2022-01-12 | Malaysia | W.P. Labuan | 10940 | 151 | 0 | 5.2831 | 115.2308 | 2022-01-13 08:00:09 | W.P. Labuan, Malaysia | |||
1284170 | 1284170 | 2022-01-05 | US | New Jersey | Salem | 34033 | 10940 | 218 | 0 | 39.58719656 | -75.34696629999998 | 2022-01-06 04:22:09 | Salem, New Jersey, US | |
152907 | 152907 | 2021-11-29 | US | Tennessee | Carter | 47019 | 10940 | 226 | 0 | 36.28969086 | -82.12588974 | 2021-11-30 04:22:53 | Carter, Tennessee, US | |
3514819 | 3514819 | 2021-11-01 | US | Virginia | Suffolk | 51800 | 10940 | 236 | 0 | 36.70155394 | -76.63603554 | 2021-11-02 04:22:03 | Suffolk, Virginia, US | |
3008420 | 3008420 | 2021-10-11 | US | Indiana | Floyd | 18043 | 10940 | 214 | 0 | 38.32117957 | -85.90385377 | 2021-10-12 04:21:09 | Floyd, Indiana, US | |
3013558 | 3013558 | 2021-09-22 | US | New York | Chautauqua | 36013 | 10940 | 156 | 0 | 42.22769210000001 | -79.36691763 | 2021-09-23 04:21:43 | Chautauqua, New York, US | |
2618955 | 2618955 | 2021-09-17 | US | Idaho | Bannock | 16005 | 10940 | 132 | 0 | 42.67002716 | -112.2233311 | 2021-09-18 04:21:24 | Bannock, Idaho, US | |
249111 | 249111 | 2021-09-04 | China | Unknown | 10940 | 0 | 0 | 2021-09-05 04:21:33 | Unknown, China | |||||
3894273 | 3894273 | 2021-08-29 | US | North Carolina | Moore | 37125 | 10940 | 209 | 0 | 35.30885257 | -79.48474178 | 2021-08-30 04:21:23 | Moore, North Carolina, US | |
2795376 | 2795376 | 2021-08-28 | US | North Carolina | Moore | 37125 | 10940 | 209 | 0 | 35.30885257 | -79.48474178 | 2021-08-29 04:21:14 | Moore, North Carolina, US | |
2925535 | 2925535 | 2021-08-27 | US | North Carolina | Moore | 37125 | 10940 | 209 | 0 | 35.30885257 | -79.48474178 | 2021-08-28 04:21:28 | Moore, North Carolina, US | |
2767757 | 2767757 | 2021-07-01 | US | South Carolina | Lancaster | 45057 | 10940 | 172 | 0 | 34.68270843 | -80.70513032 | 2021-07-02 04:21:47 | Lancaster, South Carolina, US | |
2912745 | 2912745 | 2021-06-17 | US | Maryland | Charles | 24017 | 10940 | 213 | 0 | 38.51092331 | -76.98580666 | 2021-06-18 04:22:16 | Charles, Maryland, US | |
1305098 | 1305098 | 2021-04-01 | US | Texas | Comal | 48091 | 10940 | 284 | 0 | 29.80811278 | -98.27647225 | 2021-04-02 04:20:36 | Comal, Texas, US | |
641212 | 641212 | 2021-03-31 | US | Virginia | Alexandria | 51510 | 10940 | 128 | 0 | 38.814003 | -77.08183073 | 2021-04-01 04:27:05 | Alexandria, Virginia, US | |
1156551 | 1156551 | 2021-02-18 | US | Washington | Franklin | 53021 | 10940 | 97 | 0 | 10843 | 46.53351425 | -118.9018212 | 2021-02-19 05:24:16 | Franklin, Washington, US |
3307993 | 3307993 | 2021-01-13 | Chile | Los Rios | 10940 | 111 | 9626 | 1203 | -40.231 | -72.3311 | 2021-01-14 05:22:32 | Los Rios, Chile | ||
2541127 | 2541127 | 2021-01-07 | Belgium | Unknown | 10940 | 19936 | 0 | 0 | 2021-01-08 05:22:42 | Unknown, Belgium | ||||
3230581 | 3230581 | 2021-01-03 | Netherlands | Zeeland | 10940 | 131 | 0 | 10813 | 51.47936 | 3.861559 | 2021-01-04 05:22:02 | Zeeland, Netherlands | ||
2409934 | 2409934 | 2020-12-23 | US | Texas | Hays | 48209 | 10940 | 122 | 0 | 10137 | 30.05669873 | -98.02944344 | 2020-12-24 05:23:04 | Hays, 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]);