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.

The table Medical_Claims_Procedures is part of the dataset CO APCD RIF, available at https://redivis.com/datasets/f485-0035c2392. It contains 519976457 rows across 5 variables.

The table Dental_Claims_Line is part of the dataset CO APCD RIF, available at https://redivis.com/datasets/f485-0035c2392. It contains 87939080 rows across 34 variables.

The table DIM_Provider_Entities is part of the dataset CO APCD RIF, available at https://redivis.com/datasets/f485-0035c2392. It contains 4 rows across 2 variables.

Variables and data resources in the study.

The table Provider_to_Provider_Composite_Crosswalk is part of the dataset CO APCD RIF, available at https://redivis.com/datasets/f485-0035c2392. It contains 3840120 rows across 3 variables.

This dataset contains data for the Healthcare Payments Data (HPD) Snapshot visualization. The Enrollment data file contains counts of claims and encounter data collected for California's statewide HPD Program. It includes counts of enrollment records, service records from medical and pharmacy claims, and the number of individuals represented across these records. Aggregate counts are grouped by payer type (Commercial, Medi-Cal, or Medicare), product type, and year. The Medical data file contains counts of medical procedures from medical claims and encounter data in HPD. Procedures are categorized using claim line procedure codes and grouped by year, type of setting (e.g., outpatient, laboratory, ambulance), and payer type. The Pharmacy data file contains counts of drug prescriptions from pharmacy claims and encounter data in HPD. Prescriptions are categorized by name and drug class using the reported National Drug Code (NDC) and grouped by year, payer type, and whether the drug dispensed is branded or a generic.

Number of SMMs in different datasets.

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.Permit Number: This is the permit number within the data system. For APCD industrial operating permits, it is "O-" followed by a number formatted as four digits. This number is also known as the plant ID. Text, 6 characters: "O-0001" through "O-9999"Effective Date: The date the permit or the most recent renewal became effective. Date: Dates between 2000-01-01 (1/1/2000) and a month in the future. May be blank if the permit has not yet been issued.Expiration Date: The date the permit or the most recent renewal expires/expired. Date: Blank for Minor Source permits, registered sources, and exempt sources. For Title V permits and FEDOOP permits: Dates between 2005-01-01 (1/1/2005) and up to 5 years and one month in the future. May be blank if the permit has not yet been issued.Permit Type: The general type of permit: APCD industrial operating permit. Text, 21 characters: "APCD Operating Permit"Applicant: The name of the responsible party for the permit. This is normally the company that operates the plant. Text, up to 50 characters: Names of organizations. Should not be blankStreet Address: The street address of the facility site (plant). Text, up to 75 characters: Official valid addresses in Louisville/Jefferson County, KentuckyCity: The city of the street address. Text, up to 30 characters: "LOUISVILLE" or a smaller city in Jefferson County, KentuckyState: The state of the street address: always Kentucky. Text, 2 characters: "KY"ZIP Code: The 5-digit ZIP code of the street address. Text, 5 characters: Valid 5-digit ZIP codes in Louisville/Jefferson County, KentuckyPermit Subtype: A description of the plant class. Text, up to 30 characters: "Title V Permit", "FEDOOP Permit" (STAR-applicable), "STAR-Exempt FEDOOP Permit", "Minor Source Permit", "Registered Source", "Exempt Source"Permit Description: A brief description of the permitted facility site (plant) Text, no limit: Should not be blank.Permit Type Code: The data system code for the permit type. Text, 6 characters: "APCDOP"Subtype Code: The data system code for the permit subtype. Text, up to 10 characters: "TITLE V" = Title V Permit, "FEDOOP" = STAR-Applicable FEDOOP Permit, "FEDOOPSE" = STAR-Exempt FEDOOP Permit, "MINOR" = Minor Source Permit, "REGISTERED" = Registered Source, "EXEMPT" = Exempt SourceID: Arbitrary identifier assigned by the open data portal. Long Integer: Positive integersContact:Andy Purdonandy.purdon@louisvilleky.gov

These are permits to construct or modify gasoline dispensing facilities in Louisville/Jefferson County, Kentucky, issued by the Louisville Metro Air Pollution Control District. Construction permits are generally issued for a 1-year period.Data Field Guide:PermitNumber -- Identifying number for the permit.EffectiveDate -- Date the permit becomes or became effective.ExpirationDate -- Date the permit expires.TotalGasolineTankCapacity -- Total capacity of the Tanks at the gas facility.ApplicationStatus -- The current status of the application.RecordType -- Type of record identified in Louisville Metro’s Permitting system.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.)

The table Pharmacy_Claims_Header is part of the dataset CO APCD RIF, available at https://redivis.com/datasets/f485-0035c2392. It contains 377251488 rows across 20 variables.

These are permits to operate gasoline dispensing facilities in Louisville/Jefferson County, Kentucky, issued by the Louisville Metro Air Pollution Control District. Operating permits are generally issued for a 5-year period.Data Field Guide:PermitNumber -- Identifying number for the permit.EffectiveDate -- Date the permit becomes or became effective.ExpirationDate -- Date the permit expires.TotalGasolineTankCapacity -- Total capacity of the Tanks at the gas facility.ApplicationStatus -- The current status of the application.RecordType -- Type of record identified in Louisville Metro’s Permitting system.PermitName -- The name on the permit 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.)

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.Data Field Guide:PermitNumber -- Identifying number for the permit.PermitName -- The name on the permit that the permit is issued to.PermitDescription -- What is being permitted.ApplicationStatus -- The current status of the application.RecordType -- Type of record identified in Louisville Metro’s Permitting system.BurnDate -- Date the permit expires.BurnDescription -- Total capacity of the Tanks at the gas facility.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.)

These are permits and courtesy notifications for the removal of asbestos-containing materials from structures in Louisville/Jefferson County, Kentucky, issued by the Louisville Metro Air Pollution Control District.Data Field Guide:PermitNumber -- Identifying number for the permit.RecordType -- Type of record identified in Louisville Metro’s Permitting system.SubType -- Type of asbestos removal work being performed.ApplicationStatus -- The current status of the application.ScheduledStartDate -- Date asbestos removal is scheduled to start.ScheduledEndDate -- Date asbestos removal is scheduled to end.PermitName -- Identifying number for the permit.PermitDescription -- What is being permitted.TotalACM -- The total amount of Asbestos Containing Materiel(ACM) that is being removed from the permitted location.AsbestosContractor -- Contractor performing the asbestos removal.WasteHauler -- Company hualing the asbestos away from the removal site and delivering it to the Disposal site.DisposalSite -- Facility or location where the asbestos will be disposed.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.)

Changes in FQHC funding and FQHC visit patterns, 2010–2013.

API operated by Louisville Metro that returns AQI information from local sensors operated by APCD. Shows the latest hourly data in a JSON feed.The Air Quality Index (AQI) is an easy way to tell you about air quality without having to know a lot of technical details. The “Metropolitan Air Quality Index” shows the AQI from the monitor in Kentuckiana that is currently detecting the highest level of air pollution. See: https://louisvilleky.gov/government/air-pollution-control-district/servi...See the air quality map (Louisville Air Watch) for more details: airqualitymap.louisvilleky.gov/#Read the FAQ for more information about the AQI data: https://louisvilleky.gov/government/air-pollution-control-district/louis...If you'd prefer air quality forecast data (raw data, maps, API) instead, please see AIRNow: https://www.airnow.gov/index.cfm?action=airnow.local_city&zipcode=40204&...See the Data Dictionary section below for information about what the AQI numbers mean, their corresponding colors, recommendations, and more info and links.To download daily snapshots of AQI for the last 25 years, visit the EPA website, set your year range, and choose, Louisville KY. Then download with the CSV link at the bottom of the page.IFTTT integration trigger that fires and after retrieving air quality from Louisville Metro air sensors via the APIGives a forecast instead of the current conditions, so you can take action before the air quality gets bad.The U.S. EPA AirNow program (www.AirNow.gov) protects public health by providing forecast and real-time observed air quality information across the United States, Canada, and Mexico. AirNow receives real-time air quality observations from over 2,000 monitoring stations and collects forecasts for more than 300 cities.Sign up for a free account and get started using the RSS data feed for Louisville. https://docs.airnowapi.org/feedsAir Quality Forecast via AirNowAQI Level - Value and Related Health Concerns LegendGood 0-50 GreenAir quality is considered satisfactory, and air pollution poses little or no risk.Moderate 51-100 YellowAir quality is acceptable; however, for some pollutants there may be a moderate health concern for a very small number of people who are unusually sensitive to air pollution.Unhealthy for Sensitive Groups 101-150 OrangeMembers of sensitive groups may experience health effects. The general public is not likely to be affected.Unhealthy 151-200 RedEveryone may begin to experience health effects; members of sensitive groups may experience more serious health effects.Very Unhealthy 201-300 PurpleHealth alert: everyone may experience more serious health effects.Hazardous > 300 Dark PurpleHealth warnings of emergency conditions. The entire population is more likely to be affected.Here are citizen actions APCD recommends on air quality alert days, that is, days when the forecast is for the air quality to reach or exceed the “unhealthy for sensitive groups” (orange) level:Don’t idle your car. (Recommended all the time; see the second link below.)Put off mowing grass with a gas mower until the alert ends.“Refuel when it’s cool” (pump gasoline only in the evening or night).Avoid driving if possible. Share rides or take TARC.Check on neighbors with breathing problems.Here are some links in relation to the recommendations:KAIRE, www.helptheair.org/Idle Free Louisville, www.helptheair.org/idle-freeTARCTicket to Ride, tickettoride.org/Lawn Care for Cleaner Air (rebates)Contact:Bryan FrazerBryan.Frazar@louisvilleky.gov

These are permits and courtesy notifications for the removal of asbestos-containing materials from structures in Louisville/Jefferson County, Kentucky, issued by the Louisville Metro Air Pollution Control District. A permit is required if someone is are disturbing or removing asbestos-containing material from any structure other than their own home. Also, anytime someone is demolishing a building, they will likely need to send in a notification and may need a permit to remove asbestos before the demolition. Asbestos is a general term for a group of fibrous minerals (primarily chrysotile, amosite and crocidolite) that have long been used as fireproof insulation and as a strengthener in pipe insulation, roofing tiles, floor tiles,wall coverings and other materials. Undisturbed asbestos-containing material (ACM) is not dangerous. But when asbestos-containing material is broken or torn, as during remodeling or demolition, the fibers can be spread into the air, especially if the material is friable (crumbly). Studies have shown that inhaling high concentrations of these fibers can over time cause a disease called asbestosis, lung cancer and another type of cancer called mesothelioma. In asbestosis, delicate lung tissue is damaged by the body's own attempts to remove embedded fibers. Mesothelioma can develop in the lining (pleura) of the lung or in the lining of the abdomen (peritoneum). Symptoms of lung cancer or mesothelioma usually do not appear for 15 to 30 years after exposure; for asbestosis, the latency period is 25 to 40 years. Special training and equipment are required to remove asbestos-containing material safely. For this reason, federal and local regulations require a permit and the use of a licensed contractor for removal of asbestos-containing material from any structure other than a private residence.Contact Information:Andy Purdonandy.purdon@louisvilleky.gov

Air Pollution Control DistrictThe Air Pollution Control District protects air quality in Louisville Metro to ensure healthy air for breathing, economic security, and prosperity for our citizens and future generations.The APCD implements the Federal Clean Air Act in Louisville and works in partnership with the U. S. Environmental Protection Agency, the Kentucky Division for Air Quality, and the Indiana Department of Environmental Management. Furthermore, the APCD has worked to make Louisville's air cleaner for more than half a century. The APCD is part of Louisville Forward.Contact Information:Andy Purdonandy.purdon@louisvilleky.gov

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.