_locations
24 rows where category_id = 53465
This data as json, CSV (advanced)
Suggested facets: location, latitude, longitude, ward, added, removed, active, added (date), removed (date)
| Link | rowid ▼ | location | latitude | longitude | category_id | ward | added | removed | active |
|---|---|---|---|---|---|---|---|---|---|
| 3165 | 3165 | 515 CENTRE STREET | 42.353234 | -71.186466 | 53465 | 1 | 2024-07-26 08:00 | 2024-09-17 | 0 |
| 3806 | 3806 | 1025 WALNUT STREET | 42.326453 | -71.206357 | 53465 | 6 | 2024-08-07 12:00 | 2024-08-28 | 0 |
| 4255 | 4255 | 51 FLORENCE STREET | 42.318306 | -71.180103 | 53465 | 8 | 2024-08-13 08:00 | 2024-11-04 | 0 |
| 6222 | 6222 | 375 DUDLEY RD | 42.308856 | -71.181869 | 53465 | 8 | 2024-09-23 17:45 | 2024-09-25 | 0 |
| 8630 | 8630 | 15 CHAMPA ST | 42.313394 | -71.218434 | 53465 | 5 | 2024-10-29 08:30 | 2024-10-29 | 0 |
| 10477 | 10477 | 15 CHAMPA ST | 42.313381 | -71.218477 | 53465 | 5 | 2024-11-22 10:00 | 2025-04-08 | 0 |
| 12775 | 12775 | 17 ELIOT AVE | 42.353087 | -71.218176 | 53465 | 3 | 2025-01-07 11:15 | 2025-01-07 | 0 |
| 13700 | 13700 | 32 WASHINGTON PARK | 42.348928 | -71.202505 | 53465 | 2 | 2025-01-26 19:00 | 2025-02-25 | 0 |
| 16615 | 16615 | 50 CHARLESBANK RD | 42.358302 | -71.178444 | 53465 | 1 | 2025-03-20 17:00 | 2025-04-02 | 0 |
| 16616 | 16616 | 55 CHARLESBANK ROAD | 42.3584 | -71.178395 | 53465 | 1 | 2025-03-20 17:00 | 2025-04-02 | 0 |
| 18844 | 18844 | 236 TREMONT ST | 42.353352 | -71.17799 | 53465 | 1 | 2025-05-05 19:00 | 2025-05-06 | 0 |
| 19350 | 19350 | 117 FLORENCE ST | 42.31791 | -71.177013 | 53465 | 8 | 2025-05-14 08:00 | 1 | |
| 19351 | 19351 | 143 FLORENCE ST | 42.317811 | -71.175951 | 53465 | 8 | 2025-05-14 08:00 | 1 | |
| 19833 | 19833 | 231 MELROSE ST | 42.348564 | -71.249153 | 53465 | 4 | 2025-05-22 09:30 | 2025-05-23 | 0 |
| 20687 | 20687 | 375 DUDLEY RD | 42.308856 | -71.181869 | 53465 | 8 | 2025-06-04 14:45 | 2025-07-14 | 0 |
| 20889 | 20889 | 50 CHARLESBANK ROAD | 42.358383 | -71.178401 | 53465 | 1 | 2025-06-07 11:15 | 2025-07-10 | 0 |
| 21612 | 21612 | 11 WHEELER RD | 42.311592 | -71.196422 | 53465 | 8 | 2025-06-18 12:00 | 1 | |
| 23125 | 23125 | 51 OAK ST | 42.310899 | -71.221059 | 53465 | 5 | 2025-07-11 15:45 | 1 | |
| 23621 | 23621 | 50 CHARLESBANK RD | 42.358302 | -71.178444 | 53465 | 1 | 2025-07-17 16:45 | 2025-10-30 | 0 |
| 24165 | 24165 | 1000 COMMONWEALTH AVENUE | 42.336692 | -71.208835 | 53465 | 2 | 2025-07-26 16:15 | 1 | |
| 24414 | 24414 | 217 CRAFTS ST | 42.357384 | -71.208036 | 53465 | 1 | 2025-07-30 16:15 | 1 | |
| 26724 | 26724 | 320 LOWELL AVE | 42.346314 | -71.210777 | 53465 | 2 | 2025-09-15 11:45 | 1 | |
| 27275 | 27275 | 8 LOVETT RD | 42.300765 | -71.183808 | 53465 | 8 | 2025-09-25 11:00 | 1 | |
| 29336 | 29336 | 217 CRAFTS STREET | 42.357269 | -71.208224 | 53465 | 1 | 2025-11-04 17:30 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [_locations] ( [location] TEXT, [latitude] FLOAT, [longitude] FLOAT, [category_id] TEXT REFERENCES [categories]([id]), [ward] INTEGER, [added] TEXT, [removed] TEXT, [active] INTEGER );