ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where cases = 363 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alaska 72
- Texas 70
- Georgia 40
- South Dakota 38
- Kansas 30
- Wyoming 30
- North Dakota 29
- Virginia 28
- Colorado 27
- Kentucky 21
- New Mexico 21
- Louisiana 20
- Oklahoma 20
- Idaho 19
- Iowa 18
- Mississippi 18
- Nebraska 18
- Puerto Rico 18
- Illinois 17
- Missouri 17
- Ohio 16
- Tennessee 16
- Michigan 15
- New York 15
- Arkansas 14
- Indiana 14
- North Carolina 14
- Washington 14
- Montana 11
- Minnesota 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2402143 | 2402143 | 2022-04-13 | Dolores | Colorado | 8033 | 363 | 8 |
2398888 | 2398888 | 2022-04-12 | Dolores | Colorado | 8033 | 363 | 8 |
2395633 | 2395633 | 2022-04-11 | Dolores | Colorado | 8033 | 363 | 8 |
2392377 | 2392377 | 2022-04-10 | Dolores | Colorado | 8033 | 363 | 8 |
2389121 | 2389121 | 2022-04-09 | Dolores | Colorado | 8033 | 363 | 8 |
2385866 | 2385866 | 2022-04-08 | Dolores | Colorado | 8033 | 363 | 8 |
2193781 | 2193781 | 2022-02-08 | Denali Borough | Alaska | 2068 | 363 | 1 |
2190528 | 2190528 | 2022-02-07 | Denali Borough | Alaska | 2068 | 363 | 1 |
2175835 | 2175835 | 2022-02-02 | Liberty | Montana | 30051 | 363 | 2 |
2166486 | 2166486 | 2022-01-30 | Steele | North Dakota | 38091 | 363 | 2 |
2149877 | 2149877 | 2022-01-25 | Harlan | Nebraska | 31083 | 363 | 2 |
2143395 | 2143395 | 2022-01-23 | Pawnee | Nebraska | 31133 | 363 | 4 |
2140140 | 2140140 | 2022-01-22 | Pawnee | Nebraska | 31133 | 363 | 4 |
2136884 | 2136884 | 2022-01-21 | Pawnee | Nebraska | 31133 | 363 | 4 |
2130255 | 2130255 | 2022-01-19 | Worth | Missouri | 29227 | 363 | 3 |
2125931 | 2125931 | 2022-01-18 | Webster | Georgia | 13307 | 363 | 7 |
2127001 | 2127001 | 2022-01-18 | Worth | Missouri | 29227 | 363 | 3 |
2111761 | 2111761 | 2022-01-13 | Armstrong | Texas | 48011 | 363 | 8 |
2108509 | 2108509 | 2022-01-12 | Armstrong | Texas | 48011 | 363 | 8 |
2097123 | 2097123 | 2022-01-09 | Wichita | Kansas | 20203 | 363 | 8 |
2097826 | 2097826 | 2022-01-09 | Franklin | Nebraska | 31061 | 363 | 8 |
2098154 | 2098154 | 2022-01-09 | Logan | North Dakota | 38047 | 363 | 11 |
2093871 | 2093871 | 2022-01-08 | Wichita | Kansas | 20203 | 363 | 8 |
2094574 | 2094574 | 2022-01-08 | Franklin | Nebraska | 31061 | 363 | 8 |
2094902 | 2094902 | 2022-01-08 | Logan | North Dakota | 38047 | 363 | 11 |
2090619 | 2090619 | 2022-01-07 | Wichita | Kansas | 20203 | 363 | 8 |
2091322 | 2091322 | 2022-01-07 | Franklin | Nebraska | 31061 | 363 | 8 |
2088071 | 2088071 | 2022-01-06 | Franklin | Nebraska | 31061 | 363 | 8 |
2088877 | 2088877 | 2022-01-06 | McPherson | South Dakota | 46089 | 363 | 9 |
2085626 | 2085626 | 2022-01-05 | McPherson | South Dakota | 46089 | 363 | 9 |
2081878 | 2081878 | 2022-01-04 | Burke | North Dakota | 38013 | 363 | 3 |
2082374 | 2082374 | 2022-01-04 | McPherson | South Dakota | 46089 | 363 | 9 |
2012517 | 2012517 | 2021-12-14 | Clark | Kansas | 20025 | 363 | 7 |
2013633 | 2013633 | 2021-12-14 | Grant | North Dakota | 38037 | 363 | 9 |
2009266 | 2009266 | 2021-12-13 | Clark | Kansas | 20025 | 363 | 7 |
1997175 | 1997175 | 2021-12-09 | De Baca | New Mexico | 35011 | 363 | 3 |
1975434 | 1975434 | 2021-12-02 | Schleicher | Texas | 48413 | 363 | 9 |
1965615 | 1965615 | 2021-11-29 | Knox | Texas | 48275 | 363 | 21 |
1917182 | 1917182 | 2021-11-14 | San Juan | Washington | 53055 | 363 | 0 |
1912866 | 1912866 | 2021-11-13 | Golden Valley | North Dakota | 38033 | 363 | 4 |
1913932 | 1913932 | 2021-11-13 | San Juan | Washington | 53055 | 363 | 0 |
1909616 | 1909616 | 2021-11-12 | Golden Valley | North Dakota | 38033 | 363 | 4 |
1910682 | 1910682 | 2021-11-12 | San Juan | Washington | 53055 | 363 | 0 |
1900026 | 1900026 | 2021-11-09 | Harmon | Oklahoma | 40057 | 363 | 7 |
1896776 | 1896776 | 2021-11-08 | Harmon | Oklahoma | 40057 | 363 | 7 |
1893526 | 1893526 | 2021-11-07 | Harmon | Oklahoma | 40057 | 363 | 7 |
1890276 | 1890276 | 2021-11-06 | Harmon | Oklahoma | 40057 | 363 | 7 |
1887026 | 1887026 | 2021-11-05 | Harmon | Oklahoma | 40057 | 363 | 7 |
1887762 | 1887762 | 2021-11-05 | Grand Isle | Vermont | 50013 | 363 | 2 |
1882166 | 1882166 | 2021-11-04 | Butte | Idaho | 16023 | 363 | 4 |
1883776 | 1883776 | 2021-11-04 | Harmon | Oklahoma | 40057 | 363 | 7 |
1880527 | 1880527 | 2021-11-03 | Harmon | Oklahoma | 40057 | 363 | 7 |
1877126 | 1877126 | 2021-11-02 | Kidder | North Dakota | 38043 | 363 | 11 |
1848923 | 1848923 | 2021-10-24 | Columbia | Washington | 53013 | 363 | 8 |
1845673 | 1845673 | 2021-10-23 | Columbia | Washington | 53013 | 363 | 8 |
1842423 | 1842423 | 2021-10-22 | Columbia | Washington | 53013 | 363 | 8 |
1837053 | 1837053 | 2021-10-21 | Kiowa | Kansas | 20097 | 363 | 5 |
1838133 | 1838133 | 2021-10-21 | Griggs | North Dakota | 38039 | 363 | 2 |
1833804 | 1833804 | 2021-10-20 | Kiowa | Kansas | 20097 | 363 | 5 |
1834884 | 1834884 | 2021-10-20 | Griggs | North Dakota | 38039 | 363 | 2 |
1831635 | 1831635 | 2021-10-19 | Griggs | North Dakota | 38039 | 363 | 2 |
1828386 | 1828386 | 2021-10-18 | Griggs | North Dakota | 38039 | 363 | 2 |
1787767 | 1787767 | 2021-10-06 | Baker | Georgia | 13007 | 363 | 14 |
1784518 | 1784518 | 2021-10-05 | Baker | Georgia | 13007 | 363 | 14 |
1781269 | 1781269 | 2021-10-04 | Baker | Georgia | 13007 | 363 | 14 |
1768827 | 1768827 | 2021-09-30 | Logan | Kansas | 20109 | 363 | 8 |
1765578 | 1765578 | 2021-09-29 | Logan | Kansas | 20109 | 363 | 8 |
1725057 | 1725057 | 2021-09-16 | Collingsworth | Texas | 48087 | 363 | 9 |
1719409 | 1719409 | 2021-09-15 | Gilpin | Colorado | 8047 | 363 | 3 |
1721808 | 1721808 | 2021-09-15 | Collingsworth | Texas | 48087 | 363 | 9 |
1718560 | 1718560 | 2021-09-14 | Collingsworth | Texas | 48087 | 363 | 9 |
1699903 | 1699903 | 2021-09-09 | Baca | Colorado | 8009 | 363 | 5 |
1702182 | 1702182 | 2021-09-09 | Ziebach | South Dakota | 46137 | 363 | 9 |
1699177 | 1699177 | 2021-09-08 | Lipscomb | Texas | 48295 | 363 | 12 |
1694063 | 1694063 | 2021-09-07 | Chautauqua | Kansas | 20019 | 363 | 7 |
1695929 | 1695929 | 2021-09-07 | Lipscomb | Texas | 48295 | 363 | 12 |
1690814 | 1690814 | 2021-09-06 | Chautauqua | Kansas | 20019 | 363 | 7 |
1692681 | 1692681 | 2021-09-06 | Lipscomb | Texas | 48295 | 363 | 12 |
1687564 | 1687564 | 2021-09-05 | Chautauqua | Kansas | 20019 | 363 | 7 |
1689432 | 1689432 | 2021-09-05 | Lipscomb | Texas | 48295 | 363 | 12 |
1684314 | 1684314 | 2021-09-04 | Chautauqua | Kansas | 20019 | 363 | 7 |
1686182 | 1686182 | 2021-09-04 | Lipscomb | Texas | 48295 | 363 | 12 |
1681063 | 1681063 | 2021-09-03 | Chautauqua | Kansas | 20019 | 363 | 7 |
1673736 | 1673736 | 2021-09-01 | Dillingham Census Area | Alaska | 2070 | 363 | 3 |
1655738 | 1655738 | 2021-08-26 | Mercer | Missouri | 29129 | 363 | 2 |
1621783 | 1621783 | 2021-08-16 | Unknown | Alaska | 363 | 0 | |
1618535 | 1618535 | 2021-08-15 | Unknown | Alaska | 363 | 0 | |
1615287 | 1615287 | 2021-08-14 | Unknown | Alaska | 363 | 0 | |
1612038 | 1612038 | 2021-08-13 | Unknown | Alaska | 363 | 0 | |
1605542 | 1605542 | 2021-08-11 | Unknown | Alaska | 363 | 0 | |
1559751 | 1559751 | 2021-07-27 | Rappahannock | Virginia | 51157 | 363 | 2 |
1556159 | 1556159 | 2021-07-26 | Delta | Texas | 48119 | 363 | 14 |
1459411 | 1459411 | 2021-06-27 | Sitka City and Borough | Alaska | 2220 | 363 | 1 |
1456166 | 1456166 | 2021-06-26 | Sitka City and Borough | Alaska | 2220 | 363 | 1 |
1452921 | 1452921 | 2021-06-25 | Sitka City and Borough | Alaska | 2220 | 363 | 1 |
1449675 | 1449675 | 2021-06-24 | Sitka City and Borough | Alaska | 2220 | 363 | 1 |
1446430 | 1446430 | 2021-06-23 | Sitka City and Borough | Alaska | 2220 | 363 | 1 |
1443185 | 1443185 | 2021-06-22 | Sitka City and Borough | Alaska | 2220 | 363 | 1 |
1439940 | 1439940 | 2021-06-21 | Sitka City and Borough | Alaska | 2220 | 363 | 1 |
1406636 | 1406636 | 2021-06-10 | Hand | South Dakota | 46059 | 363 | 6 |
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);