ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 42095 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388224 | 388224 | 2020-07-31 | Northampton | Pennsylvania | 42095 | 3827 | 290 |
385007 | 385007 | 2020-07-30 | Northampton | Pennsylvania | 42095 | 3816 | 289 |
381789 | 381789 | 2020-07-29 | Northampton | Pennsylvania | 42095 | 3806 | 289 |
378572 | 378572 | 2020-07-28 | Northampton | Pennsylvania | 42095 | 3780 | 289 |
375356 | 375356 | 2020-07-27 | Northampton | Pennsylvania | 42095 | 3758 | 289 |
372143 | 372143 | 2020-07-26 | Northampton | Pennsylvania | 42095 | 3746 | 289 |
368931 | 368931 | 2020-07-25 | Northampton | Pennsylvania | 42095 | 3727 | 289 |
365722 | 365722 | 2020-07-24 | Northampton | Pennsylvania | 42095 | 3703 | 289 |
362516 | 362516 | 2020-07-23 | Northampton | Pennsylvania | 42095 | 3686 | 288 |
359310 | 359310 | 2020-07-22 | Northampton | Pennsylvania | 42095 | 3669 | 288 |
356106 | 356106 | 2020-07-21 | Northampton | Pennsylvania | 42095 | 3657 | 287 |
352903 | 352903 | 2020-07-20 | Northampton | Pennsylvania | 42095 | 3649 | 285 |
349700 | 349700 | 2020-07-19 | Northampton | Pennsylvania | 42095 | 3643 | 285 |
346500 | 346500 | 2020-07-18 | Northampton | Pennsylvania | 42095 | 3631 | 284 |
343300 | 343300 | 2020-07-17 | Northampton | Pennsylvania | 42095 | 3614 | 284 |
340102 | 340102 | 2020-07-16 | Northampton | Pennsylvania | 42095 | 3601 | 283 |
336905 | 336905 | 2020-07-15 | Northampton | Pennsylvania | 42095 | 3582 | 283 |
333711 | 333711 | 2020-07-14 | Northampton | Pennsylvania | 42095 | 3558 | 281 |
330519 | 330519 | 2020-07-13 | Northampton | Pennsylvania | 42095 | 3555 | 279 |
327333 | 327333 | 2020-07-12 | Northampton | Pennsylvania | 42095 | 3554 | 279 |
324148 | 324148 | 2020-07-11 | Northampton | Pennsylvania | 42095 | 3546 | 279 |
320968 | 320968 | 2020-07-10 | Northampton | Pennsylvania | 42095 | 3527 | 278 |
317790 | 317790 | 2020-07-09 | Northampton | Pennsylvania | 42095 | 3513 | 276 |
314617 | 314617 | 2020-07-08 | Northampton | Pennsylvania | 42095 | 3500 | 276 |
311445 | 311445 | 2020-07-07 | Northampton | Pennsylvania | 42095 | 3485 | 275 |
308276 | 308276 | 2020-07-06 | Northampton | Pennsylvania | 42095 | 3475 | 273 |
305109 | 305109 | 2020-07-05 | Northampton | Pennsylvania | 42095 | 3471 | 273 |
301946 | 301946 | 2020-07-04 | Northampton | Pennsylvania | 42095 | 3463 | 272 |
298782 | 298782 | 2020-07-03 | Northampton | Pennsylvania | 42095 | 3458 | 272 |
295623 | 295623 | 2020-07-02 | Northampton | Pennsylvania | 42095 | 3441 | 270 |
292467 | 292467 | 2020-07-01 | Northampton | Pennsylvania | 42095 | 3425 | 266 |
289315 | 289315 | 2020-06-30 | Northampton | Pennsylvania | 42095 | 3413 | 266 |
286164 | 286164 | 2020-06-29 | Northampton | Pennsylvania | 42095 | 3407 | 266 |
283019 | 283019 | 2020-06-28 | Northampton | Pennsylvania | 42095 | 3389 | 265 |
279873 | 279873 | 2020-06-27 | Northampton | Pennsylvania | 42095 | 3377 | 265 |
276725 | 276725 | 2020-06-26 | Northampton | Pennsylvania | 42095 | 3360 | 263 |
273578 | 273578 | 2020-06-25 | Northampton | Pennsylvania | 42095 | 3352 | 262 |
270439 | 270439 | 2020-06-24 | Northampton | Pennsylvania | 42095 | 3339 | 259 |
267305 | 267305 | 2020-06-23 | Northampton | Pennsylvania | 42095 | 3327 | 255 |
264177 | 264177 | 2020-06-22 | Northampton | Pennsylvania | 42095 | 3312 | 252 |
261049 | 261049 | 2020-06-21 | Northampton | Pennsylvania | 42095 | 3309 | 252 |
257922 | 257922 | 2020-06-20 | Northampton | Pennsylvania | 42095 | 3304 | 252 |
254796 | 254796 | 2020-06-19 | Northampton | Pennsylvania | 42095 | 3284 | 250 |
251681 | 251681 | 2020-06-18 | Northampton | Pennsylvania | 42095 | 3270 | 249 |
248566 | 248566 | 2020-06-17 | Northampton | Pennsylvania | 42095 | 3255 | 247 |
245453 | 245453 | 2020-06-16 | Northampton | Pennsylvania | 42095 | 3250 | 244 |
242341 | 242341 | 2020-06-15 | Northampton | Pennsylvania | 42095 | 3246 | 243 |
239232 | 239232 | 2020-06-14 | Northampton | Pennsylvania | 42095 | 3240 | 241 |
236124 | 236124 | 2020-06-13 | Northampton | Pennsylvania | 42095 | 3232 | 241 |
233019 | 233019 | 2020-06-12 | Northampton | Pennsylvania | 42095 | 3217 | 238 |
229914 | 229914 | 2020-06-11 | Northampton | Pennsylvania | 42095 | 3202 | 238 |
226810 | 226810 | 2020-06-10 | Northampton | Pennsylvania | 42095 | 3193 | 238 |
223710 | 223710 | 2020-06-09 | Northampton | Pennsylvania | 42095 | 3175 | 236 |
220615 | 220615 | 2020-06-08 | Northampton | Pennsylvania | 42095 | 3168 | 232 |
217523 | 217523 | 2020-06-07 | Northampton | Pennsylvania | 42095 | 3151 | 232 |
214433 | 214433 | 2020-06-06 | Northampton | Pennsylvania | 42095 | 3144 | 231 |
211347 | 211347 | 2020-06-05 | Northampton | Pennsylvania | 42095 | 3136 | 229 |
208265 | 208265 | 2020-06-04 | Northampton | Pennsylvania | 42095 | 3124 | 225 |
205184 | 205184 | 2020-06-03 | Northampton | Pennsylvania | 42095 | 3120 | 220 |
202107 | 202107 | 2020-06-02 | Northampton | Pennsylvania | 42095 | 3108 | 213 |
199032 | 199032 | 2020-06-01 | Northampton | Pennsylvania | 42095 | 3082 | 210 |
195959 | 195959 | 2020-05-31 | Northampton | Pennsylvania | 42095 | 3083 | 210 |
192890 | 192890 | 2020-05-30 | Northampton | Pennsylvania | 42095 | 3062 | 210 |
189825 | 189825 | 2020-05-29 | Northampton | Pennsylvania | 42095 | 3045 | 207 |
186764 | 186764 | 2020-05-28 | Northampton | Pennsylvania | 42095 | 3022 | 206 |
183707 | 183707 | 2020-05-27 | Northampton | Pennsylvania | 42095 | 2958 | 203 |
180657 | 180657 | 2020-05-26 | Northampton | Pennsylvania | 42095 | 2933 | 199 |
177614 | 177614 | 2020-05-25 | Northampton | Pennsylvania | 42095 | 2920 | 199 |
174570 | 174570 | 2020-05-24 | Northampton | Pennsylvania | 42095 | 2911 | 198 |
171528 | 171528 | 2020-05-23 | Northampton | Pennsylvania | 42095 | 2866 | 197 |
168489 | 168489 | 2020-05-22 | Northampton | Pennsylvania | 42095 | 2842 | 192 |
165453 | 165453 | 2020-05-21 | Northampton | Pennsylvania | 42095 | 2814 | 186 |
162424 | 162424 | 2020-05-20 | Northampton | Pennsylvania | 42095 | 2779 | 182 |
159397 | 159397 | 2020-05-19 | Northampton | Pennsylvania | 42095 | 2758 | 176 |
156376 | 156376 | 2020-05-18 | Northampton | Pennsylvania | 42095 | 2727 | 171 |
153359 | 153359 | 2020-05-17 | Northampton | Pennsylvania | 42095 | 2703 | 199 |
150348 | 150348 | 2020-05-16 | Northampton | Pennsylvania | 42095 | 2659 | 196 |
147341 | 147341 | 2020-05-15 | Northampton | Pennsylvania | 42095 | 2600 | 196 |
144340 | 144340 | 2020-05-14 | Northampton | Pennsylvania | 42095 | 2566 | 182 |
141344 | 141344 | 2020-05-13 | Northampton | Pennsylvania | 42095 | 2518 | 162 |
138348 | 138348 | 2020-05-12 | Northampton | Pennsylvania | 42095 | 2499 | 161 |
135358 | 135358 | 2020-05-11 | Northampton | Pennsylvania | 42095 | 2465 | 160 |
132367 | 132367 | 2020-05-10 | Northampton | Pennsylvania | 42095 | 2453 | 158 |
129378 | 129378 | 2020-05-09 | Northampton | Pennsylvania | 42095 | 2429 | 158 |
126389 | 126389 | 2020-05-08 | Northampton | Pennsylvania | 42095 | 2390 | 153 |
123406 | 123406 | 2020-05-07 | Northampton | Pennsylvania | 42095 | 2355 | 152 |
120429 | 120429 | 2020-05-06 | Northampton | Pennsylvania | 42095 | 2313 | 122 |
117467 | 117467 | 2020-05-05 | Northampton | Pennsylvania | 42095 | 2279 | 117 |
114586 | 114586 | 2020-05-04 | Northampton | Pennsylvania | 42095 | 2240 | 94 |
111704 | 111704 | 2020-05-03 | Northampton | Pennsylvania | 42095 | 2214 | 94 |
108830 | 108830 | 2020-05-02 | Northampton | Pennsylvania | 42095 | 2182 | 94 |
105963 | 105963 | 2020-05-01 | Northampton | Pennsylvania | 42095 | 2103 | 94 |
103100 | 103100 | 2020-04-30 | Northampton | Pennsylvania | 42095 | 2050 | 94 |
100247 | 100247 | 2020-04-29 | Northampton | Pennsylvania | 42095 | 2008 | 85 |
97398 | 97398 | 2020-04-28 | Northampton | Pennsylvania | 42095 | 1970 | 55 |
94559 | 94559 | 2020-04-27 | Northampton | Pennsylvania | 42095 | 1834 | 49 |
91732 | 91732 | 2020-04-26 | Northampton | Pennsylvania | 42095 | 1813 | 49 |
88916 | 88916 | 2020-04-25 | Northampton | Pennsylvania | 42095 | 1780 | 49 |
86102 | 86102 | 2020-04-24 | Northampton | Pennsylvania | 42095 | 1716 | 46 |
83298 | 83298 | 2020-04-23 | Northampton | Pennsylvania | 42095 | 1656 | 45 |
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);