ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
376 rows where cases = 1302 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 36
- Texas 27
- Virginia 25
- Kentucky 19
- Georgia 18
- Missouri 18
- Kansas 17
- Mississippi 17
- Illinois 16
- Alabama 13
- North Dakota 11
- Michigan 10
- North Carolina 9
- South Dakota 9
- Oregon 8
- Puerto Rico 8
- South Carolina 8
- Tennessee 8
- Arkansas 7
- Louisiana 7
- Minnesota 7
- Nebraska 7
- Utah 7
- Colorado 6
- Florida 6
- Idaho 5
- Indiana 5
- Oklahoma 5
- Pennsylvania 5
- Wisconsin 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2463510 | 2463510 | 2022-05-01 | Norton city | Virginia | 51720 | 1302 | 22 |
2460254 | 2460254 | 2022-04-30 | Norton city | Virginia | 51720 | 1302 | 22 |
2456998 | 2456998 | 2022-04-29 | Norton city | Virginia | 51720 | 1302 | 22 |
2453742 | 2453742 | 2022-04-28 | Norton city | Virginia | 51720 | 1302 | 22 |
2427463 | 2427463 | 2022-04-20 | McCulloch | Texas | 48307 | 1302 | 47 |
2424207 | 2424207 | 2022-04-19 | McCulloch | Texas | 48307 | 1302 | 47 |
2361608 | 2361608 | 2022-03-31 | McHenry | North Dakota | 38049 | 1302 | 31 |
2358354 | 2358354 | 2022-03-30 | McHenry | North Dakota | 38049 | 1302 | 31 |
2355100 | 2355100 | 2022-03-29 | McHenry | North Dakota | 38049 | 1302 | 31 |
2351847 | 2351847 | 2022-03-28 | McHenry | North Dakota | 38049 | 1302 | 31 |
2352834 | 2352834 | 2022-03-28 | Norton city | Virginia | 51720 | 1302 | 22 |
2348595 | 2348595 | 2022-03-27 | McHenry | North Dakota | 38049 | 1302 | 31 |
2349582 | 2349582 | 2022-03-27 | Norton city | Virginia | 51720 | 1302 | 22 |
2345342 | 2345342 | 2022-03-26 | McHenry | North Dakota | 38049 | 1302 | 31 |
2346329 | 2346329 | 2022-03-26 | Norton city | Virginia | 51720 | 1302 | 22 |
2342089 | 2342089 | 2022-03-25 | McHenry | North Dakota | 38049 | 1302 | 31 |
2343076 | 2343076 | 2022-03-25 | Norton city | Virginia | 51720 | 1302 | 22 |
2333315 | 2333315 | 2022-03-22 | Norton city | Virginia | 51720 | 1302 | 22 |
2330062 | 2330062 | 2022-03-21 | Norton city | Virginia | 51720 | 1302 | 22 |
2326810 | 2326810 | 2022-03-20 | Norton city | Virginia | 51720 | 1302 | 22 |
2323557 | 2323557 | 2022-03-19 | Norton city | Virginia | 51720 | 1302 | 22 |
2320303 | 2320303 | 2022-03-18 | Norton city | Virginia | 51720 | 1302 | 22 |
2317049 | 2317049 | 2022-03-17 | Norton city | Virginia | 51720 | 1302 | 22 |
2261246 | 2261246 | 2022-02-28 | Kingsbury | South Dakota | 46077 | 1302 | 20 |
2248268 | 2248268 | 2022-02-24 | Walworth | South Dakota | 46129 | 1302 | 24 |
2201912 | 2201912 | 2022-02-10 | Dawes | Nebraska | 31045 | 1302 | 21 |
2198658 | 2198658 | 2022-02-09 | Dawes | Nebraska | 31045 | 1302 | 21 |
2194686 | 2194686 | 2022-02-08 | Republic | Kansas | 20157 | 1302 | 14 |
2195404 | 2195404 | 2022-02-08 | Dawes | Nebraska | 31045 | 1302 | 21 |
2191432 | 2191432 | 2022-02-07 | Republic | Kansas | 20157 | 1302 | 14 |
2187835 | 2187835 | 2022-02-06 | Gallatin | Illinois | 17059 | 1302 | 13 |
2184582 | 2184582 | 2022-02-05 | Gallatin | Illinois | 17059 | 1302 | 13 |
2181330 | 2181330 | 2022-02-04 | Gallatin | Illinois | 17059 | 1302 | 13 |
2171912 | 2171912 | 2022-02-01 | Phillips | Kansas | 20147 | 1302 | 28 |
2168659 | 2168659 | 2022-01-31 | Phillips | Kansas | 20147 | 1302 | 28 |
2170072 | 2170072 | 2022-01-31 | Maunabo | Puerto Rico | 72095 | 1302 | |
2166818 | 2166818 | 2022-01-30 | Maunabo | Puerto Rico | 72095 | 1302 | |
2159450 | 2159450 | 2022-01-28 | Dade | Missouri | 29057 | 1302 | 38 |
2147434 | 2147434 | 2022-01-24 | Spink | South Dakota | 46115 | 1302 | 32 |
2147548 | 2147548 | 2022-01-24 | Bailey | Texas | 48017 | 1302 | 31 |
2147921 | 2147921 | 2022-01-24 | Mathews | Virginia | 51115 | 1302 | 24 |
2144130 | 2144130 | 2022-01-23 | Brule | South Dakota | 46015 | 1302 | 18 |
2140875 | 2140875 | 2022-01-22 | Brule | South Dakota | 46015 | 1302 | 18 |
2137619 | 2137619 | 2022-01-21 | Brule | South Dakota | 46015 | 1302 | 18 |
2105733 | 2105733 | 2022-01-11 | Calhoun | West Virginia | 54013 | 1302 | 9 |
2091988 | 2091988 | 2022-01-07 | Hormigueros | Puerto Rico | 72067 | 1302 | |
2089365 | 2089365 | 2022-01-06 | Lancaster | Virginia | 51103 | 1302 | 24 |
2056917 | 2056917 | 2021-12-27 | Williamsburg city | Virginia | 51830 | 1302 | 13 |
2053615 | 2053615 | 2021-12-26 | Manassas Park city | Virginia | 51685 | 1302 | 15 |
2050365 | 2050365 | 2021-12-25 | Manassas Park city | Virginia | 51685 | 1302 | 15 |
2047115 | 2047115 | 2021-12-24 | Manassas Park city | Virginia | 51685 | 1302 | 15 |
2030241 | 2030241 | 2021-12-19 | Luquillo | Puerto Rico | 72089 | 1302 | |
2019649 | 2019649 | 2021-12-16 | Hickory | Missouri | 29085 | 1302 | 44 |
2008659 | 2008659 | 2021-12-13 | San Miguel | Colorado | 8113 | 1302 | 5 |
2009962 | 2009962 | 2021-12-13 | Sullivan | Missouri | 29211 | 1302 | 17 |
2006711 | 2006711 | 2021-12-12 | Sullivan | Missouri | 29211 | 1302 | 17 |
1992626 | 1992626 | 2021-12-08 | Taylor | Georgia | 13269 | 1302 | 39 |
1991494 | 1991494 | 2021-12-07 | Blanco | Texas | 48031 | 1302 | 28 |
1987284 | 1987284 | 2021-12-06 | Butler | Nebraska | 31023 | 1302 | 12 |
1972634 | 1972634 | 2021-12-02 | Greene | Alabama | 1063 | 1302 | 45 |
1969384 | 1969384 | 2021-12-01 | Greene | Alabama | 1063 | 1302 | 45 |
1966134 | 1966134 | 2021-11-30 | Greene | Alabama | 1063 | 1302 | 45 |
1968784 | 1968784 | 2021-11-30 | Dallam | Texas | 48111 | 1302 | 29 |
1962882 | 1962882 | 2021-11-29 | Greene | Alabama | 1063 | 1302 | 45 |
1959631 | 1959631 | 2021-11-28 | Greene | Alabama | 1063 | 1302 | 45 |
1956380 | 1956380 | 2021-11-27 | Greene | Alabama | 1063 | 1302 | 45 |
1953129 | 1953129 | 2021-11-26 | Greene | Alabama | 1063 | 1302 | 45 |
1949878 | 1949878 | 2021-11-25 | Greene | Alabama | 1063 | 1302 | 45 |
1905318 | 1905318 | 2021-11-11 | Pratt | Kansas | 20151 | 1302 | 27 |
1902068 | 1902068 | 2021-11-10 | Pratt | Kansas | 20151 | 1302 | 27 |
1892788 | 1892788 | 2021-11-07 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1889538 | 1889538 | 2021-11-06 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1886288 | 1886288 | 2021-11-05 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1883039 | 1883039 | 2021-11-04 | Humphreys | Mississippi | 28053 | 1302 | 39 |
1853606 | 1853606 | 2021-10-26 | Baraga | Michigan | 26013 | 1302 | 47 |
1850357 | 1850357 | 2021-10-25 | Baraga | Michigan | 26013 | 1302 | 47 |
1848578 | 1848578 | 2021-10-24 | Hamilton | Texas | 48193 | 1302 | 29 |
1845328 | 1845328 | 2021-10-23 | Hamilton | Texas | 48193 | 1302 | 29 |
1842078 | 1842078 | 2021-10-22 | Hamilton | Texas | 48193 | 1302 | 29 |
1837019 | 1837019 | 2021-10-21 | Cloud | Kansas | 20029 | 1302 | 27 |
1833770 | 1833770 | 2021-10-20 | Cloud | Kansas | 20029 | 1302 | 27 |
1832250 | 1832250 | 2021-10-19 | Blanco | Texas | 48031 | 1302 | 28 |
1828839 | 1828839 | 2021-10-18 | Custer | South Dakota | 46033 | 1302 | 15 |
1829001 | 1829001 | 2021-10-18 | Blanco | Texas | 48031 | 1302 | 28 |
1814679 | 1814679 | 2021-10-14 | Presque Isle | Michigan | 26141 | 1302 | 36 |
1810176 | 1810176 | 2021-10-13 | Sumter | Alabama | 1119 | 1302 | 38 |
1811431 | 1811431 | 2021-10-13 | Presque Isle | Michigan | 26141 | 1302 | 36 |
1809392 | 1809392 | 2021-10-12 | Turner | South Dakota | 46125 | 1302 | 60 |
1786942 | 1786942 | 2021-10-05 | Red River | Texas | 48387 | 1302 | 47 |
1778618 | 1778618 | 2021-10-03 | Thomas | Kansas | 20193 | 1302 | 21 |
1775368 | 1775368 | 2021-10-02 | Thomas | Kansas | 20193 | 1302 | 21 |
1772118 | 1772118 | 2021-10-01 | Thomas | Kansas | 20193 | 1302 | 21 |
1762194 | 1762194 | 2021-09-28 | Clarke | Iowa | 19039 | 1302 | 26 |
1758946 | 1758946 | 2021-09-27 | Clarke | Iowa | 19039 | 1302 | 26 |
1755698 | 1755698 | 2021-09-26 | Clarke | Iowa | 19039 | 1302 | 26 |
1752450 | 1752450 | 2021-09-25 | Clarke | Iowa | 19039 | 1302 | 26 |
1749201 | 1749201 | 2021-09-24 | Clarke | Iowa | 19039 | 1302 | 26 |
1745951 | 1745951 | 2021-09-23 | Clarke | Iowa | 19039 | 1302 | 26 |
1742702 | 1742702 | 2021-09-22 | Clarke | Iowa | 19039 | 1302 | 26 |
1723903 | 1723903 | 2021-09-16 | Carroll | Missouri | 29033 | 1302 | 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);