ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
77,809 rows where state = "North Carolina" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 37183 802
- 37037 799
- 37025 793
- 37067 793
- 37101 793
- 37119 793
- 37133 793
- 37191 792
- 37019 791
- 37049 791
- 37085 791
- 37189 790
- 37195 790
- 37063 789
- 37097 788
- 37163 788
- 37071 787
- 37081 787
- 37093 787
- 37109 787
- 37125 787
- 37129 787
- 37031 785
- 37057 785
- 37069 785
- 37135 785
- 37139 785
- 37147 785
- 37159 785
- 37167 785
- …
county >30
- Wake 802
- Chatham 799
- Cabarrus 793
- Forsyth 793
- Johnston 793
- Mecklenburg 793
- Onslow 793
- Wayne 792
- Brunswick 791
- Craven 791
- Harnett 791
- Watauga 790
- Wilson 790
- Durham 789
- Iredell 788
- Sampson 788
- Gaston 787
- Guilford 787
- Hoke 787
- Lincoln 787
- Moore 787
- New Hanover 787
- Carteret 785
- Davidson 785
- Franklin 785
- Orange 785
- Pasquotank 785
- Pitt 785
- Rowan 785
- Stanly 785
- …
state 1
- North Carolina · 77,809 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9042 | 9042 | 2020-03-23 | Alamance | North Carolina | 37001 | 3 | 0 |
10350 | 10350 | 2020-03-24 | Alamance | North Carolina | 37001 | 3 | 0 |
11786 | 11786 | 2020-03-25 | Alamance | North Carolina | 37001 | 3 | 0 |
13389 | 13389 | 2020-03-26 | Alamance | North Carolina | 37001 | 4 | 0 |
15123 | 15123 | 2020-03-27 | Alamance | North Carolina | 37001 | 5 | 0 |
16954 | 16954 | 2020-03-28 | Alamance | North Carolina | 37001 | 5 | 0 |
18880 | 18880 | 2020-03-29 | Alamance | North Carolina | 37001 | 6 | 0 |
20919 | 20919 | 2020-03-30 | Alamance | North Carolina | 37001 | 7 | 0 |
23043 | 23043 | 2020-03-31 | Alamance | North Carolina | 37001 | 7 | 0 |
25237 | 25237 | 2020-04-01 | Alamance | North Carolina | 37001 | 7 | 0 |
27498 | 27498 | 2020-04-02 | Alamance | North Carolina | 37001 | 13 | 0 |
29822 | 29822 | 2020-04-03 | Alamance | North Carolina | 37001 | 14 | 0 |
32208 | 32208 | 2020-04-04 | Alamance | North Carolina | 37001 | 16 | 0 |
34639 | 34639 | 2020-04-05 | Alamance | North Carolina | 37001 | 18 | 0 |
37108 | 37108 | 2020-04-06 | Alamance | North Carolina | 37001 | 18 | 0 |
39623 | 39623 | 2020-04-07 | Alamance | North Carolina | 37001 | 24 | 0 |
42180 | 42180 | 2020-04-08 | Alamance | North Carolina | 37001 | 27 | 0 |
44763 | 44763 | 2020-04-09 | Alamance | North Carolina | 37001 | 29 | 0 |
47376 | 47376 | 2020-04-10 | Alamance | North Carolina | 37001 | 33 | 0 |
50031 | 50031 | 2020-04-11 | Alamance | North Carolina | 37001 | 34 | 0 |
52704 | 52704 | 2020-04-12 | Alamance | North Carolina | 37001 | 36 | 0 |
55387 | 55387 | 2020-04-13 | Alamance | North Carolina | 37001 | 41 | 0 |
58087 | 58087 | 2020-04-14 | Alamance | North Carolina | 37001 | 41 | 0 |
60801 | 60801 | 2020-04-15 | Alamance | North Carolina | 37001 | 42 | 0 |
63527 | 63527 | 2020-04-16 | Alamance | North Carolina | 37001 | 45 | 0 |
66270 | 66270 | 2020-04-17 | Alamance | North Carolina | 37001 | 48 | 0 |
69027 | 69027 | 2020-04-18 | Alamance | North Carolina | 37001 | 47 | 0 |
71793 | 71793 | 2020-04-19 | Alamance | North Carolina | 37001 | 49 | 0 |
74568 | 74568 | 2020-04-20 | Alamance | North Carolina | 37001 | 49 | 0 |
77349 | 77349 | 2020-04-21 | Alamance | North Carolina | 37001 | 52 | 0 |
80138 | 80138 | 2020-04-22 | Alamance | North Carolina | 37001 | 55 | 0 |
82937 | 82937 | 2020-04-23 | Alamance | North Carolina | 37001 | 63 | 0 |
85741 | 85741 | 2020-04-24 | Alamance | North Carolina | 37001 | 73 | 1 |
88553 | 88553 | 2020-04-25 | Alamance | North Carolina | 37001 | 77 | 1 |
91368 | 91368 | 2020-04-26 | Alamance | North Carolina | 37001 | 82 | 1 |
94193 | 94193 | 2020-04-27 | Alamance | North Carolina | 37001 | 91 | 1 |
97029 | 97029 | 2020-04-28 | Alamance | North Carolina | 37001 | 92 | 1 |
99876 | 99876 | 2020-04-29 | Alamance | North Carolina | 37001 | 95 | 1 |
102729 | 102729 | 2020-04-30 | Alamance | North Carolina | 37001 | 99 | 1 |
105591 | 105591 | 2020-05-01 | Alamance | North Carolina | 37001 | 106 | 1 |
108458 | 108458 | 2020-05-02 | Alamance | North Carolina | 37001 | 121 | 2 |
111331 | 111331 | 2020-05-03 | Alamance | North Carolina | 37001 | 124 | 2 |
114212 | 114212 | 2020-05-04 | Alamance | North Carolina | 37001 | 128 | 2 |
117092 | 117092 | 2020-05-05 | Alamance | North Carolina | 37001 | 126 | 3 |
120053 | 120053 | 2020-05-06 | Alamance | North Carolina | 37001 | 128 | 3 |
123028 | 123028 | 2020-05-07 | Alamance | North Carolina | 37001 | 143 | 3 |
126011 | 126011 | 2020-05-08 | Alamance | North Carolina | 37001 | 149 | 3 |
129000 | 129000 | 2020-05-09 | Alamance | North Carolina | 37001 | 152 | 5 |
131989 | 131989 | 2020-05-10 | Alamance | North Carolina | 37001 | 172 | 5 |
134980 | 134980 | 2020-05-11 | Alamance | North Carolina | 37001 | 178 | 5 |
137970 | 137970 | 2020-05-12 | Alamance | North Carolina | 37001 | 180 | 8 |
140966 | 140966 | 2020-05-13 | Alamance | North Carolina | 37001 | 181 | 8 |
143961 | 143961 | 2020-05-14 | Alamance | North Carolina | 37001 | 190 | 9 |
146962 | 146962 | 2020-05-15 | Alamance | North Carolina | 37001 | 195 | 9 |
149969 | 149969 | 2020-05-16 | Alamance | North Carolina | 37001 | 203 | 9 |
152979 | 152979 | 2020-05-17 | Alamance | North Carolina | 37001 | 207 | 11 |
155996 | 155996 | 2020-05-18 | Alamance | North Carolina | 37001 | 215 | 11 |
159014 | 159014 | 2020-05-19 | Alamance | North Carolina | 37001 | 223 | 12 |
162041 | 162041 | 2020-05-20 | Alamance | North Carolina | 37001 | 229 | 12 |
165070 | 165070 | 2020-05-21 | Alamance | North Carolina | 37001 | 236 | 12 |
168105 | 168105 | 2020-05-22 | Alamance | North Carolina | 37001 | 246 | 12 |
171144 | 171144 | 2020-05-23 | Alamance | North Carolina | 37001 | 257 | 13 |
174186 | 174186 | 2020-05-24 | Alamance | North Carolina | 37001 | 261 | 13 |
177230 | 177230 | 2020-05-25 | Alamance | North Carolina | 37001 | 282 | 21 |
180273 | 180273 | 2020-05-26 | Alamance | North Carolina | 37001 | 282 | 21 |
183321 | 183321 | 2020-05-27 | Alamance | North Carolina | 37001 | 282 | 21 |
186378 | 186378 | 2020-05-28 | Alamance | North Carolina | 37001 | 293 | 21 |
189438 | 189438 | 2020-05-29 | Alamance | North Carolina | 37001 | 307 | 21 |
192502 | 192502 | 2020-05-30 | Alamance | North Carolina | 37001 | 329 | 21 |
195572 | 195572 | 2020-05-31 | Alamance | North Carolina | 37001 | 349 | 21 |
198645 | 198645 | 2020-06-01 | Alamance | North Carolina | 37001 | 364 | 21 |
201719 | 201719 | 2020-06-02 | Alamance | North Carolina | 37001 | 368 | 21 |
204796 | 204796 | 2020-06-03 | Alamance | North Carolina | 37001 | 382 | 21 |
207877 | 207877 | 2020-06-04 | Alamance | North Carolina | 37001 | 398 | 21 |
210959 | 210959 | 2020-06-05 | Alamance | North Carolina | 37001 | 427 | 21 |
214043 | 214043 | 2020-06-06 | Alamance | North Carolina | 37001 | 451 | 23 |
217133 | 217133 | 2020-06-07 | Alamance | North Carolina | 37001 | 465 | 23 |
220225 | 220225 | 2020-06-08 | Alamance | North Carolina | 37001 | 494 | 23 |
223319 | 223319 | 2020-06-09 | Alamance | North Carolina | 37001 | 519 | 23 |
226419 | 226419 | 2020-06-10 | Alamance | North Carolina | 37001 | 544 | 23 |
229523 | 229523 | 2020-06-11 | Alamance | North Carolina | 37001 | 581 | 23 |
232628 | 232628 | 2020-06-12 | Alamance | North Carolina | 37001 | 641 | 31 |
235733 | 235733 | 2020-06-13 | Alamance | North Carolina | 37001 | 700 | 32 |
238841 | 238841 | 2020-06-14 | Alamance | North Carolina | 37001 | 742 | 33 |
241950 | 241950 | 2020-06-15 | Alamance | North Carolina | 37001 | 778 | 34 |
245062 | 245062 | 2020-06-16 | Alamance | North Carolina | 37001 | 796 | 34 |
248175 | 248175 | 2020-06-17 | Alamance | North Carolina | 37001 | 810 | 35 |
251290 | 251290 | 2020-06-18 | Alamance | North Carolina | 37001 | 838 | 35 |
254405 | 254405 | 2020-06-19 | Alamance | North Carolina | 37001 | 883 | 35 |
257528 | 257528 | 2020-06-20 | Alamance | North Carolina | 37001 | 919 | 35 |
260655 | 260655 | 2020-06-21 | Alamance | North Carolina | 37001 | 939 | 35 |
263783 | 263783 | 2020-06-22 | Alamance | North Carolina | 37001 | 946 | 35 |
266911 | 266911 | 2020-06-23 | Alamance | North Carolina | 37001 | 969 | 36 |
270045 | 270045 | 2020-06-24 | Alamance | North Carolina | 37001 | 994 | 36 |
273184 | 273184 | 2020-06-25 | Alamance | North Carolina | 37001 | 1009 | 36 |
276330 | 276330 | 2020-06-26 | Alamance | North Carolina | 37001 | 1032 | 36 |
279478 | 279478 | 2020-06-27 | Alamance | North Carolina | 37001 | 1066 | 36 |
282624 | 282624 | 2020-06-28 | Alamance | North Carolina | 37001 | 1088 | 37 |
285769 | 285769 | 2020-06-29 | Alamance | North Carolina | 37001 | 1114 | 37 |
288919 | 288919 | 2020-06-30 | Alamance | North Carolina | 37001 | 1121 | 37 |
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);