ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 8167 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Texas 5
- Mississippi 3
- Nebraska 3
- New York 3
- Pennsylvania 3
- Tennessee 3
- Alabama 2
- Arkansas 2
- Missouri 2
- Washington 2
- Florida 1
- Georgia 1
- Guam 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Minnesota 1
- New Jersey 1
- North Carolina 1
- North Dakota 1
- South Carolina 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447307 | 2447307 | 2022-04-26 | Stevens | Washington | 53065 | 8167 | 146 |
2444051 | 2444051 | 2022-04-25 | Stevens | Washington | 53065 | 8167 | 146 |
2361886 | 2361886 | 2022-03-31 | McKean | Pennsylvania | 42083 | 8167 | 138 |
2279731 | 2279731 | 2022-03-06 | Prentiss | Mississippi | 28117 | 8167 | 103 |
2276478 | 2276478 | 2022-03-05 | Prentiss | Mississippi | 28117 | 8167 | 103 |
2273225 | 2273225 | 2022-03-04 | Prentiss | Mississippi | 28117 | 8167 | 103 |
2267529 | 2267529 | 2022-03-02 | Clarion | Pennsylvania | 42031 | 8167 | 197 |
2211719 | 2211719 | 2022-02-13 | Platte | Nebraska | 31141 | 8167 | 70 |
2208466 | 2208466 | 2022-02-12 | Platte | Nebraska | 31141 | 8167 | 70 |
2205213 | 2205213 | 2022-02-11 | Platte | Nebraska | 31141 | 8167 | 70 |
2176062 | 2176062 | 2022-02-02 | Greene | New York | 36039 | 8167 | 112 |
2155768 | 2155768 | 2022-01-27 | Perry | Kentucky | 21193 | 8167 | 138 |
1987174 | 1987174 | 2021-12-06 | Newton | Missouri | 29145 | 8167 | 168 |
1946171 | 1946171 | 2021-11-23 | Rusk | Texas | 48401 | 8167 | 188 |
1910420 | 1910420 | 2021-11-12 | Rusk | Texas | 48401 | 8167 | 183 |
1890146 | 1890146 | 2021-11-06 | Stark | North Dakota | 38089 | 8167 | 70 |
1838010 | 1838010 | 2021-10-21 | Wayne | New York | 36117 | 8167 | 84 |
1815286 | 1815286 | 2021-10-14 | Carteret | North Carolina | 37031 | 8167 | 81 |
1765154 | 1765154 | 2021-09-29 | Tift | Georgia | 13277 | 8167 | 162 |
1723561 | 1723561 | 2021-09-16 | St. Mary | Louisiana | 22101 | 8167 | 204 |
1711976 | 1711976 | 2021-09-12 | Lawrence | Tennessee | 47099 | 8167 | 106 |
1708729 | 1708729 | 2021-09-11 | Lawrence | Tennessee | 47099 | 8167 | 106 |
1705482 | 1705482 | 2021-09-10 | Lawrence | Tennessee | 47099 | 8167 | 106 |
1662220 | 1662220 | 2021-08-28 | Joplin | Missouri | 8167 | 136 | |
1656028 | 1656028 | 2021-08-26 | Chemung | New York | 36015 | 8167 | 138 |
1465981 | 1465981 | 2021-06-29 | Pope | Arkansas | 5115 | 8167 | 111 |
1324333 | 1324333 | 2021-05-16 | Clay | Minnesota | 27027 | 8167 | 92 |
1271110 | 1271110 | 2021-04-30 | Talladega | Alabama | 1121 | 8167 | 175 |
1238928 | 1238928 | 2021-04-20 | Highlands | Florida | 12055 | 8167 | 338 |
1168924 | 1168924 | 2021-03-29 | Cape May | New Jersey | 34009 | 8167 | 193 |
969252 | 969252 | 2021-01-27 | Garland | Arkansas | 5051 | 8167 | 199 |
913982 | 913982 | 2021-01-10 | Houston | Alabama | 1069 | 8167 | 72 |
843102 | 843102 | 2020-12-19 | Unknown | Guam | 8167 | 120 | |
786549 | 786549 | 2020-12-01 | Anderson | South Carolina | 45007 | 8167 | 229 |
724770 | 724770 | 2020-11-12 | Lehigh | Pennsylvania | 42077 | 8167 | 372 |
644020 | 644020 | 2020-10-18 | Brazos | Texas | 48041 | 8167 | 65 |
640772 | 640772 | 2020-10-17 | Brazos | Texas | 48041 | 8167 | 65 |
637525 | 637525 | 2020-10-16 | Brazos | Texas | 48041 | 8167 | 65 |
316729 | 316729 | 2020-07-09 | Baltimore city | Maryland | 24510 | 8167 | 358 |
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);