Skip to main navigation Skip to side nav Jump to footer

Loading...

{{ message }}

Total Datasets: {{ datasets.length }}
Terms   

{{ datasetInfo[dataset.dataset].description }}

Last Updated:
{{ datasetInfo[dataset.dataset].updated }}
 
{{ datasetInfo[dataset.dataset].category }}

Loading Dataset...

DISCLAIMER

{{datasetInfo[dataset].disclaimer_text}}

{{ datasetInfo[dataset].name }}

Terms   

Open Data API Documentation

 

The OpenData API is a web service that can be accessed through the following URL:
{{opendataURL}}?format=json

This query returns a list of all available datasets.

 

The "dataset" query variable can be set to return a list of all column names and data types for the selected dataset.
{{opendataURL}}?format=json&dataset={{ dataset }}

This query returns all the columns and their respective data types for the current dataset ({{ dataset }}).

 

To request data from a dataset the "columns" query variable can be set to any column name.
{{opendataURL}}?format=json&dataset={{dataset}}&columns={{apiColumn}}

This query returns all data in the dataset (up to the default limit of 100 records).

 

The "values" variable can be set in addition to the "columns" variable to return all records where the column contains the specified value.
{{opendataURL}}?format=json&dataset={{dataset}}&columns={{apiColumn}}&values={{currData[0][apiColumn]}}

This query returns all records where the column {{apiColumn}} contains the value {{currData[0][apiColumn]}}.

 

To match a value exactly the "compare" query variable can be set to equal (by default it is set to contains).
{{opendataURL}}?format=json&compare=equal&dataset={{dataset}}&columns={{apiColumn}}&values={{currData[0][apiColumn]}}

This query returns the records where the column {{apiColumn}} matches the value {{currData[0][apiColumn]}} exactly.

 

The default data format is XML, but can be changed by setting the format query variable to "json" (as in all the example queries) to return JSON formatted data.

 

Query Variables and Values
dataset Any dataset listed by a default service query.
columns Any column(s) listed for a dataset by a dataset information query.
values Any value(s) of the correct data type for the column(s) being queried.
format xml, json, jsonp (Default: xml)
compare contains, equal, gt, lt, gte, lte (Default: contains)
limit Any number up to 1000 (Default: 100)

 


Contact Dataset Owner


Description

{{ datasetInfo[dataset].description }}

Dataset Size

Rows:
{{ allData.length }}+

Columns:
{{ fields.length }}

Last Updated:
{{ datasetInfo[dataset].updated }}
Update Frequency:
{{ currDatasetInfo.update_frequency }}
Category:
{{ datasetInfo[dataset].category }}
Dataset Owner:
{{ datasetInfo[dataset].owner }}
Times Accessed:
{{ currDatasetInfo.accessCount }}

{{ dataPage }} of {{ numDataPages }}
{{ field.column_name }}
{{ prop }}
{{ prop }}

{{ field.column_name }} {{ currData[0][field.column_name] }}