home / n311

_locations

1,619 rows where category_id = 50976

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ward, active, added (date), removed (date)

Link rowid ▼ location latitude longitude category_id ward added removed active
148 148 11 HAWTHORN ST 42.358659 -71.203193 50976 1   2024-06-14 0
434 434 23 CONVERSE AVENUE 42.347964 -71.189564 50976 2 2024-06-14 2024-06-14 0
469 469 172 CONCORD ST 42.327844 -71.260921 50976 4 2024-06-14 2024-06-18 0
477 477 229 DUDLEY RD 42.31334 -71.181756 50976 8 2024-06-14 2024-06-14 0
478 478 52 PURITAN RD 42.327077 -71.216916 50976 5 2024-06-14 2024-06-17 0
480 480 222 WINSLOW RD 42.323467 -71.219285 50976 5 2024-06-14 2024-06-14 0
483 483 42 HAWTHORN ST 42.358372 -71.201854 50976 1 2024-06-14 2024-06-14 0
494 494 118 FORDHAM RD 42.358759 -71.225864 50976 3 2024-06-14 2024-06-17 0
495 495 144 HARWICH RD 42.306051 -71.170328 50976 8 2024-06-14 2024-06-14 0
496 496 244 ARNOLD RD 42.308314 -71.193521 50976 8 2024-06-14 2024-06-14 0
502 502 55 WHITE OAK RD 42.326858 -71.244803 50976 5 2024-06-14 2024-06-18 0
504 504 22 BEMIS ROAD 42.3627 -71.208385 50976 1 2024-06-14 2024-06-18 0
513 513 235 WABAN AVE 42.324657 -71.240941 50976 5 2024-06-15 2024-06-18 0
523 523 28 BROOKDALE RD 42.361472 -71.214936 50976 2 2024-06-15 2024-06-18 0
530 530 7 CENTRAL TERR 42.345622 -71.247342 50976 4 2024-06-16 2024-06-18 0
532 532 35 LANGDON ST 42.351039 -71.19323 50976 1 2024-06-16 2024-06-18 0
541 541 136 EDINBORO ST 42.356068 -71.213115 50976 2 2024-06-16 2024-06-25 0
543 543 165–217 BEETHOVEN AVE 42.325778 -71.220017 50976 5 2024-06-17 2024-06-18 0
544 544 75–199 LEWIS ST 42.351253 -71.193255 50976 1 2024-06-17 2024-06-18 0
552 552 178 BEETHOVEN AVE 42.32525 -71.219969 50976 5 2024-06-17 2024-06-18 0
553 553 245 WABAN AVE 42.324778 -71.241384 50976 5 2024-06-17 2024-06-18 0
558 558 14 CENTRAL TER 42.345291 -71.247305 50976 4 2024-06-17 2024-06-18 0
568 568 58 WALNUT PL 42.318625 -71.204593 50976 5 2024-06-17 2024-06-21 0
571 571 52 ASH ST 42.347071 -71.25087 50976 4 2024-06-17 2024-06-17 0
583 583 72 MANCHESTER RD 42.326986 -71.208146 50976 6 2024-06-17 2024-06-18 0
587 587 11 WOODBINE ST 42.346226 -71.251557 50976 4 2024-06-17 2024-06-20 0
603 603 4 SEVLAND RD 42.308629 -71.185492 50976 8 2024-06-17 2024-06-18 0
628 628 79 STANIFORD ST 42.353578 -71.248711 50976 4 2024-06-18 2024-06-20 0
632 632 2364 WASHINGTON ST 42.325365 -71.257753 50976 4 2024-06-18 2024-06-18 0
655 655 7 FREDANA RD 42.331817 -71.22717 50976 5 2024-06-18 2024-06-21 0
683 683 12 GARLAND RD 42.331253 -71.206141 50976 6 2024-06-18 2024-06-21 0
739 739 55 WOODBINE STREET 42.3467 -71.25353 50976 4 2024-06-19 2024-06-20 0
762 762 45 BISHOPSGATE RD 42.334516 -71.183476 50976 7 2024-06-20 2024-06-25 0
815 815 62 NORTH GATE PARK 42.355462 -71.226578 50976 3 2024-06-21 2024-06-25 0
817 817 160 EDINBORO ST 42.356883 -71.213131 50976 2 2024-06-21 2024-06-25 0
819 819 115 WARWICK RD 42.356031 -71.218064 50976 3 2024-06-21 2024-06-21 0
820 820 372 CHERRY ST 42.351803 -71.229193 50976 3 2024-06-21 2024-06-21 0
825 825 123 NORTH ST 42.363363 -71.218378 50976 3 2024-06-21 2024-06-21 0
826 826 541 GROVE ST 42.330933 -71.258187 50976 4 2024-06-21 2024-06-24 0
827 827 717 CENTRE ST 42.347283 -71.189267 50976 2 2024-06-21 2024-06-21 0
830 830 34 ALDERWOOD RD 42.340555 -71.190959 50976 7 2024-06-21 2024-06-21 0
831 831 73 RUSSELL RD 42.360693 -71.228725 50976 3 2024-06-21 2024-06-27 0
832 832 960 COMMONWEALTH AVE 42.338388 -71.206225 50976 2 2024-06-21 2024-06-21 0
836 836 131 WESTCHESTER ROAD 42.345813 -71.194163 50976 2 2024-06-21 2024-06-25 0
837 837 5 WILLARD STREET 42.357323 -71.176426 50976 1 2024-06-21 2024-06-21 0
841 841 54 HARDING ST 42.362041 -71.222228 50976 3 2024-06-21 2024-06-25 0
842 842 8 BROADLAWN PARK 42.304235 -71.166066 50976 8 2024-06-21 2024-06-25 0
846 846 2401 COMMONWEALTH AVENUE 42.344322 -71.260177 50976 4 2024-06-21 2024-06-27 0
847 847 CHARLESBANK PARK 42.357842 -71.183167 50976 1 2024-06-21 2024-06-25 0
849 849 11 HAWTHORN ST 42.358659 -71.203193 50976 1 2024-06-21 2024-07-17 0
852 852 88 LEWIS ST 42.351454 -71.193788 50976 1 2024-06-21 2024-06-27 0
854 854 244 FRANKLIN ST 42.350001 -71.18256 50976 7 2024-06-21 2024-06-21 0
855 855 6 HOLLAND ST 42.351253 -71.194899 50976 1 2024-06-21 2024-06-24 0
859 859 63 BLAKE ST 42.346124 -71.198433 50976 2 2024-06-21 2024-06-24 0
881 881 2 ABBOTT ST 42.307907 -71.218357 50976 5 2024-06-21 2024-06-24 0
895 895 59 ALLERTON ROAD 42.323891 -71.198568 50976 6 2024-06-22 2024-06-24 0
912 912 56 COTTON ST 42.342422 -71.185708 50976 7 2024-06-22 2024-06-24 0
913 913 59 ALLERTON RD 42.323926 -71.1984 50976 6 2024-06-22 2024-06-24 0
919 919 105 CARLTON ROAD 42.324657 -71.241785 50976 5 2024-06-22 2024-06-24 0
924 924 26 ATHELSTANE RD 42.322486 -71.195267 50976 6 2024-06-23 2024-06-24 0
928 928 438 ALBEMARLE RD 42.352393 -71.21481 50976 3 2024-06-23 2024-06-24 0
933 933 101–113 PARK AVE 42.342438 -71.185735 50976 7 2024-06-23 2024-06-24 0
935 935 9 HOLLAND ST 42.351193 -71.195378 50976 1 2024-06-23 2024-06-24 0
944 944 69 NEHOIDEN RD 42.325942 -71.23695 50976 5 2024-06-24 2024-06-24 0
949 949 106 WAVERLEY AVE 42.352118 -71.179664 50976 1 2024-06-24 2024-06-24 0
952 952 475 BOYLSTON ST 42.318964 -71.188418 50976 6 2024-06-24 2024-06-25 0
963 963 44 CARVER RD 42.322797 -71.217324 50976 5 2024-06-24 2024-06-24 0
967 967 89 DORCAR RD 42.300858 -71.175684 50976 8 2024-06-24 2024-06-24 0
979 979 50 SALISBURY RD 42.347876 -71.195967 50976 2 2024-06-24 2024-06-24 0
986 986 8 RIVER STREET 42.35155 -71.22702 50976 3 2024-06-24 2024-06-25 0
1010 1010 6 JUNIPER LN 42.307832 -71.186409 50976 8 2024-06-25 2024-06-25 0
1013 1013 6 JUNIPER LN 42.307832 -71.186409 50976 8 2024-06-25 2024-06-27 0
1023 1023 7 IPSWICH RD 42.326957 -71.208833 50976 6 2024-06-25 2024-06-25 0
1042 1042 27 MASON RD 42.336896 -71.197862 50976 6 2024-06-25 2024-06-27 0
1057 1057 117 WARREN ST 42.329644 -71.187235 50976 6 2024-06-25 2024-06-28 0
1116 1116 179 GREENWOOD ST 42.307222 -71.18788 50976 8 2024-06-26 2024-06-27 0
1133 1133 22 APPLETON CIR 42.298503 -71.188482 50976 8 2024-06-26 2024-06-27 0
1158 1158 31 WOODROW AVE 42.361934 -71.206492 50976 1 2024-06-26 2024-06-27 0
1171 1171 62 NORTH GATE PARK 42.355462 -71.226578 50976 3 2024-06-27 2024-06-28 0
1173 1173 27 FERNWOOD RD 42.350936 -71.23782 50976 3 2024-06-27 2024-06-27 0
1174 1174 17 LEE RD 42.331649 -71.167741 50976 7 2024-06-27 2024-06-27 0
1177 1177 74 CLEARWATER RD 42.334032 -71.259141 50976 4 2024-06-27 2024-06-27 0
1179 1179 5 MANHATTAN TER 42.35539 -71.229595 50976 3 2024-06-27 2024-06-27 0
1182 1182 20 GRANT ST 42.357946 -71.231113 50976 3 2024-06-27 2024-06-28 0
1183 1183 243 UPLAND RD 42.343643 -71.202521 50976 2 2024-06-27 2024-06-27 0
1184 1184 51 FAIR OAKS AVE 42.360035 -71.211129 50976 1 2024-06-27 2024-06-27 0
1185 1185 9 EDWARD RD 42.359197 -71.230985 50976 3 2024-06-27 2024-06-27 0
1190 1190 159 MOUNT VERNON ST 42.348742 -71.216534 50976 2 2024-06-27 2024-06-28 0
1191 1191 177 CHERRY ST 42.358166 -71.227485 50976 3 2024-06-27 2024-06-27 0
1192 1192 243 UPLAND AVE 42.343643 -71.202521 50976 2 2024-06-27 2024-06-27 0
1193 1193 44 PURITAN RD 42.326999 -71.216608 50976 5 2024-06-27 2024-06-27 0
1194 1194 53 HENSHAW ST 42.352557 -71.227806 50976 3 2024-06-27 2024-06-27 0
1195 1195 6 MANHATTAN TER 42.355446 -71.230028 50976 3 2024-06-27 2024-06-27 0
1199 1199 207 WALTHAM ST 42.359941 -71.222753 50976 3 2024-06-27 2024-06-28 0
1204 1204 33 ALEXANDER RD 42.316066 -71.199386 50976 6 2024-06-27 2024-06-27 0
1207 1207 55 CLOVERDALE RD 42.320414 -71.20045 50976 6 2024-06-27 2024-06-28 0
1213 1213 145 WARREN ST 42.329511 -71.188568 50976 6 2024-06-27 2024-06-28 0
1214 1214 1778 COMMONWEALTH AVE 42.341434 -71.239594 50976 4 2024-06-27 2024-06-28 0
1215 1215 32 FULLER TER 42.360294 -71.224131 50976 3 2024-06-27 2024-06-28 0
1218 1218 20 WILLIAM ST 42.356925 -71.236467 50976 4 2024-06-27 2024-06-28 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [_locations] (
   [location] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT,
   [category_id] TEXT REFERENCES [categories]([id]),
   [ward] INTEGER,
   [added] TEXT,
   [removed] TEXT,
   [active] INTEGER
);
Powered by Datasette · Queries took 455.248ms