tijmenb

---
- "/drink-drive-course"
- "/drink-drive-limit"
- "/drink-driving-penalties"
- "/drinking-banning-order"
- "/driver-certificate-of-professional-competence-cpc"
- "/driver-cpc-starting-up-approved-training-centre"
- "/driver-cpc-training"
- "/driver-cpc-training-courses"
- "/drivers-hours"

tijmenb

# ssh content-store-1.backend
# govuk_app_console content-store

ContentItem.distinct(:document_type).each do |document_type|
  publishing_apps = ContentItem.where(document_type: document_type).distinct(:publishing_app)
  puts "#{document_type}\t#{publishing_apps.join(', ')}"
end

tijmenb

# this should provide you with 20 random paths from each of the rendering apps on GOV.UK
#
# ssh content-store-1.integration
# govuk_app_console content-store

require 'yaml'
paths = []

ContentItem.distinct(:rendering_app).each do |rendering_app|
  coll = ContentItem.where(rendering_app: rendering_app)

tijmenb

---
- "/drink-drive-course"
- "/drink-drive-limit"
- "/drink-driving-penalties"
- "/drinking-banning-order"
- "/driver-certificate-of-professional-competence-cpc"
- "/driver-cpc-starting-up-approved-training-centre"
- "/driver-cpc-training"
- "/driver-cpc-training-courses"
- "/drivers-hours"

tijmenb

{
   "analytics_identifier":null,
   "base_path":"/organisations",
   "content_id":"3dd455fc-d0b6-40b9-8746-00bcb77185cd",
   "document_type":"finder",
   "first_published_at":"2016-10-25T09:35:58.000+00:00",
   "format":"finder",
   "locale":"en",
   "public_updated_at":"2016-10-25T09:35:58.000+00:00",
   "publishing_app":"whitehall",

tijmenb

[
  {
    "original_url": "https://gdsdata.blog.gov.uk/e-claims-service-assessment/",
    "title": "E-Claims - Service Assessment",
    "summary": "The E-Claims service is a management and control system for the delivery of DCLG and DWP programmes to meet European Commission guidelines. The public facing component of the service allows users to apply for European Regional Development Fund (ERDF) or European Social Fund (ESF) money.",
    "body": "**Department / Agency:**  \nDCLG\n\n**Date of Original Assessment:**  \n8/06/2015\n\n**Date of Reassessment:**  \n11/12/2015\n\n**Assessment Stage:**  \nalpha\n\n**Result of Original Assessment:**  \nNot Pass\n\n**Result of Reassessment:**  \nPass\n\n**Lead Assessor:**  \nH. Garrett (Original) / M. Brunton-Spall (Reassessment)\n\n**Service Manager:**  \nD. Watkinson\n\n**Digital Leader:**  \nP. White\n\n* * *\n\n## Reassessment Report\n\n**11th December 2015**\n\nThe E-Claims service has been reviewed against the 18 points of the Service Standard at the end of the al

tijmenb

[
  {
    "original_url": "https://gdsdata.blog.gov.uk/e-claims-service-assessment/",
    "title": "E-Claims - Service Assessment",
    "summary": "The E-Claims service is a management and control system for the delivery of DCLG and DWP programmes to meet European Commission guidelines. The public facing component of the service allows users to apply for European Regional Development Fund (ERDF) or European Social Fund (ESF) money.",
    "body": "**Department / Agency:**  \nDCLG\n\n**Date of Original Assessment:**  \n8/06/2015\n\n**Date of Reassessment:**  \n11/12/2015\n\n**Assessment Stage:**  \nalpha\n\n**Result of Original Assessment:**  \nNot Pass\n\n**Result of Reassessment:**  \nPass\n\n**Lead Assessor:**  \nH. Garrett (Original) / M. Brunton-Spall (Reassessment)\n\n**Service Manager:**  \nD. Watkinson\n\n**Digital Leader:**  \nP. White\n\n* * *\n\n## Reassessment Report\n\n**11th December 2015**\n\nThe E-Claims service has been reviewed against the 18 points of the Service Standard at the end of the al

tijmenb

- "/make-will"
- "/marriages-civil-partnerships"
- "/maximum-weekly-working-hours"
- "/national-insurance"
- "/check-driving-test"
- "/national-minimum-wage-rates"
- "/order-copy-birth-death-marriage-certificate"
- "/tax-help"
- "/parental-rights-responsibilities"
- "/pension-credit-calculator"

tijmenb

- "/aberdare-townscape-heritage-initiative"
- "/aberdeen-city-and-shire-first-employee-grant-scheme"
- "/access-finance-hbv-loan-funds"
- "/access-to-finance-nw"
- "/actuaries-england-scotland-wales"
- "/adult-placement-services-registration-scotland"
- "/advanced-manufacturing-supply-chain-initiative-wmlcr"
- "/advice-new-existing-businesses-hertfordshire"
- "/advisory-services-fermanagh"
- "/agri-food-biosciences-institute-afbi"

tijmenb

topics = Whitehall.publishing_api_v2_client.get_linkables(document_type: "topic")
slugs = topics.map { |topic| topic["base_path"].gsub("/topic/", "") }
y SpecialistSector.where('tag NOT IN (?)', slugs).as_json