Stack Overflow
Stack Overflow

Questions tagged [socrata]

Socrata is a company which provides government data services. Use this tag for questions about Socrata products, including the SODA API (http://dev.socrata.com/); and also indicate the Socrata product such as Data Portal, GovStat, or API Foundry. If your question is not closely related to programming, please consider asking your question on https://opendata.stackexchange.com.

Socrata is a company which provides government data services. From 2007 to 2009, it was known as Blist. Use this tag for questions about Socrata products, including the SODA API; and also indicate the Socrata product such as Data Portal, GovStat, or API Foundry.

235 questions
0
votes
1 answer

SoQL count query with Socrata API

I'm trying to count the unique number of case_numbers between 2014-02-27 and 2014-02-28 from the chicago crime database. The data source is here: http://data.cityofchicago.org/resource/ijzp-q8t2.json The API docs are…
dfriestedt
  • 483
  • 1
  • 3
  • 18
0
votes
2 answers

Importing data to Visual Basic from SODA

Sorry I am new to Visual Basic and SODA. I am trying to query/import data from http://data.cms.gov/resource/qcn7-gc3g.json into a VB project. For example if a user enters an NPI number, I would want the application to auto populate the first and…
tbat
  • 11
0
votes
1 answer

Socrata does it support startswith or endswidth on a column

Currently socrata only supports https://soda.demo.socrata.com/resource/4tka-6guv?region=Victoria Islands region&source=pr Is there an option to find the region's StartsWith Victoria?
user3789012
  • 1
0
votes
1 answer

SoQL Clause using starts with

Is there a way to use STARTS WITH operator when writing a query string for the REST API? For example: http://data.cms.gov/resource/jzd2-pt4g.json?$where=keyword STARTS WITH 'value'
ebender
  • 37
  • 3
0
votes
2 answers

Does the Socrata SODA API provide a last modified date for a table?

On the web portal, every dataset has a last modified date, however I don't see anything in the API docs (or the response for that matter). Am I missing something?
Peter
  • 1,065
  • 14
  • 29
0
votes
1 answer

Socrata and DELETE request

I have recently found out how to delete rows by ID with the SODA API, but all of them were done through HTTP POST requests. Whenever I use DELETE requests, no matter what content is sent, it deletes the entire contents of my database. On the…
user3334960
0
votes
1 answer

how to use and what is soda api & javascript require()

I want to use the data of http://data.seattle.gov/api/views/kzjm-xkqj/rows.json with SODA API. In the API DOCS, i found it using a language ruby, python, coffeescript, cURL. And it use require() function. But I don't know how exactly the require()…
jayleaf
  • 29
  • 3
-1
votes
1 answer

API Stopped Working for 2019 Medical Individual Landscape

It all the sudden stopped working last week, and it's no longer listed on data.healthcare.gov page. Is it a technical error, or a policy issue that you no longer provide this data? Or is there a new link and can you please provide it? For…
klbytec
  • 54
  • 4
-1
votes
1 answer

Socrata - Is there any way to get list of cities whose crime data is available on Open Data?

I wanted to know how can I get list of cities in US whose crime data is available Socrata dataset.
devson
  • 990
  • 8
  • 22
-1
votes
1 answer

NYC Open data DOB Missing Information

I am facing some issue in NYC department of building API. help me if you know any other API giving the same information I have used this API but didn't work for me https://data.cityofnewyork.us/resource/83x8-shf7.json Missing fields permitee…
omkar kale
  • 1
  • 1
-1
votes
1 answer

soda (socrata) NYPD Motor Vehicle Collisions API Cross-origin resource sharing

I'm trying to create a mashup using the NYPD Motor Vehicle Collisions API and Google Maps JavaScript API. I'd like to know if I can load data directly from the NYC API to the Maps API using Cross-origin resource sharing.
Zeke_B
  • 1
  • 2
-1
votes
1 answer

Is there an API for crime in the US?

As the question title states, I need the crime data from all the united states. I can't find a dataset for that, only numerous small ones for the different cities and countrysides. Is there such a united API or should I maintain these small ones as…
dror
  • 3,759
  • 6
  • 31
  • 45
-1
votes
1 answer

Need help stringing together database processes

I need some help from those with more knowledge than I posses. I am currently trying to figure out how to get real time data from a database. I need to be able to find the company info from the most recent licensees. So the search parameter I'm…
Clay
  • 7
  • 1
-1
votes
1 answer

NYC Open Data Filtering

I would like to sort date to include 6am to 10 am and also 3pm to 7 pm. There is no- date is "between" sort option. I do not know SQL, or anything
Marty
  • 1
-1
votes
1 answer

Authentication error when accessing public SODA endpoint

I am using SharePoint Designer 2013 to author a workflow and using the "Call HTTP Web Service" access to access the soda endpoint https://health.data.ny.gov/resource/7xgt-tyms.json?fac_id=1 The response I get is the following json…
Joseph LeMay
  • 1
1 2 3
…
15
16