ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,048 rows where cases = 182 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 112
- Puerto Rico 58
- Nebraska 51
- Kansas 50
- Virginia 46
- North Dakota 41
- Montana 40
- Georgia 39
- Colorado 35
- Michigan 35
- Kentucky 34
- Indiana 29
- Illinois 28
- Minnesota 28
- West Virginia 28
- Iowa 26
- North Carolina 26
- Missouri 24
- Mississippi 23
- Arkansas 22
- Ohio 19
- Alaska 18
- Louisiana 18
- New York 18
- Tennessee 18
- Pennsylvania 17
- Oklahoma 16
- Oregon 16
- Alabama 13
- California 13
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2410622 | 2410622 | 2022-04-15 | Unknown | Oklahoma | 182 | 0 | |
2407366 | 2407366 | 2022-04-14 | Unknown | Oklahoma | 182 | 0 | |
2391641 | 2391641 | 2022-04-09 | Loving | Texas | 48301 | 182 | 1 |
2388385 | 2388385 | 2022-04-08 | Loving | Texas | 48301 | 182 | 1 |
2174496 | 2174496 | 2022-02-02 | San Juan | Colorado | 8111 | 182 | 0 |
2148466 | 2148466 | 2022-01-25 | San Juan | Colorado | 8111 | 182 | 0 |
2145214 | 2145214 | 2022-01-24 | San Juan | Colorado | 8111 | 182 | 0 |
2141162 | 2141162 | 2022-01-22 | Kent | Texas | 48263 | 182 | 3 |
2133532 | 2133532 | 2022-01-20 | Judith Basin | Montana | 30045 | 182 | 1 |
2130279 | 2130279 | 2022-01-19 | Judith Basin | Montana | 30045 | 182 | 1 |
2123805 | 2123805 | 2022-01-17 | Wibaux | Montana | 30109 | 182 | 8 |
2124840 | 2124840 | 2022-01-17 | Foard | Texas | 48155 | 182 | 10 |
2120553 | 2120553 | 2022-01-16 | Wibaux | Montana | 30109 | 182 | 8 |
2117301 | 2117301 | 2022-01-15 | Wibaux | Montana | 30109 | 182 | 8 |
2114050 | 2114050 | 2022-01-14 | Wibaux | Montana | 30109 | 182 | 8 |
2110798 | 2110798 | 2022-01-13 | Wibaux | Montana | 30109 | 182 | 8 |
1974982 | 1974982 | 2021-12-02 | Maricao | Puerto Rico | 72093 | 182 | |
1971733 | 1971733 | 2021-12-01 | Maricao | Puerto Rico | 72093 | 182 | |
1968483 | 1968483 | 2021-11-30 | Maricao | Puerto Rico | 72093 | 182 | |
1968576 | 1968576 | 2021-11-30 | Campbell | South Dakota | 46021 | 182 | 4 |
1965232 | 1965232 | 2021-11-29 | Maricao | Puerto Rico | 72093 | 182 | |
1961980 | 1961980 | 2021-11-28 | Maricao | Puerto Rico | 72093 | 182 | |
1958729 | 1958729 | 2021-11-27 | Maricao | Puerto Rico | 72093 | 182 | |
1955478 | 1955478 | 2021-11-26 | Maricao | Puerto Rico | 72093 | 182 | |
1952227 | 1952227 | 2021-11-25 | Maricao | Puerto Rico | 72093 | 182 | |
1948976 | 1948976 | 2021-11-24 | Maricao | Puerto Rico | 72093 | 182 | |
1945725 | 1945725 | 2021-11-23 | Maricao | Puerto Rico | 72093 | 182 | |
1942474 | 1942474 | 2021-11-22 | Maricao | Puerto Rico | 72093 | 182 | |
1939224 | 1939224 | 2021-11-21 | Maricao | Puerto Rico | 72093 | 182 | |
1935974 | 1935974 | 2021-11-20 | Maricao | Puerto Rico | 72093 | 182 | |
1932724 | 1932724 | 2021-11-19 | Maricao | Puerto Rico | 72093 | 182 | |
1928040 | 1928040 | 2021-11-18 | Lane | Kansas | 20101 | 182 | 8 |
1929473 | 1929473 | 2021-11-18 | Maricao | Puerto Rico | 72093 | 182 | |
1924790 | 1924790 | 2021-11-17 | Lane | Kansas | 20101 | 182 | 8 |
1926223 | 1926223 | 2021-11-17 | Maricao | Puerto Rico | 72093 | 182 | |
1922833 | 1922833 | 2021-11-16 | Gilliam | Oregon | 41021 | 182 | 4 |
1922973 | 1922973 | 2021-11-16 | Maricao | Puerto Rico | 72093 | 182 | |
1919724 | 1919724 | 2021-11-15 | Maricao | Puerto Rico | 72093 | 182 | |
1916474 | 1916474 | 2021-11-14 | Maricao | Puerto Rico | 72093 | 182 | |
1913224 | 1913224 | 2021-11-13 | Maricao | Puerto Rico | 72093 | 182 | |
1909974 | 1909974 | 2021-11-12 | Maricao | Puerto Rico | 72093 | 182 | |
1906725 | 1906725 | 2021-11-11 | Maricao | Puerto Rico | 72093 | 182 | |
1903476 | 1903476 | 2021-11-10 | Maricao | Puerto Rico | 72093 | 182 | |
1903799 | 1903799 | 2021-11-10 | Foard | Texas | 48155 | 182 | 10 |
1900226 | 1900226 | 2021-11-09 | Maricao | Puerto Rico | 72093 | 182 | |
1900549 | 1900549 | 2021-11-09 | Foard | Texas | 48155 | 182 | 10 |
1896976 | 1896976 | 2021-11-08 | Maricao | Puerto Rico | 72093 | 182 | |
1897299 | 1897299 | 2021-11-08 | Foard | Texas | 48155 | 182 | 10 |
1893726 | 1893726 | 2021-11-07 | Maricao | Puerto Rico | 72093 | 182 | |
1894049 | 1894049 | 2021-11-07 | Foard | Texas | 48155 | 182 | 10 |
1894334 | 1894334 | 2021-11-07 | Highland | Virginia | 51091 | 182 | 4 |
1890476 | 1890476 | 2021-11-06 | Maricao | Puerto Rico | 72093 | 182 | |
1890799 | 1890799 | 2021-11-06 | Foard | Texas | 48155 | 182 | 10 |
1891084 | 1891084 | 2021-11-06 | Highland | Virginia | 51091 | 182 | 4 |
1887549 | 1887549 | 2021-11-05 | Foard | Texas | 48155 | 182 | 10 |
1887834 | 1887834 | 2021-11-05 | Highland | Virginia | 51091 | 182 | 4 |
1884584 | 1884584 | 2021-11-04 | Highland | Virginia | 51091 | 182 | 4 |
1881335 | 1881335 | 2021-11-03 | Highland | Virginia | 51091 | 182 | 4 |
1854051 | 1854051 | 2021-10-26 | Deuel | Nebraska | 31049 | 182 | 2 |
1850802 | 1850802 | 2021-10-25 | Deuel | Nebraska | 31049 | 182 | 2 |
1847552 | 1847552 | 2021-10-24 | Deuel | Nebraska | 31049 | 182 | 2 |
1844302 | 1844302 | 2021-10-23 | Deuel | Nebraska | 31049 | 182 | 2 |
1841052 | 1841052 | 2021-10-22 | Deuel | Nebraska | 31049 | 182 | 2 |
1837803 | 1837803 | 2021-10-21 | Deuel | Nebraska | 31049 | 182 | 2 |
1829842 | 1829842 | 2021-10-19 | Sierra | California | 6091 | 182 | 0 |
1790114 | 1790114 | 2021-10-06 | Irion | Texas | 48235 | 182 | 2 |
1776414 | 1776414 | 2021-10-02 | Oliver | North Dakota | 38065 | 182 | 3 |
1738229 | 1738229 | 2021-09-20 | Stonewall | Texas | 48433 | 182 | 6 |
1734979 | 1734979 | 2021-09-19 | Stonewall | Texas | 48433 | 182 | 6 |
1731729 | 1731729 | 2021-09-18 | Stonewall | Texas | 48433 | 182 | 6 |
1728479 | 1728479 | 2021-09-17 | Stonewall | Texas | 48433 | 182 | 6 |
1725230 | 1725230 | 2021-09-16 | Stonewall | Texas | 48433 | 182 | 6 |
1721981 | 1721981 | 2021-09-15 | Stonewall | Texas | 48433 | 182 | 6 |
1722211 | 1722211 | 2021-09-15 | Garfield | Washington | 53023 | 182 | 7 |
1718733 | 1718733 | 2021-09-14 | Stonewall | Texas | 48433 | 182 | 6 |
1642524 | 1642524 | 2021-08-22 | Cook | Minnesota | 27031 | 182 | 0 |
1639274 | 1639274 | 2021-08-21 | Cook | Minnesota | 27031 | 182 | 0 |
1636024 | 1636024 | 2021-08-20 | Cook | Minnesota | 27031 | 182 | 0 |
1611765 | 1611765 | 2021-08-12 | Columbia | Washington | 53013 | 182 | 6 |
1595790 | 1595790 | 2021-08-08 | Petersburg Borough | Alaska | 2195 | 182 | 1 |
1592541 | 1592541 | 2021-08-07 | Petersburg Borough | Alaska | 2195 | 182 | 1 |
1589292 | 1589292 | 2021-08-06 | Petersburg Borough | Alaska | 2195 | 182 | 1 |
1586043 | 1586043 | 2021-08-05 | Petersburg Borough | Alaska | 2195 | 182 | 1 |
1587790 | 1587790 | 2021-08-05 | Mora | New Mexico | 35033 | 182 | 8 |
1582793 | 1582793 | 2021-08-04 | Petersburg Borough | Alaska | 2195 | 182 | 1 |
1579543 | 1579543 | 2021-08-03 | Petersburg Borough | Alaska | 2195 | 182 | 1 |
1569112 | 1569112 | 2021-07-30 | Briscoe | Texas | 48045 | 182 | 7 |
1565864 | 1565864 | 2021-07-29 | Briscoe | Texas | 48045 | 182 | 7 |
1556809 | 1556809 | 2021-07-27 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 182 | 4 |
1553562 | 1553562 | 2021-07-26 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 182 | 4 |
1550315 | 1550315 | 2021-07-25 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 182 | 4 |
1551223 | 1551223 | 2021-07-25 | Wallace | Kansas | 20199 | 182 | 4 |
1547068 | 1547068 | 2021-07-24 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 182 | 4 |
1547976 | 1547976 | 2021-07-24 | Wallace | Kansas | 20199 | 182 | 4 |
1543821 | 1543821 | 2021-07-23 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 182 | 4 |
1544729 | 1544729 | 2021-07-23 | Wallace | Kansas | 20199 | 182 | 4 |
1541481 | 1541481 | 2021-07-22 | Wallace | Kansas | 20199 | 182 | 4 |
1538234 | 1538234 | 2021-07-21 | Wallace | Kansas | 20199 | 182 | 4 |
1518674 | 1518674 | 2021-07-15 | Elk | Kansas | 20049 | 182 | 5 |
1515427 | 1515427 | 2021-07-14 | Elk | Kansas | 20049 | 182 | 5 |
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);