ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
327 rows where fips = 6061 sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953188 | 953188 | 2021-01-22 | Placer | California | 6061 | 17675 | 188 |
949943 | 949943 | 2021-01-21 | Placer | California | 6061 | 17584 | 186 |
946697 | 946697 | 2021-01-20 | Placer | California | 6061 | 17490 | 184 |
943450 | 943450 | 2021-01-19 | Placer | California | 6061 | 17380 | 180 |
940205 | 940205 | 2021-01-18 | Placer | California | 6061 | 17194 | 173 |
936960 | 936960 | 2021-01-17 | Placer | California | 6061 | 16995 | 173 |
933715 | 933715 | 2021-01-16 | Placer | California | 6061 | 16761 | 173 |
930470 | 930470 | 2021-01-15 | Placer | California | 6061 | 16761 | 173 |
927225 | 927225 | 2021-01-14 | Placer | California | 6061 | 16532 | 172 |
923979 | 923979 | 2021-01-13 | Placer | California | 6061 | 16317 | 170 |
920734 | 920734 | 2021-01-12 | Placer | California | 6061 | 16135 | 161 |
917489 | 917489 | 2021-01-11 | Placer | California | 6061 | 15978 | 161 |
914244 | 914244 | 2021-01-10 | Placer | California | 6061 | 15609 | 159 |
910999 | 910999 | 2021-01-09 | Placer | California | 6061 | 15454 | 159 |
907754 | 907754 | 2021-01-08 | Placer | California | 6061 | 15454 | 159 |
904508 | 904508 | 2021-01-07 | Placer | California | 6061 | 15233 | 142 |
901263 | 901263 | 2021-01-06 | Placer | California | 6061 | 15015 | 132 |
898018 | 898018 | 2021-01-05 | Placer | California | 6061 | 14800 | 132 |
894773 | 894773 | 2021-01-04 | Placer | California | 6061 | 14317 | 125 |
891526 | 891526 | 2021-01-03 | Placer | California | 6061 | 14182 | 125 |
888279 | 888279 | 2021-01-02 | Placer | California | 6061 | 13987 | 125 |
885034 | 885034 | 2021-01-01 | Placer | California | 6061 | 13755 | 125 |
881789 | 881789 | 2020-12-31 | Placer | California | 6061 | 13755 | 125 |
878544 | 878544 | 2020-12-30 | Placer | California | 6061 | 13550 | 125 |
875299 | 875299 | 2020-12-29 | Placer | California | 6061 | 13272 | 125 |
872054 | 872054 | 2020-12-28 | Placer | California | 6061 | 13055 | 125 |
868809 | 868809 | 2020-12-27 | Placer | California | 6061 | 12816 | 120 |
865564 | 865564 | 2020-12-26 | Placer | California | 6061 | 12660 | 120 |
862319 | 862319 | 2020-12-25 | Placer | California | 6061 | 12457 | 120 |
859074 | 859074 | 2020-12-24 | Placer | California | 6061 | 12262 | 120 |
855829 | 855829 | 2020-12-23 | Placer | California | 6061 | 11968 | 110 |
852584 | 852584 | 2020-12-22 | Placer | California | 6061 | 11761 | 109 |
849339 | 849339 | 2020-12-21 | Placer | California | 6061 | 11541 | 104 |
846094 | 846094 | 2020-12-20 | Placer | California | 6061 | 11246 | 103 |
842848 | 842848 | 2020-12-19 | Placer | California | 6061 | 10995 | 103 |
839603 | 839603 | 2020-12-18 | Placer | California | 6061 | 10776 | 103 |
836358 | 836358 | 2020-12-17 | Placer | California | 6061 | 10554 | 98 |
833112 | 833112 | 2020-12-16 | Placer | California | 6061 | 10301 | 97 |
829865 | 829865 | 2020-12-15 | Placer | California | 6061 | 9722 | 94 |
826619 | 826619 | 2020-12-14 | Placer | California | 6061 | 9549 | 93 |
823372 | 823372 | 2020-12-13 | Placer | California | 6061 | 9390 | 92 |
820126 | 820126 | 2020-12-12 | Placer | California | 6061 | 8904 | 92 |
816880 | 816880 | 2020-12-11 | Placer | California | 6061 | 8906 | 92 |
813634 | 813634 | 2020-12-10 | Placer | California | 6061 | 8860 | 89 |
810390 | 810390 | 2020-12-09 | Placer | California | 6061 | 8544 | 85 |
807145 | 807145 | 2020-12-08 | Placer | California | 6061 | 8173 | 81 |
803900 | 803900 | 2020-12-07 | Placer | California | 6061 | 7979 | 81 |
800654 | 800654 | 2020-12-06 | Placer | California | 6061 | 7811 | 74 |
797408 | 797408 | 2020-12-05 | Placer | California | 6061 | 7461 | 74 |
794163 | 794163 | 2020-12-04 | Placer | California | 6061 | 7270 | 74 |
790917 | 790917 | 2020-12-03 | Placer | California | 6061 | 6941 | 72 |
787671 | 787671 | 2020-12-02 | Placer | California | 6061 | 6794 | 71 |
784427 | 784427 | 2020-12-01 | Placer | California | 6061 | 6664 | 71 |
781182 | 781182 | 2020-11-30 | Placer | California | 6061 | 6622 | 70 |
777936 | 777936 | 2020-11-29 | Placer | California | 6061 | 6497 | 68 |
774690 | 774690 | 2020-11-28 | Placer | California | 6061 | 6354 | 68 |
771445 | 771445 | 2020-11-27 | Placer | California | 6061 | 6354 | 68 |
768199 | 768199 | 2020-11-26 | Placer | California | 6061 | 6224 | 68 |
764952 | 764952 | 2020-11-25 | Placer | California | 6061 | 6224 | 68 |
761706 | 761706 | 2020-11-24 | Placer | California | 6061 | 6148 | 68 |
758460 | 758460 | 2020-11-23 | Placer | California | 6061 | 6071 | 67 |
755213 | 755213 | 2020-11-22 | Placer | California | 6061 | 5778 | 67 |
751966 | 751966 | 2020-11-21 | Placer | California | 6061 | 5687 | 67 |
748719 | 748719 | 2020-11-20 | Placer | California | 6061 | 5687 | 67 |
745472 | 745472 | 2020-11-19 | Placer | California | 6061 | 5642 | 66 |
742225 | 742225 | 2020-11-18 | Placer | California | 6061 | 5543 | 65 |
738978 | 738978 | 2020-11-17 | Placer | California | 6061 | 5489 | 64 |
735733 | 735733 | 2020-11-16 | Placer | California | 6061 | 5397 | 64 |
732487 | 732487 | 2020-11-15 | Placer | California | 6061 | 5215 | 63 |
729242 | 729242 | 2020-11-14 | Placer | California | 6061 | 5134 | 63 |
725998 | 725998 | 2020-11-13 | Placer | California | 6061 | 5134 | 63 |
722754 | 722754 | 2020-11-12 | Placer | California | 6061 | 5056 | 62 |
719510 | 719510 | 2020-11-11 | Placer | California | 6061 | 4993 | 60 |
716266 | 716266 | 2020-11-10 | Placer | California | 6061 | 4912 | 60 |
713022 | 713022 | 2020-11-09 | Placer | California | 6061 | 4853 | 60 |
709778 | 709778 | 2020-11-08 | Placer | California | 6061 | 4720 | 60 |
706534 | 706534 | 2020-11-07 | Placer | California | 6061 | 4692 | 60 |
703291 | 703291 | 2020-11-06 | Placer | California | 6061 | 4692 | 60 |
700047 | 700047 | 2020-11-05 | Placer | California | 6061 | 4640 | 60 |
696802 | 696802 | 2020-11-04 | Placer | California | 6061 | 4542 | 60 |
693559 | 693559 | 2020-11-03 | Placer | California | 6061 | 4527 | 60 |
690316 | 690316 | 2020-11-02 | Placer | California | 6061 | 4467 | 59 |
687071 | 687071 | 2020-11-01 | Placer | California | 6061 | 4374 | 59 |
683826 | 683826 | 2020-10-31 | Placer | California | 6061 | 4353 | 59 |
680582 | 680582 | 2020-10-30 | Placer | California | 6061 | 4353 | 59 |
677339 | 677339 | 2020-10-29 | Placer | California | 6061 | 4290 | 59 |
674095 | 674095 | 2020-10-28 | Placer | California | 6061 | 4248 | 57 |
670853 | 670853 | 2020-10-27 | Placer | California | 6061 | 4207 | 57 |
667610 | 667610 | 2020-10-26 | Placer | California | 6061 | 4178 | 57 |
664364 | 664364 | 2020-10-25 | Placer | California | 6061 | 4093 | 57 |
661119 | 661119 | 2020-10-24 | Placer | California | 6061 | 4088 | 57 |
657875 | 657875 | 2020-10-23 | Placer | California | 6061 | 4088 | 57 |
654630 | 654630 | 2020-10-22 | Placer | California | 6061 | 4052 | 57 |
651385 | 651385 | 2020-10-21 | Placer | California | 6061 | 4023 | 55 |
648141 | 648141 | 2020-10-20 | Placer | California | 6061 | 4012 | 55 |
644896 | 644896 | 2020-10-19 | Placer | California | 6061 | 3978 | 52 |
641648 | 641648 | 2020-10-18 | Placer | California | 6061 | 3898 | 52 |
638401 | 638401 | 2020-10-17 | Placer | California | 6061 | 3880 | 52 |
635156 | 635156 | 2020-10-16 | Placer | California | 6061 | 3880 | 52 |
631910 | 631910 | 2020-10-15 | Placer | California | 6061 | 3864 | 52 |
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]);