ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 37119 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 |
---|---|---|---|---|---|---|---|
1717857 | 1717857 | 2021-09-14 | Mecklenburg | North Carolina | 37119 | 143083 | 1093 |
1714609 | 1714609 | 2021-09-13 | Mecklenburg | North Carolina | 37119 | 142727 | 1093 |
1711363 | 1711363 | 2021-09-12 | Mecklenburg | North Carolina | 37119 | 140746 | 1083 |
1708116 | 1708116 | 2021-09-11 | Mecklenburg | North Carolina | 37119 | 140746 | 1083 |
1704869 | 1704869 | 2021-09-10 | Mecklenburg | North Carolina | 37119 | 140746 | 1083 |
1701619 | 1701619 | 2021-09-09 | Mecklenburg | North Carolina | 37119 | 140432 | 1074 |
1698370 | 1698370 | 2021-09-08 | Mecklenburg | North Carolina | 37119 | 139839 | 1067 |
1695122 | 1695122 | 2021-09-07 | Mecklenburg | North Carolina | 37119 | 139478 | 1067 |
1691874 | 1691874 | 2021-09-06 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1688624 | 1688624 | 2021-09-05 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1685374 | 1685374 | 2021-09-04 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1682123 | 1682123 | 2021-09-03 | Mecklenburg | North Carolina | 37119 | 137651 | 1061 |
1678874 | 1678874 | 2021-09-02 | Mecklenburg | North Carolina | 37119 | 137078 | 1056 |
1675626 | 1675626 | 2021-09-01 | Mecklenburg | North Carolina | 37119 | 136492 | 1050 |
1672379 | 1672379 | 2021-08-31 | Mecklenburg | North Carolina | 37119 | 135931 | 1050 |
1669131 | 1669131 | 2021-08-30 | Mecklenburg | North Carolina | 37119 | 135422 | 1044 |
1665884 | 1665884 | 2021-08-29 | Mecklenburg | North Carolina | 37119 | 133843 | 1034 |
1662636 | 1662636 | 2021-08-28 | Mecklenburg | North Carolina | 37119 | 133843 | 1034 |
1659388 | 1659388 | 2021-08-27 | Mecklenburg | North Carolina | 37119 | 133843 | 1034 |
1656139 | 1656139 | 2021-08-26 | Mecklenburg | North Carolina | 37119 | 133232 | 1030 |
1652892 | 1652892 | 2021-08-25 | Mecklenburg | North Carolina | 37119 | 132503 | 1025 |
1649644 | 1649644 | 2021-08-24 | Mecklenburg | North Carolina | 37119 | 131949 | 1019 |
1646395 | 1646395 | 2021-08-23 | Mecklenburg | North Carolina | 37119 | 131438 | 1014 |
1643146 | 1643146 | 2021-08-22 | Mecklenburg | North Carolina | 37119 | 129834 | 1012 |
1639896 | 1639896 | 2021-08-21 | Mecklenburg | North Carolina | 37119 | 129834 | 1012 |
1636646 | 1636646 | 2021-08-20 | Mecklenburg | North Carolina | 37119 | 129834 | 1012 |
1633396 | 1633396 | 2021-08-19 | Mecklenburg | North Carolina | 37119 | 129148 | 1006 |
1630149 | 1630149 | 2021-08-18 | Mecklenburg | North Carolina | 37119 | 128514 | 1005 |
1626902 | 1626902 | 2021-08-17 | Mecklenburg | North Carolina | 37119 | 128032 | 1005 |
1623655 | 1623655 | 2021-08-16 | Mecklenburg | North Carolina | 37119 | 127608 | 1005 |
1620408 | 1620408 | 2021-08-15 | Mecklenburg | North Carolina | 37119 | 126019 | 999 |
1617160 | 1617160 | 2021-08-14 | Mecklenburg | North Carolina | 37119 | 126019 | 999 |
1613912 | 1613912 | 2021-08-13 | Mecklenburg | North Carolina | 37119 | 126019 | 999 |
1610663 | 1610663 | 2021-08-12 | Mecklenburg | North Carolina | 37119 | 125408 | 996 |
1607415 | 1607415 | 2021-08-11 | Mecklenburg | North Carolina | 37119 | 124784 | 996 |
1604166 | 1604166 | 2021-08-10 | Mecklenburg | North Carolina | 37119 | 124176 | 995 |
1600917 | 1600917 | 2021-08-09 | Mecklenburg | North Carolina | 37119 | 123743 | 995 |
1597669 | 1597669 | 2021-08-08 | Mecklenburg | North Carolina | 37119 | 121988 | 994 |
1594420 | 1594420 | 2021-08-07 | Mecklenburg | North Carolina | 37119 | 121988 | 994 |
1591171 | 1591171 | 2021-08-06 | Mecklenburg | North Carolina | 37119 | 121988 | 994 |
1587922 | 1587922 | 2021-08-05 | Mecklenburg | North Carolina | 37119 | 121457 | 995 |
1584672 | 1584672 | 2021-08-04 | Mecklenburg | North Carolina | 37119 | 120955 | 995 |
1581422 | 1581422 | 2021-08-03 | Mecklenburg | North Carolina | 37119 | 120493 | 994 |
1578173 | 1578173 | 2021-08-02 | Mecklenburg | North Carolina | 37119 | 120200 | 993 |
1574925 | 1574925 | 2021-08-01 | Mecklenburg | North Carolina | 37119 | 119119 | 991 |
1571677 | 1571677 | 2021-07-31 | Mecklenburg | North Carolina | 37119 | 119119 | 991 |
1568429 | 1568429 | 2021-07-30 | Mecklenburg | North Carolina | 37119 | 119119 | 991 |
1565181 | 1565181 | 2021-07-29 | Mecklenburg | North Carolina | 37119 | 118725 | 990 |
1561933 | 1561933 | 2021-07-28 | Mecklenburg | North Carolina | 37119 | 118317 | 990 |
1558685 | 1558685 | 2021-07-27 | Mecklenburg | North Carolina | 37119 | 118004 | 988 |
1555438 | 1555438 | 2021-07-26 | Mecklenburg | North Carolina | 37119 | 117724 | 988 |
1552191 | 1552191 | 2021-07-25 | Mecklenburg | North Carolina | 37119 | 116949 | 988 |
1548944 | 1548944 | 2021-07-24 | Mecklenburg | North Carolina | 37119 | 116949 | 988 |
1545697 | 1545697 | 2021-07-23 | Mecklenburg | North Carolina | 37119 | 116949 | 988 |
1542450 | 1542450 | 2021-07-22 | Mecklenburg | North Carolina | 37119 | 116762 | 988 |
1539202 | 1539202 | 2021-07-21 | Mecklenburg | North Carolina | 37119 | 116505 | 986 |
1535955 | 1535955 | 2021-07-20 | Mecklenburg | North Carolina | 37119 | 116274 | 985 |
1532707 | 1532707 | 2021-07-19 | Mecklenburg | North Carolina | 37119 | 116154 | 985 |
1529460 | 1529460 | 2021-07-18 | Mecklenburg | North Carolina | 37119 | 115741 | 982 |
1526213 | 1526213 | 2021-07-17 | Mecklenburg | North Carolina | 37119 | 115741 | 982 |
1522966 | 1522966 | 2021-07-16 | Mecklenburg | North Carolina | 37119 | 115741 | 982 |
1519718 | 1519718 | 2021-07-15 | Mecklenburg | North Carolina | 37119 | 115621 | 982 |
1516470 | 1516470 | 2021-07-14 | Mecklenburg | North Carolina | 37119 | 115501 | 981 |
1513223 | 1513223 | 2021-07-13 | Mecklenburg | North Carolina | 37119 | 115389 | 981 |
1509977 | 1509977 | 2021-07-12 | Mecklenburg | North Carolina | 37119 | 115309 | 981 |
1506730 | 1506730 | 2021-07-11 | Mecklenburg | North Carolina | 37119 | 115088 | 980 |
1503484 | 1503484 | 2021-07-10 | Mecklenburg | North Carolina | 37119 | 115088 | 980 |
1500238 | 1500238 | 2021-07-09 | Mecklenburg | North Carolina | 37119 | 115088 | 980 |
1496992 | 1496992 | 2021-07-08 | Mecklenburg | North Carolina | 37119 | 115027 | 979 |
1493745 | 1493745 | 2021-07-07 | Mecklenburg | North Carolina | 37119 | 114974 | 978 |
1490498 | 1490498 | 2021-07-06 | Mecklenburg | North Carolina | 37119 | 114907 | 977 |
1487251 | 1487251 | 2021-07-05 | Mecklenburg | North Carolina | 37119 | 114737 | 975 |
1484005 | 1484005 | 2021-07-04 | Mecklenburg | North Carolina | 37119 | 114737 | 975 |
1480759 | 1480759 | 2021-07-03 | Mecklenburg | North Carolina | 37119 | 114737 | 975 |
1477512 | 1477512 | 2021-07-02 | Mecklenburg | North Carolina | 37119 | 114737 | 975 |
1474266 | 1474266 | 2021-07-01 | Mecklenburg | North Carolina | 37119 | 114680 | 975 |
1471020 | 1471020 | 2021-06-30 | Mecklenburg | North Carolina | 37119 | 114641 | 976 |
1467775 | 1467775 | 2021-06-29 | Mecklenburg | North Carolina | 37119 | 114599 | 976 |
1464530 | 1464530 | 2021-06-28 | Mecklenburg | North Carolina | 37119 | 114575 | 976 |
1461285 | 1461285 | 2021-06-27 | Mecklenburg | North Carolina | 37119 | 114441 | 976 |
1458040 | 1458040 | 2021-06-26 | Mecklenburg | North Carolina | 37119 | 114441 | 976 |
1454795 | 1454795 | 2021-06-25 | Mecklenburg | North Carolina | 37119 | 114441 | 976 |
1451550 | 1451550 | 2021-06-24 | Mecklenburg | North Carolina | 37119 | 114395 | 976 |
1448304 | 1448304 | 2021-06-23 | Mecklenburg | North Carolina | 37119 | 114364 | 975 |
1445059 | 1445059 | 2021-06-22 | Mecklenburg | North Carolina | 37119 | 114316 | 975 |
1441814 | 1441814 | 2021-06-21 | Mecklenburg | North Carolina | 37119 | 114280 | 974 |
1438569 | 1438569 | 2021-06-20 | Mecklenburg | North Carolina | 37119 | 114173 | 973 |
1435322 | 1435322 | 2021-06-19 | Mecklenburg | North Carolina | 37119 | 114173 | 973 |
1432075 | 1432075 | 2021-06-18 | Mecklenburg | North Carolina | 37119 | 114173 | 973 |
1428829 | 1428829 | 2021-06-17 | Mecklenburg | North Carolina | 37119 | 114150 | 972 |
1425584 | 1425584 | 2021-06-16 | Mecklenburg | North Carolina | 37119 | 114103 | 972 |
1422337 | 1422337 | 2021-06-15 | Mecklenburg | North Carolina | 37119 | 114068 | 973 |
1419091 | 1419091 | 2021-06-14 | Mecklenburg | North Carolina | 37119 | 114027 | 973 |
1415846 | 1415846 | 2021-06-13 | Mecklenburg | North Carolina | 37119 | 113911 | 972 |
1412600 | 1412600 | 2021-06-12 | Mecklenburg | North Carolina | 37119 | 113911 | 972 |
1409355 | 1409355 | 2021-06-11 | Mecklenburg | North Carolina | 37119 | 113911 | 972 |
1406110 | 1406110 | 2021-06-10 | Mecklenburg | North Carolina | 37119 | 113863 | 971 |
1402864 | 1402864 | 2021-06-09 | Mecklenburg | North Carolina | 37119 | 113815 | 971 |
1399619 | 1399619 | 2021-06-08 | Mecklenburg | North Carolina | 37119 | 113775 | 971 |
1396374 | 1396374 | 2021-06-07 | Mecklenburg | North Carolina | 37119 | 113758 | 971 |
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);