data-raw/query-urls.R

In britishredcrosssociety/geographr: R package for mapping UK geographies

# ---- Load libraries ----
library(tibble)

# ---- Build data ----
# ONS geoportal query urls can be found on the "API Explorer" tab.
query_urls <-
  tribble(

    # Column Names
    ~geog_type, ~id, ~publish_date, ~license, ~query, ~source,

    # Boundaries
    "boundaries", "ccg21", "01.04.21", "OGLv3", "https://opendata.arcgis.com/datasets/d6acd30ad71f4e14b4de808e58d9bc4c_0.geojson", "https://geoportal.statistics.gov.uk/datasets/clinical-commissioning-groups-april-2021-en-buc/explore?location=51.835875%2C-2.452657%2C6.00",
    "boundaries", "countries20", "01.12.20", "OGLv3", "https://opendata.arcgis.com/datasets/bb7104d3a9c04937be57e408288282dc_0.geojson", "https://geoportal.statistics.gov.uk/datasets/countries-december-2020-uk-buc/explore?location=54.650000C-3.250000%2C6.04",
    "boundaries", "dz11", "01.01.11", "OGLv3", "https://maps.gov.scot/ATOM/shapefiles/SG_DataZoneBdry_2011.zip", "https://spatialdata.gov.scot/geonetwork/srv/eng/catalog.search#/metadata/7d3e8709-98fa-4d71-867c-d5c8293823f2",
    "boundaries", "hb19", "01.01.19", "OGLv3", "https://maps.gov.scot/ATOM/shapefiles/SG_NHS_HealthBoards_2019.zip", "https://spatialdata.gov.scot/geonetwork/srv/eng/catalog.search;jsessionid=2BA249588D00C49F254018A42F2C6958#/metadata/f12c3826-4b4b-40e6-bf4f-77b9ed01dc14",
    "boundaries", "icb22", "01.07.22", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/ICB_JUL_2022_EN_BUC_V3/FeatureServer/replicafilescache/ICB_JUL_2022_EN_BUC_V3_5138400207907180607.geojson", "https://geoportal.statistics.gov.uk/datasets/ons::integrated-care-boards-july-2022-en-buc-4/explore",
    "boundaries", "iz11", "01.01.11", "OGLv3", "https://maps.gov.scot/ATOM/shapefiles/SG_IntermediateZoneBdry_2011.zip", "https://spatialdata.gov.scot/geonetwork/srv/eng/catalog.search#/metadata/389787c0-697d-4824-9ca9-9ce8cb79d6f5",
    "boundaries", "lhb20", "01.04.20", "OGLv3", "https://opendata.arcgis.com/datasets/ed5dccae76204a0ea411fcbbe1132659_0.geojson", "https://geoportal.statistics.gov.uk/datasets/local-health-boards-april-2020-wa-buc/explore?location=52.383842%2C-4.058123%2C8.70",
    "boundaries", "lhb22", "14.04.22", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/Local_Health_Boards_April_2022_WA_BFC_2022/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/ons::local-health-boards-april-2022-wa-bfc-1/explore?location=52.389238%2C-4.227835%2C9.32",
    "boundaries", "lsoa11", "01.12.11", "OGLv3", "https://opendata.arcgis.com/datasets/e9d10c36ebed4ff3865c4389c2c98827_0.geojson", "https://geoportal.statistics.gov.uk/datasets/lower-layer-super-output-areas-december-2011-boundaries-super-generalised-clipped-bsc-ew-v3/explore?location=52.837570%2C-2.489798%2C7.20",
    "boundaries", "ltla19", "01.12.19", "OGLv3", "https://opendata.arcgis.com/datasets/3a4fa2ce68f642e399b4de07643eeed3_0.geojson", "https://geoportal.statistics.gov.uk/datasets/local-authority-districts-december-2019-boundaries-uk-buc/explore?location=55.340150%2C-3.316300%2C6.22",
    "boundaries", "ltla20", "12.03.21", "OGLv3", "https://opendata.arcgis.com/datasets/69d8b52032024edf87561fb60fe07c85_0.geojson", "https://geoportal.statistics.gov.uk/datasets/ons::local-authority-districts-december-2020-uk-buc-1/explore?location=55.340122%2C-3.316413%2C5.95",
    "boundaries", "ltla21", "01.12.21", "OGLv3", "https://opendata.arcgis.com/datasets/ac4ad96a586b4e4bab306dd59eb09401_0.geojson", "https://geoportal.statistics.gov.uk/datasets/local-authority-districts-december-2021-uk-buc/explore?location=57.654858%2C-11.079503%2C13.82",
    "boundaries", "ltla24", "02.07.24", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/Local_Authority_Districts_May_2024_Boundaries_UK_BUC/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ons::local-authority-districts-may-2024-boundaries-uk-buc-2/about",
    "boundaries", "msoa11", "01.12.11", "OGLv3", "https://opendata.arcgis.com/datasets/80223f1d571c405fb2fdf719c7e6da13_0.geojson", "https://geoportal.statistics.gov.uk/datasets/middle-layer-super-output-areas-december-2011-boundaries-super-generalised-clipped-bsc-ew-v3/explore?location=52.846044%2C-2.465779%2C7.21",
    "boundaries", "msoa21", "12.07.23", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/MSOA_2021_EW_BSC_V2/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ed5c7b7d733d4fd582281f9bfc9f02a2_0/explore?location=52.800500%2C-2.489483%2C7.84",
    "boundaries", "pfa20", "01.12.20", "OGLv3", "https://opendata.arcgis.com/datasets/2a1e3c23f1f24f15808275f52b8ae20d_0.geojson", "https://geoportal.statistics.gov.uk/datasets/police-force-areas-december-2020-ew-buc/explore?location=52.846527%2C-2.452657%2C7.21",
    "boundaries", "region21", "15.03.22", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/Regions_December_2021_EN_BFC/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/ons::regions-december-2021-en-bfc/about",
    "boundaries", "sdz21", "21.02.23", "OGLv3", "https://www.nisra.gov.uk/sites/nisra.gov.uk/files/publications/geography-sdz2021-esri-shapefile.zip", "https://www.nisra.gov.uk/publications/geography-super-data-zone-boundaries-gis-format",
    "boundaries", "soa11", "01.01.11", "OGLv3", "https://www.nisra.gov.uk/sites/nisra.gov.uk/files/publications/SOA2011_Esri_Shapefile_0.zip", "https://www.nisra.gov.uk/publications/super-output-area-boundaries-gis-format",
    "boundaries", "stp21", "01.04.21", "OGLv3", "https://opendata.arcgis.com/datasets/7ee99c1d8ef4424bab4b933a5dbe6aca_0.geojson", "https://geoportal.statistics.gov.uk/datasets/sustainability-and-transformation-partnerships-april-2021-en-buc/explore?location=52.846526%2C-2.452657%2C7.21",
    "boundaries", "trusts_ni18", "21.03.18", "OGLv3", "https://www.opendatani.gov.uk/dataset/0b04b46c-49af-45d5-b277-91b10937a01b/resource/7fa52dde-90b8-446e-bb79-4871d1028cb4/download/dohtrustboundary.zip", "https://www.opendatani.gov.uk/dataset/department-of-health-trust-boundaries/resource/7fa52dde-90b8-446e-bb79-4871d1028cb4",
    "boundaries", "utla19", "01.12.19", "OGLv3", "https://opendata.arcgis.com/datasets/b216b4c8a4e74f6fb692a1785255d777_0.geojson", "https://geoportal.statistics.gov.uk/datasets/counties-and-unitary-authorities-december-2019-boundaries-uk-buc/explore?location=54.155480%2C-3.250000%2C6.00",
    "boundaries", "utla20", "28.04.21", "OGLv3", "https://opendata.arcgis.com/datasets/aff50e8d15364a7b82c62c14861eb240_0.geojson", "https://geoportal.statistics.gov.uk/datasets/ons::counties-and-unitary-authorities-december-2020-uk-bgc/explore?location=54.650000%2C-3.250000%2C5.81",
    "boundaries", "utla21", "15.09.21", "OGLv3", "https://opendata.arcgis.com/datasets/69109c4fbbc54f1f9d6e18000031a5fd_0.geojson", "https://geoportal.statistics.gov.uk/datasets/counties-and-unitary-authorities-may-2021-uk-buc/explore?location=55.340122%2C-3.316413%2C6.22",
    "boundaries", "vcsep22", "14.09.22", "OGLv3", "https://raw.githubusercontent.com/VCS-Emergencies-Partnership/ad-hoc-analysis/main/analysis/vcsep_regions_boundaries/vcsep_regions_updated/vcsep_regions_updated.geojson", "https://github.com/VCS-Emergencies-Partnership/ad-hoc-analysis/tree/main/analysis/vcsep_regions_boundaries",
    "boundaries", "wards21", "01.12.21", "OGLV3", "https://opendata.arcgis.com/datasets/bf9d32b1aa9941af84e6c2bf0c54b1bb_0.geojson", "https://geoportal.statistics.gov.uk/datasets/wards-december-2021-uk-bsc/explore",
    "boundaries", "wards22", "25.11.22", "OGLV3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/Wards_December_2022_Boundaries_UK_BSC/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ons::wards-december-2022-boundaries-uk-bsc/about",

    # Points
    "points", "nhs_trusts22", "23.04.22", "OGLv3", "https://files.digital.nhs.uk/assets/ods/current/etr.zip", "https://digital.nhs.uk/services/organisation-data-service/file-downloads/other-nhs-organisations",

    # Lookups
    "lookup", "dz11_iz11_ltla20", "", "OGLv3", "https://www.gov.scot/binaries/content/documents/govscot/publications/statistics/2020/01/scottish-index-of-multiple-deprivation-2020-data-zone-look-up-file/documents/scottish-index-of-multiple-deprivation-data-zone-look-up/scottish-index-of-multiple-deprivation-data-zone-look-up/govscot%3Adocument/SIMD_2020_Datazone_lookup_tool.xlsx", "https://www.gov.scot/publications/scottish-index-of-multiple-deprivation-2020-data-zone-look-up/",
    "lookup", "dz11_ltla19_hb19", "15.05.23", "OGLv3", "https://www.opendata.nhs.scot/en_GB/datastore/dump/d6e500c4-c1f2-4507-979a-e18855efd7a4?bom=True", "https://www.opendata.nhs.scot/en_GB/dataset/sub-health-and-social-care-partnership-areas/resource/d6e500c4-c1f2-4507-979a-e18855efd7a4",
    "lookup", "dz21_sdz21_dea14_lgd14", "01.09.23", "OGLv3", "https://www.nisra.gov.uk/sites/nisra.gov.uk/files/publications/geography-data-zone-and-super-data-zone-lookups.xlsx", "https://www.nisra.gov.uk/support/geography",
    "lookup", "lsoa11_ccg21_stp21_ltla21", "01.04.21", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA11_CCG21_STP21_LAD21_EN_LU/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ons::lsoa-2011-to-clinical-commissioning-groups-to-sustainability-and-transformation-partnerships-april-2021-lookup-in-england/explore",
    "lookup", "lsoa11_lsoa21_ltla22", "15.08.22", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA11_LSOA21_LAD22_EW_LU/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/lsoa-2011-to-lsoa-2021-to-local-authority-district-2022-lookup-for-england-and-wales-version-2/about",
    "lookup", "lsoa11_ltla18", "2.4.18", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA11_CCG18_LAD18_EN_LU_3aaed40f43e84c2787ba8b5ace264b6c/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ons::lower-layer-super-output-area-2011-to-clinical-commissioning-group-to-local-authority-district-april-2018-lookup-in-england-1/about",
    "lookup", "lsoa11_ltla19", "18.12.19", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA11_WD19_LAD19_EW_LU/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/ons::lower-layer-super-output-area-2011-to-ward-2019-lookup-in-england-and-wales/explore",
    "lookup", "lsoa11_ltla20", "22.01.21", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA11_WD20_LAD20_EW_LU_v2/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/ons::lower-layer-super-output-area-2011-to-ward-2020-to-lad-2020-lookup-in-england-and-wales-v2/about",
    "lookup", "lsoa11_ltla21", "25.11.21", "OGLv3", "https://www.arcgis.com/sharing/rest/content/items/81bcefcd048e43acb948ad069c5e06c0/data", "https://geoportal.statistics.gov.uk/documents/ons::lower-layer-super-output-area-2011-to-ward-2021-to-lad-2021-lookup-in-england-and-wales/about",
    "lookup", "lsoa11_msoa11", "03.08.18", "OGLv3", "https://opendata.arcgis.com/datasets/fe6c55f0924b4734adf1cf7104a0173e_0.csv", "http://geoportal.statistics.gov.uk/datasets/fe6c55f0924b4734adf1cf7104a0173e_0",
    "lookup", "lsoa11_sicbl22_icb22_ltla22", "01.07.22", "OGLv3", "https://opendata.arcgis.com/api/v3/datasets/423c8069710c4d488d5ff99475688101_0/downloads/data?format=csv&spatialRefId=4326&where=1%3D1", "https://geoportal.statistics.gov.uk/datasets/ons::lsoa-2011-to-sub-icb-locations-to-integrated-care-boards-july-2022-lookup-in-england/explore",
    "lookup", "lsoa11_ward17", "", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LSOA11_WD17_EW_LU_c65dfe9ca2fa4b0fa578b65a4d5c9856/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ons::lower-layer-super-output-area-2011-to-ward-2017-lookup-in-england-and-wales-1/about",
    "lookup", "ltla19_cauth19", "17.12.19", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LAD19_CAUTH19_EN_LU/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/ons::local-authority-district-to-combined-authority-december-2019-lookup-in-england/about",
    "lookup", "ltla20_cauth20", "27.11.2020", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LAD20_CAUTH20_EN_LU/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/ons::local-authority-district-to-combined-authority-december-2020-lookup-in-england/about",
    "lookup", "ltla21_cauth21", "17.02.22", "OGLv3", "https://www.arcgis.com/sharing/rest/content/items/93720e02514b408eb16cad5be13a2899/data", "https://geoportal.statistics.gov.uk/documents/local-authority-district-to-combined-authority-december-2021-lookup-in-england-v2/about",
    "lookup", "ltla21_fra21", "30.03.21", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LAD21_FRA21_EW_LU/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/ons::local-authority-district-to-fire-and-rescue-authority-april-2021-lookup-in-england-and-wales/about",
    "lookup / code history database", "ltla_ltla", "4.7.24", "OGLv3", "https://www.arcgis.com/sharing/rest/content/items/d7be63c8bd144ae0a26c6593eb5e00b7/data", "https://geoportal.statistics.gov.uk/datasets/d7be63c8bd144ae0a26c6593eb5e00b7/about",
    "lookup", "ltla19_region19", "28.03.19", "OGLv3", "https://opendata.arcgis.com/datasets/3ba3daf9278f47daba0f561889c3521a_0.geojson", "https://geoportal.statistics.gov.uk/datasets/ons::local-authority-district-to-region-april-2019-lookup-in-england/about",
    "lookup", "ltla20_region20", "30.11.20", "OGLv3", "https://opendata.arcgis.com/datasets/054349b09c094df2a97f8ddbd169c7a7_0.geojson", "https://geoportal.statistics.gov.uk/datasets/ons::local-authority-district-to-region-december-2020-lookup-in-england/about",
    "lookup", "ltla21_region21", "30.03.21", "OGLv3", "https://opendata.arcgis.com/datasets/6a41affae7e345a7b2b86602408ea8a2_0.geojson", "https://geoportal.statistics.gov.uk/datasets/ons::local-authority-district-to-region-april-2021-lookup-in-england/about",
    "lookup", "ltla19_utla19", "28.03.19", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LTLA19_UTLA19_EW_LU/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/lower-tier-local-authority-to-upper-tier-local-authority-april-2019-lookup-in-england-and-wales/explore",
    "lookup", "ltla20_utla20", "30.11.20", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LTLA20_UTLA20_EW_LU/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/lower-tier-local-authority-to-upper-tier-local-authority-december-2020-lookup-in-england-and-wales/explore",
    "lookup", "ltla21_lhb22", "30.12.22", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/UA22_LHB22_WA_LU/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ons::unitary-authority-to-local-health-board-december-2022-lookup-in-wales/explore",
    "lookup", "ltla21_utla21", "30.03.21", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LTLA21_UTLA21_EW_LU/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/lower-tier-local-authority-to-upper-tier-local-authority-april-2021-lookup-in-england-and-wales/explore",
    "lookup", "ltla21_vcsep22", "14.09.22", "OGLv3", "https://raw.githubusercontent.com/VCS-Emergencies-Partnership/ad-hoc-analysis/main/analysis/vcsep_regions_boundaries/vcsep_regions_updated/vcsep_regions_updated_ltlas.csv", "https://github.com/VCS-Emergencies-Partnership/ad-hoc-analysis/blob/main/analysis/vcsep_regions_boundaries/vcsep_boundaries.R",
    "lookup", "ltla22_ltla23", "05.04.23", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LAD22_LAD23_UK_LU/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ons::local-authority-district-2022-to-local-authority-district-2023-lookup-for-ew/about",
    "lookup", "ltla23_cauth23", "15.05.2023", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LAD23_CAUTH23_EN_LU/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ons::local-authority-district-to-combined-authority-december-2023-lookup-in-en/about",
    "lookup", "ltla23_region23", "22.11.23", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LAD23_RGN23_EN_LU/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ons::local-authority-district-to-region-april-2023-lookup-in-en/about",
    "lookup", "ltla23_utla23", "05.04.23", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/LTLA23_UTLA23_EW_LU/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ons::lower-tier-local-authority-to-upper-tier-local-authority-april-2023-lookup-in-ew/about",
    "lookup", "msoa11_ltla19", "18.12.19", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/MSOA11_WD19_LAD19_EW_LU/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/ons::middle-layer-super-output-area-2011-to-ward-to-ltla-december-2019-lookup-in-england-and-wales/about",
    "lookup", "msoa11_ltla20", "30.11.20", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/MSOA11_WD20_LAD20_EW_LU/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/ons::middle-layer-super-output-area-2011-to-ward-to-ltla-december-2020-lookup-in-england-and-wales/about",
    "lookup", "msoa11_ltla21", "25.11.21", "OGLv3", "https://www.arcgis.com/sharing/rest/content/items/b4c0247ef8564d419bdeb1eda13f2d0f/data", "https://geoportal.statistics.gov.uk/documents/middle-layer-super-output-area-2011-to-ward-to-ltla-december-2021-lookup-in-england-and-wales/about",
    "lookup", "msoa11_msoa21_ltla22", "15.08.22", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/MSOA11_MSOA21_LAD22_EW_LU_V2/FeatureServer/0/query?where=1%3D1&outFields=*&outSR=4326&f=json", "https://geoportal.statistics.gov.uk/datasets/ons::msoa-2011-to-msoa-2021-to-local-authority-district-2022-lookup-for-england-and-wales-version-2/about",
    "lookup", "nhs_trust22_msoa11", "26.06.22", "?", "https://app.box.com/index.php?rm=box_download_shared_file&shared_name=qh8gzpzeo1firv1ezfxx2e6c4tgtrudl&file_id=f_976234504165", "https://app.box.com/s/qh8gzpzeo1firv1ezfxx2e6c4tgtrudl",
    "lookup", "postcode_dz21_sdz21_dea14_lgd14", "2023", "OGLv3", "https://www.arcgis.com/sharing/rest/content/items/3700342d3d184b0d92eae99a78d9c7a3/data", "https://geoportal.statistics.gov.uk/datasets/ons-postcode-directory-november-2023/about",
    "lookup", "postcode_oa11_lsoa11_msoa11_ltla20", "23.11.20", "OGLv3", "https://www.arcgis.com/sharing/rest/content/items/9f629cd0c2fb42beb0d79a474fee4776/data", "https://geoportal.statistics.gov.uk/datasets/9f629cd0c2fb42beb0d79a474fee4776/about",
    "lookup", "postcode_oa21_lsoa21_msoa21_ltla22", "29.11.21", "OGLv3", "https://www.arcgis.com/sharing/rest/content/items/bcfc75627db44bb4b0261f8578361954/data", "https://geoportal.statistics.gov.uk/datasets/postcode-to-output-area-hierarchy-to-ltla-to-utla-to-region-to-country-may-2021-lookup-in-england-and-wales-1/about",
    "lookup", "sa11_soa11_lgd18", "23.08.22", "OGLv3", "https://opendata.arcgis.com/datasets/096a7ccbc8e244cc972189b2f07a321a_0.csv", "https://geoportal.statistics.gov.uk/datasets/small-areas-2011-to-soas-to-local-government-districts-december-2018-lookup-with-area-classifications-in-northern-ireland",
    "lookup", "scottish_postcode_directory", "2024", "OGLv3", "https://www.nrscotland.gov.uk/files//geography/2024-1/SPD_PostcodeIndex_Cut_24_1_CSV.zip", "https://www.nrscotland.gov.uk/statistics-and-data/geography/our-products/scottish-postcode-directory/2024-1",
    "lookup", "soa01_lgd14", "01.01.14", "OGLv3", "https://www.nisra.gov.uk/sites/nisra.gov.uk/files/publications/Lookup-Table-SA-OA-and-SOA-to-LGD2014-%28statistical-geographies%29-2013.ods", "https://www.nisra.gov.uk/publications/geography-lookup-tables",
    "lookup", "trust_trust_successor", "26.09.22", "OGLv3", "https://files.digital.nhs.uk/assets/ods/current/succ.zip", "https://digital.nhs.uk/services/organisation-data-service/file-downloads/miscellaneous",
    "lookup", "trust_trust_successor_archived", "26.09.22", "OGLv3", "https://files.digital.nhs.uk/assets/ods/current/succarc.zip", "https://digital.nhs.uk/services/organisation-data-service/file-downloads/miscellaneous",
    "lookup", "ward21_ltla21", "25.11.21", "OGLv3", "https://www.arcgis.com/sharing/rest/content/items/fe123ab719b2488ab41dd9c6aa84e79b/data", "https://geoportal.statistics.gov.uk/documents/ward-to-local-authority-district-december-2021-lookup-in-the-united-kingdom/about",

    # Names and codes
    "names_codes", "nhs_region21", "04.01.22", "OGLv3", "https://services1.arcgis.com/ESMARspQHYMw9BZ9/arcgis/rest/services/NHS_England_Regions_(April_2021)_in_England/FeatureServer/0/query?outFields=*&where=1%3D1&f=geojson", "https://geoportal.statistics.gov.uk/datasets/ons::nhs-england-region-april-2021-names-and-codes-in-england/about",
    "names_codes", "nhs_scotland_health_boards19", "17.06.20", "OGLv3", "https://www.opendata.nhs.scot/dataset/9f942fdb-e59e-44f5-b534-d6e17229cc7b/resource/652ff726-e676-4a20-abda-435b98dd7bdc/download/hb14_hb19.csv", "https://www.opendata.nhs.scot/dataset/geography-codes-and-labels/resource/652ff726-e676-4a20-abda-435b98dd7bdc",

    # Rural-Urban Classifications
    "ruc", "ruc16_dz11", "01.01.16", "OGLv3", "https://www.gov.scot/binaries/content/documents/govscot/publications/advice-and-guidance/2018/03/scottish-government-urban-rural-classification-2016/documents/scottish-government-urban-rural-classification-2016-data-zone-lookup/scottish-government-urban-rural-classification-2016-data-zone-lookup/govscot%3Adocument/00544928.csv", "https://www.gov.scot/publications/scottish-government-urban-rural-classification-2016/pages/2/",
    "ruc", "ruc11_lsoa11", "01.01.11", "OGLv3", "https://opendata.arcgis.com/datasets/276d973d30134c339eaecfc3c49770b3_0.geojson", "https://geoportal.statistics.gov.uk/datasets/rural-urban-classification-2011-of-lower-layer-super-output-areas-in-england-and-wales/explore",
    "ruc", "ruc11_msoa11", "01.01.11", "OGLv3", "https://opendata.arcgis.com/datasets/0af77205a4644af3af2175d21a4ef4db_0.geojson", "https://geoportal.statistics.gov.uk/datasets/rural-urban-classification-2011-of-middle-layer-super-output-areas-in-england-and-wales/explore",
    "ruc", "ruc11_wards11", "01.01.11", "OGLv3", "https://opendata.arcgis.com/datasets/21bb76b77a144ee081e8d846b888962f_0.geojson", "https://geoportal.statistics.gov.uk/datasets/rural-urban-classification-2011-of-wards-in-england-and-wales/explore"
  )

usethis::use_data(query_urls, internal = TRUE, overwrite = TRUE)