ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Washington" and fips = 42125 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637208 | 637208 | 2020-10-16 | Washington | Pennsylvania | 42125 | 1594 | 32 |
633962 | 633962 | 2020-10-15 | Washington | Pennsylvania | 42125 | 1577 | 31 |
630717 | 630717 | 2020-10-14 | Washington | Pennsylvania | 42125 | 1563 | 31 |
627473 | 627473 | 2020-10-13 | Washington | Pennsylvania | 42125 | 1556 | 31 |
624231 | 624231 | 2020-10-12 | Washington | Pennsylvania | 42125 | 1538 | 31 |
620988 | 620988 | 2020-10-11 | Washington | Pennsylvania | 42125 | 1520 | 30 |
617745 | 617745 | 2020-10-10 | Washington | Pennsylvania | 42125 | 1507 | 30 |
614503 | 614503 | 2020-10-09 | Washington | Pennsylvania | 42125 | 1494 | 30 |
611262 | 611262 | 2020-10-08 | Washington | Pennsylvania | 42125 | 1484 | 30 |
608020 | 608020 | 2020-10-07 | Washington | Pennsylvania | 42125 | 1469 | 30 |
604777 | 604777 | 2020-10-06 | Washington | Pennsylvania | 42125 | 1465 | 30 |
601535 | 601535 | 2020-10-05 | Washington | Pennsylvania | 42125 | 1449 | 30 |
598292 | 598292 | 2020-10-04 | Washington | Pennsylvania | 42125 | 1434 | 30 |
595049 | 595049 | 2020-10-03 | Washington | Pennsylvania | 42125 | 1403 | 30 |
591808 | 591808 | 2020-10-02 | Washington | Pennsylvania | 42125 | 1403 | 30 |
588567 | 588567 | 2020-10-01 | Washington | Pennsylvania | 42125 | 1388 | 30 |
585327 | 585327 | 2020-09-30 | Washington | Pennsylvania | 42125 | 1375 | 30 |
582087 | 582087 | 2020-09-29 | Washington | Pennsylvania | 42125 | 1364 | 30 |
578847 | 578847 | 2020-09-28 | Washington | Pennsylvania | 42125 | 1346 | 30 |
575606 | 575606 | 2020-09-27 | Washington | Pennsylvania | 42125 | 1338 | 30 |
572362 | 572362 | 2020-09-26 | Washington | Pennsylvania | 42125 | 1328 | 30 |
569120 | 569120 | 2020-09-25 | Washington | Pennsylvania | 42125 | 1320 | 29 |
565879 | 565879 | 2020-09-24 | Washington | Pennsylvania | 42125 | 1311 | 29 |
562638 | 562638 | 2020-09-23 | Washington | Pennsylvania | 42125 | 1310 | 29 |
559401 | 559401 | 2020-09-22 | Washington | Pennsylvania | 42125 | 1292 | 29 |
556164 | 556164 | 2020-09-21 | Washington | Pennsylvania | 42125 | 1284 | 29 |
552927 | 552927 | 2020-09-20 | Washington | Pennsylvania | 42125 | 1280 | 29 |
549688 | 549688 | 2020-09-19 | Washington | Pennsylvania | 42125 | 1275 | 29 |
546449 | 546449 | 2020-09-18 | Washington | Pennsylvania | 42125 | 1268 | 29 |
543212 | 543212 | 2020-09-17 | Washington | Pennsylvania | 42125 | 1250 | 28 |
539976 | 539976 | 2020-09-16 | Washington | Pennsylvania | 42125 | 1238 | 28 |
536739 | 536739 | 2020-09-15 | Washington | Pennsylvania | 42125 | 1232 | 28 |
533503 | 533503 | 2020-09-14 | Washington | Pennsylvania | 42125 | 1210 | 28 |
530268 | 530268 | 2020-09-13 | Washington | Pennsylvania | 42125 | 1190 | 28 |
527031 | 527031 | 2020-09-12 | Washington | Pennsylvania | 42125 | 1190 | 28 |
523795 | 523795 | 2020-09-11 | Washington | Pennsylvania | 42125 | 1177 | 28 |
520559 | 520559 | 2020-09-10 | Washington | Pennsylvania | 42125 | 1163 | 28 |
517323 | 517323 | 2020-09-09 | Washington | Pennsylvania | 42125 | 1156 | 28 |
514088 | 514088 | 2020-09-08 | Washington | Pennsylvania | 42125 | 1150 | 28 |
510855 | 510855 | 2020-09-07 | Washington | Pennsylvania | 42125 | 1142 | 28 |
507622 | 507622 | 2020-09-06 | Washington | Pennsylvania | 42125 | 1134 | 28 |
504390 | 504390 | 2020-09-05 | Washington | Pennsylvania | 42125 | 1128 | 28 |
501156 | 501156 | 2020-09-04 | Washington | Pennsylvania | 42125 | 1117 | 28 |
497922 | 497922 | 2020-09-03 | Washington | Pennsylvania | 42125 | 1108 | 28 |
494689 | 494689 | 2020-09-02 | Washington | Pennsylvania | 42125 | 1086 | 27 |
491455 | 491455 | 2020-09-01 | Washington | Pennsylvania | 42125 | 1066 | 27 |
488222 | 488222 | 2020-08-31 | Washington | Pennsylvania | 42125 | 1054 | 27 |
484989 | 484989 | 2020-08-30 | Washington | Pennsylvania | 42125 | 1042 | 27 |
481754 | 481754 | 2020-08-29 | Washington | Pennsylvania | 42125 | 1036 | 27 |
478520 | 478520 | 2020-08-28 | Washington | Pennsylvania | 42125 | 1019 | 26 |
475287 | 475287 | 2020-08-27 | Washington | Pennsylvania | 42125 | 1001 | 25 |
472053 | 472053 | 2020-08-26 | Washington | Pennsylvania | 42125 | 994 | 24 |
468821 | 468821 | 2020-08-25 | Washington | Pennsylvania | 42125 | 983 | 24 |
465593 | 465593 | 2020-08-24 | Washington | Pennsylvania | 42125 | 979 | 22 |
462364 | 462364 | 2020-08-23 | Washington | Pennsylvania | 42125 | 976 | 22 |
459136 | 459136 | 2020-08-22 | Washington | Pennsylvania | 42125 | 968 | 22 |
455908 | 455908 | 2020-08-21 | Washington | Pennsylvania | 42125 | 956 | 22 |
452680 | 452680 | 2020-08-20 | Washington | Pennsylvania | 42125 | 941 | 21 |
449452 | 449452 | 2020-08-19 | Washington | Pennsylvania | 42125 | 930 | 21 |
446224 | 446224 | 2020-08-18 | Washington | Pennsylvania | 42125 | 924 | 20 |
442998 | 442998 | 2020-08-17 | Washington | Pennsylvania | 42125 | 910 | 17 |
439771 | 439771 | 2020-08-16 | Washington | Pennsylvania | 42125 | 903 | 17 |
436546 | 436546 | 2020-08-15 | Washington | Pennsylvania | 42125 | 899 | 17 |
433319 | 433319 | 2020-08-14 | Washington | Pennsylvania | 42125 | 891 | 16 |
430093 | 430093 | 2020-08-13 | Washington | Pennsylvania | 42125 | 880 | 14 |
426868 | 426868 | 2020-08-12 | Washington | Pennsylvania | 42125 | 871 | 13 |
423645 | 423645 | 2020-08-11 | Washington | Pennsylvania | 42125 | 862 | 13 |
420422 | 420422 | 2020-08-10 | Washington | Pennsylvania | 42125 | 855 | 13 |
417202 | 417202 | 2020-08-09 | Washington | Pennsylvania | 42125 | 840 | 12 |
413981 | 413981 | 2020-08-08 | Washington | Pennsylvania | 42125 | 829 | 12 |
410761 | 410761 | 2020-08-07 | Washington | Pennsylvania | 42125 | 821 | 12 |
407541 | 407541 | 2020-08-06 | Washington | Pennsylvania | 42125 | 808 | 11 |
404322 | 404322 | 2020-08-05 | Washington | Pennsylvania | 42125 | 785 | 11 |
401104 | 401104 | 2020-08-04 | Washington | Pennsylvania | 42125 | 773 | 11 |
397889 | 397889 | 2020-08-03 | Washington | Pennsylvania | 42125 | 764 | 11 |
394672 | 394672 | 2020-08-02 | Washington | Pennsylvania | 42125 | 756 | 11 |
391456 | 391456 | 2020-08-01 | Washington | Pennsylvania | 42125 | 747 | 11 |
388239 | 388239 | 2020-07-31 | Washington | Pennsylvania | 42125 | 740 | 11 |
385022 | 385022 | 2020-07-30 | Washington | Pennsylvania | 42125 | 723 | 11 |
381804 | 381804 | 2020-07-29 | Washington | Pennsylvania | 42125 | 710 | 10 |
378587 | 378587 | 2020-07-28 | Washington | Pennsylvania | 42125 | 699 | 10 |
375371 | 375371 | 2020-07-27 | Washington | Pennsylvania | 42125 | 681 | 10 |
372158 | 372158 | 2020-07-26 | Washington | Pennsylvania | 42125 | 669 | 10 |
368946 | 368946 | 2020-07-25 | Washington | Pennsylvania | 42125 | 654 | 10 |
365737 | 365737 | 2020-07-24 | Washington | Pennsylvania | 42125 | 637 | 10 |
362531 | 362531 | 2020-07-23 | Washington | Pennsylvania | 42125 | 613 | 10 |
359325 | 359325 | 2020-07-22 | Washington | Pennsylvania | 42125 | 603 | 10 |
356121 | 356121 | 2020-07-21 | Washington | Pennsylvania | 42125 | 592 | 10 |
352918 | 352918 | 2020-07-20 | Washington | Pennsylvania | 42125 | 580 | 10 |
349715 | 349715 | 2020-07-19 | Washington | Pennsylvania | 42125 | 559 | 10 |
346515 | 346515 | 2020-07-18 | Washington | Pennsylvania | 42125 | 540 | 9 |
343315 | 343315 | 2020-07-17 | Washington | Pennsylvania | 42125 | 535 | 7 |
340117 | 340117 | 2020-07-16 | Washington | Pennsylvania | 42125 | 518 | 7 |
336920 | 336920 | 2020-07-15 | Washington | Pennsylvania | 42125 | 494 | 6 |
333726 | 333726 | 2020-07-14 | Washington | Pennsylvania | 42125 | 465 | 6 |
330534 | 330534 | 2020-07-13 | Washington | Pennsylvania | 42125 | 454 | 6 |
327348 | 327348 | 2020-07-12 | Washington | Pennsylvania | 42125 | 447 | 6 |
324163 | 324163 | 2020-07-11 | Washington | Pennsylvania | 42125 | 430 | 6 |
320983 | 320983 | 2020-07-10 | Washington | Pennsylvania | 42125 | 410 | 6 |
317805 | 317805 | 2020-07-09 | Washington | Pennsylvania | 42125 | 366 | 6 |
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);