Data source: Big Local News · About: Big Local

90,288 rows where state = "NY" and year = 2015 sorted by ccd_school_low_grade

View and edit SQL

year

  • 2015 · 90,188
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ▼ ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
783831 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_3 194.0 4.0 22.0         5.0     11.0   112.0 124.0             120     32   236 194 4 22         5     11   112 124         120   32   236
783832 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
783833 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
783834 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
783835 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
783836 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
783837 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
783838 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
783839 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
783840 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   pk_12_total 418.0 10.0 37.0         10.0     27.0   245.0 257.0             237     64   502 418 10 37         10     27   245 257         237   64   502
783841 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   pre_kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
783842 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   pre_kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
783843 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   ungraded_elementary 1.0 0.0 0.0         1.0     0.0   1.0 1.0             *     *   2 1 0 0         1     0   1 1                 2
783844 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000284 261801060004 BARCLAY ELEMENTARY SCHOOL public Regular School No 1 01 03 2015   ungraded_secondary 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
784510 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_1 4.0 66.0 133.0   0.0     1.0     0.0   102.0 102.0             162     8   204 4 66 133   0     1     0   102 102         162   8   204
784511 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_10 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784512 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_11 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784513 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_12 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784514 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_2 5.0 54.0 109.0   1.0     1.0     0.0   95.0 75.0             129     30   170 5 54 109   1     1     0   95 75         129   30   170
784515 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_3 2.0 49.0 91.0   0.0     0.0     1.0   81.0 62.0             120     12   143 2 49 91   0     0     1   81 62         120   12   143
784516 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_4 17.0 49.0 73.0   3.0     0.0     1.0   88.0 55.0             107     8   143 17 49 73   3     0     1   88 55         107   8   143
784517 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_5 2.0 50.0 61.0   0.0     2.0     0.0   55.0 60.0             92     *   115 2 50 61   0     2     0   55 60         92       115
784518 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_6 0.0 0.0 2.0   0.0     0.0     0.0   1.0 1.0             0     0   2 0 0 2   0     0     0   1 1         0   0   2
784519 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784520 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784521 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784522 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784523 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784524 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   pk_12_total 30.0 268.0 470.0   4.0     4.0     2.0   423.0 355.0             610     64   778 30 268 470   4     4     2   423 355         610   64   778
784525 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784526 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784527 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   ungraded_elementary 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0             0     *   1 0 0 1   0     0     0   1 0         0       1
784528 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 FRANKLIN SCHOOL public Regular School No 1 01 06 2015   ungraded_secondary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784529 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_1 1.0 46.0 77.0   0.0     2.0     0.0   68.0 58.0             109     8   126 1 46 77   0     2     0   68 58         109   8   126
784530 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_10 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784531 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_11 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784532 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_12 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784533 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_2 10.0 41.0 66.0   0.0     0.0     0.0   58.0 59.0             96     7   117 10 41 66   0     0     0   58 59         96   7   117
784534 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_3 5.0 39.0 63.0   2.0     2.0     1.0   52.0 60.0             95     13   112 5 39 63   2     2     1   52 60         95   13   112
784535 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_4 7.0 34.0 43.0   0.0     2.0     0.0   39.0 47.0             79     *   86 7 34 43   0     2     0   39 47         79       86
784536 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_5 2.0 23.0 36.0   0.0     2.0     0.0   29.0 34.0             53     *   63 2 23 36   0     2     0   29 34         53       63
784537 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784538 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784539 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784540 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   grade_9 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784541 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784542 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784543 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   pk_12_total 26.0 187.0 289.0   2.0     8.0     1.0   252.0 261.0             440     46   513 26 187 289   2     8     1   252 261         440   46   513
784544 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784545 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784546 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   ungraded_elementary 1.0 4.0 4.0   0.0     0.0     0.0   6.0 3.0             8     9   9 1 4 4   0     0     0   6 3         8   9   9
784547 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No 1 01 05 2015   ungraded_secondary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
784548 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_1 1.0 34.0 88.0   1.0           0.0   65.0 59.0             102     11   124 1 34 88   1           0   65 59         102   11   124
784549 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_10 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784550 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_11 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784551 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_12 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784552 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_2 4.0 19.0 51.0   0.0           2.0   41.0 35.0             62     5   76 4 19 51   0           2   41 35         62   5   76
784553 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_3 6.0 25.0 63.0   0.0           2.0   59.0 37.0             61     7   96 6 25 63   0           2   59 37         61   7   96
784554 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 9.0 26.0 30.0   0.0           0.0   38.0 27.0             59     6   65 9 26 30   0           0   38 27         59   6   65
784555 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_5 2.0 33.0 49.0   0.0           0.0   41.0 43.0             73     11   84 2 33 49   0           0   41 43         73   11   84
784556 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_6 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784557 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_7 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784558 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_8 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784559 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_9 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784560 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   kindergarten_full_day 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784561 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   kindergarten_half_day 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784562 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   pk_12_total 22.0 137.0 281.0   1.0           4.0   244.0 201.0             357     40   445 22 137 281   1           4   244 201         357   40   445
784563 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   pre_kindergarten_full_day 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784564 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   pre_kindergarten_half_day 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784565 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   ungraded_elementary 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784566 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   ungraded_secondary 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
784567 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_1 0.0 26.0 90.0   1.0     0.0         65.0 52.0             95     *   117 0 26 90   1     0         65 52         95       117
784568 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_10 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784569 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_11 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784570 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_12 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784571 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_2 3.0 12.0 76.0   0.0     1.0         46.0 46.0             67     *   92 3 12 76   0     1         46 46         67       92
784572 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_3 5.0 17.0 62.0   1.0     0.0         36.0 49.0             67     *   85 5 17 62   1     0         36 49         67       85
784573 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_4 16.0 27.0 64.0   0.0     1.0         52.0 56.0             92     22   108 16 27 64   0     1         52 56         92   22   108
784574 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_5 0.0 32.0 72.0   1.0     0.0         55.0 50.0             69     19   105 0 32 72   1     0         55 50         69   19   105
784575 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_6 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784576 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_7 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784577 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_8 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784578 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   grade_9 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784579 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784580 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784581 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   pk_12_total 24.0 114.0 364.0   3.0     2.0         254.0 253.0             390     49   507 24 114 364   3     2         254 253         390   49   507
784582 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784583 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784584 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   ungraded_elementary 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784585 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No 1 01 05 2015   ungraded_secondary 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784624 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_1 2.0 20.0 76.0   0.0     0.0         44.0 54.0             91     *   98 2 20 76   0     0         44 54         91       98
784625 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_10 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784626 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_11 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784627 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_12 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784628 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_2 8.0 9.0 75.0   1.0     1.0         54.0 40.0             87     6   94 8 9 75   1     1         54 40         87   6   94
784629 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_3 2.0 18.0 58.0   0.0     0.0         37.0 41.0             65     15   78 2 18 58   0     0         37 41         65   15   78
784630 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_4 5.0 20.0 85.0   1.0     1.0         65.0 47.0             100     18   112 5 20 85   1     1         65 47         100   18   112
784631 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_5 3.0 12.0 50.0   0.0     0.0         30.0 35.0             53     *   65 3 12 50   0     0         30 35         53       65
784632 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_6 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
784633 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413004591 280201030009 JACKSON ANNEX SCHOOL public Regular School No 1 01 05 2015   grade_7 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);