ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
153 rows where cases = 3356 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 14
- Minnesota 11
- Illinois 9
- Kentucky 9
- Wisconsin 9
- Colorado 8
- North Carolina 8
- Iowa 7
- New Mexico 7
- Indiana 5
- Mississippi 5
- Missouri 5
- Virginia 5
- Arkansas 4
- Massachusetts 4
- New York 4
- Ohio 4
- Pennsylvania 4
- Oregon 3
- Utah 3
- California 2
- Georgia 2
- Kansas 2
- Louisiana 2
- Nebraska 2
- Puerto Rico 2
- Alabama 1
- Maine 1
- Maryland 1
- Michigan 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463652 | 2463652 | 2022-05-01 | Bayfield | Wisconsin | 55007 | 3356 | 40 |
2460396 | 2460396 | 2022-04-30 | Bayfield | Wisconsin | 55007 | 3356 | 40 |
2457140 | 2457140 | 2022-04-29 | Bayfield | Wisconsin | 55007 | 3356 | 40 |
2365523 | 2365523 | 2022-04-01 | Duval | Texas | 48131 | 3356 | 69 |
2286000 | 2286000 | 2022-03-08 | Nantucket | Massachusetts | 25019 | 3356 | 0 |
2261140 | 2261140 | 2022-02-28 | Salinas | Puerto Rico | 72123 | 3356 | |
2261599 | 2261599 | 2022-02-28 | Tyler | Texas | 48457 | 3356 | 83 |
2231376 | 2231376 | 2022-02-19 | Schuyler | New York | 36097 | 3356 | 24 |
2210248 | 2210248 | 2022-02-13 | Grand | Colorado | 8049 | 3356 | 23 |
2210675 | 2210675 | 2022-02-13 | Washington | Illinois | 17189 | 3356 | 39 |
2206995 | 2206995 | 2022-02-12 | Grand | Colorado | 8049 | 3356 | 23 |
2207422 | 2207422 | 2022-02-12 | Washington | Illinois | 17189 | 3356 | 39 |
2203742 | 2203742 | 2022-02-11 | Grand | Colorado | 8049 | 3356 | 23 |
2204169 | 2204169 | 2022-02-11 | Washington | Illinois | 17189 | 3356 | 39 |
2200916 | 2200916 | 2022-02-10 | Washington | Illinois | 17189 | 3356 | 39 |
2200177 | 2200177 | 2022-02-09 | Rusk | Wisconsin | 55107 | 3356 | 47 |
2190137 | 2190137 | 2022-02-06 | Alleghany | Virginia | 51005 | 3356 | 90 |
2186884 | 2186884 | 2022-02-05 | Alleghany | Virginia | 51005 | 3356 | 90 |
2183631 | 2183631 | 2022-02-04 | Alleghany | Virginia | 51005 | 3356 | 90 |
2155688 | 2155688 | 2022-01-27 | Caldwell | Kentucky | 21033 | 3356 | 56 |
2149061 | 2149061 | 2022-01-25 | Wright | Iowa | 19197 | 3356 | 56 |
2145809 | 2145809 | 2022-01-24 | Wright | Iowa | 19197 | 3356 | 56 |
2142554 | 2142554 | 2022-01-23 | Wright | Iowa | 19197 | 3356 | 56 |
2139299 | 2139299 | 2022-01-22 | Wright | Iowa | 19197 | 3356 | 56 |
2136043 | 2136043 | 2022-01-21 | Wright | Iowa | 19197 | 3356 | 56 |
2132791 | 2132791 | 2022-01-20 | Wright | Iowa | 19197 | 3356 | 56 |
2129538 | 2129538 | 2022-01-19 | Wright | Iowa | 19197 | 3356 | 56 |
2110028 | 2110028 | 2022-01-13 | Atchison | Kansas | 20005 | 3356 | 30 |
2106777 | 2106777 | 2022-01-12 | Atchison | Kansas | 20005 | 3356 | 30 |
2108940 | 2108940 | 2022-01-12 | Asotin | Washington | 53003 | 3356 | 54 |
2082660 | 2082660 | 2022-01-04 | Montague | Texas | 48337 | 3356 | 99 |
2055867 | 2055867 | 2021-12-27 | Yancey | North Carolina | 37199 | 3356 | 36 |
2052617 | 2052617 | 2021-12-26 | Yancey | North Carolina | 37199 | 3356 | 36 |
2053263 | 2053263 | 2021-12-26 | Burleson | Texas | 48051 | 3356 | 60 |
2049367 | 2049367 | 2021-12-25 | Yancey | North Carolina | 37199 | 3356 | 36 |
2050013 | 2050013 | 2021-12-25 | Burleson | Texas | 48051 | 3356 | 60 |
2046117 | 2046117 | 2021-12-24 | Yancey | North Carolina | 37199 | 3356 | 36 |
2046763 | 2046763 | 2021-12-24 | Burleson | Texas | 48051 | 3356 | 60 |
2042867 | 2042867 | 2021-12-23 | Yancey | North Carolina | 37199 | 3356 | 36 |
2043513 | 2043513 | 2021-12-23 | Burleson | Texas | 48051 | 3356 | 60 |
2039618 | 2039618 | 2021-12-22 | Yancey | North Carolina | 37199 | 3356 | 36 |
2035862 | 2035862 | 2021-12-21 | Andrew | Missouri | 29003 | 3356 | 41 |
2037115 | 2037115 | 2021-12-21 | Jones | Texas | 48253 | 3356 | 79 |
2008482 | 2008482 | 2021-12-13 | Conway | Arkansas | 5029 | 3356 | 46 |
2005231 | 2005231 | 2021-12-12 | Conway | Arkansas | 5029 | 3356 | 46 |
1946264 | 1946264 | 2021-11-23 | Orleans | Vermont | 50019 | 3356 | 24 |
1938191 | 1938191 | 2021-11-21 | Dodge | Minnesota | 27039 | 3356 | 11 |
1934941 | 1934941 | 2021-11-20 | Dodge | Minnesota | 27039 | 3356 | 11 |
1931691 | 1931691 | 2021-11-19 | Dodge | Minnesota | 27039 | 3356 | 11 |
1925788 | 1925788 | 2021-11-17 | Greene | North Carolina | 37079 | 3356 | 55 |
1918915 | 1918915 | 2021-11-15 | New Madrid | Missouri | 29143 | 3356 | 57 |
1919168 | 1919168 | 2021-11-15 | Grant | New Mexico | 35017 | 3356 | 54 |
1915665 | 1915665 | 2021-11-14 | New Madrid | Missouri | 29143 | 3356 | 57 |
1912415 | 1912415 | 2021-11-13 | New Madrid | Missouri | 29143 | 3356 | 57 |
1900311 | 1900311 | 2021-11-09 | Beadle | South Dakota | 46005 | 3356 | 47 |
1896015 | 1896015 | 2021-11-08 | Attala | Mississippi | 28007 | 3356 | 90 |
1892396 | 1892396 | 2021-11-07 | Harrison | Kentucky | 21097 | 3356 | 39 |
1889146 | 1889146 | 2021-11-06 | Harrison | Kentucky | 21097 | 3356 | 39 |
1885896 | 1885896 | 2021-11-05 | Harrison | Kentucky | 21097 | 3356 | 39 |
1856223 | 1856223 | 2021-10-27 | Crawford | Illinois | 17033 | 3356 | 46 |
1852655 | 1852655 | 2021-10-26 | Routt | Colorado | 8107 | 3356 | 23 |
1833502 | 1833502 | 2021-10-20 | Jersey | Illinois | 17083 | 3356 | 72 |
1824346 | 1824346 | 2021-10-17 | Franklin | Massachusetts | 25011 | 3356 | 122 |
1821097 | 1821097 | 2021-10-16 | Franklin | Massachusetts | 25011 | 3356 | 122 |
1816738 | 1816738 | 2021-10-15 | Columbia | Arkansas | 5027 | 3356 | 72 |
1817848 | 1817848 | 2021-10-15 | Franklin | Massachusetts | 25011 | 3356 | 122 |
1810608 | 1810608 | 2021-10-13 | Mitchell | Georgia | 13205 | 3356 | 97 |
1786943 | 1786943 | 2021-10-05 | Reeves | Texas | 48389 | 3356 | 49 |
1780525 | 1780525 | 2021-10-03 | Sevier | Utah | 49041 | 3356 | 16 |
1776733 | 1776733 | 2021-10-02 | Dorado | Puerto Rico | 72051 | 3356 | |
1777275 | 1777275 | 2021-10-02 | Sevier | Utah | 49041 | 3356 | 16 |
1774025 | 1774025 | 2021-10-01 | Sevier | Utah | 49041 | 3356 | 16 |
1732398 | 1732398 | 2021-09-19 | Delta | Colorado | 8029 | 3356 | 79 |
1729148 | 1729148 | 2021-09-18 | Delta | Colorado | 8029 | 3356 | 79 |
1725898 | 1725898 | 2021-09-17 | Delta | Colorado | 8029 | 3356 | 79 |
1722649 | 1722649 | 2021-09-16 | Delta | Colorado | 8029 | 3356 | 79 |
1723914 | 1723914 | 2021-09-16 | Crawford | Missouri | 29055 | 3356 | 49 |
1668189 | 1668189 | 2021-08-30 | Carter | Kentucky | 21043 | 3356 | 42 |
1636582 | 1636582 | 2021-08-20 | Washington | New York | 36115 | 3356 | 57 |
1558217 | 1558217 | 2021-07-27 | Yazoo | Mississippi | 28163 | 3356 | 73 |
1553619 | 1553619 | 2021-07-26 | Jackson | Arkansas | 5067 | 3356 | 38 |
1532973 | 1532973 | 2021-07-19 | Benton | Oregon | 41003 | 3356 | 22 |
1509397 | 1509397 | 2021-07-12 | Pine | Minnesota | 27115 | 3356 | 23 |
1506151 | 1506151 | 2021-07-11 | Pine | Minnesota | 27115 | 3356 | 23 |
1502905 | 1502905 | 2021-07-10 | Pine | Minnesota | 27115 | 3356 | 23 |
1499659 | 1499659 | 2021-07-09 | Pine | Minnesota | 27115 | 3356 | 23 |
1496413 | 1496413 | 2021-07-08 | Pine | Minnesota | 27115 | 3356 | 23 |
1498210 | 1498210 | 2021-07-08 | Juneau | Wisconsin | 55057 | 3356 | 31 |
1492577 | 1492577 | 2021-07-07 | White | Indiana | 18181 | 3356 | 55 |
1494963 | 1494963 | 2021-07-07 | Juneau | Wisconsin | 55057 | 3356 | 31 |
1491716 | 1491716 | 2021-07-06 | Juneau | Wisconsin | 55057 | 3356 | 31 |
1488469 | 1488469 | 2021-07-05 | Juneau | Wisconsin | 55057 | 3356 | 31 |
1477841 | 1477841 | 2021-07-02 | Greene | Pennsylvania | 42059 | 3356 | 41 |
1474595 | 1474595 | 2021-07-01 | Greene | Pennsylvania | 42059 | 3356 | 41 |
1392635 | 1392635 | 2021-06-06 | Pike | Mississippi | 28113 | 3356 | 107 |
1389390 | 1389390 | 2021-06-05 | Pike | Mississippi | 28113 | 3356 | 107 |
1386145 | 1386145 | 2021-06-04 | Pike | Mississippi | 28113 | 3356 | 107 |
1373521 | 1373521 | 2021-05-31 | Luna | New Mexico | 35029 | 3356 | 92 |
1370276 | 1370276 | 2021-05-30 | Luna | New Mexico | 35029 | 3356 | 92 |
1367030 | 1367030 | 2021-05-29 | Luna | New Mexico | 35029 | 3356 | 92 |
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);