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,647

grade

  • grade_7 · 4,647
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
1121651 NY Wyoming   school 3603420 670201060000   ATTICA 360342000099 670201060001 ATTICA 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         0   0   0
1121670 NY Wyoming   school 3603420 670201060000   ATTICA 360342000097 670201060002 ATTICA 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
1121689 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No 2.0 05 08 2016   grade_7 107.0 0.0 0.0         2.0     1.0   60.0 50.0             39     16   110 107 0 0         2     1   60 50         39   16   110
1043276 NY Cayuga   school 3603480 50100010000   AUBURN 360348000102 50100010002 CASEY PARK 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
1043295 NY Cayuga   school 3603480 50100010000   AUBURN 360348000104 50100010004 GENESEE STREET 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
1043314 NY Cayuga   school 3603480 50100010000   AUBURN 360348000105 50100010005 HERMAN AVENUE 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
1043333 NY Cayuga   school 3603480 50100010000   AUBURN 360348000107 50100010007 OWASCO 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
1043352 NY Cayuga   school 3603480 50100010000   AUBURN 360348000109 50100010008 WILLIAM H SEWARD 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         0   0   0
1043371 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No 2.0 07 08 2016   grade_7 238.0 13.0 8.0         1.0     21.0   148.0 133.0             147     33   281 238 13 8         1     21   148 133         147   33   281
1043390 NY Cayuga   school 3603480 50100010000   AUBURN 360348000101 50100010013 AUBURN 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
1045480 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESEVILLE PRIMARY 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
1045499 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001396 90201040002 AUSABLE VALLEY 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
1045518 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS 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
1045537 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No 2.0 07 08 2016   grade_7 94.0 1.0 1.0   0.0     1.0     0.0   52.0 45.0             50     8   97 94 1 1   0     1     0   52 45         50   8   97
1100105 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600114 491302060001 SAND LAKE-MILLER HILL 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
1100124 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600111 491302060002 AVERILL PARK 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
1100143 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600113 491302060004 POESTENKILL ES 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
1100162 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600115 491302060005 WEST SAND LAKE 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
1100181 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600110 491302060006 ALGONQUIN MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 201.0 1.0 6.0         4.0     3.0   110.0 105.0             44     29   215 201 1 6         4     3   110 105         44   29   215
1106090 NY Steuben   school 3603630 570201040000   AVOCA 360363000117 570201040002 AVOCA CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_7 34.0 0.0 1.0         0.0     0.0   21.0 14.0             17     *   35 34 0 1         0     0   21 14         17       35
1066285 NY Livingston   school 3603660 240101040000   AVON 360366000118 240101040001 AVON PRIMARY 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
1066304 NY Livingston   school 3603660 240101040000   AVON 360366000119 240101040002 AVON 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
1066323 NY Livingston   school 3603660 240101040000   AVON 360366004863 240101040003 AVON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_7 72.0 0.0 1.0         2.0     1.0   37.0 39.0             *     6   76 72 0 1         2     1   37 39             6   76
1106717 NY Suffolk   school 3603720 580101030000   BABYLON 360372000122 580101030001 BABYLON MEMORIAL GRADE SCHOOL public Regular School No 1.0 03 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
1106736 NY Suffolk   school 3603720 580101030000   BABYLON 360372000121 580101030002 BABYLON JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_7 103.0 6.0 10.0         2.0     1.0   50.0 72.0             *     18   122 103 6 10         2     1   50 72             18   122
1106755 NY Suffolk   school 3603720 580101030000   BABYLON 360372000120 580101030003 BABYLON ELEMENTARY 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
1045100 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000123 80201040001 BAINBRIDGE-GUILFORD HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_7 59.0 0.0 1.0         2.0     3.0   40.0 25.0             39     8   65 59 0 1         2     3   40 25         39   8   65
1045119 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000124 80201040002 GREENLAWN ELEMENTARY SCHOOL public Regular School No 1.0 02 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
1045138 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000125 80201040003 GUILFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 01 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
1072194 NY Nassau   school 3603840 280210030000   BALDWIN 360384000129 280210030001 BROOKSIDE 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         0   0   0
1072213 NY Nassau   school 3603840 280210030000   BALDWIN 360384000132 280210030004 LENOX 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
1072232 NY Nassau   school 3603840 280210030000   BALDWIN 360384000133 280210030005 MEADOW 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
1072251 NY Nassau   school 3603840 280210030000   BALDWIN 360384000135 280210030007 PLAZA 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
1072270 NY Nassau   school 3603840 280210030000   BALDWIN 360384000138 280210030010 STEELE 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
1072289 NY Nassau   school 3603840 280210030000   BALDWIN 360384000126 280210030012 BALDWIN MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 78.0 199.0 99.0   0.0     22.0     18.0   215.0 201.0             97     57   416 78 199 99   0     22     18   215 201         97   57   416
1072308 NY Nassau   school 3603840 280210030000   BALDWIN 360384000128 280210030013 BALDWIN 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         0   0   0
1087679 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000143 420901060002 HARRY E ELDEN 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         0   0   0
1087698 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000139 420901060003 CATHERINE M MCNAMARA ELEMENTARY SCH 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
1087717 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000144 420901060004 L PEARL PALMER 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
1087736 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000147 420901060005 VAN BUREN 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         0   0   0
1087755 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000146 420901060006 THEODORE R DURGEE JUNIOR HIGH SCH public Regular School No 4.0 08 09 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
1087774 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000140 420901060007 CHARLES W BAKER HIGH SCHOOL public Regular School No 3.0 10 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
1087793 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000145 420901060008 MAE E REYNOLDS 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
1087812 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000141 420901060009 DONALD S RAY SCHOOL public Regular School No 2.0 06 07 2016   grade_7 363.0 5.0 15.0   1.0     5.0     12.0   204.0 197.0             94     62   401 363 5 15   1     5     12   204 197         94   62   401
1104152 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000149 521301060001 BALLSTON SPA 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
1104171 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000150 521301060002 MALTA AVENUE 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
1104190 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393003409 521301060003 GORDON CREEK 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
1104209 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000148 521301060005 BALLSTON SPA MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 298.0 10.0 5.0         7.0     2.0   179.0 143.0             110     50   322 298 10 5         7     2   179 143         110   50   322
1104228 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000153 521301060006 WOOD 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
1104247 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393006048 521301060008 MILTON TERRACE 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
1085380 NY Niagara   school 3603960 401301040000   BARKER 360396000154 401301040002 PRATT 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
1085399 NY Niagara   school 3603960 401301040000   BARKER 360396000155 401301040003 BARKER JR/SR HIGH SCHOOL public Regular School No 4.0 05 12 2016   grade_7 62.0   4.0         0.0     0.0   31.0 35.0             33     *   66 62   4         0     0   31 35         33       66
1053536 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No 1.0 02 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
1053555 NY Genesee   school 3603990 180300010000   BATAVIA 360399000159 180300010003 JACKSON SCHOOL public Regular School No 1.0 PK 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         0   0   0
1053574 NY Genesee   school 3603990 180300010000   BATAVIA 360399000157 180300010005 BATAVIA MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_7 111.0 6.0 12.0         2.0     20.0   83.0 68.0             77     24   151 111 6 12         2     20   83 68         77   24   151
1053593 NY Genesee   school 3603990 180300010000   BATAVIA 360399000156 180300010006 BATAVIA 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
1106109 NY Steuben   school 3604050 570302060000   BATH 360405000164 570302060001 VERNON E WIGHTMAN PRIMARY SCHOOL public Regular School No 1.0 PK 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
1106128 NY Steuben   school 3604050 570302060000   BATH 360405000163 570302060003 HAVERLING 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         0   0   0
1106147 NY Steuben   school 3604050 570302060000   BATH 360405005411 570302060004 DANA L LYON MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   grade_7 103.0 0.0 2.0   0.0           0.0   49.0 56.0             66     13   105 103 0 2   0           0   49 56         66   13   105
1110612 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000167 580501030001 BROOK AVENUE ELEMENTARY 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
1110631 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000169 580501030002 GARDINER MANOR SCHOOL 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         0   0   0
1110650 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000170 580501030003 MARY G CLARKSON 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
1110669 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000168 580501030004 FIFTH AVENUE 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
1110688 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000171 580501030005 SOUTH COUNTRY SCHOOL 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
1110707 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000166 580501030006 BAY SHORE 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         0   0   0
1110726 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000165 580501030007 BAY SHORE MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 179.0 98.0 188.0   0.0     17.0     4.0   251.0 235.0             249     61   486 179 98 188   0     17     4   251 235         249   61   486
1111049 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000174 580505020002 BLUE POINT 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
1111068 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000176 580505020003 SYLVAN AVENUE 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
1111087 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000173 580505020004 BAYPORT-BLUE POINT 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
1111106 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000172 580505020005 ACADEMY STREET ELEMENTARY SCHOOL public Regular School No 4.0 KG 09 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
1111125 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000175 580505020006 JAMES WILSON YOUNG MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 166.0 3.0 16.0   1.0     7.0     1.0   96.0 98.0             *     38   194 166 3 16   1     7     1   96 98             38   194
1047038 NY Dutchess   school 3604140 130200010000   BEACON 360414000179 130200010001 J V FORRESTAL 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
1047057 NY Dutchess   school 3604140 130200010000   BEACON 360414000182 130200010002 SOUTH AVENUE 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
1047076 NY Dutchess   school 3604140 130200010000   BEACON 360414000178 130200010003 GLENHAM 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
1047095 NY Dutchess   school 3604140 130200010000   BEACON 360414000180 130200010004 ROMBOUT MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 111.0 37.0 63.0         5.0     4.0   104.0 116.0             *     38   220 111 37 63         5     4   104 116             38   220
1047114 NY Dutchess   school 3604140 130200010000   BEACON 360414000177 130200010005 BEACON 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
1047133 NY Dutchess   school 3604140 130200010000   BEACON 360414000181 130200010006 SARGENT 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
1066228 NY Lewis   school 3604200 231301040000   BEAVER RIVER 360420004503 231301040001 BEAVER RIVER 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
1066247 NY Lewis   school 3604200 231301040000   BEAVER RIVER 360420004504 231301040002 BEAVER RIVER 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
1066266 NY Lewis   school 3604200 231301040000   BEAVER RIVER 360420005992 231301040004 BEAVER RIVER MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 57.0 2.0 0.0                   34.0 25.0             31     *   59 57 2 0                   34 25         31       59
1116958 NY Westchester   school 3619950 660102060000   BEDFORD 361995004831 660102060001 BEDFORD VILLAGE 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
1116977 NY Westchester   school 3619950 660102060000   BEDFORD 361995001820 660102060002 BEDFORD HILLS 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
1116996 NY Westchester   school 3619950 660102060000   BEDFORD 361995001824 660102060003 MT KISCO 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
1117015 NY Westchester   school 3619950 660102060000   BEDFORD 361995001825 660102060004 POUND RIDGE 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
1117034 NY Westchester   school 3619950 660102060000   BEDFORD 361995001823 660102060005 FOX LANE MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 188.0 9.0 71.0         16.0     10.0   139.0 155.0             66     21   294 188 9 71         16     10   139 155         66   21   294
1117053 NY Westchester   school 3619950 660102060000   BEDFORD 361995001822 660102060006 FOX LANE 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
1117072 NY Westchester   school 3619950 660102060000   BEDFORD 361995001826 660102060007 WEST PATENT 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
1059027 NY Kings   school 3600965 331600860918   BEDFORD STUY COLLEGIATE CS 360096506044 331600860918 BEDFORD STUY COLLEGIATE CHARTER SCH charter Regular School Yes 4.0 05 12 2016   grade_7 0.0 58.0 20.0   0.0     1.0         36.0 43.0             58     16   79 0 58 20   0     1         36 43         58   16   79
1059084 NY Kings   school 3601029 331600860971   BEDFORD STUY NEW BEGINNINGS 360102906236 331600860971 BEDFORD STUY NEW BEGINNINGS CHARTER charter Regular School Yes 1.0 KG 8 2016   grade_7 0.0 30.0 16.0   0.0     0.0     0.0   16.0 30.0             *     10   46 0 30 16   0     0     0   16 30             10   46
1045556 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000184 90301060001 BEEKMANTOWN 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
1045575 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000186 90301060003 CUMBERLAND HEAD 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
1045594 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429003247 90301060005 BEEKMANTOWN MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_7 113.0 3.0 2.0   0.0     1.0         61.0 58.0             72     22   119 113 3 2   0     1         61 58         72   22   119
1045613 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000185 90301060006 BEEKMANTOWN 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
1057336 NY Kings   school 3601064 331400861021   BEGINNING WITH CHILDREN CHAR 360106406305 331400861021 BEGINNING WITH CHILDREN CHARTER II 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     0   0 0         0   0   0
1057241 NY Kings   school 3600041 331400860825   BEGINNING WITH CHLDRN CHARTER 360004104491 331400860825 BEGINNING WITH CHLDRN CHARTER SCHOOL charter Regular School Yes 1.0 KG 8 2016   grade_7 0.0 15.0 22.0   2.0     0.0     0.0   18.0 21.0             35     11   39 0 15 22   2     0     0   18 21         35   11   39
1033187 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2016   grade_7 34.0   1.0               0.0   20.0 15.0             23     6   35 34   1               0   20 15         23   6   35
1055113 NY Jefferson   school 3604370 220909040000   BELLEVILLE-HENDERS 360437004801 220909040010 BELLEVILLE HENDERSON CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_7 29.0 0.0 2.0         0.0     1.0   14.0 18.0             14     *   32 29 0 2         0     1   14 18         14       32
1071871 NY Nassau   school 3604410 280207020000   BELLMORE 360441000190 280207020002 SHORE ROAD SCHOOL public Regular School No 2.0 05 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
1071890 NY Nassau   school 3604410 280207020000   BELLMORE 360441000191 280207020003 WINTHROP AVENUE SCHOOL public Regular School No 1.0 03 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         0   0   0
1071909 NY Nassau   school 3604410 280207020000   BELLMORE 360441002841 280207020004 REINHARD EARLY CHILDHOOD CENTER public Regular School No 1.0 PK 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

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