ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52 rows where cases = 7923 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Texas 7
- California 6
- Ohio 6
- New Hampshire 4
- Tennessee 4
- North Carolina 3
- Virgin Islands 3
- Georgia 2
- Kansas 2
- Missouri 2
- New York 2
- West Virginia 2
- Alabama 1
- Alaska 1
- Arkansas 1
- Indiana 1
- Maryland 1
- New Jersey 1
- New Mexico 1
- Pennsylvania 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2440627 | 2440627 | 2022-04-24 | St. Croix | Virgin Islands | 78010 | 7923 | 47 |
2437371 | 2437371 | 2022-04-23 | St. Croix | Virgin Islands | 78010 | 7923 | 47 |
2434115 | 2434115 | 2022-04-22 | St. Croix | Virgin Islands | 78010 | 7923 | 47 |
2416768 | 2416768 | 2022-04-17 | Delaware | New York | 36025 | 7923 | 70 |
2292220 | 2292220 | 2022-03-10 | McPherson | Kansas | 20113 | 7923 | 124 |
2288968 | 2288968 | 2022-03-09 | McPherson | Kansas | 20113 | 7923 | 124 |
2287425 | 2287425 | 2022-03-08 | Cherokee | Texas | 48073 | 7923 | 248 |
2283589 | 2283589 | 2022-03-07 | Coshocton | Ohio | 39031 | 7923 | 151 |
2284173 | 2284173 | 2022-03-07 | Cherokee | Texas | 48073 | 7923 | 248 |
2266808 | 2266808 | 2022-03-02 | Marion | Missouri | 29127 | 7923 | 114 |
2159829 | 2159829 | 2022-01-28 | Wyoming | New York | 36121 | 7923 | 80 |
2156461 | 2156461 | 2022-01-27 | Sullivan | New Hampshire | 33019 | 7923 | 59 |
2151289 | 2151289 | 2022-01-25 | Logan | West Virginia | 54045 | 7923 | 156 |
2122892 | 2122892 | 2022-01-17 | Miami | Indiana | 18103 | 7923 | 137 |
2053156 | 2053156 | 2021-12-26 | Cocke | Tennessee | 47029 | 7923 | 159 |
2049906 | 2049906 | 2021-12-25 | Cocke | Tennessee | 47029 | 7923 | 159 |
2046656 | 2046656 | 2021-12-24 | Cocke | Tennessee | 47029 | 7923 | 159 |
2043406 | 2043406 | 2021-12-23 | Cocke | Tennessee | 47029 | 7923 | 159 |
2026749 | 2026749 | 2021-12-18 | Shelby | Ohio | 39149 | 7923 | 137 |
1990431 | 1990431 | 2021-12-07 | Pettis | Missouri | 29159 | 7923 | 128 |
1984134 | 1984134 | 2021-12-05 | Belknap | New Hampshire | 33001 | 7923 | 134 |
1980884 | 1980884 | 2021-12-04 | Belknap | New Hampshire | 33001 | 7923 | 134 |
1977634 | 1977634 | 2021-12-03 | Belknap | New Hampshire | 33001 | 7923 | 134 |
1963055 | 1963055 | 2021-11-29 | Lassen | California | 6035 | 7923 | 57 |
1959804 | 1959804 | 2021-11-28 | Lassen | California | 6035 | 7923 | 57 |
1956553 | 1956553 | 2021-11-27 | Lassen | California | 6035 | 7923 | 57 |
1953302 | 1953302 | 2021-11-26 | Lassen | California | 6035 | 7923 | 57 |
1950051 | 1950051 | 2021-11-25 | Lassen | California | 6035 | 7923 | 57 |
1946800 | 1946800 | 2021-11-24 | Lassen | California | 6035 | 7923 | 57 |
1877818 | 1877818 | 2021-11-02 | Hale | Texas | 48189 | 7923 | 190 |
1874569 | 1874569 | 2021-11-01 | Hale | Texas | 48189 | 7923 | 190 |
1871320 | 1871320 | 2021-10-31 | Hale | Texas | 48189 | 7923 | 190 |
1867455 | 1867455 | 2021-10-30 | Knox | Ohio | 39083 | 7923 | 152 |
1868071 | 1868071 | 2021-10-30 | Hale | Texas | 48189 | 7923 | 189 |
1864822 | 1864822 | 2021-10-29 | Hale | Texas | 48189 | 7923 | 189 |
1836532 | 1836532 | 2021-10-21 | Coffee | Georgia | 13069 | 7923 | 220 |
1426771 | 1426771 | 2021-06-16 | Wood | West Virginia | 54107 | 7923 | 176 |
1352292 | 1352292 | 2021-05-25 | Fairbanks North Star Borough | Alaska | 2090 | 7923 | 43 |
1348043 | 1348043 | 2021-05-23 | Somerset | Pennsylvania | 42111 | 7923 | 209 |
1312089 | 1312089 | 2021-05-12 | Erie | Ohio | 39043 | 7923 | 154 |
1254998 | 1254998 | 2021-04-25 | White | Arkansas | 5145 | 7923 | 118 |
1234075 | 1234075 | 2021-04-18 | Surry | North Carolina | 37171 | 7923 | 156 |
1230827 | 1230827 | 2021-04-17 | Surry | North Carolina | 37171 | 7923 | 156 |
1227579 | 1227579 | 2021-04-16 | Surry | North Carolina | 37171 | 7923 | 156 |
1222794 | 1222794 | 2021-04-15 | Glynn | Georgia | 13127 | 7923 | 170 |
943179 | 943179 | 2021-01-19 | Elmore | Alabama | 1051 | 7923 | 101 |
867328 | 867328 | 2020-12-26 | Allen | Ohio | 39003 | 7923 | 108 |
824911 | 824911 | 2020-12-13 | San Juan | New Mexico | 35045 | 7923 | 263 |
772368 | 772368 | 2020-11-27 | Howard | Maryland | 24027 | 7923 | 139 |
728893 | 728893 | 2020-11-13 | Kenosha | Wisconsin | 55059 | 7923 | 108 |
355595 | 355595 | 2020-07-21 | Camden | New Jersey | 34007 | 7923 | 560 |
352686 | 352686 | 2020-07-20 | Hamilton | Ohio | 39061 | 7923 | 219 |
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);