ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where deaths = 217 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 |
---|---|---|---|---|---|---|---|
2013593 | 2013593 | 2021-12-14 | Rockingham | North Carolina | 37157 | 13576 | 217 |
2010342 | 2010342 | 2021-12-13 | Rockingham | North Carolina | 37157 | 13542 | 217 |
2007091 | 2007091 | 2021-12-12 | Rockingham | North Carolina | 37157 | 13412 | 217 |
2003840 | 2003840 | 2021-12-11 | Rockingham | North Carolina | 37157 | 13412 | 217 |
2000589 | 2000589 | 2021-12-10 | Rockingham | North Carolina | 37157 | 13412 | 217 |
1997339 | 1997339 | 2021-12-09 | Rockingham | North Carolina | 37157 | 13357 | 217 |
1994088 | 1994088 | 2021-12-08 | Rockingham | North Carolina | 37157 | 13324 | 217 |
1990837 | 1990837 | 2021-12-07 | Rockingham | North Carolina | 37157 | 13295 | 217 |
1987586 | 1987586 | 2021-12-06 | Rockingham | North Carolina | 37157 | 13258 | 217 |
1984336 | 1984336 | 2021-12-05 | Rockingham | North Carolina | 37157 | 13146 | 217 |
1981086 | 1981086 | 2021-12-04 | Rockingham | North Carolina | 37157 | 13146 | 217 |
1977836 | 1977836 | 2021-12-03 | Rockingham | North Carolina | 37157 | 13146 | 217 |
1974586 | 1974586 | 2021-12-02 | Rockingham | North Carolina | 37157 | 13104 | 217 |
1971337 | 1971337 | 2021-12-01 | Rockingham | North Carolina | 37157 | 13072 | 217 |
1968087 | 1968087 | 2021-11-30 | Rockingham | North Carolina | 37157 | 13042 | 217 |
1964836 | 1964836 | 2021-11-29 | Rockingham | North Carolina | 37157 | 12951 | 217 |
1961584 | 1961584 | 2021-11-28 | Rockingham | North Carolina | 37157 | 12784 | 217 |
1958333 | 1958333 | 2021-11-27 | Rockingham | North Carolina | 37157 | 12784 | 217 |
1955082 | 1955082 | 2021-11-26 | Rockingham | North Carolina | 37157 | 12784 | 217 |
1951831 | 1951831 | 2021-11-25 | Rockingham | North Carolina | 37157 | 12784 | 217 |
1948580 | 1948580 | 2021-11-24 | Rockingham | North Carolina | 37157 | 12784 | 217 |
1925762 | 1925762 | 2021-11-17 | Caldwell | North Carolina | 37027 | 13782 | 217 |
1922513 | 1922513 | 2021-11-16 | Caldwell | North Carolina | 37027 | 13764 | 217 |
1919263 | 1919263 | 2021-11-15 | Caldwell | North Carolina | 37027 | 13739 | 217 |
1916013 | 1916013 | 2021-11-14 | Caldwell | North Carolina | 37027 | 13711 | 217 |
1912763 | 1912763 | 2021-11-13 | Caldwell | North Carolina | 37027 | 13711 | 217 |
1909513 | 1909513 | 2021-11-12 | Caldwell | North Carolina | 37027 | 13711 | 217 |
1906264 | 1906264 | 2021-11-11 | Caldwell | North Carolina | 37027 | 13672 | 217 |
1903015 | 1903015 | 2021-11-10 | Caldwell | North Carolina | 37027 | 13672 | 217 |
1792550 | 1792550 | 2021-10-07 | Columbus | North Carolina | 37047 | 9803 | 217 |
1786115 | 1786115 | 2021-10-05 | Surry | North Carolina | 37171 | 11703 | 217 |
1782866 | 1782866 | 2021-10-04 | Surry | North Carolina | 37171 | 11671 | 217 |
1779617 | 1779617 | 2021-10-03 | Surry | North Carolina | 37171 | 11558 | 217 |
1776367 | 1776367 | 2021-10-02 | Surry | North Carolina | 37171 | 11558 | 217 |
1773117 | 1773117 | 2021-10-01 | Surry | North Carolina | 37171 | 11558 | 217 |
1747104 | 1747104 | 2021-09-23 | Nash | North Carolina | 37127 | 14322 | 217 |
1740585 | 1740585 | 2021-09-21 | Harnett | North Carolina | 37085 | 16768 | 217 |
1474287 | 1474287 | 2021-07-01 | Rutherford | North Carolina | 37161 | 7448 | 217 |
1471041 | 1471041 | 2021-06-30 | Rutherford | North Carolina | 37161 | 7444 | 217 |
1373644 | 1373644 | 2021-05-31 | Iredell | North Carolina | 37097 | 19053 | 217 |
1370399 | 1370399 | 2021-05-30 | Iredell | North Carolina | 37097 | 19053 | 217 |
1367153 | 1367153 | 2021-05-29 | Iredell | North Carolina | 37097 | 19053 | 217 |
1363907 | 1363907 | 2021-05-28 | Iredell | North Carolina | 37097 | 19053 | 217 |
1360661 | 1360661 | 2021-05-27 | Iredell | North Carolina | 37097 | 19036 | 217 |
1357415 | 1357415 | 2021-05-26 | Iredell | North Carolina | 37097 | 19020 | 217 |
1354169 | 1354169 | 2021-05-25 | Iredell | North Carolina | 37097 | 19005 | 217 |
1347677 | 1347677 | 2021-05-23 | Iredell | North Carolina | 37097 | 18951 | 217 |
1344429 | 1344429 | 2021-05-22 | Iredell | North Carolina | 37097 | 18951 | 217 |
1341181 | 1341181 | 2021-05-21 | Iredell | North Carolina | 37097 | 18951 | 217 |
1337933 | 1337933 | 2021-05-20 | Iredell | North Carolina | 37097 | 18933 | 217 |
1334686 | 1334686 | 2021-05-19 | Iredell | North Carolina | 37097 | 18907 | 217 |
1331439 | 1331439 | 2021-05-18 | Iredell | North Carolina | 37097 | 18891 | 217 |
1328192 | 1328192 | 2021-05-17 | Iredell | North Carolina | 37097 | 18875 | 217 |
1308754 | 1308754 | 2021-05-11 | Union | North Carolina | 37179 | 24347 | 217 |
1305508 | 1305508 | 2021-05-10 | Union | North Carolina | 37179 | 24333 | 217 |
1302262 | 1302262 | 2021-05-09 | Union | North Carolina | 37179 | 24233 | 217 |
1299014 | 1299014 | 2021-05-08 | Union | North Carolina | 37179 | 24233 | 217 |
1295768 | 1295768 | 2021-05-07 | Union | North Carolina | 37179 | 24233 | 217 |
1292483 | 1292483 | 2021-05-06 | Johnston | North Carolina | 37101 | 21328 | 217 |
1292522 | 1292522 | 2021-05-06 | Union | North Carolina | 37179 | 24172 | 217 |
1289237 | 1289237 | 2021-05-05 | Johnston | North Carolina | 37101 | 21252 | 217 |
1289276 | 1289276 | 2021-05-05 | Union | North Carolina | 37179 | 24148 | 217 |
1211331 | 1211331 | 2021-04-11 | Randolph | North Carolina | 37151 | 14438 | 217 |
1208082 | 1208082 | 2021-04-10 | Randolph | North Carolina | 37151 | 14438 | 217 |
1204834 | 1204834 | 2021-04-09 | Randolph | North Carolina | 37151 | 14438 | 217 |
1201586 | 1201586 | 2021-04-08 | Randolph | North Carolina | 37151 | 14401 | 217 |
1198337 | 1198337 | 2021-04-07 | Randolph | North Carolina | 37151 | 14370 | 217 |
1195088 | 1195088 | 2021-04-06 | Randolph | North Carolina | 37151 | 14348 | 217 |
1191840 | 1191840 | 2021-04-05 | Randolph | North Carolina | 37151 | 14336 | 217 |
1113911 | 1113911 | 2021-03-12 | Robeson | North Carolina | 37155 | 15450 | 217 |
1091132 | 1091132 | 2021-03-05 | Cleveland | North Carolina | 37045 | 10389 | 217 |
1087887 | 1087887 | 2021-03-04 | Cleveland | North Carolina | 37045 | 10358 | 217 |
1084642 | 1084642 | 2021-03-03 | Cleveland | North Carolina | 37045 | 10337 | 217 |
1081396 | 1081396 | 2021-03-02 | Cleveland | North Carolina | 37045 | 10304 | 217 |
1078150 | 1078150 | 2021-03-01 | Cleveland | North Carolina | 37045 | 10292 | 217 |
1058656 | 1058656 | 2021-02-23 | Alamance | North Carolina | 37001 | 15459 | 217 |
1055410 | 1055410 | 2021-02-22 | Alamance | North Carolina | 37001 | 15426 | 217 |
1052164 | 1052164 | 2021-02-21 | Alamance | North Carolina | 37001 | 15376 | 217 |
1048917 | 1048917 | 2021-02-20 | Alamance | North Carolina | 37001 | 15331 | 217 |
1045670 | 1045670 | 2021-02-19 | Alamance | North Carolina | 37001 | 15279 | 217 |
945137 | 945137 | 2021-01-19 | Rowan | North Carolina | 37159 | 11745 | 217 |
941891 | 941891 | 2021-01-18 | Rowan | North Carolina | 37159 | 11619 | 217 |
938646 | 938646 | 2021-01-17 | Rowan | North Carolina | 37159 | 11619 | 217 |
935401 | 935401 | 2021-01-16 | Rowan | North Carolina | 37159 | 11487 | 217 |
847736 | 847736 | 2020-12-20 | Gaston | North Carolina | 37071 | 13597 | 217 |
844491 | 844491 | 2020-12-19 | Gaston | North Carolina | 37071 | 13400 | 217 |
394313 | 394313 | 2020-08-02 | Mecklenburg | North Carolina | 37119 | 20864 | 217 |
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);