Dataset: Tanzanian Health Facility Registry Dataset

About this Dataset

Tanzanian Health Facility Registry Dataset

Context

Current Health Facility Registry data is available online but users have to visit every page individually to get comparable full breadth of data. In order to better facilitate this process, this data scraped all the pages and combined them into a tabular format.

Content

Data includes Health Facility identifiers, location data, and available services at each facility.

Acknowledgements

All data is from the official Health Facility Registry as of 2019-07-03.

Inspiration

How can we use this tabular data to improve service provision in Tanzania?

Tables

Facility Info

@kaggle.yusuph_tanzanian_health_facility_registry_dataset.facility_info

1.25 MB
10427 rows
38 columns


CREATE TABLE facility_info (
  "facility_id" VARCHAR,
  "facility_name" VARCHAR,
  "ward" VARCHAR,
  "village_street" VARCHAR,
  "facility_type" VARCHAR,
  "operating_status" VARCHAR,
  "ownership" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "facility_zone" VARCHAR,
  "facility_region" VARCHAR,
  "facility_district" VARCHAR,
  "facility_council" VARCHAR,
  "facility_location" VARCHAR,
  "common_facility_name" VARCHAR,
  "registration_id" VARCHAR,
  "ctc_id" VARCHAR,
  "mtuha_code" VARCHAR,
  "msd_id" VARCHAR,
  "facility_type_0bc181" VARCHAR,
  "facility_ownership" VARCHAR,
  "facility_operating_status" VARCHAR,
  "facility_registration_status" VARCHAR,
  "location_description" VARCHAR,
  "waypoint_number" VARCHAR,
  "altitude_meters" VARCHAR,
  "service_areas_villages" VARCHAR,
  "catchment_population" VARCHAR,
  "date_opened_inaugurated_upgraded" VARCHAR,
  "year" VARCHAR,
  "postal_address" VARCHAR,
  "postal_code" VARCHAR,
  "official_phone" VARCHAR,
  "official_fax" VARCHAR,
  "official_email" VARCHAR,
  "facility_in_charge_name" VARCHAR,
  "facility_in_charge_cadre" VARCHAR,
  "website" VARCHAR
);

Facility Infrastructure A

@kaggle.yusuph_tanzanian_health_facility_registry_dataset.facility_infrastructure_a

229.56 KB
76277 rows
3 columns


CREATE TABLE facility_infrastructure_a (
  "facility_id" VARCHAR,
  "type_of_infrastructure" VARCHAR,
  "value" VARCHAR
);

Facility Infrastructure B

@kaggle.yusuph_tanzanian_health_facility_registry_dataset.facility_infrastructure_b

291.36 KB
10427 rows
24 columns


CREATE TABLE facility_infrastructure_b (
  "facility_id" VARCHAR,
  "reception_room_s" VARCHAR,
  "consultation_room_s" VARCHAR,
  "dressing_room_s" VARCHAR,
  "ward_room_s" VARCHAR,
  "injection_room_s" VARCHAR,
  "observation_room_s" VARCHAR,
  "remarks" VARCHAR,
  "patient_beds" VARCHAR,
  "deliery_beds" VARCHAR,
  "baby_cots" VARCHAR,
  "ambulances" VARCHAR,
  "cars" VARCHAR,
  "motorcycles" VARCHAR,
  "other_transport" VARCHAR,
  "sterilazation_and_infection_control" VARCHAR,
  "means_of_transport_to_referral_point" VARCHAR,
  "distance_to_referral_point" VARCHAR,
  "challanges_remarks_to_referral_point" VARCHAR,
  "other_source_of_energy" VARCHAR,
  "other_mobile_networks" VARCHAR,
  "other_source_of_water" VARCHAR,
  "toilet_remarks" VARCHAR,
  "other_waste_management" VARCHAR
);

Facility Services

@kaggle.yusuph_tanzanian_health_facility_registry_dataset.facility_services

698.6 KB
329460 rows
3 columns


CREATE TABLE facility_services (
  "facility_id" VARCHAR,
  "type_of_service" VARCHAR,
  "services" VARCHAR
);

Health Facilities 2019–12–19

@kaggle.yusuph_tanzanian_health_facility_registry_dataset.health_facilities_2019_12_19

1.67 MB
10427 rows
86 columns


CREATE TABLE health_facilities_2019_12_19 (
  "facility_id" VARCHAR,
  "facility_name" VARCHAR,
  "ward" VARCHAR,
  "village_street" VARCHAR,
  "facility_type" VARCHAR,
  "operating_status" VARCHAR,
  "ownership" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "facility_zone" VARCHAR,
  "facility_region" VARCHAR,
  "facility_district" VARCHAR,
  "facility_council" VARCHAR,
  "facility_location" VARCHAR,
  "common_facility_name" VARCHAR,
  "registration_id" VARCHAR,
  "ctc_id" VARCHAR,
  "mtuha_code" VARCHAR,
  "msd_id" VARCHAR,
  "facility_type_0bc181" VARCHAR,
  "facility_ownership" VARCHAR,
  "facility_operating_status" VARCHAR,
  "facility_registration_status" VARCHAR,
  "location_description" VARCHAR,
  "waypoint_number" VARCHAR,
  "altitude_meters" VARCHAR,
  "service_areas_villages" VARCHAR,
  "catchment_population" VARCHAR,
  "date_opened_inaugurated_upgraded" VARCHAR,
  "year" VARCHAR,
  "postal_address" VARCHAR,
  "postal_code" VARCHAR,
  "official_phone" VARCHAR,
  "official_fax" VARCHAR,
  "official_email" VARCHAR,
  "facility_in_charge_name" VARCHAR,
  "facility_in_charge_cadre" VARCHAR,
  "website" VARCHAR,
  "reception_room_s" VARCHAR,
  "consultation_room_s" VARCHAR,
  "dressing_room_s" VARCHAR,
  "ward_room_s" VARCHAR,
  "injection_room_s" VARCHAR,
  "observation_room_s" VARCHAR,
  "remarks" VARCHAR,
  "patient_beds" VARCHAR,
  "deliery_beds" VARCHAR,
  "baby_cots" VARCHAR,
  "ambulances" VARCHAR,
  "cars" VARCHAR,
  "motorcycles" VARCHAR,
  "other_transport" VARCHAR,
  "sterilazation_and_infection_control" VARCHAR,
  "sterilazation_and_infection_control_1" VARCHAR,
  "means_of_transport_to_referral_point" VARCHAR,
  "distance_to_referral_point" VARCHAR,
  "challanges_remarks_to_referral_point" VARCHAR,
  "source_of_energy" VARCHAR,
  "other_source_of_energy" VARCHAR,
  "mobile_networks" VARCHAR,
  "other_mobile_networks" VARCHAR,
  "source_of_water" VARCHAR,
  "other_source_of_water" VARCHAR,
  "toilet_facility" VARCHAR,
  "toilet_remarks" VARCHAR,
  "waste_management" VARCHAR,
  "other_waste_management" VARCHAR,
  "general_clinical_services" VARCHAR,
  "malaria_diagnosis_and_treatment" VARCHAR,
  "tb_diagnosis_care_and_treatment" VARCHAR,
  "cardiouvascula_care_and_treatment" VARCHAR,
  "hiv_aids_prevention" VARCHAR,
  "hiv_aids_care_and_treatment" VARCHAR,
  "therapeutics" VARCHAR,
  "prosthetics_and_medical_devices" VARCHAR,
  "health_promotion_and_disease_prevention" VARCHAR,
  "diagnosis_serices" VARCHAR,
  "reproductive_child_health_care_serices" VARCHAR,
  "growth_monitoring_nutrition_surveliance" VARCHAR,
  "oral_health_services_dental_serices" VARCHAR,
  "ent_services" VARCHAR,
  "sterilazation_and_infection_control_2" VARCHAR,
  "sterilazation_and_infection_control_3" VARCHAR,
  "support_services" VARCHAR,
  "emergency_preparedness" VARCHAR,
  "other_services" VARCHAR
);