Data source: Big Local News · About: Big Local

4,747 rows where grade = "grade_7", state = "NY" and year = 2016 sorted by district

View and edit SQL

year

  • 2016 · 4,747

grade

  • grade_7 · 4,747
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
1034441 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes 1.0 PK 07 2016   grade_7 0.0 26.0 24.0   0.0     0.0     0.0   28.0 22.0             47     6   50 0 26 24   0     0     0   28 22         47   6   50
1071149 NY Nassau   school 3600997 280201860934   ACADEMY CHARTER SCHOOL 360099706131 280201860934 ACADEMY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_7 1.0 54.0 23.0   1.0     1.0     1.0   39.0 42.0             66     7   81 1 54 23   1     1     1   39 42         66   7   81
1099668 NY Queens   school 3601053 343000860998   ACADEMY OF THE CITY CHARTER 360105306289 343000860998 ACADEMY OF THE CITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 05 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1062124 NY Kings   school 3601028 331900860933   ACHIEVE FIRST APOLLO CHARTER 360102806237 331900860933 ACHIEVEMENT FIRST APOLLO CHARTER charter Regular School Yes 1.0 KG 6 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1062200 NY Kings   school 3601109 331900860993   ACHIEVEMENT FIRST ASPIRE CHA 360110906421 331900860993 ACHIEVEMENT FIRST ASPIRE CHARTER charter Regular School Yes 1.0 KG 3 2016   grade_7   0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0   0 0   0     0     0   0 0         0   0   0
1065297 NY Kings   school 3600969 332300860912   ACHIEVEMENT FIRST BROWNSVILL 360096906014 332300860912 ACHIEVEMENT FIRST BROWNSVILLE CHARTE charter Regular School Yes 1.0 KG 08 2016   grade_7 0.0 80.0 8.0   1.0           0.0   42.0 47.0             73     15   89 0 80 8   1           0   42 47         73   15   89
1065962 NY Kings   school 3600166 333200860906   ACHIEVEMENT FIRST BUSHWICK C 360016605902 333200860906 ACHIEVEMENT FIRST BUSHWICK CHARTER charter Regular School Yes 4.0 KG 12 2016   grade_7 0.0 30.0 59.0   1.0     0.0     0.0   43.0 47.0             82     10   90 0 30 59   1     0     0   43 47         82   10   90
1060148 NY Kings   school 3600147 331700860879   ACHIEVEMENT FIRST CROWN HGTS 360014705821 331700860879 ACHIEVEMENT FIRST CROWN HEIGHTS charter Regular School Yes 4.0 KG 12 2016   grade_7 0.0 85.0 2.0   0.0     0.0     0.0   46.0 41.0             63     8   87 0 85 2   0     0     0   46 41         63   8   87
1062086 NY Kings   school 3600149 331900860880   ACHIEVEMENT FIRST E NY CHART 360014905824 331900860880 ACHIEVEMENT FIRST E NY CHARTER SCH charter Regular School Yes 4.0 KG 11 2016   grade_7 0.0 67.0 1.0   0.0     0.0     0.0   27.0 41.0             54     6   68 0 67 1   0     0     0   27 41         54   6   68
1056291 NY Kings   school 3600170 331300860902   ACHIEVEMENT FIRST ENDEAVOR C 360017005867 331300860902 ACHIEVEMENT FIRST ENDEAVOR CHARTER charter Regular School Yes 4.0 KG 12 2016   grade_7 1.0 69.0 11.0   0.0     2.0     0.0   36.0 47.0             73     17   83 1 69 11   0     2     0   36 47         73   17   83
1062238 NY Kings   school 3601112 331900861072   ACHIEVEMENT FIRST LINDEN CS 360111206517 331900861072 ACHIEVEMENT FIRST LINDEN CHARTER SCH charter Regular School Yes 1.0 KG 2 2016   grade_7 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1066000 NY Kings   school 3601124 333200861045   ACHIEVEMENT FIRST NORTH BROOK 360112406457 333200861045 ACHIEVEMENT FIRST NORTH BROOKLYN PRE charter Regular School Yes 1.0 KG 02 2016   grade_7 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1106033 NY Steuben   school 3602370 570101040000   ADDISON 360237000008 570101040001 TUSCARORA ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_7 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
1106052 NY Steuben   school 3602370 570101040000   ADDISON 360237000007 570101040002 ADDISON MIDDLE/HIGH SCHOOL public Regular School No 4.0 06 12 2016   grade_7 84.0 1.0 0.0   2.0     3.0     0.0   51.0 39.0             47     13   90 84 1 0   2     3     0   51 39         47   13   90
1106071 NY Steuben   school 3602370 570101040000   ADDISON 360237000009 570101040003 VALLEY EARLY CHILDHOOD CENTER public Regular School No 1.0 PK PK 2016   grade_7 0.0                       0.0 0.0             0     0   0 0                       0 0         0   0   0
1085456 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504004187 410401060001 ADIRONDACK MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 104.0 0.0                 0.0   49.0 55.0             50     11   104 104 0                 0   49 55         50   11   104
1085475 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504000244 410401060002 WEST LEYDEN ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_7 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
1085494 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504000243 410401060003 FORESTPORT ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1085513 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504000242 410401060004 BOONVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1085532 NY Oneida   school 3605040 410401060000   ADIRONDACK 360504000241 410401060005 ADIRONDACK HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1045062 NY Chenango   school 3602400 80101040000   AFTON 360240000010 80101040002 AFTON ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1045081 NY Chenango   school 3602400 80101040000   AFTON 360240000011 80101040003 AFTON JUNIOR/SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_7 43.0 2.0 4.0   0.0     0.0     0.0   20.0 29.0             38     6   49 43 2 4   0     0     0   20 29         38   6   49
1051712 NY Erie   school 3602430 142101040000   AKRON 360243000012 142101040001 AKRON ELEMENTARY SCHOOL public Regular School No 1.0 KG 5 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1051731 NY Erie   school 3602430 142101040000   AKRON 360243000013 142101040002 AKRON HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1051750 NY Erie   school 3602430 142101040000   AKRON 360243005012 142101040003 AKRON MIDDLE SCHOOL public Regular School No 2.0 06 8 2016   grade_7 93.0 0.0     15.0     1.0     3.0   47.0 65.0             *     *   112 93 0     15     1     3   47 65                 112
1031762 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031781 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031800 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031819 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031838 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2016   grade_7 1.0 38.0 9.0   1.0     1.0     2.0   26.0 26.0             39     *   52 1 38 9   1     1     2   26 26         39       52
1031857 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No 1.0 PK 06 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031876 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031895 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No 1.0 PK 06 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031914 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031933 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 58.0 106.0 44.0   1.0     24.0     6.0   120.0 119.0             144     46   239 58 106 44   1     24     6   120 119         144   46   239
1031952 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_7 0.0 1.0 0.0   0.0     0.0     0.0   1.0 0.0             *     *   1 0 1 0   0     0     0   1 0                 1
1031971 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1031990 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No 1.0 PK 05 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1032009 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No 1.0 PK 05 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1032028 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 54.0 167.0 31.0   1.0     20.0     5.0   144.0 134.0             189     32   278 54 167 31   1     20     5   144 134         189   32   278
1032047 NY Albany   school 3602460 10100010000   ALBANY 360246006538 10100010046 WEST HILL MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 1.0 82.0 13.0   0.0     4.0     4.0   47.0 57.0             52     *   104 1 82 13   0     4     4   47 57         52       104
1032142 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_7 1.0 64.0 6.0         0.0         39.0 32.0             53     *   71 1 64 6         0         39 32         53       71
1032180 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   grade_7 0.0 0.0 0.0   0.0     0.0           0.0             0     0   0 0 0 0   0     0           0         0   0   0
1091156 NY Orleans   school 3602520 450101060000   ALBION 360252000035 450101060002 RONALD L SODOMA ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1091175 NY Orleans   school 3602520 450101060000   ALBION 360252000033 450101060003 CHARLES D'AMICO HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1091194 NY Orleans   school 3602520 450101060000   ALBION 360252000034 450101060005 CARL I BERGERSON MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 114.0 20.0 14.0   2.0     1.0         73.0 78.0             81     16   151 114 20 14   2     1         73 78         81   16   151
1048444 NY Erie   school 3602550 140101060000   ALDEN 360255000041 140101060003 ALDEN PRIMARY AT TOWNLINE public Regular School No 1.0 KG 3 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1048463 NY Erie   school 3602550 140101060000   ALDEN 360255000038 140101060005 ALDEN MIDDLE SCHOOL public Regular School No 2.0 04 8 2016   grade_7 131.0 1.0 0.0   0.0     1.0     0.0   74.0 59.0             43     18   133 131 1 0   0     1     0   74 59         43   18   133
1048482 NY Erie   school 3602550 140101060000   ALDEN 360255000039 140101060006 ALDEN SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1053498 NY Genesee   school 3602580 180202040000   ALEXANDER 360258000042 180202040002 ALEXANDER ELEMENTARY SCHOOL public Regular School No 1.0 PK 5 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1053517 NY Genesee   school 3602580 180202040000   ALEXANDER 360258000043 180202040003 ALEXANDER MIDDLE SCHOOL-HIGH SCHOOL public Regular School No 4.0 06 12 2016   grade_7 45.0 2.0 1.0         0.0     0.0   26.0 22.0             16     *   48 45 2 1         0     0   26 22         16       48
1054790 NY Jefferson   school 3602670 220202040000   ALEXANDRIA CSD 360267000044 220202040001 ALEXANDRIA CENTRAL ELEMENTARY SCHOOL public Regular School No 1.0 PK 6 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1054809 NY Jefferson   school 3602670 220202040000   ALEXANDRIA CSD 360267004333 220202040002 ALEXANDRIA CENTRAL HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_7 44.0 1.0           0.0     0.0   25.0 20.0             29     *   45 44 1           0     0   25 20         29       45
1033111 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_7 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
1033130 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   grade_7 45.0   0.0         3.0     0.0   27.0 21.0             23     8   48 45   0         3     0   27 21         23   8   48
1042687 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500053 40302060001 ALLEGANY-LIMESTONE HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1042706 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No 1.0 PK 05 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1042725 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001504317 40302060004 ALLEGANY-LIMESTONE MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 86.0 1.0 0.0   1.0     3.0     2.0   50.0 43.0             39     8   93 86 1 0   1     3     2   50 43         39   8   93
1050249 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 4 2016   grade_7   0.0 0.0   0.0           0.0   0.0 0.0             0     0   0   0 0   0           0   0 0         0   0   0
1091384 NY Oswego   school 3602820 460102040000   ALTMAR-PARISH 360282000055 460102040006 ALTMAR-PARISH-WILLIAMSTOWN JR/SR HS public Regular School No 3.0 07 12 2016   grade_7 90.0 0.0 0.0   0.0     0.0     1.0   45.0 46.0             58     19   91 90 0 0   0     0     1   45 46         58   19   91
1091403 NY Oswego   school 3602820 460102040000   ALTMAR-PARISH 360282006344 460102040007 ALTMAR-PARISH-WILLIAMSTOWN ELEMEN public Regular School No 1.0 PK 06 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1109510 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No 4.0 PK 10 2016   grade_7 0.0   0.0         0.0     0.0   0.0 0.0                   0   0 0   0         0     0   0 0             0   0
1119105 NY Westchester   school 3601051 660900861000   AMANI PUBLIC CHARTER SCHOOL 360105106291 660900861000 AMANI PUBLIC CHARTER SCHOOL charter Regular School Yes 2.0 05 08 2016   grade_7 0.0 66.0 8.0   1.0     0.0     0.0   37.0 38.0             57     *   75 0 66 8   1     0     0   37 38         57       75
1082435 NY New York   school 3600039 310400860806   AMBER CHARTER SCHOOL 360003904439 310400860806 AMBER CHARTER SCHOOL charter Regular School Yes 1.0 KG 05 2016   grade_7 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1034574 NY Bronx   school 3601119 320700861062   AMERICAN DREAM CHARTER SCHOO 360111906495 320700861062 AMERICAN DREAM CHARTER SCHOOL charter Regular School Yes 2.0 06 07 2016   grade_7 0.0 8.0 74.0               1.0   42.0 41.0             73     19   83 0 8 74               1   42 41         73   19   83
1048501 NY Erie   school 3602920 140201060000   AMHERST 360292004335 140201060001 AMHERST MIDDLE SCHOOL public Regular School No 2.0 06 8 2016   grade_7 154.0 37.0 15.0   0.0     18.0     7.0   119.0 112.0             68     29   231 154 37 15   0     18     7   119 112         68   29   231
1048520 NY Erie   school 3602920 140201060000   AMHERST 360292000061 140201060002 AMHERST CENTRAL HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1048539 NY Erie   school 3602920 140201060000   AMHERST 360292004378 140201060005 SMALLWOOD DRIVE SCHOOL public Regular School No 1.0 KG 5 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1048558 NY Erie   school 3602920 140201060000   AMHERST 360292004289 140201060006 WINDERMERE BLVD SCHOOL public Regular School No 1.0 PK 5 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1107306 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000064 580106030001 NORTHEAST SCHOOL public Regular School No 1.0 PK KG 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1107325 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000065 580106030002 NORTHWEST ELEMENTARY SCHOOL public Regular School No 1.0 01 03 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1107344 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000066 580106030003 PARK AVENUE SCHOOL public Regular School No 1.0 01 06 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1107363 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000062 580106030004 EDMUND W MILES MIDDLE SCHOOL public Regular School No 2.0 07 09 2016   grade_7 9.0 92.0 89.0         1.0     3.0   103.0 91.0             163     38   194 9 92 89         1     3   103 91         163   38   194
1107382 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000063 580106030005 AMITYVILLE MEMORIAL HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1070579 NY Montgomery   school 3602970 270100010000   AMSTERDAM 360297000075 270100010003 WILLIAM H BARKLEY MICROSOCIETY public Regular School No 1.0 PK 05 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1070598 NY Montgomery   school 3602970 270100010000   AMSTERDAM 360297000073 270100010006 R J MCNULTY ACADEMY public Regular School No 1.0 PK 05 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1070617 NY Montgomery   school 3602970 270100010000   AMSTERDAM 360297000071 270100010009 WILBUR H LYNCH LITERACY ACADEMY public Regular School No 2.0 06 08 2016   grade_7 132.0 20.0 112.0   0.0     1.0     4.0   151.0 118.0             139     32   269 132 20 112   0     1     4   151 118         139   32   269
1070636 NY Montgomery   school 3602970 270100010000   AMSTERDAM 360297000068 270100010010 AMSTERDAM HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1070655 NY Montgomery   school 3602970 270100010000   AMSTERDAM 360297000074 270100010018 WILLIAM B TECLER ARTS IN EDUCATION public Regular School No 1.0 PK 05 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1070674 NY Montgomery   school 3602970 270100010000   AMSTERDAM 360297000072 270100010019 MARIE CURIE INST OF ENGIN AND COMM public Regular School No 1.0 PK 05 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1046696 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_7 9.0 0.0 1.0         0.0     0.0   5.0 5.0             6     *   10 9 0 1         0     0   5 5         6       10
1033149 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2016   grade_7 22.0 0.0 0.0         0.0         10.0 12.0             9     *   22 22 0 0         0         10 12         9       22
1117737 NY Westchester   school 3603180 660405030000   ARDSLEY 360318000080 660405030001 ARDSLEY HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1117756 NY Westchester   school 3603180 660405030000   ARDSLEY 360318000081 660405030002 ARDSLEY MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_7 114.0 4.0 25.0         26.0     1.0   98.0 72.0             14     15   170 114 4 25         26     1   98 72         14   15   170
1117775 NY Westchester   school 3603180 660405030000   ARDSLEY 360318000082 660405030003 CONCORD ROAD ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1115704 NY Washington   school 3603210 640101040000   ARGYLE 360321000083 640101040001 ARGYLE JUNIOR/SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_7 34.0   3.0         1.0     1.0   17.0 22.0             19     8   39 34   3         1     1   17 22         19   8   39
1115723 NY Washington   school 3603210 640101040000   ARGYLE 360321004850 640101040002 ARGYLE ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1106527 NY Steuben   school 3603240 571901040000   ARKPORT 360324000085 571901040004 ARKPORT CENTRAL SCHOOL public Regular School No 4.0 KG 12 2016   grade_7 34.0   2.0   0.0     0.0     1.0   16.0 21.0             13     *   37 34   2   0     0     1   16 21         13       37
1047665 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000086 131601060001 ARTHUR S MAY SCHOOL public Regular School No 1.0 KG 05 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1047684 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000089 131601060002 BEEKMAN SCHOOL public Regular School No 1.0 KG 05 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1047703 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000093 131601060004 OVERLOOK PRIMARY SCHOOL public Regular School No 1.0 KG 02 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1047722 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000095 131601060005 TRAVER ROAD PRIMARY SCHOOL public Regular School No 1.0 KG 02 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1047741 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000088 131601060008 ARLINGTON HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1047760 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000096 131601060010 WEST ROAD/D'AQUANNI INTERM SCH public Regular School No 1.0 03 05 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1047779 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000092 131601060011 NOXON ROAD ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1047798 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003266 131601060012 LAGRANGE MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 232.0 29.0 49.0         22.0     13.0   168.0 177.0             118     57   345 232 29 49         22     13   168 177         118   57   345
1047817 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327003268 131601060013 TITUSVILLE INTERMEDIATE public Regular School No 1.0 03 05 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1047836 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005596 131601060014 VAIL FARM ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1047855 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005597 131601060015 UNION VALE MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 286.0 11.0 41.0   0.0     13.0     5.0   188.0 168.0             56     59   356 286 11 41   0     13     5   188 168         56   59   356
1039210 NY Bronx   school 3601138 321000861075   ATMOSPHERE ACADEMY PUBLIC CH 360113806563 321000861075 ATMOSPHERE ACADEMY PUBLIC CHARTER charter Regular School Yes 2.0 06 06 2016   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         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]);