Untitled

top navigation bar - all links here are also available in text at bottom of page

Meta Data Information Table

Meta Data

Data Source ID	Data Source	Data Source Description	Risk Factors	Domain Name	Data Set Name	View Name	Primary Group By Variables	Secondary Group By Variables	URL	Update Frequency	Last Update Date	Archival Indicator	Record Meta Data Url	Comments
1	State of California Department of Alcohol Beverage Control (ABC)	This data reflects all businesses with current licenses for sale of alcohol in the County of San Diego. The data set distinquishes between retail sales and on site sales.	Availability of Drugs	Community	ABC	v_abc_licenses	period license_category		www.abc.ca.gov/abchome.html	Quarterly	2003-03-03 00:00:00	Alcohol Sales Outlets		This file relects current licenses on the day of purchase of the data..
2	California State Department of Education	This data reflects free and reduced school lunch programs. Also know as CalWorks/TANFF.	Extreme Economic Deprivation	Community	CalWorks/Tanff	v_calworks		district_name county_name district_type	www.cde.ca.gov	Annually	2002-11-11 00:00:00	TANFF
3	California State Department of Education	Percentage of students enrolled who drop out in grades 9-12.	Low Commitment to School	School	School Dropout/Enrollment	v_school_enrollment_dropouts		district_name county_name district_type grade_span ethnicity	www.cde.ca.gov	Annually	2002-11-23 00:00:00	High School Dropouts
4	California State Department of Education	This data reflects the Stanford9 test scores at the school level.	Low School Achievement	School	School Performance	v_school_test_data		school_name district_name county_name district_type grade_level test_name	www.cde.ca.gov	Annually	2002-12-04 00:00:00	Poor Academic Performance, Grade 4 & 8
8	RAND	This data reflects existing home sales.	Transitions and Mobility	Community	Existing Home Sales	v_existing_home_sales	calendar_year		ca.rand.org	Annually	2003-01-29 00:00:00	Existing Home Sales		2002 records through November
9	San Diego County Tobacco Control	This data reflects data available for retail outlets that sell tobacco products.	Availability of Drugs	Community	Tobacco	v_tobacco_distributors	calendar_year	calendar_year zip	www.co.san-diego.ca.us/	Annually	2002-12-22 00:00:00	Tobacco Distributors		Store owner missing for 2002.
10	RAND	This data reflects new residential construction.	Transitions and Mobility	Community	New Residence Construction	v_new_residential_construction			ca.rand.org	Annually	2003-01-29 00:00:00	New Residence Contruction
12	SanDAG	This data reflects demographic data by census tract.		Supportive Information	Demographic by census tract	v_demographic_ct	calendar_year			Annually		Supportive Information
13	SanDAG	This data reflects census data by zip code.		Supportive Information	Census Data by zip	v_census_zip	calendar_year			Decennially		Supportive Information
15	SanDAG	This data reflects economic, population and housing data by zip code.	Low Neighborhood Attachment and Community Disorganization	Community	Economic Population and Housing by zip	v_econ_pop_housing_zip	calendar_year			Annually		Residential Vacancies
16	San Diego County Alcohol and Drug Data System	This data reflects adults in Alcohol and Other Drug rehabilitation programs.	Family History of Substance Abuse	Family	SCADDS	v_sdcadds	admit_year zip fiscal_year	race primary_problem route_primary_problem frequency_use_primary_problem secondary_problem route_secondary_problem frequency_use_secondary_problem pregnant gender first_disability public_assistance living_situation employment_status referral_source provider_name income_source legal_status needle_used_ever		Annually	2003-07-06 00:00:00	Adults in Alcohol & Other Drug Treatment
17	RAND	This data reflects felony and misdemenor juvenile arrests.	Early Initiation of the Problem Behavior	Individual	Juvenile Arrests	v_juvenile_arrests	area_name		ca.rand.org	Annually	2003-01-26 00:00:00	Arrests, Ages 10-14		Replaces v_juvenile_alcohol_drug_arrests, v_juvenile_vandalism_crime_arrests and v_juvenile_property_crime_arrests
19	San Diego County Alcohol and Drug Data System	This data reflects adults in driving under the influence programs.			DUIP	v_duip_program	fiscal_year residence_zip arrest_zip	provider_name referral_source court race gender employment_status arrest_agency first_multiple_offender		Annually	2003-07-10 00:00:00	Supportive Information
20	San Diego County Alcohol and Drug Data System	This data reflects adults in Penal Code 1000 programs.			PC1000	v_pc1000_program	fiscal_year residence_zip arrest_zip	provider_name referral_source court client_status arrest_agency arrest_drug primary_problem secondary_problem race gender employment_status primary_language		Annually	2003-07-15 00:00:00	Supportive Information
21	ARJIS	This data reflects domestic violence calls.	Family Conflict	Family	Domestic Violence Arrests	v_domestic_violence_calls				Annually	2003-01-26 00:00:00	Domestic Violence Arrests
23	National Center on Charitable Statistics.	This data reflects non profit organizations.			Non Profit	v_non_profit		non_profit_category classification_name charity_group_name				Supportive Information
24	SanDAG	This data reflects census data by census tract.			Census Data by census tract	v_census_ct	calendar_year			Every ten years		Supportive Information
25	SanDAG	This data reflects demographic data by zip code.			Demographic by zip	v_demographic_zip	calendar_year			Annually		Supportive Information
26	SanDAG	This data reflects economic, population and housing data by census tract.	Low Neighborhood Attachment and Community Disorganization	Community	Economic Population and Housing by census tract	v_econ_pop_housing_ct	calendar_year					Residential Vacancies
27	California State Department of Economic Development (?)	The data reflects employment data by city.	Extreme Economic Deprivation	Community	Unemployment by city	v_unemployment_city	calendar_year		www.calmis.ca.gov/htmlfile/subject/lftable.htm	Monthly?		Unemployment
28	CDC (Centers for Disease Control and Prevention)	Youth Risk Behavior Surey data for monitoring the prevalence of youth behaviors that most influence health. Based on data from the YouthYY application.			YRBS	v_yrb_survey	gender site_name grade_level race		http://www.cdc.gov/nccdphp/dash/yrbs/	Biennually	2003-04-25 00:00:00	Supportive Information		Based on San Diego city schools
29	California State Department of Education	The data reflects information about schools, teachers and students that is collected from each public school in the fall. This represents data by school district.			CBEDS	v_cbeds	fiscal_year	district_name county_name district_type	www.cde.ca.gov	Annually	2002-12-22 00:00:00	Supportive Information
30	CA Department of Health Services	California Department of Health Services Death Statistical Master Files from 1989-1999. The structure of 1999 data changed slightly, and is represented in the database.	Supportive Information	Supportive Information	DSMF Death Records 89-99	v_death_records	zip_code	decedent_birth_date injury_date death_in_hospital_type_description decedent_deathplace_healthservices_location_ID decedent_healthservices_race_name decedent_sex_gender decedent_birthplace_healthservices_location_name decedent_age_unit_name decedent_healthservices_marital_status underlying_cause_of_death_group_code decedent_healthservices_hispanic_origin_description underlying_cause_of_infant_death_group_code decedent_residence_state_healthservices_location_name death_special_medical_indicator_description local_registration_district_healthservices_location_ID injury_occurred_at_environmental_place_description death_certifier_description death_activity_description death_manner_of_description underlying_cause_of_death_code facility_where_decedent_died_type_description		Annually	2001-06-04 00:00:00	Supportive Information
32	CA Department of Health Services	California Department of Health Services Birth Public Use Files from 1989-1999.	Supportive Information	Supportive Information	Birth Records Public Use Files from 1989-1999	v_birth_records	birth_mother_zip birth_child_information_birth_year birth_child_healthservices_race_name birth_child_information_gender birth_father_healthservices_race_name	birth_medical_information_birth_delivery_method_description birth_medical_information_prenatal_principle_healthservices_payment_source_description birth_medical_information_delivery_expected_healthservices_payment_source_description birth_child_information_birth_type_description birth_mother_healthservices_hispanic_origin_description birth_mother_residence_healthservices_place_name birth_mother_special_factor_marital_status birth_place_healthservices_place_name birth_mother_birthplace_healthservices_global_place_name birth_child_information_birth_date birth_child_information_birth_hour		Annually	2001-06-04 00:00:00	Supportive Information
33	Statewide Database	This data reflects general election data for the County of San Diego.		Supportive Information	Election	v_general_election_2000	calendar_year		swdb.igs.berkeley.edu/cgi-bin/data	Annually	2003-07-22 00:00:00	Supportive Information		1/2003 need to create separate years.
34	California State Department of Education	This data provides information about private school enrollment in California.	Supportive Information	Supportive Information	private school enrollment	v_private_school_enrollment			www.cde.ca.gov/privateschools	Annually	2001-10-15 00:00:00	Supportive Information		Do not have address information for all schools. Cannot query by zip.
35	California State Department of Educational Planning and Information Center	This data provides information about the Scholastic Assessment Test (SAT).	Supportive Information	Supportive Information	SAT records by School Names	v_school_sat_scores		school_name district_name county_name district_type	www.cde.ca.gov/ope/epic/sat/	Annually	2003-01-30 00:00:00	Supportive Information		Do not have address information for all schools. Cannot query by zip.
36	California State Department of Education	This data reflects the Stanford9 test scores at the school district level.	Low School Achievement	School	School Performance by School District Names	v_school_district_test_data	fiscal_year	district_name county_name district_type grade_level test_name	www.cde.ca.gov	Annually	2002-12-04 00:00:00	Poor Academic Performance, Grade 4 & 8
37	California State Department of Education	This data reflects the Stanford9 test scores at the county level.	Low School Achievement	School	School Performance by County Names	v_school_county_test_data	fiscal_year	county_name grade_level test_name	www.cde.ca.gov	Annually	2002-12-04 00:00:00	Poor Academic Performance, Grade 4 & 8
38	6-6 Program	This data reflects 6-6 programs which provide a safe place for elementary and middle school children before and after normal school hours.			6 6 Program	v_6_6_program			www.sannet.gov/6to6/index.shtml	Annually	2003-01-20 00:00:00	Supportive Information
39	Head Start Program	This data reflects Head Start Programs. Head Start is a comprehensive child development program that servers children from birth to age 5, pregnant women, and their families.			Child Care	v_head_start_program				Annually	2001-05-01 00:00:00	Supportive Information		created new view 4/21/02
40	Licensed Child Care	This data reflects licensed child centers which provide a safe place for elementary and middle school children before and after normal school hours.			Child Care	v_child_care				Annually	2001-05-01 00:00:00	Supportive Information		created new view 4/21/02
41	California State Department of Economic Development	The data reflects employment data by city.	Extreme Economic Deprivation	Community	Unemployment by City	v_unemployment_city				Annually	2002-11-23 00:00:00	Unemployment		Not previously listed
42	US Government	This data reflects census data by census tract from the SF-1 census file.	Supportive Information	Supportive Information	Census 2000	v_census_2000_ct	calendar_year		www.census.gov	Every Ten Years	2002-11-25 00:00:00	Supportive Information
43	Statewide Database	This data reflects general election data for the County of San Diego.		Supportive Information	General Election 2000	v_general_election_2000	calendar_year		swdb.igs.berkeley.edu/cgi-bin/data	Annually	2003-01-26 00:00:00	Supportive Information	swb.igs.berkeley.edu/
46	San Diego County Alcohol and Drug Data System	This data reflects adults in the Inebriate Reception Center.	Supportive Information	Supportive Information	IRC	v_irc_program	admit_year zip fiscal_year			Annually	2003-02-18 00:00:00	Supportive Information