ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
223 rows where cases = 2822 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 31
- Iowa 17
- Kentucky 17
- Louisiana 13
- Florida 12
- Missouri 10
- Minnesota 9
- Oklahoma 9
- Ohio 8
- Virginia 8
- Kansas 7
- Michigan 7
- Mississippi 7
- Arkansas 6
- Georgia 6
- Illinois 6
- Wisconsin 6
- North Carolina 5
- Maryland 4
- Montana 4
- New York 4
- Puerto Rico 4
- South Dakota 4
- Alabama 3
- Indiana 2
- South Carolina 2
- Tennessee 2
- West Virginia 2
- California 1
- Colorado 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474513 | 2474513 | 2022-05-05 | Wilson | Kansas | 20205 | 2822 | 43 |
2471256 | 2471256 | 2022-05-04 | Wilson | Kansas | 20205 | 2822 | 43 |
2468000 | 2468000 | 2022-05-03 | Wilson | Kansas | 20205 | 2822 | 43 |
2464745 | 2464745 | 2022-05-02 | Wilson | Kansas | 20205 | 2822 | 43 |
2461489 | 2461489 | 2022-05-01 | Wilson | Kansas | 20205 | 2822 | 43 |
2458233 | 2458233 | 2022-04-30 | Wilson | Kansas | 20205 | 2822 | 43 |
2454977 | 2454977 | 2022-04-29 | Wilson | Kansas | 20205 | 2822 | 43 |
2447762 | 2447762 | 2022-04-27 | Rio Grande | Colorado | 8105 | 2822 | 46 |
2450162 | 2450162 | 2022-04-27 | Eastland | Texas | 48133 | 2822 | 113 |
2417773 | 2417773 | 2022-04-17 | Ward | Texas | 48475 | 2822 | 43 |
2414517 | 2414517 | 2022-04-16 | Ward | Texas | 48475 | 2822 | 43 |
2411261 | 2411261 | 2022-04-15 | Ward | Texas | 48475 | 2822 | 43 |
2408005 | 2408005 | 2022-04-14 | Ward | Texas | 48475 | 2822 | 43 |
2404749 | 2404749 | 2022-04-13 | Ward | Texas | 48475 | 2822 | 43 |
2401494 | 2401494 | 2022-04-12 | Ward | Texas | 48475 | 2822 | 43 |
2352473 | 2352473 | 2022-03-28 | Callahan | Texas | 48059 | 2822 | 72 |
2349221 | 2349221 | 2022-03-27 | Callahan | Texas | 48059 | 2822 | 72 |
2345968 | 2345968 | 2022-03-26 | Callahan | Texas | 48059 | 2822 | 72 |
2302094 | 2302094 | 2022-03-13 | Lyon | Kentucky | 21143 | 2822 | 33 |
2298842 | 2298842 | 2022-03-12 | Lyon | Kentucky | 21143 | 2822 | 33 |
2295590 | 2295590 | 2022-03-11 | Lyon | Kentucky | 21143 | 2822 | 33 |
2292338 | 2292338 | 2022-03-10 | Lyon | Kentucky | 21143 | 2822 | 33 |
2289086 | 2289086 | 2022-03-09 | Lyon | Kentucky | 21143 | 2822 | 33 |
2285599 | 2285599 | 2022-03-08 | Hancock | Iowa | 19081 | 2822 | 46 |
2285835 | 2285835 | 2022-03-08 | Lyon | Kentucky | 21143 | 2822 | 33 |
2285947 | 2285947 | 2022-03-08 | West Feliciana | Louisiana | 22125 | 2822 | 44 |
2282347 | 2282347 | 2022-03-07 | Hancock | Iowa | 19081 | 2822 | 46 |
2282583 | 2282583 | 2022-03-07 | Lyon | Kentucky | 21143 | 2822 | 33 |
2282695 | 2282695 | 2022-03-07 | West Feliciana | Louisiana | 22125 | 2822 | 44 |
2279094 | 2279094 | 2022-03-06 | Hancock | Iowa | 19081 | 2822 | 46 |
2280646 | 2280646 | 2022-03-06 | Orocovis | Puerto Rico | 72107 | 2822 | |
2275841 | 2275841 | 2022-03-05 | Hancock | Iowa | 19081 | 2822 | 46 |
2272588 | 2272588 | 2022-03-04 | Hancock | Iowa | 19081 | 2822 | 46 |
2269336 | 2269336 | 2022-03-03 | Hancock | Iowa | 19081 | 2822 | 46 |
2266083 | 2266083 | 2022-03-02 | Hancock | Iowa | 19081 | 2822 | 46 |
2240038 | 2240038 | 2022-02-22 | Appanoose | Iowa | 19007 | 2822 | 63 |
2236787 | 2236787 | 2022-02-21 | Appanoose | Iowa | 19007 | 2822 | 63 |
2233536 | 2233536 | 2022-02-20 | Appanoose | Iowa | 19007 | 2822 | 63 |
2230285 | 2230285 | 2022-02-19 | Appanoose | Iowa | 19007 | 2822 | 63 |
2227034 | 2227034 | 2022-02-18 | Appanoose | Iowa | 19007 | 2822 | 63 |
2223783 | 2223783 | 2022-02-17 | Appanoose | Iowa | 19007 | 2822 | 63 |
2220532 | 2220532 | 2022-02-16 | Appanoose | Iowa | 19007 | 2822 | 63 |
2212503 | 2212503 | 2022-02-13 | Todd | South Dakota | 46121 | 2822 | 44 |
2209250 | 2209250 | 2022-02-12 | Todd | South Dakota | 46121 | 2822 | 44 |
2205997 | 2205997 | 2022-02-11 | Todd | South Dakota | 46121 | 2822 | 44 |
2179446 | 2179446 | 2022-02-03 | Washington | North Carolina | 37187 | 2822 | 42 |
2152835 | 2152835 | 2022-01-26 | Amite | Mississippi | 28005 | 2822 | 59 |
2139969 | 2139969 | 2022-01-22 | Mississippi | Missouri | 29133 | 2822 | 51 |
2104815 | 2104815 | 2022-01-11 | Kingfisher | Oklahoma | 40073 | 2822 | 56 |
2101564 | 2101564 | 2022-01-10 | Kingfisher | Oklahoma | 40073 | 2822 | 56 |
2098313 | 2098313 | 2022-01-09 | Kingfisher | Oklahoma | 40073 | 2822 | 56 |
2095061 | 2095061 | 2022-01-08 | Kingfisher | Oklahoma | 40073 | 2822 | 56 |
2091809 | 2091809 | 2022-01-07 | Kingfisher | Oklahoma | 40073 | 2822 | 56 |
2086511 | 2086511 | 2022-01-06 | Howard | Arkansas | 5061 | 2822 | 39 |
2087768 | 2087768 | 2022-01-06 | Sibley | Minnesota | 27143 | 2822 | 21 |
2088557 | 2088557 | 2022-01-06 | Kingfisher | Oklahoma | 40073 | 2822 | 56 |
2085306 | 2085306 | 2022-01-05 | Kingfisher | Oklahoma | 40073 | 2822 | 56 |
2081370 | 2081370 | 2022-01-04 | Bates | Missouri | 29013 | 2822 | 65 |
2075011 | 2075011 | 2022-01-02 | Park | Montana | 30067 | 2822 | 31 |
2071760 | 2071760 | 2022-01-01 | Park | Montana | 30067 | 2822 | 31 |
2068509 | 2068509 | 2021-12-31 | Park | Montana | 30067 | 2822 | 31 |
2065258 | 2065258 | 2021-12-30 | Park | Montana | 30067 | 2822 | 31 |
2000110 | 2000110 | 2021-12-10 | Benton | Missouri | 29015 | 2822 | 70 |
1992707 | 1992707 | 2021-12-08 | Bond | Illinois | 17005 | 2822 | 34 |
1986748 | 1986748 | 2021-12-06 | Jackson | Louisiana | 22049 | 2822 | 64 |
1983498 | 1983498 | 2021-12-05 | Jackson | Louisiana | 22049 | 2822 | 64 |
1980248 | 1980248 | 2021-12-04 | Jackson | Louisiana | 22049 | 2822 | 64 |
1976998 | 1976998 | 2021-12-03 | Jackson | Louisiana | 22049 | 2822 | 64 |
1975822 | 1975822 | 2021-12-02 | Washburn | Wisconsin | 55129 | 2822 | 30 |
1969026 | 1969026 | 2021-11-30 | Windham | Vermont | 50025 | 2822 | 26 |
1914707 | 1914707 | 2021-11-14 | Clark | Illinois | 17023 | 2822 | 50 |
1911457 | 1911457 | 2021-11-13 | Clark | Illinois | 17023 | 2822 | 50 |
1908208 | 1908208 | 2021-11-12 | Clark | Illinois | 17023 | 2822 | 50 |
1892741 | 1892741 | 2021-11-07 | Roseau | Minnesota | 27135 | 2822 | 29 |
1889491 | 1889491 | 2021-11-06 | Roseau | Minnesota | 27135 | 2822 | 29 |
1886241 | 1886241 | 2021-11-05 | Roseau | Minnesota | 27135 | 2822 | 29 |
1883096 | 1883096 | 2021-11-04 | Andrew | Missouri | 29003 | 2822 | 24 |
1850131 | 1850131 | 2021-10-25 | Casey | Kentucky | 21045 | 2822 | 55 |
1847116 | 1847116 | 2021-10-24 | Cheboygan | Michigan | 26031 | 2822 | 63 |
1843866 | 1843866 | 2021-10-23 | Cheboygan | Michigan | 26031 | 2822 | 63 |
1840616 | 1840616 | 2021-10-22 | Cheboygan | Michigan | 26031 | 2822 | 63 |
1824201 | 1824201 | 2021-10-17 | Morgan | Kentucky | 21175 | 2822 | 6 |
1820952 | 1820952 | 2021-10-16 | Morgan | Kentucky | 21175 | 2822 | 6 |
1821385 | 1821385 | 2021-10-16 | Clinton | Missouri | 29049 | 2822 | 77 |
1817703 | 1817703 | 2021-10-15 | Morgan | Kentucky | 21175 | 2822 | 6 |
1803582 | 1803582 | 2021-10-10 | Taylor | Wisconsin | 55119 | 2822 | 43 |
1800333 | 1800333 | 2021-10-09 | Taylor | Wisconsin | 55119 | 2822 | 43 |
1797084 | 1797084 | 2021-10-08 | Taylor | Wisconsin | 55119 | 2822 | 43 |
1791917 | 1791917 | 2021-10-07 | Mason | Michigan | 26105 | 2822 | 44 |
1793646 | 1793646 | 2021-10-07 | Prince Edward | Virginia | 51147 | 2822 | 47 |
1788668 | 1788668 | 2021-10-06 | Mason | Michigan | 26105 | 2822 | 44 |
1769188 | 1769188 | 2021-09-30 | Otsego | Michigan | 26137 | 2822 | 47 |
1771093 | 1771093 | 2021-09-30 | Vilas | Wisconsin | 55125 | 2822 | 50 |
1760922 | 1760922 | 2021-09-27 | Montague | Texas | 48337 | 2822 | 83 |
1757674 | 1757674 | 2021-09-26 | Montague | Texas | 48337 | 2822 | 83 |
1754426 | 1754426 | 2021-09-25 | Montague | Texas | 48337 | 2822 | 83 |
1743494 | 1743494 | 2021-09-22 | Vernon | Missouri | 29217 | 2822 | 63 |
1734060 | 1734060 | 2021-09-19 | Caswell | North Carolina | 37033 | 2822 | 34 |
1735177 | 1735177 | 2021-09-19 | Salem city | Virginia | 51775 | 2822 | 55 |
1730810 | 1730810 | 2021-09-18 | Caswell | North Carolina | 37033 | 2822 | 34 |
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);