ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where cases = 9462 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- North Carolina 8
- Colorado 3
- South Carolina 3
- Kansas 2
- Missouri 2
- Ohio 2
- Pennsylvania 2
- West Virginia 2
- Arkansas 1
- Indiana 1
- Maine 1
- Massachusetts 1
- Montana 1
- North Dakota 1
- Texas 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489916 | 2489916 | 2022-05-10 | Boone | Arkansas | 5009 | 9462 | 179 |
2331495 | 2331495 | 2022-03-22 | Somerset | Maine | 23025 | 9462 | 101 |
2240174 | 2240174 | 2022-02-22 | Harvey | Kansas | 20079 | 9462 | 117 |
2236923 | 2236923 | 2022-02-21 | Harvey | Kansas | 20079 | 9462 | 117 |
2233040 | 2233040 | 2022-02-20 | Summit | Colorado | 8117 | 9462 | 14 |
2229789 | 2229789 | 2022-02-19 | Summit | Colorado | 8117 | 9462 | 14 |
2232112 | 2232112 | 2022-02-19 | Anderson | Texas | 48001 | 9462 | 226 |
2226538 | 2226538 | 2022-02-18 | Summit | Colorado | 8117 | 9462 | 14 |
2172522 | 2172522 | 2022-02-01 | Phelps | Missouri | 29161 | 9462 | 214 |
2106629 | 2106629 | 2022-01-12 | Lawrence | Indiana | 18093 | 9462 | 219 |
2021233 | 2021233 | 2021-12-16 | Marion | West Virginia | 54049 | 9462 | 138 |
1964955 | 1964955 | 2021-11-29 | Jefferson | Ohio | 39081 | 9462 | 225 |
1896152 | 1896152 | 2021-11-08 | Lincoln | Missouri | 29113 | 9462 | 71 |
1878135 | 1878135 | 2021-11-02 | Rockingham | Virginia | 51165 | 9462 | 157 |
1799224 | 1799224 | 2021-10-09 | Lawrence | Ohio | 39087 | 9462 | 137 |
1611803 | 1611803 | 2021-08-12 | Cabell | West Virginia | 54011 | 9462 | 183 |
1532388 | 1532388 | 2021-07-19 | Missoula | Montana | 30063 | 9462 | 99 |
1461250 | 1461250 | 2021-06-27 | Craven | North Carolina | 37049 | 9462 | 126 |
1458005 | 1458005 | 2021-06-26 | Craven | North Carolina | 37049 | 9462 | 126 |
1454760 | 1454760 | 2021-06-25 | Craven | North Carolina | 37049 | 9462 | 126 |
1445024 | 1445024 | 2021-06-22 | Craven | North Carolina | 37049 | 9462 | 128 |
1441779 | 1441779 | 2021-06-21 | Craven | North Carolina | 37049 | 9462 | 128 |
1393081 | 1393081 | 2021-06-06 | Caldwell | North Carolina | 37027 | 9462 | 110 |
1389836 | 1389836 | 2021-06-05 | Caldwell | North Carolina | 37027 | 9462 | 110 |
1386591 | 1386591 | 2021-06-04 | Caldwell | North Carolina | 37027 | 9462 | 110 |
1094755 | 1094755 | 2021-03-06 | Lycoming | Pennsylvania | 42081 | 9462 | 249 |
1075435 | 1075435 | 2021-02-28 | Sumter | South Carolina | 45085 | 9462 | 174 |
928949 | 928949 | 2021-01-14 | Grand Forks | North Dakota | 38035 | 9462 | 70 |
896800 | 896800 | 2021-01-04 | Washington | Pennsylvania | 42125 | 9462 | 138 |
692493 | 692493 | 2020-11-02 | Spartanburg | South Carolina | 45083 | 9462 | 238 |
498037 | 498037 | 2020-09-03 | Horry | South Carolina | 45051 | 9462 | 187 |
326298 | 326298 | 2020-07-12 | Norfolk | Massachusetts | 25021 | 9462 | 958 |
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);