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 |
---|---|---|---|---|---|---|---|
1193325 | 1193325 | 2021-04-06 | Placer | California | 6061 | 21239 | 277 |
1190075 | 1190075 | 2021-04-05 | Placer | California | 6061 | 21188 | 277 |
1186828 | 1186828 | 2021-04-04 | Placer | California | 6061 | 21095 | 276 |
1183581 | 1183581 | 2021-04-03 | Placer | California | 6061 | 21095 | 276 |
1180334 | 1180334 | 2021-04-02 | Placer | California | 6061 | 21095 | 276 |
1177087 | 1177087 | 2021-04-01 | Placer | California | 6061 | 20972 | 275 |
1173840 | 1173840 | 2021-03-31 | Placer | California | 6061 | 20952 | 274 |
1170593 | 1170593 | 2021-03-30 | Placer | California | 6061 | 20929 | 272 |
1167345 | 1167345 | 2021-03-29 | Placer | California | 6061 | 20888 | 272 |
1164097 | 1164097 | 2021-03-28 | Placer | California | 6061 | 20736 | 267 |
1160849 | 1160849 | 2021-03-27 | Placer | California | 6061 | 20736 | 263 |
1157601 | 1157601 | 2021-03-26 | Placer | California | 6061 | 20736 | 263 |
1154354 | 1154354 | 2021-03-25 | Placer | California | 6061 | 20697 | 257 |
1151107 | 1151107 | 2021-03-24 | Placer | California | 6061 | 20665 | 251 |
1147860 | 1147860 | 2021-03-23 | Placer | California | 6061 | 20627 | 250 |
1144613 | 1144613 | 2021-03-22 | Placer | California | 6061 | 20603 | 248 |
1141366 | 1141366 | 2021-03-21 | Placer | California | 6061 | 20505 | 244 |
1138120 | 1138120 | 2021-03-20 | Placer | California | 6061 | 20493 | 244 |
1134874 | 1134874 | 2021-03-19 | Placer | California | 6061 | 20493 | 244 |
1131627 | 1131627 | 2021-03-18 | Placer | California | 6061 | 20460 | 244 |
1128379 | 1128379 | 2021-03-17 | Placer | California | 6061 | 20407 | 240 |
1125133 | 1125133 | 2021-03-16 | Placer | California | 6061 | 20394 | 238 |
1121887 | 1121887 | 2021-03-15 | Placer | California | 6061 | 20364 | 238 |
1118640 | 1118640 | 2021-03-14 | Placer | California | 6061 | 20273 | 239 |
1115393 | 1115393 | 2021-03-13 | Placer | California | 6061 | 20273 | 239 |
1112147 | 1112147 | 2021-03-12 | Placer | California | 6061 | 20273 | 232 |
1108901 | 1108901 | 2021-03-11 | Placer | California | 6061 | 20242 | 232 |
1105655 | 1105655 | 2021-03-10 | Placer | California | 6061 | 20204 | 232 |
1102409 | 1102409 | 2021-03-09 | Placer | California | 6061 | 20183 | 232 |
1099163 | 1099163 | 2021-03-08 | Placer | California | 6061 | 20162 | 232 |
1095915 | 1095915 | 2021-03-07 | Placer | California | 6061 | 20035 | 232 |
1092669 | 1092669 | 2021-03-06 | Placer | California | 6061 | 20035 | 232 |
1089423 | 1089423 | 2021-03-05 | Placer | California | 6061 | 20035 | 232 |
1086178 | 1086178 | 2021-03-04 | Placer | California | 6061 | 19963 | 232 |
1082932 | 1082932 | 2021-03-03 | Placer | California | 6061 | 19911 | 232 |
1079686 | 1079686 | 2021-03-02 | Placer | California | 6061 | 19882 | 232 |
1076441 | 1076441 | 2021-03-01 | Placer | California | 6061 | 19861 | 232 |
1073195 | 1073195 | 2021-02-28 | Placer | California | 6061 | 19763 | 232 |
1069949 | 1069949 | 2021-02-27 | Placer | California | 6061 | 19763 | 232 |
1066704 | 1066704 | 2021-02-26 | Placer | California | 6061 | 19763 | 232 |
1063459 | 1063459 | 2021-02-25 | Placer | California | 6061 | 19713 | 231 |
1060214 | 1060214 | 2021-02-24 | Placer | California | 6061 | 19702 | 231 |
1056968 | 1056968 | 2021-02-23 | Placer | California | 6061 | 19661 | 231 |
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 |
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);