Boston Police Field Interrogation and Observation (FIO) records, 2011 to 2025: sample notebook
A worked notebook for Boston Police Field Interrogation and Observation (FIO) records, 2011 to 2025, with 1 code cell and the output each one printed. On Scigantic it opens in a hosted JupyterLab with the dataset already mounted, so nothing is downloaded first.
- Provider
- City of Boston (Boston Police Department)
- License
- Open Data Commons Public Domain Dedication and License (PDDL) 1.0
- Format
- Parquet (in sampled files)
- Stored at
- Amazon S3, s3://scigantic-boston-open-data/bpd-fio (us-east-1)
- Access
- Free and public. No account with the data provider is needed.
The notebook
Boston Police Field Interrogation and Observation (FIO) records, 2011 to 2025
Field Interrogation, Observation, Frisk and Search encounters recorded by the Boston Police Department.
Nothing is mounted. This archive is served over the data.boston.gov API, so there are no files to browse — the cell below fetches the data over the network.
import json, urllib.parse, urllib.request
import pandas as pd
# boston-police-department-fio.csv — 152,230 rows
RESOURCE = "c696738d-2625-4337-8c50-123c2a85fbad"
url = "https://data.boston.gov/api/3/action/datastore_search?" + urllib.parse.urlencode(
{"resource_id": RESOURCE, "limit": 100}
)
with urllib.request.urlopen(url, timeout=120) as r:
df = pd.DataFrame(json.load(r)["result"]["records"])
print(df.shape)
df.head()
Next
- limit is capped at 32,000 per request. This dataset has 152,230 rows, so aggregate server-side rather than pulling it all.
- Most columns come back as text even when they hold numbers or dates — cast before you compare or total.
- Ask the AI panel on the right for a query. It already has this dataset's full schema card, including the other resources and the traps.
- Source: https://data.boston.gov/dataset/boston-police-department-fio
Run it
Open this notebook to run it, see the dataset page for the full description, or browse the full catalog.