ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
205 rows where cases = 2611 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 24
- North Carolina 16
- Georgia 13
- Texas 11
- Iowa 9
- Wisconsin 9
- Illinois 8
- Mississippi 8
- Ohio 7
- Oklahoma 7
- South Carolina 7
- Arkansas 6
- California 6
- Missouri 6
- Montana 6
- Virginia 6
- Idaho 5
- Michigan 5
- Alabama 4
- Indiana 4
- Kentucky 4
- Tennessee 4
- Florida 3
- Minnesota 3
- Oregon 3
- Pennsylvania 3
- Puerto Rico 3
- Maryland 2
- Nebraska 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474489 | 2474489 | 2022-05-05 | Rice | Kansas | 20159 | 2611 | 23 |
2471232 | 2471232 | 2022-05-04 | Rice | Kansas | 20159 | 2611 | 23 |
2467976 | 2467976 | 2022-05-03 | Rice | Kansas | 20159 | 2611 | 23 |
2464721 | 2464721 | 2022-05-02 | Rice | Kansas | 20159 | 2611 | 23 |
2461465 | 2461465 | 2022-05-01 | Rice | Kansas | 20159 | 2611 | 23 |
2458209 | 2458209 | 2022-04-30 | Rice | Kansas | 20159 | 2611 | 23 |
2454953 | 2454953 | 2022-04-29 | Rice | Kansas | 20159 | 2611 | 23 |
2451697 | 2451697 | 2022-04-28 | Rice | Kansas | 20159 | 2611 | 23 |
2448441 | 2448441 | 2022-04-27 | Rice | Kansas | 20159 | 2611 | 23 |
2445185 | 2445185 | 2022-04-26 | Rice | Kansas | 20159 | 2611 | 23 |
2441929 | 2441929 | 2022-04-25 | Rice | Kansas | 20159 | 2611 | 23 |
2438673 | 2438673 | 2022-04-24 | Rice | Kansas | 20159 | 2611 | 23 |
2435417 | 2435417 | 2022-04-23 | Rice | Kansas | 20159 | 2611 | 23 |
2432161 | 2432161 | 2022-04-22 | Rice | Kansas | 20159 | 2611 | 23 |
2428905 | 2428905 | 2022-04-21 | Rice | Kansas | 20159 | 2611 | 23 |
2424714 | 2424714 | 2022-04-20 | Lowndes | Alabama | 1085 | 2611 | 76 |
2425649 | 2425649 | 2022-04-20 | Rice | Kansas | 20159 | 2611 | 23 |
2421458 | 2421458 | 2022-04-19 | Lowndes | Alabama | 1085 | 2611 | 76 |
2422393 | 2422393 | 2022-04-19 | Rice | Kansas | 20159 | 2611 | 23 |
2419137 | 2419137 | 2022-04-18 | Rice | Kansas | 20159 | 2611 | 23 |
2415881 | 2415881 | 2022-04-17 | Rice | Kansas | 20159 | 2611 | 23 |
2412625 | 2412625 | 2022-04-16 | Rice | Kansas | 20159 | 2611 | 23 |
2409369 | 2409369 | 2022-04-15 | Rice | Kansas | 20159 | 2611 | 23 |
2398330 | 2398330 | 2022-04-11 | Clarke | Virginia | 51043 | 2611 | 42 |
2368834 | 2368834 | 2022-04-02 | Jim Hogg | Texas | 48247 | 2611 | 22 |
2362511 | 2362511 | 2022-03-31 | Amelia | Virginia | 51007 | 2611 | 61 |
2264210 | 2264210 | 2022-03-01 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2265027 | 2265027 | 2022-03-01 | Richmond | Virginia | 51159 | 2611 | 25 |
2260960 | 2260960 | 2022-02-28 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2257420 | 2257420 | 2022-02-27 | Clay | North Carolina | 37043 | 2611 | 39 |
2257709 | 2257709 | 2022-02-27 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2254169 | 2254169 | 2022-02-26 | Clay | North Carolina | 37043 | 2611 | 39 |
2254458 | 2254458 | 2022-02-26 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2250918 | 2250918 | 2022-02-25 | Clay | North Carolina | 37043 | 2611 | 39 |
2251207 | 2251207 | 2022-02-25 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2247956 | 2247956 | 2022-02-24 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2244705 | 2244705 | 2022-02-23 | Pushmataha | Oklahoma | 40127 | 2611 | 42 |
2217296 | 2217296 | 2022-02-15 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2214045 | 2214045 | 2022-02-14 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2215049 | 2215049 | 2022-02-14 | Colfax | New Mexico | 35007 | 2611 | 64 |
2210793 | 2210793 | 2022-02-13 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2207540 | 2207540 | 2022-02-12 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2204287 | 2204287 | 2022-02-11 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2201034 | 2201034 | 2022-02-10 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2197780 | 2197780 | 2022-02-09 | Chickasaw | Iowa | 19037 | 2611 | 30 |
2126637 | 2126637 | 2022-01-18 | Arenac | Michigan | 26011 | 2611 | 56 |
2123385 | 2123385 | 2022-01-17 | Arenac | Michigan | 26011 | 2611 | 56 |
2120133 | 2120133 | 2022-01-16 | Arenac | Michigan | 26011 | 2611 | 56 |
2116881 | 2116881 | 2022-01-15 | Arenac | Michigan | 26011 | 2611 | 56 |
2113630 | 2113630 | 2022-01-14 | Arenac | Michigan | 26011 | 2611 | 56 |
2085436 | 2085436 | 2022-01-05 | Potter | Pennsylvania | 42105 | 2611 | 79 |
2072230 | 2072230 | 2022-01-01 | Monroe | Ohio | 39111 | 2611 | 67 |
2068979 | 2068979 | 2021-12-31 | Monroe | Ohio | 39111 | 2611 | 67 |
2062401 | 2062401 | 2021-12-29 | Ramsey | North Dakota | 38071 | 2611 | 43 |
2055860 | 2055860 | 2021-12-27 | Warren | North Carolina | 37185 | 2611 | 36 |
2052610 | 2052610 | 2021-12-26 | Warren | North Carolina | 37185 | 2611 | 36 |
2049360 | 2049360 | 2021-12-25 | Warren | North Carolina | 37185 | 2611 | 36 |
2046110 | 2046110 | 2021-12-24 | Warren | North Carolina | 37185 | 2611 | 36 |
2042860 | 2042860 | 2021-12-23 | Warren | North Carolina | 37185 | 2611 | 36 |
2039611 | 2039611 | 2021-12-22 | Warren | North Carolina | 37185 | 2611 | 36 |
2035397 | 2035397 | 2021-12-21 | Estill | Kentucky | 21065 | 2611 | 37 |
2019227 | 2019227 | 2021-12-16 | Webster | Kentucky | 21233 | 2611 | 42 |
2005306 | 2005306 | 2021-12-12 | Inyo | California | 6027 | 2611 | 46 |
2002055 | 2002055 | 2021-12-11 | Inyo | California | 6027 | 2611 | 46 |
1998805 | 1998805 | 2021-12-10 | Inyo | California | 6027 | 2611 | 46 |
1949763 | 1949763 | 2021-11-24 | Crawford | Wisconsin | 55023 | 2611 | 23 |
1941449 | 1941449 | 2021-11-22 | Houston | Minnesota | 27055 | 2611 | 17 |
1928797 | 1928797 | 2021-11-18 | Gage | Nebraska | 31067 | 2611 | 30 |
1920737 | 1920737 | 2021-11-16 | Izard | Arkansas | 5065 | 2611 | 55 |
1898355 | 1898355 | 2021-11-09 | Rabun | Georgia | 13241 | 2611 | 67 |
1896567 | 1896567 | 2021-11-08 | Northampton | North Carolina | 37131 | 2611 | 65 |
1887544 | 1887544 | 2021-11-05 | Falls | Texas | 48145 | 2611 | 48 |
1884294 | 1884294 | 2021-11-04 | Falls | Texas | 48145 | 2611 | 48 |
1873355 | 1873355 | 2021-11-01 | Benton | Missouri | 29015 | 2611 | 45 |
1870106 | 1870106 | 2021-10-31 | Benton | Missouri | 29015 | 2611 | 45 |
1871811 | 1871811 | 2021-10-31 | Sawyer | Wisconsin | 55113 | 2611 | 33 |
1868562 | 1868562 | 2021-10-30 | Sawyer | Wisconsin | 55113 | 2611 | 33 |
1865313 | 1865313 | 2021-10-29 | Sawyer | Wisconsin | 55113 | 2611 | 33 |
1852970 | 1852970 | 2021-10-26 | Clay | Illinois | 17025 | 2611 | 59 |
1855347 | 1855347 | 2021-10-26 | King George | Virginia | 51099 | 2611 | 22 |
1805097 | 1805097 | 2021-10-11 | Smith | Mississippi | 28129 | 2611 | 49 |
1792458 | 1792458 | 2021-10-07 | Roosevelt | New Mexico | 35041 | 2611 | 68 |
1786169 | 1786169 | 2021-10-05 | Rolette | North Dakota | 38079 | 2611 | 30 |
1771246 | 1771246 | 2021-10-01 | Clay | Arkansas | 5021 | 2611 | 58 |
1762013 | 1762013 | 2021-09-28 | Hancock | Illinois | 17067 | 2611 | 44 |
1746284 | 1746284 | 2021-09-23 | LaSalle | Louisiana | 22059 | 2611 | 44 |
1742063 | 1742063 | 2021-09-22 | Sharp | Arkansas | 5135 | 2611 | 62 |
1689918 | 1689918 | 2021-09-06 | Cherokee | Alabama | 1019 | 2611 | 49 |
1690499 | 1690499 | 2021-09-06 | Minidoka | Idaho | 16067 | 2611 | 34 |
1687249 | 1687249 | 2021-09-05 | Minidoka | Idaho | 16067 | 2611 | 34 |
1683999 | 1683999 | 2021-09-04 | Minidoka | Idaho | 16067 | 2611 | 34 |
1680748 | 1680748 | 2021-09-03 | Minidoka | Idaho | 16067 | 2611 | 34 |
1673182 | 1673182 | 2021-08-31 | Lee | Texas | 48287 | 2611 | 43 |
1641834 | 1641834 | 2021-08-22 | Lawrence | Illinois | 17101 | 2611 | 38 |
1638124 | 1638124 | 2021-08-21 | Colusa | California | 6011 | 2611 | 18 |
1638584 | 1638584 | 2021-08-21 | Lawrence | Illinois | 17101 | 2611 | 38 |
1635334 | 1635334 | 2021-08-20 | Lawrence | Illinois | 17101 | 2611 | 38 |
1637314 | 1637314 | 2021-08-20 | Austin | Texas | 48015 | 2611 | 39 |
1618570 | 1618570 | 2021-08-15 | Conway | Arkansas | 5029 | 2611 | 37 |
1597320 | 1597320 | 2021-08-08 | Big Horn | Montana | 30003 | 2611 | 76 |
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);