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 |
---|---|---|---|---|---|---|---|
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 |
1094396 | 1094396 | 2021-03-06 | Guilford | North Carolina | 37081 | 40451 | 558 |
1091150 | 1091150 | 2021-03-05 | Guilford | North Carolina | 37081 | 40361 | 557 |
1087905 | 1087905 | 2021-03-04 | Guilford | North Carolina | 37081 | 40228 | 555 |
1084660 | 1084660 | 2021-03-03 | Guilford | North Carolina | 37081 | 40105 | 554 |
1081414 | 1081414 | 2021-03-02 | Guilford | North Carolina | 37081 | 40024 | 553 |
1078168 | 1078168 | 2021-03-01 | Guilford | North Carolina | 37081 | 39936 | 553 |
1074923 | 1074923 | 2021-02-28 | Guilford | North Carolina | 37081 | 39769 | 552 |
1071677 | 1071677 | 2021-02-27 | Guilford | North Carolina | 37081 | 39769 | 552 |
1068431 | 1068431 | 2021-02-26 | Guilford | North Carolina | 37081 | 39633 | 552 |
1065186 | 1065186 | 2021-02-25 | Guilford | North Carolina | 37081 | 39483 | 551 |
1061942 | 1061942 | 2021-02-24 | Guilford | North Carolina | 37081 | 39323 | 551 |
1058696 | 1058696 | 2021-02-23 | Guilford | North Carolina | 37081 | 39157 | 539 |
1055450 | 1055450 | 2021-02-22 | Guilford | North Carolina | 37081 | 39089 | 537 |
1052204 | 1052204 | 2021-02-21 | Guilford | North Carolina | 37081 | 38991 | 537 |
1048957 | 1048957 | 2021-02-20 | Guilford | North Carolina | 37081 | 38935 | 537 |
1045710 | 1045710 | 2021-02-19 | Guilford | North Carolina | 37081 | 38848 | 537 |
1042465 | 1042465 | 2021-02-18 | Guilford | North Carolina | 37081 | 38705 | 534 |
1039220 | 1039220 | 2021-02-17 | Guilford | North Carolina | 37081 | 38532 | 526 |
1035975 | 1035975 | 2021-02-16 | Guilford | North Carolina | 37081 | 38403 | 517 |
1032730 | 1032730 | 2021-02-15 | Guilford | North Carolina | 37081 | 38291 | 504 |
1029484 | 1029484 | 2021-02-14 | Guilford | North Carolina | 37081 | 38163 | 504 |
1026237 | 1026237 | 2021-02-13 | Guilford | North Carolina | 37081 | 38006 | 501 |
1022992 | 1022992 | 2021-02-12 | Guilford | North Carolina | 37081 | 37806 | 489 |
1019747 | 1019747 | 2021-02-11 | Guilford | North Carolina | 37081 | 37594 | 474 |
1016502 | 1016502 | 2021-02-10 | Guilford | North Carolina | 37081 | 37390 | 464 |
1013257 | 1013257 | 2021-02-09 | Guilford | North Carolina | 37081 | 37244 | 454 |
1010012 | 1010012 | 2021-02-08 | Guilford | North Carolina | 37081 | 37108 | 454 |
1006766 | 1006766 | 2021-02-07 | Guilford | North Carolina | 37081 | 36946 | 454 |
1003520 | 1003520 | 2021-02-06 | Guilford | North Carolina | 37081 | 36716 | 453 |
1000274 | 1000274 | 2021-02-05 | Guilford | North Carolina | 37081 | 36481 | 440 |
997028 | 997028 | 2021-02-04 | Guilford | North Carolina | 37081 | 36238 | 438 |
993782 | 993782 | 2021-02-03 | Guilford | North Carolina | 37081 | 36020 | 425 |
990536 | 990536 | 2021-02-02 | Guilford | North Carolina | 37081 | 35355 | 415 |
987290 | 987290 | 2021-02-01 | Guilford | North Carolina | 37081 | 35206 | 414 |
984043 | 984043 | 2021-01-31 | Guilford | North Carolina | 37081 | 34978 | 414 |
980796 | 980796 | 2021-01-30 | Guilford | North Carolina | 37081 | 34434 | 401 |
977550 | 977550 | 2021-01-29 | Guilford | North Carolina | 37081 | 34434 | 401 |
974305 | 974305 | 2021-01-28 | Guilford | North Carolina | 37081 | 34165 | 390 |
971060 | 971060 | 2021-01-27 | Guilford | North Carolina | 37081 | 33799 | 384 |
967815 | 967815 | 2021-01-26 | Guilford | North Carolina | 37081 | 33578 | 377 |
964571 | 964571 | 2021-01-25 | Guilford | North Carolina | 37081 | 33373 | 377 |
961326 | 961326 | 2021-01-24 | Guilford | North Carolina | 37081 | 33119 | 377 |
958081 | 958081 | 2021-01-23 | Guilford | North Carolina | 37081 | 32749 | 373 |
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);