ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 10021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- North Carolina 7
- Washington 5
- Kansas 4
- Arkansas 3
- Illinois 3
- New Jersey 3
- Alabama 2
- Georgia 2
- Pennsylvania 2
- Texas 2
- Hawaii 1
- Kentucky 1
- Maine 1
- Missouri 1
- Nebraska 1
- New York 1
- North Dakota 1
- Ohio 1
- Tennessee 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446200 | 2446200 | 2022-04-26 | Scotland | North Carolina | 37165 | 10021 | 126 |
2442945 | 2442945 | 2022-04-25 | Scotland | North Carolina | 37165 | 10021 | 126 |
2439689 | 2439689 | 2022-04-24 | Scotland | North Carolina | 37165 | 10021 | 126 |
2436433 | 2436433 | 2022-04-23 | Scotland | North Carolina | 37165 | 10021 | 126 |
2433177 | 2433177 | 2022-04-22 | Scotland | North Carolina | 37165 | 10021 | 126 |
2429921 | 2429921 | 2022-04-21 | Scotland | North Carolina | 37165 | 10021 | 126 |
2426665 | 2426665 | 2022-04-20 | Scotland | North Carolina | 37165 | 10021 | 126 |
2401706 | 2401706 | 2022-04-12 | Island | Washington | 53029 | 10021 | 75 |
2398451 | 2398451 | 2022-04-11 | Island | Washington | 53029 | 10021 | 75 |
2395196 | 2395196 | 2022-04-10 | Island | Washington | 53029 | 10021 | 75 |
2391940 | 2391940 | 2022-04-09 | Island | Washington | 53029 | 10021 | 75 |
2388684 | 2388684 | 2022-04-08 | Island | Washington | 53029 | 10021 | 75 |
2332616 | 2332616 | 2022-03-22 | Pike | Pennsylvania | 42103 | 10021 | 95 |
2327100 | 2327100 | 2022-03-21 | Russell | Alabama | 1113 | 10021 | 84 |
2286342 | 2286342 | 2022-03-08 | Phelps | Missouri | 29161 | 10021 | 234 |
2169779 | 2169779 | 2022-01-31 | Fulton | Ohio | 39051 | 10021 | 161 |
2132810 | 2132810 | 2022-01-20 | Crawford | Kansas | 20037 | 10021 | 122 |
2129557 | 2129557 | 2022-01-19 | Crawford | Kansas | 20037 | 10021 | 122 |
2062169 | 2062169 | 2021-12-29 | Salem | New Jersey | 34033 | 10021 | 215 |
1895152 | 1895152 | 2021-11-08 | Maui | Hawaii | 15009 | 10021 | 98 |
1861455 | 1861455 | 2021-10-28 | Roane | Tennessee | 47145 | 10021 | 153 |
1785072 | 1785072 | 2021-10-05 | Leavenworth | Kansas | 20103 | 10021 | 118 |
1781823 | 1781823 | 2021-10-04 | Leavenworth | Kansas | 20103 | 10021 | 118 |
1763261 | 1763261 | 2021-09-28 | Oswego | New York | 36075 | 10021 | 104 |
1663441 | 1663441 | 2021-08-28 | Liberty | Texas | 48291 | 10021 | 234 |
1631586 | 1631586 | 2021-08-19 | Lonoke | Arkansas | 5085 | 10021 | 145 |
1607716 | 1607716 | 2021-08-11 | Adams | Pennsylvania | 42001 | 10021 | 190 |
1555275 | 1555275 | 2021-07-26 | Hunterdon | New Jersey | 34019 | 10021 | 177 |
1513315 | 1513315 | 2021-07-13 | Ward | North Dakota | 38101 | 10021 | 200 |
1457889 | 1457889 | 2021-06-26 | Warren | New Jersey | 34041 | 10021 | 237 |
1453301 | 1453301 | 2021-06-25 | Jackson | Georgia | 13157 | 10021 | 151 |
1437298 | 1437298 | 2021-06-20 | Vermilion | Illinois | 17183 | 10021 | 159 |
1434051 | 1434051 | 2021-06-19 | Vermilion | Illinois | 17183 | 10021 | 159 |
1430805 | 1430805 | 2021-06-18 | Vermilion | Illinois | 17183 | 10021 | 159 |
1358768 | 1358768 | 2021-05-27 | St. Clair | Alabama | 1115 | 10021 | 247 |
1164016 | 1164016 | 2021-03-28 | Garland | Arkansas | 5051 | 10021 | 254 |
1160768 | 1160768 | 2021-03-27 | Garland | Arkansas | 5051 | 10021 | 253 |
1145427 | 1145427 | 2021-03-22 | Daviess | Kentucky | 21059 | 10021 | 173 |
1126118 | 1126118 | 2021-03-16 | York | Maine | 23031 | 10021 | 125 |
780637 | 780637 | 2020-11-29 | Loudoun | Virginia | 51107 | 10021 | 142 |
750178 | 750178 | 2020-11-20 | Sarpy | Nebraska | 31153 | 10021 | 55 |
420797 | 420797 | 2020-08-10 | Fort Bend | Texas | 48157 | 10021 | 162 |
319157 | 319157 | 2020-07-10 | Fulton | Georgia | 13121 | 10021 | 321 |
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);