ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 36049 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 |
---|---|---|---|---|---|---|---|
1418996 | 1418996 | 2021-06-14 | Lewis | New York | 36049 | 2808 | 36 |
1415751 | 1415751 | 2021-06-13 | Lewis | New York | 36049 | 2807 | 36 |
1412505 | 1412505 | 2021-06-12 | Lewis | New York | 36049 | 2805 | 36 |
1409260 | 1409260 | 2021-06-11 | Lewis | New York | 36049 | 2805 | 36 |
1406015 | 1406015 | 2021-06-10 | Lewis | New York | 36049 | 2803 | 36 |
1402769 | 1402769 | 2021-06-09 | Lewis | New York | 36049 | 2802 | 36 |
1399524 | 1399524 | 2021-06-08 | Lewis | New York | 36049 | 2801 | 36 |
1396279 | 1396279 | 2021-06-07 | Lewis | New York | 36049 | 2800 | 36 |
1393032 | 1393032 | 2021-06-06 | Lewis | New York | 36049 | 2800 | 36 |
1389787 | 1389787 | 2021-06-05 | Lewis | New York | 36049 | 2800 | 36 |
1386542 | 1386542 | 2021-06-04 | Lewis | New York | 36049 | 2795 | 36 |
1383297 | 1383297 | 2021-06-03 | Lewis | New York | 36049 | 2792 | 36 |
1380051 | 1380051 | 2021-06-02 | Lewis | New York | 36049 | 2790 | 36 |
1376806 | 1376806 | 2021-06-01 | Lewis | New York | 36049 | 2787 | 36 |
1373560 | 1373560 | 2021-05-31 | Lewis | New York | 36049 | 2786 | 36 |
1370315 | 1370315 | 2021-05-30 | Lewis | New York | 36049 | 2783 | 36 |
1367069 | 1367069 | 2021-05-29 | Lewis | New York | 36049 | 2783 | 36 |
1363823 | 1363823 | 2021-05-28 | Lewis | New York | 36049 | 2779 | 36 |
1360577 | 1360577 | 2021-05-27 | Lewis | New York | 36049 | 2773 | 36 |
1357331 | 1357331 | 2021-05-26 | Lewis | New York | 36049 | 2770 | 36 |
1354085 | 1354085 | 2021-05-25 | Lewis | New York | 36049 | 2767 | 35 |
1350839 | 1350839 | 2021-05-24 | Lewis | New York | 36049 | 2763 | 35 |
1347593 | 1347593 | 2021-05-23 | Lewis | New York | 36049 | 2760 | 35 |
1344345 | 1344345 | 2021-05-22 | Lewis | New York | 36049 | 2758 | 35 |
1341097 | 1341097 | 2021-05-21 | Lewis | New York | 36049 | 2755 | 35 |
1337849 | 1337849 | 2021-05-20 | Lewis | New York | 36049 | 2747 | 35 |
1334602 | 1334602 | 2021-05-19 | Lewis | New York | 36049 | 2736 | 34 |
1331355 | 1331355 | 2021-05-18 | Lewis | New York | 36049 | 2719 | 34 |
1328108 | 1328108 | 2021-05-17 | Lewis | New York | 36049 | 2716 | 34 |
1324862 | 1324862 | 2021-05-16 | Lewis | New York | 36049 | 2711 | 34 |
1321616 | 1321616 | 2021-05-15 | Lewis | New York | 36049 | 2707 | 34 |
1318370 | 1318370 | 2021-05-14 | Lewis | New York | 36049 | 2687 | 34 |
1315122 | 1315122 | 2021-05-13 | Lewis | New York | 36049 | 2676 | 34 |
1311876 | 1311876 | 2021-05-12 | Lewis | New York | 36049 | 2659 | 34 |
1308629 | 1308629 | 2021-05-11 | Lewis | New York | 36049 | 2655 | 34 |
1305383 | 1305383 | 2021-05-10 | Lewis | New York | 36049 | 2638 | 34 |
1302137 | 1302137 | 2021-05-09 | Lewis | New York | 36049 | 2634 | 34 |
1298889 | 1298889 | 2021-05-08 | Lewis | New York | 36049 | 2626 | 34 |
1295643 | 1295643 | 2021-05-07 | Lewis | New York | 36049 | 2607 | 34 |
1292397 | 1292397 | 2021-05-06 | Lewis | New York | 36049 | 2590 | 34 |
1289151 | 1289151 | 2021-05-05 | Lewis | New York | 36049 | 2580 | 34 |
1285905 | 1285905 | 2021-05-04 | Lewis | New York | 36049 | 2569 | 34 |
1282659 | 1282659 | 2021-05-03 | Lewis | New York | 36049 | 2566 | 34 |
1279412 | 1279412 | 2021-05-02 | Lewis | New York | 36049 | 2561 | 34 |
1276165 | 1276165 | 2021-05-01 | Lewis | New York | 36049 | 2557 | 34 |
1272918 | 1272918 | 2021-04-30 | Lewis | New York | 36049 | 2545 | 34 |
1269671 | 1269671 | 2021-04-29 | Lewis | New York | 36049 | 2540 | 34 |
1266424 | 1266424 | 2021-04-28 | Lewis | New York | 36049 | 2525 | 34 |
1263177 | 1263177 | 2021-04-27 | Lewis | New York | 36049 | 2518 | 34 |
1259930 | 1259930 | 2021-04-26 | Lewis | New York | 36049 | 2507 | 34 |
1256683 | 1256683 | 2021-04-25 | Lewis | New York | 36049 | 2504 | 34 |
1253436 | 1253436 | 2021-04-24 | Lewis | New York | 36049 | 2499 | 34 |
1250189 | 1250189 | 2021-04-23 | Lewis | New York | 36049 | 2494 | 34 |
1246942 | 1246942 | 2021-04-22 | Lewis | New York | 36049 | 2488 | 34 |
1243695 | 1243695 | 2021-04-21 | Lewis | New York | 36049 | 2481 | 34 |
1240448 | 1240448 | 2021-04-20 | Lewis | New York | 36049 | 2478 | 34 |
1237201 | 1237201 | 2021-04-19 | Lewis | New York | 36049 | 2461 | 34 |
1233954 | 1233954 | 2021-04-18 | Lewis | New York | 36049 | 2457 | 34 |
1230706 | 1230706 | 2021-04-17 | Lewis | New York | 36049 | 2453 | 34 |
1227458 | 1227458 | 2021-04-16 | Lewis | New York | 36049 | 2441 | 33 |
1224210 | 1224210 | 2021-04-15 | Lewis | New York | 36049 | 2432 | 33 |
1220963 | 1220963 | 2021-04-14 | Lewis | New York | 36049 | 2423 | 33 |
1217715 | 1217715 | 2021-04-13 | Lewis | New York | 36049 | 2420 | 33 |
1214467 | 1214467 | 2021-04-12 | Lewis | New York | 36049 | 2408 | 33 |
1211220 | 1211220 | 2021-04-11 | Lewis | New York | 36049 | 2406 | 33 |
1207971 | 1207971 | 2021-04-10 | Lewis | New York | 36049 | 2402 | 33 |
1204723 | 1204723 | 2021-04-09 | Lewis | New York | 36049 | 2391 | 33 |
1201475 | 1201475 | 2021-04-08 | Lewis | New York | 36049 | 2378 | 33 |
1198226 | 1198226 | 2021-04-07 | Lewis | New York | 36049 | 2371 | 33 |
1194977 | 1194977 | 2021-04-06 | Lewis | New York | 36049 | 2365 | 33 |
1191729 | 1191729 | 2021-04-05 | Lewis | New York | 36049 | 2358 | 33 |
1188480 | 1188480 | 2021-04-04 | Lewis | New York | 36049 | 2351 | 33 |
1185233 | 1185233 | 2021-04-03 | Lewis | New York | 36049 | 2345 | 33 |
1181986 | 1181986 | 2021-04-02 | Lewis | New York | 36049 | 2337 | 33 |
1178739 | 1178739 | 2021-04-01 | Lewis | New York | 36049 | 2332 | 33 |
1175492 | 1175492 | 2021-03-31 | Lewis | New York | 36049 | 2321 | 33 |
1172245 | 1172245 | 2021-03-30 | Lewis | New York | 36049 | 2311 | 33 |
1168998 | 1168998 | 2021-03-29 | Lewis | New York | 36049 | 2302 | 33 |
1165750 | 1165750 | 2021-03-28 | Lewis | New York | 36049 | 2285 | 33 |
1162502 | 1162502 | 2021-03-27 | Lewis | New York | 36049 | 2274 | 33 |
1159253 | 1159253 | 2021-03-26 | Lewis | New York | 36049 | 2257 | 33 |
1156006 | 1156006 | 2021-03-25 | Lewis | New York | 36049 | 2242 | 33 |
1152759 | 1152759 | 2021-03-24 | Lewis | New York | 36049 | 2233 | 33 |
1149512 | 1149512 | 2021-03-23 | Lewis | New York | 36049 | 2225 | 33 |
1146265 | 1146265 | 2021-03-22 | Lewis | New York | 36049 | 2212 | 33 |
1143018 | 1143018 | 2021-03-21 | Lewis | New York | 36049 | 2202 | 33 |
1139771 | 1139771 | 2021-03-20 | Lewis | New York | 36049 | 2200 | 33 |
1136525 | 1136525 | 2021-03-19 | Lewis | New York | 36049 | 2192 | 32 |
1133279 | 1133279 | 2021-03-18 | Lewis | New York | 36049 | 2181 | 32 |
1130031 | 1130031 | 2021-03-17 | Lewis | New York | 36049 | 2167 | 31 |
1126784 | 1126784 | 2021-03-16 | Lewis | New York | 36049 | 2156 | 31 |
1123538 | 1123538 | 2021-03-15 | Lewis | New York | 36049 | 2147 | 31 |
1120292 | 1120292 | 2021-03-14 | Lewis | New York | 36049 | 2144 | 31 |
1117045 | 1117045 | 2021-03-13 | Lewis | New York | 36049 | 2139 | 30 |
1113798 | 1113798 | 2021-03-12 | Lewis | New York | 36049 | 2128 | 30 |
1110552 | 1110552 | 2021-03-11 | Lewis | New York | 36049 | 2118 | 30 |
1107306 | 1107306 | 2021-03-10 | Lewis | New York | 36049 | 2114 | 30 |
1104060 | 1104060 | 2021-03-09 | Lewis | New York | 36049 | 2110 | 30 |
1100814 | 1100814 | 2021-03-08 | Lewis | New York | 36049 | 2107 | 30 |
1097568 | 1097568 | 2021-03-07 | Lewis | New York | 36049 | 2103 | 30 |
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);