ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
139 rows where cases = 4584 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 11
- Puerto Rico 10
- South Dakota 9
- West Virginia 8
- Georgia 7
- Iowa 7
- Oklahoma 7
- Tennessee 7
- Mississippi 6
- Ohio 6
- Virginia 6
- California 5
- Wisconsin 5
- Alabama 4
- Arkansas 4
- Idaho 4
- Illinois 4
- Louisiana 4
- Massachusetts 3
- Michigan 3
- New York 3
- Minnesota 2
- Nebraska 2
- Pennsylvania 2
- Washington 2
- Indiana 1
- Kentucky 1
- Maine 1
- Maryland 1
- Missouri 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499608 | 2499608 | 2022-05-13 | Henry | Alabama | 1067 | 4584 | 76 |
2470216 | 2470216 | 2022-05-03 | Sawyer | Wisconsin | 55113 | 4584 | 62 |
2441152 | 2441152 | 2022-04-25 | Inyo | California | 6027 | 4584 | 56 |
2437896 | 2437896 | 2022-04-24 | Inyo | California | 6027 | 4584 | 56 |
2434640 | 2434640 | 2022-04-23 | Inyo | California | 6027 | 4584 | 56 |
2436856 | 2436856 | 2022-04-23 | Yabucoa | Puerto Rico | 72151 | 4584 | |
2431384 | 2431384 | 2022-04-22 | Inyo | California | 6027 | 4584 | 56 |
2422223 | 2422223 | 2022-04-19 | Buchanan | Iowa | 19019 | 4584 | 58 |
2418967 | 2418967 | 2022-04-18 | Buchanan | Iowa | 19019 | 4584 | 58 |
2415711 | 2415711 | 2022-04-17 | Buchanan | Iowa | 19019 | 4584 | 58 |
2412455 | 2412455 | 2022-04-16 | Buchanan | Iowa | 19019 | 4584 | 58 |
2409199 | 2409199 | 2022-04-15 | Buchanan | Iowa | 19019 | 4584 | 58 |
2405943 | 2405943 | 2022-04-14 | Buchanan | Iowa | 19019 | 4584 | 58 |
2402687 | 2402687 | 2022-04-13 | Buchanan | Iowa | 19019 | 4584 | 58 |
2398184 | 2398184 | 2022-04-11 | Panola | Texas | 48365 | 4584 | 129 |
2394929 | 2394929 | 2022-04-10 | Panola | Texas | 48365 | 4584 | 129 |
2391673 | 2391673 | 2022-04-09 | Panola | Texas | 48365 | 4584 | 129 |
2388417 | 2388417 | 2022-04-08 | Panola | Texas | 48365 | 4584 | 129 |
2378309 | 2378309 | 2022-04-05 | Beadle | South Dakota | 46005 | 4584 | 58 |
2375055 | 2375055 | 2022-04-04 | Beadle | South Dakota | 46005 | 4584 | 58 |
2371803 | 2371803 | 2022-04-03 | Beadle | South Dakota | 46005 | 4584 | 58 |
2368550 | 2368550 | 2022-04-02 | Beadle | South Dakota | 46005 | 4584 | 58 |
2365297 | 2365297 | 2022-04-01 | Beadle | South Dakota | 46005 | 4584 | 58 |
2362044 | 2362044 | 2022-03-31 | Beadle | South Dakota | 46005 | 4584 | 58 |
2358790 | 2358790 | 2022-03-30 | Beadle | South Dakota | 46005 | 4584 | 58 |
2355304 | 2355304 | 2022-03-29 | Clatsop | Oregon | 41007 | 4584 | 44 |
2345697 | 2345697 | 2022-03-26 | Morovis | Puerto Rico | 72101 | 4584 | |
2312976 | 2312976 | 2022-03-16 | Marshall | Oklahoma | 40095 | 4584 | 40 |
2309723 | 2309723 | 2022-03-15 | Marshall | Oklahoma | 40095 | 4584 | 40 |
2306470 | 2306470 | 2022-03-14 | Marshall | Oklahoma | 40095 | 4584 | 40 |
2303219 | 2303219 | 2022-03-13 | Marshall | Oklahoma | 40095 | 4584 | 40 |
2299967 | 2299967 | 2022-03-12 | Marshall | Oklahoma | 40095 | 4584 | 40 |
2296715 | 2296715 | 2022-03-11 | Marshall | Oklahoma | 40095 | 4584 | 40 |
2293463 | 2293463 | 2022-03-10 | Marshall | Oklahoma | 40095 | 4584 | 40 |
2285372 | 2285372 | 2022-03-08 | Cass | Illinois | 17017 | 4584 | 44 |
2278434 | 2278434 | 2022-03-06 | Sharp | Arkansas | 5135 | 4584 | 100 |
2273878 | 2273878 | 2022-03-04 | Paulding | Ohio | 39125 | 4584 | 73 |
2270625 | 2270625 | 2022-03-03 | Paulding | Ohio | 39125 | 4584 | 72 |
2261975 | 2261975 | 2022-02-28 | Carbon | Wyoming | 56007 | 4584 | 50 |
2229617 | 2229617 | 2022-02-19 | Drew | Arkansas | 5043 | 4584 | 60 |
2192390 | 2192390 | 2022-02-07 | Currituck | North Carolina | 37053 | 4584 | 32 |
2133117 | 2133117 | 2022-01-20 | Somerset | Maryland | 24039 | 4584 | 63 |
2112347 | 2112347 | 2022-01-13 | Vernon | Wisconsin | 55123 | 4584 | 76 |
2102478 | 2102478 | 2022-01-10 | Boone | West Virginia | 54005 | 4584 | 62 |
2079839 | 2079839 | 2022-01-03 | Waushara | Wisconsin | 55137 | 4584 | 73 |
2076480 | 2076480 | 2022-01-02 | Jackson | West Virginia | 54035 | 4584 | 109 |
2073229 | 2073229 | 2022-01-01 | Jackson | West Virginia | 54035 | 4584 | 109 |
2069978 | 2069978 | 2021-12-31 | Jackson | West Virginia | 54035 | 4584 | 109 |
2066727 | 2066727 | 2021-12-30 | Jackson | West Virginia | 54035 | 4584 | 109 |
2051195 | 2051195 | 2021-12-26 | Jefferson | Idaho | 16051 | 4584 | 53 |
2047945 | 2047945 | 2021-12-25 | Jefferson | Idaho | 16051 | 4584 | 53 |
2044695 | 2044695 | 2021-12-24 | Jefferson | Idaho | 16051 | 4584 | 53 |
2041446 | 2041446 | 2021-12-23 | Jefferson | Idaho | 16051 | 4584 | 53 |
2012842 | 2012842 | 2021-12-14 | Franklin | Massachusetts | 25011 | 4584 | 127 |
2006270 | 2006270 | 2021-12-12 | Sabine | Louisiana | 22085 | 4584 | 96 |
2008255 | 2008255 | 2021-12-12 | Upshur | West Virginia | 54097 | 4584 | 71 |
2003019 | 2003019 | 2021-12-11 | Sabine | Louisiana | 22085 | 4584 | 96 |
1999769 | 1999769 | 2021-12-10 | Sabine | Louisiana | 22085 | 4584 | 96 |
1987099 | 1987099 | 2021-12-06 | Yazoo | Mississippi | 28163 | 4584 | 92 |
1945748 | 1945748 | 2021-11-23 | Trujillo Alto | Puerto Rico | 72139 | 4584 | |
1942497 | 1942497 | 2021-11-22 | Trujillo Alto | Puerto Rico | 72139 | 4584 | |
1939247 | 1939247 | 2021-11-21 | Trujillo Alto | Puerto Rico | 72139 | 4584 | |
1935997 | 1935997 | 2021-11-20 | Trujillo Alto | Puerto Rico | 72139 | 4584 | |
1932747 | 1932747 | 2021-11-19 | Trujillo Alto | Puerto Rico | 72139 | 4584 | |
1929496 | 1929496 | 2021-11-18 | Trujillo Alto | Puerto Rico | 72139 | 4584 | |
1926346 | 1926346 | 2021-11-17 | Lawrence | South Dakota | 46081 | 4584 | 65 |
1913171 | 1913171 | 2021-11-13 | Warren | Pennsylvania | 42123 | 4584 | 142 |
1855484 | 1855484 | 2021-10-26 | Mingo | West Virginia | 54059 | 4584 | 79 |
1846003 | 1846003 | 2021-10-24 | Johnson | Arkansas | 5071 | 4584 | 57 |
1842753 | 1842753 | 2021-10-23 | Johnson | Arkansas | 5071 | 4584 | 56 |
1837592 | 1837592 | 2021-10-21 | Tate | Mississippi | 28137 | 4584 | 110 |
1834275 | 1834275 | 2021-10-20 | Adams | Mississippi | 28001 | 4584 | 119 |
1834708 | 1834708 | 2021-10-20 | Allegany | New York | 36003 | 4584 | 96 |
1831026 | 1831026 | 2021-10-19 | Adams | Mississippi | 28001 | 4584 | 119 |
1811561 | 1811561 | 2021-10-13 | Itawamba | Mississippi | 28057 | 4584 | 104 |
1812455 | 1812455 | 2021-10-13 | Arecibo | Puerto Rico | 72013 | 4584 | |
1808143 | 1808143 | 2021-10-12 | Huron | Michigan | 26063 | 4584 | 89 |
1804025 | 1804025 | 2021-10-11 | Butts | Georgia | 13035 | 4584 | 105 |
1804892 | 1804892 | 2021-10-11 | Huron | Michigan | 26063 | 4584 | 89 |
1800776 | 1800776 | 2021-10-10 | Butts | Georgia | 13035 | 4584 | 105 |
1797527 | 1797527 | 2021-10-09 | Butts | Georgia | 13035 | 4584 | 105 |
1794278 | 1794278 | 2021-10-08 | Butts | Georgia | 13035 | 4584 | 105 |
1786430 | 1786430 | 2021-10-05 | McKean | Pennsylvania | 42083 | 4584 | 78 |
1676198 | 1676198 | 2021-09-01 | Carroll | Tennessee | 47017 | 4584 | 90 |
1626079 | 1626079 | 2021-08-17 | Evangeline | Louisiana | 22039 | 4584 | 101 |
1628071 | 1628071 | 2021-08-17 | Ohio | West Virginia | 54069 | 4584 | 87 |
1617306 | 1617306 | 2021-08-14 | Madison | Ohio | 39097 | 4584 | 65 |
1600823 | 1600823 | 2021-08-09 | Livingston | New York | 36051 | 4584 | 60 |
1557479 | 1557479 | 2021-07-27 | Montgomery | Indiana | 18107 | 4584 | 94 |
1519625 | 1519625 | 2021-07-15 | Madison | New York | 36053 | 4584 | 89 |
1504825 | 1504825 | 2021-07-11 | Russell | Alabama | 1113 | 4584 | 42 |
1506869 | 1506869 | 2021-07-11 | Knox | Ohio | 39083 | 4584 | 112 |
1501579 | 1501579 | 2021-07-10 | Russell | Alabama | 1113 | 4584 | 42 |
1464028 | 1464028 | 2021-06-28 | Marshall | Mississippi | 28093 | 4584 | 105 |
1465638 | 1465638 | 2021-06-28 | Grays Harbor | Washington | 53027 | 4584 | 75 |
1449284 | 1449284 | 2021-06-23 | Campbell | Virginia | 51031 | 4584 | 88 |
1423318 | 1423318 | 2021-06-15 | Campbell | Virginia | 51031 | 4584 | 88 |
1420071 | 1420071 | 2021-06-14 | Campbell | Virginia | 51031 | 4584 | 88 |
1407090 | 1407090 | 2021-06-10 | Campbell | Virginia | 51031 | 4584 | 86 |
1374284 | 1374284 | 2021-05-31 | Obion | Tennessee | 47131 | 4584 | 97 |
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);