AndreaBozzo/ceres-open-data-index huggingface dataset:
State Licensed Residential Facilities in Arizona

ADHS Division of Licensing Mission Statement: To protect the health and safety of Arizonans by providing information, establishing standards, and licensing and regulating health and child care services. The Arizona Department of Health Services-Bureau of Residential Facilities Licensing licenses and regulates Residential Healthcare Facilities, including Assisted Living Centers/Homes and Behavioral Health Residential Facilities, along with Adult Day Health Care Facilities, Adult Foster Care Homes, Behavioral Health Respite Homes, and Behavioral Health Therapeutic Homes. Records are created and maintained by Bureau of Residential Facilities Licensing staff in the licensing division, while the GIS Team extracts the data and creates GIS layers and shares them publicly. Each month, an extract from the ADHS Division of Licensing SQL database is geocoded using ADHS's internal geocoder, and post-processed using a Python script to create and publish feature classes by facility type, including residential facilities. Last Updated: February 2025 Update frequency: Monthly Data FAQs: 1. Some records have “license_expiration” earlier than the “rundate” while the “OPERTION_STATUS” is “ACTIVE”, should we treat all records with “OPERATION_STATUS” of “ACTIVE” as open at the time the data is released? Answer: Yes - ACTIVE is all the current licenses. In 2019 there was a perpetual rule change that affected certain facilities so in lieu of an expiration date, we began tracking the annual fee due date in the "license_expiration" field. Per rule, these facilities can submit annual requirements up to 30 days after the fee due date (aka license expiration in the provider database) so we do expect some to be earlier than the run date. 2. Is the FACID of the same facility maintained unique and same throughout all releases? If a facility is purchased by a different company or has it’s name changed, is the FACID changed? Answer: The FACID represents a licensed premise - in many cases the facility ID is maintained when purchased by a different owner but under federal rule, certain facilities may choose to have a new CMS certification number which would require a new FACID be issued for that premise. 3. What’s the unit type of capacities for different categories? Answer: This varies - it can be child capacity, bed count, dialysis station, etc. 4. For Group_Home_for_Individuals_with_a_Developmental_Disability and Residential_Facility, how to tell if the employer’s office is at the facility VS the employer’s office is somewhere else and employees are sent to those facilities? Also is there a way to tell if a facility only has part time workers (Like workers only need to be at the residential facility less than 8hr per day or less than 5 days a week )? Answer: This is not currently available on the public database 5. The data contains a 'COUNTY' field and a "N_County' field - which one should I use to filter results? Answer: N_County - this is the county that's assigned when a record is geocoded using the physical street address, vs one that is assigned manually during the licensing process.
State Licensed Childcare Facilities in Arizona

ADHS Division of Licensing Mission Statement: To protect the health and safety of Arizonans by providing information, establishing standards, and licensing and regulating health and child care services. The Arizona Department of Health Services-Bureau of Child Care Licensing regulates and monitors licensed child care facilities, public school child care programs and certified child care group homes statewide. Records are created and maintained by Bureau of Child Care Licensing staff in the licensing division, while the GIS Team extracts the data and creates GIS layers and shares them publicly. Each month, an extract from the ADHS Division of Licensing SQL database is geocoded using ADHS's internal geocoder, and post-processed using a Python script to create and publish feature classes by facility type, including childcare facilities. Last Updated: February 2025 Update frequency: Monthly Data FAQs: 1. Some records have “license_expiration” earlier than the “rundate” while the “OPERTION_STATUS” is “ACTIVE”, should we treat all records with “OPERATION_STATUS” of “ACTIVE” as open at the time the data is released? Answer: Yes - ACTIVE is all the current licenses. In 2019 there was a perpetual rule change that affected certain facilities so in lieu of an expiration date, we began tracking the annual fee due date in the "license_expiration" field. Per rule, these facilities can submit annual requirements up to 30 days after the fee due date (aka license expiration in the provider database) so we do expect some to be earlier than the run date. 2. Is the FACID of the same facility maintained unique and same throughout all releases? If a facility is purchased by a different company or has it’s name changed, is the FACID changed? Answer: The FACID represents a licensed premise - in many cases the facility ID is maintained when purchased by a different owner but under federal rule, certain facilities may choose to have a new CMS certification number which would require a new FACID be issued for that premise. 3. What’s the unit type of capacities for different categories? Answer: This varies - it can be child capacity, bed count, dialysis station, etc. 4. For Group_Home_for_Individuals_with_a_Developmental_Disability and Residential_Facility, how to tell if the employer’s office is at the facility VS the employer’s office is somewhere else and employees are sent to those facilities? Also is there a way to tell if a facility only has part time workers (Like workers only need to be at the residential facility less than 8hr per day or less than 5 days a week )? Answer: This is not currently available on the public database 5. The data contains a 'COUNTY' field and a "N_County' field - which one should I use to filter results? Answer: N_County - this is the county that's assigned when a record is geocoded using the physical street address, vs one that is assigned manually during the licensing process.
State Licensed Group Home for Individuals with a Developmental Disability Facilities in Arizona

ADHS Division of Licensing Mission Statement: To protect the health and safety of Arizonans by providing information, establishing standards, and licensing and regulating health and child care services. The Arizona Department of Health Services-Bureau of Special Licensing conducts licensing inspections, on-site surveys, and complaint investigations to promote quality care and safety and ensure that performance standards are met. Records are created and maintained by Bureau of Special Licensing staff in the licensing division, while the GIS Team extracts the data and creates GIS layers and shares them publicly. Each month, an extract from the ADHS Division of Licensing SQL database is geocoded using ADHS's internal geocoder, and post-processed using a Python script to create and publish feature classes by facility type, including group homes for individuals with a developmental disability. Last Updated: February 2025 Update frequency: Monthly Data FAQs: 1. Some records have “license_expiration” earlier than the “rundate” while the “OPERTION_STATUS” is “ACTIVE”, should we treat all records with “OPERATION_STATUS” of “ACTIVE” as open at the time the data is released? Answer: Yes - ACTIVE is all the current licenses. In 2019 there was a perpetual rule change that affected certain facilities so in lieu of an expiration date, we began tracking the annual fee due date in the "license_expiration" field. Per rule, these facilities can submit annual requirements up to 30 days after the fee due date (aka license expiration in the provider database) so we do expect some to be earlier than the run date. 2. Is the FACID of the same facility maintained unique and same throughout all releases? If a facility is purchased by a different company or has it’s name changed, is the FACID changed? Answer: The FACID represents a licensed premise - in many cases the facility ID is maintained when purchased by a different owner but under federal rule, certain facilities may choose to have a new CMS certification number which would require a new FACID be issued for that premise. 3. What’s the unit type of capacities for different categories? Answer: This varies - it can be child capacity, bed count, dialysis station, etc. 4. For Group_Home_for_Individuals_with_a_Developmental_Disability and Residential_Facility, how to tell if the employer’s office is at the facility VS the employer’s office is somewhere else and employees are sent to those facilities? Also is there a way to tell if a facility only has part time workers (Like workers only need to be at the residential facility less than 8hr per day or less than 5 days a week )? Answer: This is not currently available on the public database 5. The data contains a 'COUNTY' field and a "N_County' field - which one should I use to filter results? Answer: N_County - this is the county that's assigned when a record is geocoded using the physical street address, vs one that is assigned manually during the licensing process.
State Licensed Business Hearing Aid Dispenser in Arizona

ADHS Division of Licensing Mission Statement: To protect the health and safety of Arizonans by providing information, establishing standards, and licensing and regulating health and child care services. The Bureau of Special Licensing conducts licensing inspections, on-site surveys, and complaint investigations to promote quality care and safety and ensure that performance standards are met. Records are created and maintained by Bureau of Special Licensing staff in the licensing division, while the GIS Team extracts the data and creates GIS layers and shares them publicly. Each month, an extract from the ADHS Division of Licensing SQL database is geocoded using ADHS's internal geocoder, and post-processed using a Python script to create and publish feature classes by facility type, including business hearing aid dispenser locations. Last Updated: October 2024 Update frequency: Monthly Data FAQs: 1. Some records have “license_expiration” earlier than the “rundate” while the “OPERTION_STATUS” is “ACTIVE”, should we treat all records with “OPERATION_STATUS” of “ACTIVE” as open at the time the data is released? Answer: Yes - ACTIVE is all the current licenses. In 2019 there was a perpetual rule change that affected certain facilities so in lieu of an expiration date, we began tracking the annual fee due date in the "license_expiration" field. Per rule, these facilities can submit annual requirements up to 30 days after the fee due date (aka license expiration in the provider database) so we do expect some to be earlier than the run date. 2. Is the FACID of the same facility maintained unique and same throughout all releases? If a facility is purchased by a different company or has it’s name changed, is the FACID changed? Answer: The FACID represents a licensed premise - in many cases the facility ID is maintained when purchased by a different owner but under federal rule, certain facilities may choose to have a new CMS certification number which would require a new FACID be issued for that premise. 3. What’s the unit type of capacities for different categories? Answer: This varies - it can be child capacity, bed count, dialysis station, etc. 4. For Group_Home_for_Individuals_with_a_Developmental_Disability and Residential_Facility, how to tell if the employer’s office is at the facility VS the employer’s office is somewhere else and employees are sent to those facilities? Also is there a way to tell if a facility only has part time workers (Like workers only need to be at the residential facility less than 8hr per day or less than 5 days a week )? Answer: This is not currently available on the public database 5. The data contains a 'COUNTY' field and a "N_County' field - which one should I use to filter results? Answer: N_County - this is the county that's assigned when a record is geocoded using the physical street address, vs one that is assigned manually during the licensing process.
State Licensed DUI and/or Domestic Violence Treatment Center in Arizona

ADHS Division of Licensing Mission Statement: To protect the health and safety of Arizonans by providing information, establishing standards, and licensing and regulating health and child care services. The Arizona Department of Health Services-Bureau of Medical Facilities Licensing licenses and certifies medical health care institutions and providers of medical services to protect the public's health and safety and assure quality customer service through teamwork in a timely, efficient, and responsive manner. Records are created and maintained by Bureau of Medical Facilities Licensing staff in the licensing division, while the GIS Team extracts the data and creates GIS layers and shares them publicly. Each month, an extract from the ADHS Division of Licensing SQL database is geocoded using ADHS's internal geocoder, and post-processed using a Python script to create and publish feature classes by facility type, including DUI and/or Domestic Violence Offender Treatment Center locations. Last Updated: February 2025 Update frequency: Monthly Data FAQs: 1. Some records have “license_expiration” earlier than the “rundate” while the “OPERTION_STATUS” is “ACTIVE”, should we treat all records with “OPERATION_STATUS” of “ACTIVE” as open at the time the data is released? Answer: Yes - ACTIVE is all the current licenses. In 2019 there was a perpetual rule change that affected certain facilities so in lieu of an expiration date, we began tracking the annual fee due date in the "license_expiration" field. Per rule, these facilities can submit annual requirements up to 30 days after the fee due date (aka license expiration in the provider database) so we do expect some to be earlier than the run date. 2. Is the FACID of the same facility maintained unique and same throughout all releases? If a facility is purchased by a different company or has it’s name changed, is the FACID changed? Answer: The FACID represents a licensed premise - in many cases the facility ID is maintained when purchased by a different owner but under federal rule, certain facilities may choose to have a new CMS certification number which would require a new FACID be issued for that premise. 3. What’s the unit type of capacities for different categories? Answer: This varies - it can be child capacity, bed count, dialysis station, etc. 4. For Group_Home_for_Individuals_with_a_Developmental_Disability and Residential_Facility, how to tell if the employer’s office is at the facility VS the employer’s office is somewhere else and employees are sent to those facilities? Also is there a way to tell if a facility only has part time workers (Like workers only need to be at the residential facility less than 8hr per day or less than 5 days a week )? Answer: This is not currently available on the public database 5. The data contains a 'COUNTY' field and a "N_County' field - which one should I use to filter results? Answer: N_County - this is the county that's assigned when a record is geocoded using the physical street address, vs one that is assigned manually during the licensing process.
CDC 2020 Social Vulnerability Index by Tract for Arizona

This dataset presents the 2020 CDC SVI by Census Tracts boundaries in Arizona. Data was provided by CDC Geospatial Research, Analysis, and Services Program (GRASP). The CDC\ATSDR Social Vulnerability Index (SVI) is a tool, created by the Geospatial Research, Analysis and Services Program (GRASP), to help public health officials and emergency response planners identify and map the communities that will most likely need support before, during, and after a hazardous event. The tract-level SVI shows the relative vulnerability of the population of every U.S. Census tract. The county-level SVI shows the relative vulnerability of every U.S. county population. The SVI ranks tracts (or counties) on 16 social factors, described in detail in the documentation. The tract (or county) rankings for individual factors are further grouped into four related themes. Thus each enumeration unit receives a ranking for each Census variable and for each of the four themes, as well as an overall ranking. See complete documentation here: [https://www.atsdr.cdc.gov/placeandhealth/svi/data_documentation_download.html]. For additional questions, contact the SVI Lead at svi_coordinator@cdc.gov. Last Updated: 2020 Update Frequency: Annually
CDC 2020 Social Vulnerability Index (SVI) by Arizona County

The CDC\ATSDR Social Vulnerability Index (SVI) is a tool, created by the Geospatial Research, Analysis and Services Program (GRASP), to help public health officials and emergency response planners identify and map the communities that will most likely need support before, during, and after a hazardous event. County-level SVI shows the relative vulnerability of every Arizona county population. The SVI ranks counties on 16 social factors, described in detail in the documentation. The county rankings for individual factors are further grouped into four related themes. Each county receives a ranking for each Census variable, each of the four themes, as well as an overall ranking. Visit the CDC SVI [website] for more information, including methodology. For additional questions, contact the National SVI Coordinator at svi_coordinator@cdc.gov. Last Updated: 2020 Update Frequency: Every 2 years (approximately)
2022 Age 0 to 18 Population Per Sq Mile

This dataset represent 2010 Census block groups that displays 2022 age 0 to 18 population per square mile in Arizona. Using the 2010 Census block groups layer it was joined to the 2022 1-Year Population Estimate dataset from Clarita's. Then, we calculated geometry for each block groups to obtain the area per square mile. Finally, we were able to calculate population density by the total population of 18 years old and younger to the block group area (sq. mile). Last Updated: May 2022 Update Frequency: Annual
States from Arizona EPHT Explorer

This dataset contains the name and state FIPS code of all the states in the US. Use this spatial data to join data tables downloaded from the Arizona EPHT Explorer that has the "Geography" filter set to "States". Environmental Public Health Tracking (EPHT) is a tool to help Arizonans learn about environmental hazards in the state that could impact their health. EPHT was built on the idea that health and environmental problems are not always separate issues with unrelated solutions. EPHT has gathered data from national and local sources in order to view both environmental and health outcome data in one easily accessible place. For example, Arizonans can review air quality information and compare the information with respiratory issues such as asthma. Dataset and web based maps display a variety of topics in the Environmental Public Health Tracking network. For more information about where to download the data tables and how, feel free to visit the Arizona EPHT Explorer or the Environmental Public Health Tracking webpage. Last Update: June 2023 Update Frequency: N/A
Groundwater Basins from Arizona EPHT Explorer

This dataset contains the name and geography ID of all the basins (groundwater) in Arizona. Use this spatial data to join data tables downloaded from the Arizona EPHT Explorer that has the "Geography" filter set to "Groundwater". This feature contains groundwater basin boundaries and provide base information for use in GIS systems to aid in assessment for a variety of planning and analysis purposes and to provide a geographic view with corresponding data. These data do not represent a legal record. Geography data was provided by Arizona Department of Water Resources (ADWR). Environmental Public Health Tracking (EPHT) is a tool to help Arizonans learn about environmental hazards in the state that could impact their health. EPHT was built on the idea that health and environmental problems are not always separate issues with unrelated solutions. EPHT has gathered data from national and local sources in order to view both environmental and health outcome data in one easily accessible place. For example, Arizonans can review air quality information and compare the information with respiratory issues such as asthma. Dataset and web based maps display a variety of topics in the Environmental Public Health Tracking network. For more information about where to download the data tables and how, feel free to visit the [Arizona EPHT Explorer] or the [Environmental Public Health Tracking] webpage. Last Update: June 2023 Update Frequency: N/A
Census Tract 2010 to PCA Crosswalk for American Community Survey (ACS) Data

Crosswalk between Census tracts (2010) and Arizona Dept. of Health Services [Primary Care Areas] (PCAs). This version is used to identify PCAs by tract for American Community Survey (ACS) data. If you're working with Census 2010 data, use this [version] instead. Why did ADHS develop two Tract to PCA conversion keys? The U.S. Census Bureau changed the tract ID for seven tracts in American Community Survey (ACS) data from the originally assigned tract id in the 2010 Census data release. As a result, two crosswalks are needed, one for Census 2010 and another for ACS data. Use the correct one depending on the source of your data.
Public Water System from Arizona EPHT Explorer

This dataset contains the name and geography ID of all the groundwater basins in Arizona. The purpose of this feature class is to provide service area boundaries for community water systems regulated by the Arizona Department of Water Resources. Use this spatial data to join data tables downloaded from the Arizona EPHT Explorer that has the "Geography" filter set to "PWS Service Areas (Public Water System)". his feature class contains service area polygons for each Community Water System (CWS). To determine the service area, ADWR utilized primary data provided directly from the water system (i.e. PDF, shapefile, verbal definition). If primary data is unavailable, secondary data was utilized to determine service area boundaries (i.e. Certificate of Convenience and Necessity (CCN), Census Designated Place shapefile from U.S Census Bureau.) New water systems are added, and contact information is updated for existing water systems on an annual basis. Environmental Public Health Tracking (EPHT) is a tool to help Arizonans learn about environmental hazards in the state that could impact their health. EPHT was built on the idea that health and environmental problems are not always separate issues with unrelated solutions. EPHT has gathered data from national and local sources in order to view both environmental and health outcome data in one easily accessible place. For example, Arizonans can review air quality information and compare the information with respiratory issues such as asthma. Dataset and web based maps display a variety of topics in the Environmental Public Health Tracking network. For more information about where to download the data tables and how, feel free to visit the [Arizona EPHT Explorer] or the [Environmental Public Health Tracking] webpage. Last Update: March 2022 Update Frequency: Annually