johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
117 rows where confirmed = 5312 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308876 | 308876 | 2022-12-13 | US | Illinois | Ford | 17053 | 5312 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-14 04:21:04 | Ford, Illinois, US | |
308734 | 308734 | 2022-12-13 | US | Georgia | Meriwether | 13199 | 5312 | 156 | 0 | 33.04163534 | -84.68859732 | 2022-12-14 04:21:04 | Meriwether, Georgia, US | |
1149795 | 1149795 | 2022-12-12 | US | Georgia | Meriwether | 13199 | 5312 | 156 | 0 | 33.04163534 | -84.68859732 | 2022-12-13 04:21:01 | Meriwether, Georgia, US | |
869649 | 869649 | 2022-12-11 | US | Georgia | Meriwether | 13199 | 5312 | 156 | 0 | 33.04163534 | -84.68859732 | 2022-12-12 04:21:01 | Meriwether, Georgia, US | |
258179 | 258179 | 2022-12-10 | US | Georgia | Meriwether | 13199 | 5312 | 156 | 0 | 33.04163534 | -84.68859732 | 2022-12-11 04:20:50 | Meriwether, Georgia, US | |
3936893 | 3936893 | 2022-12-09 | US | Georgia | Meriwether | 13199 | 5312 | 156 | 0 | 33.04163534 | -84.68859732 | 2022-12-10 04:21:02 | Meriwether, Georgia, US | |
3378225 | 3378225 | 2022-12-08 | US | Georgia | Meriwether | 13199 | 5312 | 156 | 0 | 33.04163534 | -84.68859732 | 2022-12-09 04:21:05 | Meriwether, Georgia, US | |
321365 | 321365 | 2022-10-30 | US | Kentucky | Lawrence | 21127 | 5312 | 77 | 0 | 38.07136018 | -82.72882223 | 2022-10-31 04:21:36 | Lawrence, Kentucky, US | |
913641 | 913641 | 2022-10-29 | US | Kentucky | Lawrence | 21127 | 5312 | 77 | 0 | 38.07136018 | -82.72882223 | 2022-10-30 04:22:14 | Lawrence, Kentucky, US | |
1367910 | 1367910 | 2022-10-28 | US | Kentucky | Lawrence | 21127 | 5312 | 77 | 0 | 38.07136018 | -82.72882223 | 2022-10-29 04:21:13 | Lawrence, Kentucky, US | |
3039765 | 3039765 | 2022-10-27 | US | Kentucky | Lawrence | 21127 | 5312 | 77 | 0 | 38.07136018 | -82.72882223 | 2022-10-28 04:22:31 | Lawrence, Kentucky, US | |
540185 | 540185 | 2022-10-26 | US | Kentucky | Lawrence | 21127 | 5312 | 77 | 0 | 38.07136018 | -82.72882223 | 2022-10-27 04:22:01 | Lawrence, Kentucky, US | |
1831586 | 1831586 | 2022-10-25 | US | Kentucky | Lawrence | 21127 | 5312 | 77 | 0 | 38.07136018 | -82.72882223 | 2022-10-26 04:22:19 | Lawrence, Kentucky, US | |
795847 | 795847 | 2022-10-24 | US | Kentucky | Lawrence | 21127 | 5312 | 77 | 0 | 38.07136018 | -82.72882223 | 2022-10-25 04:21:53 | Lawrence, Kentucky, US | |
1563582 | 1563582 | 2022-09-28 | US | West Virginia | Hardy | 54031 | 5312 | 51 | 0 | 39.00683177 | -78.85855301 | 2022-09-29 04:22:34 | Hardy, West Virginia, US | |
2096630 | 2096630 | 2022-08-27 | US | Arkansas | Phillips | 5107 | 5312 | 101 | 0 | 34.43268455 | -90.84800154 | 2022-08-28 04:21:02 | Phillips, Arkansas, US | |
2326936 | 2326936 | 2022-08-24 | US | Wisconsin | Taylor | 55119 | 5312 | 73 | 0 | 45.21179252 | -90.5004405 | 2022-08-25 04:21:13 | Taylor, Wisconsin, US | |
2403386 | 2403386 | 2022-08-21 | US | California | Inyo | 6027 | 5312 | 59 | 0 | 36.51112084 | -117.4111978 | 2022-08-22 04:20:38 | Inyo, California, US | |
3798464 | 3798464 | 2022-08-20 | US | California | Inyo | 6027 | 5312 | 59 | 0 | 36.51112084 | -117.4111978 | 2022-08-21 04:20:44 | Inyo, California, US | |
1161776 | 1161776 | 2022-08-18 | US | Colorado | Chaffee | 8015 | 5312 | 52 | 0 | 38.74745778 | -106.1926573 | 2022-08-19 04:20:54 | Chaffee, Colorado, US | |
992130 | 992130 | 2022-08-16 | US | Indiana | Rush | 18139 | 5312 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-08-17 04:20:59 | Rush, Indiana, US | |
2495169 | 2495169 | 2022-08-15 | US | Indiana | Rush | 18139 | 5312 | 59 | 0 | 39.62002287 | -85.4655599 | 2022-08-16 04:20:58 | Rush, Indiana, US | |
3430003 | 3430003 | 2022-07-14 | US | Illinois | Pike | 17149 | 5312 | 68 | 0 | 39.62265059 | -90.8877017 | 2022-07-15 04:20:53 | Pike, Illinois, US | |
2490678 | 2490678 | 2022-06-29 | US | Colorado | Teller | 8119 | 5312 | 58 | 0 | 38.88133511 | -105.1614893 | 2022-06-30 04:21:01 | Teller, Colorado, US | |
941778 | 941778 | 2022-06-25 | US | Tennessee | Johnson | 47091 | 5312 | 95 | 0 | 36.4552395 | -81.84886538 | 2022-06-26 04:21:02 | Johnson, Tennessee, US | |
1765193 | 1765193 | 2022-06-20 | US | Mississippi | Winston | 28159 | 5312 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-06-21 04:20:56 | Winston, Mississippi, US | |
3271379 | 3271379 | 2022-06-19 | US | Mississippi | Winston | 28159 | 5312 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-06-20 04:21:01 | Winston, Mississippi, US | |
3399291 | 3399291 | 2022-06-18 | US | Mississippi | Winston | 28159 | 5312 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-06-19 04:20:51 | Winston, Mississippi, US | |
2313168 | 2313168 | 2022-06-17 | US | Mississippi | Winston | 28159 | 5312 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-06-18 04:21:10 | Winston, Mississippi, US | |
560672 | 560672 | 2022-06-16 | US | Mississippi | Winston | 28159 | 5312 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-06-17 04:20:56 | Winston, Mississippi, US | |
3984474 | 3984474 | 2022-06-15 | US | Mississippi | Winston | 28159 | 5312 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-06-16 04:20:55 | Winston, Mississippi, US | |
948715 | 948715 | 2022-06-14 | US | Mississippi | Winston | 28159 | 5312 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-06-15 04:20:54 | Winston, Mississippi, US | |
2981123 | 2981123 | 2022-06-13 | US | Mississippi | Winston | 28159 | 5312 | 104 | 0 | 33.08747908 | -89.03391385 | 2022-06-14 04:20:52 | Winston, Mississippi, US | |
3002700 | 3002700 | 2022-05-24 | US | Virginia | Powhatan | 51145 | 5312 | 59 | 0 | 37.55016038 | -77.91267882 | 2022-05-25 04:20:56 | Powhatan, Virginia, US | |
3000895 | 3000895 | 2022-05-24 | US | Maryland | Somerset | 24039 | 5312 | 74 | 0 | 38.1163542 | -75.75118623 | 2022-05-25 04:20:56 | Somerset, Maryland, US | |
223054 | 223054 | 2022-05-09 | US | Illinois | Wayne | 17191 | 5312 | 84 | 0 | 38.42955355 | -88.42586459 | 2022-05-10 04:20:50 | Wayne, Illinois, US | |
2803510 | 2803510 | 2022-04-06 | US | Puerto Rico | Cidra | 72041 | 5312 | 0 | 0 | 18.173559 | -66.161179 | 2022-04-07 04:20:53 | Cidra, Puerto Rico, US | |
3733724 | 3733724 | 2022-04-03 | US | West Virginia | Lewis | 54041 | 5312 | 87 | 0 | 38.9947249 | -80.49988181 | 2022-04-04 04:20:51 | Lewis, West Virginia, US | |
503159 | 503159 | 2022-04-02 | US | West Virginia | Lewis | 54041 | 5312 | 87 | 0 | 38.9947249 | -80.49988181 | 2022-04-03 04:20:48 | Lewis, West Virginia, US | |
3354144 | 3354144 | 2022-04-01 | US | West Virginia | Lewis | 54041 | 5312 | 87 | 0 | 38.9947249 | -80.49988181 | 2022-04-02 04:20:47 | Lewis, West Virginia, US | |
264629 | 264629 | 2022-03-15 | US | Texas | Gillespie | 48171 | 5312 | 106 | 0 | 30.31824095 | -98.94676915 | 2022-03-16 04:20:50 | Gillespie, Texas, US | |
1514751 | 1514751 | 2022-02-24 | US | Virginia | Fredericksburg | 51630 | 5312 | 34 | 0 | 38.2977863 | -77.4922454 | 2022-02-25 04:21:11 | Fredericksburg, Virginia, US | |
318152 | 318152 | 2022-02-12 | US | New York | Essex | 36031 | 5312 | 54 | 0 | 44.11630765 | -73.77297842 | 2022-02-13 04:21:00 | Essex, New York, US | |
460802 | 460802 | 2022-02-02 | US | Kentucky | Johnson | 21115 | 5312 | 86 | 0 | 37.85106355 | -82.8264322 | 2022-02-03 04:21:21 | Johnson, Kentucky, US | |
460753 | 460753 | 2022-02-02 | US | Kentucky | Bourbon | 21017 | 5312 | 46 | 0 | 38.2054607 | -84.21827874 | 2022-02-03 04:21:21 | Bourbon, Kentucky, US | |
3615539 | 3615539 | 2022-01-12 | US | Ohio | Henry | 39069 | 5312 | 98 | 0 | 41.333964200000004 | -84.06830637 | 2022-01-13 08:00:09 | Henry, Ohio, US | |
733652 | 733652 | 2021-12-27 | US | Texas | Howard | 48227 | 5312 | 151 | 0 | 32.30621324 | -101.4356444 | 2021-12-28 04:21:47 | Howard, Texas, US | |
2113406 | 2113406 | 2021-12-26 | US | Minnesota | Cass | 27021 | 5312 | 61 | 0 | 46.95043611 | -94.32603968 | 2021-12-27 04:21:58 | Cass, Minnesota, US | |
2113090 | 2113090 | 2021-12-26 | US | Kentucky | Clay | 21051 | 5312 | 66 | 0 | 37.16451126 | -83.712575 | 2021-12-27 04:21:58 | Clay, Kentucky, US | |
3606778 | 3606778 | 2021-12-25 | US | Minnesota | Cass | 27021 | 5312 | 61 | 0 | 46.95043611 | -94.32603968 | 2021-12-26 04:21:50 | Cass, Minnesota, US | |
3606462 | 3606462 | 2021-12-25 | US | Kentucky | Clay | 21051 | 5312 | 66 | 0 | 37.16451126 | -83.712575 | 2021-12-26 04:21:50 | Clay, Kentucky, US | |
2965096 | 2965096 | 2021-12-24 | US | Minnesota | Cass | 27021 | 5312 | 61 | 0 | 46.95043611 | -94.32603968 | 2021-12-25 04:21:37 | Cass, Minnesota, US | |
2964780 | 2964780 | 2021-12-24 | US | Kentucky | Clay | 21051 | 5312 | 66 | 0 | 37.16451126 | -83.712575 | 2021-12-25 04:21:37 | Clay, Kentucky, US | |
3818128 | 3818128 | 2021-12-23 | US | Minnesota | Cass | 27021 | 5312 | 61 | 0 | 46.95043611 | -94.32603968 | 2021-12-24 04:21:34 | Cass, Minnesota, US | |
3817812 | 3817812 | 2021-12-23 | US | Kentucky | Clay | 21051 | 5312 | 66 | 0 | 37.16451126 | -83.712575 | 2021-12-24 04:21:34 | Clay, Kentucky, US | |
799820 | 799820 | 2021-12-22 | US | Kentucky | Clay | 21051 | 5312 | 66 | 0 | 37.16451126 | -83.712575 | 2021-12-23 04:21:21 | Clay, Kentucky, US | |
3073491 | 3073491 | 2021-11-23 | US | Washington | Stevens | 53065 | 5312 | 101 | 0 | 48.40035475 | -117.8542701 | 2021-11-24 04:22:14 | Stevens, Washington, US | |
3343918 | 3343918 | 2021-11-16 | US | Kansas | Harvey | 20079 | 5312 | 92 | 0 | 38.04293782 | -97.42747573 | 2021-11-17 04:21:48 | Harvey, Kansas, US | |
2288754 | 2288754 | 2021-11-15 | US | Kansas | Harvey | 20079 | 5312 | 92 | 0 | 38.04293782 | -97.42747573 | 2021-11-16 04:21:10 | Harvey, Kansas, US | |
717586 | 717586 | 2021-11-12 | US | Texas | Hockley | 48219 | 5312 | 133 | 0 | 33.60771256 | -102.3431676 | 2021-11-13 04:21:38 | Hockley, Texas, US | |
31536 | 31536 | 2021-11-11 | US | Texas | Hockley | 48219 | 5312 | 133 | 0 | 33.60771256 | -102.3431676 | 2021-11-12 04:22:01 | Hockley, Texas, US | |
1909200 | 1909200 | 2021-10-17 | Japan | Ehime | 5312 | 82 | 0 | 33.624835 | 132.856842 | 2021-10-18 04:21:10 | Ehime, Japan | |||
2461931 | 2461931 | 2021-10-06 | US | Texas | Kendall | 48259 | 5312 | 91 | 0 | 29.94414155 | -98.7113588 | 2021-10-07 04:21:36 | Kendall, Texas, US | |
3835316 | 3835316 | 2021-10-05 | US | South Carolina | Marion | 45067 | 5312 | 133 | 0 | 34.07859748 | -79.36400756 | 2021-10-06 04:21:33 | Marion, South Carolina, US | |
3760392 | 3760392 | 2021-09-21 | US | Tennessee | Carroll | 47017 | 5312 | 91 | 0 | 35.97366108 | -88.45189331 | 2021-09-22 04:21:45 | Carroll, Tennessee, US | |
3759675 | 3759675 | 2021-09-21 | US | New Mexico | Otero | 35035 | 5312 | 92 | 0 | 32.61348406 | -105.7417604 | 2021-09-22 04:21:45 | Otero, New Mexico, US | |
1387995 | 1387995 | 2021-09-13 | US | North Carolina | Stokes | 37169 | 5312 | 86 | 0 | 36.4017975 | -80.23893369 | 2021-09-14 04:21:41 | Stokes, North Carolina, US | |
2282390 | 2282390 | 2021-09-08 | US | Texas | Titus | 48449 | 5312 | 89 | 0 | 33.21339719 | -94.96797273 | 2021-09-09 04:21:27 | Titus, Texas, US | |
2178174 | 2178174 | 2021-08-22 | US | Oregon | Klamath | 41035 | 5312 | 81 | 0 | 42.68762984 | -121.64964609999998 | 2021-08-23 04:21:27 | Klamath, Oregon, US | |
3558270 | 3558270 | 2021-08-21 | US | Oregon | Klamath | 41035 | 5312 | 81 | 0 | 42.68762984 | -121.64964609999998 | 2021-08-22 04:21:29 | Klamath, Oregon, US | |
1856612 | 1856612 | 2021-08-20 | US | Oregon | Klamath | 41035 | 5312 | 81 | 0 | 42.68762984 | -121.64964609999998 | 2021-08-21 04:21:38 | Klamath, Oregon, US | |
651492 | 651492 | 2021-08-09 | US | Louisiana | St. Bernard | 22087 | 5312 | 62 | 0 | 29.87761636 | -89.51887093 | 2021-08-10 04:21:27 | St. Bernard, Louisiana, US | |
3018021 | 3018021 | 2021-08-01 | US | Pennsylvania | Huntingdon | 42061 | 5312 | 136 | 0 | 40.42162652 | -77.97673273 | 2021-08-02 04:21:36 | Huntingdon, Pennsylvania, US | |
2318332 | 2318332 | 2021-06-04 | US | Texas | Burnet | 48053 | 5312 | 66 | 0 | 30.78801353 | -98.181887 | 2021-06-05 04:23:03 | Burnet, Texas, US | |
1809775 | 1809775 | 2021-05-27 | US | Texas | Burnet | 48053 | 5312 | 65 | 0 | 30.78801353 | -98.181887 | 2021-05-28 04:20:36 | Burnet, Texas, US | |
1416632 | 1416632 | 2021-05-24 | US | Wisconsin | Shawano | 55115 | 5312 | 84 | 0 | 44.78902246 | -88.76443896 | 2021-05-25 04:21:08 | Shawano, Wisconsin, US | |
1774918 | 1774918 | 2021-05-23 | US | Wisconsin | Shawano | 55115 | 5312 | 84 | 0 | 44.78902246 | -88.76443896 | 2021-05-24 04:20:53 | Shawano, Wisconsin, US | |
730073 | 730073 | 2021-05-22 | US | Wisconsin | Shawano | 55115 | 5312 | 84 | 0 | 44.78902246 | -88.76443896 | 2021-05-23 04:20:51 | Shawano, Wisconsin, US | |
1953061 | 1953061 | 2021-05-21 | US | California | Lassen | 6035 | 5312 | 18 | 0 | 40.67311306 | -120.59350990000002 | 2021-05-22 04:20:45 | Lassen, California, US | |
3956106 | 3956106 | 2021-05-11 | US | Michigan | Cass | 26027 | 5312 | 75 | 0 | 41.91522292 | -85.99405727 | 2021-05-12 04:21:29 | Cass, Michigan, US | |
2824927 | 2824927 | 2021-05-01 | Pakistan | Gilgit-Baltistan | 5312 | 107 | 5087 | 118 | 35.792146 | 74.982138 | 2021-05-02 04:20:48 | Gilgit-Baltistan, Pakistan | ||
3705215 | 3705215 | 2021-04-27 | US | Texas | Harrison | 48203 | 5312 | 106 | 0 | 32.54935988 | -94.36934071 | 2021-04-28 04:20:32 | Harrison, Texas, US | |
888851 | 888851 | 2021-04-26 | US | Florida | Suwannee | 12121 | 5312 | 137 | 0 | 30.19746066 | -82.99099670000003 | 2021-04-27 04:20:52 | Suwannee, Florida, US | |
3885906 | 3885906 | 2021-04-11 | US | North Carolina | Halifax | 37083 | 5312 | 106 | 0 | 36.25669272 | -77.6556109 | 2021-04-12 04:21:00 | Halifax, North Carolina, US | |
2985574 | 2985574 | 2021-04-10 | US | North Carolina | Halifax | 37083 | 5312 | 106 | 0 | 36.25669272 | -77.6556109 | 2021-04-11 04:20:56 | Halifax, North Carolina, US | |
608006 | 608006 | 2021-04-09 | US | North Carolina | Halifax | 37083 | 5312 | 106 | 0 | 36.25669272 | -77.6556109 | 2021-04-10 04:20:59 | Halifax, North Carolina, US | |
3712181 | 3712181 | 2021-04-03 | US | Nebraska | Buffalo | 31019 | 5312 | 57 | 0 | 40.85486962 | -99.07500296 | 2021-04-04 04:20:49 | Buffalo, Nebraska, US | |
1303594 | 1303594 | 2021-04-01 | US | Maine | Androscoggin | 23001 | 5312 | 59 | 0 | 44.1664747 | -70.20380627 | 2021-04-02 04:20:36 | Androscoggin, Maine, US | |
282398 | 282398 | 2021-02-24 | US | New York | Cayuga | 36011 | 5312 | 87 | 0 | 5225 | 42.91261714 | -76.55731592 | 2021-02-25 05:24:57 | Cayuga, New York, US |
3051246 | 3051246 | 2021-02-16 | US | Indiana | Dearborn | 18029 | 5312 | 62 | 0 | 5250 | 39.14647946 | -84.97333539 | 2021-02-17 05:23:10 | Dearborn, Indiana, US |
1677156 | 1677156 | 2021-02-01 | US | Florida | Flagler | 12035 | 5312 | 70 | 0 | 5242 | 29.45933576 | -81.31508595 | 2021-02-02 05:22:49 | Flagler, Florida, US |
2428495 | 2428495 | 2021-01-23 | US | Massachusetts | Hampshire | 25015 | 5312 | 183 | 0 | 5086 | 42.33997957 | -72.65898478 | 2021-01-24 05:22:35 | Hampshire, Massachusetts, US |
204005 | 204005 | 2020-12-25 | US | Minnesota | Rice | 27131 | 5312 | 48 | 0 | 5264 | 44.3543376 | -93.29658715 | 2020-12-26 05:22:28 | Rice, Minnesota, US |
3693228 | 3693228 | 2020-12-24 | US | Minnesota | Rice | 27131 | 5312 | 48 | 0 | 5264 | 44.3543376 | -93.29658715 | 2020-12-25 05:22:48 | Rice, Minnesota, US |
2120988 | 2120988 | 2020-12-20 | US | Kansas | Finney | 20055 | 5312 | 34 | 0 | 5278 | 38.04340344 | -100.7381938 | 2020-12-21 05:27:58 | Finney, Kansas, US |
2932495 | 2932495 | 2020-12-19 | US | Kansas | Finney | 20055 | 5312 | 34 | 0 | 5278 | 38.04340344 | -100.7381938 | 2020-12-20 05:27:32 | Finney, Kansas, US |
1902441 | 1902441 | 2020-12-18 | US | Kansas | Finney | 20055 | 5312 | 34 | 0 | 5278 | 38.04340344 | -100.7381938 | 2020-12-19 05:27:52 | Finney, Kansas, US |
2977093 | 2977093 | 2020-12-09 | US | Missouri | Buchanan | 29021 | 5312 | 68 | 0 | 5244 | 39.65816401 | -94.80138942 | 2020-12-10 05:26:19 | Buchanan, Missouri, US |
1584468 | 1584468 | 2020-11-30 | Suriname | 5312 | 117 | 5194 | 1 | 3.9193 | -56.0278 | 2020-12-01 05:26:18 | Suriname | |||
3566871 | 3566871 | 2020-11-29 | Suriname | 5312 | 117 | 5192 | 3 | 3.9193 | -56.0278 | 2020-11-30 05:26:13 | Suriname |
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]);