ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Essex" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194969 | 1194969 | 2021-04-06 | Essex | New York | 36031 | 1474 | 26 |
1191721 | 1191721 | 2021-04-05 | Essex | New York | 36031 | 1469 | 26 |
1188472 | 1188472 | 2021-04-04 | Essex | New York | 36031 | 1468 | 26 |
1185225 | 1185225 | 2021-04-03 | Essex | New York | 36031 | 1465 | 26 |
1181978 | 1181978 | 2021-04-02 | Essex | New York | 36031 | 1462 | 26 |
1178731 | 1178731 | 2021-04-01 | Essex | New York | 36031 | 1455 | 26 |
1175484 | 1175484 | 2021-03-31 | Essex | New York | 36031 | 1447 | 26 |
1172237 | 1172237 | 2021-03-30 | Essex | New York | 36031 | 1445 | 26 |
1168990 | 1168990 | 2021-03-29 | Essex | New York | 36031 | 1443 | 26 |
1165742 | 1165742 | 2021-03-28 | Essex | New York | 36031 | 1440 | 26 |
1162494 | 1162494 | 2021-03-27 | Essex | New York | 36031 | 1436 | 26 |
1159245 | 1159245 | 2021-03-26 | Essex | New York | 36031 | 1430 | 26 |
1155998 | 1155998 | 2021-03-25 | Essex | New York | 36031 | 1428 | 26 |
1152751 | 1152751 | 2021-03-24 | Essex | New York | 36031 | 1426 | 26 |
1149504 | 1149504 | 2021-03-23 | Essex | New York | 36031 | 1422 | 26 |
1146257 | 1146257 | 2021-03-22 | Essex | New York | 36031 | 1419 | 26 |
1143010 | 1143010 | 2021-03-21 | Essex | New York | 36031 | 1419 | 26 |
1139763 | 1139763 | 2021-03-20 | Essex | New York | 36031 | 1419 | 26 |
1136517 | 1136517 | 2021-03-19 | Essex | New York | 36031 | 1417 | 26 |
1133271 | 1133271 | 2021-03-18 | Essex | New York | 36031 | 1412 | 26 |
1130023 | 1130023 | 2021-03-17 | Essex | New York | 36031 | 1408 | 26 |
1126776 | 1126776 | 2021-03-16 | Essex | New York | 36031 | 1407 | 26 |
1123530 | 1123530 | 2021-03-15 | Essex | New York | 36031 | 1406 | 26 |
1120284 | 1120284 | 2021-03-14 | Essex | New York | 36031 | 1403 | 26 |
1117037 | 1117037 | 2021-03-13 | Essex | New York | 36031 | 1399 | 26 |
1113790 | 1113790 | 2021-03-12 | Essex | New York | 36031 | 1394 | 26 |
1110544 | 1110544 | 2021-03-11 | Essex | New York | 36031 | 1386 | 26 |
1107298 | 1107298 | 2021-03-10 | Essex | New York | 36031 | 1382 | 26 |
1104052 | 1104052 | 2021-03-09 | Essex | New York | 36031 | 1380 | 26 |
1100806 | 1100806 | 2021-03-08 | Essex | New York | 36031 | 1379 | 26 |
1097560 | 1097560 | 2021-03-07 | Essex | New York | 36031 | 1372 | 26 |
1094312 | 1094312 | 2021-03-06 | Essex | New York | 36031 | 1371 | 26 |
1091066 | 1091066 | 2021-03-05 | Essex | New York | 36031 | 1368 | 26 |
1087821 | 1087821 | 2021-03-04 | Essex | New York | 36031 | 1364 | 26 |
1084576 | 1084576 | 2021-03-03 | Essex | New York | 36031 | 1360 | 26 |
1081330 | 1081330 | 2021-03-02 | Essex | New York | 36031 | 1355 | 26 |
1078084 | 1078084 | 2021-03-01 | Essex | New York | 36031 | 1350 | 26 |
1074839 | 1074839 | 2021-02-28 | Essex | New York | 36031 | 1349 | 26 |
1071593 | 1071593 | 2021-02-27 | Essex | New York | 36031 | 1344 | 26 |
1068347 | 1068347 | 2021-02-26 | Essex | New York | 36031 | 1340 | 26 |
1065102 | 1065102 | 2021-02-25 | Essex | New York | 36031 | 1336 | 26 |
1061858 | 1061858 | 2021-02-24 | Essex | New York | 36031 | 1325 | 26 |
1058612 | 1058612 | 2021-02-23 | Essex | New York | 36031 | 1322 | 26 |
1055366 | 1055366 | 2021-02-22 | Essex | New York | 36031 | 1310 | 26 |
1052120 | 1052120 | 2021-02-21 | Essex | New York | 36031 | 1306 | 26 |
1048873 | 1048873 | 2021-02-20 | Essex | New York | 36031 | 1299 | 26 |
1045626 | 1045626 | 2021-02-19 | Essex | New York | 36031 | 1280 | 26 |
1042381 | 1042381 | 2021-02-18 | Essex | New York | 36031 | 1270 | 26 |
1039136 | 1039136 | 2021-02-17 | Essex | New York | 36031 | 1268 | 26 |
1035891 | 1035891 | 2021-02-16 | Essex | New York | 36031 | 1257 | 26 |
1032646 | 1032646 | 2021-02-15 | Essex | New York | 36031 | 1250 | 26 |
1029400 | 1029400 | 2021-02-14 | Essex | New York | 36031 | 1243 | 26 |
1026153 | 1026153 | 2021-02-13 | Essex | New York | 36031 | 1233 | 26 |
1022908 | 1022908 | 2021-02-12 | Essex | New York | 36031 | 1223 | 25 |
1019663 | 1019663 | 2021-02-11 | Essex | New York | 36031 | 1210 | 24 |
1016418 | 1016418 | 2021-02-10 | Essex | New York | 36031 | 1205 | 24 |
1013173 | 1013173 | 2021-02-09 | Essex | New York | 36031 | 1197 | 24 |
1009928 | 1009928 | 2021-02-08 | Essex | New York | 36031 | 1191 | 24 |
1006682 | 1006682 | 2021-02-07 | Essex | New York | 36031 | 1186 | 24 |
1003436 | 1003436 | 2021-02-06 | Essex | New York | 36031 | 1180 | 24 |
1000190 | 1000190 | 2021-02-05 | Essex | New York | 36031 | 1168 | 23 |
996944 | 996944 | 2021-02-04 | Essex | New York | 36031 | 1161 | 22 |
993698 | 993698 | 2021-02-03 | Essex | New York | 36031 | 1142 | 22 |
990452 | 990452 | 2021-02-02 | Essex | New York | 36031 | 1131 | 22 |
987206 | 987206 | 2021-02-01 | Essex | New York | 36031 | 1125 | 22 |
983959 | 983959 | 2021-01-31 | Essex | New York | 36031 | 1119 | 22 |
980712 | 980712 | 2021-01-30 | Essex | New York | 36031 | 1108 | 21 |
977466 | 977466 | 2021-01-29 | Essex | New York | 36031 | 1099 | 21 |
974221 | 974221 | 2021-01-28 | Essex | New York | 36031 | 1086 | 21 |
970976 | 970976 | 2021-01-27 | Essex | New York | 36031 | 1073 | 21 |
967731 | 967731 | 2021-01-26 | Essex | New York | 36031 | 1064 | 21 |
964487 | 964487 | 2021-01-25 | Essex | New York | 36031 | 1054 | 21 |
961242 | 961242 | 2021-01-24 | Essex | New York | 36031 | 1045 | 21 |
957997 | 957997 | 2021-01-23 | Essex | New York | 36031 | 1033 | 21 |
954751 | 954751 | 2021-01-22 | Essex | New York | 36031 | 1025 | 21 |
951506 | 951506 | 2021-01-21 | Essex | New York | 36031 | 1005 | 19 |
948261 | 948261 | 2021-01-20 | Essex | New York | 36031 | 996 | 19 |
945014 | 945014 | 2021-01-19 | Essex | New York | 36031 | 988 | 19 |
941768 | 941768 | 2021-01-18 | Essex | New York | 36031 | 980 | 18 |
938523 | 938523 | 2021-01-17 | Essex | New York | 36031 | 967 | 16 |
935278 | 935278 | 2021-01-16 | Essex | New York | 36031 | 960 | 16 |
932033 | 932033 | 2021-01-15 | Essex | New York | 36031 | 937 | 16 |
928788 | 928788 | 2021-01-14 | Essex | New York | 36031 | 908 | 16 |
925543 | 925543 | 2021-01-13 | Essex | New York | 36031 | 894 | 16 |
922297 | 922297 | 2021-01-12 | Essex | New York | 36031 | 876 | 16 |
919052 | 919052 | 2021-01-11 | Essex | New York | 36031 | 861 | 16 |
915807 | 915807 | 2021-01-10 | Essex | New York | 36031 | 855 | 16 |
912562 | 912562 | 2021-01-09 | Essex | New York | 36031 | 840 | 16 |
909317 | 909317 | 2021-01-08 | Essex | New York | 36031 | 786 | 16 |
906072 | 906072 | 2021-01-07 | Essex | New York | 36031 | 724 | 16 |
902826 | 902826 | 2021-01-06 | Essex | New York | 36031 | 687 | 16 |
899581 | 899581 | 2021-01-05 | Essex | New York | 36031 | 671 | 16 |
896336 | 896336 | 2021-01-04 | Essex | New York | 36031 | 659 | 16 |
893090 | 893090 | 2021-01-03 | Essex | New York | 36031 | 650 | 16 |
889844 | 889844 | 2021-01-02 | Essex | New York | 36031 | 627 | 16 |
886597 | 886597 | 2021-01-01 | Essex | New York | 36031 | 616 | 16 |
883352 | 883352 | 2020-12-31 | Essex | New York | 36031 | 578 | 16 |
880107 | 880107 | 2020-12-30 | Essex | New York | 36031 | 562 | 16 |
876862 | 876862 | 2020-12-29 | Essex | New York | 36031 | 545 | 16 |
873617 | 873617 | 2020-12-28 | Essex | New York | 36031 | 537 | 16 |
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);