Public Health Activities And Services - 2013

CREATE TABLE table_1 (
  "entity" VARCHAR,
  "agency_provided_primary_care" VARCHAR,
  "number_of_primary_care_patients" BIGINT,
  "number_of_primary_care_visits" BIGINT,
  "agency_provided_oral_health" VARCHAR,
  "number_of_oral_health_visits" BIGINT,
  "number_of_oral_health_patients" BIGINT,
  "agency_provided_behavioral_health" VARCHAR,
  "number_of_behavioral_health_patients" BIGINT,
  "number_of_behavioral_health_visits" BIGINT,
  "number_of_family_planning_patients" VARCHAR,
  "agency_provided_family_planning" BIGINT,
  "number_of_family_planning_visits" BIGINT,
  "agency_was_in_a_community_coalition_to_improve_access__90be78d0" VARCHAR  -- Agency Was In A Community Coalition To Improve Access To Health Care Services Program,
  "agency_provided_direct_client_access_to_health_care_se_a13996a7" VARCHAR  -- Agency Provided Direct Client Access To Health Care Services Program,
  "number_of_health_care_access_program_clients" BIGINT,
  "number_of_hospitals_regulated_by_doh" BIGINT,
  "number_of_hospital_inspections" BIGINT,
  "number_of_ambulance_and_aid_services_licensed" BIGINT,
  "number_of_trauma_records" BIGINT,
  "number_of_emergency_medical_services_records" BIGINT,
  "number_of_health_care_credentials" BIGINT,
  "number_of_lab_inspections" BIGINT,
  "number_of_complaint_investigations_about_health_care_p_bf9cae9f" BIGINT  -- Number Of Complaint Investigations About Health Care Professionals,
  "number_of_clinical_labs_regulated_by_doh" BIGINT,
  "agency_was_involved_in_a_broadly_based_community_healt_a3ee1b85" VARCHAR  -- Agency Was Involved In A Broadly-based Community Health Assessment,
  "agency_was_involved_in_a_narrow_focused_assessment" VARCHAR,
  "focused_assessment_maternal_or_child_health" BIGINT  -- Focused Assessment: Maternal Or Child Health,
  "focused_assessment_communicable_disease_assessment" BIGINT  -- Focused Assessment: Communicable Disease Assessment,
  "focused_assessment_environmental_health_assessment" BIGINT  -- Focused Assessment: Environmental Health Assessment,
  "focused_assessment_chronic_disease_prevention_assessment" BIGINT  -- Focused Assessment: Chronic Disease Prevention Assessment,
  "focused_assessment_health_disparities_assessment" BIGINT  -- Focused Assessment: Health Disparities Assessment,
  "focused_assessment_mental_or_behavioral_health_assessment" BIGINT  -- Focused Assessment: Mental Or Behavioral Health Assessment,
  "focused_assessment_injury_prevention_assessment" BIGINT  -- Focused Assessment: Injury Prevention Assessment,
  "focused_assessment_health_care_system_issues_assessment" BIGINT  -- Focused Assessment: Health Care System Issues Assessment,
  "focused_assessment_built_environment_assessment" BIGINT  -- Focused Assessment: Built Environment Assessment,
  "focused_assessment_other_assessment" BIGINT  -- Focused Assessment: Other Assessment,
  "agency_had_a_separate_assessment_program" VARCHAR,
  "number_of_separate_assessment_program_fte_s" DOUBLE  -- Number Of Separate Assessment Program FTE(s),
  "number_of_adults_interviewed_for_behavioral_risk_facto_5ee42ec5" BIGINT  -- Number Of Adults Interviewed For Behavioral Risk Factor Surveillance System,
  "number_of_hospital_discharge_inpatient_records_collected" BIGINT,
  "number_of_birth_certificates_issued" BIGINT,
  "number_of_death_certificates_issued" BIGINT,
  "number_of_birth_records_registered" BIGINT,
  "number_of_death_records_registered" BIGINT,
  "number_of_amendments_made_to_birth_and_death_records_by_doh" BIGINT,
  "agency_provided_child_immunizations" VARCHAR,
  "number_of_child_immunization_doses_administered_to_pat_4b7ceae2" BIGINT  -- Number Of Child Immunization Doses Administered To Patients By The Agency,
  "number_of_providers_enrolled_in_the_washington_state_i_d6d51912" BIGINT  -- Number Of Providers Enrolled In The Washington State Immunization Information System,
  "number_of_doses_of_childhood_vaccine_ordered_by_local__494f32b1" BIGINT  -- Number Of Doses Of Childhood Vaccine Ordered By Local Health Jurisdictions' Offices Only,
  "number_of_doses_of_childhood_vaccine_ordered_by_provid_5c8c8562" BIGINT  -- Number Of Doses Of Childhood Vaccine Ordered By Providers (not Including Local Health Jurisdictions' Offices),
  "number_of_vaccine_for_children_site_visits" BIGINT,
  "agency_provided_adult_vaccinations" VARCHAR,
  "number_of_adult_vaccination_doses_administered_to_pati_456b90b9" BIGINT  -- Number Of Adult Vaccination Doses Administered To Patients By The Agency,
  "agency_provided_direct_administration_of_flu_vaccine" VARCHAR,
  "number_of_flu_vaccine_doses_administered_to_patients_b_58d463fb" BIGINT  -- Number Of Flu Vaccine Doses Administered To Patients By The Agency,
  "number_of_doses_of_flu_vaccine_ordered_by_providers_no_1891cd82" BIGINT  -- Number Of Doses Of Flu Vaccine Ordered By Providers (not Including Local Health Jurisdictions' Offices),
  "number_of_fatal_lab_confirmed_influenza_cases" BIGINT,
  "number_of_flu_vaccinations_given_by_the_agency_and_pro_36d3aeaf" BIGINT  -- Number Of Flu Vaccinations Given By The Agency And Providers To Patients Of All Ages,
  "agency_provided_travel_immunizations" VARCHAR,
  "number_of_travel_vaccination_doses_administered_by_the_agency" BIGINT,
  "number_of_providers_registered_with_doh_to_order_vaccine" BIGINT,
  "number_of_assessment_feedback_incentive_exchange_visits" BIGINT,
  "agency_provided_sexually_transmitted_disease_std_clini_0c017be4" VARCHAR  -- Agency Provided Sexually Transmitted Disease (STD) Clinical Services,
  "number_of_std_clinical_services_patients_unduplicated" BIGINT  -- Number Of STD Clinical Services Patients (unduplicated),
  "number_of_std_clinical_services_visits" BIGINT,
  "agency_provided_std_partner_notification" VARCHAR,
  "number_of_std_partner_notification_services_clients_un_1c4274f9" BIGINT  -- Number Of STD Partner Notification Services Clients (unduplicated),
  "number_of_std_contacts_followed" BIGINT,
  "number_of_new_std_cases_reported_to_doh_for_disease_su_0efa23c9" BIGINT  -- Number Of New STD Cases Reported To DOH For Disease Surveillance,
  "std_cases_investigated_for_disease_surveillance" BIGINT,
  "number_of_std_chlamydia_and_gonorrhea_only_tests_analy_a6a13168" BIGINT  -- Number Of STD (Chlamydia And Gonorrhea Only) Tests Analyzed By State Lab (and Other Contracted DOH Labs),
  "agency_provided_tuberculosis_tb_screening_services" VARCHAR  -- Agency Provided Tuberculosis (TB) Screening Services,
  "number_of_tb_screening_clients_unduplicated" BIGINT  -- Number Of TB Screening Clients (unduplicated),
  "agency_provided_treatment_for_latent_tb_cases" VARCHAR,
  "number_of_latent_tb_treatment_clients_unduplicated" BIGINT  -- Number Of Latent TB Treatment Clients (unduplicated),
  "number_of_latent_tb_treatment_visits" BIGINT,
  "agency_provided_treatment_for_active_tb_cases" VARCHAR,
  "number_of_active_tb_clients_unduplicated" BIGINT  -- Number Of Active TB Clients (unduplicated),
  "number_of_active_tb_treatment_visits" BIGINT,
  "number_of_new_tb_cases_investigated_and_reported_in_ca_a5fb9700" BIGINT  -- Number Of New TB Cases Investigated And Reported In Calendar Year,
  "agency_provided_contact_investigation_services_for_act_29532be9" VARCHAR  -- Agency Provided Contact Investigation Services For Active TB Cases,
  "number_of_active_tb_case_contacts" BIGINT,
  "agency_provided_hiv_aids_counseling_and_testing" VARCHAR,
  "number_of_hiv_counseling_and_testing_clients" BIGINT,
  "number_of_hiv_counseling_and_testing_visits" BIGINT,
  "agency_provided_hiv_aids_treatment" VARCHAR,
  "number_of_hiv_aids_treatment_clients" BIGINT,
  "number_of_hiv_aids_treatment_visits" BIGINT,
  "agency_provided_hiv_aids_case_management" VARCHAR,
  "number_of_hiv_aids_case_management_clients" BIGINT,
  "number_of_hiv_aids_case_management_visits" BIGINT,
  "number_of_new_hiv_cases_requiring_investigating_and_ca_c49ad965" BIGINT  -- Number Of New HIV Cases Requiring Investigating And Case Reporting,
  "number_of_hiv_tests_specimens_processed_by_the_state_lab" BIGINT,
  "number_of_new_aids_progression_cases_investigated_by_the_agency" BIGINT,
  "number_of_new_chronic_hepatitis_b_cases_requiring_agen_5dddfc93" BIGINT  -- Number Of New Chronic Hepatitis B Cases Requiring Agency Investigation,
  "number_of_new_chronic_hepatitis_c_cases_requiring_agen_c32686e9" BIGINT  -- Number Of New Chronic Hepatitis C Cases Requiring Agency Investigation,
  "number_of_twinrix_hepatitis_a_and_b_doses_administered" BIGINT,
  "number_of_hepatitis_c_tests_performed_using_home_acces_334d1395" BIGINT  -- Number Of Hepatitis C Tests Performed Using Home Access Kits Provided By DOH,
  "agency_provided_needle_exchange" VARCHAR
);