Public Health Activities And Services - 2014

CREATE TABLE table_1 (
  "entity" VARCHAR,
  "environmental_public_health_food_safety_permanent_food_729436f6" DOUBLE  -- Environmental Public Health - Food Safety: Permanent Food Service Establishments Permitted,
  "environmental_public_health_food_safety_permanent_food_1ed94ada" DOUBLE  -- Environmental Public Health - Food Safety: Permanent Food Service Establishments Inspected,
  "environmental_public_health_food_safety_routine_perman_0e39d679" DOUBLE  -- Environmental Public Health - Food Safety: Routine Permanent Food Service Establishment Inspections,
  "environmental_public_health_food_safety_temporary_food_bf0950ff" DOUBLE  -- Environmental Public Health - Food Safety: Temporary Food Service Establishments Permitted,
  "environmental_public_health_food_safety_temporary_food_340177b8" DOUBLE  -- Environmental Public Health - Food Safety: Temporary Food Service Establishments Inspected,
  "environmental_public_health_food_safety_temporary_food_a67fb8e9" DOUBLE  -- Environmental Public Health - Food Safety: Temporary Food Service Establishment Inspections,
  "environmental_public_health_food_safety_food_worker_ca_2af37cea" DOUBLE  -- Environmental Public Health - Food Safety: Food Worker Cards Issued,
  "environmental_public_health_food_safety_food_service_e_706b4e15" DOUBLE  -- Environmental Public Health - Food Safety: Food Service Establishment Complaints Investigated,
  "environmental_public_health_food_safety_investigations_b7105131" DOUBLE  -- Environmental Public Health - Food Safety: Investigations Of Reported Foodborne/waterborne Disease Cases,
  "environmental_public_health_food_safety_lab_confirmed__06c307c4" DOUBLE  -- Environmental Public Health - Food Safety: Lab Confirmed Foodborne Illness Outbreak Investigations,
  "environmental_public_health_food_safety_cases_investig_d2e64876" DOUBLE  -- Environmental Public Health - Food Safety: Cases Investigated As Part Of A Lab Confirmed Foodborne Illness Outbreaks,
  "environmental_public_health_food_safety_food_product_r_350c6efb" DOUBLE  -- Environmental Public Health - Food Safety: Food Product Recalls And Safety Alerts Issued By DOH,
  "environmental_public_health_on_site_sewage_systems_on__ca4746a0" DOUBLE  -- Environmental Public Health - On-Site Sewage Systems: On-site Sewage System Permits Issued,
  "environmental_public_health_on_site_sewage_systems_on__a5dbfe37" DOUBLE  -- Environmental Public Health - On-Site Sewage Systems: On-site Sewage System Complaints Investigated,
  "environmental_public_health_on_site_sewage_systems_on__d052e913" DOUBLE  -- Environmental Public Health - On-Site Sewage Systems: On-site Sewage System Failures Reported,
  "environmental_public_health_on_site_sewage_systems_on__27b2602b" DOUBLE  -- Environmental Public Health - On-Site Sewage Systems: On-site Sewage System Repair Permits Issued,
  "environmental_public_health_on_site_sewage_systems_on__4588b3ea" DOUBLE  -- Environmental Public Health - On-Site Sewage Systems: On-site Sewage System Failures With Corrective Action Began Within 2 Weeks,
  "environmental_public_health_drinking_water_large_publi_e0e9bc73" DOUBLE  -- Environmental Public Health - Drinking Water: Large Public Drinking Water System (Group A) Surveys,
  "environmental_public_health_drinking_water_samples_fro_5ce04f9e" DOUBLE  -- Environmental Public Health - Drinking Water: Samples From Large Public Drinking Water Systems (Group A) Submitted And Evaluated For Public Health Protection,
  "environmental_public_health_drinking_water_lab_confirm_5d14c847" DOUBLE  -- Environmental Public Health - Drinking Water: Lab Confirmed Waterborne Illness Outbreak Investigations,
  "environmental_public_health_drinking_water_drinking_wa_d95624db" DOUBLE  -- Environmental Public Health - Drinking Water: Drinking Water Health Advisories Issued,
  "environmental_public_health_drinking_water_people_affe_1c9d7367" DOUBLE  -- Environmental Public Health - Drinking Water: People Affected By Drinking Water Health Advisories,
  "environmental_public_health_drinking_water_people_serv_e306d20c" DOUBLE  -- Environmental Public Health - Drinking Water: People Served By Large Public Drinking Water Systems (Group A),
  "environmental_public_health_drinking_water_number_of_t_4481b79a" DOUBLE  -- Environmental Public Health - Drinking Water: Number Of These People Served By Systems With No Maximum Contamination Level Violations,
  "environmental_public_health_water_recreational_facilit_4bb60173" DOUBLE  -- Environmental Public Health - Water Recreational Facilities: Water Recreational Facilities Permitted,
  "environmental_public_health_water_recreational_facilit_caf82bd1" DOUBLE  -- Environmental Public Health - Water Recreational Facilities: Water Recreational Facility Inspections,
  "environmental_public_health_water_recreational_facilit_adc317d8" DOUBLE  -- Environmental Public Health - Water Recreational Facilities: Water Recreational Facility Closures,
  "environmental_public_health_solid_waste_facilities_sol_dc9c6b57" DOUBLE  -- Environmental Public Health - Solid Waste Facilities: Solid Waste Facilities Permitted,
  "environmental_public_health_solid_waste_facilities_rou_0143620a" DOUBLE  -- Environmental Public Health - Solid Waste Facilities: Routine Solid Waste Facility Inspections,
  "environmental_public_health_solid_waste_facilities_sol_06271a57" DOUBLE  -- Environmental Public Health - Solid Waste Facilities: Solid Waste Complaints Investigated,
  "environmental_public_health_x_ray_machines_facilities__cdc34f84" DOUBLE  -- Environmental Public Health - X-Ray Machines: Facilities Using X-ray Machines Registered With DOH For Safety And Regulatory Compliance,
  "environmental_public_health_x_ray_machines_routine_x_r_e1d59cb7" DOUBLE  -- Environmental Public Health - X-Ray Machines: Routine X-ray Facility Inspections To Evaluated For Safety,
  "environmental_public_health_shellfish_samples_collecte_e74d9ab9" DOUBLE  -- Environmental Public Health - Shellfish: Samples Collected And Analyzed For Safe Shellfish Consumption - Marine Biotoxins,
  "environmental_public_health_shellfish_samples_collecte_554c9220" DOUBLE  -- Environmental Public Health - Shellfish: Samples Collected And Analyzed For Safe Shellfish Consumption - Vibrio Parahaemolyticus,
  "environmental_public_health_shellfish_samples_collecte_bc26ff2d" DOUBLE  -- Environmental Public Health - Shellfish: Samples Collected And Analyzed For Safe Shellfish Consumption - Total,
  "environmental_public_health_childhood_lead_poisoning_c_ca0a3c18" DOUBLE  -- Environmental Public Health - Childhood Lead Poisoning: Cases Of Elevated Blood Lead (?5 Mcg/dL) In Children Ages 0-6 Years,
  "environmental_public_health_childhood_lead_poisoning_c_328e0884" DOUBLE  -- Environmental Public Health - Childhood Lead Poisoning: Cases Of Elevated Blood Lead In Children Age 0-6 Years Investigated,
  "environmental_public_health_pesticides_pesticide_illne_73f5f9ad" DOUBLE  -- Environmental Public Health - Pesticides: Pesticide Illness Incidents Investigated, Both Agricultural And Non-agricultural,
  "environmental_public_health_pesticides_cases_investiga_97cb9e36" DOUBLE  -- Environmental Public Health - Pesticides: Cases Investigated For Possible Pesticide Exposure,
  "environmental_public_health_west_nile_virus_mosquito_s_6c37bca2" DOUBLE  -- Environmental Public Health - West Nile Virus: Mosquito Samples Analyzed For West Nile Virus,
  "environmental_public_health_west_nile_virus_birds_test_0f50cbe4" DOUBLE  -- Environmental Public Health - West Nile Virus: Birds Tested For West Nile Virus,
  "other_environmental_public_health_environmental_sample_0a44e06c" BIGINT  -- Other Environmental Public Health: Environmental Samples Tested At The State Lab For Chemical, Radiological, Or Microbiological Analysis,
  "communicable_disease_tuberculosis_tb_reported_newly_di_daa19779" DOUBLE  -- Communicable Disease - Tuberculosis (TB): Reported Newly Diagnosed Active TB Cases,
  "communicable_disease_tuberculosis_tb_lhj_directly_prov_9b3dfdfb" VARCHAR  -- Communicable Disease - Tuberculosis (TB): LHJ Directly Provided Active TB Treatment,
  "communicable_disease_tuberculosis_tb_unduplicated_acti_226a2275" DOUBLE  -- Communicable Disease - Tuberculosis (TB): Unduplicated Active TB Treatment Clients,
  "communicable_disease_tuberculosis_tb_active_tb_treatme_0a76eb26" DOUBLE  -- Communicable Disease - Tuberculosis (TB): Active TB Treatment Client Visits,
  "communicable_disease_tuberculosis_tb_active_tb_cases_p_20d0f4f8" DOUBLE  -- Communicable Disease - Tuberculosis (TB): Active TB Cases Placed On Directly Observed Therapy,
  "communicable_disease_tuberculosis_tb_active_tb_cases_p_84bf2ade" DOUBLE  -- Communicable Disease - Tuberculosis (TB): Active TB Cases Placed On Directly Observed Therapy And Completed It,
  "communicable_disease_tuberculosis_tb_lhj_directly_prov_75881e50" VARCHAR  -- Communicable Disease - Tuberculosis (TB): LHJ Directly Provided Contact Investigation Services For Active TB Cases,
  "communicable_disease_tuberculosis_tb_unduplicated_peop_24c817ac" DOUBLE  -- Communicable Disease - Tuberculosis (TB): Unduplicated People (contacts Of Active Disease Cases) Who Were Contacted,
  "communicable_disease_tuberculosis_tb_unduplicated_peop_409455a0" DOUBLE  -- Communicable Disease - Tuberculosis (TB): Unduplicated People (contacts Of Active Disease Cases) Evaluated For TB Infection,
  "communicable_disease_tuberculosis_tb_tb_infection_case_458aa0f9" DOUBLE  -- Communicable Disease - Tuberculosis (TB): TB Infection Cases Newly Diagnosed By LHJ,
  "communicable_disease_tuberculosis_tb_lhj_directly_prov_0f0f0b07" VARCHAR  -- Communicable Disease - Tuberculosis (TB): LHJ Directly Provided TB Infection Treatment,
  "communicable_disease_tuberculosis_tb_unduplicated_tb_i_c9b203f8" DOUBLE  -- Communicable Disease - Tuberculosis (TB): Unduplicated TB Infection Treatment Clients,
  "communicable_disease_tuberculosis_tb_tb_infection_trea_f48db73f" DOUBLE  -- Communicable Disease - Tuberculosis (TB): TB Infection Treatment Client Visits,
  "communicable_disease_tuberculosis_tb_people_with_tb_in_bb088e9f" DOUBLE  -- Communicable Disease - Tuberculosis (TB): People With TB Infection Newly Diagnosed By LHJ And Started Treatment,
  "communicable_disease_tuberculosis_tb_people_with_tb_in_a21228b6" DOUBLE  -- Communicable Disease - Tuberculosis (TB): People With TB Infection Newly Diagnosed By LHJ And Completed Treatment,
  "communicable_disease_sexually_transmitted_disease_std__dede34c5" VARCHAR  -- Communicable Disease - Sexually Transmitted Disease (STD): LHJ Directly Provided STD Clinical Services,
  "communicable_disease_sexually_transmitted_disease_std__dce2eacc" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): Unduplicated STD Clinical Services Clients,
  "communicable_disease_sexually_transmitted_disease_std__eb9d5fe0" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): STD Clinical Services Client Visits,
  "communicable_disease_sexually_transmitted_disease_std__8ae8a68d" VARCHAR  -- Communicable Disease - Sexually Transmitted Disease (STD): LHJ Directly Provided STD Partner Notification And Therapy,
  "communicable_disease_sexually_transmitted_disease_std__42ed5ac4" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): Unduplicated Partner Services Clients - Gonorrhea,
  "communicable_disease_sexually_transmitted_disease_std__ee2dd553" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): Unduplicated Partner Services Clients - Chlamydia,
  "communicable_disease_sexually_transmitted_disease_std__ee732dbd" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): Unduplicated Partner Services Clients - Syphilis,
  "communicable_disease_sexually_transmitted_disease_std__9b545fdb" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): Unduplicated Partner Services Clients - HIV,
  "communicable_disease_sexually_transmitted_disease_std__9fd3994a" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): Total Unduplicated Partner Services Clients,
  "communicable_disease_sexually_transmitted_disease_std__a9a59083" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): Confirmed STD Cases - Gonorrhea,
  "communicable_disease_sexually_transmitted_disease_std__c70d459a" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): Confirmed STD Cases - Chlamydia,
  "communicable_disease_sexually_transmitted_disease_std__05e996fd" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): Confirmed STD Cases - Syphilis,
  "communicable_disease_sexually_transmitted_disease_std__935da072" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): Confirmed STD Cases - HIV,
  "communicable_disease_sexually_transmitted_disease_std__719e8b0d" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): Total Confirmed STD Cases,
  "communicable_disease_sexually_transmitted_disease_std__7d4ca811" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): STD Cases Investigated For Disease Surveillance,
  "communicable_disease_sexually_transmitted_disease_std__dcb9da72" DOUBLE  -- Communicable Disease - Sexually Transmitted Disease (STD): STD (gonorrhea, Chlamydia, Syphilis, HIV) Tests Analyzed By The State Lab And Other DOH Contracted Labs,
  "communicable_disease_hiv_aids_lhj_directly_provided_hi_ec798c03" VARCHAR  -- Communicable Disease - HIV/AIDS: LHJ Directly Provided HIV Testing And Counseling Services,
  "communicable_disease_hiv_aids_unduplicated_hiv_testing_clients" DOUBLE  -- Communicable Disease - HIV/AIDS: Unduplicated HIV Testing Clients,
  "communicable_disease_hiv_aids_total_hiv_testing_client_visits" DOUBLE  -- Communicable Disease - HIV/AIDS: Total HIV Testing Client Visits,
  "communicable_disease_hiv_aids_lhj_directly_provided_hi_051643e3" VARCHAR  -- Communicable Disease - HIV/AIDS: LHJ Directly Provided HIV Medical Case Management,
  "communicable_disease_hiv_aids_unduplicated_hiv_medical_841c99c5" DOUBLE  -- Communicable Disease - HIV/AIDS: Unduplicated HIV Medical Case Management Clients,
  "communicable_disease_hiv_aids_hiv_medical_case_managem_57f9dc3a" DOUBLE  -- Communicable Disease - HIV/AIDS: HIV Medical Case Management Client Visits,
  "communicable_disease_hiv_aids_new_hiv_cases_that_requi_aea82ef3" DOUBLE  -- Communicable Disease - HIV/AIDS: New HIV Cases That Required Investigation And Case Reporting,
  "communicable_disease_hiv_aids_hiv_tests_specimens_proc_b78db3d0" DOUBLE  -- Communicable Disease - HIV/AIDS: HIV Tests/specimens Processed By The State Lab And Other DOH Contracted Labs,
  "communicable_disease_hiv_aids_new_aids_progression_cas_f6d75b02" DOUBLE  -- Communicable Disease - HIV/AIDS: New AIDS Progression Cases Investigated By LHJ,
  "communicable_disease_hepatitis_new_chronic_hepatitis_b_ff49ede8" DOUBLE  -- Communicable Disease - Hepatitis: New Chronic Hepatitis B Cases That Required LHJ Investigation And Case Reporting,
  "communicable_disease_hepatitis_new_chronic_hepatitis_c_ab842f18" DOUBLE  -- Communicable Disease - Hepatitis: New Chronic Hepatitis C Cases That Required LHJ Investigation And Case Reporting,
  "communicable_disease_hepatitis_hepatitis_c_tests_perfo_a5e37252" DOUBLE  -- Communicable Disease - Hepatitis: Hepatitis C Tests Performed Using Test Kits Provided By DOH,
  "communicable_disease_needle_exchange_lhj_provided_need_d2b1a685" VARCHAR  -- Communicable Disease - Needle Exchange: LHJ Provided Needle Exchange Program,
  "communicable_disease_needle_exchange_needles_exchanged" DOUBLE  -- Communicable Disease - Needle Exchange: Needles Exchanged,
  "communicable_disease_communicable_diseases_investigate_03e07aaf" DOUBLE  -- Communicable Disease: Communicable Diseases Investigated By LHJ And Reported To DOH (Non STD, TB, HIV/AIDS, Hepatitis, Pertussis, Measles, Mumps, West Nile Virus And Salmonella),
  "communicable_disease_vaccine_preventable_disease_cases_2d0ca78d" DOUBLE  -- Communicable Disease - Vaccine-Preventable Disease Cases: Pertussis - (unvaccinated,
  "communicable_disease_vaccine_preventable_disease_cases_084f2fa2" DOUBLE  -- Communicable Disease - Vaccine-Preventable Disease Cases: Pertussis - (unvaccinated),
  "communicable_disease_vaccine_preventable_disease_cases_822a7c51" DOUBLE  -- Communicable Disease - Vaccine-Preventable Disease Cases: Pertussis - (unknown Vaccine Status),
  "communicable_disease_vaccine_preventable_disease_cases_c1defde3" DOUBLE  -- Communicable Disease - Vaccine-Preventable Disease Cases: Total Pertussis Cases,
  "communicable_disease_vaccine_preventable_disease_cases_a30aa1cc" DOUBLE  -- Communicable Disease - Vaccine-Preventable Disease Cases: Mumps - (vaccinated),
  "communicable_disease_vaccine_preventable_disease_cases_3bd15a41" DOUBLE  -- Communicable Disease - Vaccine-Preventable Disease Cases: Mumps - (unvaccinated),
  "communicable_disease_vaccine_preventable_disease_cases_3a489ed6" DOUBLE  -- Communicable Disease - Vaccine-Preventable Disease Cases: Mumps - (unknown Vaccine Status),
  "communicable_disease_vaccine_preventable_disease_cases_ece4ef46" DOUBLE  -- Communicable Disease - Vaccine-Preventable Disease Cases: Communicable Disease - Total Mumps Cases,
  "communicable_disease_vaccine_preventable_disease_cases_119ee73c" DOUBLE  -- Communicable Disease - Vaccine-Preventable Disease Cases: Measles - (vaccinated),
  "communicable_disease_vaccine_preventable_disease_cases_85295913" DOUBLE  -- Communicable Disease - Vaccine-Preventable Disease Cases: Measles - (unvaccinated),
  "communicable_disease_vaccine_preventable_disease_cases_0d928a6c" DOUBLE  -- Communicable Disease - Vaccine-Preventable Disease Cases: Measles - (unknown Vaccine Status)
);