ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 37097 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 |
---|---|---|---|---|---|---|---|
1487240 | 1487240 | 2021-07-05 | Iredell | North Carolina | 37097 | 19284 | 236 |
1483994 | 1483994 | 2021-07-04 | Iredell | North Carolina | 37097 | 19284 | 236 |
1480748 | 1480748 | 2021-07-03 | Iredell | North Carolina | 37097 | 19284 | 236 |
1477501 | 1477501 | 2021-07-02 | Iredell | North Carolina | 37097 | 19284 | 236 |
1474255 | 1474255 | 2021-07-01 | Iredell | North Carolina | 37097 | 19279 | 236 |
1471009 | 1471009 | 2021-06-30 | Iredell | North Carolina | 37097 | 19278 | 236 |
1467764 | 1467764 | 2021-06-29 | Iredell | North Carolina | 37097 | 19273 | 236 |
1464519 | 1464519 | 2021-06-28 | Iredell | North Carolina | 37097 | 19268 | 236 |
1461274 | 1461274 | 2021-06-27 | Iredell | North Carolina | 37097 | 19260 | 236 |
1458029 | 1458029 | 2021-06-26 | Iredell | North Carolina | 37097 | 19260 | 236 |
1454784 | 1454784 | 2021-06-25 | Iredell | North Carolina | 37097 | 19260 | 236 |
1451539 | 1451539 | 2021-06-24 | Iredell | North Carolina | 37097 | 19259 | 236 |
1448293 | 1448293 | 2021-06-23 | Iredell | North Carolina | 37097 | 19252 | 236 |
1445048 | 1445048 | 2021-06-22 | Iredell | North Carolina | 37097 | 19244 | 236 |
1441803 | 1441803 | 2021-06-21 | Iredell | North Carolina | 37097 | 19240 | 236 |
1438558 | 1438558 | 2021-06-20 | Iredell | North Carolina | 37097 | 19223 | 236 |
1435311 | 1435311 | 2021-06-19 | Iredell | North Carolina | 37097 | 19223 | 236 |
1432064 | 1432064 | 2021-06-18 | Iredell | North Carolina | 37097 | 19223 | 236 |
1428818 | 1428818 | 2021-06-17 | Iredell | North Carolina | 37097 | 19224 | 228 |
1425573 | 1425573 | 2021-06-16 | Iredell | North Carolina | 37097 | 19210 | 227 |
1422326 | 1422326 | 2021-06-15 | Iredell | North Carolina | 37097 | 19205 | 227 |
1419080 | 1419080 | 2021-06-14 | Iredell | North Carolina | 37097 | 19205 | 227 |
1415835 | 1415835 | 2021-06-13 | Iredell | North Carolina | 37097 | 19178 | 225 |
1412589 | 1412589 | 2021-06-12 | Iredell | North Carolina | 37097 | 19178 | 225 |
1409344 | 1409344 | 2021-06-11 | Iredell | North Carolina | 37097 | 19178 | 225 |
1406099 | 1406099 | 2021-06-10 | Iredell | North Carolina | 37097 | 19160 | 222 |
1402853 | 1402853 | 2021-06-09 | Iredell | North Carolina | 37097 | 19148 | 222 |
1399608 | 1399608 | 2021-06-08 | Iredell | North Carolina | 37097 | 19137 | 222 |
1396363 | 1396363 | 2021-06-07 | Iredell | North Carolina | 37097 | 19132 | 222 |
1393116 | 1393116 | 2021-06-06 | Iredell | North Carolina | 37097 | 19107 | 219 |
1389871 | 1389871 | 2021-06-05 | Iredell | North Carolina | 37097 | 19107 | 219 |
1386626 | 1386626 | 2021-06-04 | Iredell | North Carolina | 37097 | 19107 | 219 |
1383381 | 1383381 | 2021-06-03 | Iredell | North Carolina | 37097 | 19103 | 219 |
1380135 | 1380135 | 2021-06-02 | Iredell | North Carolina | 37097 | 19095 | 219 |
1376890 | 1376890 | 2021-06-01 | Iredell | North Carolina | 37097 | 19091 | 219 |
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 |
1350923 | 1350923 | 2021-05-24 | Iredell | North Carolina | 37097 | 18996 | 216 |
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 |
1324946 | 1324946 | 2021-05-16 | Iredell | North Carolina | 37097 | 18820 | 208 |
1321700 | 1321700 | 2021-05-15 | Iredell | North Carolina | 37097 | 18820 | 208 |
1318454 | 1318454 | 2021-05-14 | Iredell | North Carolina | 37097 | 18820 | 208 |
1315206 | 1315206 | 2021-05-13 | Iredell | North Carolina | 37097 | 18803 | 208 |
1311960 | 1311960 | 2021-05-12 | Iredell | North Carolina | 37097 | 18765 | 208 |
1308713 | 1308713 | 2021-05-11 | Iredell | North Carolina | 37097 | 18728 | 208 |
1305467 | 1305467 | 2021-05-10 | Iredell | North Carolina | 37097 | 18713 | 208 |
1302221 | 1302221 | 2021-05-09 | Iredell | North Carolina | 37097 | 18612 | 208 |
1298973 | 1298973 | 2021-05-08 | Iredell | North Carolina | 37097 | 18612 | 208 |
1295727 | 1295727 | 2021-05-07 | Iredell | North Carolina | 37097 | 18612 | 208 |
1292481 | 1292481 | 2021-05-06 | Iredell | North Carolina | 37097 | 18589 | 208 |
1289235 | 1289235 | 2021-05-05 | Iredell | North Carolina | 37097 | 18551 | 208 |
1285989 | 1285989 | 2021-05-04 | Iredell | North Carolina | 37097 | 18515 | 208 |
1282743 | 1282743 | 2021-05-03 | Iredell | North Carolina | 37097 | 18489 | 207 |
1279496 | 1279496 | 2021-05-02 | Iredell | North Carolina | 37097 | 18407 | 206 |
1276249 | 1276249 | 2021-05-01 | Iredell | North Carolina | 37097 | 18407 | 206 |
1273002 | 1273002 | 2021-04-30 | Iredell | North Carolina | 37097 | 18407 | 206 |
1269755 | 1269755 | 2021-04-29 | Iredell | North Carolina | 37097 | 18378 | 206 |
1266508 | 1266508 | 2021-04-28 | Iredell | North Carolina | 37097 | 18347 | 206 |
1263261 | 1263261 | 2021-04-27 | Iredell | North Carolina | 37097 | 18305 | 206 |
1260014 | 1260014 | 2021-04-26 | Iredell | North Carolina | 37097 | 18282 | 206 |
1256767 | 1256767 | 2021-04-25 | Iredell | North Carolina | 37097 | 18185 | 206 |
1253520 | 1253520 | 2021-04-24 | Iredell | North Carolina | 37097 | 18185 | 206 |
1250273 | 1250273 | 2021-04-23 | Iredell | North Carolina | 37097 | 18185 | 206 |
1247026 | 1247026 | 2021-04-22 | Iredell | North Carolina | 37097 | 18141 | 206 |
1243779 | 1243779 | 2021-04-21 | Iredell | North Carolina | 37097 | 18096 | 206 |
1240532 | 1240532 | 2021-04-20 | Iredell | North Carolina | 37097 | 18056 | 205 |
1237285 | 1237285 | 2021-04-19 | Iredell | North Carolina | 37097 | 18036 | 205 |
1234038 | 1234038 | 2021-04-18 | Iredell | North Carolina | 37097 | 17938 | 205 |
1230790 | 1230790 | 2021-04-17 | Iredell | North Carolina | 37097 | 17938 | 205 |
1227542 | 1227542 | 2021-04-16 | Iredell | North Carolina | 37097 | 17938 | 205 |
1224294 | 1224294 | 2021-04-15 | Iredell | North Carolina | 37097 | 17889 | 205 |
1221047 | 1221047 | 2021-04-14 | Iredell | North Carolina | 37097 | 17840 | 205 |
1217799 | 1217799 | 2021-04-13 | Iredell | North Carolina | 37097 | 17792 | 205 |
1214551 | 1214551 | 2021-04-12 | Iredell | North Carolina | 37097 | 17767 | 205 |
1211304 | 1211304 | 2021-04-11 | Iredell | North Carolina | 37097 | 17687 | 204 |
1208055 | 1208055 | 2021-04-10 | Iredell | North Carolina | 37097 | 17687 | 204 |
1204807 | 1204807 | 2021-04-09 | Iredell | North Carolina | 37097 | 17687 | 204 |
1201559 | 1201559 | 2021-04-08 | Iredell | North Carolina | 37097 | 17644 | 203 |
1198310 | 1198310 | 2021-04-07 | Iredell | North Carolina | 37097 | 17609 | 203 |
1195061 | 1195061 | 2021-04-06 | Iredell | North Carolina | 37097 | 17596 | 203 |
1191813 | 1191813 | 2021-04-05 | Iredell | North Carolina | 37097 | 17588 | 203 |
1188564 | 1188564 | 2021-04-04 | Iredell | North Carolina | 37097 | 17489 | 203 |
1185317 | 1185317 | 2021-04-03 | Iredell | North Carolina | 37097 | 17489 | 203 |
1182070 | 1182070 | 2021-04-02 | Iredell | North Carolina | 37097 | 17489 | 203 |
1178823 | 1178823 | 2021-04-01 | Iredell | North Carolina | 37097 | 17489 | 203 |
1175576 | 1175576 | 2021-03-31 | Iredell | North Carolina | 37097 | 17451 | 203 |
1172329 | 1172329 | 2021-03-30 | Iredell | North Carolina | 37097 | 17415 | 203 |
1169082 | 1169082 | 2021-03-29 | Iredell | North Carolina | 37097 | 17379 | 203 |
1165834 | 1165834 | 2021-03-28 | Iredell | North Carolina | 37097 | 17284 | 203 |
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);