ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 36121 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 |
---|---|---|---|---|---|---|---|
1419030 | 1419030 | 2021-06-14 | Wyoming | New York | 36121 | 3581 | 53 |
1415785 | 1415785 | 2021-06-13 | Wyoming | New York | 36121 | 3581 | 53 |
1412539 | 1412539 | 2021-06-12 | Wyoming | New York | 36121 | 3581 | 53 |
1409294 | 1409294 | 2021-06-11 | Wyoming | New York | 36121 | 3580 | 53 |
1406049 | 1406049 | 2021-06-10 | Wyoming | New York | 36121 | 3578 | 53 |
1402803 | 1402803 | 2021-06-09 | Wyoming | New York | 36121 | 3578 | 52 |
1399558 | 1399558 | 2021-06-08 | Wyoming | New York | 36121 | 3577 | 52 |
1396313 | 1396313 | 2021-06-07 | Wyoming | New York | 36121 | 3576 | 52 |
1393066 | 1393066 | 2021-06-06 | Wyoming | New York | 36121 | 3576 | 52 |
1389821 | 1389821 | 2021-06-05 | Wyoming | New York | 36121 | 3575 | 52 |
1386576 | 1386576 | 2021-06-04 | Wyoming | New York | 36121 | 3575 | 52 |
1383331 | 1383331 | 2021-06-03 | Wyoming | New York | 36121 | 3574 | 52 |
1380085 | 1380085 | 2021-06-02 | Wyoming | New York | 36121 | 3574 | 52 |
1376840 | 1376840 | 2021-06-01 | Wyoming | New York | 36121 | 3574 | 52 |
1373594 | 1373594 | 2021-05-31 | Wyoming | New York | 36121 | 3574 | 52 |
1370349 | 1370349 | 2021-05-30 | Wyoming | New York | 36121 | 3574 | 52 |
1367103 | 1367103 | 2021-05-29 | Wyoming | New York | 36121 | 3571 | 52 |
1363857 | 1363857 | 2021-05-28 | Wyoming | New York | 36121 | 3570 | 52 |
1360611 | 1360611 | 2021-05-27 | Wyoming | New York | 36121 | 3568 | 52 |
1357365 | 1357365 | 2021-05-26 | Wyoming | New York | 36121 | 3565 | 52 |
1354119 | 1354119 | 2021-05-25 | Wyoming | New York | 36121 | 3561 | 52 |
1350873 | 1350873 | 2021-05-24 | Wyoming | New York | 36121 | 3559 | 52 |
1347627 | 1347627 | 2021-05-23 | Wyoming | New York | 36121 | 3555 | 52 |
1344379 | 1344379 | 2021-05-22 | Wyoming | New York | 36121 | 3548 | 52 |
1341131 | 1341131 | 2021-05-21 | Wyoming | New York | 36121 | 3541 | 52 |
1337883 | 1337883 | 2021-05-20 | Wyoming | New York | 36121 | 3536 | 52 |
1334636 | 1334636 | 2021-05-19 | Wyoming | New York | 36121 | 3529 | 52 |
1331389 | 1331389 | 2021-05-18 | Wyoming | New York | 36121 | 3524 | 52 |
1328142 | 1328142 | 2021-05-17 | Wyoming | New York | 36121 | 3524 | 52 |
1324896 | 1324896 | 2021-05-16 | Wyoming | New York | 36121 | 3517 | 52 |
1321650 | 1321650 | 2021-05-15 | Wyoming | New York | 36121 | 3511 | 52 |
1318404 | 1318404 | 2021-05-14 | Wyoming | New York | 36121 | 3504 | 52 |
1315156 | 1315156 | 2021-05-13 | Wyoming | New York | 36121 | 3497 | 52 |
1311910 | 1311910 | 2021-05-12 | Wyoming | New York | 36121 | 3484 | 52 |
1308663 | 1308663 | 2021-05-11 | Wyoming | New York | 36121 | 3470 | 52 |
1305417 | 1305417 | 2021-05-10 | Wyoming | New York | 36121 | 3461 | 51 |
1302171 | 1302171 | 2021-05-09 | Wyoming | New York | 36121 | 3459 | 51 |
1298923 | 1298923 | 2021-05-08 | Wyoming | New York | 36121 | 3457 | 51 |
1295677 | 1295677 | 2021-05-07 | Wyoming | New York | 36121 | 3449 | 51 |
1292431 | 1292431 | 2021-05-06 | Wyoming | New York | 36121 | 3442 | 51 |
1289185 | 1289185 | 2021-05-05 | Wyoming | New York | 36121 | 3430 | 51 |
1285939 | 1285939 | 2021-05-04 | Wyoming | New York | 36121 | 3421 | 51 |
1282693 | 1282693 | 2021-05-03 | Wyoming | New York | 36121 | 3417 | 51 |
1279446 | 1279446 | 2021-05-02 | Wyoming | New York | 36121 | 3415 | 51 |
1276199 | 1276199 | 2021-05-01 | Wyoming | New York | 36121 | 3405 | 51 |
1272952 | 1272952 | 2021-04-30 | Wyoming | New York | 36121 | 3393 | 51 |
1269705 | 1269705 | 2021-04-29 | Wyoming | New York | 36121 | 3377 | 51 |
1266458 | 1266458 | 2021-04-28 | Wyoming | New York | 36121 | 3363 | 51 |
1263211 | 1263211 | 2021-04-27 | Wyoming | New York | 36121 | 3344 | 51 |
1259964 | 1259964 | 2021-04-26 | Wyoming | New York | 36121 | 3339 | 51 |
1256717 | 1256717 | 2021-04-25 | Wyoming | New York | 36121 | 3336 | 51 |
1253470 | 1253470 | 2021-04-24 | Wyoming | New York | 36121 | 3326 | 51 |
1250223 | 1250223 | 2021-04-23 | Wyoming | New York | 36121 | 3307 | 51 |
1246976 | 1246976 | 2021-04-22 | Wyoming | New York | 36121 | 3290 | 51 |
1243729 | 1243729 | 2021-04-21 | Wyoming | New York | 36121 | 3282 | 51 |
1240482 | 1240482 | 2021-04-20 | Wyoming | New York | 36121 | 3268 | 51 |
1237235 | 1237235 | 2021-04-19 | Wyoming | New York | 36121 | 3263 | 51 |
1233988 | 1233988 | 2021-04-18 | Wyoming | New York | 36121 | 3261 | 51 |
1230740 | 1230740 | 2021-04-17 | Wyoming | New York | 36121 | 3239 | 51 |
1227492 | 1227492 | 2021-04-16 | Wyoming | New York | 36121 | 3231 | 51 |
1224244 | 1224244 | 2021-04-15 | Wyoming | New York | 36121 | 3226 | 51 |
1220997 | 1220997 | 2021-04-14 | Wyoming | New York | 36121 | 3217 | 51 |
1217749 | 1217749 | 2021-04-13 | Wyoming | New York | 36121 | 3204 | 51 |
1214501 | 1214501 | 2021-04-12 | Wyoming | New York | 36121 | 3198 | 51 |
1211254 | 1211254 | 2021-04-11 | Wyoming | New York | 36121 | 3194 | 51 |
1208005 | 1208005 | 2021-04-10 | Wyoming | New York | 36121 | 3186 | 51 |
1204757 | 1204757 | 2021-04-09 | Wyoming | New York | 36121 | 3174 | 50 |
1201509 | 1201509 | 2021-04-08 | Wyoming | New York | 36121 | 3159 | 50 |
1198260 | 1198260 | 2021-04-07 | Wyoming | New York | 36121 | 3145 | 50 |
1195011 | 1195011 | 2021-04-06 | Wyoming | New York | 36121 | 3128 | 50 |
1191763 | 1191763 | 2021-04-05 | Wyoming | New York | 36121 | 3125 | 50 |
1188514 | 1188514 | 2021-04-04 | Wyoming | New York | 36121 | 3116 | 50 |
1185267 | 1185267 | 2021-04-03 | Wyoming | New York | 36121 | 3107 | 50 |
1182020 | 1182020 | 2021-04-02 | Wyoming | New York | 36121 | 3095 | 50 |
1178773 | 1178773 | 2021-04-01 | Wyoming | New York | 36121 | 3085 | 50 |
1175526 | 1175526 | 2021-03-31 | Wyoming | New York | 36121 | 3069 | 50 |
1172279 | 1172279 | 2021-03-30 | Wyoming | New York | 36121 | 3061 | 49 |
1169032 | 1169032 | 2021-03-29 | Wyoming | New York | 36121 | 3057 | 49 |
1165784 | 1165784 | 2021-03-28 | Wyoming | New York | 36121 | 3051 | 49 |
1162536 | 1162536 | 2021-03-27 | Wyoming | New York | 36121 | 3046 | 49 |
1159287 | 1159287 | 2021-03-26 | Wyoming | New York | 36121 | 3037 | 49 |
1156040 | 1156040 | 2021-03-25 | Wyoming | New York | 36121 | 3031 | 49 |
1152793 | 1152793 | 2021-03-24 | Wyoming | New York | 36121 | 3022 | 49 |
1149546 | 1149546 | 2021-03-23 | Wyoming | New York | 36121 | 3014 | 49 |
1146299 | 1146299 | 2021-03-22 | Wyoming | New York | 36121 | 3006 | 49 |
1143052 | 1143052 | 2021-03-21 | Wyoming | New York | 36121 | 3005 | 49 |
1139805 | 1139805 | 2021-03-20 | Wyoming | New York | 36121 | 2991 | 49 |
1136559 | 1136559 | 2021-03-19 | Wyoming | New York | 36121 | 2983 | 49 |
1133313 | 1133313 | 2021-03-18 | Wyoming | New York | 36121 | 2976 | 49 |
1130065 | 1130065 | 2021-03-17 | Wyoming | New York | 36121 | 2969 | 49 |
1126818 | 1126818 | 2021-03-16 | Wyoming | New York | 36121 | 2963 | 49 |
1123572 | 1123572 | 2021-03-15 | Wyoming | New York | 36121 | 2958 | 49 |
1120326 | 1120326 | 2021-03-14 | Wyoming | New York | 36121 | 2954 | 49 |
1117079 | 1117079 | 2021-03-13 | Wyoming | New York | 36121 | 2947 | 49 |
1113832 | 1113832 | 2021-03-12 | Wyoming | New York | 36121 | 2939 | 49 |
1110586 | 1110586 | 2021-03-11 | Wyoming | New York | 36121 | 2927 | 49 |
1107340 | 1107340 | 2021-03-10 | Wyoming | New York | 36121 | 2911 | 49 |
1104094 | 1104094 | 2021-03-09 | Wyoming | New York | 36121 | 2907 | 49 |
1100848 | 1100848 | 2021-03-08 | Wyoming | New York | 36121 | 2898 | 49 |
1097602 | 1097602 | 2021-03-07 | Wyoming | New York | 36121 | 2885 | 49 |
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);