ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
208 rows where cases = 2615 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 21
- Virginia 20
- Kentucky 15
- Wisconsin 15
- North Carolina 12
- Georgia 11
- Arkansas 10
- Mississippi 9
- Illinois 8
- Alabama 7
- Kansas 7
- Missouri 7
- South Carolina 7
- Minnesota 6
- New York 6
- California 5
- New Mexico 5
- Tennessee 5
- Iowa 4
- West Virginia 4
- Wyoming 4
- Florida 3
- Indiana 3
- North Dakota 3
- Nebraska 2
- Oklahoma 2
- Colorado 1
- Idaho 1
- Louisiana 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444250 | 2444250 | 2022-04-26 | Lowndes | Alabama | 1085 | 2615 | 76 |
2440994 | 2440994 | 2022-04-25 | Lowndes | Alabama | 1085 | 2615 | 76 |
2417864 | 2417864 | 2022-04-17 | Clarke | Virginia | 51043 | 2615 | 42 |
2414608 | 2414608 | 2022-04-16 | Clarke | Virginia | 51043 | 2615 | 42 |
2408557 | 2408557 | 2022-04-15 | Pike | Arkansas | 5109 | 2615 | 44 |
2411352 | 2411352 | 2022-04-15 | Clarke | Virginia | 51043 | 2615 | 42 |
2402046 | 2402046 | 2022-04-13 | Pike | Arkansas | 5109 | 2615 | 44 |
2404840 | 2404840 | 2022-04-13 | Clarke | Virginia | 51043 | 2615 | 42 |
2398791 | 2398791 | 2022-04-12 | Pike | Arkansas | 5109 | 2615 | 44 |
2395536 | 2395536 | 2022-04-11 | Pike | Arkansas | 5109 | 2615 | 44 |
2398125 | 2398125 | 2022-04-11 | Jim Hogg | Texas | 48247 | 2615 | 22 |
2394870 | 2394870 | 2022-04-10 | Jim Hogg | Texas | 48247 | 2615 | 22 |
2391614 | 2391614 | 2022-04-09 | Jim Hogg | Texas | 48247 | 2615 | 22 |
2385286 | 2385286 | 2022-04-07 | Amelia | Virginia | 51007 | 2615 | 61 |
2382031 | 2382031 | 2022-04-06 | Amelia | Virginia | 51007 | 2615 | 61 |
2376005 | 2376005 | 2022-04-05 | Pike | Arkansas | 5109 | 2615 | 44 |
2372753 | 2372753 | 2022-04-04 | Pike | Arkansas | 5109 | 2615 | 44 |
2375438 | 2375438 | 2022-04-04 | Terry | Texas | 48445 | 2615 | 84 |
2369500 | 2369500 | 2022-04-03 | Pike | Arkansas | 5109 | 2615 | 44 |
2372186 | 2372186 | 2022-04-03 | Terry | Texas | 48445 | 2615 | 84 |
2366247 | 2366247 | 2022-04-02 | Pike | Arkansas | 5109 | 2615 | 43 |
2368933 | 2368933 | 2022-04-02 | Terry | Texas | 48445 | 2615 | 84 |
2362994 | 2362994 | 2022-04-01 | Pike | Arkansas | 5109 | 2615 | 43 |
2359870 | 2359870 | 2022-03-31 | Prowers | Colorado | 8099 | 2615 | 48 |
2289941 | 2289941 | 2022-03-09 | Clay | North Carolina | 37043 | 2615 | 39 |
2286689 | 2286689 | 2022-03-08 | Clay | North Carolina | 37043 | 2615 | 39 |
2281291 | 2281291 | 2022-03-06 | Richmond | Virginia | 51159 | 2615 | 25 |
2278038 | 2278038 | 2022-03-05 | Richmond | Virginia | 51159 | 2615 | 25 |
2274785 | 2274785 | 2022-03-04 | Richmond | Virginia | 51159 | 2615 | 25 |
2218300 | 2218300 | 2022-02-15 | Colfax | New Mexico | 35007 | 2615 | 64 |
2219492 | 2219492 | 2022-02-15 | Nelson | Virginia | 51125 | 2615 | 26 |
2200143 | 2200143 | 2022-02-09 | Forest | Wisconsin | 55041 | 2615 | 47 |
2174676 | 2174676 | 2022-02-02 | Long | Georgia | 13183 | 2615 | 29 |
2164046 | 2164046 | 2022-01-29 | Ward | Texas | 48475 | 2615 | 39 |
2146920 | 2146920 | 2022-01-24 | Barnes | North Dakota | 38003 | 2615 | 41 |
2143666 | 2143666 | 2022-01-23 | Barnes | North Dakota | 38003 | 2615 | 41 |
2144352 | 2144352 | 2022-01-23 | Eastland | Texas | 48133 | 2615 | 95 |
2079384 | 2079384 | 2022-01-03 | Leon | Texas | 48289 | 2615 | 75 |
2051629 | 2051629 | 2021-12-26 | Butler | Kentucky | 21031 | 2615 | 43 |
2048379 | 2048379 | 2021-12-25 | Butler | Kentucky | 21031 | 2615 | 43 |
2045129 | 2045129 | 2021-12-24 | Butler | Kentucky | 21031 | 2615 | 43 |
2041880 | 2041880 | 2021-12-23 | Butler | Kentucky | 21031 | 2615 | 43 |
2038630 | 2038630 | 2021-12-22 | Butler | Kentucky | 21031 | 2615 | 43 |
2023393 | 2023393 | 2021-12-17 | McKenzie | North Dakota | 38053 | 2615 | 23 |
2019154 | 2019154 | 2021-12-16 | Green | Kentucky | 21087 | 2615 | 38 |
2015904 | 2015904 | 2021-12-15 | Green | Kentucky | 21087 | 2615 | 38 |
2013372 | 2013372 | 2021-12-14 | York | Nebraska | 31185 | 2615 | 19 |
1994562 | 1994562 | 2021-12-08 | Saluda | South Carolina | 45081 | 2615 | 57 |
1991311 | 1991311 | 2021-12-07 | Saluda | South Carolina | 45081 | 2615 | 56 |
1988060 | 1988060 | 2021-12-06 | Saluda | South Carolina | 45081 | 2615 | 56 |
1972623 | 1972623 | 2021-12-02 | Crenshaw | Alabama | 1041 | 2615 | 77 |
1968773 | 1968773 | 2021-11-30 | Colorado | Texas | 48089 | 2615 | 55 |
1966046 | 1966046 | 2021-11-29 | Marquette | Wisconsin | 55077 | 2615 | 37 |
1951737 | 1951737 | 2021-11-25 | Schoharie | New York | 36095 | 2615 | 24 |
1905415 | 1905415 | 2021-11-11 | Lewis | Kentucky | 21135 | 2615 | 58 |
1906316 | 1906316 | 2021-11-11 | Northampton | North Carolina | 37131 | 2615 | 66 |
1902165 | 1902165 | 2021-11-10 | Lewis | Kentucky | 21135 | 2615 | 58 |
1903067 | 1903067 | 2021-11-10 | Northampton | North Carolina | 37131 | 2615 | 66 |
1894301 | 1894301 | 2021-11-07 | Colonial Heights city | Virginia | 51570 | 2615 | 66 |
1891051 | 1891051 | 2021-11-06 | Colonial Heights city | Virginia | 51570 | 2615 | 66 |
1887801 | 1887801 | 2021-11-05 | Colonial Heights city | Virginia | 51570 | 2615 | 66 |
1876604 | 1876604 | 2021-11-02 | Benton | Missouri | 29015 | 2615 | 45 |
1878115 | 1878115 | 2021-11-02 | Nottoway | Virginia | 51135 | 2615 | 67 |
1874866 | 1874866 | 2021-11-01 | Nottoway | Virginia | 51135 | 2615 | 67 |
1869564 | 1869564 | 2021-10-31 | Neosho | Kansas | 20133 | 2615 | 51 |
1866315 | 1866315 | 2021-10-30 | Neosho | Kansas | 20133 | 2615 | 51 |
1863066 | 1863066 | 2021-10-29 | Neosho | Kansas | 20133 | 2615 | 51 |
1850677 | 1850677 | 2021-10-25 | Morgan | Missouri | 29141 | 2615 | 58 |
1852076 | 1852076 | 2021-10-25 | Fluvanna | Virginia | 51065 | 2615 | 23 |
1848554 | 1848554 | 2021-10-24 | Falls | Texas | 48145 | 2615 | 45 |
1845304 | 1845304 | 2021-10-23 | Falls | Texas | 48145 | 2615 | 45 |
1804345 | 1804345 | 2021-10-11 | Franklin | Indiana | 18047 | 2615 | 45 |
1805454 | 1805454 | 2021-10-11 | Roosevelt | New Mexico | 35041 | 2615 | 68 |
1802205 | 1802205 | 2021-10-10 | Roosevelt | New Mexico | 35041 | 2615 | 68 |
1798956 | 1798956 | 2021-10-09 | Roosevelt | New Mexico | 35041 | 2615 | 68 |
1795707 | 1795707 | 2021-10-08 | Roosevelt | New Mexico | 35041 | 2615 | 68 |
1793799 | 1793799 | 2021-10-07 | Iowa | Wisconsin | 55049 | 2615 | 16 |
1758586 | 1758586 | 2021-09-27 | Greene | Georgia | 13133 | 2615 | 68 |
1745531 | 1745531 | 2021-09-23 | Banks | Georgia | 13011 | 2615 | 52 |
1732837 | 1732837 | 2021-09-19 | White | Illinois | 17193 | 2615 | 40 |
1729587 | 1729587 | 2021-09-18 | White | Illinois | 17193 | 2615 | 40 |
1726337 | 1726337 | 2021-09-17 | White | Illinois | 17193 | 2615 | 40 |
1694265 | 1694265 | 2021-09-07 | Simpson | Kentucky | 21213 | 2615 | 46 |
1675239 | 1675239 | 2021-09-01 | Perry | Missouri | 29157 | 2615 | 32 |
1670964 | 1670964 | 2021-08-31 | Worth | Georgia | 13321 | 2615 | 72 |
1648783 | 1648783 | 2021-08-24 | Rowan | Kentucky | 21205 | 2615 | 22 |
1629723 | 1629723 | 2021-08-18 | Henry | Missouri | 29083 | 2615 | 41 |
1630312 | 1630312 | 2021-08-18 | Pike | Ohio | 39131 | 2615 | 37 |
1624937 | 1624937 | 2021-08-16 | Uinta | Wyoming | 56041 | 2615 | 14 |
1611464 | 1611464 | 2021-08-12 | Lamb | Texas | 48279 | 2615 | 83 |
1605906 | 1605906 | 2021-08-11 | Grady | Georgia | 13131 | 2615 | 66 |
1605955 | 1605955 | 2021-08-11 | Pike | Georgia | 13231 | 2615 | 44 |
1607313 | 1607313 | 2021-08-11 | Franklin | New York | 36033 | 2615 | 12 |
1599644 | 1599644 | 2021-08-09 | Union | Illinois | 17181 | 2615 | 46 |
1582384 | 1582384 | 2021-08-03 | St. Thomas | Virgin Islands | 78030 | 2615 | 22 |
1564682 | 1564682 | 2021-07-29 | Newton | Mississippi | 28101 | 2615 | 64 |
1515128 | 1515128 | 2021-07-14 | Douglas | Illinois | 17041 | 2615 | 42 |
1504799 | 1504799 | 2021-07-11 | Geneva | Alabama | 1061 | 2615 | 81 |
1501553 | 1501553 | 2021-07-10 | Geneva | Alabama | 1061 | 2615 | 81 |
1484462 | 1484462 | 2021-07-04 | Barnwell | South Carolina | 45011 | 2615 | 58 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);