Abstract

The Colorado All Payer Claims Database (CO APCD) is a state-legislated, secure health care claims database compliant with all federal privacy laws. It contains nearly 920 million claims for approximately 65 percent of insured lives in Colorado, with information from 42 commercial health insurance plans. Health insurance payers submit data monthly and the entire database is refreshed every other month, so the CO ACPD is continually evolving and being enhanced.

Usage

The dataset was extracted by the Center for Improving Value in Health Care (CIVHC) to support Stanford University COVID Long Haul Analysis. It includes medical, pharmacy, and dental claims files with coverage dates from 01/01/2012 to 08/31/2021.

For more information of CO APCD please refer to https://www.civhc.org/get-data/whats-in-the-co-apcd/

Before Manuscript Submission

All manuscripts (and other items you'd like to publish) must be submitted to

phsdatacore@stanford.edu for approval prior to journal submission.

We will check your cell sizes and citations.

For more information about how to cite PHS and PHS datasets, please visit:

https:/phsdocs.developerhub.io/need-help/citing-phs-data-core

Data Documentation

Metadata access is required to view this section.

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

These data are quality measures for each Utah small area calculated by the Utah Department of Health, Office of Healthcare Statistics (OHCS) using Utah’s All Payer Claims Database (APCD).

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

Ever wonder how many claims or people are in the Colorado All Payer Claims Database (CO APCD), and how it differs by type of claim (medical, dental, pharmacy), by year and by payer type? Use this interactive dashboard to understand what the CO APCD includes and what percentage of the population is represented in each county. Additional information is also available on race and ethnicity data, behavioral health services, dental code volume, and vision claims that are in the data warehouse under the Resources link.

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

Analysis of ‘WA-APCD Quality and Cost Summary Report: Practice Quality’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/10d4ddee-0987-4f16-a780-430181a47bf2 on 28 January 2022.

--- Dataset description provided by original source is as follows ---

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

--- Original source retains full ownership of the source dataset ---

Analysis of ‘WA-APCD Quality and Cost Summary Report: Hospital Quality’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/13e6499e-0f20-42f7-b51c-0dc0174855a9 on 12 November 2021.

--- Dataset description provided by original source is as follows ---

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

--- Original source retains full ownership of the source dataset ---

arbml/APCD dataset hosted on Hugging Face and contributed by the HF Datasets community

Analysis of ‘WA-APCD Quality and Cost Summary Report: County Cost’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/d69107cb-99d1-40ec-93f3-b94800f5e61e on 26 January 2022.

--- Dataset description provided by original source is as follows ---

WA-APCD - Washington All-Payer Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

--- Original source retains full ownership of the source dataset ---

Analysis of ‘WA-APCD Quality and Cost Summary Report: Facility Cost’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/8b31c8cf-0fbe-4d8e-abcd-1b2540a62470 on 12 November 2021.

--- Dataset description provided by original source is as follows ---

WA-APCD - Washington All Payers Claims Database

The WA-APCD is the state’s most complete source of health care eligibility, medical claims, pharmacy claims, and dental claims insurance data. It contains claims from more than 50 data suppliers, spanning commercial, Medicaid, and Medicare managed care. The WA-APCD has historical claims data for five years (2013-2017), with ongoing refreshes scheduled quarterly. Workers' compensation data from the Washington Department of Labor & Industries will be added in fall 2018.

Download the attachment for the data dictionary and more information about WA-APCD and the data.

--- Original source retains full ownership of the source dataset ---

These data are quality measures for each Utah small area calculated by the Utah Department of Health, Office of Healthcare Statistics (OHCS) using Utah’s All Payer Claims Database (APCD).

This dataset tracks the updates made on the dataset "WA-APCD Quality and Cost Summary Report: Facility Cost" as a repository for previous versions of the data and metadata.

Louisville Metro Air Pollution Control District (APCD) industrial permits are applications for a permit to operate equipment that emits or controls the emission of air pollutants.Permits ensure that emissions meet the needs of Louisville/Jefferson County to achieve and maintain federal air quality standards.Any piece of equipment or project that emits or controls air pollutants requires a permit prior to installation and operation unless it is specifically exempted from the APCD’s permit requirements. Companies apply for and receive a permit before purchasing new equipment to know exactly what the permit conditions and other requirements will be before construction, installation, and operation begin. Industrial Operating permits are issued after a project demonstrates that compliance is achievable.The Industrial Permits includes multiple types of emission based permits: Title V Permit, Federally Enforceable District-Origin Operating Permit (FEDOOP), Minor Source Permit, plus registrations (Registered Sources). FEDOOP permits are further divided into STAR-applicable and STAR-exempt. (See below.) A source may also be identified as exempt from APCD permitting.Title VTitle V refers to a section of the Clean Air Act (CAA) that addresses the largest sources of air pollution. Title V permits combine all the applicable federal, state, and local air requirements at a Title V facility into one permit.The Title V permit application process is detailed and complex and may require professional assistance. An opportunity for public comment and an opportunity for a public hearing are required. There is also a requirement that EPA and affected states are provided an opportunity to review proposed permits. EPA has the authority to object to permit issuance.Title V operating permits are issued for a period of 5 years. A complete Title V permit renewal application must be submitted to the APCD between 18 months and 6 months prior to the end of the permit term for continued operation.FEDOOPFEDOOPs, as described in APCD Regulation 2.17, are issued to major sources willing to accept federally enforceable emissions limitations below those that require a Title V permit. FEDOOP sources that emit more than certain amounts of specific toxic air pollutants are subject to APCD’s Strategic Toxic Air Reductions (STAR) Program.FEDOOPs are issued for a period of 5 years. A complete FEDOOP renewal application must be submitted to the APCD between 12 months and 90 days prior to the end of the permit term for continued operation. FEDOOPs are what the US EPA refers to as synthetic minor permits.Minor SourceThe majority of stationary air pollution sources in Louisville do not emit at the same levels as Title V sources or FEDOOP sources. If a company is unsure of its emissions levels, it is likely a minor source. However, companies are encouraged to contact the APCD with any questions about the process.Minor sources have a combined permit to construct and operate. No application is necessary to convert a construction permit into an operating permit. Minor source operating/construction permits do not have an expiration date. There is no formal renewal application for minor sources.Registered SourceStationary air pollution sources with very low emissions or that are not capable of exceeding a performance standard can be registered. These facility sites receive a registration letter rather than a permit, but pay an annual fee and are subject to compliance monitoring.ExemptExempt stationary sources do not need a permit or registration and do not pay any fees to APCD, unless the Risk Management Program under Section 112(r) of the Clean Air Act is applicable.Data Dictionary:Here is information about each column. The column name is in bold, followed by a description of the column, then the column data type in italics, then the domain or range of values.PermitNumber - Identifying number for the permit.EffectiveDate - Date the permit becomes or became effective.ExpirationDate - Date the permit expires.PermitStatus - The current status of the permit.RecordType - Type of record identified in Louisville Metro’s Permitting system.PlantClass - EPA Emissions classification of the permitted plant.ResponsibleParty - Person or Business entity responsible for permitted specifications.FacilityName - The name of the facility that the permit is issued to.PermitDescription - What is being permitted.StreetAddress - The address of the facility named in the permit.City - The city of the facility named in the permit.State - The state of the facility named in the permit.ZIP - The zip code of the facility named in the permit.Longitude - The longitude of the facility named in the permit.Latitude - The latitude of the facility named in the permit.PermitType - The top-level type of permit being issued. (This report only contains Industrial permits.)PermitSubtype - The type of application the permit is being used for within the broad permitting area. (This report only contains operating subtype permits.)PermitCategory - The category of permit referenced (This report only contains the category of permits.)Contact:Andy Purdonandy.purdon@louisvilleky.gov

CDPHE Open Data Site

This dataset tracks the updates made on the dataset "CO APCD Insights Dashboard" as a repository for previous versions of the data and metadata.

Analysis of ‘APCD Open Burning Permits’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/7ec36d06-bb94-438c-b5d7-0676d9344ef1 on 12 February 2022.

--- Dataset description provided by original source is as follows ---

Louisville Metro Air Pollution Control District (APCD) open burning permits are permits for outdoor fires in Louisville/Jefferson County (other than in an approved type of fire pit/chimenea or exclusively for cooking). These include recreational fires, such as bonfires, fire-fighting training fires, and agricultural burns and other controlled burns.

--- Original source retains full ownership of the source dataset ---

Permitted equipment by the Air Pollution Control District in San Diego County, CA (updated daily)

Variables and data resources in the study.

Industrial air pollution permits implement the laws, regulations, and requirements that apply to industrial and commercial facilities that emit air pollution. Any piece of equipment or project in Louisville that emits or controls air pollutants requires a permit prior to installation and operation unless it is specifically exempted from the APCD’s permit requirements.The APCD uses a two-permit system for “major” facilities. Construction Permits (included in this data set) are required prior to beginning any construction or modification. Once the construction project is approved, completed, and compliance of the construction project is demonstrated, an Operating Permit is issued.Data Field Guide:PermitNumber -- Identifying number for the permit.EffectiveDate -- Date the permit becomes or became effective.ExpirationDate -- Date the permit expires.ApplicationStatus -- The current status of the application.RecordType -- Type of record identified in Louisville Metro’s Permitting system.PlantClass -- EPA Emissions classification of the permitted plant.ResponsibleParty -- Person or Business entity responsible for permitted specifications.PermitName -- The name on the permit.PermitDescription -- What is being permitted.StreetAddress -- The address of the facility named in the permit.City -- The city of the facility named in the permit.State -- The state of the facility named in the permit.ZIP -- The zip code of the facility named in the permit.Longitude -- The longitude of the facility named in the permit.Latitude -- The latitude of the facility named in the permit.PermitType -- The top-level type of permit being issued. (This report only contains Industrial permits.)PermitSubtype -- The type of application the permit is being used for within the broad permitting area. (This report only contains construction subtype permits.)PermitCategory The category of permit referenced (This report only contains the category of permits.