ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,073 rows where cases = 175 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 127
- Missouri 46
- Virginia 46
- Kentucky 45
- Montana 45
- Georgia 44
- Kansas 42
- Nebraska 40
- Colorado 35
- Indiana 34
- Michigan 32
- North Carolina 31
- New Mexico 30
- Puerto Rico 29
- North Dakota 28
- Tennessee 27
- Minnesota 26
- Iowa 25
- Washington 25
- Arkansas 24
- Ohio 24
- Illinois 23
- Mississippi 22
- Oklahoma 21
- West Virginia 20
- New York 16
- California 14
- South Dakota 14
- Alabama 13
- Louisiana 13
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502404 | 2502404 | 2022-05-13 | Roberts | Texas | 48393 | 175 | 2 |
2499146 | 2499146 | 2022-05-12 | Roberts | Texas | 48393 | 175 | 2 |
2495888 | 2495888 | 2022-05-11 | Roberts | Texas | 48393 | 175 | 2 |
2492630 | 2492630 | 2022-05-10 | Roberts | Texas | 48393 | 175 | 2 |
2489372 | 2489372 | 2022-05-09 | Roberts | Texas | 48393 | 175 | 2 |
2486114 | 2486114 | 2022-05-08 | Roberts | Texas | 48393 | 175 | 2 |
2482856 | 2482856 | 2022-05-07 | Roberts | Texas | 48393 | 175 | 2 |
2479598 | 2479598 | 2022-05-06 | Roberts | Texas | 48393 | 175 | 2 |
2476340 | 2476340 | 2022-05-05 | Roberts | Texas | 48393 | 175 | 2 |
2473083 | 2473083 | 2022-05-04 | Roberts | Texas | 48393 | 175 | 2 |
2469827 | 2469827 | 2022-05-03 | Roberts | Texas | 48393 | 175 | 2 |
2466571 | 2466571 | 2022-05-02 | Roberts | Texas | 48393 | 175 | 2 |
2463316 | 2463316 | 2022-05-01 | Roberts | Texas | 48393 | 175 | 2 |
2460060 | 2460060 | 2022-04-30 | Roberts | Texas | 48393 | 175 | 2 |
2456804 | 2456804 | 2022-04-29 | Roberts | Texas | 48393 | 175 | 2 |
2453548 | 2453548 | 2022-04-28 | Roberts | Texas | 48393 | 175 | 2 |
2450292 | 2450292 | 2022-04-27 | Roberts | Texas | 48393 | 175 | 2 |
2447035 | 2447035 | 2022-04-26 | Roberts | Texas | 48393 | 175 | 2 |
2443780 | 2443780 | 2022-04-25 | Roberts | Texas | 48393 | 175 | 2 |
2439444 | 2439444 | 2022-04-24 | Rock | Nebraska | 31149 | 175 | 2 |
2440524 | 2440524 | 2022-04-24 | Roberts | Texas | 48393 | 175 | 2 |
2436188 | 2436188 | 2022-04-23 | Rock | Nebraska | 31149 | 175 | 2 |
2437268 | 2437268 | 2022-04-23 | Roberts | Texas | 48393 | 175 | 2 |
2432932 | 2432932 | 2022-04-22 | Rock | Nebraska | 31149 | 175 | 2 |
2434012 | 2434012 | 2022-04-22 | Roberts | Texas | 48393 | 175 | 2 |
2430756 | 2430756 | 2022-04-21 | Roberts | Texas | 48393 | 175 | 2 |
2427500 | 2427500 | 2022-04-20 | Roberts | Texas | 48393 | 175 | 2 |
2424244 | 2424244 | 2022-04-19 | Roberts | Texas | 48393 | 175 | 2 |
2420988 | 2420988 | 2022-04-18 | Roberts | Texas | 48393 | 175 | 2 |
2417732 | 2417732 | 2022-04-17 | Roberts | Texas | 48393 | 175 | 2 |
2414476 | 2414476 | 2022-04-16 | Roberts | Texas | 48393 | 175 | 2 |
2411220 | 2411220 | 2022-04-15 | Roberts | Texas | 48393 | 175 | 2 |
2407964 | 2407964 | 2022-04-14 | Roberts | Texas | 48393 | 175 | 2 |
2404708 | 2404708 | 2022-04-13 | Roberts | Texas | 48393 | 175 | 2 |
2401453 | 2401453 | 2022-04-12 | Roberts | Texas | 48393 | 175 | 2 |
2378620 | 2378620 | 2022-04-05 | Loving | Texas | 48301 | 175 | 1 |
2241739 | 2241739 | 2022-02-22 | Jones | South Dakota | 46075 | 175 | 2 |
2141959 | 2141959 | 2022-01-23 | San Juan | Colorado | 8111 | 175 | 0 |
2138704 | 2138704 | 2022-01-22 | San Juan | Colorado | 8111 | 175 | 0 |
2135448 | 2135448 | 2022-01-21 | San Juan | Colorado | 8111 | 175 | 0 |
2128943 | 2128943 | 2022-01-19 | San Juan | Colorado | 8111 | 175 | 0 |
2121734 | 2121734 | 2022-01-16 | Throckmorton | Texas | 48447 | 175 | 7 |
2105339 | 2105339 | 2022-01-11 | Glasscock | Texas | 48173 | 175 | 3 |
2101007 | 2101007 | 2022-01-10 | Garfield | Montana | 30033 | 175 | 3 |
2097756 | 2097756 | 2022-01-09 | Garfield | Montana | 30033 | 175 | 3 |
2094504 | 2094504 | 2022-01-08 | Garfield | Montana | 30033 | 175 | 3 |
2091252 | 2091252 | 2022-01-07 | Garfield | Montana | 30033 | 175 | 3 |
2088001 | 2088001 | 2022-01-06 | Garfield | Montana | 30033 | 175 | 3 |
2084749 | 2084749 | 2022-01-05 | Garfield | Montana | 30033 | 175 | 3 |
2081497 | 2081497 | 2022-01-04 | Garfield | Montana | 30033 | 175 | 3 |
1967772 | 1967772 | 2021-11-30 | Wibaux | Montana | 30109 | 175 | 8 |
1964520 | 1964520 | 2021-11-29 | Wibaux | Montana | 30109 | 175 | 8 |
1961269 | 1961269 | 2021-11-28 | Wibaux | Montana | 30109 | 175 | 8 |
1958018 | 1958018 | 2021-11-27 | Wibaux | Montana | 30109 | 175 | 8 |
1954767 | 1954767 | 2021-11-26 | Wibaux | Montana | 30109 | 175 | 8 |
1951501 | 1951501 | 2021-11-25 | Prairie | Montana | 30079 | 175 | 2 |
1948250 | 1948250 | 2021-11-24 | Prairie | Montana | 30079 | 175 | 2 |
1944999 | 1944999 | 2021-11-23 | Prairie | Montana | 30079 | 175 | 2 |
1941748 | 1941748 | 2021-11-22 | Prairie | Montana | 30079 | 175 | 2 |
1942567 | 1942567 | 2021-11-22 | Campbell | South Dakota | 46021 | 175 | 4 |
1939317 | 1939317 | 2021-11-21 | Campbell | South Dakota | 46021 | 175 | 4 |
1936067 | 1936067 | 2021-11-20 | Campbell | South Dakota | 46021 | 175 | 4 |
1932817 | 1932817 | 2021-11-19 | Campbell | South Dakota | 46021 | 175 | 4 |
1900103 | 1900103 | 2021-11-09 | Sherman | Oregon | 41055 | 175 | 3 |
1896853 | 1896853 | 2021-11-08 | Sherman | Oregon | 41055 | 175 | 3 |
1893603 | 1893603 | 2021-11-07 | Sherman | Oregon | 41055 | 175 | 3 |
1890353 | 1890353 | 2021-11-06 | Sherman | Oregon | 41055 | 175 | 3 |
1887103 | 1887103 | 2021-11-05 | Sherman | Oregon | 41055 | 175 | 3 |
1883853 | 1883853 | 2021-11-04 | Sherman | Oregon | 41055 | 175 | 3 |
1852001 | 1852001 | 2021-10-25 | Piute | Utah | 49031 | 175 | 2 |
1848751 | 1848751 | 2021-10-24 | Piute | Utah | 49031 | 175 | 2 |
1845501 | 1845501 | 2021-10-23 | Piute | Utah | 49031 | 175 | 2 |
1842251 | 1842251 | 2021-10-22 | Piute | Utah | 49031 | 175 | 2 |
1833113 | 1833113 | 2021-10-20 | Cheyenne | Colorado | 8017 | 175 | 7 |
1787466 | 1787466 | 2021-10-06 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 175 | 2 |
1763416 | 1763416 | 2021-09-28 | Oliver | North Dakota | 38065 | 175 | 3 |
1755144 | 1755144 | 2021-09-26 | Dolores | Colorado | 8033 | 175 | 1 |
1751896 | 1751896 | 2021-09-25 | Dolores | Colorado | 8033 | 175 | 1 |
1748647 | 1748647 | 2021-09-24 | Dolores | Colorado | 8033 | 175 | 1 |
1751087 | 1751087 | 2021-09-24 | Foard | Texas | 48155 | 175 | 10 |
1747838 | 1747838 | 2021-09-23 | Foard | Texas | 48155 | 175 | 10 |
1744588 | 1744588 | 2021-09-22 | Foard | Texas | 48155 | 175 | 10 |
1741339 | 1741339 | 2021-09-21 | Foard | Texas | 48155 | 175 | 10 |
1741379 | 1741379 | 2021-09-21 | Irion | Texas | 48235 | 175 | 2 |
1738090 | 1738090 | 2021-09-20 | Foard | Texas | 48155 | 175 | 10 |
1738130 | 1738130 | 2021-09-20 | Irion | Texas | 48235 | 175 | 2 |
1734840 | 1734840 | 2021-09-19 | Foard | Texas | 48155 | 175 | 10 |
1731590 | 1731590 | 2021-09-18 | Foard | Texas | 48155 | 175 | 10 |
1699246 | 1699246 | 2021-09-08 | Stonewall | Texas | 48433 | 175 | 6 |
1643561 | 1643561 | 2021-08-22 | Maricao | Puerto Rico | 72093 | 175 | |
1640311 | 1640311 | 2021-08-21 | Maricao | Puerto Rico | 72093 | 175 | |
1637061 | 1637061 | 2021-08-20 | Maricao | Puerto Rico | 72093 | 175 | |
1631976 | 1631976 | 2021-08-19 | Webster | Georgia | 13307 | 175 | 4 |
1633811 | 1633811 | 2021-08-19 | Maricao | Puerto Rico | 72093 | 175 | |
1597147 | 1597147 | 2021-08-08 | Issaquena | Mississippi | 28055 | 175 | 6 |
1598799 | 1598799 | 2021-08-08 | Wahkiakum | Washington | 53069 | 175 | 3 |
1598944 | 1598944 | 2021-08-08 | Niobrara | Wyoming | 56027 | 175 | 3 |
1593898 | 1593898 | 2021-08-07 | Issaquena | Mississippi | 28055 | 175 | 6 |
1595550 | 1595550 | 2021-08-07 | Wahkiakum | Washington | 53069 | 175 | 3 |
1595695 | 1595695 | 2021-08-07 | Niobrara | Wyoming | 56027 | 175 | 3 |
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);