ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 36023 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 |
---|---|---|---|---|---|---|---|
1418984 | 1418984 | 2021-06-14 | Cortland | New York | 36023 | 3925 | 62 |
1415739 | 1415739 | 2021-06-13 | Cortland | New York | 36023 | 3925 | 62 |
1412493 | 1412493 | 2021-06-12 | Cortland | New York | 36023 | 3924 | 62 |
1409248 | 1409248 | 2021-06-11 | Cortland | New York | 36023 | 3919 | 62 |
1406003 | 1406003 | 2021-06-10 | Cortland | New York | 36023 | 3916 | 62 |
1402757 | 1402757 | 2021-06-09 | Cortland | New York | 36023 | 3915 | 62 |
1399512 | 1399512 | 2021-06-08 | Cortland | New York | 36023 | 3913 | 62 |
1396267 | 1396267 | 2021-06-07 | Cortland | New York | 36023 | 3911 | 62 |
1393020 | 1393020 | 2021-06-06 | Cortland | New York | 36023 | 3908 | 62 |
1389775 | 1389775 | 2021-06-05 | Cortland | New York | 36023 | 3902 | 60 |
1386530 | 1386530 | 2021-06-04 | Cortland | New York | 36023 | 3898 | 60 |
1383285 | 1383285 | 2021-06-03 | Cortland | New York | 36023 | 3895 | 60 |
1380039 | 1380039 | 2021-06-02 | Cortland | New York | 36023 | 3893 | 60 |
1376794 | 1376794 | 2021-06-01 | Cortland | New York | 36023 | 3889 | 60 |
1373548 | 1373548 | 2021-05-31 | Cortland | New York | 36023 | 3887 | 60 |
1370303 | 1370303 | 2021-05-30 | Cortland | New York | 36023 | 3880 | 60 |
1367057 | 1367057 | 2021-05-29 | Cortland | New York | 36023 | 3875 | 60 |
1363811 | 1363811 | 2021-05-28 | Cortland | New York | 36023 | 3870 | 60 |
1360565 | 1360565 | 2021-05-27 | Cortland | New York | 36023 | 3857 | 60 |
1357319 | 1357319 | 2021-05-26 | Cortland | New York | 36023 | 3847 | 60 |
1354073 | 1354073 | 2021-05-25 | Cortland | New York | 36023 | 3839 | 60 |
1350827 | 1350827 | 2021-05-24 | Cortland | New York | 36023 | 3833 | 60 |
1347581 | 1347581 | 2021-05-23 | Cortland | New York | 36023 | 3831 | 60 |
1344333 | 1344333 | 2021-05-22 | Cortland | New York | 36023 | 3824 | 60 |
1341085 | 1341085 | 2021-05-21 | Cortland | New York | 36023 | 3816 | 60 |
1337837 | 1337837 | 2021-05-20 | Cortland | New York | 36023 | 3807 | 60 |
1334590 | 1334590 | 2021-05-19 | Cortland | New York | 36023 | 3795 | 60 |
1331343 | 1331343 | 2021-05-18 | Cortland | New York | 36023 | 3785 | 60 |
1328096 | 1328096 | 2021-05-17 | Cortland | New York | 36023 | 3773 | 60 |
1324850 | 1324850 | 2021-05-16 | Cortland | New York | 36023 | 3766 | 60 |
1321604 | 1321604 | 2021-05-15 | Cortland | New York | 36023 | 3756 | 60 |
1318358 | 1318358 | 2021-05-14 | Cortland | New York | 36023 | 3750 | 60 |
1315110 | 1315110 | 2021-05-13 | Cortland | New York | 36023 | 3728 | 60 |
1311864 | 1311864 | 2021-05-12 | Cortland | New York | 36023 | 3716 | 60 |
1308617 | 1308617 | 2021-05-11 | Cortland | New York | 36023 | 3710 | 60 |
1305371 | 1305371 | 2021-05-10 | Cortland | New York | 36023 | 3704 | 60 |
1302125 | 1302125 | 2021-05-09 | Cortland | New York | 36023 | 3702 | 60 |
1298877 | 1298877 | 2021-05-08 | Cortland | New York | 36023 | 3694 | 60 |
1295631 | 1295631 | 2021-05-07 | Cortland | New York | 36023 | 3679 | 60 |
1292385 | 1292385 | 2021-05-06 | Cortland | New York | 36023 | 3673 | 60 |
1289139 | 1289139 | 2021-05-05 | Cortland | New York | 36023 | 3663 | 60 |
1285893 | 1285893 | 2021-05-04 | Cortland | New York | 36023 | 3652 | 60 |
1282647 | 1282647 | 2021-05-03 | Cortland | New York | 36023 | 3643 | 60 |
1279400 | 1279400 | 2021-05-02 | Cortland | New York | 36023 | 3636 | 60 |
1276153 | 1276153 | 2021-05-01 | Cortland | New York | 36023 | 3624 | 60 |
1272906 | 1272906 | 2021-04-30 | Cortland | New York | 36023 | 3622 | 60 |
1269659 | 1269659 | 2021-04-29 | Cortland | New York | 36023 | 3619 | 60 |
1266412 | 1266412 | 2021-04-28 | Cortland | New York | 36023 | 3613 | 60 |
1263165 | 1263165 | 2021-04-27 | Cortland | New York | 36023 | 3603 | 60 |
1259918 | 1259918 | 2021-04-26 | Cortland | New York | 36023 | 3601 | 60 |
1256671 | 1256671 | 2021-04-25 | Cortland | New York | 36023 | 3599 | 60 |
1253424 | 1253424 | 2021-04-24 | Cortland | New York | 36023 | 3597 | 60 |
1250177 | 1250177 | 2021-04-23 | Cortland | New York | 36023 | 3588 | 60 |
1246930 | 1246930 | 2021-04-22 | Cortland | New York | 36023 | 3579 | 60 |
1243683 | 1243683 | 2021-04-21 | Cortland | New York | 36023 | 3569 | 60 |
1240436 | 1240436 | 2021-04-20 | Cortland | New York | 36023 | 3559 | 60 |
1237189 | 1237189 | 2021-04-19 | Cortland | New York | 36023 | 3553 | 60 |
1233942 | 1233942 | 2021-04-18 | Cortland | New York | 36023 | 3546 | 60 |
1230694 | 1230694 | 2021-04-17 | Cortland | New York | 36023 | 3537 | 60 |
1227446 | 1227446 | 2021-04-16 | Cortland | New York | 36023 | 3528 | 60 |
1224198 | 1224198 | 2021-04-15 | Cortland | New York | 36023 | 3522 | 60 |
1220951 | 1220951 | 2021-04-14 | Cortland | New York | 36023 | 3515 | 60 |
1217703 | 1217703 | 2021-04-13 | Cortland | New York | 36023 | 3507 | 60 |
1214455 | 1214455 | 2021-04-12 | Cortland | New York | 36023 | 3502 | 60 |
1211208 | 1211208 | 2021-04-11 | Cortland | New York | 36023 | 3493 | 60 |
1207959 | 1207959 | 2021-04-10 | Cortland | New York | 36023 | 3487 | 60 |
1204711 | 1204711 | 2021-04-09 | Cortland | New York | 36023 | 3482 | 60 |
1201463 | 1201463 | 2021-04-08 | Cortland | New York | 36023 | 3470 | 60 |
1198214 | 1198214 | 2021-04-07 | Cortland | New York | 36023 | 3457 | 60 |
1194965 | 1194965 | 2021-04-06 | Cortland | New York | 36023 | 3453 | 60 |
1191717 | 1191717 | 2021-04-05 | Cortland | New York | 36023 | 3446 | 60 |
1188468 | 1188468 | 2021-04-04 | Cortland | New York | 36023 | 3441 | 60 |
1185221 | 1185221 | 2021-04-03 | Cortland | New York | 36023 | 3434 | 60 |
1181974 | 1181974 | 2021-04-02 | Cortland | New York | 36023 | 3426 | 60 |
1178727 | 1178727 | 2021-04-01 | Cortland | New York | 36023 | 3418 | 60 |
1175480 | 1175480 | 2021-03-31 | Cortland | New York | 36023 | 3406 | 60 |
1172233 | 1172233 | 2021-03-30 | Cortland | New York | 36023 | 3399 | 60 |
1168986 | 1168986 | 2021-03-29 | Cortland | New York | 36023 | 3390 | 60 |
1165738 | 1165738 | 2021-03-28 | Cortland | New York | 36023 | 3383 | 60 |
1162490 | 1162490 | 2021-03-27 | Cortland | New York | 36023 | 3378 | 60 |
1159241 | 1159241 | 2021-03-26 | Cortland | New York | 36023 | 3372 | 60 |
1155994 | 1155994 | 2021-03-25 | Cortland | New York | 36023 | 3363 | 60 |
1152747 | 1152747 | 2021-03-24 | Cortland | New York | 36023 | 3356 | 60 |
1149500 | 1149500 | 2021-03-23 | Cortland | New York | 36023 | 3346 | 60 |
1146253 | 1146253 | 2021-03-22 | Cortland | New York | 36023 | 3342 | 60 |
1143006 | 1143006 | 2021-03-21 | Cortland | New York | 36023 | 3336 | 60 |
1139759 | 1139759 | 2021-03-20 | Cortland | New York | 36023 | 3329 | 60 |
1136513 | 1136513 | 2021-03-19 | Cortland | New York | 36023 | 3325 | 60 |
1133267 | 1133267 | 2021-03-18 | Cortland | New York | 36023 | 3321 | 60 |
1130019 | 1130019 | 2021-03-17 | Cortland | New York | 36023 | 3315 | 60 |
1126772 | 1126772 | 2021-03-16 | Cortland | New York | 36023 | 3309 | 60 |
1123526 | 1123526 | 2021-03-15 | Cortland | New York | 36023 | 3304 | 60 |
1120280 | 1120280 | 2021-03-14 | Cortland | New York | 36023 | 3301 | 60 |
1117033 | 1117033 | 2021-03-13 | Cortland | New York | 36023 | 3296 | 60 |
1113786 | 1113786 | 2021-03-12 | Cortland | New York | 36023 | 3282 | 60 |
1110540 | 1110540 | 2021-03-11 | Cortland | New York | 36023 | 3276 | 60 |
1107294 | 1107294 | 2021-03-10 | Cortland | New York | 36023 | 3265 | 60 |
1104048 | 1104048 | 2021-03-09 | Cortland | New York | 36023 | 3258 | 60 |
1100802 | 1100802 | 2021-03-08 | Cortland | New York | 36023 | 3250 | 60 |
1097556 | 1097556 | 2021-03-07 | Cortland | New York | 36023 | 3241 | 60 |
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);