ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 101 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
542852 | 542852 | 2020-09-17 | Mitchell | North Carolina | 37121 | 101 | 3 |
539616 | 539616 | 2020-09-16 | Mitchell | North Carolina | 37121 | 101 | 3 |
536379 | 536379 | 2020-09-15 | Mitchell | North Carolina | 37121 | 101 | 3 |
516917 | 516917 | 2020-09-09 | Camden | North Carolina | 37029 | 101 | 3 |
516939 | 516939 | 2020-09-09 | Gates | North Carolina | 37073 | 101 | 3 |
513704 | 513704 | 2020-09-08 | Gates | North Carolina | 37073 | 101 | 3 |
510471 | 510471 | 2020-09-07 | Gates | North Carolina | 37073 | 101 | 3 |
507216 | 507216 | 2020-09-06 | Camden | North Carolina | 37029 | 101 | 3 |
503984 | 503984 | 2020-09-05 | Camden | North Carolina | 37029 | 101 | 3 |
500835 | 500835 | 2020-09-04 | Yancey | North Carolina | 37199 | 101 | 0 |
458788 | 458788 | 2020-08-22 | Perquimans | North Carolina | 37143 | 101 | 2 |
439440 | 439440 | 2020-08-16 | Tyrrell | North Carolina | 37177 | 101 | 2 |
436215 | 436215 | 2020-08-15 | Tyrrell | North Carolina | 37177 | 101 | 2 |
362201 | 362201 | 2020-07-23 | Transylvania | North Carolina | 37175 | 101 | 1 |
336578 | 336578 | 2020-07-15 | Polk | North Carolina | 37149 | 101 | 4 |
333384 | 333384 | 2020-07-14 | Polk | North Carolina | 37149 | 101 | 4 |
330194 | 330194 | 2020-07-13 | Polk | North Carolina | 37149 | 101 | 4 |
301564 | 301564 | 2020-07-04 | Carteret | North Carolina | 37031 | 101 | 3 |
295227 | 295227 | 2020-07-02 | Alexander | North Carolina | 37003 | 101 | 1 |
254489 | 254489 | 2020-06-19 | Stokes | North Carolina | 37169 | 101 | 0 |
248232 | 248232 | 2020-06-17 | Martin | North Carolina | 37117 | 101 | 4 |
245119 | 245119 | 2020-06-16 | Martin | North Carolina | 37117 | 101 | 4 |
235749 | 235749 | 2020-06-13 | Caswell | North Carolina | 37033 | 101 | 1 |
229539 | 229539 | 2020-06-11 | Caswell | North Carolina | 37033 | 101 | 1 |
223377 | 223377 | 2020-06-09 | McDowell | North Carolina | 37111 | 101 | 1 |
220283 | 220283 | 2020-06-08 | McDowell | North Carolina | 37111 | 101 | 1 |
214097 | 214097 | 2020-06-06 | Lincoln | North Carolina | 37109 | 101 | 0 |
195580 | 195580 | 2020-05-31 | Bladen | North Carolina | 37017 | 101 | 2 |
159099 | 159099 | 2020-05-19 | Surry | North Carolina | 37171 | 101 | 1 |
147002 | 147002 | 2020-05-15 | Halifax | North Carolina | 37083 | 101 | 1 |
134989 | 134989 | 2020-05-11 | Buncombe | North Carolina | 37021 | 101 | 4 |
117137 | 117137 | 2020-05-05 | Hoke | North Carolina | 37093 | 101 | 0 |
88601 | 88601 | 2020-04-25 | Lee | North Carolina | 37105 | 101 | 0 |
69043 | 69043 | 2020-04-18 | Chatham | North Carolina | 37037 | 101 | 0 |
52785 | 52785 | 2020-04-12 | Union | North Carolina | 37179 | 101 | 1 |
50112 | 50112 | 2020-04-11 | Union | North Carolina | 37179 | 101 | 1 |
16972 | 16972 | 2020-03-28 | Durham | North Carolina | 37063 | 101 | 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);