ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
242 rows where cases = 2199 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 18
- Virginia 15
- Georgia 14
- Minnesota 11
- North Carolina 11
- Texas 11
- West Virginia 11
- Nebraska 10
- Arkansas 9
- Indiana 9
- Kansas 9
- Kentucky 9
- Oklahoma 9
- Puerto Rico 9
- Colorado 8
- Idaho 8
- Missouri 8
- Arizona 5
- Florida 5
- Ohio 5
- Tennessee 5
- Montana 4
- Wyoming 4
- Illinois 3
- Louisiana 3
- New York 3
- South Carolina 3
- Washington 3
- Alabama 2
- California 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499857 | 2499857 | 2022-05-13 | Lincoln | Colorado | 8073 | 2199 | 9 |
2496599 | 2496599 | 2022-05-12 | Lincoln | Colorado | 8073 | 2199 | 9 |
2375737 | 2375737 | 2022-04-04 | Tyler | West Virginia | 54095 | 2199 | 31 |
2372485 | 2372485 | 2022-04-03 | Tyler | West Virginia | 54095 | 2199 | 31 |
2369232 | 2369232 | 2022-04-02 | Tyler | West Virginia | 54095 | 2199 | 31 |
2365979 | 2365979 | 2022-04-01 | Tyler | West Virginia | 54095 | 2199 | 31 |
2326127 | 2326127 | 2022-03-20 | Adjuntas | Puerto Rico | 72001 | 2199 | |
2322874 | 2322874 | 2022-03-19 | Adjuntas | Puerto Rico | 72001 | 2199 | |
2302979 | 2302979 | 2022-03-13 | Jones | North Carolina | 37103 | 2199 | 38 |
2299727 | 2299727 | 2022-03-12 | Jones | North Carolina | 37103 | 2199 | 38 |
2296475 | 2296475 | 2022-03-11 | Jones | North Carolina | 37103 | 2199 | 38 |
2279682 | 2279682 | 2022-03-06 | Choctaw | Mississippi | 28019 | 2199 | 33 |
2276429 | 2276429 | 2022-03-05 | Choctaw | Mississippi | 28019 | 2199 | 33 |
2273176 | 2273176 | 2022-03-04 | Choctaw | Mississippi | 28019 | 2199 | 33 |
2269924 | 2269924 | 2022-03-03 | Choctaw | Mississippi | 28019 | 2199 | 33 |
2266671 | 2266671 | 2022-03-02 | Choctaw | Mississippi | 28019 | 2199 | 33 |
2262096 | 2262096 | 2022-03-01 | Greenlee | Arizona | 4011 | 2199 | 32 |
2258845 | 2258845 | 2022-02-28 | Greenlee | Arizona | 4011 | 2199 | 32 |
2255594 | 2255594 | 2022-02-27 | Greenlee | Arizona | 4011 | 2199 | 32 |
2252343 | 2252343 | 2022-02-26 | Greenlee | Arizona | 4011 | 2199 | 32 |
2249092 | 2249092 | 2022-02-25 | Greenlee | Arizona | 4011 | 2199 | 32 |
2241633 | 2241633 | 2022-02-22 | Sabana Grande | Puerto Rico | 72121 | 2199 | |
2238382 | 2238382 | 2022-02-21 | Sabana Grande | Puerto Rico | 72121 | 2199 | |
2235131 | 2235131 | 2022-02-20 | Sabana Grande | Puerto Rico | 72121 | 2199 | |
2223285 | 2223285 | 2022-02-17 | San Miguel | Colorado | 8113 | 2199 | 7 |
2224722 | 2224722 | 2022-02-17 | Phelps | Nebraska | 31137 | 2199 | 12 |
2215173 | 2215173 | 2022-02-14 | Graham | North Carolina | 37075 | 2199 | 30 |
2216196 | 2216196 | 2022-02-14 | Essex | Virginia | 51057 | 2199 | 24 |
2171192 | 2171192 | 2022-02-01 | Bent | Colorado | 8011 | 2199 | 46 |
2157759 | 2157759 | 2022-01-27 | Pend Oreille | Washington | 53051 | 2199 | 28 |
2154506 | 2154506 | 2022-01-26 | Pend Oreille | Washington | 53051 | 2199 | 28 |
2143021 | 2143021 | 2022-01-23 | Koochiching | Minnesota | 27071 | 2199 | 32 |
2143633 | 2143633 | 2022-01-23 | Pamlico | North Carolina | 37137 | 2199 | 27 |
2139766 | 2139766 | 2022-01-22 | Koochiching | Minnesota | 27071 | 2199 | 32 |
2139989 | 2139989 | 2022-01-22 | Ralls | Missouri | 29173 | 2199 | 19 |
2140378 | 2140378 | 2022-01-22 | Pamlico | North Carolina | 37137 | 2199 | 27 |
2136510 | 2136510 | 2022-01-21 | Koochiching | Minnesota | 27071 | 2199 | 32 |
2137122 | 2137122 | 2022-01-21 | Pamlico | North Carolina | 37137 | 2199 | 27 |
2128394 | 2128394 | 2022-01-18 | Manassas Park city | Virginia | 51685 | 2199 | 16 |
2109568 | 2109568 | 2022-01-13 | Early | Georgia | 13099 | 2199 | 58 |
2108401 | 2108401 | 2022-01-12 | Todd | South Dakota | 46121 | 2199 | 40 |
2100824 | 2100824 | 2022-01-10 | Jefferson Davis | Mississippi | 28065 | 2199 | 43 |
2097536 | 2097536 | 2022-01-09 | Watonwan | Minnesota | 27165 | 2199 | 21 |
2094284 | 2094284 | 2022-01-08 | Watonwan | Minnesota | 27165 | 2199 | 21 |
2091032 | 2091032 | 2022-01-07 | Watonwan | Minnesota | 27165 | 2199 | 21 |
2086489 | 2086489 | 2022-01-06 | Chicot | Arkansas | 5017 | 2199 | 49 |
2081001 | 2081001 | 2022-01-04 | Claiborne | Louisiana | 22027 | 2199 | 66 |
2074781 | 2074781 | 2022-01-02 | Amite | Mississippi | 28005 | 2199 | 58 |
2071530 | 2071530 | 2022-01-01 | Amite | Mississippi | 28005 | 2199 | 58 |
2068279 | 2068279 | 2021-12-31 | Amite | Mississippi | 28005 | 2199 | 58 |
2065028 | 2065028 | 2021-12-30 | Amite | Mississippi | 28005 | 2199 | 58 |
2058197 | 2058197 | 2021-12-28 | Metcalfe | Kentucky | 21169 | 2199 | 50 |
2055869 | 2055869 | 2021-12-27 | Barnes | North Dakota | 38003 | 2199 | 40 |
2056210 | 2056210 | 2021-12-27 | Catano | Puerto Rico | 72033 | 2199 | |
2056227 | 2056227 | 2021-12-27 | Hatillo | Puerto Rico | 72065 | 2199 | |
2056434 | 2056434 | 2021-12-27 | Jackson | Tennessee | 47087 | 2199 | 48 |
2036208 | 2036208 | 2021-12-21 | Torrance | New Mexico | 35057 | 2199 | 30 |
2010780 | 2010780 | 2021-12-13 | Bamberg | South Carolina | 45009 | 2199 | 64 |
2005575 | 2005575 | 2021-12-12 | Jasper | Georgia | 13159 | 2199 | 59 |
2002324 | 2002324 | 2021-12-11 | Jasper | Georgia | 13159 | 2199 | 59 |
1999074 | 1999074 | 2021-12-10 | Jasper | Georgia | 13159 | 2199 | 59 |
1994200 | 1994200 | 2021-12-08 | Harrison | Ohio | 39067 | 2199 | 54 |
1975212 | 1975212 | 2021-12-02 | Stewart | Tennessee | 47161 | 2199 | 36 |
1970807 | 1970807 | 2021-12-01 | Lawrence | Mississippi | 28077 | 2199 | 41 |
1960566 | 1960566 | 2021-11-28 | Osage | Kansas | 20139 | 2199 | 39 |
1957315 | 1957315 | 2021-11-27 | Osage | Kansas | 20139 | 2199 | 39 |
1954064 | 1954064 | 2021-11-26 | Osage | Kansas | 20139 | 2199 | 39 |
1950813 | 1950813 | 2021-11-25 | Osage | Kansas | 20139 | 2199 | 39 |
1947562 | 1947562 | 2021-11-24 | Osage | Kansas | 20139 | 2199 | 39 |
1926822 | 1926822 | 2021-11-17 | Grayson | Virginia | 51077 | 2199 | 48 |
1917499 | 1917499 | 2021-11-15 | Marion | Arkansas | 5089 | 2199 | 61 |
1905007 | 1905007 | 2021-11-11 | Mason | Illinois | 17125 | 2199 | 54 |
1901757 | 1901757 | 2021-11-10 | Mason | Illinois | 17125 | 2199 | 54 |
1876658 | 1876658 | 2021-11-02 | Macon | Missouri | 29121 | 2199 | 19 |
1874960 | 1874960 | 2021-11-01 | Grant | West Virginia | 54023 | 2199 | 33 |
1871831 | 1871831 | 2021-10-31 | Converse | Wyoming | 56009 | 2199 | 32 |
1868582 | 1868582 | 2021-10-30 | Converse | Wyoming | 56009 | 2199 | 32 |
1863669 | 1863669 | 2021-10-29 | Mississippi | Missouri | 29133 | 2199 | 42 |
1865333 | 1865333 | 2021-10-29 | Converse | Wyoming | 56009 | 2199 | 32 |
1832487 | 1832487 | 2021-10-19 | Zapata | Texas | 48505 | 2199 | 45 |
1805025 | 1805025 | 2021-10-11 | Wadena | Minnesota | 27159 | 2199 | 29 |
1785479 | 1785479 | 2021-10-05 | Houston | Minnesota | 27055 | 2199 | 17 |
1781289 | 1781289 | 2021-10-04 | Charlton | Georgia | 13049 | 2199 | 52 |
1782379 | 1782379 | 2021-10-04 | Bates | Missouri | 29013 | 2199 | 39 |
1761052 | 1761052 | 2021-09-27 | Windsor | Vermont | 50027 | 2199 | 24 |
1751535 | 1751535 | 2021-09-24 | Wetzel | West Virginia | 54103 | 2199 | 37 |
1740197 | 1740197 | 2021-09-21 | Madison | Missouri | 29123 | 2199 | 19 |
1715157 | 1715157 | 2021-09-13 | Oglala Lakota | South Dakota | 46102 | 2199 | 51 |
1705546 | 1705546 | 2021-09-10 | Bosque | Texas | 48035 | 2199 | 45 |
1698376 | 1698376 | 2021-09-08 | Northampton | North Carolina | 37131 | 2199 | 62 |
1690488 | 1690488 | 2021-09-06 | Gem | Idaho | 16045 | 2199 | 46 |
1687238 | 1687238 | 2021-09-05 | Gem | Idaho | 16045 | 2199 | 46 |
1683988 | 1683988 | 2021-09-04 | Gem | Idaho | 16045 | 2199 | 46 |
1680737 | 1680737 | 2021-09-03 | Gem | Idaho | 16045 | 2199 | 46 |
1672623 | 1672623 | 2021-08-31 | Pawnee | Oklahoma | 40117 | 2199 | 55 |
1669375 | 1669375 | 2021-08-30 | Pawnee | Oklahoma | 40117 | 2199 | 55 |
1666128 | 1666128 | 2021-08-29 | Pawnee | Oklahoma | 40117 | 2199 | 55 |
1662880 | 1662880 | 2021-08-28 | Pawnee | Oklahoma | 40117 | 2199 | 55 |
1659632 | 1659632 | 2021-08-27 | Pawnee | Oklahoma | 40117 | 2199 | 55 |
1660344 | 1660344 | 2021-08-27 | Washington | Vermont | 50023 | 2199 | 16 |
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);