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 date
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 3
- Pennsylvania 751
- Virginia 751
- North Carolina 750
county 1
- Northampton · 2,252 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
83298 | 83298 | 2020-04-23 | Northampton | Pennsylvania | 42095 | 1656 | 45 |
83830 | 83830 | 2020-04-23 | Northampton | Virginia | 51131 | 12 | 0 |
85801 | 85801 | 2020-04-24 | Northampton | North Carolina | 37131 | 79 | 3 |
86102 | 86102 | 2020-04-24 | Northampton | Pennsylvania | 42095 | 1716 | 46 |
86637 | 86637 | 2020-04-24 | Northampton | Virginia | 51131 | 15 | 0 |
88614 | 88614 | 2020-04-25 | Northampton | North Carolina | 37131 | 80 | 3 |
88916 | 88916 | 2020-04-25 | Northampton | Pennsylvania | 42095 | 1780 | 49 |
89452 | 89452 | 2020-04-25 | Northampton | Virginia | 51131 | 20 | 0 |
91429 | 91429 | 2020-04-26 | Northampton | North Carolina | 37131 | 80 | 3 |
91732 | 91732 | 2020-04-26 | Northampton | Pennsylvania | 42095 | 1813 | 49 |
92269 | 92269 | 2020-04-26 | Northampton | Virginia | 51131 | 24 | 0 |
94255 | 94255 | 2020-04-27 | Northampton | North Carolina | 37131 | 81 | 4 |
94559 | 94559 | 2020-04-27 | Northampton | Pennsylvania | 42095 | 1834 | 49 |
95098 | 95098 | 2020-04-27 | Northampton | Virginia | 51131 | 28 | 0 |
97092 | 97092 | 2020-04-28 | Northampton | North Carolina | 37131 | 81 | 4 |
97398 | 97398 | 2020-04-28 | Northampton | Pennsylvania | 42095 | 1970 | 55 |
97942 | 97942 | 2020-04-28 | Northampton | Virginia | 51131 | 35 | 0 |
99940 | 99940 | 2020-04-29 | Northampton | North Carolina | 37131 | 81 | 4 |
100247 | 100247 | 2020-04-29 | Northampton | Pennsylvania | 42095 | 2008 | 85 |
100792 | 100792 | 2020-04-29 | Northampton | Virginia | 51131 | 36 | 0 |
102793 | 102793 | 2020-04-30 | Northampton | North Carolina | 37131 | 82 | 4 |
103100 | 103100 | 2020-04-30 | Northampton | Pennsylvania | 42095 | 2050 | 94 |
103647 | 103647 | 2020-04-30 | Northampton | Virginia | 51131 | 64 | 0 |
105655 | 105655 | 2020-05-01 | Northampton | North Carolina | 37131 | 87 | 4 |
105963 | 105963 | 2020-05-01 | Northampton | Pennsylvania | 42095 | 2103 | 94 |
106511 | 106511 | 2020-05-01 | Northampton | Virginia | 51131 | 82 | 0 |
108522 | 108522 | 2020-05-02 | Northampton | North Carolina | 37131 | 89 | 4 |
108830 | 108830 | 2020-05-02 | Northampton | Pennsylvania | 42095 | 2182 | 94 |
109380 | 109380 | 2020-05-02 | Northampton | Virginia | 51131 | 94 | 0 |
111395 | 111395 | 2020-05-03 | Northampton | North Carolina | 37131 | 89 | 4 |
111704 | 111704 | 2020-05-03 | Northampton | Pennsylvania | 42095 | 2214 | 94 |
112254 | 112254 | 2020-05-03 | Northampton | Virginia | 51131 | 134 | 1 |
114276 | 114276 | 2020-05-04 | Northampton | North Carolina | 37131 | 92 | 4 |
114586 | 114586 | 2020-05-04 | Northampton | Pennsylvania | 42095 | 2240 | 94 |
115137 | 115137 | 2020-05-04 | Northampton | Virginia | 51131 | 139 | 1 |
117156 | 117156 | 2020-05-05 | Northampton | North Carolina | 37131 | 91 | 4 |
117467 | 117467 | 2020-05-05 | Northampton | Pennsylvania | 42095 | 2279 | 117 |
118096 | 118096 | 2020-05-05 | Northampton | Virginia | 51131 | 140 | 1 |
120117 | 120117 | 2020-05-06 | Northampton | North Carolina | 37131 | 93 | 5 |
120429 | 120429 | 2020-05-06 | Northampton | Pennsylvania | 42095 | 2313 | 122 |
121060 | 121060 | 2020-05-06 | Northampton | Virginia | 51131 | 140 | 1 |
123092 | 123092 | 2020-05-07 | Northampton | North Carolina | 37131 | 102 | 5 |
123406 | 123406 | 2020-05-07 | Northampton | Pennsylvania | 42095 | 2355 | 152 |
124041 | 124041 | 2020-05-07 | Northampton | Virginia | 51131 | 149 | 3 |
126075 | 126075 | 2020-05-08 | Northampton | North Carolina | 37131 | 102 | 7 |
126389 | 126389 | 2020-05-08 | Northampton | Pennsylvania | 42095 | 2390 | 153 |
127026 | 127026 | 2020-05-08 | Northampton | Virginia | 51131 | 149 | 5 |
129064 | 129064 | 2020-05-09 | Northampton | North Carolina | 37131 | 102 | 7 |
129378 | 129378 | 2020-05-09 | Northampton | Pennsylvania | 42095 | 2429 | 158 |
130016 | 130016 | 2020-05-09 | Northampton | Virginia | 51131 | 159 | 5 |
132053 | 132053 | 2020-05-10 | Northampton | North Carolina | 37131 | 104 | 7 |
132367 | 132367 | 2020-05-10 | Northampton | Pennsylvania | 42095 | 2453 | 158 |
133006 | 133006 | 2020-05-10 | Northampton | Virginia | 51131 | 163 | 5 |
135044 | 135044 | 2020-05-11 | Northampton | North Carolina | 37131 | 106 | 7 |
135358 | 135358 | 2020-05-11 | Northampton | Pennsylvania | 42095 | 2465 | 160 |
135996 | 135996 | 2020-05-11 | Northampton | Virginia | 51131 | 170 | 5 |
138034 | 138034 | 2020-05-12 | Northampton | North Carolina | 37131 | 108 | 9 |
138348 | 138348 | 2020-05-12 | Northampton | Pennsylvania | 42095 | 2499 | 161 |
138987 | 138987 | 2020-05-12 | Northampton | Virginia | 51131 | 171 | 5 |
141030 | 141030 | 2020-05-13 | Northampton | North Carolina | 37131 | 122 | 9 |
141344 | 141344 | 2020-05-13 | Northampton | Pennsylvania | 42095 | 2518 | 162 |
141983 | 141983 | 2020-05-13 | Northampton | Virginia | 51131 | 174 | 5 |
144025 | 144025 | 2020-05-14 | Northampton | North Carolina | 37131 | 126 | 9 |
144340 | 144340 | 2020-05-14 | Northampton | Pennsylvania | 42095 | 2566 | 182 |
144980 | 144980 | 2020-05-14 | Northampton | Virginia | 51131 | 184 | 6 |
147026 | 147026 | 2020-05-15 | Northampton | North Carolina | 37131 | 129 | 9 |
147341 | 147341 | 2020-05-15 | Northampton | Pennsylvania | 42095 | 2600 | 196 |
147983 | 147983 | 2020-05-15 | Northampton | Virginia | 51131 | 193 | 7 |
150033 | 150033 | 2020-05-16 | Northampton | North Carolina | 37131 | 129 | 10 |
150348 | 150348 | 2020-05-16 | Northampton | Pennsylvania | 42095 | 2659 | 196 |
150992 | 150992 | 2020-05-16 | Northampton | Virginia | 51131 | 196 | 8 |
153043 | 153043 | 2020-05-17 | Northampton | North Carolina | 37131 | 129 | 10 |
153359 | 153359 | 2020-05-17 | Northampton | Pennsylvania | 42095 | 2703 | 199 |
154003 | 154003 | 2020-05-17 | Northampton | Virginia | 51131 | 198 | 9 |
156060 | 156060 | 2020-05-18 | Northampton | North Carolina | 37131 | 130 | 10 |
156376 | 156376 | 2020-05-18 | Northampton | Pennsylvania | 42095 | 2727 | 171 |
157020 | 157020 | 2020-05-18 | Northampton | Virginia | 51131 | 198 | 9 |
159079 | 159079 | 2020-05-19 | Northampton | North Carolina | 37131 | 131 | 10 |
159397 | 159397 | 2020-05-19 | Northampton | Pennsylvania | 42095 | 2758 | 176 |
160044 | 160044 | 2020-05-19 | Northampton | Virginia | 51131 | 204 | 11 |
162106 | 162106 | 2020-05-20 | Northampton | North Carolina | 37131 | 131 | 11 |
162424 | 162424 | 2020-05-20 | Northampton | Pennsylvania | 42095 | 2779 | 182 |
163072 | 163072 | 2020-05-20 | Northampton | Virginia | 51131 | 205 | 15 |
165135 | 165135 | 2020-05-21 | Northampton | North Carolina | 37131 | 132 | 11 |
165453 | 165453 | 2020-05-21 | Northampton | Pennsylvania | 42095 | 2814 | 186 |
166101 | 166101 | 2020-05-21 | Northampton | Virginia | 51131 | 206 | 16 |
168170 | 168170 | 2020-05-22 | Northampton | North Carolina | 37131 | 135 | 12 |
168489 | 168489 | 2020-05-22 | Northampton | Pennsylvania | 42095 | 2842 | 192 |
169137 | 169137 | 2020-05-22 | Northampton | Virginia | 51131 | 206 | 16 |
171209 | 171209 | 2020-05-23 | Northampton | North Carolina | 37131 | 137 | 12 |
171528 | 171528 | 2020-05-23 | Northampton | Pennsylvania | 42095 | 2866 | 197 |
172178 | 172178 | 2020-05-23 | Northampton | Virginia | 51131 | 210 | 16 |
174251 | 174251 | 2020-05-24 | Northampton | North Carolina | 37131 | 138 | 12 |
174570 | 174570 | 2020-05-24 | Northampton | Pennsylvania | 42095 | 2911 | 198 |
175221 | 175221 | 2020-05-24 | Northampton | Virginia | 51131 | 213 | 16 |
177295 | 177295 | 2020-05-25 | Northampton | North Carolina | 37131 | 140 | 12 |
177614 | 177614 | 2020-05-25 | Northampton | Pennsylvania | 42095 | 2920 | 199 |
178266 | 178266 | 2020-05-25 | Northampton | Virginia | 51131 | 216 | 17 |
180338 | 180338 | 2020-05-26 | Northampton | North Carolina | 37131 | 141 | 12 |
180657 | 180657 | 2020-05-26 | Northampton | Pennsylvania | 42095 | 2933 | 199 |
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);