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_provided_direct_client_access_to_health_care_se_a13996a7" VARCHAR,
  "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_clinical_labs_regulated_by_doh" BIGINT,
  "agency_was_involved_in_a_broadly_based_community_healt_a3ee1b85" VARCHAR,
  "agency_was_involved_in_a_narrow_focused_assessment" VARCHAR,
  "focused_assessment_maternal_or_child_health" BIGINT,
  "focused_assessment_communicable_disease_assessment" BIGINT,
  "focused_assessment_environmental_health_assessment" BIGINT,
  "focused_assessment_chronic_disease_prevention_assessment" BIGINT,
  "focused_assessment_health_disparities_assessment" BIGINT,
  "focused_assessment_mental_or_behavioral_health_assessment" BIGINT,
  "focused_assessment_injury_prevention_assessment" BIGINT,
  "focused_assessment_health_care_system_issues_assessment" BIGINT,
  "focused_assessment_built_environment_assessment" BIGINT,
  "focused_assessment_other_assessment" BIGINT,
  "agency_had_a_separate_assessment_program" VARCHAR,
  "number_of_separate_assessment_program_fte_s" DOUBLE,
  "number_of_adults_interviewed_for_behavioral_risk_facto_5ee42ec5" BIGINT,
  "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_providers_enrolled_in_the_washington_state_i_d6d51912" BIGINT,
  "number_of_doses_of_childhood_vaccine_ordered_by_local__494f32b1" BIGINT,
  "number_of_doses_of_childhood_vaccine_ordered_by_provid_5c8c8562" BIGINT,
  "number_of_vaccine_for_children_site_visits" BIGINT,
  "agency_provided_adult_vaccinations" VARCHAR,
  "number_of_adult_vaccination_doses_administered_to_pati_456b90b9" BIGINT,
  "agency_provided_direct_administration_of_flu_vaccine" VARCHAR,
  "number_of_flu_vaccine_doses_administered_to_patients_b_58d463fb" BIGINT,
  "number_of_doses_of_flu_vaccine_ordered_by_providers_no_1891cd82" BIGINT,
  "number_of_fatal_lab_confirmed_influenza_cases" BIGINT,
  "number_of_flu_vaccinations_given_by_the_agency_and_pro_36d3aeaf" BIGINT,
  "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,
  "number_of_std_clinical_services_patients_unduplicated" BIGINT,
  "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_contacts_followed" BIGINT,
  "number_of_new_std_cases_reported_to_doh_for_disease_su_0efa23c9" BIGINT,
  "std_cases_investigated_for_disease_surveillance" BIGINT,
  "number_of_std_chlamydia_and_gonorrhea_only_tests_analy_a6a13168" BIGINT,
  "agency_provided_tuberculosis_tb_screening_services" VARCHAR,
  "number_of_tb_screening_clients_unduplicated" BIGINT,
  "agency_provided_treatment_for_latent_tb_cases" VARCHAR,
  "number_of_latent_tb_treatment_clients_unduplicated" BIGINT,
  "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_treatment_visits" BIGINT,
  "number_of_new_tb_cases_investigated_and_reported_in_ca_a5fb9700" BIGINT,
  "agency_provided_contact_investigation_services_for_act_29532be9" VARCHAR,
  "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_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_c_cases_requiring_agen_c32686e9" BIGINT,
  "number_of_twinrix_hepatitis_a_and_b_doses_administered" BIGINT,
  "number_of_hepatitis_c_tests_performed_using_home_acces_334d1395" BIGINT,
  "agency_provided_needle_exchange" VARCHAR
);