ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
11 rows where cases = 466 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 10
state 1
- North Carolina · 11 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
601132 | 601132 | 2020-10-05 | Caswell | North Carolina | 37033 | 466 | 5 |
601188 | 601188 | 2020-10-05 | Person | North Carolina | 37145 | 466 | 8 |
584965 | 584965 | 2020-09-30 | Martin | North Carolina | 37117 | 466 | 9 |
497521 | 497521 | 2020-09-03 | Cherokee | North Carolina | 37039 | 466 | 5 |
478116 | 478116 | 2020-08-28 | Carteret | North Carolina | 37031 | 466 | 5 |
358969 | 358969 | 2020-07-22 | Montgomery | North Carolina | 37123 | 466 | 11 |
279487 | 279487 | 2020-06-27 | Brunswick | North Carolina | 37019 | 466 | 6 |
201771 | 201771 | 2020-06-02 | Lee | North Carolina | 37105 | 466 | 4 |
201808 | 201808 | 2020-06-02 | Union | North Carolina | 37179 | 466 | 21 |
198695 | 198695 | 2020-06-01 | Johnston | North Carolina | 37101 | 466 | 21 |
198734 | 198734 | 2020-06-01 | Union | North Carolina | 37179 | 466 | 21 |
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);