johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
91 rows where active = 1836 and country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Georgia 10
- Pennsylvania 6
- Minnesota 5
- Ohio 5
- Arkansas 4
- Florida 4
- Nebraska 4
- New York 4
- North Carolina 4
- Idaho 3
- Indiana 3
- Tennessee 3
- Texas 3
- West Virginia 3
- Alabama 2
- California 2
- Hawaii 2
- Iowa 2
- Kentucky 2
- Louisiana 2
- Mississippi 2
- Missouri 2
- Oregon 2
- Rhode Island 2
- South Carolina 2
- Virginia 2
- Maryland 1
- Michigan 1
- New Mexico 1
- Puerto Rico 1
- …
country_or_region 1
- US · 91 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1090584 | 1090584 | 2021-03-03 | US | Arkansas | Polk | 5113 | 1901 | 65 | 0 | 1836 | 34.48254879 | -94.22728802 | 2021-03-04 05:24:24 | Polk, Arkansas, US |
3254968 | 3254968 | 2021-03-02 | US | Georgia | Lamar | 13171 | 1885 | 49 | 0 | 1836 | 33.07841647 | -84.14263877 | 2021-03-03 05:23:28 | Lamar, Georgia, US |
2185163 | 2185163 | 2021-02-26 | US | Maryland | Talbot | 24041 | 1870 | 34 | 0 | 1836 | 38.76618159 | -76.10882561 | 2021-02-27 05:22:28 | Talbot, Maryland, US |
2186737 | 2186737 | 2021-02-26 | US | Texas | Madison | 48313 | 2118 | 24 | 0 | 1836 | 30.96694679 | -95.93003775 | 2021-02-27 05:22:28 | Madison, Texas, US |
1937271 | 1937271 | 2021-02-23 | US | Georgia | Jones | 13169 | 1878 | 42 | 0 | 1836 | 33.02512137 | -83.56019163 | 2021-02-24 05:29:16 | Jones, Georgia, US |
532436 | 532436 | 2021-02-22 | US | Minnesota | Martin | 27091 | 1864 | 28 | 0 | 1836 | 43.67429718 | -94.55099908 | 2021-02-23 05:23:41 | Martin, Minnesota, US |
472188 | 472188 | 2021-02-19 | US | Georgia | Crisp | 13081 | 1894 | 58 | 0 | 1836 | 31.92289565 | -83.76811843 | 2021-02-20 05:22:51 | Crisp, Georgia, US |
3051941 | 3051941 | 2021-02-16 | US | Minnesota | Wabasha | 27157 | 1839 | 3 | 0 | 1836 | 44.28424356 | -92.23121312 | 2021-02-17 05:23:10 | Wabasha, Minnesota, US |
3052495 | 3052495 | 2021-02-16 | US | North Carolina | Hertford | 37091 | 1892 | 56 | 0 | 1836 | 36.3607755 | -76.98104134 | 2021-02-17 05:23:10 | Hertford, North Carolina, US |
1340040 | 1340040 | 2021-02-15 | US | Minnesota | Wabasha | 27157 | 1839 | 3 | 0 | 1836 | 44.28424356 | -92.23121312 | 2021-02-16 05:24:38 | Wabasha, Minnesota, US |
1340741 | 1340741 | 2021-02-15 | US | Ohio | Hocking | 39073 | 1891 | 55 | 0 | 1836 | 39.49537927 | -82.47991446 | 2021-02-16 05:24:38 | Hocking, Ohio, US |
2284883 | 2284883 | 2021-02-14 | US | Kentucky | Rowan | 21205 | 1845 | 9 | 0 | 1836 | 38.19484205 | -83.42088935 | 2021-02-15 05:24:49 | Rowan, Kentucky, US |
614542 | 614542 | 2021-02-08 | US | Georgia | Putnam | 13237 | 1879 | 43 | 0 | 1836 | 33.32056115 | -83.37552891 | 2021-02-09 05:23:30 | Putnam, Georgia, US |
1677272 | 1677272 | 2021-02-01 | US | Georgia | Grady | 13131 | 1882 | 46 | 0 | 1836 | 30.87454847 | -84.23418364 | 2021-02-02 05:22:49 | Grady, Georgia, US |
1677353 | 1677353 | 2021-02-01 | US | Georgia | Union | 13291 | 1892 | 56 | 0 | 1836 | 34.82995757 | -83.98967069 | 2021-02-02 05:22:49 | Union, Georgia, US |
2485434 | 2485434 | 2021-01-28 | US | West Virginia | Brooke | 54009 | 1884 | 48 | 0 | 1836 | 40.27367263 | -80.57915332 | 2021-01-29 05:22:23 | Brooke, West Virginia, US |
3156858 | 3156858 | 2021-01-27 | US | Texas | Young | 48503 | 1855 | 34 | 0 | 1836 | 33.17659707 | -98.68790885 | 2021-01-28 05:22:24 | Young, Texas, US |
436589 | 436589 | 2021-01-21 | US | Iowa | Tama | 19171 | 1895 | 59 | 0 | 1836 | 42.07991767 | -92.53266945 | 2021-01-22 05:22:10 | Tama, Iowa, US |
3517920 | 3517920 | 2021-01-15 | US | Ohio | Wyandot | 39175 | 1885 | 49 | 0 | 1836 | 40.84339621 | -83.30734173 | 2021-01-16 05:22:40 | Wyandot, Ohio, US |
3518903 | 3518903 | 2021-01-15 | US | West Virginia | Randolph | 54083 | 1844 | 8 | 0 | 1836 | 38.769899 | -79.87919615 | 2021-01-16 05:22:40 | Randolph, West Virginia, US |
3880478 | 3880478 | 2021-01-14 | US | Hawaii | Maui | 15009 | 1856 | 20 | 0 | 1836 | 20.86399628 | -156.56890969999995 | 2021-01-15 05:22:24 | Maui, Hawaii, US |
3881012 | 3881012 | 2021-01-14 | US | Kentucky | Mercer | 21167 | 1847 | 11 | 0 | 1836 | 37.81474237 | -84.87488475 | 2021-01-15 05:22:24 | Mercer, Kentucky, US |
3310420 | 3310420 | 2021-01-13 | US | New York | Clinton | 36019 | 1848 | 12 | 0 | 1836 | 44.74530905 | -73.67875352 | 2021-01-14 05:22:32 | Clinton, New York, US |
777124 | 777124 | 2021-01-12 | US | Puerto Rico | Vega Baja | 72145 | 1836 | 0 | 0 | 1836 | 18.428262 | -66.397924 | 2021-01-13 05:22:15 | Vega Baja, Puerto Rico, US |
2867517 | 2867517 | 2021-01-06 | US | South Carolina | Clarendon | 45027 | 1915 | 79 | 0 | 1836 | 33.66610974 | -80.21647898 | 2021-01-07 05:22:03 | Clarendon, South Carolina, US |
1065315 | 1065315 | 2021-01-04 | US | West Virginia | Fayette | 54019 | 1884 | 48 | 0 | 1836 | 38.02974928 | -81.08286634 | 2021-01-05 05:21:49 | Fayette, West Virginia, US |
3230791 | 3230791 | 2021-01-03 | US | Alabama | Bibb | 1007 | 1882 | 46 | 0 | 1836 | 32.99642064 | -87.12511459999997 | 2021-01-04 05:22:02 | Bibb, Alabama, US |
3232390 | 3232390 | 2021-01-03 | US | Missouri | Polk | 29167 | 1857 | 21 | 0 | 1836 | 37.6162296 | -93.39828174 | 2021-01-04 05:22:02 | Polk, Missouri, US |
1011818 | 1011818 | 2020-12-30 | US | Louisiana | Pointe Coupee | 22077 | 1893 | 57 | 0 | 1836 | 30.71409502 | -91.60209535 | 2020-12-31 05:22:49 | Pointe Coupee, Louisiana, US |
1012035 | 1012035 | 2020-12-30 | US | Minnesota | Meeker | 27093 | 1867 | 31 | 0 | 1836 | 45.12328869 | -94.52839455 | 2020-12-31 05:22:49 | Meeker, Minnesota, US |
3762708 | 3762708 | 2020-12-28 | US | Indiana | Scott | 18143 | 1872 | 36 | 0 | 1836 | 38.68672078 | -85.74627859 | 2020-12-29 05:22:37 | Scott, Indiana, US |
3764275 | 3764275 | 2020-12-28 | US | Pennsylvania | Tioga | 42117 | 1886 | 50 | 0 | 1836 | 41.77255149 | -77.25433032 | 2020-12-29 05:22:37 | Tioga, Pennsylvania, US |
2224408 | 2224408 | 2020-12-26 | US | Hawaii | Hawaii | 15001 | 1880 | 44 | 0 | 1836 | 19.60121157 | -155.5210167 | 2020-12-27 05:22:55 | Hawaii, Hawaii, US |
3772902 | 3772902 | 2020-12-22 | US | Texas | Burnet | 48053 | 2126 | 23 | 0 | 1836 | 30.78801353 | -98.181887 | 2020-12-23 05:22:03 | Burnet, Texas, US |
929387 | 929387 | 2020-12-21 | US | Minnesota | Cass | 27021 | 1853 | 17 | 0 | 1836 | 46.95043611 | -94.32603968 | 2020-12-22 05:22:33 | Cass, Minnesota, US |
2934480 | 2934480 | 2020-12-19 | US | Utah | Southeast Utah | 1848 | 12 | 0 | 1836 | 38.99617072 | -110.7013958 | 2020-12-20 05:27:32 | Southeast Utah, Utah, US | |
3152082 | 3152082 | 2020-12-16 | US | Ohio | Ottawa | 39123 | 1883 | 47 | 0 | 1836 | 41.53781826 | -83.0940185 | 2020-12-17 05:28:12 | Ottawa, Ohio, US |
1754134 | 1754134 | 2020-12-14 | US | South Dakota | Hughes | 46065 | 1861 | 25 | 0 | 1836 | 44.39091534 | -99.99661148 | 2020-12-15 05:26:38 | Hughes, South Dakota, US |
3848862 | 3848862 | 2020-12-13 | US | Indiana | Fayette | 18041 | 1880 | 44 | 0 | 1836 | 39.63684962 | -85.17797541 | 2020-12-14 05:26:27 | Fayette, Indiana, US |
3850727 | 3850727 | 2020-12-13 | US | Tennessee | Haywood | 47075 | 1885 | 31 | 0 | 1836 | 35.58332824 | -89.28536625 | 2020-12-14 05:26:27 | Haywood, Tennessee, US |
846087 | 846087 | 2020-12-12 | US | Arkansas | Sevier | 5133 | 1856 | 20 | 0 | 1836 | 33.99780401 | -94.2424869 | 2020-12-13 05:27:20 | Sevier, Arkansas, US |
1821405 | 1821405 | 2020-12-08 | US | Oregon | Linn | 41043 | 1862 | 26 | 0 | 1836 | 44.48899494 | -122.5373154 | 2020-12-09 05:28:01 | Linn, Oregon, US |
1632702 | 1632702 | 2020-12-05 | US | Alabama | Tallapoosa | 1123 | 1928 | 92 | 0 | 1836 | 32.86698258 | -85.79833053 | 2020-12-06 05:26:18 | Tallapoosa, Alabama, US |
1634143 | 1634143 | 2020-12-05 | US | Mississippi | Tate | 28137 | 1887 | 51 | 0 | 1836 | 34.65133709 | -89.94485778 | 2020-12-06 05:26:18 | Tate, Mississippi, US |
3861678 | 3861678 | 2020-12-04 | US | Mississippi | Warren | 28149 | 1895 | 59 | 0 | 1836 | 32.35810271 | -90.83352619 | 2020-12-05 05:27:36 | Warren, Mississippi, US |
3862463 | 3862463 | 2020-12-04 | US | Oregon | Yamhill | 41071 | 1853 | 17 | 0 | 1836 | 45.23330449 | -123.3086963 | 2020-12-05 05:27:36 | Yamhill, Oregon, US |
3862768 | 3862768 | 2020-12-04 | US | Tennessee | Hardin | 47071 | 1868 | 29 | 0 | 1836 | 35.19732531 | -88.18593755 | 2020-12-05 05:27:36 | Hardin, Tennessee, US |
77339 | 77339 | 2020-12-03 | US | New York | Rensselaer | 36083 | 1891 | 55 | 0 | 1836 | 42.71348136 | -73.51089874 | 2020-12-04 05:27:27 | Rensselaer, New York, US |
740977 | 740977 | 2020-12-02 | US | Pennsylvania | Mifflin | 42087 | 1877 | 41 | 0 | 1836 | 40.61116939 | -77.61070738 | 2020-12-03 05:28:22 | Mifflin, Pennsylvania, US |
925872 | 925872 | 2020-11-26 | US | New Mexico | Luna | 35029 | 1861 | 25 | 0 | 1836 | 32.18179341 | -107.75088259999998 | 2020-11-27 05:26:53 | Luna, New Mexico, US |
3340676 | 3340676 | 2020-11-17 | US | Nebraska | Lincoln | 31111 | 1848 | 12 | 0 | 1836 | 41.04658298 | -100.7475374 | 2020-11-18 05:40:31 | Lincoln, Nebraska, US |
1731443 | 1731443 | 2020-11-08 | US | Tennessee | McMinn | 47107 | 1929 | 44 | 0 | 1836 | 35.42812616 | -84.61520715 | 2020-11-09 05:25:45 | McMinn, Tennessee, US |
376660 | 376660 | 2020-11-06 | US | Arkansas | Greene | 5055 | 1858 | 22 | 0 | 1836 | 36.11735460000001 | -90.55832668 | 2020-11-07 05:24:52 | Greene, Arkansas, US |
1054393 | 1054393 | 2020-10-23 | US | California | Shasta | 6089 | 1865 | 29 | 0 | 1836 | 40.76391419 | -122.0396884 | 2020-10-24 04:24:46 | Shasta, California, US |
1056111 | 1056111 | 2020-10-23 | US | North Carolina | Chatham | 37037 | 1896 | 60 | 0 | 1836 | 35.70394416 | -79.25541492 | 2020-10-24 04:24:46 | Chatham, North Carolina, US |
2193252 | 2193252 | 2020-10-21 | US | Michigan | Monroe | 26115 | 1867 | 31 | 0 | 1836 | 41.92734151 | -83.53749864 | 2020-10-22 04:24:27 | Monroe, Michigan, US |
2857780 | 2857780 | 2020-10-16 | US | Idaho | Madison | 16065 | 1838 | 2 | 0 | 1836 | 43.78141028 | -111.65384740000002 | 2020-10-17 04:24:12 | Madison, Idaho, US |
2516801 | 2516801 | 2020-10-03 | US | Pennsylvania | Beaver | 42007 | 1963 | 127 | 0 | 1836 | 40.6825484 | -80.34921611 | 2020-10-04 04:23:44 | Beaver, Pennsylvania, US |
2608492 | 2608492 | 2020-09-24 | US | Ohio | Licking | 39089 | 1898 | 62 | 0 | 1836 | 40.09136236 | -82.48185785 | 2020-09-25 04:23:00 | Licking, Ohio, US |
3319615 | 3319615 | 2020-09-22 | US | Virginia | Suffolk | 51800 | 1908 | 72 | 0 | 1836 | 36.70155394 | -76.63603554 | 2020-09-23 04:23:00 | Suffolk, Virginia, US |
2839149 | 2839149 | 2020-09-21 | US | North Carolina | Onslow | 37133 | 1859 | 23 | 0 | 1836 | 34.72607366 | -77.42908179 | 2020-09-22 04:23:00 | Onslow, North Carolina, US |
2839253 | 2839253 | 2020-09-21 | US | Ohio | Columbiana | 39029 | 1920 | 84 | 0 | 1836 | 40.76932373 | -80.78094576 | 2020-09-22 04:23:00 | Columbiana, Ohio, US |
2457410 | 2457410 | 2020-09-19 | US | Pennsylvania | Centre | 42027 | 1847 | 11 | 0 | 1836 | 40.92058903 | -77.82200624 | 2020-09-20 04:22:00 | Centre, Pennsylvania, US |
1122317 | 1122317 | 2020-09-17 | US | Florida | Walton | 12131 | 1858 | 22 | 0 | 1836 | 30.64204028 | -86.16935664 | 2020-09-18 05:05:00 | Walton, Florida, US |
2869654 | 2869654 | 2020-09-13 | US | Idaho | Twin Falls | 16083 | 1871 | 35 | 0 | 1836 | 42.35440512 | -114.6685381 | 2020-09-14 04:26:00 | Twin Falls, Idaho, US |
547517 | 547517 | 2020-09-12 | US | Georgia | Colquitt | 13071 | 1868 | 32 | 0 | 1836 | 31.18810588 | -83.7677946 | 2020-09-13 04:30:52 | Colquitt, Georgia, US |
547693 | 547693 | 2020-09-12 | US | Idaho | Twin Falls | 16083 | 1871 | 35 | 0 | 1836 | 42.35440512 | -114.6685381 | 2020-09-13 04:30:52 | Twin Falls, Idaho, US |
2172263 | 2172263 | 2020-09-09 | US | Florida | Putnam | 12107 | 1874 | 38 | 0 | 1836 | 29.60779729 | -81.74230285 | 2020-09-10 04:29:01 | Putnam, Florida, US |
2172311 | 2172311 | 2020-09-09 | US | Georgia | Coffee | 13069 | 1876 | 40 | 0 | 1836 | 31.54892966 | -82.85492059999999 | 2020-09-10 04:29:01 | Coffee, Georgia, US |
2173506 | 2173506 | 2020-09-09 | US | Missouri | Unassigned | 90029 | 1836 | 0 | 0 | 1836 | 40.47945588 | 0.0 | 2020-09-10 04:29:01 | Unassigned, Missouri, US |
1244520 | 1244520 | 2020-09-08 | US | Georgia | Coffee | 13069 | 1874 | 38 | 0 | 1836 | 31.54892966 | -82.85492059999999 | 2020-09-09 04:28:48 | Coffee, Georgia, US |
815638 | 815638 | 2020-09-05 | US | Nebraska | Hall | 31079 | 1882 | 46 | 0 | 1836 | 40.87257079 | -98.50218293 | 2020-09-06 04:28:33 | Hall, Nebraska, US |
1357007 | 1357007 | 2020-09-03 | US | Pennsylvania | Westmoreland | 42129 | 1885 | 49 | 0 | 1836 | 40.31377979999999 | -79.46615476 | 2020-09-04 04:28:26 | Westmoreland, Pennsylvania, US |
3932487 | 3932487 | 2020-08-30 | US | Arkansas | Craighead | 5031 | 1851 | 15 | 0 | 1836 | 35.83018283 | -90.63235729 | 2020-08-31 04:28:27 | Craighead, Arkansas, US |
1525958 | 1525958 | 2020-08-28 | US | Rhode Island | Unassigned | 90044 | 1874 | 38 | 0 | 1836 | 41.87064746 | 0.0 | 2020-08-29 04:28:19 | Unassigned, Rhode Island, US |
3484974 | 3484974 | 2020-08-20 | US | Florida | Citrus | 12017 | 1882 | 46 | 0 | 1836 | 28.84804315 | -82.47614748 | 2020-08-21 04:27:41 | Citrus, Florida, US |
665695 | 665695 | 2020-08-11 | US | Virginia | Newport News | 51700 | 1855 | 19 | 0 | 1836 | 37.08166899 | -76.51754109 | 2020-08-12 04:27:29 | Newport News, Virginia, US |
1919210 | 1919210 | 2020-08-10 | US | South Carolina | Pickens | 45077 | 1863 | 27 | 0 | 1836 | 34.88807695 | -82.72791551 | 2020-08-11 04:35:08 | Pickens, South Carolina, US |
176633 | 176633 | 2020-07-27 | US | New York | Ulster | 36111 | 1926 | 90 | 0 | 1836 | 41.89027881 | -74.26252104 | 2020-07-28 04:58:43 | Ulster, New York, US |
1704759 | 1704759 | 2020-07-21 | US | Nebraska | Dakota | 31043 | 1873 | 37 | 0 | 1836 | 42.39040144 | -96.56656425 | 2020-07-22 04:34:42 | Dakota, Nebraska, US |
324320 | 324320 | 2020-07-20 | US | Nebraska | Dakota | 31043 | 1873 | 37 | 0 | 1836 | 42.39040144 | -96.56656425 | 2020-07-21 04:38:46 | Dakota, Nebraska, US |
120009 | 120009 | 2020-07-19 | US | Louisiana | Lafourche | 22057 | 1928 | 92 | 0 | 1836 | 29.52470226 | -90.40976986 | 2020-07-20 05:34:40 | Lafourche, Louisiana, US |
120591 | 120591 | 2020-07-19 | US | New York | Oneida | 36065 | 1940 | 104 | 0 | 1836 | 43.24375382 | -75.43710392 | 2020-07-20 05:34:40 | Oneida, New York, US |
412780 | 412780 | 2020-07-05 | US | Georgia | Dougherty | 13095 | 1991 | 155 | 0 | 1836 | 31.53328528 | -84.21722377 | 2020-07-06 04:33:57 | Dougherty, Georgia, US |
529157 | 529157 | 2020-07-04 | US | Indiana | St. Joseph | 18141 | 1908 | 72 | 0 | 1836 | 41.61756781 | -86.29040834 | 2020-07-05 04:33:46 | St. Joseph, Indiana, US |
2234200 | 2234200 | 2020-07-03 | US | North Carolina | Wayne | 37191 | 1864 | 28 | 0 | 1836 | 35.36438125 | -78.00027268 | 2020-07-04 04:33:51 | Wayne, North Carolina, US |
3246233 | 3246233 | 2020-06-21 | US | Iowa | Black Hawk | 19013 | 1892 | 56 | 0 | 1836 | 42.4704581 | -92.30524729 | 2020-06-22 04:33:20 | Black Hawk, Iowa, US |
1691030 | 1691030 | 2020-06-19 | US | California | Ventura | 6111 | 1879 | 37 | 0 | 1836 | 34.44465746 | -119.09106129999999 | 2020-06-20 04:33:19 | Ventura, California, US |
736983 | 736983 | 2020-06-12 | US | Rhode Island | Unassigned | 90044 | 1870 | 34 | 0 | 1836 | 41.87064746 | 0.0 | 2020-06-13 03:33:14 | Unassigned, Rhode Island, US |
1270990 | 1270990 | 2020-06-11 | US | Florida | Duval | 12031 | 1893 | 57 | 0 | 1836 | 30.33225875 | -81.66976468 | 2020-06-12 05:09:52 | Duval, Florida, US |
1382380 | 1382380 | 2020-04-19 | US | Pennsylvania | Berks | 42011 | 1901 | 65 | 0 | 1836 | 40.41570541 | -75.92457766 | 2020-04-19 23:41:01 | Berks, Pennsylvania, 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]);