ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 7562 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Iowa 7
- Ohio 5
- Kentucky 4
- Pennsylvania 4
- California 3
- Wisconsin 3
- Georgia 2
- Kansas 2
- Mississippi 2
- Texas 2
- Alabama 1
- Arkansas 1
- Colorado 1
- Idaho 1
- Indiana 1
- Louisiana 1
- Maryland 1
- Minnesota 1
- Missouri 1
- Montana 1
- New Hampshire 1
- New York 1
- North Carolina 1
- Oklahoma 1
- Oregon 1
- South Carolina 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2399486 | 2399486 | 2022-04-12 | Marion | Iowa | 19125 | 7562 | 122 |
2396230 | 2396230 | 2022-04-11 | Marion | Iowa | 19125 | 7562 | 122 |
2392975 | 2392975 | 2022-04-10 | Marion | Iowa | 19125 | 7562 | 122 |
2389719 | 2389719 | 2022-04-09 | Marion | Iowa | 19125 | 7562 | 122 |
2386463 | 2386463 | 2022-04-08 | Marion | Iowa | 19125 | 7562 | 122 |
2383209 | 2383209 | 2022-04-07 | Marion | Iowa | 19125 | 7562 | 122 |
2379954 | 2379954 | 2022-04-06 | Marion | Iowa | 19125 | 7562 | 122 |
2378078 | 2378078 | 2022-04-05 | Columbia | Oregon | 41009 | 7562 | 92 |
2258783 | 2258783 | 2022-02-28 | Lawrence | Alabama | 1079 | 7562 | 150 |
2251847 | 2251847 | 2022-02-25 | Upshur | Texas | 48459 | 7562 | 176 |
2239152 | 2239152 | 2022-02-21 | Clark | Wisconsin | 55019 | 7562 | 115 |
2189326 | 2189326 | 2022-02-06 | Morrow | Ohio | 39117 | 7562 | 88 |
2176283 | 2176283 | 2022-02-02 | Fayette | Ohio | 39047 | 7562 | 99 |
2170595 | 2170595 | 2022-01-31 | Uintah | Utah | 49047 | 7562 | 57 |
2147697 | 2147697 | 2022-01-24 | Matagorda | Texas | 48321 | 7562 | 168 |
2117948 | 2117948 | 2022-01-15 | Perry | Pennsylvania | 42099 | 7562 | 163 |
2065708 | 2065708 | 2021-12-30 | Highland | Ohio | 39071 | 7562 | 130 |
2039705 | 2039705 | 2021-12-22 | Guernsey | Ohio | 39059 | 7562 | 93 |
1990343 | 1990343 | 2021-12-07 | Washington | Mississippi | 28151 | 7562 | 169 |
1930305 | 1930305 | 2021-11-18 | Shawano | Wisconsin | 55115 | 7562 | 92 |
1884049 | 1884049 | 2021-11-04 | Newberry | South Carolina | 45071 | 7562 | 146 |
1826786 | 1826786 | 2021-10-18 | Colquitt | Georgia | 13071 | 7562 | 175 |
1807136 | 1807136 | 2021-10-12 | Garfield | Colorado | 8045 | 7562 | 60 |
1753205 | 1753205 | 2021-09-25 | Newton | Missouri | 29145 | 7562 | 117 |
1747056 | 1747056 | 2021-09-23 | Carteret | North Carolina | 37031 | 7562 | 58 |
1700999 | 1700999 | 2021-09-09 | Crow Wing | Minnesota | 27035 | 7562 | 101 |
1618689 | 1618689 | 2021-08-15 | Yuba | California | 6115 | 7562 | 51 |
1615441 | 1615441 | 2021-08-14 | Yuba | California | 6115 | 7562 | 51 |
1612192 | 1612192 | 2021-08-13 | Yuba | California | 6115 | 7562 | 51 |
1606040 | 1606040 | 2021-08-11 | Madison | Idaho | 16065 | 7562 | 28 |
1497312 | 1497312 | 2021-07-08 | Crawford | Pennsylvania | 42039 | 7562 | 156 |
1460386 | 1460386 | 2021-06-27 | Laurel | Kentucky | 21125 | 7562 | 81 |
1457141 | 1457141 | 2021-06-26 | Laurel | Kentucky | 21125 | 7562 | 81 |
1453896 | 1453896 | 2021-06-25 | Laurel | Kentucky | 21125 | 7562 | 81 |
1455446 | 1455446 | 2021-06-25 | Unknown | Tennessee | 7562 | 89 | |
1450650 | 1450650 | 2021-06-24 | Laurel | Kentucky | 21125 | 7562 | 81 |
1407546 | 1407546 | 2021-06-11 | Lonoke | Arkansas | 5085 | 7562 | 123 |
1361008 | 1361008 | 2021-05-27 | Lawrence | Pennsylvania | 42073 | 7562 | 211 |
1349701 | 1349701 | 2021-05-24 | Grant | Indiana | 18053 | 7562 | 181 |
1330390 | 1330390 | 2021-05-18 | Butler | Kansas | 20015 | 7562 | 87 |
1327143 | 1327143 | 2021-05-17 | Butler | Kansas | 20015 | 7562 | 87 |
1317727 | 1317727 | 2021-05-14 | Wicomico | Maryland | 24045 | 7562 | 153 |
1303429 | 1303429 | 2021-05-09 | Chippewa | Wisconsin | 55017 | 7562 | 96 |
1240011 | 1240011 | 2021-04-20 | Forrest | Mississippi | 28035 | 7562 | 149 |
1123521 | 1123521 | 2021-03-15 | Chautauqua | New York | 36013 | 7562 | 129 |
1094238 | 1094238 | 2021-03-06 | Merrimack | New Hampshire | 33013 | 7562 | 107 |
1065413 | 1065413 | 2021-02-25 | Garfield | Oklahoma | 40047 | 7562 | 76 |
950815 | 950815 | 2021-01-21 | St. Landry | Louisiana | 22097 | 7562 | 220 |
808475 | 808475 | 2020-12-08 | Flathead | Montana | 30029 | 7562 | 44 |
745606 | 745606 | 2020-11-19 | Clarke | Georgia | 13059 | 7562 | 52 |
601319 | 601319 | 2020-10-05 | Lucas | Ohio | 39095 | 7562 | 369 |
459082 | 459082 | 2020-08-22 | Bucks | Pennsylvania | 42017 | 7562 | 584 |
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);