ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 121 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
607657 | 607657 | 2020-10-07 | Madison | North Carolina | 37115 | 121 | 1 |
601130 | 601130 | 2020-10-05 | Camden | North Carolina | 37029 | 121 | 3 |
549304 | 549304 | 2020-09-19 | Gates | North Carolina | 37073 | 121 | 3 |
507228 | 507228 | 2020-09-06 | Currituck | North Carolina | 37053 | 121 | 0 |
471639 | 471639 | 2020-08-26 | Avery | North Carolina | 37011 | 121 | 0 |
442665 | 442665 | 2020-08-17 | Swain | North Carolina | 37173 | 121 | 2 |
426536 | 426536 | 2020-08-12 | Swain | North Carolina | 37173 | 121 | 2 |
400779 | 400779 | 2020-08-04 | Washington | North Carolina | 37187 | 121 | 4 |
397564 | 397564 | 2020-08-03 | Washington | North Carolina | 37187 | 121 | 3 |
387908 | 387908 | 2020-07-31 | Transylvania | North Carolina | 37175 | 121 | 1 |
362188 | 362188 | 2020-07-23 | Polk | North Carolina | 37149 | 121 | 5 |
358982 | 358982 | 2020-07-22 | Polk | North Carolina | 37149 | 121 | 5 |
323764 | 323764 | 2020-07-11 | Carteret | North Carolina | 37031 | 121 | 3 |
279481 | 279481 | 2020-06-27 | Anson | North Carolina | 37007 | 121 | 1 |
276414 | 276414 | 2020-06-26 | Stokes | North Carolina | 37169 | 121 | 1 |
273241 | 273241 | 2020-06-25 | Martin | North Carolina | 37117 | 121 | 4 |
266927 | 266927 | 2020-06-23 | Caswell | North Carolina | 37033 | 121 | 1 |
229581 | 229581 | 2020-06-11 | McDowell | North Carolina | 37111 | 121 | 1 |
220247 | 220247 | 2020-06-08 | Cleveland | North Carolina | 37045 | 121 | 2 |
217155 | 217155 | 2020-06-07 | Cleveland | North Carolina | 37045 | 121 | 2 |
217188 | 217188 | 2020-06-07 | Macon | North Carolina | 37113 | 121 | 1 |
214109 | 214109 | 2020-06-06 | Onslow | North Carolina | 37133 | 121 | 2 |
204805 | 204805 | 2020-06-03 | Brunswick | North Carolina | 37019 | 121 | 5 |
201728 | 201728 | 2020-06-02 | Brunswick | North Carolina | 37019 | 121 | 5 |
162117 | 162117 | 2020-05-20 | Richmond | North Carolina | 37153 | 121 | 2 |
150002 | 150002 | 2020-05-16 | Franklin | North Carolina | 37069 | 121 | 20 |
146995 | 146995 | 2020-05-15 | Franklin | North Carolina | 37069 | 121 | 20 |
143994 | 143994 | 2020-05-14 | Franklin | North Carolina | 37069 | 121 | 20 |
135042 | 135042 | 2020-05-11 | Nash | North Carolina | 37127 | 121 | 3 |
108458 | 108458 | 2020-05-02 | Alamance | North Carolina | 37001 | 121 | 2 |
85776 | 85776 | 2020-04-24 | Granville | North Carolina | 37077 | 121 | 5 |
82983 | 82983 | 2020-04-23 | Johnston | North Carolina | 37101 | 121 | 10 |
80229 | 80229 | 2020-04-22 | Wilson | North Carolina | 37195 | 121 | 5 |
69073 | 69073 | 2020-04-18 | Johnston | North Carolina | 37101 | 121 | 9 |
58118 | 58118 | 2020-04-14 | Forsyth | North Carolina | 37067 | 121 | 4 |
15179 | 15179 | 2020-03-27 | Wake | North Carolina | 37183 | 121 | 0 |
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);