ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 42077 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388215 | 388215 | 2020-07-31 | Lehigh | Pennsylvania | 42077 | 4810 | 334 |
384998 | 384998 | 2020-07-30 | Lehigh | Pennsylvania | 42077 | 4795 | 335 |
381780 | 381780 | 2020-07-29 | Lehigh | Pennsylvania | 42077 | 4775 | 335 |
378563 | 378563 | 2020-07-28 | Lehigh | Pennsylvania | 42077 | 4733 | 335 |
375347 | 375347 | 2020-07-27 | Lehigh | Pennsylvania | 42077 | 4703 | 335 |
372134 | 372134 | 2020-07-26 | Lehigh | Pennsylvania | 42077 | 4688 | 335 |
368922 | 368922 | 2020-07-25 | Lehigh | Pennsylvania | 42077 | 4667 | 334 |
365713 | 365713 | 2020-07-24 | Lehigh | Pennsylvania | 42077 | 4624 | 334 |
362507 | 362507 | 2020-07-23 | Lehigh | Pennsylvania | 42077 | 4609 | 334 |
359301 | 359301 | 2020-07-22 | Lehigh | Pennsylvania | 42077 | 4600 | 334 |
356097 | 356097 | 2020-07-21 | Lehigh | Pennsylvania | 42077 | 4585 | 333 |
352894 | 352894 | 2020-07-20 | Lehigh | Pennsylvania | 42077 | 4564 | 332 |
349691 | 349691 | 2020-07-19 | Lehigh | Pennsylvania | 42077 | 4546 | 332 |
346491 | 346491 | 2020-07-18 | Lehigh | Pennsylvania | 42077 | 4541 | 332 |
343291 | 343291 | 2020-07-17 | Lehigh | Pennsylvania | 42077 | 4519 | 331 |
340093 | 340093 | 2020-07-16 | Lehigh | Pennsylvania | 42077 | 4495 | 330 |
336896 | 336896 | 2020-07-15 | Lehigh | Pennsylvania | 42077 | 4465 | 330 |
333702 | 333702 | 2020-07-14 | Lehigh | Pennsylvania | 42077 | 4450 | 329 |
330510 | 330510 | 2020-07-13 | Lehigh | Pennsylvania | 42077 | 4439 | 327 |
327324 | 327324 | 2020-07-12 | Lehigh | Pennsylvania | 42077 | 4430 | 326 |
324139 | 324139 | 2020-07-11 | Lehigh | Pennsylvania | 42077 | 4424 | 324 |
320959 | 320959 | 2020-07-10 | Lehigh | Pennsylvania | 42077 | 4391 | 319 |
317781 | 317781 | 2020-07-09 | Lehigh | Pennsylvania | 42077 | 4370 | 315 |
314608 | 314608 | 2020-07-08 | Lehigh | Pennsylvania | 42077 | 4354 | 312 |
311436 | 311436 | 2020-07-07 | Lehigh | Pennsylvania | 42077 | 4334 | 309 |
308267 | 308267 | 2020-07-06 | Lehigh | Pennsylvania | 42077 | 4317 | 307 |
305100 | 305100 | 2020-07-05 | Lehigh | Pennsylvania | 42077 | 4311 | 307 |
301937 | 301937 | 2020-07-04 | Lehigh | Pennsylvania | 42077 | 4303 | 307 |
298773 | 298773 | 2020-07-03 | Lehigh | Pennsylvania | 42077 | 4292 | 307 |
295614 | 295614 | 2020-07-02 | Lehigh | Pennsylvania | 42077 | 4280 | 305 |
292458 | 292458 | 2020-07-01 | Lehigh | Pennsylvania | 42077 | 4258 | 297 |
289306 | 289306 | 2020-06-30 | Lehigh | Pennsylvania | 42077 | 4235 | 297 |
286155 | 286155 | 2020-06-29 | Lehigh | Pennsylvania | 42077 | 4220 | 294 |
283010 | 283010 | 2020-06-28 | Lehigh | Pennsylvania | 42077 | 4214 | 292 |
279864 | 279864 | 2020-06-27 | Lehigh | Pennsylvania | 42077 | 4205 | 292 |
276716 | 276716 | 2020-06-26 | Lehigh | Pennsylvania | 42077 | 4187 | 288 |
273569 | 273569 | 2020-06-25 | Lehigh | Pennsylvania | 42077 | 4164 | 285 |
270430 | 270430 | 2020-06-24 | Lehigh | Pennsylvania | 42077 | 4130 | 284 |
267296 | 267296 | 2020-06-23 | Lehigh | Pennsylvania | 42077 | 4109 | 281 |
264168 | 264168 | 2020-06-22 | Lehigh | Pennsylvania | 42077 | 4091 | 279 |
261040 | 261040 | 2020-06-21 | Lehigh | Pennsylvania | 42077 | 4085 | 278 |
257913 | 257913 | 2020-06-20 | Lehigh | Pennsylvania | 42077 | 4072 | 278 |
254787 | 254787 | 2020-06-19 | Lehigh | Pennsylvania | 42077 | 4024 | 277 |
251672 | 251672 | 2020-06-18 | Lehigh | Pennsylvania | 42077 | 3997 | 276 |
248557 | 248557 | 2020-06-17 | Lehigh | Pennsylvania | 42077 | 3978 | 273 |
245444 | 245444 | 2020-06-16 | Lehigh | Pennsylvania | 42077 | 3973 | 271 |
242332 | 242332 | 2020-06-15 | Lehigh | Pennsylvania | 42077 | 3957 | 269 |
239223 | 239223 | 2020-06-14 | Lehigh | Pennsylvania | 42077 | 3953 | 267 |
236115 | 236115 | 2020-06-13 | Lehigh | Pennsylvania | 42077 | 3939 | 267 |
233010 | 233010 | 2020-06-12 | Lehigh | Pennsylvania | 42077 | 3926 | 264 |
229905 | 229905 | 2020-06-11 | Lehigh | Pennsylvania | 42077 | 3907 | 263 |
226801 | 226801 | 2020-06-10 | Lehigh | Pennsylvania | 42077 | 3895 | 259 |
223701 | 223701 | 2020-06-09 | Lehigh | Pennsylvania | 42077 | 3890 | 253 |
220606 | 220606 | 2020-06-08 | Lehigh | Pennsylvania | 42077 | 3871 | 249 |
217514 | 217514 | 2020-06-07 | Lehigh | Pennsylvania | 42077 | 3858 | 248 |
214424 | 214424 | 2020-06-06 | Lehigh | Pennsylvania | 42077 | 3846 | 248 |
211338 | 211338 | 2020-06-05 | Lehigh | Pennsylvania | 42077 | 3829 | 245 |
208256 | 208256 | 2020-06-04 | Lehigh | Pennsylvania | 42077 | 3817 | 242 |
205175 | 205175 | 2020-06-03 | Lehigh | Pennsylvania | 42077 | 3802 | 239 |
202098 | 202098 | 2020-06-02 | Lehigh | Pennsylvania | 42077 | 3780 | 235 |
199023 | 199023 | 2020-06-01 | Lehigh | Pennsylvania | 42077 | 3770 | 228 |
195950 | 195950 | 2020-05-31 | Lehigh | Pennsylvania | 42077 | 3765 | 228 |
192881 | 192881 | 2020-05-30 | Lehigh | Pennsylvania | 42077 | 3747 | 228 |
189816 | 189816 | 2020-05-29 | Lehigh | Pennsylvania | 42077 | 3738 | 222 |
186755 | 186755 | 2020-05-28 | Lehigh | Pennsylvania | 42077 | 3719 | 218 |
183698 | 183698 | 2020-05-27 | Lehigh | Pennsylvania | 42077 | 3699 | 215 |
180648 | 180648 | 2020-05-26 | Lehigh | Pennsylvania | 42077 | 3676 | 210 |
177605 | 177605 | 2020-05-25 | Lehigh | Pennsylvania | 42077 | 3667 | 209 |
174561 | 174561 | 2020-05-24 | Lehigh | Pennsylvania | 42077 | 3651 | 206 |
171519 | 171519 | 2020-05-23 | Lehigh | Pennsylvania | 42077 | 3628 | 202 |
168480 | 168480 | 2020-05-22 | Lehigh | Pennsylvania | 42077 | 3613 | 197 |
165444 | 165444 | 2020-05-21 | Lehigh | Pennsylvania | 42077 | 3586 | 192 |
162415 | 162415 | 2020-05-20 | Lehigh | Pennsylvania | 42077 | 3550 | 188 |
159388 | 159388 | 2020-05-19 | Lehigh | Pennsylvania | 42077 | 3513 | 182 |
156367 | 156367 | 2020-05-18 | Lehigh | Pennsylvania | 42077 | 3491 | 173 |
153350 | 153350 | 2020-05-17 | Lehigh | Pennsylvania | 42077 | 3470 | 139 |
150339 | 150339 | 2020-05-16 | Lehigh | Pennsylvania | 42077 | 3440 | 139 |
147332 | 147332 | 2020-05-15 | Lehigh | Pennsylvania | 42077 | 3396 | 136 |
144331 | 144331 | 2020-05-14 | Lehigh | Pennsylvania | 42077 | 3378 | 133 |
141335 | 141335 | 2020-05-13 | Lehigh | Pennsylvania | 42077 | 3318 | 129 |
138339 | 138339 | 2020-05-12 | Lehigh | Pennsylvania | 42077 | 3286 | 123 |
135349 | 135349 | 2020-05-11 | Lehigh | Pennsylvania | 42077 | 3259 | 121 |
132358 | 132358 | 2020-05-10 | Lehigh | Pennsylvania | 42077 | 3241 | 121 |
129369 | 129369 | 2020-05-09 | Lehigh | Pennsylvania | 42077 | 3169 | 120 |
126380 | 126380 | 2020-05-08 | Lehigh | Pennsylvania | 42077 | 3140 | 114 |
123397 | 123397 | 2020-05-07 | Lehigh | Pennsylvania | 42077 | 3102 | 111 |
120420 | 120420 | 2020-05-06 | Lehigh | Pennsylvania | 42077 | 3063 | 102 |
117458 | 117458 | 2020-05-05 | Lehigh | Pennsylvania | 42077 | 2999 | 94 |
114577 | 114577 | 2020-05-04 | Lehigh | Pennsylvania | 42077 | 2963 | 83 |
111695 | 111695 | 2020-05-03 | Lehigh | Pennsylvania | 42077 | 2924 | 83 |
108821 | 108821 | 2020-05-02 | Lehigh | Pennsylvania | 42077 | 2896 | 83 |
105954 | 105954 | 2020-05-01 | Lehigh | Pennsylvania | 42077 | 2850 | 80 |
103091 | 103091 | 2020-04-30 | Lehigh | Pennsylvania | 42077 | 2796 | 74 |
100238 | 100238 | 2020-04-29 | Lehigh | Pennsylvania | 42077 | 2719 | 72 |
97389 | 97389 | 2020-04-28 | Lehigh | Pennsylvania | 42077 | 2685 | 64 |
94550 | 94550 | 2020-04-27 | Lehigh | Pennsylvania | 42077 | 2636 | 56 |
91723 | 91723 | 2020-04-26 | Lehigh | Pennsylvania | 42077 | 2601 | 51 |
88907 | 88907 | 2020-04-25 | Lehigh | Pennsylvania | 42077 | 2551 | 50 |
86093 | 86093 | 2020-04-24 | Lehigh | Pennsylvania | 42077 | 2478 | 49 |
83289 | 83289 | 2020-04-23 | Lehigh | Pennsylvania | 42077 | 2418 | 49 |
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);