ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
151 rows where cases = 3821 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Florida 17
- Texas 17
- Illinois 15
- Louisiana 9
- Virginia 8
- Indiana 7
- Iowa 7
- North Carolina 7
- California 6
- Kentucky 6
- Minnesota 5
- Georgia 4
- Michigan 4
- Ohio 4
- Tennessee 4
- Wisconsin 4
- Alabama 3
- Colorado 3
- Mississippi 3
- Missouri 3
- Pennsylvania 3
- Arkansas 2
- New Jersey 2
- Puerto Rico 2
- West Virginia 2
- Massachusetts 1
- Nevada 1
- New York 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498950 | 2498950 | 2022-05-12 | Andrews | Texas | 48003 | 3821 | 72 |
2495692 | 2495692 | 2022-05-11 | Andrews | Texas | 48003 | 3821 | 72 |
2492434 | 2492434 | 2022-05-10 | Andrews | Texas | 48003 | 3821 | 72 |
2489176 | 2489176 | 2022-05-09 | Andrews | Texas | 48003 | 3821 | 72 |
2485919 | 2485919 | 2022-05-08 | Andrews | Texas | 48003 | 3821 | 72 |
2482661 | 2482661 | 2022-05-07 | Andrews | Texas | 48003 | 3821 | 72 |
2479403 | 2479403 | 2022-05-06 | Andrews | Texas | 48003 | 3821 | 72 |
2476145 | 2476145 | 2022-05-05 | Andrews | Texas | 48003 | 3821 | 72 |
2444151 | 2444151 | 2022-04-25 | Marquette | Wisconsin | 55077 | 3821 | 61 |
2337149 | 2337149 | 2022-03-24 | Hamilton | Florida | 12047 | 3821 | 54 |
2333895 | 2333895 | 2022-03-23 | Hamilton | Florida | 12047 | 3821 | 54 |
2330641 | 2330641 | 2022-03-22 | Hamilton | Florida | 12047 | 3821 | 54 |
2333243 | 2333243 | 2022-03-22 | Buckingham | Virginia | 51029 | 3821 | 56 |
2327389 | 2327389 | 2022-03-21 | Hamilton | Florida | 12047 | 3821 | 54 |
2329990 | 2329990 | 2022-03-21 | Buckingham | Virginia | 51029 | 3821 | 56 |
2324136 | 2324136 | 2022-03-20 | Hamilton | Florida | 12047 | 3821 | 54 |
2320882 | 2320882 | 2022-03-19 | Hamilton | Florida | 12047 | 3821 | 54 |
2317628 | 2317628 | 2022-03-18 | Hamilton | Florida | 12047 | 3821 | 54 |
2314375 | 2314375 | 2022-03-17 | Hamilton | Florida | 12047 | 3821 | 54 |
2311122 | 2311122 | 2022-03-16 | Hamilton | Florida | 12047 | 3821 | 54 |
2307869 | 2307869 | 2022-03-15 | Hamilton | Florida | 12047 | 3821 | 53 |
2304618 | 2304618 | 2022-03-14 | Hamilton | Florida | 12047 | 3821 | 53 |
2301366 | 2301366 | 2022-03-13 | Hamilton | Florida | 12047 | 3821 | 53 |
2298114 | 2298114 | 2022-03-12 | Hamilton | Florida | 12047 | 3821 | 53 |
2294862 | 2294862 | 2022-03-11 | Hamilton | Florida | 12047 | 3821 | 53 |
2292880 | 2292880 | 2022-03-10 | Wright | Missouri | 29229 | 3821 | 79 |
2289628 | 2289628 | 2022-03-09 | Wright | Missouri | 29229 | 3821 | 79 |
2289994 | 2289994 | 2022-03-09 | Polk | North Carolina | 37149 | 3821 | 53 |
2256609 | 2256609 | 2022-02-27 | Washington | Kentucky | 21229 | 3821 | 55 |
2253358 | 2253358 | 2022-02-26 | Washington | Kentucky | 21229 | 3821 | 55 |
2250107 | 2250107 | 2022-02-25 | Washington | Kentucky | 21229 | 3821 | 55 |
2237378 | 2237378 | 2022-02-21 | Redwood | Minnesota | 27127 | 3821 | 52 |
2234127 | 2234127 | 2022-02-20 | Redwood | Minnesota | 27127 | 3821 | 52 |
2230876 | 2230876 | 2022-02-19 | Redwood | Minnesota | 27127 | 3821 | 52 |
2227625 | 2227625 | 2022-02-18 | Redwood | Minnesota | 27127 | 3821 | 52 |
2210639 | 2210639 | 2022-02-13 | Mason | Illinois | 17125 | 3821 | 60 |
2207386 | 2207386 | 2022-02-12 | Mason | Illinois | 17125 | 3821 | 60 |
2204133 | 2204133 | 2022-02-11 | Mason | Illinois | 17125 | 3821 | 60 |
2200880 | 2200880 | 2022-02-10 | Mason | Illinois | 17125 | 3821 | 60 |
2196171 | 2196171 | 2022-02-08 | Saluda | South Carolina | 45081 | 3821 | 67 |
2171759 | 2171759 | 2022-02-01 | Clay | Iowa | 19041 | 3821 | 40 |
2168506 | 2168506 | 2022-01-31 | Clay | Iowa | 19041 | 3821 | 40 |
2165251 | 2165251 | 2022-01-30 | Clay | Iowa | 19041 | 3821 | 40 |
2161996 | 2161996 | 2022-01-29 | Clay | Iowa | 19041 | 3821 | 40 |
2164329 | 2164329 | 2022-01-29 | Taylor | West Virginia | 54091 | 3821 | 59 |
2158741 | 2158741 | 2022-01-28 | Clay | Iowa | 19041 | 3821 | 40 |
2155487 | 2155487 | 2022-01-27 | Clay | Iowa | 19041 | 3821 | 40 |
2152234 | 2152234 | 2022-01-26 | Clay | Iowa | 19041 | 3821 | 40 |
2118318 | 2118318 | 2022-01-15 | Deaf Smith | Texas | 48117 | 3821 | 101 |
2082662 | 2082662 | 2022-01-04 | Moore | Texas | 48341 | 3821 | 94 |
2054514 | 2054514 | 2021-12-27 | Lawrence | Illinois | 17101 | 3821 | 47 |
2028641 | 2028641 | 2021-12-19 | Starke | Indiana | 18149 | 3821 | 79 |
2025390 | 2025390 | 2021-12-18 | Starke | Indiana | 18149 | 3821 | 79 |
2022139 | 2022139 | 2021-12-17 | Starke | Indiana | 18149 | 3821 | 79 |
1997427 | 1997427 | 2021-12-09 | Carroll | Ohio | 39019 | 3821 | 78 |
1994895 | 1994895 | 2021-12-08 | Milam | Texas | 48331 | 3821 | 91 |
1985391 | 1985391 | 2021-12-05 | Salem city | Virginia | 51775 | 3821 | 69 |
1982141 | 1982141 | 2021-12-04 | Salem city | Virginia | 51775 | 3821 | 69 |
1978891 | 1978891 | 2021-12-03 | Salem city | Virginia | 51775 | 3821 | 69 |
1972534 | 1972534 | 2021-12-01 | Jackson | Wisconsin | 55053 | 3821 | 34 |
1959794 | 1959794 | 2021-11-28 | Del Norte | California | 6015 | 3821 | 42 |
1956543 | 1956543 | 2021-11-27 | Del Norte | California | 6015 | 3821 | 42 |
1953292 | 1953292 | 2021-11-26 | Del Norte | California | 6015 | 3821 | 42 |
1950041 | 1950041 | 2021-11-25 | Del Norte | California | 6015 | 3821 | 42 |
1946790 | 1946790 | 2021-11-24 | Del Norte | California | 6015 | 3821 | 42 |
1918403 | 1918403 | 2021-11-15 | Johnson | Kentucky | 21115 | 3821 | 50 |
1878809 | 1878809 | 2021-11-03 | Haralson | Georgia | 13143 | 3821 | 120 |
1875560 | 1875560 | 2021-11-02 | Haralson | Georgia | 13143 | 3821 | 119 |
1876102 | 1876102 | 2021-11-02 | Allen | Kentucky | 21003 | 3821 | 70 |
1869744 | 1869744 | 2021-10-31 | Grant | Louisiana | 22043 | 3821 | 77 |
1866495 | 1866495 | 2021-10-30 | Grant | Louisiana | 22043 | 3821 | 77 |
1863246 | 1863246 | 2021-10-29 | Grant | Louisiana | 22043 | 3821 | 77 |
1829786 | 1829786 | 2021-10-19 | Sevier | Arkansas | 5133 | 3821 | 50 |
1823010 | 1823010 | 2021-10-16 | Upshur | West Virginia | 54097 | 3821 | 58 |
1768325 | 1768325 | 2021-09-30 | Franklin | Georgia | 13119 | 3821 | 73 |
1756485 | 1756485 | 2021-09-26 | Stone | Missouri | 29209 | 3821 | 78 |
1750766 | 1750766 | 2021-09-24 | Mayaguez | Puerto Rico | 72097 | 3821 | |
1712650 | 1712650 | 2021-09-13 | Bibb | Alabama | 1007 | 3821 | 75 |
1708445 | 1708445 | 2021-09-11 | Greene | Pennsylvania | 42059 | 3821 | 44 |
1701755 | 1701755 | 2021-09-09 | Jackson | Ohio | 39079 | 3821 | 58 |
1678677 | 1678677 | 2021-09-02 | Douglas | Nevada | 32005 | 3821 | 42 |
1648452 | 1648452 | 2021-08-24 | Ripley | Indiana | 18137 | 3821 | 72 |
1645912 | 1645912 | 2021-08-23 | Sunflower | Mississippi | 28133 | 3821 | 98 |
1645927 | 1645927 | 2021-08-23 | Yazoo | Mississippi | 28163 | 3821 | 82 |
1643766 | 1643766 | 2021-08-22 | Marion | Tennessee | 47115 | 3821 | 51 |
1640516 | 1640516 | 2021-08-21 | Marion | Tennessee | 47115 | 3821 | 51 |
1637266 | 1637266 | 2021-08-20 | Marion | Tennessee | 47115 | 3821 | 51 |
1598977 | 1598977 | 2021-08-09 | Dallas | Alabama | 1047 | 3821 | 164 |
1600092 | 1600092 | 2021-08-09 | East Feliciana | Louisiana | 22037 | 3821 | 122 |
1584662 | 1584662 | 2021-08-04 | Jackson | North Carolina | 37099 | 3821 | 56 |
1528165 | 1528165 | 2021-07-18 | Montgomery | Illinois | 17135 | 3821 | 80 |
1524918 | 1524918 | 2021-07-17 | Montgomery | Illinois | 17135 | 3821 | 80 |
1521670 | 1521670 | 2021-07-16 | Montgomery | Illinois | 17135 | 3821 | 80 |
1511666 | 1511666 | 2021-07-13 | Bryan | Georgia | 13029 | 3821 | 41 |
1500991 | 1500991 | 2021-07-09 | Grimes | Texas | 48185 | 3821 | 74 |
1487362 | 1487362 | 2021-07-05 | Clinton | Ohio | 39027 | 3821 | 66 |
1475018 | 1475018 | 2021-07-01 | Grimes | Texas | 48185 | 3821 | 74 |
1449536 | 1449536 | 2021-06-23 | Oneida | Wisconsin | 55085 | 3821 | 78 |
1415051 | 1415051 | 2021-06-13 | St. John the Baptist | Louisiana | 22095 | 3821 | 141 |
1411806 | 1411806 | 2021-06-12 | St. John the Baptist | Louisiana | 22095 | 3821 | 141 |
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);