ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 36009 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 |
---|---|---|---|---|---|---|---|
1418977 | 1418977 | 2021-06-14 | Cattaraugus | New York | 36009 | 5720 | 91 |
1415732 | 1415732 | 2021-06-13 | Cattaraugus | New York | 36009 | 5720 | 91 |
1412486 | 1412486 | 2021-06-12 | Cattaraugus | New York | 36009 | 5719 | 91 |
1409241 | 1409241 | 2021-06-11 | Cattaraugus | New York | 36009 | 5718 | 91 |
1405996 | 1405996 | 2021-06-10 | Cattaraugus | New York | 36009 | 5718 | 91 |
1402750 | 1402750 | 2021-06-09 | Cattaraugus | New York | 36009 | 5717 | 91 |
1399505 | 1399505 | 2021-06-08 | Cattaraugus | New York | 36009 | 5716 | 90 |
1396260 | 1396260 | 2021-06-07 | Cattaraugus | New York | 36009 | 5716 | 90 |
1393013 | 1393013 | 2021-06-06 | Cattaraugus | New York | 36009 | 5716 | 90 |
1389768 | 1389768 | 2021-06-05 | Cattaraugus | New York | 36009 | 5715 | 89 |
1386523 | 1386523 | 2021-06-04 | Cattaraugus | New York | 36009 | 5712 | 89 |
1383278 | 1383278 | 2021-06-03 | Cattaraugus | New York | 36009 | 5709 | 89 |
1380032 | 1380032 | 2021-06-02 | Cattaraugus | New York | 36009 | 5707 | 89 |
1376787 | 1376787 | 2021-06-01 | Cattaraugus | New York | 36009 | 5702 | 89 |
1373541 | 1373541 | 2021-05-31 | Cattaraugus | New York | 36009 | 5702 | 89 |
1370296 | 1370296 | 2021-05-30 | Cattaraugus | New York | 36009 | 5702 | 89 |
1367050 | 1367050 | 2021-05-29 | Cattaraugus | New York | 36009 | 5694 | 89 |
1363804 | 1363804 | 2021-05-28 | Cattaraugus | New York | 36009 | 5686 | 89 |
1360558 | 1360558 | 2021-05-27 | Cattaraugus | New York | 36009 | 5684 | 89 |
1357312 | 1357312 | 2021-05-26 | Cattaraugus | New York | 36009 | 5678 | 89 |
1354066 | 1354066 | 2021-05-25 | Cattaraugus | New York | 36009 | 5672 | 89 |
1350820 | 1350820 | 2021-05-24 | Cattaraugus | New York | 36009 | 5671 | 89 |
1347574 | 1347574 | 2021-05-23 | Cattaraugus | New York | 36009 | 5668 | 88 |
1344326 | 1344326 | 2021-05-22 | Cattaraugus | New York | 36009 | 5668 | 88 |
1341078 | 1341078 | 2021-05-21 | Cattaraugus | New York | 36009 | 5665 | 88 |
1337830 | 1337830 | 2021-05-20 | Cattaraugus | New York | 36009 | 5653 | 88 |
1334583 | 1334583 | 2021-05-19 | Cattaraugus | New York | 36009 | 5643 | 88 |
1331336 | 1331336 | 2021-05-18 | Cattaraugus | New York | 36009 | 5625 | 88 |
1328089 | 1328089 | 2021-05-17 | Cattaraugus | New York | 36009 | 5620 | 88 |
1324843 | 1324843 | 2021-05-16 | Cattaraugus | New York | 36009 | 5612 | 87 |
1321597 | 1321597 | 2021-05-15 | Cattaraugus | New York | 36009 | 5600 | 87 |
1318351 | 1318351 | 2021-05-14 | Cattaraugus | New York | 36009 | 5574 | 87 |
1315103 | 1315103 | 2021-05-13 | Cattaraugus | New York | 36009 | 5559 | 87 |
1311857 | 1311857 | 2021-05-12 | Cattaraugus | New York | 36009 | 5539 | 87 |
1308610 | 1308610 | 2021-05-11 | Cattaraugus | New York | 36009 | 5526 | 87 |
1305364 | 1305364 | 2021-05-10 | Cattaraugus | New York | 36009 | 5516 | 86 |
1302118 | 1302118 | 2021-05-09 | Cattaraugus | New York | 36009 | 5509 | 86 |
1298870 | 1298870 | 2021-05-08 | Cattaraugus | New York | 36009 | 5496 | 86 |
1295624 | 1295624 | 2021-05-07 | Cattaraugus | New York | 36009 | 5465 | 86 |
1292378 | 1292378 | 2021-05-06 | Cattaraugus | New York | 36009 | 5460 | 85 |
1289132 | 1289132 | 2021-05-05 | Cattaraugus | New York | 36009 | 5444 | 85 |
1285886 | 1285886 | 2021-05-04 | Cattaraugus | New York | 36009 | 5433 | 85 |
1282640 | 1282640 | 2021-05-03 | Cattaraugus | New York | 36009 | 5422 | 84 |
1279393 | 1279393 | 2021-05-02 | Cattaraugus | New York | 36009 | 5411 | 84 |
1276146 | 1276146 | 2021-05-01 | Cattaraugus | New York | 36009 | 5399 | 84 |
1272899 | 1272899 | 2021-04-30 | Cattaraugus | New York | 36009 | 5374 | 84 |
1269652 | 1269652 | 2021-04-29 | Cattaraugus | New York | 36009 | 5339 | 84 |
1266405 | 1266405 | 2021-04-28 | Cattaraugus | New York | 36009 | 5314 | 83 |
1263158 | 1263158 | 2021-04-27 | Cattaraugus | New York | 36009 | 5293 | 83 |
1259911 | 1259911 | 2021-04-26 | Cattaraugus | New York | 36009 | 5281 | 83 |
1256664 | 1256664 | 2021-04-25 | Cattaraugus | New York | 36009 | 5270 | 82 |
1253417 | 1253417 | 2021-04-24 | Cattaraugus | New York | 36009 | 5260 | 82 |
1250170 | 1250170 | 2021-04-23 | Cattaraugus | New York | 36009 | 5244 | 82 |
1246923 | 1246923 | 2021-04-22 | Cattaraugus | New York | 36009 | 5231 | 82 |
1243676 | 1243676 | 2021-04-21 | Cattaraugus | New York | 36009 | 5213 | 82 |
1240429 | 1240429 | 2021-04-20 | Cattaraugus | New York | 36009 | 5194 | 82 |
1237182 | 1237182 | 2021-04-19 | Cattaraugus | New York | 36009 | 5180 | 81 |
1233935 | 1233935 | 2021-04-18 | Cattaraugus | New York | 36009 | 5169 | 81 |
1230687 | 1230687 | 2021-04-17 | Cattaraugus | New York | 36009 | 5148 | 81 |
1227439 | 1227439 | 2021-04-16 | Cattaraugus | New York | 36009 | 5111 | 81 |
1224191 | 1224191 | 2021-04-15 | Cattaraugus | New York | 36009 | 5098 | 80 |
1220944 | 1220944 | 2021-04-14 | Cattaraugus | New York | 36009 | 5068 | 80 |
1217696 | 1217696 | 2021-04-13 | Cattaraugus | New York | 36009 | 5037 | 80 |
1214448 | 1214448 | 2021-04-12 | Cattaraugus | New York | 36009 | 5015 | 80 |
1211201 | 1211201 | 2021-04-11 | Cattaraugus | New York | 36009 | 5002 | 80 |
1207952 | 1207952 | 2021-04-10 | Cattaraugus | New York | 36009 | 4985 | 79 |
1204704 | 1204704 | 2021-04-09 | Cattaraugus | New York | 36009 | 4966 | 79 |
1201456 | 1201456 | 2021-04-08 | Cattaraugus | New York | 36009 | 4945 | 79 |
1198207 | 1198207 | 2021-04-07 | Cattaraugus | New York | 36009 | 4923 | 79 |
1194958 | 1194958 | 2021-04-06 | Cattaraugus | New York | 36009 | 4903 | 79 |
1191710 | 1191710 | 2021-04-05 | Cattaraugus | New York | 36009 | 4897 | 79 |
1188461 | 1188461 | 2021-04-04 | Cattaraugus | New York | 36009 | 4877 | 79 |
1185214 | 1185214 | 2021-04-03 | Cattaraugus | New York | 36009 | 4861 | 79 |
1181967 | 1181967 | 2021-04-02 | Cattaraugus | New York | 36009 | 4845 | 79 |
1178720 | 1178720 | 2021-04-01 | Cattaraugus | New York | 36009 | 4827 | 79 |
1175473 | 1175473 | 2021-03-31 | Cattaraugus | New York | 36009 | 4813 | 79 |
1172226 | 1172226 | 2021-03-30 | Cattaraugus | New York | 36009 | 4792 | 79 |
1168979 | 1168979 | 2021-03-29 | Cattaraugus | New York | 36009 | 4761 | 79 |
1165731 | 1165731 | 2021-03-28 | Cattaraugus | New York | 36009 | 4746 | 79 |
1162483 | 1162483 | 2021-03-27 | Cattaraugus | New York | 36009 | 4734 | 79 |
1159234 | 1159234 | 2021-03-26 | Cattaraugus | New York | 36009 | 4712 | 79 |
1155987 | 1155987 | 2021-03-25 | Cattaraugus | New York | 36009 | 4699 | 79 |
1152740 | 1152740 | 2021-03-24 | Cattaraugus | New York | 36009 | 4683 | 79 |
1149493 | 1149493 | 2021-03-23 | Cattaraugus | New York | 36009 | 4669 | 79 |
1146246 | 1146246 | 2021-03-22 | Cattaraugus | New York | 36009 | 4654 | 79 |
1142999 | 1142999 | 2021-03-21 | Cattaraugus | New York | 36009 | 4649 | 79 |
1139752 | 1139752 | 2021-03-20 | Cattaraugus | New York | 36009 | 4639 | 79 |
1136506 | 1136506 | 2021-03-19 | Cattaraugus | New York | 36009 | 4626 | 79 |
1133260 | 1133260 | 2021-03-18 | Cattaraugus | New York | 36009 | 4623 | 79 |
1130012 | 1130012 | 2021-03-17 | Cattaraugus | New York | 36009 | 4607 | 79 |
1126765 | 1126765 | 2021-03-16 | Cattaraugus | New York | 36009 | 4589 | 79 |
1123519 | 1123519 | 2021-03-15 | Cattaraugus | New York | 36009 | 4575 | 79 |
1120273 | 1120273 | 2021-03-14 | Cattaraugus | New York | 36009 | 4562 | 79 |
1117026 | 1117026 | 2021-03-13 | Cattaraugus | New York | 36009 | 4552 | 79 |
1113779 | 1113779 | 2021-03-12 | Cattaraugus | New York | 36009 | 4548 | 79 |
1110533 | 1110533 | 2021-03-11 | Cattaraugus | New York | 36009 | 4528 | 78 |
1107287 | 1107287 | 2021-03-10 | Cattaraugus | New York | 36009 | 4518 | 77 |
1104041 | 1104041 | 2021-03-09 | Cattaraugus | New York | 36009 | 4507 | 77 |
1100795 | 1100795 | 2021-03-08 | Cattaraugus | New York | 36009 | 4500 | 77 |
1097549 | 1097549 | 2021-03-07 | Cattaraugus | New York | 36009 | 4499 | 77 |
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);