ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 10186 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 16
- Virginia 4
- Alabama 3
- Missouri 3
- New York 3
- Illinois 2
- Tennessee 2
- Texas 2
- Florida 1
- Kentucky 1
- Maryland 1
- Mississippi 1
- New Jersey 1
- New Mexico 1
- North Carolina 1
- Oregon 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2429817 | 2429817 | 2022-04-21 | Otsego | New York | 36077 | 10186 | 88 |
2372388 | 2372388 | 2022-04-03 | Tazewell | Virginia | 51185 | 10186 | 164 |
2369135 | 2369135 | 2022-04-02 | Tazewell | Virginia | 51185 | 10186 | 164 |
2365882 | 2365882 | 2022-04-01 | Tazewell | Virginia | 51185 | 10186 | 164 |
2268107 | 2268107 | 2022-03-02 | Van Zandt | Texas | 48467 | 10186 | 269 |
2185848 | 2185848 | 2022-02-05 | Tioga | New York | 36107 | 10186 | 81 |
2077286 | 2077286 | 2022-01-03 | Ogle | Illinois | 17141 | 10186 | 122 |
2056597 | 2056597 | 2021-12-27 | Hood | Texas | 48221 | 10186 | 215 |
2011248 | 2011248 | 2021-12-13 | Iron | Utah | 49021 | 10186 | 70 |
1876179 | 1876179 | 2021-11-02 | McCracken | Kentucky | 21145 | 10186 | 178 |
1809418 | 1809418 | 2021-10-12 | Dickson | Tennessee | 47043 | 10186 | 160 |
1565819 | 1565819 | 2021-07-29 | Robertson | Tennessee | 47147 | 10186 | 142 |
1459382 | 1459382 | 2021-06-27 | St. Clair | Alabama | 1115 | 10186 | 251 |
1456137 | 1456137 | 2021-06-26 | St. Clair | Alabama | 1115 | 10186 | 251 |
1452892 | 1452892 | 2021-06-25 | St. Clair | Alabama | 1115 | 10186 | 251 |
1373151 | 1373151 | 2021-05-31 | Madison | Mississippi | 28089 | 10186 | 224 |
1250562 | 1250562 | 2021-04-23 | Jackson | Oregon | 41029 | 10186 | 129 |
1230721 | 1230721 | 2021-04-17 | Putnam | New York | 36079 | 10186 | 91 |
1223552 | 1223552 | 2021-04-15 | Charles | Maryland | 24017 | 10186 | 181 |
1224181 | 1224181 | 2021-04-15 | Santa Fe | New Mexico | 35049 | 10186 | 144 |
1056432 | 1056432 | 2021-02-22 | Alexandria city | Virginia | 51510 | 10186 | 107 |
843197 | 843197 | 2020-12-19 | Kankakee | Illinois | 17091 | 10186 | 149 |
779581 | 779581 | 2020-11-29 | Gaston | North Carolina | 37071 | 10186 | 183 |
756470 | 756470 | 2020-11-22 | Jefferson | Missouri | 29099 | 10186 | 96 |
753224 | 753224 | 2020-11-21 | Jefferson | Missouri | 29099 | 10186 | 96 |
749978 | 749978 | 2020-11-20 | Jefferson | Missouri | 29099 | 10186 | 96 |
700146 | 700146 | 2020-11-05 | Sarasota | Florida | 12115 | 10186 | 348 |
365222 | 365222 | 2020-07-24 | Ocean | New Jersey | 34029 | 10186 | 1014 |
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);