ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pitt" 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 |
---|---|---|---|---|---|---|---|
1279521 | 1279521 | 2021-05-02 | Pitt | North Carolina | 37147 | 19269 | 86 |
1276274 | 1276274 | 2021-05-01 | Pitt | North Carolina | 37147 | 19269 | 86 |
1273027 | 1273027 | 2021-04-30 | Pitt | North Carolina | 37147 | 19269 | 86 |
1269780 | 1269780 | 2021-04-29 | Pitt | North Carolina | 37147 | 19219 | 86 |
1266533 | 1266533 | 2021-04-28 | Pitt | North Carolina | 37147 | 19183 | 86 |
1263286 | 1263286 | 2021-04-27 | Pitt | North Carolina | 37147 | 19154 | 86 |
1260039 | 1260039 | 2021-04-26 | Pitt | North Carolina | 37147 | 19129 | 86 |
1256792 | 1256792 | 2021-04-25 | Pitt | North Carolina | 37147 | 19000 | 86 |
1253545 | 1253545 | 2021-04-24 | Pitt | North Carolina | 37147 | 19000 | 86 |
1250298 | 1250298 | 2021-04-23 | Pitt | North Carolina | 37147 | 19000 | 86 |
1247051 | 1247051 | 2021-04-22 | Pitt | North Carolina | 37147 | 18953 | 86 |
1243804 | 1243804 | 2021-04-21 | Pitt | North Carolina | 37147 | 18898 | 86 |
1240557 | 1240557 | 2021-04-20 | Pitt | North Carolina | 37147 | 18850 | 86 |
1237310 | 1237310 | 2021-04-19 | Pitt | North Carolina | 37147 | 18844 | 86 |
1234063 | 1234063 | 2021-04-18 | Pitt | North Carolina | 37147 | 18704 | 86 |
1230815 | 1230815 | 2021-04-17 | Pitt | North Carolina | 37147 | 18704 | 86 |
1227567 | 1227567 | 2021-04-16 | Pitt | North Carolina | 37147 | 18704 | 86 |
1224319 | 1224319 | 2021-04-15 | Pitt | North Carolina | 37147 | 18646 | 86 |
1221072 | 1221072 | 2021-04-14 | Pitt | North Carolina | 37147 | 18606 | 86 |
1217824 | 1217824 | 2021-04-13 | Pitt | North Carolina | 37147 | 18563 | 86 |
1214576 | 1214576 | 2021-04-12 | Pitt | North Carolina | 37147 | 18548 | 86 |
1211329 | 1211329 | 2021-04-11 | Pitt | North Carolina | 37147 | 18436 | 86 |
1208080 | 1208080 | 2021-04-10 | Pitt | North Carolina | 37147 | 18436 | 86 |
1204832 | 1204832 | 2021-04-09 | Pitt | North Carolina | 37147 | 18436 | 86 |
1201584 | 1201584 | 2021-04-08 | Pitt | North Carolina | 37147 | 18382 | 86 |
1198335 | 1198335 | 2021-04-07 | Pitt | North Carolina | 37147 | 18350 | 86 |
1195086 | 1195086 | 2021-04-06 | Pitt | North Carolina | 37147 | 18304 | 86 |
1191838 | 1191838 | 2021-04-05 | Pitt | North Carolina | 37147 | 18311 | 86 |
1188589 | 1188589 | 2021-04-04 | Pitt | North Carolina | 37147 | 18228 | 86 |
1185342 | 1185342 | 2021-04-03 | Pitt | North Carolina | 37147 | 18228 | 86 |
1182095 | 1182095 | 2021-04-02 | Pitt | North Carolina | 37147 | 18228 | 86 |
1178848 | 1178848 | 2021-04-01 | Pitt | North Carolina | 37147 | 18228 | 86 |
1175601 | 1175601 | 2021-03-31 | Pitt | North Carolina | 37147 | 18192 | 86 |
1172354 | 1172354 | 2021-03-30 | Pitt | North Carolina | 37147 | 18156 | 86 |
1169107 | 1169107 | 2021-03-29 | Pitt | North Carolina | 37147 | 18153 | 86 |
1165859 | 1165859 | 2021-03-28 | Pitt | North Carolina | 37147 | 18120 | 86 |
1162611 | 1162611 | 2021-03-27 | Pitt | North Carolina | 37147 | 18120 | 86 |
1159362 | 1159362 | 2021-03-26 | Pitt | North Carolina | 37147 | 18120 | 86 |
1156115 | 1156115 | 2021-03-25 | Pitt | North Carolina | 37147 | 18088 | 85 |
1152868 | 1152868 | 2021-03-24 | Pitt | North Carolina | 37147 | 18064 | 84 |
1149621 | 1149621 | 2021-03-23 | Pitt | North Carolina | 37147 | 18042 | 84 |
1146374 | 1146374 | 2021-03-22 | Pitt | North Carolina | 37147 | 18036 | 84 |
1143127 | 1143127 | 2021-03-21 | Pitt | North Carolina | 37147 | 17996 | 84 |
1139880 | 1139880 | 2021-03-20 | Pitt | North Carolina | 37147 | 17996 | 84 |
1136634 | 1136634 | 2021-03-19 | Pitt | North Carolina | 37147 | 17974 | 84 |
1133388 | 1133388 | 2021-03-18 | Pitt | North Carolina | 37147 | 17946 | 84 |
1130140 | 1130140 | 2021-03-17 | Pitt | North Carolina | 37147 | 17920 | 84 |
1126893 | 1126893 | 2021-03-16 | Pitt | North Carolina | 37147 | 17901 | 84 |
1123647 | 1123647 | 2021-03-15 | Pitt | North Carolina | 37147 | 17883 | 84 |
1120401 | 1120401 | 2021-03-14 | Pitt | North Carolina | 37147 | 17822 | 84 |
1117154 | 1117154 | 2021-03-13 | Pitt | North Carolina | 37147 | 17822 | 84 |
1113907 | 1113907 | 2021-03-12 | Pitt | North Carolina | 37147 | 17824 | 84 |
1110661 | 1110661 | 2021-03-11 | Pitt | North Carolina | 37147 | 17796 | 84 |
1107415 | 1107415 | 2021-03-10 | Pitt | North Carolina | 37147 | 17767 | 84 |
1104169 | 1104169 | 2021-03-09 | Pitt | North Carolina | 37147 | 17745 | 83 |
1100923 | 1100923 | 2021-03-08 | Pitt | North Carolina | 37147 | 17735 | 83 |
1097677 | 1097677 | 2021-03-07 | Pitt | North Carolina | 37147 | 17698 | 83 |
1094429 | 1094429 | 2021-03-06 | Pitt | North Carolina | 37147 | 17698 | 83 |
1091183 | 1091183 | 2021-03-05 | Pitt | North Carolina | 37147 | 17665 | 83 |
1087938 | 1087938 | 2021-03-04 | Pitt | North Carolina | 37147 | 17644 | 83 |
1084693 | 1084693 | 2021-03-03 | Pitt | North Carolina | 37147 | 17600 | 80 |
1081447 | 1081447 | 2021-03-02 | Pitt | North Carolina | 37147 | 17553 | 77 |
1078201 | 1078201 | 2021-03-01 | Pitt | North Carolina | 37147 | 17534 | 77 |
1074956 | 1074956 | 2021-02-28 | Pitt | North Carolina | 37147 | 17466 | 77 |
1071710 | 1071710 | 2021-02-27 | Pitt | North Carolina | 37147 | 17466 | 77 |
1068464 | 1068464 | 2021-02-26 | Pitt | North Carolina | 37147 | 17387 | 77 |
1065219 | 1065219 | 2021-02-25 | Pitt | North Carolina | 37147 | 17321 | 77 |
1061975 | 1061975 | 2021-02-24 | Pitt | North Carolina | 37147 | 17253 | 77 |
1058729 | 1058729 | 2021-02-23 | Pitt | North Carolina | 37147 | 17183 | 77 |
1055483 | 1055483 | 2021-02-22 | Pitt | North Carolina | 37147 | 17162 | 77 |
1052237 | 1052237 | 2021-02-21 | Pitt | North Carolina | 37147 | 17117 | 77 |
1048990 | 1048990 | 2021-02-20 | Pitt | North Carolina | 37147 | 17087 | 76 |
1045743 | 1045743 | 2021-02-19 | Pitt | North Carolina | 37147 | 16996 | 76 |
1042498 | 1042498 | 2021-02-18 | Pitt | North Carolina | 37147 | 16914 | 76 |
1039253 | 1039253 | 2021-02-17 | Pitt | North Carolina | 37147 | 16823 | 76 |
1036008 | 1036008 | 2021-02-16 | Pitt | North Carolina | 37147 | 16759 | 76 |
1032763 | 1032763 | 2021-02-15 | Pitt | North Carolina | 37147 | 16736 | 76 |
1029517 | 1029517 | 2021-02-14 | Pitt | North Carolina | 37147 | 16705 | 76 |
1026270 | 1026270 | 2021-02-13 | Pitt | North Carolina | 37147 | 16633 | 76 |
1023025 | 1023025 | 2021-02-12 | Pitt | North Carolina | 37147 | 16527 | 72 |
1019780 | 1019780 | 2021-02-11 | Pitt | North Carolina | 37147 | 16422 | 72 |
1016535 | 1016535 | 2021-02-10 | Pitt | North Carolina | 37147 | 16323 | 72 |
1013290 | 1013290 | 2021-02-09 | Pitt | North Carolina | 37147 | 16233 | 72 |
1010045 | 1010045 | 2021-02-08 | Pitt | North Carolina | 37147 | 16199 | 72 |
1006799 | 1006799 | 2021-02-07 | Pitt | North Carolina | 37147 | 16143 | 72 |
1003553 | 1003553 | 2021-02-06 | Pitt | North Carolina | 37147 | 16048 | 72 |
1000307 | 1000307 | 2021-02-05 | Pitt | North Carolina | 37147 | 15877 | 72 |
997061 | 997061 | 2021-02-04 | Pitt | North Carolina | 37147 | 15817 | 72 |
993815 | 993815 | 2021-02-03 | Pitt | North Carolina | 37147 | 15718 | 72 |
990569 | 990569 | 2021-02-02 | Pitt | North Carolina | 37147 | 15480 | 71 |
987323 | 987323 | 2021-02-01 | Pitt | North Carolina | 37147 | 15450 | 71 |
984076 | 984076 | 2021-01-31 | Pitt | North Carolina | 37147 | 15387 | 71 |
980829 | 980829 | 2021-01-30 | Pitt | North Carolina | 37147 | 15164 | 71 |
977583 | 977583 | 2021-01-29 | Pitt | North Carolina | 37147 | 15164 | 71 |
974338 | 974338 | 2021-01-28 | Pitt | North Carolina | 37147 | 15037 | 70 |
971093 | 971093 | 2021-01-27 | Pitt | North Carolina | 37147 | 14909 | 70 |
967848 | 967848 | 2021-01-26 | Pitt | North Carolina | 37147 | 14822 | 70 |
964604 | 964604 | 2021-01-25 | Pitt | North Carolina | 37147 | 14796 | 70 |
961359 | 961359 | 2021-01-24 | Pitt | North Carolina | 37147 | 14714 | 70 |
958114 | 958114 | 2021-01-23 | Pitt | North Carolina | 37147 | 14597 | 69 |
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);