ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 36115 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 |
---|---|---|---|---|---|---|---|
1419027 | 1419027 | 2021-06-14 | Washington | New York | 36115 | 3161 | 55 |
1415782 | 1415782 | 2021-06-13 | Washington | New York | 36115 | 3159 | 55 |
1412536 | 1412536 | 2021-06-12 | Washington | New York | 36115 | 3159 | 55 |
1409291 | 1409291 | 2021-06-11 | Washington | New York | 36115 | 3159 | 55 |
1406046 | 1406046 | 2021-06-10 | Washington | New York | 36115 | 3155 | 55 |
1402800 | 1402800 | 2021-06-09 | Washington | New York | 36115 | 3152 | 55 |
1399555 | 1399555 | 2021-06-08 | Washington | New York | 36115 | 3150 | 55 |
1396310 | 1396310 | 2021-06-07 | Washington | New York | 36115 | 3147 | 55 |
1393063 | 1393063 | 2021-06-06 | Washington | New York | 36115 | 3147 | 55 |
1389818 | 1389818 | 2021-06-05 | Washington | New York | 36115 | 3146 | 55 |
1386573 | 1386573 | 2021-06-04 | Washington | New York | 36115 | 3142 | 55 |
1383328 | 1383328 | 2021-06-03 | Washington | New York | 36115 | 3142 | 55 |
1380082 | 1380082 | 2021-06-02 | Washington | New York | 36115 | 3141 | 55 |
1376837 | 1376837 | 2021-06-01 | Washington | New York | 36115 | 3138 | 55 |
1373591 | 1373591 | 2021-05-31 | Washington | New York | 36115 | 3136 | 55 |
1370346 | 1370346 | 2021-05-30 | Washington | New York | 36115 | 3136 | 55 |
1367100 | 1367100 | 2021-05-29 | Washington | New York | 36115 | 3130 | 55 |
1363854 | 1363854 | 2021-05-28 | Washington | New York | 36115 | 3127 | 55 |
1360608 | 1360608 | 2021-05-27 | Washington | New York | 36115 | 3125 | 55 |
1357362 | 1357362 | 2021-05-26 | Washington | New York | 36115 | 3119 | 55 |
1354116 | 1354116 | 2021-05-25 | Washington | New York | 36115 | 3117 | 55 |
1350870 | 1350870 | 2021-05-24 | Washington | New York | 36115 | 3116 | 55 |
1347624 | 1347624 | 2021-05-23 | Washington | New York | 36115 | 3115 | 55 |
1344376 | 1344376 | 2021-05-22 | Washington | New York | 36115 | 3112 | 55 |
1341128 | 1341128 | 2021-05-21 | Washington | New York | 36115 | 3106 | 55 |
1337880 | 1337880 | 2021-05-20 | Washington | New York | 36115 | 3104 | 55 |
1334633 | 1334633 | 2021-05-19 | Washington | New York | 36115 | 3101 | 55 |
1331386 | 1331386 | 2021-05-18 | Washington | New York | 36115 | 3095 | 55 |
1328139 | 1328139 | 2021-05-17 | Washington | New York | 36115 | 3095 | 55 |
1324893 | 1324893 | 2021-05-16 | Washington | New York | 36115 | 3091 | 55 |
1321647 | 1321647 | 2021-05-15 | Washington | New York | 36115 | 3085 | 55 |
1318401 | 1318401 | 2021-05-14 | Washington | New York | 36115 | 3075 | 55 |
1315153 | 1315153 | 2021-05-13 | Washington | New York | 36115 | 3073 | 55 |
1311907 | 1311907 | 2021-05-12 | Washington | New York | 36115 | 3064 | 55 |
1308660 | 1308660 | 2021-05-11 | Washington | New York | 36115 | 3055 | 55 |
1305414 | 1305414 | 2021-05-10 | Washington | New York | 36115 | 3048 | 55 |
1302168 | 1302168 | 2021-05-09 | Washington | New York | 36115 | 3040 | 55 |
1298920 | 1298920 | 2021-05-08 | Washington | New York | 36115 | 3037 | 55 |
1295674 | 1295674 | 2021-05-07 | Washington | New York | 36115 | 3027 | 55 |
1292428 | 1292428 | 2021-05-06 | Washington | New York | 36115 | 3016 | 55 |
1289182 | 1289182 | 2021-05-05 | Washington | New York | 36115 | 3011 | 55 |
1285936 | 1285936 | 2021-05-04 | Washington | New York | 36115 | 2994 | 55 |
1282690 | 1282690 | 2021-05-03 | Washington | New York | 36115 | 2983 | 55 |
1279443 | 1279443 | 2021-05-02 | Washington | New York | 36115 | 2981 | 55 |
1276196 | 1276196 | 2021-05-01 | Washington | New York | 36115 | 2973 | 55 |
1272949 | 1272949 | 2021-04-30 | Washington | New York | 36115 | 2962 | 55 |
1269702 | 1269702 | 2021-04-29 | Washington | New York | 36115 | 2946 | 55 |
1266455 | 1266455 | 2021-04-28 | Washington | New York | 36115 | 2933 | 55 |
1263208 | 1263208 | 2021-04-27 | Washington | New York | 36115 | 2927 | 55 |
1259961 | 1259961 | 2021-04-26 | Washington | New York | 36115 | 2924 | 55 |
1256714 | 1256714 | 2021-04-25 | Washington | New York | 36115 | 2921 | 55 |
1253467 | 1253467 | 2021-04-24 | Washington | New York | 36115 | 2915 | 55 |
1250220 | 1250220 | 2021-04-23 | Washington | New York | 36115 | 2900 | 56 |
1246973 | 1246973 | 2021-04-22 | Washington | New York | 36115 | 2892 | 55 |
1243726 | 1243726 | 2021-04-21 | Washington | New York | 36115 | 2879 | 55 |
1240479 | 1240479 | 2021-04-20 | Washington | New York | 36115 | 2870 | 55 |
1237232 | 1237232 | 2021-04-19 | Washington | New York | 36115 | 2867 | 55 |
1233985 | 1233985 | 2021-04-18 | Washington | New York | 36115 | 2857 | 55 |
1230737 | 1230737 | 2021-04-17 | Washington | New York | 36115 | 2847 | 55 |
1227489 | 1227489 | 2021-04-16 | Washington | New York | 36115 | 2840 | 55 |
1224241 | 1224241 | 2021-04-15 | Washington | New York | 36115 | 2826 | 55 |
1220994 | 1220994 | 2021-04-14 | Washington | New York | 36115 | 2813 | 55 |
1217746 | 1217746 | 2021-04-13 | Washington | New York | 36115 | 2803 | 55 |
1214498 | 1214498 | 2021-04-12 | Washington | New York | 36115 | 2795 | 55 |
1211251 | 1211251 | 2021-04-11 | Washington | New York | 36115 | 2792 | 55 |
1208002 | 1208002 | 2021-04-10 | Washington | New York | 36115 | 2789 | 55 |
1204754 | 1204754 | 2021-04-09 | Washington | New York | 36115 | 2779 | 55 |
1201506 | 1201506 | 2021-04-08 | Washington | New York | 36115 | 2768 | 55 |
1198257 | 1198257 | 2021-04-07 | Washington | New York | 36115 | 2755 | 55 |
1195008 | 1195008 | 2021-04-06 | Washington | New York | 36115 | 2739 | 55 |
1191760 | 1191760 | 2021-04-05 | Washington | New York | 36115 | 2733 | 55 |
1188511 | 1188511 | 2021-04-04 | Washington | New York | 36115 | 2725 | 55 |
1185264 | 1185264 | 2021-04-03 | Washington | New York | 36115 | 2714 | 55 |
1182017 | 1182017 | 2021-04-02 | Washington | New York | 36115 | 2708 | 55 |
1178770 | 1178770 | 2021-04-01 | Washington | New York | 36115 | 2691 | 55 |
1175523 | 1175523 | 2021-03-31 | Washington | New York | 36115 | 2676 | 55 |
1172276 | 1172276 | 2021-03-30 | Washington | New York | 36115 | 2664 | 55 |
1169029 | 1169029 | 2021-03-29 | Washington | New York | 36115 | 2647 | 55 |
1165781 | 1165781 | 2021-03-28 | Washington | New York | 36115 | 2637 | 55 |
1162533 | 1162533 | 2021-03-27 | Washington | New York | 36115 | 2620 | 55 |
1159284 | 1159284 | 2021-03-26 | Washington | New York | 36115 | 2590 | 54 |
1156037 | 1156037 | 2021-03-25 | Washington | New York | 36115 | 2582 | 54 |
1152790 | 1152790 | 2021-03-24 | Washington | New York | 36115 | 2569 | 54 |
1149543 | 1149543 | 2021-03-23 | Washington | New York | 36115 | 2557 | 54 |
1146296 | 1146296 | 2021-03-22 | Washington | New York | 36115 | 2538 | 54 |
1143049 | 1143049 | 2021-03-21 | Washington | New York | 36115 | 2531 | 54 |
1139802 | 1139802 | 2021-03-20 | Washington | New York | 36115 | 2515 | 54 |
1136556 | 1136556 | 2021-03-19 | Washington | New York | 36115 | 2507 | 54 |
1133310 | 1133310 | 2021-03-18 | Washington | New York | 36115 | 2501 | 54 |
1130062 | 1130062 | 2021-03-17 | Washington | New York | 36115 | 2493 | 54 |
1126815 | 1126815 | 2021-03-16 | Washington | New York | 36115 | 2482 | 54 |
1123569 | 1123569 | 2021-03-15 | Washington | New York | 36115 | 2471 | 54 |
1120323 | 1120323 | 2021-03-14 | Washington | New York | 36115 | 2464 | 54 |
1117076 | 1117076 | 2021-03-13 | Washington | New York | 36115 | 2460 | 54 |
1113829 | 1113829 | 2021-03-12 | Washington | New York | 36115 | 2448 | 54 |
1110583 | 1110583 | 2021-03-11 | Washington | New York | 36115 | 2435 | 54 |
1107337 | 1107337 | 2021-03-10 | Washington | New York | 36115 | 2426 | 54 |
1104091 | 1104091 | 2021-03-09 | Washington | New York | 36115 | 2418 | 54 |
1100845 | 1100845 | 2021-03-08 | Washington | New York | 36115 | 2412 | 54 |
1097599 | 1097599 | 2021-03-07 | Washington | New York | 36115 | 2406 | 54 |
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);