Boston Food Establishment Inspections and Active Licenses: sample notebook
A worked notebook for Boston Food Establishment Inspections and Active Licenses, 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 (Inspectional Services Department, Health Division)
- License
- Open Data Commons Public Domain Dedication and License (PDDL) 1.0
- Size
- 2 files
- Stored at
- data.boston.gov
- Access
- Free and public. No account with the data provider is needed.
The notebook
Boston Food Establishment Inspections and Active Licenses
A row is one VIOLATION cited at one inspection.
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
# Food Establishment Inspections — 896,379 rows
RESOURCE = "4582bec6-2b4f-4f9e-bc55-cbaa73117f4c"
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 896,379 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/food-establishment-inspections
Run it
Open this notebook to run it, see the dataset page for the full description, or browse the full catalog.