ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37147 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 |
---|---|---|---|---|---|---|---|
1717871 | 1717871 | 2021-09-14 | Pitt | North Carolina | 37147 | 26461 | 129 |
1714623 | 1714623 | 2021-09-13 | Pitt | North Carolina | 37147 | 26376 | 129 |
1711377 | 1711377 | 2021-09-12 | Pitt | North Carolina | 37147 | 25706 | 122 |
1708130 | 1708130 | 2021-09-11 | Pitt | North Carolina | 37147 | 25706 | 122 |
1704883 | 1704883 | 2021-09-10 | Pitt | North Carolina | 37147 | 25706 | 122 |
1701633 | 1701633 | 2021-09-09 | Pitt | North Carolina | 37147 | 25671 | 122 |
1698384 | 1698384 | 2021-09-08 | Pitt | North Carolina | 37147 | 25493 | 122 |
1695136 | 1695136 | 2021-09-07 | Pitt | North Carolina | 37147 | 25401 | 122 |
1691888 | 1691888 | 2021-09-06 | Pitt | North Carolina | 37147 | 24854 | 119 |
1688638 | 1688638 | 2021-09-05 | Pitt | North Carolina | 37147 | 24854 | 119 |
1685388 | 1685388 | 2021-09-04 | Pitt | North Carolina | 37147 | 24854 | 119 |
1682137 | 1682137 | 2021-09-03 | Pitt | North Carolina | 37147 | 24854 | 119 |
1678888 | 1678888 | 2021-09-02 | Pitt | North Carolina | 37147 | 24716 | 119 |
1675640 | 1675640 | 2021-09-01 | Pitt | North Carolina | 37147 | 24527 | 114 |
1672393 | 1672393 | 2021-08-31 | Pitt | North Carolina | 37147 | 24419 | 114 |
1669145 | 1669145 | 2021-08-30 | Pitt | North Carolina | 37147 | 24302 | 114 |
1665898 | 1665898 | 2021-08-29 | Pitt | North Carolina | 37147 | 23970 | 109 |
1662650 | 1662650 | 2021-08-28 | Pitt | North Carolina | 37147 | 23970 | 109 |
1659402 | 1659402 | 2021-08-27 | Pitt | North Carolina | 37147 | 23970 | 109 |
1656153 | 1656153 | 2021-08-26 | Pitt | North Carolina | 37147 | 23758 | 109 |
1652906 | 1652906 | 2021-08-25 | Pitt | North Carolina | 37147 | 23635 | 109 |
1649658 | 1649658 | 2021-08-24 | Pitt | North Carolina | 37147 | 23542 | 109 |
1646409 | 1646409 | 2021-08-23 | Pitt | North Carolina | 37147 | 23482 | 108 |
1643160 | 1643160 | 2021-08-22 | Pitt | North Carolina | 37147 | 23198 | 107 |
1639910 | 1639910 | 2021-08-21 | Pitt | North Carolina | 37147 | 23198 | 107 |
1636660 | 1636660 | 2021-08-20 | Pitt | North Carolina | 37147 | 23198 | 107 |
1633410 | 1633410 | 2021-08-19 | Pitt | North Carolina | 37147 | 23102 | 107 |
1630163 | 1630163 | 2021-08-18 | Pitt | North Carolina | 37147 | 22978 | 105 |
1626916 | 1626916 | 2021-08-17 | Pitt | North Carolina | 37147 | 22877 | 104 |
1623669 | 1623669 | 2021-08-16 | Pitt | North Carolina | 37147 | 22800 | 103 |
1620422 | 1620422 | 2021-08-15 | Pitt | North Carolina | 37147 | 22511 | 100 |
1617174 | 1617174 | 2021-08-14 | Pitt | North Carolina | 37147 | 22511 | 100 |
1613926 | 1613926 | 2021-08-13 | Pitt | North Carolina | 37147 | 22511 | 100 |
1610677 | 1610677 | 2021-08-12 | Pitt | North Carolina | 37147 | 22366 | 95 |
1607429 | 1607429 | 2021-08-11 | Pitt | North Carolina | 37147 | 22232 | 95 |
1604180 | 1604180 | 2021-08-10 | Pitt | North Carolina | 37147 | 22136 | 95 |
1600931 | 1600931 | 2021-08-09 | Pitt | North Carolina | 37147 | 22066 | 95 |
1597683 | 1597683 | 2021-08-08 | Pitt | North Carolina | 37147 | 21744 | 96 |
1594434 | 1594434 | 2021-08-07 | Pitt | North Carolina | 37147 | 21744 | 96 |
1591185 | 1591185 | 2021-08-06 | Pitt | North Carolina | 37147 | 21744 | 96 |
1587936 | 1587936 | 2021-08-05 | Pitt | North Carolina | 37147 | 21646 | 96 |
1584686 | 1584686 | 2021-08-04 | Pitt | North Carolina | 37147 | 21579 | 96 |
1581436 | 1581436 | 2021-08-03 | Pitt | North Carolina | 37147 | 21500 | 96 |
1578187 | 1578187 | 2021-08-02 | Pitt | North Carolina | 37147 | 21457 | 96 |
1574939 | 1574939 | 2021-08-01 | Pitt | North Carolina | 37147 | 21303 | 96 |
1571691 | 1571691 | 2021-07-31 | Pitt | North Carolina | 37147 | 21303 | 96 |
1568443 | 1568443 | 2021-07-30 | Pitt | North Carolina | 37147 | 21303 | 96 |
1565195 | 1565195 | 2021-07-29 | Pitt | North Carolina | 37147 | 21241 | 96 |
1561947 | 1561947 | 2021-07-28 | Pitt | North Carolina | 37147 | 21149 | 96 |
1558699 | 1558699 | 2021-07-27 | Pitt | North Carolina | 37147 | 21082 | 96 |
1555452 | 1555452 | 2021-07-26 | Pitt | North Carolina | 37147 | 21050 | 96 |
1552205 | 1552205 | 2021-07-25 | Pitt | North Carolina | 37147 | 20936 | 96 |
1548958 | 1548958 | 2021-07-24 | Pitt | North Carolina | 37147 | 20936 | 96 |
1545711 | 1545711 | 2021-07-23 | Pitt | North Carolina | 37147 | 20936 | 96 |
1542464 | 1542464 | 2021-07-22 | Pitt | North Carolina | 37147 | 20902 | 96 |
1539216 | 1539216 | 2021-07-21 | Pitt | North Carolina | 37147 | 20850 | 96 |
1535969 | 1535969 | 2021-07-20 | Pitt | North Carolina | 37147 | 20822 | 96 |
1532721 | 1532721 | 2021-07-19 | Pitt | North Carolina | 37147 | 20799 | 96 |
1529474 | 1529474 | 2021-07-18 | Pitt | North Carolina | 37147 | 20736 | 96 |
1526227 | 1526227 | 2021-07-17 | Pitt | North Carolina | 37147 | 20736 | 96 |
1522980 | 1522980 | 2021-07-16 | Pitt | North Carolina | 37147 | 20736 | 96 |
1519732 | 1519732 | 2021-07-15 | Pitt | North Carolina | 37147 | 20713 | 96 |
1516484 | 1516484 | 2021-07-14 | Pitt | North Carolina | 37147 | 20687 | 96 |
1513237 | 1513237 | 2021-07-13 | Pitt | North Carolina | 37147 | 20662 | 96 |
1509991 | 1509991 | 2021-07-12 | Pitt | North Carolina | 37147 | 20655 | 96 |
1506744 | 1506744 | 2021-07-11 | Pitt | North Carolina | 37147 | 20613 | 96 |
1503498 | 1503498 | 2021-07-10 | Pitt | North Carolina | 37147 | 20613 | 96 |
1500252 | 1500252 | 2021-07-09 | Pitt | North Carolina | 37147 | 20613 | 96 |
1497006 | 1497006 | 2021-07-08 | Pitt | North Carolina | 37147 | 20595 | 96 |
1493759 | 1493759 | 2021-07-07 | Pitt | North Carolina | 37147 | 20560 | 96 |
1490512 | 1490512 | 2021-07-06 | Pitt | North Carolina | 37147 | 20552 | 96 |
1487265 | 1487265 | 2021-07-05 | Pitt | North Carolina | 37147 | 20514 | 96 |
1484019 | 1484019 | 2021-07-04 | Pitt | North Carolina | 37147 | 20514 | 96 |
1480773 | 1480773 | 2021-07-03 | Pitt | North Carolina | 37147 | 20514 | 96 |
1477526 | 1477526 | 2021-07-02 | Pitt | North Carolina | 37147 | 20514 | 96 |
1474280 | 1474280 | 2021-07-01 | Pitt | North Carolina | 37147 | 20504 | 96 |
1471034 | 1471034 | 2021-06-30 | Pitt | North Carolina | 37147 | 20499 | 96 |
1467789 | 1467789 | 2021-06-29 | Pitt | North Carolina | 37147 | 20491 | 96 |
1464544 | 1464544 | 2021-06-28 | Pitt | North Carolina | 37147 | 20490 | 96 |
1461299 | 1461299 | 2021-06-27 | Pitt | North Carolina | 37147 | 20475 | 96 |
1458054 | 1458054 | 2021-06-26 | Pitt | North Carolina | 37147 | 20475 | 96 |
1454809 | 1454809 | 2021-06-25 | Pitt | North Carolina | 37147 | 20475 | 96 |
1451564 | 1451564 | 2021-06-24 | Pitt | North Carolina | 37147 | 20472 | 96 |
1448318 | 1448318 | 2021-06-23 | Pitt | North Carolina | 37147 | 20462 | 96 |
1445073 | 1445073 | 2021-06-22 | Pitt | North Carolina | 37147 | 20455 | 96 |
1441828 | 1441828 | 2021-06-21 | Pitt | North Carolina | 37147 | 20449 | 96 |
1438583 | 1438583 | 2021-06-20 | Pitt | North Carolina | 37147 | 20436 | 96 |
1435336 | 1435336 | 2021-06-19 | Pitt | North Carolina | 37147 | 20436 | 96 |
1432089 | 1432089 | 2021-06-18 | Pitt | North Carolina | 37147 | 20436 | 96 |
1428843 | 1428843 | 2021-06-17 | Pitt | North Carolina | 37147 | 20429 | 96 |
1425598 | 1425598 | 2021-06-16 | Pitt | North Carolina | 37147 | 20422 | 96 |
1422351 | 1422351 | 2021-06-15 | Pitt | North Carolina | 37147 | 20412 | 96 |
1419105 | 1419105 | 2021-06-14 | Pitt | North Carolina | 37147 | 20414 | 96 |
1415860 | 1415860 | 2021-06-13 | Pitt | North Carolina | 37147 | 20376 | 96 |
1412614 | 1412614 | 2021-06-12 | Pitt | North Carolina | 37147 | 20376 | 96 |
1409369 | 1409369 | 2021-06-11 | Pitt | North Carolina | 37147 | 20376 | 96 |
1406124 | 1406124 | 2021-06-10 | Pitt | North Carolina | 37147 | 20366 | 96 |
1402878 | 1402878 | 2021-06-09 | Pitt | North Carolina | 37147 | 20355 | 96 |
1399633 | 1399633 | 2021-06-08 | Pitt | North Carolina | 37147 | 20347 | 96 |
1396388 | 1396388 | 2021-06-07 | Pitt | North Carolina | 37147 | 20325 | 96 |
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);