ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
574 rows where cases = 711 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 63
- Texas 41
- Georgia 37
- Missouri 31
- Puerto Rico 27
- Kentucky 25
- Virginia 22
- Nebraska 21
- Arkansas 19
- North Dakota 19
- Iowa 18
- Michigan 17
- North Carolina 14
- Montana 13
- Tennessee 13
- Minnesota 12
- Colorado 11
- Illinois 11
- Indiana 10
- Louisiana 10
- Oklahoma 10
- Nevada 9
- Pennsylvania 9
- South Dakota 9
- Wisconsin 9
- Idaho 8
- Mississippi 8
- Alaska 7
- New Mexico 7
- Ohio 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2459997 | 2459997 | 2022-04-30 | Kimble | Texas | 48267 | 711 | 15 |
2358084 | 2358084 | 2022-03-30 | Webster | Nebraska | 31181 | 711 | 10 |
2358733 | 2358733 | 2022-03-30 | Vieques | Puerto Rico | 72147 | 711 | |
2355479 | 2355479 | 2022-03-29 | Vieques | Puerto Rico | 72147 | 711 | |
2351578 | 2351578 | 2022-03-28 | Webster | Nebraska | 31181 | 711 | 10 |
2352226 | 2352226 | 2022-03-28 | Vieques | Puerto Rico | 72147 | 711 | |
2348326 | 2348326 | 2022-03-27 | Webster | Nebraska | 31181 | 711 | 10 |
2348974 | 2348974 | 2022-03-27 | Vieques | Puerto Rico | 72147 | 711 | |
2345073 | 2345073 | 2022-03-26 | Webster | Nebraska | 31181 | 711 | 10 |
2345721 | 2345721 | 2022-03-26 | Vieques | Puerto Rico | 72147 | 711 | |
2341820 | 2341820 | 2022-03-25 | Webster | Nebraska | 31181 | 711 | 10 |
2338567 | 2338567 | 2022-03-24 | Webster | Nebraska | 31181 | 711 | 10 |
2335313 | 2335313 | 2022-03-23 | Webster | Nebraska | 31181 | 711 | 10 |
2332059 | 2332059 | 2022-03-22 | Webster | Nebraska | 31181 | 711 | 10 |
2325554 | 2325554 | 2022-03-20 | Webster | Nebraska | 31181 | 711 | 10 |
2322300 | 2322300 | 2022-03-19 | Webster | Nebraska | 31181 | 711 | 10 |
2195732 | 2195732 | 2022-02-08 | Emmons | North Dakota | 38029 | 711 | 17 |
2192180 | 2192180 | 2022-02-07 | Kimball | Nebraska | 31105 | 711 | 9 |
2180209 | 2180209 | 2022-02-03 | Kinney | Texas | 48271 | 711 | 10 |
2149165 | 2149165 | 2022-01-25 | Woodson | Kansas | 20207 | 711 | 11 |
2145506 | 2145506 | 2022-01-24 | Oneida | Idaho | 16071 | 711 | 10 |
2145913 | 2145913 | 2022-01-24 | Woodson | Kansas | 20207 | 711 | 11 |
2132859 | 2132859 | 2022-01-20 | Ness | Kansas | 20135 | 711 | 17 |
2134172 | 2134172 | 2022-01-20 | Cameron | Pennsylvania | 42023 | 711 | 16 |
2129606 | 2129606 | 2022-01-19 | Ness | Kansas | 20135 | 711 | 17 |
2124954 | 2124954 | 2022-01-17 | Reagan | Texas | 48383 | 711 | 11 |
2108695 | 2108695 | 2022-01-12 | Reagan | Texas | 48383 | 711 | 11 |
2101243 | 2101243 | 2022-01-10 | Hamilton | New York | 36041 | 711 | 4 |
2085974 | 2085974 | 2022-01-05 | Upton | Texas | 48461 | 711 | 15 |
2082579 | 2082579 | 2022-01-04 | Goliad | Texas | 48175 | 711 | 28 |
2063026 | 2063026 | 2021-12-29 | Coke | Texas | 48081 | 711 | 18 |
2029708 | 2029708 | 2021-12-19 | Union | New Mexico | 35059 | 711 | 12 |
2030879 | 2030879 | 2021-12-19 | Norton city | Virginia | 51720 | 711 | 19 |
2026457 | 2026457 | 2021-12-18 | Union | New Mexico | 35059 | 711 | 12 |
2027628 | 2027628 | 2021-12-18 | Norton city | Virginia | 51720 | 711 | 19 |
2023206 | 2023206 | 2021-12-17 | Union | New Mexico | 35059 | 711 | 12 |
2024377 | 2024377 | 2021-12-17 | Norton city | Virginia | 51720 | 711 | 19 |
2012244 | 2012244 | 2021-12-14 | Hardin | Illinois | 17069 | 711 | 16 |
2012917 | 2012917 | 2021-12-14 | Ontonagon | Michigan | 26131 | 711 | 25 |
2009666 | 2009666 | 2021-12-13 | Ontonagon | Michigan | 26131 | 711 | 25 |
2010379 | 2010379 | 2021-12-13 | Foster | North Dakota | 38031 | 711 | 19 |
2006841 | 2006841 | 2021-12-12 | Nuckolls | Nebraska | 31129 | 711 | 12 |
2007128 | 2007128 | 2021-12-12 | Foster | North Dakota | 38031 | 711 | 19 |
2003590 | 2003590 | 2021-12-11 | Nuckolls | Nebraska | 31129 | 711 | 12 |
2004189 | 2004189 | 2021-12-11 | Adjuntas | Puerto Rico | 72001 | 711 | |
2000340 | 2000340 | 2021-12-10 | Nuckolls | Nebraska | 31129 | 711 | 12 |
2000938 | 2000938 | 2021-12-10 | Adjuntas | Puerto Rico | 72001 | 711 | |
1997688 | 1997688 | 2021-12-09 | Adjuntas | Puerto Rico | 72001 | 711 | |
1993877 | 1993877 | 2021-12-08 | Lincoln | Nevada | 32017 | 711 | 5 |
1990437 | 1990437 | 2021-12-07 | Putnam | Missouri | 29171 | 711 | 19 |
1990626 | 1990626 | 2021-12-07 | Lincoln | Nevada | 32017 | 711 | 5 |
1987376 | 1987376 | 2021-12-06 | Lincoln | Nevada | 32017 | 711 | 5 |
1982865 | 1982865 | 2021-12-05 | Schley | Georgia | 13249 | 711 | 8 |
1984126 | 1984126 | 2021-12-05 | Lincoln | Nevada | 32017 | 711 | 5 |
1979615 | 1979615 | 2021-12-04 | Schley | Georgia | 13249 | 711 | 8 |
1980876 | 1980876 | 2021-12-04 | Lincoln | Nevada | 32017 | 711 | 5 |
1976365 | 1976365 | 2021-12-03 | Schley | Georgia | 13249 | 711 | 8 |
1977626 | 1977626 | 2021-12-03 | Lincoln | Nevada | 32017 | 711 | 5 |
1978215 | 1978215 | 2021-12-03 | Guayanilla | Puerto Rico | 72059 | 711 | |
1974376 | 1974376 | 2021-12-02 | Lincoln | Nevada | 32017 | 711 | 5 |
1971127 | 1971127 | 2021-12-01 | Lincoln | Nevada | 32017 | 711 | 5 |
1971399 | 1971399 | 2021-12-01 | Sargent | North Dakota | 38081 | 711 | 9 |
1971720 | 1971720 | 2021-12-01 | Hormigueros | Puerto Rico | 72067 | 711 | |
1967877 | 1967877 | 2021-11-30 | Lincoln | Nevada | 32017 | 711 | 5 |
1968470 | 1968470 | 2021-11-30 | Hormigueros | Puerto Rico | 72067 | 711 | |
1965219 | 1965219 | 2021-11-29 | Hormigueros | Puerto Rico | 72067 | 711 | |
1961967 | 1961967 | 2021-11-28 | Hormigueros | Puerto Rico | 72067 | 711 | |
1958716 | 1958716 | 2021-11-27 | Hormigueros | Puerto Rico | 72067 | 711 | |
1955465 | 1955465 | 2021-11-26 | Hormigueros | Puerto Rico | 72067 | 711 | |
1952815 | 1952815 | 2021-11-25 | Falls Church city | Virginia | 51610 | 711 | 14 |
1944707 | 1944707 | 2021-11-23 | Kittson | Minnesota | 27069 | 711 | 22 |
1944751 | 1944751 | 2021-11-23 | Unknown | Minnesota | 711 | 124 | |
1944992 | 1944992 | 2021-11-23 | Musselshell | Montana | 30065 | 711 | 22 |
1930932 | 1930932 | 2021-11-19 | Lincoln | Idaho | 16063 | 711 | 13 |
1932372 | 1932372 | 2021-11-19 | LaMoure | North Dakota | 38045 | 711 | 17 |
1927682 | 1927682 | 2021-11-18 | Lincoln | Idaho | 16063 | 711 | 13 |
1929121 | 1929121 | 2021-11-18 | LaMoure | North Dakota | 38045 | 711 | 17 |
1924432 | 1924432 | 2021-11-17 | Lincoln | Idaho | 16063 | 711 | 12 |
1925871 | 1925871 | 2021-11-17 | LaMoure | North Dakota | 38045 | 711 | 17 |
1923075 | 1923075 | 2021-11-16 | Deuel | South Dakota | 46039 | 711 | 11 |
1915099 | 1915099 | 2021-11-14 | Ballard | Kentucky | 21007 | 711 | 20 |
1911849 | 1911849 | 2021-11-13 | Ballard | Kentucky | 21007 | 711 | 20 |
1908600 | 1908600 | 2021-11-12 | Ballard | Kentucky | 21007 | 711 | 20 |
1910267 | 1910267 | 2021-11-12 | Concho | Texas | 48095 | 711 | 10 |
1905351 | 1905351 | 2021-11-11 | Ballard | Kentucky | 21007 | 711 | 20 |
1902101 | 1902101 | 2021-11-10 | Ballard | Kentucky | 21007 | 711 | 20 |
1896315 | 1896315 | 2021-11-08 | Johnson | Nebraska | 31097 | 711 | 10 |
1891619 | 1891619 | 2021-11-07 | Huerfano | Colorado | 8055 | 711 | 19 |
1888369 | 1888369 | 2021-11-06 | Huerfano | Colorado | 8055 | 711 | 19 |
1885119 | 1885119 | 2021-11-05 | Huerfano | Colorado | 8055 | 711 | 19 |
1873472 | 1873472 | 2021-11-01 | Chouteau | Montana | 30015 | 711 | 8 |
1873495 | 1873495 | 2021-11-01 | Mineral | Montana | 30061 | 711 | 13 |
1868695 | 1868695 | 2021-10-31 | Yukon-Koyukuk Census Area | Alaska | 2290 | 711 | 5 |
1865446 | 1865446 | 2021-10-30 | Yukon-Koyukuk Census Area | Alaska | 2290 | 711 | 5 |
1862197 | 1862197 | 2021-10-29 | Yukon-Koyukuk Census Area | Alaska | 2290 | 711 | 5 |
1858948 | 1858948 | 2021-10-28 | Yukon-Koyukuk Census Area | Alaska | 2290 | 711 | 5 |
1851125 | 1851125 | 2021-10-25 | Dunn | North Dakota | 38025 | 711 | 7 |
1839066 | 1839066 | 2021-10-21 | Cumberland | Virginia | 51049 | 711 | 17 |
1823798 | 1823798 | 2021-10-17 | Scott | Illinois | 17171 | 711 | 6 |
1820549 | 1820549 | 2021-10-16 | Scott | Illinois | 17171 | 711 | 6 |
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);