ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
191 rows where cases = 3159 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 19
- Oklahoma 19
- Texas 13
- Iowa 10
- Tennessee 9
- Virginia 9
- Kentucky 7
- New York 7
- Arkansas 6
- Louisiana 6
- Ohio 6
- Alabama 5
- Florida 5
- Kansas 5
- Mississippi 5
- North Carolina 5
- Utah 5
- West Virginia 5
- Wisconsin 5
- Minnesota 4
- Illinois 3
- Indiana 3
- Michigan 3
- Montana 3
- Oregon 3
- Puerto Rico 3
- California 2
- Colorado 2
- Pennsylvania 2
- South Carolina 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492884 | 2492884 | 2022-05-10 | Jefferson | Washington | 53031 | 3159 | 28 |
2489626 | 2489626 | 2022-05-09 | Jefferson | Washington | 53031 | 3159 | 28 |
2408285 | 2408285 | 2022-04-14 | Roane | West Virginia | 54087 | 3159 | 36 |
2405029 | 2405029 | 2022-04-13 | Roane | West Virginia | 54087 | 3159 | 36 |
2368462 | 2368462 | 2022-04-02 | Loiza | Puerto Rico | 72087 | 3159 | |
2281941 | 2281941 | 2022-03-07 | Dade | Georgia | 13083 | 3159 | 28 |
2215266 | 2215266 | 2022-02-14 | Mountrail | North Dakota | 38061 | 3159 | 34 |
2200023 | 2200023 | 2022-02-09 | Westmoreland | Virginia | 51193 | 3159 | 42 |
2194846 | 2194846 | 2022-02-08 | Claiborne | Louisiana | 22027 | 3159 | 68 |
2190099 | 2190099 | 2022-02-06 | Millard | Utah | 49027 | 3159 | 32 |
2186846 | 2186846 | 2022-02-05 | Millard | Utah | 49027 | 3159 | 32 |
2183593 | 2183593 | 2022-02-04 | Millard | Utah | 49027 | 3159 | 32 |
2173987 | 2173987 | 2022-02-01 | Southampton | Virginia | 51175 | 3159 | 75 |
2156068 | 2156068 | 2022-01-27 | Sibley | Minnesota | 27143 | 3159 | 23 |
2153840 | 2153840 | 2022-01-26 | Bamberg | South Carolina | 45009 | 3159 | 66 |
2133013 | 2133013 | 2022-01-20 | Webster | Kentucky | 21233 | 3159 | 46 |
2130290 | 2130290 | 2022-01-19 | Park | Montana | 30067 | 3159 | 32 |
2128059 | 2128059 | 2022-01-18 | Colorado | Texas | 48089 | 3159 | 57 |
2080704 | 2080704 | 2022-01-04 | Hardin | Iowa | 19083 | 3159 | 55 |
2077452 | 2077452 | 2022-01-03 | Hardin | Iowa | 19083 | 3159 | 55 |
2079449 | 2079449 | 2022-01-03 | Shelby | Texas | 48419 | 3159 | 114 |
2074201 | 2074201 | 2022-01-02 | Hardin | Iowa | 19083 | 3159 | 55 |
2070950 | 2070950 | 2022-01-01 | Hardin | Iowa | 19083 | 3159 | 55 |
2067699 | 2067699 | 2021-12-31 | Hardin | Iowa | 19083 | 3159 | 55 |
2064448 | 2064448 | 2021-12-30 | Hardin | Iowa | 19083 | 3159 | 55 |
2061198 | 2061198 | 2021-12-29 | Hardin | Iowa | 19083 | 3159 | 55 |
2047501 | 2047501 | 2021-12-25 | Hempstead | Arkansas | 5057 | 3159 | 46 |
2018659 | 2018659 | 2021-12-16 | Worth | Georgia | 13321 | 3159 | 96 |
2017224 | 2017224 | 2021-12-15 | Gurabo | Puerto Rico | 72063 | 3159 | |
2014495 | 2014495 | 2021-12-14 | Duchesne | Utah | 49013 | 3159 | 21 |
1993966 | 1993966 | 2021-12-08 | Essex | New York | 36031 | 3159 | 41 |
1994472 | 1994472 | 2021-12-08 | Humacao | Puerto Rico | 72069 | 3159 | |
1988396 | 1988396 | 2021-12-06 | Montague | Texas | 48337 | 3159 | 98 |
1969530 | 1969530 | 2021-12-01 | Sharp | Arkansas | 5135 | 3159 | 70 |
1916330 | 1916330 | 2021-11-14 | Crook | Oregon | 41013 | 3159 | 54 |
1913080 | 1913080 | 2021-11-13 | Crook | Oregon | 41013 | 3159 | 54 |
1909830 | 1909830 | 2021-11-12 | Crook | Oregon | 41013 | 3159 | 54 |
1894788 | 1894788 | 2021-11-08 | Colusa | California | 6011 | 3159 | 20 |
1881630 | 1881630 | 2021-11-04 | Henry | Alabama | 1067 | 3159 | 66 |
1877713 | 1877713 | 2021-11-02 | Unicoi | Tennessee | 47171 | 3159 | 65 |
1874811 | 1874811 | 2021-11-01 | Dinwiddie | Virginia | 51053 | 3159 | 52 |
1858372 | 1858372 | 2021-10-27 | Lavaca | Texas | 48285 | 3159 | 96 |
1853085 | 1853085 | 2021-10-26 | Fulton | Indiana | 18049 | 3159 | 68 |
1853366 | 1853366 | 2021-10-26 | Bourbon | Kentucky | 21017 | 3159 | 35 |
1855123 | 1855123 | 2021-10-26 | Lavaca | Texas | 48285 | 3159 | 95 |
1852219 | 1852219 | 2021-10-25 | Hampshire | West Virginia | 54027 | 3159 | 48 |
1830718 | 1830718 | 2021-10-19 | Simpson | Kentucky | 21213 | 3159 | 52 |
1830879 | 1830879 | 2021-10-19 | Gladwin | Michigan | 26051 | 3159 | 69 |
1827630 | 1827630 | 2021-10-18 | Gladwin | Michigan | 26051 | 3159 | 69 |
1815006 | 1815006 | 2021-10-14 | Lincoln | Montana | 30053 | 3159 | 52 |
1815936 | 1815936 | 2021-10-14 | Humphreys | Tennessee | 47085 | 3159 | 44 |
1807032 | 1807032 | 2021-10-12 | Phillips | Arkansas | 5107 | 3159 | 76 |
1809700 | 1809700 | 2021-10-12 | Scurry | Texas | 48415 | 3159 | 81 |
1803737 | 1803737 | 2021-10-11 | Clark | Arkansas | 5019 | 3159 | 54 |
1791064 | 1791064 | 2021-10-07 | Elbert | Georgia | 13105 | 3159 | 81 |
1781382 | 1781382 | 2021-10-04 | Putnam | Georgia | 13237 | 3159 | 74 |
1781527 | 1781527 | 2021-10-04 | Lawrence | Illinois | 17101 | 3159 | 41 |
1782097 | 1782097 | 2021-10-04 | Somerset | Maryland | 24039 | 3159 | 47 |
1780632 | 1780632 | 2021-10-03 | Mecklenburg | Virginia | 51117 | 3159 | 75 |
1777382 | 1777382 | 2021-10-02 | Mecklenburg | Virginia | 51117 | 3159 | 75 |
1774132 | 1774132 | 2021-10-01 | Mecklenburg | Virginia | 51117 | 3159 | 75 |
1765408 | 1765408 | 2021-09-29 | Sullivan | Indiana | 18153 | 3159 | 51 |
1767807 | 1767807 | 2021-09-29 | Jackson | Wisconsin | 55053 | 3159 | 31 |
1738383 | 1738383 | 2021-09-20 | Lee | Virginia | 51105 | 3159 | 51 |
1734008 | 1734008 | 2021-09-19 | Lewis | New York | 36049 | 3159 | 36 |
1734712 | 1734712 | 2021-09-19 | Johnson | Tennessee | 47091 | 3159 | 43 |
1731462 | 1731462 | 2021-09-18 | Johnson | Tennessee | 47091 | 3159 | 43 |
1728212 | 1728212 | 2021-09-17 | Johnson | Tennessee | 47091 | 3159 | 43 |
1716367 | 1716367 | 2021-09-14 | Lamar | Georgia | 13171 | 3159 | 73 |
1718424 | 1718424 | 2021-09-14 | Bledsoe | Tennessee | 47007 | 3159 | 13 |
1693548 | 1693548 | 2021-09-07 | Appling | Georgia | 13001 | 3159 | 79 |
1674097 | 1674097 | 2021-09-01 | Dodge | Georgia | 13091 | 3159 | 112 |
1674732 | 1674732 | 2021-09-01 | Lincoln | Kentucky | 21137 | 3159 | 64 |
1654409 | 1654409 | 2021-08-26 | Siskiyou | California | 6093 | 3159 | 40 |
1656731 | 1656731 | 2021-08-26 | Grainger | Tennessee | 47057 | 3159 | 52 |
1649897 | 1649897 | 2021-08-24 | Seminole | Oklahoma | 40133 | 3159 | 79 |
1646648 | 1646648 | 2021-08-23 | Seminole | Oklahoma | 40133 | 3159 | 79 |
1643399 | 1643399 | 2021-08-22 | Seminole | Oklahoma | 40133 | 3159 | 79 |
1640149 | 1640149 | 2021-08-21 | Seminole | Oklahoma | 40133 | 3159 | 79 |
1636899 | 1636899 | 2021-08-20 | Seminole | Oklahoma | 40133 | 3159 | 79 |
1633649 | 1633649 | 2021-08-19 | Seminole | Oklahoma | 40133 | 3159 | 79 |
1634573 | 1634573 | 2021-08-19 | Randolph | West Virginia | 54083 | 3159 | 18 |
1630402 | 1630402 | 2021-08-18 | Seminole | Oklahoma | 40133 | 3159 | 79 |
1624931 | 1624931 | 2021-08-16 | Park | Wyoming | 56029 | 3159 | 35 |
1602462 | 1602462 | 2021-08-10 | Delta | Colorado | 8029 | 3159 | 74 |
1604525 | 1604525 | 2021-08-10 | Tioga | Pennsylvania | 42117 | 3159 | 113 |
1495084 | 1495084 | 2021-07-08 | Pike | Alabama | 1109 | 3159 | 78 |
1491837 | 1491837 | 2021-07-07 | Pike | Alabama | 1109 | 3159 | 78 |
1468679 | 1468679 | 2021-06-29 | Willacy | Texas | 48489 | 3159 | 91 |
1445055 | 1445055 | 2021-06-22 | Macon | North Carolina | 37113 | 3159 | 41 |
1419087 | 1419087 | 2021-06-14 | Macon | North Carolina | 37113 | 3159 | 41 |
1415782 | 1415782 | 2021-06-13 | Washington | New York | 36115 | 3159 | 55 |
1412189 | 1412189 | 2021-06-12 | Lafayette | Missouri | 29107 | 3159 | 57 |
1412536 | 1412536 | 2021-06-12 | Washington | New York | 36115 | 3159 | 55 |
1409291 | 1409291 | 2021-06-11 | Washington | New York | 36115 | 3159 | 55 |
1398174 | 1398174 | 2021-06-08 | Stephens | Georgia | 13257 | 3159 | 80 |
1373791 | 1373791 | 2021-05-31 | Jackson | Ohio | 39079 | 3159 | 53 |
1374426 | 1374426 | 2021-05-31 | Hopkins | Texas | 48223 | 3159 | 112 |
1370546 | 1370546 | 2021-05-30 | Jackson | Ohio | 39079 | 3159 | 53 |
1367300 | 1367300 | 2021-05-29 | Jackson | Ohio | 39079 | 3159 | 53 |
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);