ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49 rows where cases = 7866 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Iowa 7
- Kentucky 7
- Indiana 4
- Utah 4
- Arkansas 3
- Georgia 3
- Illinois 3
- Virginia 3
- California 2
- North Carolina 2
- Ohio 2
- South Carolina 2
- Alabama 1
- Alaska 1
- Idaho 1
- Louisiana 1
- Michigan 1
- New Jersey 1
- New York 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490654 | 2490654 | 2022-05-10 | Lee | Iowa | 19111 | 7866 | 142 |
2487397 | 2487397 | 2022-05-09 | Lee | Iowa | 19111 | 7866 | 142 |
2484139 | 2484139 | 2022-05-08 | Lee | Iowa | 19111 | 7866 | 142 |
2484315 | 2484315 | 2022-05-08 | Clay | Kentucky | 21051 | 7866 | 92 |
2480881 | 2480881 | 2022-05-07 | Lee | Iowa | 19111 | 7866 | 142 |
2481057 | 2481057 | 2022-05-07 | Clay | Kentucky | 21051 | 7866 | 92 |
2477623 | 2477623 | 2022-05-06 | Lee | Iowa | 19111 | 7866 | 142 |
2477799 | 2477799 | 2022-05-06 | Clay | Kentucky | 21051 | 7866 | 92 |
2474365 | 2474365 | 2022-05-05 | Lee | Iowa | 19111 | 7866 | 142 |
2474541 | 2474541 | 2022-05-05 | Clay | Kentucky | 21051 | 7866 | 92 |
2471108 | 2471108 | 2022-05-04 | Lee | Iowa | 19111 | 7866 | 142 |
2471284 | 2471284 | 2022-05-04 | Clay | Kentucky | 21051 | 7866 | 92 |
2468028 | 2468028 | 2022-05-03 | Clay | Kentucky | 21051 | 7866 | 92 |
2464773 | 2464773 | 2022-05-02 | Clay | Kentucky | 21051 | 7866 | 92 |
2396054 | 2396054 | 2022-04-11 | Saline | Illinois | 17165 | 7866 | 109 |
2376963 | 2376963 | 2022-04-05 | Allen | Louisiana | 22003 | 7866 | 137 |
2281676 | 2281676 | 2022-03-07 | Poinsett | Arkansas | 5111 | 7866 | 121 |
2228313 | 2228313 | 2022-02-18 | Coshocton | Ohio | 39031 | 7866 | 144 |
2054620 | 2054620 | 2021-12-27 | Montgomery | Indiana | 18107 | 7866 | 129 |
2053513 | 2053513 | 2021-12-26 | Summit | Utah | 49043 | 7866 | 19 |
2050263 | 2050263 | 2021-12-25 | Summit | Utah | 49043 | 7866 | 19 |
2047013 | 2047013 | 2021-12-24 | Summit | Utah | 49043 | 7866 | 19 |
2043763 | 2043763 | 2021-12-23 | Summit | Utah | 49043 | 7866 | 19 |
2011748 | 2011748 | 2021-12-14 | Hot Spring | Arkansas | 5059 | 7866 | 112 |
1992842 | 1992842 | 2021-12-08 | Huntington | Indiana | 18069 | 7866 | 121 |
1989481 | 1989481 | 2021-12-07 | Franklin | Illinois | 17055 | 7866 | 136 |
1966344 | 1966344 | 2021-11-30 | Tuolumne | California | 6109 | 7866 | 141 |
1921120 | 1921120 | 2021-11-16 | Thomas | Georgia | 13275 | 7866 | 182 |
1660687 | 1660687 | 2021-08-28 | Coffee | Alabama | 1031 | 7866 | 145 |
1607333 | 1607333 | 2021-08-11 | Oswego | New York | 36075 | 7866 | 93 |
1488688 | 1488688 | 2021-07-06 | Lonoke | Arkansas | 5085 | 7866 | 127 |
1489261 | 1489261 | 2021-07-06 | Floyd | Indiana | 18043 | 7866 | 185 |
1424134 | 1424134 | 2021-06-16 | Rockdale | Georgia | 13247 | 7866 | 175 |
1417641 | 1417641 | 2021-06-14 | Rockdale | Georgia | 13247 | 7866 | 174 |
1342227 | 1342227 | 2021-05-21 | Lynchburg city | Virginia | 51680 | 7866 | 151 |
1337968 | 1337968 | 2021-05-20 | Stanly | North Carolina | 37167 | 7866 | 134 |
1326315 | 1326315 | 2021-05-17 | Fairbanks North Star Borough | Alaska | 2090 | 7866 | 43 |
1293573 | 1293573 | 2021-05-06 | Suffolk city | Virginia | 51800 | 7866 | 187 |
1199390 | 1199390 | 2021-04-07 | Roanoke | Virginia | 51161 | 7866 | 132 |
1061964 | 1061964 | 2021-02-24 | Moore | North Carolina | 37125 | 7866 | 172 |
1023122 | 1023122 | 2021-02-12 | Columbiana | Ohio | 39029 | 7866 | 163 |
1010518 | 1010518 | 2021-02-08 | Oconee | South Carolina | 45073 | 7866 | 108 |
875600 | 875600 | 2020-12-29 | Twin Falls | Idaho | 16083 | 7866 | 114 |
823861 | 823861 | 2020-12-13 | Vigo | Indiana | 18167 | 7866 | 128 |
727038 | 727038 | 2020-11-13 | Washtenaw | Michigan | 26161 | 7866 | 133 |
710107 | 710107 | 2020-11-08 | Champaign | Illinois | 17019 | 7866 | 33 |
643171 | 643171 | 2020-10-18 | Burlington | New Jersey | 34005 | 7866 | 506 |
391585 | 391585 | 2020-08-01 | Richland | South Carolina | 45079 | 7866 | 133 |
325258 | 325258 | 2020-07-12 | Alameda | California | 6001 | 7866 | 148 |
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);