ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 19022 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- Louisiana 2
- Maryland 2
- North Dakota 2
- Ohio 2
- South Carolina 2
- Florida 1
- Massachusetts 1
- North Carolina 1
- Pennsylvania 1
- Texas 1
- Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489597 | 2489597 | 2022-05-09 | Suffolk city | Virginia | 51800 | 19022 | 302 |
2489714 | 2489714 | 2022-05-09 | Chippewa | Wisconsin | 55017 | 19022 | 186 |
2469307 | 2469307 | 2022-05-03 | Lawrence | Pennsylvania | 42073 | 19022 | 416 |
2448689 | 2448689 | 2022-04-27 | St. Mary's | Maryland | 24037 | 19022 | 213 |
2215219 | 2215219 | 2022-02-14 | Stanly | North Carolina | 37167 | 19022 | 241 |
2179532 | 2179532 | 2022-02-03 | Erie | Ohio | 39043 | 19022 | 241 |
2146936 | 2146936 | 2022-01-24 | Grand Forks | North Dakota | 38035 | 19022 | 110 |
2143682 | 2143682 | 2022-01-23 | Grand Forks | North Dakota | 38035 | 19022 | 110 |
1762554 | 1762554 | 2021-09-28 | Terrebonne | Louisiana | 22109 | 19022 | 309 |
1714757 | 1714757 | 2021-09-13 | Medina | Ohio | 39103 | 19022 | 283 |
1674823 | 1674823 | 2021-09-01 | Rapides | Louisiana | 22079 | 19022 | 391 |
1380636 | 1380636 | 2021-06-02 | Pickens | South Carolina | 45077 | 19022 | 301 |
1298236 | 1298236 | 2021-05-08 | Howard | Maryland | 24027 | 19022 | 233 |
1199103 | 1199103 | 2021-04-07 | Jefferson | Texas | 48245 | 19022 | 403 |
867706 | 867706 | 2020-12-26 | Horry | South Carolina | 45051 | 19022 | 306 |
846124 | 846124 | 2020-12-20 | Brevard | Florida | 12009 | 19022 | 501 |
548599 | 548599 | 2020-09-19 | Essex | Massachusetts | 25009 | 19022 | 1266 |
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);