Boston Safety Data

311 calls reported to the city of Boston.

Refer to this link to learn more about BOS:311.

Note

Microsoft provides Azure Open Datasets on an “as is” basis. Microsoft makes no warranties, express or implied, guarantees or conditions with respect to your use of the datasets. To the extent permitted under your local law, Microsoft disclaims all liability for any damages or losses, including direct, consequential, special, indirect, incidental or punitive, resulting from your use of the datasets.

This dataset is provided under the original terms that Microsoft received source data. The dataset may include data sourced from Microsoft.

Volume and retention

This dataset is stored in Parquet format. It is updated daily, and contains about 100-K rows (10 MB) in total as of 2019.

This dataset contains historical records accumulated from 2011 to the present. You can use parameter settings in our SDK to fetch data within a specific time range.

Storage location

This dataset is stored in the East US Azure region. Allocating compute resources in East US is recommended for affinity.

Additional information

This dataset is sourced from city of Boston government. For more information, see Boston's dataset site. For dataset licensing, see Open Data Commons Public Domain Dedication and License (ODC PDDL).

Columns

Name Data type Unique Values (sample) Description
address string 140,612 " " 1 City Hall Plz Boston MA 02108 Location.
category string 54 Street Cleaning Sanitation Reason of the service request.
dataSubtype string 1 311_All “311_All”
dataType string 1 Safety “Safety”
dateTime timestamp 1,529,075 2015-07-23 10:51:00 2015-07-23 10:47:00 Open date and time of the service request.
latitude double 1,622 42.3594 42.3603 This is the latitude value. Lines of latitude are parallel to the equator.
longitude double 1,806 -71.0587 -71.0583 This is the longitude value. Lines of longitude run perpendicular to lines of latitude, and all pass through both poles.
source string 7 Constituent Call Citizens Connect App Original source of the case.
status string 2 Closed Open Case status.
subcategory string 209 Parking Enforcement Requests for Street Cleaning Type of the service request.

Preview

ataType dataSubtype dateTime category subcategory status address latitude longitude source extendedProperties
Safety 311_All 4/27/2021 11:45:49 PM Enforcement & Abandoned Vehicles Parking Enforcement Open 51 Gardner St Allston MA 02134 42.3535 -71.1285 Citizens Connect App
Safety 311_All 4/27/2021 11:43:43 PM Sanitation Missed Trash/Recycling/Yard Waste/Bulk Item Open 4 Putnam Pl Roxbury MA 02119 42.3298 -71.0883 Self Service
Safety 311_All 4/27/2021 11:37:19 PM Enforcement & Abandoned Vehicles Parking Enforcement Open 36 Raven St Dorchester MA 02125 42.3177 -71.0546 Citizens Connect App
Safety 311_All 4/27/2021 11:30:00 PM Sanitation Missed Trash/Recycling/Yard Waste/Bulk Item Open 58 Bicknell St Dorchester MA 02121 42.2984 -71.0834 Constituent Call
Safety 311_All 4/27/2021 11:10:20 PM Enforcement & Abandoned Vehicles Parking Enforcement Open 2000 Commonwealth Ave Brighton MA 02135 42.3394 -71.1585 Citizens Connect App
Safety 311_All 4/27/2021 11:06:00 PM Noise Disturbance Loud Parties/Music/People Open INTERSECTION of Lewis St & North St Boston MA 42.3594 -71.0587 Constituent Call
Safety 311_All 4/27/2021 11:05:00 PM Enforcement & Abandoned Vehicles Parking Enforcement Open 1 Nassau St Boston MA 02111 42.3486 -71.0629 Constituent Call
Safety 311_All 4/27/2021 11:00:55 PM Code Enforcement Poor Conditions of Property Open 17 Mercer St South Boston MA 02127 42.3332 -71.0492 Citizens Connect App

Data access

Azure Notebooks

# This is a package in preview.
from azureml.opendatasets import BostonSafety

from datetime import datetime
from dateutil import parser

end_date = parser.parse('2016-01-01')
start_date = parser.parse('2015-05-01')
safety = BostonSafety(start_date=start_date, end_date=end_date)
safety = safety.to_pandas_dataframe()
safety.info()

Azure Databricks

# This is a package in preview.
# You need to pip install azureml-opendatasets in Databricks cluster. https://docs.microsoft.com/en-us/azure/data-explorer/connect-from-databricks#install-the-python-library-on-your-azure-databricks-cluster
from azureml.opendatasets import BostonSafety

from datetime import datetime
from dateutil import parser


end_date = parser.parse('2016-01-01')
start_date = parser.parse('2015-05-01')
safety = BostonSafety(start_date=start_date, end_date=end_date)
safety = safety.to_spark_dataframe()
display(safety)

Azure Synapse

from azureml.opendatasets import BostonSafety

from datetime import datetime
from dateutil import parser


end_date = parser.parse('2016-01-01')
start_date = parser.parse('2015-05-01')
safety = BostonSafety(start_date=start_date, end_date=end_date)
safety = safety.to_spark_dataframe()
display(safety)

Examples

Next steps

View the rest of the datasets in the Open Datasets catalog.