ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 9445 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Ohio 8
- Texas 5
- Kentucky 4
- North Dakota 3
- South Carolina 3
- Vermont 3
- Arkansas 2
- Missouri 2
- Washington 2
- California 1
- Colorado 1
- Florida 1
- Hawaii 1
- Idaho 1
- Illinois 1
- Nebraska 1
- New Jersey 1
- New York 1
- North Carolina 1
- Puerto Rico 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467114 | 2467114 | 2022-05-03 | Boone | Arkansas | 5009 | 9445 | 180 |
2454091 | 2454091 | 2022-04-29 | Boone | Arkansas | 5009 | 9445 | 180 |
2416764 | 2416764 | 2022-04-17 | Chenango | New York | 36017 | 9445 | 120 |
2403632 | 2403632 | 2022-04-13 | Scotts Bluff | Nebraska | 31157 | 9445 | 102 |
2358455 | 2358455 | 2022-03-30 | Preble | Ohio | 39135 | 9445 | 195 |
2355201 | 2355201 | 2022-03-29 | Preble | Ohio | 39135 | 9445 | 195 |
2351948 | 2351948 | 2022-03-28 | Preble | Ohio | 39135 | 9445 | 195 |
2348696 | 2348696 | 2022-03-27 | Preble | Ohio | 39135 | 9445 | 195 |
2345443 | 2345443 | 2022-03-26 | Preble | Ohio | 39135 | 9445 | 195 |
2342190 | 2342190 | 2022-03-25 | Preble | Ohio | 39135 | 9445 | 195 |
2338937 | 2338937 | 2022-03-24 | Preble | Ohio | 39135 | 9445 | 195 |
2326716 | 2326716 | 2022-03-20 | Washington | Vermont | 50023 | 9445 | 47 |
2323463 | 2323463 | 2022-03-19 | Washington | Vermont | 50023 | 9445 | 47 |
2320209 | 2320209 | 2022-03-18 | Washington | Vermont | 50023 | 9445 | 47 |
2304941 | 2304941 | 2022-03-14 | Monroe | Illinois | 17133 | 9445 | 127 |
2296901 | 2296901 | 2022-03-11 | Mayaguez | Puerto Rico | 72097 | 9445 | |
2222359 | 2222359 | 2022-02-16 | Anderson | Texas | 48001 | 9445 | 225 |
2216785 | 2216785 | 2022-02-15 | Summit | Colorado | 8117 | 9445 | 14 |
2189634 | 2189634 | 2022-02-06 | Chester | South Carolina | 45023 | 9445 | 132 |
2186381 | 2186381 | 2022-02-05 | Chester | South Carolina | 45023 | 9445 | 132 |
2183129 | 2183129 | 2022-02-04 | Chester | South Carolina | 45023 | 9445 | 132 |
2166016 | 2166016 | 2022-01-30 | Platte | Missouri | 29165 | 9445 | 83 |
2161734 | 2161734 | 2022-01-29 | Kauai | Hawaii | 15007 | 9445 | 22 |
2146972 | 2146972 | 2022-01-24 | Williams | North Dakota | 38105 | 9445 | 66 |
2143718 | 2143718 | 2022-01-23 | Williams | North Dakota | 38105 | 9445 | 66 |
2138022 | 2138022 | 2022-01-21 | Wilson | Texas | 48493 | 9445 | 148 |
2120920 | 2120920 | 2022-01-16 | Morton | North Dakota | 38059 | 9445 | 134 |
1990458 | 1990458 | 2021-12-07 | Taney | Missouri | 29213 | 9445 | 173 |
1893436 | 1893436 | 2021-11-07 | Geauga | Ohio | 39055 | 9445 | 162 |
1736482 | 1736482 | 2021-09-20 | Oldham | Kentucky | 21185 | 9445 | 88 |
1696129 | 1696129 | 2021-09-07 | Frederick | Virginia | 51069 | 9445 | 107 |
1628745 | 1628745 | 2021-08-18 | Bannock | Idaho | 16005 | 9445 | 122 |
1568261 | 1568261 | 2021-07-30 | Cape May | New Jersey | 34009 | 9445 | 209 |
1540367 | 1540367 | 2021-07-21 | Monongalia | West Virginia | 54061 | 9445 | 91 |
1380100 | 1380100 | 2021-06-02 | Caldwell | North Carolina | 37027 | 9445 | 110 |
1376011 | 1376011 | 2021-06-01 | Madison | Kentucky | 21151 | 9445 | 111 |
1326477 | 1326477 | 2021-05-17 | Sutter | California | 6101 | 9445 | 113 |
1313099 | 1313099 | 2021-05-12 | Thurston | Washington | 53067 | 9445 | 103 |
1226636 | 1226636 | 2021-04-16 | Hardin | Kentucky | 21093 | 9445 | 149 |
1196180 | 1196180 | 2021-04-06 | Grant | Washington | 53025 | 9445 | 114 |
712305 | 712305 | 2020-11-08 | Potter | Texas | 48375 | 9445 | 121 |
709061 | 709061 | 2020-11-07 | Potter | Texas | 48375 | 9445 | 121 |
703392 | 703392 | 2020-11-06 | St. Lucie | Florida | 12111 | 9445 | 339 |
705817 | 705817 | 2020-11-06 | Potter | Texas | 48375 | 9445 | 121 |
626184 | 626184 | 2020-10-13 | Fayette | Kentucky | 21067 | 9445 | 84 |
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);