Baselight
Sign In

Tanzanian Health Facility Registry Dataset

Tabular form of official Tanzanian Health Facility Registry data

@kaggle.yusuph_tanzanian_health_facility_registry_dataset

Loading...
Loading...

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.31 MB
  • 10,427 rows
  • 38 columns
Loading... 
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 Type,
  "facility_ownership" VARCHAR,
  "facility_operating_status" VARCHAR,
  "facility_registration_status" VARCHAR,
  "location_description" VARCHAR,
  "waypoint_number" VARCHAR,
  "altitude_meters" VARCHAR  -- Altitude(Meters),
  "service_areas_villages" VARCHAR  -- Service Areas(Villages),
  "catchment_population" VARCHAR,
  "date_opened_inaugurated_upgraded" VARCHAR,
  "year" VARCHAR,
  "postal_address" VARCHAR,
  "postal_code" VARCHAR,
  "official_phone" VARCHAR  -- Official Phone #,
  "official_fax" VARCHAR  -- Official Fax #,
  "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
  • 235.07 kB
  • 76,277 rows
  • 3 columns
Loading... 
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
  • 298.36 kB
  • 10,427 rows
  • 24 columns
Loading... 
CREATE TABLE facility_infrastructure_b (
  "facility_id" VARCHAR,
  "reception_room_s" VARCHAR  -- Reception Room(s),
  "consultation_room_s" VARCHAR  -- Consultation Room(s),
  "dressing_room_s" VARCHAR  -- Dressing Room(s),
  "ward_room_s" VARCHAR  -- Ward Room(s),
  "injection_room_s" VARCHAR  -- Injection Room(s),
  "observation_room_s" VARCHAR  -- Observation Room(s),
  "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
  • 715.37 kB
  • 329,460 rows
  • 3 columns
Loading... 
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.75 MB
  • 10,427 rows
  • 86 columns
Loading... 
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 Type,
  "facility_ownership" VARCHAR,
  "facility_operating_status" VARCHAR,
  "facility_registration_status" VARCHAR,
  "location_description" VARCHAR,
  "waypoint_number" VARCHAR,
  "altitude_meters" VARCHAR  -- Altitude(Meters),
  "service_areas_villages" VARCHAR  -- Service Areas(Villages),
  "catchment_population" VARCHAR,
  "date_opened_inaugurated_upgraded" VARCHAR,
  "year" VARCHAR,
  "postal_address" VARCHAR,
  "postal_code" VARCHAR,
  "official_phone" VARCHAR  -- Official Phone #,
  "official_fax" VARCHAR  -- Official Fax #,
  "official_email" VARCHAR,
  "facility_in_charge_name" VARCHAR,
  "facility_in_charge_cadre" VARCHAR,
  "website" VARCHAR,
  "reception_room_s" VARCHAR  -- Reception Room(s),
  "consultation_room_s" VARCHAR  -- Consultation Room(s),
  "dressing_room_s" VARCHAR  -- Dressing Room(s),
  "ward_room_s" VARCHAR  -- Ward Room(s),
  "injection_room_s" VARCHAR  -- Injection Room(s),
  "observation_room_s" VARCHAR  -- Observation Room(s),
  "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  -- Reproductive \u0026 Child Health Care Serices,
  "growth_monitoring_nutrition_surveliance" VARCHAR  -- Growth Monitoring/Nutrition \u0026 Surveliance,
  "oral_health_services_dental_serices" VARCHAR  -- Oral Health Services(Dental Serices),
  "ent_services" VARCHAR,
  "sterilazation_and_infection_control_2" VARCHAR,
  "sterilazation_and_infection_control_3" VARCHAR,
  "support_services" VARCHAR,
  "emergency_preparedness" VARCHAR,
  "other_services" VARCHAR
);

Share link

Anyone who has the link will be able to view this.