ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where deaths = 11 and fips = 42027 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 |
---|---|---|---|---|---|---|---|
607971 | 607971 | 2020-10-07 | Centre | Pennsylvania | 42027 | 3197 | 11 |
604728 | 604728 | 2020-10-06 | Centre | Pennsylvania | 42027 | 3171 | 11 |
601486 | 601486 | 2020-10-05 | Centre | Pennsylvania | 42027 | 3044 | 11 |
598243 | 598243 | 2020-10-04 | Centre | Pennsylvania | 42027 | 3024 | 11 |
595000 | 595000 | 2020-10-03 | Centre | Pennsylvania | 42027 | 2854 | 11 |
591759 | 591759 | 2020-10-02 | Centre | Pennsylvania | 42027 | 2854 | 11 |
588518 | 588518 | 2020-10-01 | Centre | Pennsylvania | 42027 | 2755 | 11 |
585278 | 585278 | 2020-09-30 | Centre | Pennsylvania | 42027 | 2710 | 11 |
582038 | 582038 | 2020-09-29 | Centre | Pennsylvania | 42027 | 2667 | 11 |
578798 | 578798 | 2020-09-28 | Centre | Pennsylvania | 42027 | 2551 | 11 |
575557 | 575557 | 2020-09-27 | Centre | Pennsylvania | 42027 | 2481 | 11 |
572313 | 572313 | 2020-09-26 | Centre | Pennsylvania | 42027 | 2393 | 11 |
569071 | 569071 | 2020-09-25 | Centre | Pennsylvania | 42027 | 2231 | 11 |
565830 | 565830 | 2020-09-24 | Centre | Pennsylvania | 42027 | 2202 | 11 |
562589 | 562589 | 2020-09-23 | Centre | Pennsylvania | 42027 | 2078 | 11 |
559352 | 559352 | 2020-09-22 | Centre | Pennsylvania | 42027 | 2031 | 11 |
556115 | 556115 | 2020-09-21 | Centre | Pennsylvania | 42027 | 1836 | 11 |
552878 | 552878 | 2020-09-20 | Centre | Pennsylvania | 42027 | 1799 | 11 |
549639 | 549639 | 2020-09-19 | Centre | Pennsylvania | 42027 | 1727 | 11 |
546400 | 546400 | 2020-09-18 | Centre | Pennsylvania | 42027 | 1630 | 11 |
543163 | 543163 | 2020-09-17 | Centre | Pennsylvania | 42027 | 1600 | 11 |
539927 | 539927 | 2020-09-16 | Centre | Pennsylvania | 42027 | 1508 | 11 |
536690 | 536690 | 2020-09-15 | Centre | Pennsylvania | 42027 | 1449 | 11 |
533454 | 533454 | 2020-09-14 | Centre | Pennsylvania | 42027 | 1237 | 11 |
530219 | 530219 | 2020-09-13 | Centre | Pennsylvania | 42027 | 1135 | 11 |
526982 | 526982 | 2020-09-12 | Centre | Pennsylvania | 42027 | 1135 | 11 |
523746 | 523746 | 2020-09-11 | Centre | Pennsylvania | 42027 | 1062 | 11 |
520510 | 520510 | 2020-09-10 | Centre | Pennsylvania | 42027 | 925 | 11 |
517274 | 517274 | 2020-09-09 | Centre | Pennsylvania | 42027 | 870 | 11 |
514039 | 514039 | 2020-09-08 | Centre | Pennsylvania | 42027 | 686 | 11 |
510806 | 510806 | 2020-09-07 | Centre | Pennsylvania | 42027 | 674 | 11 |
507573 | 507573 | 2020-09-06 | Centre | Pennsylvania | 42027 | 661 | 11 |
504341 | 504341 | 2020-09-05 | Centre | Pennsylvania | 42027 | 652 | 11 |
501107 | 501107 | 2020-09-04 | Centre | Pennsylvania | 42027 | 615 | 11 |
497873 | 497873 | 2020-09-03 | Centre | Pennsylvania | 42027 | 578 | 11 |
494640 | 494640 | 2020-09-02 | Centre | Pennsylvania | 42027 | 538 | 11 |
491406 | 491406 | 2020-09-01 | Centre | Pennsylvania | 42027 | 491 | 11 |
488173 | 488173 | 2020-08-31 | Centre | Pennsylvania | 42027 | 486 | 11 |
484940 | 484940 | 2020-08-30 | Centre | Pennsylvania | 42027 | 469 | 11 |
481705 | 481705 | 2020-08-29 | Centre | Pennsylvania | 42027 | 462 | 11 |
478471 | 478471 | 2020-08-28 | Centre | Pennsylvania | 42027 | 442 | 11 |
475238 | 475238 | 2020-08-27 | Centre | Pennsylvania | 42027 | 433 | 11 |
472004 | 472004 | 2020-08-26 | Centre | Pennsylvania | 42027 | 429 | 11 |
468772 | 468772 | 2020-08-25 | Centre | Pennsylvania | 42027 | 427 | 11 |
465544 | 465544 | 2020-08-24 | Centre | Pennsylvania | 42027 | 423 | 11 |
462315 | 462315 | 2020-08-23 | Centre | Pennsylvania | 42027 | 417 | 11 |
459087 | 459087 | 2020-08-22 | Centre | Pennsylvania | 42027 | 415 | 11 |
455859 | 455859 | 2020-08-21 | Centre | Pennsylvania | 42027 | 410 | 11 |
452631 | 452631 | 2020-08-20 | Centre | Pennsylvania | 42027 | 407 | 11 |
449403 | 449403 | 2020-08-19 | Centre | Pennsylvania | 42027 | 406 | 11 |
446175 | 446175 | 2020-08-18 | Centre | Pennsylvania | 42027 | 399 | 11 |
442949 | 442949 | 2020-08-17 | Centre | Pennsylvania | 42027 | 393 | 11 |
439722 | 439722 | 2020-08-16 | Centre | Pennsylvania | 42027 | 392 | 11 |
436497 | 436497 | 2020-08-15 | Centre | Pennsylvania | 42027 | 391 | 11 |
433270 | 433270 | 2020-08-14 | Centre | Pennsylvania | 42027 | 386 | 11 |
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);