ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where fips = 6061 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053722 | 1053722 | 2021-02-22 | Placer | California | 6061 | 19646 | 230 |
1050475 | 1050475 | 2021-02-21 | Placer | California | 6061 | 19520 | 229 |
1047228 | 1047228 | 2021-02-20 | Placer | California | 6061 | 19520 | 229 |
1043983 | 1043983 | 2021-02-19 | Placer | California | 6061 | 19520 | 229 |
1040738 | 1040738 | 2021-02-18 | Placer | California | 6061 | 19462 | 229 |
1037493 | 1037493 | 2021-02-17 | Placer | California | 6061 | 19457 | 223 |
1034248 | 1034248 | 2021-02-16 | Placer | California | 6061 | 19433 | 223 |
1031002 | 1031002 | 2021-02-15 | Placer | California | 6061 | 19313 | 222 |
1027755 | 1027755 | 2021-02-14 | Placer | California | 6061 | 19214 | 222 |
1024510 | 1024510 | 2021-02-13 | Placer | California | 6061 | 19175 | 222 |
1021265 | 1021265 | 2021-02-12 | Placer | California | 6061 | 19175 | 222 |
1018020 | 1018020 | 2021-02-11 | Placer | California | 6061 | 19175 | 222 |
1014775 | 1014775 | 2021-02-10 | Placer | California | 6061 | 19121 | 217 |
1011530 | 1011530 | 2021-02-09 | Placer | California | 6061 | 19036 | 216 |
1008284 | 1008284 | 2021-02-08 | Placer | California | 6061 | 18973 | 214 |
1005038 | 1005038 | 2021-02-07 | Placer | California | 6061 | 18836 | 206 |
1001792 | 1001792 | 2021-02-06 | Placer | California | 6061 | 18784 | 206 |
998546 | 998546 | 2021-02-05 | Placer | California | 6061 | 18784 | 206 |
995300 | 995300 | 2021-02-04 | Placer | California | 6061 | 18738 | 206 |
992054 | 992054 | 2021-02-03 | Placer | California | 6061 | 18670 | 205 |
988808 | 988808 | 2021-02-02 | Placer | California | 6061 | 18638 | 201 |
985561 | 985561 | 2021-02-01 | Placer | California | 6061 | 18608 | 201 |
982314 | 982314 | 2021-01-31 | Placer | California | 6061 | 18430 | 199 |
979068 | 979068 | 2021-01-30 | Placer | California | 6061 | 18399 | 199 |
975823 | 975823 | 2021-01-29 | Placer | California | 6061 | 18399 | 199 |
972578 | 972578 | 2021-01-28 | Placer | California | 6061 | 18267 | 192 |
969333 | 969333 | 2021-01-27 | Placer | California | 6061 | 18129 | 192 |
966089 | 966089 | 2021-01-26 | Placer | California | 6061 | 18034 | 188 |
962844 | 962844 | 2021-01-25 | Placer | California | 6061 | 17839 | 188 |
959599 | 959599 | 2021-01-24 | Placer | California | 6061 | 17675 | 188 |
956353 | 956353 | 2021-01-23 | Placer | California | 6061 | 17675 | 188 |
953108 | 953108 | 2021-01-22 | Placer | California | 6061 | 17675 | 188 |
949863 | 949863 | 2021-01-21 | Placer | California | 6061 | 17584 | 186 |
946617 | 946617 | 2021-01-20 | Placer | California | 6061 | 17490 | 184 |
943370 | 943370 | 2021-01-19 | Placer | California | 6061 | 17380 | 180 |
940125 | 940125 | 2021-01-18 | Placer | California | 6061 | 17194 | 173 |
936880 | 936880 | 2021-01-17 | Placer | California | 6061 | 16995 | 173 |
933635 | 933635 | 2021-01-16 | Placer | California | 6061 | 16761 | 173 |
930390 | 930390 | 2021-01-15 | Placer | California | 6061 | 16761 | 173 |
927145 | 927145 | 2021-01-14 | Placer | California | 6061 | 16532 | 172 |
923899 | 923899 | 2021-01-13 | Placer | California | 6061 | 16317 | 170 |
920654 | 920654 | 2021-01-12 | Placer | California | 6061 | 16135 | 161 |
917409 | 917409 | 2021-01-11 | Placer | California | 6061 | 15978 | 161 |
914164 | 914164 | 2021-01-10 | Placer | California | 6061 | 15609 | 159 |
910919 | 910919 | 2021-01-09 | Placer | California | 6061 | 15454 | 159 |
907674 | 907674 | 2021-01-08 | Placer | California | 6061 | 15454 | 159 |
904428 | 904428 | 2021-01-07 | Placer | California | 6061 | 15233 | 142 |
901183 | 901183 | 2021-01-06 | Placer | California | 6061 | 15015 | 132 |
897938 | 897938 | 2021-01-05 | Placer | California | 6061 | 14800 | 132 |
894693 | 894693 | 2021-01-04 | Placer | California | 6061 | 14317 | 125 |
891446 | 891446 | 2021-01-03 | Placer | California | 6061 | 14182 | 125 |
888199 | 888199 | 2021-01-02 | Placer | California | 6061 | 13987 | 125 |
884954 | 884954 | 2021-01-01 | Placer | California | 6061 | 13755 | 125 |
881709 | 881709 | 2020-12-31 | Placer | California | 6061 | 13755 | 125 |
878464 | 878464 | 2020-12-30 | Placer | California | 6061 | 13550 | 125 |
875219 | 875219 | 2020-12-29 | Placer | California | 6061 | 13272 | 125 |
871974 | 871974 | 2020-12-28 | Placer | California | 6061 | 13055 | 125 |
868729 | 868729 | 2020-12-27 | Placer | California | 6061 | 12816 | 120 |
865484 | 865484 | 2020-12-26 | Placer | California | 6061 | 12660 | 120 |
862239 | 862239 | 2020-12-25 | Placer | California | 6061 | 12457 | 120 |
858994 | 858994 | 2020-12-24 | Placer | California | 6061 | 12262 | 120 |
855749 | 855749 | 2020-12-23 | Placer | California | 6061 | 11968 | 110 |
852504 | 852504 | 2020-12-22 | Placer | California | 6061 | 11761 | 109 |
849259 | 849259 | 2020-12-21 | Placer | California | 6061 | 11541 | 104 |
846014 | 846014 | 2020-12-20 | Placer | California | 6061 | 11246 | 103 |
842768 | 842768 | 2020-12-19 | Placer | California | 6061 | 10995 | 103 |
839523 | 839523 | 2020-12-18 | Placer | California | 6061 | 10776 | 103 |
836278 | 836278 | 2020-12-17 | Placer | California | 6061 | 10554 | 98 |
833032 | 833032 | 2020-12-16 | Placer | California | 6061 | 10301 | 97 |
829785 | 829785 | 2020-12-15 | Placer | California | 6061 | 9722 | 94 |
826539 | 826539 | 2020-12-14 | Placer | California | 6061 | 9549 | 93 |
823292 | 823292 | 2020-12-13 | Placer | California | 6061 | 9390 | 92 |
820046 | 820046 | 2020-12-12 | Placer | California | 6061 | 8904 | 92 |
816800 | 816800 | 2020-12-11 | Placer | California | 6061 | 8906 | 92 |
813554 | 813554 | 2020-12-10 | Placer | California | 6061 | 8860 | 89 |
810310 | 810310 | 2020-12-09 | Placer | California | 6061 | 8544 | 85 |
807065 | 807065 | 2020-12-08 | Placer | California | 6061 | 8173 | 81 |
803820 | 803820 | 2020-12-07 | Placer | California | 6061 | 7979 | 81 |
800575 | 800575 | 2020-12-06 | Placer | California | 6061 | 7811 | 74 |
797330 | 797330 | 2020-12-05 | Placer | California | 6061 | 7461 | 74 |
794085 | 794085 | 2020-12-04 | Placer | California | 6061 | 7270 | 74 |
790840 | 790840 | 2020-12-03 | Placer | California | 6061 | 6941 | 72 |
787595 | 787595 | 2020-12-02 | Placer | California | 6061 | 6794 | 71 |
784351 | 784351 | 2020-12-01 | Placer | California | 6061 | 6664 | 71 |
781106 | 781106 | 2020-11-30 | Placer | California | 6061 | 6622 | 70 |
777860 | 777860 | 2020-11-29 | Placer | California | 6061 | 6497 | 68 |
774615 | 774615 | 2020-11-28 | Placer | California | 6061 | 6354 | 68 |
771370 | 771370 | 2020-11-27 | Placer | California | 6061 | 6354 | 68 |
768125 | 768125 | 2020-11-26 | Placer | California | 6061 | 6224 | 68 |
764879 | 764879 | 2020-11-25 | Placer | California | 6061 | 6224 | 68 |
761634 | 761634 | 2020-11-24 | Placer | California | 6061 | 6148 | 68 |
758389 | 758389 | 2020-11-23 | Placer | California | 6061 | 6071 | 67 |
755142 | 755142 | 2020-11-22 | Placer | California | 6061 | 5778 | 67 |
751896 | 751896 | 2020-11-21 | Placer | California | 6061 | 5687 | 67 |
748650 | 748650 | 2020-11-20 | Placer | California | 6061 | 5687 | 67 |
745404 | 745404 | 2020-11-19 | Placer | California | 6061 | 5642 | 66 |
742157 | 742157 | 2020-11-18 | Placer | California | 6061 | 5543 | 65 |
738910 | 738910 | 2020-11-17 | Placer | California | 6061 | 5489 | 64 |
735666 | 735666 | 2020-11-16 | Placer | California | 6061 | 5397 | 64 |
732420 | 732420 | 2020-11-15 | Placer | California | 6061 | 5215 | 63 |
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);