mapping.py

# NB in the comments i describe the source data

# query to get the data required to make this mapping:
# select a.value, q.id, q.title, q.cell_column, q.cell_row, q.identifier, q2.identifier, q2.column_headers, q2.row_headers from answers a join questions q on a.question_id = q.id left join questions q2 on q.parent_id = q2.id where a.value <> '""' and q.section_id > 225 order by q.id, a.id;



id_to_name = {
    16402: "budget",
    16405: "income_sources:client_institutions",
    16406: "income_sources:european_funding",
    16407: "income_sources:commercial",
    16408: "income_sources:other",
    16409: "income_sources:gov_public_bodies",
    16410: "charging_mechanism",  # "Other" "We use a combination of flat fee and usage-based fee" "We charge a usage-based fee" "We charge a flat fee, based on bandwidth" "We do not charge them directly"
    16413: "staff_employment_type:subcontracted_fte",
    16414: "staff_employment_type:permanent_fte",
    16416: "staff_roles:technical_fte",
    16417: "staff_roles:nontechnical_fte",
    16418: "parent_organization",  # "Yes" "No"
    16419: "parent_organization_name",
    16420: "suborganizations",  # "Yes" "No"
    16422: "suborganization_details[0]:suborganization_name",
    16426: "suborganization_details[0]:suborganization_role-Comment",
    16429: "suborganization_details[1]:suborganization_name",
    16430: "suborganization_details[2]:suborganization_name",
    16432: "suborganization_details[3]:suborganization_name",
    16433: "suborganization_details[4]:suborganization_name",
    16434: "suborganization_details[1]:suborganization_role-Comment",
    16435: "suborganization_details[2]:suborganization_role-Comment",
    16438: "suborganization_details[3]:suborganization_role-Comment",
    16439: "suborganization_details[4]:suborganization_role-Comment",
    16446: "suborganization_details[2]:suborganization_role",  # "Other" "HPC centre" "IDC federation"
    16448: "suborganization_details[1]:suborganization_role",  # "Other" "HPC centre" "IDC federation"
    16449: "suborganization_details[0]:suborganization_role",  # "Other" "HPC centre" "IDC federation"
    16450: "suborganization_details[4]:suborganization_role",  # "Other" "HPC centre" "IDC federation"
    16451: "suborganization_details[3]:suborganization_role",  # "Other" "HPC centre" "IDC federation"
    16452: "ec_projects",  # "Yes" "No"
    16453: "ec_project_names[]:ec_project_name",  # json list with double quotes
    16455: "full_name_english",
    16456: "full_name_national_languages",
    16457: "abbreviation_english",
    16458: "abbreviation_national_languages",
    16459: "street_name_and_number",
    16460: "city",
    16461: "postal_code",
    16462: "country",  # NB some country names are a bit different
    16463: "phone_number",
    16464: "email_address",
    16465: "website",
    16466: "organization_comments",  # but should we map comments or not?

    16468: "corporate_strategy",  # "Yes" "No"
    16469: "corporate_strategy_url",
    16470: "policies:environmental_policy:available",  # "Yes" "No"
    16471: "policies:environmental_policy:url",
    16472: "policies:equal_opportunity_policy:available",  # "Yes" "No"
    16473: "policies:equal_opportunity_policy:url",
    16474: "policies:connectivity_policy:available",  # "Yes" "No"
    16475: "policies:connectivity_policy:url",
    16476: "policies:acceptable_use_policy:available",  # "Yes" "No"
    16477: "policies:acceptable_use_policy:url",
    16478: "policies:privacy_notice:available",  # "Yes" "No"
    16479: "policies:privacy_notice:url",
    16480: "policies:data_protection_contact:available",  # "Yes" "No"
    16481: "policies:data_protection_contact:url",
    16482: "central_software_procurement",  # "Yes" "No"
    16483: "central_procurement_amount",
    16484: "formal_service_management_framework",  # "Yes" "No"
    16485: "service_level_targets",  # "Yes" "No"
    16486: "service_portfolio_changes",  # "Yes" "No"
    16488: "service_matrix{keys}:service_types['identity']",  # json list with double quotes  ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
    16489: "service_matrix{keys}:service_types['network_services']",  # json list with double quotes  ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
    16490: "service_matrix{keys}:service_types['collaboration']",  # json list with double quotes  ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
    16491: "service_matrix{keys}:service_types['security']",  # json list with double quotes  ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
    16492: "service_matrix{keys}:service_types['isp_support']",  # json list with double quotes  ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
    16493: "service_matrix{keys}:service_types['storage_and_hosting']",  # json list with double quotes  ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
    16494: "service_matrix{keys}:service_types['multimedia']",  # json list with double quotes  ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
    16495: "service_matrix{keys}:service_types['professional_services']",  # json list with double quotes  ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
    16496: "service_portfolio_eosc_portal",  # "Yes" "No"
    16497: "services_on_eosc_portal_list[]:service_name",  # json list with double quotes
    16499: "audits",  # "Yes" "No"
    16500: "audit_specifics",
    16501: "business_continuity_plans",  # "Yes" "No"
    16502: "business_continuity_plans_specifics",
    16503: "security_controls",   # json list with double quotes  ["Anti Virus","Anti-Spam","Firewall","DDoS mitigation","Network monitoring","IPS/IDS","ACL","Network segmentation","Integrity checking","Other"]
    16504: "security_controls-Comment",
    16505: "policy_comments",  # but should we map comments or not?
    16760: "policies:gender_equality_policy:available",  # "Yes" "No"
    16761: "policies:gender_equality_policy:url",
    16762: "crisis_management_procedure",  # "Yes" "No"
    16763: "crisis_exercises",  # json list with double quotes  ["We participate in GEANT Crisis workshops such as CLAW","No, we have not done any crisis exercises or trainings","We participated in National crisis exercises ","We had a real crisis","We run our own simulation exercises","We run our own tabletop exercises","We have done/participated in other exercises or trainings"]



}