Icon for Socrata external plugin
Open repository in Console
Updated 1 year ago
Indexed 5 hours ago

TJJD – Average Daily Population by Location, FY 2011-2022

This project is part of a larger plan to transfer commonly requested TJJD data onto the Texas Open Data Portal. This will allow for greater efficiency in sharing publicly available information and answering Public Information Requests (PIRs). Average Daily Population (ADP) data provides the daily population of specific TJJD locations of the following types: Institutions, Halfway Houses, Contract Services, Orientation and Assessment, Parole, Other Parole (Out of State Parole) and Interstate Compact.

There are two levels of measurement of ADP on this data set. The first, titled MTD ADP (Month to Date), provides a month to month population count; it does NOT take into account the previous month's population count. Each month's population count is specific to that month.

The second, titled YTD ADP (Year to Date), provides a rolling average of ADP; it includes the previous month's population and averages it out with that month's population count.
Lastly, both Calendar Years (CY) and Fiscal Years (FY) are provided on this data set. TJJD’s fiscal year starts in September and ends in August of the following year.

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" \
{"sql": "
    SELECT *
    FROM \"texas-gov/tjjd-average-daily-population-by-location-fy-25ut-iey2\".\"tjjd_average_daily_population_by_location_fy\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • tjjd_average_daily_population_by_location_fy
Upstream Metadata