Data source: Big Local News · About: Big Local

4,742 rows where grade = "grade_7", state = "NY" and year = 2020 sorted by district

View and edit SQL

year

  • 2020 · 4,642

grade

  • grade_7 · 4,642
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
1539157 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005596 131601060014 VAIL FARM ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1539176 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327005597 131601060015 UNION VALE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 225.0 12.0 49.0         10.0     17.0   146.0 167.0     *       59     44   313 225 12 49         10     17   146 167         59   44   313
1530493 NY Bronx   school 3601138 321000861075   ATMOSPHERE ACADEMY PUBLIC CH 360113806563 321000861075 ATMOSPHERE ACADEMY PUBLIC CHARTER charter Regular School Yes Middle 06 08 2020   grade_7 6.0 18.0 109.0   1.0     0.0     0.0   75.0 59.0     13       122     29   134 6 18 109   1     0     0   75 59     13   122   29   134
1612820 NY Wyoming   school 3603420 670201060000   ATTICA 360342000099 670201060001 ATTICA SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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
1612839 NY Wyoming   school 3603420 670201060000   ATTICA 360342000097 670201060002 ATTICA ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1612858 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2020   grade_7 85.0 1.0 6.0   0.0     0.0         34.0 58.0     *       43     19   92 85 1 6   0     0         34 58         43   19   92
1534616 NY Cayuga   school 3603480 50100010000   AUBURN 360348000102 50100010002 CASEY PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   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
1534635 NY Cayuga   school 3603480 50100010000   AUBURN 360348000104 50100010004 GENESEE STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   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
1534654 NY Cayuga   school 3603480 50100010000   AUBURN 360348000105 50100010005 HERMAN AVENUE ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   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
1534673 NY Cayuga   school 3603480 50100010000   AUBURN 360348000107 50100010007 OWASCO ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   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
1534692 NY Cayuga   school 3603480 50100010000   AUBURN 360348000109 50100010008 WILLIAM H SEWARD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   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   0   0
1534711 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2020   grade_7 228.0 19.0 15.0         3.0     33.0   146.0 152.0     *       179     41   298 228 19 15         3     33   146 152         179   41   298
1534730 NY Cayuga   school 3603480 50100010000   AUBURN 360348000101 50100010013 AUBURN HIGH SCHOOL public Regular School No High 09 12 2020   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
1536820 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001397 90201040001 KEESEVILLE PRIMARY SCHOOL public Regular School No Elementary PK 06 2020   grade_7 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
1536839 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001396 90201040002 AUSABLE VALLEY HIGH SCHOOL public Regular School No High 09 12 2020   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
1536858 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_7 0.0 0.0                 0.0   0.0 0.0             0     0   0 0 0                 0   0 0         0   0   0
1536877 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 08 2020   grade_7 73.0 3.0 0.0                   34.0 42.0             *     17   76 73 3 0                   34 42             17   76
1591426 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600114 491302060001 SAND LAKE-MILLER HILL SCHOOL public Regular School No Elementary KG 05 2020   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
1591445 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600111 491302060002 AVERILL PARK HIGH SCHOOL public Regular School No High 09 12 2020   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
1591464 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600113 491302060004 POESTENKILL ES public Regular School No Elementary KG 05 2020   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
1591483 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600115 491302060005 WEST SAND LAKE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1591502 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600110 491302060006 ALGONQUIN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 231.0 3.0 5.0         4.0     5.0   123.0 125.0     *       61     47   248 231 3 5         4     5   123 125         61   47   248
1597411 NY Steuben   school 3603630 570201040000   AVOCA 360363000117 570201040002 AVOCA CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 28.0 0.0 1.0   0.0     0.0     0.0   12.0 17.0             17     *   29 28 0 1   0     0     0   12 17         17       29
1557549 NY Livingston   school 3603660 240101040000   AVON 360366000118 240101040001 AVON PRIMARY SCHOOL public Regular School No Elementary KG 04 2020   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   0   0
1557568 NY Livingston   school 3603660 240101040000   AVON 360366000119 240101040002 AVON HIGH SCHOOL public Regular School No High 09 12 2020   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
1557587 NY Livingston   school 3603660 240101040000   AVON 360366004863 240101040003 AVON MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 64.0 3.0 8.0   0.0     0.0     0.0   42.0 33.0     *       27     7   75 64 3 8   0     0     0   42 33         27   7   75
1598019 NY Suffolk   school 3603720 580101030000   BABYLON 360372000122 580101030001 BABYLON MEMORIAL GRADE SCHOOL public Regular School No Elementary 03 06 2020   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
1598038 NY Suffolk   school 3603720 580101030000   BABYLON 360372000121 580101030002 BABYLON JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 92.0 2.0 15.0   0.0     7.0     6.0   65.0 57.0     *       17     8   122 92 2 15   0     7     6   65 57         17   8   122
1598057 NY Suffolk   school 3603720 580101030000   BABYLON 360372000120 580101030003 BABYLON ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   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
1536440 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000123 80201040001 BAINBRIDGE-GUILFORD HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 64.0 1.0 4.0   0.0     0.0     5.0   41.0 33.0             47     9   74 64 1 4   0     0     5   41 33         47   9   74
1536459 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000124 80201040002 GREENLAWN ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2020   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
1536478 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000125 80201040003 GUILFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 01 2020   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
1563477 NY Nassau   school 3603840 280210030000   BALDWIN 360384000129 280210030001 BROOKSIDE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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   0   0
1563496 NY Nassau   school 3603840 280210030000   BALDWIN 360384000132 280210030004 LENOX ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1563515 NY Nassau   school 3603840 280210030000   BALDWIN 360384000133 280210030005 MEADOW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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   0   0
1563534 NY Nassau   school 3603840 280210030000   BALDWIN 360384000135 280210030007 PLAZA ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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   0   0
1563553 NY Nassau   school 3603840 280210030000   BALDWIN 360384000138 280210030010 STEELE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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   0   0
1563572 NY Nassau   school 3603840 280210030000   BALDWIN 360384000126 280210030012 BALDWIN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 34.0 176.0 101.0         13.0     7.0   160.0 171.0     *       122     58   331 34 176 101         13     7   160 171         122   58   331
1563591 NY Nassau   school 3603840 280210030000   BALDWIN 360384000128 280210030013 BALDWIN SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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   0   0
1578848 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000143 420901060002 HARRY E ELDEN ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1578867 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000139 420901060003 CATHERINE M MCNAMARA ELEMENTARY SCH public Regular School No Elementary KG 05 2020   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
1578886 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000144 420901060004 L PEARL PALMER ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1578905 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000147 420901060005 VAN BUREN ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1578924 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000146 420901060006 THEODORE R DURGEE JUNIOR HIGH SCH public Regular School No Secondary 08 09 2020   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
1578943 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000140 420901060007 CHARLES W BAKER HIGH SCHOOL public Regular School No High 10 12 2020   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
1578962 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000145 420901060008 MAE E REYNOLDS SCHOOL public Regular School No Elementary KG 05 2020   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   0   0
1578981 NY Onondaga   school 3603870 420901060000   BALDWINSVILLE 360387000141 420901060009 DONALD S RAY SCHOOL public Regular School No Middle 06 07 2020   grade_7 378.0 16.0 28.0   1.0     4.0     26.0   227.0 226.0     *       156     78   453 378 16 28   1     4     26   227 226         156   78   453
1595606 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000149 521301060001 BALLSTON SPA SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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
1595625 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000150 521301060002 MALTA AVENUE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1595644 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393003409 521301060003 GORDON CREEK ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1595663 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000148 521301060005 BALLSTON SPA MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 300.0 3.0 10.0         6.0     6.0   184.0 141.0     *       111     46   325 300 3 10         6     6   184 141         111   46   325
1595682 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000153 521301060006 WOOD ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1595701 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393006048 521301060008 MILTON TERRACE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1576587 NY Niagara   school 3603960 401301040000   BARKER 360396000154 401301040002 PRATT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   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
1576606 NY Niagara   school 3603960 401301040000   BARKER 360396000155 401301040003 BARKER JR/SR HIGH SCHOOL public Regular School No High 07 12 2020   grade_7 53.0 0.0 8.0         0.0     1.0   32.0 30.0     *       35     *   62 53 0 8         0     1   32 30         35       62
1544895 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary KG 04 2020   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   0   0
1544914 NY Genesee   school 3603990 180300010000   BATAVIA 360399000159 180300010003 JACKSON SCHOOL public Regular School No Elementary PK 02 2020   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   0   0
1544933 NY Genesee   school 3603990 180300010000   BATAVIA 360399000157 180300010005 BATAVIA MIDDLE SCHOOL public Regular School No Middle 05 08 2020   grade_7 123.0 29.0 15.0   2.0     3.0     1.0   88.0 85.0     *       104     16   173 123 29 15   2     3     1   88 85         104   16   173
1544952 NY Genesee   school 3603990 180300010000   BATAVIA 360399000156 180300010006 BATAVIA HIGH SCHOOL public Regular School No High 09 12 2020   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   0   0
1597430 NY Steuben   school 3604050 570302060000   BATH 360405000164 570302060001 VERNON E WIGHTMAN PRIMARY SCHOOL public Regular School No Elementary PK 03 2020   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
1597449 NY Steuben   school 3604050 570302060000   BATH 360405000163 570302060003 HAVERLING SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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
1597468 NY Steuben   school 3604050 570302060000   BATH 360405005411 570302060004 DANA L LYON MIDDLE SCHOOL public Regular School No Middle 04 08 2020   grade_7 105.0 3.0     0.0           0.0   54.0 54.0             57     23   108 105 3     0           0   54 54         57   23   108
1601857 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000167 580501030001 BROOK AVENUE ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   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
1601876 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000169 580501030002 GARDINER MANOR SCHOOL public Regular School No Elementary 03 05 2020   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   0   0
1601895 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000170 580501030003 MARY G CLARKSON SCHOOL public Regular School No Elementary KG 02 2020   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
1601914 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000168 580501030004 FIFTH AVENUE SCHOOL public Regular School No Elementary KG 02 2020   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   0   0
1601933 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000171 580501030005 SOUTH COUNTRY SCHOOL public Regular School No Elementary 03 05 2020   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   0   0
1601952 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000166 580501030006 BAY SHORE SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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   0   0
1601971 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000165 580501030007 BAY SHORE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 113.0 94.0 185.0   1.0     20.0     19.0   202.0 230.0     *       262     68   432 113 94 185   1     20     19   202 230         262   68   432
1602294 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000174 580505020002 BLUE POINT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1602313 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000176 580505020003 SYLVAN AVENUE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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   0   0
1602332 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000173 580505020004 BAYPORT-BLUE POINT HIGH SCHOOL public Regular School No High 09 12 2020   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
1602351 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000172 580505020005 ACADEMY STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1602370 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000175 580505020006 JAMES WILSON YOUNG MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 138.0 3.0 13.0   2.0     4.0     4.0   81.0 83.0     *       *     29   164 138 3 13   2     4     4   81 83             29   164
1538378 NY Dutchess   school 3604140 130200010000   BEACON 360414000179 130200010001 J V FORRESTAL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1538397 NY Dutchess   school 3604140 130200010000   BEACON 360414000182 130200010002 SOUTH AVENUE SCHOOL public Regular School No Elementary KG 05 2020   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
1538416 NY Dutchess   school 3604140 130200010000   BEACON 360414000178 130200010003 GLENHAM SCHOOL public Regular School No Elementary PK 05 2020   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
1538435 NY Dutchess   school 3604140 130200010000   BEACON 360414000180 130200010004 ROMBOUT MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 85.0 48.0 66.0         4.0     15.0   99.0 119.0     *       95     30   218 85 48 66         4     15   99 119         95   30   218
1538454 NY Dutchess   school 3604140 130200010000   BEACON 360414000177 130200010005 BEACON HIGH SCHOOL public Regular School No High 09 12 2020   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
1538473 NY Dutchess   school 3604140 130200010000   BEACON 360414000181 130200010006 SARGENT SCHOOL public Regular School No Elementary PK 05 2020   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
1557492 NY Lewis   school 3604200 231301040000   BEAVER RIVER 360420004503 231301040001 BEAVER RIVER ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1557511 NY Lewis   school 3604200 231301040000   BEAVER RIVER 360420004504 231301040002 BEAVER RIVER HIGH SCHOOL public Regular School No High 09 12 2020   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
1557530 NY Lewis   school 3604200 231301040000   BEAVER RIVER 360420005992 231301040004 BEAVER RIVER MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 66.0 1.0 1.0   2.0     0.0         38.0 32.0     *       36     16   70 66 1 1   2     0         38 32         36   16   70
1608165 NY Westchester   school 3619950 660102060000   BEDFORD 361995004831 660102060001 BEDFORD VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1608184 NY Westchester   school 3619950 660102060000   BEDFORD 361995001820 660102060002 BEDFORD HILLS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1608203 NY Westchester   school 3619950 660102060000   BEDFORD 361995001824 660102060003 MT KISCO ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1608222 NY Westchester   school 3619950 660102060000   BEDFORD 361995001825 660102060004 POUND RIDGE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1608241 NY Westchester   school 3619950 660102060000   BEDFORD 361995001823 660102060005 FOX LANE MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 166.0 7.0 124.0         12.0     7.0   170.0 146.0     29       124     50   316 166 7 124         12     7   170 146     29   124   50   316
1608260 NY Westchester   school 3619950 660102060000   BEDFORD 361995001822 660102060006 FOX LANE HIGH SCHOOL public Regular School No High 09 12 2020   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
1608279 NY Westchester   school 3619950 660102060000   BEDFORD 361995001826 660102060007 WEST PATENT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   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
1550291 NY Kings   school 3600965 331600860918   BEDFORD STUY COLLEGIATE CS 360096506044 331600860918 BEDFORD STUY COLLEGIATE CHARTER SCH charter Regular School Yes Middle 05 08 2020   grade_7 2.0 45.0 37.0   2.0     3.0     0.0   42.0 47.0     *       77     17   89 2 45 37   2     3     0   42 47         77   17   89
1550348 NY Kings   school 3601029 331600860971   BEDFORD STUY NEW BEGINNINGS 360102906236 331600860971 BEDFORD STUY NEW BEGINNINGS CHARTER charter Regular School Yes Elementary KG 08 2020   grade_7 0.0 46.0 35.0   0.0     0.0     0.0   37.0 44.0     5       78     17   81 0 46 35   0     0     0   37 44     5   78   17   81
1536896 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000184 90301060001 BEEKMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1536915 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000186 90301060003 CUMBERLAND HEAD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   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
1536934 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429003247 90301060005 BEEKMANTOWN MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_7 136.0 2.0 4.0   2.0     2.0         72.0 74.0     *       76     33   146 136 2 4   2     2         72 74         76   33   146
1536953 NY Clinton   school 3604290 90301060000   BEEKMANTOWN 360429000185 90301060006 BEEKMANTOWN HIGH SCHOOL public Regular School No High 09 12 2020   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
1548638 NY Kings   school 3601064 331400861021   BEGINNING WITH CHILDREN CHAR 360106406305 331400861021 BEGINNING WITH CHILDREN CHARTER II charter Regular School Yes Elementary KG 08 2020   grade_7 1.0 13.0 33.0   1.0     1.0     0.0   23.0 26.0     5       46     10   49 1 13 33   1     1     0   23 26     5   46   10   49
1524451 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2020   grade_7 32.0 1.0 0.0               0.0   13.0 20.0     *       21     7   33 32 1 0               0   13 20         21   7   33
1546453 NY Jefferson   school 3604370 220909040000   BELLEVILLE-HENDERS 360437004801 220909040010 BELLEVILLE HENDERSON CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_7 30.0 1.0 3.0         0.0     2.0   18.0 18.0     *       20     10   36 30 1 3         0     2   18 18         20   10   36
1563154 NY Nassau   school 3604410 280207020000   BELLMORE 360441000190 280207020002 SHORE ROAD SCHOOL public Regular School No Middle 05 06 2020   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]);