DeJong-Richter data imported into public database

Someone was asking some questions of the DeJong-Richter “Futures Conference” survey data, and I decided it would be easiest to answer the questions if the data were in a database. I know, you are rolling your eyes. However, part of my justification stems from the fact that the data has some messy outliers. For instance, one survey responder said they were 65+ years old and a student in Unit 4. Another student said they were associated with both Centennial and Central. Some high school students did not say they were Unit 4 students. So for me, the easiest way to start grouping (and aggregating) the answers is with a database.

For those geeky enough to know what to do with this information:

  • rdbms type: mysql
  • host: mysql.cb-pta.com
  • port: 3306 (default)
  • user: dr_reader
  • password: {try typing in the the username}1
  • database: dejong_data

 

 

Importing the data was more of a pain than I thought – the original has a ton of #REF fields that I eventually just decided to strip out. Which totally threw off the column mapping, so I am providing a simple one:

 

Here are some of the queries I started playing around with (having troubles with wordpress tables again…. *sigh*):

SELECT ba, count(*) FROM `survey` group by ba;
80
1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) 128
1 Traditional, Comprehensive High School (1 at 3,000 students) 150
2 Traditional, Comprehensive High Schools (2 at 1,300 students) AND 1 Magnet / Thematic High School (1 at 400 students) 292
2 Traditional, Comprehensive High Schools (2 at 1,500 students) 316
3 Traditional, Comprehensive High Schools (3 at 1,000 students) 301
Other 58
SELECT a, ba, bq, cj, dm, dl, count(*) FROM `survey`
where (ba = '2 Traditional, Comprehensive High Schools (2 at 1,500 students)' or ba = '1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students)')
-- and (dm = 'X' or dl = 'X') -- high schools
and (bq = 'Under 18' or cj = 'X') -- age or student
group by a, ba, bq, cj, dm, dl;
a ba bq cj dm dl count(*)
Paper: Scanning 1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) Under 18 X X 1
Paper: Scanning 1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) Under 18 X X 1
Paper: Scanning 2 Traditional, Comprehensive High Schools (2 at 1,500 students) Under 18 1
Paper: Scanning 2 Traditional, Comprehensive High Schools (2 at 1,500 students) Under 18 X 1
Paper: Scanning 2 Traditional, Comprehensive High Schools (2 at 1,500 students) Under 18 X X 1
Web 1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) X 1
Web 1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) 18 – 29 X X 2
Web 1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) 30 – 39 X 1
Web 1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) Under 18 10
Web 1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) Under 18 X 1
Web 1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) Under 18 X 7
Web 1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) Under 18 X 27
Web 1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) Under 18 X X 20
Web 1 Traditional, Comprehensive High School (1 at 2,600 students) AND 1 Magnet / Thematic High School (1 at 400 students) Under 18 X X X 2
Web 2 Traditional, Comprehensive High Schools (2 at 1,500 students) 18 – 29 X X 1
Web 2 Traditional, Comprehensive High Schools (2 at 1,500 students) 18 – 29 X X X 1
Web 2 Traditional, Comprehensive High Schools (2 at 1,500 students) 65 + X 1
Web 2 Traditional, Comprehensive High Schools (2 at 1,500 students) 65 + X X 1
Web 2 Traditional, Comprehensive High Schools (2 at 1,500 students) Under 18 19
Web 2 Traditional, Comprehensive High Schools (2 at 1,500 students) Under 18 X 2
Web 2 Traditional, Comprehensive High Schools (2 at 1,500 students) Under 18 X 19
Web 2 Traditional, Comprehensive High Schools (2 at 1,500 students) Under 18 X 94
Web 2 Traditional, Comprehensive High Schools (2 at 1,500 students) Under 18 X X 7
Web 2 Traditional, Comprehensive High Schools (2 at 1,500 students) Under 18 X X 79
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: