ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Union" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637205 | 637205 | 2020-10-16 | Union | Pennsylvania | 42119 | 634 | 7 |
633959 | 633959 | 2020-10-15 | Union | Pennsylvania | 42119 | 637 | 7 |
630714 | 630714 | 2020-10-14 | Union | Pennsylvania | 42119 | 619 | 7 |
627470 | 627470 | 2020-10-13 | Union | Pennsylvania | 42119 | 613 | 7 |
624228 | 624228 | 2020-10-12 | Union | Pennsylvania | 42119 | 611 | 7 |
620985 | 620985 | 2020-10-11 | Union | Pennsylvania | 42119 | 600 | 7 |
617742 | 617742 | 2020-10-10 | Union | Pennsylvania | 42119 | 597 | 7 |
614500 | 614500 | 2020-10-09 | Union | Pennsylvania | 42119 | 586 | 7 |
611259 | 611259 | 2020-10-08 | Union | Pennsylvania | 42119 | 577 | 7 |
608017 | 608017 | 2020-10-07 | Union | Pennsylvania | 42119 | 576 | 7 |
604774 | 604774 | 2020-10-06 | Union | Pennsylvania | 42119 | 571 | 7 |
601532 | 601532 | 2020-10-05 | Union | Pennsylvania | 42119 | 568 | 7 |
598289 | 598289 | 2020-10-04 | Union | Pennsylvania | 42119 | 558 | 6 |
595046 | 595046 | 2020-10-03 | Union | Pennsylvania | 42119 | 490 | 6 |
591805 | 591805 | 2020-10-02 | Union | Pennsylvania | 42119 | 490 | 6 |
588564 | 588564 | 2020-10-01 | Union | Pennsylvania | 42119 | 477 | 6 |
585324 | 585324 | 2020-09-30 | Union | Pennsylvania | 42119 | 472 | 6 |
582084 | 582084 | 2020-09-29 | Union | Pennsylvania | 42119 | 475 | 6 |
578844 | 578844 | 2020-09-28 | Union | Pennsylvania | 42119 | 475 | 6 |
575603 | 575603 | 2020-09-27 | Union | Pennsylvania | 42119 | 472 | 6 |
572359 | 572359 | 2020-09-26 | Union | Pennsylvania | 42119 | 472 | 6 |
569117 | 569117 | 2020-09-25 | Union | Pennsylvania | 42119 | 464 | 6 |
565876 | 565876 | 2020-09-24 | Union | Pennsylvania | 42119 | 454 | 6 |
562635 | 562635 | 2020-09-23 | Union | Pennsylvania | 42119 | 453 | 6 |
559398 | 559398 | 2020-09-22 | Union | Pennsylvania | 42119 | 462 | 6 |
556161 | 556161 | 2020-09-21 | Union | Pennsylvania | 42119 | 459 | 6 |
552924 | 552924 | 2020-09-20 | Union | Pennsylvania | 42119 | 452 | 6 |
549685 | 549685 | 2020-09-19 | Union | Pennsylvania | 42119 | 451 | 6 |
546446 | 546446 | 2020-09-18 | Union | Pennsylvania | 42119 | 451 | 6 |
543209 | 543209 | 2020-09-17 | Union | Pennsylvania | 42119 | 448 | 6 |
539973 | 539973 | 2020-09-16 | Union | Pennsylvania | 42119 | 438 | 6 |
536736 | 536736 | 2020-09-15 | Union | Pennsylvania | 42119 | 439 | 6 |
533500 | 533500 | 2020-09-14 | Union | Pennsylvania | 42119 | 435 | 6 |
530265 | 530265 | 2020-09-13 | Union | Pennsylvania | 42119 | 425 | 6 |
527028 | 527028 | 2020-09-12 | Union | Pennsylvania | 42119 | 425 | 6 |
523792 | 523792 | 2020-09-11 | Union | Pennsylvania | 42119 | 420 | 6 |
520556 | 520556 | 2020-09-10 | Union | Pennsylvania | 42119 | 416 | 6 |
517320 | 517320 | 2020-09-09 | Union | Pennsylvania | 42119 | 411 | 6 |
514085 | 514085 | 2020-09-08 | Union | Pennsylvania | 42119 | 414 | 6 |
510852 | 510852 | 2020-09-07 | Union | Pennsylvania | 42119 | 417 | 6 |
507619 | 507619 | 2020-09-06 | Union | Pennsylvania | 42119 | 406 | 6 |
504387 | 504387 | 2020-09-05 | Union | Pennsylvania | 42119 | 407 | 6 |
501153 | 501153 | 2020-09-04 | Union | Pennsylvania | 42119 | 397 | 6 |
497919 | 497919 | 2020-09-03 | Union | Pennsylvania | 42119 | 397 | 6 |
494686 | 494686 | 2020-09-02 | Union | Pennsylvania | 42119 | 390 | 6 |
491452 | 491452 | 2020-09-01 | Union | Pennsylvania | 42119 | 386 | 6 |
488219 | 488219 | 2020-08-31 | Union | Pennsylvania | 42119 | 377 | 4 |
484986 | 484986 | 2020-08-30 | Union | Pennsylvania | 42119 | 371 | 4 |
481751 | 481751 | 2020-08-29 | Union | Pennsylvania | 42119 | 367 | 4 |
478517 | 478517 | 2020-08-28 | Union | Pennsylvania | 42119 | 372 | 4 |
475284 | 475284 | 2020-08-27 | Union | Pennsylvania | 42119 | 359 | 4 |
472050 | 472050 | 2020-08-26 | Union | Pennsylvania | 42119 | 359 | 4 |
468818 | 468818 | 2020-08-25 | Union | Pennsylvania | 42119 | 359 | 4 |
465590 | 465590 | 2020-08-24 | Union | Pennsylvania | 42119 | 361 | 4 |
462361 | 462361 | 2020-08-23 | Union | Pennsylvania | 42119 | 359 | 4 |
459133 | 459133 | 2020-08-22 | Union | Pennsylvania | 42119 | 354 | 4 |
455905 | 455905 | 2020-08-21 | Union | Pennsylvania | 42119 | 347 | 3 |
452677 | 452677 | 2020-08-20 | Union | Pennsylvania | 42119 | 344 | 2 |
449449 | 449449 | 2020-08-19 | Union | Pennsylvania | 42119 | 322 | 2 |
446221 | 446221 | 2020-08-18 | Union | Pennsylvania | 42119 | 310 | 2 |
442995 | 442995 | 2020-08-17 | Union | Pennsylvania | 42119 | 305 | 2 |
439768 | 439768 | 2020-08-16 | Union | Pennsylvania | 42119 | 306 | 2 |
436543 | 436543 | 2020-08-15 | Union | Pennsylvania | 42119 | 292 | 2 |
433316 | 433316 | 2020-08-14 | Union | Pennsylvania | 42119 | 279 | 2 |
430090 | 430090 | 2020-08-13 | Union | Pennsylvania | 42119 | 276 | 2 |
426865 | 426865 | 2020-08-12 | Union | Pennsylvania | 42119 | 276 | 2 |
423642 | 423642 | 2020-08-11 | Union | Pennsylvania | 42119 | 262 | 2 |
420419 | 420419 | 2020-08-10 | Union | Pennsylvania | 42119 | 238 | 2 |
417199 | 417199 | 2020-08-09 | Union | Pennsylvania | 42119 | 225 | 2 |
413978 | 413978 | 2020-08-08 | Union | Pennsylvania | 42119 | 218 | 2 |
410758 | 410758 | 2020-08-07 | Union | Pennsylvania | 42119 | 216 | 2 |
407538 | 407538 | 2020-08-06 | Union | Pennsylvania | 42119 | 206 | 2 |
404319 | 404319 | 2020-08-05 | Union | Pennsylvania | 42119 | 201 | 2 |
401101 | 401101 | 2020-08-04 | Union | Pennsylvania | 42119 | 191 | 2 |
397886 | 397886 | 2020-08-03 | Union | Pennsylvania | 42119 | 173 | 2 |
394669 | 394669 | 2020-08-02 | Union | Pennsylvania | 42119 | 172 | 2 |
391453 | 391453 | 2020-08-01 | Union | Pennsylvania | 42119 | 165 | 2 |
388236 | 388236 | 2020-07-31 | Union | Pennsylvania | 42119 | 132 | 2 |
385019 | 385019 | 2020-07-30 | Union | Pennsylvania | 42119 | 135 | 2 |
381801 | 381801 | 2020-07-29 | Union | Pennsylvania | 42119 | 129 | 2 |
378584 | 378584 | 2020-07-28 | Union | Pennsylvania | 42119 | 128 | 2 |
375368 | 375368 | 2020-07-27 | Union | Pennsylvania | 42119 | 124 | 2 |
372155 | 372155 | 2020-07-26 | Union | Pennsylvania | 42119 | 123 | 2 |
368943 | 368943 | 2020-07-25 | Union | Pennsylvania | 42119 | 119 | 2 |
365734 | 365734 | 2020-07-24 | Union | Pennsylvania | 42119 | 116 | 2 |
362528 | 362528 | 2020-07-23 | Union | Pennsylvania | 42119 | 115 | 2 |
359322 | 359322 | 2020-07-22 | Union | Pennsylvania | 42119 | 113 | 2 |
356118 | 356118 | 2020-07-21 | Union | Pennsylvania | 42119 | 113 | 2 |
352915 | 352915 | 2020-07-20 | Union | Pennsylvania | 42119 | 114 | 2 |
349712 | 349712 | 2020-07-19 | Union | Pennsylvania | 42119 | 111 | 2 |
346512 | 346512 | 2020-07-18 | Union | Pennsylvania | 42119 | 110 | 2 |
343312 | 343312 | 2020-07-17 | Union | Pennsylvania | 42119 | 109 | 2 |
340114 | 340114 | 2020-07-16 | Union | Pennsylvania | 42119 | 108 | 2 |
336917 | 336917 | 2020-07-15 | Union | Pennsylvania | 42119 | 108 | 2 |
333723 | 333723 | 2020-07-14 | Union | Pennsylvania | 42119 | 105 | 2 |
330531 | 330531 | 2020-07-13 | Union | Pennsylvania | 42119 | 100 | 2 |
327345 | 327345 | 2020-07-12 | Union | Pennsylvania | 42119 | 99 | 2 |
324160 | 324160 | 2020-07-11 | Union | Pennsylvania | 42119 | 98 | 2 |
320980 | 320980 | 2020-07-10 | Union | Pennsylvania | 42119 | 97 | 2 |
317802 | 317802 | 2020-07-09 | Union | Pennsylvania | 42119 | 97 | 2 |
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);