Skip to contents

All functions

collect_collections()
For a provided url, returns links associated with statistical collections
collect_links()
For a provided url, returns links associated with uploaded statistical publication files
create_bq_table()
For a provided table, create and upload a table to BigQuery
download_cover()
Download the cover sheet from a published DfT table
download_orr_cover()
Download the cover sheet from a published ORR table
extract_metadata()
Extract metadata from the most recent DfT files in a Google Cloud Storage bucket
extract_orr_metadata()
Extract metadata from the most recent ORR files in a Google Cloud Storage bucket
extract_orr_urls()
For a provided url, return a table of urls of uploaded ODS and CSV files
extract_table_urls()
For a provided url, return a table of urls of uploaded ODS and CSV files
gcp_tables_to_list()
To tidy published DfT data, stored in GCP, and move to BigQuery
gcp_to_bq()
To tidy published DfT data, stored in GCP, and move to BigQuery
scrape_links()
For a provided url, reads in the page and extracts all the link addresses from that page
scrape_odd_methodology()
For a provided url, return those stats which have dynamically updating methodology links
scrape_orr_methodology()
For a provided ORR url, return those stats which have dynamically updating methodology links
scrape_tables()
For a provided url, returns urls of uploaded ODS and CSV files associated with statistical publications
tidied_df()
Tidies tables in ODS workbooks and converts to long format
year_column_check()
For a given vatiable, check if it includes year information