johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
179 rows where confirmed = 5114 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1629687 | 1629687 | 2022-12-18 | US | Kentucky | Breathitt | 21025 | 5114 | 69 | 0 | 37.52333168 | -83.31959161 | 2022-12-19 04:21:03 | Breathitt, Kentucky, US | |
505066 | 505066 | 2022-12-17 | US | Kentucky | Breathitt | 21025 | 5114 | 69 | 0 | 37.52333168 | -83.31959161 | 2022-12-18 04:21:03 | Breathitt, Kentucky, US | |
3325638 | 3325638 | 2022-12-16 | US | Kentucky | Breathitt | 21025 | 5114 | 69 | 0 | 37.52333168 | -83.31959161 | 2022-12-17 04:21:04 | Breathitt, Kentucky, US | |
544150 | 544150 | 2022-12-15 | US | Kentucky | Breathitt | 21025 | 5114 | 69 | 0 | 37.52333168 | -83.31959161 | 2022-12-16 04:21:01 | Breathitt, Kentucky, US | |
349678 | 349678 | 2022-12-14 | US | Kentucky | Breathitt | 21025 | 5114 | 69 | 0 | 37.52333168 | -83.31959161 | 2022-12-15 04:20:58 | Breathitt, Kentucky, US | |
309266 | 309266 | 2022-12-13 | US | Kentucky | Breathitt | 21025 | 5114 | 69 | 0 | 37.52333168 | -83.31959161 | 2022-12-14 04:21:04 | Breathitt, Kentucky, US | |
1150327 | 1150327 | 2022-12-12 | US | Kentucky | Breathitt | 21025 | 5114 | 69 | 0 | 37.52333168 | -83.31959161 | 2022-12-13 04:21:01 | Breathitt, Kentucky, US | |
3554874 | 3554874 | 2022-11-27 | US | Texas | Shelby | 48419 | 5114 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-11-28 04:21:02 | Shelby, Texas, US | |
2103354 | 2103354 | 2022-11-26 | US | Texas | Shelby | 48419 | 5114 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-11-27 04:21:05 | Shelby, Texas, US | |
2102884 | 2102884 | 2022-11-26 | US | Puerto Rico | Jayuya | 72073 | 5114 | 0 | 0 | 18.211446 | -66.58878 | 2022-11-27 04:21:05 | Jayuya, Puerto Rico, US | |
490845 | 490845 | 2022-11-25 | US | Texas | Shelby | 48419 | 5114 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-11-26 04:21:11 | Shelby, Texas, US | |
490375 | 490375 | 2022-11-25 | US | Puerto Rico | Jayuya | 72073 | 5114 | 0 | 0 | 18.211446 | -66.58878 | 2022-11-26 04:21:11 | Jayuya, Puerto Rico, US | |
3526674 | 3526674 | 2022-11-24 | US | Texas | Shelby | 48419 | 5114 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-11-25 04:21:06 | Shelby, Texas, US | |
3526204 | 3526204 | 2022-11-24 | US | Puerto Rico | Jayuya | 72073 | 5114 | 0 | 0 | 18.211446 | -66.58878 | 2022-11-25 04:21:06 | Jayuya, Puerto Rico, US | |
3315457 | 3315457 | 2022-11-23 | US | Texas | Shelby | 48419 | 5114 | 136 | 0 | 31.79211404 | -94.14550696 | 2022-11-24 04:21:09 | Shelby, Texas, US | |
3461779 | 3461779 | 2022-11-21 | US | Michigan | Antrim | 26009 | 5114 | 74 | 0 | 44.99690221 | -85.15503082 | 2022-11-22 04:20:47 | Antrim, Michigan, US | |
1641964 | 1641964 | 2022-11-20 | US | Michigan | Antrim | 26009 | 5114 | 74 | 0 | 44.99690221 | -85.15503082 | 2022-11-21 04:21:05 | Antrim, Michigan, US | |
2065521 | 2065521 | 2022-11-19 | US | Michigan | Antrim | 26009 | 5114 | 74 | 0 | 44.99690221 | -85.15503082 | 2022-11-20 04:21:08 | Antrim, Michigan, US | |
1756915 | 1756915 | 2022-11-18 | US | Michigan | Antrim | 26009 | 5114 | 74 | 0 | 44.99690221 | -85.15503082 | 2022-11-19 04:21:14 | Antrim, Michigan, US | |
3027908 | 3027908 | 2022-11-17 | US | Michigan | Antrim | 26009 | 5114 | 74 | 0 | 44.99690221 | -85.15503082 | 2022-11-18 04:21:15 | Antrim, Michigan, US | |
2487619 | 2487619 | 2022-11-16 | US | Michigan | Antrim | 26009 | 5114 | 74 | 0 | 44.99690221 | -85.15503082 | 2022-11-17 04:21:11 | Antrim, Michigan, US | |
293630 | 293630 | 2022-11-15 | US | Michigan | Antrim | 26009 | 5114 | 74 | 0 | 44.99690221 | -85.15503082 | 2022-11-16 04:21:09 | Antrim, Michigan, US | |
850147 | 850147 | 2022-11-02 | US | California | Colusa | 6011 | 5114 | 22 | 0 | 39.17881957 | -122.2331726 | 2022-11-03 04:22:05 | Colusa, California, US | |
2272987 | 2272987 | 2022-10-20 | US | Illinois | White | 17193 | 5114 | 53 | 0 | 38.08706198 | -88.17657461 | 2022-10-21 04:22:23 | White, Illinois, US | |
3217650 | 3217650 | 2022-10-12 | US | Virginia | Grayson | 51077 | 5114 | 86 | 0 | 36.65677234 | -81.23215889 | 2022-10-13 04:22:39 | Grayson, Virginia, US | |
3100793 | 3100793 | 2022-10-09 | US | Virginia | Goochland | 51075 | 5114 | 58 | 0 | 37.71714806 | -77.90381514 | 2022-10-10 04:22:32 | Goochland, Virginia, US | |
4006018 | 4006018 | 2022-10-08 | US | Virginia | Goochland | 51075 | 5114 | 58 | 0 | 37.71714806 | -77.90381514 | 2022-10-09 04:21:16 | Goochland, Virginia, US | |
399615 | 399615 | 2022-10-07 | US | Virginia | Goochland | 51075 | 5114 | 58 | 0 | 37.71714806 | -77.90381514 | 2022-10-08 04:22:56 | Goochland, Virginia, US | |
3996208 | 3996208 | 2022-09-27 | US | Maine | Washington | 23029 | 5114 | 61 | 0 | 45.01607142 | -67.62813524 | 2022-09-28 04:23:01 | Washington, Maine, US | |
2636642 | 2636642 | 2022-09-05 | US | Tennessee | Bledsoe | 47007 | 5114 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-09-06 04:21:02 | Bledsoe, Tennessee, US | |
2990206 | 2990206 | 2022-09-04 | US | Tennessee | Bledsoe | 47007 | 5114 | 61 | 0 | 35.59942968 | -85.20611967 | 2022-09-05 04:21:01 | Bledsoe, Tennessee, US | |
992135 | 992135 | 2022-08-16 | US | Indiana | Starke | 18149 | 5114 | 104 | 0 | 41.27890281 | -86.64686895 | 2022-08-17 04:20:59 | Starke, Indiana, US | |
2495174 | 2495174 | 2022-08-15 | US | Indiana | Starke | 18149 | 5114 | 104 | 0 | 41.27890281 | -86.64686895 | 2022-08-16 04:20:58 | Starke, Indiana, US | |
1971575 | 1971575 | 2022-08-13 | US | Tennessee | Polk | 47139 | 5114 | 83 | 0 | 35.12245443 | -84.52075859 | 2022-08-14 04:20:55 | Polk, Tennessee, US | |
1098621 | 1098621 | 2022-08-03 | US | Arkansas | Lincoln | 5079 | 5114 | 69 | 0 | 33.95317155 | -91.74002806 | 2022-08-04 04:20:58 | Lincoln, Arkansas, US | |
959448 | 959448 | 2022-07-19 | US | California | Inyo | 6027 | 5114 | 56 | 0 | 36.51112084 | -117.4111978 | 2022-07-20 04:20:59 | Inyo, California, US | |
3365937 | 3365937 | 2022-07-02 | US | Colorado | Chaffee | 8015 | 5114 | 50 | 0 | 38.74745778 | -106.1926573 | 2022-07-03 04:20:59 | Chaffee, Colorado, US | |
559208 | 559208 | 2022-06-16 | US | Alabama | Randolph | 1111 | 5114 | 75 | 0 | 33.29526734 | -85.45708831 | 2022-06-17 04:20:56 | Randolph, Alabama, US | |
3158674 | 3158674 | 2022-06-09 | US | Illinois | Pike | 17149 | 5114 | 68 | 0 | 39.62265059 | -90.8877017 | 2022-06-10 04:20:55 | Pike, Illinois, US | |
3727049 | 3727049 | 2022-06-07 | US | Georgia | Jones | 13169 | 5114 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-08 04:20:55 | Jones, Georgia, US | |
3888451 | 3888451 | 2022-06-06 | US | Georgia | Jones | 13169 | 5114 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-07 04:21:08 | Jones, Georgia, US | |
3508220 | 3508220 | 2022-06-05 | US | Georgia | Jones | 13169 | 5114 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-06 04:20:57 | Jones, Georgia, US | |
3528297 | 3528297 | 2022-06-04 | US | Georgia | Jones | 13169 | 5114 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-05 04:20:55 | Jones, Georgia, US | |
3134383 | 3134383 | 2022-06-03 | US | Georgia | Jones | 13169 | 5114 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-04 04:20:58 | Jones, Georgia, US | |
3134172 | 3134172 | 2022-06-03 | US | Colorado | Elbert | 8039 | 5114 | 41 | 0 | 39.28656773 | -104.1358721 | 2022-06-04 04:20:58 | Elbert, Colorado, US | |
3579458 | 3579458 | 2022-06-02 | US | Georgia | Jones | 13169 | 5114 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-03 04:20:58 | Jones, Georgia, US | |
971751 | 971751 | 2022-06-01 | US | Georgia | Jones | 13169 | 5114 | 109 | 0 | 33.02512137 | -83.56019163 | 2022-06-02 05:20:39 | Jones, Georgia, US | |
1186247 | 1186247 | 2022-05-18 | US | Louisiana | Concordia | 22029 | 5114 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-05-19 04:20:54 | Concordia, Louisiana, US | |
3583445 | 3583445 | 2022-05-17 | US | Georgia | Fannin | 13111 | 5114 | 160 | 0 | 34.86430205 | -84.316964 | 2022-05-18 04:20:50 | Fannin, Georgia, US | |
1504402 | 1504402 | 2022-05-16 | US | Georgia | Fannin | 13111 | 5114 | 160 | 0 | 34.86430205 | -84.316964 | 2022-05-17 04:20:59 | Fannin, Georgia, US | |
2084761 | 2084761 | 2022-05-15 | US | Georgia | Fannin | 13111 | 5114 | 160 | 0 | 34.86430205 | -84.316964 | 2022-05-16 04:20:47 | Fannin, Georgia, US | |
3355471 | 3355471 | 2022-05-14 | US | Georgia | Fannin | 13111 | 5114 | 160 | 0 | 34.86430205 | -84.316964 | 2022-05-15 04:20:53 | Fannin, Georgia, US | |
659116 | 659116 | 2022-05-13 | US | Georgia | Fannin | 13111 | 5114 | 160 | 0 | 34.86430205 | -84.316964 | 2022-05-14 04:20:48 | Fannin, Georgia, US | |
2534199 | 2534199 | 2022-05-12 | US | Georgia | Fannin | 13111 | 5114 | 160 | 0 | 34.86430205 | -84.316964 | 2022-05-13 04:20:51 | Fannin, Georgia, US | |
2533861 | 2533861 | 2022-05-12 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-13 04:20:51 | Ashley, Arkansas, US | |
3445645 | 3445645 | 2022-05-11 | US | Georgia | Fannin | 13111 | 5114 | 160 | 0 | 34.86430205 | -84.316964 | 2022-05-12 04:20:54 | Fannin, Georgia, US | |
3535924 | 3535924 | 2022-05-10 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-11 04:20:48 | Ashley, Arkansas, US | |
222459 | 222459 | 2022-05-09 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-10 04:20:50 | Ashley, Arkansas, US | |
2331844 | 2331844 | 2022-05-08 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-09 04:20:54 | Ashley, Arkansas, US | |
360806 | 360806 | 2022-05-07 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-08 04:20:49 | Ashley, Arkansas, US | |
1398157 | 1398157 | 2022-05-06 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-07 04:21:09 | Ashley, Arkansas, US | |
2598512 | 2598512 | 2022-05-05 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-06 04:21:00 | Ashley, Arkansas, US | |
3265961 | 3265961 | 2022-05-04 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-05 04:20:55 | Ashley, Arkansas, US | |
1572600 | 1572600 | 2022-05-03 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-04 04:20:59 | Ashley, Arkansas, US | |
463860 | 463860 | 2022-05-02 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-03 04:21:00 | Ashley, Arkansas, US | |
3916499 | 3916499 | 2022-05-01 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-02 04:21:10 | Ashley, Arkansas, US | |
2841303 | 2841303 | 2022-04-30 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-05-01 04:20:57 | Ashley, Arkansas, US | |
1157616 | 1157616 | 2022-04-29 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-04-30 04:21:05 | Ashley, Arkansas, US | |
1696798 | 1696798 | 2022-04-28 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-04-29 04:20:59 | Ashley, Arkansas, US | |
3852281 | 3852281 | 2022-04-27 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.7698471 | 2022-04-28 04:20:47 | Ashley, Arkansas, US | |
1326711 | 1326711 | 2022-04-26 | US | Arkansas | Ashley | 5003 | 5114 | 66 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-27 04:20:52 | Ashley, Arkansas, US | |
2443220 | 2443220 | 2022-04-13 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-13 23:21:06 | Ashley, Arkansas, US | |
1948977 | 1948977 | 2022-04-12 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-13 04:21:03 | Ashley, Arkansas, US | |
3206730 | 3206730 | 2022-04-11 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-12 04:20:49 | Ashley, Arkansas, US | |
1576616 | 1576616 | 2022-04-10 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-11 04:21:02 | Ashley, Arkansas, US | |
1652858 | 1652858 | 2022-04-09 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-10 04:20:52 | Ashley, Arkansas, US | |
2116180 | 2116180 | 2022-04-08 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-09 04:20:42 | Ashley, Arkansas, US | |
3320704 | 3320704 | 2022-04-07 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-08 04:20:48 | Ashley, Arkansas, US | |
3320594 | 3320594 | 2022-04-07 | US | Alabama | Cherokee | 1019 | 5114 | 85 | 0 | 34.17805983 | -85.60638968 | 2022-04-08 04:20:48 | Cherokee, Alabama, US | |
2801240 | 2801240 | 2022-04-06 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-07 04:20:53 | Ashley, Arkansas, US | |
3868009 | 3868009 | 2022-04-05 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-06 04:20:49 | Ashley, Arkansas, US | |
2749351 | 2749351 | 2022-04-04 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-05 04:20:48 | Ashley, Arkansas, US | |
3730697 | 3730697 | 2022-04-03 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-04 04:20:51 | Ashley, Arkansas, US | |
500132 | 500132 | 2022-04-02 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-03 04:20:48 | Ashley, Arkansas, US | |
3351117 | 3351117 | 2022-04-01 | US | Arkansas | Ashley | 5003 | 5114 | 65 | 0 | 33.19153461 | -91.76984709999999 | 2022-04-02 04:20:47 | Ashley, Arkansas, US | |
1548955 | 1548955 | 2022-03-07 | US | Illinois | Edgar | 17045 | 5114 | 58 | 0 | 39.6809186 | -87.74759563 | 2022-03-08 04:20:54 | Edgar, Illinois, US | |
2528325 | 2528325 | 2022-03-02 | US | Tennessee | Johnson | 47091 | 5114 | 87 | 0 | 36.45523950000001 | -81.84886538 | 2022-03-03 04:21:01 | Johnson, Tennessee, US | |
1058248 | 1058248 | 2022-02-23 | US | Alabama | Pickens | 1107 | 5114 | 96 | 0 | 33.28094866 | -88.08818103 | 2022-02-24 04:21:14 | Pickens, Alabama, US | |
3877166 | 3877166 | 2022-02-19 | US | Maryland | Somerset | 24039 | 5114 | 69 | 0 | 38.1163542 | -75.75118623 | 2022-02-20 04:21:00 | Somerset, Maryland, US | |
3821381 | 3821381 | 2022-02-16 | US | Idaho | Jerome | 16053 | 5114 | 61 | 0 | 42.68891267 | -114.2655033 | 2022-02-17 04:20:56 | Jerome, Idaho, US | |
187208 | 187208 | 2022-02-13 | US | Indiana | Spencer | 18147 | 5114 | 56 | 0 | 38.01519732 | -87.0079644 | 2022-02-14 04:20:51 | Spencer, Indiana, US | |
317054 | 317054 | 2022-02-12 | US | Indiana | Spencer | 18147 | 5114 | 56 | 0 | 38.01519732 | -87.0079644 | 2022-02-13 04:21:00 | Spencer, Indiana, US | |
234380 | 234380 | 2022-02-11 | US | Indiana | Spencer | 18147 | 5114 | 56 | 0 | 38.01519732 | -87.0079644 | 2022-02-12 04:21:06 | Spencer, Indiana, US | |
3302657 | 3302657 | 2022-01-30 | US | Ohio | Carroll | 39019 | 5114 | 119 | 0 | 40.578968599999996 | -81.09178213 | 2022-01-31 04:21:09 | Carroll, Ohio, US | |
1142066 | 1142066 | 2022-01-23 | US | Indiana | Washington | 18175 | 5114 | 70 | 0 | 38.60219804 | -86.1049363 | 2022-01-24 04:21:12 | Washington, Indiana, US | |
2834803 | 2834803 | 2022-01-22 | US | Missouri | Stone | 29209 | 5114 | 102 | 0 | 36.75000327 | -93.45256475 | 2022-01-23 04:21:13 | Stone, Missouri, US | |
2833984 | 2833984 | 2022-01-22 | US | Indiana | Washington | 18175 | 5114 | 70 | 0 | 38.60219804 | -86.1049363 | 2022-01-23 04:21:13 | Washington, Indiana, US | |
3426102 | 3426102 | 2022-01-21 | US | Indiana | Washington | 18175 | 5114 | 70 | 0 | 38.60219804 | -86.1049363 | 2022-01-22 04:21:13 | Washington, Indiana, US | |
1962536 | 1962536 | 2022-01-20 | US | Missouri | Washington | 29221 | 5114 | 114 | 0 | 37.96130078 | -90.87948158 | 2022-01-21 04:21:09 | Washington, Missouri, US | |
3690797 | 3690797 | 2022-01-13 | US | Virginia | Carroll | 51035 | 5114 | 113 | 0 | 36.73066666 | -80.73455942 | 2022-01-14 04:21:54 | Carroll, Virginia, 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]);