ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 8306 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Iowa 7
- Georgia 5
- Kentucky 5
- Texas 5
- North Carolina 4
- South Carolina 4
- New York 3
- Tennessee 3
- Kansas 2
- Michigan 2
- Ohio 2
- West Virginia 2
- Wyoming 2
- Florida 1
- Maryland 1
- New Jersey 1
- North Dakota 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2365615 | 2365615 | 2022-04-01 | Matagorda | Texas | 48321 | 8306 | 175 |
2311279 | 2311279 | 2022-03-16 | Pickens | Georgia | 13227 | 8306 | 160 |
2202086 | 2202086 | 2022-02-10 | Greene | New York | 36039 | 8306 | 116 |
2189655 | 2189655 | 2022-02-06 | Marion | South Carolina | 45067 | 8306 | 153 |
2186402 | 2186402 | 2022-02-05 | Marion | South Carolina | 45067 | 8306 | 153 |
2183150 | 2183150 | 2022-02-04 | Marion | South Carolina | 45067 | 8306 | 153 |
2149025 | 2149025 | 2022-01-25 | Marshall | Iowa | 19127 | 8306 | 96 |
2145773 | 2145773 | 2022-01-24 | Marshall | Iowa | 19127 | 8306 | 96 |
2142518 | 2142518 | 2022-01-23 | Marshall | Iowa | 19127 | 8306 | 96 |
2139263 | 2139263 | 2022-01-22 | Marshall | Iowa | 19127 | 8306 | 96 |
2136007 | 2136007 | 2022-01-21 | Marshall | Iowa | 19127 | 8306 | 96 |
2132755 | 2132755 | 2022-01-20 | Marshall | Iowa | 19127 | 8306 | 96 |
2129502 | 2129502 | 2022-01-19 | Marshall | Iowa | 19127 | 8306 | 96 |
2081139 | 2081139 | 2022-01-04 | Hillsdale | Michigan | 26059 | 8306 | 173 |
2077887 | 2077887 | 2022-01-03 | Hillsdale | Michigan | 26059 | 8306 | 173 |
2065484 | 2065484 | 2021-12-30 | Montgomery | New York | 36057 | 8306 | 176 |
2016894 | 2016894 | 2021-12-15 | Morton | North Dakota | 38059 | 8306 | 127 |
1971297 | 1971297 | 2021-12-01 | Granville | North Carolina | 37077 | 8306 | 106 |
1949773 | 1949773 | 2021-11-24 | Grant | Wisconsin | 55043 | 8306 | 119 |
1937851 | 1937851 | 2021-11-21 | Barren | Kentucky | 21009 | 8306 | 157 |
1934601 | 1934601 | 2021-11-20 | Barren | Kentucky | 21009 | 8306 | 157 |
1931350 | 1931350 | 2021-11-19 | Barren | Kentucky | 21009 | 8306 | 157 |
1881470 | 1881470 | 2021-11-03 | Marion | West Virginia | 54049 | 8306 | 106 |
1856696 | 1856696 | 2021-10-27 | Nelson | Kentucky | 21179 | 8306 | 87 |
1851009 | 1851009 | 2021-10-25 | Wayne | New York | 36117 | 8306 | 85 |
1721670 | 1721670 | 2021-09-15 | Bedford | Tennessee | 47003 | 8306 | 139 |
1596241 | 1596241 | 2021-08-08 | Walker | Georgia | 13295 | 8306 | 92 |
1592992 | 1592992 | 2021-08-07 | Walker | Georgia | 13295 | 8306 | 92 |
1589743 | 1589743 | 2021-08-06 | Walker | Georgia | 13295 | 8306 | 92 |
1585565 | 1585565 | 2021-08-04 | Val Verde | Texas | 48465 | 8306 | 233 |
1582315 | 1582315 | 2021-08-03 | Val Verde | Texas | 48465 | 8306 | 233 |
1579066 | 1579066 | 2021-08-02 | Val Verde | Texas | 48465 | 8306 | 233 |
1552213 | 1552213 | 2021-07-25 | Sampson | North Carolina | 37163 | 8306 | 115 |
1548966 | 1548966 | 2021-07-24 | Sampson | North Carolina | 37163 | 8306 | 115 |
1545719 | 1545719 | 2021-07-23 | Sampson | North Carolina | 37163 | 8306 | 115 |
1520992 | 1520992 | 2021-07-15 | Natrona | Wyoming | 56025 | 8306 | 140 |
1517744 | 1517744 | 2021-07-14 | Natrona | Wyoming | 56025 | 8306 | 140 |
1498011 | 1498011 | 2021-07-08 | Hanover | Virginia | 51085 | 8306 | 167 |
1260492 | 1260492 | 2021-04-26 | Darlington | South Carolina | 45031 | 8306 | 172 |
1160488 | 1160488 | 2021-03-26 | Cabell | West Virginia | 54011 | 8306 | 174 |
1152965 | 1152965 | 2021-03-24 | Columbiana | Ohio | 39029 | 8306 | 218 |
1133938 | 1133938 | 2021-03-18 | Anderson | Tennessee | 47001 | 8306 | 160 |
1086934 | 1086934 | 2021-03-04 | Reno | Kansas | 20155 | 8306 | 126 |
1083688 | 1083688 | 2021-03-03 | Reno | Kansas | 20155 | 8306 | 126 |
1028612 | 1028612 | 2021-02-14 | Madison | Kentucky | 21151 | 8306 | 77 |
1004175 | 1004175 | 2021-02-06 | Robertson | Tennessee | 47147 | 8306 | 106 |
877807 | 877807 | 2020-12-29 | Parker | Texas | 48367 | 8306 | 91 |
821933 | 821933 | 2020-12-12 | Licking | Ohio | 39089 | 8306 | 96 |
790955 | 790955 | 2020-12-03 | Clay | Florida | 12019 | 8306 | 154 |
521936 | 521936 | 2020-09-11 | Hall | Georgia | 13139 | 8306 | 136 |
465072 | 465072 | 2020-08-24 | Mercer | New Jersey | 34021 | 8306 | 624 |
304049 | 304049 | 2020-07-05 | Baltimore | Maryland | 24005 | 8306 | 481 |
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);