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

Run it

Open this notebook to run it, see the dataset page for the full description, or browse the full catalog.