johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
50 rows where confirmed = 15014 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
795427 | 795427 | 2022-10-24 | US | Illinois | Knox | 17095 | 15014 | 229 | 0 | 40.93148779 | -90.2133034 | 2022-10-25 04:21:53 | Knox, Illinois, US | |
422452 | 422452 | 2022-09-18 | US | Texas | Harrison | 48203 | 15014 | 230 | 0 | 32.54935988 | -94.36934071 | 2022-09-19 04:21:49 | Harrison, Texas, US | |
3376476 | 3376476 | 2022-09-17 | US | Texas | Harrison | 48203 | 15014 | 230 | 0 | 32.54935988 | -94.36934071 | 2022-09-18 04:22:50 | Harrison, Texas, US | |
2358584 | 2358584 | 2022-09-16 | US | Texas | Harrison | 48203 | 15014 | 230 | 0 | 32.54935988 | -94.36934071 | 2022-09-17 04:20:19 | Harrison, Texas, US | |
3872978 | 3872978 | 2022-07-31 | US | Kentucky | Henderson | 21101 | 15014 | 174 | 0 | 37.79344553 | -87.57392021 | 2022-08-01 04:21:03 | Henderson, Kentucky, US | |
675732 | 675732 | 2022-07-30 | US | Kentucky | Henderson | 21101 | 15014 | 174 | 0 | 37.79344553 | -87.57392021 | 2022-07-31 04:21:02 | Henderson, Kentucky, US | |
1784931 | 1784931 | 2022-07-29 | US | Kentucky | Henderson | 21101 | 15014 | 174 | 0 | 37.79344553 | -87.57392021 | 2022-07-30 04:20:42 | Henderson, Kentucky, US | |
1067294 | 1067294 | 2022-07-28 | US | Kentucky | Henderson | 21101 | 15014 | 174 | 0 | 37.79344553 | -87.57392021 | 2022-07-29 04:20:45 | Henderson, Kentucky, US | |
2338182 | 2338182 | 2022-07-27 | US | Puerto Rico | Trujillo Alto | 72139 | 15014 | 0 | 0 | 18.336159 | -65.998884 | 2022-07-28 04:20:56 | Trujillo Alto, Puerto Rico, US | |
2337636 | 2337636 | 2022-07-27 | US | New York | Genesee | 36037 | 15014 | 195 | 0 | 43.0022601 | -78.19135193 | 2022-07-28 04:20:56 | Genesee, New York, US | |
2336813 | 2336813 | 2022-07-27 | US | Kentucky | Henderson | 21101 | 15014 | 174 | 0 | 37.79344553 | -87.57392021 | 2022-07-28 04:20:56 | Henderson, Kentucky, US | |
1489826 | 1489826 | 2022-07-26 | US | New York | Genesee | 36037 | 15014 | 195 | 0 | 43.0022601 | -78.19135193 | 2022-07-27 04:21:04 | Genesee, New York, US | |
1489003 | 1489003 | 2022-07-26 | US | Kentucky | Henderson | 21101 | 15014 | 174 | 0 | 37.79344553 | -87.57392021 | 2022-07-27 04:21:04 | Henderson, Kentucky, US | |
2595449 | 2595449 | 2022-07-25 | US | Kentucky | Henderson | 21101 | 15014 | 174 | 0 | 37.79344553 | -87.57392021 | 2022-07-26 04:20:58 | Henderson, Kentucky, US | |
2150681 | 2150681 | 2022-06-27 | US | Texas | Caldwell | 48055 | 15014 | 176 | 0 | 29.83668859 | -97.61814775 | 2022-06-28 04:20:58 | Caldwell, Texas, US | |
3891109 | 3891109 | 2022-06-06 | US | West Virginia | Jefferson | 54037 | 15014 | 134 | 0 | 39.30776166 | -77.86014147 | 2022-06-07 04:21:08 | Jefferson, West Virginia, US | |
3208105 | 3208105 | 2022-04-11 | US | Mississippi | Pearl River | 28109 | 15014 | 275 | 0 | 30.77090935 | -89.58677275 | 2022-04-12 04:20:49 | Pearl River, Mississippi, US | |
1577991 | 1577991 | 2022-04-10 | US | Mississippi | Pearl River | 28109 | 15014 | 275 | 0 | 30.77090935 | -89.58677275 | 2022-04-11 04:21:02 | Pearl River, Mississippi, US | |
1654233 | 1654233 | 2022-04-09 | US | Mississippi | Pearl River | 28109 | 15014 | 275 | 0 | 30.77090935 | -89.58677275 | 2022-04-10 04:20:52 | Pearl River, Mississippi, US | |
2117555 | 2117555 | 2022-04-08 | US | Mississippi | Pearl River | 28109 | 15014 | 275 | 0 | 30.77090935 | -89.58677275 | 2022-04-09 04:20:42 | Pearl River, Mississippi, US | |
3322079 | 3322079 | 2022-04-07 | US | Mississippi | Pearl River | 28109 | 15014 | 275 | 0 | 30.77090935 | -89.58677275 | 2022-04-08 04:20:48 | Pearl River, Mississippi, US | |
2802615 | 2802615 | 2022-04-06 | US | Mississippi | Pearl River | 28109 | 15014 | 275 | 0 | 30.77090935 | -89.58677275 | 2022-04-07 04:20:53 | Pearl River, Mississippi, US | |
3869384 | 3869384 | 2022-04-05 | US | Mississippi | Pearl River | 28109 | 15014 | 275 | 0 | 30.77090935 | -89.58677275 | 2022-04-06 04:20:49 | Pearl River, Mississippi, US | |
2750726 | 2750726 | 2022-04-04 | US | Mississippi | Pearl River | 28109 | 15014 | 275 | 0 | 30.77090935 | -89.58677275 | 2022-04-05 04:20:48 | Pearl River, Mississippi, US | |
953781 | 953781 | 2022-03-12 | US | Tennessee | Bedford | 47003 | 15014 | 228 | 0 | 35.51123746 | -86.45549096 | 2022-03-13 04:20:49 | Bedford, Tennessee, US | |
1512479 | 1512479 | 2022-02-24 | US | Indiana | Boone | 18011 | 15014 | 164 | 0 | 40.0509304 | -86.46841646 | 2022-02-25 04:21:11 | Boone, Indiana, US | |
233864 | 233864 | 2022-02-11 | US | Colorado | Garfield | 8045 | 15014 | 90 | 0 | 39.59921777 | -107.902708 | 2022-02-12 04:21:06 | Garfield, Colorado, US | |
2613451 | 2613451 | 2022-01-06 | US | Virginia | Roanoke City | 51770 | 15014 | 273 | 0 | 37.27791025 | -79.96189766 | 2022-01-07 04:22:09 | Roanoke City, Virginia, US | |
2113888 | 2113888 | 2021-12-26 | US | New Mexico | Chaves | 35005 | 15014 | 231 | 0 | 33.36406072 | -104.4665365 | 2021-12-27 04:21:58 | Chaves, New Mexico, US | |
3607260 | 3607260 | 2021-12-25 | US | New Mexico | Chaves | 35005 | 15014 | 231 | 0 | 33.36406072 | -104.4665365 | 2021-12-26 04:21:50 | Chaves, New Mexico, US | |
2965578 | 2965578 | 2021-12-24 | US | New Mexico | Chaves | 35005 | 15014 | 231 | 0 | 33.36406072 | -104.4665365 | 2021-12-25 04:21:37 | Chaves, New Mexico, US | |
3818610 | 3818610 | 2021-12-23 | US | New Mexico | Chaves | 35005 | 15014 | 231 | 0 | 33.36406072 | -104.4665365 | 2021-12-24 04:21:34 | Chaves, New Mexico, US | |
32106 | 32106 | 2021-08-25 | Andorra | 15014 | 130 | 0 | 42.5063 | 1.5218 | 2021-08-26 04:21:28 | Andorra | ||||
408377 | 408377 | 2021-07-28 | Mexico | Colima | 15014 | 1254 | 0 | 13760 | 19.1223 | -104.0072 | 2021-07-29 04:21:33 | Colima, Mexico | ||
110101 | 110101 | 2021-06-19 | US | Pennsylvania | Cambria | 42021 | 15014 | 438 | 0 | 40.49527404 | -78.71377428 | 2021-06-20 04:21:48 | Cambria, Pennsylvania, US | |
3382293 | 3382293 | 2021-06-13 | US | Idaho | Bonneville | 16019 | 15014 | 174 | 0 | 43.38713372 | -111.6161537 | 2021-06-14 04:22:46 | Bonneville, Idaho, US | |
1737427 | 1737427 | 2021-06-12 | US | Idaho | Bonneville | 16019 | 15014 | 174 | 0 | 43.38713372 | -111.6161537 | 2021-06-13 04:22:44 | Bonneville, Idaho, US | |
3971468 | 3971468 | 2021-06-11 | US | Idaho | Bonneville | 16019 | 15014 | 174 | 0 | 43.38713372 | -111.6161537 | 2021-06-12 04:22:22 | Bonneville, Idaho, US | |
1452223 | 1452223 | 2021-06-03 | Ukraine | Sevastopol* | 15014 | 687 | 13745 | 582 | 44.6054 | 33.522 | 2021-06-04 04:23:37 | Sevastopol*, Ukraine | ||
3956749 | 3956749 | 2021-05-11 | US | New York | Saratoga | 36091 | 15014 | 166 | 0 | 43.10904162 | -73.86653895 | 2021-05-12 04:21:29 | Saratoga, New York, US | |
2823435 | 2823435 | 2021-05-10 | US | Pennsylvania | Franklin | 42055 | 15014 | 363 | 0 | 39.92956518 | -77.72157791 | 2021-05-11 04:20:41 | Franklin, Pennsylvania, US | |
3705207 | 3705207 | 2021-04-27 | US | Texas | Guadalupe | 48187 | 15014 | 209 | 0 | 29.58165339 | -97.94786822 | 2021-04-28 04:20:32 | Guadalupe, Texas, US | |
3883699 | 3883699 | 2021-04-11 | Mongolia | 15014 | 23 | 9159 | 5833 | 46.8625 | 103.8467 | 2021-04-12 04:21:00 | Mongolia | |||
3069551 | 3069551 | 2021-02-27 | US | Wisconsin | Marathon | 55073 | 15014 | 209 | 0 | 14805 | 44.89792533 | -89.75863384 | 2021-02-28 05:22:20 | Marathon, Wisconsin, US |
282534 | 282534 | 2021-02-24 | US | North Carolina | Robeson | 37155 | 15014 | 199 | 0 | 14815 | 34.64244496 | -79.10250529999998 | 2021-02-25 05:24:57 | Robeson, North Carolina, US |
3880215 | 3880215 | 2021-01-14 | US | Colorado | Pueblo | 8101 | 15014 | 355 | 0 | 13592 | 38.17359144 | -104.5127437 | 2021-01-15 05:22:24 | Pueblo, Colorado, US |
2815570 | 2815570 | 2020-09-25 | US | South Carolina | Richland | 45079 | 15014 | 235 | 0 | 14779 | 34.01791263 | -80.90267209 | 2020-09-26 04:23:00 | Richland, South Carolina, US |
753461 | 753461 | 2020-08-01 | Pakistan | Islamabad | 15014 | 165 | 12494 | 2355 | 33.665087 | 73.121219 | 2020-08-02 04:34:47 | Islamabad, Pakistan | ||
3264626 | 3264626 | 2020-07-31 | Pakistan | Islamabad | 15014 | 165 | 12494 | 2355 | 33.665087 | 73.121219 | 2020-08-01 04:36:27 | Islamabad, Pakistan | ||
3183895 | 3183895 | 2020-07-28 | US | Georgia | Out of GA | 80013 | 15014 | 75 | 0 | 14939 | 34.91369188 | 0.0 | 2020-07-29 04:35:11 | Out of GA, Georgia, 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]);