ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
61 rows where cases = 6584 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Tennessee 8
- Georgia 7
- Kansas 5
- Colorado 4
- North Carolina 4
- Virginia 4
- Louisiana 3
- Michigan 3
- Ohio 3
- West Virginia 3
- Oregon 2
- Washington 2
- California 1
- District of Columbia 1
- Florida 1
- Kentucky 1
- Maine 1
- Massachusetts 1
- Minnesota 1
- New Jersey 1
- New York 1
- Pennsylvania 1
- South Carolina 1
- Vermont 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447316 | 2447316 | 2022-04-26 | Boone | West Virginia | 54005 | 6584 | 75 |
2304690 | 2304690 | 2022-03-14 | Chattooga | Georgia | 13055 | 6584 | 129 |
2291140 | 2291140 | 2022-03-09 | Mason | West Virginia | 54053 | 6584 | 89 |
2287711 | 2287711 | 2022-03-08 | Carroll | Virginia | 51035 | 6584 | 136 |
2269445 | 2269445 | 2022-03-03 | Labette | Kansas | 20099 | 6584 | 72 |
2266192 | 2266192 | 2022-03-02 | Labette | Kansas | 20099 | 6584 | 72 |
2246903 | 2246903 | 2022-02-24 | Richland | Louisiana | 22083 | 6584 | 94 |
2241675 | 2241675 | 2022-02-22 | Edgefield | South Carolina | 45037 | 6584 | 65 |
2202471 | 2202471 | 2022-02-10 | Lincoln | Oregon | 41041 | 6584 | 66 |
2194162 | 2194162 | 2022-02-08 | Gilmer | Georgia | 13123 | 6584 | 153 |
2149430 | 2149430 | 2022-01-25 | Dickinson | Michigan | 26043 | 6584 | 96 |
2146178 | 2146178 | 2022-01-24 | Dickinson | Michigan | 26043 | 6584 | 96 |
2140533 | 2140533 | 2022-01-22 | Pike | Ohio | 39131 | 6584 | 89 |
2105184 | 2105184 | 2022-01-11 | Giles | Tennessee | 47055 | 6584 | 150 |
2101933 | 2101933 | 2022-01-10 | Giles | Tennessee | 47055 | 6584 | 150 |
2098682 | 2098682 | 2022-01-09 | Giles | Tennessee | 47055 | 6584 | 150 |
2095430 | 2095430 | 2022-01-08 | Giles | Tennessee | 47055 | 6584 | 150 |
2092178 | 2092178 | 2022-01-07 | Giles | Tennessee | 47055 | 6584 | 150 |
2088926 | 2088926 | 2022-01-06 | Giles | Tennessee | 47055 | 6584 | 150 |
2085675 | 2085675 | 2022-01-05 | Giles | Tennessee | 47055 | 6584 | 150 |
2082423 | 2082423 | 2022-01-04 | Giles | Tennessee | 47055 | 6584 | 150 |
2076421 | 2076421 | 2022-01-02 | Wise | Virginia | 51195 | 6584 | 146 |
2073170 | 2073170 | 2022-01-01 | Wise | Virginia | 51195 | 6584 | 146 |
2069919 | 2069919 | 2021-12-31 | Wise | Virginia | 51195 | 6584 | 146 |
2027532 | 2027532 | 2021-12-18 | Rutland | Vermont | 50021 | 6584 | 38 |
1959888 | 1959888 | 2021-11-28 | Montrose | Colorado | 8085 | 6584 | 107 |
1860010 | 1860010 | 2021-10-28 | Natchitoches | Louisiana | 22069 | 6584 | 135 |
1854356 | 1854356 | 2021-10-26 | Watauga | North Carolina | 37189 | 6584 | 37 |
1846109 | 1846109 | 2021-10-24 | Broomfield | Colorado | 8014 | 6584 | 81 |
1842859 | 1842859 | 2021-10-23 | Broomfield | Colorado | 8014 | 6584 | 81 |
1839609 | 1839609 | 2021-10-22 | Broomfield | Colorado | 8014 | 6584 | 81 |
1812113 | 1812113 | 2021-10-13 | Vance | North Carolina | 37181 | 6584 | 97 |
1804012 | 1804012 | 2021-10-11 | Baldwin | Georgia | 13009 | 6584 | 174 |
1805541 | 1805541 | 2021-10-11 | Chatham | North Carolina | 37037 | 6584 | 91 |
1800763 | 1800763 | 2021-10-10 | Baldwin | Georgia | 13009 | 6584 | 174 |
1797514 | 1797514 | 2021-10-09 | Baldwin | Georgia | 13009 | 6584 | 174 |
1794265 | 1794265 | 2021-10-08 | Baldwin | Georgia | 13009 | 6584 | 174 |
1722884 | 1722884 | 2021-09-16 | Murray | Georgia | 13213 | 6584 | 107 |
1721423 | 1721423 | 2021-09-15 | Columbia | Pennsylvania | 42037 | 6584 | 139 |
1702792 | 1702792 | 2021-09-09 | Putnam | West Virginia | 54079 | 6584 | 105 |
1692011 | 1692011 | 2021-09-06 | Jefferson | Ohio | 39081 | 6584 | 166 |
1636750 | 1636750 | 2021-08-20 | Belmont | Ohio | 39013 | 6584 | 181 |
1559882 | 1559882 | 2021-07-27 | Calumet | Wisconsin | 55015 | 6584 | 56 |
1428058 | 1428058 | 2021-06-17 | Kennebec | Maine | 23011 | 6584 | 74 |
1350862 | 1350862 | 2021-05-24 | St. Lawrence | New York | 36089 | 6584 | 96 |
1316877 | 1316877 | 2021-05-14 | Putnam | Florida | 12107 | 6584 | 152 |
1265618 | 1265618 | 2021-04-28 | Laurel | Kentucky | 21125 | 6584 | 68 |
1192937 | 1192937 | 2021-04-05 | Kitsap | Washington | 53035 | 6584 | 95 |
1181451 | 1181451 | 2021-04-02 | Blue Earth | Minnesota | 27013 | 6584 | 39 |
1126060 | 1126060 | 2021-03-16 | Iberia | Louisiana | 22045 | 6584 | 148 |
1032770 | 1032770 | 2021-02-15 | Rutherford | North Carolina | 37161 | 6584 | 193 |
960284 | 960284 | 2021-01-24 | Butler | Kansas | 20015 | 6584 | 43 |
957038 | 957038 | 2021-01-23 | Butler | Kansas | 20015 | 6584 | 43 |
953793 | 953793 | 2021-01-22 | Butler | Kansas | 20015 | 6584 | 43 |
931461 | 931461 | 2021-01-15 | Lenawee | Michigan | 26091 | 6584 | 85 |
855722 | 855722 | 2020-12-23 | Butte | California | 6007 | 6584 | 83 |
533431 | 533431 | 2020-09-14 | Multnomah | Oregon | 41051 | 6584 | 127 |
256904 | 256904 | 2020-06-20 | Hampden | Massachusetts | 25013 | 6584 | 648 |
213945 | 213945 | 2020-06-06 | Morris | New Jersey | 34027 | 6584 | 626 |
139514 | 139514 | 2020-05-13 | District of Columbia | District of Columbia | 11001 | 6584 | 350 |
115200 | 115200 | 2020-05-04 | King | Washington | 53033 | 6584 | 465 |
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);