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
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_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 methdology 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