ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where county = "Somerset", deaths = 3 and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
715058 | 715058 | 2020-11-09 | Somerset | Pennsylvania | 42111 | 597 | 3 |
711814 | 711814 | 2020-11-08 | Somerset | Pennsylvania | 42111 | 573 | 3 |
708570 | 708570 | 2020-11-07 | Somerset | Pennsylvania | 42111 | 559 | 3 |
705327 | 705327 | 2020-11-06 | Somerset | Pennsylvania | 42111 | 531 | 3 |
702084 | 702084 | 2020-11-05 | Somerset | Pennsylvania | 42111 | 514 | 3 |
698840 | 698840 | 2020-11-04 | Somerset | Pennsylvania | 42111 | 511 | 3 |
695597 | 695597 | 2020-11-03 | Somerset | Pennsylvania | 42111 | 498 | 3 |
692355 | 692355 | 2020-11-02 | Somerset | Pennsylvania | 42111 | 488 | 3 |
689111 | 689111 | 2020-11-01 | Somerset | Pennsylvania | 42111 | 474 | 3 |
685866 | 685866 | 2020-10-31 | Somerset | Pennsylvania | 42111 | 461 | 3 |
682623 | 682623 | 2020-10-30 | Somerset | Pennsylvania | 42111 | 449 | 3 |
679380 | 679380 | 2020-10-29 | Somerset | Pennsylvania | 42111 | 434 | 3 |
676137 | 676137 | 2020-10-28 | Somerset | Pennsylvania | 42111 | 420 | 3 |
672894 | 672894 | 2020-10-27 | Somerset | Pennsylvania | 42111 | 412 | 3 |
669652 | 669652 | 2020-10-26 | Somerset | Pennsylvania | 42111 | 398 | 3 |
666408 | 666408 | 2020-10-25 | Somerset | Pennsylvania | 42111 | 391 | 3 |
663163 | 663163 | 2020-10-24 | Somerset | Pennsylvania | 42111 | 372 | 3 |
659919 | 659919 | 2020-10-23 | Somerset | Pennsylvania | 42111 | 355 | 3 |
656675 | 656675 | 2020-10-22 | Somerset | Pennsylvania | 42111 | 344 | 3 |
653430 | 653430 | 2020-10-21 | Somerset | Pennsylvania | 42111 | 334 | 3 |
650185 | 650185 | 2020-10-20 | Somerset | Pennsylvania | 42111 | 331 | 3 |
646941 | 646941 | 2020-10-19 | Somerset | Pennsylvania | 42111 | 325 | 3 |
643695 | 643695 | 2020-10-18 | Somerset | Pennsylvania | 42111 | 319 | 3 |
640447 | 640447 | 2020-10-17 | Somerset | Pennsylvania | 42111 | 313 | 3 |
637201 | 637201 | 2020-10-16 | Somerset | Pennsylvania | 42111 | 308 | 3 |
633955 | 633955 | 2020-10-15 | Somerset | Pennsylvania | 42111 | 284 | 3 |
630710 | 630710 | 2020-10-14 | Somerset | Pennsylvania | 42111 | 279 | 3 |
627466 | 627466 | 2020-10-13 | Somerset | Pennsylvania | 42111 | 278 | 3 |
624224 | 624224 | 2020-10-12 | Somerset | Pennsylvania | 42111 | 274 | 3 |
620981 | 620981 | 2020-10-11 | Somerset | Pennsylvania | 42111 | 273 | 3 |
617738 | 617738 | 2020-10-10 | Somerset | Pennsylvania | 42111 | 265 | 3 |
614496 | 614496 | 2020-10-09 | Somerset | Pennsylvania | 42111 | 261 | 3 |
611255 | 611255 | 2020-10-08 | Somerset | Pennsylvania | 42111 | 259 | 3 |
608013 | 608013 | 2020-10-07 | Somerset | Pennsylvania | 42111 | 246 | 3 |
604770 | 604770 | 2020-10-06 | Somerset | Pennsylvania | 42111 | 239 | 3 |
601528 | 601528 | 2020-10-05 | Somerset | Pennsylvania | 42111 | 238 | 3 |
598285 | 598285 | 2020-10-04 | Somerset | Pennsylvania | 42111 | 238 | 3 |
595042 | 595042 | 2020-10-03 | Somerset | Pennsylvania | 42111 | 231 | 3 |
591801 | 591801 | 2020-10-02 | Somerset | Pennsylvania | 42111 | 231 | 3 |
588560 | 588560 | 2020-10-01 | Somerset | Pennsylvania | 42111 | 225 | 3 |
585320 | 585320 | 2020-09-30 | Somerset | Pennsylvania | 42111 | 220 | 3 |
582080 | 582080 | 2020-09-29 | Somerset | Pennsylvania | 42111 | 219 | 3 |
578840 | 578840 | 2020-09-28 | Somerset | Pennsylvania | 42111 | 219 | 3 |
575599 | 575599 | 2020-09-27 | Somerset | Pennsylvania | 42111 | 218 | 3 |
572355 | 572355 | 2020-09-26 | Somerset | Pennsylvania | 42111 | 215 | 3 |
569113 | 569113 | 2020-09-25 | Somerset | Pennsylvania | 42111 | 212 | 3 |
565872 | 565872 | 2020-09-24 | Somerset | Pennsylvania | 42111 | 211 | 3 |
562631 | 562631 | 2020-09-23 | Somerset | Pennsylvania | 42111 | 211 | 3 |
559394 | 559394 | 2020-09-22 | Somerset | Pennsylvania | 42111 | 206 | 3 |
556157 | 556157 | 2020-09-21 | Somerset | Pennsylvania | 42111 | 206 | 3 |
552920 | 552920 | 2020-09-20 | Somerset | Pennsylvania | 42111 | 205 | 3 |
549681 | 549681 | 2020-09-19 | Somerset | Pennsylvania | 42111 | 203 | 3 |
546442 | 546442 | 2020-09-18 | Somerset | Pennsylvania | 42111 | 201 | 3 |
543205 | 543205 | 2020-09-17 | Somerset | Pennsylvania | 42111 | 197 | 3 |
539969 | 539969 | 2020-09-16 | Somerset | Pennsylvania | 42111 | 195 | 3 |
536732 | 536732 | 2020-09-15 | Somerset | Pennsylvania | 42111 | 195 | 3 |
533496 | 533496 | 2020-09-14 | Somerset | Pennsylvania | 42111 | 195 | 3 |
530261 | 530261 | 2020-09-13 | Somerset | Pennsylvania | 42111 | 195 | 3 |
527024 | 527024 | 2020-09-12 | Somerset | Pennsylvania | 42111 | 195 | 3 |
523788 | 523788 | 2020-09-11 | Somerset | Pennsylvania | 42111 | 192 | 3 |
520552 | 520552 | 2020-09-10 | Somerset | Pennsylvania | 42111 | 190 | 3 |
517316 | 517316 | 2020-09-09 | Somerset | Pennsylvania | 42111 | 186 | 3 |
514081 | 514081 | 2020-09-08 | Somerset | Pennsylvania | 42111 | 183 | 3 |
510848 | 510848 | 2020-09-07 | Somerset | Pennsylvania | 42111 | 182 | 3 |
507615 | 507615 | 2020-09-06 | Somerset | Pennsylvania | 42111 | 182 | 3 |
504383 | 504383 | 2020-09-05 | Somerset | Pennsylvania | 42111 | 181 | 3 |
501149 | 501149 | 2020-09-04 | Somerset | Pennsylvania | 42111 | 179 | 3 |
497915 | 497915 | 2020-09-03 | Somerset | Pennsylvania | 42111 | 174 | 3 |
494682 | 494682 | 2020-09-02 | Somerset | Pennsylvania | 42111 | 172 | 3 |
491448 | 491448 | 2020-09-01 | Somerset | Pennsylvania | 42111 | 167 | 3 |
488215 | 488215 | 2020-08-31 | Somerset | Pennsylvania | 42111 | 165 | 3 |
484982 | 484982 | 2020-08-30 | Somerset | Pennsylvania | 42111 | 164 | 3 |
481747 | 481747 | 2020-08-29 | Somerset | Pennsylvania | 42111 | 164 | 3 |
478513 | 478513 | 2020-08-28 | Somerset | Pennsylvania | 42111 | 162 | 3 |
475280 | 475280 | 2020-08-27 | Somerset | Pennsylvania | 42111 | 161 | 3 |
472046 | 472046 | 2020-08-26 | Somerset | Pennsylvania | 42111 | 160 | 3 |
468814 | 468814 | 2020-08-25 | Somerset | Pennsylvania | 42111 | 157 | 3 |
465586 | 465586 | 2020-08-24 | Somerset | Pennsylvania | 42111 | 156 | 3 |
462357 | 462357 | 2020-08-23 | Somerset | Pennsylvania | 42111 | 156 | 3 |
459129 | 459129 | 2020-08-22 | Somerset | Pennsylvania | 42111 | 153 | 3 |
455901 | 455901 | 2020-08-21 | Somerset | Pennsylvania | 42111 | 151 | 3 |
452673 | 452673 | 2020-08-20 | Somerset | Pennsylvania | 42111 | 146 | 3 |
449445 | 449445 | 2020-08-19 | Somerset | Pennsylvania | 42111 | 145 | 3 |
446217 | 446217 | 2020-08-18 | Somerset | Pennsylvania | 42111 | 143 | 3 |
442991 | 442991 | 2020-08-17 | Somerset | Pennsylvania | 42111 | 143 | 3 |
439764 | 439764 | 2020-08-16 | Somerset | Pennsylvania | 42111 | 142 | 3 |
436539 | 436539 | 2020-08-15 | Somerset | Pennsylvania | 42111 | 142 | 3 |
433312 | 433312 | 2020-08-14 | Somerset | Pennsylvania | 42111 | 140 | 3 |
430086 | 430086 | 2020-08-13 | Somerset | Pennsylvania | 42111 | 138 | 3 |
426861 | 426861 | 2020-08-12 | Somerset | Pennsylvania | 42111 | 138 | 3 |
423638 | 423638 | 2020-08-11 | Somerset | Pennsylvania | 42111 | 136 | 3 |
420415 | 420415 | 2020-08-10 | Somerset | Pennsylvania | 42111 | 135 | 3 |
417195 | 417195 | 2020-08-09 | Somerset | Pennsylvania | 42111 | 134 | 3 |
413974 | 413974 | 2020-08-08 | Somerset | Pennsylvania | 42111 | 133 | 3 |
410754 | 410754 | 2020-08-07 | Somerset | Pennsylvania | 42111 | 129 | 3 |
407534 | 407534 | 2020-08-06 | Somerset | Pennsylvania | 42111 | 127 | 3 |
404315 | 404315 | 2020-08-05 | Somerset | Pennsylvania | 42111 | 127 | 3 |
401097 | 401097 | 2020-08-04 | Somerset | Pennsylvania | 42111 | 128 | 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);