ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
385 rows where cases = 1293 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 38
- Iowa 28
- Oklahoma 24
- Kentucky 21
- Virginia 20
- Georgia 16
- Puerto Rico 16
- Arkansas 15
- Texas 15
- California 14
- Missouri 13
- Illinois 12
- Wisconsin 12
- North Dakota 10
- Tennessee 10
- Florida 9
- Minnesota 9
- Ohio 9
- North Carolina 8
- Idaho 7
- Louisiana 7
- West Virginia 7
- Alabama 6
- Colorado 6
- Kansas 6
- Indiana 5
- Nebraska 5
- Montana 4
- New Mexico 4
- Washington 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471998 | 2471998 | 2022-05-04 | Pierce | Nebraska | 31139 | 1293 | 21 |
2468742 | 2468742 | 2022-05-03 | Pierce | Nebraska | 31139 | 1293 | 21 |
2404065 | 2404065 | 2022-04-13 | Greer | Oklahoma | 40055 | 1293 | 36 |
2400810 | 2400810 | 2022-04-12 | Greer | Oklahoma | 40055 | 1293 | 36 |
2397555 | 2397555 | 2022-04-11 | Greer | Oklahoma | 40055 | 1293 | 36 |
2394300 | 2394300 | 2022-04-10 | Greer | Oklahoma | 40055 | 1293 | 36 |
2391044 | 2391044 | 2022-04-09 | Greer | Oklahoma | 40055 | 1293 | 36 |
2387788 | 2387788 | 2022-04-08 | Greer | Oklahoma | 40055 | 1293 | 36 |
2384533 | 2384533 | 2022-04-07 | Greer | Oklahoma | 40055 | 1293 | 36 |
2381278 | 2381278 | 2022-04-06 | Greer | Oklahoma | 40055 | 1293 | 35 |
2378023 | 2378023 | 2022-04-05 | Greer | Oklahoma | 40055 | 1293 | 35 |
2374769 | 2374769 | 2022-04-04 | Greer | Oklahoma | 40055 | 1293 | 35 |
2371517 | 2371517 | 2022-04-03 | Greer | Oklahoma | 40055 | 1293 | 35 |
2368264 | 2368264 | 2022-04-02 | Greer | Oklahoma | 40055 | 1293 | 35 |
2365011 | 2365011 | 2022-04-01 | Greer | Oklahoma | 40055 | 1293 | 35 |
2361758 | 2361758 | 2022-03-31 | Greer | Oklahoma | 40055 | 1293 | 35 |
2284527 | 2284527 | 2022-03-07 | Norton city | Virginia | 51720 | 1293 | 22 |
2280288 | 2280288 | 2022-03-06 | McHenry | North Dakota | 38049 | 1293 | 31 |
2277035 | 2277035 | 2022-03-05 | McHenry | North Dakota | 38049 | 1293 | 31 |
2198790 | 2198790 | 2022-02-09 | Guadalupe | New Mexico | 35019 | 1293 | 16 |
2174604 | 2174604 | 2022-02-02 | Calhoun | Georgia | 13037 | 1293 | 22 |
2150944 | 2150944 | 2022-01-25 | Lynn | Texas | 48305 | 1293 | 31 |
2115791 | 2115791 | 2022-01-15 | Montgomery | Arkansas | 5097 | 1293 | 53 |
2109601 | 2109601 | 2022-01-13 | Jenkins | Georgia | 13165 | 1293 | 63 |
2111910 | 2111910 | 2022-01-13 | Marion | Texas | 48315 | 1293 | 55 |
2106063 | 2106063 | 2022-01-12 | Woodruff | Arkansas | 5147 | 1293 | 24 |
2079100 | 2079100 | 2022-01-03 | Fall River | South Dakota | 46047 | 1293 | 30 |
2066576 | 2066576 | 2021-12-30 | Fairfax city | Virginia | 51600 | 1293 | 36 |
2037065 | 2037065 | 2021-12-21 | Floyd | Texas | 48153 | 1293 | 40 |
2029226 | 2029226 | 2021-12-19 | Lac qui Parle | Minnesota | 27073 | 1293 | 26 |
2025975 | 2025975 | 2021-12-18 | Lac qui Parle | Minnesota | 27073 | 1293 | 26 |
2022724 | 2022724 | 2021-12-17 | Lac qui Parle | Minnesota | 27073 | 1293 | 26 |
2024201 | 2024201 | 2021-12-17 | Stephens | Texas | 48429 | 1293 | 37 |
2020606 | 2020606 | 2021-12-16 | Hutchinson | South Dakota | 46067 | 1293 | 28 |
2020950 | 2020950 | 2021-12-16 | Stephens | Texas | 48429 | 1293 | 37 |
1985771 | 1985771 | 2021-12-06 | Prairie | Arkansas | 5117 | 1293 | 29 |
1984915 | 1984915 | 2021-12-05 | Hancock | Tennessee | 47067 | 1293 | 21 |
1981665 | 1981665 | 2021-12-04 | Hancock | Tennessee | 47067 | 1293 | 21 |
1978415 | 1978415 | 2021-12-03 | Hancock | Tennessee | 47067 | 1293 | 21 |
1964686 | 1964686 | 2021-11-29 | Quay | New Mexico | 35037 | 1293 | 25 |
1927616 | 1927616 | 2021-11-18 | Taylor | Georgia | 13269 | 1293 | 38 |
1926807 | 1926807 | 2021-11-17 | Essex | Virginia | 51057 | 1293 | 20 |
1907626 | 1907626 | 2021-11-12 | Greene | Alabama | 1063 | 1293 | 44 |
1909633 | 1909633 | 2021-11-12 | Pembina | North Dakota | 38067 | 1293 | 13 |
1904377 | 1904377 | 2021-11-11 | Greene | Alabama | 1063 | 1293 | 44 |
1900041 | 1900041 | 2021-11-09 | Major | Oklahoma | 40093 | 1293 | 32 |
1900953 | 1900953 | 2021-11-09 | Clay | West Virginia | 54015 | 1293 | 20 |
1896791 | 1896791 | 2021-11-08 | Major | Oklahoma | 40093 | 1293 | 32 |
1897703 | 1897703 | 2021-11-08 | Clay | West Virginia | 54015 | 1293 | 20 |
1893541 | 1893541 | 2021-11-07 | Major | Oklahoma | 40093 | 1293 | 32 |
1890291 | 1890291 | 2021-11-06 | Major | Oklahoma | 40093 | 1293 | 32 |
1887041 | 1887041 | 2021-11-05 | Major | Oklahoma | 40093 | 1293 | 32 |
1883791 | 1883791 | 2021-11-04 | Major | Oklahoma | 40093 | 1293 | 32 |
1879883 | 1879883 | 2021-11-03 | Gentry | Missouri | 29075 | 1293 | 27 |
1880542 | 1880542 | 2021-11-03 | Major | Oklahoma | 40093 | 1293 | 32 |
1881297 | 1881297 | 2021-11-03 | Charlotte | Virginia | 51037 | 1293 | 27 |
1876029 | 1876029 | 2021-11-02 | Grant | Kansas | 20067 | 1293 | 29 |
1819273 | 1819273 | 2021-10-15 | Castro | Texas | 48069 | 1293 | 34 |
1811488 | 1811488 | 2021-10-13 | Marshall | Minnesota | 27089 | 1293 | 19 |
1809890 | 1809890 | 2021-10-12 | Poquoson city | Virginia | 51735 | 1293 | 19 |
1801754 | 1801754 | 2021-10-10 | Pipestone | Minnesota | 27117 | 1293 | 27 |
1798505 | 1798505 | 2021-10-09 | Pipestone | Minnesota | 27117 | 1293 | 27 |
1795256 | 1795256 | 2021-10-08 | Pipestone | Minnesota | 27117 | 1293 | 27 |
1784021 | 1784021 | 2021-10-04 | Tyler | West Virginia | 54095 | 1293 | 18 |
1778109 | 1778109 | 2021-10-03 | Macon | Georgia | 13193 | 1293 | 39 |
1778720 | 1778720 | 2021-10-03 | Owen | Kentucky | 21187 | 1293 | 20 |
1774859 | 1774859 | 2021-10-02 | Macon | Georgia | 13193 | 1293 | 39 |
1775470 | 1775470 | 2021-10-02 | Owen | Kentucky | 21187 | 1293 | 20 |
1771609 | 1771609 | 2021-10-01 | Macon | Georgia | 13193 | 1293 | 39 |
1772220 | 1772220 | 2021-10-01 | Owen | Kentucky | 21187 | 1293 | 20 |
1762803 | 1762803 | 2021-09-28 | Choctaw | Mississippi | 28019 | 1293 | 26 |
1763055 | 1763055 | 2021-09-28 | Box Butte | Nebraska | 31013 | 1293 | 12 |
1755929 | 1755929 | 2021-09-26 | Hancock | Kentucky | 21091 | 1293 | 16 |
1756425 | 1756425 | 2021-09-26 | Iron | Missouri | 29093 | 1293 | 10 |
1756455 | 1756455 | 2021-09-26 | Oregon | Missouri | 29149 | 1293 | 10 |
1752681 | 1752681 | 2021-09-25 | Hancock | Kentucky | 21091 | 1293 | 16 |
1753207 | 1753207 | 2021-09-25 | Oregon | Missouri | 29149 | 1293 | 10 |
1749432 | 1749432 | 2021-09-24 | Hancock | Kentucky | 21091 | 1293 | 16 |
1733763 | 1733763 | 2021-09-19 | Dawson | Montana | 30021 | 1293 | 32 |
1730513 | 1730513 | 2021-09-18 | Dawson | Montana | 30021 | 1293 | 32 |
1727263 | 1727263 | 2021-09-17 | Dawson | Montana | 30021 | 1293 | 32 |
1720654 | 1720654 | 2021-09-15 | Carroll | Missouri | 29033 | 1293 | 25 |
1718852 | 1718852 | 2021-09-14 | Dickenson | Virginia | 51051 | 1293 | 20 |
1713808 | 1713808 | 2021-09-13 | Red River | Louisiana | 22081 | 1293 | 42 |
1714186 | 1714186 | 2021-09-13 | Howard | Missouri | 29089 | 1293 | 11 |
1697065 | 1697065 | 2021-09-08 | Marshall | Illinois | 17123 | 1293 | 23 |
1695062 | 1695062 | 2021-09-07 | Yates | New York | 36123 | 1293 | 26 |
1664003 | 1664003 | 2021-08-29 | North Slope Borough | Alaska | 2185 | 1293 | 4 |
1666915 | 1666915 | 2021-08-29 | Lexington city | Virginia | 51678 | 1293 | 33 |
1660755 | 1660755 | 2021-08-28 | North Slope Borough | Alaska | 2185 | 1293 | 4 |
1663667 | 1663667 | 2021-08-28 | Lexington city | Virginia | 51678 | 1293 | 33 |
1657507 | 1657507 | 2021-08-27 | North Slope Borough | Alaska | 2185 | 1293 | 4 |
1658992 | 1658992 | 2021-08-27 | Montgomery | Missouri | 29139 | 1293 | 17 |
1660419 | 1660419 | 2021-08-27 | Lexington city | Virginia | 51678 | 1293 | 33 |
1651092 | 1651092 | 2021-08-25 | Perry | Arkansas | 5105 | 1293 | 13 |
1651444 | 1651444 | 2021-08-25 | Seminole | Georgia | 13253 | 1293 | 20 |
1653244 | 1653244 | 2021-08-25 | Potter | Pennsylvania | 42105 | 1293 | 26 |
1648116 | 1648116 | 2021-08-24 | Dooly | Georgia | 13093 | 1293 | 47 |
1625780 | 1625780 | 2021-08-17 | Humboldt | Iowa | 19091 | 1293 | 26 |
1622289 | 1622289 | 2021-08-16 | Teton | Idaho | 16081 | 1293 | 4 |
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);