md_water_services | Data dictionary
Description
This database contains the records of a water survey for the Integrated Project.
Data model
The database md_water_services includes more than 60 000 unique records and 43 columns. The
data model, including the column names, data types and feature descriptions, is included in Table 1
ordered by table.
Table 1: The data model for the md_water_services database.
employee table
Column name Description Data type
assigned_employee_id Unique ID assigned to each employee. INT
employee_name Name of the employee. VARCHAR(255)
phone_number Contact number of the employee. VARCHAR(15)
email Email address of the employee. VARCHAR(255)
address Residential address of the employee. VARCHAR(255)
town_name Name of the town where the employee resides. VARCHAR(255)
Name of the province where the employee
province_name VARCHAR(255)
resides.
position Position or job title of the employee. VARCHAR(255)
global_water_access table
Column name Description Data type
name The country or area name. VARCHAR(255)
region Geographical region. VARCHAR(255)
year Year of the data record. INT
The national population size estimate in
pop_n FLOAT
thousands.
The urban population share estimate in
pop_u FLOAT
percentage points (%).
The estimated national share of people with at
wat_bas_n FLOAT
least basic service (%).
The estimated national share of people with
wat_lim_n FLOAT
limited service (%).
The estimated national share of people with
wat_unimp_n FLOAT
unimproved service (%).
The estimated national share of people with
wat_sur_n FLOAT
surface service (%).
The estimated rural share of people with at
wat_bas_r FLOAT
least basic service (%).
The estimated rural share of people with limited
wat_lim_r FLOAT
service (%).
The estimated rural share of people with
wat_unimp_r FLOAT
unimproved service (%).
The estimated rural share of people with
wat_sur_r FLOAT
surface service (%).
The estimated urban share of people with at
wat_bas_u FLOAT
least basic service (%).
The estimated urban share of people with
wat_lim_u FLOAT
limited service (%).
The estimated urban share of people with
wat_unimp_u FLOAT
unimproved service (%).
The estimated urban share of people with
wat_sur_u FLOAT
surface service (%).
location table
Column name Description Data type
location_id Unique ID assigned to each location. VARCHAR(255)
address Address of the location. VARCHAR(255)
Name of the province where the location is
province_name VARCHAR(255)
situated.
Name of the town where the location is
town_name VARCHAR(255)
situated.
location_type Type or category of the location. VARCHAR(255)
visits table
Column name Description Data type
record_id Unique ID assigned to each visit. INT
location_id ID of the location visited. VARCHAR(255)
source_id ID of the water source visited. VARCHAR(510)
time_of_record Date and time of the visit. DATETIME
visit_count Number of visits made to this location. INT
Time spent by people waiting for water in a
time_in_queue INT
queue at the location.
assigned_employee_id ID of the employee who visited the location. INT
water_quality table
Column name Description Data type
record_id Unique ID assigned to each record. INT
Score representing the subjective quality of the
subjective_quality_score INT
water source.
visit_count Number of visits made for data collection. INT
water_source table
Column name Description Data type
source_id Unique ID assigned to each water source. INT
Type or category of the water source. Can be:
type_of_water
tap_in_home, tap_in_home_broken, well, INT
_source
shared_tap, river.
Number_of
Number of people served by this water source. INT
_people_served
well_pollution table
Column name Description Data type
ID of the water source being tested for
source_id VARCHAR(258)
pollution.
date Date of the pollution test. DATETIME
description Description of the pollution test. VARCHAR(255)
pollutant_ppm Result of the pollution test in parts per million. FLOAT
biological Biological contamination level. FLOAT
results Result of the pollution test. VARCHAR(255)
