johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where confirmed = 11975 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
330056 | 330056 | 2022-12-27 | US | Nevada | Lyon | 32019 | 11975 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-28 04:21:04 | Lyon, Nevada, US | |
220129 | 220129 | 2022-12-26 | US | Nevada | Lyon | 32019 | 11975 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-27 04:21:07 | Lyon, Nevada, US | |
3224586 | 3224586 | 2022-12-25 | US | Nevada | Lyon | 32019 | 11975 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-26 04:21:06 | Lyon, Nevada, US | |
1020500 | 1020500 | 2022-12-24 | US | Nevada | Lyon | 32019 | 11975 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-25 04:21:04 | Lyon, Nevada, US | |
692523 | 692523 | 2022-12-23 | US | Nevada | Lyon | 32019 | 11975 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-24 04:21:02 | Lyon, Nevada, US | |
2181733 | 2181733 | 2022-12-22 | US | Nevada | Lyon | 32019 | 11975 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-23 04:21:04 | Lyon, Nevada, US | |
453537 | 453537 | 2022-12-21 | US | Nevada | Lyon | 32019 | 11975 | 183 | 0 | 39.01777974 | -119.1870479 | 2022-12-22 04:20:56 | Lyon, Nevada, US | |
350760 | 350760 | 2022-12-14 | US | Ohio | Defiance | 39039 | 11975 | 172 | 0 | 41.32398837 | -84.49076944 | 2022-12-15 04:20:58 | Defiance, Ohio, US | |
310348 | 310348 | 2022-12-13 | US | Ohio | Defiance | 39039 | 11975 | 172 | 0 | 41.32398837 | -84.49076944 | 2022-12-14 04:21:04 | Defiance, Ohio, US | |
1151409 | 1151409 | 2022-12-12 | US | Ohio | Defiance | 39039 | 11975 | 172 | 0 | 41.32398837 | -84.49076944 | 2022-12-13 04:21:01 | Defiance, Ohio, US | |
871263 | 871263 | 2022-12-11 | US | Ohio | Defiance | 39039 | 11975 | 172 | 0 | 41.32398837 | -84.49076944 | 2022-12-12 04:21:01 | Defiance, Ohio, US | |
259793 | 259793 | 2022-12-10 | US | Ohio | Defiance | 39039 | 11975 | 172 | 0 | 41.32398837 | -84.49076944 | 2022-12-11 04:20:50 | Defiance, Ohio, US | |
3938507 | 3938507 | 2022-12-09 | US | Ohio | Defiance | 39039 | 11975 | 172 | 0 | 41.32398837 | -84.49076944 | 2022-12-10 04:21:02 | Defiance, Ohio, US | |
3379839 | 3379839 | 2022-12-08 | US | Ohio | Defiance | 39039 | 11975 | 172 | 0 | 41.32398837 | -84.49076944 | 2022-12-09 04:21:05 | Defiance, Ohio, US | |
482914 | 482914 | 2022-11-08 | US | Virginia | Charlottesville | 51540 | 11975 | 85 | 0 | 38.03527919 | -78.48569588 | 2022-11-09 04:21:22 | Charlottesville, Virginia, US | |
3215292 | 3215292 | 2022-10-12 | US | Illinois | Fulton | 17057 | 11975 | 133 | 0 | 40.47289135 | -90.20862357 | 2022-10-13 04:22:39 | Fulton, Illinois, US | |
2968382 | 2968382 | 2022-10-10 | US | Illinois | Christian | 17021 | 11975 | 115 | 0 | 39.54581621 | -89.27780482 | 2022-10-11 04:23:05 | Christian, Illinois, US | |
3098418 | 3098418 | 2022-10-09 | US | Illinois | Christian | 17021 | 11975 | 115 | 0 | 39.54581621 | -89.27780482 | 2022-10-10 04:22:32 | Christian, Illinois, US | |
4003643 | 4003643 | 2022-10-08 | US | Illinois | Christian | 17021 | 11975 | 115 | 0 | 39.54581621 | -89.27780482 | 2022-10-09 04:21:16 | Christian, Illinois, US | |
397240 | 397240 | 2022-10-07 | US | Illinois | Christian | 17021 | 11975 | 115 | 0 | 39.54581621 | -89.27780482 | 2022-10-08 04:22:56 | Christian, Illinois, US | |
1396428 | 1396428 | 2022-09-02 | US | Puerto Rico | Isabela | 72071 | 11975 | 0 | 0 | 18.44981 | -67.005093 | 2022-09-03 04:21:04 | Isabela, Puerto Rico, US | |
2346158 | 2346158 | 2022-08-31 | US | Puerto Rico | Cayey | 72035 | 11975 | 0 | 0 | 18.102851 | -66.14914 | 2022-09-01 04:21:03 | Cayey, Puerto Rico, US | |
3545722 | 3545722 | 2022-08-08 | US | New York | Columbia | 36021 | 11975 | 152 | 0 | 42.24819348 | -73.63089095 | 2022-08-09 04:20:34 | Columbia, New York, US | |
1100534 | 1100534 | 2022-08-03 | US | North Dakota | Morton | 38059 | 11975 | 142 | 0 | 46.71681782 | -101.2822377 | 2022-08-04 04:20:58 | Morton, North Dakota, US | |
1573882 | 1573882 | 2022-05-03 | US | Minnesota | Mower | 27099 | 11975 | 73 | 0 | 43.67142874 | -92.75234549 | 2022-05-04 04:20:59 | Mower, Minnesota, US | |
3301224 | 3301224 | 2022-01-30 | US | Illinois | Macoupin | 17117 | 11975 | 128 | 0 | 39.26119767 | -89.92424028 | 2022-01-31 04:21:09 | Macoupin, Illinois, US | |
3063015 | 3063015 | 2022-01-29 | US | Illinois | Macoupin | 17117 | 11975 | 128 | 0 | 39.26119767 | -89.92424028 | 2022-01-30 04:21:26 | Macoupin, Illinois, US | |
3810949 | 3810949 | 2022-01-28 | US | Illinois | Macoupin | 17117 | 11975 | 128 | 0 | 39.26119767 | -89.92424028 | 2022-01-29 04:21:10 | Macoupin, Illinois, US | |
127077 | 127077 | 2022-01-09 | US | Alabama | Autauga | 1001 | 11975 | 162 | 0 | 32.53952745 | -86.64408227 | 2022-01-10 04:22:07 | Autauga, Alabama, US | |
1287125 | 1287125 | 2022-01-04 | US | Indiana | Morgan | 18109 | 11975 | 212 | 0 | 39.47899078 | -86.44573375 | 2022-01-05 04:21:59 | Morgan, Indiana, US | |
760832 | 760832 | 2021-11-26 | US | Ohio | Pickaway | 39129 | 11975 | 158 | 0 | 39.64170392 | -83.0243386 | 2021-11-27 04:22:45 | Pickaway, Ohio, US | |
32799 | 32799 | 2021-08-25 | US | Alabama | Limestone | 1083 | 11975 | 170 | 0 | 34.81185586 | -86.98310072 | 2021-08-26 04:21:28 | Limestone, Alabama, US | |
3105838 | 3105838 | 2021-08-24 | US | Alabama | Limestone | 1083 | 11975 | 170 | 0 | 34.81185586 | -86.98310072 | 2021-08-25 04:21:41 | Limestone, Alabama, US | |
3166009 | 3166009 | 2021-08-23 | US | Alabama | Limestone | 1083 | 11975 | 170 | 0 | 34.81185586 | -86.98310072 | 2021-08-24 04:21:19 | Limestone, Alabama, US | |
2177127 | 2177127 | 2021-08-22 | US | Maryland | Charles | 24017 | 11975 | 219 | 0 | 38.51092331 | -76.98580666 | 2021-08-23 04:21:27 | Charles, Maryland, US | |
3555646 | 3555646 | 2021-08-21 | Italy | Valle d'Aosta | 11975 | 473 | 0 | 45.73750286 | 7.320149366 | 2021-08-22 04:21:29 | Valle d'Aosta, Italy | |||
3470553 | 3470553 | 2021-08-03 | US | North Carolina | Wayne | 37191 | 11975 | 245 | 0 | 35.36438125 | -78.00027268 | 2021-08-04 04:21:25 | Wayne, North Carolina, US | |
1330057 | 1330057 | 2021-07-24 | China | Hong Kong | 11975 | 212 | 11696 | 67 | 22.3 | 114.2 | 2021-07-25 04:22:12 | Hong Kong, China | ||
3056394 | 3056394 | 2021-05-13 | US | New Mexico | Sandoval | 35043 | 11975 | 230 | 0 | 35.68862401 | -106.8687803 | 2021-05-14 04:20:41 | Sandoval, New Mexico, US | |
3245759 | 3245759 | 2021-04-21 | US | Washington | Franklin | 53021 | 11975 | 108 | 0 | 46.53351425 | -118.9018212 | 2021-04-22 04:20:53 | Franklin, Washington, US | |
3885252 | 3885252 | 2021-04-11 | US | Michigan | Muskegon | 26121 | 11975 | 312 | 0 | 43.29123859 | -86.15176712 | 2021-04-12 04:21:00 | Muskegon, Michigan, US | |
2984920 | 2984920 | 2021-04-10 | US | Michigan | Muskegon | 26121 | 11975 | 312 | 0 | 43.29123859 | -86.15176712 | 2021-04-11 04:20:56 | Muskegon, Michigan, US | |
1799741 | 1799741 | 2021-03-23 | US | Indiana | Madison | 18095 | 11975 | 331 | 0 | 40.16143691 | -85.71964711 | 2021-03-24 05:25:40 | Madison, Indiana, US | |
1001530 | 1001530 | 2021-03-01 | US | Texas | Grayson | 48181 | 11975 | 311 | 0 | 10477 | 33.62744998 | -96.67753461 | 2021-03-02 05:23:30 | Grayson, Texas, US |
2370588 | 2370588 | 2021-02-28 | US | Texas | Grayson | 48181 | 11975 | 310 | 0 | 10478 | 33.62744998 | -96.67753461 | 2021-03-01 05:23:01 | Grayson, Texas, US |
3069090 | 3069090 | 2021-02-27 | US | Texas | Grayson | 48181 | 11975 | 310 | 0 | 10478 | 33.62744998 | -96.67753461 | 2021-02-28 05:22:20 | Grayson, Texas, US |
1588708 | 1588708 | 2021-02-05 | US | California | Butte | 6007 | 11975 | 150 | 0 | 11882 | 39.66727762 | -121.6005252 | 2021-02-06 05:23:55 | Butte, California, US |
791379 | 791379 | 2021-02-04 | US | Illinois | Kankakee | 17091 | 11975 | 183 | 0 | 11792 | 41.13746989 | -87.86205334 | 2021-02-05 05:22:38 | Kankakee, Illinois, US |
2469263 | 2469263 | 2021-01-22 | US | Ohio | Greene | 39057 | 11975 | 203 | 0 | 11772 | 39.69116283 | -83.89032084 | 2021-01-23 05:22:03 | Greene, Ohio, US |
2629497 | 2629497 | 2021-01-10 | Ukraine | Luhansk Oblast | 11975 | 333 | 8607 | 3035 | 48.574 | 39.3078 | 2021-01-11 05:21:50 | Luhansk Oblast, Ukraine | ||
3899920 | 3899920 | 2021-01-09 | India | Nagaland | 11975 | 84 | 11778 | 113 | 26.06702 | 94.470302 | 2021-01-10 05:22:12 | Nagaland, India | ||
1901415 | 1901415 | 2020-12-18 | Russia | Tatarstan Republic | 11975 | 170 | 10445 | 1360 | 55.7648572 | 52.43104273 | 2020-12-19 05:27:52 | Tatarstan Republic, Russia | ||
1026888 | 1026888 | 2020-10-17 | US | California | Imperial | 6025 | 11975 | 330 | 0 | 11640 | 33.0393082 | -115.3669042 | 2020-10-18 04:24:25 | Imperial, California, US |
2849550 | 2849550 | 2020-09-18 | US | Florida | Osceola | 12097 | 11975 | 137 | 0 | 11838 | 28.06312234 | -81.14882926 | 2020-09-19 04:22:00 | Osceola, Florida, US |
1245260 | 1245260 | 2020-09-08 | US | Louisiana | Orleans | 22071 | 11975 | 581 | 0 | 11394 | 30.06971951 | -89.92660315 | 2020-09-09 04:28:48 | Orleans, Louisiana, US |
2299617 | 2299617 | 2020-08-22 | Peru | San Martin | 11975 | 1299 | 0 | 10676 | -7.039531 | -76.729127 | 2020-08-23 04:27:48 | San Martin, Peru | ||
3531542 | 3531542 | 2020-08-12 | Mexico | Oaxaca | 11975 | 1089 | 10113 | 773 | 17.0732 | -96.7266 | 2020-08-13 04:29:15 | Oaxaca, Mexico | ||
1836863 | 1836863 | 2020-06-14 | US | Massachusetts | Worcester | 25027 | 11975 | 870 | 0 | 11105 | 42.35026951 | -71.90493363 | 2020-06-15 03:33:14 | Worcester, Massachusetts, US |
1404583 | 1404583 | 2020-05-14 | Kuwait | 11975 | 88 | 3451 | 8436 | 29.311659999999996 | 47.481766 | 2020-05-15 02:33:02 | Kuwait |
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]);