ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
834 rows where fips = 6085 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953120 | 953120 | 2021-01-22 | Santa Clara | California | 6085 | 96340 | 1182 |
949875 | 949875 | 2021-01-21 | Santa Clara | California | 6085 | 95936 | 1159 |
946629 | 946629 | 2021-01-20 | Santa Clara | California | 6085 | 94905 | 1130 |
943382 | 943382 | 2021-01-19 | Santa Clara | California | 6085 | 94366 | 1110 |
940137 | 940137 | 2021-01-18 | Santa Clara | California | 6085 | 93557 | 1077 |
936892 | 936892 | 2021-01-17 | Santa Clara | California | 6085 | 92625 | 1066 |
933647 | 933647 | 2021-01-16 | Santa Clara | California | 6085 | 91466 | 1061 |
930402 | 930402 | 2021-01-15 | Santa Clara | California | 6085 | 89983 | 1041 |
927157 | 927157 | 2021-01-14 | Santa Clara | California | 6085 | 88379 | 1029 |
923911 | 923911 | 2021-01-13 | Santa Clara | California | 6085 | 87045 | 1012 |
920666 | 920666 | 2021-01-12 | Santa Clara | California | 6085 | 85929 | 987 |
917421 | 917421 | 2021-01-11 | Santa Clara | California | 6085 | 84726 | 945 |
914176 | 914176 | 2021-01-10 | Santa Clara | California | 6085 | 83655 | 920 |
910931 | 910931 | 2021-01-09 | Santa Clara | California | 6085 | 82170 | 884 |
907686 | 907686 | 2021-01-08 | Santa Clara | California | 6085 | 80466 | 844 |
904440 | 904440 | 2021-01-07 | Santa Clara | California | 6085 | 78683 | 816 |
901195 | 901195 | 2021-01-06 | Santa Clara | California | 6085 | 77366 | 800 |
897950 | 897950 | 2021-01-05 | Santa Clara | California | 6085 | 76235 | 772 |
894705 | 894705 | 2021-01-04 | Santa Clara | California | 6085 | 74527 | 748 |
891458 | 891458 | 2021-01-03 | Santa Clara | California | 6085 | 74359 | 748 |
888211 | 888211 | 2021-01-02 | Santa Clara | California | 6085 | 73493 | 748 |
884966 | 884966 | 2021-01-01 | Santa Clara | California | 6085 | 71755 | 748 |
881721 | 881721 | 2020-12-31 | Santa Clara | California | 6085 | 69879 | 710 |
878476 | 878476 | 2020-12-30 | Santa Clara | California | 6085 | 67581 | 674 |
875231 | 875231 | 2020-12-29 | Santa Clara | California | 6085 | 67423 | 674 |
871986 | 871986 | 2020-12-28 | Santa Clara | California | 6085 | 66270 | 653 |
868741 | 868741 | 2020-12-27 | Santa Clara | California | 6085 | 64974 | 653 |
865496 | 865496 | 2020-12-26 | Santa Clara | California | 6085 | 63302 | 653 |
862251 | 862251 | 2020-12-25 | Santa Clara | California | 6085 | 61742 | 644 |
859006 | 859006 | 2020-12-24 | Santa Clara | California | 6085 | 61090 | 644 |
855761 | 855761 | 2020-12-23 | Santa Clara | California | 6085 | 59923 | 633 |
852516 | 852516 | 2020-12-22 | Santa Clara | California | 6085 | 58637 | 616 |
849271 | 849271 | 2020-12-21 | Santa Clara | California | 6085 | 57452 | 608 |
846026 | 846026 | 2020-12-20 | Santa Clara | California | 6085 | 56334 | 584 |
842780 | 842780 | 2020-12-19 | Santa Clara | California | 6085 | 54905 | 584 |
839535 | 839535 | 2020-12-18 | Santa Clara | California | 6085 | 53885 | 584 |
836290 | 836290 | 2020-12-17 | Santa Clara | California | 6085 | 52414 | 567 |
833044 | 833044 | 2020-12-16 | Santa Clara | California | 6085 | 51233 | 562 |
829797 | 829797 | 2020-12-15 | Santa Clara | California | 6085 | 50315 | 554 |
826551 | 826551 | 2020-12-14 | Santa Clara | California | 6085 | 49216 | 530 |
823304 | 823304 | 2020-12-13 | Santa Clara | California | 6085 | 48015 | 527 |
820058 | 820058 | 2020-12-12 | Santa Clara | California | 6085 | 45986 | 527 |
816812 | 816812 | 2020-12-11 | Santa Clara | California | 6085 | 45178 | 527 |
813566 | 813566 | 2020-12-10 | Santa Clara | California | 6085 | 44039 | 520 |
810322 | 810322 | 2020-12-09 | Santa Clara | California | 6085 | 43001 | 516 |
807077 | 807077 | 2020-12-08 | Santa Clara | California | 6085 | 41316 | 513 |
803832 | 803832 | 2020-12-07 | Santa Clara | California | 6085 | 40624 | 512 |
800587 | 800587 | 2020-12-06 | Santa Clara | California | 6085 | 39193 | 504 |
797342 | 797342 | 2020-12-05 | Santa Clara | California | 6085 | 38388 | 504 |
794097 | 794097 | 2020-12-04 | Santa Clara | California | 6085 | 37517 | 504 |
790852 | 790852 | 2020-12-03 | Santa Clara | California | 6085 | 36673 | 496 |
787607 | 787607 | 2020-12-02 | Santa Clara | California | 6085 | 35945 | 487 |
784363 | 784363 | 2020-12-01 | Santa Clara | California | 6085 | 35457 | 483 |
781118 | 781118 | 2020-11-30 | Santa Clara | California | 6085 | 35085 | 477 |
777872 | 777872 | 2020-11-29 | Santa Clara | California | 6085 | 34292 | 477 |
774627 | 774627 | 2020-11-28 | Santa Clara | California | 6085 | 33732 | 477 |
771382 | 771382 | 2020-11-27 | Santa Clara | California | 6085 | 32985 | 477 |
768137 | 768137 | 2020-11-26 | Santa Clara | California | 6085 | 32454 | 477 |
764891 | 764891 | 2020-11-25 | Santa Clara | California | 6085 | 32049 | 471 |
761646 | 761646 | 2020-11-24 | Santa Clara | California | 6085 | 31603 | 468 |
758401 | 758401 | 2020-11-23 | Santa Clara | California | 6085 | 31103 | 465 |
755154 | 755154 | 2020-11-22 | Santa Clara | California | 6085 | 30676 | 464 |
751908 | 751908 | 2020-11-21 | Santa Clara | California | 6085 | 30411 | 464 |
748662 | 748662 | 2020-11-20 | Santa Clara | California | 6085 | 30025 | 464 |
745416 | 745416 | 2020-11-19 | Santa Clara | California | 6085 | 29631 | 460 |
742169 | 742169 | 2020-11-18 | Santa Clara | California | 6085 | 29297 | 454 |
738922 | 738922 | 2020-11-17 | Santa Clara | California | 6085 | 29023 | 448 |
735678 | 735678 | 2020-11-16 | Santa Clara | California | 6085 | 28686 | 446 |
732432 | 732432 | 2020-11-15 | Santa Clara | California | 6085 | 28307 | 445 |
729187 | 729187 | 2020-11-14 | Santa Clara | California | 6085 | 27977 | 445 |
725944 | 725944 | 2020-11-13 | Santa Clara | California | 6085 | 27648 | 445 |
722701 | 722701 | 2020-11-12 | Santa Clara | California | 6085 | 27299 | 441 |
719458 | 719458 | 2020-11-11 | Santa Clara | California | 6085 | 27124 | 441 |
716215 | 716215 | 2020-11-10 | Santa Clara | California | 6085 | 26972 | 437 |
712971 | 712971 | 2020-11-09 | Santa Clara | California | 6085 | 26747 | 434 |
709727 | 709727 | 2020-11-08 | Santa Clara | California | 6085 | 26490 | 431 |
706483 | 706483 | 2020-11-07 | Santa Clara | California | 6085 | 26137 | 431 |
703240 | 703240 | 2020-11-06 | Santa Clara | California | 6085 | 25883 | 431 |
699997 | 699997 | 2020-11-05 | Santa Clara | California | 6085 | 25705 | 425 |
696753 | 696753 | 2020-11-04 | Santa Clara | California | 6085 | 25543 | 422 |
693511 | 693511 | 2020-11-03 | Santa Clara | California | 6085 | 25421 | 413 |
690268 | 690268 | 2020-11-02 | Santa Clara | California | 6085 | 25277 | 410 |
687023 | 687023 | 2020-11-01 | Santa Clara | California | 6085 | 25139 | 407 |
683779 | 683779 | 2020-10-31 | Santa Clara | California | 6085 | 24986 | 407 |
680536 | 680536 | 2020-10-30 | Santa Clara | California | 6085 | 24867 | 407 |
677293 | 677293 | 2020-10-29 | Santa Clara | California | 6085 | 24665 | 405 |
674050 | 674050 | 2020-10-28 | Santa Clara | California | 6085 | 24558 | 403 |
670808 | 670808 | 2020-10-27 | Santa Clara | California | 6085 | 24425 | 393 |
667565 | 667565 | 2020-10-26 | Santa Clara | California | 6085 | 24313 | 389 |
664320 | 664320 | 2020-10-25 | Santa Clara | California | 6085 | 24144 | 389 |
661076 | 661076 | 2020-10-24 | Santa Clara | California | 6085 | 24014 | 389 |
657832 | 657832 | 2020-10-23 | Santa Clara | California | 6085 | 23881 | 389 |
654587 | 654587 | 2020-10-22 | Santa Clara | California | 6085 | 23679 | 386 |
651342 | 651342 | 2020-10-21 | Santa Clara | California | 6085 | 23591 | 386 |
648098 | 648098 | 2020-10-20 | Santa Clara | California | 6085 | 23458 | 383 |
644853 | 644853 | 2020-10-19 | Santa Clara | California | 6085 | 23355 | 379 |
641605 | 641605 | 2020-10-18 | Santa Clara | California | 6085 | 23224 | 374 |
638358 | 638358 | 2020-10-17 | Santa Clara | California | 6085 | 23052 | 374 |
635113 | 635113 | 2020-10-16 | Santa Clara | California | 6085 | 22974 | 374 |
631867 | 631867 | 2020-10-15 | Santa Clara | California | 6085 | 22859 | 368 |
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);