ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Lake" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923885 | 923885 | 2021-01-13 | Lake | California | 6033 | 2260 | 27 |
920640 | 920640 | 2021-01-12 | Lake | California | 6033 | 2205 | 27 |
917395 | 917395 | 2021-01-11 | Lake | California | 6033 | 2174 | 26 |
914150 | 914150 | 2021-01-10 | Lake | California | 6033 | 2144 | 26 |
910905 | 910905 | 2021-01-09 | Lake | California | 6033 | 2098 | 26 |
907660 | 907660 | 2021-01-08 | Lake | California | 6033 | 2054 | 25 |
904414 | 904414 | 2021-01-07 | Lake | California | 6033 | 2033 | 25 |
901169 | 901169 | 2021-01-06 | Lake | California | 6033 | 2015 | 25 |
897924 | 897924 | 2021-01-05 | Lake | California | 6033 | 1984 | 24 |
894679 | 894679 | 2021-01-04 | Lake | California | 6033 | 1976 | 24 |
891432 | 891432 | 2021-01-03 | Lake | California | 6033 | 1925 | 24 |
888185 | 888185 | 2021-01-02 | Lake | California | 6033 | 1888 | 24 |
884940 | 884940 | 2021-01-01 | Lake | California | 6033 | 1848 | 24 |
881695 | 881695 | 2020-12-31 | Lake | California | 6033 | 1817 | 23 |
878450 | 878450 | 2020-12-30 | Lake | California | 6033 | 1805 | 23 |
875205 | 875205 | 2020-12-29 | Lake | California | 6033 | 1785 | 23 |
871960 | 871960 | 2020-12-28 | Lake | California | 6033 | 1769 | 23 |
868715 | 868715 | 2020-12-27 | Lake | California | 6033 | 1710 | 23 |
865470 | 865470 | 2020-12-26 | Lake | California | 6033 | 1669 | 23 |
862225 | 862225 | 2020-12-25 | Lake | California | 6033 | 1629 | 23 |
858980 | 858980 | 2020-12-24 | Lake | California | 6033 | 1595 | 22 |
855735 | 855735 | 2020-12-23 | Lake | California | 6033 | 1569 | 22 |
852490 | 852490 | 2020-12-22 | Lake | California | 6033 | 1538 | 22 |
849245 | 849245 | 2020-12-21 | Lake | California | 6033 | 1463 | 21 |
846000 | 846000 | 2020-12-20 | Lake | California | 6033 | 1438 | 21 |
842754 | 842754 | 2020-12-19 | Lake | California | 6033 | 1397 | 21 |
839509 | 839509 | 2020-12-18 | Lake | California | 6033 | 1374 | 21 |
836264 | 836264 | 2020-12-17 | Lake | California | 6033 | 1363 | 21 |
833018 | 833018 | 2020-12-16 | Lake | California | 6033 | 1341 | 22 |
829771 | 829771 | 2020-12-15 | Lake | California | 6033 | 1301 | 22 |
826525 | 826525 | 2020-12-14 | Lake | California | 6033 | 1271 | 22 |
823278 | 823278 | 2020-12-13 | Lake | California | 6033 | 1232 | 22 |
820032 | 820032 | 2020-12-12 | Lake | California | 6033 | 1205 | 22 |
816786 | 816786 | 2020-12-11 | Lake | California | 6033 | 1167 | 22 |
813540 | 813540 | 2020-12-10 | Lake | California | 6033 | 1158 | 22 |
810296 | 810296 | 2020-12-09 | Lake | California | 6033 | 1127 | 21 |
807051 | 807051 | 2020-12-08 | Lake | California | 6033 | 1090 | 21 |
803806 | 803806 | 2020-12-07 | Lake | California | 6033 | 1075 | 21 |
800561 | 800561 | 2020-12-06 | Lake | California | 6033 | 1069 | 21 |
797316 | 797316 | 2020-12-05 | Lake | California | 6033 | 1018 | 21 |
794071 | 794071 | 2020-12-04 | Lake | California | 6033 | 991 | 21 |
790826 | 790826 | 2020-12-03 | Lake | California | 6033 | 971 | 21 |
787581 | 787581 | 2020-12-02 | Lake | California | 6033 | 969 | 20 |
784337 | 784337 | 2020-12-01 | Lake | California | 6033 | 939 | 20 |
781092 | 781092 | 2020-11-30 | Lake | California | 6033 | 927 | 19 |
777846 | 777846 | 2020-11-29 | Lake | California | 6033 | 920 | 19 |
774601 | 774601 | 2020-11-28 | Lake | California | 6033 | 909 | 19 |
771356 | 771356 | 2020-11-27 | Lake | California | 6033 | 890 | 19 |
768111 | 768111 | 2020-11-26 | Lake | California | 6033 | 878 | 19 |
764865 | 764865 | 2020-11-25 | Lake | California | 6033 | 872 | 19 |
761620 | 761620 | 2020-11-24 | Lake | California | 6033 | 840 | 19 |
758375 | 758375 | 2020-11-23 | Lake | California | 6033 | 834 | 18 |
755128 | 755128 | 2020-11-22 | Lake | California | 6033 | 832 | 18 |
751882 | 751882 | 2020-11-21 | Lake | California | 6033 | 820 | 18 |
748636 | 748636 | 2020-11-20 | Lake | California | 6033 | 809 | 18 |
745390 | 745390 | 2020-11-19 | Lake | California | 6033 | 802 | 18 |
742143 | 742143 | 2020-11-18 | Lake | California | 6033 | 792 | 18 |
738896 | 738896 | 2020-11-17 | Lake | California | 6033 | 784 | 18 |
735652 | 735652 | 2020-11-16 | Lake | California | 6033 | 777 | 17 |
732406 | 732406 | 2020-11-15 | Lake | California | 6033 | 773 | 17 |
729161 | 729161 | 2020-11-14 | Lake | California | 6033 | 770 | 17 |
725918 | 725918 | 2020-11-13 | Lake | California | 6033 | 764 | 17 |
722675 | 722675 | 2020-11-12 | Lake | California | 6033 | 763 | 17 |
719432 | 719432 | 2020-11-11 | Lake | California | 6033 | 762 | 17 |
716189 | 716189 | 2020-11-10 | Lake | California | 6033 | 755 | 17 |
712945 | 712945 | 2020-11-09 | Lake | California | 6033 | 754 | 17 |
709701 | 709701 | 2020-11-08 | Lake | California | 6033 | 751 | 17 |
706457 | 706457 | 2020-11-07 | Lake | California | 6033 | 741 | 17 |
703214 | 703214 | 2020-11-06 | Lake | California | 6033 | 739 | 17 |
699971 | 699971 | 2020-11-05 | Lake | California | 6033 | 735 | 17 |
696727 | 696727 | 2020-11-04 | Lake | California | 6033 | 732 | 17 |
693485 | 693485 | 2020-11-03 | Lake | California | 6033 | 728 | 17 |
690242 | 690242 | 2020-11-02 | Lake | California | 6033 | 727 | 18 |
686997 | 686997 | 2020-11-01 | Lake | California | 6033 | 724 | 18 |
683753 | 683753 | 2020-10-31 | Lake | California | 6033 | 720 | 17 |
680510 | 680510 | 2020-10-30 | Lake | California | 6033 | 702 | 17 |
677267 | 677267 | 2020-10-29 | Lake | California | 6033 | 700 | 16 |
674024 | 674024 | 2020-10-28 | Lake | California | 6033 | 700 | 16 |
670782 | 670782 | 2020-10-27 | Lake | California | 6033 | 697 | 16 |
667539 | 667539 | 2020-10-26 | Lake | California | 6033 | 695 | 15 |
664294 | 664294 | 2020-10-25 | Lake | California | 6033 | 696 | 15 |
661050 | 661050 | 2020-10-24 | Lake | California | 6033 | 689 | 15 |
657806 | 657806 | 2020-10-23 | Lake | California | 6033 | 678 | 15 |
654561 | 654561 | 2020-10-22 | Lake | California | 6033 | 676 | 15 |
651316 | 651316 | 2020-10-21 | Lake | California | 6033 | 675 | 15 |
648072 | 648072 | 2020-10-20 | Lake | California | 6033 | 673 | 15 |
644827 | 644827 | 2020-10-19 | Lake | California | 6033 | 670 | 15 |
641579 | 641579 | 2020-10-18 | Lake | California | 6033 | 663 | 15 |
638332 | 638332 | 2020-10-17 | Lake | California | 6033 | 644 | 15 |
635087 | 635087 | 2020-10-16 | Lake | California | 6033 | 642 | 14 |
631841 | 631841 | 2020-10-15 | Lake | California | 6033 | 642 | 14 |
628597 | 628597 | 2020-10-14 | Lake | California | 6033 | 639 | 14 |
625354 | 625354 | 2020-10-13 | Lake | California | 6033 | 633 | 13 |
622111 | 622111 | 2020-10-12 | Lake | California | 6033 | 631 | 13 |
618868 | 618868 | 2020-10-11 | Lake | California | 6033 | 630 | 13 |
615626 | 615626 | 2020-10-10 | Lake | California | 6033 | 610 | 13 |
612385 | 612385 | 2020-10-09 | Lake | California | 6033 | 604 | 12 |
609143 | 609143 | 2020-10-08 | Lake | California | 6033 | 599 | 12 |
605900 | 605900 | 2020-10-07 | Lake | California | 6033 | 596 | 12 |
602658 | 602658 | 2020-10-06 | Lake | California | 6033 | 592 | 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);