ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where county = "Clarion", deaths = 3 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
659879 | 659879 | 2020-10-23 | Clarion | Pennsylvania | 42031 | 200 | 3 |
656635 | 656635 | 2020-10-22 | Clarion | Pennsylvania | 42031 | 197 | 3 |
653390 | 653390 | 2020-10-21 | Clarion | Pennsylvania | 42031 | 188 | 3 |
650145 | 650145 | 2020-10-20 | Clarion | Pennsylvania | 42031 | 186 | 3 |
646901 | 646901 | 2020-10-19 | Clarion | Pennsylvania | 42031 | 181 | 3 |
643655 | 643655 | 2020-10-18 | Clarion | Pennsylvania | 42031 | 178 | 3 |
640407 | 640407 | 2020-10-17 | Clarion | Pennsylvania | 42031 | 177 | 3 |
637161 | 637161 | 2020-10-16 | Clarion | Pennsylvania | 42031 | 174 | 3 |
633915 | 633915 | 2020-10-15 | Clarion | Pennsylvania | 42031 | 171 | 3 |
630670 | 630670 | 2020-10-14 | Clarion | Pennsylvania | 42031 | 166 | 3 |
627426 | 627426 | 2020-10-13 | Clarion | Pennsylvania | 42031 | 165 | 3 |
624184 | 624184 | 2020-10-12 | Clarion | Pennsylvania | 42031 | 164 | 3 |
620941 | 620941 | 2020-10-11 | Clarion | Pennsylvania | 42031 | 162 | 3 |
617698 | 617698 | 2020-10-10 | Clarion | Pennsylvania | 42031 | 158 | 3 |
614456 | 614456 | 2020-10-09 | Clarion | Pennsylvania | 42031 | 154 | 3 |
611215 | 611215 | 2020-10-08 | Clarion | Pennsylvania | 42031 | 150 | 3 |
607973 | 607973 | 2020-10-07 | Clarion | Pennsylvania | 42031 | 145 | 3 |
604730 | 604730 | 2020-10-06 | Clarion | Pennsylvania | 42031 | 142 | 3 |
601488 | 601488 | 2020-10-05 | Clarion | Pennsylvania | 42031 | 139 | 3 |
598245 | 598245 | 2020-10-04 | Clarion | Pennsylvania | 42031 | 137 | 3 |
595002 | 595002 | 2020-10-03 | Clarion | Pennsylvania | 42031 | 130 | 3 |
591761 | 591761 | 2020-10-02 | Clarion | Pennsylvania | 42031 | 130 | 3 |
588520 | 588520 | 2020-10-01 | Clarion | Pennsylvania | 42031 | 129 | 3 |
585280 | 585280 | 2020-09-30 | Clarion | Pennsylvania | 42031 | 127 | 3 |
582040 | 582040 | 2020-09-29 | Clarion | Pennsylvania | 42031 | 127 | 3 |
578800 | 578800 | 2020-09-28 | Clarion | Pennsylvania | 42031 | 122 | 3 |
575559 | 575559 | 2020-09-27 | Clarion | Pennsylvania | 42031 | 122 | 3 |
572315 | 572315 | 2020-09-26 | Clarion | Pennsylvania | 42031 | 121 | 3 |
569073 | 569073 | 2020-09-25 | Clarion | Pennsylvania | 42031 | 120 | 3 |
565832 | 565832 | 2020-09-24 | Clarion | Pennsylvania | 42031 | 117 | 3 |
562591 | 562591 | 2020-09-23 | Clarion | Pennsylvania | 42031 | 116 | 3 |
559354 | 559354 | 2020-09-22 | Clarion | Pennsylvania | 42031 | 116 | 3 |
556117 | 556117 | 2020-09-21 | Clarion | Pennsylvania | 42031 | 114 | 3 |
552880 | 552880 | 2020-09-20 | Clarion | Pennsylvania | 42031 | 114 | 3 |
549641 | 549641 | 2020-09-19 | Clarion | Pennsylvania | 42031 | 115 | 3 |
546402 | 546402 | 2020-09-18 | Clarion | Pennsylvania | 42031 | 113 | 3 |
543165 | 543165 | 2020-09-17 | Clarion | Pennsylvania | 42031 | 113 | 3 |
539929 | 539929 | 2020-09-16 | Clarion | Pennsylvania | 42031 | 112 | 3 |
536692 | 536692 | 2020-09-15 | Clarion | Pennsylvania | 42031 | 112 | 3 |
533456 | 533456 | 2020-09-14 | Clarion | Pennsylvania | 42031 | 112 | 3 |
530221 | 530221 | 2020-09-13 | Clarion | Pennsylvania | 42031 | 110 | 3 |
526984 | 526984 | 2020-09-12 | Clarion | Pennsylvania | 42031 | 110 | 3 |
523748 | 523748 | 2020-09-11 | Clarion | Pennsylvania | 42031 | 107 | 3 |
520512 | 520512 | 2020-09-10 | Clarion | Pennsylvania | 42031 | 107 | 3 |
517276 | 517276 | 2020-09-09 | Clarion | Pennsylvania | 42031 | 107 | 3 |
514041 | 514041 | 2020-09-08 | Clarion | Pennsylvania | 42031 | 102 | 3 |
510808 | 510808 | 2020-09-07 | Clarion | Pennsylvania | 42031 | 102 | 3 |
507575 | 507575 | 2020-09-06 | Clarion | Pennsylvania | 42031 | 101 | 3 |
504343 | 504343 | 2020-09-05 | Clarion | Pennsylvania | 42031 | 100 | 3 |
501109 | 501109 | 2020-09-04 | Clarion | Pennsylvania | 42031 | 100 | 3 |
497875 | 497875 | 2020-09-03 | Clarion | Pennsylvania | 42031 | 98 | 3 |
494642 | 494642 | 2020-09-02 | Clarion | Pennsylvania | 42031 | 98 | 3 |
491408 | 491408 | 2020-09-01 | Clarion | Pennsylvania | 42031 | 98 | 3 |
488175 | 488175 | 2020-08-31 | Clarion | Pennsylvania | 42031 | 98 | 3 |
484942 | 484942 | 2020-08-30 | Clarion | Pennsylvania | 42031 | 99 | 3 |
481707 | 481707 | 2020-08-29 | Clarion | Pennsylvania | 42031 | 98 | 3 |
478473 | 478473 | 2020-08-28 | Clarion | Pennsylvania | 42031 | 98 | 3 |
475240 | 475240 | 2020-08-27 | Clarion | Pennsylvania | 42031 | 99 | 3 |
472006 | 472006 | 2020-08-26 | Clarion | Pennsylvania | 42031 | 96 | 3 |
468774 | 468774 | 2020-08-25 | Clarion | Pennsylvania | 42031 | 96 | 3 |
465546 | 465546 | 2020-08-24 | Clarion | Pennsylvania | 42031 | 95 | 3 |
462317 | 462317 | 2020-08-23 | Clarion | Pennsylvania | 42031 | 95 | 3 |
459089 | 459089 | 2020-08-22 | Clarion | Pennsylvania | 42031 | 95 | 3 |
455861 | 455861 | 2020-08-21 | Clarion | Pennsylvania | 42031 | 95 | 3 |
452633 | 452633 | 2020-08-20 | Clarion | Pennsylvania | 42031 | 95 | 3 |
449405 | 449405 | 2020-08-19 | Clarion | Pennsylvania | 42031 | 93 | 3 |
446177 | 446177 | 2020-08-18 | Clarion | Pennsylvania | 42031 | 94 | 3 |
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);