ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Guilford" 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 |
---|---|---|---|---|---|---|---|
1419072 | 1419072 | 2021-06-14 | Guilford | North Carolina | 37081 | 48468 | 720 |
1415827 | 1415827 | 2021-06-13 | Guilford | North Carolina | 37081 | 48433 | 719 |
1412581 | 1412581 | 2021-06-12 | Guilford | North Carolina | 37081 | 48433 | 719 |
1409336 | 1409336 | 2021-06-11 | Guilford | North Carolina | 37081 | 48433 | 719 |
1406091 | 1406091 | 2021-06-10 | Guilford | North Carolina | 37081 | 48431 | 717 |
1402845 | 1402845 | 2021-06-09 | Guilford | North Carolina | 37081 | 48423 | 717 |
1399600 | 1399600 | 2021-06-08 | Guilford | North Carolina | 37081 | 48397 | 715 |
1396355 | 1396355 | 2021-06-07 | Guilford | North Carolina | 37081 | 48393 | 715 |
1393108 | 1393108 | 2021-06-06 | Guilford | North Carolina | 37081 | 48360 | 714 |
1389863 | 1389863 | 2021-06-05 | Guilford | North Carolina | 37081 | 48360 | 714 |
1386618 | 1386618 | 2021-06-04 | Guilford | North Carolina | 37081 | 48360 | 714 |
1383373 | 1383373 | 2021-06-03 | Guilford | North Carolina | 37081 | 48319 | 714 |
1380127 | 1380127 | 2021-06-02 | Guilford | North Carolina | 37081 | 48278 | 713 |
1376882 | 1376882 | 2021-06-01 | Guilford | North Carolina | 37081 | 48266 | 711 |
1373636 | 1373636 | 2021-05-31 | Guilford | North Carolina | 37081 | 48157 | 711 |
1370391 | 1370391 | 2021-05-30 | Guilford | North Carolina | 37081 | 48157 | 711 |
1367145 | 1367145 | 2021-05-29 | Guilford | North Carolina | 37081 | 48157 | 711 |
1363899 | 1363899 | 2021-05-28 | Guilford | North Carolina | 37081 | 48157 | 711 |
1360653 | 1360653 | 2021-05-27 | Guilford | North Carolina | 37081 | 48132 | 711 |
1357407 | 1357407 | 2021-05-26 | Guilford | North Carolina | 37081 | 48103 | 709 |
1354161 | 1354161 | 2021-05-25 | Guilford | North Carolina | 37081 | 48039 | 708 |
1350915 | 1350915 | 2021-05-24 | Guilford | North Carolina | 37081 | 48024 | 708 |
1347669 | 1347669 | 2021-05-23 | Guilford | North Carolina | 37081 | 47915 | 707 |
1344421 | 1344421 | 2021-05-22 | Guilford | North Carolina | 37081 | 47915 | 707 |
1341173 | 1341173 | 2021-05-21 | Guilford | North Carolina | 37081 | 47915 | 707 |
1337925 | 1337925 | 2021-05-20 | Guilford | North Carolina | 37081 | 47870 | 707 |
1334678 | 1334678 | 2021-05-19 | Guilford | North Carolina | 37081 | 47830 | 707 |
1331431 | 1331431 | 2021-05-18 | Guilford | North Carolina | 37081 | 47783 | 703 |
1328184 | 1328184 | 2021-05-17 | Guilford | North Carolina | 37081 | 47744 | 703 |
1324938 | 1324938 | 2021-05-16 | Guilford | North Carolina | 37081 | 47588 | 700 |
1321692 | 1321692 | 2021-05-15 | Guilford | North Carolina | 37081 | 47588 | 700 |
1318446 | 1318446 | 2021-05-14 | Guilford | North Carolina | 37081 | 47588 | 700 |
1315198 | 1315198 | 2021-05-13 | Guilford | North Carolina | 37081 | 47358 | 701 |
1311952 | 1311952 | 2021-05-12 | Guilford | North Carolina | 37081 | 47293 | 701 |
1308705 | 1308705 | 2021-05-11 | Guilford | North Carolina | 37081 | 47192 | 701 |
1305459 | 1305459 | 2021-05-10 | Guilford | North Carolina | 37081 | 47176 | 700 |
1302213 | 1302213 | 2021-05-09 | Guilford | North Carolina | 37081 | 46996 | 700 |
1298965 | 1298965 | 2021-05-08 | Guilford | North Carolina | 37081 | 46996 | 700 |
1295719 | 1295719 | 2021-05-07 | Guilford | North Carolina | 37081 | 46996 | 700 |
1292473 | 1292473 | 2021-05-06 | Guilford | North Carolina | 37081 | 46902 | 698 |
1289227 | 1289227 | 2021-05-05 | Guilford | North Carolina | 37081 | 46810 | 698 |
1285981 | 1285981 | 2021-05-04 | Guilford | North Carolina | 37081 | 46750 | 696 |
1282735 | 1282735 | 2021-05-03 | Guilford | North Carolina | 37081 | 46705 | 695 |
1279488 | 1279488 | 2021-05-02 | Guilford | North Carolina | 37081 | 46460 | 693 |
1276241 | 1276241 | 2021-05-01 | Guilford | North Carolina | 37081 | 46460 | 693 |
1272994 | 1272994 | 2021-04-30 | Guilford | North Carolina | 37081 | 46460 | 693 |
1269747 | 1269747 | 2021-04-29 | Guilford | North Carolina | 37081 | 46364 | 680 |
1266500 | 1266500 | 2021-04-28 | Guilford | North Carolina | 37081 | 46271 | 677 |
1263253 | 1263253 | 2021-04-27 | Guilford | North Carolina | 37081 | 46205 | 673 |
1260006 | 1260006 | 2021-04-26 | Guilford | North Carolina | 37081 | 46151 | 673 |
1256759 | 1256759 | 2021-04-25 | Guilford | North Carolina | 37081 | 45781 | 673 |
1253512 | 1253512 | 2021-04-24 | Guilford | North Carolina | 37081 | 45781 | 673 |
1250265 | 1250265 | 2021-04-23 | Guilford | North Carolina | 37081 | 45781 | 673 |
1247018 | 1247018 | 2021-04-22 | Guilford | North Carolina | 37081 | 45600 | 668 |
1243771 | 1243771 | 2021-04-21 | Guilford | North Carolina | 37081 | 45454 | 666 |
1240524 | 1240524 | 2021-04-20 | Guilford | North Carolina | 37081 | 45347 | 656 |
1237277 | 1237277 | 2021-04-19 | Guilford | North Carolina | 37081 | 45274 | 655 |
1234030 | 1234030 | 2021-04-18 | Guilford | North Carolina | 37081 | 44926 | 647 |
1230782 | 1230782 | 2021-04-17 | Guilford | North Carolina | 37081 | 44926 | 647 |
1227534 | 1227534 | 2021-04-16 | Guilford | North Carolina | 37081 | 44926 | 647 |
1224286 | 1224286 | 2021-04-15 | Guilford | North Carolina | 37081 | 44792 | 640 |
1221039 | 1221039 | 2021-04-14 | Guilford | North Carolina | 37081 | 44634 | 634 |
1217791 | 1217791 | 2021-04-13 | Guilford | North Carolina | 37081 | 44520 | 632 |
1214543 | 1214543 | 2021-04-12 | Guilford | North Carolina | 37081 | 44402 | 630 |
1211296 | 1211296 | 2021-04-11 | Guilford | North Carolina | 37081 | 43946 | 627 |
1208047 | 1208047 | 2021-04-10 | Guilford | North Carolina | 37081 | 43946 | 627 |
1204799 | 1204799 | 2021-04-09 | Guilford | North Carolina | 37081 | 43946 | 627 |
1201551 | 1201551 | 2021-04-08 | Guilford | North Carolina | 37081 | 43703 | 622 |
1198302 | 1198302 | 2021-04-07 | Guilford | North Carolina | 37081 | 43555 | 622 |
1195053 | 1195053 | 2021-04-06 | Guilford | North Carolina | 37081 | 43477 | 622 |
1191805 | 1191805 | 2021-04-05 | Guilford | North Carolina | 37081 | 43431 | 621 |
1188556 | 1188556 | 2021-04-04 | Guilford | North Carolina | 37081 | 43019 | 617 |
1185309 | 1185309 | 2021-04-03 | Guilford | North Carolina | 37081 | 43019 | 617 |
1182062 | 1182062 | 2021-04-02 | Guilford | North Carolina | 37081 | 43019 | 617 |
1178815 | 1178815 | 2021-04-01 | Guilford | North Carolina | 37081 | 43019 | 617 |
1175568 | 1175568 | 2021-03-31 | Guilford | North Carolina | 37081 | 42862 | 617 |
1172321 | 1172321 | 2021-03-30 | Guilford | North Carolina | 37081 | 42760 | 611 |
1169074 | 1169074 | 2021-03-29 | Guilford | North Carolina | 37081 | 42686 | 611 |
1165826 | 1165826 | 2021-03-28 | Guilford | North Carolina | 37081 | 42309 | 603 |
1162578 | 1162578 | 2021-03-27 | Guilford | North Carolina | 37081 | 42309 | 603 |
1159329 | 1159329 | 2021-03-26 | Guilford | North Carolina | 37081 | 42309 | 603 |
1156082 | 1156082 | 2021-03-25 | Guilford | North Carolina | 37081 | 42188 | 601 |
1152835 | 1152835 | 2021-03-24 | Guilford | North Carolina | 37081 | 42025 | 600 |
1149588 | 1149588 | 2021-03-23 | Guilford | North Carolina | 37081 | 41928 | 592 |
1146341 | 1146341 | 2021-03-22 | Guilford | North Carolina | 37081 | 41851 | 589 |
1143094 | 1143094 | 2021-03-21 | Guilford | North Carolina | 37081 | 41677 | 584 |
1139847 | 1139847 | 2021-03-20 | Guilford | North Carolina | 37081 | 41677 | 584 |
1136601 | 1136601 | 2021-03-19 | Guilford | North Carolina | 37081 | 41521 | 582 |
1133355 | 1133355 | 2021-03-18 | Guilford | North Carolina | 37081 | 41438 | 572 |
1130107 | 1130107 | 2021-03-17 | Guilford | North Carolina | 37081 | 41320 | 571 |
1126860 | 1126860 | 2021-03-16 | Guilford | North Carolina | 37081 | 41221 | 567 |
1123614 | 1123614 | 2021-03-15 | Guilford | North Carolina | 37081 | 41168 | 567 |
1120368 | 1120368 | 2021-03-14 | Guilford | North Carolina | 37081 | 40987 | 564 |
1117121 | 1117121 | 2021-03-13 | Guilford | North Carolina | 37081 | 40987 | 564 |
1113874 | 1113874 | 2021-03-12 | Guilford | North Carolina | 37081 | 40936 | 564 |
1110628 | 1110628 | 2021-03-11 | Guilford | North Carolina | 37081 | 40845 | 563 |
1107382 | 1107382 | 2021-03-10 | Guilford | North Carolina | 37081 | 40744 | 561 |
1104136 | 1104136 | 2021-03-09 | Guilford | North Carolina | 37081 | 40661 | 559 |
1100890 | 1100890 | 2021-03-08 | Guilford | North Carolina | 37081 | 40605 | 559 |
1097644 | 1097644 | 2021-03-07 | Guilford | North Carolina | 37081 | 40451 | 558 |
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);