ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
148 rows where cases = 4355 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 22
- Georgia 11
- Ohio 11
- Michigan 8
- Illinois 7
- Montana 7
- Oklahoma 7
- California 6
- Alaska 5
- Minnesota 5
- Louisiana 4
- Virginia 4
- Arkansas 3
- Indiana 3
- Kentucky 3
- Mississippi 3
- New York 3
- Pennsylvania 3
- South Carolina 3
- Washington 3
- Wisconsin 3
- Alabama 2
- Colorado 2
- Florida 2
- New Jersey 2
- New Mexico 2
- North Carolina 2
- Vermont 2
- West Virginia 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495831 | 2495831 | 2022-05-11 | Lamb | Texas | 48279 | 4355 | 122 |
2492573 | 2492573 | 2022-05-10 | Lamb | Texas | 48279 | 4355 | 122 |
2489315 | 2489315 | 2022-05-09 | Lamb | Texas | 48279 | 4355 | 122 |
2486058 | 2486058 | 2022-05-08 | Lamb | Texas | 48279 | 4355 | 122 |
2482800 | 2482800 | 2022-05-07 | Lamb | Texas | 48279 | 4355 | 122 |
2479542 | 2479542 | 2022-05-06 | Lamb | Texas | 48279 | 4355 | 122 |
2467603 | 2467603 | 2022-05-03 | Bond | Illinois | 17005 | 4355 | 37 |
2451340 | 2451340 | 2022-04-28 | De Witt | Illinois | 17039 | 4355 | 44 |
2445458 | 2445458 | 2022-04-26 | Antrim | Michigan | 26009 | 4355 | 64 |
2442202 | 2442202 | 2022-04-25 | Antrim | Michigan | 26009 | 4355 | 64 |
2438946 | 2438946 | 2022-04-24 | Antrim | Michigan | 26009 | 4355 | 64 |
2435690 | 2435690 | 2022-04-23 | Antrim | Michigan | 26009 | 4355 | 64 |
2432434 | 2432434 | 2022-04-22 | Antrim | Michigan | 26009 | 4355 | 64 |
2429178 | 2429178 | 2022-04-21 | Antrim | Michigan | 26009 | 4355 | 64 |
2353151 | 2353151 | 2022-03-29 | North Slope Borough | Alaska | 2185 | 4355 | 11 |
2349899 | 2349899 | 2022-03-28 | North Slope Borough | Alaska | 2185 | 4355 | 11 |
2346646 | 2346646 | 2022-03-27 | North Slope Borough | Alaska | 2185 | 4355 | 11 |
2343393 | 2343393 | 2022-03-26 | North Slope Borough | Alaska | 2185 | 4355 | 11 |
2340140 | 2340140 | 2022-03-25 | North Slope Borough | Alaska | 2185 | 4355 | 11 |
2311030 | 2311030 | 2022-03-16 | Chaffee | Colorado | 8015 | 4355 | 43 |
2265787 | 2265787 | 2022-03-02 | Washington | Georgia | 13303 | 4355 | 132 |
2252379 | 2252379 | 2022-02-26 | Grant | Arkansas | 5053 | 4355 | 58 |
2221492 | 2221492 | 2022-02-16 | Washington | Nebraska | 31177 | 4355 | 34 |
2211613 | 2211613 | 2022-02-13 | Hill | Montana | 30041 | 4355 | 71 |
2208360 | 2208360 | 2022-02-12 | Hill | Montana | 30041 | 4355 | 71 |
2205107 | 2205107 | 2022-02-11 | Hill | Montana | 30041 | 4355 | 71 |
2196997 | 2196997 | 2022-02-09 | Henry | Alabama | 1067 | 4355 | 67 |
2195909 | 2195909 | 2022-02-08 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2192655 | 2192655 | 2022-02-07 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2189401 | 2189401 | 2022-02-06 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2186148 | 2186148 | 2022-02-05 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2181272 | 2181272 | 2022-02-04 | Cassia | Idaho | 16031 | 4355 | 48 |
2182896 | 2182896 | 2022-02-04 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2179644 | 2179644 | 2022-02-03 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2175836 | 2175836 | 2022-02-02 | Lincoln | Montana | 30053 | 4355 | 77 |
2176393 | 2176393 | 2022-02-02 | Marshall | Oklahoma | 40095 | 4355 | 32 |
2172059 | 2172059 | 2022-02-01 | Wayne | Kentucky | 21231 | 4355 | 78 |
2167260 | 2167260 | 2022-01-30 | Robertson | Texas | 48395 | 4355 | 70 |
2160269 | 2160269 | 2022-01-28 | Barranquitas | Puerto Rico | 72019 | 4355 | |
2152498 | 2152498 | 2022-01-26 | McCreary | Kentucky | 21147 | 4355 | 68 |
2134815 | 2134815 | 2022-01-20 | Orleans | Vermont | 50019 | 4355 | 31 |
2131563 | 2131563 | 2022-01-19 | Orleans | Vermont | 50019 | 4355 | 31 |
2109291 | 2109291 | 2022-01-13 | Ouachita | Arkansas | 5103 | 4355 | 91 |
2099144 | 2099144 | 2022-01-09 | Page | Virginia | 51139 | 4355 | 93 |
2095893 | 2095893 | 2022-01-08 | Page | Virginia | 51139 | 4355 | 93 |
2092641 | 2092641 | 2022-01-07 | Page | Virginia | 51139 | 4355 | 93 |
2029323 | 2029323 | 2021-12-19 | Marion | Mississippi | 28091 | 4355 | 113 |
2026072 | 2026072 | 2021-12-18 | Marion | Mississippi | 28091 | 4355 | 113 |
2022821 | 2022821 | 2021-12-17 | Marion | Mississippi | 28091 | 4355 | 113 |
2008876 | 2008876 | 2021-12-13 | Sumter | Georgia | 13261 | 4355 | 141 |
1987472 | 1987472 | 2021-12-06 | Lewis | New York | 36049 | 4355 | 40 |
1978985 | 1978985 | 2021-12-03 | Nicholas | West Virginia | 54067 | 4355 | 67 |
1939167 | 1939167 | 2021-11-21 | Susquehanna | Pennsylvania | 42115 | 4355 | 73 |
1925006 | 1925006 | 2021-11-17 | Richland | Louisiana | 22083 | 4355 | 79 |
1895235 | 1895235 | 2021-11-08 | Iroquois | Illinois | 17075 | 4355 | 83 |
1892681 | 1892681 | 2021-11-07 | Brown | Minnesota | 27015 | 4355 | 52 |
1889431 | 1889431 | 2021-11-06 | Brown | Minnesota | 27015 | 4355 | 52 |
1886181 | 1886181 | 2021-11-05 | Brown | Minnesota | 27015 | 4355 | 52 |
1860239 | 1860239 | 2021-10-28 | Pine | Minnesota | 27115 | 4355 | 33 |
1854483 | 1854483 | 2021-10-26 | Pike | Ohio | 39131 | 4355 | 67 |
1841239 | 1841239 | 2021-10-22 | Orleans | New York | 36073 | 4355 | 87 |
1811300 | 1811300 | 2021-10-13 | West Baton Rouge | Louisiana | 22121 | 4355 | 72 |
1792698 | 1792698 | 2021-10-07 | Coshocton | Ohio | 39031 | 4355 | 74 |
1789669 | 1789669 | 2021-10-06 | Jefferson | Pennsylvania | 42065 | 4355 | 109 |
1769031 | 1769031 | 2021-09-30 | Morehouse | Louisiana | 22067 | 4355 | 110 |
1764860 | 1764860 | 2021-09-29 | Siskiyou | California | 6093 | 4355 | 51 |
1738920 | 1738920 | 2021-09-21 | Logan | Colorado | 8075 | 4355 | 72 |
1738551 | 1738551 | 2021-09-20 | Clark | Wisconsin | 55019 | 4355 | 71 |
1709882 | 1709882 | 2021-09-12 | Lumpkin | Georgia | 13187 | 4355 | 87 |
1706635 | 1706635 | 2021-09-11 | Lumpkin | Georgia | 13187 | 4355 | 87 |
1703387 | 1703387 | 2021-09-10 | Lumpkin | Georgia | 13187 | 4355 | 87 |
1672863 | 1672863 | 2021-08-31 | Marion | South Carolina | 45067 | 4355 | 111 |
1673150 | 1673150 | 2021-08-31 | Hopkins | Texas | 48223 | 4355 | 125 |
1664422 | 1664422 | 2021-08-29 | Pickens | Georgia | 13227 | 4355 | 82 |
1661174 | 1661174 | 2021-08-28 | Pickens | Georgia | 13227 | 4355 | 82 |
1657926 | 1657926 | 2021-08-27 | Pickens | Georgia | 13227 | 4355 | 82 |
1642842 | 1642842 | 2021-08-22 | Silver Bow | Montana | 30093 | 4355 | 88 |
1639592 | 1639592 | 2021-08-21 | Silver Bow | Montana | 30093 | 4355 | 88 |
1634871 | 1634871 | 2021-08-20 | Amador | California | 6005 | 4355 | 50 |
1636342 | 1636342 | 2021-08-20 | Silver Bow | Montana | 30093 | 4355 | 88 |
1553092 | 1553092 | 2021-07-25 | Wharton | Texas | 48481 | 4355 | 120 |
1549067 | 1549067 | 2021-07-24 | Fulton | Ohio | 39051 | 4355 | 75 |
1533606 | 1533606 | 2021-07-19 | Washington | Texas | 48477 | 4355 | 96 |
1452234 | 1452234 | 2021-06-24 | Brown | Texas | 48049 | 4355 | 139 |
1448988 | 1448988 | 2021-06-23 | Brown | Texas | 48049 | 4355 | 139 |
1445743 | 1445743 | 2021-06-22 | Brown | Texas | 48049 | 4355 | 139 |
1442498 | 1442498 | 2021-06-21 | Brown | Texas | 48049 | 4355 | 139 |
1439253 | 1439253 | 2021-06-20 | Brown | Texas | 48049 | 4355 | 139 |
1436006 | 1436006 | 2021-06-19 | Brown | Texas | 48049 | 4355 | 139 |
1432759 | 1432759 | 2021-06-18 | Brown | Texas | 48049 | 4355 | 139 |
1428928 | 1428928 | 2021-06-17 | Ashland | Ohio | 39005 | 4355 | 97 |
1425683 | 1425683 | 2021-06-16 | Ashland | Ohio | 39005 | 4355 | 97 |
1422436 | 1422436 | 2021-06-15 | Ashland | Ohio | 39005 | 4355 | 97 |
1391363 | 1391363 | 2021-06-06 | Humboldt | California | 6023 | 4355 | 45 |
1388118 | 1388118 | 2021-06-05 | Humboldt | California | 6023 | 4355 | 45 |
1384873 | 1384873 | 2021-06-04 | Humboldt | California | 6023 | 4355 | 45 |
1377976 | 1377976 | 2021-06-01 | Shenandoah | Virginia | 51171 | 4355 | 133 |
1314610 | 1314610 | 2021-05-13 | Itasca | Minnesota | 27061 | 4355 | 56 |
1307428 | 1307428 | 2021-05-11 | Monroe | Illinois | 17133 | 4355 | 93 |
1304182 | 1304182 | 2021-05-10 | Monroe | Illinois | 17133 | 4355 | 93 |
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);