ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

87 rows where deaths = 311 and state = "North Carolina" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

fips 14

state 1

  • North Carolina · 87 ✖
Link rowid date ▲ county state fips cases deaths
2332215 2332215 2022-03-22 Burke North Carolina 37023 24982 311
2328962 2328962 2022-03-21 Burke North Carolina 37023 24982 311
2270447 2270447 2022-03-03 Harnett North Carolina 37085 32013 311
2267215 2267215 2022-03-02 Moore North Carolina 37125 23938 311
2263963 2263963 2022-03-01 Moore North Carolina 37125 23920 311
2260712 2260712 2022-02-28 Moore North Carolina 37125 23913 311
1922528 1922528 2021-11-16 Davidson North Carolina 37057 26308 311
1919278 1919278 2021-11-15 Davidson North Carolina 37057 26288 311
1916028 1916028 2021-11-14 Davidson North Carolina 37057 26181 311
1912778 1912778 2021-11-13 Davidson North Carolina 37057 26181 311
1909528 1909528 2021-11-12 Davidson North Carolina 37057 26181 311
1896530 1896530 2021-11-08 Davidson North Carolina 37057 26060 311
1893280 1893280 2021-11-07 Davidson North Carolina 37057 25965 311
1890030 1890030 2021-11-06 Davidson North Carolina 37057 25965 311
1886780 1886780 2021-11-05 Davidson North Carolina 37057 25965 311
1883531 1883531 2021-11-04 Davidson North Carolina 37057 25937 311
1857586 1857586 2021-10-27 Randolph North Carolina 37151 21786 311
1808822 1808822 2021-10-12 Iredell North Carolina 37097 28098 311
1805571 1805571 2021-10-11 Iredell North Carolina 37097 28070 311
1802363 1802363 2021-10-10 Union North Carolina 37179 35163 311
1799114 1799114 2021-10-09 Union North Carolina 37179 35163 311
1795865 1795865 2021-10-08 Union North Carolina 37179 35163 311
1792577 1792577 2021-10-07 Johnston North Carolina 37101 31352 311
1665902 1665902 2021-08-29 Robeson North Carolina 37155 21037 311
1662654 1662654 2021-08-28 Robeson North Carolina 37155 21037 311
1659406 1659406 2021-08-27 Robeson North Carolina 37155 21037 311
1604124 1604124 2021-08-10 Catawba North Carolina 37035 21021 311
1600875 1600875 2021-08-09 Catawba North Carolina 37035 20954 311
1597627 1597627 2021-08-08 Catawba North Carolina 37035 20680 311
1594378 1594378 2021-08-07 Catawba North Carolina 37035 20680 311
1591129 1591129 2021-08-06 Catawba North Carolina 37035 20680 311
1587880 1587880 2021-08-05 Catawba North Carolina 37035 20612 311
1584630 1584630 2021-08-04 Catawba North Carolina 37035 20573 311
1581380 1581380 2021-08-03 Catawba North Carolina 37035 20529 311
1578131 1578131 2021-08-02 Catawba North Carolina 37035 20486 311
1574883 1574883 2021-08-01 Catawba North Carolina 37035 20323 311
1571635 1571635 2021-07-31 Catawba North Carolina 37035 20323 311
1568387 1568387 2021-07-30 Catawba North Carolina 37035 20323 311
1565139 1565139 2021-07-29 Catawba North Carolina 37035 20300 311
1561891 1561891 2021-07-28 Catawba North Carolina 37035 20262 311
1558643 1558643 2021-07-27 Catawba North Carolina 37035 20213 311
1555396 1555396 2021-07-26 Catawba North Carolina 37035 20169 311
1552149 1552149 2021-07-25 Catawba North Carolina 37035 20094 311
1548902 1548902 2021-07-24 Catawba North Carolina 37035 20094 311
1545655 1545655 2021-07-23 Catawba North Carolina 37035 20094 311
1542408 1542408 2021-07-22 Catawba North Carolina 37035 20058 311
1539160 1539160 2021-07-21 Catawba North Carolina 37035 20032 311
1535913 1535913 2021-07-20 Catawba North Carolina 37035 20013 311
1532665 1532665 2021-07-19 Catawba North Carolina 37035 19991 311
1529418 1529418 2021-07-18 Catawba North Carolina 37035 19955 311
1526171 1526171 2021-07-17 Catawba North Carolina 37035 19955 311
1522924 1522924 2021-07-16 Catawba North Carolina 37035 19955 311
1519676 1519676 2021-07-15 Catawba North Carolina 37035 19950 311
1516428 1516428 2021-07-14 Catawba North Carolina 37035 19931 311
1513181 1513181 2021-07-13 Catawba North Carolina 37035 19904 311
1509935 1509935 2021-07-12 Catawba North Carolina 37035 19897 311
1506688 1506688 2021-07-11 Catawba North Carolina 37035 19872 311
1503442 1503442 2021-07-10 Catawba North Carolina 37035 19872 311
1500196 1500196 2021-07-09 Catawba North Carolina 37035 19872 311
1496950 1496950 2021-07-08 Catawba North Carolina 37035 19863 311
1493703 1493703 2021-07-07 Catawba North Carolina 37035 19860 311
1490456 1490456 2021-07-06 Catawba North Carolina 37035 19849 311
1487209 1487209 2021-07-05 Catawba North Carolina 37035 19823 311
1487271 1487271 2021-07-05 Rowan North Carolina 37159 17258 311
1483963 1483963 2021-07-04 Catawba North Carolina 37035 19823 311
1484025 1484025 2021-07-04 Rowan North Carolina 37159 17258 311
1480717 1480717 2021-07-03 Catawba North Carolina 37035 19823 311
1480779 1480779 2021-07-03 Rowan North Carolina 37159 17258 311
1477470 1477470 2021-07-02 Catawba North Carolina 37035 19823 311
1477532 1477532 2021-07-02 Rowan North Carolina 37159 17258 311
1474224 1474224 2021-07-01 Catawba North Carolina 37035 19814 311
1474286 1474286 2021-07-01 Rowan North Carolina 37159 17248 311
1471040 1471040 2021-06-30 Rowan North Carolina 37159 17241 311
1438589 1438589 2021-06-20 Rowan North Carolina 37159 17174 311
1435342 1435342 2021-06-19 Rowan North Carolina 37159 17174 311
1432095 1432095 2021-06-18 Rowan North Carolina 37159 17174 311
1428849 1428849 2021-06-17 Rowan North Carolina 37159 17172 311
1425604 1425604 2021-06-16 Rowan North Carolina 37159 17167 311
1422357 1422357 2021-06-15 Rowan North Carolina 37159 17155 311
1419111 1419111 2021-06-14 Rowan North Carolina 37159 17150 311
1415866 1415866 2021-06-13 Rowan North Carolina 37159 17127 311
1412620 1412620 2021-06-12 Rowan North Carolina 37159 17127 311
1409375 1409375 2021-06-11 Rowan North Carolina 37159 17127 311
1380112 1380112 2021-06-02 Cumberland North Carolina 37051 29695 311
1172291 1172291 2021-03-30 Buncombe North Carolina 37021 16409 311
1169044 1169044 2021-03-29 Buncombe North Carolina 37021 16378 311
880191 880191 2020-12-30 Guilford North Carolina 37081 24206 311

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);