Data source: Big Local News · About: Big Local

4,742 rows where grade = "grade_9", state = "NY" and year = 2020 sorted by ccd_school_type

View and edit SQL

year

  • 2020 · 4,742

grade

  • grade_9 · 4,742
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
1555993 NY Kings   school   332300010000   NYC GEOG DIST #23 - BROOKLYN   331700011646 ASPIRATIONS DIPLOMA PLUS HIGH SCHOOL public           2020   grade_9 0.0 18.0 1.0   0.0     1.0     0.0   14.0 6.0     *       16     9   20 0 18 1   0     1     0   14 6         16   9   20
1534523 NY Cattaraugus   school 3625440 43200050000   SALAMANCA 362544006681 43200050008 WARRIOR ACADEMY public Alternative School No High 10 12 2020   grade_9         0.0           0.0   0.0               *         0         0           0   0                   0
1537373 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2020   grade_9 3.0 1.0 0.0               2.0   5.0 1.0             *     *   6 3 1 0               2   5 1                 6
1539672 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988005598 132101060016 ORCHARD VIEW ALT HIGH SCHOOL public Alternative School No High 09 12 2020   grade_9 4.0 0.0 1.0         1.0     0.0   4.0 2.0             *     *   6 4 0 1         1     0   4 2                 6
1541211 NY Erie   school 3605850 140600010000   BUFFALO 360585006262 140600010133 ACADEMY SCHOOL public Alternative School No High 07 12 2020   grade_9 1.0 11.0 1.0   0.0           2.0   10.0 5.0     *       14     7   15 1 11 1   0           2   10 5         14   7   15
1541458 NY Erie   school 3605850 140600010000   BUFFALO 360585006632 140600010316 PATHWAYS ACADEMY public Alternative School No High 09 12 2020   grade_9 8.0 25.0 12.0   1.0     1.0     1.0   30.0 18.0     *       43     25   48 8 25 12   1     1     1   30 18         43   25   48
1547671 NY Kings   school 3601065 331300861006   URBAN DOVE TEAM CHARTER SCH 360106506342 331300861006 URBAN DOVE TEAM CHARTER SCHOOL charter Alternative School Yes High 10 12 2020   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
1549704 NY Kings   school 3601061 331500861016   NEW DAWN CHARTER HIGH SCHOOL 360106106343 331500861016 NEW DAWN CHARTER HIGH SCHOOL charter Alternative School Yes High 09 12 2020   grade_9 2.0 37.0 27.0   2.0     1.0         35.0 34.0     5       54     29   69 2 37 27   2     1         35 34     5   54   29   69
1566424 NY Nassau   school 3612510 280407030000   GREAT NECK 361251002027 280407030016 VILLAGE SCHOOL public Alternative School No High 08 12 2020   grade_9 2.0 0.0 0.0         0.0         1.0 1.0             *     *   2 2 0 0         0         1 1                 2
1571991 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 2020   grade_9 1.0 51.0 85.0   1.0     3.0         81.0 60.0     12       130     61   141 1 51 85   1     3         81 60     12   130   61   141
1583733 NY Putnam   school 3618120 480101060000   MAHOPAC 361812006584 480101060008 MAHOPAC FALLS SCHOOL public Alternative School No Middle 06 08 2020   grade_9 0.0   0.0         0.0         0.0 0.0             *     0   0 0   0         0         0 0             0   0
1597679 NY Steuben   school 3608400 571000010000   CORNING 360840005574 571000010019 CORNING-PAINTED POST HS LRN CTR public Alternative School No High 09 12 2020   grade_9 1.0 0.0                     1.0 0.0             0     *   1 1 0                     1 0         0       1
1525194 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406383 320700011259 HERO HIGH SCHOOL public Career and Technical School No High 09 12 2020   grade_9 5.0 39.0 86.0   0.0     7.0     0.0   48.0 89.0     13       124     41   137 5 39 86   0     7     0   48 89     13   124   41   137
1525346 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 2020   grade_9 1.0 36.0 97.0   0.0     0.0     1.0   118.0 17.0     22       127     68   135 1 36 97   0     0     1   118 17     22   127   68   135
1525441 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 2020   grade_9 1.0 37.0 100.0   3.0     2.0         124.0 19.0     31       131     44   143 1 37 100   3     2         124 19     31   131   44   143
1526980 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 2020   grade_9 1.0 33.0 59.0   1.0     0.0     1.0   43.0 52.0     20       84     43   95 1 33 59   1     0     1   43 52     20   84   43   95
1529944 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 2020   grade_9 1.0 33.0 79.0   1.0     6.0     1.0   109.0 12.0     7       103     43   121 1 33 79   1     6     1   109 12     7   103   43   121
1530286 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 2020   grade_9   4.0 81.0         2.0         51.0 36.0     71       68     *   87   4 81         2         51 36     71   68       87
1530343 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 2020   grade_9 4.0 17.0 88.0   0.0     11.0     1.0   88.0 33.0     24       109     33   121 4 17 88   0     11     1   88 33     24   109   33   121
1531540 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805684 321100011275 HIGH SCHOOL-COMPUTERS & TECHNOLOGY public Career and Technical School No High 08 12 2020   grade_9 5.0 68.0 99.0   2.0     14.0     4.0   171.0 21.0     24       159     60   192 5 68 99   2     14     4   171 21     24   159   60   192
1540945 NY Erie   school 3605850 140600010000   BUFFALO 360585000315 140600010098 MCKINLEY VOC HIGH SCHOOL public Career and Technical School No High 09 12 2020   grade_9 24.0 139.0 50.0   5.0     24.0     9.0   143.0 108.0     47       218     54   251 24 139 50   5     24     9   143 108     47   218   54   251
1540964 NY Erie   school 3605850 140600010000   BUFFALO 360585000301 140600010101 BURGARD HIGH SCHOOL public Career and Technical School No High 09 12 2020   grade_9 13.0 79.0 25.0   2.0     7.0     4.0   89.0 41.0     15       118     37   130 13 79 25   2     7     4   89 41     15   118   37   130
1547500 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009101955 331300011605 GEORGE WESTINGHOUSE CAREER/TECH HS public Career and Technical School No High 08 12 2020   grade_9 2.0 131.0 49.0   0.0     7.0     3.0   122.0 70.0     13       160     57   192 2 131 49   0     7     3   122 70     13   160   57   192
1547557 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 2020   grade_9 4.0 63.0 33.0   0.0     11.0     2.0   98.0 15.0     5       91     30   113 4 63 33   0     11     2   98 15     5   91   30   113
1548431 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 2020   grade_9 18.0 41.0 91.0   3.0     3.0     0.0   127.0 29.0     *       127     38   156 18 41 91   3     3     0   127 29         127   38   156
1548488 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011901913 331400011610 A-TECH HIGH SCHOOL public Career and Technical School No High 09 12 2020   grade_9 3.0 28.0 40.0   0.0     1.0     1.0   71.0 2.0     *       *     *   73 3 28 40   0     1     1   71 2                 73
1551034 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 2020   grade_9 3.0 85.0 12.0   3.0     2.0     0.0   76.0 29.0     *       88     19   105 3 85 12   3     2     0   76 29         88   19   105
1551300 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 2020   grade_9 2.0 348.0 46.0   5.0     6.0     6.0   104.0 309.0     34       314     72   413 2 348 46   5     6     6   104 309     34   314   72   413
1551338 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 2020   grade_9 1.0 54.0 9.0   0.0     4.0     0.0   19.0 49.0     *       61     11   68 1 54 9   0     4     0   19 49         61   11   68
1552060 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 2020   grade_9 3.0 43.0 5.0   0.0     2.0     1.0   43.0 11.0     *       43     16   54 3 43 5   0     2     1   43 11         43   16   54
1553143 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 2020   grade_9 6.0 158.0 71.0   7.0     26.0     7.0   240.0 35.0     17       232     98   275 6 158 71   7     26     7   240 35     17   232   98   275
1553162 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 2020   grade_9 1.0 32.0 86.0   1.0     6.0     4.0   98.0 32.0     10       114     33   130 1 32 86   1     6     4   98 32     10   114   33   130
1553219 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 2020   grade_9 5.0 68.0 36.0   1.0     4.0     0.0   38.0 76.0     15       106     45   114 5 68 36   1     4     0   38 76     15   106   45   114
1553257 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 2020   grade_9 4.0 25.0 50.0   0.0     16.0     5.0   43.0 57.0     16       83     16   100 4 25 50   0     16     5   43 57     16   83   16   100
1555005 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 2020   grade_9 27.0 93.0 53.0   0.0     11.0     3.0   134.0 53.0     17       162     74   187 27 93 53   0     11     3   134 53     17   162   74   187
1570756 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 2020   grade_9 1.0 26.0 46.0   0.0     3.0     0.0   39.0 37.0     6       64     20   76 1 26 46   0     3     0   39 37     6   64   20   76
1570775 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 2020   grade_9 8.0 26.0 75.0   2.0     2.0     3.0   78.0 38.0     10       100     37   116 8 26 75   2     2     3   78 38     10   100   37   116
1570813 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 2020   grade_9 6.0 36.0 52.0   4.0     14.0     3.0   60.0 55.0     6       96     27   115 6 36 52   4     14     3   60 55     6   96   27   115
1570832 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 2020   grade_9 12.0 48.0 59.0   0.0     18.0     4.0   90.0 51.0     8       105     38   141 12 48 59   0     18     4   90 51     8   105   38   141
1570851 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 2020   grade_9 4.0 41.0 71.0   1.0     3.0     2.0   42.0 80.0     7       110     40   122 4 41 71   1     3     2   42 80     7   110   40   122
1571098 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 2020   grade_9 2.0 46.0 78.0   1.0     1.0     1.0   92.0 37.0     13       101     35   129 2 46 78   1     1     1   92 37     13   101   35   129
1571516 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 2020   grade_9 9.0 15.0 79.0   1.0     8.0     3.0   88.0 27.0     *       71     25   115 9 15 79   1     8     3   88 27         71   25   115
1571611 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 2020   grade_9 5.0 27.0 94.0   2.0     11.0     1.0   40.0 100.0     13       127     38   140 5 27 94   2     11     1   40 100     13   127   38   140
1571725 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 2020   grade_9 9.0 28.0 56.0   1.0     17.0     4.0   99.0 16.0     10       89     37   115 9 28 56   1     17     4   99 16     10   89   37   115
1571763 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 2020   grade_9 31.0 24.0 64.0   0.0     7.0     8.0   89.0 45.0     *       89     46   134 31 24 64   0     7     8   89 45         89   46   134
1571896 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 2020   grade_9 20.0 146.0 265.0   3.0     22.0     11.0   60.0 407.0     26       400     99   467 20 146 265   3     22     11   60 407     26   400   99   467
1571934 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 2020   grade_9 9.0 35.0 72.0   1.0     15.0     5.0   94.0 43.0     9       118     44   137 9 35 72   1     15     5   94 43     9   118   44   137
1571953 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 2020   grade_9 93.0 51.0 173.0   0.0     32.0     31.0   147.0 233.0     *       222     103   380 93 51 173   0     32     31   147 233         222   103   380
1572694 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 2020   grade_9 1.0 15.0 69.0   0.0     4.0     1.0   53.0 37.0     9       75     19   90 1 15 69   0     4     1   53 37     9   75   19   90
1574233 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 2020   grade_9 0.0 34.0 37.0   1.0     0.0     0.0   46.0 26.0     7       69     34   72 0 34 37   1     0     0   46 26     7   69   34   72
1575354 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 2020   grade_9 2.0 6.0 103.0   0.0     0.0     0.0   64.0 47.0     19       103     28   111 2 6 103   0     0     0   64 47     19   103   28   111
1585044 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 2020   grade_9 26.0 8.0 318.0   2.0     37.0     1.0   244.0 148.0     33       338     78   392 26 8 318   2     37     1   244 148     33   338   78   392
1585063 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 2020   grade_9 62.0 14.0 252.0   3.0     171.0     9.0   406.0 105.0     17       346     80   511 62 14 252   3     171     9   406 105     17   346   80   511
1586564 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 2020   grade_9 4.0 68.0 27.0   6.0     28.0     5.0   93.0 45.0     *       102     24   138 4 68 27   6     28     5   93 45         102   24   138
1587856 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 2020   grade_9 33.0 21.0 110.0   6.0     94.0     20.0   182.0 102.0     9       213     52   284 33 21 110   6     94     20   182 102     9   213   52   284
1588863 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 2020   grade_9 19.0 99.0 117.0   22.0     283.0     15.0   330.0 225.0     19       396     86   555 19 99 117   22     283     15   330 225     19   396   86   555
1589680 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 2020   grade_9 2.0 89.0 25.0   5.0     12.0     4.0   52.0 85.0     17       100     23   137 2 89 25   5     12     4   52 85     17   100   23   137
1589794 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 2020   grade_9 3.0 71.0 32.0   4.0     24.0     0.0   90.0 44.0     23       113     28   134 3 71 32   4     24     0   90 44     23   113   28   134
1590725 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 2020   grade_9 16.0 8.0 54.0   1.0     32.0     2.0   87.0 26.0     9       90     26   113 16 8 54   1     32     2   87 26     9   90   26   113
1590763 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 2020   grade_9 22.0 19.0 69.0   0.0     16.0     5.0   70.0 61.0     11       91     42   131 22 19 69   0     16     5   70 61     11   91   42   131
1593081 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 2020   grade_9 51.0 81.0 136.0   1.0     13.0     5.0   228.0 59.0     27       237     111   287 51 81 136   1     13     5   228 59     27   237   111   287
1523028 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2020   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
1523047 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1523066 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2020   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
1523085 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1523104 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2020   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
1523123 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   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
1523142 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2020   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
1523161 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   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
1523180 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1523199 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 128.0 364.0 114.0   2.0     56.0     22.0   343.0 343.0     75       418     88   686 128 364 114   2     56     22   343 343     75   418   88   686
1523218 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1523237 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2020   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
1523256 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2020   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
1523275 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1523294 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2020   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
1523313 NY Albany   school 3602460 10100010000   ALBANY 360246006700 10100010051 NORTH ALBANY ACADEMY MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1523332 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2020   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
1523351 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2020   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
1523370 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   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
1523389 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2020   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
1523408 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   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
1523427 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 06 12 2020   grade_9 2.0 64.0 15.0   0.0     0.0     10.0   91.0               68     0   91 2 64 15   0     0     10   91           68   0   91
1523446 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2020   grade_9 13.0 50.0 13.0   2.0     5.0     6.0     89.0     9       69     5   89 13 50 13   2     5     6     89     9   69   5   89
1523465 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2020   grade_9 46.0 1.0 0.0   0.0     0.0     2.0   26.0 23.0             22     7   49 46 1 0   0     0     2   26 23         22   7   49
1523484 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2020   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
1523503 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1523522 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1523541 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1523560 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1523579 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1523598 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 305.0 9.0 11.0         21.0     2.0   157.0 191.0     *       53     36   348 305 9 11         21     2   157 191         53   36   348
1523617 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1523636 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2020   grade_9 129.0 5.0 13.0         0.0     11.0   93.0 65.0     0       79     35   158 129 5 13         0     11   93 65     0   79   35   158
1523655 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2020   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
1523674 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2020   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
1523693 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2020   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
1523712 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 2020   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
1523731 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2020   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
1523750 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2020   grade_9 100.0 18.0 16.0   2.0     2.0     7.0   64.0 81.0     *       89     20   145 100 18 16   2     2     7   64 81         89   20   145

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