ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Santa Cruz" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1621922 | 1621922 | 2021-08-16 | Santa Cruz | California | 6087 | 18327 | 209 |
1618675 | 1618675 | 2021-08-15 | Santa Cruz | California | 6087 | 18271 | 209 |
1615427 | 1615427 | 2021-08-14 | Santa Cruz | California | 6087 | 18219 | 209 |
1612178 | 1612178 | 2021-08-13 | Santa Cruz | California | 6087 | 18148 | 209 |
1608930 | 1608930 | 2021-08-12 | Santa Cruz | California | 6087 | 18078 | 209 |
1605681 | 1605681 | 2021-08-11 | Santa Cruz | California | 6087 | 18029 | 209 |
1602432 | 1602432 | 2021-08-10 | Santa Cruz | California | 6087 | 17969 | 209 |
1599183 | 1599183 | 2021-08-09 | Santa Cruz | California | 6087 | 17922 | 209 |
1595934 | 1595934 | 2021-08-08 | Santa Cruz | California | 6087 | 17881 | 209 |
1592685 | 1592685 | 2021-08-07 | Santa Cruz | California | 6087 | 17754 | 207 |
1589436 | 1589436 | 2021-08-06 | Santa Cruz | California | 6087 | 17754 | 207 |
1586187 | 1586187 | 2021-08-05 | Santa Cruz | California | 6087 | 17707 | 208 |
1582937 | 1582937 | 2021-08-04 | Santa Cruz | California | 6087 | 17663 | 207 |
1579687 | 1579687 | 2021-08-03 | Santa Cruz | California | 6087 | 17631 | 207 |
1576439 | 1576439 | 2021-08-02 | Santa Cruz | California | 6087 | 17594 | 207 |
1573191 | 1573191 | 2021-08-01 | Santa Cruz | California | 6087 | 17461 | 207 |
1569943 | 1569943 | 2021-07-31 | Santa Cruz | California | 6087 | 17461 | 207 |
1566695 | 1566695 | 2021-07-30 | Santa Cruz | California | 6087 | 17461 | 207 |
1563447 | 1563447 | 2021-07-29 | Santa Cruz | California | 6087 | 17436 | 207 |
1560199 | 1560199 | 2021-07-28 | Santa Cruz | California | 6087 | 17406 | 207 |
1556952 | 1556952 | 2021-07-27 | Santa Cruz | California | 6087 | 17376 | 207 |
1553705 | 1553705 | 2021-07-26 | Santa Cruz | California | 6087 | 17357 | 207 |
1550458 | 1550458 | 2021-07-25 | Santa Cruz | California | 6087 | 17299 | 207 |
1547211 | 1547211 | 2021-07-24 | Santa Cruz | California | 6087 | 17299 | 207 |
1543964 | 1543964 | 2021-07-23 | Santa Cruz | California | 6087 | 17299 | 207 |
1540716 | 1540716 | 2021-07-22 | Santa Cruz | California | 6087 | 17290 | 207 |
1537469 | 1537469 | 2021-07-21 | Santa Cruz | California | 6087 | 17279 | 207 |
1534221 | 1534221 | 2021-07-20 | Santa Cruz | California | 6087 | 17267 | 207 |
1530974 | 1530974 | 2021-07-19 | Santa Cruz | California | 6087 | 17252 | 207 |
1527727 | 1527727 | 2021-07-18 | Santa Cruz | California | 6087 | 17217 | 207 |
1524480 | 1524480 | 2021-07-17 | Santa Cruz | California | 6087 | 17217 | 207 |
1521232 | 1521232 | 2021-07-16 | Santa Cruz | California | 6087 | 17217 | 207 |
1517984 | 1517984 | 2021-07-15 | Santa Cruz | California | 6087 | 17206 | 207 |
1514737 | 1514737 | 2021-07-14 | Santa Cruz | California | 6087 | 17195 | 207 |
1511491 | 1511491 | 2021-07-13 | Santa Cruz | California | 6087 | 17190 | 207 |
1508244 | 1508244 | 2021-07-12 | Santa Cruz | California | 6087 | 17183 | 207 |
1504998 | 1504998 | 2021-07-11 | Santa Cruz | California | 6087 | 17166 | 207 |
1501752 | 1501752 | 2021-07-10 | Santa Cruz | California | 6087 | 17166 | 207 |
1498506 | 1498506 | 2021-07-09 | Santa Cruz | California | 6087 | 17166 | 207 |
1495259 | 1495259 | 2021-07-08 | Santa Cruz | California | 6087 | 17159 | 207 |
1492012 | 1492012 | 2021-07-07 | Santa Cruz | California | 6087 | 16306 | 207 |
1488765 | 1488765 | 2021-07-06 | Santa Cruz | California | 6087 | 16306 | 208 |
1485518 | 1485518 | 2021-07-05 | Santa Cruz | California | 6087 | 16289 | 208 |
1482272 | 1482272 | 2021-07-04 | Santa Cruz | California | 6087 | 16289 | 208 |
1479025 | 1479025 | 2021-07-03 | Santa Cruz | California | 6087 | 16289 | 208 |
1475779 | 1475779 | 2021-07-02 | Santa Cruz | California | 6087 | 16289 | 208 |
1472533 | 1472533 | 2021-07-01 | Santa Cruz | California | 6087 | 16289 | 208 |
1469288 | 1469288 | 2021-06-30 | Santa Cruz | California | 6087 | 16269 | 208 |
1466043 | 1466043 | 2021-06-29 | Santa Cruz | California | 6087 | 16269 | 208 |
1462798 | 1462798 | 2021-06-28 | Santa Cruz | California | 6087 | 16269 | 208 |
1459553 | 1459553 | 2021-06-27 | Santa Cruz | California | 6087 | 16262 | 208 |
1456308 | 1456308 | 2021-06-26 | Santa Cruz | California | 6087 | 16262 | 208 |
1453063 | 1453063 | 2021-06-25 | Santa Cruz | California | 6087 | 16262 | 208 |
1449817 | 1449817 | 2021-06-24 | Santa Cruz | California | 6087 | 16262 | 209 |
1446572 | 1446572 | 2021-06-23 | Santa Cruz | California | 6087 | 16246 | 209 |
1443327 | 1443327 | 2021-06-22 | Santa Cruz | California | 6087 | 16246 | 208 |
1440082 | 1440082 | 2021-06-21 | Santa Cruz | California | 6087 | 16246 | 208 |
1436835 | 1436835 | 2021-06-20 | Santa Cruz | California | 6087 | 16235 | 208 |
1433588 | 1433588 | 2021-06-19 | Santa Cruz | California | 6087 | 16235 | 208 |
1430342 | 1430342 | 2021-06-18 | Santa Cruz | California | 6087 | 16235 | 208 |
1427097 | 1427097 | 2021-06-17 | Santa Cruz | California | 6087 | 16232 | 208 |
1423852 | 1423852 | 2021-06-16 | Santa Cruz | California | 6087 | 16222 | 208 |
1420604 | 1420604 | 2021-06-15 | Santa Cruz | California | 6087 | 16216 | 208 |
1417359 | 1417359 | 2021-06-14 | Santa Cruz | California | 6087 | 16206 | 208 |
1414113 | 1414113 | 2021-06-13 | Santa Cruz | California | 6087 | 16202 | 208 |
1410868 | 1410868 | 2021-06-12 | Santa Cruz | California | 6087 | 16202 | 208 |
1407623 | 1407623 | 2021-06-11 | Santa Cruz | California | 6087 | 16202 | 208 |
1404377 | 1404377 | 2021-06-10 | Santa Cruz | California | 6087 | 16198 | 208 |
1401132 | 1401132 | 2021-06-09 | Santa Cruz | California | 6087 | 16191 | 208 |
1397887 | 1397887 | 2021-06-08 | Santa Cruz | California | 6087 | 16199 | 208 |
1394640 | 1394640 | 2021-06-07 | Santa Cruz | California | 6087 | 16200 | 208 |
1391395 | 1391395 | 2021-06-06 | Santa Cruz | California | 6087 | 16190 | 208 |
1388150 | 1388150 | 2021-06-05 | Santa Cruz | California | 6087 | 16190 | 207 |
1384905 | 1384905 | 2021-06-04 | Santa Cruz | California | 6087 | 16190 | 207 |
1381659 | 1381659 | 2021-06-03 | Santa Cruz | California | 6087 | 16182 | 207 |
1378414 | 1378414 | 2021-06-02 | Santa Cruz | California | 6087 | 16182 | 207 |
1375168 | 1375168 | 2021-06-01 | Santa Cruz | California | 6087 | 16182 | 207 |
1371923 | 1371923 | 2021-05-31 | Santa Cruz | California | 6087 | 16169 | 207 |
1368678 | 1368678 | 2021-05-30 | Santa Cruz | California | 6087 | 16169 | 207 |
1365432 | 1365432 | 2021-05-29 | Santa Cruz | California | 6087 | 16169 | 207 |
1362186 | 1362186 | 2021-05-28 | Santa Cruz | California | 6087 | 16169 | 207 |
1358939 | 1358939 | 2021-05-27 | Santa Cruz | California | 6087 | 16177 | 207 |
1355693 | 1355693 | 2021-05-26 | Santa Cruz | California | 6087 | 16177 | 207 |
1352447 | 1352447 | 2021-05-25 | Santa Cruz | California | 6087 | 16177 | 207 |
1349201 | 1349201 | 2021-05-24 | Santa Cruz | California | 6087 | 16173 | 207 |
1345954 | 1345954 | 2021-05-23 | Santa Cruz | California | 6087 | 16159 | 207 |
1342706 | 1342706 | 2021-05-22 | Santa Cruz | California | 6087 | 16159 | 207 |
1339458 | 1339458 | 2021-05-21 | Santa Cruz | California | 6087 | 16159 | 207 |
1336211 | 1336211 | 2021-05-20 | Santa Cruz | California | 6087 | 16159 | 207 |
1332964 | 1332964 | 2021-05-19 | Santa Cruz | California | 6087 | 16275 | 207 |
1329717 | 1329717 | 2021-05-18 | Santa Cruz | California | 6087 | 16275 | 206 |
1326470 | 1326470 | 2021-05-17 | Santa Cruz | California | 6087 | 16275 | 206 |
1323224 | 1323224 | 2021-05-16 | Santa Cruz | California | 6087 | 16264 | 206 |
1319978 | 1319978 | 2021-05-15 | Santa Cruz | California | 6087 | 16264 | 207 |
1316731 | 1316731 | 2021-05-14 | Santa Cruz | California | 6087 | 16264 | 208 |
1313484 | 1313484 | 2021-05-13 | Santa Cruz | California | 6087 | 16264 | 207 |
1310237 | 1310237 | 2021-05-12 | Santa Cruz | California | 6087 | 16249 | 206 |
1306991 | 1306991 | 2021-05-11 | Santa Cruz | California | 6087 | 16246 | 206 |
1303745 | 1303745 | 2021-05-10 | Santa Cruz | California | 6087 | 16238 | 206 |
1300498 | 1300498 | 2021-05-09 | Santa Cruz | California | 6087 | 16188 | 206 |
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);