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 |
---|---|---|---|---|---|---|---|
1277760 | 1277760 | 2021-05-02 | Placer | California | 6061 | 22240 | 289 |
1274513 | 1274513 | 2021-05-01 | Placer | California | 6061 | 22222 | 289 |
1271266 | 1271266 | 2021-04-30 | Placer | California | 6061 | 22222 | 289 |
1268019 | 1268019 | 2021-04-29 | Placer | California | 6061 | 22193 | 288 |
1264772 | 1264772 | 2021-04-28 | Placer | California | 6061 | 22151 | 286 |
1261525 | 1261525 | 2021-04-27 | Placer | California | 6061 | 22120 | 286 |
1258278 | 1258278 | 2021-04-26 | Placer | California | 6061 | 22107 | 286 |
1255031 | 1255031 | 2021-04-25 | Placer | California | 6061 | 22028 | 285 |
1251784 | 1251784 | 2021-04-24 | Placer | California | 6061 | 22028 | 284 |
1248537 | 1248537 | 2021-04-23 | Placer | California | 6061 | 22028 | 284 |
1245290 | 1245290 | 2021-04-22 | Placer | California | 6061 | 21979 | 283 |
1242043 | 1242043 | 2021-04-21 | Placer | California | 6061 | 21957 | 283 |
1238796 | 1238796 | 2021-04-20 | Placer | California | 6061 | 21908 | 283 |
1235549 | 1235549 | 2021-04-19 | Placer | California | 6061 | 21878 | 283 |
1232302 | 1232302 | 2021-04-18 | Placer | California | 6061 | 21751 | 283 |
1229053 | 1229053 | 2021-04-17 | Placer | California | 6061 | 21751 | 283 |
1225805 | 1225805 | 2021-04-16 | Placer | California | 6061 | 21751 | 283 |
1222558 | 1222558 | 2021-04-15 | Placer | California | 6061 | 21686 | 282 |
1219310 | 1219310 | 2021-04-14 | Placer | California | 6061 | 21644 | 281 |
1216062 | 1216062 | 2021-04-13 | Placer | California | 6061 | 21600 | 281 |
1212815 | 1212815 | 2021-04-12 | Placer | California | 6061 | 21540 | 279 |
1209567 | 1209567 | 2021-04-11 | Placer | California | 6061 | 21402 | 279 |
1206318 | 1206318 | 2021-04-10 | Placer | California | 6061 | 21389 | 279 |
1203070 | 1203070 | 2021-04-09 | Placer | California | 6061 | 21389 | 279 |
1199822 | 1199822 | 2021-04-08 | Placer | California | 6061 | 21317 | 278 |
1196573 | 1196573 | 2021-04-07 | Placer | California | 6061 | 21287 | 277 |
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 |
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);