ct-gov/department-of-social-services-people-served-by-tqie-jawf
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 3 months ago
Indexed 4 hours ago

Department of Social Services - People Served by Town and Gender, 2015-2023

This dataset includes the number of people enrolled in DSS services by town and by gender from CY 2015-2023. To view the full dataset and filter the data, click the "View Data" button at the top right of the screen. More data on people served by DSS can be found <a href="https://data.ct.gov/browse?tags=dss%20enrollment%20counts" target="_blank">here</a>.

<b>About this data</b>

<li>For privacy considerations, a count of zero is used for counts less than five.</li> <li>A recipient is counted in all towns where that recipient resided in that year.</li> <li>Due to eligibility policies and operational processes, enrollment can vary slightly after publication. Please be aware of the point-in-time nature of the published data when comparing to other data published or shared by the Department of Social Services, as this data may vary slightly.</li>

<b>Notes by year</b>

<b>2021</b>

In March 2020, Connecticut opted to add a new Medicaid coverage group: the COVID-19 Testing Coverage for the Uninsured. Enrollment data on this limited-benefit Medicaid coverage group is being incorporated into Medicaid data effective January 1, 2021.

Enrollment data for this coverage group prior to January 1, 2021, was listed under State Funded Medical. An historical accounting of enrollment of the specific coverage group starting in calendar year 2020 will also be published separately.

<b>2018</b>

On April 22, 2019 the methodology for determining HUSKY A Newborn recipients changed, which caused an increase of recipients for that benefit starting in October 2016. We now count recipients recorded in the ImpaCT system as well as in the HIX system for that assistance type, instead using HIX exclusively.

Also, the methodology for determining the address of the recipients changed:

  1. The address of a recipient in the ImpaCT system is now correctly determined specific to that month instead of using the address of the most recent month. This resulted in some shuffling of the recipients among townships starting in October 2016.
  1. If, in a given month, a recipient has benefit records in both the HIX system and in the ImpaCT system, the address of the recipient is now calculated as follows to resolve conflicts: Use the residential address in ImpaCT if it exists, else use the mailing address in ImpaCT if it exists, else use the address in HIX. This resulted in a reduction in counts for most townships starting in March 2017 because a single address is now used instead of two when the systems do not agree.

On February 14, 2019 the enrollment counts for 2012-2015 across all programs were updated to account for an error in the data integration process. As a result, the count of the number of people served increased by 13% for 2012, 10% for 2013, 8% for 2014 and 4% for 2015. Counts for 2016, 2017 and 2018 remain unchanged.

On January 16, 2019 these counts were revised to count a recipient in all locations that recipient resided in that year.

On January 1, 2019 the counts were revised to count a recipient in only one town per year even when the recipient moved within the year. The most recent address is used.

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" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ct-gov/department-of-social-services-people-served-by-tqie-jawf\".\"department_of_social_services_people_served_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • department_of_social_services_people_served_by
     
     
     
     
     
Upstream Metadata