# tianjara.net | Andrew Harvey's Blog

myschool NPLAN Data (and NSW's Attempt at Censorship)
18th February 2010

Following up from my previous post, I have made improvements to the code, and I now have all the NPLAN data too. There are also some data files so you don't need to run the scraper and parser which hopefully this makes the data more usable and to a wider range of people. Now that I have the NPLAN data you can compare schools in terms of their (I assume the numbers are averages) test results. I was going to put in the repository some tables mashing together some of the data in the database, but I've had to research about a silly NSW law first. I'm not exactly sure what I can publish and what the implication of that would be (so best make your own league tables and possibly publish them if you want). The NSW law says,

A person must not, in a newspaper or other document that is publicly available in this State: (a) publish any ranking or other comparison of particular schools according to school results, or, (b) identify a school as being in a percentile of less than 90 per cent in relation to school results.

The folks at the Sydney Morning Herald seem to think that "Published online the same tables infringe no law; printed on these pages they are illegal." This is not what I interpret the law as. Publishing online means that the document is available for access from NSW. However I am confident I can get around this by not hosting anything myself and not hosting in Australia. For this I rely on the great services provided by wordpress.com (Automattic, Inc.) and/or github.com (GitHub, Inc.). Hopefully these US companies wouldn't cave into any threats from the Australian government.

This section of the law carries a maximum of 50 penalty units. Which is currently a fine of \$5500, that is a large enough sum for me to take extra care. This is why I'm still not sure if I should put such lists like schools ordered by certain NPLAN results in the github repository.

By the way, this censorship and damaging law raises the same questions and problems (problems for those that wish to avoid criminal or civil charges) about legal jurisdiction over the internet, the classic example is the "yahoo! nazi paraphernalia" debacle.

Footnote: This SQL query should give you an ordered list of schools based on the 2009 year 9 NPLAN results (but I guess if you can load the database dump you can probably write your own queries...).

SELECT s.name, n.score, sub.state
FROM nplan n, school s, (SELECT distinct pcode, state FROM suburb) sub
WHERE n.school = s.myschool_url
AND s.postcode = sub.pcode
AND n.year = 2009
ORDER BY n.score DESC;