ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
168 rows where cases = 2700 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 20
- Florida 12
- New Mexico 11
- Texas 10
- Georgia 8
- Iowa 8
- Minnesota 8
- Kentucky 7
- Ohio 7
- Virginia 7
- Arkansas 6
- Mississippi 6
- Pennsylvania 6
- Indiana 5
- New York 5
- Illinois 4
- Alaska 3
- California 3
- Idaho 3
- North Carolina 3
- Puerto Rico 3
- Tennessee 3
- Alabama 2
- Oklahoma 2
- Utah 2
- West Virginia 2
- Wyoming 2
- Arizona 1
- Colorado 1
- Connecticut 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500711 | 2500711 | 2022-05-13 | Catahoula | Louisiana | 22025 | 2700 | 55 |
2449287 | 2449287 | 2022-04-27 | Colfax | New Mexico | 35007 | 2700 | 65 |
2446030 | 2446030 | 2022-04-26 | Colfax | New Mexico | 35007 | 2700 | 65 |
2442775 | 2442775 | 2022-04-25 | Colfax | New Mexico | 35007 | 2700 | 65 |
2439519 | 2439519 | 2022-04-24 | Colfax | New Mexico | 35007 | 2700 | 65 |
2436263 | 2436263 | 2022-04-23 | Colfax | New Mexico | 35007 | 2700 | 65 |
2433007 | 2433007 | 2022-04-22 | Colfax | New Mexico | 35007 | 2700 | 65 |
2351179 | 2351179 | 2022-03-28 | Koochiching | Minnesota | 27071 | 2700 | 37 |
2347926 | 2347926 | 2022-03-27 | Koochiching | Minnesota | 27071 | 2700 | 37 |
2344673 | 2344673 | 2022-03-26 | Koochiching | Minnesota | 27071 | 2700 | 37 |
2341420 | 2341420 | 2022-03-25 | Koochiching | Minnesota | 27071 | 2700 | 37 |
2332055 | 2332055 | 2022-03-22 | Unknown | Nebraska | 2700 | 438 | |
2322369 | 2322369 | 2022-03-19 | Los Alamos | New Mexico | 35028 | 2700 | 14 |
2319115 | 2319115 | 2022-03-18 | Los Alamos | New Mexico | 35028 | 2700 | 14 |
2314628 | 2314628 | 2022-03-17 | Teton | Idaho | 16081 | 2700 | 8 |
2315862 | 2315862 | 2022-03-17 | Los Alamos | New Mexico | 35028 | 2700 | 14 |
2312609 | 2312609 | 2022-03-16 | Los Alamos | New Mexico | 35028 | 2700 | 13 |
2213711 | 2213711 | 2022-02-14 | Long | Georgia | 13183 | 2700 | 31 |
2194548 | 2194548 | 2022-02-08 | Hancock | Iowa | 19081 | 2700 | 45 |
2191294 | 2191294 | 2022-02-07 | Hancock | Iowa | 19081 | 2700 | 45 |
2188041 | 2188041 | 2022-02-06 | Hancock | Iowa | 19081 | 2700 | 45 |
2184788 | 2184788 | 2022-02-05 | Hancock | Iowa | 19081 | 2700 | 45 |
2181536 | 2181536 | 2022-02-04 | Hancock | Iowa | 19081 | 2700 | 45 |
2178285 | 2178285 | 2022-02-03 | Hancock | Iowa | 19081 | 2700 | 45 |
2174511 | 2174511 | 2022-02-02 | Unknown | Connecticut | 2700 | 4 | |
2175032 | 2175032 | 2022-02-02 | Hancock | Iowa | 19081 | 2700 | 45 |
2145029 | 2145029 | 2022-01-24 | Bradley | Arkansas | 5011 | 2700 | 43 |
2138552 | 2138552 | 2022-01-22 | Lee | Arkansas | 5077 | 2700 | 54 |
2122348 | 2122348 | 2022-01-17 | Mono | California | 6051 | 2700 | 4 |
2114478 | 2114478 | 2022-01-14 | Harrison | Ohio | 39067 | 2700 | 61 |
2074890 | 2074890 | 2022-01-02 | Dallas | Missouri | 29059 | 2700 | 59 |
2071639 | 2071639 | 2022-01-01 | Dallas | Missouri | 29059 | 2700 | 59 |
2068388 | 2068388 | 2021-12-31 | Dallas | Missouri | 29059 | 2700 | 59 |
2065137 | 2065137 | 2021-12-30 | Dallas | Missouri | 29059 | 2700 | 59 |
2057311 | 2057311 | 2021-12-28 | Inyo | California | 6027 | 2700 | 48 |
2059780 | 2059780 | 2021-12-28 | Colorado | Texas | 48089 | 2700 | 56 |
2052214 | 2052214 | 2021-12-26 | Ste. Genevieve | Missouri | 29186 | 2700 | 34 |
2048964 | 2048964 | 2021-12-25 | Ste. Genevieve | Missouri | 29186 | 2700 | 34 |
2045714 | 2045714 | 2021-12-24 | Ste. Genevieve | Missouri | 29186 | 2700 | 34 |
2042464 | 2042464 | 2021-12-23 | Ste. Genevieve | Missouri | 29186 | 2700 | 34 |
2039837 | 2039837 | 2021-12-22 | Unknown | Oklahoma | 2700 | 2 | |
2005185 | 2005185 | 2021-12-12 | Kodiak Island Borough | Alaska | 2150 | 2700 | 10 |
2001934 | 2001934 | 2021-12-11 | Kodiak Island Borough | Alaska | 2150 | 2700 | 10 |
1998684 | 1998684 | 2021-12-10 | Kodiak Island Borough | Alaska | 2150 | 2700 | 10 |
1996050 | 1996050 | 2021-12-09 | Warren | Illinois | 17187 | 2700 | 72 |
1983910 | 1983910 | 2021-12-05 | Livingston | Missouri | 29117 | 2700 | 79 |
1985127 | 1985127 | 2021-12-05 | Llano | Texas | 48299 | 2700 | 79 |
1985307 | 1985307 | 2021-12-05 | Colonial Heights city | Virginia | 51570 | 2700 | 69 |
1982057 | 1982057 | 2021-12-04 | Colonial Heights city | Virginia | 51570 | 2700 | 69 |
1978807 | 1978807 | 2021-12-03 | Colonial Heights city | Virginia | 51570 | 2700 | 69 |
1943017 | 1943017 | 2021-11-22 | Windham | Vermont | 50025 | 2700 | 26 |
1915535 | 1915535 | 2021-11-14 | Holmes | Mississippi | 28051 | 2700 | 89 |
1912285 | 1912285 | 2021-11-13 | Holmes | Mississippi | 28051 | 2700 | 89 |
1909035 | 1909035 | 2021-11-12 | Holmes | Mississippi | 28051 | 2700 | 89 |
1892112 | 1892112 | 2021-11-07 | Perry | Indiana | 18123 | 2700 | 55 |
1888862 | 1888862 | 2021-11-06 | Perry | Indiana | 18123 | 2700 | 55 |
1885612 | 1885612 | 2021-11-05 | Perry | Indiana | 18123 | 2700 | 55 |
1865202 | 1865202 | 2021-10-29 | Barbour | West Virginia | 54001 | 2700 | 44 |
1853371 | 1853371 | 2021-10-26 | Breckinridge | Kentucky | 21027 | 2700 | 34 |
1836229 | 1836229 | 2021-10-21 | Clay | Arkansas | 5021 | 2700 | 68 |
1831521 | 1831521 | 2021-10-19 | Avery | North Carolina | 37011 | 2700 | 33 |
1796168 | 1796168 | 2021-10-08 | Juniata | Pennsylvania | 42067 | 2700 | 111 |
1791018 | 1791018 | 2021-10-07 | Banks | Georgia | 13011 | 2700 | 59 |
1781984 | 1781984 | 2021-10-04 | Spencer | Kentucky | 21215 | 2700 | 28 |
1766049 | 1766049 | 2021-09-29 | Calhoun | Mississippi | 28013 | 2700 | 41 |
1753155 | 1753155 | 2021-09-25 | Clinton | Missouri | 29049 | 2700 | 75 |
1725770 | 1725770 | 2021-09-17 | Drew | Arkansas | 5043 | 2700 | 53 |
1725196 | 1725196 | 2021-09-16 | Panola | Texas | 48365 | 2700 | 97 |
1719903 | 1719903 | 2021-09-15 | Orange | Indiana | 18117 | 2700 | 62 |
1718042 | 1718042 | 2021-09-14 | Wyandot | Ohio | 39175 | 2700 | 58 |
1705672 | 1705672 | 2021-09-10 | Lee | Texas | 48287 | 2700 | 45 |
1699996 | 1699996 | 2021-09-09 | Gilchrist | Florida | 12041 | 2700 | 44 |
1696747 | 1696747 | 2021-09-08 | Gilchrist | Florida | 12041 | 2700 | 44 |
1699227 | 1699227 | 2021-09-08 | Robertson | Texas | 48395 | 2700 | 52 |
1693499 | 1693499 | 2021-09-07 | Gilchrist | Florida | 12041 | 2700 | 44 |
1690250 | 1690250 | 2021-09-06 | Gilchrist | Florida | 12041 | 2700 | 44 |
1687000 | 1687000 | 2021-09-05 | Gilchrist | Florida | 12041 | 2700 | 44 |
1683750 | 1683750 | 2021-09-04 | Gilchrist | Florida | 12041 | 2700 | 44 |
1680499 | 1680499 | 2021-09-03 | Gilchrist | Florida | 12041 | 2700 | 44 |
1655781 | 1655781 | 2021-08-26 | Texas | Missouri | 29215 | 2700 | 32 |
1633294 | 1633294 | 2021-08-19 | Franklin | New York | 36033 | 2700 | 12 |
1602823 | 1602823 | 2021-08-10 | Douglas | Illinois | 17041 | 2700 | 42 |
1601370 | 1601370 | 2021-08-09 | Abbeville | South Carolina | 45001 | 2700 | 41 |
1562721 | 1562721 | 2021-07-28 | Karnes | Texas | 48255 | 2700 | 37 |
1523359 | 1523359 | 2021-07-16 | Dorado | Puerto Rico | 72051 | 2700 | |
1503045 | 1503045 | 2021-07-10 | Crawford | Missouri | 29055 | 2700 | 40 |
1491295 | 1491295 | 2021-07-06 | Kleberg | Texas | 48273 | 2700 | 94 |
1467887 | 1467887 | 2021-06-29 | Coshocton | Ohio | 39031 | 2700 | 60 |
1432209 | 1432209 | 2021-06-18 | Holmes | Ohio | 39075 | 2700 | 101 |
1423401 | 1423401 | 2021-06-15 | Pulaski | Virginia | 51155 | 2700 | 62 |
1401403 | 1401403 | 2021-06-09 | Peach | Georgia | 13225 | 2700 | 65 |
1403957 | 1403957 | 2021-06-09 | Wythe | Virginia | 51197 | 2700 | 81 |
1398431 | 1398431 | 2021-06-08 | Scott | Indiana | 18143 | 2700 | 57 |
1378676 | 1378676 | 2021-06-02 | Monroe | Georgia | 13207 | 2700 | 99 |
1361609 | 1361609 | 2021-05-27 | Uintah | Utah | 49047 | 2700 | 23 |
1355912 | 1355912 | 2021-05-26 | Franklin | Georgia | 13119 | 2700 | 51 |
1357034 | 1357034 | 2021-05-26 | Nodaway | Missouri | 29147 | 2700 | 25 |
1358363 | 1358363 | 2021-05-26 | Uintah | Utah | 49047 | 2700 | 23 |
1353788 | 1353788 | 2021-05-25 | Nodaway | Missouri | 29147 | 2700 | 25 |
1350542 | 1350542 | 2021-05-24 | Nodaway | Missouri | 29147 | 2700 | 25 |
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);