ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
215 rows where cases = 2629 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 24
- Georgia 18
- Missouri 14
- Iowa 12
- Kentucky 12
- Texas 12
- South Carolina 9
- Virginia 9
- Indiana 8
- Wisconsin 8
- Idaho 7
- Michigan 7
- Mississippi 7
- Illinois 6
- Arkansas 5
- Montana 5
- Alabama 4
- Ohio 4
- Pennsylvania 4
- Tennessee 4
- West Virginia 4
- Kansas 3
- Minnesota 3
- New Mexico 3
- Oklahoma 3
- Washington 3
- California 2
- Colorado 2
- New York 2
- Hawaii 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500840 | 2500840 | 2022-05-13 | Crawford | Michigan | 26039 | 2629 | 31 |
2497582 | 2497582 | 2022-05-12 | Crawford | Michigan | 26039 | 2629 | 31 |
2494324 | 2494324 | 2022-05-11 | Crawford | Michigan | 26039 | 2629 | 31 |
2491733 | 2491733 | 2022-05-10 | Clay | North Carolina | 37043 | 2629 | 44 |
2488475 | 2488475 | 2022-05-09 | Clay | North Carolina | 37043 | 2629 | 44 |
2485218 | 2485218 | 2022-05-08 | Clay | North Carolina | 37043 | 2629 | 44 |
2481960 | 2481960 | 2022-05-07 | Clay | North Carolina | 37043 | 2629 | 44 |
2478702 | 2478702 | 2022-05-06 | Clay | North Carolina | 37043 | 2629 | 44 |
2474112 | 2474112 | 2022-05-05 | Valley | Idaho | 16085 | 2629 | 16 |
2475444 | 2475444 | 2022-05-05 | Clay | North Carolina | 37043 | 2629 | 44 |
2470855 | 2470855 | 2022-05-04 | Valley | Idaho | 16085 | 2629 | 16 |
2472187 | 2472187 | 2022-05-04 | Clay | North Carolina | 37043 | 2629 | 44 |
2406540 | 2406540 | 2022-04-14 | Stevens | Minnesota | 27149 | 2629 | 13 |
2401563 | 2401563 | 2022-04-12 | Amelia | Virginia | 51007 | 2629 | 60 |
2393774 | 2393774 | 2022-04-10 | Richland | Montana | 30083 | 2629 | 33 |
2390518 | 2390518 | 2022-04-09 | Richland | Montana | 30083 | 2629 | 33 |
2387262 | 2387262 | 2022-04-08 | Richland | Montana | 30083 | 2629 | 33 |
2375253 | 2375253 | 2022-04-04 | Childress | Texas | 48075 | 2629 | 31 |
2372001 | 2372001 | 2022-04-03 | Childress | Texas | 48075 | 2629 | 31 |
2368748 | 2368748 | 2022-04-02 | Childress | Texas | 48075 | 2629 | 31 |
2331955 | 2331955 | 2022-03-22 | Rosebud | Montana | 30087 | 2629 | 59 |
2328702 | 2328702 | 2022-03-21 | Rosebud | Montana | 30087 | 2629 | 59 |
2328972 | 2328972 | 2022-03-21 | Clay | North Carolina | 37043 | 2629 | 39 |
2310559 | 2310559 | 2022-03-15 | Richmond | Virginia | 51159 | 2629 | 27 |
2232871 | 2232871 | 2022-02-20 | Fulton | Arkansas | 5049 | 2629 | 83 |
2187802 | 2187802 | 2022-02-06 | Teton | Idaho | 16081 | 2629 | 8 |
2184549 | 2184549 | 2022-02-05 | Teton | Idaho | 16081 | 2629 | 8 |
2181297 | 2181297 | 2022-02-04 | Teton | Idaho | 16081 | 2629 | 8 |
2179920 | 2179920 | 2022-02-03 | Butte | South Dakota | 46019 | 2629 | 44 |
2149504 | 2149504 | 2022-01-25 | Chippewa | Minnesota | 27023 | 2629 | 45 |
2107974 | 2107974 | 2022-01-12 | Harrison | Ohio | 39067 | 2629 | 60 |
2103474 | 2103474 | 2022-01-11 | Jefferson | Iowa | 19101 | 2629 | 44 |
2100223 | 2100223 | 2022-01-10 | Jefferson | Iowa | 19101 | 2629 | 44 |
2096972 | 2096972 | 2022-01-09 | Jefferson | Iowa | 19101 | 2629 | 44 |
2093720 | 2093720 | 2022-01-08 | Jefferson | Iowa | 19101 | 2629 | 44 |
2090468 | 2090468 | 2022-01-07 | Jefferson | Iowa | 19101 | 2629 | 44 |
2091939 | 2091939 | 2022-01-07 | Potter | Pennsylvania | 42105 | 2629 | 80 |
2087217 | 2087217 | 2022-01-06 | Jefferson | Iowa | 19101 | 2629 | 44 |
2083965 | 2083965 | 2022-01-05 | Jefferson | Iowa | 19101 | 2629 | 44 |
2055775 | 2055775 | 2021-12-27 | Bertie | North Carolina | 37015 | 2629 | 54 |
2051673 | 2051673 | 2021-12-26 | Knott | Kentucky | 21119 | 2629 | 46 |
2052525 | 2052525 | 2021-12-26 | Bertie | North Carolina | 37015 | 2629 | 54 |
2048423 | 2048423 | 2021-12-25 | Knott | Kentucky | 21119 | 2629 | 46 |
2049275 | 2049275 | 2021-12-25 | Bertie | North Carolina | 37015 | 2629 | 54 |
2045173 | 2045173 | 2021-12-24 | Knott | Kentucky | 21119 | 2629 | 46 |
2046025 | 2046025 | 2021-12-24 | Bertie | North Carolina | 37015 | 2629 | 54 |
2041924 | 2041924 | 2021-12-23 | Knott | Kentucky | 21119 | 2629 | 46 |
2042775 | 2042775 | 2021-12-23 | Bertie | North Carolina | 37015 | 2629 | 54 |
2038658 | 2038658 | 2021-12-22 | Green | Kentucky | 21087 | 2629 | 39 |
2038674 | 2038674 | 2021-12-22 | Knott | Kentucky | 21119 | 2629 | 46 |
2039526 | 2039526 | 2021-12-22 | Bertie | North Carolina | 37015 | 2629 | 54 |
2035408 | 2035408 | 2021-12-21 | Green | Kentucky | 21087 | 2629 | 39 |
2031878 | 2031878 | 2021-12-20 | Parke | Indiana | 18121 | 2629 | 34 |
2028646 | 2028646 | 2021-12-19 | Tipton | Indiana | 18159 | 2629 | 70 |
2030321 | 2030321 | 2021-12-19 | Saluda | South Carolina | 45081 | 2629 | 59 |
2025395 | 2025395 | 2021-12-18 | Tipton | Indiana | 18159 | 2629 | 70 |
2027070 | 2027070 | 2021-12-18 | Saluda | South Carolina | 45081 | 2629 | 59 |
2022144 | 2022144 | 2021-12-17 | Tipton | Indiana | 18159 | 2629 | 70 |
2023819 | 2023819 | 2021-12-17 | Saluda | South Carolina | 45081 | 2629 | 59 |
2016623 | 2016623 | 2021-12-15 | York | Nebraska | 31185 | 2629 | 19 |
1973247 | 1973247 | 2021-12-02 | Jo Daviess | Illinois | 17085 | 2629 | 32 |
1974835 | 1974835 | 2021-12-02 | Clatsop | Oregon | 41007 | 2629 | 35 |
1969296 | 1969296 | 2021-11-30 | Marquette | Wisconsin | 55077 | 2629 | 37 |
1961571 | 1961571 | 2021-11-28 | Northampton | North Carolina | 37131 | 2629 | 66 |
1958320 | 1958320 | 2021-11-27 | Northampton | North Carolina | 37131 | 2629 | 66 |
1955069 | 1955069 | 2021-11-26 | Northampton | North Carolina | 37131 | 2629 | 66 |
1951818 | 1951818 | 2021-11-25 | Northampton | North Carolina | 37131 | 2629 | 66 |
1948567 | 1948567 | 2021-11-24 | Northampton | North Carolina | 37131 | 2629 | 66 |
1921103 | 1921103 | 2021-11-16 | Rabun | Georgia | 13241 | 2629 | 70 |
1914487 | 1914487 | 2021-11-14 | Bacon | Georgia | 13005 | 2629 | 62 |
1915173 | 1915173 | 2021-11-14 | Mason | Kentucky | 21161 | 2629 | 70 |
1915708 | 1915708 | 2021-11-14 | Wright | Missouri | 29229 | 2629 | 54 |
1911237 | 1911237 | 2021-11-13 | Bacon | Georgia | 13005 | 2629 | 62 |
1911923 | 1911923 | 2021-11-13 | Mason | Kentucky | 21161 | 2629 | 70 |
1907988 | 1907988 | 2021-11-12 | Bacon | Georgia | 13005 | 2629 | 62 |
1908674 | 1908674 | 2021-11-12 | Mason | Kentucky | 21161 | 2629 | 70 |
1906189 | 1906189 | 2021-11-11 | Taos | New Mexico | 35055 | 2629 | 66 |
1902940 | 1902940 | 2021-11-10 | Taos | New Mexico | 35055 | 2629 | 66 |
1859478 | 1859478 | 2021-10-28 | Edgar | Illinois | 17045 | 2629 | 69 |
1830801 | 1830801 | 2021-10-19 | Hancock | Maine | 23009 | 2629 | 47 |
1805549 | 1805549 | 2021-10-11 | Currituck | North Carolina | 37053 | 2629 | 25 |
1788139 | 1788139 | 2021-10-06 | Perry | Indiana | 18123 | 2629 | 57 |
1784245 | 1784245 | 2021-10-05 | Clay | Arkansas | 5021 | 2629 | 60 |
1741465 | 1741465 | 2021-09-21 | San Jacinto | Texas | 48407 | 2629 | 55 |
1703036 | 1703036 | 2021-09-10 | Drew | Arkansas | 5043 | 2629 | 53 |
1691175 | 1691175 | 2021-09-06 | Emmet | Michigan | 26047 | 2629 | 45 |
1687925 | 1687925 | 2021-09-05 | Emmet | Michigan | 26047 | 2629 | 45 |
1684675 | 1684675 | 2021-09-04 | Emmet | Michigan | 26047 | 2629 | 45 |
1681424 | 1681424 | 2021-09-03 | Emmet | Michigan | 26047 | 2629 | 45 |
1674783 | 1674783 | 2021-09-01 | Woodford | Kentucky | 21239 | 2629 | 23 |
1675085 | 1675085 | 2021-09-01 | Chickasaw | Mississippi | 28017 | 2629 | 61 |
1659031 | 1659031 | 2021-08-27 | Vernon | Missouri | 29217 | 2629 | 52 |
1627914 | 1627914 | 2021-08-17 | Gloucester | Virginia | 51073 | 2629 | 53 |
1624432 | 1624432 | 2021-08-16 | Hutchinson | Texas | 48233 | 2629 | 72 |
1621185 | 1621185 | 2021-08-15 | Hutchinson | Texas | 48233 | 2629 | 72 |
1617937 | 1617937 | 2021-08-14 | Hutchinson | Texas | 48233 | 2629 | 72 |
1611413 | 1611413 | 2021-08-12 | Gray | Texas | 48179 | 2629 | 58 |
1608109 | 1608109 | 2021-08-11 | Cass | Texas | 48067 | 2629 | 87 |
1598956 | 1598956 | 2021-08-09 | Barbour | Alabama | 1005 | 2629 | 63 |
1579503 | 1579503 | 2021-08-03 | Marengo | Alabama | 1091 | 2629 | 67 |
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);