ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pitt" 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 |
---|---|---|---|---|---|---|---|
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 |
1393141 | 1393141 | 2021-06-06 | Pitt | North Carolina | 37147 | 20284 | 96 |
1389896 | 1389896 | 2021-06-05 | Pitt | North Carolina | 37147 | 20284 | 96 |
1386651 | 1386651 | 2021-06-04 | Pitt | North Carolina | 37147 | 20284 | 96 |
1383406 | 1383406 | 2021-06-03 | Pitt | North Carolina | 37147 | 20261 | 96 |
1380160 | 1380160 | 2021-06-02 | Pitt | North Carolina | 37147 | 20243 | 96 |
1376915 | 1376915 | 2021-06-01 | Pitt | North Carolina | 37147 | 20241 | 96 |
1373669 | 1373669 | 2021-05-31 | Pitt | North Carolina | 37147 | 20164 | 96 |
1370424 | 1370424 | 2021-05-30 | Pitt | North Carolina | 37147 | 20164 | 96 |
1367178 | 1367178 | 2021-05-29 | Pitt | North Carolina | 37147 | 20164 | 96 |
1363932 | 1363932 | 2021-05-28 | Pitt | North Carolina | 37147 | 20164 | 96 |
1360686 | 1360686 | 2021-05-27 | Pitt | North Carolina | 37147 | 20113 | 96 |
1357440 | 1357440 | 2021-05-26 | Pitt | North Carolina | 37147 | 20088 | 93 |
1354194 | 1354194 | 2021-05-25 | Pitt | North Carolina | 37147 | 20072 | 93 |
1350948 | 1350948 | 2021-05-24 | Pitt | North Carolina | 37147 | 20065 | 93 |
1347702 | 1347702 | 2021-05-23 | Pitt | North Carolina | 37147 | 19999 | 93 |
1344454 | 1344454 | 2021-05-22 | Pitt | North Carolina | 37147 | 19999 | 93 |
1341206 | 1341206 | 2021-05-21 | Pitt | North Carolina | 37147 | 19999 | 93 |
1337958 | 1337958 | 2021-05-20 | Pitt | North Carolina | 37147 | 19951 | 93 |
1334711 | 1334711 | 2021-05-19 | Pitt | North Carolina | 37147 | 19924 | 90 |
1331464 | 1331464 | 2021-05-18 | Pitt | North Carolina | 37147 | 19897 | 90 |
1328217 | 1328217 | 2021-05-17 | Pitt | North Carolina | 37147 | 19888 | 90 |
1324971 | 1324971 | 2021-05-16 | Pitt | North Carolina | 37147 | 19824 | 90 |
1321725 | 1321725 | 2021-05-15 | Pitt | North Carolina | 37147 | 19824 | 90 |
1318479 | 1318479 | 2021-05-14 | Pitt | North Carolina | 37147 | 19824 | 90 |
1315231 | 1315231 | 2021-05-13 | Pitt | North Carolina | 37147 | 19790 | 90 |
1311985 | 1311985 | 2021-05-12 | Pitt | North Carolina | 37147 | 19742 | 90 |
1308738 | 1308738 | 2021-05-11 | Pitt | North Carolina | 37147 | 19678 | 87 |
1305492 | 1305492 | 2021-05-10 | Pitt | North Carolina | 37147 | 19653 | 87 |
1302246 | 1302246 | 2021-05-09 | Pitt | North Carolina | 37147 | 19542 | 86 |
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);