Changes in version 1.2.0.9000 - Updated geo_hierarchy, and associated fetch_* functions with latest 2025 lookups. - Updated pretty_num() function to add abbreviate argument giving the option to avoid displaying large numbers in millions/billions. Changes in version 1.2.0 - Added geo_hierarchy, which supersedes wd_pcon_lad_la_rgn_ctry and adds 2025 along with mayoral columns. - Added fetch_mayoral(). Changes in version 1.1.0 - Added a function that checks Databricks variables for ODBC connections: check_databricks_odbc(). - Updated wd_pcon_lad_la_rgn_ctry by adding three digit local authority codes (also known as old_la_codes) to the data. - Added old_la_codes which is an internal lookup table of local authorities with their names, nine digit codes and 'old' three digit codes. It is used to add 'old' 3 digit la codes to wd_pcon_lad_la_rgn_ctry. - Updated fetch_las() so that old_la_codes are included in the output. Changes in version 1.0.1 (2025-01-15) Fix the spacing and printing of the z_replace() warning message, updating the eesyapi URL in the README and removed extraneous package tests. Changes in version 1.0.0 (2025-01-13) Initial CRAN release. Added lookup data geog_time_identifiers. Added z_replace() to replace NA values in tables except for ones in geography and time columns that match ones in geog_time_identifiers. Changes in version 0.6.1 Patch to update the pretty_num() function so that the dp argument's default is 0. Changes in version 0.6.0 Update pretty_num so that: - it can take single or multiple values. - it has the argument nsmall that allows control over the number of digits displayed after rounding. Add pretty_num_table() which uses pretty_num() to format numbers in a readable format in data frames. It has all the customization provided by pretty_num. Changes in version 0.5.1 Patch to update the get_clean_sql() function to ignore lines starting with 'USE'. Changes in version 0.5.0 Add the following lookup data sets into the package: - ons_geog_shorthands - countries - regions - wd_pcon_lad_la_rgn_ctry Add the following fetch_locations() functions: - fetch_wards() - fetch_pcons() - fetch_lads() - fetch_las() - fetch_regions() - fetch_countries() Add wrapper for ONS Open Geography Portal API: - get_ons_api_data() Add helper for turning messages on or off: - toggle_message() Changes in version 0.4.1 Update comma_sep() function to allow non-numeric values instead of throwing an error, now returns them unchanged. Changes in version 0.4.0 Add function which creates a DfE R project: - create_project() Changes in version 0.3.1 Fix bug in get_clean_sql() where using the additional settings would lose the original SQL statement. Changes in version 0.3.0 Add pretty_* functions for presenting pretty numbers: - pretty_num() - pretty_filesize() - pretty_time_taken() Add helper function for comma separating numbers: - comma_sep() Changes in version 0.2.0 Add function for formatting financial years: - format_fy() Add reversing functions for academic and financial years: - format_ay_reverse() - format_fy_reverse() Add function for grabbing and cleaning a SQL script, and vignette for connecting to SQL. - get_clean_sql() Changes in version 0.1.1 Add default value to decimal place argument of round_five_up() function. Changes in version 0.1.0 Relaunch of the package with two functions: - format_ay() - round_five_up()