johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
148 rows where confirmed = 5269 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 11
- US 131
- Palau 7
- Russia 2
- China 1
- Colombia 1
- Eswatini 1
- Iceland 1
- Japan 1
- Mozambique 1
- Saint Lucia 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3176543 | 3176543 | 2022-12-19 | US | Puerto Rico | Jayuya | 72073 | 5269 | 0 | 0 | 18.211446 | -66.58878 | 2022-12-20 04:21:04 | Jayuya, Puerto Rico, US | |
315110 | 315110 | 2022-11-13 | US | Texas | Reeves | 48389 | 5269 | 75 | 0 | 31.32323325 | -103.6903896 | 2022-11-14 04:21:09 | Reeves, Texas, US | |
66271 | 66271 | 2022-11-12 | US | Texas | Reeves | 48389 | 5269 | 75 | 0 | 31.32323325 | -103.6903896 | 2022-11-13 04:21:14 | Reeves, Texas, US | |
2930433 | 2930433 | 2022-11-11 | US | Texas | Reeves | 48389 | 5269 | 75 | 0 | 31.32323325 | -103.6903896 | 2022-11-12 04:20:41 | Reeves, Texas, US | |
2509269 | 2509269 | 2022-11-10 | US | Texas | Reeves | 48389 | 5269 | 75 | 0 | 31.32323325 | -103.6903896 | 2022-11-11 04:21:22 | Reeves, Texas, US | |
2434144 | 2434144 | 2022-11-09 | US | Texas | Reeves | 48389 | 5269 | 75 | 0 | 31.32323325 | -103.6903896 | 2022-11-10 04:21:16 | Reeves, Texas, US | |
711305 | 711305 | 2022-11-01 | US | Georgia | Morgan | 13211 | 5269 | 71 | 0 | 33.59232073 | -83.49129491 | 2022-11-02 04:22:09 | Morgan, Georgia, US | |
3285754 | 3285754 | 2022-10-31 | US | Georgia | Morgan | 13211 | 5269 | 71 | 0 | 33.59232073 | -83.49129491 | 2022-11-01 04:22:36 | Morgan, Georgia, US | |
320787 | 320787 | 2022-10-30 | US | Georgia | Morgan | 13211 | 5269 | 71 | 0 | 33.59232073 | -83.49129491 | 2022-10-31 04:21:36 | Morgan, Georgia, US | |
913063 | 913063 | 2022-10-29 | US | Georgia | Morgan | 13211 | 5269 | 71 | 0 | 33.59232073 | -83.49129491 | 2022-10-30 04:22:14 | Morgan, Georgia, US | |
1367332 | 1367332 | 2022-10-28 | US | Georgia | Morgan | 13211 | 5269 | 71 | 0 | 33.59232073 | -83.49129491 | 2022-10-29 04:21:13 | Morgan, Georgia, US | |
3039187 | 3039187 | 2022-10-27 | US | Georgia | Morgan | 13211 | 5269 | 71 | 0 | 33.59232073 | -83.49129491 | 2022-10-28 04:22:31 | Morgan, Georgia, US | |
539607 | 539607 | 2022-10-26 | US | Georgia | Morgan | 13211 | 5269 | 71 | 0 | 33.59232073 | -83.49129491 | 2022-10-27 04:22:01 | Morgan, Georgia, US | |
2686670 | 2686670 | 2022-10-03 | US | Illinois | Cass | 17017 | 5269 | 37 | 0 | 39.96991073 | -90.24734436 | 2022-10-04 04:22:55 | Cass, Illinois, US | |
3574086 | 3574086 | 2022-09-19 | US | West Virginia | Hardy | 54031 | 5269 | 51 | 0 | 39.00683177 | -78.85855301 | 2022-09-20 04:22:48 | Hardy, West Virginia, US | |
2346203 | 2346203 | 2022-08-31 | US | Puerto Rico | Sabana Grande | 72121 | 5269 | 0 | 0 | 18.08282 | -66.943758 | 2022-09-01 04:21:03 | Sabana Grande, Puerto Rico, US | |
2406146 | 2406146 | 2022-08-21 | US | Virginia | Buchanan | 51027 | 5269 | 129 | 0 | 37.26818323 | -82.03749726 | 2022-08-22 04:20:38 | Buchanan, Virginia, US | |
3801224 | 3801224 | 2022-08-20 | US | Virginia | Buchanan | 51027 | 5269 | 129 | 0 | 37.26818323 | -82.03749726 | 2022-08-21 04:20:44 | Buchanan, Virginia, US | |
2366810 | 2366810 | 2022-08-19 | US | Virginia | Buchanan | 51027 | 5269 | 129 | 0 | 37.26818323 | -82.03749726 | 2022-08-20 04:21:01 | Buchanan, Virginia, US | |
1405651 | 1405651 | 2022-08-02 | US | Colorado | Chaffee | 8015 | 5269 | 51 | 0 | 38.74745778 | -106.1926573 | 2022-08-03 04:20:59 | Chaffee, Colorado, US | |
1069349 | 1069349 | 2022-07-28 | US | West Virginia | Barbour | 54001 | 5269 | 74 | 0 | 39.1307219 | -80.00350858 | 2022-07-29 04:20:45 | Barbour, West Virginia, US | |
2421928 | 2421928 | 2022-07-15 | US | Texas | Burleson | 48051 | 5269 | 67 | 0 | 30.49273808 | -96.62158484 | 2022-07-16 04:21:05 | Burleson, Texas, US | |
1211954 | 1211954 | 2022-07-11 | US | Alabama | Randolph | 1111 | 5269 | 75 | 0 | 33.29526734 | -85.45708831 | 2022-07-12 04:20:51 | Randolph, Alabama, US | |
1211704 | 1211704 | 2022-07-11 | Palau | 5269 | 6 | 0 | 7.515 | 134.5825 | 2022-07-12 04:20:51 | Palau | ||||
2789186 | 2789186 | 2022-07-10 | Palau | 5269 | 6 | 0 | 7.515 | 134.5825 | 2022-07-11 04:20:46 | Palau | ||||
142139 | 142139 | 2022-07-09 | Palau | 5269 | 6 | 0 | 7.515 | 134.5825 | 2022-07-10 04:20:54 | Palau | ||||
1417239 | 1417239 | 2022-07-08 | Palau | 5269 | 6 | 0 | 7.515 | 134.5825 | 2022-07-09 04:20:59 | Palau | ||||
2741164 | 2741164 | 2022-07-07 | Palau | 5269 | 6 | 0 | 7.515 | 134.5825 | 2022-07-08 04:20:56 | Palau | ||||
1199959 | 1199959 | 2022-07-06 | Palau | 5269 | 6 | 0 | 7.515 | 134.5825 | 2022-07-07 04:20:55 | Palau | ||||
3966702 | 3966702 | 2022-07-05 | Palau | 5269 | 6 | 0 | 7.515 | 134.5825 | 2022-07-06 04:20:58 | Palau | ||||
949810 | 949810 | 2022-06-14 | US | Tennessee | Johnson | 47091 | 5269 | 95 | 0 | 36.4552395 | -81.84886538 | 2022-06-15 04:20:54 | Johnson, Tennessee, US | |
3581558 | 3581558 | 2022-06-02 | US | Tennessee | Crockett | 47033 | 5269 | 87 | 0 | 35.81830662 | -89.14916269 | 2022-06-03 04:20:58 | Crockett, Tennessee, US | |
3189353 | 3189353 | 2022-05-30 | US | Virginia | King George | 51099 | 5269 | 39 | 0 | 38.26818502 | -77.15852768 | 2022-05-31 04:20:51 | King George, Virginia, US | |
3201502 | 3201502 | 2022-05-29 | US | Virginia | King George | 51099 | 5269 | 39 | 0 | 38.26818502 | -77.15852768 | 2022-05-30 04:20:50 | King George, Virginia, US | |
2728380 | 2728380 | 2022-05-28 | US | Virginia | King George | 51099 | 5269 | 39 | 0 | 38.26818502 | -77.15852768 | 2022-05-29 04:20:53 | King George, Virginia, US | |
1317561 | 1317561 | 2022-05-27 | US | Virginia | King George | 51099 | 5269 | 39 | 0 | 38.26818502 | -77.15852768 | 2022-05-28 04:21:07 | King George, Virginia, US | |
1506323 | 1506323 | 2022-05-16 | US | Puerto Rico | Barranquitas | 72019 | 5269 | 0 | 0 | 18.201592 | -66.30963 | 2022-05-17 04:20:59 | Barranquitas, Puerto Rico, US | |
2533796 | 2533796 | 2022-05-12 | US | Alabama | Pickens | 1107 | 5269 | 102 | 0 | 33.28094866 | -88.08818103 | 2022-05-13 04:20:51 | Pickens, Alabama, US | |
3267947 | 3267947 | 2022-05-04 | US | Ohio | Carroll | 39019 | 5269 | 127 | 0 | 40.5789686 | -81.09178213 | 2022-05-05 04:20:55 | Carroll, Ohio, US | |
1574586 | 1574586 | 2022-05-03 | US | Ohio | Carroll | 39019 | 5269 | 127 | 0 | 40.5789686 | -81.09178213 | 2022-05-04 04:20:59 | Carroll, Ohio, US | |
465846 | 465846 | 2022-05-02 | US | Ohio | Carroll | 39019 | 5269 | 127 | 0 | 40.5789686 | -81.09178213 | 2022-05-03 04:21:00 | Carroll, Ohio, US | |
465597 | 465597 | 2022-05-02 | US | New Mexico | Lincoln | 35027 | 5269 | 67 | 0 | 33.74526079 | -105.4586166 | 2022-05-03 04:21:00 | Lincoln, New Mexico, US | |
3918485 | 3918485 | 2022-05-01 | US | Ohio | Carroll | 39019 | 5269 | 127 | 0 | 40.5789686 | -81.09178213 | 2022-05-02 04:21:10 | Carroll, Ohio, US | |
2843289 | 2843289 | 2022-04-30 | US | Ohio | Carroll | 39019 | 5269 | 127 | 0 | 40.5789686 | -81.09178213 | 2022-05-01 04:20:57 | Carroll, Ohio, US | |
1159602 | 1159602 | 2022-04-29 | US | Ohio | Carroll | 39019 | 5269 | 127 | 0 | 40.5789686 | -81.09178213 | 2022-04-30 04:21:05 | Carroll, Ohio, US | |
1698784 | 1698784 | 2022-04-28 | US | Ohio | Carroll | 39019 | 5269 | 127 | 0 | 40.5789686 | -81.09178213 | 2022-04-29 04:20:59 | Carroll, Ohio, US | |
2029163 | 2029163 | 2022-04-24 | US | Alabama | Monroe | 1099 | 5269 | 80 | 0 | 31.56729412 | -87.36995001 | 2022-04-25 04:20:56 | Monroe, Alabama, US | |
746738 | 746738 | 2022-04-23 | US | Alabama | Monroe | 1099 | 5269 | 80 | 0 | 31.56729412 | -87.36995001 | 2022-04-24 04:20:56 | Monroe, Alabama, US | |
3437223 | 3437223 | 2022-04-22 | US | Alabama | Monroe | 1099 | 5269 | 80 | 0 | 31.56729412 | -87.36995001 | 2022-04-23 04:20:50 | Monroe, Alabama, US | |
1949277 | 1949277 | 2022-04-12 | US | Georgia | Burke | 13033 | 5269 | 108 | 0 | 33.05917989 | -81.99928721 | 2022-04-13 04:21:03 | Burke, Georgia, US | |
3207030 | 3207030 | 2022-04-11 | US | Georgia | Burke | 13033 | 5269 | 107 | 0 | 33.05917989 | -81.99928721 | 2022-04-12 04:20:49 | Burke, Georgia, US | |
3731375 | 3731375 | 2022-04-03 | US | Indiana | Sullivan | 18153 | 5269 | 76 | 0 | 39.08952258 | -87.41414469 | 2022-04-04 04:20:51 | Sullivan, Indiana, US | |
500810 | 500810 | 2022-04-02 | US | Indiana | Sullivan | 18153 | 5269 | 76 | 0 | 39.08952258 | -87.41414469 | 2022-04-03 04:20:48 | Sullivan, Indiana, US | |
3351795 | 3351795 | 2022-04-01 | US | Indiana | Sullivan | 18153 | 5269 | 76 | 0 | 39.08952258 | -87.41414469 | 2022-04-02 04:20:47 | Sullivan, Indiana, US | |
1541100 | 1541100 | 2022-03-31 | US | Indiana | Sullivan | 18153 | 5269 | 74 | 0 | 39.08952258 | -87.41414469 | 2022-04-01 04:20:28 | Sullivan, Indiana, US | |
2479113 | 2479113 | 2022-03-30 | US | Indiana | Sullivan | 18153 | 5269 | 74 | 0 | 39.08952258 | -87.41414469 | 2022-03-31 04:20:56 | Sullivan, Indiana, US | |
159154 | 159154 | 2022-03-29 | US | Indiana | Sullivan | 18153 | 5269 | 74 | 0 | 39.08952258 | -87.41414469 | 2022-03-30 04:20:45 | Sullivan, Indiana, US | |
2265823 | 2265823 | 2022-03-14 | US | Missouri | McDonald | 29119 | 5269 | 66 | 0 | 36.62869595 | -94.34867205 | 2022-03-15 04:20:47 | McDonald, Missouri, US | |
1868759 | 1868759 | 2022-03-10 | US | Vermont | Addison | 50001 | 5269 | 15 | 0 | 44.03217337 | -73.14130877 | 2022-03-11 04:20:50 | Addison, Vermont, US | |
186876 | 186876 | 2022-02-13 | US | Georgia | Franklin | 13119 | 5269 | 91 | 0 | 34.37525597 | -83.23159927 | 2022-02-14 04:20:51 | Franklin, Georgia, US | |
316722 | 316722 | 2022-02-12 | US | Georgia | Franklin | 13119 | 5269 | 91 | 0 | 34.37525597 | -83.23159927 | 2022-02-13 04:21:00 | Franklin, Georgia, US | |
234048 | 234048 | 2022-02-11 | US | Georgia | Franklin | 13119 | 5269 | 91 | 0 | 34.37525597 | -83.23159927 | 2022-02-12 04:21:06 | Franklin, Georgia, US | |
1297128 | 1297128 | 2022-02-05 | US | Texas | Frio | 48163 | 5269 | 84 | 0 | 28.86751206 | -99.10804207 | 2022-02-06 04:21:00 | Frio, Texas, US | |
982336 | 982336 | 2022-02-01 | US | Virginia | Page | 51139 | 5269 | 97 | 0 | 38.61807452 | -78.48797204 | 2022-02-02 04:21:09 | Page, Virginia, US | |
3812972 | 3812972 | 2022-01-28 | US | Texas | Calhoun | 48057 | 5269 | 41 | 0 | 28.47048236 | -96.61633945 | 2022-01-29 04:21:10 | Calhoun, Texas, US | |
3228823 | 3228823 | 2022-01-19 | US | North Carolina | Transylvania | 37175 | 5269 | 56 | 0 | 35.20383864 | -82.79638423 | 2022-01-20 04:21:07 | Transylvania, North Carolina, US | |
1114822 | 1114822 | 2022-01-11 | US | Iowa | Plymouth | 19149 | 5269 | 92 | 0 | 42.737633 | -96.21366621 | 2022-01-12 04:21:44 | Plymouth, Iowa, US | |
1693550 | 1693550 | 2022-01-10 | US | Iowa | Plymouth | 19149 | 5269 | 92 | 0 | 42.737633 | -96.21366621 | 2022-01-11 04:22:01 | Plymouth, Iowa, US | |
127965 | 127965 | 2022-01-09 | US | Iowa | Plymouth | 19149 | 5269 | 92 | 0 | 42.737633 | -96.21366621 | 2022-01-10 04:22:07 | Plymouth, Iowa, US | |
1216800 | 1216800 | 2022-01-08 | US | Iowa | Plymouth | 19149 | 5269 | 92 | 0 | 42.737633 | -96.21366621 | 2022-01-09 04:21:46 | Plymouth, Iowa, US | |
1390893 | 1390893 | 2022-01-07 | US | Iowa | Plymouth | 19149 | 5269 | 92 | 0 | 42.737633 | -96.21366621 | 2022-01-08 04:21:53 | Plymouth, Iowa, US | |
2611280 | 2611280 | 2022-01-06 | US | Iowa | Plymouth | 19149 | 5269 | 92 | 0 | 42.737633 | -96.21366621 | 2022-01-07 04:22:09 | Plymouth, Iowa, US | |
1285418 | 1285418 | 2022-01-05 | US | Virginia | Wythe | 51197 | 5269 | 119 | 0 | 36.91582035 | -81.07834059 | 2022-01-06 04:22:09 | Wythe, Virginia, US | |
1283222 | 1283222 | 2022-01-05 | US | Iowa | Plymouth | 19149 | 5269 | 92 | 0 | 42.737633 | -96.21366621 | 2022-01-06 04:22:09 | Plymouth, Iowa, US | |
733196 | 733196 | 2021-12-27 | US | Pennsylvania | Elk | 42047 | 5269 | 74 | 0 | 41.42822061 | -78.64524744 | 2021-12-28 04:21:47 | Elk, Pennsylvania, US | |
2112988 | 2112988 | 2021-12-26 | US | Kansas | Geary | 20061 | 5269 | 62 | 0 | 38.99871131 | -96.7577178 | 2021-12-27 04:21:58 | Geary, Kansas, US | |
3606360 | 3606360 | 2021-12-25 | US | Kansas | Geary | 20061 | 5269 | 62 | 0 | 38.99871131 | -96.7577178 | 2021-12-26 04:21:50 | Geary, Kansas, US | |
2964678 | 2964678 | 2021-12-24 | US | Kansas | Geary | 20061 | 5269 | 62 | 0 | 38.99871131 | -96.7577178 | 2021-12-25 04:21:37 | Geary, Kansas, US | |
3817710 | 3817710 | 2021-12-23 | US | Kansas | Geary | 20061 | 5269 | 62 | 0 | 38.99871131 | -96.7577178 | 2021-12-24 04:21:34 | Geary, Kansas, US | |
799718 | 799718 | 2021-12-22 | US | Kansas | Geary | 20061 | 5269 | 62 | 0 | 38.99871131 | -96.7577178 | 2021-12-23 04:21:21 | Geary, Kansas, US | |
3830312 | 3830312 | 2021-12-21 | US | Mississippi | Prentiss | 28117 | 5269 | 86 | 0 | 34.61810501 | -88.51986294 | 2021-12-22 04:21:54 | Prentiss, Mississippi, US | |
783027 | 783027 | 2021-12-13 | US | Colorado | Logan | 8075 | 5269 | 97 | 0 | 40.7249637 | -103.110817 | 2021-12-14 04:22:38 | Logan, Colorado, US | |
406792 | 406792 | 2021-12-07 | US | Ohio | Morrow | 39117 | 5269 | 68 | 0 | 40.52363560000001 | -82.7892599 | 2021-12-08 04:22:46 | Morrow, Ohio, US | |
2078 | 2078 | 2021-12-02 | US | Minnesota | Nobles | 27105 | 5269 | 54 | 0 | 43.67434621 | -95.75329576 | 2021-12-03 04:23:05 | Nobles, Minnesota, US | |
1235025 | 1235025 | 2021-11-28 | US | Virginia | Prince George | 51149 | 5269 | 51 | 0 | 37.18497668 | -77.22922187 | 2021-11-29 04:22:30 | Prince George, Virginia, US | |
1361732 | 1361732 | 2021-11-27 | US | Virginia | Prince George | 51149 | 5269 | 51 | 0 | 37.18497668 | -77.22922187 | 2021-11-28 04:22:43 | Prince George, Virginia, US | |
761723 | 761723 | 2021-11-26 | US | Virginia | Prince George | 51149 | 5269 | 51 | 0 | 37.18497668 | -77.22922187 | 2021-11-27 04:22:45 | Prince George, Virginia, US | |
724449 | 724449 | 2021-11-20 | US | Missouri | Polk | 29167 | 5269 | 50 | 0 | 37.616229600000004 | -93.39828174 | 2021-11-21 04:22:13 | Polk, Missouri, US | |
723880 | 723880 | 2021-11-20 | US | Kentucky | Calloway | 21035 | 5269 | 64 | 0 | 36.62093411 | -88.2731593 | 2021-11-21 04:22:13 | Calloway, Kentucky, US | |
3344645 | 3344645 | 2021-11-16 | US | Montana | Ravalli | 30081 | 5269 | 69 | 0 | 46.08520862 | -114.11891640000002 | 2021-11-17 04:21:48 | Ravalli, Montana, US | |
3342988 | 3342988 | 2021-11-16 | US | Alabama | Dallas | 1047 | 5269 | 207 | 0 | 32.32688101 | -87.10866709999998 | 2021-11-17 04:21:48 | Dallas, Alabama, US | |
89055 | 89055 | 2021-11-09 | US | Missouri | Marion | 29127 | 5269 | 64 | 0 | 39.80601912 | -91.62203062 | 2021-11-10 04:21:38 | Marion, Missouri, US | |
3643171 | 3643171 | 2021-11-08 | US | Wyoming | Teton | 56039 | 5269 | 14 | 0 | 43.93522482 | -110.5890801 | 2021-11-09 04:21:36 | Teton, Wyoming, US | |
7404 | 7404 | 2021-10-28 | US | Texas | Cooke | 48097 | 5269 | 101 | 0 | 33.63979567 | -97.21240912 | 2021-10-29 04:22:03 | Cooke, Texas, US | |
444343 | 444343 | 2021-10-20 | US | Illinois | Fulton | 17057 | 5269 | 76 | 0 | 40.47289135 | -90.20862357 | 2021-10-21 04:21:18 | Fulton, Illinois, US | |
600181 | 600181 | 2021-10-19 | US | Ohio | Putnam | 39137 | 5269 | 113 | 0 | 41.02094889 | -84.1336111 | 2021-10-20 04:21:00 | Putnam, Ohio, US | |
2458821 | 2458821 | 2021-10-06 | Japan | Wakayama | 5269 | 61 | 0 | 33.911879 | 135.505446 | 2021-10-07 04:21:36 | Wakayama, Japan | |||
988117 | 988117 | 2021-10-04 | US | Indiana | Steuben | 18151 | 5269 | 70 | 0 | 41.64423868 | -85.00101094 | 2021-10-05 04:21:27 | Steuben, Indiana, US | |
1275172 | 1275172 | 2021-10-03 | US | Georgia | Toombs | 13279 | 5269 | 155 | 0 | 32.12059861 | -82.32957247 | 2021-10-04 04:21:31 | Toombs, Georgia, US | |
3928925 | 3928925 | 2021-10-02 | US | Georgia | Toombs | 13279 | 5269 | 155 | 0 | 32.12059861 | -82.32957247 | 2021-10-03 04:21:24 | Toombs, 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]);