ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
176 rows where cases = 2750 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 16
- Kansas 14
- Illinois 11
- Georgia 9
- Indiana 9
- Oklahoma 9
- Iowa 8
- Louisiana 8
- Virginia 8
- Minnesota 7
- South Carolina 7
- South Dakota 7
- Arkansas 6
- Mississippi 6
- North Carolina 6
- Pennsylvania 4
- Colorado 3
- Florida 3
- Michigan 3
- Missouri 3
- Puerto Rico 3
- Arizona 2
- California 2
- Idaho 2
- Nevada 2
- New Jersey 2
- New York 2
- Ohio 2
- West Virginia 2
- Wisconsin 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2401103 | 2401103 | 2022-04-12 | Butte | South Dakota | 46019 | 2750 | 44 |
2397848 | 2397848 | 2022-04-11 | Butte | South Dakota | 46019 | 2750 | 44 |
2394593 | 2394593 | 2022-04-10 | Butte | South Dakota | 46019 | 2750 | 44 |
2391337 | 2391337 | 2022-04-09 | Butte | South Dakota | 46019 | 2750 | 44 |
2388081 | 2388081 | 2022-04-08 | Butte | South Dakota | 46019 | 2750 | 44 |
2384826 | 2384826 | 2022-04-07 | Butte | South Dakota | 46019 | 2750 | 44 |
2381571 | 2381571 | 2022-04-06 | Butte | South Dakota | 46019 | 2750 | 44 |
2314690 | 2314690 | 2022-03-17 | Marshall | Illinois | 17123 | 2750 | 33 |
2288305 | 2288305 | 2022-03-09 | Park | Colorado | 8093 | 2750 | 20 |
2257920 | 2257920 | 2022-02-27 | Calhoun | South Carolina | 45017 | 2750 | 58 |
2254669 | 2254669 | 2022-02-26 | Calhoun | South Carolina | 45017 | 2750 | 58 |
2251418 | 2251418 | 2022-02-25 | Calhoun | South Carolina | 45017 | 2750 | 58 |
2225639 | 2225639 | 2022-02-17 | Callahan | Texas | 48059 | 2750 | 70 |
2213546 | 2213546 | 2022-02-14 | Unknown | Connecticut | 2750 | 0 | |
2145044 | 2145044 | 2022-01-24 | Desha | Arkansas | 5041 | 2750 | 35 |
2145171 | 2145171 | 2022-01-24 | Crowley | Colorado | 8025 | 2750 | 27 |
2133030 | 2133030 | 2022-01-20 | Claiborne | Louisiana | 22027 | 2750 | 67 |
2134933 | 2134933 | 2022-01-20 | Rockbridge | Virginia | 51163 | 2750 | 72 |
2118538 | 2118538 | 2022-01-15 | Unknown | Utah | 2750 | 57 | |
2110412 | 2110412 | 2022-01-13 | Kalkaska | Michigan | 26079 | 2750 | 48 |
2107161 | 2107161 | 2022-01-12 | Kalkaska | Michigan | 26079 | 2750 | 48 |
2109083 | 2109083 | 2022-01-12 | Price | Wisconsin | 55099 | 2750 | 23 |
2080007 | 2080007 | 2022-01-04 | Howard | Arkansas | 5061 | 2750 | 39 |
2057878 | 2057878 | 2021-12-28 | Pike | Indiana | 18125 | 2750 | 46 |
2059298 | 2059298 | 2021-12-28 | Kingfisher | Oklahoma | 40073 | 2750 | 56 |
2056049 | 2056049 | 2021-12-27 | Kingfisher | Oklahoma | 40073 | 2750 | 56 |
2052800 | 2052800 | 2021-12-26 | Kingfisher | Oklahoma | 40073 | 2750 | 56 |
2049550 | 2049550 | 2021-12-25 | Kingfisher | Oklahoma | 40073 | 2750 | 56 |
2046300 | 2046300 | 2021-12-24 | Kingfisher | Oklahoma | 40073 | 2750 | 56 |
2043050 | 2043050 | 2021-12-23 | Kingfisher | Oklahoma | 40073 | 2750 | 56 |
2039801 | 2039801 | 2021-12-22 | Kingfisher | Oklahoma | 40073 | 2750 | 56 |
2029211 | 2029211 | 2021-12-19 | Faribault | Minnesota | 27043 | 2750 | 37 |
2025960 | 2025960 | 2021-12-18 | Faribault | Minnesota | 27043 | 2750 | 37 |
2022709 | 2022709 | 2021-12-17 | Faribault | Minnesota | 27043 | 2750 | 37 |
2012304 | 2012304 | 2021-12-14 | Warren | Illinois | 17187 | 2750 | 72 |
1989480 | 1989480 | 2021-12-07 | Ford | Illinois | 17053 | 2750 | 67 |
1960210 | 1960210 | 2021-11-28 | Cass | Illinois | 17017 | 2750 | 40 |
1960540 | 1960540 | 2021-11-28 | Jefferson | Kansas | 20087 | 2750 | 51 |
1956959 | 1956959 | 2021-11-27 | Cass | Illinois | 17017 | 2750 | 40 |
1957289 | 1957289 | 2021-11-27 | Jefferson | Kansas | 20087 | 2750 | 51 |
1953708 | 1953708 | 2021-11-26 | Cass | Illinois | 17017 | 2750 | 40 |
1954038 | 1954038 | 2021-11-26 | Jefferson | Kansas | 20087 | 2750 | 51 |
1950457 | 1950457 | 2021-11-25 | Cass | Illinois | 17017 | 2750 | 40 |
1950787 | 1950787 | 2021-11-25 | Jefferson | Kansas | 20087 | 2750 | 51 |
1947206 | 1947206 | 2021-11-24 | Cass | Illinois | 17017 | 2750 | 40 |
1947536 | 1947536 | 2021-11-24 | Jefferson | Kansas | 20087 | 2750 | 51 |
1937632 | 1937632 | 2021-11-21 | Vermillion | Indiana | 18165 | 2750 | 56 |
1934382 | 1934382 | 2021-11-20 | Vermillion | Indiana | 18165 | 2750 | 56 |
1931131 | 1931131 | 2021-11-19 | Vermillion | Indiana | 18165 | 2750 | 56 |
1932656 | 1932656 | 2021-11-19 | Montour | Pennsylvania | 42093 | 2750 | 75 |
1928660 | 1928660 | 2021-11-18 | Moniteau | Missouri | 29135 | 2750 | 46 |
1925887 | 1925887 | 2021-11-17 | Richland | North Dakota | 38077 | 2750 | 21 |
1926835 | 1926835 | 2021-11-17 | King George | Virginia | 51099 | 2750 | 24 |
1921270 | 1921270 | 2021-11-16 | Pike | Illinois | 17149 | 2750 | 61 |
1921360 | 1921360 | 2021-11-16 | Perry | Indiana | 18123 | 2750 | 55 |
1921743 | 1921743 | 2021-11-16 | LaSalle | Louisiana | 22059 | 2750 | 46 |
1917465 | 1917465 | 2021-11-15 | Clay | Arkansas | 5021 | 2750 | 74 |
1875950 | 1875950 | 2021-11-02 | Kossuth | Iowa | 19109 | 2750 | 74 |
1872701 | 1872701 | 2021-11-01 | Kossuth | Iowa | 19109 | 2750 | 74 |
1873622 | 1873622 | 2021-11-01 | Humboldt | Nevada | 32013 | 2750 | 35 |
1869452 | 1869452 | 2021-10-31 | Kossuth | Iowa | 19109 | 2750 | 74 |
1870533 | 1870533 | 2021-10-31 | Currituck | North Carolina | 37053 | 2750 | 27 |
1866203 | 1866203 | 2021-10-30 | Kossuth | Iowa | 19109 | 2750 | 74 |
1867284 | 1867284 | 2021-10-30 | Currituck | North Carolina | 37053 | 2750 | 27 |
1862954 | 1862954 | 2021-10-29 | Kossuth | Iowa | 19109 | 2750 | 74 |
1864035 | 1864035 | 2021-10-29 | Currituck | North Carolina | 37053 | 2750 | 27 |
1859705 | 1859705 | 2021-10-28 | Kossuth | Iowa | 19109 | 2750 | 74 |
1856456 | 1856456 | 2021-10-27 | Kossuth | Iowa | 19109 | 2750 | 74 |
1830581 | 1830581 | 2021-10-19 | Pottawatomie | Kansas | 20149 | 2750 | 41 |
1830756 | 1830756 | 2021-10-19 | Jackson | Louisiana | 22049 | 2750 | 63 |
1827332 | 1827332 | 2021-10-18 | Pottawatomie | Kansas | 20149 | 2750 | 42 |
1815370 | 1815370 | 2021-10-14 | Yancey | North Carolina | 37199 | 2750 | 29 |
1778840 | 1778840 | 2021-10-03 | Garrett | Maryland | 24023 | 2750 | 71 |
1759441 | 1759441 | 2021-09-27 | Otsego | Michigan | 26137 | 2750 | 45 |
1707729 | 1707729 | 2021-09-11 | Perry | Missouri | 29157 | 2750 | 32 |
1673046 | 1673046 | 2021-08-31 | Austin | Texas | 48015 | 2750 | 42 |
1656940 | 1656940 | 2021-08-26 | Lampasas | Texas | 48281 | 2750 | 40 |
1650330 | 1650330 | 2021-08-24 | Burleson | Texas | 48051 | 2750 | 48 |
1646519 | 1646519 | 2021-08-23 | Gallia | Ohio | 39053 | 2750 | 51 |
1631937 | 1631937 | 2021-08-19 | Pike | Georgia | 13231 | 2750 | 46 |
1630507 | 1630507 | 2021-08-18 | Susquehanna | Pennsylvania | 42115 | 2750 | 62 |
1630936 | 1630936 | 2021-08-18 | Jones | Texas | 48253 | 2750 | 57 |
1627757 | 1627757 | 2021-08-17 | Reeves | Texas | 48389 | 2750 | 45 |
1618447 | 1618447 | 2021-08-15 | Barbour | Alabama | 1005 | 2750 | 65 |
1605973 | 1605973 | 2021-08-11 | Tattnall | Georgia | 13267 | 2750 | 72 |
1597141 | 1597141 | 2021-08-08 | Grenada | Mississippi | 28043 | 2750 | 88 |
1593892 | 1593892 | 2021-08-07 | Grenada | Mississippi | 28043 | 2750 | 88 |
1590643 | 1590643 | 2021-08-06 | Grenada | Mississippi | 28043 | 2750 | 88 |
1564714 | 1564714 | 2021-07-29 | Adair | Missouri | 29001 | 2750 | 24 |
1540266 | 1540266 | 2021-07-21 | Pulaski | Virginia | 51155 | 2750 | 64 |
1540296 | 1540296 | 2021-07-21 | Wythe | Virginia | 51197 | 2750 | 81 |
1534452 | 1534452 | 2021-07-20 | Haralson | Georgia | 13143 | 2750 | 91 |
1531386 | 1531386 | 2021-07-19 | Jersey | Illinois | 17083 | 2750 | 71 |
1497124 | 1497124 | 2021-07-08 | Henry | Ohio | 39069 | 2750 | 67 |
1469347 | 1469347 | 2021-06-30 | Morgan | Colorado | 8087 | 2750 | 96 |
1449467 | 1449467 | 2021-06-23 | Mingo | West Virginia | 54059 | 2750 | 42 |
1406940 | 1406940 | 2021-06-10 | Moore | Texas | 48341 | 2750 | 73 |
1403694 | 1403694 | 2021-06-09 | Moore | Texas | 48341 | 2750 | 73 |
1374485 | 1374485 | 2021-05-31 | Moore | Texas | 48341 | 2750 | 73 |
1371240 | 1371240 | 2021-05-30 | Moore | Texas | 48341 | 2750 | 73 |
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);