ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
262 rows where cases = 1902 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 34
- Arkansas 14
- Missouri 14
- Puerto Rico 14
- North Carolina 13
- Virginia 13
- Texas 12
- Minnesota 11
- Mississippi 11
- Tennessee 10
- Alabama 9
- Illinois 9
- Indiana 8
- Kentucky 7
- Wisconsin 7
- North Dakota 6
- Utah 6
- West Virginia 5
- Iowa 4
- Montana 4
- Ohio 4
- Oklahoma 4
- Wyoming 4
- Alaska 3
- Louisiana 3
- Maryland 3
- Michigan 3
- Nebraska 3
- Washington 3
- California 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446154 | 2446154 | 2022-04-26 | Gates | North Carolina | 37073 | 1902 | 19 |
2442899 | 2442899 | 2022-04-25 | Gates | North Carolina | 37073 | 1902 | 19 |
2438163 | 2438163 | 2022-04-24 | Irwin | Georgia | 13155 | 1902 | 49 |
2439643 | 2439643 | 2022-04-24 | Gates | North Carolina | 37073 | 1902 | 19 |
2434907 | 2434907 | 2022-04-23 | Irwin | Georgia | 13155 | 1902 | 49 |
2436387 | 2436387 | 2022-04-23 | Gates | North Carolina | 37073 | 1902 | 19 |
2431651 | 2431651 | 2022-04-22 | Irwin | Georgia | 13155 | 1902 | 49 |
2433131 | 2433131 | 2022-04-22 | Gates | North Carolina | 37073 | 1902 | 19 |
2428395 | 2428395 | 2022-04-21 | Irwin | Georgia | 13155 | 1902 | 49 |
2429875 | 2429875 | 2022-04-21 | Gates | North Carolina | 37073 | 1902 | 19 |
2425139 | 2425139 | 2022-04-20 | Irwin | Georgia | 13155 | 1902 | 49 |
2426619 | 2426619 | 2022-04-20 | Gates | North Carolina | 37073 | 1902 | 19 |
2395315 | 2395315 | 2022-04-10 | Menominee | Wisconsin | 55078 | 1902 | 14 |
2392059 | 2392059 | 2022-04-09 | Menominee | Wisconsin | 55078 | 1902 | 14 |
2388803 | 2388803 | 2022-04-08 | Menominee | Wisconsin | 55078 | 1902 | 14 |
2385548 | 2385548 | 2022-04-07 | Menominee | Wisconsin | 55078 | 1902 | 14 |
2362821 | 2362821 | 2022-03-31 | Platte | Wyoming | 56031 | 1902 | 39 |
2359567 | 2359567 | 2022-03-30 | Platte | Wyoming | 56031 | 1902 | 39 |
2356313 | 2356313 | 2022-03-29 | Platte | Wyoming | 56031 | 1902 | 39 |
2266413 | 2266413 | 2022-03-02 | St. Helena | Louisiana | 22091 | 1902 | 23 |
2248585 | 2248585 | 2022-02-24 | Swisher | Texas | 48437 | 1902 | 32 |
2211987 | 2211987 | 2022-02-13 | Benson | North Dakota | 38005 | 1902 | 22 |
2189243 | 2189243 | 2022-02-06 | Pembina | North Dakota | 38067 | 1902 | 16 |
2185990 | 2185990 | 2022-02-05 | Pembina | North Dakota | 38067 | 1902 | 16 |
2179289 | 2179289 | 2022-02-03 | Sierra | New Mexico | 35051 | 1902 | 69 |
2164608 | 2164608 | 2022-01-30 | Searcy | Arkansas | 5129 | 1902 | 37 |
2167405 | 2167405 | 2022-01-30 | Fairfax city | Virginia | 51600 | 1902 | 36 |
2161353 | 2161353 | 2022-01-29 | Searcy | Arkansas | 5129 | 1902 | 37 |
2164150 | 2164150 | 2022-01-29 | Fairfax city | Virginia | 51600 | 1902 | 36 |
2158097 | 2158097 | 2022-01-28 | Searcy | Arkansas | 5129 | 1902 | 37 |
2160895 | 2160895 | 2022-01-28 | Fairfax city | Virginia | 51600 | 1902 | 36 |
2110041 | 2110041 | 2022-01-13 | Coffey | Kansas | 20031 | 1902 | 35 |
2106790 | 2106790 | 2022-01-12 | Coffey | Kansas | 20031 | 1902 | 35 |
2096654 | 2096654 | 2022-01-09 | Towns | Georgia | 13281 | 1902 | 88 |
2098417 | 2098417 | 2022-01-09 | Forest | Pennsylvania | 42053 | 1902 | 33 |
2093402 | 2093402 | 2022-01-08 | Towns | Georgia | 13281 | 1902 | 88 |
2094484 | 2094484 | 2022-01-08 | Wayne | Missouri | 29223 | 1902 | 37 |
2090150 | 2090150 | 2022-01-07 | Towns | Georgia | 13281 | 1902 | 88 |
2086899 | 2086899 | 2022-01-06 | Towns | Georgia | 13281 | 1902 | 88 |
2083647 | 2083647 | 2022-01-05 | Towns | Georgia | 13281 | 1902 | 88 |
2086367 | 2086367 | 2022-01-05 | Washakie | Wyoming | 56043 | 1902 | 39 |
2054503 | 2054503 | 2021-12-27 | Jasper | Illinois | 17079 | 1902 | 23 |
2050630 | 2050630 | 2021-12-26 | Coosa | Alabama | 1037 | 1902 | 48 |
2047380 | 2047380 | 2021-12-25 | Coosa | Alabama | 1037 | 1902 | 48 |
2039984 | 2039984 | 2021-12-22 | Juana Diaz | Puerto Rico | 72075 | 1902 | |
2012971 | 2012971 | 2021-12-14 | Koochiching | Minnesota | 27071 | 1902 | 27 |
2004774 | 2004774 | 2021-12-11 | Orange | Vermont | 50017 | 1902 | 8 |
1996857 | 1996857 | 2021-12-09 | Barton | Missouri | 29011 | 1902 | 40 |
1986041 | 1986041 | 2021-12-06 | Early | Georgia | 13099 | 1902 | 58 |
1982443 | 1982443 | 2021-12-05 | Valdez-Cordova Census Area | Alaska | 2261 | 1902 | 9 |
1982791 | 1982791 | 2021-12-05 | Early | Georgia | 13099 | 1902 | 58 |
1979193 | 1979193 | 2021-12-04 | Valdez-Cordova Census Area | Alaska | 2261 | 1902 | 9 |
1979541 | 1979541 | 2021-12-04 | Early | Georgia | 13099 | 1902 | 58 |
1975943 | 1975943 | 2021-12-03 | Valdez-Cordova Census Area | Alaska | 2261 | 1902 | 9 |
1976291 | 1976291 | 2021-12-03 | Early | Georgia | 13099 | 1902 | 58 |
1972738 | 1972738 | 2021-12-02 | Fulton | Arkansas | 5049 | 1902 | 68 |
1974636 | 1974636 | 2021-12-02 | Mercer | North Dakota | 38057 | 1902 | 17 |
1971924 | 1971924 | 2021-12-01 | Houston | Tennessee | 47083 | 1902 | 45 |
1938500 | 1938500 | 2021-11-21 | Richland | Montana | 30083 | 1902 | 24 |
1935250 | 1935250 | 2021-11-20 | Richland | Montana | 30083 | 1902 | 24 |
1931850 | 1931850 | 2021-11-19 | Bollinger | Missouri | 29017 | 1902 | 27 |
1932000 | 1932000 | 2021-11-19 | Richland | Montana | 30083 | 1902 | 24 |
1897651 | 1897651 | 2021-11-08 | Westmoreland | Virginia | 51193 | 1902 | 37 |
1875054 | 1875054 | 2021-11-01 | Price | Wisconsin | 55099 | 1902 | 12 |
1868214 | 1868214 | 2021-10-30 | Ward | Texas | 48475 | 1902 | 30 |
1855736 | 1855736 | 2021-10-27 | Desha | Arkansas | 5041 | 1902 | 32 |
1853434 | 1853434 | 2021-10-26 | Martin | Kentucky | 21159 | 1902 | 35 |
1836727 | 1836727 | 2021-10-21 | Cumberland | Illinois | 17035 | 1902 | 38 |
1837447 | 1837447 | 2021-10-21 | Chippewa | Minnesota | 27023 | 1902 | 40 |
1838460 | 1838460 | 2021-10-21 | Cidra | Puerto Rico | 72041 | 1902 | |
1835211 | 1835211 | 2021-10-20 | Cidra | Puerto Rico | 72041 | 1902 | |
1830970 | 1830970 | 2021-10-19 | Kanabec | Minnesota | 27065 | 1902 | 30 |
1829251 | 1829251 | 2021-10-18 | Juab | Utah | 49023 | 1902 | 18 |
1824702 | 1824702 | 2021-10-17 | Ripley | Missouri | 29181 | 1902 | 24 |
1825231 | 1825231 | 2021-10-17 | Morgan | Ohio | 39115 | 1902 | 32 |
1826002 | 1826002 | 2021-10-17 | Juab | Utah | 49023 | 1902 | 18 |
1822753 | 1822753 | 2021-10-16 | Juab | Utah | 49023 | 1902 | 18 |
1819504 | 1819504 | 2021-10-15 | Juab | Utah | 49023 | 1902 | 18 |
1815708 | 1815708 | 2021-10-14 | Cabo Rojo | Puerto Rico | 72023 | 1902 | |
1812460 | 1812460 | 2021-10-13 | Cabo Rojo | Puerto Rico | 72023 | 1902 | |
1786472 | 1786472 | 2021-10-05 | Catano | Puerto Rico | 72033 | 1902 | |
1787143 | 1787143 | 2021-10-05 | Patrick | Virginia | 51141 | 1902 | 52 |
1782507 | 1782507 | 2021-10-04 | Glacier | Montana | 30035 | 1902 | 48 |
1783223 | 1783223 | 2021-10-04 | Catano | Puerto Rico | 72033 | 1902 | |
1779974 | 1779974 | 2021-10-03 | Catano | Puerto Rico | 72033 | 1902 | |
1754763 | 1754763 | 2021-09-25 | Monroe | West Virginia | 54063 | 1902 | 21 |
1745286 | 1745286 | 2021-09-23 | Little River | Arkansas | 5081 | 1902 | 44 |
1733522 | 1733522 | 2021-09-19 | Pennington | Minnesota | 27113 | 1902 | 21 |
1730272 | 1730272 | 2021-09-18 | Pennington | Minnesota | 27113 | 1902 | 21 |
1727022 | 1727022 | 2021-09-17 | Pennington | Minnesota | 27113 | 1902 | 21 |
1727987 | 1727987 | 2021-09-17 | Cayey | Puerto Rico | 72035 | 1902 | |
1683279 | 1683279 | 2021-09-03 | Lincoln | West Virginia | 54043 | 1902 | 28 |
1670569 | 1670569 | 2021-08-31 | Marion | Arkansas | 5089 | 1902 | 49 |
1668521 | 1668521 | 2021-08-30 | Houston | Minnesota | 27055 | 1902 | 16 |
1655432 | 1655432 | 2021-08-26 | Charlevoix | Michigan | 26029 | 1902 | 26 |
1646692 | 1646692 | 2021-08-23 | Wasco | Oregon | 41065 | 1902 | 37 |
1631062 | 1631062 | 2021-08-18 | Zapata | Texas | 48505 | 1902 | 38 |
1627296 | 1627296 | 2021-08-17 | Fajardo | Puerto Rico | 72053 | 1902 | |
1618838 | 1618838 | 2021-08-15 | Bacon | Georgia | 13005 | 1902 | 41 |
1615590 | 1615590 | 2021-08-14 | Bacon | Georgia | 13005 | 1902 | 41 |
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);