Skip to contents

Connect

connect_bq()
Connect to the OpenPrescribing BigQuery database

Query tables

Query the main OpenPrescribing tables

get_practices()
Get practices
get_normalised_prescribing()
Get normalised prescribing

Lookup tables

practice_settings
Practice setting codes and labels
practice_statuses
Practice status codes and labels

Sample data

Five-row samples of the main tables, bundled so examples run without a BigQuery connection

practices_sample
Sample of the practices table
normalised_prescribing_sample
Sample of the normalised_prescribing table
practice_statistics_sample
Sample of the practice_statistics table
regional_teams_sample
Sample of the regional_teams table