ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
431 rows where cases = 942 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 36
- Georgia 35
- Nebraska 23
- Alabama 21
- Mississippi 21
- Louisiana 18
- Missouri 18
- South Dakota 18
- Arkansas 17
- Kansas 17
- Kentucky 15
- Michigan 14
- Virginia 14
- Minnesota 11
- Montana 11
- North Carolina 11
- Alaska 10
- Puerto Rico 9
- Iowa 8
- North Dakota 8
- Wisconsin 8
- Indiana 7
- Tennessee 7
- Colorado 6
- New Mexico 6
- Illinois 5
- West Virginia 5
- Wyoming 5
- California 4
- Florida 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469490 | 2469490 | 2022-05-03 | Edmunds | South Dakota | 46045 | 942 | 16 |
2466234 | 2466234 | 2022-05-02 | Edmunds | South Dakota | 46045 | 942 | 16 |
2462979 | 2462979 | 2022-05-01 | Edmunds | South Dakota | 46045 | 942 | 16 |
2459723 | 2459723 | 2022-04-30 | Edmunds | South Dakota | 46045 | 942 | 16 |
2456467 | 2456467 | 2022-04-29 | Edmunds | South Dakota | 46045 | 942 | 16 |
2453211 | 2453211 | 2022-04-28 | Edmunds | South Dakota | 46045 | 942 | 16 |
2449955 | 2449955 | 2022-04-27 | Edmunds | South Dakota | 46045 | 942 | 16 |
2246417 | 2246417 | 2022-02-24 | Pope | Illinois | 17151 | 942 | 7 |
2179475 | 2179475 | 2022-02-03 | LaMoure | North Dakota | 38045 | 942 | 19 |
2173757 | 2173757 | 2022-02-01 | Presidio | Texas | 48377 | 942 | 32 |
2148801 | 2148801 | 2022-01-25 | Hardin | Illinois | 17069 | 942 | 18 |
2143199 | 2143199 | 2022-01-23 | Holt | Missouri | 29087 | 942 | 25 |
2134573 | 2134573 | 2022-01-20 | Crockett | Texas | 48105 | 942 | 17 |
2089460 | 2089460 | 2022-01-06 | Skamania | Washington | 53059 | 942 | 9 |
2085932 | 2085932 | 2022-01-05 | Presidio | Texas | 48377 | 942 | 31 |
2082680 | 2082680 | 2022-01-04 | Presidio | Texas | 48377 | 942 | 30 |
2061728 | 2061728 | 2021-12-29 | Lincoln | Minnesota | 27081 | 942 | 5 |
2039113 | 2039113 | 2021-12-22 | Atchison | Missouri | 29005 | 942 | 18 |
2029543 | 2029543 | 2021-12-19 | Burt | Nebraska | 31021 | 942 | 13 |
2026292 | 2026292 | 2021-12-18 | Burt | Nebraska | 31021 | 942 | 13 |
2027004 | 2027004 | 2021-12-18 | Rincon | Puerto Rico | 72117 | 942 | |
2023041 | 2023041 | 2021-12-17 | Burt | Nebraska | 31021 | 942 | 13 |
2024110 | 2024110 | 2021-12-17 | Jim Hogg | Texas | 48247 | 942 | 20 |
2019069 | 2019069 | 2021-12-16 | Morris | Kansas | 20127 | 942 | 23 |
2020859 | 2020859 | 2021-12-16 | Jim Hogg | Texas | 48247 | 942 | 20 |
2015819 | 2015819 | 2021-12-15 | Morris | Kansas | 20127 | 942 | 23 |
2017608 | 2017608 | 2021-12-15 | Jim Hogg | Texas | 48247 | 942 | 20 |
2014358 | 2014358 | 2021-12-14 | Jim Hogg | Texas | 48247 | 942 | 20 |
2006103 | 2006103 | 2021-12-12 | Washington | Kansas | 20201 | 942 | 17 |
2002852 | 2002852 | 2021-12-11 | Washington | Kansas | 20201 | 942 | 17 |
1999602 | 1999602 | 2021-12-10 | Washington | Kansas | 20201 | 942 | 17 |
1997086 | 1997086 | 2021-12-09 | Morrill | Nebraska | 31123 | 942 | 16 |
1974320 | 1974320 | 2021-12-02 | Jefferson | Nebraska | 31095 | 942 | 3 |
1967034 | 1967034 | 2021-11-30 | Gray | Kansas | 20069 | 942 | 22 |
1967078 | 1967078 | 2021-11-30 | Republic | Kansas | 20157 | 942 | 14 |
1963782 | 1963782 | 2021-11-29 | Gray | Kansas | 20069 | 942 | 22 |
1963826 | 1963826 | 2021-11-29 | Republic | Kansas | 20157 | 942 | 14 |
1959668 | 1959668 | 2021-11-28 | Aleutians West Census Area | Alaska | 2016 | 942 | 1 |
1956417 | 1956417 | 2021-11-27 | Aleutians West Census Area | Alaska | 2016 | 942 | 1 |
1953166 | 1953166 | 2021-11-26 | Aleutians West Census Area | Alaska | 2016 | 942 | 1 |
1949915 | 1949915 | 2021-11-25 | Aleutians West Census Area | Alaska | 2016 | 942 | 1 |
1946664 | 1946664 | 2021-11-24 | Aleutians West Census Area | Alaska | 2016 | 942 | 1 |
1943413 | 1943413 | 2021-11-23 | Aleutians West Census Area | Alaska | 2016 | 942 | 1 |
1946526 | 1946526 | 2021-11-23 | Iron | Wisconsin | 55051 | 942 | 42 |
1932392 | 1932392 | 2021-11-19 | Sioux | North Dakota | 38085 | 942 | 18 |
1929594 | 1929594 | 2021-11-18 | Kingsbury | South Dakota | 46077 | 942 | 18 |
1919871 | 1919871 | 2021-11-15 | Walworth | South Dakota | 46129 | 942 | 18 |
1916136 | 1916136 | 2021-11-14 | Ransom | North Dakota | 38073 | 942 | 20 |
1912886 | 1912886 | 2021-11-13 | Ransom | North Dakota | 38073 | 942 | 20 |
1906852 | 1906852 | 2021-11-11 | McCook | South Dakota | 46087 | 942 | 25 |
1901335 | 1901335 | 2021-11-10 | Trinity | California | 6105 | 942 | 17 |
1903603 | 1903603 | 2021-11-10 | McCook | South Dakota | 46087 | 942 | 25 |
1899590 | 1899590 | 2021-11-09 | Richardson | Nebraska | 31147 | 942 | 24 |
1901078 | 1901078 | 2021-11-09 | Crook | Wyoming | 56011 | 942 | 20 |
1887631 | 1887631 | 2021-11-05 | McCulloch | Texas | 48307 | 942 | 38 |
1882978 | 1882978 | 2021-11-04 | Norman | Minnesota | 27107 | 942 | 9 |
1883193 | 1883193 | 2021-11-04 | Shelby | Missouri | 29205 | 942 | 9 |
1877891 | 1877891 | 2021-11-02 | Mitchell | Texas | 48335 | 942 | 40 |
1861597 | 1861597 | 2021-10-28 | Jack | Texas | 48237 | 942 | 20 |
1855156 | 1855156 | 2021-10-26 | Newton | Texas | 48351 | 942 | 51 |
1855363 | 1855363 | 2021-10-26 | Middlesex | Virginia | 51119 | 942 | 30 |
1847168 | 1847168 | 2021-10-24 | Oscoda | Michigan | 26135 | 942 | 34 |
1843918 | 1843918 | 2021-10-23 | Oscoda | Michigan | 26135 | 942 | 34 |
1840668 | 1840668 | 2021-10-22 | Oscoda | Michigan | 26135 | 942 | 34 |
1827808 | 1827808 | 2021-10-18 | Jefferson | Mississippi | 28063 | 942 | 34 |
1824559 | 1824559 | 2021-10-17 | Jefferson | Mississippi | 28063 | 942 | 34 |
1825122 | 1825122 | 2021-10-17 | Bottineau | North Dakota | 38009 | 942 | 21 |
1821310 | 1821310 | 2021-10-16 | Jefferson | Mississippi | 28063 | 942 | 34 |
1821873 | 1821873 | 2021-10-16 | Bottineau | North Dakota | 38009 | 942 | 21 |
1818061 | 1818061 | 2021-10-15 | Jefferson | Mississippi | 28063 | 942 | 34 |
1814812 | 1814812 | 2021-10-14 | Jefferson | Mississippi | 28063 | 942 | 34 |
1815030 | 1815030 | 2021-10-14 | Toole | Montana | 30101 | 942 | 12 |
1811481 | 1811481 | 2021-10-13 | Lac qui Parle | Minnesota | 27073 | 942 | 24 |
1807412 | 1807412 | 2021-10-12 | Wheeler | Georgia | 13309 | 942 | 32 |
1808232 | 1808232 | 2021-10-12 | Lac qui Parle | Minnesota | 27073 | 942 | 24 |
1804161 | 1804161 | 2021-10-11 | Wheeler | Georgia | 13309 | 942 | 32 |
1800912 | 1800912 | 2021-10-10 | Wheeler | Georgia | 13309 | 942 | 32 |
1797663 | 1797663 | 2021-10-09 | Wheeler | Georgia | 13309 | 942 | 32 |
1794414 | 1794414 | 2021-10-08 | Wheeler | Georgia | 13309 | 942 | 32 |
1789612 | 1789612 | 2021-10-06 | Grant | Oregon | 41023 | 942 | 10 |
1782287 | 1782287 | 2021-10-04 | Wilkin | Minnesota | 27167 | 942 | 14 |
1778869 | 1778869 | 2021-10-03 | Alcona | Michigan | 26001 | 942 | 39 |
1775619 | 1775619 | 2021-10-02 | Alcona | Michigan | 26001 | 942 | 39 |
1772369 | 1772369 | 2021-10-01 | Alcona | Michigan | 26001 | 942 | 39 |
1736908 | 1736908 | 2021-09-20 | Clark | Missouri | 29045 | 942 | 12 |
1732227 | 1732227 | 2021-09-19 | Southeast Fairbanks Census Area | Alaska | 2240 | 942 | 7 |
1728977 | 1728977 | 2021-09-18 | Southeast Fairbanks Census Area | Alaska | 2240 | 942 | 7 |
1725727 | 1725727 | 2021-09-17 | Southeast Fairbanks Census Area | Alaska | 2240 | 942 | 7 |
1722473 | 1722473 | 2021-09-16 | Northwest Arctic Borough | Alaska | 2188 | 942 | 3 |
1722899 | 1722899 | 2021-09-16 | Randolph | Georgia | 13243 | 942 | 37 |
1724908 | 1724908 | 2021-09-16 | Spink | South Dakota | 46115 | 942 | 26 |
1719348 | 1719348 | 2021-09-15 | Mariposa | California | 6043 | 942 | 12 |
1719419 | 1719419 | 2021-09-15 | Lake | Colorado | 8065 | 942 | 1 |
1697920 | 1697920 | 2021-09-08 | Carter | Missouri | 29035 | 942 | 12 |
1694675 | 1694675 | 2021-09-07 | Chariton | Missouri | 29041 | 942 | 8 |
1696170 | 1696170 | 2021-09-07 | Northampton | Virginia | 51131 | 942 | 38 |
1690337 | 1690337 | 2021-09-06 | Crawford | Georgia | 13079 | 942 | 25 |
1687087 | 1687087 | 2021-09-05 | Crawford | Georgia | 13079 | 942 | 25 |
1683837 | 1683837 | 2021-09-04 | Crawford | Georgia | 13079 | 942 | 25 |
1680586 | 1680586 | 2021-09-03 | Crawford | Georgia | 13079 | 942 | 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);