DataSF

Returns 200 monthly SFO passenger counts broken out by operating and published airline, IATA code, domestic/international geo summary and region, enplaned/deplaned/in-transit activity type, price category, terminal and boarding area.

Returns the 200 most recently filed PermitSF records with record number and type, status detail, submitted/issued/completed/expiration dates, review durations in calendar and business days, parcel number and street address.

Returns the 200 most recently registered San Francisco business locations with ownership name, DBA name, full business address, registration certificate number, start and end dates and parking/transient-occupancy tax flags.

Returns the full Socrata view record for one dataset: title, description, attribution, licence, category, tags, update cadence, row count and every column with its field name, data type and description.

Searches the City and County of San Francisco open-data catalog and returns matching assets with their four-by-four dataset id, name, description, category, tags, owner, update time and row count.

Returns the 200 most recent eviction notices filed with the San Francisco Rent Board, each with address, ZIP, filing date and a boolean per statutory ground — non-payment, breach, nuisance, owner move-in, Ellis Act withdrawal, demolition, capital improvement and the rest.

Returns the 200 most recent San Francisco Fire Department incident records with incident number, address, alarm/arrival/close timestamps, battalion and station area, units and personnel committed, alarm count, primary situation, property use and casualty counts.

Returns the 200 most recent SFPD incident reports from 2018 onward, each with incident datetime, category and subcategory, description, resolution, report type, police district and neighborhood.

Runs an arbitrary SoQL statement against one DataSF dataset and returns the result rows — SELECT, WHERE, GROUP BY, ORDER BY, LIMIT and OFFSET are all expressed inside the statement.

Returns the first 200 rows of any DataSF dataset as a JSON array of objects keyed by column field name.

Returns the 200 most recent SF311 service requests, each with request id, opened and closed timestamps, status, service name and subtype, responsible agency, address, neighborhood, supervisor district and latitude/longitude.

Returns the 200 most recent San Francisco traffic collisions that caused injury, with collision datetime, primary and secondary street, severity, collision type, number killed and injured, weather, lighting, road condition, Vision Zero cause description, neighborhood and coordinates.