ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
841 rows where cases = 238 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 82
- Texas 74
- Kansas 48
- Virginia 47
- Puerto Rico 30
- Michigan 25
- Nebraska 25
- Minnesota 23
- Missouri 23
- New York 23
- Kentucky 22
- Iowa 21
- Indiana 20
- West Virginia 20
- Alabama 19
- Colorado 19
- North Carolina 19
- Ohio 19
- South Dakota 19
- Louisiana 18
- Idaho 16
- Illinois 16
- Washington 16
- Arkansas 15
- Oregon 15
- Wisconsin 15
- North Dakota 14
- Alaska 13
- Oklahoma 13
- Florida 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496602 | 2496602 | 2022-05-12 | Mineral | Colorado | 8079 | 238 | 2 |
2270119 | 2270119 | 2022-03-03 | Carter | Montana | 30011 | 238 | 5 |
2263615 | 2263615 | 2022-03-01 | Carter | Montana | 30011 | 238 | 5 |
2157512 | 2157512 | 2022-01-27 | Sterling | Texas | 48431 | 238 | 5 |
2154259 | 2154259 | 2022-01-26 | Sterling | Texas | 48431 | 238 | 5 |
2151007 | 2151007 | 2022-01-25 | Sterling | Texas | 48431 | 238 | 5 |
2134368 | 2134368 | 2022-01-20 | Campbell | South Dakota | 46021 | 238 | 7 |
2096357 | 2096357 | 2022-01-09 | Sierra | California | 6091 | 238 | 0 |
2093105 | 2093105 | 2022-01-08 | Sierra | California | 6091 | 238 | 0 |
2089853 | 2089853 | 2022-01-07 | Sierra | California | 6091 | 238 | 0 |
2087302 | 2087302 | 2022-01-06 | Greeley | Kansas | 20071 | 238 | 3 |
2084050 | 2084050 | 2022-01-05 | Greeley | Kansas | 20071 | 238 | 3 |
2085861 | 2085861 | 2022-01-05 | Irion | Texas | 48235 | 238 | 2 |
2078661 | 2078661 | 2022-01-03 | Sheridan | North Dakota | 38083 | 238 | 6 |
2075410 | 2075410 | 2022-01-02 | Sheridan | North Dakota | 38083 | 238 | 6 |
2072159 | 2072159 | 2022-01-01 | Sheridan | North Dakota | 38083 | 238 | 6 |
2065990 | 2065990 | 2021-12-30 | Maricao | Puerto Rico | 72093 | 238 | |
1990547 | 1990547 | 2021-12-07 | Deuel | Nebraska | 31049 | 238 | 2 |
1987297 | 1987297 | 2021-12-06 | Deuel | Nebraska | 31049 | 238 | 2 |
1988444 | 1988444 | 2021-12-06 | Stonewall | Texas | 48433 | 238 | 6 |
1985194 | 1985194 | 2021-12-05 | Stonewall | Texas | 48433 | 238 | 6 |
1981944 | 1981944 | 2021-12-04 | Stonewall | Texas | 48433 | 238 | 6 |
1974381 | 1974381 | 2021-12-02 | Storey | Nevada | 32029 | 238 | 6 |
1968141 | 1968141 | 2021-11-30 | Oliver | North Dakota | 38065 | 238 | 3 |
1945116 | 1945116 | 2021-11-23 | Eureka | Nevada | 32011 | 238 | 1 |
1942742 | 1942742 | 2021-11-22 | Briscoe | Texas | 48045 | 238 | 7 |
1939492 | 1939492 | 2021-11-21 | Briscoe | Texas | 48045 | 238 | 7 |
1936242 | 1936242 | 2021-11-20 | Briscoe | Texas | 48045 | 238 | 7 |
1899662 | 1899662 | 2021-11-09 | Catron | New Mexico | 35003 | 238 | 7 |
1876037 | 1876037 | 2021-11-02 | Hodgeman | Kansas | 20083 | 238 | 10 |
1872788 | 1872788 | 2021-11-01 | Hodgeman | Kansas | 20083 | 238 | 10 |
1859850 | 1859850 | 2021-10-28 | Wallace | Kansas | 20199 | 238 | 4 |
1856601 | 1856601 | 2021-10-27 | Wallace | Kansas | 20199 | 238 | 4 |
1853352 | 1853352 | 2021-10-26 | Wallace | Kansas | 20199 | 238 | 4 |
1854177 | 1854177 | 2021-10-26 | De Baca | New Mexico | 35011 | 238 | 3 |
1850103 | 1850103 | 2021-10-25 | Wallace | Kansas | 20199 | 238 | 4 |
1846853 | 1846853 | 2021-10-24 | Wallace | Kansas | 20199 | 238 | 4 |
1843603 | 1843603 | 2021-10-23 | Wallace | Kansas | 20199 | 238 | 4 |
1840353 | 1840353 | 2021-10-22 | Wallace | Kansas | 20199 | 238 | 4 |
1832517 | 1832517 | 2021-10-19 | Wayne | Utah | 49055 | 238 | 0 |
1816436 | 1816436 | 2021-10-14 | Garfield | Washington | 53023 | 238 | 7 |
1811460 | 1811460 | 2021-10-13 | Cook | Minnesota | 27031 | 238 | 0 |
1795921 | 1795921 | 2021-10-08 | Steele | North Dakota | 38091 | 238 | 2 |
1792672 | 1792672 | 2021-10-07 | Steele | North Dakota | 38091 | 238 | 2 |
1743592 | 1743592 | 2021-09-22 | Garfield | Nebraska | 31071 | 238 | 1 |
1743903 | 1743903 | 2021-09-22 | Divide | North Dakota | 38023 | 238 | 2 |
1732646 | 1732646 | 2021-09-19 | Quitman | Georgia | 13239 | 238 | 4 |
1729396 | 1729396 | 2021-09-18 | Quitman | Georgia | 13239 | 238 | 4 |
1726146 | 1726146 | 2021-09-17 | Quitman | Georgia | 13239 | 238 | 4 |
1722897 | 1722897 | 2021-09-16 | Quitman | Georgia | 13239 | 238 | 3 |
1711231 | 1711231 | 2021-09-12 | Mora | New Mexico | 35033 | 238 | 9 |
1707984 | 1707984 | 2021-09-11 | Mora | New Mexico | 35033 | 238 | 9 |
1704737 | 1704737 | 2021-09-10 | Mora | New Mexico | 35033 | 238 | 9 |
1700644 | 1700644 | 2021-09-09 | Stanton | Kansas | 20187 | 238 | 6 |
1697395 | 1697395 | 2021-09-08 | Stanton | Kansas | 20187 | 238 | 6 |
1673983 | 1673983 | 2021-09-01 | Unknown | Delaware | 238 | 0 | |
1670735 | 1670735 | 2021-08-31 | Unknown | Delaware | 238 | 0 | |
1648677 | 1648677 | 2021-08-24 | Wichita | Kansas | 20203 | 238 | 6 |
1645429 | 1645429 | 2021-08-23 | Wichita | Kansas | 20203 | 238 | 6 |
1641253 | 1641253 | 2021-08-22 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 238 | 0 |
1638003 | 1638003 | 2021-08-21 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 238 | 0 |
1634753 | 1634753 | 2021-08-20 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 238 | 0 |
1634347 | 1634347 | 2021-08-19 | Grand Isle | Vermont | 50013 | 238 | 2 |
1586260 | 1586260 | 2021-08-05 | Sedgwick | Colorado | 8115 | 238 | 3 |
1583010 | 1583010 | 2021-08-04 | Sedgwick | Colorado | 8115 | 238 | 3 |
1557721 | 1557721 | 2021-07-27 | Woodson | Kansas | 20207 | 238 | 5 |
1554474 | 1554474 | 2021-07-26 | Woodson | Kansas | 20207 | 238 | 5 |
1540560 | 1540560 | 2021-07-22 | Dillingham Census Area | Alaska | 2070 | 238 | 2 |
1537313 | 1537313 | 2021-07-21 | Dillingham Census Area | Alaska | 2070 | 238 | 2 |
1534065 | 1534065 | 2021-07-20 | Dillingham Census Area | Alaska | 2070 | 238 | 2 |
1530818 | 1530818 | 2021-07-19 | Dillingham Census Area | Alaska | 2070 | 238 | 2 |
1523837 | 1523837 | 2021-07-16 | Sherman | Texas | 48421 | 238 | 12 |
1520589 | 1520589 | 2021-07-15 | Sherman | Texas | 48421 | 238 | 12 |
1496130 | 1496130 | 2021-07-08 | Robertson | Kentucky | 21201 | 238 | 14 |
1492884 | 1492884 | 2021-07-07 | Robertson | Kentucky | 21201 | 238 | 14 |
1489637 | 1489637 | 2021-07-06 | Robertson | Kentucky | 21201 | 238 | 14 |
1372113 | 1372113 | 2021-05-31 | Clay | Georgia | 13061 | 238 | 3 |
1373428 | 1373428 | 2021-05-31 | Pawnee | Nebraska | 31133 | 238 | 4 |
1374615 | 1374615 | 2021-05-31 | St. John | Virgin Islands | 78020 | 238 | 1 |
1368868 | 1368868 | 2021-05-30 | Clay | Georgia | 13061 | 238 | 3 |
1370183 | 1370183 | 2021-05-30 | Pawnee | Nebraska | 31133 | 238 | 4 |
1371370 | 1371370 | 2021-05-30 | St. John | Virgin Islands | 78020 | 238 | 1 |
1365622 | 1365622 | 2021-05-29 | Clay | Georgia | 13061 | 238 | 3 |
1366937 | 1366937 | 2021-05-29 | Pawnee | Nebraska | 31133 | 238 | 4 |
1368124 | 1368124 | 2021-05-29 | St. John | Virgin Islands | 78020 | 238 | 1 |
1362376 | 1362376 | 2021-05-28 | Clay | Georgia | 13061 | 238 | 3 |
1363691 | 1363691 | 2021-05-28 | Pawnee | Nebraska | 31133 | 238 | 4 |
1364878 | 1364878 | 2021-05-28 | St. John | Virgin Islands | 78020 | 238 | 1 |
1359129 | 1359129 | 2021-05-27 | Clay | Georgia | 13061 | 238 | 3 |
1355883 | 1355883 | 2021-05-26 | Clay | Georgia | 13061 | 238 | 3 |
1335563 | 1335563 | 2021-05-19 | Schleicher | Texas | 48413 | 238 | 6 |
1332316 | 1332316 | 2021-05-18 | Schleicher | Texas | 48413 | 238 | 6 |
1329069 | 1329069 | 2021-05-17 | Schleicher | Texas | 48413 | 238 | 6 |
1325823 | 1325823 | 2021-05-16 | Schleicher | Texas | 48413 | 238 | 6 |
1322577 | 1322577 | 2021-05-15 | Schleicher | Texas | 48413 | 238 | 6 |
1316921 | 1316921 | 2021-05-14 | Clay | Georgia | 13061 | 238 | 3 |
1319331 | 1319331 | 2021-05-14 | Schleicher | Texas | 48413 | 238 | 6 |
1316083 | 1316083 | 2021-05-13 | Schleicher | Texas | 48413 | 238 | 6 |
1307181 | 1307181 | 2021-05-11 | Clay | Georgia | 13061 | 238 | 3 |
1303935 | 1303935 | 2021-05-10 | Clay | Georgia | 13061 | 238 | 3 |
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);