ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 224 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
792562 | 792562 | 2020-12-03 | Gates | North Carolina | 37073 | 224 | 7 |
740648 | 740648 | 2020-11-17 | Jones | North Carolina | 37103 | 224 | 15 |
682236 | 682236 | 2020-10-30 | Currituck | North Carolina | 37053 | 224 | 4 |
678993 | 678993 | 2020-10-29 | Currituck | North Carolina | 37053 | 224 | 4 |
675750 | 675750 | 2020-10-28 | Currituck | North Carolina | 37053 | 224 | 4 |
614177 | 614177 | 2020-10-09 | Washington | North Carolina | 37187 | 224 | 8 |
610942 | 610942 | 2020-10-08 | Yancey | North Carolina | 37199 | 224 | 0 |
607700 | 607700 | 2020-10-07 | Yancey | North Carolina | 37199 | 224 | 0 |
565461 | 565461 | 2020-09-24 | Alleghany | North Carolina | 37005 | 224 | 0 |
542860 | 542860 | 2020-09-17 | Pamlico | North Carolina | 37137 | 224 | 2 |
539624 | 539624 | 2020-09-16 | Pamlico | North Carolina | 37137 | 224 | 2 |
513673 | 513673 | 2020-09-08 | Avery | North Carolina | 37011 | 224 | 0 |
510440 | 510440 | 2020-09-07 | Avery | North Carolina | 37011 | 224 | 0 |
362120 | 362120 | 2020-07-23 | Beaufort | North Carolina | 37013 | 224 | 0 |
270111 | 270111 | 2020-06-24 | Onslow | North Carolina | 37133 | 224 | 3 |
229564 | 229564 | 2020-06-11 | Halifax | North Carolina | 37083 | 224 | 1 |
201804 | 201804 | 2020-06-02 | Surry | North Carolina | 37171 | 224 | 2 |
129043 | 129043 | 2020-05-09 | Henderson | North Carolina | 37089 | 224 | 27 |
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);