ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 11430 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 15
- Tennessee 9
- Illinois 4
- Indiana 4
- New Mexico 3
- Pennsylvania 2
- Texas 2
- Alabama 1
- Arkansas 1
- Kentucky 1
- Maryland 1
- New Jersey 1
- New York 1
- Ohio 1
- South Carolina 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446766 | 2446766 | 2022-04-26 | Fayette | Tennessee | 47047 | 11430 | 185 |
2443511 | 2443511 | 2022-04-25 | Fayette | Tennessee | 47047 | 11430 | 185 |
2440255 | 2440255 | 2022-04-24 | Fayette | Tennessee | 47047 | 11430 | 185 |
2436999 | 2436999 | 2022-04-23 | Fayette | Tennessee | 47047 | 11430 | 185 |
2433743 | 2433743 | 2022-04-22 | Fayette | Tennessee | 47047 | 11430 | 185 |
2430487 | 2430487 | 2022-04-21 | Fayette | Tennessee | 47047 | 11430 | 185 |
2427231 | 2427231 | 2022-04-20 | Fayette | Tennessee | 47047 | 11430 | 185 |
2291955 | 2291955 | 2022-03-10 | Stephenson | Illinois | 17177 | 11430 | 173 |
2277302 | 2277302 | 2022-03-05 | Huntingdon | Pennsylvania | 42061 | 11430 | 240 |
2256232 | 2256232 | 2022-02-27 | Huntington | Indiana | 18069 | 11430 | 152 |
2252981 | 2252981 | 2022-02-26 | Huntington | Indiana | 18069 | 11430 | 152 |
2249730 | 2249730 | 2022-02-25 | Huntington | Indiana | 18069 | 11430 | 152 |
2193120 | 2193120 | 2022-02-07 | Chambers | Texas | 48071 | 11430 | 106 |
2187863 | 2187863 | 2022-02-06 | Marion | Illinois | 17121 | 11430 | 198 |
2184610 | 2184610 | 2022-02-05 | Marion | Illinois | 17121 | 11430 | 198 |
2181358 | 2181358 | 2022-02-04 | Marion | Illinois | 17121 | 11430 | 198 |
2084329 | 2084329 | 2022-01-05 | Cecil | Maryland | 24015 | 11430 | 211 |
2079869 | 2079869 | 2022-01-04 | Blount | Alabama | 1009 | 11430 | 198 |
2035443 | 2035443 | 2021-12-21 | McCracken | Kentucky | 21145 | 11430 | 202 |
1945892 | 1945892 | 2021-11-23 | Cumberland | Tennessee | 47035 | 11430 | 227 |
1887720 | 1887720 | 2021-11-05 | Wise | Texas | 48497 | 11430 | 201 |
1856398 | 1856398 | 2021-10-27 | Wayne | Indiana | 18177 | 11430 | 260 |
1758033 | 1758033 | 2021-09-26 | Wood | West Virginia | 54107 | 11430 | 203 |
1325123 | 1325123 | 2021-05-16 | Richland | Ohio | 39139 | 11430 | 199 |
1188450 | 1188450 | 2021-04-04 | Sandoval | New Mexico | 35043 | 11430 | 220 |
1185203 | 1185203 | 2021-04-03 | Sandoval | New Mexico | 35043 | 11430 | 220 |
1181956 | 1181956 | 2021-04-02 | Sandoval | New Mexico | 35043 | 11430 | 220 |
1146284 | 1146284 | 2021-03-22 | Schenectady | New York | 36093 | 11430 | 186 |
1076396 | 1076396 | 2021-03-01 | Saline | Arkansas | 5125 | 11430 | 154 |
1013916 | 1013916 | 2021-02-09 | Sevier | Tennessee | 47155 | 11430 | 149 |
990867 | 990867 | 2021-02-02 | Centre | Pennsylvania | 42027 | 11430 | 193 |
932593 | 932593 | 2021-01-15 | Beaufort | South Carolina | 45013 | 11430 | 122 |
737252 | 737252 | 2020-11-16 | Morris | New Jersey | 34027 | 11430 | 850 |
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);