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 |
---|---|---|---|---|---|---|---|
1517971 | 1517971 | 2021-07-15 | Placer | California | 6061 | 25783 | 304 |
1514724 | 1514724 | 2021-07-14 | Placer | California | 6061 | 25749 | 303 |
1511478 | 1511478 | 2021-07-13 | Placer | California | 6061 | 25710 | 303 |
1508231 | 1508231 | 2021-07-12 | Placer | California | 6061 | 25675 | 303 |
1504985 | 1504985 | 2021-07-11 | Placer | California | 6061 | 25574 | 303 |
1501739 | 1501739 | 2021-07-10 | Placer | California | 6061 | 25574 | 303 |
1498493 | 1498493 | 2021-07-09 | Placer | California | 6061 | 25574 | 303 |
1495246 | 1495246 | 2021-07-08 | Placer | California | 6061 | 25559 | 303 |
1491999 | 1491999 | 2021-07-07 | Placer | California | 6061 | 23876 | 302 |
1488752 | 1488752 | 2021-07-06 | Placer | California | 6061 | 23867 | 302 |
1485505 | 1485505 | 2021-07-05 | Placer | California | 6061 | 23846 | 300 |
1482259 | 1482259 | 2021-07-04 | Placer | California | 6061 | 23846 | 300 |
1479012 | 1479012 | 2021-07-03 | Placer | California | 6061 | 23846 | 300 |
1475766 | 1475766 | 2021-07-02 | Placer | California | 6061 | 23846 | 300 |
1472520 | 1472520 | 2021-07-01 | Placer | California | 6061 | 23793 | 300 |
1469275 | 1469275 | 2021-06-30 | Placer | California | 6061 | 23755 | 300 |
1466030 | 1466030 | 2021-06-29 | Placer | California | 6061 | 23756 | 300 |
1462785 | 1462785 | 2021-06-28 | Placer | California | 6061 | 23751 | 300 |
1459540 | 1459540 | 2021-06-27 | Placer | California | 6061 | 23702 | 300 |
1456295 | 1456295 | 2021-06-26 | Placer | California | 6061 | 23673 | 300 |
1453050 | 1453050 | 2021-06-25 | Placer | California | 6061 | 23673 | 300 |
1449804 | 1449804 | 2021-06-24 | Placer | California | 6061 | 23633 | 300 |
1446559 | 1446559 | 2021-06-23 | Placer | California | 6061 | 23633 | 300 |
1443314 | 1443314 | 2021-06-22 | Placer | California | 6061 | 23604 | 300 |
1440069 | 1440069 | 2021-06-21 | Placer | California | 6061 | 23589 | 299 |
1436822 | 1436822 | 2021-06-20 | Placer | California | 6061 | 23537 | 299 |
1433575 | 1433575 | 2021-06-19 | Placer | California | 6061 | 23518 | 299 |
1430329 | 1430329 | 2021-06-18 | Placer | California | 6061 | 23518 | 299 |
1427084 | 1427084 | 2021-06-17 | Placer | California | 6061 | 23477 | 299 |
1423839 | 1423839 | 2021-06-16 | Placer | California | 6061 | 23438 | 299 |
1420591 | 1420591 | 2021-06-15 | Placer | California | 6061 | 23410 | 299 |
1417346 | 1417346 | 2021-06-14 | Placer | California | 6061 | 23383 | 299 |
1414100 | 1414100 | 2021-06-13 | Placer | California | 6061 | 23345 | 298 |
1410855 | 1410855 | 2021-06-12 | Placer | California | 6061 | 23338 | 298 |
1407610 | 1407610 | 2021-06-11 | Placer | California | 6061 | 23338 | 298 |
1404364 | 1404364 | 2021-06-10 | Placer | California | 6061 | 23305 | 297 |
1401119 | 1401119 | 2021-06-09 | Placer | California | 6061 | 23257 | 297 |
1397874 | 1397874 | 2021-06-08 | Placer | California | 6061 | 23228 | 297 |
1394627 | 1394627 | 2021-06-07 | Placer | California | 6061 | 23196 | 297 |
1391382 | 1391382 | 2021-06-06 | Placer | California | 6061 | 23133 | 297 |
1388137 | 1388137 | 2021-06-05 | Placer | California | 6061 | 23127 | 297 |
1384892 | 1384892 | 2021-06-04 | Placer | California | 6061 | 23127 | 297 |
1381646 | 1381646 | 2021-06-03 | Placer | California | 6061 | 23118 | 297 |
1378401 | 1378401 | 2021-06-02 | Placer | California | 6061 | 23075 | 297 |
1375155 | 1375155 | 2021-06-01 | Placer | California | 6061 | 23042 | 297 |
1371910 | 1371910 | 2021-05-31 | Placer | California | 6061 | 23016 | 297 |
1368665 | 1368665 | 2021-05-30 | Placer | California | 6061 | 23009 | 297 |
1365419 | 1365419 | 2021-05-29 | Placer | California | 6061 | 23004 | 297 |
1362173 | 1362173 | 2021-05-28 | Placer | California | 6061 | 23004 | 297 |
1358926 | 1358926 | 2021-05-27 | Placer | California | 6061 | 22956 | 296 |
1355680 | 1355680 | 2021-05-26 | Placer | California | 6061 | 22956 | 296 |
1352434 | 1352434 | 2021-05-25 | Placer | California | 6061 | 22942 | 295 |
1349188 | 1349188 | 2021-05-24 | Placer | California | 6061 | 22918 | 295 |
1345941 | 1345941 | 2021-05-23 | Placer | California | 6061 | 22871 | 295 |
1342693 | 1342693 | 2021-05-22 | Placer | California | 6061 | 22871 | 295 |
1339445 | 1339445 | 2021-05-21 | Placer | California | 6061 | 22871 | 295 |
1336198 | 1336198 | 2021-05-20 | Placer | California | 6061 | 22841 | 295 |
1332951 | 1332951 | 2021-05-19 | Placer | California | 6061 | 22801 | 295 |
1329704 | 1329704 | 2021-05-18 | Placer | California | 6061 | 22745 | 294 |
1326457 | 1326457 | 2021-05-17 | Placer | California | 6061 | 22720 | 293 |
1323211 | 1323211 | 2021-05-16 | Placer | California | 6061 | 22688 | 292 |
1319965 | 1319965 | 2021-05-15 | Placer | California | 6061 | 22679 | 292 |
1316718 | 1316718 | 2021-05-14 | Placer | California | 6061 | 22679 | 292 |
1313471 | 1313471 | 2021-05-13 | Placer | California | 6061 | 22679 | 292 |
1310224 | 1310224 | 2021-05-12 | Placer | California | 6061 | 22665 | 292 |
1306978 | 1306978 | 2021-05-11 | Placer | California | 6061 | 22635 | 292 |
1303732 | 1303732 | 2021-05-10 | Placer | California | 6061 | 22610 | 291 |
1300485 | 1300485 | 2021-05-09 | Placer | California | 6061 | 22550 | 290 |
1297238 | 1297238 | 2021-05-08 | Placer | California | 6061 | 22550 | 290 |
1293992 | 1293992 | 2021-05-07 | Placer | California | 6061 | 22550 | 290 |
1290746 | 1290746 | 2021-05-06 | Placer | California | 6061 | 22532 | 290 |
1287500 | 1287500 | 2021-05-05 | Placer | California | 6061 | 22386 | 290 |
1284254 | 1284254 | 2021-05-04 | Placer | California | 6061 | 22358 | 289 |
1281007 | 1281007 | 2021-05-03 | Placer | California | 6061 | 22323 | 289 |
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 |
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);