ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
808 rows where fips = 6097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1517989 | 1517989 | 2021-07-15 | Sonoma | California | 6097 | 31851 | 323 |
1514742 | 1514742 | 2021-07-14 | Sonoma | California | 6097 | 31812 | 323 |
1511496 | 1511496 | 2021-07-13 | Sonoma | California | 6097 | 31758 | 323 |
1508249 | 1508249 | 2021-07-12 | Sonoma | California | 6097 | 31733 | 323 |
1505003 | 1505003 | 2021-07-11 | Sonoma | California | 6097 | 31612 | 323 |
1501757 | 1501757 | 2021-07-10 | Sonoma | California | 6097 | 31612 | 323 |
1498511 | 1498511 | 2021-07-09 | Sonoma | California | 6097 | 31612 | 319 |
1495264 | 1495264 | 2021-07-08 | Sonoma | California | 6097 | 31553 | 319 |
1492017 | 1492017 | 2021-07-07 | Sonoma | California | 6097 | 31160 | 318 |
1488770 | 1488770 | 2021-07-06 | Sonoma | California | 6097 | 31160 | 318 |
1485523 | 1485523 | 2021-07-05 | Sonoma | California | 6097 | 31160 | 318 |
1482277 | 1482277 | 2021-07-04 | Sonoma | California | 6097 | 31160 | 318 |
1479030 | 1479030 | 2021-07-03 | Sonoma | California | 6097 | 31116 | 318 |
1475784 | 1475784 | 2021-07-02 | Sonoma | California | 6097 | 31090 | 318 |
1472538 | 1472538 | 2021-07-01 | Sonoma | California | 6097 | 31026 | 318 |
1469293 | 1469293 | 2021-06-30 | Sonoma | California | 6097 | 30950 | 318 |
1466048 | 1466048 | 2021-06-29 | Sonoma | California | 6097 | 31137 | 317 |
1462803 | 1462803 | 2021-06-28 | Sonoma | California | 6097 | 31129 | 317 |
1459558 | 1459558 | 2021-06-27 | Sonoma | California | 6097 | 31103 | 317 |
1456313 | 1456313 | 2021-06-26 | Sonoma | California | 6097 | 31059 | 317 |
1453068 | 1453068 | 2021-06-25 | Sonoma | California | 6097 | 31026 | 317 |
1449822 | 1449822 | 2021-06-24 | Sonoma | California | 6097 | 30974 | 317 |
1446577 | 1446577 | 2021-06-23 | Sonoma | California | 6097 | 30957 | 317 |
1443332 | 1443332 | 2021-06-22 | Sonoma | California | 6097 | 30957 | 317 |
1440087 | 1440087 | 2021-06-21 | Sonoma | California | 6097 | 30884 | 317 |
1436840 | 1436840 | 2021-06-20 | Sonoma | California | 6097 | 30868 | 317 |
1433593 | 1433593 | 2021-06-19 | Sonoma | California | 6097 | 30844 | 316 |
1430347 | 1430347 | 2021-06-18 | Sonoma | California | 6097 | 30825 | 323 |
1427102 | 1427102 | 2021-06-17 | Sonoma | California | 6097 | 30783 | 323 |
1423857 | 1423857 | 2021-06-16 | Sonoma | California | 6097 | 30752 | 323 |
1420609 | 1420609 | 2021-06-15 | Sonoma | California | 6097 | 30688 | 323 |
1417364 | 1417364 | 2021-06-14 | Sonoma | California | 6097 | 30688 | 323 |
1414118 | 1414118 | 2021-06-13 | Sonoma | California | 6097 | 30688 | 323 |
1410873 | 1410873 | 2021-06-12 | Sonoma | California | 6097 | 30659 | 323 |
1407628 | 1407628 | 2021-06-11 | Sonoma | California | 6097 | 30616 | 323 |
1404382 | 1404382 | 2021-06-10 | Sonoma | California | 6097 | 30586 | 323 |
1401137 | 1401137 | 2021-06-09 | Sonoma | California | 6097 | 30569 | 323 |
1397892 | 1397892 | 2021-06-08 | Sonoma | California | 6097 | 30504 | 323 |
1394645 | 1394645 | 2021-06-07 | Sonoma | California | 6097 | 30493 | 323 |
1391400 | 1391400 | 2021-06-06 | Sonoma | California | 6097 | 30493 | 323 |
1388155 | 1388155 | 2021-06-05 | Sonoma | California | 6097 | 30454 | 323 |
1384910 | 1384910 | 2021-06-04 | Sonoma | California | 6097 | 30422 | 322 |
1381664 | 1381664 | 2021-06-03 | Sonoma | California | 6097 | 30393 | 322 |
1378419 | 1378419 | 2021-06-02 | Sonoma | California | 6097 | 30336 | 322 |
1375173 | 1375173 | 2021-06-01 | Sonoma | California | 6097 | 30336 | 322 |
1371928 | 1371928 | 2021-05-31 | Sonoma | California | 6097 | 30336 | 322 |
1368683 | 1368683 | 2021-05-30 | Sonoma | California | 6097 | 30333 | 322 |
1365437 | 1365437 | 2021-05-29 | Sonoma | California | 6097 | 30298 | 321 |
1362191 | 1362191 | 2021-05-28 | Sonoma | California | 6097 | 30269 | 321 |
1358944 | 1358944 | 2021-05-27 | Sonoma | California | 6097 | 30257 | 321 |
1355698 | 1355698 | 2021-05-26 | Sonoma | California | 6097 | 30230 | 321 |
1352452 | 1352452 | 2021-05-25 | Sonoma | California | 6097 | 30187 | 321 |
1349206 | 1349206 | 2021-05-24 | Sonoma | California | 6097 | 30169 | 321 |
1345959 | 1345959 | 2021-05-23 | Sonoma | California | 6097 | 30168 | 321 |
1342711 | 1342711 | 2021-05-22 | Sonoma | California | 6097 | 30150 | 321 |
1339463 | 1339463 | 2021-05-21 | Sonoma | California | 6097 | 30130 | 321 |
1336216 | 1336216 | 2021-05-20 | Sonoma | California | 6097 | 30104 | 321 |
1332969 | 1332969 | 2021-05-19 | Sonoma | California | 6097 | 30101 | 321 |
1329722 | 1329722 | 2021-05-18 | Sonoma | California | 6097 | 30071 | 321 |
1326475 | 1326475 | 2021-05-17 | Sonoma | California | 6097 | 30067 | 321 |
1323229 | 1323229 | 2021-05-16 | Sonoma | California | 6097 | 30057 | 321 |
1319983 | 1319983 | 2021-05-15 | Sonoma | California | 6097 | 30053 | 321 |
1316736 | 1316736 | 2021-05-14 | Sonoma | California | 6097 | 30035 | 321 |
1313489 | 1313489 | 2021-05-13 | Sonoma | California | 6097 | 30035 | 320 |
1310242 | 1310242 | 2021-05-12 | Sonoma | California | 6097 | 30012 | 318 |
1306996 | 1306996 | 2021-05-11 | Sonoma | California | 6097 | 30002 | 318 |
1303750 | 1303750 | 2021-05-10 | Sonoma | California | 6097 | 29984 | 318 |
1300503 | 1300503 | 2021-05-09 | Sonoma | California | 6097 | 29975 | 318 |
1297256 | 1297256 | 2021-05-08 | Sonoma | California | 6097 | 29966 | 318 |
1294010 | 1294010 | 2021-05-07 | Sonoma | California | 6097 | 29951 | 318 |
1290764 | 1290764 | 2021-05-06 | Sonoma | California | 6097 | 29921 | 318 |
1287518 | 1287518 | 2021-05-05 | Sonoma | California | 6097 | 29910 | 318 |
1284272 | 1284272 | 2021-05-04 | Sonoma | California | 6097 | 29897 | 318 |
1281025 | 1281025 | 2021-05-03 | Sonoma | California | 6097 | 29886 | 318 |
1277778 | 1277778 | 2021-05-02 | Sonoma | California | 6097 | 29876 | 318 |
1274531 | 1274531 | 2021-05-01 | Sonoma | California | 6097 | 29856 | 318 |
1271284 | 1271284 | 2021-04-30 | Sonoma | California | 6097 | 29832 | 318 |
1268037 | 1268037 | 2021-04-29 | Sonoma | California | 6097 | 29818 | 318 |
1264790 | 1264790 | 2021-04-28 | Sonoma | California | 6097 | 29807 | 318 |
1261543 | 1261543 | 2021-04-27 | Sonoma | California | 6097 | 29794 | 318 |
1258296 | 1258296 | 2021-04-26 | Sonoma | California | 6097 | 29778 | 318 |
1255049 | 1255049 | 2021-04-25 | Sonoma | California | 6097 | 29776 | 318 |
1251802 | 1251802 | 2021-04-24 | Sonoma | California | 6097 | 29762 | 318 |
1248555 | 1248555 | 2021-04-23 | Sonoma | California | 6097 | 29747 | 318 |
1245308 | 1245308 | 2021-04-22 | Sonoma | California | 6097 | 29734 | 318 |
1242061 | 1242061 | 2021-04-21 | Sonoma | California | 6097 | 29720 | 311 |
1238814 | 1238814 | 2021-04-20 | Sonoma | California | 6097 | 29715 | 311 |
1235567 | 1235567 | 2021-04-19 | Sonoma | California | 6097 | 29696 | 311 |
1232320 | 1232320 | 2021-04-18 | Sonoma | California | 6097 | 29679 | 311 |
1229071 | 1229071 | 2021-04-17 | Sonoma | California | 6097 | 29632 | 311 |
1225823 | 1225823 | 2021-04-16 | Sonoma | California | 6097 | 29632 | 311 |
1222576 | 1222576 | 2021-04-15 | Sonoma | California | 6097 | 29632 | 311 |
1219328 | 1219328 | 2021-04-14 | Sonoma | California | 6097 | 29608 | 311 |
1216080 | 1216080 | 2021-04-13 | Sonoma | California | 6097 | 29573 | 311 |
1212833 | 1212833 | 2021-04-12 | Sonoma | California | 6097 | 29536 | 310 |
1209585 | 1209585 | 2021-04-11 | Sonoma | California | 6097 | 29525 | 310 |
1206336 | 1206336 | 2021-04-10 | Sonoma | California | 6097 | 29501 | 310 |
1203088 | 1203088 | 2021-04-09 | Sonoma | California | 6097 | 29448 | 310 |
1199840 | 1199840 | 2021-04-08 | Sonoma | California | 6097 | 29448 | 310 |
1196591 | 1196591 | 2021-04-07 | Sonoma | California | 6097 | 29431 | 311 |
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);