ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 4915 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Washington 13
- Virginia 8
- Oklahoma 7
- Georgia 6
- Illinois 6
- Alabama 5
- Kentucky 5
- Mississippi 5
- Puerto Rico 5
- Wisconsin 5
- Michigan 4
- Oregon 4
- California 3
- Missouri 3
- Ohio 3
- Colorado 2
- Louisiana 2
- Nebraska 2
- North Carolina 2
- Arkansas 1
- Indiana 1
- Kansas 1
- Massachusetts 1
- Minnesota 1
- Montana 1
- Nevada 1
- New Mexico 1
- New York 1
- Pennsylvania 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467149 | 2467149 | 2022-05-03 | Lincoln | Arkansas | 5079 | 4915 | 68 |
2469960 | 2469960 | 2022-05-03 | Colonial Heights city | Virginia | 51570 | 4915 | 97 |
2436788 | 2436788 | 2022-04-23 | Barranquitas | Puerto Rico | 72019 | 4915 | |
2404916 | 2404916 | 2022-04-13 | Radford city | Virginia | 51750 | 4915 | 52 |
2401692 | 2401692 | 2022-04-12 | Adams | Washington | 53001 | 4915 | 38 |
2398437 | 2398437 | 2022-04-11 | Adams | Washington | 53001 | 4915 | 38 |
2395182 | 2395182 | 2022-04-10 | Adams | Washington | 53001 | 4915 | 38 |
2391926 | 2391926 | 2022-04-09 | Adams | Washington | 53001 | 4915 | 38 |
2388670 | 2388670 | 2022-04-08 | Adams | Washington | 53001 | 4915 | 38 |
2385415 | 2385415 | 2022-04-07 | Adams | Washington | 53001 | 4915 | 38 |
2382160 | 2382160 | 2022-04-06 | Adams | Washington | 53001 | 4915 | 38 |
2378905 | 2378905 | 2022-04-05 | Adams | Washington | 53001 | 4915 | 38 |
2375651 | 2375651 | 2022-04-04 | Adams | Washington | 53001 | 4915 | 38 |
2336344 | 2336344 | 2022-03-23 | Milam | Texas | 48331 | 4915 | 101 |
2304048 | 2304048 | 2022-03-13 | Powhatan | Virginia | 51145 | 4915 | 55 |
2300796 | 2300796 | 2022-03-12 | Powhatan | Virginia | 51145 | 4915 | 55 |
2297544 | 2297544 | 2022-03-11 | Powhatan | Virginia | 51145 | 4915 | 55 |
2287733 | 2287733 | 2022-03-08 | Fluvanna | Virginia | 51065 | 4915 | 42 |
2254587 | 2254587 | 2022-02-26 | Cabo Rojo | Puerto Rico | 72023 | 4915 | |
2221160 | 2221160 | 2022-02-16 | Clay | Mississippi | 28025 | 4915 | 92 |
2215491 | 2215491 | 2022-02-14 | Union | Oregon | 41061 | 4915 | 71 |
2205840 | 2205840 | 2022-02-11 | Hatillo | Puerto Rico | 72065 | 4915 | |
2200741 | 2200741 | 2022-02-10 | Tattnall | Georgia | 13267 | 4915 | 123 |
2199409 | 2199409 | 2022-02-09 | Hampton | South Carolina | 45049 | 4915 | 78 |
2190462 | 2190462 | 2022-02-07 | Butler | Alabama | 1013 | 4915 | 110 |
2134046 | 2134046 | 2022-01-20 | Wyandot | Ohio | 39175 | 4915 | 90 |
2111039 | 2111039 | 2022-01-13 | Anson | North Carolina | 37007 | 4915 | 86 |
2096316 | 2096316 | 2022-01-09 | Calaveras | California | 6009 | 4915 | 93 |
2093064 | 2093064 | 2022-01-08 | Calaveras | California | 6009 | 4915 | 93 |
2089812 | 2089812 | 2022-01-07 | Calaveras | California | 6009 | 4915 | 93 |
2060777 | 2060777 | 2021-12-29 | Chattooga | Georgia | 13055 | 4915 | 109 |
2039952 | 2039952 | 2021-12-22 | Arecibo | Puerto Rico | 72013 | 4915 | |
2031152 | 2031152 | 2021-12-20 | Lawrence | Alabama | 1079 | 4915 | 133 |
1963806 | 1963806 | 2021-11-29 | McPherson | Kansas | 20113 | 4915 | 98 |
1924887 | 1924887 | 2021-11-17 | Grayson | Kentucky | 21085 | 4915 | 96 |
1848949 | 1848949 | 2021-10-24 | Stevens | Washington | 53065 | 4915 | 86 |
1845699 | 1845699 | 2021-10-23 | Stevens | Washington | 53065 | 4915 | 86 |
1842449 | 1842449 | 2021-10-22 | Stevens | Washington | 53065 | 4915 | 86 |
1808843 | 1808843 | 2021-10-12 | Pasquotank | North Carolina | 37139 | 4915 | 98 |
1804694 | 1804694 | 2021-10-11 | Marshall | Kentucky | 21157 | 4915 | 76 |
1779856 | 1779856 | 2021-10-03 | Benton | Oregon | 41003 | 4915 | 30 |
1776606 | 1776606 | 2021-10-02 | Benton | Oregon | 41003 | 4915 | 30 |
1773356 | 1773356 | 2021-10-01 | Benton | Oregon | 41003 | 4915 | 30 |
1764623 | 1764623 | 2021-09-28 | Teton | Wyoming | 56039 | 4915 | 13 |
1760259 | 1760259 | 2021-09-27 | Putnam | Ohio | 39137 | 4915 | 107 |
1755512 | 1755512 | 2021-09-26 | Fulton | Illinois | 17057 | 4915 | 78 |
1752264 | 1752264 | 2021-09-25 | Fulton | Illinois | 17057 | 4915 | 78 |
1749015 | 1749015 | 2021-09-24 | Fulton | Illinois | 17057 | 4915 | 78 |
1743612 | 1743612 | 2021-09-22 | Lincoln | Nebraska | 31111 | 4915 | 80 |
1723951 | 1723951 | 2021-09-16 | Marion | Missouri | 29127 | 4915 | 58 |
1621639 | 1621639 | 2021-08-15 | Monroe | Wisconsin | 55081 | 4915 | 51 |
1618391 | 1618391 | 2021-08-14 | Monroe | Wisconsin | 55081 | 4915 | 51 |
1615143 | 1615143 | 2021-08-13 | Monroe | Wisconsin | 55081 | 4915 | 51 |
1606912 | 1606912 | 2021-08-11 | Marshall | Mississippi | 28093 | 4915 | 106 |
1585108 | 1585108 | 2021-08-04 | Toa Alta | Puerto Rico | 72135 | 4915 | |
1580147 | 1580147 | 2021-08-03 | Stephenson | Illinois | 17177 | 4915 | 105 |
1558928 | 1558928 | 2021-07-27 | Osage | Oklahoma | 40113 | 4915 | 82 |
1555681 | 1555681 | 2021-07-26 | Osage | Oklahoma | 40113 | 4915 | 82 |
1551696 | 1551696 | 2021-07-25 | Pearl River | Mississippi | 28109 | 4915 | 149 |
1552434 | 1552434 | 2021-07-25 | Osage | Oklahoma | 40113 | 4915 | 82 |
1548449 | 1548449 | 2021-07-24 | Pearl River | Mississippi | 28109 | 4915 | 149 |
1549187 | 1549187 | 2021-07-24 | Osage | Oklahoma | 40113 | 4915 | 82 |
1545202 | 1545202 | 2021-07-23 | Pearl River | Mississippi | 28109 | 4915 | 149 |
1545940 | 1545940 | 2021-07-23 | Osage | Oklahoma | 40113 | 4915 | 82 |
1542693 | 1542693 | 2021-07-22 | Osage | Oklahoma | 40113 | 4915 | 82 |
1539445 | 1539445 | 2021-07-21 | Osage | Oklahoma | 40113 | 4915 | 82 |
1508439 | 1508439 | 2021-07-12 | Colquitt | Georgia | 13071 | 4915 | 131 |
1394433 | 1394433 | 2021-06-07 | Dale | Alabama | 1045 | 4915 | 114 |
1391417 | 1391417 | 2021-06-06 | Broomfield | Colorado | 8014 | 4915 | 76 |
1334501 | 1334501 | 2021-05-19 | Elko | Nevada | 32007 | 4915 | 56 |
1304042 | 1304042 | 2021-05-10 | Tift | Georgia | 13277 | 4915 | 126 |
1304633 | 1304633 | 2021-05-10 | Whitley | Kentucky | 21235 | 4915 | 55 |
1301386 | 1301386 | 2021-05-09 | Whitley | Kentucky | 21235 | 4915 | 55 |
1262818 | 1262818 | 2021-04-27 | Callaway | Missouri | 29027 | 4915 | 47 |
1261256 | 1261256 | 2021-04-26 | Oconto | Wisconsin | 55083 | 4915 | 58 |
1201470 | 1201470 | 2021-04-08 | Genesee | New York | 36037 | 4915 | 121 |
1162180 | 1162180 | 2021-03-27 | Johnson | Missouri | 29101 | 4915 | 48 |
1135951 | 1135951 | 2021-03-19 | Marquette | Michigan | 26103 | 4915 | 57 |
1113312 | 1113312 | 2021-03-12 | Otter Tail | Minnesota | 27111 | 4915 | 71 |
1103421 | 1103421 | 2021-03-09 | Berkshire | Massachusetts | 25003 | 4915 | 262 |
1071550 | 1071550 | 2021-02-27 | Curry | New Mexico | 35009 | 4915 | 67 |
1034702 | 1034702 | 2021-02-16 | Ogle | Illinois | 17141 | 4915 | 79 |
1018451 | 1018451 | 2021-02-11 | Knox | Illinois | 17095 | 4915 | 153 |
1016237 | 1016237 | 2021-02-10 | Buffalo | Nebraska | 31019 | 4915 | 54 |
1012479 | 1012479 | 2021-02-09 | St. Charles | Louisiana | 22089 | 4915 | 88 |
982113 | 982113 | 2021-01-31 | Coffee | Alabama | 1031 | 4915 | 72 |
978071 | 978071 | 2021-01-29 | Brown | South Dakota | 46013 | 4915 | 79 |
968805 | 968805 | 2021-01-26 | Bedford | Virginia | 51019 | 4915 | 37 |
953991 | 953991 | 2021-01-22 | Pulaski | Kentucky | 21199 | 4915 | 73 |
946327 | 946327 | 2021-01-19 | Grant | Wisconsin | 55043 | 4915 | 83 |
917459 | 917459 | 2021-01-11 | Fremont | Colorado | 8043 | 4915 | 26 |
875533 | 875533 | 2020-12-29 | Troup | Georgia | 13285 | 4915 | 127 |
871793 | 871793 | 2020-12-28 | Jackson | Alabama | 1071 | 4915 | 34 |
862811 | 862811 | 2020-12-25 | Warrick | Indiana | 18173 | 4915 | 88 |
861903 | 861903 | 2020-12-24 | Monongalia | West Virginia | 54061 | 4915 | 25 |
847085 | 847085 | 2020-12-20 | Lenawee | Michigan | 26091 | 4915 | 59 |
843839 | 843839 | 2020-12-19 | Lenawee | Michigan | 26091 | 4915 | 59 |
818657 | 818657 | 2020-12-11 | Columbiana | Ohio | 39029 | 4915 | 110 |
784600 | 784600 | 2020-12-01 | Houston | Georgia | 13153 | 4915 | 107 |
730585 | 730585 | 2020-11-14 | Flathead | Montana | 30029 | 4915 | 27 |
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);