Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data & Insights going forward.

JSON Format

JSON (JavaScript Object Notation) is our most commonly used format. JSON is a text-based open standard derived from the format used to represent simple data structures in JavaScript. Although it is rooted in JavaScript, it is language-agnostic and parsers exist for all popular (and many unpopular) languages.

When JSON is specified as the format, the response will be a JSON array, where each element in the array is a result. The key will be the column’s field name and the value will be the result. Fields with null values are omitted. For example:

[ {
  "position" : "Member",
  "agency_website" : "SSAB (",
  "name" : "Aaron, Henry Jacob",
  "nomination_date" : "2011-02-14T00:00:00.000",
  "agency_name" : "Social Security Advisory Board"
}, {
  "position" : "Member",
  "confirmed" : true,
  "agency_website" : "EOP-CEA (",
  "name" : "Abraham, Katharine",
  "confirmation_vote" : "2011-04-14T00:00:00.000",
  "nomination_date" : "2011-01-26T00:00:00.000",
  "agency_name" : "Council of Economic Advisers"
} ]

The format is designed to be easily human-readable, and should also be immediately parsable by all common JSON parsers.

Details on how data is encoded are described in the documentation for each datatype.