Children's Demographics

Welcome to the Proximity Children's Demographics Database Query System.

Registered users may use this "level 1" version of the Database Query System at no fee subject to the terms of use. This version of the system provides access to the Census 2000 school district special tabulation data on the number of children by type of enrollment. Extended versions of this system, available on a subscription fee basis, enable the user to access a wider range of data for school districts and link school and school district data.

Uses of System -- How can I view a type of enrollment profile for my district?

To view school districts that meet your criteria, modify the SQL statement in the text area and then click View. View this sample profile that is generated from the default SQL statement.

UserID: Password: (required, contact us for additional information)

Use any MySQL SELECT operation (see reference manual) in the above form with functions.

Uses of System [goto top]

This version of the System enables you to call up a profile of the number of students by type of enrollment for districts meeting your criteria. You can view the number of children in a school districts, compare one district to other districts, and see how many children are enrolled in private versus public school. You can view how many and what percentage of school age children are not enrolled in school (see related description).

Note: all of the following instructions also work with the School District Information System.

SELECT General Syntax

SELECT what_to_select
FROM which_table (there is only one table in CDSQL)
WHERE conditions_to_satisfy

Example 1 -- Viewing type of enrollment profile for your district -- the simplest case. There are many ways the SQL statement can be structured to achieve this objective. Suppose that you want the profile for Houston Independent School District in Texas. The suggested SQL statement is:

SELECT * FROM sdcop1 WHERE substring(name,1,7)='Houston' and stab='TX'

In the above example, "7" is the numbers of characters to be matched in the left portion of the district name which is "Houston". Since those 7 characters appear in other school district names, the WHERE criteria also makes it mandatory that only districts with stab (State Abbreviation) of "TX" are included in the query.

If the query were for Corpus Christi Independent School District, rather than Houston Independent School District, you would replace "Houston" with "Corpus Christi" and the "7" with "14" (number of left-most match characters in name) as shown in this SQL statement:

SELECT * FROM sdcop1 WHERE substring(name,1,14)='corpus christi' and stab='TX'

Example 2 -- Viewing type of enrollment profile for your district -- a more detailed example. Here is a more detailed example. Suppose that you know the name of the school district is Peoria Unified School District, AZ and want to view a computed percentage. The following SQL statement could be used:

SELECT code, name, tc, rc, rce, rcepub, rceprv, rcne, FORMAT(100*rcne/rc,2), stab FROM sdcop1 WHERE substring(name,1,6)='Peoria' and stab='AZ'

Note that only the first portion of the district name is used and the number of characters specified in the substring function must be the same as the number of characters in the name specified (6 in this example). Since there are "Peoria" named districts in other states, the STAB (State Abbreviation) field is also used as a match criteria. Note that the district names are up/low case and the State Abbreviation field is loaded with upper case values only.

Try it! Cut and paste the above query into the query text box and click View. You will see that there are 3,830 RCNE (Census 2000 relevant children not enrolled) in Peoria USD, AZ and that this is 9.47 percent of the total relevant children.

Example 3 -- How can I get a ranked listing of Texas districts having RCNE of 3,000 or more?

SELECT code, name, tc, rc, rce, rcepub, rceprv, rcne, FORMAT(100*rcne/rc,2), stab FROM sdcop1 WHERE rcne>3000 and stab='TX' ORDER BY rcne DESC

Note: ORDER BY is only available using the School District Information System (not CDSQL).

Example 4 -- How can I get the RCNE sum for each state?

SELECT stab, SUM(RCNE) FROM sdcop1 group by stab ORDER BY stab

Note: SUM is only available using the School District Information System (not CDSQL).

What is SDCOP1? SDCOP1 is the name of the database table being accessed by the SQL statement. The name is shorthand for School District (SD) Children's Own (CO) Table P1 (P1). This shorthand refers to the Census 2000 School District Special Tabulation Children's Own tabulations, Table P1. Items from other database tables may be mixed in queries and displays using the School District Information System.

Items available in this database: [goto top]

Code	Federal School District 7 character code
Name	School District Name
STAB	State Postal Abbreviation
TC	Total Children
RC	Relevant Children
RCE	Relevant Children Enrolled
RCEPUB	Relevant Children Enrolled -- Public
RCEPRV	Relevant Children Enrolled -- Private
RCNE	Relevant Children Not Enrolled

Terms of Use [goto top]

Registered users may utilize data displays for any purpose provided that no income is generated directly or indirectly from use of the data and the source of the data is documented in all uses. Contact Proximity to access extended data or for commercial use of this service.

Definitions and Documentation [goto top]

Total children definition. The 2000 SDST defines a child as a person age 0 to 17 (as of April 1, 2000) or a person age 18 or 19 who is not a high school graduate (based on the educational attainment response from the Census 2000 questionnaire).

Relevant children definition. A child is relevant to a school district if he/she lives within the territory of the district and his/her assigned grade falls within the grade range provided by a district.

This SQL database includes only school districts having 50 or more unweighted number of children (13,559 or 14,286 districts). These data were not tabulated for districts with a smaller number of children.

About ProximityOne. ProximityOne develops geographic-demographic-economic data and analytical tools and helps organizations knit together and use diverse data in a decision-making and analytical framework. We develop custom demographic/economic estimates and projections, develop geographic and geocoded address files, and assist with impact and geospatial analyses. Wide-ranging organizations use our tools (software, data, methodologies) to analyze their own data integrated with other data. Contact us (888-364-7656) with questions or for additional information.