lacity/restaurant-and-market-health-violations-ckya-qgys
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 3 years ago
Indexed 1 month ago

Restaurant and Market Health Violations

This dataset contains Environmental Health Inspection Results for Restaurants and Markets in the City of Los Angeles. Los Angeles County Environmental Health is responsible for inspections and enforcement activities for all unincorporated areas and 85 of the 88 cities in the County. This dataset combines some of the fields from the County's inspection and violation data, and is filtered to include only facilities in the City of Los Angeles. The full datasets can be found at the following urls:

https://data.lacounty.gov/Health/LOS-ANGELES-COUNTY-RESTAURANT-AND-MARKET-INSPECTIO/6ni6-h5kp

https://data.lacounty.gov/Health/LOS-ANGELES-COUNTY-RESTAURANT-AND-MARKET-VIOLATION/8jyd-4pv9

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"lacity/restaurant-and-market-health-violations-ckya-qgys\".\"restaurant_and_market_health_violations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • restaurant_and_market_health_violations
     
     
     
     
     
Upstream Metadata