ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
484 rows where cases = 853 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 60
- Georgia 48
- Iowa 31
- Illinois 20
- Montana 20
- Kansas 18
- Nebraska 18
- Arkansas 17
- Virginia 17
- Missouri 15
- Kentucky 14
- Puerto Rico 14
- Wisconsin 13
- Louisiana 12
- Minnesota 11
- Idaho 10
- Ohio 10
- Tennessee 10
- Mississippi 9
- West Virginia 9
- South Dakota 8
- Vermont 8
- Alaska 7
- Michigan 7
- New Mexico 7
- Oklahoma 7
- Washington 7
- Alabama 6
- Florida 6
- Indiana 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2421487 | 2421487 | 2022-04-19 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 853 | 1 |
2418231 | 2418231 | 2022-04-18 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 853 | 1 |
2414975 | 2414975 | 2022-04-17 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 853 | 1 |
2411719 | 2411719 | 2022-04-16 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 853 | 1 |
2408463 | 2408463 | 2022-04-15 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 853 | 1 |
2405207 | 2405207 | 2022-04-14 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 853 | 1 |
2401952 | 2401952 | 2022-04-13 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 853 | 1 |
2400033 | 2400033 | 2022-04-12 | Traverse | Minnesota | 27155 | 853 | 10 |
2396777 | 2396777 | 2022-04-11 | Traverse | Minnesota | 27155 | 853 | 10 |
2223276 | 2223276 | 2022-02-17 | Phillips | Colorado | 8095 | 853 | 17 |
2216147 | 2216147 | 2022-02-14 | Grand Isle | Vermont | 50013 | 853 | 4 |
2156317 | 2156317 | 2022-01-27 | Musselshell | Montana | 30065 | 853 | 26 |
2152006 | 2152006 | 2022-01-26 | Lincoln | Idaho | 16063 | 853 | 14 |
2145474 | 2145474 | 2022-01-24 | Bear Lake | Idaho | 16007 | 853 | 15 |
2132832 | 2132832 | 2022-01-20 | Haskell | Kansas | 20081 | 853 | 10 |
2129579 | 2129579 | 2022-01-19 | Haskell | Kansas | 20081 | 853 | 10 |
2131383 | 2131383 | 2022-01-19 | Hudspeth | Texas | 48229 | 853 | 16 |
2122772 | 2122772 | 2022-01-17 | Hardin | Illinois | 17069 | 853 | 18 |
2119520 | 2119520 | 2022-01-16 | Hardin | Illinois | 17069 | 853 | 18 |
2116268 | 2116268 | 2022-01-15 | Hardin | Illinois | 17069 | 853 | 18 |
2113017 | 2113017 | 2022-01-14 | Hardin | Illinois | 17069 | 853 | 18 |
2104168 | 2104168 | 2022-01-11 | Holt | Missouri | 29087 | 853 | 25 |
2096665 | 2096665 | 2022-01-09 | Warren | Georgia | 13301 | 853 | 26 |
2093413 | 2093413 | 2022-01-08 | Warren | Georgia | 13301 | 853 | 26 |
2090161 | 2090161 | 2022-01-07 | Warren | Georgia | 13301 | 853 | 26 |
2086910 | 2086910 | 2022-01-06 | Warren | Georgia | 13301 | 853 | 26 |
2083658 | 2083658 | 2022-01-05 | Warren | Georgia | 13301 | 853 | 26 |
2079103 | 2079103 | 2022-01-03 | Gregory | South Dakota | 46053 | 853 | 33 |
2062693 | 2062693 | 2021-12-29 | Adjuntas | Puerto Rico | 72001 | 853 | |
2053575 | 2053575 | 2021-12-26 | Emporia city | Virginia | 51595 | 853 | 46 |
2050325 | 2050325 | 2021-12-25 | Emporia city | Virginia | 51595 | 853 | 46 |
2047075 | 2047075 | 2021-12-24 | Emporia city | Virginia | 51595 | 853 | 46 |
2038299 | 2038299 | 2021-12-22 | Scott | Illinois | 17171 | 853 | 7 |
2040002 | 2040002 | 2021-12-22 | Penuelas | Puerto Rico | 72111 | 853 | |
2036114 | 2036114 | 2021-12-21 | Sheridan | Nebraska | 31161 | 853 | 23 |
2037277 | 2037277 | 2021-12-21 | Essex | Vermont | 50009 | 853 | 2 |
2028450 | 2028450 | 2021-12-19 | Lewis | Idaho | 16061 | 853 | 23 |
2025199 | 2025199 | 2021-12-18 | Lewis | Idaho | 16061 | 853 | 23 |
2021948 | 2021948 | 2021-12-17 | Lewis | Idaho | 16061 | 853 | 23 |
1987298 | 1987298 | 2021-12-06 | Dixon | Nebraska | 31051 | 853 | 11 |
1973012 | 1973012 | 2021-12-02 | Calhoun | Georgia | 13037 | 853 | 21 |
1975692 | 1975692 | 2021-12-02 | Skamania | Washington | 53059 | 853 | 7 |
1941744 | 1941744 | 2021-11-22 | Phillips | Montana | 30071 | 853 | 28 |
1938494 | 1938494 | 2021-11-21 | Phillips | Montana | 30071 | 853 | 28 |
1939636 | 1939636 | 2021-11-21 | Mills | Texas | 48333 | 853 | 28 |
1935244 | 1935244 | 2021-11-20 | Phillips | Montana | 30071 | 853 | 28 |
1936386 | 1936386 | 2021-11-20 | Mills | Texas | 48333 | 853 | 28 |
1931994 | 1931994 | 2021-11-19 | Phillips | Montana | 30071 | 853 | 28 |
1933136 | 1933136 | 2021-11-19 | Mills | Texas | 48333 | 853 | 28 |
1928461 | 1928461 | 2021-11-18 | Lincoln | Minnesota | 27081 | 853 | 5 |
1929885 | 1929885 | 2021-11-18 | Mills | Texas | 48333 | 853 | 28 |
1924532 | 1924532 | 2021-11-17 | Stark | Illinois | 17175 | 853 | 29 |
1926635 | 1926635 | 2021-11-17 | Mills | Texas | 48333 | 853 | 28 |
1921003 | 1921003 | 2021-11-16 | Calhoun | Georgia | 13037 | 853 | 21 |
1921283 | 1921283 | 2021-11-16 | Stark | Illinois | 17175 | 853 | 29 |
1923385 | 1923385 | 2021-11-16 | Mills | Texas | 48333 | 853 | 28 |
1920136 | 1920136 | 2021-11-15 | Mills | Texas | 48333 | 853 | 28 |
1916886 | 1916886 | 2021-11-14 | Mills | Texas | 48333 | 853 | 28 |
1913636 | 1913636 | 2021-11-13 | Mills | Texas | 48333 | 853 | 28 |
1907742 | 1907742 | 2021-11-12 | Lafayette | Arkansas | 5073 | 853 | 28 |
1910386 | 1910386 | 2021-11-12 | Mills | Texas | 48333 | 853 | 28 |
1904493 | 1904493 | 2021-11-11 | Lafayette | Arkansas | 5073 | 853 | 28 |
1907137 | 1907137 | 2021-11-11 | Mills | Texas | 48333 | 853 | 28 |
1901243 | 1901243 | 2021-11-10 | Lafayette | Arkansas | 5073 | 853 | 28 |
1897993 | 1897993 | 2021-11-09 | Lafayette | Arkansas | 5073 | 853 | 28 |
1900809 | 1900809 | 2021-11-09 | Emporia city | Virginia | 51595 | 853 | 45 |
1894416 | 1894416 | 2021-11-07 | Ferry | Washington | 53019 | 853 | 15 |
1891166 | 1891166 | 2021-11-06 | Ferry | Washington | 53019 | 853 | 15 |
1887916 | 1887916 | 2021-11-05 | Ferry | Washington | 53019 | 853 | 15 |
1879701 | 1879701 | 2021-11-03 | Grant | Minnesota | 27051 | 853 | 9 |
1881499 | 1881499 | 2021-11-03 | Wirt | West Virginia | 54105 | 853 | 13 |
1869010 | 1869010 | 2021-10-31 | Calhoun | Georgia | 13037 | 853 | 21 |
1871124 | 1871124 | 2021-10-31 | Tripp | South Dakota | 46123 | 853 | 18 |
1865761 | 1865761 | 2021-10-30 | Calhoun | Georgia | 13037 | 853 | 21 |
1867875 | 1867875 | 2021-10-30 | Tripp | South Dakota | 46123 | 853 | 18 |
1862512 | 1862512 | 2021-10-29 | Calhoun | Georgia | 13037 | 853 | 21 |
1864626 | 1864626 | 2021-10-29 | Tripp | South Dakota | 46123 | 853 | 18 |
1856367 | 1856367 | 2021-10-27 | Ohio | Indiana | 18115 | 853 | 13 |
1853287 | 1853287 | 2021-10-26 | Gray | Kansas | 20069 | 853 | 16 |
1850038 | 1850038 | 2021-10-25 | Gray | Kansas | 20069 | 853 | 16 |
1832009 | 1832009 | 2021-10-19 | Santa Isabel | Puerto Rico | 72133 | 853 | |
1832841 | 1832841 | 2021-10-19 | Crook | Wyoming | 56011 | 853 | 18 |
1828409 | 1828409 | 2021-10-18 | Sioux | North Dakota | 38085 | 853 | 15 |
1828760 | 1828760 | 2021-10-18 | Santa Isabel | Puerto Rico | 72133 | 853 | |
1829540 | 1829540 | 2021-10-18 | Iron | Wisconsin | 55051 | 853 | 42 |
1829595 | 1829595 | 2021-10-18 | Hot Springs | Wyoming | 56017 | 853 | 8 |
1825511 | 1825511 | 2021-10-17 | Santa Isabel | Puerto Rico | 72133 | 853 | |
1826291 | 1826291 | 2021-10-17 | Iron | Wisconsin | 55051 | 853 | 42 |
1807107 | 1807107 | 2021-10-12 | Trinity | California | 6105 | 853 | 11 |
1808693 | 1808693 | 2021-10-12 | Guadalupe | New Mexico | 35019 | 853 | 15 |
1793881 | 1793881 | 2021-10-08 | Choctaw | Alabama | 1023 | 853 | 27 |
1790632 | 1790632 | 2021-10-07 | Choctaw | Alabama | 1023 | 853 | 27 |
1737109 | 1737109 | 2021-09-20 | Keith | Nebraska | 31101 | 853 | 10 |
1715144 | 1715144 | 2021-09-13 | Kingsbury | South Dakota | 46077 | 853 | 18 |
1704920 | 1704920 | 2021-09-10 | Dickey | North Dakota | 38021 | 853 | 33 |
1702454 | 1702454 | 2021-09-09 | Newton | Texas | 48351 | 853 | 43 |
1699205 | 1699205 | 2021-09-08 | Newton | Texas | 48351 | 853 | 43 |
1699541 | 1699541 | 2021-09-08 | Pocahontas | West Virginia | 54075 | 853 | 15 |
1694012 | 1694012 | 2021-09-07 | Lucas | Iowa | 19117 | 853 | 23 |
1690763 | 1690763 | 2021-09-06 | Lucas | Iowa | 19117 | 853 | 23 |
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);