ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
194 rows where cases = 2389 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 14
- Indiana 12
- Georgia 11
- Puerto Rico 11
- North Carolina 10
- Arkansas 9
- Illinois 9
- Minnesota 9
- Texas 9
- Iowa 8
- Virginia 8
- Michigan 7
- South Carolina 7
- Wisconsin 7
- Kentucky 5
- Missouri 5
- New York 5
- Louisiana 4
- Nebraska 4
- Ohio 4
- Alabama 3
- Mississippi 3
- Oregon 3
- Tennessee 3
- West Virginia 3
- Colorado 2
- Florida 2
- Idaho 2
- Maryland 2
- New Hampshire 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474506 | 2474506 | 2022-05-05 | Thomas | Kansas | 20193 | 2389 | 28 |
2471249 | 2471249 | 2022-05-04 | Thomas | Kansas | 20193 | 2389 | 28 |
2467993 | 2467993 | 2022-05-03 | Thomas | Kansas | 20193 | 2389 | 28 |
2464738 | 2464738 | 2022-05-02 | Thomas | Kansas | 20193 | 2389 | 28 |
2461482 | 2461482 | 2022-05-01 | Thomas | Kansas | 20193 | 2389 | 28 |
2458226 | 2458226 | 2022-04-30 | Thomas | Kansas | 20193 | 2389 | 28 |
2454970 | 2454970 | 2022-04-29 | Thomas | Kansas | 20193 | 2389 | 28 |
2269105 | 2269105 | 2022-03-03 | Brown | Illinois | 17009 | 2389 | 21 |
2268390 | 2268390 | 2022-03-02 | Ritchie | West Virginia | 54085 | 2389 | 30 |
2246652 | 2246652 | 2022-02-24 | Coffey | Kansas | 20031 | 2389 | 39 |
2243401 | 2243401 | 2022-02-23 | Coffey | Kansas | 20031 | 2389 | 39 |
2225647 | 2225647 | 2022-02-17 | Childress | Texas | 48075 | 2389 | 28 |
2214816 | 2214816 | 2022-02-14 | Ralls | Missouri | 29173 | 2389 | 20 |
2202594 | 2202594 | 2022-02-10 | Lajas | Puerto Rico | 72079 | 2389 | |
2203074 | 2203074 | 2022-02-10 | Trinity | Texas | 48455 | 2389 | 69 |
2195217 | 2195217 | 2022-02-08 | Bollinger | Missouri | 29017 | 2389 | 35 |
2190620 | 2190620 | 2022-02-07 | Perry | Arkansas | 5105 | 2389 | 30 |
2154417 | 2154417 | 2022-01-26 | Lexington city | Virginia | 51678 | 2389 | 38 |
2135282 | 2135282 | 2022-01-21 | Fulton | Arkansas | 5049 | 2389 | 79 |
2126776 | 2126776 | 2022-01-18 | Pope | Minnesota | 27121 | 2389 | 14 |
2097078 | 2097078 | 2022-01-09 | Marion | Kansas | 20115 | 2389 | 36 |
2093826 | 2093826 | 2022-01-08 | Marion | Kansas | 20115 | 2389 | 36 |
2090574 | 2090574 | 2022-01-07 | Marion | Kansas | 20115 | 2389 | 36 |
2080703 | 2080703 | 2022-01-04 | Hancock | Iowa | 19081 | 2389 | 42 |
2077451 | 2077451 | 2022-01-03 | Hancock | Iowa | 19081 | 2389 | 42 |
2074200 | 2074200 | 2022-01-02 | Hancock | Iowa | 19081 | 2389 | 42 |
2070949 | 2070949 | 2022-01-01 | Hancock | Iowa | 19081 | 2389 | 42 |
2067698 | 2067698 | 2021-12-31 | Hancock | Iowa | 19081 | 2389 | 42 |
2064447 | 2064447 | 2021-12-30 | Hancock | Iowa | 19081 | 2389 | 42 |
2061197 | 2061197 | 2021-12-29 | Hancock | Iowa | 19081 | 2389 | 42 |
2058364 | 2058364 | 2021-12-28 | Benzie | Michigan | 26019 | 2389 | 53 |
2055115 | 2055115 | 2021-12-27 | Benzie | Michigan | 26019 | 2389 | 53 |
2032441 | 2032441 | 2021-12-20 | Aitkin | Minnesota | 27001 | 2389 | 53 |
2029150 | 2029150 | 2021-12-19 | Leelanau | Michigan | 26089 | 2389 | 39 |
2025899 | 2025899 | 2021-12-18 | Leelanau | Michigan | 26089 | 2389 | 39 |
2022648 | 2022648 | 2021-12-17 | Leelanau | Michigan | 26089 | 2389 | 39 |
2020586 | 2020586 | 2021-12-16 | Clay | South Dakota | 46027 | 2389 | 17 |
2014629 | 2014629 | 2021-12-14 | Patrick | Virginia | 51141 | 2389 | 61 |
1991833 | 1991833 | 2021-12-07 | Greene | Virginia | 51079 | 2389 | 45 |
1962788 | 1962788 | 2021-11-28 | Lafayette | Wisconsin | 55065 | 2389 | 12 |
1959537 | 1959537 | 2021-11-27 | Lafayette | Wisconsin | 55065 | 2389 | 12 |
1956286 | 1956286 | 2021-11-26 | Lafayette | Wisconsin | 55065 | 2389 | 12 |
1953035 | 1953035 | 2021-11-25 | Lafayette | Wisconsin | 55065 | 2389 | 12 |
1938594 | 1938594 | 2021-11-21 | Seward | Nebraska | 31159 | 2389 | 38 |
1935344 | 1935344 | 2021-11-20 | Seward | Nebraska | 31159 | 2389 | 38 |
1932094 | 1932094 | 2021-11-19 | Seward | Nebraska | 31159 | 2389 | 38 |
1923800 | 1923800 | 2021-11-16 | Richland | Wisconsin | 55103 | 2389 | 29 |
1918128 | 1918128 | 2021-11-15 | Tipton | Indiana | 18159 | 2389 | 66 |
1918460 | 1918460 | 2021-11-15 | Washington | Kentucky | 21229 | 2389 | 47 |
1919324 | 1919324 | 2021-11-15 | Polk | North Carolina | 37149 | 2389 | 48 |
1909154 | 1909154 | 2021-11-12 | Madison | Missouri | 29123 | 2389 | 27 |
1884789 | 1884789 | 2021-11-04 | Marquette | Wisconsin | 55077 | 2389 | 35 |
1875708 | 1875708 | 2021-11-02 | Carroll | Illinois | 17015 | 2389 | 39 |
1877484 | 1877484 | 2021-11-02 | Naranjito | Puerto Rico | 72105 | 2389 | |
1874235 | 1874235 | 2021-11-01 | Naranjito | Puerto Rico | 72105 | 2389 | |
1870986 | 1870986 | 2021-10-31 | Naranjito | Puerto Rico | 72105 | 2389 | |
1867737 | 1867737 | 2021-10-30 | Naranjito | Puerto Rico | 72105 | 2389 | |
1840959 | 1840959 | 2021-10-22 | Ste. Genevieve | Missouri | 29186 | 2389 | 29 |
1815597 | 1815597 | 2021-10-14 | Clatsop | Oregon | 41007 | 2389 | 28 |
1802412 | 1802412 | 2021-10-10 | Richland | North Dakota | 38077 | 2389 | 19 |
1797674 | 1797674 | 2021-10-09 | Kauai | Hawaii | 15007 | 2389 | 8 |
1796267 | 1796267 | 2021-10-08 | San Lorenzo | Puerto Rico | 72129 | 2389 | |
1757338 | 1757338 | 2021-09-26 | Saluda | South Carolina | 45081 | 2389 | 50 |
1754090 | 1754090 | 2021-09-25 | Saluda | South Carolina | 45081 | 2389 | 50 |
1750718 | 1750718 | 2021-09-24 | Aguada | Puerto Rico | 72003 | 2389 | |
1750842 | 1750842 | 2021-09-24 | Saluda | South Carolina | 45081 | 2389 | 50 |
1724174 | 1724174 | 2021-09-16 | Coos | New Hampshire | 33007 | 2389 | 46 |
1720164 | 1720164 | 2021-09-15 | Casey | Kentucky | 21045 | 2389 | 50 |
1716505 | 1716505 | 2021-09-14 | Clark | Illinois | 17023 | 2389 | 46 |
1710613 | 1710613 | 2021-09-12 | Garrett | Maryland | 24023 | 2389 | 69 |
1698316 | 1698316 | 2021-09-08 | Avery | North Carolina | 37011 | 2389 | 26 |
1674391 | 1674391 | 2021-09-01 | Fulton | Indiana | 18049 | 2389 | 48 |
1641671 | 1641671 | 2021-08-22 | Meriwether | Georgia | 13199 | 2389 | 93 |
1638421 | 1638421 | 2021-08-21 | Meriwether | Georgia | 13199 | 2389 | 93 |
1635171 | 1635171 | 2021-08-20 | Meriwether | Georgia | 13199 | 2389 | 93 |
1628966 | 1628966 | 2021-08-18 | Sullivan | Indiana | 18153 | 2389 | 46 |
1625515 | 1625515 | 2021-08-17 | Elmore | Idaho | 16039 | 2389 | 19 |
1609099 | 1609099 | 2021-08-12 | Ben Hill | Georgia | 13017 | 2389 | 85 |
1608489 | 1608489 | 2021-08-11 | Russell | Virginia | 51167 | 2389 | 40 |
1603513 | 1603513 | 2021-08-10 | Otsego | Michigan | 26137 | 2389 | 41 |
1600862 | 1600862 | 2021-08-09 | Ashe | North Carolina | 37009 | 2389 | 45 |
1601775 | 1601775 | 2021-08-09 | Robertson | Texas | 48395 | 2389 | 48 |
1597076 | 1597076 | 2021-08-08 | Martin | Minnesota | 27091 | 2389 | 33 |
1592626 | 1592626 | 2021-08-07 | Randolph | Arkansas | 5121 | 2389 | 48 |
1593827 | 1593827 | 2021-08-07 | Martin | Minnesota | 27091 | 2389 | 33 |
1590578 | 1590578 | 2021-08-06 | Martin | Minnesota | 27091 | 2389 | 33 |
1587329 | 1587329 | 2021-08-05 | Martin | Minnesota | 27091 | 2389 | 33 |
1580144 | 1580144 | 2021-08-03 | Shelby | Illinois | 17173 | 2389 | 41 |
1571319 | 1571319 | 2021-07-31 | Texas | Missouri | 29215 | 2389 | 27 |
1560745 | 1560745 | 2021-07-28 | Spencer | Indiana | 18147 | 2389 | 31 |
1556844 | 1556844 | 2021-07-27 | Cleburne | Arkansas | 5023 | 2389 | 74 |
1557498 | 1557498 | 2021-07-27 | Spencer | Indiana | 18147 | 2389 | 31 |
1524253 | 1524253 | 2021-07-17 | Barbour | Alabama | 1005 | 2389 | 60 |
1515029 | 1515029 | 2021-07-14 | Tattnall | Georgia | 13267 | 2389 | 68 |
1476957 | 1476957 | 2021-07-02 | Waseca | Minnesota | 27161 | 2389 | 23 |
1467803 | 1467803 | 2021-06-29 | Transylvania | North Carolina | 37175 | 2389 | 33 |
1468054 | 1468054 | 2021-06-29 | Jefferson | Oregon | 41031 | 2389 | 39 |
1464558 | 1464558 | 2021-06-28 | Transylvania | North Carolina | 37175 | 2389 | 33 |
1454689 | 1454689 | 2021-06-25 | Delaware | New York | 36025 | 2389 | 39 |
1451444 | 1451444 | 2021-06-24 | Delaware | New York | 36025 | 2389 | 39 |
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);