ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 36113 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 |
---|---|---|---|---|---|---|---|
1419026 | 1419026 | 2021-06-14 | Warren | New York | 36113 | 3658 | 57 |
1415781 | 1415781 | 2021-06-13 | Warren | New York | 36113 | 3658 | 57 |
1412535 | 1412535 | 2021-06-12 | Warren | New York | 36113 | 3658 | 57 |
1409290 | 1409290 | 2021-06-11 | Warren | New York | 36113 | 3658 | 57 |
1406045 | 1406045 | 2021-06-10 | Warren | New York | 36113 | 3657 | 57 |
1402799 | 1402799 | 2021-06-09 | Warren | New York | 36113 | 3656 | 57 |
1399554 | 1399554 | 2021-06-08 | Warren | New York | 36113 | 3656 | 57 |
1396309 | 1396309 | 2021-06-07 | Warren | New York | 36113 | 3656 | 57 |
1393062 | 1393062 | 2021-06-06 | Warren | New York | 36113 | 3656 | 57 |
1389817 | 1389817 | 2021-06-05 | Warren | New York | 36113 | 3653 | 57 |
1386572 | 1386572 | 2021-06-04 | Warren | New York | 36113 | 3648 | 57 |
1383327 | 1383327 | 2021-06-03 | Warren | New York | 36113 | 3645 | 57 |
1380081 | 1380081 | 2021-06-02 | Warren | New York | 36113 | 3640 | 57 |
1376836 | 1376836 | 2021-06-01 | Warren | New York | 36113 | 3638 | 57 |
1373590 | 1373590 | 2021-05-31 | Warren | New York | 36113 | 3638 | 57 |
1370345 | 1370345 | 2021-05-30 | Warren | New York | 36113 | 3635 | 57 |
1367099 | 1367099 | 2021-05-29 | Warren | New York | 36113 | 3634 | 57 |
1363853 | 1363853 | 2021-05-28 | Warren | New York | 36113 | 3630 | 57 |
1360607 | 1360607 | 2021-05-27 | Warren | New York | 36113 | 3629 | 57 |
1357361 | 1357361 | 2021-05-26 | Warren | New York | 36113 | 3627 | 57 |
1354115 | 1354115 | 2021-05-25 | Warren | New York | 36113 | 3623 | 57 |
1350869 | 1350869 | 2021-05-24 | Warren | New York | 36113 | 3622 | 57 |
1347623 | 1347623 | 2021-05-23 | Warren | New York | 36113 | 3614 | 57 |
1344375 | 1344375 | 2021-05-22 | Warren | New York | 36113 | 3612 | 57 |
1341127 | 1341127 | 2021-05-21 | Warren | New York | 36113 | 3608 | 57 |
1337879 | 1337879 | 2021-05-20 | Warren | New York | 36113 | 3602 | 57 |
1334632 | 1334632 | 2021-05-19 | Warren | New York | 36113 | 3599 | 57 |
1331385 | 1331385 | 2021-05-18 | Warren | New York | 36113 | 3594 | 57 |
1328138 | 1328138 | 2021-05-17 | Warren | New York | 36113 | 3592 | 57 |
1324892 | 1324892 | 2021-05-16 | Warren | New York | 36113 | 3590 | 57 |
1321646 | 1321646 | 2021-05-15 | Warren | New York | 36113 | 3585 | 57 |
1318400 | 1318400 | 2021-05-14 | Warren | New York | 36113 | 3580 | 57 |
1315152 | 1315152 | 2021-05-13 | Warren | New York | 36113 | 3577 | 57 |
1311906 | 1311906 | 2021-05-12 | Warren | New York | 36113 | 3569 | 57 |
1308659 | 1308659 | 2021-05-11 | Warren | New York | 36113 | 3563 | 57 |
1305413 | 1305413 | 2021-05-10 | Warren | New York | 36113 | 3552 | 57 |
1302167 | 1302167 | 2021-05-09 | Warren | New York | 36113 | 3548 | 57 |
1298919 | 1298919 | 2021-05-08 | Warren | New York | 36113 | 3540 | 57 |
1295673 | 1295673 | 2021-05-07 | Warren | New York | 36113 | 3529 | 57 |
1292427 | 1292427 | 2021-05-06 | Warren | New York | 36113 | 3513 | 57 |
1289181 | 1289181 | 2021-05-05 | Warren | New York | 36113 | 3507 | 57 |
1285935 | 1285935 | 2021-05-04 | Warren | New York | 36113 | 3497 | 57 |
1282689 | 1282689 | 2021-05-03 | Warren | New York | 36113 | 3489 | 57 |
1279442 | 1279442 | 2021-05-02 | Warren | New York | 36113 | 3488 | 57 |
1276195 | 1276195 | 2021-05-01 | Warren | New York | 36113 | 3488 | 57 |
1272948 | 1272948 | 2021-04-30 | Warren | New York | 36113 | 3482 | 57 |
1269701 | 1269701 | 2021-04-29 | Warren | New York | 36113 | 3476 | 57 |
1266454 | 1266454 | 2021-04-28 | Warren | New York | 36113 | 3472 | 57 |
1263207 | 1263207 | 2021-04-27 | Warren | New York | 36113 | 3468 | 57 |
1259960 | 1259960 | 2021-04-26 | Warren | New York | 36113 | 3458 | 57 |
1256713 | 1256713 | 2021-04-25 | Warren | New York | 36113 | 3454 | 57 |
1253466 | 1253466 | 2021-04-24 | Warren | New York | 36113 | 3449 | 57 |
1250219 | 1250219 | 2021-04-23 | Warren | New York | 36113 | 3438 | 57 |
1246972 | 1246972 | 2021-04-22 | Warren | New York | 36113 | 3431 | 56 |
1243725 | 1243725 | 2021-04-21 | Warren | New York | 36113 | 3418 | 56 |
1240478 | 1240478 | 2021-04-20 | Warren | New York | 36113 | 3399 | 56 |
1237231 | 1237231 | 2021-04-19 | Warren | New York | 36113 | 3395 | 56 |
1233984 | 1233984 | 2021-04-18 | Warren | New York | 36113 | 3386 | 56 |
1230736 | 1230736 | 2021-04-17 | Warren | New York | 36113 | 3374 | 56 |
1227488 | 1227488 | 2021-04-16 | Warren | New York | 36113 | 3360 | 56 |
1224240 | 1224240 | 2021-04-15 | Warren | New York | 36113 | 3349 | 56 |
1220993 | 1220993 | 2021-04-14 | Warren | New York | 36113 | 3337 | 56 |
1217745 | 1217745 | 2021-04-13 | Warren | New York | 36113 | 3333 | 55 |
1214497 | 1214497 | 2021-04-12 | Warren | New York | 36113 | 3314 | 55 |
1211250 | 1211250 | 2021-04-11 | Warren | New York | 36113 | 3307 | 55 |
1208001 | 1208001 | 2021-04-10 | Warren | New York | 36113 | 3299 | 55 |
1204753 | 1204753 | 2021-04-09 | Warren | New York | 36113 | 3288 | 55 |
1201505 | 1201505 | 2021-04-08 | Warren | New York | 36113 | 3280 | 55 |
1198256 | 1198256 | 2021-04-07 | Warren | New York | 36113 | 3260 | 55 |
1195007 | 1195007 | 2021-04-06 | Warren | New York | 36113 | 3251 | 55 |
1191759 | 1191759 | 2021-04-05 | Warren | New York | 36113 | 3239 | 55 |
1188510 | 1188510 | 2021-04-04 | Warren | New York | 36113 | 3234 | 55 |
1185263 | 1185263 | 2021-04-03 | Warren | New York | 36113 | 3231 | 55 |
1182016 | 1182016 | 2021-04-02 | Warren | New York | 36113 | 3211 | 55 |
1178769 | 1178769 | 2021-04-01 | Warren | New York | 36113 | 3199 | 55 |
1175522 | 1175522 | 2021-03-31 | Warren | New York | 36113 | 3180 | 55 |
1172275 | 1172275 | 2021-03-30 | Warren | New York | 36113 | 3164 | 55 |
1169028 | 1169028 | 2021-03-29 | Warren | New York | 36113 | 3148 | 55 |
1165780 | 1165780 | 2021-03-28 | Warren | New York | 36113 | 3140 | 55 |
1162532 | 1162532 | 2021-03-27 | Warren | New York | 36113 | 3132 | 55 |
1159283 | 1159283 | 2021-03-26 | Warren | New York | 36113 | 3116 | 55 |
1156036 | 1156036 | 2021-03-25 | Warren | New York | 36113 | 3099 | 55 |
1152789 | 1152789 | 2021-03-24 | Warren | New York | 36113 | 3079 | 55 |
1149542 | 1149542 | 2021-03-23 | Warren | New York | 36113 | 3068 | 55 |
1146295 | 1146295 | 2021-03-22 | Warren | New York | 36113 | 3045 | 55 |
1143048 | 1143048 | 2021-03-21 | Warren | New York | 36113 | 3040 | 55 |
1139801 | 1139801 | 2021-03-20 | Warren | New York | 36113 | 3032 | 55 |
1136555 | 1136555 | 2021-03-19 | Warren | New York | 36113 | 3022 | 55 |
1133309 | 1133309 | 2021-03-18 | Warren | New York | 36113 | 3017 | 55 |
1130061 | 1130061 | 2021-03-17 | Warren | New York | 36113 | 3003 | 55 |
1126814 | 1126814 | 2021-03-16 | Warren | New York | 36113 | 2991 | 55 |
1123568 | 1123568 | 2021-03-15 | Warren | New York | 36113 | 2977 | 55 |
1120322 | 1120322 | 2021-03-14 | Warren | New York | 36113 | 2971 | 55 |
1117075 | 1117075 | 2021-03-13 | Warren | New York | 36113 | 2968 | 55 |
1113828 | 1113828 | 2021-03-12 | Warren | New York | 36113 | 2958 | 55 |
1110582 | 1110582 | 2021-03-11 | Warren | New York | 36113 | 2946 | 55 |
1107336 | 1107336 | 2021-03-10 | Warren | New York | 36113 | 2939 | 55 |
1104090 | 1104090 | 2021-03-09 | Warren | New York | 36113 | 2925 | 55 |
1100844 | 1100844 | 2021-03-08 | Warren | New York | 36113 | 2917 | 55 |
1097598 | 1097598 | 2021-03-07 | Warren | New York | 36113 | 2913 | 55 |
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);