Skip to content

Instantly share code, notes, and snippets.

<style>
.wax-popup {
font: 13px/20px 'Helvetica Neue', Helvetica, Arial, sans-serif;
color: #404040;
height: auto;
background: #fff;
border: 1px solid #8C8C8C;
border: 1px solid rgba(0, 0, 0, .45);
-moz-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
-webkit-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
<style>
.wax-popup {
font: 13px/20px 'Helvetica Neue', Helvetica, Arial, sans-serif;
color: #404040;
height: auto;
background: #fff;
border: 1px solid #8C8C8C;
border: 1px solid rgba(0, 0, 0, .45);
-moz-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
-webkit-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
<style>
.wax-popup {
font: 13px/20px 'Helvetica Neue', Helvetica, Arial, sans-serif;
color: #404040;
height: auto;
background: #fff;
border: 1px solid #8C8C8C;
border: 1px solid rgba(0, 0, 0, .45);
-moz-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
-webkit-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
<style>
.wax-popup {
font: 13px/20px 'Helvetica Neue', Helvetica, Arial, sans-serif;
color: #404040;
height: auto;
background: #fff;
border: 1px solid #8C8C8C;
border: 1px solid rgba(0, 0, 0, .45);
-moz-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
-webkit-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
<style>
.wax-popup {
font: 13px/20px 'Helvetica Neue', Helvetica, Arial, sans-serif;
color: #404040;
height: auto;
background: #fff;
border: 1px solid #8C8C8C;
border: 1px solid rgba(0, 0, 0, .45);
-moz-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
-webkit-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);

Abundant testing data have existed for decades. Today we have the tools to access and consume these data like never before. Use the search bar to see how your neighborhood schools are performing. See which neighborhoods enjoy schools with high graduation rates and where more resources are needed. Included are reading and math breakdowns for the 2009-2010 school year, as well indication of how scores have changed since the previous year. For a deeper dive click through on each school to see performance in reading and math for the last three school years, as well as district averages for the 2009-2010.

Visualizing the dynamic geography of testing data not only empowers individual choices about where to send their children, but enables policymakers and researcher to see trends in how schools are performing only visible on a map.

<style>
.wax-tooltip {
font: 13px/20px 'Helvetica Neue', Helvetica, Arial, sans-serif;
color: #404040;
height: auto;
background: #fff;
border: 1px solid #8C8C8C;
border: 1px solid rgba(0, 0, 0, .45);
-moz-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
-webkit-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
<style>
.wax-popup {
font: 13px/20px 'Helvetica Neue', Helvetica, Arial, sans-serif;
color: #404040;
height: auto;
background: #fff;
border: 1px solid #8C8C8C;
border: 1px solid rgba(0, 0, 0, .45);
-moz-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
-webkit-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
<style>
.wax-tooltip {
position: absolute;
height: auto;
background: #fff;
border: 1px solid #8C8C8C;
border: 1px solid rgba(0, 0, 0, .45);
-moz-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
-webkit-box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
box-shadow: 0 1px 8px rgba(0, 0, 0, .3);
@ian29
ian29 / clean-sch.sql
Created January 25, 2012 03:26
clean sch
CREATE TABLE clean_sch AS
SELECT
nt.*,
c.stnam stnam07,
c.fipst fipst07,
schnam07,
c.leanm07,
c.leaid leaid07,
c.ncessch ncessch07,
cast(round((all_math04pctprof_0708 * 100), 1) as text)||'%' all_math04_0708,