ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where cases = 6574 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Texas 12
- Indiana 8
- South Carolina 7
- Colorado 4
- Michigan 3
- Ohio 3
- Arkansas 2
- Georgia 2
- New York 2
- Pennsylvania 2
- Alabama 1
- Kentucky 1
- Massachusetts 1
- Minnesota 1
- Missouri 1
- Montana 1
- New Hampshire 1
- Puerto Rico 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497086 | 2497086 | 2022-05-12 | Posey | Indiana | 18129 | 6574 | 58 |
2493828 | 2493828 | 2022-05-11 | Posey | Indiana | 18129 | 6574 | 58 |
2494328 | 2494328 | 2022-05-11 | Emmet | Michigan | 26047 | 6574 | 87 |
2491070 | 2491070 | 2022-05-10 | Emmet | Michigan | 26047 | 6574 | 87 |
2359324 | 2359324 | 2022-03-30 | Louisa | Virginia | 51109 | 6574 | 80 |
2338443 | 2338443 | 2022-03-24 | Lake | Montana | 30047 | 6574 | 98 |
2251734 | 2251734 | 2022-02-25 | Hutchinson | Texas | 48233 | 6574 | 133 |
2150261 | 2150261 | 2022-01-25 | Hardin | Ohio | 39065 | 6574 | 134 |
2145091 | 2145091 | 2022-01-24 | St. Francis | Arkansas | 5123 | 6574 | 74 |
2088153 | 2088153 | 2022-01-06 | Carroll | New Hampshire | 33003 | 6574 | 34 |
2078157 | 2078157 | 2022-01-03 | Howell | Missouri | 29091 | 6574 | 175 |
2075644 | 2075644 | 2022-01-02 | Clarion | Pennsylvania | 42031 | 6574 | 171 |
2059544 | 2059544 | 2021-12-28 | Dillon | South Carolina | 45033 | 6574 | 119 |
2056295 | 2056295 | 2021-12-27 | Dillon | South Carolina | 45033 | 6574 | 119 |
2053046 | 2053046 | 2021-12-26 | Dillon | South Carolina | 45033 | 6574 | 119 |
2053309 | 2053309 | 2021-12-26 | Erath | Texas | 48143 | 6574 | 109 |
2049796 | 2049796 | 2021-12-25 | Dillon | South Carolina | 45033 | 6574 | 119 |
2050059 | 2050059 | 2021-12-25 | Erath | Texas | 48143 | 6574 | 109 |
2046546 | 2046546 | 2021-12-24 | Dillon | South Carolina | 45033 | 6574 | 119 |
2046809 | 2046809 | 2021-12-24 | Erath | Texas | 48143 | 6574 | 109 |
2043296 | 2043296 | 2021-12-23 | Dillon | South Carolina | 45033 | 6574 | 119 |
2043559 | 2043559 | 2021-12-23 | Erath | Texas | 48143 | 6574 | 109 |
1920219 | 1920219 | 2021-11-15 | Wood | Texas | 48499 | 6574 | 227 |
1916969 | 1916969 | 2021-11-14 | Wood | Texas | 48499 | 6574 | 227 |
1913719 | 1913719 | 2021-11-13 | Wood | Texas | 48499 | 6574 | 227 |
1910469 | 1910469 | 2021-11-12 | Wood | Texas | 48499 | 6574 | 226 |
1897354 | 1897354 | 2021-11-08 | Kerr | Texas | 48265 | 6574 | 135 |
1869336 | 1869336 | 2021-10-31 | Harrison | Indiana | 18061 | 6574 | 98 |
1866087 | 1866087 | 2021-10-30 | Harrison | Indiana | 18061 | 6574 | 98 |
1862838 | 1862838 | 2021-10-29 | Harrison | Indiana | 18061 | 6574 | 98 |
1847755 | 1847755 | 2021-10-24 | Tompkins | New York | 36109 | 6574 | 59 |
1708514 | 1708514 | 2021-09-11 | Guaynabo | Puerto Rico | 72061 | 6574 | |
1705653 | 1705653 | 2021-09-10 | Jim Wells | Texas | 48249 | 6574 | 137 |
1608968 | 1608968 | 2021-08-12 | Garfield | Colorado | 8045 | 6574 | 56 |
1511528 | 1511528 | 2021-07-13 | Fremont | Colorado | 8043 | 6574 | 65 |
1508281 | 1508281 | 2021-07-12 | Fremont | Colorado | 8043 | 6574 | 63 |
1496258 | 1496258 | 2021-07-08 | Berkshire | Massachusetts | 25003 | 6574 | 288 |
1337875 | 1337875 | 2021-05-20 | Sullivan | New York | 36105 | 6574 | 72 |
1297779 | 1297779 | 2021-05-08 | Morgan | Indiana | 18109 | 6574 | 144 |
1258066 | 1258066 | 2021-04-26 | Blount | Alabama | 1009 | 6574 | 134 |
1250408 | 1250408 | 2021-04-23 | Geauga | Ohio | 39055 | 6574 | 146 |
1195239 | 1195239 | 2021-04-06 | Ross | Ohio | 39141 | 6574 | 144 |
1082110 | 1082110 | 2021-03-02 | Bowie | Texas | 48037 | 6574 | 182 |
999423 | 999423 | 2021-02-05 | Oldham | Kentucky | 21185 | 6574 | 68 |
995537 | 995537 | 2021-02-04 | Gordon | Georgia | 13129 | 6574 | 88 |
992368 | 992368 | 2021-02-03 | Troup | Georgia | 13285 | 6574 | 170 |
986074 | 986074 | 2021-02-01 | Grant | Indiana | 18053 | 6574 | 128 |
949527 | 949527 | 2021-01-20 | Monongalia | West Virginia | 54061 | 6574 | 54 |
895812 | 895812 | 2021-01-04 | Carver | Minnesota | 27019 | 6574 | 34 |
793037 | 793037 | 2020-12-03 | Aiken | South Carolina | 45003 | 6574 | 100 |
674552 | 674552 | 2020-10-28 | Hamilton | Indiana | 18057 | 6574 | 128 |
573397 | 573397 | 2020-09-27 | Benton | Arkansas | 5007 | 6574 | 86 |
537923 | 537923 | 2020-09-16 | El Paso | Colorado | 8041 | 6574 | 165 |
361512 | 361512 | 2020-07-23 | Kent | Michigan | 26081 | 6574 | 150 |
356060 | 356060 | 2020-07-21 | Allegheny | Pennsylvania | 42003 | 6574 | 211 |
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);