Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
role Table id serial 10 nextval('role_id_seq'::regclass)
country_metadata Table dove94 bool 1 null
schema_version Table type varchar 20 null
burden_estimate_set Table set_type_details text 2147483647 null
impact_estimate_recipe Table current_impact_estimate_set int4 10 null
burden_all View touchstone_name text 2147483647 null
role Table description text 2147483647 null
model_version_country Table country text 2147483647 null
country_fragility Table id serial 10 nextval('country_fragility_id_seq'::regclass)
demographic_dataset Table demographic_source int4 10 null
burden_all View disease_name varchar 2147483647 null
burden_all View scenario_description text 2147483647 null
demographic_statistic_type Table age_interpretation text 2147483647 null
country_metadata Table region text 2147483647 null
app_user Table email text 2147483647 null
touchstone_years Table id serial 10 nextval('touchstone_years_id_seq'::regclass)
demographic_subnational_statistic Table demographic_dataset int4 10 null
app_user Table last_logged_in timestamp 29 null
scenario_type Table name varchar 255 null
burden_all View value float4 8 null
impact_estimate_ingredient Table name text 2147483647 null
touchstone Table status text 2147483647 null
model Table gender int4 10 null
responsibility_set_comment Table added_on timestamp 29 null
country_metadata Table who_region text 2147483647 null
model_version Table code text 2147483647 null
country_metadata Table gavi73 bool 1 null
responsibility_set_status Table name text 2147483647 null
responsibility Table is_open bool 1 true
impact_estimate Table id serial 10 nextval('impact_estimate_id_seq'::regclass)
gavi_eligibility Table year int4 10 null
role_permission Table role int4 10 null
impact_estimate_recipe Table version int4 10 null
cofinance_status Table id text 2147483647 null
disability_weight Table touchstone text 2147483647 null
country_disease_endemic Table country text 2147483647 null
burden_estimate_expectation Table year_max_inclusive int2 5 null
api_access_log Table ip_address text 2147483647 null
demographic_statistic_type Table code text 2147483647 null
burden_estimate_expectation Table version text 2147483647 null
model Table id text 2147483647 null
country Table nid int2 5 null
country_metadata Table francophone text 2147483647 null

28 Gavi-supported French-speaking countries of interest to Gavi donors + 1 associated member + 4 observer counrties

coverage Table source_from text 2147483647 null
impact_estimate_ingredient Table burden_outcome int2 5 null
coverage Table age_range_verbatim text 2147483647 null
burden_all View modelling_group text 2147483647 null
permission Table name text 2147483647 null
impact_estimate_recipe Table name text 2147483647 null
dettl_import_log Table git_email text 2147483647 null
demographic_source Table id serial 10 nextval('demographic_source_id_seq'::regclass)
v_coverage_info View disease text 2147483647 null
country_cofinance Table country text 2147483647 null
touchstone Table version int4 10 null
touchstone_demographic_source Table demographic_source int4 10 null
burden_estimate Table age int2 5 null
burden_estimate_set_type Table description text 2147483647 null
disability_weight Table id serial 10 nextval('disability_weight_id_seq'::regclass)
role Table name text 2147483647 null
impact_estimate Table value numeric 131089 null
api_access_log Table timestamp timestamp 29 null
country_metadata Table gavi_region text 2147483647 null
coverage_set Table coverage_set_upload_metadata int4 10 null
coverage Table subnational bool 1 null
impact_estimate_recipe Table activity_type text 2147483647 null
burden_estimate_set Table complete bool 1 false
dettl_import_log Table language text 2147483647 null
country_fragility Table is_fragile bool 1 null
impact_estimate_ingredient Table responsibility int4 10 null
api_access_log Table what text 2147483647 null
burden_outcome Table code text 2147483647 null
scenario Table id serial 10 nextval('scenario_id_seq'::regclass)
touchstone_country Table disease text 2147483647 null
upload_info Table uploaded_by text 2147483647 null
coverage_set Table gavi_support_level text 2147483647 null
scenario_description Table id text 2147483647 null
burden View age int2 5 null
dettl_import_log Table git_hash bpchar 40 null
user_group Table name text 2147483647 null
impact_estimate_recipe Table disease text 2147483647 null
v_responsibility_info View disease text 2147483647 null
burden_all View touchstone text 2147483647 null
onetime_token Table token text 2147483647 null
demographic_statistic Table year int4 10 null
schema_version Table description varchar 200 null
gavi_eligibility_status Table id int4 10 null
api_access_log Table id serial 10 nextval('api_access_log_id_seq'::regclass)
burden View outcome_code text 2147483647 null
country_fragility Table year int4 10 null
schema_version Table installed_rank int4 10 null
coverage Table country text 2147483647 null
country_worldbank_status Table country text 2147483647 null
demographic_statistic Table gender int4 10 null
v_responsibility_info View current_burden_estimate_set int4 10 null
burden_estimate_expectation Table year_min_inclusive int2 5 null
burden_estimate_set Table comment text 2147483647 null
burden_estimate_set Table set_type text 2147483647 'central-unknown'::text
coverage Table age_to numeric 131089 null
burden_estimate_set Table id serial 10 nextval('burden_estimate_set_id_seq'::regclass)
impact_estimate_recipe Table focal_ingredient int4 10 null
impact_estimate_set Table coverage_touchstone text 2147483647 null
burden_estimate_set_problem Table burden_estimate_set int4 10 null
vaccine_routine_age Table id serial 10 nextval('vaccine_routine_age_id_seq'::regclass)
touchstone Table comment text 2147483647 null
v_coverage_info View touchstone text 2147483647 null
impact_estimate_set Table computed_on timestamp 29 CURRENT_TIMESTAMP
v_coverage_info View coverage_set_id int4 10 null
support_type Table id text 2147483647 null
responsibility_set_comment Table comment text 2147483647 null
impact_estimate_ingredient Table id serial 10 nextval('impact_estimate_ingredient_id_seq'::regclass)
burden_estimate Table burden_outcome int2 5 null
country_fragility Table country text 2147483647 null
touchstone_country Table touchstone text 2147483647 null
touchstone_name Table description text 2147483647 null
demographic_subnational_statistic Table region int4 10 null
touchstone Table description text 2147483647 null
model_run_parameter_value Table model_run_parameter int4 10 null
scenario_coverage_set Table order int4 10 null
impact_estimate_recipe Table vaccine text 2147483647 null
model Table gender_specific bool 1 false
burden View year int2 5 null
app_user Table password_hash text 2147483647 null
burden_estimate Table model_run int4 10 null
v_coverage_info View scenario_description text 2147483647 null
impact_estimate_recipe Table id serial 10 nextval('impact_estimate_recipe_id_seq'::regclass)
model_version Table model text 2147483647 null
impact_estimate_recipe Table responsibility_set int4 10 null
impact_estimate_set_ingredient Table impact_estimate_set int4 10 null
demographic_variant Table name varchar 2147483647 'NULL'::character varying
disability_weight Table sequela text 2147483647 null
upload_info Table uploaded_on timestamp 29 date_trunc('milliseconds'::text, now())
worldbank_status Table id text 2147483647 null
schema_version Table installed_on timestamp 29 now()
legal_agreement Table description text 2147483647 null
touchstone Table id text 2147483647 null
model Table description text 2147483647 null
disease Table id text 2147483647 null
coverage Table target numeric 131089 null

This field is valid only for campaign coverage

dettl_import_log Table name text 2147483647 null
model_run_parameter_set Table upload_info int4 10 null
gavi_eligibility Table country text 2147483647 null
touchstone_status Table id text 2147483647 null
burden_estimate_set_type Table is_valid_option bool 1 null

New burden_estimate_set rows should only be created with set types that have is_valid_option to true. Those with false are for legacy data

role_permission Table permission text 2147483647 null
demographic_statistic_type Table year_step_size int4 10 null
burden_estimate_set_status Table description text 2147483647 null
country_metadata Table gavi72 bool 1 null
burden_estimate_set Table uploaded_by text 2147483647 null
touchstone_demographic_dataset Table demographic_dataset int4 10 null
responsibility_set Table id serial 10 nextval('responsibility_set_id_seq'::regclass)
demographic_variant Table id serial 10 nextval('demographic_variant_id_seq'::regclass)
touchstone_name Table id text 2147483647 null
burden_estimate_set Table status text 2147483647 'complete'::text
model_version Table is_dynamic bool 1 false
touchstone_years Table disease text 2147483647 null
burden_estimate_set_status Table code text 2147483647 null

Valid values: {empty, partial, complete, invalid}

burden_all View age int2 5 null
burden_all View year int2 5 null
demographic_variant Table code text 2147483647 null
impact_estimate Table country text 2147483647 null
country_vaccine_metadata Table country text 2147483647 null
dettl_import_log Table end_time timestamptz 35 null
responsibility_set Table touchstone text 2147483647 null
country_metadata Table wuenic_coverage bool 1 null
schema_version Table checksum int4 10 null
demographic_statistic Table age_to int4 10 null
country_metadata Table vxdel_segment text 2147483647 null

An internal grouping as used by BMFG to stratify countries

model_version Table id serial 10 nextval('model_version_id_seq'::regclass)
impact_outcome Table id text 2147483647 null
user_group_role Table role int4 10 null
coverage_set_upload_metadata Table uploaded_by text 2147483647 null
gender Table code text 2147483647 null
country_vaccine_metadata Table year_support_last int4 10 null
francophone_status Table id text 2147483647 null
activity_type Table id text 2147483647 'NULL'::text
impact_estimate_set Table id serial 10 nextval('impact_estimate_set_id_seq'::regclass)
burden_estimate_set Table model_version int4 10 null
demographic_statistic Table country text 2147483647 null
demographic_dataset Table demographic_statistic_type int4 10 null
gavi_eligibility Table touchstone text 2147483647 null
gavi_focal_model Table model text 2147483647 null
country_disease_endemic Table disease text 2147483647 null
demographic_statistic_type Table reference_date date 13 null
api_access_log Table result int4 10 null

The HTTP status code returned by the API

demographic_statistic Table demographic_source int4 10 null
responsibility Table scenario int4 10 null
coverage_set Table touchstone text 2147483647 null
burden_estimate_set Table uploaded_on timestamp 29 date_trunc('milliseconds'::text, now())
model Table modelling_group text 2147483647 'NULL'::text
scenario_coverage_set Table id serial 10 nextval('scenario_coverage_set_id_seq'::regclass)
demographic_source Table name varchar 2147483647 null
responsibility Table current_burden_estimate_set int4 10 null
schema_version Table success bool 1 null
demographic_subnational_statistic Table age_to int4 10 null
disability_weight Table disability_weight numeric 131089 null
responsibility_set_status Table id text 2147483647 null
model_version Table version text 2147483647 null
scenario_coverage_set Table coverage_set int4 10 null
burden View value float4 8 null
demographic_value_unit Table name text 2147483647 null

A free text description

model Table is_current bool 1 false
region_subnational Table id serial 10 nextval('region_subnational_id_seq'::regclass)
burden_estimate_set Table validation text 2147483647 null
vaccine Table id text 2147483647 'NULL'::text
burden_estimate_set_type Table code text 2147483647 null
model_run_parameter_value Table id serial 10 nextval('model_run_parameter_value_id_seq'::regclass)
v_responsibility_info View status text 2147483647 null
country_vaccine_metadata Table year_support_first int4 10 null
demographic_subnational_statistic Table gender int4 10 null
user_group_role Table user_group text 2147483647 null
vxdel_segment Table id text 2147483647 null
region_subnational Table parent_id int4 10 null
responsibility_comment Table added_by text 2147483647 null
v_responsibility_info View scenario_description text 2147483647 null
country_fragility Table touchstone text 2147483647 null
burden_estimate Table value float4 8 null
country_metadata Table gavi77 bool 1 null
model Table citation text 2147483647 null
coverage Table coverage_set int4 10 null
vaccine_routine_age Table vaccine text 2147483647 null
disability_weight Table disease text 2147483647 null
model_run Table model_run_parameter_set int4 10 null
country_cofinance Table cofinance_status text 2147483647 null
schema_version Table installed_by varchar 100 null
responsibility Table current_stochastic_burden_estimate_set int4 10 null
gavi_focal_model Table disease text 2147483647 null
burden_estimate_outcome_expectation Table burden_estimate_expectation int4 10 null
impact_estimate_recipe Table support_type text 2147483647 null
impact_estimate_recipe Table comment text 2147483647 null
touchstone_years Table year_first int4 10 null
dettl_import_log Table duration float4 8 null
burden_estimate_set Table original_filename text 2147483647 null
impact_estimate_set_ingredient Table id serial 10 nextval('impact_estimate_set_ingredient_id_seq'::regclass)
dettl_import_log Table mode text 2147483647 null
burden_estimate_expectation Table age_max_inclusive int2 5 null
model_version Table note text 2147483647 null
burden_estimate_set Table model_run_parameter_set int4 10 null
burden_all View outcome_code text 2147483647 null
impact_estimate Table year int4 10 null
demographic_value_unit Table id serial 10 nextval('demographic_value_unit_id_seq'::regclass)
coverage_set Table activity_type text 2147483647 null
country_worldbank_status Table touchstone text 2147483647 null
country_worldbank_status Table year int4 10 null
v_responsibility_info View touchstone text 2147483647 null
country_worldbank_status Table id serial 10 nextval('country_worldbank_status_id_seq'::regclass)
user_legal_agreement Table date timestamp 29 CURRENT_TIMESTAMP
responsibility_comment Table id serial 10 nextval('responsibility_comment_id_seq'::regclass)
country_metadata Table continent text 2147483647 null
gavi_eligibility_status Table name text 2147483647 null
burden_estimate Table country int2 5 null
responsibility_comment Table responsibility int4 10 null
country_metadata Table country text 2147483647 null
demographic_statistic_type_variant Table demographic_variant int4 10 null
touchstone_country Table id serial 10 nextval('touchstone_country_id_seq'::regclass)
gavi_support_level Table name varchar 255 'NULL'::character varying
burden View country text 2147483647 null
region_subnational Table name text 2147483647 null
demographic_statistic Table id serial 10 nextval('demographic_statistic_id_seq'::regclass)
gender Table name varchar 6 null
gavi_region Table name text 2147483647 null
demographic_source Table code text 2147483647 null
coverage_set Table vaccine text 2147483647 null
responsibility_set_comment Table responsibility_set int4 10 null
burden_estimate_set Table run_info text 2147483647 null
user_group Table id text 2147483647 null
impact_estimate_set Table focal_burden_estimate_set int4 10 null
demographic_statistic Table demographic_statistic_type int4 10 null
dettl_import_log Table git_branch text 2147483647 null
modelling_group Table replaced_by text 2147483647 null
scenario Table focal_coverage_set int4 10 null
model_run_parameter_set Table responsibility_set int4 10 null
region_subnational Table admin_level int4 10 null
country Table id text 2147483647 null
burden_estimate_expectation Table description text 2147483647 null
coverage Table gender int4 10 null
burden View touchstone text 2147483647 null
modelling_group Table pi text 2147483647 null
impact_estimate_recipe Table script text 2147483647 null
model_run_parameter_set Table id serial 10 nextval('model_run_parameter_set_id_seq'::regclass)
country_cofinance Table id serial 10 nextval('country_cofinance_id_seq'::regclass)
responsibility_set_comment Table id serial 10 nextval('responsibility_set_comment_id_seq'::regclass)
responsibility_set_comment Table added_by text 2147483647 null
demographic_statistic_type Table name varchar 2147483647 null
schema_version Table version varchar 50 null
demographic_subnational_statistic Table value numeric 131089 null
app_user Table username text 2147483647 null
user_group_membership Table username text 2147483647 null
v_coverage_info View activity_type text 2147483647 null
scenario Table scenario_description text 2147483647 null
cofinance_status Table name text 2147483647 null
demographic_statistic_type Table default_variant int4 10 null
demographic_statistic_type Table demographic_value_unit int4 10 null
gavi_focal_model Table touchstone text 2147483647 null
coverage_set Table id serial 10 nextval('coverage_set_id_seq'::regclass)
country Table name text 2147483647 null
onetime_token Table id serial 10 nextval('onetime_token_id_seq'::regclass)
touchstone_demographic_source Table id serial 10 nextval('touchstone_demographic_source_id_seq'::regclass)
demographic_dataset Table id serial 10 nextval('demographic_dataset_id_seq'::regclass)
model Table current_version int4 10 null
scenario_description Table scenario_type text 2147483647 null
touchstone_demographic_dataset Table touchstone text 2147483647 null
schema_version Table script varchar 1000 null
coverage Table age_from numeric 131089 null
model_run_parameter Table model_run_parameter_set int4 10 null
country_cofinance Table year int4 10 null
impact_estimate_set Table impact_estimate_recipe int4 10 null
touchstone_name Table comment text 2147483647 null
coverage_set_upload_metadata Table description text 2147483647 null
model_version Table fingerprint text 2147483647 null
burden_outcome Table id int2 5 nextval('burden_outcome_id_seq'::regclass)
gender Table id serial 10 nextval('gender_id_seq'::regclass)
country_vaccine_metadata Table id serial 10 nextval('country_vaccine_metadata_id_seq'::regclass)
demographic_subnational_statistic Table year int4 10 null
model Table disease text 2147483647 null
role Table scope_prefix text 2147483647 null
burden_estimate_country_expectation Table burden_estimate_expectation int4 10 null
upload_info Table id serial 10 nextval('upload_info_id_seq'::regclass)
coverage_set_upload_metadata Table uploaded_on timestamp 29 CURRENT_TIMESTAMP
demographic_statistic_type Table gender_is_applicable bool 1 null
burden_estimate_set Table interpolated bool 1 null
demographic_dataset Table description text 2147483647 null
impact_estimate_ingredient Table impact_estimate_recipe int4 10 null
demographic_subnational_statistic Table age_from int4 10 null
touchstone_years Table touchstone text 2147483647 null
responsibility Table id serial 10 nextval('responsibility_id_seq'::regclass)
demographic_statistic Table age_from int4 10 null
responsibility_set Table status text 2147483647 null
support_type Table name text 2147483647 null
model_run_parameter Table id serial 10 nextval('model_run_parameter_id_seq'::regclass)
coverage Table proportion_risk numeric 131089 null
coverage Table year int4 10 null
region_subnational Table country int4 10 null
scenario_type Table id text 2147483647 null
country_metadata Table id serial 10 nextval('country_metadata_id_seq'::regclass)
burden_outcome Table name text 2147483647 null
responsibility Table responsibility_set int4 10 null
burden_estimate_expectation Table id serial 10 nextval('burden_estimate_expectation_id_seq'::regclass)
coverage Table coverage numeric 131089 null
demographic_statistic Table value numeric 131089 null
modelling_group Table institution text 2147483647 null
country_vaccine_metadata Table year_vaccine_intro int4 10 null
burden View touchstone_name text 2147483647 null
demographic_subnational_statistic Table id serial 10 nextval('demographic_subnational_statistic_id_seq'::regclass)
country_disease_endemic Table id serial 10 nextval('country_disease_endemic_id_seq'::regclass)
responsibility_comment Table added_on timestamp 29 null
model_run Table run_id text 2147483647 null
burden View scenario_description text 2147483647 null
modelling_group Table comment text 2147483647 null
burden_estimate_expectation Table age_min_inclusive int2 5 null
dettl_import_log Table git_user text 2147483647 null
responsibility_set Table modelling_group text 2147483647 null
touchstone_demographic_dataset Table id serial 10 nextval('touchstone_demographic_dataset_id_seq'::regclass)
country_metadata Table gavi_pef_tier int4 10 null

Gavi Partners engagement framework; Tier 1, 2 or 3 (stored as integer). NULL values indicate "Not PEF"

country_worldbank_status Table worldbank_status text 2147483647 null
coverage_set_upload_metadata Table filename text 2147483647 null
burden_estimate_set_problem Table problem text 2147483647 null
impact_estimate Table impact_estimate_set int4 10 null
schema_version Table execution_time int4 10 null
model_run_parameter_set Table model_version int4 10 null
impact_outcome Table name text 2147483647 null
touchstone_years Table year_last int4 10 null
disease Table name varchar 2147483647 null
gavi_region Table id text 2147483647 null
impact_estimate_recipe Table impact_outcome text 2147483647 null
scenario_description Table disease text 2147483647 null
impact_estimate_set_ingredient Table impact_estimate_ingredient int4 10 null
worldbank_status Table name text 2147483647 null
gavi_eligibility Table status int4 10 null
burden_outcome Table proportion bool 1 false
model_run_parameter_value Table value text 2147483647 null
burden_estimate_expectation Table cohort_max_inclusive int2 5 null
vaccine_routine_age Table age int4 10 null
country_cofinance Table touchstone text 2147483647 null
scenario_coverage_set Table scenario int4 10 null
country_disease_endemic Table touchstone text 2147483647 null
v_coverage_info View vaccine text 2147483647 null
impact_estimate_set Table focal_coverage_set int4 10 null
demographic_statistic Table demographic_variant int4 10 null
demographic_statistic_type Table id serial 10 nextval('demographic_statistic_type_id_seq'::regclass)
country_metadata Table pine_5 bool 1 null
burden_estimate_expectation Table cohort_min_inclusive int2 5 null
responsibility_comment Table comment text 2147483647 null
model_version_country Table model_version int4 10 null
modelling_group Table id text 2147483647 null
dettl_import_log Table start_time timestamptz 35 null
burden_estimate Table burden_estimate_set int4 10 null
touchstone Table touchstone_name text 2147483647 null
dettl_import_log Table comment text 2147483647 null
touchstone_demographic_source Table touchstone text 2147483647 null
coverage Table id serial 10 nextval('coverage_id_seq'::regclass)
demographic_statistic_type_variant Table demographic_statistic_type int4 10 null
scenario_description Table description text 2147483647 null
country_vaccine_metadata Table touchstone text 2147483647 null
gavi_focal_model Table id serial 10 nextval('gavi_focal_model_id_seq'::regclass)
activity_type Table name varchar 255 'NULL'::character varying
disability_weight Table disability_weight_min numeric 131089 null
country_vaccine_metadata Table vaccine text 2147483647 null
scenario Table touchstone text 2147483647 'NULL'::text
burden_estimate_set Table responsibility int4 10 null
burden View disease_name varchar 2147483647 null
modelling_group Table description text 2147483647 null
model_run_parameter Table key text 2147483647 null
burden_estimate_outcome_expectation Table outcome text 2147483647 null
user_group_membership Table user_group text 2147483647 null
responsibility Table expectations int4 10 null
touchstone_status Table name text 2147483647 null
disability_weight Table disability_weight_max numeric 131089 null
coverage_set_upload_metadata Table id serial 10 nextval('coverage_set_upload_metadata_id_seq'::regclass)
burden View modelling_group text 2147483647 null
touchstone_country Table country text 2147483647 null
vaccine Table name text 2147483647 null
impact_estimate_set Table recipe_touchstone text 2147483647 null
v_responsibility_info View responsibility_id int4 10 null
burden_estimate Table year int2 5 null
gavi_eligibility Table id serial 10 nextval('gavi_eligibility_id_seq'::regclass)
user_legal_agreement Table legal_agreement text 2147483647 null
coverage Table gavi_support bool 1 null
burden_estimate_country_expectation Table country text 2147483647 null
gavi_support_level Table id text 2147483647 null
v_coverage_info View gavi_support_level text 2147483647 null
legal_agreement Table name text 2147483647 null
demographic_statistic Table demographic_dataset int4 10 null
user_group Table description text 2147483647 null
model_run Table internal_id serial 10 nextval('model_run_internal_id_seq'::regclass)
model_run_parameter_value Table model_run int4 10 null
user_legal_agreement Table username text 2147483647 null
user_group_role Table scope_id text 2147483647 null
coverage_set Table name text 2147483647 null
burden_estimate_set_problem Table id serial 10 nextval('burden_estimate_set_problem_id_seq'::regclass)
burden_all View country text 2147483647 null
app_user Table name text 2147483647 null
country_metadata Table dove96 bool 1 null
country_metadata Table gavi68 bool 1 null
country_metadata Table touchstone text 2147483647 null
impact_estimate_set_ingredient Table burden_estimate_set int4 10 null
api_access_log Table who text 2147483647 null