johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
160 rows where confirmed = 4449 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 150
- Colombia 2
- Italy 2
- Burkina Faso 1
- China 1
- Djibouti 1
- Russia 1
- Sierra Leone 1
- Spain 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3715410 | 3715410 | 2022-12-06 | US | Iowa | Poweshiek | 19157 | 4449 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-07 04:20:58 | Poweshiek, Iowa, US | |
2416115 | 2416115 | 2022-12-05 | US | Iowa | Poweshiek | 19157 | 4449 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-06 04:21:03 | Poweshiek, Iowa, US | |
719723 | 719723 | 2022-12-04 | US | Iowa | Poweshiek | 19157 | 4449 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-05 04:20:58 | Poweshiek, Iowa, US | |
2818012 | 2818012 | 2022-12-03 | US | Iowa | Poweshiek | 19157 | 4449 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-04 04:20:56 | Poweshiek, Iowa, US | |
834868 | 834868 | 2022-12-02 | US | Iowa | Poweshiek | 19157 | 4449 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-03 04:21:02 | Poweshiek, Iowa, US | |
2137398 | 2137398 | 2022-12-01 | US | Iowa | Poweshiek | 19157 | 4449 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-02 04:21:07 | Poweshiek, Iowa, US | |
1965814 | 1965814 | 2022-11-30 | US | Iowa | Poweshiek | 19157 | 4449 | 65 | 0 | 41.68625425 | -92.53155731 | 2022-12-01 04:21:03 | Poweshiek, Iowa, US | |
795474 | 795474 | 2022-10-24 | US | Illinois | Wabash | 17185 | 4449 | 30 | 0 | 38.44272901 | -87.84922065 | 2022-10-25 04:21:53 | Wabash, Illinois, US | |
3280235 | 3280235 | 2022-10-23 | US | Virginia | King William | 51101 | 4449 | 49 | 0 | 37.70965316 | -77.09384941 | 2022-10-24 04:22:29 | King William, Virginia, US | |
2271273 | 2271273 | 2022-10-22 | US | Virginia | King William | 51101 | 4449 | 49 | 0 | 37.70965316 | -77.09384941 | 2022-10-23 04:22:46 | King William, Virginia, US | |
1595573 | 1595573 | 2022-10-21 | US | Virginia | King William | 51101 | 4449 | 49 | 0 | 37.70965316 | -77.09384941 | 2022-10-22 04:22:53 | King William, Virginia, US | |
1595156 | 1595156 | 2022-10-21 | US | Tennessee | Grundy | 47061 | 4449 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-10-22 04:22:53 | Grundy, Tennessee, US | |
2274872 | 2274872 | 2022-10-20 | US | Tennessee | Grundy | 47061 | 4449 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-10-21 04:22:23 | Grundy, Tennessee, US | |
201207 | 201207 | 2022-10-19 | US | Tennessee | Grundy | 47061 | 4449 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-10-20 04:22:59 | Grundy, Tennessee, US | |
2759868 | 2759868 | 2022-10-18 | US | Tennessee | Grundy | 47061 | 4449 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-10-19 04:22:26 | Grundy, Tennessee, US | |
2027702 | 2027702 | 2022-10-17 | US | Tennessee | Grundy | 47061 | 4449 | 79 | 0 | 35.38433717 | -85.72142731 | 2022-10-18 04:22:42 | Grundy, Tennessee, US | |
2970799 | 2970799 | 2022-10-10 | US | Virginia | Patrick | 51141 | 4449 | 98 | 0 | 36.6801638 | -80.2865648 | 2022-10-11 04:23:05 | Patrick, Virginia, US | |
2532774 | 2532774 | 2022-10-06 | US | Virginia | Patrick | 51141 | 4449 | 98 | 0 | 36.6801638 | -80.2865648 | 2022-10-07 04:23:08 | Patrick, Virginia, US | |
2379027 | 2379027 | 2022-09-29 | US | West Virginia | Grant | 54023 | 4449 | 59 | 0 | 39.10314817 | -79.19440518 | 2022-09-30 04:23:09 | Grant, West Virginia, US | |
117111 | 117111 | 2022-09-06 | US | North Carolina | Polk | 37149 | 4449 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-09-07 04:20:59 | Polk, North Carolina, US | |
2636083 | 2636083 | 2022-09-05 | US | North Carolina | Polk | 37149 | 4449 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-09-06 04:21:02 | Polk, North Carolina, US | |
2989647 | 2989647 | 2022-09-04 | US | North Carolina | Polk | 37149 | 4449 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-09-05 04:21:01 | Polk, North Carolina, US | |
2715332 | 2715332 | 2022-09-03 | US | North Carolina | Polk | 37149 | 4449 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-09-04 04:21:22 | Polk, North Carolina, US | |
1396037 | 1396037 | 2022-09-02 | US | North Carolina | Polk | 37149 | 4449 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-09-03 04:21:04 | Polk, North Carolina, US | |
3549866 | 3549866 | 2022-09-01 | US | North Carolina | Polk | 37149 | 4449 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-09-02 04:21:07 | Polk, North Carolina, US | |
2345786 | 2345786 | 2022-08-31 | US | North Carolina | Polk | 37149 | 4449 | 68 | 0 | 35.27820615 | -82.16812354 | 2022-09-01 04:21:03 | Polk, North Carolina, US | |
3911033 | 3911033 | 2022-08-11 | US | Texas | Bosque | 48035 | 4449 | 70 | 0 | 31.89978581 | -97.63613524 | 2022-08-12 04:20:54 | Bosque, Texas, US | |
1070925 | 1070925 | 2022-08-07 | US | Illinois | Moultrie | 17139 | 4449 | 47 | 0 | 39.64187451 | -88.62099969 | 2022-08-08 04:21:08 | Moultrie, Illinois, US | |
1941513 | 1941513 | 2022-08-06 | US | Illinois | Moultrie | 17139 | 4449 | 47 | 0 | 39.64187451 | -88.62099969 | 2022-08-07 04:20:54 | Moultrie, Illinois, US | |
881312 | 881312 | 2022-08-05 | US | Illinois | Moultrie | 17139 | 4449 | 47 | 0 | 39.64187451 | -88.62099969 | 2022-08-06 04:20:56 | Moultrie, Illinois, US | |
1611417 | 1611417 | 2022-07-20 | US | Texas | Lavaca | 48285 | 4449 | 121 | 0 | 29.38508402 | -96.93186692 | 2022-07-21 04:21:10 | Lavaca, Texas, US | |
2154580 | 2154580 | 2022-07-16 | US | Tennessee | Cannon | 47015 | 4449 | 68 | 0 | 35.80990797 | -86.05738983 | 2022-07-17 04:21:15 | Cannon, Tennessee, US | |
2493170 | 2493170 | 2022-06-29 | US | Texas | Lamb | 48279 | 4449 | 122 | 0 | 34.06859623 | -102.3516289 | 2022-06-30 04:21:01 | Lamb, Texas, US | |
2150473 | 2150473 | 2022-06-27 | US | South Carolina | Lee | 45061 | 4449 | 96 | 0 | 34.16393091 | -80.25690731 | 2022-06-28 04:20:58 | Lee, South Carolina, US | |
478274 | 478274 | 2022-06-26 | US | South Carolina | Lee | 45061 | 4449 | 96 | 0 | 34.16393091 | -80.25690731 | 2022-06-27 04:21:00 | Lee, South Carolina, US | |
941649 | 941649 | 2022-06-25 | US | South Carolina | Lee | 45061 | 4449 | 96 | 0 | 34.16393091 | -80.25690731 | 2022-06-26 04:21:02 | Lee, South Carolina, US | |
3349469 | 3349469 | 2022-06-24 | US | South Carolina | Lee | 45061 | 4449 | 96 | 0 | 34.16393091 | -80.25690731 | 2022-06-25 04:20:57 | Lee, South Carolina, US | |
1651210 | 1651210 | 2022-06-23 | US | South Carolina | Lee | 45061 | 4449 | 96 | 0 | 34.16393091 | -80.25690731 | 2022-06-24 04:20:58 | Lee, South Carolina, US | |
2190445 | 2190445 | 2022-06-22 | US | South Carolina | Lee | 45061 | 4449 | 96 | 0 | 34.16393091 | -80.25690731 | 2022-06-23 04:20:55 | Lee, South Carolina, US | |
168876 | 168876 | 2022-06-21 | US | South Carolina | Lee | 45061 | 4449 | 96 | 0 | 34.16393091 | -80.25690731 | 2022-06-22 04:20:54 | Lee, South Carolina, US | |
3272900 | 3272900 | 2022-06-19 | US | Virginia | Nottoway | 51135 | 4449 | 94 | 0 | 37.1435975 | -78.05065922 | 2022-06-20 04:21:01 | Nottoway, Virginia, US | |
3400812 | 3400812 | 2022-06-18 | US | Virginia | Nottoway | 51135 | 4449 | 94 | 0 | 37.1435975 | -78.05065922 | 2022-06-19 04:20:51 | Nottoway, Virginia, US | |
2314689 | 2314689 | 2022-06-17 | US | Virginia | Nottoway | 51135 | 4449 | 94 | 0 | 37.1435975 | -78.05065922 | 2022-06-18 04:21:10 | Nottoway, Virginia, US | |
2980769 | 2980769 | 2022-06-13 | US | Louisiana | Jackson | 22049 | 4449 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-06-14 04:20:52 | Jackson, Louisiana, US | |
2051157 | 2051157 | 2022-05-25 | US | Vermont | Orange | 50017 | 4449 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-05-26 04:20:50 | Orange, Vermont, US | |
3002595 | 3002595 | 2022-05-24 | US | Vermont | Orange | 50017 | 4449 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-05-25 04:20:56 | Orange, Vermont, US | |
3596316 | 3596316 | 2022-05-23 | US | Vermont | Orange | 50017 | 4449 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-05-24 04:20:57 | Orange, Vermont, US | |
625168 | 625168 | 2022-05-22 | US | Vermont | Orange | 50017 | 4449 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-05-26 04:20:50 | Orange, Vermont, US | |
1112864 | 1112864 | 2022-05-21 | US | Vermont | Orange | 50017 | 4449 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-05-22 04:20:52 | Orange, Vermont, US | |
1172488 | 1172488 | 2022-05-20 | US | Vermont | Orange | 50017 | 4449 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-05-21 04:20:58 | Orange, Vermont, US | |
3899251 | 3899251 | 2022-05-19 | US | Vermont | Orange | 50017 | 4449 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-05-20 04:20:57 | Orange, Vermont, US | |
1188035 | 1188035 | 2022-05-18 | US | Vermont | Orange | 50017 | 4449 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-05-19 04:20:54 | Orange, Vermont, US | |
3438398 | 3438398 | 2022-04-22 | US | Maine | Washington | 23029 | 4449 | 55 | 0 | 45.01607142 | -67.62813524 | 2022-04-23 04:20:50 | Washington, Maine, US | |
3417955 | 3417955 | 2022-04-17 | US | Illinois | Piatt | 17147 | 4449 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-04-18 04:21:12 | Piatt, Illinois, US | |
304904 | 304904 | 2022-04-16 | US | Illinois | Piatt | 17147 | 4449 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-04-17 04:20:59 | Piatt, Illinois, US | |
2670849 | 2670849 | 2022-04-15 | US | Illinois | Piatt | 17147 | 4449 | 23 | 0 | 40.01360584 | -88.59319339 | 2022-04-16 04:20:48 | Piatt, Illinois, US | |
3353874 | 3353874 | 2022-04-01 | US | Texas | Shelby | 48419 | 4449 | 133 | 0 | 31.79211404 | -94.14550696 | 2022-04-02 04:20:47 | Shelby, Texas, US | |
3239332 | 3239332 | 2022-03-21 | US | Illinois | Johnson | 17087 | 4449 | 40 | 0 | 37.45939802 | -88.88165419 | 2022-03-22 04:20:54 | Johnson, Illinois, US | |
3239173 | 3239173 | 2022-03-21 | US | Georgia | Meriwether | 13199 | 4449 | 140 | 0 | 33.04163534 | -84.68859732 | 2022-03-22 04:20:54 | Meriwether, Georgia, US | |
2142940 | 2142940 | 2022-03-09 | US | Puerto Rico | Naranjito | 72105 | 4449 | 0 | 0 | 18.288019 | -66.252703 | 2022-03-10 04:20:48 | Naranjito, Puerto Rico, US | |
1467293 | 1467293 | 2022-02-10 | US | Texas | Robertson | 48395 | 4449 | 71 | 0 | 31.02539637 | -96.51272246 | 2022-02-11 04:21:09 | Robertson, Texas, US | |
2327736 | 2327736 | 2022-02-04 | US | Alabama | Fayette | 1057 | 4449 | 87 | 0 | 33.72076938 | -87.73886638 | 2022-02-05 04:21:05 | Fayette, Alabama, US | |
1781716 | 1781716 | 2022-01-27 | US | North Carolina | Hertford | 37091 | 4449 | 80 | 0 | 36.3607755 | -76.98104134 | 2022-01-28 04:21:09 | Hertford, North Carolina, US | |
1230974 | 1230974 | 2022-01-24 | US | Virginia | King George | 51099 | 4449 | 27 | 0 | 38.26818502 | -77.15852768 | 2022-01-25 04:21:05 | King George, Virginia, US | |
1702220 | 1702220 | 2022-01-03 | US | Missouri | Audrain | 29007 | 4449 | 87 | 0 | 39.215877 | -91.84242683 | 2022-01-04 04:22:17 | Audrain, Missouri, US | |
3521303 | 3521303 | 2022-01-02 | US | Missouri | Audrain | 29007 | 4449 | 87 | 0 | 39.215877 | -91.84242683 | 2022-01-03 02:22:25 | Audrain, Missouri, US | |
2169433 | 2169433 | 2022-01-01 | US | Missouri | Audrain | 29007 | 4449 | 87 | 0 | 39.215877 | -91.84242683 | 2022-01-02 04:20:52 | Audrain, Missouri, US | |
2778864 | 2778864 | 2021-12-31 | US | Missouri | Audrain | 29007 | 4449 | 87 | 0 | 39.215877 | -91.84242683 | 2022-01-01 04:22:14 | Audrain, Missouri, US | |
4000521 | 4000521 | 2021-12-30 | US | Missouri | Audrain | 29007 | 4449 | 87 | 0 | 39.215877 | -91.84242683 | 2021-12-31 04:21:50 | Audrain, Missouri, US | |
733878 | 733878 | 2021-12-27 | US | Virginia | Halifax | 51083 | 4449 | 121 | 0 | 36.76654925 | -78.93512622 | 2021-12-28 04:21:47 | Halifax, Virginia, US | |
3829405 | 3829405 | 2021-12-21 | US | Idaho | Elmore | 16039 | 4449 | 52 | 0 | 43.3507101 | -115.4701578 | 2021-12-22 04:21:54 | Elmore, Idaho, US | |
1262276 | 1262276 | 2021-12-18 | US | West Virginia | Jackson | 54035 | 4449 | 103 | 0 | 38.84263974 | -81.68148753 | 2021-12-19 04:21:11 | Jackson, West Virginia, US | |
1717297 | 1717297 | 2021-12-16 | US | Idaho | Jerome | 16053 | 4449 | 55 | 0 | 42.68891267 | -114.2655033 | 2021-12-17 04:22:14 | Jerome, Idaho, US | |
784252 | 784252 | 2021-12-13 | US | Mississippi | Wayne | 28153 | 4449 | 72 | 0 | 31.64135687 | -88.69573913 | 2021-12-14 04:22:38 | Wayne, Mississippi, US | |
1271 | 1271 | 2021-12-02 | US | Idaho | Jefferson | 16051 | 4449 | 51 | 0 | 43.82078483 | -112.3131749 | 2021-12-03 04:23:05 | Jefferson, Idaho, US | |
3072231 | 3072231 | 2021-11-23 | US | New Mexico | Luna | 35029 | 4449 | 97 | 0 | 32.18179341 | -107.75088259999998 | 2021-11-24 04:22:14 | Luna, New Mexico, US | |
2288256 | 2288256 | 2021-11-15 | US | Georgia | Emanuel | 13107 | 4449 | 133 | 0 | 32.59221302 | -82.30239915 | 2021-11-16 04:21:10 | Emanuel, Georgia, US | |
89943 | 89943 | 2021-11-09 | US | South Carolina | Edgefield | 45037 | 4449 | 57 | 0 | 33.77221995 | -81.96231108 | 2021-11-10 04:21:38 | Edgefield, South Carolina, US | |
497623 | 497623 | 2021-11-06 | US | Missouri | Stoddard | 29207 | 4449 | 71 | 0 | 36.85571651 | -89.9444155 | 2021-11-07 04:21:53 | Stoddard, Missouri, US | |
567651 | 567651 | 2021-10-29 | US | California | Glenn | 6021 | 4449 | 33 | 0 | 39.59875897 | -122.3938452 | 2021-10-30 04:22:03 | Glenn, California, US | |
536991 | 536991 | 2021-10-27 | US | New York | Orleans | 36073 | 4449 | 90 | 0 | 43.2516977 | -78.2320066 | 2021-10-28 04:22:08 | Orleans, New York, US | |
598258 | 598258 | 2021-10-19 | US | California | Siskiyou | 6093 | 4449 | 42 | 0 | 41.59198861 | -122.54074340000001 | 2021-10-20 04:21:00 | Siskiyou, California, US | |
2046694 | 2046694 | 2021-10-18 | US | South Carolina | Union | 45087 | 4449 | 101 | 0 | 34.68835752 | -81.61730349 | 2021-10-19 04:20:54 | Union, South Carolina, US | |
1495035 | 1495035 | 2021-10-12 | US | Washington | Clallam | 53009 | 4449 | 51 | 0 | 48.04754642 | -123.92263190000001 | 2021-10-13 04:20:51 | Clallam, Washington, US | |
3008863 | 3008863 | 2021-10-11 | US | Louisiana | Sabine | 22085 | 4449 | 85 | 0 | 31.56388699 | -93.55433981 | 2021-10-12 04:21:09 | Sabine, Louisiana, US | |
425488 | 425488 | 2021-10-10 | US | Nevada | Douglas | 32005 | 4449 | 52 | 0 | 38.912862 | -119.61713329999999 | 2021-10-11 04:21:31 | Douglas, Nevada, US | |
2878345 | 2878345 | 2021-10-09 | US | Nevada | Douglas | 32005 | 4449 | 52 | 0 | 38.912862 | -119.61713329999999 | 2021-10-10 04:21:38 | Douglas, Nevada, US | |
2961511 | 2961511 | 2021-10-08 | US | Nevada | Douglas | 32005 | 4449 | 52 | 0 | 38.912862 | -119.61713329999999 | 2021-10-09 04:21:34 | Douglas, Nevada, US | |
2460295 | 2460295 | 2021-10-06 | US | Louisiana | East Feliciana | 22037 | 4449 | 142 | 0 | 30.84425359 | -91.04976723 | 2021-10-07 04:21:36 | East Feliciana, Louisiana, US | |
3833988 | 3833988 | 2021-10-05 | US | Louisiana | East Feliciana | 22037 | 4449 | 140 | 0 | 30.84425359 | -91.04976723 | 2021-10-06 04:21:33 | East Feliciana, Louisiana, US | |
3833291 | 3833291 | 2021-10-05 | US | Georgia | Gilmer | 13123 | 4449 | 124 | 0 | 34.69316688 | -84.45802506 | 2021-10-06 04:21:33 | Gilmer, Georgia, US | |
1334911 | 1334911 | 2021-09-28 | US | Colorado | Logan | 8075 | 4449 | 81 | 0 | 40.7249637 | -103.110817 | 2021-09-29 04:21:45 | Logan, Colorado, US | |
2464473 | 2464473 | 2021-09-14 | US | Michigan | Sanilac | 26151 | 4449 | 127 | 0 | 43.42406072 | -82.82055898 | 2021-09-15 03:22:37 | Sanilac, Michigan, US | |
1387312 | 1387312 | 2021-09-13 | US | Michigan | Sanilac | 26151 | 4449 | 127 | 0 | 43.42406072 | -82.82055898 | 2021-09-14 04:21:41 | Sanilac, Michigan, US | |
3194638 | 3194638 | 2021-09-06 | US | Colorado | Montrose | 8085 | 4449 | 78 | 0 | 38.40214114 | -108.26390220000002 | 2021-09-07 04:21:35 | Montrose, Colorado, US | |
250732 | 250732 | 2021-09-04 | US | Kentucky | Muhlenberg | 21177 | 4449 | 79 | 0 | 37.21425819 | -87.14632053 | 2021-09-05 04:21:33 | Muhlenberg, Kentucky, US | |
652969 | 652969 | 2021-08-09 | US | Tennessee | Weakley | 47183 | 4449 | 69 | 0 | 36.29896232 | -88.71990865 | 2021-08-10 04:21:27 | Weakley, Tennessee, US | |
334925 | 334925 | 2021-08-04 | US | Texas | Bee | 48025 | 4449 | 75 | 0 | 28.41761668 | -97.74215593 | 2021-08-05 04:21:51 | Bee, Texas, US | |
3471421 | 3471421 | 2021-08-03 | US | Texas | Waller | 48473 | 4449 | 52 | 0 | 30.01058447 | -95.99011759 | 2021-08-04 04:21:25 | Waller, Texas, US | |
3221509 | 3221509 | 2021-07-26 | US | Texas | San Patricio | 48409 | 4449 | 153 | 0 | 28.00880118 | -97.51763891 | 2021-07-27 04:21:18 | San Patricio, Texas, 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]);