enrollments

Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_9", state = "NY" and year = 2019 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 4,719 ✖

grade ✖

  • grade_9 · 4,719 ✖
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
2153202 2153202 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   grade_9 1.0 0.0 2.0               1.0   2.0 2.0             *     *   4 1 0 2               1   2 2                 4
2155520 2155520 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2019   grade_9 3.0 0.0 0.0               0.0   2.0 1.0             *     *   3 3 0 0               0   2 1                 3
2157078 2157078 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL AT 4 public Alternative School No High 07 12 2019   grade_9 4.0 18.0 2.0   0.0     1.0     0.0   18.0 7.0     *       23     11   25 4 18 2   0     1     0   18 7         23   11   25
2163519 2163519 NY Kings   school 3601065 331300861006   URBAN DOVE TEAM CHARTER SCH 360106506342 331300861006 URBAN DOVE TEAM CHARTER SCHOOL charter Alternative School Yes High 10 12 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
2165552 2165552 NY Kings   school 3601061 331500861016   NEW DAWN CHARTER HIGH SCHOOL 360106106343 331500861016 NEW DAWN CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2019   grade_9 3.0 19.0 16.0   1.0     0.0     0.0   21.0 18.0     *       32     21   39 3 19 16   1     0     0   21 18         32   21   39
2182158 2182158 NY Nassau   school 3612510 280407030000   GREAT NECK 361251002027 280407030016 VILLAGE SCHOOL public Alternative School No High 09 12 2019   grade_9 5.0   0.0         0.0         2.0 3.0             *     5   5 5   0         0         2 3             5   5
2187744 2187744 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 2019   grade_9 3.0 56.0 98.0   0.0     3.0     0.0   87.0 73.0     15       140     58   160 3 56 98   0     3     0   87 73     15   140   58   160
2199467 2199467 NY Putnam   school 3618120 480101060000   MAHOPAC 361812006584 480101060008 MAHOPAC FALLS SCHOOL public Alternative School No Middle 06 08 2019   grade_9 0.0   0.0                   0.0 0.0             *     0   0 0   0                   0 0             0   0
2213299 2213299 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2019   grade_9 0.0 0.0                     0.0 0.0             0     *   0 0 0                     0 0         0       0
2221146 2221146 NY Tompkins   school 3615570 610600010000   ITHACA 361557001328 610600010019 LEHMAN ALTERNATIVE COMM SCHOOL public Alternative School No High 06 12 2019   grade_9 27.0 0.0 2.0   0.0     2.0     6.0   18.0 19.0     *       12     *   37 27 0 2   0     2     6   18 19         12       37
2225858 2225858 NY Westchester   school 3620100 660900010000   MOUNT VERNON 362010000365 660900010025 NELSON R MANDELA/DR HOSEA ZOLLICOFF public Alternative School No High 09 12 2019   grade_9 0.0 1.0 0.0                   0.0 1.0     *       *     0   1 0 1 0                   0 1             0   1
2141270 2141270 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406383 320700011259 HERO HIGH SCHOOL public Career and Technical School No High 09 12 2019   grade_9 1.0 40.0 68.0   2.0     2.0     0.0   40.0 73.0     14       91     30   113 1 40 68   2     2     0   40 73     14   91   30   113
2141422 2141422 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406253 320700011522 BRONX DESIGN-CONSTRUCTION ACADEMY public Career and Technical School No High 09 12 2019   grade_9 2.0 31.0 74.0   4.0     0.0     0.0   95.0 16.0     15       99     38   111 2 31 74   4     0     0   95 16     15   99   38   111
2141517 2141517 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 2019   grade_9 1.0 28.0 102.0   1.0     0.0     0.0   113.0 19.0     33       123     41   132 1 28 102   1     0     0   113 19     33   123   41   132
2142961 2142961 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506348 320800011559 SCHOOL FOR TOURISM AND HOSPITALITY public Career and Technical School No High 09 12 2019   grade_9 1.0 27.0 59.0   0.0     1.0     1.0   30.0 59.0     19       85     24   89 1 27 59   0     1     1   30 59     19   85   24   89
2145868 2145868 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706396 321000011264 BRONX ACAD FOR SOFTWARE ENGINEERING public Career and Technical School No High 09 12 2019   grade_9 1.0 27.0 81.0   0.0     4.0     1.0   85.0 29.0     14       91     34   114 1 27 81   0     4     1   85 29     14   91   34   114
2146229 2146229 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706247 321000011524 CROTONA INTERNATIONAL HIGH SCHOOL public Career and Technical School No High 09 12 2019   grade_9 3.0 5.0 63.0   1.0     0.0         37.0 35.0     65       65     *   72 3 5 63   1     0         37 35     65   65       72
2146286 2146286 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706364 321000011565 HIGH SCHOOL FOR ENERGY AND TECHNOLOG public Career and Technical School No High 09 12 2019   grade_9 2.0 20.0 93.0   1.0     6.0     0.0   94.0 28.0     22       103     35   122 2 20 93   1     6     0   94 28     22   103   35   122
2147407 2147407 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805684 321100011275 HIGH SCHOOL-COMPUTERS & TECHNOLOGY public Career and Technical School No High 09 12 2019   grade_9 3.0 60.0 107.0   3.0     13.0         159.0 27.0     29       149     65   186 3 60 107   3     13         159 27     29   149   65   186
2156793 2156793 NY Erie   school 3605850 140600010000   BUFFALO 360585000315 140600010098 MCKINLEY VOC HIGH SCHOOL public Career and Technical School No High 09 12 2019   grade_9 18.0 158.0 48.0   3.0     19.0     7.0   126.0 127.0     31       223     51   253 18 158 48   3     19     7   126 127     31   223   51   253
2156812 2156812 NY Erie   school 3605850 140600010000   BUFFALO 360585000301 140600010101 BURGARD HIGH SCHOOL public Career and Technical School No High 09 12 2019   grade_9 15.0 77.0 21.0   1.0     13.0     3.0   103.0 27.0     22       115     37   130 15 77 21   1     13     3   103 27     22   115   37   130
2163348 2163348 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 2019   grade_9 2.0 145.0 62.0   1.0     9.0     4.0   155.0 68.0     9       182     51   223 2 145 62   1     9     4   155 68     9   182   51   223
2163405 2163405 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009106164 331300011674 CITY POLYTECHNIC HIGH SCHOOL public Career and Technical School No High 09 12 2019   grade_9 13.0 78.0 40.0   2.0     3.0     0.0   114.0 22.0     *       108     39   136 13 78 40   2     3     0   114 22         108   39   136
2164279 2164279 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011905703 331400011558 WILLAMSBURG HS-ARCH & DESIGN public Career and Technical School No High 09 12 2019   grade_9 9.0 43.0 100.0   3.0     1.0     1.0   104.0 53.0     *       131     35   157 9 43 100   3     1     1   104 53         131   35   157
2164336 2164336 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011901913 331400011610 AUTOMOTIVE HIGH SCHOOL public Career and Technical School No High 09 12 2019   grade_9 0.0 35.0 43.0   1.0     4.0     0.0   75.0 8.0     6       73     24   83 0 35 43   1     4     0   75 8     6   73   24   83
2166825 2166825 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009506273 331700011122 PATHWAYS TECH EARLY COLLEGE HIGH SCH public Career and Technical School No High 09 12 2019   grade_9 2.0 98.0 15.0   3.0     2.0     5.0   75.0 50.0     *       103     35   125 2 98 15   3     2     5   75 50         103   35   125
2167091 2167091 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 2019   grade_9 6.0 354.0 34.0   4.0     4.0     0.0   105.0 297.0     28       307     63   402 6 354 34   4     4     0   105 297     28   307   63   402
2167129 2167129 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009506200 331700011751 ACADEMY FOR HEALTH CAREERS public Career and Technical School No High 09 12 2019   grade_9 1.0 53.0 11.0   1.0     5.0     1.0   19.0 53.0     *       66     14   72 1 53 11   1     5     1   19 53         66   14   72
2167813 2167813 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009606059 331800011617 HS FOR INNOVATION -ADVERTISING/MEDIA public Career and Technical School No High 09 12 2019   grade_9 7.0 52.0 6.0   0.0     3.0     0.0   50.0 18.0     9       51     16   68 7 52 6   0     3     0   50 18     9   51   16   68
2168877 2168877 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 2019   grade_9 8.0 138.0 73.0   5.0     13.0     5.0   222.0 20.0     20       198     86   242 8 138 73   5     13     5   222 20     20   198   86   242
2168896 2168896 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006046 331900011618 ACADEMY OF INNOVATIVE TECHNOLOGY public Career and Technical School No High 09 12 2019   grade_9 3.0 46.0 59.0   3.0     10.0     2.0   99.0 24.0     17       108     25   123 3 46 59   3     10     2   99 24     17   108   25   123
2168953 2168953 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 2019   grade_9 4.0 64.0 37.0   1.0     1.0     0.0   37.0 70.0     9       97     39   107 4 64 37   1     1     0   37 70     9   97   39   107
2168991 2168991 NY Kings   school 3600120 331900010000   NYC GEOG DIST #19 - BROOKLYN 360012006484 331900011764 URBAN ASSEMBLY-COLLABORATIVE HEALTHC public Career and Technical School No High 09 12 2019   grade_9 2.0 26.0 59.0   3.0     4.0     3.0   32.0 65.0     20       73     13   97 2 26 59   3     4     3   32 65     20   73   13   97
2170720 2170720 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 2019   grade_9 19.0 71.0 36.0   1.0     3.0     0.0   95.0 35.0     13       116     51   130 19 71 36   1     3     0   95 35     13   116   51   130
2186509 2186509 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706372 310200011135 URBAN ASSEMBLY-EMERGENCY MANAGEMENT public Career and Technical School No High 09 12 2019   grade_9 2.0 19.0 49.0   1.0     5.0     1.0   25.0 52.0     *       65     19   77 2 19 49   1     5     1   25 52         65   19   77
2186528 2186528 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706373 310200011139 STEPHEN T MATHER BLDG ARTS-CRAFTSMAN public Career and Technical School No High 09 12 2019   grade_9 6.0 27.0 70.0   2.0     12.0     1.0   77.0 41.0     18       99     36   118 6 27 70   2     12     1   77 41     18   99   36   118
2186566 2186566 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706466 310200011280 MANHATTAN EARLY COLLEGE SCH-ADVERTIS public Career and Technical School No High 09 12 2019   grade_9 6.0 39.0 54.0   1.0     19.0     1.0   62.0 58.0     *       96     25   120 6 39 54   1     19     1   62 58         96   25   120
2186585 2186585 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706463 310200011282 URBAN ASSEMBLY MAKER ACADEMY public Career and Technical School No High 09 12 2019   grade_9 17.0 30.0 60.0   0.0     8.0     1.0   83.0 33.0     *       92     28   116 17 30 60   0     8     1   83 33         92   28   116
2186604 2186604 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705622 310200011288 FOOD AND FINANCE HIGH SCHOOL public Career and Technical School No High 09 12 2019   grade_9 4.0 49.0 72.0   1.0     7.0     0.0   58.0 75.0     5       119     34   133 4 49 72   1     7     0   58 75     5   119   34   133
2186851 2186851 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706126 310200011393 BUSINESS OF SPORTS SCHOOL public Career and Technical School No High 09 12 2019   grade_9 4.0 35.0 88.0   4.0     1.0     1.0   110.0 23.0     17       101     35   133 4 35 88   4     1     1   110 23     17   101   35   133
2187269 2187269 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706251 310200011507 URBAN ASSEMBLY GATEWAY SCHOOL-TECH public Career and Technical School No High 09 12 2019   grade_9 11.0 29.0 75.0   1.0     4.0     2.0   102.0 20.0     10       82     30   122 11 29 75   1     4     2   102 20     10   82   30   122
2187364 2187364 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706309 310200011533 UNION SQUARE ACAD FOR HEALTH SCIENCE public Career and Technical School No High 09 12 2019   grade_9 6.0 26.0 91.0   0.0     16.0         47.0 92.0     18       124     31   139 6 26 91   0     16         47 92     18   124   31   139
2187478 2187478 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007706363 310200011546 ACADEMY FOR SOFTWARE ENGINEERING public Career and Technical School No High 09 12 2019   grade_9 12.0 21.0 68.0   1.0     16.0     0.0   95.0 23.0     6       89     34   118 12 21 68   1     16     0   95 23     6   89   34   118
2187516 2187516 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705560 310200011551 URBAN ASSEMBLY NY HARBOR SCHOOL public Career and Technical School No High 09 12 2019   grade_9 36.0 22.0 63.0   3.0     12.0     15.0   100.0 51.0     *       89     37   151 36 22 63   3     12     15   100 51         89   37   151
2187649 2187649 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 2019   grade_9 26.0 149.0 291.0   7.0     23.0     2.0   54.0 444.0     21       416     111   498 26 149 291   7     23     2   54 444     21   416   111   498
2187687 2187687 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 2019   grade_9 5.0 32.0 85.0   1.0     23.0     1.0   121.0 26.0     8       120     43   147 5 32 85   1     23     1   121 26     8   120   43   147
2187706 2187706 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 2019   grade_9 101.0 63.0 221.0   2.0     45.0     26.0   144.0 314.0     *       272     114   458 101 63 221   2     45     26   144 314         272   114   458
2188447 2188447 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007806148 310300011402 URBAN ASSEMBLY FOR GREEN CAREERS public Career and Technical School No High 09 12 2019   grade_9 7.0 22.0 47.0   0.0     2.0     0.0   41.0 37.0     13       71     19   78 7 22 47   0     2     0   41 37     13   71   19   78
2189967 2189967 NY New York   school 3600081 310500010000   NYC GEOG DIST # 5 - MANHATTAN 360008106380 310500011157 URBAN ASSEMBLY-GLOBAL COMMERCE public Career and Technical School No High 09 12 2019   grade_9 1.0 33.0 35.0   1.0     0.0     1.0   36.0 35.0     9       64     30   71 1 33 35   1     0     1   36 35     9   64   30   71
2191050 2191050 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008306490 310600011211 INWOOD EARLY COLLEGE FOR HEALTH-INFO public Career and Technical School No High 09 12 2019   grade_9 1.0 7.0 99.0   2.0     0.0     0.0   56.0 53.0     14       101     25   109 1 7 99   2     0     0   56 53     14   101   25   109
2200759 2200759 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009802860 342400011600 QUEENS TECHNICAL HIGH SCHOOL public Career and Technical School No High 09 12 2019   grade_9 30.0 25.0 351.0   3.0     30.0     1.0   282.0 158.0     48       372     101   440 30 25 351   3     30     1   282 158     48   372   101   440
2200778 2200778 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801915 342400011610 AVIATION CAREER AND TECH ED HS public Career and Technical School No High 09 12 2019   grade_9 49.0 24.0 236.0   6.0     194.0     10.0   412.0 107.0     16       351     89   519 49 24 236   6     194     10   412 107     16   351   89   519
2202279 2202279 NY Queens   school 3600099 342600010000   NYC GEOG DIST #26 - QUEENS 360009906468 342600011315 BUSINESS TECHNOLOGY EARLY COLLEGE HS public Career and Technical School No High 09 12 2019   grade_9 5.0 67.0 24.0   3.0     25.0     6.0   85.0 45.0     *       83     22   130 5 67 24   3     25     6   85 45         83   22   130
2203571 2203571 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012305899 342700011650 HS FOR CON, TRADES, ENGINEER AND ARC public Career and Technical School No High 09 12 2019   grade_9 35.0 17.0 112.0   16.0     95.0     17.0   181.0 111.0     *       167     50   292 35 17 112   16     95     17   181 111         167   50   292
2204559 2204559 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 2019   grade_9 17.0 89.0 134.0   31.0     283.0     10.0   370.0 194.0     19       445     94   564 17 89 134   31     283     10   370 194     19   445   94   564
2205376 2205376 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010106440 342900011243 INSTITUTE FOR HEALTH PROFESIONS public Career and Technical School No High 09 12 2019   grade_9 0.0 68.0 8.0   0.0     14.0     1.0   40.0 51.0     14       65     13   91 0 68 8   0     14     1   40 51     14   65   13   91
2205490 2205490 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010106508 342900011313 BENJAMIN FRANKLIN HS-FINANCE-INFO public Career and Technical School No High 09 12 2019   grade_9 3.0 75.0 17.0   7.0     18.0     1.0   83.0 38.0     13       108     23   121 3 75 17   7     18     1   83 38     13   108   23   121
2206402 2206402 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206443 343000011258 ENERGY TECH HIGH SCHOOL public Career and Technical School No High 09 12 2019   grade_9 12.0 6.0 70.0   1.0     24.0     3.0   90.0 26.0     *       95     26   116 12 6 70   1     24     3   90 26         95   26   116
2206440 2206440 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010206070 343000011301 ACAD FOR CAREERS IN TELEVISION-FILM public Career and Technical School No High 09 12 2019   grade_9 22.0 19.0 82.0   1.0     14.0     9.0   73.0 74.0     *       95     38   147 22 19 82   1     14     9   73 74         95   38   147
2208739 2208739 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 2019   grade_9 44.0 71.0 116.0   1.0     13.0     3.0   195.0 53.0     13       192     99   248 44 71 116   1     13     3   195 53     13   192   99   248
2139104 2139104 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 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
2139123 2139123 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 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
2139142 2139142 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 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
2139161 2139161 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 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
2139180 2139180 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 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
2139199 2139199 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES 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     0     0   0 0     0   0   0   0
2139218 2139218 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT 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 0     0   0   0   0
2139237 2139237 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH 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     0     0   0 0     0   0   0   0
2139256 2139256 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary KG 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     0     0   0 0     0   0   0   0
2139275 2139275 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT 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   0   0   0
2139294 2139294 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 132.0 341.0 116.0   1.0     63.0     21.0   347.0 327.0     78       449     94   674 132 341 116   1     63     21   347 327     78   449   94   674
2139313 2139313 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL 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 0     0   0   0   0
2139332 2139332 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 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
2139351 2139351 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 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
2139370 2139370 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS 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   0   0   0
2139389 2139389 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE 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
2139408 2139408 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 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
2139427 2139427 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 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
2139446 2139446 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle 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
2139465 2139465 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 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
2139484 2139484 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 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
2139503 2139503 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 09 12 2019   grade_9 0.0 76.0 15.0   1.0     1.0     13.0   106.0               77     *   106 0 76 15   1     1     13   106           77       106
2139522 2139522 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2019   grade_9 7.0 55.0 23.0   0.0     2.0     3.0     90.0     8       80     9   90 7 55 23   0     2     3     90     8   80   9   90
2139541 2139541 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2019   grade_9 53.0 0.0 1.0   0.0     0.0     1.0   31.0 24.0             24     11   55 53 0 1   0     0     1   31 24         24   11   55
2139560 2139560 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH 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         0   0   0
2139579 2139579 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 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
2139598 2139598 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 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
2139617 2139617 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 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
2139636 2139636 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 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
2139655 2139655 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL 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
2139674 2139674 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 330.0 7.0 13.0         28.0     8.0   172.0 214.0     *       56     33   386 330 7 13         28     8   172 214         56   33   386
2139693 2139693 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 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
2139712 2139712 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2019   grade_9 127.0 10.0 14.0         1.0     7.0   97.0 62.0     *       88     34   159 127 10 14         1     7   97 62         88   34   159
2139731 2139731 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 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
2139750 2139750 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 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
2139769 2139769 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH 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
2139788 2139788 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 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
2139807 2139807 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 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
2139826 2139826 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   grade_9 104.0 18.0 10.0   0.0     3.0     9.0   78.0 66.0     *       104     32   144 104 18 10   0     3     9   78 66         104   32   144
2139845 2139845 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES 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   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]);