ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,352 rows where county = "Northampton" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
state 3
- Pennsylvania 793
- North Carolina 780
- Virginia 779
county 1
- Northampton · 2,352 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
11824 | 11824 | 2020-03-25 | Northampton | North Carolina | 37131 | 1 | 0 |
13428 | 13428 | 2020-03-26 | Northampton | North Carolina | 37131 | 3 | 0 |
15163 | 15163 | 2020-03-27 | Northampton | North Carolina | 37131 | 3 | 0 |
16995 | 16995 | 2020-03-28 | Northampton | North Carolina | 37131 | 4 | 0 |
18926 | 18926 | 2020-03-29 | Northampton | North Carolina | 37131 | 25 | 0 |
20966 | 20966 | 2020-03-30 | Northampton | North Carolina | 37131 | 26 | 0 |
23093 | 23093 | 2020-03-31 | Northampton | North Carolina | 37131 | 30 | 0 |
25287 | 25287 | 2020-04-01 | Northampton | North Carolina | 37131 | 30 | 0 |
27552 | 27552 | 2020-04-02 | Northampton | North Carolina | 37131 | 30 | 0 |
29879 | 29879 | 2020-04-03 | Northampton | North Carolina | 37131 | 33 | 0 |
32266 | 32266 | 2020-04-04 | Northampton | North Carolina | 37131 | 36 | 0 |
34697 | 34697 | 2020-04-05 | Northampton | North Carolina | 37131 | 42 | 0 |
37166 | 37166 | 2020-04-06 | Northampton | North Carolina | 37131 | 46 | 0 |
39681 | 39681 | 2020-04-07 | Northampton | North Carolina | 37131 | 51 | 0 |
42238 | 42238 | 2020-04-08 | Northampton | North Carolina | 37131 | 52 | 0 |
44822 | 44822 | 2020-04-09 | Northampton | North Carolina | 37131 | 54 | 0 |
47435 | 47435 | 2020-04-10 | Northampton | North Carolina | 37131 | 55 | 0 |
50090 | 50090 | 2020-04-11 | Northampton | North Carolina | 37131 | 60 | 0 |
52763 | 52763 | 2020-04-12 | Northampton | North Carolina | 37131 | 61 | 0 |
55447 | 55447 | 2020-04-13 | Northampton | North Carolina | 37131 | 61 | 0 |
58147 | 58147 | 2020-04-14 | Northampton | North Carolina | 37131 | 63 | 0 |
60861 | 60861 | 2020-04-15 | Northampton | North Carolina | 37131 | 65 | 0 |
63587 | 63587 | 2020-04-16 | Northampton | North Carolina | 37131 | 69 | 1 |
66330 | 66330 | 2020-04-17 | Northampton | North Carolina | 37131 | 69 | 1 |
69087 | 69087 | 2020-04-18 | Northampton | North Carolina | 37131 | 69 | 2 |
71853 | 71853 | 2020-04-19 | Northampton | North Carolina | 37131 | 72 | 2 |
74628 | 74628 | 2020-04-20 | Northampton | North Carolina | 37131 | 72 | 2 |
77409 | 77409 | 2020-04-21 | Northampton | North Carolina | 37131 | 73 | 2 |
80198 | 80198 | 2020-04-22 | Northampton | North Carolina | 37131 | 73 | 2 |
82997 | 82997 | 2020-04-23 | Northampton | North Carolina | 37131 | 74 | 2 |
85801 | 85801 | 2020-04-24 | Northampton | North Carolina | 37131 | 79 | 3 |
88614 | 88614 | 2020-04-25 | Northampton | North Carolina | 37131 | 80 | 3 |
91429 | 91429 | 2020-04-26 | Northampton | North Carolina | 37131 | 80 | 3 |
94255 | 94255 | 2020-04-27 | Northampton | North Carolina | 37131 | 81 | 4 |
97092 | 97092 | 2020-04-28 | Northampton | North Carolina | 37131 | 81 | 4 |
99940 | 99940 | 2020-04-29 | Northampton | North Carolina | 37131 | 81 | 4 |
102793 | 102793 | 2020-04-30 | Northampton | North Carolina | 37131 | 82 | 4 |
105655 | 105655 | 2020-05-01 | Northampton | North Carolina | 37131 | 87 | 4 |
108522 | 108522 | 2020-05-02 | Northampton | North Carolina | 37131 | 89 | 4 |
111395 | 111395 | 2020-05-03 | Northampton | North Carolina | 37131 | 89 | 4 |
114276 | 114276 | 2020-05-04 | Northampton | North Carolina | 37131 | 92 | 4 |
117156 | 117156 | 2020-05-05 | Northampton | North Carolina | 37131 | 91 | 4 |
120117 | 120117 | 2020-05-06 | Northampton | North Carolina | 37131 | 93 | 5 |
123092 | 123092 | 2020-05-07 | Northampton | North Carolina | 37131 | 102 | 5 |
126075 | 126075 | 2020-05-08 | Northampton | North Carolina | 37131 | 102 | 7 |
129064 | 129064 | 2020-05-09 | Northampton | North Carolina | 37131 | 102 | 7 |
132053 | 132053 | 2020-05-10 | Northampton | North Carolina | 37131 | 104 | 7 |
135044 | 135044 | 2020-05-11 | Northampton | North Carolina | 37131 | 106 | 7 |
138034 | 138034 | 2020-05-12 | Northampton | North Carolina | 37131 | 108 | 9 |
141030 | 141030 | 2020-05-13 | Northampton | North Carolina | 37131 | 122 | 9 |
144025 | 144025 | 2020-05-14 | Northampton | North Carolina | 37131 | 126 | 9 |
147026 | 147026 | 2020-05-15 | Northampton | North Carolina | 37131 | 129 | 9 |
150033 | 150033 | 2020-05-16 | Northampton | North Carolina | 37131 | 129 | 10 |
153043 | 153043 | 2020-05-17 | Northampton | North Carolina | 37131 | 129 | 10 |
156060 | 156060 | 2020-05-18 | Northampton | North Carolina | 37131 | 130 | 10 |
159079 | 159079 | 2020-05-19 | Northampton | North Carolina | 37131 | 131 | 10 |
162106 | 162106 | 2020-05-20 | Northampton | North Carolina | 37131 | 131 | 11 |
165135 | 165135 | 2020-05-21 | Northampton | North Carolina | 37131 | 132 | 11 |
168170 | 168170 | 2020-05-22 | Northampton | North Carolina | 37131 | 135 | 12 |
171209 | 171209 | 2020-05-23 | Northampton | North Carolina | 37131 | 137 | 12 |
174251 | 174251 | 2020-05-24 | Northampton | North Carolina | 37131 | 138 | 12 |
177295 | 177295 | 2020-05-25 | Northampton | North Carolina | 37131 | 140 | 12 |
180338 | 180338 | 2020-05-26 | Northampton | North Carolina | 37131 | 141 | 12 |
183386 | 183386 | 2020-05-27 | Northampton | North Carolina | 37131 | 144 | 12 |
186443 | 186443 | 2020-05-28 | Northampton | North Carolina | 37131 | 143 | 12 |
189503 | 189503 | 2020-05-29 | Northampton | North Carolina | 37131 | 144 | 14 |
192567 | 192567 | 2020-05-30 | Northampton | North Carolina | 37131 | 147 | 14 |
195637 | 195637 | 2020-05-31 | Northampton | North Carolina | 37131 | 147 | 14 |
198710 | 198710 | 2020-06-01 | Northampton | North Carolina | 37131 | 148 | 14 |
201784 | 201784 | 2020-06-02 | Northampton | North Carolina | 37131 | 155 | 14 |
204861 | 204861 | 2020-06-03 | Northampton | North Carolina | 37131 | 156 | 14 |
207942 | 207942 | 2020-06-04 | Northampton | North Carolina | 37131 | 155 | 14 |
211024 | 211024 | 2020-06-05 | Northampton | North Carolina | 37131 | 153 | 14 |
214108 | 214108 | 2020-06-06 | Northampton | North Carolina | 37131 | 155 | 14 |
217198 | 217198 | 2020-06-07 | Northampton | North Carolina | 37131 | 156 | 14 |
220290 | 220290 | 2020-06-08 | Northampton | North Carolina | 37131 | 156 | 14 |
223384 | 223384 | 2020-06-09 | Northampton | North Carolina | 37131 | 158 | 14 |
226484 | 226484 | 2020-06-10 | Northampton | North Carolina | 37131 | 160 | 14 |
229588 | 229588 | 2020-06-11 | Northampton | North Carolina | 37131 | 162 | 14 |
232693 | 232693 | 2020-06-12 | Northampton | North Carolina | 37131 | 163 | 14 |
235798 | 235798 | 2020-06-13 | Northampton | North Carolina | 37131 | 165 | 14 |
238906 | 238906 | 2020-06-14 | Northampton | North Carolina | 37131 | 166 | 14 |
242015 | 242015 | 2020-06-15 | Northampton | North Carolina | 37131 | 169 | 14 |
245127 | 245127 | 2020-06-16 | Northampton | North Carolina | 37131 | 171 | 15 |
248240 | 248240 | 2020-06-17 | Northampton | North Carolina | 37131 | 171 | 15 |
251355 | 251355 | 2020-06-18 | Northampton | North Carolina | 37131 | 174 | 15 |
254470 | 254470 | 2020-06-19 | Northampton | North Carolina | 37131 | 176 | 15 |
257593 | 257593 | 2020-06-20 | Northampton | North Carolina | 37131 | 173 | 15 |
260720 | 260720 | 2020-06-21 | Northampton | North Carolina | 37131 | 175 | 15 |
263848 | 263848 | 2020-06-22 | Northampton | North Carolina | 37131 | 175 | 15 |
266976 | 266976 | 2020-06-23 | Northampton | North Carolina | 37131 | 177 | 15 |
270110 | 270110 | 2020-06-24 | Northampton | North Carolina | 37131 | 178 | 15 |
273249 | 273249 | 2020-06-25 | Northampton | North Carolina | 37131 | 177 | 15 |
276395 | 276395 | 2020-06-26 | Northampton | North Carolina | 37131 | 179 | 15 |
279543 | 279543 | 2020-06-27 | Northampton | North Carolina | 37131 | 179 | 15 |
282689 | 282689 | 2020-06-28 | Northampton | North Carolina | 37131 | 180 | 15 |
285834 | 285834 | 2020-06-29 | Northampton | North Carolina | 37131 | 180 | 15 |
288984 | 288984 | 2020-06-30 | Northampton | North Carolina | 37131 | 181 | 15 |
292136 | 292136 | 2020-07-01 | Northampton | North Carolina | 37131 | 183 | 15 |
295291 | 295291 | 2020-07-02 | Northampton | North Carolina | 37131 | 185 | 15 |
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);