ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 42049 and state = "Pennsylvania" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282996 | 282996 | 2020-06-28 | Erie | Pennsylvania | 42049 | 589 | 13 |
286141 | 286141 | 2020-06-29 | Erie | Pennsylvania | 42049 | 595 | 13 |
289292 | 289292 | 2020-06-30 | Erie | Pennsylvania | 42049 | 607 | 13 |
292444 | 292444 | 2020-07-01 | Erie | Pennsylvania | 42049 | 620 | 13 |
295600 | 295600 | 2020-07-02 | Erie | Pennsylvania | 42049 | 626 | 13 |
298759 | 298759 | 2020-07-03 | Erie | Pennsylvania | 42049 | 642 | 13 |
301923 | 301923 | 2020-07-04 | Erie | Pennsylvania | 42049 | 646 | 13 |
305086 | 305086 | 2020-07-05 | Erie | Pennsylvania | 42049 | 650 | 13 |
308253 | 308253 | 2020-07-06 | Erie | Pennsylvania | 42049 | 661 | 13 |
311422 | 311422 | 2020-07-07 | Erie | Pennsylvania | 42049 | 679 | 13 |
314594 | 314594 | 2020-07-08 | Erie | Pennsylvania | 42049 | 691 | 13 |
317767 | 317767 | 2020-07-09 | Erie | Pennsylvania | 42049 | 699 | 13 |
320945 | 320945 | 2020-07-10 | Erie | Pennsylvania | 42049 | 704 | 13 |
324125 | 324125 | 2020-07-11 | Erie | Pennsylvania | 42049 | 707 | 13 |
327310 | 327310 | 2020-07-12 | Erie | Pennsylvania | 42049 | 712 | 13 |
330496 | 330496 | 2020-07-13 | Erie | Pennsylvania | 42049 | 718 | 13 |
333688 | 333688 | 2020-07-14 | Erie | Pennsylvania | 42049 | 740 | 13 |
336882 | 336882 | 2020-07-15 | Erie | Pennsylvania | 42049 | 747 | 13 |
340079 | 340079 | 2020-07-16 | Erie | Pennsylvania | 42049 | 756 | 13 |
343277 | 343277 | 2020-07-17 | Erie | Pennsylvania | 42049 | 763 | 13 |
346477 | 346477 | 2020-07-18 | Erie | Pennsylvania | 42049 | 769 | 13 |
349677 | 349677 | 2020-07-19 | Erie | Pennsylvania | 42049 | 781 | 13 |
352880 | 352880 | 2020-07-20 | Erie | Pennsylvania | 42049 | 787 | 13 |
356083 | 356083 | 2020-07-21 | Erie | Pennsylvania | 42049 | 805 | 13 |
359287 | 359287 | 2020-07-22 | Erie | Pennsylvania | 42049 | 813 | 13 |
362493 | 362493 | 2020-07-23 | Erie | Pennsylvania | 42049 | 818 | 14 |
365699 | 365699 | 2020-07-24 | Erie | Pennsylvania | 42049 | 838 | 14 |
368908 | 368908 | 2020-07-25 | Erie | Pennsylvania | 42049 | 847 | 15 |
372120 | 372120 | 2020-07-26 | Erie | Pennsylvania | 42049 | 856 | 15 |
375333 | 375333 | 2020-07-27 | Erie | Pennsylvania | 42049 | 865 | 15 |
378549 | 378549 | 2020-07-28 | Erie | Pennsylvania | 42049 | 871 | 15 |
381766 | 381766 | 2020-07-29 | Erie | Pennsylvania | 42049 | 891 | 15 |
384984 | 384984 | 2020-07-30 | Erie | Pennsylvania | 42049 | 905 | 15 |
388201 | 388201 | 2020-07-31 | Erie | Pennsylvania | 42049 | 923 | 16 |
391418 | 391418 | 2020-08-01 | Erie | Pennsylvania | 42049 | 954 | 16 |
394634 | 394634 | 2020-08-02 | Erie | Pennsylvania | 42049 | 967 | 16 |
397851 | 397851 | 2020-08-03 | Erie | Pennsylvania | 42049 | 983 | 16 |
401066 | 401066 | 2020-08-04 | Erie | Pennsylvania | 42049 | 1025 | 17 |
404284 | 404284 | 2020-08-05 | Erie | Pennsylvania | 42049 | 1037 | 17 |
407503 | 407503 | 2020-08-06 | Erie | Pennsylvania | 42049 | 1046 | 17 |
410723 | 410723 | 2020-08-07 | Erie | Pennsylvania | 42049 | 1058 | 18 |
413943 | 413943 | 2020-08-08 | Erie | Pennsylvania | 42049 | 1094 | 18 |
417164 | 417164 | 2020-08-09 | Erie | Pennsylvania | 42049 | 1102 | 19 |
420384 | 420384 | 2020-08-10 | Erie | Pennsylvania | 42049 | 1110 | 19 |
423607 | 423607 | 2020-08-11 | Erie | Pennsylvania | 42049 | 1126 | 21 |
426830 | 426830 | 2020-08-12 | Erie | Pennsylvania | 42049 | 1143 | 22 |
430055 | 430055 | 2020-08-13 | Erie | Pennsylvania | 42049 | 1163 | 22 |
433281 | 433281 | 2020-08-14 | Erie | Pennsylvania | 42049 | 1182 | 27 |
436508 | 436508 | 2020-08-15 | Erie | Pennsylvania | 42049 | 1200 | 27 |
439733 | 439733 | 2020-08-16 | Erie | Pennsylvania | 42049 | 1211 | 27 |
442960 | 442960 | 2020-08-17 | Erie | Pennsylvania | 42049 | 1217 | 27 |
446186 | 446186 | 2020-08-18 | Erie | Pennsylvania | 42049 | 1229 | 28 |
449414 | 449414 | 2020-08-19 | Erie | Pennsylvania | 42049 | 1245 | 28 |
452642 | 452642 | 2020-08-20 | Erie | Pennsylvania | 42049 | 1264 | 28 |
455870 | 455870 | 2020-08-21 | Erie | Pennsylvania | 42049 | 1271 | 28 |
459098 | 459098 | 2020-08-22 | Erie | Pennsylvania | 42049 | 1283 | 29 |
462326 | 462326 | 2020-08-23 | Erie | Pennsylvania | 42049 | 1296 | 29 |
465555 | 465555 | 2020-08-24 | Erie | Pennsylvania | 42049 | 1297 | 29 |
468783 | 468783 | 2020-08-25 | Erie | Pennsylvania | 42049 | 1305 | 30 |
472015 | 472015 | 2020-08-26 | Erie | Pennsylvania | 42049 | 1313 | 30 |
475249 | 475249 | 2020-08-27 | Erie | Pennsylvania | 42049 | 1321 | 30 |
478482 | 478482 | 2020-08-28 | Erie | Pennsylvania | 42049 | 1335 | 30 |
481716 | 481716 | 2020-08-29 | Erie | Pennsylvania | 42049 | 1345 | 32 |
484951 | 484951 | 2020-08-30 | Erie | Pennsylvania | 42049 | 1348 | 33 |
488184 | 488184 | 2020-08-31 | Erie | Pennsylvania | 42049 | 1349 | 33 |
491417 | 491417 | 2020-09-01 | Erie | Pennsylvania | 42049 | 1358 | 35 |
494651 | 494651 | 2020-09-02 | Erie | Pennsylvania | 42049 | 1369 | 35 |
497884 | 497884 | 2020-09-03 | Erie | Pennsylvania | 42049 | 1370 | 35 |
501118 | 501118 | 2020-09-04 | Erie | Pennsylvania | 42049 | 1376 | 36 |
504352 | 504352 | 2020-09-05 | Erie | Pennsylvania | 42049 | 1387 | 36 |
507584 | 507584 | 2020-09-06 | Erie | Pennsylvania | 42049 | 1390 | 36 |
510817 | 510817 | 2020-09-07 | Erie | Pennsylvania | 42049 | 1393 | 36 |
514050 | 514050 | 2020-09-08 | Erie | Pennsylvania | 42049 | 1395 | 36 |
517285 | 517285 | 2020-09-09 | Erie | Pennsylvania | 42049 | 1408 | 36 |
520521 | 520521 | 2020-09-10 | Erie | Pennsylvania | 42049 | 1407 | 37 |
523757 | 523757 | 2020-09-11 | Erie | Pennsylvania | 42049 | 1411 | 37 |
526993 | 526993 | 2020-09-12 | Erie | Pennsylvania | 42049 | 1421 | 37 |
530230 | 530230 | 2020-09-13 | Erie | Pennsylvania | 42049 | 1421 | 37 |
533465 | 533465 | 2020-09-14 | Erie | Pennsylvania | 42049 | 1423 | 37 |
536701 | 536701 | 2020-09-15 | Erie | Pennsylvania | 42049 | 1435 | 37 |
539938 | 539938 | 2020-09-16 | Erie | Pennsylvania | 42049 | 1439 | 37 |
543174 | 543174 | 2020-09-17 | Erie | Pennsylvania | 42049 | 1446 | 37 |
546411 | 546411 | 2020-09-18 | Erie | Pennsylvania | 42049 | 1459 | 37 |
549650 | 549650 | 2020-09-19 | Erie | Pennsylvania | 42049 | 1466 | 37 |
552889 | 552889 | 2020-09-20 | Erie | Pennsylvania | 42049 | 1475 | 37 |
556126 | 556126 | 2020-09-21 | Erie | Pennsylvania | 42049 | 1483 | 48 |
559363 | 559363 | 2020-09-22 | Erie | Pennsylvania | 42049 | 1491 | 48 |
562600 | 562600 | 2020-09-23 | Erie | Pennsylvania | 42049 | 1504 | 48 |
565841 | 565841 | 2020-09-24 | Erie | Pennsylvania | 42049 | 1514 | 48 |
569082 | 569082 | 2020-09-25 | Erie | Pennsylvania | 42049 | 1526 | 48 |
572324 | 572324 | 2020-09-26 | Erie | Pennsylvania | 42049 | 1537 | 48 |
575568 | 575568 | 2020-09-27 | Erie | Pennsylvania | 42049 | 1544 | 48 |
578809 | 578809 | 2020-09-28 | Erie | Pennsylvania | 42049 | 1552 | 48 |
582049 | 582049 | 2020-09-29 | Erie | Pennsylvania | 42049 | 1563 | 48 |
585289 | 585289 | 2020-09-30 | Erie | Pennsylvania | 42049 | 1567 | 48 |
588529 | 588529 | 2020-10-01 | Erie | Pennsylvania | 42049 | 1579 | 48 |
591770 | 591770 | 2020-10-02 | Erie | Pennsylvania | 42049 | 1603 | 48 |
595011 | 595011 | 2020-10-03 | Erie | Pennsylvania | 42049 | 1603 | 48 |
598254 | 598254 | 2020-10-04 | Erie | Pennsylvania | 42049 | 1643 | 48 |
601497 | 601497 | 2020-10-05 | Erie | Pennsylvania | 42049 | 1656 | 48 |
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);