ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
192 rows where cases = 2460 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 13
- Texas 13
- Georgia 12
- Virginia 12
- Louisiana 11
- Mississippi 10
- Tennessee 10
- Indiana 8
- Alabama 7
- Colorado 7
- Iowa 7
- Puerto Rico 7
- Utah 7
- Arizona 6
- Illinois 6
- Missouri 6
- Arkansas 5
- Ohio 5
- Nebraska 4
- South Dakota 4
- West Virginia 4
- Wisconsin 4
- New York 3
- Kansas 2
- Montana 2
- New Mexico 2
- Oklahoma 2
- Pennsylvania 2
- South Carolina 2
- Washington 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502582 | 2502582 | 2022-05-13 | Lunenburg | Virginia | 51111 | 2460 | 39 |
2499467 | 2499467 | 2022-05-12 | Ritchie | West Virginia | 54085 | 2460 | 31 |
2496209 | 2496209 | 2022-05-11 | Ritchie | West Virginia | 54085 | 2460 | 31 |
2375540 | 2375540 | 2022-04-04 | Charlotte | Virginia | 51037 | 2460 | 45 |
2360063 | 2360063 | 2022-03-31 | McIntosh | Georgia | 13191 | 2460 | 35 |
2349538 | 2349538 | 2022-03-27 | Franklin city | Virginia | 51620 | 2460 | 52 |
2346285 | 2346285 | 2022-03-26 | Franklin city | Virginia | 51620 | 2460 | 52 |
2342438 | 2342438 | 2022-03-25 | Luquillo | Puerto Rico | 72089 | 2460 | |
2343032 | 2343032 | 2022-03-25 | Franklin city | Virginia | 51620 | 2460 | 52 |
2339185 | 2339185 | 2022-03-24 | Luquillo | Puerto Rico | 72089 | 2460 | |
2335931 | 2335931 | 2022-03-23 | Luquillo | Puerto Rico | 72089 | 2460 | |
2328581 | 2328581 | 2022-03-21 | Grundy | Missouri | 29079 | 2460 | 67 |
2308386 | 2308386 | 2022-03-15 | Mitchell | Iowa | 19131 | 2460 | 50 |
2305135 | 2305135 | 2022-03-14 | Mitchell | Iowa | 19131 | 2460 | 50 |
2301883 | 2301883 | 2022-03-13 | Mitchell | Iowa | 19131 | 2460 | 50 |
2303910 | 2303910 | 2022-03-13 | Emery | Utah | 49015 | 2460 | 28 |
2298631 | 2298631 | 2022-03-12 | Mitchell | Iowa | 19131 | 2460 | 50 |
2300658 | 2300658 | 2022-03-12 | Emery | Utah | 49015 | 2460 | 28 |
2295379 | 2295379 | 2022-03-11 | Mitchell | Iowa | 19131 | 2460 | 50 |
2297406 | 2297406 | 2022-03-11 | Emery | Utah | 49015 | 2460 | 28 |
2292127 | 2292127 | 2022-03-10 | Mitchell | Iowa | 19131 | 2460 | 50 |
2294154 | 2294154 | 2022-03-10 | Emery | Utah | 49015 | 2460 | 28 |
2288875 | 2288875 | 2022-03-09 | Mitchell | Iowa | 19131 | 2460 | 50 |
2290902 | 2290902 | 2022-03-09 | Emery | Utah | 49015 | 2460 | 28 |
2287849 | 2287849 | 2022-03-08 | Pend Oreille | Washington | 53051 | 2460 | 32 |
2284597 | 2284597 | 2022-03-07 | Pend Oreille | Washington | 53051 | 2460 | 32 |
2256201 | 2256201 | 2022-02-27 | Benton | Indiana | 18007 | 2460 | 21 |
2252950 | 2252950 | 2022-02-26 | Benton | Indiana | 18007 | 2460 | 21 |
2249699 | 2249699 | 2022-02-25 | Benton | Indiana | 18007 | 2460 | 21 |
2217513 | 2217513 | 2022-02-15 | Edmonson | Kentucky | 21061 | 2460 | 38 |
2195347 | 2195347 | 2022-02-08 | Jefferson | Montana | 30043 | 2460 | 23 |
2187499 | 2187499 | 2022-02-06 | Prowers | Colorado | 8099 | 2460 | 45 |
2184246 | 2184246 | 2022-02-05 | Prowers | Colorado | 8099 | 2460 | 45 |
2180994 | 2180994 | 2022-02-04 | Prowers | Colorado | 8099 | 2460 | 45 |
2170702 | 2170702 | 2022-01-31 | Nelson | Virginia | 51125 | 2460 | 25 |
2164732 | 2164732 | 2022-01-30 | Rio Grande | Colorado | 8105 | 2460 | 41 |
2158221 | 2158221 | 2022-01-28 | Rio Grande | Colorado | 8105 | 2460 | 41 |
2132555 | 2132555 | 2022-01-20 | Marshall | Illinois | 17123 | 2460 | 28 |
2128046 | 2128046 | 2022-01-18 | Camp | Texas | 48063 | 2460 | 69 |
2105018 | 2105018 | 2022-01-11 | Quebradillas | Puerto Rico | 72115 | 2460 | |
2097147 | 2097147 | 2022-01-09 | Carroll | Kentucky | 21041 | 2460 | 38 |
2093895 | 2093895 | 2022-01-08 | Carroll | Kentucky | 21041 | 2460 | 38 |
2095247 | 2095247 | 2022-01-08 | Lares | Puerto Rico | 72081 | 2460 | |
2090202 | 2090202 | 2022-01-07 | Gooding | Idaho | 16047 | 2460 | 44 |
2090643 | 2090643 | 2022-01-07 | Carroll | Kentucky | 21041 | 2460 | 38 |
2075839 | 2075839 | 2022-01-02 | Clay | South Dakota | 46027 | 2460 | 17 |
2072588 | 2072588 | 2022-01-01 | Clay | South Dakota | 46027 | 2460 | 17 |
2069337 | 2069337 | 2021-12-31 | Clay | South Dakota | 46027 | 2460 | 17 |
2066086 | 2066086 | 2021-12-30 | Clay | South Dakota | 46027 | 2460 | 17 |
2051016 | 2051016 | 2021-12-26 | Brooks | Georgia | 13027 | 2460 | 74 |
2053543 | 2053543 | 2021-12-26 | Alleghany | Virginia | 51005 | 2460 | 86 |
2047766 | 2047766 | 2021-12-25 | Brooks | Georgia | 13027 | 2460 | 74 |
2050293 | 2050293 | 2021-12-25 | Alleghany | Virginia | 51005 | 2460 | 86 |
2044516 | 2044516 | 2021-12-24 | Brooks | Georgia | 13027 | 2460 | 74 |
2047043 | 2047043 | 2021-12-24 | Alleghany | Virginia | 51005 | 2460 | 86 |
2038245 | 2038245 | 2021-12-22 | Greene | Illinois | 17061 | 2460 | 53 |
2027743 | 2027743 | 2021-12-18 | Monroe | West Virginia | 54063 | 2460 | 29 |
2009024 | 2009024 | 2021-12-13 | Mercer | Illinois | 17131 | 2460 | 37 |
1993296 | 1993296 | 2021-12-08 | Knox | Maine | 23013 | 2460 | 17 |
1970440 | 1970440 | 2021-12-01 | Monroe | Kentucky | 21171 | 2460 | 64 |
1971996 | 1971996 | 2021-12-01 | Bosque | Texas | 48035 | 2460 | 57 |
1938608 | 1938608 | 2021-11-21 | York | Nebraska | 31185 | 2460 | 19 |
1935358 | 1935358 | 2021-11-20 | York | Nebraska | 31185 | 2460 | 19 |
1932108 | 1932108 | 2021-11-19 | York | Nebraska | 31185 | 2460 | 19 |
1907511 | 1907511 | 2021-11-11 | Crawford | Wisconsin | 55023 | 2460 | 23 |
1850225 | 1850225 | 2021-10-25 | Webster | Kentucky | 21233 | 2460 | 35 |
1846485 | 1846485 | 2021-10-24 | Ford | Illinois | 17053 | 2460 | 67 |
1843235 | 1843235 | 2021-10-23 | Ford | Illinois | 17053 | 2460 | 67 |
1839985 | 1839985 | 2021-10-22 | Ford | Illinois | 17053 | 2460 | 67 |
1842158 | 1842158 | 2021-10-22 | Nolan | Texas | 48353 | 2460 | 75 |
1838909 | 1838909 | 2021-10-21 | Nolan | Texas | 48353 | 2460 | 75 |
1829764 | 1829764 | 2021-10-19 | Madison | Arkansas | 5087 | 2460 | 37 |
1826030 | 1826030 | 2021-10-17 | Orleans | Vermont | 50019 | 2460 | 13 |
1767940 | 1767940 | 2021-09-30 | Washington | Alabama | 1129 | 2460 | 49 |
1767505 | 1767505 | 2021-09-29 | Zavala | Texas | 48507 | 2460 | 52 |
1763082 | 1763082 | 2021-09-28 | Gage | Nebraska | 31067 | 2460 | 20 |
1719906 | 1719906 | 2021-09-15 | Perry | Indiana | 18123 | 2460 | 52 |
1720969 | 1720969 | 2021-09-15 | Lincoln | New Mexico | 35027 | 2460 | 26 |
1717527 | 1717527 | 2021-09-14 | Hill | Montana | 30041 | 2460 | 48 |
1696033 | 1696033 | 2021-09-07 | Young | Texas | 48503 | 2460 | 51 |
1692785 | 1692785 | 2021-09-06 | Young | Texas | 48503 | 2460 | 51 |
1689536 | 1689536 | 2021-09-05 | Young | Texas | 48503 | 2460 | 51 |
1686286 | 1686286 | 2021-09-04 | Young | Texas | 48503 | 2460 | 51 |
1682993 | 1682993 | 2021-09-03 | Shelby | Texas | 48419 | 2460 | 80 |
1673207 | 1673207 | 2021-08-31 | Montague | Texas | 48337 | 2460 | 76 |
1663975 | 1663975 | 2021-08-29 | Randolph | Alabama | 1111 | 2460 | 53 |
1655673 | 1655673 | 2021-08-26 | Andrew | Missouri | 29003 | 2460 | 23 |
1638069 | 1638069 | 2021-08-21 | Grant | Arkansas | 5053 | 2460 | 41 |
1627470 | 1627470 | 2021-08-17 | Bledsoe | Tennessee | 47007 | 2460 | 13 |
1623268 | 1623268 | 2021-08-16 | Perry | Missouri | 29157 | 2460 | 30 |
1624459 | 1624459 | 2021-08-16 | Lee | Texas | 48287 | 2460 | 40 |
1620021 | 1620021 | 2021-08-15 | Perry | Missouri | 29157 | 2460 | 30 |
1606869 | 1606869 | 2021-08-11 | Attala | Mississippi | 28007 | 2460 | 74 |
1602978 | 1602978 | 2021-08-10 | Spencer | Indiana | 18147 | 2460 | 31 |
1582832 | 1582832 | 2021-08-04 | Conway | Arkansas | 5029 | 2460 | 36 |
1576178 | 1576178 | 2021-08-01 | Vilas | Wisconsin | 55125 | 2460 | 45 |
1571840 | 1571840 | 2021-07-31 | Pike | Ohio | 39131 | 2460 | 37 |
1572930 | 1572930 | 2021-07-31 | Vilas | Wisconsin | 55125 | 2460 | 45 |
1569682 | 1569682 | 2021-07-30 | Vilas | Wisconsin | 55125 | 2460 | 45 |
1541555 | 1541555 | 2021-07-22 | Lincoln | Kentucky | 21137 | 2460 | 60 |
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);