Child Abuse Prevention Services In San Francisco by US Government | Demographics and Population Studies

About this Dataset

Child Abuse Prevention Services In San Francisco

Contains information on child abuse prevention services provided by multiple departments within the City and County of San Francisco, including services run directly by City departments and programs provided by contracted organizations. Information was collected by the Controller’s Office as a first step in creating a county-wide abuse prevention plan, and includes program descriptions, cost information (where available), and categorizations by service area, protective factor, target audience, and level of prevention. This data was originally collected in FY19 for programs run during FY18. For more information please see the Controller's report at http://openbook.sfgov.org/webreports/details3.aspx?id=2778
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:07.260251
Tags: abuse-prevention, children, contracts, services

Tables

Table 1

@usgov.city_of_san_francisco_child_abuse_prevention_services__5fd72130.table_1

186.05 KB
375 rows
61 columns


CREATE TABLE table_1 (
  "program_or_contract_name" VARCHAR,
  "contractor_name" VARCHAR,
  "combined_program_and_contractor_name" VARCHAR,
  "program_description" VARCHAR,
  "lead_department" VARCHAR,
  "department_division" VARCHAR,
  "targets_of_service" VARCHAR,
  "service_categories" VARCHAR,
  "levels_of_prevention" VARCHAR,
  "name_of_evidence_based_practice_used" VARCHAR,
  "cebc_rating" VARCHAR,
  "cebc_topic_areas" VARCHAR,
  "cebc_child_welfare_relevance" VARCHAR,
  "protective_factors" VARCHAR,
  "name_of_family_first_practice" VARCHAR,
  "family_first_practice_rating" VARCHAR,
  "contracted_or_direct_service" VARCHAR,
  "program_cost" DOUBLE,
  "program_cost_notes" VARCHAR,
  "number_of_participants" VARCHAR,
  "participant_number_notes" VARCHAR,
  "contract_id_number" VARCHAR,
  "program_relevance_rating" BIGINT,
  "audience_relevance_rating" BIGINT,
  "sc_case_management" BIGINT,
  "sc_crisis_care" BIGINT,
  "sc_mental_behavioral_health" BIGINT,
  "sc_social_emotional_behavioral_development" BIGINT,
  "sc_programs_around_birth" BIGINT,
  "sc_violence_prevention_programs" BIGINT,
  "sc_parent_education" BIGINT,
  "sc_home_visitation" BIGINT,
  "sc_agency_collaboratives" BIGINT,
  "sc_programs_for_professionals" BIGINT,
  "sc_parent_support" BIGINT,
  "sc_programs_for_commercially_sexually_exploited_children" BIGINT,
  "sc_substance_abuse" BIGINT,
  "sc_medical_services" BIGINT,
  "sc_developmental_screening" BIGINT,
  "sc_kinship_navigator" BIGINT,
  "sc_pregnancy_prevention" BIGINT,
  "cebc_anger_management" DOUBLE,
  "cebc_behavior_management" DOUBLE,
  "cebc_core_child_welfare_services" DOUBLE,
  "cebc_engagement" DOUBLE,
  "cebc_mental_health" DOUBLE,
  "cebc_prevention" DOUBLE,
  "cebc_support_services" DOUBLE,
  "cebc_measurement" DOUBLE,
  "target_children" BIGINT,
  "target_parents" BIGINT,
  "target_providers" BIGINT,
  "target_system" BIGINT,
  "level_primary" BIGINT,
  "level_secondary" BIGINT,
  "level_tertiary" BIGINT,
  "pf_social_emotional" BIGINT,
  "pf_parental_resilience" BIGINT,
  "pf_knowledge_of_parenting" BIGINT,
  "pf_concrete_support" BIGINT,
  "pf_social_connections" BIGINT
);