ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
94 rows where cases = 4966 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- California 7
- Georgia 7
- Illinois 7
- Indiana 7
- Iowa 7
- Oklahoma 7
- Texas 5
- North Carolina 4
- Alaska 3
- Florida 3
- Kentucky 3
- Michigan 3
- New York 3
- Puerto Rico 3
- Wisconsin 3
- Colorado 2
- Louisiana 2
- Mississippi 2
- Ohio 2
- Pennsylvania 2
- West Virginia 2
- Alabama 1
- Arkansas 1
- Maryland 1
- Missouri 1
- Montana 1
- Nebraska 1
- New Mexico 1
- South Dakota 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442571 | 2442571 | 2022-04-25 | Big Horn | Montana | 30003 | 4966 | 94 |
2385187 | 2385187 | 2022-04-07 | Scurry | Texas | 48415 | 4966 | 103 |
2332643 | 2332643 | 2022-03-22 | Cabo Rojo | Puerto Rico | 72023 | 4966 | |
2329390 | 2329390 | 2022-03-21 | Cabo Rojo | Puerto Rico | 72023 | 4966 | |
2326138 | 2326138 | 2022-03-20 | Cabo Rojo | Puerto Rico | 72023 | 4966 | |
2308834 | 2308834 | 2022-03-15 | Osceola | Michigan | 26133 | 4966 | 79 |
2305583 | 2305583 | 2022-03-14 | Osceola | Michigan | 26133 | 4966 | 79 |
2236663 | 2236663 | 2022-02-21 | Pike | Illinois | 17149 | 4966 | 67 |
2233412 | 2233412 | 2022-02-20 | Pike | Illinois | 17149 | 4966 | 67 |
2230161 | 2230161 | 2022-02-19 | Pike | Illinois | 17149 | 4966 | 67 |
2226910 | 2226910 | 2022-02-18 | Pike | Illinois | 17149 | 4966 | 67 |
2219884 | 2219884 | 2022-02-16 | Logan | Arkansas | 5083 | 4966 | 63 |
2203348 | 2203348 | 2022-02-10 | McDowell | West Virginia | 54047 | 4966 | 60 |
2195942 | 2195942 | 2022-02-08 | Woodward | Oklahoma | 40153 | 4966 | 61 |
2192688 | 2192688 | 2022-02-07 | Woodward | Oklahoma | 40153 | 4966 | 61 |
2189434 | 2189434 | 2022-02-06 | Woodward | Oklahoma | 40153 | 4966 | 61 |
2186181 | 2186181 | 2022-02-05 | Woodward | Oklahoma | 40153 | 4966 | 61 |
2182929 | 2182929 | 2022-02-04 | Woodward | Oklahoma | 40153 | 4966 | 61 |
2179677 | 2179677 | 2022-02-03 | Woodward | Oklahoma | 40153 | 4966 | 61 |
2176426 | 2176426 | 2022-02-02 | Woodward | Oklahoma | 40153 | 4966 | 61 |
2171623 | 2171623 | 2022-02-01 | Richland | Illinois | 17159 | 4966 | 79 |
2149014 | 2149014 | 2022-01-25 | Jones | Iowa | 19105 | 4966 | 68 |
2145762 | 2145762 | 2022-01-24 | Jones | Iowa | 19105 | 4966 | 68 |
2142507 | 2142507 | 2022-01-23 | Jones | Iowa | 19105 | 4966 | 68 |
2142763 | 2142763 | 2022-01-23 | Russell | Kentucky | 21207 | 4966 | 68 |
2139252 | 2139252 | 2022-01-22 | Jones | Iowa | 19105 | 4966 | 68 |
2139508 | 2139508 | 2022-01-22 | Russell | Kentucky | 21207 | 4966 | 68 |
2135996 | 2135996 | 2022-01-21 | Jones | Iowa | 19105 | 4966 | 68 |
2136252 | 2136252 | 2022-01-21 | Russell | Kentucky | 21207 | 4966 | 68 |
2132744 | 2132744 | 2022-01-20 | Jones | Iowa | 19105 | 4966 | 68 |
2129491 | 2129491 | 2022-01-19 | Jones | Iowa | 19105 | 4966 | 68 |
2106075 | 2106075 | 2022-01-12 | Glenn | California | 6021 | 4966 | 55 |
2084273 | 2084273 | 2022-01-05 | Morehouse | Louisiana | 22067 | 4966 | 119 |
2041380 | 2041380 | 2021-12-23 | Stephens | Georgia | 13257 | 4966 | 124 |
2018841 | 2018841 | 2021-12-16 | Greene | Indiana | 18055 | 4966 | 108 |
1995899 | 1995899 | 2021-12-09 | White | Georgia | 13311 | 4966 | 133 |
1992648 | 1992648 | 2021-12-08 | White | Georgia | 13311 | 4966 | 132 |
1974294 | 1974294 | 2021-12-02 | Dakota | Nebraska | 31043 | 4966 | 82 |
1960318 | 1960318 | 2021-11-28 | Daviess | Indiana | 18027 | 4966 | 118 |
1957067 | 1957067 | 2021-11-27 | Daviess | Indiana | 18027 | 4966 | 118 |
1953816 | 1953816 | 2021-11-26 | Daviess | Indiana | 18027 | 4966 | 118 |
1950565 | 1950565 | 2021-11-25 | Daviess | Indiana | 18027 | 4966 | 118 |
1947314 | 1947314 | 2021-11-24 | Daviess | Indiana | 18027 | 4966 | 118 |
1927376 | 1927376 | 2021-11-18 | Logan | Colorado | 8075 | 4966 | 89 |
1898150 | 1898150 | 2021-11-09 | Summit | Colorado | 8117 | 4966 | 11 |
1832905 | 1832905 | 2021-10-20 | Marion | Alabama | 1093 | 4966 | 126 |
1829498 | 1829498 | 2021-10-18 | Preston | West Virginia | 54077 | 4966 | 79 |
1824969 | 1824969 | 2021-10-17 | Columbia | New York | 36021 | 4966 | 111 |
1754952 | 1754952 | 2021-09-26 | Bethel Census Area | Alaska | 2050 | 4966 | 25 |
1751704 | 1751704 | 2021-09-25 | Bethel Census Area | Alaska | 2050 | 4966 | 25 |
1748455 | 1748455 | 2021-09-24 | Bethel Census Area | Alaska | 2050 | 4966 | 25 |
1743440 | 1743440 | 2021-09-22 | Lawrence | Missouri | 29109 | 4966 | 102 |
1724263 | 1724263 | 2021-09-16 | Montgomery | New York | 36057 | 4966 | 133 |
1701642 | 1701642 | 2021-09-09 | Scotland | North Carolina | 37165 | 4966 | 97 |
1656870 | 1656870 | 2021-08-26 | Erath | Texas | 48143 | 4966 | 73 |
1516457 | 1516457 | 2021-07-14 | Hoke | North Carolina | 37093 | 4966 | 56 |
1485503 | 1485503 | 2021-07-05 | Nevada | California | 6057 | 4966 | 75 |
1482257 | 1482257 | 2021-07-04 | Nevada | California | 6057 | 4966 | 75 |
1479010 | 1479010 | 2021-07-03 | Nevada | California | 6057 | 4966 | 75 |
1475764 | 1475764 | 2021-07-02 | Nevada | California | 6057 | 4966 | 75 |
1445094 | 1445094 | 2021-06-22 | Watauga | North Carolina | 37189 | 4966 | 33 |
1411165 | 1411165 | 2021-06-12 | Tift | Georgia | 13277 | 4966 | 130 |
1407920 | 1407920 | 2021-06-11 | Tift | Georgia | 13277 | 4966 | 130 |
1404674 | 1404674 | 2021-06-10 | Tift | Georgia | 13277 | 4966 | 130 |
1391704 | 1391704 | 2021-06-06 | Ware | Georgia | 13299 | 4966 | 177 |
1371614 | 1371614 | 2021-05-30 | Douglas | Wisconsin | 55031 | 4966 | 58 |
1368368 | 1368368 | 2021-05-29 | Douglas | Wisconsin | 55031 | 4966 | 58 |
1365122 | 1365122 | 2021-05-28 | Douglas | Wisconsin | 55031 | 4966 | 58 |
1292361 | 1292361 | 2021-05-06 | Otero | New Mexico | 35035 | 4966 | 75 |
1273835 | 1273835 | 2021-04-30 | Medina | Texas | 48325 | 4966 | 103 |
1217911 | 1217911 | 2021-04-13 | Athens | Ohio | 39009 | 4966 | 54 |
1204704 | 1204704 | 2021-04-09 | Cattaraugus | New York | 36009 | 4966 | 79 |
1110949 | 1110949 | 2021-03-11 | Armstrong | Pennsylvania | 42005 | 4966 | 116 |
1084782 | 1084782 | 2021-03-03 | Belmont | Ohio | 39013 | 4966 | 59 |
1038486 | 1038486 | 2021-02-17 | Cecil | Maryland | 24015 | 4966 | 115 |
1022990 | 1022990 | 2021-02-12 | Granville | North Carolina | 37077 | 4966 | 74 |
1015318 | 1015318 | 2021-02-10 | Noble | Indiana | 18113 | 4966 | 77 |
994303 | 994303 | 2021-02-03 | Brown | South Dakota | 46013 | 4966 | 80 |
950932 | 950932 | 2021-01-21 | Lapeer | Michigan | 26087 | 4966 | 118 |
952286 | 952286 | 2021-01-21 | Bowie | Texas | 48037 | 4966 | 144 |
941358 | 941358 | 2021-01-18 | Lafayette | Mississippi | 28071 | 4966 | 92 |
860209 | 860209 | 2020-12-24 | Forrest | Mississippi | 28035 | 4966 | 94 |
852501 | 852501 | 2020-12-22 | Napa | California | 6055 | 4966 | 25 |
814512 | 814512 | 2020-12-10 | Terrebonne | Louisiana | 22109 | 4966 | 141 |
726369 | 726369 | 2020-11-13 | Macon | Illinois | 17115 | 4966 | 88 |
718847 | 718847 | 2020-11-10 | Wichita | Texas | 48485 | 4966 | 66 |
567131 | 567131 | 2020-09-25 | Clay | Florida | 12019 | 4966 | 98 |
569675 | 569675 | 2020-09-25 | Davis | Utah | 49011 | 4966 | 28 |
524450 | 524450 | 2020-09-11 | Henrico | Virginia | 51087 | 4966 | 195 |
399017 | 399017 | 2020-08-04 | Monterey | California | 6053 | 4966 | 34 |
370186 | 370186 | 2020-07-26 | Brevard | Florida | 12009 | 4966 | 64 |
186725 | 186725 | 2020-05-28 | Bucks | Pennsylvania | 42017 | 4966 | 486 |
167000 | 167000 | 2020-05-22 | Will | Illinois | 17197 | 4966 | 255 |
163654 | 163654 | 2020-05-21 | Palm Beach | Florida | 12099 | 4966 | 308 |
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);