ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 37097 and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1717846 | 1717846 | 2021-09-14 | Iredell | North Carolina | 37097 | 25566 | 271 |
1714598 | 1714598 | 2021-09-13 | Iredell | North Carolina | 37097 | 25435 | 268 |
1711352 | 1711352 | 2021-09-12 | Iredell | North Carolina | 37097 | 24780 | 265 |
1708105 | 1708105 | 2021-09-11 | Iredell | North Carolina | 37097 | 24780 | 265 |
1704858 | 1704858 | 2021-09-10 | Iredell | North Carolina | 37097 | 24780 | 265 |
1701608 | 1701608 | 2021-09-09 | Iredell | North Carolina | 37097 | 24585 | 263 |
1698359 | 1698359 | 2021-09-08 | Iredell | North Carolina | 37097 | 24440 | 259 |
1695111 | 1695111 | 2021-09-07 | Iredell | North Carolina | 37097 | 24316 | 259 |
1691863 | 1691863 | 2021-09-06 | Iredell | North Carolina | 37097 | 23800 | 254 |
1688613 | 1688613 | 2021-09-05 | Iredell | North Carolina | 37097 | 23800 | 254 |
1685363 | 1685363 | 2021-09-04 | Iredell | North Carolina | 37097 | 23800 | 254 |
1682112 | 1682112 | 2021-09-03 | Iredell | North Carolina | 37097 | 23800 | 254 |
1678863 | 1678863 | 2021-09-02 | Iredell | North Carolina | 37097 | 23645 | 254 |
1675615 | 1675615 | 2021-09-01 | Iredell | North Carolina | 37097 | 23409 | 252 |
1672368 | 1672368 | 2021-08-31 | Iredell | North Carolina | 37097 | 23261 | 248 |
1669120 | 1669120 | 2021-08-30 | Iredell | North Carolina | 37097 | 23142 | 246 |
1665873 | 1665873 | 2021-08-29 | Iredell | North Carolina | 37097 | 22730 | 245 |
1662625 | 1662625 | 2021-08-28 | Iredell | North Carolina | 37097 | 22730 | 245 |
1659377 | 1659377 | 2021-08-27 | Iredell | North Carolina | 37097 | 22730 | 245 |
1656128 | 1656128 | 2021-08-26 | Iredell | North Carolina | 37097 | 22531 | 245 |
1652881 | 1652881 | 2021-08-25 | Iredell | North Carolina | 37097 | 22306 | 242 |
1649633 | 1649633 | 2021-08-24 | Iredell | North Carolina | 37097 | 22171 | 242 |
1646384 | 1646384 | 2021-08-23 | Iredell | North Carolina | 37097 | 22097 | 240 |
1643135 | 1643135 | 2021-08-22 | Iredell | North Carolina | 37097 | 21762 | 240 |
1639885 | 1639885 | 2021-08-21 | Iredell | North Carolina | 37097 | 21762 | 240 |
1636635 | 1636635 | 2021-08-20 | Iredell | North Carolina | 37097 | 21762 | 240 |
1633385 | 1633385 | 2021-08-19 | Iredell | North Carolina | 37097 | 21645 | 240 |
1630138 | 1630138 | 2021-08-18 | Iredell | North Carolina | 37097 | 21512 | 239 |
1626891 | 1626891 | 2021-08-17 | Iredell | North Carolina | 37097 | 21401 | 238 |
1623644 | 1623644 | 2021-08-16 | Iredell | North Carolina | 37097 | 21343 | 238 |
1620397 | 1620397 | 2021-08-15 | Iredell | North Carolina | 37097 | 21030 | 238 |
1617149 | 1617149 | 2021-08-14 | Iredell | North Carolina | 37097 | 21030 | 238 |
1613901 | 1613901 | 2021-08-13 | Iredell | North Carolina | 37097 | 21030 | 238 |
1610652 | 1610652 | 2021-08-12 | Iredell | North Carolina | 37097 | 20900 | 238 |
1607404 | 1607404 | 2021-08-11 | Iredell | North Carolina | 37097 | 20773 | 238 |
1604155 | 1604155 | 2021-08-10 | Iredell | North Carolina | 37097 | 20688 | 237 |
1600906 | 1600906 | 2021-08-09 | Iredell | North Carolina | 37097 | 20622 | 237 |
1597658 | 1597658 | 2021-08-08 | Iredell | North Carolina | 37097 | 20242 | 237 |
1594409 | 1594409 | 2021-08-07 | Iredell | North Carolina | 37097 | 20242 | 237 |
1591160 | 1591160 | 2021-08-06 | Iredell | North Carolina | 37097 | 20242 | 237 |
1587911 | 1587911 | 2021-08-05 | Iredell | North Carolina | 37097 | 20165 | 237 |
1584661 | 1584661 | 2021-08-04 | Iredell | North Carolina | 37097 | 20075 | 237 |
1581411 | 1581411 | 2021-08-03 | Iredell | North Carolina | 37097 | 20006 | 237 |
1578162 | 1578162 | 2021-08-02 | Iredell | North Carolina | 37097 | 19978 | 237 |
1574914 | 1574914 | 2021-08-01 | Iredell | North Carolina | 37097 | 19839 | 237 |
1571666 | 1571666 | 2021-07-31 | Iredell | North Carolina | 37097 | 19839 | 237 |
1568418 | 1568418 | 2021-07-30 | Iredell | North Carolina | 37097 | 19839 | 237 |
1565170 | 1565170 | 2021-07-29 | Iredell | North Carolina | 37097 | 19791 | 237 |
1561922 | 1561922 | 2021-07-28 | Iredell | North Carolina | 37097 | 19733 | 237 |
1558674 | 1558674 | 2021-07-27 | Iredell | North Carolina | 37097 | 19674 | 236 |
1555427 | 1555427 | 2021-07-26 | Iredell | North Carolina | 37097 | 19651 | 236 |
1552180 | 1552180 | 2021-07-25 | Iredell | North Carolina | 37097 | 19573 | 236 |
1548933 | 1548933 | 2021-07-24 | Iredell | North Carolina | 37097 | 19573 | 236 |
1545686 | 1545686 | 2021-07-23 | Iredell | North Carolina | 37097 | 19573 | 236 |
1542439 | 1542439 | 2021-07-22 | Iredell | North Carolina | 37097 | 19554 | 236 |
1539191 | 1539191 | 2021-07-21 | Iredell | North Carolina | 37097 | 19527 | 236 |
1535944 | 1535944 | 2021-07-20 | Iredell | North Carolina | 37097 | 19488 | 236 |
1532696 | 1532696 | 2021-07-19 | Iredell | North Carolina | 37097 | 19472 | 236 |
1529449 | 1529449 | 2021-07-18 | Iredell | North Carolina | 37097 | 19435 | 236 |
1526202 | 1526202 | 2021-07-17 | Iredell | North Carolina | 37097 | 19435 | 236 |
1522955 | 1522955 | 2021-07-16 | Iredell | North Carolina | 37097 | 19435 | 236 |
1519707 | 1519707 | 2021-07-15 | Iredell | North Carolina | 37097 | 19427 | 236 |
1516459 | 1516459 | 2021-07-14 | Iredell | North Carolina | 37097 | 19415 | 236 |
1513212 | 1513212 | 2021-07-13 | Iredell | North Carolina | 37097 | 19394 | 236 |
1509966 | 1509966 | 2021-07-12 | Iredell | North Carolina | 37097 | 19385 | 236 |
1506719 | 1506719 | 2021-07-11 | Iredell | North Carolina | 37097 | 19353 | 236 |
1503473 | 1503473 | 2021-07-10 | Iredell | North Carolina | 37097 | 19353 | 236 |
1500227 | 1500227 | 2021-07-09 | Iredell | North Carolina | 37097 | 19353 | 236 |
1496981 | 1496981 | 2021-07-08 | Iredell | North Carolina | 37097 | 19343 | 236 |
1493734 | 1493734 | 2021-07-07 | Iredell | North Carolina | 37097 | 19334 | 236 |
1490487 | 1490487 | 2021-07-06 | Iredell | North Carolina | 37097 | 19317 | 236 |
1487240 | 1487240 | 2021-07-05 | Iredell | North Carolina | 37097 | 19284 | 236 |
1483994 | 1483994 | 2021-07-04 | Iredell | North Carolina | 37097 | 19284 | 236 |
1480748 | 1480748 | 2021-07-03 | Iredell | North Carolina | 37097 | 19284 | 236 |
1477501 | 1477501 | 2021-07-02 | Iredell | North Carolina | 37097 | 19284 | 236 |
1474255 | 1474255 | 2021-07-01 | Iredell | North Carolina | 37097 | 19279 | 236 |
1471009 | 1471009 | 2021-06-30 | Iredell | North Carolina | 37097 | 19278 | 236 |
1467764 | 1467764 | 2021-06-29 | Iredell | North Carolina | 37097 | 19273 | 236 |
1464519 | 1464519 | 2021-06-28 | Iredell | North Carolina | 37097 | 19268 | 236 |
1461274 | 1461274 | 2021-06-27 | Iredell | North Carolina | 37097 | 19260 | 236 |
1458029 | 1458029 | 2021-06-26 | Iredell | North Carolina | 37097 | 19260 | 236 |
1454784 | 1454784 | 2021-06-25 | Iredell | North Carolina | 37097 | 19260 | 236 |
1451539 | 1451539 | 2021-06-24 | Iredell | North Carolina | 37097 | 19259 | 236 |
1448293 | 1448293 | 2021-06-23 | Iredell | North Carolina | 37097 | 19252 | 236 |
1445048 | 1445048 | 2021-06-22 | Iredell | North Carolina | 37097 | 19244 | 236 |
1441803 | 1441803 | 2021-06-21 | Iredell | North Carolina | 37097 | 19240 | 236 |
1438558 | 1438558 | 2021-06-20 | Iredell | North Carolina | 37097 | 19223 | 236 |
1435311 | 1435311 | 2021-06-19 | Iredell | North Carolina | 37097 | 19223 | 236 |
1432064 | 1432064 | 2021-06-18 | Iredell | North Carolina | 37097 | 19223 | 236 |
1428818 | 1428818 | 2021-06-17 | Iredell | North Carolina | 37097 | 19224 | 228 |
1425573 | 1425573 | 2021-06-16 | Iredell | North Carolina | 37097 | 19210 | 227 |
1422326 | 1422326 | 2021-06-15 | Iredell | North Carolina | 37097 | 19205 | 227 |
1419080 | 1419080 | 2021-06-14 | Iredell | North Carolina | 37097 | 19205 | 227 |
1415835 | 1415835 | 2021-06-13 | Iredell | North Carolina | 37097 | 19178 | 225 |
1412589 | 1412589 | 2021-06-12 | Iredell | North Carolina | 37097 | 19178 | 225 |
1409344 | 1409344 | 2021-06-11 | Iredell | North Carolina | 37097 | 19178 | 225 |
1406099 | 1406099 | 2021-06-10 | Iredell | North Carolina | 37097 | 19160 | 222 |
1402853 | 1402853 | 2021-06-09 | Iredell | North Carolina | 37097 | 19148 | 222 |
1399608 | 1399608 | 2021-06-08 | Iredell | North Carolina | 37097 | 19137 | 222 |
1396363 | 1396363 | 2021-06-07 | Iredell | North Carolina | 37097 | 19132 | 222 |
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);