ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
230 rows where cases = 2082 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 24
- Texas 24
- Georgia 15
- Virginia 13
- Wisconsin 12
- Illinois 10
- Indiana 9
- Missouri 9
- Tennessee 9
- Arkansas 8
- North Carolina 8
- Alabama 7
- Colorado 7
- Louisiana 7
- Minnesota 6
- Ohio 6
- Idaho 5
- Iowa 5
- Puerto Rico 5
- South Dakota 5
- Mississippi 4
- North Dakota 4
- Washington 4
- Nebraska 3
- Kansas 2
- Maine 2
- Michigan 2
- Montana 2
- New York 2
- West Virginia 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500068 | 2500068 | 2022-05-13 | Montgomery | Georgia | 13209 | 2082 | 53 |
2496810 | 2496810 | 2022-05-12 | Montgomery | Georgia | 13209 | 2082 | 53 |
2493552 | 2493552 | 2022-05-11 | Montgomery | Georgia | 13209 | 2082 | 53 |
2442713 | 2442713 | 2022-04-25 | Unknown | Nebraska | 2082 | 461 | |
2438790 | 2438790 | 2022-04-24 | Nicholas | Kentucky | 21181 | 2082 | 31 |
2439063 | 2439063 | 2022-04-24 | Lake | Minnesota | 27075 | 2082 | 28 |
2440042 | 2440042 | 2022-04-24 | Arroyo | Puerto Rico | 72015 | 2082 | |
2435534 | 2435534 | 2022-04-23 | Nicholas | Kentucky | 21181 | 2082 | 31 |
2435807 | 2435807 | 2022-04-23 | Lake | Minnesota | 27075 | 2082 | 28 |
2432278 | 2432278 | 2022-04-22 | Nicholas | Kentucky | 21181 | 2082 | 31 |
2432551 | 2432551 | 2022-04-22 | Lake | Minnesota | 27075 | 2082 | 28 |
2429022 | 2429022 | 2022-04-21 | Nicholas | Kentucky | 21181 | 2082 | 31 |
2425766 | 2425766 | 2022-04-20 | Nicholas | Kentucky | 21181 | 2082 | 31 |
2422510 | 2422510 | 2022-04-19 | Nicholas | Kentucky | 21181 | 2082 | 31 |
2419254 | 2419254 | 2022-04-18 | Nicholas | Kentucky | 21181 | 2082 | 31 |
2350384 | 2350384 | 2022-03-28 | Boundary | Idaho | 16021 | 2082 | 59 |
2351187 | 2351187 | 2022-03-28 | Marshall | Minnesota | 27089 | 2082 | 23 |
2347131 | 2347131 | 2022-03-27 | Boundary | Idaho | 16021 | 2082 | 59 |
2343878 | 2343878 | 2022-03-26 | Boundary | Idaho | 16021 | 2082 | 59 |
2340625 | 2340625 | 2022-03-25 | Boundary | Idaho | 16021 | 2082 | 59 |
2334340 | 2334340 | 2022-03-23 | Warren | Indiana | 18171 | 2082 | 30 |
2285184 | 2285184 | 2022-03-08 | Clinch | Georgia | 13065 | 2082 | 40 |
2255885 | 2255885 | 2022-02-27 | Atkinson | Georgia | 13003 | 2082 | 44 |
2252294 | 2252294 | 2022-02-26 | Perry | Alabama | 1105 | 2082 | 43 |
2252634 | 2252634 | 2022-02-26 | Atkinson | Georgia | 13003 | 2082 | 44 |
2249383 | 2249383 | 2022-02-25 | Atkinson | Georgia | 13003 | 2082 | 44 |
2246753 | 2246753 | 2022-02-24 | Bracken | Kentucky | 21023 | 2082 | 23 |
2243502 | 2243502 | 2022-02-23 | Bracken | Kentucky | 21023 | 2082 | 23 |
2240251 | 2240251 | 2022-02-22 | Bracken | Kentucky | 21023 | 2082 | 23 |
2240836 | 2240836 | 2022-02-22 | St. Clair | Missouri | 29185 | 2082 | 31 |
2232191 | 2232191 | 2022-02-19 | Franklin | Texas | 48159 | 2082 | 39 |
2220762 | 2220762 | 2022-02-16 | Cumberland | Kentucky | 21057 | 2082 | 27 |
2222571 | 2222571 | 2022-02-16 | Somervell | Texas | 48425 | 2082 | 32 |
2219320 | 2219320 | 2022-02-15 | Somervell | Texas | 48425 | 2082 | 32 |
2202613 | 2202613 | 2022-02-10 | Rincon | Puerto Rico | 72117 | 2082 | |
2190617 | 2190617 | 2022-02-07 | Nevada | Arkansas | 5099 | 2082 | 43 |
2142797 | 2142797 | 2022-01-23 | East Carroll | Louisiana | 22035 | 2082 | 35 |
2139542 | 2139542 | 2022-01-22 | East Carroll | Louisiana | 22035 | 2082 | 35 |
2136286 | 2136286 | 2022-01-21 | East Carroll | Louisiana | 22035 | 2082 | 35 |
2130570 | 2130570 | 2022-01-19 | Clay | North Carolina | 37043 | 2082 | 38 |
2119592 | 2119592 | 2022-01-16 | Benton | Indiana | 18007 | 2082 | 21 |
2116340 | 2116340 | 2022-01-15 | Benton | Indiana | 18007 | 2082 | 21 |
2113089 | 2113089 | 2022-01-14 | Benton | Indiana | 18007 | 2082 | 21 |
2100017 | 2100017 | 2022-01-10 | Jasper | Illinois | 17079 | 2082 | 26 |
2100383 | 2100383 | 2022-01-10 | Bath | Kentucky | 21011 | 2082 | 34 |
2032186 | 2032186 | 2021-12-20 | Lyon | Kentucky | 21143 | 2082 | 29 |
2033466 | 2033466 | 2021-12-20 | Cidra | Puerto Rico | 72041 | 2082 | |
2011319 | 2011319 | 2021-12-13 | Dickenson | Virginia | 51051 | 2082 | 31 |
1971386 | 1971386 | 2021-12-01 | McLean | North Dakota | 38055 | 2082 | 44 |
1927374 | 1927374 | 2021-11-18 | Las Animas | Colorado | 8071 | 2082 | 26 |
1923571 | 1923571 | 2021-11-16 | Goochland | Virginia | 51075 | 2082 | 31 |
1895228 | 1895228 | 2021-11-08 | Greene | Illinois | 17061 | 2082 | 53 |
1893469 | 1893469 | 2021-11-07 | Noble | Ohio | 39121 | 2082 | 47 |
1890219 | 1890219 | 2021-11-06 | Noble | Ohio | 39121 | 2082 | 47 |
1877671 | 1877671 | 2021-11-02 | Jackson | Tennessee | 47087 | 2082 | 40 |
1836045 | 1836045 | 2021-10-20 | Lafayette | Wisconsin | 55065 | 2082 | 12 |
1805658 | 1805658 | 2021-10-11 | Ramsey | North Dakota | 38071 | 2082 | 33 |
1806763 | 1806763 | 2021-10-11 | Taylor | West Virginia | 54091 | 2082 | 36 |
1803587 | 1803587 | 2021-10-10 | Washburn | Wisconsin | 55129 | 2082 | 26 |
1800338 | 1800338 | 2021-10-09 | Washburn | Wisconsin | 55129 | 2082 | 26 |
1797089 | 1797089 | 2021-10-08 | Washburn | Wisconsin | 55129 | 2082 | 26 |
1781950 | 1781950 | 2021-10-04 | Magoffin | Kentucky | 21153 | 2082 | 18 |
1768573 | 1768573 | 2021-09-30 | Washington | Illinois | 17189 | 2082 | 34 |
1770547 | 1770547 | 2021-09-30 | Comanche | Texas | 48093 | 2082 | 59 |
1767216 | 1767216 | 2021-09-29 | Meigs | Tennessee | 47121 | 2082 | 26 |
1762728 | 1762728 | 2021-09-28 | Fillmore | Minnesota | 27045 | 2082 | 11 |
1762944 | 1762944 | 2021-09-28 | Mississippi | Missouri | 29133 | 2082 | 37 |
1761139 | 1761139 | 2021-09-27 | New Kent | Virginia | 51127 | 2082 | 20 |
1746180 | 1746180 | 2021-09-23 | Green | Kentucky | 21087 | 2082 | 27 |
1746694 | 1746694 | 2021-09-23 | Macon | Missouri | 29121 | 2082 | 20 |
1737502 | 1737502 | 2021-09-20 | Meigs | Ohio | 39105 | 2082 | 42 |
1723060 | 1723060 | 2021-09-16 | Moultrie | Illinois | 17139 | 2082 | 39 |
1714642 | 1714642 | 2021-09-13 | Warren | North Carolina | 37185 | 2082 | 20 |
1710464 | 1710464 | 2021-09-12 | Lawrence | Kentucky | 21127 | 2082 | 32 |
1707217 | 1707217 | 2021-09-11 | Lawrence | Kentucky | 21127 | 2082 | 32 |
1703969 | 1703969 | 2021-09-10 | Lawrence | Kentucky | 21127 | 2082 | 32 |
1682928 | 1682928 | 2021-09-03 | Leon | Texas | 48289 | 2082 | 49 |
1669477 | 1669477 | 2021-08-30 | Montour | Pennsylvania | 42093 | 2082 | 67 |
1660106 | 1660106 | 2021-08-27 | DeWitt | Texas | 48123 | 2082 | 65 |
1654481 | 1654481 | 2021-08-26 | Teller | Colorado | 8119 | 2082 | 19 |
1656857 | 1656857 | 2021-08-26 | DeWitt | Texas | 48123 | 2082 | 65 |
1651556 | 1651556 | 2021-08-25 | Ford | Illinois | 17053 | 2082 | 60 |
1644199 | 1644199 | 2021-08-22 | Nottoway | Virginia | 51135 | 2082 | 55 |
1640949 | 1640949 | 2021-08-21 | Nottoway | Virginia | 51135 | 2082 | 55 |
1637699 | 1637699 | 2021-08-20 | Nottoway | Virginia | 51135 | 2082 | 55 |
1634115 | 1634115 | 2021-08-19 | DeWitt | Texas | 48123 | 2082 | 64 |
1630868 | 1630868 | 2021-08-18 | DeWitt | Texas | 48123 | 2082 | 64 |
1625704 | 1625704 | 2021-08-17 | Perry | Indiana | 18123 | 2082 | 41 |
1627621 | 1627621 | 2021-08-17 | DeWitt | Texas | 48123 | 2082 | 64 |
1621757 | 1621757 | 2021-08-16 | Washington | Alabama | 1129 | 2082 | 39 |
1617087 | 1617087 | 2021-08-14 | Seneca | New York | 36099 | 2082 | 57 |
1613135 | 1613135 | 2021-08-13 | Aroostook | Maine | 23003 | 2082 | 54 |
1610279 | 1610279 | 2021-08-12 | Pike | Missouri | 29163 | 2082 | 28 |
1582675 | 1582675 | 2021-08-03 | Vernon | Wisconsin | 55123 | 2082 | 43 |
1566394 | 1566394 | 2021-07-29 | Green Lake | Wisconsin | 55047 | 2082 | 25 |
1562967 | 1562967 | 2021-07-28 | Louisa | Virginia | 51109 | 2082 | 34 |
1559719 | 1559719 | 2021-07-27 | Louisa | Virginia | 51109 | 2082 | 34 |
1535397 | 1535397 | 2021-07-20 | Wabasha | Minnesota | 27157 | 2082 | 3 |
1518363 | 1518363 | 2021-07-15 | Cass | Illinois | 17017 | 2082 | 36 |
1511373 | 1511373 | 2021-07-13 | Ashley | Arkansas | 5003 | 2082 | 36 |
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);