johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
171 rows where confirmed = 4452 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
506429 | 506429 | 2022-12-17 | US | Puerto Rico | Florida | 72054 | 4452 | 0 | 0 | 18.373715 | -66.560488 | 2022-12-18 04:21:03 | Florida, Puerto Rico, US | |
1831213 | 1831213 | 2022-10-25 | US | Illinois | Wabash | 17185 | 4452 | 30 | 0 | 38.44272901 | -87.84922065 | 2022-10-26 04:22:19 | Wabash, Illinois, US | |
3997010 | 3997010 | 2022-09-27 | US | North Carolina | Swain | 37173 | 4452 | 52 | 0 | 35.48665845 | -83.48748932 | 2022-09-28 04:23:01 | Swain, North Carolina, US | |
2771338 | 2771338 | 2022-09-26 | US | North Carolina | Swain | 37173 | 4452 | 52 | 0 | 35.48665845 | -83.48748932 | 2022-09-27 04:23:01 | Swain, North Carolina, US | |
1978991 | 1978991 | 2022-09-25 | US | North Carolina | Swain | 37173 | 4452 | 52 | 0 | 35.48665845 | -83.48748932 | 2022-09-26 04:20:52 | Swain, North Carolina, US | |
2652158 | 2652158 | 2022-09-24 | US | North Carolina | Swain | 37173 | 4452 | 52 | 0 | 35.48665845 | -83.48748932 | 2022-09-25 04:23:31 | Swain, North Carolina, US | |
386598 | 386598 | 2022-09-23 | US | North Carolina | Swain | 37173 | 4452 | 52 | 0 | 35.48665845 | -83.48748932 | 2022-09-24 04:21:40 | Swain, North Carolina, US | |
1626664 | 1626664 | 2022-09-22 | US | North Carolina | Swain | 37173 | 4452 | 52 | 0 | 35.48665845 | -83.48748932 | 2022-09-23 04:23:13 | Swain, North Carolina, US | |
1372868 | 1372868 | 2022-09-21 | US | North Carolina | Swain | 37173 | 4452 | 52 | 0 | 35.48665845 | -83.48748932 | 2022-09-22 04:22:56 | Swain, North Carolina, US | |
115271 | 115271 | 2022-09-06 | US | Arkansas | Polk | 5113 | 4452 | 152 | 0 | 34.48254879 | -94.22728802 | 2022-09-07 04:20:59 | Polk, Arkansas, US | |
993995 | 993995 | 2022-08-16 | US | Tennessee | Trousdale | 47169 | 4452 | 47 | 0 | 36.39026213 | -86.16087954 | 2022-08-17 04:20:59 | Trousdale, Tennessee, US | |
1346709 | 1346709 | 2022-08-10 | US | Alabama | Macon | 1087 | 4452 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-11 04:20:49 | Macon, Alabama, US | |
1086464 | 1086464 | 2022-08-09 | US | Alabama | Macon | 1087 | 4452 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-10 04:20:57 | Macon, Alabama, US | |
3544518 | 3544518 | 2022-08-08 | US | Illinois | Mercer | 17131 | 4452 | 51 | 0 | 41.20596782 | -90.74290052 | 2022-08-09 04:20:34 | Mercer, Illinois, US | |
3543879 | 3543879 | 2022-08-08 | US | Alabama | Macon | 1087 | 4452 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-09 04:20:34 | Macon, Alabama, US | |
1070282 | 1070282 | 2022-08-07 | US | Alabama | Macon | 1087 | 4452 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-08 04:21:08 | Macon, Alabama, US | |
1940870 | 1940870 | 2022-08-06 | US | Alabama | Macon | 1087 | 4452 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-07 04:20:54 | Macon, Alabama, US | |
880669 | 880669 | 2022-08-05 | US | Alabama | Macon | 1087 | 4452 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-06 04:20:56 | Macon, Alabama, US | |
2012005 | 2012005 | 2022-08-04 | US | Virginia | Buckingham | 51029 | 4452 | 59 | 0 | 37.57242268 | -78.52518834 | 2022-08-05 04:20:52 | Buckingham, Virginia, US | |
2009080 | 2009080 | 2022-08-04 | US | Alabama | Macon | 1087 | 4452 | 86 | 0 | 32.38759944 | -85.69267724 | 2022-08-05 04:20:52 | Macon, Alabama, US | |
3620675 | 3620675 | 2022-08-01 | US | Wisconsin | Washburn | 55129 | 4452 | 47 | 0 | 45.89838588 | -91.79050449 | 2022-08-02 04:20:53 | Washburn, Wisconsin, US | |
3620427 | 3620427 | 2022-08-01 | US | Virginia | Giles | 51071 | 4452 | 50 | 0 | 37.31234791 | -80.70636931 | 2022-08-02 04:20:53 | Giles, Virginia, US | |
3872944 | 3872944 | 2022-07-31 | US | Kentucky | Caldwell | 21033 | 4452 | 63 | 0 | 37.14749129 | -87.86948214 | 2022-08-01 04:21:03 | Caldwell, Kentucky, US | |
675698 | 675698 | 2022-07-30 | US | Kentucky | Caldwell | 21033 | 4452 | 63 | 0 | 37.14749129 | -87.86948214 | 2022-07-31 04:21:02 | Caldwell, Kentucky, US | |
1784897 | 1784897 | 2022-07-29 | US | Kentucky | Caldwell | 21033 | 4452 | 63 | 0 | 37.14749129 | -87.86948214 | 2022-07-30 04:20:42 | Caldwell, Kentucky, US | |
1067260 | 1067260 | 2022-07-28 | US | Kentucky | Caldwell | 21033 | 4452 | 63 | 0 | 37.14749129 | -87.86948214 | 2022-07-29 04:20:45 | Caldwell, Kentucky, US | |
2338746 | 2338746 | 2022-07-27 | US | Virginia | Greene | 51079 | 4452 | 62 | 0 | 38.29545894 | -78.46525378 | 2022-07-28 04:20:56 | Greene, Virginia, US | |
2336779 | 2336779 | 2022-07-27 | US | Kentucky | Caldwell | 21033 | 4452 | 63 | 0 | 37.14749129 | -87.86948214 | 2022-07-28 04:20:56 | Caldwell, Kentucky, US | |
1488969 | 1488969 | 2022-07-26 | US | Kentucky | Caldwell | 21033 | 4452 | 63 | 0 | 37.14749129 | -87.86948214 | 2022-07-27 04:21:04 | Caldwell, Kentucky, US | |
2595415 | 2595415 | 2022-07-25 | US | Kentucky | Caldwell | 21033 | 4452 | 63 | 0 | 37.14749129 | -87.86948214 | 2022-07-26 04:20:58 | Caldwell, Kentucky, US | |
3408380 | 3408380 | 2022-07-17 | US | Tennessee | Cannon | 47015 | 4452 | 68 | 0 | 35.80990797 | -86.05738983 | 2022-07-18 04:20:59 | Cannon, Tennessee, US | |
2790460 | 2790460 | 2022-07-10 | US | Kentucky | Knott | 21119 | 4452 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-11 04:20:46 | Knott, Kentucky, US | |
143413 | 143413 | 2022-07-09 | US | Kentucky | Knott | 21119 | 4452 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-10 04:20:54 | Knott, Kentucky, US | |
1418513 | 1418513 | 2022-07-08 | US | Kentucky | Knott | 21119 | 4452 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-09 04:20:59 | Knott, Kentucky, US | |
2742438 | 2742438 | 2022-07-07 | US | Kentucky | Knott | 21119 | 4452 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-08 04:20:56 | Knott, Kentucky, US | |
1201233 | 1201233 | 2022-07-06 | US | Kentucky | Knott | 21119 | 4452 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-07 04:20:55 | Knott, Kentucky, US | |
3967976 | 3967976 | 2022-07-05 | US | Kentucky | Knott | 21119 | 4452 | 66 | 0 | 37.35388197 | -82.94981134 | 2022-07-06 04:20:58 | Knott, Kentucky, US | |
941586 | 941586 | 2022-06-25 | US | Puerto Rico | Orocovis | 72107 | 4452 | 0 | 0 | 18.215046 | -66.433604 | 2022-06-26 04:21:02 | Orocovis, Puerto Rico, US | |
3271025 | 3271025 | 2022-06-19 | US | Louisiana | Jackson | 22049 | 4452 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-06-20 04:21:01 | Jackson, Louisiana, US | |
3398937 | 3398937 | 2022-06-18 | US | Louisiana | Jackson | 22049 | 4452 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-06-19 04:20:51 | Jackson, Louisiana, US | |
2312814 | 2312814 | 2022-06-17 | US | Louisiana | Jackson | 22049 | 4452 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-06-18 04:21:10 | Jackson, Louisiana, US | |
560318 | 560318 | 2022-06-16 | US | Louisiana | Jackson | 22049 | 4452 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-06-17 04:20:56 | Jackson, Louisiana, US | |
3727894 | 3727894 | 2022-06-07 | US | Michigan | Ogemaw | 26129 | 4452 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-06-08 04:20:55 | Ogemaw, Michigan, US | |
3889296 | 3889296 | 2022-06-06 | US | Michigan | Ogemaw | 26129 | 4452 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-06-07 04:21:08 | Ogemaw, Michigan, US | |
3509065 | 3509065 | 2022-06-05 | US | Michigan | Ogemaw | 26129 | 4452 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-06-06 04:20:57 | Ogemaw, Michigan, US | |
3529142 | 3529142 | 2022-06-04 | US | Michigan | Ogemaw | 26129 | 4452 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-06-05 04:20:55 | Ogemaw, Michigan, US | |
3135228 | 3135228 | 2022-06-03 | US | Michigan | Ogemaw | 26129 | 4452 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-06-04 04:20:58 | Ogemaw, Michigan, US | |
3580303 | 3580303 | 2022-06-02 | US | Michigan | Ogemaw | 26129 | 4452 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-06-03 04:20:58 | Ogemaw, Michigan, US | |
972596 | 972596 | 2022-06-01 | US | Michigan | Ogemaw | 26129 | 4452 | 106 | 0 | 44.33481032 | -84.12725175 | 2022-06-02 05:20:39 | Ogemaw, Michigan, US | |
3896942 | 3896942 | 2022-05-19 | US | Illinois | De Witt | 17039 | 4452 | 39 | 0 | 40.17514519 | -88.90959682 | 2022-05-20 04:20:57 | De Witt, Illinois, US | |
1187465 | 1187465 | 2022-05-18 | US | Puerto Rico | Anasco | 72011 | 4452 | 0 | 0 | 18.287985 | -67.120611 | 2022-05-19 04:20:54 | Anasco, Puerto Rico, US | |
1186224 | 1186224 | 2022-05-18 | US | Kentucky | Unassigned | 90021 | 4452 | 25 | 0 | 38.97065142 | 0.0 | 2022-05-19 04:20:54 | Unassigned, Kentucky, US | |
2085511 | 2085511 | 2022-05-15 | US | Louisiana | Winn | 22127 | 4452 | 64 | 0 | 31.94449367 | -92.63789413 | 2022-05-16 04:20:47 | Winn, Louisiana, US | |
3356221 | 3356221 | 2022-05-14 | US | Louisiana | Winn | 22127 | 4452 | 64 | 0 | 31.94449367 | -92.63789413 | 2022-05-15 04:20:53 | Winn, Louisiana, US | |
659866 | 659866 | 2022-05-13 | US | Louisiana | Winn | 22127 | 4452 | 64 | 0 | 31.94449367 | -92.63789413 | 2022-05-14 04:20:48 | Winn, Louisiana, US | |
3448153 | 3448153 | 2022-05-11 | US | Virginia | Bristol | 51520 | 4452 | 80 | 0 | 36.6163024 | -82.16359122 | 2022-05-12 04:20:54 | Bristol, Virginia, US | |
3917023 | 3917023 | 2022-05-01 | US | Illinois | Ford | 17053 | 4452 | 66 | 0 | 40.59706922 | -88.22350769 | 2022-05-02 04:21:10 | Ford, Illinois, US | |
2841827 | 2841827 | 2022-04-30 | US | Illinois | Ford | 17053 | 4452 | 66 | 0 | 40.59706922 | -88.22350769 | 2022-05-01 04:20:57 | Ford, Illinois, US | |
1158140 | 1158140 | 2022-04-29 | US | Illinois | Ford | 17053 | 4452 | 66 | 0 | 40.59706922 | -88.22350769 | 2022-04-30 04:21:05 | Ford, Illinois, US | |
1224444 | 1224444 | 2022-04-14 | US | Georgia | Meriwether | 13199 | 4452 | 144 | 0 | 33.04163534 | -84.68859732 | 2022-04-15 04:20:57 | Meriwether, Georgia, US | |
2443602 | 2443602 | 2022-04-13 | US | Georgia | Meriwether | 13199 | 4452 | 144 | 0 | 33.04163534 | -84.68859732 | 2022-04-13 23:21:06 | Meriwether, Georgia, US | |
2752108 | 2752108 | 2022-04-04 | US | Texas | Shelby | 48419 | 4452 | 133 | 0 | 31.79211404 | -94.14550696 | 2022-04-05 04:20:48 | Shelby, Texas, US | |
3733454 | 3733454 | 2022-04-03 | US | Texas | Shelby | 48419 | 4452 | 133 | 0 | 31.79211404 | -94.14550696 | 2022-04-04 04:20:51 | Shelby, Texas, US | |
502889 | 502889 | 2022-04-02 | US | Texas | Shelby | 48419 | 4452 | 133 | 0 | 31.79211404 | -94.14550696 | 2022-04-03 04:20:48 | Shelby, Texas, US | |
1468589 | 1468589 | 2022-03-24 | US | Arkansas | Grant | 5053 | 4452 | 60 | 0 | 34.29017991 | -92.42320562 | 2022-03-25 04:20:46 | Grant, Arkansas, US | |
1468478 | 1468478 | 2022-03-24 | US | Alabama | Henry | 1067 | 4452 | 73 | 0 | 31.51148016 | -85.24267944 | 2022-03-25 04:20:46 | Henry, Alabama, US | |
359093 | 359093 | 2022-03-11 | US | Puerto Rico | Naranjito | 72105 | 4452 | 0 | 0 | 18.288019 | -66.252703 | 2022-03-12 04:20:50 | Naranjito, Puerto Rico, US | |
1058700 | 1058700 | 2022-02-23 | US | Georgia | Morgan | 13211 | 4452 | 56 | 0 | 33.59232073 | -83.49129491 | 2022-02-24 04:21:14 | Morgan, Georgia, US | |
2447263 | 2447263 | 2022-02-22 | US | Arkansas | Hempstead | 5057 | 4452 | 54 | 0 | 33.73325583 | -93.66935133 | 2022-02-23 04:21:09 | Hempstead, Arkansas, US | |
3718676 | 3718676 | 2022-02-21 | US | Arkansas | Hempstead | 5057 | 4452 | 54 | 0 | 33.73325583 | -93.66935133 | 2022-02-22 04:21:01 | Hempstead, Arkansas, US | |
1465803 | 1465803 | 2022-02-10 | US | Minnesota | Fillmore | 27045 | 4452 | 22 | 0 | 43.67394126 | -92.08980382 | 2022-02-11 04:21:09 | Fillmore, Minnesota, US | |
2474753 | 2474753 | 2022-02-03 | US | Georgia | Elbert | 13105 | 4452 | 97 | 0 | 34.11302332 | -82.83936148 | 2022-02-04 04:21:10 | Elbert, Georgia, US | |
1780489 | 1780489 | 2022-01-27 | US | Indiana | Jay | 18075 | 4452 | 65 | 0 | 40.43781032 | -85.00576229 | 2022-01-28 04:21:09 | Jay, Indiana, US | |
1229829 | 1229829 | 2022-01-24 | US | New Mexico | Taos | 35055 | 4452 | 76 | 0 | 36.58006022 | -105.63101979999999 | 2022-01-25 04:21:05 | Taos, New Mexico, US | |
1142237 | 1142237 | 2022-01-23 | US | Kansas | Neosho | 20133 | 4452 | 57 | 0 | 37.55862897 | -95.30670046 | 2022-01-24 04:21:12 | Neosho, Kansas, US | |
2834155 | 2834155 | 2022-01-22 | US | Kansas | Neosho | 20133 | 4452 | 57 | 0 | 37.55862897 | -95.30670046 | 2022-01-23 04:21:13 | Neosho, Kansas, US | |
3426273 | 3426273 | 2022-01-21 | US | Kansas | Neosho | 20133 | 4452 | 57 | 0 | 37.55862897 | -95.30670046 | 2022-01-22 04:21:13 | Neosho, Kansas, US | |
3425452 | 3425452 | 2022-01-21 | US | Arkansas | Logan | 5083 | 4452 | 57 | 0 | 35.21413234 | -93.71951016 | 2022-01-22 04:21:13 | Logan, Arkansas, US | |
3843244 | 3843244 | 2022-01-15 | US | Puerto Rico | Cidra | 72041 | 4452 | 0 | 0 | 18.173559 | -66.161179 | 2022-01-16 04:21:12 | Cidra, Puerto Rico, US | |
3615884 | 3615884 | 2022-01-12 | US | South Carolina | Fairfield | 45039 | 4452 | 96 | 0 | 34.39287073 | -81.1195624 | 2022-01-13 08:00:09 | Fairfield, South Carolina, US | |
3612746 | 3612746 | 2022-01-12 | Australia | Northern Territory | 4452 | 1 | 0 | -12.4634 | 130.8456 | 2022-01-13 08:00:09 | Northern Territory, Australia | |||
1282902 | 1282902 | 2022-01-05 | US | Hawaii | Kauai | 15007 | 4452 | 18 | 0 | 22.03935037 | -159.5966786 | 2022-01-06 04:22:09 | Kauai, Hawaii, US | |
1703262 | 1703262 | 2022-01-03 | US | South Dakota | Yankton | 46135 | 4452 | 45 | 0 | 43.00924485 | -97.39467635 | 2022-01-04 04:22:17 | Yankton, South Dakota, US | |
3521008 | 3521008 | 2022-01-02 | US | Maryland | Caroline | 24011 | 4452 | 57 | 0 | 38.87172293 | -75.82904158 | 2022-01-03 02:22:25 | Caroline, Maryland, US | |
4001645 | 4001645 | 2021-12-30 | US | Tennessee | Smith | 47159 | 4452 | 63 | 0 | 36.25359775 | -85.95411046 | 2021-12-31 04:21:50 | Smith, Tennessee, US | |
1433220 | 1433220 | 2021-12-28 | US | Colorado | Routt | 8107 | 4452 | 24 | 0 | 40.48596505 | -106.9905548 | 2021-12-29 03:21:43 | Routt, Colorado, US | |
1432914 | 1432914 | 2021-12-28 | US | Alabama | Bibb | 1007 | 4452 | 95 | 0 | 32.99642064 | -87.12511459999996 | 2021-12-29 03:21:43 | Bibb, Alabama, US | |
798561 | 798561 | 2021-12-22 | Netherlands | Unknown | 4452 | 34 | 0 | 2021-12-23 04:21:21 | Unknown, Netherlands | |||||
2907203 | 2907203 | 2021-12-19 | US | West Virginia | Jackson | 54035 | 4452 | 103 | 0 | 38.84263974 | -81.68148753 | 2021-12-20 04:21:43 | Jackson, West Virginia, US | |
785685 | 785685 | 2021-12-13 | US | Vermont | Windsor | 50027 | 4452 | 35 | 0 | 43.58010937 | -72.58595157 | 2021-12-14 04:22:38 | Windsor, Vermont, US | |
406036 | 406036 | 2021-12-07 | US | Minnesota | Meeker | 27093 | 4452 | 60 | 0 | 45.12328869 | -94.52839455 | 2021-12-08 04:22:46 | Meeker, Minnesota, US | |
3461 | 3461 | 2021-12-02 | US | Texas | Jasper | 48241 | 4452 | 163 | 0 | 30.74685667 | -94.02667579 | 2021-12-03 04:23:05 | Jasper, Texas, US | |
1878 | 1878 | 2021-12-02 | US | Louisiana | West Baton Rouge | 22121 | 4452 | 78 | 0 | 30.46058217 | -91.30989571 | 2021-12-03 04:23:05 | West Baton Rouge, Louisiana, US | |
3514964 | 3514964 | 2021-11-01 | US | Wisconsin | Lincoln | 55069 | 4452 | 110 | 0 | 45.33737523 | -89.73411273 | 2021-11-02 04:22:03 | Lincoln, Wisconsin, US | |
635309 | 635309 | 2021-10-13 | US | Kentucky | Carter | 21043 | 4452 | 57 | 0 | 38.31690743 | -83.05092385 | 2021-10-14 04:21:29 | Carter, Kentucky, US | |
3008107 | 3008107 | 2021-10-11 | US | Georgia | Chattooga | 13055 | 4452 | 98 | 0 | 34.47197698 | -85.34535662 | 2021-10-12 04:21:09 | Chattooga, Georgia, US | |
424123 | 424123 | 2021-10-10 | US | Georgia | Chattooga | 13055 | 4452 | 98 | 0 | 34.47197698 | -85.34535662 | 2021-10-11 04:21:31 | Chattooga, Georgia, US | |
2876980 | 2876980 | 2021-10-09 | US | Georgia | Chattooga | 13055 | 4452 | 98 | 0 | 34.47197698 | -85.34535662 | 2021-10-10 04:21:38 | Chattooga, Georgia, US | |
2960146 | 2960146 | 2021-10-08 | US | Georgia | Chattooga | 13055 | 4452 | 98 | 0 | 34.47197698 | -85.34535662 | 2021-10-09 04:21:34 | Chattooga, Georgia, US | |
468915 | 468915 | 2021-10-07 | US | Louisiana | East Feliciana | 22037 | 4452 | 142 | 0 | 30.84425359 | -91.04976723 | 2021-10-08 04:21:25 | East Feliciana, Louisiana, 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]);