ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Washington" 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 |
---|---|---|---|---|---|---|---|
1419125 | 1419125 | 2021-06-14 | Washington | North Carolina | 37187 | 1131 | 32 |
1415880 | 1415880 | 2021-06-13 | Washington | North Carolina | 37187 | 1125 | 31 |
1412634 | 1412634 | 2021-06-12 | Washington | North Carolina | 37187 | 1125 | 31 |
1409389 | 1409389 | 2021-06-11 | Washington | North Carolina | 37187 | 1125 | 31 |
1406144 | 1406144 | 2021-06-10 | Washington | North Carolina | 37187 | 1124 | 31 |
1402898 | 1402898 | 2021-06-09 | Washington | North Carolina | 37187 | 1123 | 31 |
1399653 | 1399653 | 2021-06-08 | Washington | North Carolina | 37187 | 1122 | 31 |
1396408 | 1396408 | 2021-06-07 | Washington | North Carolina | 37187 | 1121 | 31 |
1393161 | 1393161 | 2021-06-06 | Washington | North Carolina | 37187 | 1119 | 31 |
1389916 | 1389916 | 2021-06-05 | Washington | North Carolina | 37187 | 1119 | 31 |
1386671 | 1386671 | 2021-06-04 | Washington | North Carolina | 37187 | 1119 | 31 |
1383426 | 1383426 | 2021-06-03 | Washington | North Carolina | 37187 | 1116 | 31 |
1380180 | 1380180 | 2021-06-02 | Washington | North Carolina | 37187 | 1115 | 31 |
1376935 | 1376935 | 2021-06-01 | Washington | North Carolina | 37187 | 1113 | 31 |
1373689 | 1373689 | 2021-05-31 | Washington | North Carolina | 37187 | 1113 | 31 |
1370444 | 1370444 | 2021-05-30 | Washington | North Carolina | 37187 | 1113 | 31 |
1367198 | 1367198 | 2021-05-29 | Washington | North Carolina | 37187 | 1113 | 31 |
1363952 | 1363952 | 2021-05-28 | Washington | North Carolina | 37187 | 1113 | 31 |
1360706 | 1360706 | 2021-05-27 | Washington | North Carolina | 37187 | 1109 | 31 |
1357460 | 1357460 | 2021-05-26 | Washington | North Carolina | 37187 | 1104 | 31 |
1354214 | 1354214 | 2021-05-25 | Washington | North Carolina | 37187 | 1102 | 31 |
1350968 | 1350968 | 2021-05-24 | Washington | North Carolina | 37187 | 1101 | 31 |
1347722 | 1347722 | 2021-05-23 | Washington | North Carolina | 37187 | 1089 | 31 |
1344474 | 1344474 | 2021-05-22 | Washington | North Carolina | 37187 | 1089 | 31 |
1341226 | 1341226 | 2021-05-21 | Washington | North Carolina | 37187 | 1089 | 31 |
1337978 | 1337978 | 2021-05-20 | Washington | North Carolina | 37187 | 1085 | 31 |
1334731 | 1334731 | 2021-05-19 | Washington | North Carolina | 37187 | 1082 | 31 |
1331484 | 1331484 | 2021-05-18 | Washington | North Carolina | 37187 | 1081 | 31 |
1328237 | 1328237 | 2021-05-17 | Washington | North Carolina | 37187 | 1080 | 31 |
1324991 | 1324991 | 2021-05-16 | Washington | North Carolina | 37187 | 1075 | 31 |
1321745 | 1321745 | 2021-05-15 | Washington | North Carolina | 37187 | 1075 | 31 |
1318499 | 1318499 | 2021-05-14 | Washington | North Carolina | 37187 | 1075 | 31 |
1315251 | 1315251 | 2021-05-13 | Washington | North Carolina | 37187 | 1074 | 31 |
1312005 | 1312005 | 2021-05-12 | Washington | North Carolina | 37187 | 1073 | 31 |
1308758 | 1308758 | 2021-05-11 | Washington | North Carolina | 37187 | 1072 | 31 |
1305512 | 1305512 | 2021-05-10 | Washington | North Carolina | 37187 | 1072 | 31 |
1302266 | 1302266 | 2021-05-09 | Washington | North Carolina | 37187 | 1061 | 31 |
1299018 | 1299018 | 2021-05-08 | Washington | North Carolina | 37187 | 1061 | 31 |
1295772 | 1295772 | 2021-05-07 | Washington | North Carolina | 37187 | 1061 | 31 |
1292526 | 1292526 | 2021-05-06 | Washington | North Carolina | 37187 | 1058 | 31 |
1289280 | 1289280 | 2021-05-05 | Washington | North Carolina | 37187 | 1057 | 31 |
1286034 | 1286034 | 2021-05-04 | Washington | North Carolina | 37187 | 1057 | 31 |
1282788 | 1282788 | 2021-05-03 | Washington | North Carolina | 37187 | 1056 | 31 |
1279541 | 1279541 | 2021-05-02 | Washington | North Carolina | 37187 | 1054 | 31 |
1276294 | 1276294 | 2021-05-01 | Washington | North Carolina | 37187 | 1054 | 31 |
1273047 | 1273047 | 2021-04-30 | Washington | North Carolina | 37187 | 1054 | 31 |
1269800 | 1269800 | 2021-04-29 | Washington | North Carolina | 37187 | 1053 | 31 |
1266553 | 1266553 | 2021-04-28 | Washington | North Carolina | 37187 | 1052 | 31 |
1263306 | 1263306 | 2021-04-27 | Washington | North Carolina | 37187 | 1051 | 31 |
1260059 | 1260059 | 2021-04-26 | Washington | North Carolina | 37187 | 1050 | 31 |
1256812 | 1256812 | 2021-04-25 | Washington | North Carolina | 37187 | 1045 | 31 |
1253565 | 1253565 | 2021-04-24 | Washington | North Carolina | 37187 | 1045 | 31 |
1250318 | 1250318 | 2021-04-23 | Washington | North Carolina | 37187 | 1045 | 31 |
1247071 | 1247071 | 2021-04-22 | Washington | North Carolina | 37187 | 1043 | 31 |
1243824 | 1243824 | 2021-04-21 | Washington | North Carolina | 37187 | 1042 | 31 |
1240577 | 1240577 | 2021-04-20 | Washington | North Carolina | 37187 | 1042 | 31 |
1237330 | 1237330 | 2021-04-19 | Washington | North Carolina | 37187 | 1041 | 31 |
1234083 | 1234083 | 2021-04-18 | Washington | North Carolina | 37187 | 1039 | 31 |
1230835 | 1230835 | 2021-04-17 | Washington | North Carolina | 37187 | 1039 | 31 |
1227587 | 1227587 | 2021-04-16 | Washington | North Carolina | 37187 | 1039 | 31 |
1224339 | 1224339 | 2021-04-15 | Washington | North Carolina | 37187 | 1037 | 31 |
1221092 | 1221092 | 2021-04-14 | Washington | North Carolina | 37187 | 1035 | 31 |
1217844 | 1217844 | 2021-04-13 | Washington | North Carolina | 37187 | 1035 | 31 |
1214596 | 1214596 | 2021-04-12 | Washington | North Carolina | 37187 | 1035 | 31 |
1211349 | 1211349 | 2021-04-11 | Washington | North Carolina | 37187 | 1030 | 31 |
1208100 | 1208100 | 2021-04-10 | Washington | North Carolina | 37187 | 1030 | 31 |
1204852 | 1204852 | 2021-04-09 | Washington | North Carolina | 37187 | 1030 | 31 |
1201604 | 1201604 | 2021-04-08 | Washington | North Carolina | 37187 | 1029 | 31 |
1198355 | 1198355 | 2021-04-07 | Washington | North Carolina | 37187 | 1026 | 31 |
1195106 | 1195106 | 2021-04-06 | Washington | North Carolina | 37187 | 1025 | 31 |
1191858 | 1191858 | 2021-04-05 | Washington | North Carolina | 37187 | 1025 | 31 |
1188609 | 1188609 | 2021-04-04 | Washington | North Carolina | 37187 | 1022 | 31 |
1185362 | 1185362 | 2021-04-03 | Washington | North Carolina | 37187 | 1022 | 31 |
1182115 | 1182115 | 2021-04-02 | Washington | North Carolina | 37187 | 1022 | 31 |
1178868 | 1178868 | 2021-04-01 | Washington | North Carolina | 37187 | 1022 | 31 |
1175621 | 1175621 | 2021-03-31 | Washington | North Carolina | 37187 | 1019 | 31 |
1172374 | 1172374 | 2021-03-30 | Washington | North Carolina | 37187 | 1018 | 31 |
1169127 | 1169127 | 2021-03-29 | Washington | North Carolina | 37187 | 1018 | 31 |
1165879 | 1165879 | 2021-03-28 | Washington | North Carolina | 37187 | 1014 | 31 |
1162631 | 1162631 | 2021-03-27 | Washington | North Carolina | 37187 | 1014 | 31 |
1159382 | 1159382 | 2021-03-26 | Washington | North Carolina | 37187 | 1014 | 31 |
1156135 | 1156135 | 2021-03-25 | Washington | North Carolina | 37187 | 1013 | 31 |
1152888 | 1152888 | 2021-03-24 | Washington | North Carolina | 37187 | 1010 | 31 |
1149641 | 1149641 | 2021-03-23 | Washington | North Carolina | 37187 | 1009 | 31 |
1146394 | 1146394 | 2021-03-22 | Washington | North Carolina | 37187 | 1009 | 31 |
1143147 | 1143147 | 2021-03-21 | Washington | North Carolina | 37187 | 1008 | 31 |
1139900 | 1139900 | 2021-03-20 | Washington | North Carolina | 37187 | 1008 | 31 |
1136654 | 1136654 | 2021-03-19 | Washington | North Carolina | 37187 | 1008 | 31 |
1133408 | 1133408 | 2021-03-18 | Washington | North Carolina | 37187 | 1008 | 31 |
1130160 | 1130160 | 2021-03-17 | Washington | North Carolina | 37187 | 1007 | 31 |
1126913 | 1126913 | 2021-03-16 | Washington | North Carolina | 37187 | 1005 | 31 |
1123667 | 1123667 | 2021-03-15 | Washington | North Carolina | 37187 | 1005 | 31 |
1120421 | 1120421 | 2021-03-14 | Washington | North Carolina | 37187 | 1004 | 31 |
1117174 | 1117174 | 2021-03-13 | Washington | North Carolina | 37187 | 1004 | 31 |
1113927 | 1113927 | 2021-03-12 | Washington | North Carolina | 37187 | 1005 | 31 |
1110681 | 1110681 | 2021-03-11 | Washington | North Carolina | 37187 | 1003 | 31 |
1107435 | 1107435 | 2021-03-10 | Washington | North Carolina | 37187 | 1000 | 31 |
1104189 | 1104189 | 2021-03-09 | Washington | North Carolina | 37187 | 999 | 31 |
1100943 | 1100943 | 2021-03-08 | Washington | North Carolina | 37187 | 999 | 31 |
1097697 | 1097697 | 2021-03-07 | Washington | North Carolina | 37187 | 999 | 31 |
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);