ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where cases = 6413 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Tennessee 7
- Alabama 5
- Pennsylvania 5
- Kansas 4
- Ohio 4
- Texas 4
- Missouri 3
- New York 3
- Kentucky 2
- Louisiana 2
- Michigan 2
- Virginia 2
- West Virginia 2
- Arkansas 1
- Florida 1
- Indiana 1
- Mississippi 1
- Nebraska 1
- New Jersey 1
- North Carolina 1
- South Carolina 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2333553 | 2333553 | 2022-03-23 | Bibb | Alabama | 1007 | 6413 | 101 |
2310899 | 2310899 | 2022-03-16 | Cleburne | Arkansas | 5023 | 6413 | 127 |
2283608 | 2283608 | 2022-03-07 | Henry | Ohio | 39069 | 6413 | 106 |
2217484 | 2217484 | 2022-02-15 | Allen | Kentucky | 21003 | 6413 | 92 |
2200122 | 2200122 | 2022-02-09 | Wyoming | West Virginia | 54109 | 6413 | 87 |
2196433 | 2196433 | 2022-02-08 | Hale | Texas | 48189 | 6413 | 226 |
2173891 | 2173891 | 2022-02-01 | Caroline | Virginia | 51033 | 6413 | 63 |
2127931 | 2127931 | 2022-01-18 | Claiborne | Tennessee | 47025 | 6413 | 145 |
2124679 | 2124679 | 2022-01-17 | Claiborne | Tennessee | 47025 | 6413 | 145 |
2121427 | 2121427 | 2022-01-16 | Claiborne | Tennessee | 47025 | 6413 | 145 |
2118175 | 2118175 | 2022-01-15 | Claiborne | Tennessee | 47025 | 6413 | 145 |
2114924 | 2114924 | 2022-01-14 | Claiborne | Tennessee | 47025 | 6413 | 145 |
2111672 | 2111672 | 2022-01-13 | Claiborne | Tennessee | 47025 | 6413 | 145 |
2108420 | 2108420 | 2022-01-12 | Claiborne | Tennessee | 47025 | 6413 | 145 |
2105739 | 2105739 | 2022-01-11 | Greenbrier | West Virginia | 54025 | 6413 | 123 |
2039468 | 2039468 | 2021-12-22 | Chenango | New York | 36017 | 6413 | 99 |
2019652 | 2019652 | 2021-12-16 | Howell | Missouri | 29091 | 6413 | 174 |
1971250 | 1971250 | 2021-12-01 | Tioga | New York | 36107 | 6413 | 73 |
1964963 | 1964963 | 2021-11-29 | Madison | Ohio | 39097 | 6413 | 89 |
1925540 | 1925540 | 2021-11-17 | Dodge | Nebraska | 31053 | 6413 | 83 |
1923290 | 1923290 | 2021-11-16 | Erath | Texas | 48143 | 6413 | 104 |
1881574 | 1881574 | 2021-11-03 | Albany | Wyoming | 56001 | 6413 | 35 |
1799414 | 1799414 | 2021-10-09 | Huntingdon | Pennsylvania | 42061 | 6413 | 150 |
1785593 | 1785593 | 2021-10-05 | Panola | Mississippi | 28107 | 6413 | 128 |
1764368 | 1764368 | 2021-09-28 | James City | Virginia | 51095 | 6413 | 86 |
1714238 | 1714238 | 2021-09-13 | Scott | Missouri | 29201 | 6413 | 95 |
1682810 | 1682810 | 2021-09-03 | Burnet | Texas | 48053 | 6413 | 84 |
1671424 | 1671424 | 2021-08-31 | Boyd | Kentucky | 21019 | 6413 | 84 |
1642692 | 1642692 | 2021-08-22 | Callaway | Missouri | 29027 | 6413 | 57 |
1627664 | 1627664 | 2021-08-17 | Harrison | Texas | 48203 | 6413 | 115 |
1518734 | 1518734 | 2021-07-15 | Saline | Kansas | 20169 | 6413 | 142 |
1515487 | 1515487 | 2021-07-14 | Saline | Kansas | 20169 | 6413 | 142 |
1512241 | 1512241 | 2021-07-13 | Saline | Kansas | 20169 | 6413 | 142 |
1508994 | 1508994 | 2021-07-12 | Saline | Kansas | 20169 | 6413 | 142 |
1464861 | 1464861 | 2021-06-28 | Indiana | Pennsylvania | 42063 | 6413 | 179 |
1461616 | 1461616 | 2021-06-27 | Indiana | Pennsylvania | 42063 | 6413 | 179 |
1448635 | 1448635 | 2021-06-23 | Indiana | Pennsylvania | 42063 | 6413 | 178 |
1436622 | 1436622 | 2021-06-20 | Colbert | Alabama | 1033 | 6413 | 140 |
1433375 | 1433375 | 2021-06-19 | Colbert | Alabama | 1033 | 6413 | 140 |
1430129 | 1430129 | 2021-06-18 | Colbert | Alabama | 1033 | 6413 | 140 |
1425915 | 1425915 | 2021-06-16 | Indiana | Pennsylvania | 42063 | 6413 | 178 |
1405465 | 1405465 | 2021-06-10 | Shiawassee | Michigan | 26155 | 6413 | 105 |
1264931 | 1264931 | 2021-04-28 | Putnam | Florida | 12107 | 6413 | 145 |
1184073 | 1184073 | 2021-04-03 | Boone | Indiana | 18011 | 6413 | 103 |
1143586 | 1143586 | 2021-03-21 | Georgetown | South Carolina | 45043 | 6413 | 137 |
1027574 | 1027574 | 2021-02-14 | Jackson | Alabama | 1071 | 6413 | 92 |
984180 | 984180 | 2021-01-31 | Erie | Ohio | 39043 | 6413 | 131 |
922385 | 922385 | 2021-01-12 | Henderson | North Carolina | 37089 | 6413 | 92 |
892404 | 892404 | 2021-01-03 | Terrebonne | Louisiana | 22109 | 6413 | 150 |
786269 | 786269 | 2020-12-01 | Trumbull | Ohio | 39155 | 6413 | 152 |
762589 | 762589 | 2020-11-24 | Tangipahoa | Louisiana | 22105 | 6413 | 141 |
174085 | 174085 | 2020-05-24 | Mercer | New Jersey | 34021 | 6413 | 449 |
149433 | 149433 | 2020-05-16 | Macomb | Michigan | 26099 | 6413 | 744 |
42161 | 42161 | 2020-04-08 | Rockland | New York | 36087 | 6413 | 98 |
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);