ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53 rows where cases = 7429 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Kentucky 12
- Tennessee 7
- Illinois 4
- Pennsylvania 4
- Ohio 3
- Arkansas 2
- Florida 2
- Indiana 2
- Puerto Rico 2
- Texas 2
- Colorado 1
- Georgia 1
- Maine 1
- Missouri 1
- New Mexico 1
- New York 1
- North Carolina 1
- Oklahoma 1
- South Carolina 1
- Virginia 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2406329 | 2406329 | 2022-04-14 | Hancock | Maine | 23009 | 7429 | 84 |
2238356 | 2238356 | 2022-02-21 | Humacao | Puerto Rico | 72069 | 7429 | |
2233778 | 2233778 | 2022-02-20 | Grant | Kentucky | 21081 | 7429 | 55 |
2230527 | 2230527 | 2022-02-19 | Grant | Kentucky | 21081 | 7429 | 55 |
2227276 | 2227276 | 2022-02-18 | Grant | Kentucky | 21081 | 7429 | 55 |
2214257 | 2214257 | 2022-02-14 | Clay | Kentucky | 21051 | 7429 | 75 |
2186687 | 2186687 | 2022-02-05 | Hockley | Texas | 48219 | 7429 | 154 |
2059208 | 2059208 | 2021-12-28 | Highland | Ohio | 39071 | 7429 | 130 |
1960643 | 1960643 | 2021-11-28 | Graves | Kentucky | 21083 | 7429 | 130 |
1957392 | 1957392 | 2021-11-27 | Graves | Kentucky | 21083 | 7429 | 130 |
1954141 | 1954141 | 2021-11-26 | Graves | Kentucky | 21083 | 7429 | 130 |
1950890 | 1950890 | 2021-11-25 | Graves | Kentucky | 21083 | 7429 | 130 |
1952816 | 1952816 | 2021-11-25 | Fauquier | Virginia | 51061 | 7429 | 88 |
1947639 | 1947639 | 2021-11-24 | Graves | Kentucky | 21083 | 7429 | 130 |
1923129 | 1923129 | 2021-11-16 | Campbell | Tennessee | 47013 | 7429 | 88 |
1873670 | 1873670 | 2021-11-01 | Curry | New Mexico | 35009 | 7429 | 119 |
1857929 | 1857929 | 2021-10-27 | Union | Pennsylvania | 42119 | 7429 | 99 |
1808971 | 1808971 | 2021-10-12 | Knox | Ohio | 39083 | 7429 | 132 |
1804289 | 1804289 | 2021-10-11 | Ogle | Illinois | 17141 | 7429 | 95 |
1801040 | 1801040 | 2021-10-10 | Ogle | Illinois | 17141 | 7429 | 95 |
1797791 | 1797791 | 2021-10-09 | Ogle | Illinois | 17141 | 7429 | 95 |
1794542 | 1794542 | 2021-10-08 | Ogle | Illinois | 17141 | 7429 | 95 |
1784039 | 1784039 | 2021-10-04 | Columbia | Wisconsin | 55021 | 7429 | 78 |
1706309 | 1706309 | 2021-09-11 | Mississippi | Arkansas | 5093 | 7429 | 122 |
1692490 | 1692490 | 2021-09-06 | Loudon | Tennessee | 47105 | 7429 | 77 |
1689241 | 1689241 | 2021-09-05 | Loudon | Tennessee | 47105 | 7429 | 77 |
1685991 | 1685991 | 2021-09-04 | Loudon | Tennessee | 47105 | 7429 | 77 |
1682740 | 1682740 | 2021-09-03 | Loudon | Tennessee | 47105 | 7429 | 77 |
1611254 | 1611254 | 2021-08-12 | Gibson | Tennessee | 47053 | 7429 | 152 |
1611838 | 1611838 | 2021-08-12 | Raleigh | West Virginia | 54081 | 7429 | 103 |
1596729 | 1596729 | 2021-08-08 | Christian | Kentucky | 21047 | 7429 | 108 |
1593480 | 1593480 | 2021-08-07 | Christian | Kentucky | 21047 | 7429 | 108 |
1590231 | 1590231 | 2021-08-06 | Christian | Kentucky | 21047 | 7429 | 108 |
1555022 | 1555022 | 2021-07-26 | Joplin | Missouri | 7429 | 119 | |
1539582 | 1539582 | 2021-07-21 | Caguas | Puerto Rico | 72025 | 7429 | |
1400527 | 1400527 | 2021-06-08 | Wise | Texas | 48497 | 7429 | 123 |
1364237 | 1364237 | 2021-05-28 | Crawford | Pennsylvania | 42039 | 7429 | 151 |
1146953 | 1146953 | 2021-03-22 | Greene | Tennessee | 47059 | 7429 | 149 |
1097963 | 1097963 | 2021-03-07 | Adams | Pennsylvania | 42001 | 7429 | 152 |
1044219 | 1044219 | 2021-02-19 | Glynn | Georgia | 13127 | 7429 | 157 |
1024660 | 1024660 | 2021-02-13 | Nassau | Florida | 12089 | 7429 | 106 |
917180 | 917180 | 2021-01-10 | Laramie | Wyoming | 56021 | 7429 | 65 |
911438 | 911438 | 2021-01-09 | Howard | Indiana | 18067 | 7429 | 133 |
872477 | 872477 | 2020-12-28 | Delaware | Indiana | 18035 | 7429 | 126 |
860625 | 860625 | 2020-12-24 | Broome | New York | 36007 | 7429 | 195 |
854718 | 854718 | 2020-12-22 | Dorchester | South Carolina | 45035 | 7429 | 122 |
799080 | 799080 | 2020-12-05 | New Hanover | North Carolina | 37129 | 7429 | 61 |
764958 | 764958 | 2020-11-25 | Pueblo | Colorado | 8101 | 7429 | 109 |
637045 | 637045 | 2020-10-16 | Cleveland | Oklahoma | 40027 | 7429 | 85 |
588351 | 588351 | 2020-10-01 | Lucas | Ohio | 39095 | 7429 | 364 |
499023 | 499023 | 2020-09-04 | Washington | Arkansas | 5143 | 7429 | 78 |
379840 | 379840 | 2020-07-29 | Escambia | Florida | 12033 | 7429 | 88 |
311420 | 311420 | 2020-07-07 | Delaware | Pennsylvania | 42045 | 7429 | 704 |
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);