ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
278 rows where cases = 1847 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 23
- Tennessee 23
- Kentucky 18
- Arkansas 16
- Texas 16
- Georgia 15
- Minnesota 15
- Virginia 14
- Mississippi 12
- Missouri 12
- Indiana 10
- Michigan 10
- Alabama 7
- North Carolina 7
- Puerto Rico 7
- Florida 6
- South Carolina 6
- New Mexico 5
- Ohio 5
- California 4
- Colorado 4
- Illinois 4
- Kansas 4
- Oregon 4
- West Virginia 4
- Nebraska 3
- Pennsylvania 3
- South Dakota 3
- Wisconsin 3
- Maryland 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466757 | 2466757 | 2022-05-02 | Middlesex | Virginia | 51119 | 1847 | 48 |
2424040 | 2424040 | 2022-04-19 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2420784 | 2420784 | 2022-04-18 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2417528 | 2417528 | 2022-04-17 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2414272 | 2414272 | 2022-04-16 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2411016 | 2411016 | 2022-04-15 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2407760 | 2407760 | 2022-04-14 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2404504 | 2404504 | 2022-04-13 | Van Buren | Tennessee | 47175 | 1847 | 48 |
2401249 | 2401249 | 2022-04-12 | Van Buren | Tennessee | 47175 | 1847 | 47 |
2397994 | 2397994 | 2022-04-11 | Van Buren | Tennessee | 47175 | 1847 | 47 |
2394739 | 2394739 | 2022-04-10 | Van Buren | Tennessee | 47175 | 1847 | 47 |
2391483 | 2391483 | 2022-04-09 | Van Buren | Tennessee | 47175 | 1847 | 47 |
2388227 | 2388227 | 2022-04-08 | Van Buren | Tennessee | 47175 | 1847 | 47 |
2384972 | 2384972 | 2022-04-07 | Van Buren | Tennessee | 47175 | 1847 | 47 |
2381717 | 2381717 | 2022-04-06 | Van Buren | Tennessee | 47175 | 1847 | 47 |
2297198 | 2297198 | 2022-03-11 | Crosby | Texas | 48107 | 1847 | 45 |
2246832 | 2246832 | 2022-02-24 | Nicholas | Kentucky | 21181 | 1847 | 30 |
2243581 | 2243581 | 2022-02-23 | Nicholas | Kentucky | 21181 | 1847 | 30 |
2232767 | 2232767 | 2022-02-20 | Greene | Alabama | 1063 | 1847 | 48 |
2200686 | 2200686 | 2022-02-10 | Irwin | Georgia | 13155 | 1847 | 42 |
2199935 | 2199935 | 2022-02-09 | Falls Church city | Virginia | 51610 | 1847 | 14 |
2193653 | 2193653 | 2022-02-07 | Menominee | Wisconsin | 55078 | 1847 | 13 |
2157059 | 2157059 | 2022-01-27 | Patillas | Puerto Rico | 72109 | 1847 | |
2148339 | 2148339 | 2022-01-25 | Searcy | Arkansas | 5129 | 1847 | 37 |
2132287 | 2132287 | 2022-01-20 | Atkinson | Georgia | 13003 | 1847 | 39 |
2134733 | 2134733 | 2022-01-20 | Somervell | Texas | 48425 | 1847 | 30 |
2126318 | 2126318 | 2022-01-18 | Grant | Kansas | 20067 | 1847 | 33 |
2123066 | 2123066 | 2022-01-17 | Grant | Kansas | 20067 | 1847 | 33 |
2110176 | 2110176 | 2022-01-13 | Hancock | Kentucky | 21091 | 1847 | 19 |
2108954 | 2108954 | 2022-01-12 | Jefferson | Washington | 53031 | 1847 | 20 |
2100779 | 2100779 | 2022-01-10 | Swift | Minnesota | 27151 | 1847 | 30 |
2085636 | 2085636 | 2022-01-05 | Roberts | South Dakota | 46109 | 1847 | 45 |
2080039 | 2080039 | 2022-01-04 | Scott | Arkansas | 5127 | 1847 | 34 |
2057988 | 2057988 | 2021-12-28 | Sac | Iowa | 19161 | 1847 | 27 |
2054376 | 2054376 | 2021-12-27 | Screven | Georgia | 13251 | 1847 | 62 |
2054739 | 2054739 | 2021-12-27 | Sac | Iowa | 19161 | 1847 | 27 |
2051489 | 2051489 | 2021-12-26 | Sac | Iowa | 19161 | 1847 | 27 |
2052014 | 2052014 | 2021-12-26 | Stevens | Minnesota | 27149 | 1847 | 11 |
2048239 | 2048239 | 2021-12-25 | Sac | Iowa | 19161 | 1847 | 27 |
2048764 | 2048764 | 2021-12-25 | Stevens | Minnesota | 27149 | 1847 | 11 |
2044989 | 2044989 | 2021-12-24 | Sac | Iowa | 19161 | 1847 | 27 |
2045514 | 2045514 | 2021-12-24 | Stevens | Minnesota | 27149 | 1847 | 11 |
2041740 | 2041740 | 2021-12-23 | Sac | Iowa | 19161 | 1847 | 27 |
2042264 | 2042264 | 2021-12-23 | Stevens | Minnesota | 27149 | 1847 | 11 |
2038490 | 2038490 | 2021-12-22 | Sac | Iowa | 19161 | 1847 | 27 |
2035654 | 2035654 | 2021-12-21 | Luce | Michigan | 26095 | 1847 | 6 |
2032404 | 2032404 | 2021-12-20 | Luce | Michigan | 26095 | 1847 | 6 |
2022557 | 2022557 | 2021-12-17 | Piscataquis | Maine | 23021 | 1847 | 15 |
1998272 | 1998272 | 2021-12-09 | Lamoille | Vermont | 50015 | 1847 | 9 |
1986609 | 1986609 | 2021-12-06 | Bath | Kentucky | 21011 | 1847 | 33 |
1987510 | 1987510 | 2021-12-06 | Alleghany | North Carolina | 37005 | 1847 | 6 |
1977407 | 1977407 | 2021-12-03 | Lewis | Missouri | 29111 | 1847 | 30 |
1974157 | 1974157 | 2021-12-02 | Lewis | Missouri | 29111 | 1847 | 30 |
1951262 | 1951262 | 2021-11-25 | Yellow Medicine | Minnesota | 27173 | 1847 | 21 |
1948011 | 1948011 | 2021-11-24 | Yellow Medicine | Minnesota | 27173 | 1847 | 21 |
1875370 | 1875370 | 2021-11-02 | Gunnison | Colorado | 8051 | 1847 | 12 |
1876348 | 1876348 | 2021-11-02 | Arenac | Michigan | 26011 | 1847 | 35 |
1872121 | 1872121 | 2021-11-01 | Gunnison | Colorado | 8051 | 1847 | 12 |
1873099 | 1873099 | 2021-11-01 | Arenac | Michigan | 26011 | 1847 | 35 |
1860411 | 1860411 | 2021-10-28 | Linn | Missouri | 29115 | 1847 | 26 |
1854827 | 1854827 | 2021-10-26 | Butte | South Dakota | 46019 | 1847 | 30 |
1809730 | 1809730 | 2021-10-12 | Ward | Texas | 48475 | 1847 | 26 |
1801835 | 1801835 | 2021-10-10 | Noxubee | Mississippi | 28103 | 1847 | 40 |
1798586 | 1798586 | 2021-10-09 | Noxubee | Mississippi | 28103 | 1847 | 40 |
1795337 | 1795337 | 2021-10-08 | Noxubee | Mississippi | 28103 | 1847 | 40 |
1784255 | 1784255 | 2021-10-05 | Desha | Arkansas | 5041 | 1847 | 29 |
1759144 | 1759144 | 2021-09-27 | Breathitt | Kentucky | 21025 | 1847 | 18 |
1739576 | 1739576 | 2021-09-21 | Jackson | Kansas | 20085 | 1847 | 19 |
1736327 | 1736327 | 2021-09-20 | Jackson | Kansas | 20085 | 1847 | 19 |
1725079 | 1725079 | 2021-09-16 | Duval | Texas | 48131 | 1847 | 52 |
1716559 | 1716559 | 2021-09-14 | Mercer | Illinois | 17131 | 1847 | 34 |
1714996 | 1714996 | 2021-09-13 | Cidra | Puerto Rico | 72041 | 1847 | |
1698748 | 1698748 | 2021-09-08 | Cabo Rojo | Puerto Rico | 72023 | 1847 | |
1693965 | 1693965 | 2021-09-07 | Butler | Iowa | 19023 | 1847 | 36 |
1690716 | 1690716 | 2021-09-06 | Butler | Iowa | 19023 | 1847 | 36 |
1687466 | 1687466 | 2021-09-05 | Butler | Iowa | 19023 | 1847 | 36 |
1684216 | 1684216 | 2021-09-04 | Butler | Iowa | 19023 | 1847 | 36 |
1680965 | 1680965 | 2021-09-03 | Butler | Iowa | 19023 | 1847 | 36 |
1677717 | 1677717 | 2021-09-02 | Butler | Iowa | 19023 | 1847 | 36 |
1674470 | 1674470 | 2021-09-01 | Butler | Iowa | 19023 | 1847 | 36 |
1670596 | 1670596 | 2021-08-31 | Van Buren | Arkansas | 5141 | 1847 | 34 |
1663020 | 1663020 | 2021-08-28 | Cayey | Puerto Rico | 72035 | 1847 | |
1651084 | 1651084 | 2021-08-25 | Marion | Arkansas | 5089 | 1847 | 46 |
1654052 | 1654052 | 2021-08-25 | McDowell | West Virginia | 54047 | 1847 | 27 |
1632739 | 1632739 | 2021-08-19 | Ogemaw | Michigan | 26129 | 1847 | 44 |
1629492 | 1629492 | 2021-08-18 | Ogemaw | Michigan | 26129 | 1847 | 44 |
1624960 | 1624960 | 2021-08-17 | Crenshaw | Alabama | 1041 | 1847 | 59 |
1626292 | 1626292 | 2021-08-17 | Houston | Minnesota | 27055 | 1847 | 16 |
1623534 | 1623534 | 2021-08-16 | Taos | New Mexico | 35055 | 1847 | 56 |
1624460 | 1624460 | 2021-08-16 | Leon | Texas | 48289 | 1847 | 44 |
1624594 | 1624594 | 2021-08-16 | Unknown | Utah | 1847 | 25 | |
1604114 | 1604114 | 2021-08-10 | Bertie | North Carolina | 37015 | 1847 | 45 |
1604461 | 1604461 | 2021-08-10 | Union | Oregon | 41061 | 1847 | 28 |
1584098 | 1584098 | 2021-08-04 | Renville | Minnesota | 27129 | 1847 | 46 |
1580849 | 1580849 | 2021-08-03 | Renville | Minnesota | 27129 | 1847 | 46 |
1574789 | 1574789 | 2021-08-01 | Lincoln | New Mexico | 35027 | 1847 | 20 |
1571541 | 1571541 | 2021-07-31 | Lincoln | New Mexico | 35027 | 1847 | 20 |
1568293 | 1568293 | 2021-07-30 | Lincoln | New Mexico | 35027 | 1847 | 20 |
1565776 | 1565776 | 2021-07-29 | Grundy | Tennessee | 47061 | 1847 | 35 |
1551231 | 1551231 | 2021-07-25 | Anderson | Kentucky | 21005 | 1847 | 23 |
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);