enrollments

Data source: Big Local News · About: Big Local

89,661 rows where state = "NY" and year = 2019 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 89,661 ✖
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
2206296 2206296 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   grade_1 18.0 2.0 8.0   1.0     24.0     7.0   30.0 30.0     *       7     *   60 18 2 8   1     24     7   30 30         7       60
2206297 2206297 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   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   0   0
2206298 2206298 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   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   0   0
2206299 2206299 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   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   0   0
2206300 2206300 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   grade_2 23.0 4.0 4.0   0.0     26.0     5.0   34.0 28.0     *       10     *   62 23 4 4   0     26     5   34 28         10       62
2206301 2206301 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   grade_3 20.0 1.0 5.0   2.0     26.0     6.0   33.0 27.0     0       14     *   60 20 1 5   2     26     6   33 27     0   14       60
2206302 2206302 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   grade_4 18.0 3.0 3.0   1.0     31.0     4.0   31.0 29.0     0       18     *   60 18 3 3   1     31     4   31 29     0   18       60
2206303 2206303 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   grade_5 21.0 4.0 5.0   0.0     22.0     5.0   20.0 37.0     0       15     *   57 21 4 5   0     22     5   20 37     0   15       57
2206304 2206304 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   grade_6 13.0 2.0 12.0   1.0     28.0     4.0   28.0 32.0     0       22     5   60 13 2 12   1     28     4   28 32     0   22   5   60
2206305 2206305 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   grade_7 13.0 2.0 2.0   1.0     21.0     2.0   19.0 22.0     0       13     7   41 13 2 2   1     21     2   19 22     0   13   7   41
2206306 2206306 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   grade_8 16.0 6.0 10.0   0.0     31.0     1.0   37.0 27.0     0       20     *   64 16 6 10   0     31     1   37 27     0   20       64
2206307 2206307 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   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   0   0
2206308 2206308 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   kindergarten_full_day 12.0 0.0 3.0   0.0     30.0     3.0   22.0 26.0     *       12     *   48 12 0 3   0     30     3   22 26         12       48
2206309 2206309 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   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   0   0
2206310 2206310 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   pk_12_total 154.0 24.0 52.0   6.0     239.0     37.0   254.0 258.0     9       131     31   512 154 24 52   6     239     37   254 258     9   131   31   512
2206311 2206311 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   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   0   0
2206312 2206312 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   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   0   0
2206313 2206313 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   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 0     0   0   0   0
2206314 2206314 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206477 343000010300 30TH AVENUE SCHOOL (THE) public Regular School No Elementary KG 08 2019   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   0   0
2186308 2186308 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   grade_1 4.0 9.0 7.0         1.0     0.0   8.0 13.0     10       18     18   21 4 9 7         1     0   8 13     10   18   18   21
2186309 2186309 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   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
2186310 2186310 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   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
2186311 2186311 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   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
2186312 2186312 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   grade_2 1.0 1.0 7.0         2.0     1.0   8.0 4.0     6       8     7   12 1 1 7         2     1   8 4     6   8   7   12
2186313 2186313 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   grade_3 6.0 5.0 7.0         0.0     2.0   11.0 9.0     11       15     12   20 6 5 7         0     2   11 9     11   15   12   20
2186314 2186314 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   grade_4 1.0 2.0 8.0         0.0     0.0   7.0 4.0     *       11     7   11 1 2 8         0     0   7 4         11   7   11
2186315 2186315 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   grade_5 1.0 2.0 7.0         0.0     0.0   3.0 7.0     0       9     5   10 1 2 7         0     0   3 7     0   9   5   10
2186316 2186316 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   grade_6 3.0 6.0 8.0         0.0     0.0   4.0 13.0     *       14     5   17 3 6 8         0     0   4 13         14   5   17
2186317 2186317 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   grade_7 0.0 2.0 7.0         1.0     0.0   4.0 6.0     *       9     6   10 0 2 7         1     0   4 6         9   6   10
2186318 2186318 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   grade_8 2.0 6.0 13.0         0.0     0.0   9.0 12.0     *       20     8   21 2 6 13         0     0   9 12         20   8   21
2186319 2186319 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   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
2186320 2186320 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   kindergarten_full_day 3.0 5.0 10.0         0.0     1.0   10.0 9.0     *       14     12   19 3 5 10         0     1   10 9         14   12   19
2186321 2186321 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   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
2186322 2186322 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   pk_12_total 49.0 42.0 88.0         7.0     10.0   96.0 100.0     39       135     99   196 49 42 88         7     10   96 100     39   135   99   196
2186323 2186323 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   pre_kindergarten_full_day 28.0 4.0 14.0         3.0     6.0   32.0 23.0     0       17     19   55 28 4 14         3     6   32 23     0   17   19   55
2186324 2186324 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   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
2186325 2186325 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   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   0   0
2186326 2186326 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705767 310200010347 47 AMER SIGN LANG & ENG LOWER public Regular School No Elementary PK 08 2019   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
2150740 2150740 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 49.0 0.0 1.0               0.0   25.0 25.0             26     5   50 49 0 1               0   25 25         26   5   50
2150741 2150741 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2150742 2150742 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2150743 2150743 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2150744 2150744 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 52.0 1.0 1.0               1.0   27.0 28.0             23     6   55 52 1 1               1   27 28         23   6   55
2150745 2150745 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_3 46.0 1.0 2.0               0.0   23.0 26.0             22     8   49 46 1 2               0   23 26         22   8   49
2150746 2150746 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_4 62.0 0.0 2.0               3.0   35.0 32.0             38     8   67 62 0 2               3   35 32         38   8   67
2150747 2150747 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_5 43.0 1.0 2.0               2.0   21.0 27.0             27     9   48 43 1 2               2   21 27         27   9   48
2150748 2150748 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_6 56.0 0.0 1.0               1.0   33.0 25.0             25     9   58 56 0 1               1   33 25         25   9   58
2150749 2150749 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2150750 2150750 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2150751 2150751 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2150752 2150752 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   kindergarten_full_day 45.0 0.0 1.0               5.0   25.0 26.0             28     5   51 45 0 1               5   25 26         28   5   51
2150753 2150753 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2150754 2150754 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pk_12_total 390.0 3.0 10.0               14.0   202.0 215.0             205     60   417 390 3 10               14   202 215         205   60   417
2150755 2150755 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   pre_kindergarten_full_day 37.0 0.0 0.0               2.0   13.0 26.0             16     10   39 37 0 0               2   13 26         16   10   39
2150756 2150756 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2150757 2150757 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2150758 2150758 NY Cayuga   school 3623430 51101040000   PORT BYRON 362343003270 51101040001 A A GATES ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   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
2210685 2210685 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210686 2210686 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210687 2210687 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210688 2210688 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210689 2210689 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210690 2210690 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210691 2210691 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210692 2210692 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_5 83.0 1.0 1.0   0.0     4.0     3.0   43.0 49.0     *       *     13   92 83 1 1   0     4     3   43 49             13   92
2210693 2210693 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_6 94.0 2.0 3.0   1.0     2.0     1.0   64.0 39.0     *       48     22   103 94 2 3   1     2     1   64 39         48   22   103
2210694 2210694 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 95.0 0.0 1.0   1.0     2.0     0.0   51.0 48.0     *       35     14   99 95 0 1   1     2     0   51 48         35   14   99
2210695 2210695 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_8 85.0 2.0 4.0   0.0     2.0     0.0   58.0 35.0     0       38     *   93 85 2 4   0     2     0   58 35     0   38       93
2210696 2210696 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210697 2210697 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210698 2210698 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210699 2210699 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   pk_12_total 361.0 5.0 9.0   2.0     10.0     4.0   217.0 174.0     6       159     64   391 361 5 9   2     10     4   217 174     6   159   64   391
2210700 2210700 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210701 2210701 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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   0   0
2210702 2210702 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     0       *     *   1 1 0 0   0     0     0   0 1     0           1
2210703 2210703 NY Saint Lawrence   school 3623670 512902060000   POTSDAM 362367003299 512902060004 A A KINGSTON MIDDLE SCHOOL public Regular School No Middle 05 08 2019   ungraded_secondary 3.0 0.0 0.0   0.0     0.0     0.0   1.0 2.0     0       *     *   3 3 0 0   0     0     0   1 2     0           3
2177245 2177245 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177246 2177246 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177247 2177247 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177248 2177248 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177249 2177249 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177250 2177250 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177251 2177251 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177252 2177252 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177253 2177253 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_6 214.0 11.0 26.0         3.0     15.0   131.0 138.0     *       129     45   269 214 11 26         3     15   131 138         129   45   269
2177254 2177254 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 196.0 11.0 33.0         5.0     14.0   125.0 134.0     *       135     41   259 196 11 33         5     14   125 134         135   41   259
2177255 2177255 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_8 190.0 10.0 18.0         5.0     16.0   127.0 112.0     *       107     45   239 190 10 18         5     16   127 112         107   45   239
2177256 2177256 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177257 2177257 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177258 2177258 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177259 2177259 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   pk_12_total 603.0 32.0 78.0         13.0     47.0   385.0 388.0     10       377     137   773 603 32 78         13     47   385 388     10   377   137   773
2177260 2177260 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177261 2177261 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2177262 2177262 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   ungraded_elementary 3.0 0.0 1.0         0.0     2.0   2.0 4.0     0       6     6   6 3 0 1         0     2   2 4     0   6   6   6
2177263 2177263 NY Monroe   school 3605580 261801060000   BROCKPORT 360558000286 261801060005 A D OLIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2149847 2149847 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2019   grade_1 20.0 0.0 2.0         0.0     0.0   11.0 11.0     *       18     *   22 20 0 2         0     0   11 11         18       22
2149848 2149848 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2019   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
2149849 2149849 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2019   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
2149850 2149850 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2019   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
2149851 2149851 NY Broome   school 3602730 31701060000   WINDSOR 360273000048 31701060004 A F PALMER ES / WINDSOR CENTRAL MS public Regular School No Elementary PK 08 2019   grade_2 29.0 0.0 2.0         1.0     0.0   20.0 12.0     *       19     *   32 29 0 2         1     0   20 12         19       32

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]);