ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
833 rows where fips = 25025 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921677 | 921677 | 2021-01-12 | Suffolk | Massachusetts | 25025 | 62241 | 1439 |
918432 | 918432 | 2021-01-11 | Suffolk | Massachusetts | 25025 | 61722 | 1430 |
915187 | 915187 | 2021-01-10 | Suffolk | Massachusetts | 25025 | 61178 | 1426 |
911942 | 911942 | 2021-01-09 | Suffolk | Massachusetts | 25025 | 60502 | 1415 |
908697 | 908697 | 2021-01-08 | Suffolk | Massachusetts | 25025 | 59640 | 1412 |
905451 | 905451 | 2021-01-07 | Suffolk | Massachusetts | 25025 | 58671 | 1406 |
902206 | 902206 | 2021-01-06 | Suffolk | Massachusetts | 25025 | 57742 | 1401 |
898961 | 898961 | 2021-01-05 | Suffolk | Massachusetts | 25025 | 56911 | 1395 |
895716 | 895716 | 2021-01-04 | Suffolk | Massachusetts | 25025 | 56431 | 1387 |
892469 | 892469 | 2021-01-03 | Suffolk | Massachusetts | 25025 | 55925 | 1382 |
889223 | 889223 | 2021-01-02 | Suffolk | Massachusetts | 25025 | 55575 | 1377 |
885977 | 885977 | 2021-01-01 | Suffolk | Massachusetts | 25025 | 54556 | 1374 |
882732 | 882732 | 2020-12-31 | Suffolk | Massachusetts | 25025 | 54556 | 1374 |
879487 | 879487 | 2020-12-30 | Suffolk | Massachusetts | 25025 | 53695 | 1369 |
876242 | 876242 | 2020-12-29 | Suffolk | Massachusetts | 25025 | 53046 | 1361 |
872997 | 872997 | 2020-12-28 | Suffolk | Massachusetts | 25025 | 52598 | 1357 |
869752 | 869752 | 2020-12-27 | Suffolk | Massachusetts | 25025 | 52079 | 1352 |
866507 | 866507 | 2020-12-26 | Suffolk | Massachusetts | 25025 | 51663 | 1343 |
863262 | 863262 | 2020-12-25 | Suffolk | Massachusetts | 25025 | 50653 | 1341 |
860017 | 860017 | 2020-12-24 | Suffolk | Massachusetts | 25025 | 50653 | 1341 |
856772 | 856772 | 2020-12-23 | Suffolk | Massachusetts | 25025 | 50032 | 1332 |
853527 | 853527 | 2020-12-22 | Suffolk | Massachusetts | 25025 | 49518 | 1325 |
850282 | 850282 | 2020-12-21 | Suffolk | Massachusetts | 25025 | 49082 | 1320 |
847037 | 847037 | 2020-12-20 | Suffolk | Massachusetts | 25025 | 48654 | 1315 |
843791 | 843791 | 2020-12-19 | Suffolk | Massachusetts | 25025 | 48181 | 1312 |
840546 | 840546 | 2020-12-18 | Suffolk | Massachusetts | 25025 | 47701 | 1310 |
837301 | 837301 | 2020-12-17 | Suffolk | Massachusetts | 25025 | 47013 | 1310 |
834055 | 834055 | 2020-12-16 | Suffolk | Massachusetts | 25025 | 46365 | 1309 |
830808 | 830808 | 2020-12-15 | Suffolk | Massachusetts | 25025 | 45642 | 1306 |
827562 | 827562 | 2020-12-14 | Suffolk | Massachusetts | 25025 | 45188 | 1298 |
824315 | 824315 | 2020-12-13 | Suffolk | Massachusetts | 25025 | 44631 | 1298 |
821069 | 821069 | 2020-12-12 | Suffolk | Massachusetts | 25025 | 43986 | 1296 |
817823 | 817823 | 2020-12-11 | Suffolk | Massachusetts | 25025 | 43396 | 1294 |
814577 | 814577 | 2020-12-10 | Suffolk | Massachusetts | 25025 | 42667 | 1291 |
811332 | 811332 | 2020-12-09 | Suffolk | Massachusetts | 25025 | 42036 | 1288 |
808087 | 808087 | 2020-12-08 | Suffolk | Massachusetts | 25025 | 41487 | 1278 |
804842 | 804842 | 2020-12-07 | Suffolk | Massachusetts | 25025 | 40982 | 1276 |
801597 | 801597 | 2020-12-06 | Suffolk | Massachusetts | 25025 | 40646 | 1275 |
798352 | 798352 | 2020-12-05 | Suffolk | Massachusetts | 25025 | 40045 | 1273 |
795107 | 795107 | 2020-12-04 | Suffolk | Massachusetts | 25025 | 39360 | 1266 |
791862 | 791862 | 2020-12-03 | Suffolk | Massachusetts | 25025 | 38648 | 1261 |
788617 | 788617 | 2020-12-02 | Suffolk | Massachusetts | 25025 | 37821 | 1256 |
785372 | 785372 | 2020-12-01 | Suffolk | Massachusetts | 25025 | 37318 | 1250 |
782128 | 782128 | 2020-11-30 | Suffolk | Massachusetts | 25025 | 36959 | 1248 |
778882 | 778882 | 2020-11-29 | Suffolk | Massachusetts | 25025 | 36836 | 1246 |
775637 | 775637 | 2020-11-28 | Suffolk | Massachusetts | 25025 | 36516 | 1239 |
772392 | 772392 | 2020-11-27 | Suffolk | Massachusetts | 25025 | 36276 | 1234 |
769147 | 769147 | 2020-11-26 | Suffolk | Massachusetts | 25025 | 35687 | 1231 |
765901 | 765901 | 2020-11-25 | Suffolk | Massachusetts | 25025 | 35687 | 1231 |
762656 | 762656 | 2020-11-24 | Suffolk | Massachusetts | 25025 | 35362 | 1228 |
759411 | 759411 | 2020-11-23 | Suffolk | Massachusetts | 25025 | 35124 | 1227 |
756164 | 756164 | 2020-11-22 | Suffolk | Massachusetts | 25025 | 34870 | 1225 |
752918 | 752918 | 2020-11-21 | Suffolk | Massachusetts | 25025 | 34584 | 1224 |
749672 | 749672 | 2020-11-20 | Suffolk | Massachusetts | 25025 | 34270 | 1224 |
746426 | 746426 | 2020-11-19 | Suffolk | Massachusetts | 25025 | 33994 | 1218 |
743179 | 743179 | 2020-11-18 | Suffolk | Massachusetts | 25025 | 33695 | 1215 |
739932 | 739932 | 2020-11-17 | Suffolk | Massachusetts | 25025 | 33366 | 1210 |
736688 | 736688 | 2020-11-16 | Suffolk | Massachusetts | 25025 | 33106 | 1209 |
733442 | 733442 | 2020-11-15 | Suffolk | Massachusetts | 25025 | 32792 | 1208 |
730197 | 730197 | 2020-11-14 | Suffolk | Massachusetts | 25025 | 32561 | 1205 |
726954 | 726954 | 2020-11-13 | Suffolk | Massachusetts | 25025 | 32188 | 1204 |
723711 | 723711 | 2020-11-12 | Suffolk | Massachusetts | 25025 | 31791 | 1203 |
720468 | 720468 | 2020-11-11 | Suffolk | Massachusetts | 25025 | 31454 | 1201 |
717225 | 717225 | 2020-11-10 | Suffolk | Massachusetts | 25025 | 31158 | 1201 |
713981 | 713981 | 2020-11-09 | Suffolk | Massachusetts | 25025 | 30857 | 1201 |
710737 | 710737 | 2020-11-08 | Suffolk | Massachusetts | 25025 | 30677 | 1198 |
707493 | 707493 | 2020-11-07 | Suffolk | Massachusetts | 25025 | 30359 | 1193 |
704250 | 704250 | 2020-11-06 | Suffolk | Massachusetts | 25025 | 30062 | 1191 |
701008 | 701008 | 2020-11-05 | Suffolk | Massachusetts | 25025 | 29726 | 1189 |
697764 | 697764 | 2020-11-04 | Suffolk | Massachusetts | 25025 | 29474 | 1187 |
694521 | 694521 | 2020-11-03 | Suffolk | Massachusetts | 25025 | 29269 | 1184 |
691279 | 691279 | 2020-11-02 | Suffolk | Massachusetts | 25025 | 29166 | 1184 |
688034 | 688034 | 2020-11-01 | Suffolk | Massachusetts | 25025 | 29031 | 1183 |
684790 | 684790 | 2020-10-31 | Suffolk | Massachusetts | 25025 | 28851 | 1181 |
681547 | 681547 | 2020-10-30 | Suffolk | Massachusetts | 25025 | 28660 | 1180 |
678303 | 678303 | 2020-10-29 | Suffolk | Massachusetts | 25025 | 28400 | 1177 |
675061 | 675061 | 2020-10-28 | Suffolk | Massachusetts | 25025 | 28152 | 1173 |
671818 | 671818 | 2020-10-27 | Suffolk | Massachusetts | 25025 | 27992 | 1171 |
668576 | 668576 | 2020-10-26 | Suffolk | Massachusetts | 25025 | 27823 | 1171 |
665332 | 665332 | 2020-10-25 | Suffolk | Massachusetts | 25025 | 27571 | 1169 |
662087 | 662087 | 2020-10-24 | Suffolk | Massachusetts | 25025 | 27346 | 1168 |
658843 | 658843 | 2020-10-23 | Suffolk | Massachusetts | 25025 | 27180 | 1168 |
655598 | 655598 | 2020-10-22 | Suffolk | Massachusetts | 25025 | 26954 | 1166 |
652353 | 652353 | 2020-10-21 | Suffolk | Massachusetts | 25025 | 26787 | 1163 |
649108 | 649108 | 2020-10-20 | Suffolk | Massachusetts | 25025 | 26663 | 1161 |
645864 | 645864 | 2020-10-19 | Suffolk | Massachusetts | 25025 | 26546 | 1160 |
642617 | 642617 | 2020-10-18 | Suffolk | Massachusetts | 25025 | 26383 | 1156 |
639370 | 639370 | 2020-10-17 | Suffolk | Massachusetts | 25025 | 26250 | 1156 |
636124 | 636124 | 2020-10-16 | Suffolk | Massachusetts | 25025 | 26160 | 1155 |
632878 | 632878 | 2020-10-15 | Suffolk | Massachusetts | 25025 | 26012 | 1153 |
629633 | 629633 | 2020-10-14 | Suffolk | Massachusetts | 25025 | 25896 | 1150 |
626389 | 626389 | 2020-10-13 | Suffolk | Massachusetts | 25025 | 25824 | 1148 |
623147 | 623147 | 2020-10-12 | Suffolk | Massachusetts | 25025 | 25702 | 1147 |
619904 | 619904 | 2020-10-11 | Suffolk | Massachusetts | 25025 | 25562 | 1147 |
616662 | 616662 | 2020-10-10 | Suffolk | Massachusetts | 25025 | 25497 | 1145 |
613421 | 613421 | 2020-10-09 | Suffolk | Massachusetts | 25025 | 25382 | 1144 |
610179 | 610179 | 2020-10-08 | Suffolk | Massachusetts | 25025 | 25273 | 1143 |
606937 | 606937 | 2020-10-07 | Suffolk | Massachusetts | 25025 | 25200 | 1143 |
603694 | 603694 | 2020-10-06 | Suffolk | Massachusetts | 25025 | 25117 | 1142 |
600452 | 600452 | 2020-10-05 | Suffolk | Massachusetts | 25025 | 25052 | 1142 |
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);