enrollments

Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_9", state = "NY" and year = 2017 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 4,722 ✖

grade ✖

  • grade_9 · 4,722 ✖
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
987038 987038 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   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
944212 944212 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405761 320700011321 CROTONA ACADEMY HIGH SCHOOL public Alternative School No High 09 12 2017   grade_9 0.0 2.0 4.0                   3.0 3.0     *       *     *   6 0 2 4                   3 3                 6
948886 948886 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705760 321000011319 PULSE HIGH SCHOOL public Alternative School No High 09 12 2017   grade_9 0.0 3.0 16.0   7.0     0.0         10.0 16.0     0       22     6   26 0 3 16   7     0         10 16     0   22   6   26
951584 951584 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009000744 321200011480 BRONX REGIONAL HIGH SCHOOL public Alternative School No High 09 12 2017   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
952439 952439 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Alternative School No Other 02 09 2017   grade_9 9.0 2.0 0.0               1.0   11.0 1.0             11     8   12 9 2 0               1   11 1         11   8   12
958500 958500 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2017   grade_9 5.0 0.0 2.0               0.0   4.0 3.0             *     *   7 5 0 2               0   4 3                 7
960115 960115 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ALTERNATIVE HIGH SCHOOL AT 44 public Alternative School No High 07 12 2017   grade_9 9.0 29.0 10.0   2.0     0.0     1.0   28.0 23.0     5       42     19   51 9 29 10   2     0     1   28 23     5   42   19   51
960590 960590 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723006246 140701060008 PINE HILL EDUCATION CENTER public Alternative School No Other KG 12 2017   grade_9 1.0 3.0 0.0         0.0     0.0   2.0 2.0             *     *   4 1 3 0         0     0   2 2                 4
966233 966233 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009105563 331300011553 BROOKLYN ACADEMY HIGH SCHOOL public Alternative School No High 09 12 2017   grade_9   0.0 0.0   0.0               0.0 0.0             0     0   0   0 0   0               0 0         0   0   0
966252 966252 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009100847 331300011575 BEDFORD STUYVESANT PREP HIGH SCHOOL public Alternative School No High 09 12 2017   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
966461 966461 NY Kings   school 3601065 331300861006   URBAN DOVE TEAM CHARTER SCH 360106506342 331300861006 URBAN DOVE TEAM CHARTER SCHOOL charter Alternative School Yes High 09 12 2017   grade_9 1.0 8.0 2.0   0.0     0.0     0.0   6.0 5.0     *       8     *   11 1 8 2   0     0     0   6 5         8       11
968285 968285 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009205864 331500011529 WEST BROOKLYN COMMUNITY HIGH SCHOOL public Alternative School No High 09 12 2017   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
970052 970052 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009505762 331700011568 BROWNSVILLE ACADEMY HIGH SCHOOL public Alternative School No High 09 12 2017   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
985157 985157 NY Nassau   school 3612510 280407030000   GREAT NECK 361251002027 280407030016 VILLAGE SCHOOL public Alternative School No High 08 12 2017   grade_9 3.0   0.0         0.0         3.0 0.0             *     *   3 3   0         0         3 0                 3
988292 988292 NY New York   school 3600076 310100010000   NYC GEOG DIST # 1 - MANHATTAN 360007600624 310100011515 LOWER EAST SIDE PREP HIGH SCHOOL public Alternative School No High 09 12 2017   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
988330 988330 NY New York   school 3600076 310100010000   NYC GEOG DIST # 1 - MANHATTAN 360007603352 310100011650 CASCADES HIGH SCHOOL public Alternative School No High 09 12 2017   grade_9 0.0 13.0 7.0   0.0     0.0     0.0   14.0 6.0     *       14     5   20 0 13 7   0     0     0   14 6         14   5   20
990382 990382 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705566 310200011544 INDEPENDENCE HIGH SCHOOL public Alternative School No High 09 12 2017   grade_9 3.0 2.0 8.0   0.0     1.0     0.0   5.0 9.0     *       14     *   14 3 2 8   0     1     0   5 9         14       14
990439 990439 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007700637 310200011550 LIBERTY HIGH SCH ACAD-NEWCOMERS public Alternative School No High 09 12 2017   grade_9 22.0 21.0 59.0   0.0     15.0         78.0 39.0     115       49     5   117 22 21 59   0     15         78 39     115   49   5   117
990477 990477 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007700649 310200011560 HS 560 CITY-AS-SCHOOL public Alternative School No High 09 12 2017   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
990515 990515 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007700668 310200011570 SATELLITE ACADEMY HIGH SCHOOL public Alternative School No High 09 12 2017   grade_9 6.0 74.0 126.0   1.0     2.0         89.0 120.0     *       161     44   209 6 74 126   1     2         89 120         161   44   209
990686 990686 NY New York   school 3600053 310200860819   JOHN V LINDSAY WILDCAT ACAD 360005304411 310200860819 JOHN V LINDSAY WILDCAT ACAD CHARTER charter Alternative School Yes High 09 12 2017   grade_9 1.0 66.0 92.0   3.0     3.0         87.0 78.0     14       126     58   165 1 66 92   3     3         87 78     14   126   58   165
991541 991541 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007800619 310300011505 EDWARD A REYNOLDS WEST SIDE HS public Alternative School No High 09 12 2017   grade_9 0.0 5.0 4.0   0.0     0.0         6.0 3.0     0       7     0   9 0 5 4   0     0         6 3     0   7   0   9
992985 992985 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008105758 310500011285 HARLEM RENAISSANCE HIGH SCHOOL public Alternative School No High 09 12 2017   grade_9 0.0 9.0 5.0   0.0     0.0         11.0 3.0     *       13     5   14 0 9 5   0     0         11 3         13   5   14
1000794 1000794 NY Orange   school 3601104 441600861060   NEWBURGH PREP CHARTER HIGH S 360110406449 441600861060 NEWBURGH PREP CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2017   grade_9 0.0 4.0 5.0                   5.0 4.0     *                 9 0 4 5                   5 4                 9
1002561 1002561 NY Putnam   school 3618120 480101060000   MAHOPAC 361812006584 480101060008 MAHOPAC FALLS SCHOOL public Alternative School No Middle 06 08 2017   grade_9 0.0                       0.0 0.0             *     *   0 0                       0 0                 0
1004765 1004765 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012205503 342500011540 QUEENS ACADEMY HIGH SCHOOL public Alternative School No High 09 12 2017   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
1011700 1011700 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010300962 353100011470 CONCORD HIGH SCHOOL public Alternative School No High 09 12 2017   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
1016260 1016260 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2017   grade_9 0.0 0.0                     0.0 0.0             0         0 0 0                     0 0         0       0
1024107 1024107 NY Tompkins   school 3615570 610600010000   ITHACA 361557001328 610600010019 LEHMAN ALTERNATIVE COMM SCHOOL public Alternative School No Other 06 12 2017   grade_9 35.0 3.0 3.0   1.0     2.0     0.0   22.0 22.0     *       15     8   44 35 3 3   1     2     0   22 22         15   8   44
1028876 1028876 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010000365 660900010025 NELSON R MANDELA/DR HOSEA ZOLLICOFF public Alternative School No High 09 12 2017   grade_9 0.0 12.0 1.0         0.0     0.0   10.0 3.0             11     *   13 0 12 1         0     0   10 3         11       13
944478 944478 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008401909 320700011600 ALFRED E SMITH CAREER-TECH HIGH SCH public Career and Technical School No High 09 12 2017   grade_9 2.0 39.0 114.0   0.0     0.0     0.0   135.0 20.0     41       147     47   155 2 39 114   0     0     0   135 20     41   147   47   155
959792 959792 NY Erie   school 3605850 140600010000   BUFFALO 360585000315 140600010098 MCKINLEY VOC HIGH SCHOOL public Career and Technical School No High 09 12 2017   grade_9 40.0 147.0 54.0   3.0     34.0     3.0   156.0 125.0     46       234     48   281 40 147 54   3     34     3   156 125     46   234   48   281
959830 959830 NY Erie   school 3605850 140600010000   BUFFALO 360585000301 140600010101 BURGARD VOC HIGH SCHOOL public Career and Technical School No High 09 12 2017   grade_9 8.0 118.0 16.0   1.0     7.0     4.0   95.0 59.0     12       136     42   154 8 118 16   1     7     4   95 59     12   136   42   154
959868 959868 NY Erie   school 3605850 140600010000   BUFFALO 360585000307 140600010104 EMERSON SCHOOL OF HOSPITALITY public Career and Technical School No High 09 12 2017   grade_9 54.0 132.0 47.0   1.0     4.0     4.0   91.0 151.0     *       201     69   242 54 132 47   1     4     4   91 151         201   69   242
966119 966119 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009101928 331300011430 BROOKLYN TECH HIGH SCHOOL public Career and Technical School No High 09 12 2017   grade_9 371.0 100.0 122.0   11.0     937.0     9.0   920.0 630.0             926     30   1550 371 100 122   11     937     9   920 630         926   30   1550
966290 966290 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009101955 331300011605 GEORGE WESTINGHOUSE CAREER/TECH HS public Career and Technical School No High 09 12 2017   grade_9 3.0 169.0 57.0   1.0     16.0     5.0   188.0 63.0     9       207     59   251 3 169 57   1     16     5   188 63     9   207   59   251
967259 967259 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011901913 331400011610 AUTOMOTIVE HIGH SCHOOL public Career and Technical School No High 09 12 2017   grade_9 4.0 45.0 45.0   1.0     6.0     2.0   97.0 6.0     9       90     27   103 4 45 45   1     6     2   97 6     9   90   27   103
970090 970090 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009501937 331700011600 CLARA BARTON HIGH SCHOOL public Career and Technical School No High 09 12 2017   grade_9 4.0 325.0 29.0   1.0     5.0     12.0   106.0 270.0     34       295     67   376 4 325 29   1     5     12   106 270     34   295   67   376
971952 971952 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012001941 331900011615 TRANSIT TECH CAREER AND TECH EDU public Career and Technical School No High 09 12 2017   grade_9 3.0 114.0 80.0   3.0     9.0     3.0   183.0 29.0     20       164     68   212 3 114 80   3     9     3   183 29     20   164   68   212
972028 972028 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012002889 331900011660 W H MAXWELL CAREER AND TECH HS public Career and Technical School No High 09 12 2017   grade_9 0.0 62.0 36.0         3.0     0.0   30.0 71.0     10       94     25   101 0 62 36         3     0   30 71     10   94   25   101
973795 973795 NY Kings   school 3600152 332100010000   NYC GEOG DIST #21 - BROOKLYN 360015202888 332100011620 WILLIAM E GRADY CAREER AND TECH public Career and Technical School No High 09 12 2017   grade_9 4.0 75.0 19.0   0.0     3.0     2.0   90.0 13.0     11       83     45   103 4 75 19   0     3     2   90 13     11   83   45   103
990097 990097 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705112 310200011442 BALLET TECH/NYC PS FOR DANCE public Career and Technical School No Elementary 04 08 2017   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
990591 990591 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701949 310200011600 HIGH SCH OF FASHION INDUSTRIES (THE) public Career and Technical School No High 09 12 2017   grade_9 26.0 162.0 271.0   2.0     31.0     0.0   28.0 464.0     26       425     89   492 26 162 271   2     31     0   28 464     26   425   89   492
990629 990629 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701934 310200011615 CHELSEA CAREER AND TECH ED HS public Career and Technical School No High 09 12 2017   grade_9 5.0 35.0 91.0   0.0     14.0     3.0   105.0 43.0     *       140     38   148 5 35 91   0     14     3   105 43         140   38   148
990648 990648 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701911 310200011630 ART AND DESIGN HIGH SCHOOL public Career and Technical School No High 09 12 2017   grade_9 66.0 76.0 279.0   4.0     39.0     18.0   176.0 306.0     7       309     128   482 66 76 279   4     39     18   176 306     7   309   128   482
1003872 1003872 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802860 342400011600 QUEENS VOCATIONAL-TECHNICAL HS public Career and Technical School No High 09 12 2017   grade_9 28.0 19.0 340.0   0.0     42.0     0.0   253.0 176.0     55       359     85   429 28 19 340   0     42     0   253 176     55   359   85   429
1003891 1003891 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801915 342400011610 AVIATION CAREER AND TECH HIGH SCHOOL public Career and Technical School No High 09 12 2017   grade_9 38.0 22.0 211.0   4.0     186.0     27.0   397.0 91.0     28       255     78   488 38 22 211   4     186     27   397 91     28   255   78   488
1007539 1007539 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002881 342800011620 THOMAS A EDISON CAREER-TECH HS public Career and Technical School No High 09 12 2017   grade_9 27.0 109.0 136.0   33.0     214.0     7.0   333.0 193.0     *       437     90   526 27 109 136   33     214     7   333 193         437   90   526
1011529 1011529 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010306149 353100010861 STATEN ISLAND SCH-CIVIC LEADERSHIP public Career and Technical School No Elementary PK 08 2017   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
1011719 1011719 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010302861 353100011600 RALPH R MCKEE CAREER-TECH HIGH SCH public Career and Technical School No High 09 12 2017   grade_9 60.0 84.0 135.0   3.0     15.0     11.0   247.0 61.0     24       227     104   308 60 84 135   3     15     11   247 61     24   227   104   308
1011738 1011738 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010304186 353100011605 STATEN ISLAND TECH HIGH SCHOOL public Career and Technical School No High 09 12 2017   grade_9 148.0 1.0 10.0   2.0     185.0     0.0   191.0 155.0     *       165     5   346 148 1 10   2     185     0   191 155         165   5   346
942046 942046 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2017   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
942065 942065 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   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
942084 942084 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2017   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
942103 942103 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   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
942122 942122 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 08 2017   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
942141 942141 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary KG 06 2017   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
942160 942160 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   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
942179 942179 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2017   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
942198 942198 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   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
942217 942217 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
942236 942236 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 142.0 397.0 108.0   3.0     55.0     23.0   346.0 382.0     89       418     96   728 142 397 108   3     55     23   346 382     89   418   96   728
942255 942255 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   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
942274 942274 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2017   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
942293 942293 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2017   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
942312 942312 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
942331 942331 NY Albany   school 3602460 10100010000   ALBANY 360246006538 10100010046 WEST HILL MIDDLE SCHOOL public Regular School No Middle 07 08 2017   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
942350 942350 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2017   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
942369 942369 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2017   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
942388 942388 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 05 08 2017   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
942407 942407 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2017   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
942426 942426 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   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
942445 942445 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 09 12 2017   grade_9 3.0 94.0 21.0   1.0     0.0     12.0   131.0               79     *   131 3 94 21   1     0     12   131           79       131
942464 942464 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2017   grade_9 11.0 75.0 13.0   2.0     4.0     6.0     111.0     8       87     6   111 11 75 13   2     4     6     111     8   87   6   111
942483 942483 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   grade_9 61.0 2.0 1.0   1.0     1.0         32.0 34.0             25     10   66 61 2 1   1     1         32 34         25   10   66
942502 942502 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary KG 06 2017   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
942521 942521 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
942540 942540 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
942559 942559 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
942578 942578 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
942597 942597 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
942616 942616 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 355.0 9.0 18.0         26.0     2.0   207.0 203.0     *       54     44   410 355 9 18         26     2   207 203         54   44   410
942635 942635 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   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
942654 942654 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2017   grade_9 111.0 8.0 6.0         1.0     2.0   73.0 55.0     *       52     29   128 111 8 6         1     2   73 55         52   29   128
942673 942673 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2017   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
942692 942692 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2017   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
942711 942711 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2017   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
942730 942730 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 2017   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
942749 942749 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2017   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
942768 942768 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 121.0 14.0 8.0   1.0     3.0     5.0   68.0 84.0     *       94     23   152 121 14 8   1     3     5   68 84         94   23   152
942787 942787 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2017   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
942806 942806 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2017   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
942825 942825 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2017   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
942844 942844 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   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
942863 942863 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   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
942882 942882 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 253.0 36.0 27.0   1.0     36.0     21.0   179.0 195.0     11       113     55   374 253 36 27   1     36     21   179 195     11   113   55   374
942901 942901 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   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
942920 942920 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   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
942939 942939 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 08 2017   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
942958 942958 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2017   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

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