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:
- dejong data column map (xls version)
- dejong data column map (html version)
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 |