ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where cases = 5875 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Tennessee 9
- Kentucky 8
- Louisiana 6
- South Carolina 6
- Georgia 4
- New York 4
- South Dakota 4
- Kansas 3
- New Mexico 3
- Texas 3
- Indiana 2
- Ohio 2
- Pennsylvania 2
- California 1
- Florida 1
- Illinois 1
- Iowa 1
- Missouri 1
- Nebraska 1
- Puerto Rico 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450177 | 2450177 | 2022-04-27 | Frio | Texas | 48163 | 5875 | 93 |
2439539 | 2439539 | 2022-04-24 | San Miguel | New Mexico | 35047 | 5875 | 58 |
2436283 | 2436283 | 2022-04-23 | San Miguel | New Mexico | 35047 | 5875 | 58 |
2433027 | 2433027 | 2022-04-22 | San Miguel | New Mexico | 35047 | 5875 | 58 |
2402373 | 2402373 | 2022-04-13 | Monroe | Georgia | 13207 | 5875 | 172 |
2280703 | 2280703 | 2022-03-06 | Jasper | South Carolina | 45053 | 5875 | 92 |
2277450 | 2277450 | 2022-03-05 | Jasper | South Carolina | 45053 | 5875 | 92 |
2274197 | 2274197 | 2022-03-04 | Jasper | South Carolina | 45053 | 5875 | 92 |
2259754 | 2259754 | 2022-02-28 | Bourbon | Kentucky | 21017 | 5875 | 50 |
2258022 | 2258022 | 2022-02-27 | Yankton | South Dakota | 46135 | 5875 | 56 |
2254771 | 2254771 | 2022-02-26 | Yankton | South Dakota | 46135 | 5875 | 56 |
2251520 | 2251520 | 2022-02-25 | Yankton | South Dakota | 46135 | 5875 | 56 |
2245018 | 2245018 | 2022-02-23 | Yankton | South Dakota | 46135 | 5875 | 54 |
2201269 | 2201269 | 2022-02-10 | Harrison | Kentucky | 21097 | 5875 | 58 |
2202555 | 2202555 | 2022-02-10 | Aguada | Puerto Rico | 72003 | 5875 | |
2058977 | 2058977 | 2021-12-28 | Greene | New York | 36039 | 5875 | 95 |
2023265 | 2023265 | 2021-12-17 | Wyoming | New York | 36121 | 5875 | 72 |
2021009 | 2021009 | 2021-12-16 | Sanpete | Utah | 49039 | 5875 | 43 |
1963349 | 1963349 | 2021-11-29 | Oconee | Georgia | 13219 | 5875 | 82 |
1964592 | 1964592 | 2021-11-29 | Platte | Nebraska | 31141 | 5875 | 56 |
1960745 | 1960745 | 2021-11-28 | Iberville | Louisiana | 22047 | 5875 | 128 |
1957494 | 1957494 | 2021-11-27 | Iberville | Louisiana | 22047 | 5875 | 128 |
1954243 | 1954243 | 2021-11-26 | Iberville | Louisiana | 22047 | 5875 | 128 |
1950992 | 1950992 | 2021-11-25 | Iberville | Louisiana | 22047 | 5875 | 128 |
1947741 | 1947741 | 2021-11-24 | Iberville | Louisiana | 22047 | 5875 | 128 |
1944490 | 1944490 | 2021-11-23 | Iberville | Louisiana | 22047 | 5875 | 128 |
1945913 | 1945913 | 2021-11-23 | Henderson | Tennessee | 47077 | 5875 | 105 |
1945930 | 1945930 | 2021-11-23 | Marion | Tennessee | 47115 | 5875 | 57 |
1828471 | 1828471 | 2021-10-18 | Madison | Ohio | 39097 | 5875 | 76 |
1824694 | 1824694 | 2021-10-17 | Platte | Missouri | 29165 | 5875 | 61 |
1650132 | 1650132 | 2021-08-24 | Newberry | South Carolina | 45071 | 5875 | 112 |
1632523 | 1632523 | 2021-08-19 | Nelson | Kentucky | 21179 | 5875 | 63 |
1573885 | 1573885 | 2021-08-01 | Ford | Kansas | 20057 | 5875 | 81 |
1570637 | 1570637 | 2021-07-31 | Ford | Kansas | 20057 | 5875 | 81 |
1567389 | 1567389 | 2021-07-30 | Ford | Kansas | 20057 | 5875 | 81 |
1513400 | 1513400 | 2021-07-13 | Union | Ohio | 39159 | 5875 | 49 |
1486387 | 1486387 | 2021-07-05 | Pike | Kentucky | 21195 | 5875 | 106 |
1483141 | 1483141 | 2021-07-04 | Pike | Kentucky | 21195 | 5875 | 106 |
1479894 | 1479894 | 2021-07-03 | Pike | Kentucky | 21195 | 5875 | 106 |
1476648 | 1476648 | 2021-07-02 | Pike | Kentucky | 21195 | 5875 | 106 |
1432741 | 1432741 | 2021-06-18 | Atascosa | Texas | 48013 | 5875 | 151 |
1378920 | 1378920 | 2021-06-02 | Henry | Indiana | 18065 | 5875 | 109 |
1325582 | 1325582 | 2021-05-16 | Monroe | Tennessee | 47123 | 5875 | 96 |
1322336 | 1322336 | 2021-05-15 | Monroe | Tennessee | 47123 | 5875 | 96 |
1319090 | 1319090 | 2021-05-14 | Monroe | Tennessee | 47123 | 5875 | 96 |
1270379 | 1270379 | 2021-04-29 | Lawrence | Tennessee | 47099 | 5875 | 86 |
1177091 | 1177091 | 2021-04-01 | San Benito | California | 6069 | 5875 | 61 |
1166461 | 1166461 | 2021-03-28 | Loudon | Tennessee | 47105 | 5875 | 68 |
1163213 | 1163213 | 2021-03-27 | Loudon | Tennessee | 47105 | 5875 | 68 |
1159964 | 1159964 | 2021-03-26 | Loudon | Tennessee | 47105 | 5875 | 68 |
1151406 | 1151406 | 2021-03-24 | Spalding | Georgia | 13255 | 5875 | 174 |
1096778 | 1096778 | 2021-03-07 | McCracken | Kentucky | 21145 | 5875 | 76 |
1048894 | 1048894 | 2021-02-20 | Oswego | New York | 36075 | 5875 | 89 |
1034730 | 1034730 | 2021-02-16 | Whiteside | Illinois | 17195 | 5875 | 186 |
995595 | 995595 | 2021-02-04 | Rockdale | Georgia | 13247 | 5875 | 116 |
920804 | 920804 | 2021-01-12 | Nassau | Florida | 12089 | 5875 | 71 |
820574 | 820574 | 2020-12-12 | Kosciusko | Indiana | 18085 | 5875 | 60 |
798960 | 798960 | 2020-12-05 | Broome | New York | 36007 | 5875 | 160 |
763691 | 763691 | 2020-11-24 | Centre | Pennsylvania | 42027 | 5875 | 35 |
747602 | 747602 | 2020-11-19 | Aiken | South Carolina | 45003 | 5875 | 95 |
674622 | 674622 | 2020-10-28 | Black Hawk | Iowa | 19013 | 5875 | 102 |
621084 | 621084 | 2020-10-11 | Beaufort | South Carolina | 45013 | 5875 | 88 |
611238 | 611238 | 2020-10-08 | Lehigh | Pennsylvania | 42077 | 5875 | 357 |
514405 | 514405 | 2020-09-08 | Brazos | Texas | 48041 | 5875 | 58 |
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);