ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
31 rows where cases = 116 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 19
county 19
- Tyrrell 8
- Yancey 3
- Camden 2
- Madison 2
- Watauga 2
- Avery 1
- Buncombe 1
- Caswell 1
- Cherokee 1
- Clay 1
- Currituck 1
- Greene 1
- Moore 1
- Nash 1
- New Hanover 1
- Rockingham 1
- Rutherford 1
- Transylvania 1
- Wilson 1
state 1
- North Carolina · 31 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
604446 | 604446 | 2020-10-06 | Tyrrell | North Carolina | 37177 | 116 | 3 |
601204 | 601204 | 2020-10-05 | Tyrrell | North Carolina | 37177 | 116 | 3 |
597929 | 597929 | 2020-10-04 | Madison | North Carolina | 37115 | 116 | 1 |
594686 | 594686 | 2020-10-03 | Madison | North Carolina | 37115 | 116 | 1 |
588162 | 588162 | 2020-10-01 | Camden | North Carolina | 37029 | 116 | 3 |
588236 | 588236 | 2020-10-01 | Tyrrell | North Carolina | 37177 | 116 | 3 |
584922 | 584922 | 2020-09-30 | Camden | North Carolina | 37029 | 116 | 3 |
584996 | 584996 | 2020-09-30 | Tyrrell | North Carolina | 37177 | 116 | 3 |
581755 | 581755 | 2020-09-29 | Tyrrell | North Carolina | 37177 | 116 | 3 |
575274 | 575274 | 2020-09-27 | Tyrrell | North Carolina | 37177 | 116 | 3 |
572030 | 572030 | 2020-09-26 | Tyrrell | North Carolina | 37177 | 116 | 3 |
568721 | 568721 | 2020-09-25 | Clay | North Carolina | 37043 | 116 | 2 |
568788 | 568788 | 2020-09-25 | Tyrrell | North Carolina | 37177 | 116 | 3 |
539655 | 539655 | 2020-09-16 | Yancey | North Carolina | 37199 | 116 | 0 |
536418 | 536418 | 2020-09-15 | Yancey | North Carolina | 37199 | 116 | 0 |
533182 | 533182 | 2020-09-14 | Yancey | North Carolina | 37199 | 116 | 0 |
500762 | 500762 | 2020-09-04 | Currituck | North Carolina | 37053 | 116 | 0 |
455494 | 455494 | 2020-08-21 | Avery | North Carolina | 37011 | 116 | 0 |
384691 | 384691 | 2020-07-30 | Transylvania | North Carolina | 37175 | 116 | 1 |
346116 | 346116 | 2020-07-18 | Cherokee | North Carolina | 37039 | 116 | 2 |
323843 | 323843 | 2020-07-11 | Watauga | North Carolina | 37189 | 116 | 0 |
320663 | 320663 | 2020-07-10 | Watauga | North Carolina | 37189 | 116 | 0 |
260671 | 260671 | 2020-06-21 | Caswell | North Carolina | 37033 | 116 | 1 |
235772 | 235772 | 2020-06-13 | Greene | North Carolina | 37079 | 116 | 2 |
220303 | 220303 | 2020-06-08 | Rockingham | North Carolina | 37157 | 116 | 2 |
153040 | 153040 | 2020-05-17 | Moore | North Carolina | 37125 | 116 | 10 |
143970 | 143970 | 2020-05-14 | Buncombe | North Carolina | 37021 | 116 | 4 |
144024 | 144024 | 2020-05-14 | New Hanover | North Carolina | 37129 | 116 | 3 |
126073 | 126073 | 2020-05-08 | Nash | North Carolina | 37127 | 116 | 3 |
91444 | 91444 | 2020-04-26 | Rutherford | North Carolina | 37161 | 116 | 6 |
74659 | 74659 | 2020-04-20 | Wilson | North Carolina | 37195 | 116 | 4 |
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);