Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_4" and state = "NY" sorted by black descending

View and edit SQL

year

grade

  • grade_4 · 33,145
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
949755 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802450 321100010121 PS 121 THROOP public Regular School No Elementary PK 05 2017   grade_4 7.0 99.0 45.0   2.0     12.0     1.0   77.0 89.0     14       90     41   166 7 99 45   2     12     1   77 89     14   90   41   166
1064344 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302783 332200010269 PS 269 NOSTRAND public Regular School No 1.0 03 5 2016   grade_4 1.0 99.0 17.0   0.0     4.0     1.0   63.0 59.0             72     *   122 1 99 17   0     4     1   63 59         72       122
2172349 NY Kings   school 3601002 332300860954   BROWNSVILLE ASCEND CHARTER 360100206167 332300860954 BROWNSVILLE ASCEND CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_4 2.0 99.0 15.0   0.0     1.0     1.0   51.0 67.0     *       99     18   118 2 99 15   0     1     1   51 67         99   18   118
2056886 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802312 321100010078 PS 78 ANNE HUTCHINSON public Regular School No Elementary PK 05 2018   grade_4 3.0 98.0 30.0   1.0     1.0     0.0   71.0 62.0     10       113     27   133 3 98 30   1     1     0   71 62     10   113   27   133
2115501 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102617 342900010176 PS 176 CAMBRIA HEIGHTS public Regular School No Elementary PK 05 2018   grade_4 1.0 98.0 6.0   6.0     5.0     0.0   51.0 65.0     0       88     10   116 1 98 6   6     5     0   51 65     0   88   10   116
1064819 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012102564 332300010156 PS 156 WAVERLY public Regular School No 1.0 PK 05 2016   grade_4 0.0 97.0 29.0   1.0     0.0     1.0   72.0 56.0             113     31   128 0 97 29   1     0     1   72 56         113   31   128
1499786 NY Queens   school 3601035 342900860974   RIVERTON STREET CHARTER SCHO 360103506226 342900860974 RIVERTON STREET CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_4 2.0 97.0 6.0   1.0     3.0     3.0   51.0 61.0     *       85     17   112 2 97 6   1     3     3   51 61         85   17   112
2057000 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No Elementary KG 05 2018   grade_4 2.0 97.0 63.0   4.0     4.0     1.0   87.0 84.0     29       *     49   171 2 97 63   4     4     1   87 84     29       49   171
2076513 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009500799 331700010006 NORMA ADAMS CLEMONS ACADEMY public Regular School No Elementary KG 05 2018   grade_4 4.0 97.0 21.0   1.0     1.0     0.0   60.0 64.0     27       101     28   124 4 97 21   1     1     0   60 64     27   101   28   124
2205637 NY Queens   school 3601118 342900861078   SUCCESS ACADEMY CS - SPRINGFI 360111806486 342900861078 SUCCESS ACADEMY CS - SPRINGFIELD charter Regular School Yes Elementary KG 06 2019   grade_4 0.0 97.0 3.0   3.0     3.0     0.0   45.0 61.0     *       71     *   106 0 97 3   3     3     0   45 61         71       106
772755 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502649 331700010189 PS 189 BILINGUAL CENTER (THE) public Regular School No 1 KG 8 2015   grade_4 0.0 96.0 36.0   1.0     2.0     0.0   63.0 72.0             128     14   135 0 96 36   1     2     0   63 72         128   14   135
975367 NY Kings   school 3601002 332300860954   BROWNSVILLE ASCEND CHARTER 360100206167 332300860954 BROWNSVILLE ASCEND CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_4 0.0 96.0 14.0   3.0     0.0     0.0   56.0 57.0     *       110     12   113 0 96 14   3     0     0   56 57         110   12   113
1059309 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502631 331700010181 PS 181 public Regular School No 1.0 PK 8 2016   grade_4 0.0 96.0 13.0   2.0     1.0     0.0   63.0 49.0             69     27   112 0 96 13   2     1     0   63 49         69   27   112
1064002 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302549 332200010152 SCHOOL OF SCIENCE AND TECHNOLOGY public Regular School No 1.0 PK 5 2016   grade_4 8.0 96.0 25.0   0.0     12.0     1.0   71.0 71.0             103     22   142 8 96 25   0     12     1   71 71         103   22   142
1039283 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802185 321100010041 PS 41 GUN HILL ROAD public Regular School No 1.0 KG 05 2016   grade_4 4.0 95.0 61.0   1.0     1.0     0.0   98.0 64.0             154     27   162 4 95 61   1     1     0   98 64         154   27   162
1072913 NY Nassau   school 3610620 280216020000   ELMONT 361062000834 280216020004 DUTCH BROADWAY SCHOOL public Regular School No 1.0 PK 06 2016   grade_4 1.0 95.0 23.0   0.0     7.0     2.0   76.0 52.0             73     24   128 1 95 23   0     7     2   76 52         73   24   128
2146699 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No Elementary KG 05 2019   grade_4 6.0 95.0 82.0   8.0     6.0     0.0   107.0 90.0     37       174     46   197 6 95 82   8     6     0   107 90     37   174   46   197
1039340 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802312 321100010078 PS 78 ANNE HUTCHINSON public Regular School No 1.0 PK 05 2016   grade_4 5.0 94.0 25.0   1.0     0.0     0.0   63.0 62.0             105     27   125 5 94 25   1     0     0   63 62         105   27   125
1039454 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802389 321100010103 PS 103 HECTOR FONTANEZ public Regular School No 1.0 KG 05 2016   grade_4 4.0 94.0 74.0   5.0     4.0     0.0   90.0 91.0             150     40   181 4 94 74   5     4     0   90 91         150   40   181
796923 NY New York   school 3600108 310500860864   HARLEM CHILDREN'S ZONE PROMIS 360010805640 310500860864 HARLEM CHILDREN'S ZONE PROMISE charter Regular School Yes 4 KG 11 2015   grade_4 0.0 93.0 5.0   0.0     0.0     0.0   44.0 54.0             84     23   98 0 93 5   0     0     0   44 54         84   23   98
949489 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802282 321100010068 PS 68 public Regular School No Elementary PK 05 2017   grade_4 1.0 93.0 25.0   1.0     2.0     1.0   59.0 64.0     *       69     26   123 1 93 25   1     2     1   59 64         69   26   123
968546 NY Kings   school 3600094 331600010000   NYC GEOG DIST #16 - BROOKLYN 360009402108 331600010021 PS 21 CRISPUS ATTUCKS public Regular School No Elementary PK 5 2017   grade_4 4.0 93.0 9.0   0.0     3.0         54.0 55.0     *       75     33   109 4 93 9   0     3         54 55         75   33   109
969363 NY Kings   school 3600095 331700010000   NYC GEOG DIST #17 - BROOKLYN 360009502649 331700010189 PS 189 BILINGUAL CENTER (THE) public Regular School No Elementary KG 8 2017   grade_4 0.0 93.0 21.0   2.0     3.0     0.0   60.0 59.0     13       109     25   119 0 93 21   2     3     0   60 59     13   109   25   119
1008142 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102666 342900010195 PS 195 WILLIAM HABERLE public Regular School No Elementary PK 05 2017   grade_4 1.0 93.0 6.0   3.0     0.0     1.0   48.0 56.0     *       93     16   104 1 93 6   3     0     1   48 56         93   16   104
1107341 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000066 580106030003 PARK AVENUE SCHOOL public Regular School No 1.0 01 06 2016   grade_4 18.0 93.0 105.0   0.0     0.0     7.0   132.0 91.0             196     24   223 18 93 105   0     0     7   132 91         196   24   223
1546830 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009102074 331300010011 PS 11 PURVIS J BEHAN public Regular School No Elementary PK 05 2020   grade_4 13.0 93.0 19.0   2.0     4.0     6.0   65.0 72.0     5       52     14   137 13 93 19   2     4     6   65 72     5   52   14   137
1551371 NY Kings   school 3600147 331700860879   ACHIEVEMENT FIRST CROWN HGTS 360014705821 331700860879 ACHIEVEMENT FIRST CROWN HEIGHTS charter Regular School Yes Other KG 12 2020   grade_4 1.0 93.0 0.0   1.0     0.0     0.0   45.0 50.0     0       77     19   95 1 93 0   1     0     0   45 50     0   77   19   95
2146585 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802312 321100010078 PS 78 ANNE HUTCHINSON public Regular School No Elementary PK 05 2019   grade_4 12.0 93.0 38.0   1.0     3.0     1.0   82.0 66.0     13       124     32   148 12 93 38   1     3     1   82 66     13   124   32   148
786473 NY Nassau   school 3610620 280216020000   ELMONT 361062000834 280216020004 DUTCH BROADWAY SCHOOL public Regular School No 1 PK 06 2015   grade_4 1.0 92.0 21.0   0.0     7.0     1.0   62.0 60.0             86     23   122 1 92 21   0     7     1   62 60         86   23   122
970408 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602496 331800010135 PS 135 SHELDON A BROOKNER public Regular School No Elementary PK 5 2017   grade_4 5.0 92.0 13.0   1.0     1.0     3.0   49.0 66.0     *       101     18   115 5 92 13   1     1     3   49 66         101   18   115
1049866 NY Erie   school 3605850 140600010000   BUFFALO 360585001549 140600010126 STANLEY MAKOWSKI EARLY CHLDHD CTR public Regular School No 1.0 PK 4 2016   grade_4 6.0 92.0 12.0   1.0     10.0     4.0   75.0 50.0             118     50   125 6 92 12   1     10     4   75 50         118   50   125
1456732 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009102074 331300010011 PS 11 PURVIS J BEHAN public Regular School No Elementary PK 05 2021   grade_4 19.0 92.0 17.0   2.0     3.0     10.0   62.0 81.0     *       52     *   143 19 92 17   2     3     10   62 81         52       143
2056848 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802282 321100010068 PS 68 public Regular School No Elementary PK 05 2018   grade_4 0.0 92.0 23.0   2.0     3.0     0.0   62.0 58.0     *       79     36   120 0 92 23   2     3     0   62 58         79   36   120
949470 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802185 321100010041 PS 41 GUN HILL ROAD public Regular School No Elementary KG 05 2017   grade_4 2.0 91.0 82.0   3.0     1.0     1.0   91.0 89.0     13       180     37   180 2 91 82   3     1     1   91 89     13   180   37   180
970465 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602721 331800010219 PS 219 KENNEDY-KING public Regular School No Elementary PK 5 2017   grade_4 1.0 91.0 11.0   1.0     3.0     0.0   54.0 53.0     7       74     30   107 1 91 11   1     3     0   54 53     7   74   30   107
1007325 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010006284 342800010354 JERMAINE L GREEN STEM INSTITUTE public Regular School No Elementary PK 05 2017   grade_4 2.0 91.0 10.0   3.0     3.0     0.0   57.0 52.0     8       82     21   109 2 91 10   3     3     0   57 52     8   82   21   109
1055490 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009102074 331300010011 PS 11 PURVIS J BEHAN public Regular School No 1.0 PK 5 2016   grade_4 10.0 91.0 19.0   3.0     10.0     2.0   70.0 65.0             65     19   135 10 91 19   3     10     2   70 65         65   19   135
1060563 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602790 331800010276 PS 276 LOUIS MARSHALL public Regular School No 1.0 PK 5 2016   grade_4 1.0 91.0 5.0   5.0     3.0     0.0   55.0 50.0             77     19   105 1 91 5   5     3     0   55 50         77   19   105
1064420 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015303385 332200010315 PS 315 public Regular School No 1.0 PK 5 2016   grade_4 6.0 91.0 22.0   0.0     10.0     0.0   68.0 61.0             106     33   129 6 91 22   0     10     0   68 61         106   33   129
2056810 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802111 321100010021 PS 21 PHILIP H SHERIDAN public Regular School No Elementary KG 05 2018   grade_4 3.0 91.0 41.0   4.0     1.0     1.0   67.0 74.0     9       133     31   141 3 91 41   4     1     1   67 74     9   133   31   141
2077862 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602790 331800010276 PS 276 LOUIS MARSHALL public Regular School No Elementary PK 05 2018   grade_4 3.0 91.0 7.0   1.0     1.0     0.0   60.0 43.0     11       80     20   103 3 91 7   1     1     0   60 43     11   80   20   103
2082118 NY Kings   school 3600121 332300010000   NYC GEOG DIST #23 - BROOKLYN 360012102564 332300010156 PS 156 WAVERLY public Regular School No Elementary PK 05 2018   grade_4 3.0 91.0 27.0   0.0     1.0     0.0   60.0 62.0     *       115     31   122 3 91 27   0     1     0   60 62         115   31   122
2124621 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000066 580106030003 PARK AVENUE SCHOOL public Regular School No Elementary KG 06 2018   grade_4 9.0 91.0 116.0   2.0     2.0     7.0   126.0 101.0     54       192     19   227 9 91 116   2     2     7   126 101     54   192   19   227
811762 NY Queens   school 3600101 342900010000   NYC GEOG DIST #29 - QUEENS 360010102666 342900010195 PS 195 WILLIAM HABERLE public Regular School No 1 PK 05 2015   grade_4 0.0 90.0 2.0   0.0     2.0     0.0   49.0 45.0             87     20   94 0 90 2   0     2     0   49 45         87   20   94
2077805 NY Kings   school 3600096 331800010000   NYC GEOG DIST #18 - BROOKLYN 360009602759 331800010244 PS 244 RICHARD R GREEN public Regular School No Elementary PK 05 2018   grade_4 1.0 90.0 6.0         0.0     1.0   55.0 43.0     *       82     28   98 1 90 6         0     1   55 43         82   28   98
746364 NY Albany   school 3613080 10802060000   GUILDERLAND 361308004589 10802060003 GUILDERLAND ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_4 59.0 9.0 1.0         14.0     3.0   39.0 47.0             11     9   86 59 9 1         14     3   39 47         11   9   86
746972 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No 1.0 PK 05 2015   grade_4 0.0 9.0 82.0   0.0     0.0     0.0   48.0 43.0             88     27   91 0 9 82   0     0     0   48 43         88   27   91
747846 NY Bronx   school 3600144 320700860889   SOUTH BRONX CHARTER SCHOOL 360014405787 320700860889 SOUTH BRONX CHARTER SCHOOL charter Regular School Yes 1.0 KG 05 2015   grade_4 0.0 9.0 43.0   0.0     0.0         25.0 27.0             39     7   52 0 9 43   0     0         25 27         39   7   52
748587 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505123 320800010304 PS 304 EARLY CHILDHOOD SCHOOL public Regular School No 1.0 PK 05 2015   grade_4 30.0 9.0 41.0   2.0     3.0     1.0   47.0 39.0             69     19   86 30 9 41   2     3     1   47 39         69   19   86
750829 NY Bronx   school 3600066 320900860839   FAMILY LIFE ACAD CHARTER I 360006604877 320900860839 FAMILY LIFE ACADEMY CHARTER I charter Regular School Yes 1.0 KG 08 2015   grade_4 0.0 9.0 42.0   1.0           0.0   27.0 25.0             45     11   52 0 9 42   1           0   27 25         45   11   52
751038 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008701748 321000010015 PS 15 INST FOR ENVIRON LRNG public Regular School No 1.0 KG 08 2015   grade_4 0.0 9.0 41.0   0.0     0.0     0.0   26.0 24.0             *     14   50 0 9 41   0     0     0   26 24             14   50
751627 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008704464 321000010246 PS 246 POE CENTER public Regular School No 1.0 KG 05 2015   grade_4 1.0 9.0 108.0   1.0     1.0     0.0   67.0 53.0             113     25   120 1 9 108   1     1     0   67 53         113   25   120
755218 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000230 30200010011 MACARTHUR SCHOOL public Regular School No 1.0 PK 05 2015   grade_4 39.0 9.0 11.0   1.0     1.0     8.0   30.0 39.0             49     10   69 39 9 11   1     1     8   30 39         49   10   69
755674 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000846 31501060001 CHARLES F JOHNSON JR ELEMENTARY SCH public Regular School No 1.0 KG 05 2015   grade_4 32.0 9.0 2.0         3.0     9.0   29.0 26.0             *     7   55 32 9 2         3     9   29 26             7   55
755750 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000853 31501060013 THOMAS J WATSON SR ELEM SCHOOL public Regular School No 1.0 KG 05 2015   grade_4 32.0 9.0 4.0         1.0     2.0   19.0 29.0             34     *   48 32 9 4         1     2   19 29         34       48
758220 NY Chemung   school 3610560 70600010000   ELMIRA 361056000810 70600010022 BROADWAY ELEMENTARY SCHOOL public Regular School No 1.0 03 06 2015   grade_4 101.0 9.0 1.0         1.0     2.0   58.0 56.0             57     12   114 101 9 1         1     2   58 56         57   12   114
760443 NY Dutchess   school 3604140 130200010000   BEACON 360414000182 130200010002 SOUTH AVENUE SCHOOL public Regular School No 1.0 PK 05 2015   grade_4 17.0 9.0 12.0         3.0     9.0   21.0 29.0             28     *   50 17 9 12         3     9   21 29         28       50
761051 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000086 131601060001 ARTHUR S MAY SCHOOL public Regular School No 1.0 KG 05 2015   grade_4 43.0 9.0 15.0   0.0     3.0     0.0   38.0 32.0             *     16   70 43 9 15   0     3     0   38 32             16   70
761260 NY Dutchess   school 3606500 131602020000   SPACKENKILL 360650000430 131602020001 HAGAN SCHOOL public Regular School No 1.0 03 05 2015   grade_4 63.0 9.0 16.0         10.0     2.0   51.0 49.0             20     *   100 63 9 16         10     2   51 49         20       100
761925 NY Erie   school 3602920 140201060000   AMHERST 360292004378 140201060005 SMALLWOOD DRIVE SCHOOL public Regular School No 1 KG 5 2015   grade_4 96.0 9.0 5.0   1.0     3.0     3.0   56.0 61.0             20     6   117 96 9 5   1     3     3   56 61         20   6   117
768765 NY Jefferson   school 3606630 222201060000   CARTHAGE 360663000443 222201060002 BLACK RIVER SCHOOL public Regular School No 1 KG 4 2015   grade_4 64.0 9.0 13.0   0.0     2.0     7.0   52.0 43.0             48     28   95 64 9 13   0     2     7   52 43         48   28   95
770152 NY Kings   school 3600119 331400010000   NYC GEOG DIST #14 - BROOKLYN 360011902668 331400010196 PS 196 TEN EYCK public Regular School No 1 PK 5 2015   grade_4 0.0 9.0 34.0   0.0     0.0     0.0   27.0 16.0             37     18   43 0 9 34   0     0     0   27 16         37   18   43
771045 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202251 331500010058 PS 58 CARROLL (THE) public Regular School No 1 PK 5 2015   grade_4 104.0 9.0 19.0   1.0     12.0     10.0   86.0 69.0             26     36   155 104 9 19   1     12     10   86 69         26   36   155
771273 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202607 331500010172 PS 172 BEACON SCHOOL OF EXCELLENCE public Regular School No 1 PK 5 2015   grade_4 15.0 9.0 67.0   0.0     3.0         52.0 42.0             88     31   94 15 9 67   0     3         52 42         88   31   94
779120 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702788 333200010274 PS 274 KOSCIUSKO public Regular School No 1 PK 05 2015   grade_4 0.0 9.0 75.0   0.0     2.0         45.0 41.0             83     8   86 0 9 75   0     2         45 41         83   8   86
779234 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702829 333200010377 PS 377 ALEJANDINA B DE GAUTIER public Regular School No 1 PK 08 2015   grade_4 0.0 9.0 35.0   0.0     0.0         23.0 21.0             41     17   44 0 9 35   0     0         23 21         41   17   44
780830 NY Monroe   school 3611880 260401060000   GATES CHILI 361188000953 260401060007 PAUL ROAD SCHOOL public Regular School No 1 PK 05 2015   grade_4 49.0 9.0 3.0   0.0     0.0     9.0   37.0 33.0             21     11   70 49 9 3   0     0     9   37 33         21   11   70
781951 NY Monroe   school 3610890 261301060000   FAIRPORT 361089000858 261301060001 BROOKS HILL SCHOOL public Regular School No 1 KG 05 2015   grade_4 83.0 9.0 8.0         9.0     0.0   49.0 60.0             23     10   109 83 9 8         9     0   49 60         23   10   109
783642 NY Monroe   school 3625170 261701060000   RUSH HENRIETTA 362517003486 261701060004 MONICA B LEARY ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_4 62.0 9.0 4.0         7.0     6.0   54.0 34.0             22     *   88 62 9 4         7     6   54 34         22       88
783870 NY Monroe   school 3605580 261801060000   BROCKPORT 360558004579 261801060006 FRED W HILL SCHOOL public Regular School No 2 04 05 2015   grade_4 210.0 9.0 15.0         6.0     13.0   144.0 109.0             113     38   253 210 9 15         6     13   144 109         113   38   253
787442 NY Nassau   school 3630660 280227030000   WEST HEMPSTEAD 363066004122 280227030006 GEORGE WASHINGTON SCHOOL public Regular School No 1 01 05 2015   grade_4 25.0 9.0 28.0   0.0     1.0     6.0   29.0 40.0             31     *   69 25 9 28   0     1     6   29 40         31       69
790064 NY Nassau   school 3610980 280522030000   FARMINGDALE 361098000881 280522030006 WOODWARD PARKWAY ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_4 98.0 9.0 23.0   0.0     5.0     2.0   79.0 58.0             30     26   137 98 9 23   0     5     2   79 58         30   26   137
790767 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504561 307500013140 PS 140 public Special Education School No 1 KG 08 2015   grade_4 0.0 9.0 4.0         0.0     0.0   12.0 1.0             12     13   13 0 9 4         0     0   12 1         12   13   13
790862 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013502826 307500013370 PS 370 public Special Education School No 4 KG 12 2015   grade_4 3.0 9.0 2.0   0.0     2.0     0.0   9.0 7.0             13     16   16 3 9 2   0     2     0   9 7         13   16   16
791071 NY New York   school 3600135 307500010000   NYC SPEC SCHOOLS - DIST 75 360013504480 307500014023 PS 23 AT QUEENS CHILDREN CTR public Special Education School No 4 KG 12 2015   grade_4 1.0 9.0 4.0   1.0     1.0     0.0   12.0 4.0             14     15   16 1 9 4   1     1     0   12 4         14   15   16
791489 NY New York   school 3600076 310100010000   NYC GEOG DIST # 1 - MANHATTAN 360007602411 310100010110 PS 110 FLORENCE NIGHTINGALE public Regular School No 1 PK 05 2015   grade_4 17.0 9.0 36.0   3.0     6.0     0.0   35.0 36.0             38     18   71 17 9 36   3     6     0   35 36         38   18   71
791717 NY New York   school 3600076 310100010000   NYC GEOG DIST # 1 - MANHATTAN 360007605618 310100010363 NEIGHBORHOOD SCHOOL public Regular School No 1 PK 05 2015   grade_4 24.0 9.0 16.0   0.0     4.0     0.0   31.0 22.0             23     20   53 24 9 16   0     4     0   31 22         23   20   53
794529 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802335 310300010087 PS 87 WILLIAM SHERMAN public Regular School No 1 PK 05 2015   grade_4 89.0 9.0 21.0   1.0     12.0     3.0   70.0 65.0             16     29   135 89 9 21   1     12     3   70 65         16   29   135
794605 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802591 310300010165 PS 165 ROBERT E SIMON public Regular School No 1 PK 08 2015   grade_4 8.0 9.0 70.0   1.0     4.0     0.0   44.0 48.0             79     20   92 8 9 70   1     4     0   44 48         79   20   92
795726 NY New York   school 3600079 310400010000   NYC GEOG DIST # 4 - MANHATTAN 360007902560 310400010155 PS 155 WILLIAM PACA public Regular School No 1 PK 05 2015   grade_4   9.0 51.0   1.0     2.0         30.0 33.0             61     24   63   9 51   1     2         30 33         61   24   63
803326 NY Orange   school 3630030 440102060000   WASHINGTONVILLE 363003004038 440102060002 TAFT ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_4 70.0 9.0 21.0   0.0     5.0     2.0   55.0 52.0             32     14   107 70 9 21   0     5     2   55 52         32   14   107
803725 NY Orange   school 3612330 440601040000   GOSHEN 361233000996 440601040005 GOSHEN INTERMEDIATE SCHOOL public Regular School No 1 03 05 2015   grade_4 150.0 9.0 42.0   0.0     8.0     1.0   99.0 111.0             *     23   210 150 9 42   0     8     1   99 111             23   210
808133 NY Queens   school 3600122 342500010000   NYC GEOG DIST #25 - QUEENS 360012202711 342500010214 PS 214 CADWALLADER COLDEN public Regular School No 1 PK 05 2015   grade_4 4.0 9.0 28.0         41.0     1.0   37.0 46.0             71     18   83 4 9 28         41     1   37 46         71   18   83
815068 NY Richmond   school 3600103 353100010000   NYC GEOG DIST #31 - SI 360010306184 353100010074 PS 74 FUTURE LEADERS ELEMENTARY public Regular School No 1 PK 05 2015   grade_4 1.0 9.0 28.0   1.0     3.0         19.0 23.0             39     20   42 1 9 28   1     3         19 23         39   20   42
815809 NY Rockland   school 3614010 500201060000   HAVERSTRAW-STONY POINT 361401001143 500201060008 JAMES A FARLEY ELEMENTARY SCHOOL public Regular School No 2 04 06 2015   grade_4 82.0 9.0 105.0   2.0     6.0     8.0   113.0 99.0             106     22   212 82 9 105   2     6     8   113 99         106   22   212
823162 NY Suffolk   school 3610680 580401020000   ELWOOD 361068000840 580401020001 JAMES H BOYD ELEMENTARY SCHOOL public Regular School No 1 03 05 2015   grade_4 132.0 9.0 30.0         16.0     3.0   94.0 96.0             40     19   190 132 9 30         16     3   94 96         40   19   190
823333 NY Suffolk   school 3615090 580403030000   HUNTINGTON 361509001261 580403030004 FLOWER HILL SCHOOL public Regular School No 1 KG 04 2015   grade_4 24.0 9.0 27.0         2.0     2.0   28.0 36.0             36     7   64 24 9 27         2     2   28 36         36   7   64
825176 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000251 580512030004 LAUREL PARK ELEMENTARY SCHOOL public Regular School No 1 01 05 2015   grade_4 4.0 9.0 97.0   1.0     1.0         64.0 48.0             106     24   112 4 9 97   1     1         64 48         106   24   112
826791 NY Sullivan   school 3610950 590501060000   FALLSBURGH 361095000873 590501060003 BENJAMIN COSOR ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_4 39.0 9.0 46.0   0.0     3.0     8.0   59.0 46.0             76     17   105 39 9 46   0     3     8   59 46         76   17   105
830230 NY Wayne   school 3627120 651201060000   SODUS 362712004902 651201060004 SODUS INTERMEDIATE SCHOOL public Regular School No 2 04 06 2015   grade_4 40.0 9.0 20.0   0.0           4.0   35.0 38.0             48     5   73 40 9 20   0           4   35 38         48   5   73
944910 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502168 320800010036 PS 36 UNIONPORT public Regular School No Elementary PK 05 2017   grade_4 9.0 9.0 71.0   5.0     18.0     0.0   57.0 55.0     15       80     25   112 9 9 71   5     18     0   57 55     15   80   25   112
948026 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702318 321000010081 PS 81 ROBERT J CHRISTEN public Regular School No Elementary KG 05 2017   grade_4 29.0 9.0 64.0   0.0     9.0     1.0   52.0 60.0     9       61     17   112 29 9 64   0     9     1   52 60     9   61   17   112
948653 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008706015 321000010386 SCHOOL FOR ENVIRONMENTAL CITIZENSHIP public Regular School No Elementary PK 05 2017   grade_4 0.0 9.0 58.0   0.0     2.0         37.0 32.0     *       69     11   69 0 9 58   0     2         37 32         69   11   69
950648 NY Bronx   school 3600943 321100860909   ICAHN CHARTER SCHOOL 2 360094305973 321100860909 ICAHN CHARTER SCHOOL 2 charter Regular School Yes Elementary KG 08 2017   grade_4 0.0 9.0 30.0   0.0     1.0     0.0   15.0 25.0     0       31     *   40 0 9 30   0     1     0   15 25     0   31       40
957222 NY Dutchess   school 3604140 130200010000   BEACON 360414000178 130200010003 GLENHAM SCHOOL public Regular School No Elementary PK 05 2017   grade_4 29.0 9.0 23.0         3.0     5.0   32.0 37.0     *       34     25   69 29 9 23         3     5   32 37         34   25   69
958305 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004017 132101060005 JAMES S EVANS ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_4 29.0 9.0 14.0         1.0     4.0   27.0 30.0     *       29     11   57 29 9 14         1     4   27 30         29   11   57
959160 NY Erie   school 3605850 140600010000   BUFFALO 360585003478 140600010001 DISCOVERY SCHOOL public Regular School No Elementary PK 8 2017   grade_4 39.0 9.0 8.0   0.0     0.0     4.0   28.0 32.0     *       28     18   60 39 9 8   0     0     4   28 32         28   18   60
959179 NY Erie   school 3605850 140600010000   BUFFALO 360585000318 140600010003 D'YOUVILLE-PORTER CAMPUS public Regular School No Elementary PK 8 2017   grade_4 5.0 9.0 60.0   0.0     4.0     1.0   41.0 38.0     38       70     16   79 5 9 60   0     4     1   41 38     38   70   16   79
967482 NY Kings   school 3601098 331400861036   CITIZENS OF THE WORLD CHARTE 360109806405 331400861036 CITIZENS OF THE WORLD CHARTER SCH 1 charter Regular School Yes Elementary KG 4 2017   grade_4 2.0 9.0 33.0         1.0     0.0   26.0 19.0     5       43     14   45 2 9 33         1     0   26 19     5   43   14   45
975481 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009702400 333200010106 PS 106 EDWARD EVERETT HALE public Regular School No Elementary PK 05 2017   grade_4 0.0 9.0 66.0         2.0         35.0 42.0     25       75     29   77 0 9 66         2         35 42     25   75   29   77

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