ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
840 rows where fips = 6059 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053721 | 1053721 | 2021-02-22 | Orange | California | 6059 | 259581 | 3848 |
1050474 | 1050474 | 2021-02-21 | Orange | California | 6059 | 259305 | 3810 |
1047227 | 1047227 | 2021-02-20 | Orange | California | 6059 | 258991 | 3770 |
1043982 | 1043982 | 2021-02-19 | Orange | California | 6059 | 258567 | 3726 |
1040737 | 1040737 | 2021-02-18 | Orange | California | 6059 | 258182 | 3685 |
1037492 | 1037492 | 2021-02-17 | Orange | California | 6059 | 257816 | 3644 |
1034247 | 1034247 | 2021-02-16 | Orange | California | 6059 | 257589 | 3617 |
1031001 | 1031001 | 2021-02-15 | Orange | California | 6059 | 256889 | 3577 |
1027754 | 1027754 | 2021-02-14 | Orange | California | 6059 | 256889 | 3577 |
1024509 | 1024509 | 2021-02-13 | Orange | California | 6059 | 256510 | 3544 |
1021264 | 1021264 | 2021-02-12 | Orange | California | 6059 | 255254 | 3493 |
1018019 | 1018019 | 2021-02-11 | Orange | California | 6059 | 255254 | 3493 |
1014774 | 1014774 | 2021-02-10 | Orange | California | 6059 | 254417 | 3451 |
1011529 | 1011529 | 2021-02-09 | Orange | California | 6059 | 253900 | 3416 |
1008283 | 1008283 | 2021-02-08 | Orange | California | 6059 | 253289 | 3383 |
1005037 | 1005037 | 2021-02-07 | Orange | California | 6059 | 252311 | 3358 |
1001791 | 1001791 | 2021-02-06 | Orange | California | 6059 | 251079 | 3312 |
998545 | 998545 | 2021-02-05 | Orange | California | 6059 | 250300 | 3279 |
995299 | 995299 | 2021-02-04 | Orange | California | 6059 | 249195 | 3249 |
992053 | 992053 | 2021-02-03 | Orange | California | 6059 | 248510 | 3199 |
988807 | 988807 | 2021-02-02 | Orange | California | 6059 | 247886 | 3162 |
985560 | 985560 | 2021-02-01 | Orange | California | 6059 | 247035 | 3109 |
982313 | 982313 | 2021-01-31 | Orange | California | 6059 | 245978 | 3062 |
979067 | 979067 | 2021-01-30 | Orange | California | 6059 | 244562 | 3018 |
975822 | 975822 | 2021-01-29 | Orange | California | 6059 | 243212 | 2975 |
972577 | 972577 | 2021-01-28 | Orange | California | 6059 | 241648 | 2868 |
969332 | 969332 | 2021-01-27 | Orange | California | 6059 | 240314 | 2839 |
966088 | 966088 | 2021-01-26 | Orange | California | 6059 | 239175 | 2768 |
962843 | 962843 | 2021-01-25 | Orange | California | 6059 | 237708 | 2704 |
959598 | 959598 | 2021-01-24 | Orange | California | 6059 | 236312 | 2638 |
956352 | 956352 | 2021-01-23 | Orange | California | 6059 | 234427 | 2625 |
953107 | 953107 | 2021-01-22 | Orange | California | 6059 | 231574 | 2547 |
949862 | 949862 | 2021-01-21 | Orange | California | 6059 | 230582 | 2546 |
946616 | 946616 | 2021-01-20 | Orange | California | 6059 | 229132 | 2508 |
943369 | 943369 | 2021-01-19 | Orange | California | 6059 | 227321 | 2477 |
940124 | 940124 | 2021-01-18 | Orange | California | 6059 | 223088 | 2367 |
936879 | 936879 | 2021-01-17 | Orange | California | 6059 | 223088 | 2367 |
933634 | 933634 | 2021-01-16 | Orange | California | 6059 | 221532 | 2320 |
930389 | 930389 | 2021-01-15 | Orange | California | 6059 | 217925 | 2277 |
927144 | 927144 | 2021-01-14 | Orange | California | 6059 | 214649 | 2195 |
923898 | 923898 | 2021-01-13 | Orange | California | 6059 | 211331 | 2179 |
920653 | 920653 | 2021-01-12 | Orange | California | 6059 | 207318 | 2148 |
917408 | 917408 | 2021-01-11 | Orange | California | 6059 | 202787 | 2120 |
914163 | 914163 | 2021-01-10 | Orange | California | 6059 | 199401 | 2091 |
910918 | 910918 | 2021-01-09 | Orange | California | 6059 | 196024 | 2041 |
907673 | 907673 | 2021-01-08 | Orange | California | 6059 | 191804 | 1998 |
904427 | 904427 | 2021-01-07 | Orange | California | 6059 | 188013 | 1972 |
901182 | 901182 | 2021-01-06 | Orange | California | 6059 | 185125 | 1943 |
897937 | 897937 | 2021-01-05 | Orange | California | 6059 | 181850 | 1926 |
894692 | 894692 | 2021-01-04 | Orange | California | 6059 | 180386 | 1926 |
891445 | 891445 | 2021-01-03 | Orange | California | 6059 | 170802 | 1901 |
888198 | 888198 | 2021-01-02 | Orange | California | 6059 | 170802 | 1901 |
884953 | 884953 | 2021-01-01 | Orange | California | 6059 | 166196 | 1875 |
881708 | 881708 | 2020-12-31 | Orange | California | 6059 | 166196 | 1875 |
878463 | 878463 | 2020-12-30 | Orange | California | 6059 | 164990 | 1874 |
875218 | 875218 | 2020-12-29 | Orange | California | 6059 | 160476 | 1847 |
871973 | 871973 | 2020-12-28 | Orange | California | 6059 | 157926 | 1846 |
868728 | 868728 | 2020-12-27 | Orange | California | 6059 | 153527 | 1846 |
865483 | 865483 | 2020-12-26 | Orange | California | 6059 | 149439 | 1845 |
862238 | 862238 | 2020-12-25 | Orange | California | 6059 | 141205 | 1782 |
858993 | 858993 | 2020-12-24 | Orange | California | 6059 | 140699 | 1782 |
855748 | 855748 | 2020-12-23 | Orange | California | 6059 | 137194 | 1781 |
852503 | 852503 | 2020-12-22 | Orange | California | 6059 | 132772 | 1779 |
849258 | 849258 | 2020-12-21 | Orange | California | 6059 | 130530 | 1777 |
846013 | 846013 | 2020-12-20 | Orange | California | 6059 | 126776 | 1775 |
842767 | 842767 | 2020-12-19 | Orange | California | 6059 | 122168 | 1760 |
839522 | 839522 | 2020-12-18 | Orange | California | 6059 | 118721 | 1734 |
836277 | 836277 | 2020-12-17 | Orange | California | 6059 | 116116 | 1731 |
833031 | 833031 | 2020-12-16 | Orange | California | 6059 | 113492 | 1718 |
829784 | 829784 | 2020-12-15 | Orange | California | 6059 | 110253 | 1695 |
826538 | 826538 | 2020-12-14 | Orange | California | 6059 | 108070 | 1694 |
823291 | 823291 | 2020-12-13 | Orange | California | 6059 | 104817 | 1694 |
820045 | 820045 | 2020-12-12 | Orange | California | 6059 | 101696 | 1680 |
816799 | 816799 | 2020-12-11 | Orange | California | 6059 | 99603 | 1662 |
813553 | 813553 | 2020-12-10 | Orange | California | 6059 | 96948 | 1640 |
810309 | 810309 | 2020-12-09 | Orange | California | 6059 | 95425 | 1633 |
807064 | 807064 | 2020-12-08 | Orange | California | 6059 | 92811 | 1633 |
803819 | 803819 | 2020-12-07 | Orange | California | 6059 | 91139 | 1633 |
800574 | 800574 | 2020-12-06 | Orange | California | 6059 | 89175 | 1633 |
797329 | 797329 | 2020-12-05 | Orange | California | 6059 | 87150 | 1618 |
794084 | 794084 | 2020-12-04 | Orange | California | 6059 | 85181 | 1603 |
790839 | 790839 | 2020-12-03 | Orange | California | 6059 | 83947 | 1586 |
787594 | 787594 | 2020-12-02 | Orange | California | 6059 | 82840 | 1578 |
784350 | 784350 | 2020-12-01 | Orange | California | 6059 | 81631 | 1577 |
781105 | 781105 | 2020-11-30 | Orange | California | 6059 | 80841 | 1577 |
777859 | 777859 | 2020-11-29 | Orange | California | 6059 | 80107 | 1577 |
774614 | 774614 | 2020-11-28 | Orange | California | 6059 | 79049 | 1577 |
771369 | 771369 | 2020-11-27 | Orange | California | 6059 | 77380 | 1577 |
768124 | 768124 | 2020-11-26 | Orange | California | 6059 | 75424 | 1559 |
764878 | 764878 | 2020-11-25 | Orange | California | 6059 | 75424 | 1559 |
761633 | 761633 | 2020-11-24 | Orange | California | 6059 | 74218 | 1556 |
758388 | 758388 | 2020-11-23 | Orange | California | 6059 | 73378 | 1554 |
755141 | 755141 | 2020-11-22 | Orange | California | 6059 | 71955 | 1554 |
751895 | 751895 | 2020-11-21 | Orange | California | 6059 | 71402 | 1551 |
748649 | 748649 | 2020-11-20 | Orange | California | 6059 | 70593 | 1540 |
745403 | 745403 | 2020-11-19 | Orange | California | 6059 | 69413 | 1537 |
742156 | 742156 | 2020-11-18 | Orange | California | 6059 | 68816 | 1528 |
738909 | 738909 | 2020-11-17 | Orange | California | 6059 | 68175 | 1526 |
735665 | 735665 | 2020-11-16 | Orange | California | 6059 | 67819 | 1526 |
732419 | 732419 | 2020-11-15 | Orange | California | 6059 | 67439 | 1526 |
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);