ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
137 rows where cases = 4585 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 25
- Tennessee 12
- Ohio 9
- Virginia 8
- South Dakota 7
- California 6
- Nebraska 6
- Georgia 4
- Illinois 4
- Minnesota 4
- Mississippi 4
- New York 4
- North Carolina 4
- Washington 4
- Indiana 3
- Michigan 3
- Puerto Rico 3
- Wisconsin 3
- Arkansas 2
- Colorado 2
- Idaho 2
- Iowa 2
- Kentucky 2
- Louisiana 2
- New Jersey 2
- Pennsylvania 2
- West Virginia 2
- Wyoming 2
- Arizona 1
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500779 | 2500779 | 2022-05-13 | Washington | Maine | 23029 | 4585 | 57 |
2502728 | 2502728 | 2022-05-13 | Taylor | West Virginia | 54091 | 4585 | 73 |
2492143 | 2492143 | 2022-05-10 | Aguas Buenas | Puerto Rico | 72007 | 4585 | |
2472018 | 2472018 | 2022-05-04 | Washington | Nebraska | 31177 | 4585 | 43 |
2468762 | 2468762 | 2022-05-03 | Washington | Nebraska | 31177 | 4585 | 43 |
2465506 | 2465506 | 2022-05-02 | Washington | Nebraska | 31177 | 4585 | 43 |
2462251 | 2462251 | 2022-05-01 | Washington | Nebraska | 31177 | 4585 | 43 |
2458995 | 2458995 | 2022-04-30 | Washington | Nebraska | 31177 | 4585 | 43 |
2455739 | 2455739 | 2022-04-29 | Washington | Nebraska | 31177 | 4585 | 43 |
2450920 | 2450920 | 2022-04-28 | Inyo | California | 6027 | 4585 | 56 |
2447664 | 2447664 | 2022-04-27 | Inyo | California | 6027 | 4585 | 56 |
2444408 | 2444408 | 2022-04-26 | Inyo | California | 6027 | 4585 | 56 |
2417718 | 2417718 | 2022-04-17 | Panola | Texas | 48365 | 4585 | 129 |
2414462 | 2414462 | 2022-04-16 | Panola | Texas | 48365 | 4585 | 129 |
2411206 | 2411206 | 2022-04-15 | Panola | Texas | 48365 | 4585 | 129 |
2407950 | 2407950 | 2022-04-14 | Panola | Texas | 48365 | 4585 | 129 |
2404694 | 2404694 | 2022-04-13 | Panola | Texas | 48365 | 4585 | 129 |
2401096 | 2401096 | 2022-04-12 | Beadle | South Dakota | 46005 | 4585 | 59 |
2401439 | 2401439 | 2022-04-12 | Panola | Texas | 48365 | 4585 | 129 |
2397841 | 2397841 | 2022-04-11 | Beadle | South Dakota | 46005 | 4585 | 59 |
2394586 | 2394586 | 2022-04-10 | Beadle | South Dakota | 46005 | 4585 | 59 |
2391330 | 2391330 | 2022-04-09 | Beadle | South Dakota | 46005 | 4585 | 59 |
2388074 | 2388074 | 2022-04-08 | Beadle | South Dakota | 46005 | 4585 | 59 |
2388361 | 2388361 | 2022-04-08 | Jones | Texas | 48253 | 4585 | 92 |
2384819 | 2384819 | 2022-04-07 | Beadle | South Dakota | 46005 | 4585 | 59 |
2381564 | 2381564 | 2022-04-06 | Beadle | South Dakota | 46005 | 4585 | 59 |
2312895 | 2312895 | 2022-03-16 | Meigs | Ohio | 39105 | 4585 | 84 |
2309642 | 2309642 | 2022-03-15 | Meigs | Ohio | 39105 | 4585 | 84 |
2306389 | 2306389 | 2022-03-14 | Meigs | Ohio | 39105 | 4585 | 84 |
2303138 | 2303138 | 2022-03-13 | Meigs | Ohio | 39105 | 4585 | 84 |
2299886 | 2299886 | 2022-03-12 | Meigs | Ohio | 39105 | 4585 | 84 |
2281687 | 2281687 | 2022-03-07 | Sharp | Arkansas | 5135 | 4585 | 100 |
2277131 | 2277131 | 2022-03-05 | Paulding | Ohio | 39125 | 4585 | 73 |
2270842 | 2270842 | 2022-03-03 | Barranquitas | Puerto Rico | 72019 | 4585 | |
2267373 | 2267373 | 2022-03-02 | Paulding | Ohio | 39125 | 4585 | 72 |
2264120 | 2264120 | 2022-03-01 | Paulding | Ohio | 39125 | 4585 | 72 |
2265225 | 2265225 | 2022-03-01 | Carbon | Wyoming | 56007 | 4585 | 51 |
2261565 | 2261565 | 2022-02-28 | Reeves | Texas | 48389 | 4585 | 71 |
2261900 | 2261900 | 2022-02-28 | Adams | Wisconsin | 55001 | 4585 | 52 |
2258314 | 2258314 | 2022-02-27 | Reeves | Texas | 48389 | 4585 | 71 |
2255063 | 2255063 | 2022-02-26 | Reeves | Texas | 48389 | 4585 | 71 |
2251812 | 2251812 | 2022-02-25 | Reeves | Texas | 48389 | 4585 | 71 |
2248561 | 2248561 | 2022-02-24 | Reeves | Texas | 48389 | 4585 | 71 |
2245310 | 2245310 | 2022-02-23 | Reeves | Texas | 48389 | 4585 | 71 |
2245516 | 2245516 | 2022-02-23 | Prince Edward | Virginia | 51147 | 4585 | 61 |
2239732 | 2239732 | 2022-02-22 | Morgan | Georgia | 13211 | 4585 | 56 |
2241772 | 2241772 | 2022-02-22 | Bledsoe | Tennessee | 47007 | 4585 | 44 |
2238521 | 2238521 | 2022-02-21 | Bledsoe | Tennessee | 47007 | 4585 | 44 |
2235270 | 2235270 | 2022-02-20 | Bledsoe | Tennessee | 47007 | 4585 | 44 |
2232019 | 2232019 | 2022-02-19 | Bledsoe | Tennessee | 47007 | 4585 | 44 |
2228768 | 2228768 | 2022-02-18 | Bledsoe | Tennessee | 47007 | 4585 | 44 |
2225517 | 2225517 | 2022-02-17 | Bledsoe | Tennessee | 47007 | 4585 | 44 |
2225778 | 2225778 | 2022-02-17 | Montague | Texas | 48337 | 4585 | 120 |
2222266 | 2222266 | 2022-02-16 | Bledsoe | Tennessee | 47007 | 4585 | 44 |
2197515 | 2197515 | 2022-02-09 | Worth | Georgia | 13321 | 4585 | 104 |
2147565 | 2147565 | 2022-01-24 | Burleson | Texas | 48051 | 4585 | 62 |
2144624 | 2144624 | 2022-01-23 | Dinwiddie | Virginia | 51053 | 4585 | 63 |
2141369 | 2141369 | 2022-01-22 | Dinwiddie | Virginia | 51053 | 4585 | 63 |
2138113 | 2138113 | 2022-01-21 | Dinwiddie | Virginia | 51053 | 4585 | 63 |
2129237 | 2129237 | 2022-01-19 | Payette | Idaho | 16075 | 4585 | 75 |
2131019 | 2131019 | 2022-01-19 | Las Piedras | Puerto Rico | 72085 | 4585 | |
2118386 | 2118386 | 2022-01-15 | Karnes | Texas | 48255 | 4585 | 58 |
2112965 | 2112965 | 2022-01-14 | Jerome | Idaho | 16053 | 4585 | 58 |
2083805 | 2083805 | 2022-01-05 | Shelby | Illinois | 17173 | 4585 | 61 |
2083890 | 2083890 | 2022-01-05 | Randolph | Indiana | 18135 | 4585 | 121 |
2038753 | 2038753 | 2021-12-22 | East Feliciana | Louisiana | 22037 | 4585 | 145 |
2035111 | 2035111 | 2021-12-21 | LaGrange | Indiana | 18087 | 4585 | 95 |
2030598 | 2030598 | 2021-12-19 | Hockley | Texas | 48219 | 4585 | 139 |
2009521 | 2009521 | 2021-12-13 | Sabine | Louisiana | 22085 | 4585 | 96 |
1982549 | 1982549 | 2021-12-05 | Glenn | California | 6021 | 4585 | 51 |
1979299 | 1979299 | 2021-12-04 | Glenn | California | 6021 | 4585 | 51 |
1976049 | 1976049 | 2021-12-03 | Glenn | California | 6021 | 4585 | 51 |
1855483 | 1855483 | 2021-10-26 | Mineral | West Virginia | 54057 | 4585 | 112 |
1807054 | 1807054 | 2021-10-12 | Yell | Arkansas | 5149 | 4585 | 77 |
1809909 | 1809909 | 2021-10-12 | Smyth | Virginia | 51173 | 4585 | 109 |
1803460 | 1803460 | 2021-10-10 | Stevens | Washington | 53065 | 4585 | 77 |
1800211 | 1800211 | 2021-10-09 | Stevens | Washington | 53065 | 4585 | 77 |
1796962 | 1796962 | 2021-10-08 | Stevens | Washington | 53065 | 4585 | 77 |
1793861 | 1793861 | 2021-10-07 | Park | Wyoming | 56029 | 4585 | 54 |
1788829 | 1788829 | 2021-10-06 | Leflore | Mississippi | 28083 | 4585 | 141 |
1765332 | 1765332 | 2021-09-29 | Adams | Indiana | 18001 | 4585 | 70 |
1710774 | 1710774 | 2021-09-12 | Morrison | Minnesota | 27097 | 4585 | 62 |
1707527 | 1707527 | 2021-09-11 | Morrison | Minnesota | 27097 | 4585 | 62 |
1708009 | 1708009 | 2021-09-11 | Cortland | New York | 36023 | 4585 | 68 |
1704280 | 1704280 | 2021-09-10 | Morrison | Minnesota | 27097 | 4585 | 62 |
1673131 | 1673131 | 2021-08-31 | Grimes | Texas | 48185 | 4585 | 76 |
1632704 | 1632704 | 2021-08-19 | Hillsdale | Michigan | 26059 | 4585 | 96 |
1634473 | 1634473 | 2021-08-19 | Shenandoah | Virginia | 51171 | 4585 | 136 |
1629457 | 1629457 | 2021-08-18 | Hillsdale | Michigan | 26059 | 4585 | 96 |
1620433 | 1620433 | 2021-08-15 | Stokes | North Carolina | 37169 | 4585 | 81 |
1617185 | 1617185 | 2021-08-14 | Stokes | North Carolina | 37169 | 4585 | 81 |
1613937 | 1613937 | 2021-08-13 | Stokes | North Carolina | 37169 | 4585 | 81 |
1582418 | 1582418 | 2021-08-03 | Danville city | Virginia | 51590 | 4585 | 144 |
1538727 | 1538727 | 2021-07-21 | Warren | Mississippi | 28149 | 4585 | 124 |
1531749 | 1531749 | 2021-07-19 | Barren | Kentucky | 21009 | 4585 | 104 |
1533572 | 1533572 | 2021-07-19 | San Patricio | Texas | 48409 | 4585 | 152 |
1530325 | 1530325 | 2021-07-18 | San Patricio | Texas | 48409 | 4585 | 152 |
1527078 | 1527078 | 2021-07-17 | San Patricio | Texas | 48409 | 4585 | 152 |
1522873 | 1522873 | 2021-07-16 | Madison | New York | 36053 | 4585 | 89 |
1517239 | 1517239 | 2021-07-14 | Hill | Texas | 48217 | 4585 | 111 |
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);