ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
400 rows where cases = 1133 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 33
- Virginia 32
- Texas 31
- Kansas 21
- Missouri 21
- Iowa 20
- Louisiana 18
- Idaho 15
- Kentucky 15
- Mississippi 15
- North Carolina 15
- Tennessee 13
- Puerto Rico 12
- Alabama 10
- Arkansas 10
- Michigan 10
- Minnesota 9
- Indiana 8
- Ohio 8
- South Carolina 8
- West Virginia 7
- Colorado 6
- New Mexico 6
- Wisconsin 5
- Wyoming 5
- Montana 4
- Nebraska 4
- Washington 4
- California 3
- Florida 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490678 | 2490678 | 2022-05-10 | Ringgold | Iowa | 19159 | 1133 | 34 |
2487421 | 2487421 | 2022-05-09 | Ringgold | Iowa | 19159 | 1133 | 34 |
2484163 | 2484163 | 2022-05-08 | Ringgold | Iowa | 19159 | 1133 | 34 |
2480905 | 2480905 | 2022-05-07 | Ringgold | Iowa | 19159 | 1133 | 34 |
2477647 | 2477647 | 2022-05-06 | Ringgold | Iowa | 19159 | 1133 | 34 |
2474389 | 2474389 | 2022-05-05 | Ringgold | Iowa | 19159 | 1133 | 34 |
2471132 | 2471132 | 2022-05-04 | Ringgold | Iowa | 19159 | 1133 | 34 |
2469999 | 2469999 | 2022-05-03 | King and Queen | Virginia | 51097 | 1133 | 12 |
2466743 | 2466743 | 2022-05-02 | King and Queen | Virginia | 51097 | 1133 | 12 |
2399214 | 2399214 | 2022-04-12 | Lewis | Idaho | 16061 | 1133 | 29 |
2357000 | 2357000 | 2022-03-30 | Putnam | Illinois | 17155 | 1133 | 10 |
2336509 | 2336509 | 2022-03-23 | Covington city | Virginia | 51580 | 1133 | 25 |
2279246 | 2279246 | 2022-03-06 | Stafford | Kansas | 20185 | 1133 | 26 |
2275993 | 2275993 | 2022-03-05 | Stafford | Kansas | 20185 | 1133 | 26 |
2272740 | 2272740 | 2022-03-04 | Stafford | Kansas | 20185 | 1133 | 26 |
2237576 | 2237576 | 2022-02-21 | Reynolds | Missouri | 29179 | 1133 | 20 |
2234325 | 2234325 | 2022-02-20 | Reynolds | Missouri | 29179 | 1133 | 20 |
2231074 | 2231074 | 2022-02-19 | Reynolds | Missouri | 29179 | 1133 | 20 |
2227823 | 2227823 | 2022-02-18 | Reynolds | Missouri | 29179 | 1133 | 20 |
2225933 | 2225933 | 2022-02-17 | Charles City | Virginia | 51036 | 1133 | 26 |
2213750 | 2213750 | 2022-02-14 | Talbot | Georgia | 13263 | 1133 | 31 |
2216012 | 2216012 | 2022-02-14 | Martin | Texas | 48317 | 1133 | 26 |
2173204 | 2173204 | 2022-02-01 | Wallowa | Oregon | 41063 | 1133 | 14 |
2156288 | 2156288 | 2022-01-27 | Broadwater | Montana | 30007 | 1133 | 18 |
2114743 | 2114743 | 2022-01-14 | Guanica | Puerto Rico | 72055 | 1133 | |
2083329 | 2083329 | 2022-01-05 | Modoc | California | 6049 | 1133 | 11 |
2021076 | 2021076 | 2021-12-16 | Fairfax city | Virginia | 51600 | 1133 | 35 |
2012926 | 2012926 | 2021-12-14 | Schoolcraft | Michigan | 26153 | 1133 | 7 |
2009675 | 2009675 | 2021-12-13 | Schoolcraft | Michigan | 26153 | 1133 | 7 |
2006863 | 2006863 | 2021-12-12 | Thurston | Nebraska | 31173 | 1133 | 17 |
2003612 | 2003612 | 2021-12-11 | Thurston | Nebraska | 31173 | 1133 | 17 |
2000362 | 2000362 | 2021-12-10 | Thurston | Nebraska | 31173 | 1133 | 17 |
1996869 | 1996869 | 2021-12-09 | Carter | Missouri | 29035 | 1133 | 18 |
1987295 | 1987295 | 2021-12-06 | Dawes | Nebraska | 31045 | 1133 | 21 |
1985001 | 1985001 | 2021-12-05 | Brooks | Texas | 48047 | 1133 | 47 |
1985291 | 1985291 | 2021-12-05 | Bland | Virginia | 51021 | 1133 | 17 |
1981751 | 1981751 | 2021-12-04 | Brooks | Texas | 48047 | 1133 | 47 |
1982041 | 1982041 | 2021-12-04 | Bland | Virginia | 51021 | 1133 | 17 |
1978791 | 1978791 | 2021-12-03 | Bland | Virginia | 51021 | 1133 | 17 |
1967348 | 1967348 | 2021-11-30 | Alger | Michigan | 26003 | 1133 | 9 |
1964096 | 1964096 | 2021-11-29 | Alger | Michigan | 26003 | 1133 | 9 |
1960060 | 1960060 | 2021-11-28 | Hancock | Georgia | 13141 | 1133 | 82 |
1961542 | 1961542 | 2021-11-28 | Gates | North Carolina | 37073 | 1133 | 18 |
1956809 | 1956809 | 2021-11-27 | Hancock | Georgia | 13141 | 1133 | 82 |
1958291 | 1958291 | 2021-11-27 | Gates | North Carolina | 37073 | 1133 | 18 |
1953558 | 1953558 | 2021-11-26 | Hancock | Georgia | 13141 | 1133 | 82 |
1955040 | 1955040 | 2021-11-26 | Gates | North Carolina | 37073 | 1133 | 18 |
1950307 | 1950307 | 2021-11-25 | Hancock | Georgia | 13141 | 1133 | 82 |
1951789 | 1951789 | 2021-11-25 | Gates | North Carolina | 37073 | 1133 | 18 |
1947056 | 1947056 | 2021-11-24 | Hancock | Georgia | 13141 | 1133 | 82 |
1948538 | 1948538 | 2021-11-24 | Gates | North Carolina | 37073 | 1133 | 18 |
1943805 | 1943805 | 2021-11-23 | Hancock | Georgia | 13141 | 1133 | 82 |
1940280 | 1940280 | 2021-11-22 | Woodruff | Arkansas | 5147 | 1133 | 24 |
1919179 | 1919179 | 2021-11-15 | Quay | New Mexico | 35037 | 1133 | 23 |
1894422 | 1894422 | 2021-11-07 | Jefferson | Washington | 53031 | 1133 | 17 |
1891172 | 1891172 | 2021-11-06 | Jefferson | Washington | 53031 | 1133 | 17 |
1887922 | 1887922 | 2021-11-05 | Jefferson | Washington | 53031 | 1133 | 17 |
1878507 | 1878507 | 2021-11-03 | Montgomery | Arkansas | 5097 | 1133 | 45 |
1864769 | 1864769 | 2021-10-29 | Coleman | Texas | 48083 | 1133 | 53 |
1853866 | 1853866 | 2021-10-26 | Caldwell | Missouri | 29025 | 1133 | 20 |
1848252 | 1848252 | 2021-10-24 | San German | Puerto Rico | 72125 | 1133 | |
1839244 | 1839244 | 2021-10-21 | Pocahontas | West Virginia | 54075 | 1133 | 18 |
1781177 | 1781177 | 2021-10-04 | San Miguel | Colorado | 8113 | 1133 | 3 |
1765107 | 1765107 | 2021-09-29 | Lincoln | Georgia | 13181 | 1133 | 32 |
1759734 | 1759734 | 2021-09-27 | Sullivan | Missouri | 29211 | 1133 | 14 |
1748546 | 1748546 | 2021-09-24 | Newton | Arkansas | 5101 | 1133 | 32 |
1744706 | 1744706 | 2021-09-22 | Refugio | Texas | 48391 | 1133 | 25 |
1720070 | 1720070 | 2021-09-15 | Grant | Kansas | 20067 | 1133 | 24 |
1717849 | 1717849 | 2021-09-14 | Jones | North Carolina | 37103 | 1133 | 29 |
1718596 | 1718596 | 2021-09-14 | Franklin | Texas | 48159 | 1133 | 28 |
1714078 | 1714078 | 2021-09-13 | Franklin | Mississippi | 28037 | 1133 | 27 |
1710776 | 1710776 | 2021-09-12 | Murray | Minnesota | 27101 | 1133 | 10 |
1707529 | 1707529 | 2021-09-11 | Murray | Minnesota | 27101 | 1133 | 10 |
1704282 | 1704282 | 2021-09-10 | Murray | Minnesota | 27101 | 1133 | 10 |
1700254 | 1700254 | 2021-09-09 | Valley | Idaho | 16085 | 1133 | 6 |
1696928 | 1696928 | 2021-09-08 | Taylor | Georgia | 13269 | 1133 | 26 |
1699168 | 1699168 | 2021-09-08 | La Salle | Texas | 48283 | 1133 | 30 |
1699336 | 1699336 | 2021-09-08 | Amelia | Virginia | 51007 | 1133 | 38 |
1693317 | 1693317 | 2021-09-07 | Nevada | Arkansas | 5099 | 1133 | 29 |
1670588 | 1670588 | 2021-08-31 | Searcy | Arkansas | 5129 | 1133 | 20 |
1656065 | 1656065 | 2021-08-26 | Schuyler | New York | 36097 | 1133 | 14 |
1656625 | 1656625 | 2021-08-26 | McCormick | South Carolina | 45065 | 1133 | 28 |
1646004 | 1646004 | 2021-08-23 | Oregon | Missouri | 29149 | 1133 | 6 |
1644285 | 1644285 | 2021-08-22 | Braxton | West Virginia | 54007 | 1133 | 4 |
1641035 | 1641035 | 2021-08-21 | Braxton | West Virginia | 54007 | 1133 | 4 |
1637785 | 1637785 | 2021-08-20 | Braxton | West Virginia | 54007 | 1133 | 4 |
1618856 | 1618856 | 2021-08-15 | Candler | Georgia | 13043 | 1133 | 68 |
1619152 | 1619152 | 2021-08-15 | Benton | Indiana | 18007 | 1133 | 15 |
1615608 | 1615608 | 2021-08-14 | Candler | Georgia | 13043 | 1133 | 68 |
1615904 | 1615904 | 2021-08-14 | Benton | Indiana | 18007 | 1133 | 15 |
1612359 | 1612359 | 2021-08-13 | Candler | Georgia | 13043 | 1133 | 68 |
1612655 | 1612655 | 2021-08-13 | Benton | Indiana | 18007 | 1133 | 15 |
1609293 | 1609293 | 2021-08-12 | Owyhee | Idaho | 16073 | 1133 | 31 |
1609407 | 1609407 | 2021-08-12 | Benton | Indiana | 18007 | 1133 | 15 |
1610266 | 1610266 | 2021-08-12 | Monroe | Missouri | 29137 | 1133 | 12 |
1605918 | 1605918 | 2021-08-11 | Irwin | Georgia | 13155 | 1133 | 31 |
1606044 | 1606044 | 2021-08-11 | Owyhee | Idaho | 16073 | 1133 | 31 |
1602254 | 1602254 | 2021-08-10 | Perry | Alabama | 1105 | 1133 | 28 |
1603826 | 1603826 | 2021-08-10 | Dawson | Montana | 30021 | 1133 | 32 |
1596703 | 1596703 | 2021-08-08 | Wilson | Kansas | 20205 | 1133 | 21 |
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);