johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
193 rows where confirmed = 4762 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753600 | 2753600 | 2022-12-29 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-30 04:21:04 | Dixie, Florida, US | |
1074606 | 1074606 | 2022-12-28 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-29 04:21:01 | Dixie, Florida, US | |
328603 | 328603 | 2022-12-27 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-28 04:21:04 | Dixie, Florida, US | |
218676 | 218676 | 2022-12-26 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-27 04:21:07 | Dixie, Florida, US | |
3223133 | 3223133 | 2022-12-25 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-26 04:21:06 | Dixie, Florida, US | |
1019047 | 1019047 | 2022-12-24 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-25 04:21:04 | Dixie, Florida, US | |
691070 | 691070 | 2022-12-23 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-24 04:21:02 | Dixie, Florida, US | |
2180280 | 2180280 | 2022-12-22 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-23 04:21:04 | Dixie, Florida, US | |
452084 | 452084 | 2022-12-21 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-22 04:20:56 | Dixie, Florida, US | |
2952083 | 2952083 | 2022-12-20 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-21 04:21:03 | Dixie, Florida, US | |
3174485 | 3174485 | 2022-12-19 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-20 04:21:04 | Dixie, Florida, US | |
1629002 | 1629002 | 2022-12-18 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-19 04:21:03 | Dixie, Florida, US | |
504381 | 504381 | 2022-12-17 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-18 04:21:03 | Dixie, Florida, US | |
3324953 | 3324953 | 2022-12-16 | US | Florida | Dixie | 12029 | 4762 | 82 | 0 | 29.60631086 | -83.15724673 | 2022-12-17 04:21:04 | Dixie, Florida, US | |
294775 | 294775 | 2022-11-15 | US | Puerto Rico | Luquillo | 72089 | 4762 | 0 | 0 | 18.342114 | -65.725097 | 2022-11-16 04:21:09 | Luquillo, Puerto Rico, US | |
3599805 | 3599805 | 2022-11-14 | US | Puerto Rico | Luquillo | 72089 | 4762 | 0 | 0 | 18.342114 | -65.725097 | 2022-11-15 04:21:16 | Luquillo, Puerto Rico, US | |
2432787 | 2432787 | 2022-11-09 | US | Mississippi | Smith | 28129 | 4762 | 71 | 0 | 32.01744532 | -89.50644846 | 2022-11-10 04:21:16 | Smith, Mississippi, US | |
481443 | 481443 | 2022-11-08 | US | Mississippi | Smith | 28129 | 4762 | 71 | 0 | 32.01744532 | -89.50644846 | 2022-11-09 04:21:22 | Smith, Mississippi, US | |
2440593 | 2440593 | 2022-11-07 | US | Mississippi | Smith | 28129 | 4762 | 71 | 0 | 32.01744532 | -89.50644846 | 2022-11-08 04:21:21 | Smith, Mississippi, US | |
1051691 | 1051691 | 2022-11-06 | US | Mississippi | Smith | 28129 | 4762 | 71 | 0 | 32.01744532 | -89.50644846 | 2022-11-07 04:21:26 | Smith, Mississippi, US | |
619715 | 619715 | 2022-11-05 | US | Mississippi | Smith | 28129 | 4762 | 71 | 0 | 32.01744532 | -89.50644846 | 2022-11-06 04:21:24 | Smith, Mississippi, US | |
1024219 | 1024219 | 2022-11-04 | US | Mississippi | Smith | 28129 | 4762 | 71 | 0 | 32.01744532 | -89.50644846 | 2022-11-05 04:21:52 | Smith, Mississippi, US | |
433210 | 433210 | 2022-11-03 | US | Mississippi | Smith | 28129 | 4762 | 71 | 0 | 32.01744532 | -89.50644846 | 2022-11-04 04:22:11 | Smith, Mississippi, US | |
851452 | 851452 | 2022-11-02 | US | Mississippi | Smith | 28129 | 4762 | 71 | 0 | 32.01744532 | -89.50644846 | 2022-11-03 04:22:05 | Smith, Mississippi, US | |
3041460 | 3041460 | 2022-10-27 | US | Texas | Houston | 48225 | 4762 | 114 | 0 | 31.31925973 | -95.42226208 | 2022-10-28 04:22:31 | Houston, Texas, US | |
541880 | 541880 | 2022-10-26 | US | Texas | Houston | 48225 | 4762 | 114 | 0 | 31.31925973 | -95.42226208 | 2022-10-27 04:22:01 | Houston, Texas, US | |
2028290 | 2028290 | 2022-10-17 | US | Wisconsin | Burnett | 55013 | 4762 | 45 | 0 | 45.86303537 | -92.36711412 | 2022-10-18 04:22:42 | Burnett, Wisconsin, US | |
2635112 | 2635112 | 2022-09-05 | US | Kentucky | Casey | 21045 | 4762 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-09-06 04:21:02 | Casey, Kentucky, US | |
2988676 | 2988676 | 2022-09-04 | US | Kentucky | Casey | 21045 | 4762 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-09-05 04:21:01 | Casey, Kentucky, US | |
2714361 | 2714361 | 2022-09-03 | US | Kentucky | Casey | 21045 | 4762 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-09-04 04:21:22 | Casey, Kentucky, US | |
1395066 | 1395066 | 2022-09-02 | US | Kentucky | Casey | 21045 | 4762 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-09-03 04:21:04 | Casey, Kentucky, US | |
3548895 | 3548895 | 2022-09-01 | US | Kentucky | Casey | 21045 | 4762 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-09-02 04:21:07 | Casey, Kentucky, US | |
2344815 | 2344815 | 2022-08-31 | US | Kentucky | Casey | 21045 | 4762 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-09-01 04:21:03 | Casey, Kentucky, US | |
3775295 | 3775295 | 2022-08-30 | US | Kentucky | Casey | 21045 | 4762 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-08-31 04:20:57 | Casey, Kentucky, US | |
1681891 | 1681891 | 2022-08-29 | US | Kentucky | Casey | 21045 | 4762 | 78 | 0 | 37.32533118 | -84.92726209 | 2022-08-30 04:21:03 | Casey, Kentucky, US | |
3543980 | 3543980 | 2022-08-08 | US | Arkansas | Grant | 5053 | 4762 | 62 | 0 | 34.29017991 | -92.42320562 | 2022-08-09 04:20:34 | Grant, Arkansas, US | |
1784159 | 1784159 | 2022-07-29 | US | Colorado | Otero | 8089 | 4762 | 132 | 0 | 37.9014485 | -103.7173385 | 2022-07-30 04:20:42 | Otero, Colorado, US | |
1488452 | 1488452 | 2022-07-26 | US | Georgia | Putnam | 13237 | 4762 | 107 | 0 | 33.32056115 | -83.37552891 | 2022-07-27 04:21:04 | Putnam, Georgia, US | |
2594898 | 2594898 | 2022-07-25 | US | Georgia | Putnam | 13237 | 4762 | 107 | 0 | 33.32056115 | -83.37552891 | 2022-07-26 04:20:58 | Putnam, Georgia, US | |
897013 | 897013 | 2022-07-24 | US | Georgia | Putnam | 13237 | 4762 | 107 | 0 | 33.32056115 | -83.37552891 | 2022-07-25 04:20:51 | Putnam, Georgia, US | |
92007 | 92007 | 2022-07-23 | US | Georgia | Putnam | 13237 | 4762 | 107 | 0 | 33.32056115 | -83.37552891 | 2022-07-24 04:20:47 | Putnam, Georgia, US | |
901029 | 901029 | 2022-07-22 | US | Georgia | Putnam | 13237 | 4762 | 107 | 0 | 33.32056115 | -83.37552891 | 2022-07-23 04:20:53 | Putnam, Georgia, US | |
671165 | 671165 | 2022-07-21 | US | Georgia | Putnam | 13237 | 4762 | 107 | 0 | 33.32056115 | -83.37552891 | 2022-07-22 04:21:15 | Putnam, Georgia, US | |
1609128 | 1609128 | 2022-07-20 | US | Georgia | Putnam | 13237 | 4762 | 107 | 0 | 33.32056115 | -83.37552891 | 2022-07-21 04:21:10 | Putnam, Georgia, US | |
3429954 | 3429954 | 2022-07-14 | US | Illinois | Ford | 17053 | 4762 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-07-15 04:20:53 | Ford, Illinois, US | |
2242606 | 2242606 | 2022-06-28 | US | Texas | Reeves | 48389 | 4762 | 74 | 0 | 31.32323325 | -103.6903896 | 2022-06-29 04:20:59 | Reeves, Texas, US | |
3510489 | 3510489 | 2022-06-05 | US | Texas | Gonzales | 48177 | 4762 | 99 | 0 | 29.45634206 | -97.49424032 | 2022-06-06 04:20:57 | Gonzales, Texas, US | |
3582210 | 3582210 | 2022-06-02 | US | Wisconsin | Sawyer | 55113 | 4762 | 62 | 0 | 45.87931905 | -91.14504927 | 2022-06-03 04:20:58 | Sawyer, Wisconsin, US | |
3596012 | 3596012 | 2022-05-23 | US | Tennessee | Polk | 47139 | 4762 | 76 | 0 | 35.12245443 | -84.52075859 | 2022-05-24 04:20:57 | Polk, Tennessee, US | |
1573276 | 1573276 | 2022-05-03 | US | Indiana | Starke | 18149 | 4762 | 99 | 0 | 41.27890281 | -86.64686895 | 2022-05-04 04:20:59 | Starke, Indiana, US | |
466119 | 466119 | 2022-05-02 | US | Puerto Rico | Barranquitas | 72019 | 4762 | 0 | 0 | 18.201592 | -66.30963 | 2022-05-03 04:21:00 | Barranquitas, Puerto Rico, US | |
464536 | 464536 | 2022-05-02 | US | Indiana | Starke | 18149 | 4762 | 99 | 0 | 41.27890281 | -86.64686895 | 2022-05-03 04:21:00 | Starke, Indiana, US | |
3918046 | 3918046 | 2022-05-01 | US | Montana | Lincoln | 30053 | 4762 | 89 | 0 | 48.54265777 | -115.4046155 | 2022-05-02 04:21:10 | Lincoln, Montana, US | |
3917175 | 3917175 | 2022-05-01 | US | Indiana | Starke | 18149 | 4762 | 99 | 0 | 41.27890281 | -86.64686895 | 2022-05-02 04:21:10 | Starke, Indiana, US | |
2842850 | 2842850 | 2022-04-30 | US | Montana | Lincoln | 30053 | 4762 | 89 | 0 | 48.54265777 | -115.4046155 | 2022-05-01 04:20:57 | Lincoln, Montana, US | |
2841979 | 2841979 | 2022-04-30 | US | Indiana | Starke | 18149 | 4762 | 99 | 0 | 41.27890281 | -86.64686895 | 2022-05-01 04:20:57 | Starke, Indiana, US | |
1159163 | 1159163 | 2022-04-29 | US | Montana | Lincoln | 30053 | 4762 | 89 | 0 | 48.54265777 | -115.4046155 | 2022-04-30 04:21:05 | Lincoln, Montana, US | |
1158292 | 1158292 | 2022-04-29 | US | Indiana | Starke | 18149 | 4762 | 99 | 0 | 41.27890281 | -86.64686895 | 2022-04-30 04:21:05 | Starke, Indiana, US | |
3731650 | 3731650 | 2022-04-03 | US | Kentucky | Henry | 21103 | 4762 | 47 | 0 | 38.44942688 | -85.11587507 | 2022-04-04 04:20:51 | Henry, Kentucky, US | |
501085 | 501085 | 2022-04-02 | US | Kentucky | Henry | 21103 | 4762 | 47 | 0 | 38.44942688 | -85.11587507 | 2022-04-03 04:20:48 | Henry, Kentucky, US | |
3352070 | 3352070 | 2022-04-01 | US | Kentucky | Henry | 21103 | 4762 | 47 | 0 | 38.44942688 | -85.11587507 | 2022-04-02 04:20:47 | Henry, Kentucky, US | |
1541375 | 1541375 | 2022-03-31 | US | Kentucky | Henry | 21103 | 4762 | 47 | 0 | 38.44942688 | -85.11587507 | 2022-04-01 04:20:28 | Henry, Kentucky, US | |
2479388 | 2479388 | 2022-03-30 | US | Kentucky | Henry | 21103 | 4762 | 47 | 0 | 38.44942688 | -85.11587507 | 2022-03-31 04:20:56 | Henry, Kentucky, US | |
159429 | 159429 | 2022-03-29 | US | Kentucky | Henry | 21103 | 4762 | 47 | 0 | 38.44942688 | -85.11587507 | 2022-03-30 04:20:45 | Henry, Kentucky, US | |
1438000 | 1438000 | 2022-03-28 | US | Kentucky | Henry | 21103 | 4762 | 47 | 0 | 38.44942688 | -85.11587507 | 2022-03-29 04:20:46 | Henry, Kentucky, US | |
3024953 | 3024953 | 2022-03-23 | US | Pennsylvania | Juniata | 42067 | 4762 | 175 | 0 | 40.53358749 | -77.39975129999998 | 2022-03-24 04:20:43 | Juniata, Pennsylvania, US | |
1905803 | 1905803 | 2022-03-22 | US | Colorado | Chaffee | 8015 | 4762 | 47 | 0 | 38.74745778 | -106.19265729999998 | 2022-03-23 04:20:48 | Chaffee, Colorado, US | |
3238934 | 3238934 | 2022-03-21 | US | Colorado | Chaffee | 8015 | 4762 | 47 | 0 | 38.74745778 | -106.19265729999998 | 2022-03-22 04:20:54 | Chaffee, Colorado, US | |
25007 | 25007 | 2022-03-20 | US | Colorado | Chaffee | 8015 | 4762 | 47 | 0 | 38.74745778 | -106.19265729999998 | 2022-03-21 04:20:50 | Chaffee, Colorado, US | |
3631428 | 3631428 | 2022-03-13 | US | West Virginia | Barbour | 54001 | 4762 | 74 | 0 | 39.1307219 | -80.00350858 | 2022-03-14 04:20:46 | Barbour, West Virginia, US | |
954336 | 954336 | 2022-03-12 | US | West Virginia | Barbour | 54001 | 4762 | 74 | 0 | 39.1307219 | -80.00350858 | 2022-03-13 04:20:49 | Barbour, West Virginia, US | |
359797 | 359797 | 2022-03-11 | US | West Virginia | Barbour | 54001 | 4762 | 74 | 0 | 39.1307219 | -80.00350858 | 2022-03-12 04:20:50 | Barbour, West Virginia, US | |
1647651 | 1647651 | 2022-03-03 | US | Vermont | Orange | 50017 | 4762 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-03-04 04:21:09 | Orange, Vermont, US | |
1513527 | 1513527 | 2022-02-24 | US | Nebraska | Saunders | 31155 | 4762 | 16 | 0 | 41.227810299999994 | -96.63773905 | 2022-02-25 04:21:11 | Saunders, Nebraska, US | |
1058742 | 1058742 | 2022-02-23 | US | Georgia | Union | 13291 | 4762 | 144 | 0 | 34.82995757 | -83.98967069 | 2022-02-24 04:21:14 | Union, Georgia, US | |
2448587 | 2448587 | 2022-02-22 | US | Mississippi | Jasper | 28061 | 4762 | 70 | 0 | 32.01922104 | -89.11786866 | 2022-02-23 04:21:09 | Jasper, Mississippi, US | |
187173 | 187173 | 2022-02-13 | US | Indiana | Jay | 18075 | 4762 | 69 | 0 | 40.43781032 | -85.00576229 | 2022-02-14 04:20:51 | Jay, Indiana, US | |
317019 | 317019 | 2022-02-12 | US | Indiana | Jay | 18075 | 4762 | 69 | 0 | 40.43781032 | -85.00576229 | 2022-02-13 04:21:00 | Jay, Indiana, US | |
234345 | 234345 | 2022-02-11 | US | Indiana | Jay | 18075 | 4762 | 69 | 0 | 40.43781032 | -85.00576229 | 2022-02-12 04:21:06 | Jay, Indiana, US | |
2015348 | 2015348 | 2022-02-06 | US | Oregon | Wasco | 41065 | 4762 | 53 | 0 | 45.16292781 | -121.16709540000001 | 2022-02-07 04:21:05 | Wasco, Oregon, US | |
1296677 | 1296677 | 2022-02-05 | US | Oregon | Wasco | 41065 | 4762 | 53 | 0 | 45.16292781 | -121.16709540000001 | 2022-02-06 04:21:00 | Wasco, Oregon, US | |
2330005 | 2330005 | 2022-02-04 | US | Oregon | Wasco | 41065 | 4762 | 53 | 0 | 45.16292781 | -121.16709540000001 | 2022-02-05 04:21:05 | Wasco, Oregon, US | |
979448 | 979448 | 2022-02-01 | US | Arkansas | Lawrence | 5075 | 4762 | 65 | 0 | 36.04188196 | -91.10867198 | 2022-02-02 04:21:09 | Lawrence, Arkansas, US | |
2661080 | 2661080 | 2022-01-31 | US | Vermont | Orleans | 50019 | 4762 | 31 | 0 | 44.82964024 | -72.24562697 | 2022-02-01 04:21:11 | Orleans, Vermont, US | |
2659205 | 2659205 | 2022-01-31 | US | Kentucky | Hart | 21099 | 4762 | 88 | 0 | 37.29943898 | -85.88461055 | 2022-02-01 04:21:11 | Hart, Kentucky, US | |
3303497 | 3303497 | 2022-01-30 | US | Vermont | Orleans | 50019 | 4762 | 31 | 0 | 44.82964024 | -72.24562697 | 2022-01-31 04:21:09 | Orleans, Vermont, US | |
3301244 | 3301244 | 2022-01-30 | US | Illinois | Pike | 17149 | 4762 | 63 | 0 | 39.62265059 | -90.8877017 | 2022-01-31 04:21:09 | Pike, Illinois, US | |
3063035 | 3063035 | 2022-01-29 | US | Illinois | Pike | 17149 | 4762 | 63 | 0 | 39.62265059 | -90.8877017 | 2022-01-30 04:21:26 | Pike, Illinois, US | |
3813151 | 3813151 | 2022-01-28 | US | Texas | Scurry | 48415 | 4762 | 95 | 0 | 32.74613808 | -100.91626640000001 | 2022-01-29 04:21:10 | Scurry, Texas, US | |
3810969 | 3810969 | 2022-01-28 | US | Illinois | Pike | 17149 | 4762 | 63 | 0 | 39.62265059 | -90.8877017 | 2022-01-29 04:21:10 | Pike, Illinois, US | |
1231204 | 1231204 | 2022-01-24 | US | Wisconsin | Vilas | 55125 | 4762 | 83 | 0 | 46.05467334 | -89.51719204 | 2022-01-25 04:21:05 | Vilas, Wisconsin, US | |
3467183 | 3467183 | 2022-01-18 | US | Tennessee | Wayne | 47181 | 4762 | 50 | 0 | 35.23868267 | -87.78644456 | 2022-01-19 04:21:23 | Wayne, Tennessee, US | |
556926 | 556926 | 2022-01-16 | US | Nevada | Churchill | 32001 | 4762 | 92 | 0 | 39.58105744 | -118.3394607 | 2022-01-17 04:21:08 | Churchill, Nevada, US | |
3842647 | 3842647 | 2022-01-15 | US | Nevada | Churchill | 32001 | 4762 | 92 | 0 | 39.58105744 | -118.3394607 | 2022-01-16 04:21:12 | Churchill, Nevada, US | |
102821 | 102821 | 2022-01-14 | US | West Virginia | Mason | 54053 | 4762 | 74 | 0 | 38.77071799 | -82.02524219 | 2022-01-15 04:21:07 | Mason, West Virginia, US | |
101462 | 101462 | 2022-01-14 | US | Nevada | Churchill | 32001 | 4762 | 92 | 0 | 39.58105744 | -118.3394607 | 2022-01-15 04:21:07 | Churchill, Nevada, US | |
3613538 | 3613538 | 2022-01-12 | US | Arkansas | Cleburne | 5023 | 4762 | 104 | 0 | 35.53864922 | -92.02640019 | 2022-01-13 08:00:09 | Cleburne, Arkansas, US | |
1287439 | 1287439 | 2022-01-04 | US | Kentucky | Lincoln | 21137 | 4762 | 108 | 0 | 37.45475628 | -84.6565327 | 2022-01-05 04:21:59 | Lincoln, Kentucky, US | |
2400788 | 2400788 | 2021-12-17 | US | Missouri | Stoddard | 29207 | 4762 | 108 | 0 | 36.85571651 | -89.9444155 | 2021-12-18 02:22:20 | Stoddard, Missouri, US | |
138584 | 138584 | 2021-12-04 | US | Colorado | Delta | 8029 | 4762 | 119 | 0 | 38.86246243 | -107.86313419999999 | 2021-12-05 04:22:25 | Delta, Colorado, 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]);