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 |
---|---|---|---|---|---|---|---|
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 |
729174 | 729174 | 2020-11-14 | Orange | California | 6059 | 66778 | 1524 |
725931 | 725931 | 2020-11-13 | Orange | California | 6059 | 66183 | 1522 |
722688 | 722688 | 2020-11-12 | Orange | California | 6059 | 65554 | 1520 |
719445 | 719445 | 2020-11-11 | Orange | California | 6059 | 65234 | 1514 |
716202 | 716202 | 2020-11-10 | Orange | California | 6059 | 64891 | 1512 |
712958 | 712958 | 2020-11-09 | Orange | California | 6059 | 64621 | 1509 |
709714 | 709714 | 2020-11-08 | Orange | California | 6059 | 64311 | 1509 |
706470 | 706470 | 2020-11-07 | Orange | California | 6059 | 63798 | 1506 |
703227 | 703227 | 2020-11-06 | Orange | California | 6059 | 63469 | 1503 |
699984 | 699984 | 2020-11-05 | Orange | California | 6059 | 63125 | 1494 |
696740 | 696740 | 2020-11-04 | Orange | California | 6059 | 62838 | 1491 |
693498 | 693498 | 2020-11-03 | Orange | California | 6059 | 62589 | 1484 |
690255 | 690255 | 2020-11-02 | Orange | California | 6059 | 62264 | 1484 |
687010 | 687010 | 2020-11-01 | Orange | California | 6059 | 62080 | 1484 |
683766 | 683766 | 2020-10-31 | Orange | California | 6059 | 61836 | 1483 |
680523 | 680523 | 2020-10-30 | Orange | California | 6059 | 61671 | 1475 |
677280 | 677280 | 2020-10-29 | Orange | California | 6059 | 61358 | 1468 |
674037 | 674037 | 2020-10-28 | Orange | California | 6059 | 61097 | 1467 |
670795 | 670795 | 2020-10-27 | Orange | California | 6059 | 60836 | 1454 |
667552 | 667552 | 2020-10-26 | Orange | California | 6059 | 60583 | 1447 |
664307 | 664307 | 2020-10-25 | Orange | California | 6059 | 60431 | 1447 |
661063 | 661063 | 2020-10-24 | Orange | California | 6059 | 60184 | 1444 |
657819 | 657819 | 2020-10-23 | Orange | California | 6059 | 59868 | 1440 |
654574 | 654574 | 2020-10-22 | Orange | California | 6059 | 59697 | 1434 |
651329 | 651329 | 2020-10-21 | Orange | California | 6059 | 59448 | 1423 |
648085 | 648085 | 2020-10-20 | Orange | California | 6059 | 59168 | 1412 |
644840 | 644840 | 2020-10-19 | Orange | California | 6059 | 58851 | 1410 |
641592 | 641592 | 2020-10-18 | Orange | California | 6059 | 58648 | 1409 |
638345 | 638345 | 2020-10-17 | Orange | California | 6059 | 58447 | 1409 |
635100 | 635100 | 2020-10-16 | Orange | California | 6059 | 58354 | 1401 |
631854 | 631854 | 2020-10-15 | Orange | California | 6059 | 58183 | 1391 |
628610 | 628610 | 2020-10-14 | Orange | California | 6059 | 58021 | 1360 |
625367 | 625367 | 2020-10-13 | Orange | California | 6059 | 57773 | 1341 |
622124 | 622124 | 2020-10-12 | Orange | California | 6059 | 57595 | 1341 |
618881 | 618881 | 2020-10-11 | Orange | California | 6059 | 57479 | 1341 |
615639 | 615639 | 2020-10-10 | Orange | California | 6059 | 57225 | 1340 |
612398 | 612398 | 2020-10-09 | Orange | California | 6059 | 57001 | 1316 |
609156 | 609156 | 2020-10-08 | Orange | California | 6059 | 56800 | 1306 |
605913 | 605913 | 2020-10-07 | Orange | California | 6059 | 56652 | 1292 |
602671 | 602671 | 2020-10-06 | Orange | California | 6059 | 56493 | 1289 |
599428 | 599428 | 2020-10-05 | Orange | California | 6059 | 56346 | 1287 |
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);