ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
365 rows where cases = 1403 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 27
- Iowa 22
- Kentucky 21
- Illinois 20
- Louisiana 16
- Missouri 16
- Georgia 15
- Texas 15
- North Carolina 13
- Alabama 12
- Kansas 11
- Oregon 11
- Arkansas 10
- South Carolina 9
- Virginia 9
- Indiana 8
- Minnesota 8
- Florida 7
- Michigan 7
- Mississippi 7
- Montana 7
- Pennsylvania 7
- Tennessee 7
- Colorado 6
- New York 6
- North Dakota 6
- Utah 6
- Washington 6
- West Virginia 6
- Idaho 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499412 | 2499412 | 2022-05-12 | San Juan | Washington | 53055 | 1403 | 2 |
2496154 | 2496154 | 2022-05-11 | San Juan | Washington | 53055 | 1403 | 2 |
2374838 | 2374838 | 2022-04-04 | Lake | Oregon | 41037 | 1403 | 26 |
2371586 | 2371586 | 2022-04-03 | Lake | Oregon | 41037 | 1403 | 26 |
2368333 | 2368333 | 2022-04-02 | Lake | Oregon | 41037 | 1403 | 26 |
2365080 | 2365080 | 2022-04-01 | Lake | Oregon | 41037 | 1403 | 26 |
2361827 | 2361827 | 2022-03-31 | Lake | Oregon | 41037 | 1403 | 26 |
2356141 | 2356141 | 2022-03-29 | Ferry | Washington | 53019 | 1403 | 29 |
2350447 | 2350447 | 2022-03-28 | Gallatin | Illinois | 17059 | 1403 | 17 |
2352888 | 2352888 | 2022-03-28 | Ferry | Washington | 53019 | 1403 | 29 |
2347194 | 2347194 | 2022-03-27 | Gallatin | Illinois | 17059 | 1403 | 17 |
2343941 | 2343941 | 2022-03-26 | Gallatin | Illinois | 17059 | 1403 | 17 |
2340688 | 2340688 | 2022-03-25 | Gallatin | Illinois | 17059 | 1403 | 17 |
2336898 | 2336898 | 2022-03-24 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1403 | 10 |
2337435 | 2337435 | 2022-03-24 | Gallatin | Illinois | 17059 | 1403 | 17 |
2333644 | 2333644 | 2022-03-23 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1403 | 10 |
2330390 | 2330390 | 2022-03-22 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1403 | 9 |
2327138 | 2327138 | 2022-03-21 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1403 | 9 |
2310161 | 2310161 | 2022-03-15 | Bailey | Texas | 48017 | 1403 | 38 |
2265519 | 2265519 | 2022-03-02 | Huerfano | Colorado | 8055 | 1403 | 31 |
2237513 | 2237513 | 2022-02-21 | Dade | Missouri | 29057 | 1403 | 38 |
2234262 | 2234262 | 2022-02-20 | Dade | Missouri | 29057 | 1403 | 38 |
2231011 | 2231011 | 2022-02-19 | Dade | Missouri | 29057 | 1403 | 38 |
2227760 | 2227760 | 2022-02-18 | Dade | Missouri | 29057 | 1403 | 38 |
2224509 | 2224509 | 2022-02-17 | Dade | Missouri | 29057 | 1403 | 38 |
2222739 | 2222739 | 2022-02-16 | Mathews | Virginia | 51115 | 1403 | 27 |
2219488 | 2219488 | 2022-02-15 | Mathews | Virginia | 51115 | 1403 | 27 |
2219634 | 2219634 | 2022-02-15 | Wirt | West Virginia | 54105 | 1403 | 21 |
2212341 | 2212341 | 2022-02-13 | Guanica | Puerto Rico | 72055 | 1403 | |
2156265 | 2156265 | 2022-01-27 | Shannon | Missouri | 29203 | 1403 | 32 |
2102252 | 2102252 | 2022-01-10 | Yoakum | Texas | 48501 | 1403 | 36 |
2097217 | 2097217 | 2022-01-09 | Nicholas | Kentucky | 21181 | 1403 | 29 |
2097292 | 2097292 | 2022-01-09 | St. Helena | Louisiana | 22091 | 1403 | 20 |
2093965 | 2093965 | 2022-01-08 | Nicholas | Kentucky | 21181 | 1403 | 29 |
2094040 | 2094040 | 2022-01-08 | St. Helena | Louisiana | 22091 | 1403 | 20 |
2090713 | 2090713 | 2022-01-07 | Nicholas | Kentucky | 21181 | 1403 | 29 |
2090788 | 2090788 | 2022-01-07 | St. Helena | Louisiana | 22091 | 1403 | 20 |
2087910 | 2087910 | 2022-01-06 | Hickory | Missouri | 29085 | 1403 | 45 |
2088865 | 2088865 | 2022-01-06 | Hutchinson | South Dakota | 46067 | 1403 | 30 |
2078281 | 2078281 | 2022-01-03 | Valley | Montana | 30105 | 1403 | 32 |
2074649 | 2074649 | 2022-01-02 | Lake | Michigan | 26085 | 1403 | 31 |
2071398 | 2071398 | 2022-01-01 | Lake | Michigan | 26085 | 1403 | 31 |
2068147 | 2068147 | 2021-12-31 | Lake | Michigan | 26085 | 1403 | 31 |
2064896 | 2064896 | 2021-12-30 | Lake | Michigan | 26085 | 1403 | 31 |
2061646 | 2061646 | 2021-12-29 | Lake | Michigan | 26085 | 1403 | 31 |
2058536 | 2058536 | 2021-12-28 | Choctaw | Mississippi | 28019 | 1403 | 27 |
2033518 | 2033518 | 2021-12-20 | Utuado | Puerto Rico | 72141 | 1403 | |
2027003 | 2027003 | 2021-12-18 | Quebradillas | Puerto Rico | 72115 | 1403 | |
2013552 | 2013552 | 2021-12-14 | Graham | North Carolina | 37075 | 1403 | 28 |
1989160 | 1989160 | 2021-12-07 | Yuma | Colorado | 8125 | 1403 | 18 |
1983264 | 1983264 | 2021-12-05 | Coffey | Kansas | 20031 | 1403 | 28 |
1980014 | 1980014 | 2021-12-04 | Coffey | Kansas | 20031 | 1403 | 28 |
1981866 | 1981866 | 2021-12-04 | La Salle | Texas | 48283 | 1403 | 40 |
1976764 | 1976764 | 2021-12-03 | Coffey | Kansas | 20031 | 1403 | 28 |
1965214 | 1965214 | 2021-11-29 | Guayama | Puerto Rico | 72057 | 1403 | |
1960234 | 1960234 | 2021-11-28 | Hamilton | Illinois | 17065 | 1403 | 26 |
1956983 | 1956983 | 2021-11-27 | Hamilton | Illinois | 17065 | 1403 | 26 |
1953732 | 1953732 | 2021-11-26 | Hamilton | Illinois | 17065 | 1403 | 26 |
1950481 | 1950481 | 2021-11-25 | Hamilton | Illinois | 17065 | 1403 | 26 |
1952299 | 1952299 | 2021-11-25 | McCormick | South Carolina | 45065 | 1403 | 30 |
1947230 | 1947230 | 2021-11-24 | Hamilton | Illinois | 17065 | 1403 | 26 |
1949048 | 1949048 | 2021-11-24 | McCormick | South Carolina | 45065 | 1403 | 30 |
1943505 | 1943505 | 2021-11-23 | Nevada | Arkansas | 5099 | 1403 | 40 |
1945797 | 1945797 | 2021-11-23 | McCormick | South Carolina | 45065 | 1403 | 30 |
1940255 | 1940255 | 2021-11-22 | Nevada | Arkansas | 5099 | 1403 | 40 |
1942546 | 1942546 | 2021-11-22 | McCormick | South Carolina | 45065 | 1403 | 30 |
1937005 | 1937005 | 2021-11-21 | Nevada | Arkansas | 5099 | 1403 | 40 |
1933492 | 1933492 | 2021-11-19 | Tyler | West Virginia | 54095 | 1403 | 24 |
1921458 | 1921458 | 2021-11-16 | Monroe | Iowa | 19135 | 1403 | 39 |
1918208 | 1918208 | 2021-11-15 | Monroe | Iowa | 19135 | 1403 | 39 |
1919832 | 1919832 | 2021-11-15 | Grant | South Dakota | 46051 | 1403 | 46 |
1914958 | 1914958 | 2021-11-14 | Monroe | Iowa | 19135 | 1403 | 39 |
1915608 | 1915608 | 2021-11-14 | Carroll | Missouri | 29033 | 1403 | 27 |
1911708 | 1911708 | 2021-11-13 | Monroe | Iowa | 19135 | 1403 | 39 |
1908459 | 1908459 | 2021-11-12 | Monroe | Iowa | 19135 | 1403 | 39 |
1905210 | 1905210 | 2021-11-11 | Monroe | Iowa | 19135 | 1403 | 39 |
1901960 | 1901960 | 2021-11-10 | Monroe | Iowa | 19135 | 1403 | 39 |
1903915 | 1903915 | 2021-11-10 | Red River | Texas | 48387 | 1403 | 53 |
1900665 | 1900665 | 2021-11-09 | Red River | Texas | 48387 | 1403 | 53 |
1892339 | 1892339 | 2021-11-07 | Thomas | Kansas | 20193 | 1403 | 22 |
1889089 | 1889089 | 2021-11-06 | Thomas | Kansas | 20193 | 1403 | 22 |
1885839 | 1885839 | 2021-11-05 | Thomas | Kansas | 20193 | 1403 | 22 |
1876022 | 1876022 | 2021-11-02 | Ellsworth | Kansas | 20053 | 1403 | 29 |
1872773 | 1872773 | 2021-11-01 | Ellsworth | Kansas | 20053 | 1403 | 29 |
1860016 | 1860016 | 2021-10-28 | Red River | Louisiana | 22081 | 1403 | 48 |
1849399 | 1849399 | 2021-10-25 | Park | Colorado | 8093 | 1403 | 8 |
1849000 | 1849000 | 2021-10-24 | Summers | West Virginia | 54089 | 1403 | 30 |
1831983 | 1831983 | 2021-10-19 | Lares | Puerto Rico | 72081 | 1403 | |
1828734 | 1828734 | 2021-10-18 | Lares | Puerto Rico | 72081 | 1403 | |
1825485 | 1825485 | 2021-10-17 | Lares | Puerto Rico | 72081 | 1403 | |
1822236 | 1822236 | 2021-10-16 | Lares | Puerto Rico | 72081 | 1403 | |
1817214 | 1817214 | 2021-10-15 | Valley | Idaho | 16085 | 1403 | 10 |
1818987 | 1818987 | 2021-10-15 | Lares | Puerto Rico | 72081 | 1403 | |
1813026 | 1813026 | 2021-10-13 | Addison | Vermont | 50001 | 1403 | 8 |
1807528 | 1807528 | 2021-10-12 | Marshall | Illinois | 17123 | 1403 | 23 |
1796223 | 1796223 | 2021-10-08 | Coamo | Puerto Rico | 72043 | 1403 | |
1791333 | 1791333 | 2021-10-07 | Brown | Indiana | 18013 | 1403 | 47 |
1792071 | 1792071 | 2021-10-07 | Kemper | Mississippi | 28069 | 1403 | 41 |
1792512 | 1792512 | 2021-10-07 | Schuyler | New York | 36097 | 1403 | 16 |
1792974 | 1792974 | 2021-10-07 | Coamo | Puerto Rico | 72043 | 1403 |
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);