johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
179 rows where confirmed = 4586 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
451886 | 451886 | 2022-12-21 | US | Arkansas | Izard | 5065 | 4586 | 77 | 0 | 36.09604046 | -91.90847954 | 2022-12-22 04:20:56 | Izard, Arkansas, US | |
3324779 | 3324779 | 2022-12-16 | US | Arkansas | Polk | 5113 | 4586 | 160 | 0 | 34.48254879 | -94.22728802 | 2022-12-17 04:21:04 | Polk, Arkansas, US | |
308701 | 308701 | 2022-12-13 | US | Georgia | Greene | 13133 | 4586 | 90 | 0 | 33.5769205 | -83.17139104 | 2022-12-14 04:21:04 | Greene, Georgia, US | |
1149762 | 1149762 | 2022-12-12 | US | Georgia | Greene | 13133 | 4586 | 90 | 0 | 33.5769205 | -83.17139104 | 2022-12-13 04:21:01 | Greene, Georgia, US | |
869616 | 869616 | 2022-12-11 | US | Georgia | Greene | 13133 | 4586 | 90 | 0 | 33.5769205 | -83.17139104 | 2022-12-12 04:21:01 | Greene, Georgia, US | |
258146 | 258146 | 2022-12-10 | US | Georgia | Greene | 13133 | 4586 | 90 | 0 | 33.5769205 | -83.17139104 | 2022-12-11 04:20:50 | Greene, Georgia, US | |
3936860 | 3936860 | 2022-12-09 | US | Georgia | Greene | 13133 | 4586 | 90 | 0 | 33.5769205 | -83.17139104 | 2022-12-10 04:21:02 | Greene, Georgia, US | |
3378192 | 3378192 | 2022-12-08 | US | Georgia | Greene | 13133 | 4586 | 90 | 0 | 33.5769205 | -83.17139104 | 2022-12-09 04:21:05 | Greene, Georgia, US | |
2557351 | 2557351 | 2022-11-29 | US | Georgia | Brantley | 13025 | 4586 | 114 | 0 | 31.19576557 | -81.97743999 | 2022-11-30 04:21:07 | Brantley, Georgia, US | |
1240425 | 1240425 | 2022-11-28 | US | Georgia | Brantley | 13025 | 4586 | 114 | 0 | 31.19576557 | -81.97743999 | 2022-11-29 04:21:05 | Brantley, Georgia, US | |
3552413 | 3552413 | 2022-11-27 | US | Georgia | Brantley | 13025 | 4586 | 114 | 0 | 31.19576557 | -81.97743999 | 2022-11-28 04:21:02 | Brantley, Georgia, US | |
2100893 | 2100893 | 2022-11-26 | US | Georgia | Brantley | 13025 | 4586 | 114 | 0 | 31.19576557 | -81.97743999 | 2022-11-27 04:21:05 | Brantley, Georgia, US | |
488384 | 488384 | 2022-11-25 | US | Georgia | Brantley | 13025 | 4586 | 114 | 0 | 31.19576557 | -81.97743999 | 2022-11-26 04:21:11 | Brantley, Georgia, US | |
3524213 | 3524213 | 2022-11-24 | US | Georgia | Brantley | 13025 | 4586 | 114 | 0 | 31.19576557 | -81.97743999 | 2022-11-25 04:21:06 | Brantley, Georgia, US | |
3312996 | 3312996 | 2022-11-23 | US | Georgia | Brantley | 13025 | 4586 | 114 | 0 | 31.19576557 | -81.97743999 | 2022-11-24 04:21:09 | Brantley, Georgia, US | |
3598940 | 3598940 | 2022-11-14 | US | Missouri | Cooper | 29053 | 4586 | 80 | 0 | 38.844478 | -92.80896081 | 2022-11-15 04:21:16 | Cooper, Missouri, US | |
313798 | 313798 | 2022-11-13 | US | Missouri | Cooper | 29053 | 4586 | 80 | 0 | 38.844478 | -92.80896081 | 2022-11-14 04:21:09 | Cooper, Missouri, US | |
64959 | 64959 | 2022-11-12 | US | Missouri | Cooper | 29053 | 4586 | 80 | 0 | 38.844478 | -92.80896081 | 2022-11-13 04:21:14 | Cooper, Missouri, US | |
2929121 | 2929121 | 2022-11-11 | US | Missouri | Cooper | 29053 | 4586 | 80 | 0 | 38.844478 | -92.80896081 | 2022-11-12 04:20:41 | Cooper, Missouri, US | |
2507957 | 2507957 | 2022-11-10 | US | Missouri | Cooper | 29053 | 4586 | 80 | 0 | 38.844478 | -92.80896081 | 2022-11-11 04:21:22 | Cooper, Missouri, US | |
2432832 | 2432832 | 2022-11-09 | US | Missouri | Cooper | 29053 | 4586 | 80 | 0 | 38.844478 | -92.80896081 | 2022-11-10 04:21:16 | Cooper, Missouri, US | |
481488 | 481488 | 2022-11-08 | US | Missouri | Cooper | 29053 | 4586 | 80 | 0 | 38.844478 | -92.80896081 | 2022-11-09 04:21:22 | Cooper, Missouri, US | |
322360 | 322360 | 2022-10-30 | US | North Dakota | Richland | 38077 | 4586 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-10-31 04:21:36 | Richland, North Dakota, US | |
914636 | 914636 | 2022-10-29 | US | North Dakota | Richland | 38077 | 4586 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-10-30 04:22:14 | Richland, North Dakota, US | |
1368905 | 1368905 | 2022-10-28 | US | North Dakota | Richland | 38077 | 4586 | 23 | 0 | 46.26440649 | -96.94852979 | 2022-10-29 04:21:13 | Richland, North Dakota, US | |
3766830 | 3766830 | 2022-09-11 | US | Idaho | Minidoka | 16067 | 4586 | 66 | 0 | 42.85518524 | -113.6357257 | 2022-09-12 04:20:58 | Minidoka, Idaho, US | |
3827225 | 3827225 | 2022-09-10 | US | Puerto Rico | Patillas | 72109 | 4586 | 0 | 0 | 18.03174 | -66.012242 | 2022-09-11 04:20:50 | Patillas, Puerto Rico, US | |
3825405 | 3825405 | 2022-09-10 | US | Idaho | Minidoka | 16067 | 4586 | 66 | 0 | 42.85518524 | -113.6357257 | 2022-09-11 04:20:50 | Minidoka, Idaho, US | |
965682 | 965682 | 2022-09-09 | US | Puerto Rico | Patillas | 72109 | 4586 | 0 | 0 | 18.03174 | -66.012242 | 2022-09-10 04:21:10 | Patillas, Puerto Rico, US | |
963862 | 963862 | 2022-09-09 | US | Idaho | Minidoka | 16067 | 4586 | 66 | 0 | 42.85518524 | -113.6357257 | 2022-09-10 04:21:10 | Minidoka, Idaho, US | |
1251932 | 1251932 | 2022-08-23 | US | Iowa | Cedar | 19031 | 4586 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-24 04:20:46 | Cedar, Iowa, US | |
2854036 | 2854036 | 2022-08-22 | US | Iowa | Cedar | 19031 | 4586 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-23 04:20:56 | Cedar, Iowa, US | |
2404008 | 2404008 | 2022-08-21 | US | Iowa | Cedar | 19031 | 4586 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-22 04:20:38 | Cedar, Iowa, US | |
3799086 | 3799086 | 2022-08-20 | US | Iowa | Cedar | 19031 | 4586 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-21 04:20:44 | Cedar, Iowa, US | |
2364672 | 2364672 | 2022-08-19 | US | Iowa | Cedar | 19031 | 4586 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-20 04:21:01 | Cedar, Iowa, US | |
1162343 | 1162343 | 2022-08-18 | US | Iowa | Cedar | 19031 | 4586 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-19 04:20:54 | Cedar, Iowa, US | |
3951667 | 3951667 | 2022-08-17 | US | Iowa | Cedar | 19031 | 4586 | 37 | 0 | 41.77233777 | -91.13246684 | 2022-08-18 04:21:11 | Cedar, Iowa, US | |
1349243 | 1349243 | 2022-08-10 | US | Tennessee | Cannon | 47015 | 4586 | 68 | 0 | 35.80990797 | -86.05738983 | 2022-08-11 04:20:49 | Cannon, Tennessee, US | |
1088955 | 1088955 | 2022-08-09 | US | South Dakota | Hughes | 46065 | 4586 | 60 | 0 | 44.39091534 | -99.99661148 | 2022-08-10 04:20:57 | Hughes, South Dakota, US | |
3546370 | 3546370 | 2022-08-08 | US | South Dakota | Hughes | 46065 | 4586 | 60 | 0 | 44.39091534 | -99.99661148 | 2022-08-09 04:20:34 | Hughes, South Dakota, US | |
1072773 | 1072773 | 2022-08-07 | US | South Dakota | Hughes | 46065 | 4586 | 60 | 0 | 44.39091534 | -99.99661148 | 2022-08-08 04:21:08 | Hughes, South Dakota, US | |
1943361 | 1943361 | 2022-08-06 | US | South Dakota | Hughes | 46065 | 4586 | 60 | 0 | 44.39091534 | -99.99661148 | 2022-08-07 04:20:54 | Hughes, South Dakota, US | |
883160 | 883160 | 2022-08-05 | US | South Dakota | Hughes | 46065 | 4586 | 60 | 0 | 44.39091534 | -99.99661148 | 2022-08-06 04:20:56 | Hughes, South Dakota, US | |
2011571 | 2011571 | 2022-08-04 | US | South Dakota | Hughes | 46065 | 4586 | 60 | 0 | 44.39091534 | -99.99661148 | 2022-08-05 04:20:52 | Hughes, South Dakota, US | |
1100998 | 1100998 | 2022-08-03 | US | South Dakota | Hughes | 46065 | 4586 | 60 | 0 | 44.39091534 | -99.99661148 | 2022-08-04 04:20:58 | Hughes, South Dakota, US | |
1066967 | 1066967 | 2022-07-28 | US | Indiana | Franklin | 18047 | 4586 | 67 | 0 | 39.4142482 | -85.06062647 | 2022-07-29 04:20:45 | Franklin, Indiana, US | |
2336486 | 2336486 | 2022-07-27 | US | Indiana | Franklin | 18047 | 4586 | 67 | 0 | 39.4142482 | -85.06062647 | 2022-07-28 04:20:56 | Franklin, Indiana, US | |
2241750 | 2241750 | 2022-06-28 | US | North Carolina | Northampton | 37131 | 4586 | 86 | 0 | 36.41736238 | -77.39769443 | 2022-06-29 04:20:59 | Northampton, North Carolina, US | |
2149992 | 2149992 | 2022-06-27 | US | North Carolina | Northampton | 37131 | 4586 | 86 | 0 | 36.41736238 | -77.39769443 | 2022-06-28 04:20:58 | Northampton, North Carolina, US | |
477793 | 477793 | 2022-06-26 | US | North Carolina | Northampton | 37131 | 4586 | 86 | 0 | 36.41736238 | -77.39769443 | 2022-06-27 04:21:00 | Northampton, North Carolina, US | |
941168 | 941168 | 2022-06-25 | US | North Carolina | Northampton | 37131 | 4586 | 86 | 0 | 36.41736238 | -77.39769443 | 2022-06-26 04:21:02 | Northampton, North Carolina, US | |
3348988 | 3348988 | 2022-06-24 | US | North Carolina | Northampton | 37131 | 4586 | 86 | 0 | 36.41736238 | -77.39769443 | 2022-06-25 04:20:57 | Northampton, North Carolina, US | |
1651902 | 1651902 | 2022-06-23 | US | West Virginia | Wetzel | 54103 | 4586 | 87 | 0 | 39.6065771 | -80.6401654 | 2022-06-24 04:20:58 | Wetzel, West Virginia, US | |
1650729 | 1650729 | 2022-06-23 | US | North Carolina | Northampton | 37131 | 4586 | 86 | 0 | 36.41736238 | -77.39769443 | 2022-06-24 04:20:58 | Northampton, North Carolina, US | |
2189964 | 2189964 | 2022-06-22 | US | North Carolina | Northampton | 37131 | 4586 | 86 | 0 | 36.41736238 | -77.39769443 | 2022-06-23 04:20:55 | Northampton, North Carolina, US | |
166844 | 166844 | 2022-06-21 | US | Georgia | Elbert | 13105 | 4586 | 109 | 0 | 34.11302332 | -82.83936148 | 2022-06-22 04:20:54 | Elbert, Georgia, US | |
1764127 | 1764127 | 2022-06-20 | US | Georgia | Elbert | 13105 | 4586 | 109 | 0 | 34.11302332 | -82.83936148 | 2022-06-21 04:20:56 | Elbert, Georgia, US | |
3270313 | 3270313 | 2022-06-19 | US | Georgia | Elbert | 13105 | 4586 | 109 | 0 | 34.11302332 | -82.83936148 | 2022-06-20 04:21:01 | Elbert, Georgia, US | |
3398225 | 3398225 | 2022-06-18 | US | Georgia | Elbert | 13105 | 4586 | 109 | 0 | 34.11302332 | -82.83936148 | 2022-06-19 04:20:51 | Elbert, Georgia, US | |
2312102 | 2312102 | 2022-06-17 | US | Georgia | Elbert | 13105 | 4586 | 109 | 0 | 34.11302332 | -82.83936148 | 2022-06-18 04:21:10 | Elbert, Georgia, US | |
559606 | 559606 | 2022-06-16 | US | Georgia | Elbert | 13105 | 4586 | 109 | 0 | 34.11302332 | -82.83936148 | 2022-06-17 04:20:56 | Elbert, Georgia, US | |
3983408 | 3983408 | 2022-06-15 | US | Georgia | Elbert | 13105 | 4586 | 109 | 0 | 34.11302332 | -82.83936148 | 2022-06-16 04:20:55 | Elbert, Georgia, US | |
1947707 | 1947707 | 2022-06-10 | US | Texas | Robertson | 48395 | 4586 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-06-11 04:21:01 | Robertson, Texas, US | |
3160846 | 3160846 | 2022-06-09 | US | Texas | Robertson | 48395 | 4586 | 77 | 0 | 31.02539637 | -96.51272246 | 2022-06-10 04:20:55 | Robertson, Texas, US | |
3890537 | 3890537 | 2022-06-06 | US | Tennessee | Benton | 47005 | 4586 | 94 | 0 | 36.07110411 | -88.06849355 | 2022-06-07 04:21:08 | Benton, Tennessee, US | |
1503978 | 1503978 | 2022-05-16 | US | Alabama | Henry | 1067 | 4586 | 76 | 0 | 31.51148016 | -85.24267944 | 2022-05-17 04:20:59 | Henry, Alabama, US | |
2601631 | 2601631 | 2022-05-05 | US | Wisconsin | Sawyer | 55113 | 4586 | 62 | 0 | 45.87931905 | -91.14504927 | 2022-05-06 04:21:00 | Sawyer, Wisconsin, US | |
3266049 | 3266049 | 2022-05-04 | US | California | Inyo | 6027 | 4586 | 56 | 0 | 36.51112084 | -117.4111978 | 2022-05-05 04:20:55 | Inyo, California, US | |
1572688 | 1572688 | 2022-05-03 | US | California | Inyo | 6027 | 4586 | 56 | 0 | 36.51112084 | -117.4111978 | 2022-05-04 04:20:59 | Inyo, California, US | |
466088 | 466088 | 2022-05-02 | US | Pennsylvania | Montour | 42093 | 4586 | 93 | 0 | 41.03023987 | -76.66345939 | 2022-05-03 04:21:00 | Montour, Pennsylvania, US | |
2307886 | 2307886 | 2022-04-20 | US | Colorado | Alamosa | 8003 | 4586 | 62 | 0 | 37.57250606 | -105.7885451 | 2022-04-21 04:20:46 | Alamosa, Colorado, US | |
2254619 | 2254619 | 2022-04-19 | US | Texas | Panola | 48365 | 4586 | 129 | 0 | 32.163959600000005 | -94.30552481 | 2022-04-20 04:20:45 | Panola, Texas, US | |
1849169 | 1849169 | 2022-04-18 | US | Texas | Panola | 48365 | 4586 | 129 | 0 | 32.163959600000005 | -94.30552481 | 2022-04-19 04:21:00 | Panola, Texas, US | |
1655532 | 1655532 | 2022-04-09 | US | Texas | Jones | 48253 | 4586 | 92 | 0 | 32.73997145 | -99.87861576 | 2022-04-10 04:20:52 | Jones, Texas, US | |
2322057 | 2322057 | 2022-03-16 | US | Puerto Rico | Cabo Rojo | 72023 | 4586 | 0 | 0 | 18.040993 | -67.154391 | 2022-03-17 04:20:56 | Cabo Rojo, Puerto Rico, US | |
1867162 | 1867162 | 2022-03-10 | US | Michigan | Roscommon | 26143 | 4586 | 111 | 0 | 44.33473082 | -84.61067651 | 2022-03-11 04:20:50 | Roscommon, Michigan, US | |
2141857 | 2141857 | 2022-03-09 | US | Michigan | Roscommon | 26143 | 4586 | 111 | 0 | 44.33473082 | -84.61067651 | 2022-03-10 04:20:48 | Roscommon, Michigan, US | |
2141143 | 2141143 | 2022-03-09 | US | Illinois | Cass | 17017 | 4586 | 35 | 0 | 39.96991073 | -90.24734436 | 2022-03-10 04:20:48 | Cass, Illinois, US | |
920213 | 920213 | 2022-03-08 | US | Arkansas | Sharp | 5135 | 4586 | 100 | 0 | 36.16258158 | -91.47819342 | 2022-03-09 04:20:59 | Sharp, Arkansas, US | |
2202143 | 2202143 | 2022-03-06 | US | Ohio | Paulding | 39125 | 4586 | 74 | 0 | 41.11676341 | -84.5801017 | 2022-03-07 04:20:47 | Paulding, Ohio, US | |
1995865 | 1995865 | 2022-03-01 | US | Texas | Reeves | 48389 | 4586 | 71 | 0 | 31.32323325 | -103.69038959999999 | 2022-03-02 04:21:07 | Reeves, Texas, US | |
1058757 | 1058757 | 2022-02-23 | US | Georgia | Worth | 13321 | 4586 | 107 | 0 | 31.55162306 | -83.85090513 | 2022-02-24 04:21:14 | Worth, Georgia, US | |
3720161 | 3720161 | 2022-02-21 | US | Missouri | Texas | 29215 | 4586 | 87 | 0 | 37.31728859 | -91.96564727 | 2022-02-22 04:21:01 | Texas, Missouri, US | |
3913995 | 3913995 | 2022-02-20 | US | Missouri | Texas | 29215 | 4586 | 87 | 0 | 37.31728859 | -91.96564727 | 2022-02-21 04:21:05 | Texas, Missouri, US | |
3877553 | 3877553 | 2022-02-19 | US | Missouri | Texas | 29215 | 4586 | 87 | 0 | 37.31728859 | -91.96564727 | 2022-02-20 04:21:00 | Texas, Missouri, US | |
3857809 | 3857809 | 2022-02-18 | US | Missouri | Texas | 29215 | 4586 | 87 | 0 | 37.31728859 | -91.96564727 | 2022-02-19 04:21:11 | Texas, Missouri, US | |
3821565 | 3821565 | 2022-02-16 | US | Indiana | Perry | 18123 | 4586 | 58 | 0 | 38.07809328 | -86.63741946 | 2022-02-17 04:20:56 | Perry, Indiana, US | |
1365438 | 1365438 | 2022-02-08 | US | Texas | Fayette | 48149 | 4586 | 98 | 0 | 29.87788372 | -96.92076062 | 2022-02-09 04:21:04 | Fayette, Texas, US | |
2474702 | 2474702 | 2022-02-03 | US | Georgia | Appling | 13001 | 4586 | 113 | 0 | 31.74847232 | -82.28909114 | 2022-02-04 04:21:10 | Appling, Georgia, US | |
3690286 | 3690286 | 2022-01-13 | US | South Carolina | Barnwell | 45011 | 4586 | 88 | 0 | 33.26679302 | -81.43584352 | 2022-01-14 04:21:54 | Barnwell, South Carolina, US | |
2611909 | 2611909 | 2022-01-06 | US | Mississippi | Wayne | 28153 | 4586 | 73 | 0 | 31.64135687 | -88.69573913 | 2022-01-07 04:22:09 | Wayne, Mississippi, US | |
4001782 | 4001782 | 2021-12-30 | US | Texas | Jasper | 48241 | 4586 | 165 | 0 | 30.74685667 | -94.02667579 | 2021-12-31 04:21:50 | Jasper, Texas, US | |
3831617 | 3831617 | 2021-12-21 | US | Texas | Kleberg | 48273 | 4586 | 133 | 0 | 27.42435506 | -97.69894948 | 2021-12-22 04:21:54 | Kleberg, Texas, US | |
2401061 | 2401061 | 2021-12-17 | US | New York | Lewis | 36049 | 4586 | 40 | 0 | 43.784415700000004 | -75.44903992 | 2021-12-18 02:22:20 | Lewis, New York, US | |
406160 | 406160 | 2021-12-07 | US | Mississippi | Yazoo | 28163 | 4586 | 92 | 0 | 32.77890365 | -90.39656148 | 2021-12-08 04:22:46 | Yazoo, Mississippi, US | |
1034056 | 1034056 | 2021-12-06 | United Kingdom | Guernsey | 4586 | 23 | 0 | 0 | 49.448196 | -2.58949 | 2021-12-07 04:22:34 | Guernsey, United Kingdom | ||
1033318 | 1033318 | 2021-12-06 | US | Tennessee | Grainger | 47057 | 4586 | 74 | 0 | 36.27469206 | -83.51254721 | 2021-12-07 04:22:34 | Grainger, Tennessee, US | |
1076 | 1076 | 2021-12-02 | US | Florida | Washington | 12133 | 4586 | 52 | 0 | 30.61359259 | -85.66002461 | 2021-12-03 04:23:05 | Washington, Florida, US | |
1145675 | 1145675 | 2021-12-01 | US | Florida | Washington | 12133 | 4586 | 52 | 0 | 30.61359259 | -85.66002461 | 2021-12-02 04:22:37 | Washington, Florida, US | |
3402187 | 3402187 | 2021-11-30 | US | Florida | Washington | 12133 | 4586 | 52 | 0 | 30.61359259 | -85.66002461 | 2021-12-01 04:22:29 | Washington, Florida, 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]);