johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
235 rows where confirmed = 3189 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1074563 | 1074563 | 2022-12-28 | US | Colorado | Prowers | 8099 | 3189 | 52 | 0 | 37.95544985 | -102.3926052 | 2022-12-29 04:21:01 | Prowers, Colorado, US | |
329071 | 329071 | 2022-12-27 | US | Iowa | Allamakee | 19005 | 3189 | 64 | 0 | 43.28383218 | -91.37860922 | 2022-12-28 04:21:04 | Allamakee, Iowa, US | |
219144 | 219144 | 2022-12-26 | US | Iowa | Allamakee | 19005 | 3189 | 64 | 0 | 43.28383218 | -91.37860922 | 2022-12-27 04:21:07 | Allamakee, Iowa, US | |
3223601 | 3223601 | 2022-12-25 | US | Iowa | Allamakee | 19005 | 3189 | 64 | 0 | 43.28383218 | -91.37860922 | 2022-12-26 04:21:06 | Allamakee, Iowa, US | |
1019515 | 1019515 | 2022-12-24 | US | Iowa | Allamakee | 19005 | 3189 | 64 | 0 | 43.28383218 | -91.37860922 | 2022-12-25 04:21:04 | Allamakee, Iowa, US | |
691538 | 691538 | 2022-12-23 | US | Iowa | Allamakee | 19005 | 3189 | 64 | 0 | 43.28383218 | -91.37860922 | 2022-12-24 04:21:02 | Allamakee, Iowa, US | |
2180748 | 2180748 | 2022-12-22 | US | Iowa | Allamakee | 19005 | 3189 | 64 | 0 | 43.28383218 | -91.37860922 | 2022-12-23 04:21:04 | Allamakee, Iowa, US | |
452552 | 452552 | 2022-12-21 | US | Iowa | Allamakee | 19005 | 3189 | 64 | 0 | 43.28383218 | -91.37860922 | 2022-12-22 04:20:56 | Allamakee, Iowa, US | |
546141 | 546141 | 2022-12-15 | US | Virginia | Lunenburg | 51111 | 3189 | 45 | 0 | 36.94618528 | -78.24133319 | 2022-12-16 04:21:01 | Lunenburg, Virginia, US | |
3716479 | 3716479 | 2022-12-06 | US | North Carolina | Clay | 37043 | 3189 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-07 04:20:58 | Clay, North Carolina, US | |
2417184 | 2417184 | 2022-12-05 | US | North Carolina | Clay | 37043 | 3189 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-06 04:21:03 | Clay, North Carolina, US | |
720792 | 720792 | 2022-12-04 | US | North Carolina | Clay | 37043 | 3189 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-05 04:20:58 | Clay, North Carolina, US | |
2819081 | 2819081 | 2022-12-03 | US | North Carolina | Clay | 37043 | 3189 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-04 04:20:56 | Clay, North Carolina, US | |
835937 | 835937 | 2022-12-02 | US | North Carolina | Clay | 37043 | 3189 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-03 04:21:02 | Clay, North Carolina, US | |
2138467 | 2138467 | 2022-12-01 | US | North Carolina | Clay | 37043 | 3189 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-02 04:21:07 | Clay, North Carolina, US | |
1966883 | 1966883 | 2022-11-30 | US | North Carolina | Clay | 37043 | 3189 | 50 | 0 | 35.05704275 | -83.74353633 | 2022-12-01 04:21:03 | Clay, North Carolina, US | |
3098843 | 3098843 | 2022-10-09 | US | Kentucky | Elliott | 21063 | 3189 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-10-10 04:22:32 | Elliott, Kentucky, US | |
4004068 | 4004068 | 2022-10-08 | US | Kentucky | Elliott | 21063 | 3189 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-10-09 04:21:16 | Elliott, Kentucky, US | |
397665 | 397665 | 2022-10-07 | US | Kentucky | Elliott | 21063 | 3189 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-10-08 04:22:56 | Elliott, Kentucky, US | |
2530782 | 2530782 | 2022-10-06 | US | Kentucky | Elliott | 21063 | 3189 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-10-07 04:23:08 | Elliott, Kentucky, US | |
1812176 | 1812176 | 2022-10-05 | US | Kentucky | Elliott | 21063 | 3189 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-10-06 04:21:22 | Elliott, Kentucky, US | |
132150 | 132150 | 2022-10-04 | US | Kentucky | Elliott | 21063 | 3189 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-10-05 04:23:06 | Elliott, Kentucky, US | |
2687097 | 2687097 | 2022-10-03 | US | Kentucky | Elliott | 21063 | 3189 | 22 | 0 | 38.11624059 | -83.09771563 | 2022-10-04 04:22:55 | Elliott, Kentucky, US | |
2343928 | 2343928 | 2022-08-31 | US | Arkansas | Lee | 5077 | 3189 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-09-01 04:21:03 | Lee, Arkansas, US | |
1683312 | 1683312 | 2022-08-29 | US | South Carolina | Calhoun | 45017 | 3189 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-08-30 04:21:03 | Calhoun, South Carolina, US | |
1879796 | 1879796 | 2022-08-28 | US | South Carolina | Calhoun | 45017 | 3189 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-08-29 04:21:06 | Calhoun, South Carolina, US | |
2098923 | 2098923 | 2022-08-27 | US | South Carolina | Calhoun | 45017 | 3189 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-08-28 04:21:02 | Calhoun, South Carolina, US | |
1534738 | 1534738 | 2022-08-26 | US | South Carolina | Calhoun | 45017 | 3189 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-08-27 04:20:57 | Calhoun, South Carolina, US | |
2831625 | 2831625 | 2022-08-25 | US | South Carolina | Calhoun | 45017 | 3189 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-08-26 04:21:02 | Calhoun, South Carolina, US | |
2829836 | 2829836 | 2022-08-25 | US | Illinois | Marshall | 17123 | 3189 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-08-26 04:21:02 | Marshall, Illinois, US | |
2326158 | 2326158 | 2022-08-24 | US | South Carolina | Calhoun | 45017 | 3189 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-08-25 04:21:13 | Calhoun, South Carolina, US | |
1253567 | 1253567 | 2022-08-23 | US | South Carolina | Calhoun | 45017 | 3189 | 61 | 0 | 33.66926881 | -80.77722168 | 2022-08-24 04:20:46 | Calhoun, South Carolina, US | |
3405273 | 3405273 | 2022-07-17 | China | Zhejiang | 3189 | 1 | 0 | 29.1832 | 120.0934 | 2022-07-18 04:20:59 | Zhejiang, China | |||
2154846 | 2154846 | 2022-07-16 | US | Texas | Nolan | 48353 | 3189 | 99 | 0 | 32.30365282 | -100.4060208 | 2022-07-17 04:21:15 | Nolan, Texas, US | |
1212036 | 1212036 | 2022-07-11 | US | Arkansas | Desha | 5041 | 3189 | 41 | 0 | 33.83011025 | -91.25500948 | 2022-07-12 04:20:51 | Desha, Arkansas, US | |
2789682 | 2789682 | 2022-07-10 | US | Colorado | Park | 8093 | 3189 | 22 | 0 | 39.120926 | -105.7182065 | 2022-07-11 04:20:46 | Park, Colorado, US | |
948328 | 948328 | 2022-06-14 | US | Kentucky | Unassigned | 90021 | 3189 | 9 | 0 | 38.97065142 | 0.0 | 2022-06-15 04:20:54 | Unassigned, Kentucky, US | |
3594612 | 3594612 | 2022-05-23 | US | Maryland | Kent | 24029 | 3189 | 66 | 0 | 39.24976208 | -76.04741541 | 2022-05-24 04:20:57 | Kent, Maryland, US | |
3724006 | 3724006 | 2022-04-25 | US | Mississippi | Greene | 28041 | 3189 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-26 04:20:51 | Greene, Mississippi, US | |
2030574 | 2030574 | 2022-04-24 | US | Mississippi | Greene | 28041 | 3189 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-25 04:20:56 | Greene, Mississippi, US | |
748149 | 748149 | 2022-04-23 | US | Mississippi | Greene | 28041 | 3189 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-24 04:20:56 | Greene, Mississippi, US | |
3438634 | 3438634 | 2022-04-22 | US | Mississippi | Greene | 28041 | 3189 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-23 04:20:50 | Greene, Mississippi, US | |
2894219 | 2894219 | 2022-04-21 | US | Mississippi | Greene | 28041 | 3189 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-22 04:20:45 | Greene, Mississippi, US | |
2309091 | 2309091 | 2022-04-20 | US | Mississippi | Greene | 28041 | 3189 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-21 04:20:46 | Greene, Mississippi, US | |
2253230 | 2253230 | 2022-04-19 | US | Mississippi | Greene | 28041 | 3189 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-20 04:20:45 | Greene, Mississippi, US | |
1847780 | 1847780 | 2022-04-18 | US | Mississippi | Greene | 28041 | 3189 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-04-19 04:21:00 | Greene, Mississippi, US | |
1655092 | 1655092 | 2022-04-09 | US | Pennsylvania | Potter | 42105 | 3189 | 92 | 0 | 41.74471626 | -77.89559864 | 2022-04-10 04:20:52 | Potter, Pennsylvania, US | |
879575 | 879575 | 2022-03-27 | US | Virginia | Brunswick | 51025 | 3189 | 45 | 0 | 36.76366949 | -77.8593436 | 2022-03-28 04:20:33 | Brunswick, Virginia, US | |
2166858 | 2166858 | 2022-03-26 | US | Virginia | Brunswick | 51025 | 3189 | 45 | 0 | 36.76366949 | -77.8593436 | 2022-03-27 04:20:47 | Brunswick, Virginia, US | |
1723794 | 1723794 | 2022-03-25 | US | Virginia | Brunswick | 51025 | 3189 | 45 | 0 | 36.76366949 | -77.8593436 | 2022-03-26 04:20:23 | Brunswick, Virginia, US | |
1867093 | 1867093 | 2022-03-10 | US | Michigan | Arenac | 26011 | 3189 | 64 | 0 | 44.0636262 | -83.89277559 | 2022-03-11 04:20:50 | Arenac, Michigan, US | |
2141788 | 2141788 | 2022-03-09 | US | Michigan | Arenac | 26011 | 3189 | 64 | 0 | 44.0636262 | -83.89277559 | 2022-03-10 04:20:48 | Arenac, Michigan, US | |
2094598 | 2094598 | 2022-03-05 | US | Ohio | Noble | 39121 | 3189 | 58 | 0 | 39.76818851 | -81.45937183 | 2022-03-06 04:20:49 | Noble, Ohio, US | |
2527309 | 2527309 | 2022-03-02 | US | Missouri | Osage | 29151 | 3189 | 40 | 0 | 38.46036182 | -91.8613635 | 2022-03-03 04:21:01 | Osage, Missouri, US | |
2526221 | 2526221 | 2022-03-02 | US | Georgia | Oglethorpe | 13221 | 3189 | 49 | 0 | 33.878629600000004 | -83.08278123 | 2022-03-03 04:21:01 | Oglethorpe, Georgia, US | |
2449730 | 2449730 | 2022-02-22 | US | Tennessee | Jackson | 47087 | 3189 | 58 | 0 | 36.36380466 | -85.67239905 | 2022-02-23 04:21:09 | Jackson, Tennessee, US | |
2449246 | 2449246 | 2022-02-22 | US | Ohio | Harrison | 39067 | 3189 | 74 | 0 | 40.29380509 | -81.09068544 | 2022-02-23 04:21:09 | Harrison, Ohio, US | |
3720659 | 3720659 | 2022-02-21 | US | Ohio | Harrison | 39067 | 3189 | 74 | 0 | 40.29380509 | -81.09068544 | 2022-02-22 04:21:01 | Harrison, Ohio, US | |
3856336 | 3856336 | 2022-02-18 | US | Arkansas | Little River | 5081 | 3189 | 87 | 0 | 33.70375665 | -94.23468591 | 2022-02-19 04:21:11 | Little River, Arkansas, US | |
2645330 | 2645330 | 2022-02-14 | US | Wisconsin | Price | 55099 | 3189 | 28 | 0 | 45.68051754 | -90.36098879999999 | 2022-02-15 04:21:09 | Price, Wisconsin, US | |
189147 | 189147 | 2022-02-13 | US | Texas | Duval | 48131 | 3189 | 67 | 0 | 27.68184592 | -98.50864568 | 2022-02-14 04:20:51 | Duval, Texas, US | |
982298 | 982298 | 2022-02-01 | US | Virginia | Greensville | 51081 | 3189 | 30 | 0 | 36.67878901 | -77.56351439 | 2022-02-02 04:21:09 | Greensville, Virginia, US | |
980149 | 980149 | 2022-02-01 | US | Iowa | Harrison | 19085 | 3189 | 89 | 0 | 41.68330137 | -95.81558439 | 2022-02-02 04:21:09 | Harrison, Iowa, US | |
2660765 | 2660765 | 2022-01-31 | US | Tennessee | Meigs | 47121 | 3189 | 50 | 0 | 35.51558739 | -84.81482914 | 2022-02-01 04:21:11 | Meigs, Tennessee, US | |
2658991 | 2658991 | 2022-01-31 | US | Iowa | Harrison | 19085 | 3189 | 89 | 0 | 41.68330137 | -95.81558439 | 2022-02-01 04:21:11 | Harrison, Iowa, US | |
3301826 | 3301826 | 2022-01-30 | US | Michigan | Benzie | 26019 | 3189 | 60 | 0 | 44.63899297 | -86.01608482 | 2022-01-31 04:21:09 | Benzie, Michigan, US | |
3301408 | 3301408 | 2022-01-30 | US | Iowa | Harrison | 19085 | 3189 | 89 | 0 | 41.68330137 | -95.81558439 | 2022-01-31 04:21:09 | Harrison, Iowa, US | |
3063617 | 3063617 | 2022-01-29 | US | Michigan | Benzie | 26019 | 3189 | 60 | 0 | 44.63899297 | -86.01608482 | 2022-01-30 04:21:26 | Benzie, Michigan, US | |
3063199 | 3063199 | 2022-01-29 | US | Iowa | Harrison | 19085 | 3189 | 89 | 0 | 41.68330137 | -95.81558439 | 2022-01-30 04:21:26 | Harrison, Iowa, US | |
3811551 | 3811551 | 2022-01-28 | US | Michigan | Benzie | 26019 | 3189 | 60 | 0 | 44.63899297 | -86.01608482 | 2022-01-29 04:21:10 | Benzie, Michigan, US | |
3811133 | 3811133 | 2022-01-28 | US | Iowa | Harrison | 19085 | 3189 | 89 | 0 | 41.68330137 | -95.81558439 | 2022-01-29 04:21:10 | Harrison, Iowa, US | |
1780587 | 1780587 | 2022-01-27 | US | Iowa | Harrison | 19085 | 3189 | 89 | 0 | 41.68330137 | -95.81558439 | 2022-01-28 04:21:09 | Harrison, Iowa, US | |
1321235 | 1321235 | 2022-01-26 | US | Texas | Bandera | 48019 | 3189 | 67 | 0 | 29.74619598 | -99.24598147 | 2022-01-27 04:21:19 | Bandera, Texas, US | |
1320987 | 1320987 | 2022-01-26 | US | Puerto Rico | Quebradillas | 72115 | 3189 | 0 | 0 | 18.439692 | -66.926113 | 2022-01-27 04:21:19 | Quebradillas, Puerto Rico, US | |
1319415 | 1319415 | 2022-01-26 | US | Iowa | Harrison | 19085 | 3189 | 89 | 0 | 41.68330137 | -95.81558439 | 2022-01-27 04:21:19 | Harrison, Iowa, US | |
3428204 | 3428204 | 2022-01-21 | US | Texas | Wilbarger | 48487 | 3189 | 77 | 0 | 34.07945812 | -99.24178437 | 2022-01-22 04:21:13 | Wilbarger, Texas, US | |
3426876 | 3426876 | 2022-01-21 | US | Missouri | Macon | 29121 | 3189 | 40 | 0 | 39.83049768 | -92.56453089 | 2022-01-22 04:21:13 | Macon, Missouri, US | |
3690564 | 3690564 | 2022-01-13 | US | Texas | Falls | 48145 | 3189 | 52 | 0 | 31.25350609 | -96.93630086 | 2022-01-14 04:21:54 | Falls, Texas, US | |
3614484 | 3614484 | 2022-01-12 | US | Kentucky | Jackson | 21109 | 3189 | 59 | 0 | 37.41866422 | -83.99825483 | 2022-01-13 08:00:09 | Jackson, Kentucky, US | |
1114768 | 1114768 | 2022-01-11 | US | Iowa | Clay | 19041 | 3189 | 40 | 0 | 43.08247182 | -95.15096481 | 2022-01-12 04:21:44 | Clay, Iowa, US | |
1693496 | 1693496 | 2022-01-10 | US | Iowa | Clay | 19041 | 3189 | 40 | 0 | 43.08247182 | -95.15096481 | 2022-01-11 04:22:01 | Clay, Iowa, US | |
130255 | 130255 | 2022-01-09 | US | West Virginia | Wetzel | 54103 | 3189 | 68 | 0 | 39.6065771 | -80.64016540000001 | 2022-01-10 04:22:07 | Wetzel, West Virginia, US | |
127911 | 127911 | 2022-01-09 | US | Iowa | Clay | 19041 | 3189 | 40 | 0 | 43.08247182 | -95.15096481 | 2022-01-10 04:22:07 | Clay, Iowa, US | |
1217506 | 1217506 | 2022-01-08 | US | Missouri | Morgan | 29141 | 3189 | 76 | 0 | 38.4181765 | -92.88791859 | 2022-01-09 04:21:46 | Morgan, Missouri, US | |
1216746 | 1216746 | 2022-01-08 | US | Iowa | Clay | 19041 | 3189 | 40 | 0 | 43.08247182 | -95.15096481 | 2022-01-09 04:21:46 | Clay, Iowa, US | |
1390839 | 1390839 | 2022-01-07 | US | Iowa | Clay | 19041 | 3189 | 40 | 0 | 43.08247182 | -95.15096481 | 2022-01-08 04:21:53 | Clay, Iowa, US | |
2611226 | 2611226 | 2022-01-06 | US | Iowa | Clay | 19041 | 3189 | 40 | 0 | 43.08247182 | -95.15096481 | 2022-01-07 04:22:09 | Clay, Iowa, US | |
1283168 | 1283168 | 2022-01-05 | US | Iowa | Clay | 19041 | 3189 | 40 | 0 | 43.08247182 | -95.15096481 | 2022-01-06 04:22:09 | Clay, Iowa, US | |
3520837 | 3520837 | 2022-01-02 | US | Kentucky | Garrard | 21079 | 3189 | 59 | 0 | 37.638866799999995 | -84.53289319 | 2022-01-03 02:22:25 | Garrard, Kentucky, US | |
2168967 | 2168967 | 2022-01-01 | US | Kentucky | Garrard | 21079 | 3189 | 59 | 0 | 37.638866799999995 | -84.53289319 | 2022-01-02 04:20:52 | Garrard, Kentucky, US | |
2778398 | 2778398 | 2021-12-31 | US | Kentucky | Garrard | 21079 | 3189 | 59 | 0 | 37.638866799999995 | -84.53289319 | 2022-01-01 04:22:14 | Garrard, Kentucky, US | |
4000055 | 4000055 | 2021-12-30 | US | Kentucky | Garrard | 21079 | 3189 | 59 | 0 | 37.638866799999995 | -84.53289319 | 2021-12-31 04:21:50 | Garrard, Kentucky, US | |
1669862 | 1669862 | 2021-12-29 | US | Kentucky | Garrard | 21079 | 3189 | 59 | 0 | 37.638866799999995 | -84.53289319 | 2021-12-30 04:21:25 | Garrard, Kentucky, US | |
731980 | 731980 | 2021-12-27 | US | Kentucky | Morgan | 21175 | 3189 | 17 | 0 | 37.92465657 | -83.25558245 | 2021-12-28 04:21:47 | Morgan, Kentucky, US | |
3496808 | 3496808 | 2021-12-15 | US | Colorado | Elbert | 8039 | 3189 | 31 | 0 | 39.28656773 | -104.13587209999999 | 2021-12-16 04:22:11 | Elbert, Colorado, US | |
1078623 | 1078623 | 2021-12-09 | US | Florida | Gilchrist | 12041 | 3189 | 44 | 0 | 29.72856978 | -82.79880657 | 2021-12-10 04:22:28 | Gilchrist, Florida, US | |
551472 | 551472 | 2021-12-08 | US | Florida | Gilchrist | 12041 | 3189 | 44 | 0 | 29.72856978 | -82.79880657 | 2021-12-09 04:22:49 | Gilchrist, Florida, US | |
404992 | 404992 | 2021-12-07 | US | Florida | Gilchrist | 12041 | 3189 | 44 | 0 | 29.72856978 | -82.79880657 | 2021-12-08 04:22:46 | Gilchrist, Florida, US | |
1031074 | 1031074 | 2021-12-06 | US | Florida | Gilchrist | 12041 | 3189 | 44 | 0 | 29.72856978 | -82.79880657 | 2021-12-07 04:22:34 | Gilchrist, Florida, US | |
1742011 | 1742011 | 2021-12-05 | US | Kentucky | Spencer | 21215 | 3189 | 40 | 0 | 38.03223971 | -85.32749335 | 2021-12-06 04:22:34 | Spencer, Kentucky, 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]);