ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 6009 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053696 | 1053696 | 2021-02-22 | Calaveras | California | 6009 | 1860 | 25 |
1050449 | 1050449 | 2021-02-21 | Calaveras | California | 6009 | 1858 | 25 |
1047202 | 1047202 | 2021-02-20 | Calaveras | California | 6009 | 1856 | 25 |
1043957 | 1043957 | 2021-02-19 | Calaveras | California | 6009 | 1873 | 25 |
1040712 | 1040712 | 2021-02-18 | Calaveras | California | 6009 | 1876 | 25 |
1037467 | 1037467 | 2021-02-17 | Calaveras | California | 6009 | 1872 | 25 |
1034222 | 1034222 | 2021-02-16 | Calaveras | California | 6009 | 1871 | 25 |
1030976 | 1030976 | 2021-02-15 | Calaveras | California | 6009 | 1866 | 25 |
1027729 | 1027729 | 2021-02-14 | Calaveras | California | 6009 | 1863 | 25 |
1024484 | 1024484 | 2021-02-13 | Calaveras | California | 6009 | 1860 | 25 |
1021239 | 1021239 | 2021-02-12 | Calaveras | California | 6009 | 1856 | 25 |
1017994 | 1017994 | 2021-02-11 | Calaveras | California | 6009 | 1850 | 25 |
1014749 | 1014749 | 2021-02-10 | Calaveras | California | 6009 | 1847 | 23 |
1011504 | 1011504 | 2021-02-09 | Calaveras | California | 6009 | 1840 | 23 |
1008258 | 1008258 | 2021-02-08 | Calaveras | California | 6009 | 1837 | 23 |
1005012 | 1005012 | 2021-02-07 | Calaveras | California | 6009 | 1832 | 23 |
1001766 | 1001766 | 2021-02-06 | Calaveras | California | 6009 | 1818 | 23 |
998520 | 998520 | 2021-02-05 | Calaveras | California | 6009 | 1808 | 23 |
995274 | 995274 | 2021-02-04 | Calaveras | California | 6009 | 1799 | 23 |
992028 | 992028 | 2021-02-03 | Calaveras | California | 6009 | 1786 | 23 |
988782 | 988782 | 2021-02-02 | Calaveras | California | 6009 | 1785 | 23 |
985535 | 985535 | 2021-02-01 | Calaveras | California | 6009 | 1778 | 23 |
982288 | 982288 | 2021-01-31 | Calaveras | California | 6009 | 1763 | 23 |
979042 | 979042 | 2021-01-30 | Calaveras | California | 6009 | 1757 | 23 |
975797 | 975797 | 2021-01-29 | Calaveras | California | 6009 | 1747 | 23 |
972552 | 972552 | 2021-01-28 | Calaveras | California | 6009 | 1737 | 23 |
969307 | 969307 | 2021-01-27 | Calaveras | California | 6009 | 1723 | 23 |
966063 | 966063 | 2021-01-26 | Calaveras | California | 6009 | 1713 | 23 |
962818 | 962818 | 2021-01-25 | Calaveras | California | 6009 | 1704 | 23 |
959573 | 959573 | 2021-01-24 | Calaveras | California | 6009 | 1695 | 23 |
956327 | 956327 | 2021-01-23 | Calaveras | California | 6009 | 1672 | 23 |
953082 | 953082 | 2021-01-22 | Calaveras | California | 6009 | 1647 | 23 |
949837 | 949837 | 2021-01-21 | Calaveras | California | 6009 | 1637 | 23 |
946591 | 946591 | 2021-01-20 | Calaveras | California | 6009 | 1621 | 23 |
943344 | 943344 | 2021-01-19 | Calaveras | California | 6009 | 1617 | 23 |
940099 | 940099 | 2021-01-18 | Calaveras | California | 6009 | 1608 | 23 |
936854 | 936854 | 2021-01-17 | Calaveras | California | 6009 | 1596 | 23 |
933609 | 933609 | 2021-01-16 | Calaveras | California | 6009 | 1538 | 23 |
930364 | 930364 | 2021-01-15 | Calaveras | California | 6009 | 1513 | 23 |
927119 | 927119 | 2021-01-14 | Calaveras | California | 6009 | 1493 | 22 |
923873 | 923873 | 2021-01-13 | Calaveras | California | 6009 | 1475 | 22 |
920628 | 920628 | 2021-01-12 | Calaveras | California | 6009 | 1460 | 22 |
917383 | 917383 | 2021-01-11 | Calaveras | California | 6009 | 1449 | 22 |
914138 | 914138 | 2021-01-10 | Calaveras | California | 6009 | 1425 | 22 |
910893 | 910893 | 2021-01-09 | Calaveras | California | 6009 | 1385 | 22 |
907648 | 907648 | 2021-01-08 | Calaveras | California | 6009 | 1342 | 22 |
904402 | 904402 | 2021-01-07 | Calaveras | California | 6009 | 1321 | 22 |
901157 | 901157 | 2021-01-06 | Calaveras | California | 6009 | 1292 | 22 |
897912 | 897912 | 2021-01-05 | Calaveras | California | 6009 | 1276 | 22 |
894667 | 894667 | 2021-01-04 | Calaveras | California | 6009 | 1248 | 22 |
891420 | 891420 | 2021-01-03 | Calaveras | California | 6009 | 1230 | 22 |
888173 | 888173 | 2021-01-02 | Calaveras | California | 6009 | 1186 | 22 |
884928 | 884928 | 2021-01-01 | Calaveras | California | 6009 | 1161 | 22 |
881683 | 881683 | 2020-12-31 | Calaveras | California | 6009 | 1131 | 22 |
878438 | 878438 | 2020-12-30 | Calaveras | California | 6009 | 1111 | 22 |
875193 | 875193 | 2020-12-29 | Calaveras | California | 6009 | 1102 | 22 |
871948 | 871948 | 2020-12-28 | Calaveras | California | 6009 | 1097 | 22 |
868703 | 868703 | 2020-12-27 | Calaveras | California | 6009 | 1084 | 22 |
865458 | 865458 | 2020-12-26 | Calaveras | California | 6009 | 1062 | 22 |
862213 | 862213 | 2020-12-25 | Calaveras | California | 6009 | 1032 | 22 |
858968 | 858968 | 2020-12-24 | Calaveras | California | 6009 | 1002 | 22 |
855723 | 855723 | 2020-12-23 | Calaveras | California | 6009 | 988 | 22 |
852478 | 852478 | 2020-12-22 | Calaveras | California | 6009 | 963 | 22 |
849233 | 849233 | 2020-12-21 | Calaveras | California | 6009 | 926 | 22 |
845988 | 845988 | 2020-12-20 | Calaveras | California | 6009 | 900 | 22 |
842742 | 842742 | 2020-12-19 | Calaveras | California | 6009 | 870 | 22 |
839497 | 839497 | 2020-12-18 | Calaveras | California | 6009 | 848 | 22 |
836252 | 836252 | 2020-12-17 | Calaveras | California | 6009 | 821 | 22 |
833006 | 833006 | 2020-12-16 | Calaveras | California | 6009 | 799 | 22 |
829759 | 829759 | 2020-12-15 | Calaveras | California | 6009 | 718 | 22 |
826513 | 826513 | 2020-12-14 | Calaveras | California | 6009 | 710 | 22 |
823266 | 823266 | 2020-12-13 | Calaveras | California | 6009 | 708 | 22 |
820020 | 820020 | 2020-12-12 | Calaveras | California | 6009 | 697 | 22 |
816774 | 816774 | 2020-12-11 | Calaveras | California | 6009 | 684 | 22 |
813528 | 813528 | 2020-12-10 | Calaveras | California | 6009 | 670 | 22 |
810284 | 810284 | 2020-12-09 | Calaveras | California | 6009 | 657 | 22 |
807039 | 807039 | 2020-12-08 | Calaveras | California | 6009 | 606 | 22 |
803794 | 803794 | 2020-12-07 | Calaveras | California | 6009 | 606 | 22 |
800549 | 800549 | 2020-12-06 | Calaveras | California | 6009 | 606 | 22 |
797304 | 797304 | 2020-12-05 | Calaveras | California | 6009 | 585 | 22 |
794059 | 794059 | 2020-12-04 | Calaveras | California | 6009 | 572 | 22 |
790814 | 790814 | 2020-12-03 | Calaveras | California | 6009 | 553 | 22 |
787569 | 787569 | 2020-12-02 | Calaveras | California | 6009 | 544 | 22 |
784325 | 784325 | 2020-12-01 | Calaveras | California | 6009 | 498 | 22 |
781080 | 781080 | 2020-11-30 | Calaveras | California | 6009 | 478 | 22 |
777834 | 777834 | 2020-11-29 | Calaveras | California | 6009 | 478 | 22 |
774589 | 774589 | 2020-11-28 | Calaveras | California | 6009 | 478 | 22 |
771344 | 771344 | 2020-11-27 | Calaveras | California | 6009 | 478 | 22 |
768099 | 768099 | 2020-11-26 | Calaveras | California | 6009 | 475 | 22 |
764853 | 764853 | 2020-11-25 | Calaveras | California | 6009 | 466 | 22 |
761608 | 761608 | 2020-11-24 | Calaveras | California | 6009 | 450 | 22 |
758363 | 758363 | 2020-11-23 | Calaveras | California | 6009 | 434 | 21 |
755116 | 755116 | 2020-11-22 | Calaveras | California | 6009 | 434 | 21 |
751870 | 751870 | 2020-11-21 | Calaveras | California | 6009 | 424 | 21 |
748624 | 748624 | 2020-11-20 | Calaveras | California | 6009 | 422 | 21 |
745378 | 745378 | 2020-11-19 | Calaveras | California | 6009 | 409 | 21 |
742131 | 742131 | 2020-11-18 | Calaveras | California | 6009 | 405 | 21 |
738884 | 738884 | 2020-11-17 | Calaveras | California | 6009 | 402 | 21 |
735640 | 735640 | 2020-11-16 | Calaveras | California | 6009 | 390 | 21 |
732394 | 732394 | 2020-11-15 | Calaveras | California | 6009 | 390 | 21 |
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);