ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where cases = 6450 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Florida 13
- North Carolina 5
- California 4
- Indiana 4
- Pennsylvania 4
- South Dakota 4
- Georgia 3
- Illinois 3
- Michigan 3
- Missouri 3
- Tennessee 3
- Wisconsin 3
- Alabama 2
- Arkansas 2
- Virginia 2
- West Virginia 2
- Colorado 1
- Kentucky 1
- Maine 1
- Maryland 1
- New Mexico 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489804 | 2489804 | 2022-05-10 | Bibb | Alabama | 1007 | 6450 | 104 |
2369957 | 2369957 | 2022-04-03 | Douglas | Illinois | 17041 | 6450 | 61 |
2366704 | 2366704 | 2022-04-02 | Douglas | Illinois | 17041 | 6450 | 61 |
2363451 | 2363451 | 2022-04-01 | Douglas | Illinois | 17041 | 6450 | 61 |
2265443 | 2265443 | 2022-03-02 | Glenn | California | 6021 | 6450 | 63 |
2245615 | 2245615 | 2022-02-23 | Mason | West Virginia | 54053 | 6450 | 87 |
2200365 | 2200365 | 2022-02-10 | Johnson | Arkansas | 5071 | 6450 | 66 |
2198796 | 2198796 | 2022-02-09 | Luna | New Mexico | 35029 | 6450 | 113 |
2190323 | 2190323 | 2022-02-06 | Jackson | West Virginia | 54035 | 6450 | 117 |
2154903 | 2154903 | 2022-01-27 | Siskiyou | California | 6093 | 6450 | 86 |
2126942 | 2126942 | 2022-01-18 | Lawrence | Missouri | 29109 | 6450 | 141 |
2122069 | 2122069 | 2022-01-16 | Juneau | Wisconsin | 55057 | 6450 | 55 |
2118817 | 2118817 | 2022-01-15 | Juneau | Wisconsin | 55057 | 6450 | 55 |
2115565 | 2115565 | 2022-01-14 | Juneau | Wisconsin | 55057 | 6450 | 55 |
2094435 | 2094435 | 2022-01-08 | Marion | Missouri | 29127 | 6450 | 105 |
2075840 | 2075840 | 2022-01-02 | Codington | South Dakota | 46029 | 6450 | 91 |
2072589 | 2072589 | 2022-01-01 | Codington | South Dakota | 46029 | 6450 | 91 |
2069338 | 2069338 | 2021-12-31 | Codington | South Dakota | 46029 | 6450 | 91 |
2066087 | 2066087 | 2021-12-30 | Codington | South Dakota | 46029 | 6450 | 91 |
2059391 | 2059391 | 2021-12-28 | Clarion | Pennsylvania | 42031 | 6450 | 169 |
2041268 | 2041268 | 2021-12-23 | Bryan | Georgia | 13029 | 6450 | 77 |
2005822 | 2005822 | 2021-12-12 | Clinton | Indiana | 18023 | 6450 | 87 |
2002571 | 2002571 | 2021-12-11 | Clinton | Indiana | 18023 | 6450 | 87 |
1999321 | 1999321 | 2021-12-10 | Clinton | Indiana | 18023 | 6450 | 87 |
1963239 | 1963239 | 2021-11-29 | Wakulla | Florida | 12129 | 6450 | 107 |
1959988 | 1959988 | 2021-11-28 | Wakulla | Florida | 12129 | 6450 | 107 |
1956737 | 1956737 | 2021-11-27 | Wakulla | Florida | 12129 | 6450 | 107 |
1953486 | 1953486 | 2021-11-26 | Wakulla | Florida | 12129 | 6450 | 107 |
1950235 | 1950235 | 2021-11-25 | Wakulla | Florida | 12129 | 6450 | 107 |
1946984 | 1946984 | 2021-11-24 | Wakulla | Florida | 12129 | 6450 | 107 |
1943733 | 1943733 | 2021-11-23 | Wakulla | Florida | 12129 | 6450 | 107 |
1940483 | 1940483 | 2021-11-22 | Wakulla | Florida | 12129 | 6450 | 107 |
1937233 | 1937233 | 2021-11-21 | Wakulla | Florida | 12129 | 6450 | 107 |
1933983 | 1933983 | 2021-11-20 | Wakulla | Florida | 12129 | 6450 | 107 |
1930731 | 1930731 | 2021-11-19 | Wakulla | Florida | 12129 | 6450 | 104 |
1767617 | 1767617 | 2021-09-29 | James City | Virginia | 51095 | 6450 | 87 |
1742281 | 1742281 | 2021-09-22 | Baldwin | Georgia | 13009 | 6450 | 163 |
1744471 | 1744471 | 2021-09-22 | Marshall | Tennessee | 47117 | 6450 | 73 |
1714626 | 1714626 | 2021-09-13 | Richmond | North Carolina | 37153 | 6450 | 127 |
1649190 | 1649190 | 2021-08-24 | Callaway | Missouri | 29027 | 6450 | 57 |
1636550 | 1636550 | 2021-08-20 | Jefferson | New York | 36045 | 6450 | 69 |
1619764 | 1619764 | 2021-08-15 | St. Joseph | Michigan | 26149 | 6450 | 104 |
1616516 | 1616516 | 2021-08-14 | St. Joseph | Michigan | 26149 | 6450 | 104 |
1613268 | 1613268 | 2021-08-13 | St. Joseph | Michigan | 26149 | 6450 | 104 |
1601531 | 1601531 | 2021-08-09 | Lawrence | Tennessee | 47099 | 6450 | 100 |
1557917 | 1557917 | 2021-07-27 | Penobscot | Maine | 23019 | 6450 | 105 |
1559294 | 1559294 | 2021-07-27 | Jefferson | Tennessee | 47089 | 6450 | 126 |
1551437 | 1551437 | 2021-07-25 | Cecil | Maryland | 24015 | 6450 | 157 |
1461249 | 1461249 | 2021-06-27 | Columbus | North Carolina | 37047 | 6450 | 152 |
1458004 | 1458004 | 2021-06-26 | Columbus | North Carolina | 37047 | 6450 | 152 |
1454759 | 1454759 | 2021-06-25 | Columbus | North Carolina | 37047 | 6450 | 152 |
1277279 | 1277279 | 2021-05-01 | Harrisonburg city | Virginia | 51660 | 6450 | 95 |
1249078 | 1249078 | 2021-04-23 | Morgan | Indiana | 18109 | 6450 | 143 |
1177236 | 1177236 | 2021-04-01 | Monroe | Florida | 12087 | 6450 | 49 |
1101225 | 1101225 | 2021-03-08 | Clearfield | Pennsylvania | 42033 | 6450 | 117 |
1056787 | 1056787 | 2021-02-23 | Jackson | Alabama | 1071 | 6450 | 101 |
998456 | 998456 | 2021-02-05 | Crawford | Arkansas | 5033 | 6450 | 95 |
906129 | 906129 | 2021-01-07 | Caldwell | North Carolina | 37027 | 6450 | 31 |
805884 | 805884 | 2020-12-07 | Cumberland | Pennsylvania | 42041 | 6450 | 177 |
751975 | 751975 | 2020-11-21 | Pueblo | Colorado | 8101 | 6450 | 80 |
721528 | 721528 | 2020-11-11 | Luzerne | Pennsylvania | 42079 | 6450 | 218 |
644949 | 644949 | 2020-10-19 | Bay | Florida | 12005 | 6450 | 128 |
645043 | 645043 | 2020-10-19 | Clarke | Georgia | 13059 | 6450 | 46 |
583240 | 583240 | 2020-09-30 | Solano | California | 6095 | 6450 | 71 |
524921 | 524921 | 2020-09-12 | Marin | California | 6041 | 6450 | 99 |
509573 | 509573 | 2020-09-07 | Fayette | Kentucky | 21067 | 6450 | 61 |
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);