ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
662 rows where cases = 430 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 59
- Kansas 50
- Texas 47
- Nebraska 43
- North Dakota 33
- Puerto Rico 28
- Colorado 26
- Kentucky 26
- Georgia 25
- Missouri 23
- Illinois 20
- Oklahoma 20
- Minnesota 17
- Montana 16
- Tennessee 16
- Michigan 15
- Arkansas 14
- South Dakota 13
- Louisiana 12
- North Carolina 11
- Indiana 10
- Iowa 10
- Oregon 10
- Pennsylvania 10
- Idaho 9
- New York 9
- Mississippi 7
- Rhode Island 7
- South Carolina 7
- Maryland 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2308514 | 2308514 | 2022-03-15 | Stanton | Kansas | 20187 | 430 | 8 |
2305263 | 2305263 | 2022-03-14 | Stanton | Kansas | 20187 | 430 | 8 |
2302011 | 2302011 | 2022-03-13 | Stanton | Kansas | 20187 | 430 | 8 |
2298759 | 2298759 | 2022-03-12 | Stanton | Kansas | 20187 | 430 | 8 |
2295507 | 2295507 | 2022-03-11 | Stanton | Kansas | 20187 | 430 | 8 |
2292255 | 2292255 | 2022-03-10 | Stanton | Kansas | 20187 | 430 | 8 |
2289003 | 2289003 | 2022-03-09 | Stanton | Kansas | 20187 | 430 | 8 |
2290026 | 2290026 | 2022-03-09 | Burke | North Dakota | 38013 | 430 | 3 |
2285752 | 2285752 | 2022-03-08 | Stanton | Kansas | 20187 | 430 | 8 |
2286774 | 2286774 | 2022-03-08 | Burke | North Dakota | 38013 | 430 | 3 |
2282500 | 2282500 | 2022-03-07 | Stanton | Kansas | 20187 | 430 | 8 |
2283522 | 2283522 | 2022-03-07 | Burke | North Dakota | 38013 | 430 | 3 |
2279247 | 2279247 | 2022-03-06 | Stanton | Kansas | 20187 | 430 | 8 |
2280270 | 2280270 | 2022-03-06 | Burke | North Dakota | 38013 | 430 | 3 |
2275994 | 2275994 | 2022-03-05 | Stanton | Kansas | 20187 | 430 | 8 |
2277017 | 2277017 | 2022-03-05 | Burke | North Dakota | 38013 | 430 | 3 |
2272741 | 2272741 | 2022-03-04 | Stanton | Kansas | 20187 | 430 | 8 |
2273764 | 2273764 | 2022-03-04 | Burke | North Dakota | 38013 | 430 | 3 |
2270511 | 2270511 | 2022-03-03 | Burke | North Dakota | 38013 | 430 | 3 |
2267259 | 2267259 | 2022-03-02 | Burke | North Dakota | 38013 | 430 | 3 |
2264007 | 2264007 | 2022-03-01 | Burke | North Dakota | 38013 | 430 | 3 |
2260756 | 2260756 | 2022-02-28 | Burke | North Dakota | 38013 | 430 | 3 |
2257505 | 2257505 | 2022-02-27 | Burke | North Dakota | 38013 | 430 | 3 |
2254254 | 2254254 | 2022-02-26 | Burke | North Dakota | 38013 | 430 | 3 |
2251020 | 2251020 | 2022-02-25 | Logan | North Dakota | 38047 | 430 | 12 |
2223973 | 2223973 | 2022-02-17 | Stanton | Kansas | 20187 | 430 | 8 |
2220275 | 2220275 | 2022-02-16 | Webster | Georgia | 13307 | 430 | 7 |
2220722 | 2220722 | 2022-02-16 | Stanton | Kansas | 20187 | 430 | 8 |
2202964 | 2202964 | 2022-02-10 | Irion | Texas | 48235 | 430 | 3 |
2161482 | 2161482 | 2022-01-29 | Sedgwick | Colorado | 8115 | 430 | 8 |
2154973 | 2154973 | 2022-01-27 | Sedgwick | Colorado | 8115 | 430 | 8 |
2150187 | 2150187 | 2022-01-25 | Golden Valley | North Dakota | 38033 | 430 | 4 |
2146937 | 2146937 | 2022-01-24 | Grant | North Dakota | 38037 | 430 | 11 |
2143683 | 2143683 | 2022-01-23 | Grant | North Dakota | 38037 | 430 | 11 |
2140428 | 2140428 | 2022-01-22 | Grant | North Dakota | 38037 | 430 | 11 |
2097863 | 2097863 | 2022-01-09 | Perkins | Nebraska | 31135 | 430 | 12 |
2094611 | 2094611 | 2022-01-08 | Perkins | Nebraska | 31135 | 430 | 12 |
2095553 | 2095553 | 2022-01-08 | Culberson | Texas | 48109 | 430 | 13 |
2091359 | 2091359 | 2022-01-07 | Perkins | Nebraska | 31135 | 430 | 12 |
2082934 | 2082934 | 2022-01-04 | Columbia | Washington | 53013 | 430 | 10 |
2060812 | 2060812 | 2021-12-29 | Glascock | Georgia | 13125 | 430 | 21 |
2028811 | 2028811 | 2021-12-19 | Lincoln | Kansas | 20105 | 430 | 7 |
2025560 | 2025560 | 2021-12-18 | Lincoln | Kansas | 20105 | 430 | 7 |
2022309 | 2022309 | 2021-12-17 | Lincoln | Kansas | 20105 | 430 | 7 |
2020608 | 2020608 | 2021-12-16 | Jackson | South Dakota | 46071 | 430 | 19 |
2017357 | 2017357 | 2021-12-15 | Jackson | South Dakota | 46071 | 430 | 19 |
2014107 | 2014107 | 2021-12-14 | Jackson | South Dakota | 46071 | 430 | 19 |
2010856 | 2010856 | 2021-12-13 | Jackson | South Dakota | 46071 | 430 | 19 |
2006820 | 2006820 | 2021-12-12 | Hitchcock | Nebraska | 31087 | 430 | 5 |
2003569 | 2003569 | 2021-12-11 | Hitchcock | Nebraska | 31087 | 430 | 5 |
2000319 | 2000319 | 2021-12-10 | Hitchcock | Nebraska | 31087 | 430 | 5 |
1993817 | 1993817 | 2021-12-08 | Hitchcock | Nebraska | 31087 | 430 | 5 |
1974288 | 1974288 | 2021-12-02 | Cherry | Nebraska | 31031 | 430 | 8 |
1972022 | 1972022 | 2021-12-01 | Collingsworth | Texas | 48087 | 430 | 11 |
1972269 | 1972269 | 2021-12-01 | Grand Isle | Vermont | 50013 | 430 | 2 |
1935637 | 1935637 | 2021-11-20 | Renville | North Dakota | 38075 | 430 | 14 |
1876072 | 1876072 | 2021-11-02 | Rawlins | Kansas | 20153 | 430 | 7 |
1872823 | 1872823 | 2021-11-01 | Rawlins | Kansas | 20153 | 430 | 7 |
1858125 | 1858125 | 2021-10-27 | Stanley | South Dakota | 46117 | 430 | 3 |
1846765 | 1846765 | 2021-10-24 | Cheyenne | Kansas | 20023 | 430 | 13 |
1843515 | 1843515 | 2021-10-23 | Cheyenne | Kansas | 20023 | 430 | 13 |
1840265 | 1840265 | 2021-10-22 | Cheyenne | Kansas | 20023 | 430 | 13 |
1833108 | 1833108 | 2021-10-20 | Baca | Colorado | 8009 | 430 | 5 |
1835692 | 1835692 | 2021-10-20 | Shackelford | Texas | 48417 | 430 | 5 |
1818481 | 1818481 | 2021-10-15 | Hamilton | New York | 36041 | 430 | 3 |
1815232 | 1815232 | 2021-10-14 | Hamilton | New York | 36041 | 430 | 3 |
1803684 | 1803684 | 2021-10-11 | Aleutians East Borough | Alaska | 2013 | 430 | 3 |
1790036 | 1790036 | 2021-10-06 | Cochran | Texas | 48079 | 430 | 18 |
1786155 | 1786155 | 2021-10-05 | McIntosh | North Dakota | 38051 | 430 | 8 |
1786788 | 1786788 | 2021-10-05 | Cochran | Texas | 48079 | 430 | 16 |
1766653 | 1766653 | 2021-09-29 | Hettinger | North Dakota | 38041 | 430 | 4 |
1740997 | 1740997 | 2021-09-21 | Guanica | Puerto Rico | 72055 | 430 | |
1737748 | 1737748 | 2021-09-20 | Guanica | Puerto Rico | 72055 | 430 | |
1728361 | 1728361 | 2021-09-17 | Hardeman | Texas | 48197 | 430 | 13 |
1716792 | 1716792 | 2021-09-14 | Barber | Kansas | 20007 | 430 | 7 |
1713546 | 1713546 | 2021-09-13 | Barber | Kansas | 20007 | 430 | 7 |
1691571 | 1691571 | 2021-09-06 | Sweet Grass | Montana | 30097 | 430 | 7 |
1688321 | 1688321 | 2021-09-05 | Sweet Grass | Montana | 30097 | 430 | 7 |
1685071 | 1685071 | 2021-09-04 | Sweet Grass | Montana | 30097 | 430 | 7 |
1681820 | 1681820 | 2021-09-03 | Sweet Grass | Montana | 30097 | 430 | 7 |
1649860 | 1649860 | 2021-08-24 | Harper | Oklahoma | 40059 | 430 | 8 |
1645485 | 1645485 | 2021-08-23 | Hickman | Kentucky | 21105 | 430 | 16 |
1646611 | 1646611 | 2021-08-23 | Harper | Oklahoma | 40059 | 430 | 8 |
1647116 | 1647116 | 2021-08-23 | Delta | Texas | 48119 | 430 | 14 |
1647537 | 1647537 | 2021-08-23 | Calhoun | West Virginia | 54013 | 430 | 1 |
1643362 | 1643362 | 2021-08-22 | Harper | Oklahoma | 40059 | 430 | 8 |
1640112 | 1640112 | 2021-08-21 | Harper | Oklahoma | 40059 | 430 | 8 |
1636862 | 1636862 | 2021-08-20 | Harper | Oklahoma | 40059 | 430 | 8 |
1633612 | 1633612 | 2021-08-19 | Harper | Oklahoma | 40059 | 430 | 8 |
1630365 | 1630365 | 2021-08-18 | Harper | Oklahoma | 40059 | 430 | 8 |
1626955 | 1626955 | 2021-08-17 | Dunn | North Dakota | 38025 | 430 | 7 |
1621437 | 1621437 | 2021-08-15 | King and Queen | Virginia | 51097 | 430 | 7 |
1618189 | 1618189 | 2021-08-14 | King and Queen | Virginia | 51097 | 430 | 7 |
1614941 | 1614941 | 2021-08-13 | King and Queen | Virginia | 51097 | 430 | 7 |
1610490 | 1610490 | 2021-08-12 | Unknown | New Hampshire | 430 | 1 | |
1606628 | 1606628 | 2021-08-11 | Unknown | Louisiana | 430 | 0 | |
1585489 | 1585489 | 2021-08-04 | Mason | Texas | 48319 | 430 | 6 |
1582239 | 1582239 | 2021-08-03 | Mason | Texas | 48319 | 430 | 6 |
1576769 | 1576769 | 2021-08-02 | Bear Lake | Idaho | 16007 | 430 | 2 |
1578054 | 1578054 | 2021-08-02 | Union | New Mexico | 35059 | 430 | 10 |
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);