ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where cases = 2752 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 20
- Texas 16
- Illinois 10
- Kentucky 10
- Tennessee 10
- Arkansas 7
- Kansas 7
- Virginia 7
- Georgia 6
- Indiana 5
- Missouri 5
- Ohio 5
- South Carolina 5
- Louisiana 4
- Michigan 4
- Colorado 3
- Minnesota 3
- Mississippi 3
- Pennsylvania 3
- Puerto Rico 3
- New York 2
- North Carolina 2
- Oklahoma 2
- South Dakota 2
- Vermont 2
- Wyoming 2
- Idaho 1
- Iowa 1
- Maryland 1
- Nebraska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2324451 | 2324451 | 2022-03-20 | Marshall | Illinois | 17123 | 2752 | 33 |
2321197 | 2321197 | 2022-03-19 | Marshall | Illinois | 17123 | 2752 | 33 |
2317943 | 2317943 | 2022-03-18 | Marshall | Illinois | 17123 | 2752 | 33 |
2220313 | 2220313 | 2022-02-16 | Gooding | Idaho | 16047 | 2752 | 51 |
2188315 | 2188315 | 2022-02-06 | Todd | Kentucky | 21219 | 2752 | 40 |
2185062 | 2185062 | 2022-02-05 | Todd | Kentucky | 21219 | 2752 | 40 |
2181810 | 2181810 | 2022-02-04 | Todd | Kentucky | 21219 | 2752 | 40 |
2177862 | 2177862 | 2022-02-03 | Charlton | Georgia | 13049 | 2752 | 58 |
2125055 | 2125055 | 2022-01-17 | Lamoille | Vermont | 50015 | 2752 | 12 |
2121803 | 2121803 | 2022-01-16 | Lamoille | Vermont | 50015 | 2752 | 12 |
2103644 | 2103644 | 2022-01-11 | Butler | Kentucky | 21031 | 2752 | 44 |
2100073 | 2100073 | 2022-01-10 | Washington | Illinois | 17189 | 2752 | 37 |
1998759 | 1998759 | 2021-12-10 | Madison | Arkansas | 5087 | 2752 | 42 |
1970432 | 1970432 | 2021-12-01 | Mason | Kentucky | 21161 | 2752 | 73 |
1967608 | 1967608 | 2021-11-30 | Benton | Missouri | 29015 | 2752 | 70 |
1963196 | 1963196 | 2021-11-29 | Hamilton | Florida | 12047 | 2752 | 49 |
1959945 | 1959945 | 2021-11-28 | Hamilton | Florida | 12047 | 2752 | 49 |
1956694 | 1956694 | 2021-11-27 | Hamilton | Florida | 12047 | 2752 | 49 |
1953443 | 1953443 | 2021-11-26 | Hamilton | Florida | 12047 | 2752 | 49 |
1950192 | 1950192 | 2021-11-25 | Hamilton | Florida | 12047 | 2752 | 49 |
1946941 | 1946941 | 2021-11-24 | Hamilton | Florida | 12047 | 2752 | 49 |
1943690 | 1943690 | 2021-11-23 | Hamilton | Florida | 12047 | 2752 | 49 |
1940440 | 1940440 | 2021-11-22 | Hamilton | Florida | 12047 | 2752 | 49 |
1937190 | 1937190 | 2021-11-21 | Hamilton | Florida | 12047 | 2752 | 49 |
1933940 | 1933940 | 2021-11-20 | Hamilton | Florida | 12047 | 2752 | 49 |
1930688 | 1930688 | 2021-11-19 | Hamilton | Florida | 12047 | 2752 | 49 |
1915352 | 1915352 | 2021-11-14 | Charlevoix | Michigan | 26029 | 2752 | 38 |
1912102 | 1912102 | 2021-11-13 | Charlevoix | Michigan | 26029 | 2752 | 38 |
1908852 | 1908852 | 2021-11-12 | Charlevoix | Michigan | 26029 | 2752 | 38 |
1897566 | 1897566 | 2021-11-08 | Fluvanna | Virginia | 51065 | 2752 | 25 |
1878638 | 1878638 | 2021-11-03 | Otero | Colorado | 8089 | 2752 | 84 |
1862091 | 1862091 | 2021-10-28 | Lincoln | Wyoming | 56023 | 2752 | 20 |
1812861 | 1812861 | 2021-10-13 | Jackson | Texas | 48239 | 2752 | 50 |
1806177 | 1806177 | 2021-10-11 | Grundy | Tennessee | 47061 | 2752 | 37 |
1788054 | 1788054 | 2021-10-06 | Richland | Illinois | 17159 | 2752 | 65 |
1779147 | 1779147 | 2021-10-03 | Clinton | Missouri | 29049 | 2752 | 75 |
1759219 | 1759219 | 2021-09-27 | Morgan | Kentucky | 21175 | 2752 | 6 |
1751766 | 1751766 | 2021-09-25 | Drew | Arkansas | 5043 | 2752 | 53 |
1748134 | 1748134 | 2021-09-23 | Louisa | Virginia | 51109 | 2752 | 40 |
1742890 | 1742890 | 2021-09-22 | Anderson | Kentucky | 21005 | 2752 | 34 |
1733726 | 1733726 | 2021-09-19 | Ray | Missouri | 29177 | 2752 | 41 |
1722526 | 1722526 | 2021-09-16 | Grant | Arkansas | 5053 | 2752 | 46 |
1716656 | 1716656 | 2021-09-14 | Owen | Indiana | 18119 | 2752 | 63 |
1666532 | 1666532 | 2021-08-29 | Trousdale | Tennessee | 47169 | 2752 | 22 |
1662814 | 1662814 | 2021-08-28 | Van Wert | Ohio | 39161 | 2752 | 67 |
1663284 | 1663284 | 2021-08-28 | Trousdale | Tennessee | 47169 | 2752 | 22 |
1660036 | 1660036 | 2021-08-27 | Trousdale | Tennessee | 47169 | 2752 | 22 |
1654952 | 1654952 | 2021-08-26 | Spencer | Indiana | 18147 | 2752 | 31 |
1643618 | 1643618 | 2021-08-22 | Fairfield | South Carolina | 45039 | 2752 | 83 |
1640368 | 1640368 | 2021-08-21 | Fairfield | South Carolina | 45039 | 2752 | 83 |
1637118 | 1637118 | 2021-08-20 | Fairfield | South Carolina | 45039 | 2752 | 83 |
1633754 | 1633754 | 2021-08-19 | Susquehanna | Pennsylvania | 42115 | 2752 | 62 |
1621816 | 1621816 | 2021-08-16 | Columbia | Arkansas | 5027 | 2752 | 60 |
1602324 | 1602324 | 2021-08-10 | Cleburne | Arkansas | 5023 | 2752 | 75 |
1585889 | 1585889 | 2021-08-04 | Jackson | Wisconsin | 55053 | 2752 | 29 |
1552793 | 1552793 | 2021-07-25 | Haywood | Tennessee | 47075 | 2752 | 62 |
1549546 | 1549546 | 2021-07-24 | Haywood | Tennessee | 47075 | 2752 | 62 |
1546299 | 1546299 | 2021-07-23 | Haywood | Tennessee | 47075 | 2752 | 62 |
1543544 | 1543544 | 2021-07-22 | Wythe | Virginia | 51197 | 2752 | 81 |
1537881 | 1537881 | 2021-07-21 | Jersey | Illinois | 17083 | 2752 | 71 |
1534633 | 1534633 | 2021-07-20 | Jersey | Illinois | 17083 | 2752 | 71 |
1513355 | 1513355 | 2021-07-13 | Henry | Ohio | 39069 | 2752 | 67 |
1492942 | 1492942 | 2021-07-07 | Pointe Coupee | Louisiana | 22077 | 2752 | 75 |
1449971 | 1449971 | 2021-06-24 | Taylor | Florida | 12123 | 2752 | 48 |
1446726 | 1446726 | 2021-06-23 | Taylor | Florida | 12123 | 2752 | 48 |
1443481 | 1443481 | 2021-06-22 | Taylor | Florida | 12123 | 2752 | 48 |
1440236 | 1440236 | 2021-06-21 | Taylor | Florida | 12123 | 2752 | 48 |
1436989 | 1436989 | 2021-06-20 | Taylor | Florida | 12123 | 2752 | 48 |
1433742 | 1433742 | 2021-06-19 | Taylor | Florida | 12123 | 2752 | 48 |
1435451 | 1435451 | 2021-06-19 | Hardin | Ohio | 39065 | 2752 | 65 |
1430496 | 1430496 | 2021-06-18 | Taylor | Florida | 12123 | 2752 | 48 |
1429563 | 1429563 | 2021-06-17 | Fayette | Texas | 48149 | 2752 | 67 |
1424885 | 1424885 | 2021-06-16 | Dickinson | Michigan | 26043 | 2752 | 74 |
1426318 | 1426318 | 2021-06-16 | Fayette | Texas | 48149 | 2752 | 67 |
1398602 | 1398602 | 2021-06-08 | Labette | Kansas | 20099 | 2752 | 50 |
1400449 | 1400449 | 2021-06-08 | Moore | Texas | 48341 | 2752 | 73 |
1395355 | 1395355 | 2021-06-07 | Labette | Kansas | 20099 | 2752 | 50 |
1392110 | 1392110 | 2021-06-06 | Labette | Kansas | 20099 | 2752 | 50 |
1388865 | 1388865 | 2021-06-05 | Labette | Kansas | 20099 | 2752 | 50 |
1385620 | 1385620 | 2021-06-04 | Labette | Kansas | 20099 | 2752 | 50 |
1382374 | 1382374 | 2021-06-03 | Labette | Kansas | 20099 | 2752 | 50 |
1378574 | 1378574 | 2021-06-02 | Washington | Florida | 12133 | 2752 | 52 |
1379129 | 1379129 | 2021-06-02 | Labette | Kansas | 20099 | 2752 | 50 |
1377649 | 1377649 | 2021-06-01 | Gonzales | Texas | 48177 | 2752 | 57 |
1374403 | 1374403 | 2021-05-31 | Gonzales | Texas | 48177 | 2752 | 57 |
1371158 | 1371158 | 2021-05-30 | Gonzales | Texas | 48177 | 2752 | 57 |
1367912 | 1367912 | 2021-05-29 | Gonzales | Texas | 48177 | 2752 | 57 |
1364666 | 1364666 | 2021-05-28 | Gonzales | Texas | 48177 | 2752 | 57 |
1361502 | 1361502 | 2021-05-27 | Moore | Texas | 48341 | 2752 | 72 |
1358174 | 1358174 | 2021-05-26 | Gonzales | Texas | 48177 | 2752 | 57 |
1321356 | 1321356 | 2021-05-15 | Washington | Missouri | 29221 | 2752 | 49 |
1316492 | 1316492 | 2021-05-13 | Park | Wyoming | 56029 | 2752 | 30 |
1244433 | 1244433 | 2021-04-21 | Smith | Tennessee | 47159 | 2752 | 38 |
1218901 | 1218901 | 2021-04-13 | Winchester city | Virginia | 51840 | 2752 | 41 |
1204327 | 1204327 | 2021-04-09 | Prentiss | Mississippi | 28117 | 2752 | 59 |
1198944 | 1198944 | 2021-04-07 | McNairy | Tennessee | 47109 | 2752 | 54 |
1196245 | 1196245 | 2021-04-06 | Preston | West Virginia | 54077 | 2752 | 47 |
1156542 | 1156542 | 2021-03-25 | Vega Baja | Puerto Rico | 72145 | 2752 | |
1130455 | 1130455 | 2021-03-17 | Greene | Pennsylvania | 42059 | 2752 | 35 |
1085177 | 1085177 | 2021-03-03 | Beadle | South Dakota | 46005 | 2752 | 39 |
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);