ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 42017 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536685 | 536685 | 2020-09-15 | Bucks | Pennsylvania | 42017 | 8349 | 596 |
533449 | 533449 | 2020-09-14 | Bucks | Pennsylvania | 42017 | 8294 | 595 |
530214 | 530214 | 2020-09-13 | Bucks | Pennsylvania | 42017 | 8229 | 594 |
526977 | 526977 | 2020-09-12 | Bucks | Pennsylvania | 42017 | 8229 | 594 |
523741 | 523741 | 2020-09-11 | Bucks | Pennsylvania | 42017 | 8198 | 594 |
520505 | 520505 | 2020-09-10 | Bucks | Pennsylvania | 42017 | 8148 | 592 |
517269 | 517269 | 2020-09-09 | Bucks | Pennsylvania | 42017 | 8128 | 591 |
514034 | 514034 | 2020-09-08 | Bucks | Pennsylvania | 42017 | 8093 | 590 |
510801 | 510801 | 2020-09-07 | Bucks | Pennsylvania | 42017 | 8084 | 590 |
507568 | 507568 | 2020-09-06 | Bucks | Pennsylvania | 42017 | 8048 | 589 |
504336 | 504336 | 2020-09-05 | Bucks | Pennsylvania | 42017 | 8003 | 589 |
501102 | 501102 | 2020-09-04 | Bucks | Pennsylvania | 42017 | 7961 | 589 |
497868 | 497868 | 2020-09-03 | Bucks | Pennsylvania | 42017 | 7899 | 588 |
494635 | 494635 | 2020-09-02 | Bucks | Pennsylvania | 42017 | 7856 | 587 |
491401 | 491401 | 2020-09-01 | Bucks | Pennsylvania | 42017 | 7824 | 586 |
488168 | 488168 | 2020-08-31 | Bucks | Pennsylvania | 42017 | 7805 | 586 |
484935 | 484935 | 2020-08-30 | Bucks | Pennsylvania | 42017 | 7777 | 586 |
481700 | 481700 | 2020-08-29 | Bucks | Pennsylvania | 42017 | 7744 | 586 |
478466 | 478466 | 2020-08-28 | Bucks | Pennsylvania | 42017 | 7705 | 585 |
475233 | 475233 | 2020-08-27 | Bucks | Pennsylvania | 42017 | 7666 | 585 |
471999 | 471999 | 2020-08-26 | Bucks | Pennsylvania | 42017 | 7641 | 585 |
468767 | 468767 | 2020-08-25 | Bucks | Pennsylvania | 42017 | 7623 | 585 |
465539 | 465539 | 2020-08-24 | Bucks | Pennsylvania | 42017 | 7607 | 584 |
462310 | 462310 | 2020-08-23 | Bucks | Pennsylvania | 42017 | 7580 | 584 |
459082 | 459082 | 2020-08-22 | Bucks | Pennsylvania | 42017 | 7562 | 584 |
455854 | 455854 | 2020-08-21 | Bucks | Pennsylvania | 42017 | 7535 | 584 |
452626 | 452626 | 2020-08-20 | Bucks | Pennsylvania | 42017 | 7512 | 584 |
449398 | 449398 | 2020-08-19 | Bucks | Pennsylvania | 42017 | 7481 | 584 |
446170 | 446170 | 2020-08-18 | Bucks | Pennsylvania | 42017 | 7458 | 584 |
442944 | 442944 | 2020-08-17 | Bucks | Pennsylvania | 42017 | 7441 | 583 |
439717 | 439717 | 2020-08-16 | Bucks | Pennsylvania | 42017 | 7419 | 583 |
436492 | 436492 | 2020-08-15 | Bucks | Pennsylvania | 42017 | 7382 | 583 |
433265 | 433265 | 2020-08-14 | Bucks | Pennsylvania | 42017 | 7344 | 583 |
430039 | 430039 | 2020-08-13 | Bucks | Pennsylvania | 42017 | 7318 | 582 |
426814 | 426814 | 2020-08-12 | Bucks | Pennsylvania | 42017 | 7275 | 582 |
423591 | 423591 | 2020-08-11 | Bucks | Pennsylvania | 42017 | 7231 | 582 |
420368 | 420368 | 2020-08-10 | Bucks | Pennsylvania | 42017 | 7210 | 582 |
417148 | 417148 | 2020-08-09 | Bucks | Pennsylvania | 42017 | 7197 | 582 |
413927 | 413927 | 2020-08-08 | Bucks | Pennsylvania | 42017 | 7173 | 582 |
410707 | 410707 | 2020-08-07 | Bucks | Pennsylvania | 42017 | 7147 | 582 |
407487 | 407487 | 2020-08-06 | Bucks | Pennsylvania | 42017 | 7118 | 581 |
404268 | 404268 | 2020-08-05 | Bucks | Pennsylvania | 42017 | 7085 | 580 |
401050 | 401050 | 2020-08-04 | Bucks | Pennsylvania | 42017 | 7056 | 580 |
397835 | 397835 | 2020-08-03 | Bucks | Pennsylvania | 42017 | 7020 | 579 |
394618 | 394618 | 2020-08-02 | Bucks | Pennsylvania | 42017 | 6995 | 579 |
391402 | 391402 | 2020-08-01 | Bucks | Pennsylvania | 42017 | 6959 | 578 |
388185 | 388185 | 2020-07-31 | Bucks | Pennsylvania | 42017 | 6902 | 578 |
384968 | 384968 | 2020-07-30 | Bucks | Pennsylvania | 42017 | 6847 | 577 |
381750 | 381750 | 2020-07-29 | Bucks | Pennsylvania | 42017 | 6796 | 574 |
378533 | 378533 | 2020-07-28 | Bucks | Pennsylvania | 42017 | 6771 | 574 |
375317 | 375317 | 2020-07-27 | Bucks | Pennsylvania | 42017 | 6718 | 574 |
372104 | 372104 | 2020-07-26 | Bucks | Pennsylvania | 42017 | 6690 | 574 |
368892 | 368892 | 2020-07-25 | Bucks | Pennsylvania | 42017 | 6664 | 574 |
365683 | 365683 | 2020-07-24 | Bucks | Pennsylvania | 42017 | 6614 | 574 |
362477 | 362477 | 2020-07-23 | Bucks | Pennsylvania | 42017 | 6542 | 574 |
359271 | 359271 | 2020-07-22 | Bucks | Pennsylvania | 42017 | 6513 | 573 |
356067 | 356067 | 2020-07-21 | Bucks | Pennsylvania | 42017 | 6467 | 573 |
352864 | 352864 | 2020-07-20 | Bucks | Pennsylvania | 42017 | 6387 | 573 |
349661 | 349661 | 2020-07-19 | Bucks | Pennsylvania | 42017 | 6353 | 573 |
346461 | 346461 | 2020-07-18 | Bucks | Pennsylvania | 42017 | 6320 | 573 |
343261 | 343261 | 2020-07-17 | Bucks | Pennsylvania | 42017 | 6284 | 573 |
340063 | 340063 | 2020-07-16 | Bucks | Pennsylvania | 42017 | 6228 | 572 |
336866 | 336866 | 2020-07-15 | Bucks | Pennsylvania | 42017 | 6189 | 572 |
333672 | 333672 | 2020-07-14 | Bucks | Pennsylvania | 42017 | 6137 | 572 |
330480 | 330480 | 2020-07-13 | Bucks | Pennsylvania | 42017 | 6105 | 572 |
327294 | 327294 | 2020-07-12 | Bucks | Pennsylvania | 42017 | 6083 | 572 |
324109 | 324109 | 2020-07-11 | Bucks | Pennsylvania | 42017 | 6064 | 572 |
320929 | 320929 | 2020-07-10 | Bucks | Pennsylvania | 42017 | 6030 | 572 |
317751 | 317751 | 2020-07-09 | Bucks | Pennsylvania | 42017 | 6003 | 571 |
314578 | 314578 | 2020-07-08 | Bucks | Pennsylvania | 42017 | 5967 | 570 |
311406 | 311406 | 2020-07-07 | Bucks | Pennsylvania | 42017 | 5948 | 570 |
308237 | 308237 | 2020-07-06 | Bucks | Pennsylvania | 42017 | 5912 | 568 |
305070 | 305070 | 2020-07-05 | Bucks | Pennsylvania | 42017 | 5883 | 567 |
301907 | 301907 | 2020-07-04 | Bucks | Pennsylvania | 42017 | 5844 | 567 |
298743 | 298743 | 2020-07-03 | Bucks | Pennsylvania | 42017 | 5829 | 567 |
295584 | 295584 | 2020-07-02 | Bucks | Pennsylvania | 42017 | 5801 | 565 |
292428 | 292428 | 2020-07-01 | Bucks | Pennsylvania | 42017 | 5777 | 564 |
289276 | 289276 | 2020-06-30 | Bucks | Pennsylvania | 42017 | 5744 | 564 |
286125 | 286125 | 2020-06-29 | Bucks | Pennsylvania | 42017 | 5729 | 563 |
282980 | 282980 | 2020-06-28 | Bucks | Pennsylvania | 42017 | 5718 | 564 |
279834 | 279834 | 2020-06-27 | Bucks | Pennsylvania | 42017 | 5704 | 563 |
276686 | 276686 | 2020-06-26 | Bucks | Pennsylvania | 42017 | 5676 | 561 |
273539 | 273539 | 2020-06-25 | Bucks | Pennsylvania | 42017 | 5649 | 560 |
270400 | 270400 | 2020-06-24 | Bucks | Pennsylvania | 42017 | 5619 | 559 |
267266 | 267266 | 2020-06-23 | Bucks | Pennsylvania | 42017 | 5580 | 555 |
264138 | 264138 | 2020-06-22 | Bucks | Pennsylvania | 42017 | 5567 | 552 |
261010 | 261010 | 2020-06-21 | Bucks | Pennsylvania | 42017 | 5547 | 552 |
257883 | 257883 | 2020-06-20 | Bucks | Pennsylvania | 42017 | 5535 | 552 |
254757 | 254757 | 2020-06-19 | Bucks | Pennsylvania | 42017 | 5510 | 551 |
251642 | 251642 | 2020-06-18 | Bucks | Pennsylvania | 42017 | 5498 | 549 |
248527 | 248527 | 2020-06-17 | Bucks | Pennsylvania | 42017 | 5466 | 546 |
245414 | 245414 | 2020-06-16 | Bucks | Pennsylvania | 42017 | 5452 | 544 |
242302 | 242302 | 2020-06-15 | Bucks | Pennsylvania | 42017 | 5439 | 542 |
239193 | 239193 | 2020-06-14 | Bucks | Pennsylvania | 42017 | 5428 | 542 |
236085 | 236085 | 2020-06-13 | Bucks | Pennsylvania | 42017 | 5419 | 542 |
232980 | 232980 | 2020-06-12 | Bucks | Pennsylvania | 42017 | 5396 | 541 |
229875 | 229875 | 2020-06-11 | Bucks | Pennsylvania | 42017 | 5365 | 540 |
226771 | 226771 | 2020-06-10 | Bucks | Pennsylvania | 42017 | 5340 | 534 |
223671 | 223671 | 2020-06-09 | Bucks | Pennsylvania | 42017 | 5304 | 532 |
220576 | 220576 | 2020-06-08 | Bucks | Pennsylvania | 42017 | 5278 | 529 |
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);