ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
844 rows where fips = 53061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
770994 | 770994 | 2020-11-26 | Snohomish | Washington | 53061 | 14925 | 287 |
767748 | 767748 | 2020-11-25 | Snohomish | Washington | 53061 | 14925 | 287 |
764503 | 764503 | 2020-11-24 | Snohomish | Washington | 53061 | 14715 | 288 |
761258 | 761258 | 2020-11-23 | Snohomish | Washington | 53061 | 14443 | 279 |
758013 | 758013 | 2020-11-22 | Snohomish | Washington | 53061 | 13639 | 272 |
754766 | 754766 | 2020-11-21 | Snohomish | Washington | 53061 | 13639 | 272 |
751520 | 751520 | 2020-11-20 | Snohomish | Washington | 53061 | 13639 | 272 |
748274 | 748274 | 2020-11-19 | Snohomish | Washington | 53061 | 13428 | 269 |
745028 | 745028 | 2020-11-18 | Snohomish | Washington | 53061 | 13269 | 269 |
741781 | 741781 | 2020-11-17 | Snohomish | Washington | 53061 | 13111 | 263 |
738534 | 738534 | 2020-11-16 | Snohomish | Washington | 53061 | 12965 | 263 |
735290 | 735290 | 2020-11-15 | Snohomish | Washington | 53061 | 12301 | 258 |
732044 | 732044 | 2020-11-14 | Snohomish | Washington | 53061 | 12301 | 258 |
728799 | 728799 | 2020-11-13 | Snohomish | Washington | 53061 | 12301 | 258 |
725556 | 725556 | 2020-11-12 | Snohomish | Washington | 53061 | 12013 | 259 |
722313 | 722313 | 2020-11-11 | Snohomish | Washington | 53061 | 11747 | 259 |
719070 | 719070 | 2020-11-10 | Snohomish | Washington | 53061 | 11747 | 259 |
715827 | 715827 | 2020-11-09 | Snohomish | Washington | 53061 | 11609 | 256 |
712583 | 712583 | 2020-11-08 | Snohomish | Washington | 53061 | 11129 | 251 |
709339 | 709339 | 2020-11-07 | Snohomish | Washington | 53061 | 11129 | 251 |
706095 | 706095 | 2020-11-06 | Snohomish | Washington | 53061 | 11129 | 251 |
702852 | 702852 | 2020-11-05 | Snohomish | Washington | 53061 | 10877 | 251 |
699609 | 699609 | 2020-11-04 | Snohomish | Washington | 53061 | 10723 | 248 |
696365 | 696365 | 2020-11-03 | Snohomish | Washington | 53061 | 10587 | 246 |
693123 | 693123 | 2020-11-02 | Snohomish | Washington | 53061 | 10505 | 245 |
689879 | 689879 | 2020-11-01 | Snohomish | Washington | 53061 | 10219 | 244 |
686634 | 686634 | 2020-10-31 | Snohomish | Washington | 53061 | 10219 | 244 |
683391 | 683391 | 2020-10-30 | Snohomish | Washington | 53061 | 10219 | 244 |
680148 | 680148 | 2020-10-29 | Snohomish | Washington | 53061 | 10126 | 243 |
676905 | 676905 | 2020-10-28 | Snohomish | Washington | 53061 | 10025 | 245 |
673662 | 673662 | 2020-10-27 | Snohomish | Washington | 53061 | 9948 | 241 |
670420 | 670420 | 2020-10-26 | Snohomish | Washington | 53061 | 9891 | 241 |
667177 | 667177 | 2020-10-25 | Snohomish | Washington | 53061 | 9659 | 239 |
663932 | 663932 | 2020-10-24 | Snohomish | Washington | 53061 | 9659 | 239 |
660688 | 660688 | 2020-10-23 | Snohomish | Washington | 53061 | 9659 | 239 |
657444 | 657444 | 2020-10-22 | Snohomish | Washington | 53061 | 9562 | 239 |
654199 | 654199 | 2020-10-21 | Snohomish | Washington | 53061 | 9478 | 238 |
650954 | 650954 | 2020-10-20 | Snohomish | Washington | 53061 | 9402 | 236 |
647710 | 647710 | 2020-10-19 | Snohomish | Washington | 53061 | 9322 | 234 |
644464 | 644464 | 2020-10-18 | Snohomish | Washington | 53061 | 9125 | 231 |
641216 | 641216 | 2020-10-17 | Snohomish | Washington | 53061 | 9125 | 231 |
637969 | 637969 | 2020-10-16 | Snohomish | Washington | 53061 | 9125 | 231 |
634724 | 634724 | 2020-10-15 | Snohomish | Washington | 53061 | 9047 | 230 |
631479 | 631479 | 2020-10-14 | Snohomish | Washington | 53061 | 8951 | 229 |
628235 | 628235 | 2020-10-13 | Snohomish | Washington | 53061 | 8869 | 229 |
624992 | 624992 | 2020-10-12 | Snohomish | Washington | 53061 | 8813 | 229 |
621749 | 621749 | 2020-10-11 | Snohomish | Washington | 53061 | 8595 | 229 |
618506 | 618506 | 2020-10-10 | Snohomish | Washington | 53061 | 8595 | 229 |
615264 | 615264 | 2020-10-09 | Snohomish | Washington | 53061 | 8595 | 229 |
612023 | 612023 | 2020-10-08 | Snohomish | Washington | 53061 | 8525 | 228 |
608781 | 608781 | 2020-10-07 | Snohomish | Washington | 53061 | 8482 | 225 |
605538 | 605538 | 2020-10-06 | Snohomish | Washington | 53061 | 8435 | 225 |
602296 | 602296 | 2020-10-05 | Snohomish | Washington | 53061 | 8372 | 225 |
599053 | 599053 | 2020-10-04 | Snohomish | Washington | 53061 | 8283 | 223 |
595810 | 595810 | 2020-10-03 | Snohomish | Washington | 53061 | 8283 | 223 |
592568 | 592568 | 2020-10-02 | Snohomish | Washington | 53061 | 8283 | 223 |
589328 | 589328 | 2020-10-01 | Snohomish | Washington | 53061 | 8221 | 223 |
586087 | 586087 | 2020-09-30 | Snohomish | Washington | 53061 | 8173 | 223 |
582847 | 582847 | 2020-09-29 | Snohomish | Washington | 53061 | 8127 | 226 |
579608 | 579608 | 2020-09-28 | Snohomish | Washington | 53061 | 8100 | 223 |
576367 | 576367 | 2020-09-27 | Snohomish | Washington | 53061 | 8016 | 223 |
573123 | 573123 | 2020-09-26 | Snohomish | Washington | 53061 | 8016 | 223 |
569881 | 569881 | 2020-09-25 | Snohomish | Washington | 53061 | 8016 | 223 |
566640 | 566640 | 2020-09-24 | Snohomish | Washington | 53061 | 7955 | 222 |
563399 | 563399 | 2020-09-23 | Snohomish | Washington | 53061 | 7944 | 222 |
560160 | 560160 | 2020-09-22 | Snohomish | Washington | 53061 | 7697 | 224 |
556924 | 556924 | 2020-09-21 | Snohomish | Washington | 53061 | 7673 | 221 |
553687 | 553687 | 2020-09-20 | Snohomish | Washington | 53061 | 7616 | 221 |
550448 | 550448 | 2020-09-19 | Snohomish | Washington | 53061 | 7616 | 221 |
547209 | 547209 | 2020-09-18 | Snohomish | Washington | 53061 | 7616 | 221 |
543972 | 543972 | 2020-09-17 | Snohomish | Washington | 53061 | 7588 | 219 |
540736 | 540736 | 2020-09-16 | Snohomish | Washington | 53061 | 7555 | 219 |
537499 | 537499 | 2020-09-15 | Snohomish | Washington | 53061 | 7528 | 219 |
534263 | 534263 | 2020-09-14 | Snohomish | Washington | 53061 | 7510 | 218 |
531028 | 531028 | 2020-09-13 | Snohomish | Washington | 53061 | 7385 | 216 |
527791 | 527791 | 2020-09-12 | Snohomish | Washington | 53061 | 7385 | 216 |
524555 | 524555 | 2020-09-11 | Snohomish | Washington | 53061 | 7385 | 216 |
521319 | 521319 | 2020-09-10 | Snohomish | Washington | 53061 | 7363 | 216 |
518082 | 518082 | 2020-09-09 | Snohomish | Washington | 53061 | 7327 | 216 |
514847 | 514847 | 2020-09-08 | Snohomish | Washington | 53061 | 7304 | 218 |
511614 | 511614 | 2020-09-07 | Snohomish | Washington | 53061 | 7204 | 218 |
508381 | 508381 | 2020-09-06 | Snohomish | Washington | 53061 | 7204 | 218 |
505149 | 505149 | 2020-09-05 | Snohomish | Washington | 53061 | 7204 | 218 |
501915 | 501915 | 2020-09-04 | Snohomish | Washington | 53061 | 7204 | 218 |
498681 | 498681 | 2020-09-03 | Snohomish | Washington | 53061 | 7173 | 218 |
495448 | 495448 | 2020-09-02 | Snohomish | Washington | 53061 | 7146 | 218 |
492214 | 492214 | 2020-09-01 | Snohomish | Washington | 53061 | 7113 | 219 |
488981 | 488981 | 2020-08-31 | Snohomish | Washington | 53061 | 7085 | 220 |
485748 | 485748 | 2020-08-30 | Snohomish | Washington | 53061 | 7005 | 220 |
482513 | 482513 | 2020-08-29 | Snohomish | Washington | 53061 | 7005 | 220 |
479279 | 479279 | 2020-08-28 | Snohomish | Washington | 53061 | 7005 | 220 |
476046 | 476046 | 2020-08-27 | Snohomish | Washington | 53061 | 6960 | 219 |
472813 | 472813 | 2020-08-26 | Snohomish | Washington | 53061 | 6911 | 219 |
469581 | 469581 | 2020-08-25 | Snohomish | Washington | 53061 | 6858 | 218 |
466352 | 466352 | 2020-08-24 | Snohomish | Washington | 53061 | 6833 | 218 |
463123 | 463123 | 2020-08-23 | Snohomish | Washington | 53061 | 6752 | 217 |
459894 | 459894 | 2020-08-22 | Snohomish | Washington | 53061 | 6752 | 217 |
456667 | 456667 | 2020-08-21 | Snohomish | Washington | 53061 | 6752 | 218 |
453439 | 453439 | 2020-08-20 | Snohomish | Washington | 53061 | 6714 | 218 |
450211 | 450211 | 2020-08-19 | Snohomish | Washington | 53061 | 6668 | 216 |
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);