The Texas Department of Insurance, Division of Workers’ Compensation (DWC) maintains a database of pharmacy medical billing services (SV4). It contains charges, payments, and prescriptions billed on a DWC Form-066, Statement of Pharmacy Services by pharmacies with dates of service for the last five years. For datasets going back to 2010, see pharmacy medical billing services (SV4) detail information – historical.

The detail section contains information to identify insurance carriers, injured employees, employers, place of service, and diagnostic information. The bill details are individual line items that are grouped in the header section of a single bill. The bill selection date and bill ID must be used to group individual line items into a single bill. Find more information in our pharmacy medical billing services (SV4) detail data dictionary.

See pharmacy medical billing services (SV4) header information for the corresponding header records related this dataset.

Go to our page on DWC medical state reporting public use data file (PUDF) to learn more about using this information.

The Texas Department of Insurance, Division of Workers’ Compensation (DWC) maintains a database of pharmacy medical billing services (SV4). It contains charges, payments, and prescriptions billed on a DWC Form-066, Statement of Pharmacy Services by pharmacies with dates of service for the last five years. For datasets going back to 2010, see pharmacy medical billing services (SV4) header information – historical. The header identifies insurance carriers, injured employees, employers, place of service, and diagnostic information. The bill header information groups individual line items reported in the detail section. The bill selection date and bill ID must be used to group individual line items into a single bill. Find more information in our pharmacy medical billing services (SV4) header data dictionary. See pharmacy medical billing services (SV4) detail information for the corresponding detail records related to this dataset. Go to our page on DWC medical state reporting public use data file (PUDF) to learn more about using this information.

With respect to the NHS supporting early diagnosis of cancer (Community Pharmacy) pilot 1. How many pharmacy contractors registered for this pilot during June, July, August, September, October, November and December 2023? 2. How many pharmacy contractors are currently registered for this pilot? 3. How many claims for payment for the service have been received by community pharmacies during June, July, August, September, October, November and December 2023? 4. How many claims have community pharmacies made cumulatively for this pilot to date? 5. How much have community pharmacies been paid for their work as part of the pilot during June, July, August, September, October, November and December 2023? 6. How much have community pharmacies been paid cumulatively for this pilot to date? Response Question 1 Our User Research team have confirmed that 8 pharmacies registered for the service in July 2023- no other pharmacies have registered in June 2023, or between August and December 2023. Question 2 9 pharmacies are registered in total for the pilot as of January 2024. Questions 3 & 4 We are unable to answer these questions- This is because the NHSBSA only receive monthly confirmation of amounts to be paid to pharmacies participating in the Early Diagnosis of Cancer local scheme, as confirmed by the regional Integrated Care Boards the pharmacies are located in. The amounts confirmed are not broken down into the number of claims the pharmacies have made in order to be entitled to those payments. Therefore, we cannot definitively confirm how many claims for payment have been received, or made cumulatively, for the pilot to date. Questions 5 & 6 This information is held within the monthly Management Information Spreadsheet (MIS) Pharmacy Contractor reports, for which data is currently available up until October 2023. All the reports for the months requested (that are currently available) have been published in previous FOI’s; June 2023’s Pharmacy Contractor report was published in FOI-01426 - https://opendata.nhsbsa.net/dataset/foi-01426 July, August and September 2023’s Pharmacy Contractor report was published in FOI-01579 - https://opendata.nhsbsa.net/dataset/foi-01579 October 2023’s Pharmacy Contractor report was published in FOI-01673 - https://opendata.nhsbsa.net/dataset/foi-01673 Any payments made to a pharmacy contractor within the respective month are listed under the column Local_Scheme_21 within each pharmacy contractor spreadsheet. Please note that payments have only been made in June 2023, July 2023 and September 2023, based on the data within the MIS spreadsheets. We would also state as a caveat that any payments made may be subject to adjustments in further months.

This dataset consolidates the pharmaceutical lists which NHS England has a regulatory duty to prepare, maintain and publish for each Health and Wellbeing Board area. This consolidated list includes lists of: NHS pharmacies (also known as NHS community pharmacies) and; NHS appliance contractors (also known as NHS dispensing appliance contractors) and; Local Pharmaceutical Services contractors Pharmaceutical lists for each Health and Wellbeing Board area are maintained by NHS England by pharmacy contract teams. Community pharmacies and dispensing appliance contractors can apply to or notify contract teams to amend the details held by the regional teams as specified in The National Health Service (Pharmaceutical and Local Pharmaceutical Services) Regulations 2013 . Further details on the application processes can be found on the Primary Care Support England website. NHSBSA collates information on changes from NHS pharmacy contract teams and PCSE in the consolidated pharmaceutical list on NHS England's behalf. Typically, high volumes of changes take place each month; and so, the consolidated pharmaceutical list is produced and validated on a quarterly basis. This validation confirms the accuracy of the consolidated pharmaceutical list, by comparing it to the pharmaceutical lists maintained for each Health and Wellbeing Board area. The consolidated pharmaceutical list here represents the data as recorded in the NHSBSA Master Data Replacement System (MDR) on the last day of each quarter. Where information contained in the published list is discovered to be incorrect after publication, backdated amendments are made and reflected in the next publication. We publish the related dataset Pharmacy Openings and Closures on a monthly basis.

Context

RxNorm is a name of a US-specific terminology in medicine that contains all medications available on US market. Source: https://en.wikipedia.org/wiki/RxNorm

RxNorm provides normalized names for clinical drugs and links its names to many of the drug vocabularies commonly used in pharmacy management and drug interaction software, including those of First Databank, Micromedex, Gold Standard Drug Database, and Multum. By providing links between these vocabularies, RxNorm can mediate messages between systems not using the same software and vocabulary. Source: https://www.nlm.nih.gov/research/umls/rxnorm/

Content

RxNorm was created by the U.S. National Library of Medicine (NLM) to provide a normalized naming system for clinical drugs, defined as the combination of {ingredient + strength + dose form}. In addition to the naming system, the RxNorm dataset also provides structured information such as brand names, ingredients, drug classes, and so on, for each clinical drug. Typical uses of RxNorm include navigating between names and codes among different drug vocabularies and using information in RxNorm to assist with health information exchange/medication reconciliation, e-prescribing, drug analytics, formulary development, and other functions.

This public dataset includes multiple data files originally released in RxNorm Rich Release Format (RXNRRF) that are loaded into Bigquery tables. The data is updated and archived on a monthly basis.

The following tables are included in the RxNorm dataset:

• RXNCONSO contains concept and source information

• RXNREL contains information regarding relationships between entities

• RXNSAT contains attribute information

• RXNSTY contains semantic information

• RXNSAB contains source info

• RXNCUI contains retired rxcui codes

• RXNATOMARCHIVE contains archived data

• RXNCUICHANGES contains concept changes

Update Frequency: Monthly

Fork this kernel to get started with this dataset.

Acknowledgements

https://www.nlm.nih.gov/research/umls/rxnorm/

https://bigquery.cloud.google.com/dataset/bigquery-public-data:nlm_rxnorm

https://cloud.google.com/bigquery/public-data/rxnorm

Dataset Source: Unified Medical Language System RxNorm. The dataset is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset. This dataset uses publicly available data from the U.S. National Library of Medicine (NLM), National Institutes of Health, Department of Health and Human Services; NLM is not responsible for the dataset, does not endorse or recommend this or any other dataset.

Banner Photo by @freestocks from Unsplash.

Inspiration

What are the RXCUI codes for the ingredients of a list of drugs?

Which ingredients have the most variety of dose forms?

In what dose forms is the drug phenylephrine found?

What are the ingredients of the drug labeled with the generic code number 072718?

The pharmacy opening and closures data set shows the numbers of pharmacies in England that are included on a Pharmaceutical List held by NHS England on the last calendar day of each month, and so can provide NHS prescriptions and pharmaceutical services. These are split into three groups by the number of premises in each pharmacy group: Small (1-5), Medium (6-99) and Large (100+) pharmacy groups. This data set also separately includes figures for pharmacies subject to the 100 hours condition and distance selling pharmacies. Pharmacies which have changed ownership will be counted as a closure with a new pharmacy opening on the next day, however this doesn’t affect the net change figures. ‘Opened’ means pharmacies that have joined a Pharmaceutical List and started providing NHS services between the first and last calendar day of the month; and ‘closed’ means pharmacies that have been removed from a list and have ceased providing NHS services between first and last calendar day of the month. Data is as accurate as the data held by the NHSBSA data warehouse at the time of publishing each month. Total figures may not agree month to month due to openings and closures resulting in pharmacies changing group size or where backdated amendments are made. This dataset differs from the General Pharmaceutical Services (GPhS) official statistics publication as the two publications count the number of pharmacies included in a Pharmaceutical List in two different ways. The GPhS publication presents active pharmacies as those which submitted prescriptions to the NHSBSA for processing across a whole year. That methodology used for the GPhS publication differs from the methodology used for this dataset which is set out above, so we would not expect the two to be comparable. We publish the related dataset Consolidated Pharmaceutical List on a quarterly basis.

Washington’s PMP was created (RCW 70.225 (2007)) to improve patient care and to stop prescription drug misuse by collecting dispensing records for Schedule II, III, IV and V drugs, and by making the information available to medical providers and pharmacists as a patient care tool. Program rules, WAC 246-470, took effect August 27, 2011. The program started data collection from all dispensers October 7, 2011.

Under RCW 70.225.040(5)(a), the department is authorized to publish public data after removing information that could be used directly or indirectly to identify individual patients, requestors, dispensers, prescribers, and persons who received prescriptions from dispensers. The data available here are de-identified, and exclude patient, prescriber, and dispenser related information in alignment with program rules WAC 246-470-080. No requestor information is available here.

Prescriptions excluded from PMP include those dispensed outside of WA State, those prescribed for less than or equal to 24 hours, those administered or given to a patient in the hospital, and those dispensed from a Department of Corrections pharmacy (unless an offender is released with a prescription), an Opioid Treatment Program, and some federally operated pharmacies (Indian Health Services and Veterans Affairs report voluntarily since 2015).

Further information on collection and management of PMP data at DOH can be found at www.doh.wa.gov/pmp/data.

NOTE: As of 12/17/2024, this dataset is no longer updated. Please use ASPR Treatments Locator.

This dataset displays pharmacies, clinics, and other locations with safe and effective COVID-19 medications. These medications require a prescription from a healthcare provider. Some locations, known as Test to Treat sites, give you the option to get tested, get assessed by a healthcare provider, and receive treatment – all in one visit. COVID-19 medications may be available at additional locations that are not shown in this dataset.

The locations displayed have either self-attested they have inventory of Paxlovid (nirmatrelvir packaged with ritonavir), Lagevrio (molnupiravir), or Veklury (Remdesivir) within at least the last two months and/or reported participation in the Paxlovid Patient Assistance Program. Sites that have not reported in the last two weeks display a notification, "Inventory has not been reported in the last 2 weeks. Please contact the provider to make sure the product is available." Outpatient COVID-19 medications may be available at additional locations not listed on this website.

All therapeutics identified in the locator not approved by the FDA must be used in alignment with the terms of the respective product’s Emergency Use Authorization. Visit COVID-19 Treatments and Therapeutics for more information on all treatment options.

This website identifies sites that have commercially purchased inventory of COVID-19 treatments and, in some cases, may identify sites that have remaining, no-cost U.S. government distributed supply. Some sites may charge for services not covered by insurance. Some sites may offer telehealth services. This website is intended for informational purposes only and does not serve as an endorsement or recommendation for use of any of the locations listed on the sites.

Clarification for DoD Facilities: Those individuals eligible for care in an MTF include Active Duty Service Members (ADSMs), covered beneficiaries enrolled in TRICARE Prime or Select, including TRICARE Reserve Select (TRS), TRICARE Retired Reserve (TRR) and TRICARE Young Adult (TYA) participants, TRICARE for Life beneficiaries, and individuals otherwise entitled by law to MTF care (e.g., regular retired members and their dependents who are not enrolled in TRICARE but who are otherwise eligible for MTF space-available care, certain foreign military members and their families registered in DEERS, and others).

Appliance Contractors data within the MIS- Report shows data for the following month. (E.g. MIS-Report for January 19 will show February 19 Appliance Contractor data). Data source Source System - ISP (National MIS Files) Time period May 2022 The month refers to the month of the report. Please note Appliance Contractors data within the MIS Report shows data for the following month. (E.g. MIS Report for May 2022 will show June 2022 Appliance Contractor data). This dataset FOI27648 has 2 files – May 2022 MIS Pharmacy and May 2022 MIS Appliance Contractor. This report consists of a management information file detailing monthly Community Pharmacy and Appliance Payments by type of payment and contractor account. Payments include all drug costs, fees, patient charges, locally authorised payments, etc. Other details such as the numbers of items dispensed, patient’s charges collected are also included. The management information file reflects the contractor's payment and prescription data associated with the sustainability and transformation partnerships (STPs) structure at the relevant payment date. The data contained within the files can be interpreted correctly by using the ‘MIS Glossary’ available under ‘Management Information Spreadsheet (MIS) Report’ at https://www.nhsbsa.nhs.uk/information-services-portal-isp/isp-report-information . NHSBSA Prescription Services process prescriptions for Pharmacy Contractors, Appliance Contractors, Dispensing Doctors and Personal Administration with information then used to make payments to pharmacists and appliance contractors in England for prescriptions dispensed in primary care settings (other arrangements are in place for making payments to Dispensing Doctors and Personal Administration). This involves processing over 1 billion prescription items and payments totalling over £9 billion each year. The information gathered from this process is then used to provide information on costs and trends in prescribing in England and Wales to over 25,000 registered NHS and Department of Health and Social Care users. This report consists of a management information file detailing monthly Community Pharmacy and Appliance Payments by type of payment and contractor account. Payments include all drug costs, fees, patient charges, locally authorised payments, etc. Other details such as the numbers of items dispensed, patient’s charges collected are also included. The management information file reflects the contractor's payment and prescription data associated with the sustainability and transformation partnerships (STPs) structure at the relevant payment date.

The Texas Department of Insurance, Division of Workers’ Compensation (DWC) maintains a database of pharmacy medical billing services (SV4). It contains charges, payments, and prescriptions billed on a DWC Form-066, Statement of Pharmacy Services by pharmacies with dates of service more than five years old going back to 2010. For datasets from the past five years, see pharmacy medical billing services (SV4) detail information. The detail section contains information to identify insurance carriers, injured employees, employers, place of service, and diagnostic information. The bill details are individual line items that are grouped in the header section of a single bill. The bill selection date and bill ID must be used to group individual line items into a single bill. Find more information in our pharmacy medical billing services (SV4) detail data dictionary. See pharmacy medical billing services (SV4) header information - historical for the corresponding header records related this dataset. Go to our page on DWC medical state reporting public use data file (PUDF) to learn more about using this information.

Pharmacies licensed in the District of Columbia. For more information on pharmaceutical licensing, please visit the DC Department of Health's website at https://doh.dc.gov. Search for Pharmaceutical Control Division. This dataset was created as part of the DC Geographic Information System (DC GIS) for the D.C. Office of the Chief Technology Officer (OCTO) and the D.C. Department of Health. A database provided by the D.C. Department of Health (Health Regulation and Licensing Administration, Pharmacy Control Division) identified pharmacy locations.

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.

1) A total of 3900 medication pack images were captured at different random angles. There are 26 images per pack. 2) Backgrounds are made of paper, cardboard, and plastic. 3) No transparent, reflexive, or patterned backgrounds are used. 4) 300 images were captured while enabling the flashlight. 5) 3600 images were captured in different lighting conditions without using a flashlight. Some images were even captured at dawn time to try the worst lighting conditions. 6) Pharmaceutical packs only were captured. Nothing was captured without its pack. 7) Captured medication packs contain tablets, capsules, syrups, creams, ampoules, gels, drops, ointments, and other types. Two types of special medical tapes were also captured. 8) 150 different pharmaceutical packages were captured. If there is a difference in the dose, size, or type, it is considered a different pack. 9) Some images were captured by different people after receiving the instructions to simulate a real patient experience. 10) Images were captured using 6 devices: • Huawei P30 Lite • Huawei Cun-L21 • Samsung A50 • Samsung A30s • iPhone XS Max • iPhone 11 Pro Max 11) Some medication packs have handwriting. 12) Some images contain shadows and flash burns. 13) 13) Some packs have different types of damage such as having spills, being ripped, etc. 14) Some images are slightly blurred. 15) All captures were taken in all day and night times for several days to try as much lighting and shadow conditions as possible. 16) The images are in the following resolutions: • 3264 x 2448 pixels – 72 dpi • 4000 x 3000 pixels – 72 dpi • 5632 x 4224 pixels – 96 dpi • 4032 x 3024 pixels – 72 dpi • 4032 x 2268 pixels – 72 dpi Images with dimensions that are greater than or equal to 4000 pixels were reduced by 20% for storing purposes.

The Texas Department of Insurance, Division of Workers’ Compensation (DWC) maintains a database of pharmacy medical billing services (SV4). It contains charges, payments, and prescriptions billed on a DWC Form-066, Statement of Pharmacy Services by pharmacies with dates of service more than five years old going back to 2010. For datasets from the past five years, see pharmacy medical billing services (SV4) detail information.

The detail section contains information to identify insurance carriers, injured employees, employers, place of service, and diagnostic information. The bill details are individual line items that are grouped in the header section of a single bill. The bill selection date and bill ID must be used to group individual line items into a single bill. Find more information in our pharmacy medical billing services (SV4) detail data dictionary.

See pharmacy medical billing services (SV4) header information - historical for the corresponding header records related this dataset.

Go to our page on DWC medical state reporting public use data file (PUDF) to learn more about using this information.

Here are a few use cases for this project:

1. Drug Identification App: The Pills Classification model can be integrated into a mobile app to help individuals, specially elderly and visually-impaired individuals, identify their medications to help prevent medication errors.

2. Aid in Drug Discovery: In the pharmaceutical industry, the model could be used to sort and classify different types of pills during drug discovery and testing phases, making the process more organized.

3. Pharmacy Automation: Pharmacies could use the model to automatically sort and categorize incoming drugs. In turn, this could minimize human error, improve drug dispensing accuracy, and enhance efficiency at a lower cost.

4. Poison Control Usage: In cases of inadvertent ingestion of unknown pills, the model can be used to quickly identify the drug for effective treatment recommendations.

5. Hospital Drug Verification: Hospitals could use the model to verify drugs before being dispensed or given to the patients, thus reducing the chances of human error and potentially dangerous drug mix-ups.

IntroductionOver-the-counter (OTC) medications are those obtained without a medical prescription from a healthcare professional. With the increasing availability of information from various sources, including social media, pharmacy students may be exposed to unreliable or inaccurate data. Incorrect medication use is particularly concerning due to its potential risk of causing adverse health effects.” Hence, this study aims to determine students’ knowledge and attitudes at Taif University’s pharmacy college.MethodsThis research utilized a cross-sectional online questionnaire-based study, employing data from a sample of 450 pharmacy students from Taif University in Saudi Arabia. Descriptive analysis included descriptive and differential analysis. The data were analyzed using statistical package for social sciences (SPSS) Version 27.ResultsThe majority of participants, 297 (88.2%), were aware that inappropriate use of over-the-counter medications might have negative implications. A total of 233 participants (51.8%) reported having previously used an OTC medication. Also, 293 (65.1%), were aware that using OTC medications beyond their expiration date was harmful. A total of 280 participants (62.2%) had a high knowledge of OTC medication, whereas 170 respondents (37.8%) had a low level of knowledge. A significant correlation was found between age, year of study, and the use of OTC medication p-values  0.05).ConclusionThe study found positive attitudes toward OTC medications. Due to increased pharmaceutical exposure and self-medication, upper-year students and OTC course graduates comprehend OTC medications better. The examination found safety protocol violations in expiration dates, prescription label interpretation, and storage. Therefore, the study provides useful information for future attempts. Also, this study may contribute to the literature and guide future research to fill knowledge gaps.

This dataset provides a list of drugstores, pharmacies and licensed pharmacists names in the United States, as well as the territories of American Samoa, Guam, Puerto Rico, the Commonwealth of the Northern Mariana Islands, and the Virgin Islands, with detailed geolocation identifiers such as latitude and longitude of each drugstore or pharmacy, as well as telephone numbers, addresses, website URLs and other provider information.

A list of Pharmacies in Ireland, with geographical coordinates. All data linked to the Open data portal is published “as is”. The Information is licensed 'as is' and the Information Provider and/or Licensor excludes all representations, warranties, obligations and liabilities in relation to the Information to the maximum extent permitted by law. The Information Provider and/or Licensor are not liable for any errors or omissions in the Information and shall not be liable for any loss, injury or damage of any kind caused by its use. The Information Provider does not guarantee the continued supply of the Information.

DOWNLOAD SERVICE OF THE PHARMACY DATASET. Compressed folder (zip) containing TWO shapefile SETs (shp, dbf,shx,prj) on time for pharmacies located in the territory of Milan and those located in the Metropolitan City area (excluding Milan). The data were drawn from Open Data Regione Lombardia https://www.dati.lombardia.it/ in table format with IODL 2.0 license and were processed, standardised, integrated and converted into geographical format by the Municipality of Milan — Central SIT Unit for their representation in map (Work derivative). The data are available in shapefile format in the GCS_WGS_1984 coordinate system. The data as shown are not validated by the Municipality of Milan and therefore their purpose is to be considered informational only. The Municipality of Milan makes no representations of warranty or other kind in this regard and is not in any case responsible, nor assumes any responsibility, for any use made by third parties of the material.

The General Pharmaceutical Services in England report shows information about community pharmacy contractors (community pharmacies) and appliance contractors in England, and the NHS services they provided It is a National Statistics publication and is the only national level dataset that shows this information. It may be of interest to members of the public, healthcare professionals, policy officials and other stakeholders.

The data provided in this publication comes from NHS Prescription Services, a division of NHS Business Services Authority, NHS England Local Area Teams and NHS Litigation Authority Family Health Services Appeal Unit. The data covers community pharmacy contractors and appliance contractors on the NHS England pharmaceutical list dispensing NHS prescriptions under the NHS (Pharmaceutical Services and Local Pharmaceutical Services) Regulations.