ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Santa Cruz" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917422 | 917422 | 2021-01-11 | Santa Cruz | California | 6087 | 10951 | 106 |
914177 | 914177 | 2021-01-10 | Santa Cruz | California | 6087 | 10717 | 104 |
910932 | 910932 | 2021-01-09 | Santa Cruz | California | 6087 | 10486 | 104 |
907687 | 907687 | 2021-01-08 | Santa Cruz | California | 6087 | 10228 | 104 |
904441 | 904441 | 2021-01-07 | Santa Cruz | California | 6087 | 10108 | 104 |
901196 | 901196 | 2021-01-06 | Santa Cruz | California | 6087 | 9891 | 97 |
897951 | 897951 | 2021-01-05 | Santa Cruz | California | 6087 | 9700 | 93 |
894706 | 894706 | 2021-01-04 | Santa Cruz | California | 6087 | 9579 | 83 |
891459 | 891459 | 2021-01-03 | Santa Cruz | California | 6087 | 9340 | 83 |
888212 | 888212 | 2021-01-02 | Santa Cruz | California | 6087 | 9146 | 83 |
884967 | 884967 | 2021-01-01 | Santa Cruz | California | 6087 | 8909 | 83 |
881722 | 881722 | 2020-12-31 | Santa Cruz | California | 6087 | 8749 | 83 |
878477 | 878477 | 2020-12-30 | Santa Cruz | California | 6087 | 8492 | 83 |
875232 | 875232 | 2020-12-29 | Santa Cruz | California | 6087 | 8310 | 83 |
871987 | 871987 | 2020-12-28 | Santa Cruz | California | 6087 | 8234 | 83 |
868742 | 868742 | 2020-12-27 | Santa Cruz | California | 6087 | 8113 | 76 |
865497 | 865497 | 2020-12-26 | Santa Cruz | California | 6087 | 8018 | 76 |
862252 | 862252 | 2020-12-25 | Santa Cruz | California | 6087 | 7856 | 76 |
859007 | 859007 | 2020-12-24 | Santa Cruz | California | 6087 | 7637 | 76 |
855762 | 855762 | 2020-12-23 | Santa Cruz | California | 6087 | 7471 | 76 |
852517 | 852517 | 2020-12-22 | Santa Cruz | California | 6087 | 7315 | 73 |
849272 | 849272 | 2020-12-21 | Santa Cruz | California | 6087 | 7178 | 73 |
846027 | 846027 | 2020-12-20 | Santa Cruz | California | 6087 | 7054 | 70 |
842781 | 842781 | 2020-12-19 | Santa Cruz | California | 6087 | 6838 | 70 |
839536 | 839536 | 2020-12-18 | Santa Cruz | California | 6087 | 6689 | 70 |
836291 | 836291 | 2020-12-17 | Santa Cruz | California | 6087 | 6536 | 64 |
833045 | 833045 | 2020-12-16 | Santa Cruz | California | 6087 | 6361 | 64 |
829798 | 829798 | 2020-12-15 | Santa Cruz | California | 6087 | 6143 | 60 |
826552 | 826552 | 2020-12-14 | Santa Cruz | California | 6087 | 6003 | 55 |
823305 | 823305 | 2020-12-13 | Santa Cruz | California | 6087 | 5905 | 53 |
820059 | 820059 | 2020-12-12 | Santa Cruz | California | 6087 | 5764 | 53 |
816813 | 816813 | 2020-12-11 | Santa Cruz | California | 6087 | 5645 | 53 |
813567 | 813567 | 2020-12-10 | Santa Cruz | California | 6087 | 5527 | 50 |
810323 | 810323 | 2020-12-09 | Santa Cruz | California | 6087 | 5388 | 47 |
807078 | 807078 | 2020-12-08 | Santa Cruz | California | 6087 | 5176 | 47 |
803833 | 803833 | 2020-12-07 | Santa Cruz | California | 6087 | 5157 | 44 |
800588 | 800588 | 2020-12-06 | Santa Cruz | California | 6087 | 4997 | 40 |
797343 | 797343 | 2020-12-05 | Santa Cruz | California | 6087 | 4985 | 40 |
794098 | 794098 | 2020-12-04 | Santa Cruz | California | 6087 | 4850 | 40 |
790853 | 790853 | 2020-12-03 | Santa Cruz | California | 6087 | 4766 | 37 |
787608 | 787608 | 2020-12-02 | Santa Cruz | California | 6087 | 4696 | 33 |
784364 | 784364 | 2020-12-01 | Santa Cruz | California | 6087 | 4610 | 29 |
781119 | 781119 | 2020-11-30 | Santa Cruz | California | 6087 | 4529 | 28 |
777873 | 777873 | 2020-11-29 | Santa Cruz | California | 6087 | 4426 | 28 |
774628 | 774628 | 2020-11-28 | Santa Cruz | California | 6087 | 4424 | 28 |
771383 | 771383 | 2020-11-27 | Santa Cruz | California | 6087 | 4269 | 28 |
768138 | 768138 | 2020-11-26 | Santa Cruz | California | 6087 | 4202 | 28 |
764892 | 764892 | 2020-11-25 | Santa Cruz | California | 6087 | 4198 | 28 |
761647 | 761647 | 2020-11-24 | Santa Cruz | California | 6087 | 4092 | 28 |
758402 | 758402 | 2020-11-23 | Santa Cruz | California | 6087 | 3987 | 28 |
755155 | 755155 | 2020-11-22 | Santa Cruz | California | 6087 | 3898 | 27 |
751909 | 751909 | 2020-11-21 | Santa Cruz | California | 6087 | 3819 | 27 |
748663 | 748663 | 2020-11-20 | Santa Cruz | California | 6087 | 3819 | 27 |
745417 | 745417 | 2020-11-19 | Santa Cruz | California | 6087 | 3685 | 27 |
742170 | 742170 | 2020-11-18 | Santa Cruz | California | 6087 | 3628 | 27 |
738923 | 738923 | 2020-11-17 | Santa Cruz | California | 6087 | 3557 | 26 |
735679 | 735679 | 2020-11-16 | Santa Cruz | California | 6087 | 3542 | 26 |
732433 | 732433 | 2020-11-15 | Santa Cruz | California | 6087 | 3402 | 26 |
729188 | 729188 | 2020-11-14 | Santa Cruz | California | 6087 | 3356 | 26 |
725945 | 725945 | 2020-11-13 | Santa Cruz | California | 6087 | 3356 | 26 |
722702 | 722702 | 2020-11-12 | Santa Cruz | California | 6087 | 3329 | 26 |
719459 | 719459 | 2020-11-11 | Santa Cruz | California | 6087 | 3227 | 26 |
716216 | 716216 | 2020-11-10 | Santa Cruz | California | 6087 | 3227 | 26 |
712972 | 712972 | 2020-11-09 | Santa Cruz | California | 6087 | 3221 | 26 |
709728 | 709728 | 2020-11-08 | Santa Cruz | California | 6087 | 3101 | 26 |
706484 | 706484 | 2020-11-07 | Santa Cruz | California | 6087 | 3074 | 26 |
703241 | 703241 | 2020-11-06 | Santa Cruz | California | 6087 | 3074 | 26 |
699998 | 699998 | 2020-11-05 | Santa Cruz | California | 6087 | 3031 | 26 |
696754 | 696754 | 2020-11-04 | Santa Cruz | California | 6087 | 3007 | 26 |
693512 | 693512 | 2020-11-03 | Santa Cruz | California | 6087 | 2974 | 26 |
690269 | 690269 | 2020-11-02 | Santa Cruz | California | 6087 | 2964 | 26 |
687024 | 687024 | 2020-11-01 | Santa Cruz | California | 6087 | 2895 | 26 |
683780 | 683780 | 2020-10-31 | Santa Cruz | California | 6087 | 2884 | 26 |
680537 | 680537 | 2020-10-30 | Santa Cruz | California | 6087 | 2884 | 26 |
677294 | 677294 | 2020-10-29 | Santa Cruz | California | 6087 | 2861 | 25 |
674051 | 674051 | 2020-10-28 | Santa Cruz | California | 6087 | 2848 | 25 |
670809 | 670809 | 2020-10-27 | Santa Cruz | California | 6087 | 2821 | 25 |
667566 | 667566 | 2020-10-26 | Santa Cruz | California | 6087 | 2808 | 25 |
664321 | 664321 | 2020-10-25 | Santa Cruz | California | 6087 | 2802 | 25 |
661077 | 661077 | 2020-10-24 | Santa Cruz | California | 6087 | 2788 | 25 |
657833 | 657833 | 2020-10-23 | Santa Cruz | California | 6087 | 2771 | 25 |
654588 | 654588 | 2020-10-22 | Santa Cruz | California | 6087 | 2753 | 25 |
651343 | 651343 | 2020-10-21 | Santa Cruz | California | 6087 | 2744 | 25 |
648099 | 648099 | 2020-10-20 | Santa Cruz | California | 6087 | 2725 | 24 |
644854 | 644854 | 2020-10-19 | Santa Cruz | California | 6087 | 2722 | 23 |
641606 | 641606 | 2020-10-18 | Santa Cruz | California | 6087 | 2706 | 23 |
638359 | 638359 | 2020-10-17 | Santa Cruz | California | 6087 | 2696 | 23 |
635114 | 635114 | 2020-10-16 | Santa Cruz | California | 6087 | 2682 | 23 |
631868 | 631868 | 2020-10-15 | Santa Cruz | California | 6087 | 2670 | 23 |
628624 | 628624 | 2020-10-14 | Santa Cruz | California | 6087 | 2633 | 23 |
625381 | 625381 | 2020-10-13 | Santa Cruz | California | 6087 | 2618 | 20 |
622138 | 622138 | 2020-10-12 | Santa Cruz | California | 6087 | 2605 | 20 |
618895 | 618895 | 2020-10-11 | Santa Cruz | California | 6087 | 2595 | 20 |
615653 | 615653 | 2020-10-10 | Santa Cruz | California | 6087 | 2589 | 20 |
612412 | 612412 | 2020-10-09 | Santa Cruz | California | 6087 | 2563 | 20 |
609170 | 609170 | 2020-10-08 | Santa Cruz | California | 6087 | 2552 | 19 |
605927 | 605927 | 2020-10-07 | Santa Cruz | California | 6087 | 2535 | 18 |
602685 | 602685 | 2020-10-06 | Santa Cruz | California | 6087 | 2527 | 14 |
599442 | 599442 | 2020-10-05 | Santa Cruz | California | 6087 | 2519 | 12 |
596199 | 596199 | 2020-10-04 | Santa Cruz | California | 6087 | 2501 | 12 |
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);