ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
181 rows where cases = 2360 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 18
- Texas 15
- Virginia 15
- Georgia 13
- Arkansas 8
- Louisiana 8
- Mississippi 8
- Missouri 8
- Minnesota 7
- Puerto Rico 7
- Illinois 5
- Tennessee 5
- Alaska 4
- Idaho 4
- Indiana 4
- New York 4
- West Virginia 4
- California 3
- Kansas 3
- Maryland 3
- Michigan 3
- North Carolina 3
- North Dakota 3
- Ohio 3
- Florida 2
- Iowa 2
- Massachusetts 2
- Oklahoma 2
- Pennsylvania 2
- South Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463517 | 2463517 | 2022-05-01 | Poquoson city | Virginia | 51735 | 2360 | 30 |
2460261 | 2460261 | 2022-04-30 | Poquoson city | Virginia | 51735 | 2360 | 30 |
2457005 | 2457005 | 2022-04-29 | Poquoson city | Virginia | 51735 | 2360 | 30 |
2398186 | 2398186 | 2022-04-11 | Parmer | Texas | 48369 | 2360 | 52 |
2393212 | 2393212 | 2022-04-10 | Owen | Kentucky | 21187 | 2360 | 33 |
2394931 | 2394931 | 2022-04-10 | Parmer | Texas | 48369 | 2360 | 52 |
2389956 | 2389956 | 2022-04-09 | Owen | Kentucky | 21187 | 2360 | 33 |
2391675 | 2391675 | 2022-04-09 | Parmer | Texas | 48369 | 2360 | 52 |
2386700 | 2386700 | 2022-04-08 | Owen | Kentucky | 21187 | 2360 | 33 |
2388419 | 2388419 | 2022-04-08 | Parmer | Texas | 48369 | 2360 | 52 |
2383445 | 2383445 | 2022-04-07 | Owen | Kentucky | 21187 | 2360 | 33 |
2385164 | 2385164 | 2022-04-07 | Parmer | Texas | 48369 | 2360 | 52 |
2380190 | 2380190 | 2022-04-06 | Owen | Kentucky | 21187 | 2360 | 33 |
2381909 | 2381909 | 2022-04-06 | Parmer | Texas | 48369 | 2360 | 52 |
2376935 | 2376935 | 2022-04-05 | Owen | Kentucky | 21187 | 2360 | 33 |
2373683 | 2373683 | 2022-04-04 | Owen | Kentucky | 21187 | 2360 | 33 |
2372338 | 2372338 | 2022-04-03 | Lunenburg | Virginia | 51111 | 2360 | 36 |
2369085 | 2369085 | 2022-04-02 | Lunenburg | Virginia | 51111 | 2360 | 36 |
2365832 | 2365832 | 2022-04-01 | Lunenburg | Virginia | 51111 | 2360 | 36 |
2288614 | 2288614 | 2022-03-09 | Washington | Idaho | 16087 | 2360 | 56 |
2271450 | 2271450 | 2022-03-03 | Charlotte | Virginia | 51037 | 2360 | 43 |
2259273 | 2259273 | 2022-02-28 | Towns | Georgia | 13281 | 2360 | 100 |
2244850 | 2244850 | 2022-02-23 | Florida | Puerto Rico | 72054 | 2360 | |
2241599 | 2241599 | 2022-02-22 | Florida | Puerto Rico | 72054 | 2360 | |
2236423 | 2236423 | 2022-02-21 | Dooly | Georgia | 13093 | 2360 | 66 |
2238348 | 2238348 | 2022-02-21 | Florida | Puerto Rico | 72054 | 2360 | |
2182285 | 2182285 | 2022-02-04 | Ralls | Missouri | 29173 | 2360 | 19 |
2173343 | 2173343 | 2022-02-01 | Santa Isabel | Puerto Rico | 72133 | 2360 | |
2151949 | 2151949 | 2022-01-26 | Turner | Georgia | 13287 | 2360 | 50 |
2107349 | 2107349 | 2022-01-12 | Perry | Mississippi | 28111 | 2360 | 57 |
2097543 | 2097543 | 2022-01-09 | Amite | Mississippi | 28005 | 2360 | 59 |
2094291 | 2094291 | 2022-01-08 | Amite | Mississippi | 28005 | 2360 | 59 |
2091039 | 2091039 | 2022-01-07 | Amite | Mississippi | 28005 | 2360 | 59 |
2091657 | 2091657 | 2022-01-07 | Mountrail | North Dakota | 38061 | 2360 | 32 |
2074495 | 2074495 | 2022-01-02 | Caldwell | Louisiana | 22021 | 2360 | 42 |
2071244 | 2071244 | 2022-01-01 | Caldwell | Louisiana | 22021 | 2360 | 42 |
2067993 | 2067993 | 2021-12-31 | Caldwell | Louisiana | 22021 | 2360 | 42 |
2064742 | 2064742 | 2021-12-30 | Caldwell | Louisiana | 22021 | 2360 | 42 |
2035060 | 2035060 | 2021-12-21 | Washington | Illinois | 17189 | 2360 | 36 |
2034344 | 2034344 | 2021-12-20 | Converse | Wyoming | 56009 | 2360 | 46 |
2019901 | 2019901 | 2021-12-16 | Unknown | New Hampshire | 2360 | 16 | |
2013344 | 2013344 | 2021-12-14 | Otoe | Nebraska | 31131 | 2360 | 16 |
1991329 | 1991329 | 2021-12-07 | Clay | South Dakota | 46027 | 2360 | 17 |
1962272 | 1962272 | 2021-11-28 | Comanche | Texas | 48093 | 2360 | 66 |
1959021 | 1959021 | 2021-11-27 | Comanche | Texas | 48093 | 2360 | 66 |
1955770 | 1955770 | 2021-11-26 | Comanche | Texas | 48093 | 2360 | 66 |
1952519 | 1952519 | 2021-11-25 | Comanche | Texas | 48093 | 2360 | 66 |
1949268 | 1949268 | 2021-11-24 | Comanche | Texas | 48093 | 2360 | 66 |
1929134 | 1929134 | 2021-11-18 | Ramsey | North Dakota | 38071 | 2360 | 38 |
1922226 | 1922226 | 2021-11-16 | Glacier | Montana | 30035 | 2360 | 57 |
1903475 | 1903475 | 2021-11-10 | Manati | Puerto Rico | 72091 | 2360 | |
1882242 | 1882242 | 2021-11-04 | Johnson | Illinois | 17087 | 2360 | 38 |
1878548 | 1878548 | 2021-11-03 | Inyo | California | 6027 | 2360 | 41 |
1877131 | 1877131 | 2021-11-02 | McKenzie | North Dakota | 38053 | 2360 | 21 |
1877967 | 1877967 | 2021-11-02 | Wilbarger | Texas | 48487 | 2360 | 62 |
1869956 | 1869956 | 2021-10-31 | Houston | Minnesota | 27055 | 2360 | 17 |
1866707 | 1866707 | 2021-10-30 | Houston | Minnesota | 27055 | 2360 | 17 |
1863458 | 1863458 | 2021-10-29 | Houston | Minnesota | 27055 | 2360 | 17 |
1859917 | 1859917 | 2021-10-28 | Larue | Kentucky | 21123 | 2360 | 47 |
1860744 | 1860744 | 2021-10-28 | Schoharie | New York | 36095 | 2360 | 23 |
1826440 | 1826440 | 2021-10-18 | Kodiak Island Borough | Alaska | 2150 | 2360 | 7 |
1826970 | 1826970 | 2021-10-18 | Carroll | Illinois | 17015 | 2360 | 39 |
1823191 | 1823191 | 2021-10-17 | Kodiak Island Borough | Alaska | 2150 | 2360 | 7 |
1826154 | 1826154 | 2021-10-17 | Southampton | Virginia | 51175 | 2360 | 63 |
1819942 | 1819942 | 2021-10-16 | Kodiak Island Borough | Alaska | 2150 | 2360 | 7 |
1822905 | 1822905 | 2021-10-16 | Southampton | Virginia | 51175 | 2360 | 63 |
1816693 | 1816693 | 2021-10-15 | Kodiak Island Borough | Alaska | 2150 | 2360 | 7 |
1818216 | 1818216 | 2021-10-15 | Ste. Genevieve | Missouri | 29186 | 2360 | 29 |
1819532 | 1819532 | 2021-10-15 | Orleans | Vermont | 50019 | 2360 | 13 |
1819656 | 1819656 | 2021-10-15 | Southampton | Virginia | 51175 | 2360 | 63 |
1790763 | 1790763 | 2021-10-07 | Howard | Arkansas | 5061 | 2360 | 30 |
1768929 | 1768929 | 2021-09-30 | Henry | Kentucky | 21103 | 2360 | 23 |
1758001 | 1758001 | 2021-09-26 | Lincoln | West Virginia | 54043 | 2360 | 33 |
1734535 | 1734535 | 2021-09-19 | San Lorenzo | Puerto Rico | 72129 | 2360 | |
1720721 | 1720721 | 2021-09-15 | Pike | Missouri | 29163 | 2360 | 31 |
1713259 | 1713259 | 2021-09-13 | Clark | Illinois | 17023 | 2360 | 45 |
1702036 | 1702036 | 2021-09-09 | Moca | Puerto Rico | 72099 | 2360 | |
1693278 | 1693278 | 2021-09-07 | Clay | Arkansas | 5021 | 2360 | 52 |
1692852 | 1692852 | 2021-09-06 | Buckingham | Virginia | 51029 | 2360 | 34 |
1674360 | 1674360 | 2021-09-01 | Wayne | Illinois | 17191 | 2360 | 55 |
1675612 | 1675612 | 2021-09-01 | Hertford | North Carolina | 37091 | 2360 | 65 |
1657199 | 1657199 | 2021-08-26 | Prince Edward | Virginia | 51147 | 2360 | 38 |
1625428 | 1625428 | 2021-08-17 | Meriwether | Georgia | 13199 | 2360 | 93 |
1626459 | 1626459 | 2021-08-17 | Clinton | Missouri | 29049 | 2360 | 68 |
1626525 | 1626525 | 2021-08-17 | Ray | Missouri | 29177 | 2360 | 37 |
1619561 | 1619561 | 2021-08-15 | Wayne | Kentucky | 21231 | 2360 | 51 |
1616313 | 1616313 | 2021-08-14 | Wayne | Kentucky | 21231 | 2360 | 51 |
1608490 | 1608490 | 2021-08-11 | Salem city | Virginia | 51775 | 2360 | 50 |
1608568 | 1608568 | 2021-08-11 | Jackson | West Virginia | 54035 | 2360 | 62 |
1576400 | 1576400 | 2021-08-02 | Calaveras | California | 6009 | 2360 | 58 |
1568615 | 1568615 | 2021-07-30 | Wyandot | Ohio | 39175 | 2360 | 57 |
1564823 | 1564823 | 2021-07-29 | Texas | Missouri | 29215 | 2360 | 27 |
1565983 | 1565983 | 2021-07-29 | Lampasas | Texas | 48281 | 2360 | 36 |
1560695 | 1560695 | 2021-07-28 | Fountain | Indiana | 18045 | 2360 | 51 |
1556293 | 1556293 | 2021-07-26 | Reeves | Texas | 48389 | 2360 | 44 |
1550353 | 1550353 | 2021-07-25 | Conway | Arkansas | 5029 | 2360 | 36 |
1553046 | 1553046 | 2021-07-25 | Reeves | Texas | 48389 | 2360 | 44 |
1539200 | 1539200 | 2021-07-21 | Martin | North Carolina | 37117 | 2360 | 46 |
1535199 | 1535199 | 2021-07-20 | Caroline | Maryland | 24011 | 2360 | 30 |
1531951 | 1531951 | 2021-07-19 | Caroline | Maryland | 24011 | 2360 | 30 |
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);