ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where cases = 7151 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Illinois 8
- Kansas 7
- Arkansas 6
- Washington 5
- Kentucky 4
- Alabama 3
- Alaska 3
- Minnesota 3
- Georgia 2
- Indiana 2
- Nebraska 2
- Ohio 2
- Pennsylvania 2
- Texas 2
- Virginia 2
- California 1
- Louisiana 1
- Mississippi 1
- Missouri 1
- Montana 1
- New Jersey 1
- North Carolina 1
- Oklahoma 1
- Puerto Rico 1
- South Carolina 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496944 | 2496944 | 2022-05-12 | Fayette | Illinois | 17051 | 7151 | 104 |
2497240 | 2497240 | 2022-05-12 | Ellis | Kansas | 20051 | 7151 | 84 |
2493071 | 2493071 | 2022-05-11 | Clarke | Alabama | 1025 | 7151 | 101 |
2493982 | 2493982 | 2022-05-11 | Ellis | Kansas | 20051 | 7151 | 84 |
2490724 | 2490724 | 2022-05-10 | Ellis | Kansas | 20051 | 7151 | 84 |
2487467 | 2487467 | 2022-05-09 | Ellis | Kansas | 20051 | 7151 | 84 |
2484209 | 2484209 | 2022-05-08 | Ellis | Kansas | 20051 | 7151 | 84 |
2480951 | 2480951 | 2022-05-07 | Ellis | Kansas | 20051 | 7151 | 84 |
2477693 | 2477693 | 2022-05-06 | Ellis | Kansas | 20051 | 7151 | 84 |
2259227 | 2259227 | 2022-02-28 | Lumpkin | Georgia | 13187 | 7151 | 126 |
2243221 | 2243221 | 2022-02-23 | Greene | Indiana | 18055 | 7151 | 135 |
2191597 | 2191597 | 2022-02-07 | East Feliciana | Louisiana | 22037 | 7151 | 159 |
2168407 | 2168407 | 2022-01-31 | Daviess | Indiana | 18027 | 7151 | 134 |
2157039 | 2157039 | 2022-01-27 | Humacao | Puerto Rico | 72069 | 7151 | |
2096305 | 2096305 | 2022-01-09 | Union | Arkansas | 5139 | 7151 | 153 |
2093053 | 2093053 | 2022-01-08 | Union | Arkansas | 5139 | 7151 | 153 |
2083233 | 2083233 | 2022-01-05 | Boone | Arkansas | 5009 | 7151 | 142 |
2040401 | 2040401 | 2021-12-22 | Medina | Texas | 48325 | 7151 | 171 |
2033442 | 2033442 | 2021-12-20 | Wayne | Pennsylvania | 42127 | 7151 | 133 |
2016608 | 2016608 | 2021-12-15 | Scotts Bluff | Nebraska | 31157 | 7151 | 102 |
2013357 | 2013357 | 2021-12-14 | Scotts Bluff | Nebraska | 31157 | 7151 | 102 |
1983765 | 1983765 | 2021-12-05 | Winona | Minnesota | 27169 | 7151 | 58 |
1980515 | 1980515 | 2021-12-04 | Winona | Minnesota | 27169 | 7151 | 58 |
1977265 | 1977265 | 2021-12-03 | Winona | Minnesota | 27169 | 7151 | 58 |
1900814 | 1900814 | 2021-11-09 | Fauquier | Virginia | 51061 | 7151 | 86 |
1877163 | 1877163 | 2021-11-02 | Ashland | Ohio | 39005 | 7151 | 141 |
1873832 | 1873832 | 2021-11-01 | Richmond | North Carolina | 37153 | 7151 | 140 |
1865413 | 1865413 | 2021-10-30 | Tallapoosa | Alabama | 1123 | 7151 | 199 |
1853950 | 1853950 | 2021-10-26 | Scott | Missouri | 29201 | 7151 | 113 |
1849348 | 1849348 | 2021-10-25 | Tuolumne | California | 6109 | 7151 | 117 |
1846919 | 1846919 | 2021-10-24 | Knox | Kentucky | 21121 | 7151 | 53 |
1843669 | 1843669 | 2021-10-23 | Knox | Kentucky | 21121 | 7151 | 53 |
1840419 | 1840419 | 2021-10-22 | Knox | Kentucky | 21121 | 7151 | 53 |
1737655 | 1737655 | 2021-09-20 | Armstrong | Pennsylvania | 42005 | 7151 | 157 |
1632037 | 1632037 | 2021-08-19 | Boone | Illinois | 17007 | 7151 | 93 |
1611735 | 1611735 | 2021-08-12 | Rockingham | Virginia | 51165 | 7151 | 114 |
1583808 | 1583808 | 2021-08-04 | Pulaski | Kentucky | 21199 | 7151 | 128 |
1491597 | 1491597 | 2021-07-06 | Chelan | Washington | 53007 | 7151 | 72 |
1488350 | 1488350 | 2021-07-05 | Chelan | Washington | 53007 | 7151 | 72 |
1485103 | 1485103 | 2021-07-04 | Chelan | Washington | 53007 | 7151 | 72 |
1481857 | 1481857 | 2021-07-03 | Chelan | Washington | 53007 | 7151 | 72 |
1478610 | 1478610 | 2021-07-02 | Chelan | Washington | 53007 | 7151 | 72 |
1397784 | 1397784 | 2021-06-08 | Crawford | Arkansas | 5033 | 7151 | 119 |
1394537 | 1394537 | 2021-06-07 | Crawford | Arkansas | 5033 | 7151 | 119 |
1391292 | 1391292 | 2021-06-06 | Crawford | Arkansas | 5033 | 7151 | 119 |
1278242 | 1278242 | 2021-05-02 | Whiteside | Illinois | 17195 | 7151 | 208 |
1264208 | 1264208 | 2021-04-27 | Tooele | Utah | 49045 | 7151 | 41 |
1254889 | 1254889 | 2021-04-25 | Fairbanks North Star Borough | Alaska | 2090 | 7151 | 36 |
1251642 | 1251642 | 2021-04-24 | Fairbanks North Star Borough | Alaska | 2090 | 7151 | 36 |
1248395 | 1248395 | 2021-04-23 | Fairbanks North Star Borough | Alaska | 2090 | 7151 | 36 |
1235396 | 1235396 | 2021-04-19 | Walker | Alabama | 1127 | 7151 | 276 |
1195719 | 1195719 | 2021-04-06 | Tipton | Tennessee | 47167 | 7151 | 104 |
1094252 | 1094252 | 2021-03-06 | Hunterdon | New Jersey | 34019 | 7151 | 164 |
981062 | 981062 | 2021-01-30 | Pottawatomie | Oklahoma | 40125 | 7151 | 55 |
961832 | 961832 | 2021-01-24 | Oconee | South Carolina | 45073 | 7151 | 85 |
948525 | 948525 | 2021-01-20 | Pickaway | Ohio | 39129 | 7151 | 50 |
938283 | 938283 | 2021-01-17 | Cascade | Montana | 30013 | 7151 | 122 |
914567 | 914567 | 2021-01-10 | DeKalb | Illinois | 17037 | 7151 | 87 |
911322 | 911322 | 2021-01-09 | DeKalb | Illinois | 17037 | 7151 | 87 |
908077 | 908077 | 2021-01-08 | DeKalb | Illinois | 17037 | 7151 | 85 |
897189 | 897189 | 2021-01-04 | Gregg | Texas | 48183 | 7151 | 173 |
758668 | 758668 | 2020-11-23 | Muscogee | Georgia | 13215 | 7151 | 191 |
684212 | 684212 | 2020-10-31 | McHenry | Illinois | 17111 | 7151 | 126 |
680969 | 680969 | 2020-10-30 | McHenry | Illinois | 17111 | 7151 | 126 |
577963 | 577963 | 2020-09-28 | Hinds | Mississippi | 28049 | 7151 | 160 |
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);