ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
814 rows where fips = 6023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1517952 | 1517952 | 2021-07-15 | Humboldt | California | 6023 | 4781 | 53 |
1514705 | 1514705 | 2021-07-14 | Humboldt | California | 6023 | 4771 | 53 |
1511459 | 1511459 | 2021-07-13 | Humboldt | California | 6023 | 4758 | 52 |
1508212 | 1508212 | 2021-07-12 | Humboldt | California | 6023 | 4748 | 51 |
1504966 | 1504966 | 2021-07-11 | Humboldt | California | 6023 | 4711 | 51 |
1501720 | 1501720 | 2021-07-10 | Humboldt | California | 6023 | 4711 | 51 |
1498474 | 1498474 | 2021-07-09 | Humboldt | California | 6023 | 4711 | 51 |
1495227 | 1495227 | 2021-07-08 | Humboldt | California | 6023 | 4703 | 51 |
1491980 | 1491980 | 2021-07-07 | Humboldt | California | 6023 | 4614 | 51 |
1488733 | 1488733 | 2021-07-06 | Humboldt | California | 6023 | 4608 | 51 |
1485486 | 1485486 | 2021-07-05 | Humboldt | California | 6023 | 4586 | 50 |
1482240 | 1482240 | 2021-07-04 | Humboldt | California | 6023 | 4586 | 50 |
1478993 | 1478993 | 2021-07-03 | Humboldt | California | 6023 | 4586 | 50 |
1475747 | 1475747 | 2021-07-02 | Humboldt | California | 6023 | 4586 | 50 |
1472501 | 1472501 | 2021-07-01 | Humboldt | California | 6023 | 4582 | 50 |
1469256 | 1469256 | 2021-06-30 | Humboldt | California | 6023 | 4569 | 50 |
1466011 | 1466011 | 2021-06-29 | Humboldt | California | 6023 | 4560 | 50 |
1462766 | 1462766 | 2021-06-28 | Humboldt | California | 6023 | 4554 | 50 |
1459521 | 1459521 | 2021-06-27 | Humboldt | California | 6023 | 4533 | 50 |
1456276 | 1456276 | 2021-06-26 | Humboldt | California | 6023 | 4533 | 50 |
1453031 | 1453031 | 2021-06-25 | Humboldt | California | 6023 | 4533 | 50 |
1449785 | 1449785 | 2021-06-24 | Humboldt | California | 6023 | 4528 | 49 |
1446540 | 1446540 | 2021-06-23 | Humboldt | California | 6023 | 4514 | 49 |
1443295 | 1443295 | 2021-06-22 | Humboldt | California | 6023 | 4508 | 49 |
1440050 | 1440050 | 2021-06-21 | Humboldt | California | 6023 | 4499 | 48 |
1436803 | 1436803 | 2021-06-20 | Humboldt | California | 6023 | 4463 | 48 |
1433556 | 1433556 | 2021-06-19 | Humboldt | California | 6023 | 4462 | 48 |
1430310 | 1430310 | 2021-06-18 | Humboldt | California | 6023 | 4462 | 48 |
1427065 | 1427065 | 2021-06-17 | Humboldt | California | 6023 | 4462 | 48 |
1423820 | 1423820 | 2021-06-16 | Humboldt | California | 6023 | 4451 | 48 |
1420572 | 1420572 | 2021-06-15 | Humboldt | California | 6023 | 4442 | 47 |
1417327 | 1417327 | 2021-06-14 | Humboldt | California | 6023 | 4434 | 46 |
1414081 | 1414081 | 2021-06-13 | Humboldt | California | 6023 | 4415 | 46 |
1410836 | 1410836 | 2021-06-12 | Humboldt | California | 6023 | 4415 | 46 |
1407591 | 1407591 | 2021-06-11 | Humboldt | California | 6023 | 4415 | 46 |
1404345 | 1404345 | 2021-06-10 | Humboldt | California | 6023 | 4408 | 46 |
1401100 | 1401100 | 2021-06-09 | Humboldt | California | 6023 | 4405 | 46 |
1397855 | 1397855 | 2021-06-08 | Humboldt | California | 6023 | 4390 | 46 |
1394608 | 1394608 | 2021-06-07 | Humboldt | California | 6023 | 4382 | 46 |
1391363 | 1391363 | 2021-06-06 | Humboldt | California | 6023 | 4355 | 45 |
1388118 | 1388118 | 2021-06-05 | Humboldt | California | 6023 | 4355 | 45 |
1384873 | 1384873 | 2021-06-04 | Humboldt | California | 6023 | 4355 | 45 |
1381627 | 1381627 | 2021-06-03 | Humboldt | California | 6023 | 4339 | 44 |
1378382 | 1378382 | 2021-06-02 | Humboldt | California | 6023 | 4325 | 43 |
1375136 | 1375136 | 2021-06-01 | Humboldt | California | 6023 | 4323 | 43 |
1371891 | 1371891 | 2021-05-31 | Humboldt | California | 6023 | 4291 | 43 |
1368646 | 1368646 | 2021-05-30 | Humboldt | California | 6023 | 4285 | 43 |
1365400 | 1365400 | 2021-05-29 | Humboldt | California | 6023 | 4285 | 43 |
1362154 | 1362154 | 2021-05-28 | Humboldt | California | 6023 | 4285 | 43 |
1358907 | 1358907 | 2021-05-27 | Humboldt | California | 6023 | 4279 | 43 |
1355661 | 1355661 | 2021-05-26 | Humboldt | California | 6023 | 4266 | 43 |
1352415 | 1352415 | 2021-05-25 | Humboldt | California | 6023 | 4253 | 43 |
1349169 | 1349169 | 2021-05-24 | Humboldt | California | 6023 | 4248 | 43 |
1345922 | 1345922 | 2021-05-23 | Humboldt | California | 6023 | 4198 | 42 |
1342674 | 1342674 | 2021-05-22 | Humboldt | California | 6023 | 4198 | 42 |
1339426 | 1339426 | 2021-05-21 | Humboldt | California | 6023 | 4198 | 42 |
1336179 | 1336179 | 2021-05-20 | Humboldt | California | 6023 | 4186 | 42 |
1332932 | 1332932 | 2021-05-19 | Humboldt | California | 6023 | 4166 | 42 |
1329685 | 1329685 | 2021-05-18 | Humboldt | California | 6023 | 4152 | 42 |
1326438 | 1326438 | 2021-05-17 | Humboldt | California | 6023 | 4135 | 42 |
1323192 | 1323192 | 2021-05-16 | Humboldt | California | 6023 | 4080 | 42 |
1319946 | 1319946 | 2021-05-15 | Humboldt | California | 6023 | 4072 | 42 |
1316699 | 1316699 | 2021-05-14 | Humboldt | California | 6023 | 4072 | 42 |
1313452 | 1313452 | 2021-05-13 | Humboldt | California | 6023 | 4046 | 41 |
1310205 | 1310205 | 2021-05-12 | Humboldt | California | 6023 | 4002 | 41 |
1306959 | 1306959 | 2021-05-11 | Humboldt | California | 6023 | 3984 | 40 |
1303713 | 1303713 | 2021-05-10 | Humboldt | California | 6023 | 3980 | 40 |
1300466 | 1300466 | 2021-05-09 | Humboldt | California | 6023 | 3939 | 39 |
1297219 | 1297219 | 2021-05-08 | Humboldt | California | 6023 | 3935 | 39 |
1293973 | 1293973 | 2021-05-07 | Humboldt | California | 6023 | 3935 | 39 |
1290727 | 1290727 | 2021-05-06 | Humboldt | California | 6023 | 3915 | 39 |
1287481 | 1287481 | 2021-05-05 | Humboldt | California | 6023 | 3903 | 39 |
1284235 | 1284235 | 2021-05-04 | Humboldt | California | 6023 | 3895 | 39 |
1280988 | 1280988 | 2021-05-03 | Humboldt | California | 6023 | 3885 | 38 |
1277741 | 1277741 | 2021-05-02 | Humboldt | California | 6023 | 3852 | 38 |
1274494 | 1274494 | 2021-05-01 | Humboldt | California | 6023 | 3852 | 38 |
1271247 | 1271247 | 2021-04-30 | Humboldt | California | 6023 | 3852 | 38 |
1268000 | 1268000 | 2021-04-29 | Humboldt | California | 6023 | 3833 | 38 |
1264753 | 1264753 | 2021-04-28 | Humboldt | California | 6023 | 3814 | 38 |
1261506 | 1261506 | 2021-04-27 | Humboldt | California | 6023 | 3799 | 38 |
1258259 | 1258259 | 2021-04-26 | Humboldt | California | 6023 | 3785 | 38 |
1255012 | 1255012 | 2021-04-25 | Humboldt | California | 6023 | 3722 | 38 |
1251765 | 1251765 | 2021-04-24 | Humboldt | California | 6023 | 3717 | 38 |
1248518 | 1248518 | 2021-04-23 | Humboldt | California | 6023 | 3717 | 38 |
1245271 | 1245271 | 2021-04-22 | Humboldt | California | 6023 | 3697 | 38 |
1242024 | 1242024 | 2021-04-21 | Humboldt | California | 6023 | 3659 | 38 |
1238777 | 1238777 | 2021-04-20 | Humboldt | California | 6023 | 3631 | 38 |
1235530 | 1235530 | 2021-04-19 | Humboldt | California | 6023 | 3621 | 38 |
1232283 | 1232283 | 2021-04-18 | Humboldt | California | 6023 | 3587 | 37 |
1229034 | 1229034 | 2021-04-17 | Humboldt | California | 6023 | 3587 | 37 |
1225786 | 1225786 | 2021-04-16 | Humboldt | California | 6023 | 3587 | 37 |
1222539 | 1222539 | 2021-04-15 | Humboldt | California | 6023 | 3579 | 37 |
1219291 | 1219291 | 2021-04-14 | Humboldt | California | 6023 | 3572 | 36 |
1216043 | 1216043 | 2021-04-13 | Humboldt | California | 6023 | 3560 | 36 |
1212796 | 1212796 | 2021-04-12 | Humboldt | California | 6023 | 3553 | 36 |
1209548 | 1209548 | 2021-04-11 | Humboldt | California | 6023 | 3518 | 36 |
1206299 | 1206299 | 2021-04-10 | Humboldt | California | 6023 | 3518 | 36 |
1203051 | 1203051 | 2021-04-09 | Humboldt | California | 6023 | 3518 | 36 |
1199803 | 1199803 | 2021-04-08 | Humboldt | California | 6023 | 3508 | 36 |
1196554 | 1196554 | 2021-04-07 | Humboldt | California | 6023 | 3507 | 36 |
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);