ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
163 rows where cases = 3609 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 16
- Missouri 15
- Florida 10
- Tennessee 9
- Louisiana 8
- North Carolina 8
- Georgia 7
- Indiana 7
- Kentucky 6
- Mississippi 6
- South Carolina 6
- West Virginia 6
- Alabama 5
- Ohio 5
- Arkansas 4
- Colorado 4
- New Mexico 4
- Virginia 4
- Wisconsin 4
- Illinois 3
- Michigan 3
- Pennsylvania 3
- Iowa 2
- Kansas 2
- New York 2
- Oklahoma 2
- South Dakota 2
- Utah 2
- Wyoming 2
- Alaska 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2460769 | 2460769 | 2022-05-01 | Las Animas | Colorado | 8071 | 3609 | 40 |
2457513 | 2457513 | 2022-04-30 | Las Animas | Colorado | 8071 | 3609 | 40 |
2454257 | 2454257 | 2022-04-29 | Las Animas | Colorado | 8071 | 3609 | 40 |
2451001 | 2451001 | 2022-04-28 | Las Animas | Colorado | 8071 | 3609 | 40 |
2448598 | 2448598 | 2022-04-27 | Caldwell | Louisiana | 22021 | 3609 | 55 |
2445342 | 2445342 | 2022-04-26 | Caldwell | Louisiana | 22021 | 3609 | 55 |
2440337 | 2440337 | 2022-04-24 | Bandera | Texas | 48019 | 3609 | 77 |
2422048 | 2422048 | 2022-04-19 | Greene | Illinois | 17061 | 3609 | 58 |
2385374 | 2385374 | 2022-04-07 | Patrick | Virginia | 51141 | 3609 | 93 |
2305832 | 2305832 | 2022-03-14 | Macon | Missouri | 29121 | 3609 | 52 |
2279441 | 2279441 | 2022-03-06 | West Carroll | Louisiana | 22123 | 3609 | 61 |
2276188 | 2276188 | 2022-03-05 | West Carroll | Louisiana | 22123 | 3609 | 61 |
2272935 | 2272935 | 2022-03-04 | West Carroll | Louisiana | 22123 | 3609 | 61 |
2254617 | 2254617 | 2022-02-26 | Lares | Puerto Rico | 72081 | 3609 | |
2237589 | 2237589 | 2022-02-21 | Ste. Genevieve | Missouri | 29186 | 3609 | 37 |
2234338 | 2234338 | 2022-02-20 | Ste. Genevieve | Missouri | 29186 | 3609 | 37 |
2231087 | 2231087 | 2022-02-19 | Ste. Genevieve | Missouri | 29186 | 3609 | 37 |
2227836 | 2227836 | 2022-02-18 | Ste. Genevieve | Missouri | 29186 | 3609 | 37 |
2224585 | 2224585 | 2022-02-17 | Ste. Genevieve | Missouri | 29186 | 3609 | 37 |
2213701 | 2213701 | 2022-02-14 | Jefferson | Georgia | 13163 | 3609 | 102 |
2196825 | 2196825 | 2022-02-08 | Grant | West Virginia | 54023 | 3609 | 52 |
2154813 | 2154813 | 2022-01-27 | Izard | Arkansas | 5065 | 3609 | 62 |
2156237 | 2156237 | 2022-01-27 | Moniteau | Missouri | 29135 | 3609 | 48 |
2152078 | 2152078 | 2022-01-26 | Mason | Illinois | 17125 | 3609 | 58 |
2133511 | 2133511 | 2022-01-20 | Big Horn | Montana | 30003 | 3609 | 87 |
2129721 | 2129721 | 2022-01-19 | Mason | Kentucky | 21161 | 3609 | 88 |
2101308 | 2101308 | 2022-01-10 | Currituck | North Carolina | 37053 | 3609 | 30 |
2086422 | 2086422 | 2022-01-06 | Pickens | Alabama | 1107 | 3609 | 91 |
2086240 | 2086240 | 2022-01-05 | Lincoln | West Virginia | 54043 | 3609 | 57 |
2030194 | 2030194 | 2021-12-19 | Wyoming | Pennsylvania | 42131 | 3609 | 79 |
2024782 | 2024782 | 2021-12-18 | Randolph | Arkansas | 5121 | 3609 | 65 |
1985119 | 1985119 | 2021-12-05 | Lampasas | Texas | 48281 | 3609 | 70 |
1969816 | 1969816 | 2021-12-01 | Hart | Georgia | 13147 | 3609 | 73 |
1942890 | 1942890 | 2021-11-22 | Moore | Texas | 48341 | 3609 | 88 |
1939640 | 1939640 | 2021-11-21 | Moore | Texas | 48341 | 3609 | 88 |
1936390 | 1936390 | 2021-11-20 | Moore | Texas | 48341 | 3609 | 88 |
1881599 | 1881599 | 2021-11-04 | Barbour | Alabama | 1005 | 3609 | 77 |
1860335 | 1860335 | 2021-10-28 | Stone | Mississippi | 28131 | 3609 | 64 |
1847355 | 1847355 | 2021-10-24 | Adair | Missouri | 29001 | 3609 | 34 |
1844105 | 1844105 | 2021-10-23 | Adair | Missouri | 29001 | 3609 | 34 |
1840855 | 1840855 | 2021-10-22 | Adair | Missouri | 29001 | 3609 | 34 |
1838071 | 1838071 | 2021-10-21 | Martin | North Carolina | 37117 | 3609 | 70 |
1780219 | 1780219 | 2021-10-03 | Morgan | Tennessee | 47129 | 3609 | 44 |
1776969 | 1776969 | 2021-10-02 | Morgan | Tennessee | 47129 | 3609 | 44 |
1773719 | 1773719 | 2021-10-01 | Morgan | Tennessee | 47129 | 3609 | 44 |
1755958 | 1755958 | 2021-09-26 | Marion | Kentucky | 21155 | 3609 | 40 |
1752710 | 1752710 | 2021-09-25 | Marion | Kentucky | 21155 | 3609 | 40 |
1749461 | 1749461 | 2021-09-24 | Marion | Kentucky | 21155 | 3609 | 40 |
1721420 | 1721420 | 2021-09-15 | Clarion | Pennsylvania | 42031 | 3609 | 100 |
1700386 | 1700386 | 2021-09-09 | Greene | Indiana | 18055 | 3609 | 90 |
1695777 | 1695777 | 2021-09-07 | Wayne | Tennessee | 47181 | 3609 | 37 |
1652419 | 1652419 | 2021-08-25 | Wayne | Mississippi | 28153 | 3609 | 55 |
1649545 | 1649545 | 2021-08-24 | Greene | New York | 36039 | 3609 | 82 |
1642625 | 1642625 | 2021-08-22 | Itawamba | Mississippi | 28057 | 3609 | 83 |
1639375 | 1639375 | 2021-08-21 | Itawamba | Mississippi | 28057 | 3609 | 83 |
1636125 | 1636125 | 2021-08-20 | Itawamba | Mississippi | 28057 | 3609 | 83 |
1623657 | 1623657 | 2021-08-16 | Montgomery | North Carolina | 37123 | 3609 | 97 |
1597522 | 1597522 | 2021-08-08 | Cibola | New Mexico | 35006 | 3609 | 128 |
1594273 | 1594273 | 2021-08-07 | Cibola | New Mexico | 35006 | 3609 | 128 |
1591024 | 1591024 | 2021-08-06 | Cibola | New Mexico | 35006 | 3609 | 128 |
1587775 | 1587775 | 2021-08-05 | Cibola | New Mexico | 35006 | 3609 | 128 |
1581908 | 1581908 | 2021-08-03 | Marlboro | South Carolina | 45069 | 3609 | 61 |
1576084 | 1576084 | 2021-08-01 | Marshall | West Virginia | 54051 | 3609 | 79 |
1572836 | 1572836 | 2021-07-31 | Marshall | West Virginia | 54051 | 3609 | 79 |
1569588 | 1569588 | 2021-07-30 | Marshall | West Virginia | 54051 | 3609 | 79 |
1564396 | 1564396 | 2021-07-29 | Vernon | Louisiana | 22115 | 3609 | 108 |
1557680 | 1557680 | 2021-07-27 | Montgomery | Kansas | 20125 | 3609 | 84 |
1554433 | 1554433 | 2021-07-26 | Montgomery | Kansas | 20125 | 3609 | 84 |
1543360 | 1543360 | 2021-07-22 | Wood | Texas | 48499 | 3609 | 130 |
1540112 | 1540112 | 2021-07-21 | Wood | Texas | 48499 | 3609 | 130 |
1536865 | 1536865 | 2021-07-20 | Wood | Texas | 48499 | 3609 | 129 |
1449611 | 1449611 | 2021-06-24 | Dallas | Alabama | 1047 | 3609 | 158 |
1449946 | 1449946 | 2021-06-24 | Levy | Florida | 12075 | 3609 | 56 |
1446366 | 1446366 | 2021-06-23 | Dallas | Alabama | 1047 | 3609 | 158 |
1446701 | 1446701 | 2021-06-23 | Levy | Florida | 12075 | 3609 | 56 |
1443456 | 1443456 | 2021-06-22 | Levy | Florida | 12075 | 3609 | 56 |
1445950 | 1445950 | 2021-06-22 | Uvalde | Texas | 48463 | 3609 | 73 |
1440211 | 1440211 | 2021-06-21 | Levy | Florida | 12075 | 3609 | 56 |
1442705 | 1442705 | 2021-06-21 | Uvalde | Texas | 48463 | 3609 | 73 |
1436964 | 1436964 | 2021-06-20 | Levy | Florida | 12075 | 3609 | 56 |
1439460 | 1439460 | 2021-06-20 | Uvalde | Texas | 48463 | 3609 | 73 |
1433717 | 1433717 | 2021-06-19 | Levy | Florida | 12075 | 3609 | 56 |
1430471 | 1430471 | 2021-06-18 | Levy | Florida | 12075 | 3609 | 56 |
1417917 | 1417917 | 2021-06-14 | Wabash | Indiana | 18169 | 3609 | 83 |
1414671 | 1414671 | 2021-06-13 | Wabash | Indiana | 18169 | 3609 | 83 |
1411426 | 1411426 | 2021-06-12 | Wabash | Indiana | 18169 | 3609 | 83 |
1377962 | 1377962 | 2021-06-01 | Prince George | Virginia | 51149 | 3609 | 32 |
1368626 | 1368626 | 2021-05-30 | St. Francis | Arkansas | 5123 | 3609 | 44 |
1347678 | 1347678 | 2021-05-23 | Jackson | North Carolina | 37099 | 3609 | 56 |
1344430 | 1344430 | 2021-05-22 | Jackson | North Carolina | 37099 | 3609 | 56 |
1341182 | 1341182 | 2021-05-21 | Jackson | North Carolina | 37099 | 3609 | 56 |
1334344 | 1334344 | 2021-05-19 | Webster | Missouri | 29225 | 3609 | 54 |
1327850 | 1327850 | 2021-05-17 | Webster | Missouri | 29225 | 3609 | 54 |
1312288 | 1312288 | 2021-05-12 | Clinton | Pennsylvania | 42035 | 3609 | 62 |
1304285 | 1304285 | 2021-05-10 | Putnam | Indiana | 18133 | 3609 | 60 |
1299451 | 1299451 | 2021-05-08 | Colleton | South Carolina | 45029 | 3609 | 127 |
1291120 | 1291120 | 2021-05-06 | Nez Perce | Idaho | 16069 | 3609 | 55 |
1288843 | 1288843 | 2021-05-05 | Marion | Missouri | 29127 | 3609 | 45 |
1289178 | 1289178 | 2021-05-05 | Tioga | New York | 36107 | 3609 | 61 |
1287211 | 1287211 | 2021-05-04 | Green | Wisconsin | 55045 | 3609 | 24 |
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);