San Francisco Open Data - DataSF

Search hundreds of datasets from the City and County of San Francisco

Go to site
Explore
/
Apps
/
San Francisco Open Data - DataSF

San Francisco Open Data - DataSF API Integrations

Build and run workflows using the San Francisco Open Data - DataSF API. Use 1000s of open source triggers and actions across 500+ apps. Or write custom code to integrate any app or API in seconds.

// Below, we fetch a range of COVID-19 case data from DataSF. You can
// run this to see how the results are displayed on Pipedream, or modify it 
// in any way to fetch data from another dataset or modify the Socrata 
// query. See the docs below for Socrata docs and examples.

// COVID-19 Cases Summarized by Date, Transmission and Case Disposition
// https://dev.socrata.com/foundry/data.sfgov.org/tvq9-ec9w

return await require("@pipedreamhq/platform").axios(this, {
  url: `https://data.sfgov.org/resource/tvq9-ec9w.json`,
  headers: {
    "X-App-Token": `${auths.san_francisco_open_data_datasf.app_token}`,
  },
  params: {
    "$where": `date between '2020-05-18T00:00:00' and '2020-05-20T00:00:00'`,
  },
})

Authentication

San Francisco Open Data - DataSF uses API keys for authentication. When you connect your San Francisco Open Data - DataSF account, Pipedream securely stores the keys so you can easily authenticate to San Francisco Open Data - DataSF APIs in both code and no-code steps.

Sign up for a DataSF account, visit your Developer Settings, and click the button to Create New App Token under the App Tokens section.

Once you generate your app token, add it below.