ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
256 rows where cases = 1884 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 19
- Virginia 15
- Indiana 14
- Texas 13
- Colorado 12
- Mississippi 12
- Arkansas 11
- Missouri 11
- Georgia 10
- Tennessee 10
- Florida 9
- Puerto Rico 9
- North Carolina 8
- Alabama 7
- Oklahoma 7
- West Virginia 7
- Kentucky 6
- Michigan 6
- Minnesota 6
- Oregon 6
- Washington 6
- Ohio 5
- California 4
- Idaho 4
- Nebraska 4
- Pennsylvania 4
- Montana 3
- New York 3
- Vermont 3
- Wisconsin 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496173 | 2496173 | 2022-05-11 | Calhoun | West Virginia | 54013 | 1884 | 15 |
2492915 | 2492915 | 2022-05-10 | Calhoun | West Virginia | 54013 | 1884 | 15 |
2489657 | 2489657 | 2022-05-09 | Calhoun | West Virginia | 54013 | 1884 | 15 |
2464052 | 2464052 | 2022-05-02 | Yuma | Colorado | 8125 | 1884 | 23 |
2460796 | 2460796 | 2022-05-01 | Yuma | Colorado | 8125 | 1884 | 23 |
2457540 | 2457540 | 2022-04-30 | Yuma | Colorado | 8125 | 1884 | 23 |
2454284 | 2454284 | 2022-04-29 | Yuma | Colorado | 8125 | 1884 | 23 |
2451028 | 2451028 | 2022-04-28 | Yuma | Colorado | 8125 | 1884 | 23 |
2447772 | 2447772 | 2022-04-27 | Yuma | Colorado | 8125 | 1884 | 23 |
2444516 | 2444516 | 2022-04-26 | Yuma | Colorado | 8125 | 1884 | 23 |
2441260 | 2441260 | 2022-04-25 | Yuma | Colorado | 8125 | 1884 | 23 |
2424101 | 2424101 | 2022-04-19 | Crosby | Texas | 48107 | 1884 | 45 |
2235439 | 2235439 | 2022-02-20 | Floyd | Texas | 48153 | 1884 | 47 |
2232188 | 2232188 | 2022-02-19 | Floyd | Texas | 48153 | 1884 | 47 |
2222879 | 2222879 | 2022-02-16 | Tucker | West Virginia | 54093 | 1884 | 33 |
2203630 | 2203630 | 2022-02-11 | Monroe | Arkansas | 5095 | 1884 | 28 |
2202228 | 2202228 | 2022-02-10 | Benson | North Dakota | 38005 | 1884 | 22 |
2195398 | 2195398 | 2022-02-08 | Cheyenne | Nebraska | 31033 | 1884 | 23 |
2172313 | 2172313 | 2022-02-01 | Marshall | Minnesota | 27089 | 1884 | 23 |
2173306 | 2173306 | 2022-02-01 | Guayanilla | Puerto Rico | 72059 | 1884 | |
2168257 | 2168257 | 2022-01-31 | Boundary | Idaho | 16021 | 1884 | 54 |
2169114 | 2169114 | 2022-01-31 | Choctaw | Mississippi | 28019 | 1884 | 28 |
2170054 | 2170054 | 2022-01-31 | Guayanilla | Puerto Rico | 72059 | 1884 | |
2157673 | 2157673 | 2022-01-27 | Lunenburg | Virginia | 51111 | 1884 | 23 |
2146856 | 2146856 | 2022-01-24 | Graham | North Carolina | 37075 | 1884 | 30 |
2142252 | 2142252 | 2022-01-23 | Owyhee | Idaho | 16073 | 1884 | 43 |
2138997 | 2138997 | 2022-01-22 | Owyhee | Idaho | 16073 | 1884 | 43 |
2131417 | 2131417 | 2022-01-19 | Live Oak | Texas | 48297 | 1884 | 39 |
2122685 | 2122685 | 2022-01-17 | Wilkinson | Georgia | 13319 | 1884 | 48 |
2098099 | 2098099 | 2022-01-09 | Pamlico | North Carolina | 37137 | 1884 | 27 |
2094847 | 2094847 | 2022-01-08 | Pamlico | North Carolina | 37137 | 1884 | 27 |
2091595 | 2091595 | 2022-01-07 | Pamlico | North Carolina | 37137 | 1884 | 27 |
2091913 | 2091913 | 2022-01-07 | Forest | Pennsylvania | 42053 | 1884 | 31 |
2058648 | 2058648 | 2021-12-28 | Grundy | Missouri | 29079 | 1884 | 57 |
2035191 | 2035191 | 2021-12-21 | Emmet | Iowa | 19063 | 1884 | 47 |
2031941 | 2031941 | 2021-12-20 | Emmet | Iowa | 19063 | 1884 | 47 |
2028690 | 2028690 | 2021-12-19 | Emmet | Iowa | 19063 | 1884 | 47 |
2030805 | 2030805 | 2021-12-19 | Brunswick | Virginia | 51025 | 1884 | 35 |
2025439 | 2025439 | 2021-12-18 | Emmet | Iowa | 19063 | 1884 | 47 |
2027554 | 2027554 | 2021-12-18 | Brunswick | Virginia | 51025 | 1884 | 35 |
2022188 | 2022188 | 2021-12-17 | Emmet | Iowa | 19063 | 1884 | 47 |
2024303 | 2024303 | 2021-12-17 | Brunswick | Virginia | 51025 | 1884 | 35 |
2018820 | 2018820 | 2021-12-16 | Brown | Indiana | 18013 | 1884 | 51 |
2018937 | 2018937 | 2021-12-16 | Emmet | Iowa | 19063 | 1884 | 47 |
2021052 | 2021052 | 2021-12-16 | Brunswick | Virginia | 51025 | 1884 | 35 |
2014877 | 2014877 | 2021-12-15 | Coosa | Alabama | 1037 | 1884 | 48 |
2015687 | 2015687 | 2021-12-15 | Emmet | Iowa | 19063 | 1884 | 47 |
2009912 | 2009912 | 2021-12-13 | Lewis | Missouri | 29111 | 1884 | 30 |
2006661 | 2006661 | 2021-12-12 | Lewis | Missouri | 29111 | 1884 | 30 |
2003410 | 2003410 | 2021-12-11 | Lewis | Missouri | 29111 | 1884 | 30 |
1989683 | 1989683 | 2021-12-07 | Franklin | Iowa | 19069 | 1884 | 31 |
1986433 | 1986433 | 2021-12-06 | Franklin | Iowa | 19069 | 1884 | 31 |
1983183 | 1983183 | 2021-12-05 | Franklin | Iowa | 19069 | 1884 | 31 |
1983855 | 1983855 | 2021-12-05 | Barton | Missouri | 29011 | 1884 | 39 |
1979933 | 1979933 | 2021-12-04 | Franklin | Iowa | 19069 | 1884 | 31 |
1980605 | 1980605 | 2021-12-04 | Barton | Missouri | 29011 | 1884 | 39 |
1976683 | 1976683 | 2021-12-03 | Franklin | Iowa | 19069 | 1884 | 31 |
1973434 | 1973434 | 2021-12-02 | Franklin | Iowa | 19069 | 1884 | 31 |
1970184 | 1970184 | 2021-12-01 | Franklin | Iowa | 19069 | 1884 | 31 |
1966238 | 1966238 | 2021-11-30 | Fulton | Arkansas | 5049 | 1884 | 67 |
1965423 | 1965423 | 2021-11-29 | Houston | Tennessee | 47083 | 1884 | 45 |
1965507 | 1965507 | 2021-11-29 | Callahan | Texas | 48059 | 1884 | 57 |
1962686 | 1962686 | 2021-11-28 | Pacific | Washington | 53049 | 1884 | 34 |
1959435 | 1959435 | 2021-11-27 | Pacific | Washington | 53049 | 1884 | 34 |
1956184 | 1956184 | 2021-11-26 | Pacific | Washington | 53049 | 1884 | 34 |
1952933 | 1952933 | 2021-11-25 | Pacific | Washington | 53049 | 1884 | 34 |
1949682 | 1949682 | 2021-11-24 | Pacific | Washington | 53049 | 1884 | 34 |
1946431 | 1946431 | 2021-11-23 | Pacific | Washington | 53049 | 1884 | 34 |
1938533 | 1938533 | 2021-11-21 | Colfax | Nebraska | 31037 | 1884 | 22 |
1939081 | 1939081 | 2021-11-21 | Curry | Oregon | 41015 | 1884 | 35 |
1935283 | 1935283 | 2021-11-20 | Colfax | Nebraska | 31037 | 1884 | 22 |
1935831 | 1935831 | 2021-11-20 | Curry | Oregon | 41015 | 1884 | 35 |
1932033 | 1932033 | 2021-11-19 | Colfax | Nebraska | 31037 | 1884 | 22 |
1932581 | 1932581 | 2021-11-19 | Curry | Oregon | 41015 | 1884 | 35 |
1876399 | 1876399 | 2021-11-02 | Missaukee | Michigan | 26113 | 1884 | 39 |
1878002 | 1878002 | 2021-11-02 | Unknown | Utah | 1884 | 39 | |
1873150 | 1873150 | 2021-11-01 | Missaukee | Michigan | 26113 | 1884 | 39 |
1870608 | 1870608 | 2021-10-31 | Barnes | North Dakota | 38003 | 1884 | 33 |
1858871 | 1858871 | 2021-10-28 | Conecuh | Alabama | 1035 | 1884 | 54 |
1855336 | 1855336 | 2021-10-26 | Greensville | Virginia | 51081 | 1884 | 28 |
1852087 | 1852087 | 2021-10-25 | Greensville | Virginia | 51081 | 1884 | 28 |
1835851 | 1835851 | 2021-10-20 | King William | Virginia | 51101 | 1884 | 24 |
1831975 | 1831975 | 2021-10-19 | Hatillo | Puerto Rico | 72065 | 1884 | |
1828726 | 1828726 | 2021-10-18 | Hatillo | Puerto Rico | 72065 | 1884 | |
1829223 | 1829223 | 2021-10-18 | Ward | Texas | 48475 | 1884 | 27 |
1816745 | 1816745 | 2021-10-15 | Desha | Arkansas | 5041 | 1884 | 32 |
1788470 | 1788470 | 2021-10-06 | Pendleton | Kentucky | 21191 | 1884 | 14 |
1788995 | 1788995 | 2021-10-06 | Custer | Montana | 30017 | 1884 | 27 |
1776728 | 1776728 | 2021-10-02 | Cidra | Puerto Rico | 72041 | 1884 | |
1748140 | 1748140 | 2021-09-23 | Martinsville city | Virginia | 51690 | 1884 | 85 |
1739875 | 1739875 | 2021-09-21 | Nantucket | Massachusetts | 25019 | 1884 | 0 |
1740754 | 1740754 | 2021-09-21 | Monroe | Ohio | 39111 | 1884 | 49 |
1736626 | 1736626 | 2021-09-20 | Nantucket | Massachusetts | 25019 | 1884 | 0 |
1738574 | 1738574 | 2021-09-20 | Lafayette | Wisconsin | 55065 | 1884 | 11 |
1720524 | 1720524 | 2021-09-15 | Pennington | Minnesota | 27113 | 1884 | 21 |
1717754 | 1717754 | 2021-09-14 | Essex | New York | 36031 | 1884 | 29 |
1705827 | 1705827 | 2021-09-10 | Windsor | Vermont | 50027 | 1884 | 18 |
1698754 | 1698754 | 2021-09-08 | Cayey | Puerto Rico | 72035 | 1884 | |
1660827 | 1660827 | 2021-08-28 | Marion | Arkansas | 5089 | 1884 | 49 |
1646071 | 1646071 | 2021-08-23 | Lincoln | Montana | 30053 | 1884 | 28 |
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);