Data source: Big Local News · About: Big Local

90,193 rows where state = "NY" and year = 2016 sorted by school

View and edit SQL

year

  • 2016 · 90,193
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
1099317 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   grade_1 16.0 3.0 4.0   1.0     27.0     6.0   27.0 30.0             13     7   57 16 3 4   1     27     6   27 30         13   7   57
1099318 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   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
1099319 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   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
1099320 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   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
1099321 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   grade_2 20.0 4.0 4.0   0.0     19.0     6.0   17.0 36.0             13     *   53 20 4 4   0     19     6   17 36         13       53
1099322 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   grade_3 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1099323 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   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         0   0   0
1099324 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   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         0   0   0
1099325 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   grade_6 15.0 3.0 7.0   0.0     24.0     1.0   23.0 27.0             14     7   50 15 3 7   0     24     1   23 27         14   7   50
1099326 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   grade_7 5.0 3.0 1.0   0.0     15.0     2.0   17.0 9.0             10     5   26 5 3 1   0     15     2   17 9         10   5   26
1099327 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   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
1099328 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   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
1099329 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   kindergarten_full_day 15.0 0.0 5.0   3.0     22.0     5.0   30.0 20.0             11     *   50 15 0 5   3     22     5   30 20         11       50
1099330 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   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
1099331 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   pk_12_total 72.0 13.0 21.0   4.0     107.0     20.0   115.0 122.0             61     24   237 72 13 21   4     107     20   115 122         61   24   237
1099332 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   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
1099333 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   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
1099334 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0             0     *   1 1 0 0   0     0     0   1 0         0       1
1099335 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No 1.0 KG 07 2016   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
1079272 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   grade_1 1.0 8.0 9.0         0.0     0.0   8.0 10.0             17     15   18 1 8 9         0     0   8 10         17   15   18
1079273 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   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
1079274 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   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
1079275 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   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
1079276 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   grade_2 5.0 0.0 10.0         0.0     0.0   5.0 10.0             8     11   15 5 0 10         0     0   5 10         8   11   15
1079277 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   grade_3 5.0 8.0 6.0         0.0     0.0   6.0 13.0             15     7   19 5 8 6         0     0   6 13         15   7   19
1079278 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   grade_4 2.0 2.0 9.0         0.0     0.0   7.0 6.0             9     11   13 2 2 9         0     0   7 6         9   11   13
1079279 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   grade_5 1.0 6.0 9.0         2.0     1.0   11.0 8.0             15     9   19 1 6 9         2     1   11 8         15   9   19
1079280 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   grade_6 0.0 2.0 8.0         0.0     0.0   6.0 4.0             10     6   10 0 2 8         0     0   6 4         10   6   10
1079281 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   grade_7 0.0 0.0 7.0         0.0     0.0   4.0 3.0             *     6   7 0 0 7         0     0   4 3             6   7
1079282 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   grade_8 2.0 3.0 7.0         0.0     0.0   5.0 7.0             11     *   12 2 3 7         0     0   5 7         11       12
1079283 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   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
1079284 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   kindergarten_full_day 5.0 2.0 10.0         0.0     1.0   12.0 6.0             12     14   18 5 2 10         0     1   12 6         12   14   18
1079285 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   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
1079286 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   pk_12_total 44.0 41.0 90.0         8.0     8.0   98.0 93.0             129     113   191 44 41 90         8     8   98 93         129   113   191
1079287 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   pre_kindergarten_full_day 23.0 9.0 15.0         6.0     6.0   34.0 25.0             25     28   59 23 9 15         6     6   34 25         25   28   59
1079288 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   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
1079289 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   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
1079290 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No 1.0 PK 08 2016   ungraded_secondary 0.0 1.0 0.0         0.0     0.0   0.0 1.0             *     *   1 0 1 0         0     0   0 1                 1
1093655 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   grade_1 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1093656 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1093657 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1093658 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1093659 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1093660 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   grade_3 0.0 0.0 1.0   0.0     0.0         1.0 0.0             *     *   1 0 0 1   0     0         1 0                 1
1093661 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   grade_4 1.0 0.0 89.0   0.0     144.0         132.0 102.0             *     *   234 1 0 89   0     144         132 102                 234
1093662 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   grade_5 7.0 5.0 93.0   1.0     146.0         138.0 114.0             231     37   252 7 5 93   1     146         138 114         231   37   252
1093663 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1093664 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1093665 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1093666 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1093667 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1093668 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1093669 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   pk_12_total 8.0 5.0 183.0   1.0     292.0         273.0 216.0             444     73   489 8 5 183   1     292         273 216         444   73   489
1093670 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1093671 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1093672 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   ungraded_elementary 0.0 0.0 0.0   0.0     2.0         2.0 0.0             *     *   2 0 0 0   0     2         2 0                 2
1093673 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009805726 342400010877 51ST AVENUE ACADEMY (THE) public Regular School No 1.0 03 05 2016   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
1043533 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_1 68.0 0.0 1.0               2.0   38.0 33.0             43     5   71 68 0 1               2   38 33         43   5   71
1043534 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1043535 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1043536 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1043537 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_2 47.0 1.0 2.0               3.0   25.0 28.0             36     9   53 47 1 2               3   25 28         36   9   53
1043538 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_3 60.0 0.0 2.0               1.0   39.0 24.0             34     7   63 60 0 2               1   39 24         34   7   63
1043539 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_4 66.0 1.0 5.0               1.0   40.0 33.0             40     13   73 66 1 5               1   40 33         40   13   73
1043540 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_5 52.0 2.0 1.0               2.0   26.0 31.0             35     9   57 52 2 1               2   26 31         35   9   57
1043541 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_6 59.0 0.0 1.0               0.0   27.0 33.0             29     11   60 59 0 1               0   27 33         29   11   60
1043542 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1043543 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1043544 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1043545 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   kindergarten_full_day 56.0 0.0 1.0               0.0   25.0 32.0             28     *   57 56 0 1               0   25 32         28       57
1043546 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1043547 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   pk_12_total 447.0 4.0 14.0               9.0   239.0 235.0             261     62   474 447 4 14               9   239 235         261   62   474
1043548 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   pre_kindergarten_full_day 39.0 0.0 1.0               0.0   19.0 21.0             16     *   40 39 0 1               0   19 21         16       40
1043549 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1043550 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1043551 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   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
1103706 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1103707 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1103708 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1103709 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1103710 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1103711 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_3 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1103712 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1103713 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_5 85.0 1.0 3.0         3.0     0.0   55.0 37.0             39     20   92 85 1 3         3     0   55 37         39   20   92
1103714 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_6 97.0 3.0 2.0         5.0     2.0   60.0 49.0             47     14   109 97 3 2         5     2   60 49         47   14   109
1103715 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_7 89.0 2.0 0.0         4.0     1.0   46.0 50.0             31     9   96 89 2 0         4     1   46 50         31   9   96
1103716 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_8 92.0 3.0 1.0         2.0     1.0   60.0 39.0             *     17   99 92 3 1         2     1   60 39             17   99
1103717 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1103718 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1103719 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1103720 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   pk_12_total 368.0 9.0 6.0         14.0     4.0   224.0 177.0             147     65   401 368 9 6         14     4   224 177         147   65   401
1103721 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1103722 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   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
1103723 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   ungraded_elementary 4.0 0.0 0.0         0.0     0.0   2.0 2.0             *     *   4 4 0 0         0     0   2 2                 4
1103724 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   ungraded_secondary 1.0 0.0 0.0         0.0     0.0   1.0 0.0             0     *   1 1 0 0         0     0   1 0         0       1
1070285 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1070286 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   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
1070287 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   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
1070288 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   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
1070289 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_2 0.0 0.0 0.0   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]);