ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
171 rows where cases = 8 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Watauga 27
- Pamlico 16
- Perquimans 10
- Avery 7
- Cherokee 7
- Mitchell 7
- Jones 6
- Yancey 6
- Person 5
- Polk 5
- Stokes 5
- Clay 4
- Moore 4
- Stanly 4
- Transylvania 4
- Alleghany 3
- Beaufort 3
- McDowell 3
- Pasquotank 3
- Tyrrell 3
- Alexander 2
- Caswell 2
- Graham 2
- Martin 2
- Montgomery 2
- Robeson 2
- Rockingham 2
- Ashe 1
- Brunswick 1
- Cabarrus 1
- …
state 1
- North Carolina · 171 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282712 | 282712 | 2020-06-28 | Tyrrell | North Carolina | 37177 | 8 | 0 |
279566 | 279566 | 2020-06-27 | Tyrrell | North Carolina | 37177 | 8 | 0 |
276335 | 276335 | 2020-06-26 | Avery | North Carolina | 37011 | 8 | 0 |
276418 | 276418 | 2020-06-26 | Tyrrell | North Carolina | 37177 | 8 | 0 |
273189 | 273189 | 2020-06-25 | Avery | North Carolina | 37011 | 8 | 0 |
273221 | 273221 | 2020-06-25 | Graham | North Carolina | 37075 | 8 | 0 |
270050 | 270050 | 2020-06-24 | Avery | North Carolina | 37011 | 8 | 0 |
270082 | 270082 | 2020-06-24 | Graham | North Carolina | 37075 | 8 | 0 |
270101 | 270101 | 2020-06-24 | Madison | North Carolina | 37115 | 8 | 0 |
266916 | 266916 | 2020-06-23 | Avery | North Carolina | 37011 | 8 | 0 |
263788 | 263788 | 2020-06-22 | Avery | North Carolina | 37011 | 8 | 0 |
260660 | 260660 | 2020-06-21 | Avery | North Carolina | 37011 | 8 | 0 |
254410 | 254410 | 2020-06-19 | Avery | North Carolina | 37011 | 8 | 0 |
232649 | 232649 | 2020-06-12 | Clay | North Carolina | 37043 | 8 | 0 |
229544 | 229544 | 2020-06-11 | Clay | North Carolina | 37043 | 8 | 0 |
226440 | 226440 | 2020-06-10 | Clay | North Carolina | 37043 | 8 | 0 |
223340 | 223340 | 2020-06-09 | Clay | North Carolina | 37043 | 8 | 0 |
174246 | 174246 | 2020-05-24 | Mitchell | North Carolina | 37121 | 8 | 0 |
171199 | 171199 | 2020-05-23 | Macon | North Carolina | 37113 | 8 | 1 |
171204 | 171204 | 2020-05-23 | Mitchell | North Carolina | 37121 | 8 | 0 |
165156 | 165156 | 2020-05-21 | Swain | North Carolina | 37173 | 8 | 0 |
162101 | 162101 | 2020-05-20 | Mitchell | North Carolina | 37121 | 8 | 0 |
162128 | 162128 | 2020-05-20 | Transylvania | North Carolina | 37175 | 8 | 0 |
159074 | 159074 | 2020-05-19 | Mitchell | North Carolina | 37121 | 8 | 0 |
159101 | 159101 | 2020-05-19 | Transylvania | North Carolina | 37175 | 8 | 0 |
156055 | 156055 | 2020-05-18 | Mitchell | North Carolina | 37121 | 8 | 0 |
153038 | 153038 | 2020-05-17 | Mitchell | North Carolina | 37121 | 8 | 0 |
153046 | 153046 | 2020-05-17 | Pamlico | North Carolina | 37137 | 8 | 0 |
153077 | 153077 | 2020-05-17 | Yancey | North Carolina | 37199 | 8 | 0 |
150028 | 150028 | 2020-05-16 | Mitchell | North Carolina | 37121 | 8 | 0 |
150036 | 150036 | 2020-05-16 | Pamlico | North Carolina | 37137 | 8 | 0 |
150067 | 150067 | 2020-05-16 | Yancey | North Carolina | 37199 | 8 | 0 |
147029 | 147029 | 2020-05-15 | Pamlico | North Carolina | 37137 | 8 | 0 |
147060 | 147060 | 2020-05-15 | Yancey | North Carolina | 37199 | 8 | 0 |
144028 | 144028 | 2020-05-14 | Pamlico | North Carolina | 37137 | 8 | 0 |
144059 | 144059 | 2020-05-14 | Yancey | North Carolina | 37199 | 8 | 0 |
141033 | 141033 | 2020-05-13 | Pamlico | North Carolina | 37137 | 8 | 0 |
141064 | 141064 | 2020-05-13 | Yancey | North Carolina | 37199 | 8 | 0 |
137972 | 137972 | 2020-05-12 | Alleghany | North Carolina | 37005 | 8 | 0 |
138037 | 138037 | 2020-05-12 | Pamlico | North Carolina | 37137 | 8 | 0 |
138068 | 138068 | 2020-05-12 | Yancey | North Carolina | 37199 | 8 | 0 |
134982 | 134982 | 2020-05-11 | Alleghany | North Carolina | 37005 | 8 | 0 |
135047 | 135047 | 2020-05-11 | Pamlico | North Carolina | 37137 | 8 | 0 |
131991 | 131991 | 2020-05-10 | Alleghany | North Carolina | 37005 | 8 | 0 |
132056 | 132056 | 2020-05-10 | Pamlico | North Carolina | 37137 | 8 | 0 |
129004 | 129004 | 2020-05-09 | Ashe | North Carolina | 37009 | 8 | 0 |
129067 | 129067 | 2020-05-09 | Pamlico | North Carolina | 37137 | 8 | 0 |
126012 | 126012 | 2020-05-08 | Alexander | North Carolina | 37003 | 8 | 0 |
126030 | 126030 | 2020-05-08 | Chowan | North Carolina | 37041 | 8 | 0 |
126078 | 126078 | 2020-05-08 | Pamlico | North Carolina | 37137 | 8 | 0 |
123029 | 123029 | 2020-05-07 | Alexander | North Carolina | 37003 | 8 | 0 |
123095 | 123095 | 2020-05-07 | Pamlico | North Carolina | 37137 | 8 | 0 |
120120 | 120120 | 2020-05-06 | Pamlico | North Carolina | 37137 | 8 | 0 |
120146 | 120146 | 2020-05-06 | Watauga | North Carolina | 37189 | 8 | 0 |
117159 | 117159 | 2020-05-05 | Pamlico | North Carolina | 37137 | 8 | 0 |
117185 | 117185 | 2020-05-05 | Watauga | North Carolina | 37189 | 8 | 0 |
114279 | 114279 | 2020-05-04 | Pamlico | North Carolina | 37137 | 8 | 0 |
114305 | 114305 | 2020-05-04 | Watauga | North Carolina | 37189 | 8 | 0 |
111398 | 111398 | 2020-05-03 | Pamlico | North Carolina | 37137 | 8 | 0 |
111424 | 111424 | 2020-05-03 | Watauga | North Carolina | 37189 | 8 | 0 |
108525 | 108525 | 2020-05-02 | Pamlico | North Carolina | 37137 | 8 | 0 |
108544 | 108544 | 2020-05-02 | Transylvania | North Carolina | 37175 | 8 | 0 |
108551 | 108551 | 2020-05-02 | Watauga | North Carolina | 37189 | 8 | 0 |
99969 | 99969 | 2020-04-29 | Watauga | North Carolina | 37189 | 8 | 0 |
97120 | 97120 | 2020-04-28 | Watauga | North Carolina | 37189 | 8 | 0 |
94283 | 94283 | 2020-04-27 | Watauga | North Carolina | 37189 | 8 | 0 |
91457 | 91457 | 2020-04-26 | Watauga | North Carolina | 37189 | 8 | 0 |
88642 | 88642 | 2020-04-25 | Watauga | North Carolina | 37189 | 8 | 0 |
85829 | 85829 | 2020-04-24 | Watauga | North Carolina | 37189 | 8 | 0 |
83003 | 83003 | 2020-04-23 | Perquimans | North Carolina | 37143 | 8 | 0 |
83025 | 83025 | 2020-04-23 | Watauga | North Carolina | 37189 | 8 | 0 |
83027 | 83027 | 2020-04-23 | Wilkes | North Carolina | 37193 | 8 | 1 |
80204 | 80204 | 2020-04-22 | Perquimans | North Carolina | 37143 | 8 | 0 |
80226 | 80226 | 2020-04-22 | Watauga | North Carolina | 37189 | 8 | 0 |
77363 | 77363 | 2020-04-21 | Caswell | North Carolina | 37033 | 8 | 0 |
77415 | 77415 | 2020-04-21 | Perquimans | North Carolina | 37143 | 8 | 0 |
77437 | 77437 | 2020-04-21 | Watauga | North Carolina | 37189 | 8 | 0 |
74582 | 74582 | 2020-04-20 | Caswell | North Carolina | 37033 | 8 | 0 |
74615 | 74615 | 2020-04-20 | Jones | North Carolina | 37103 | 8 | 1 |
74633 | 74633 | 2020-04-20 | Pender | North Carolina | 37141 | 8 | 0 |
74634 | 74634 | 2020-04-20 | Perquimans | North Carolina | 37143 | 8 | 0 |
74649 | 74649 | 2020-04-20 | Transylvania | North Carolina | 37175 | 8 | 0 |
74656 | 74656 | 2020-04-20 | Watauga | North Carolina | 37189 | 8 | 0 |
71840 | 71840 | 2020-04-19 | Jones | North Carolina | 37103 | 8 | 1 |
71859 | 71859 | 2020-04-19 | Perquimans | North Carolina | 37143 | 8 | 0 |
71881 | 71881 | 2020-04-19 | Watauga | North Carolina | 37189 | 8 | 0 |
69074 | 69074 | 2020-04-18 | Jones | North Carolina | 37103 | 8 | 1 |
69079 | 69079 | 2020-04-18 | Martin | North Carolina | 37117 | 8 | 0 |
69093 | 69093 | 2020-04-18 | Perquimans | North Carolina | 37143 | 8 | 0 |
69115 | 69115 | 2020-04-18 | Watauga | North Carolina | 37189 | 8 | 0 |
66317 | 66317 | 2020-04-17 | Jones | North Carolina | 37103 | 8 | 1 |
66322 | 66322 | 2020-04-17 | Martin | North Carolina | 37117 | 8 | 0 |
66336 | 66336 | 2020-04-17 | Perquimans | North Carolina | 37143 | 8 | 0 |
66358 | 66358 | 2020-04-17 | Watauga | North Carolina | 37189 | 8 | 0 |
63574 | 63574 | 2020-04-16 | Jones | North Carolina | 37103 | 8 | 1 |
63593 | 63593 | 2020-04-16 | Perquimans | North Carolina | 37143 | 8 | 0 |
63615 | 63615 | 2020-04-16 | Watauga | North Carolina | 37189 | 8 | 0 |
60848 | 60848 | 2020-04-15 | Jones | North Carolina | 37103 | 8 | 1 |
60867 | 60867 | 2020-04-15 | Perquimans | North Carolina | 37143 | 8 | 0 |
60889 | 60889 | 2020-04-15 | Watauga | North Carolina | 37189 | 8 | 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);