Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_4", state = "NY" and year = 2018 sorted by school_nces_id

View and edit SQL

year

  • 2018 · 4,722

grade

  • grade_4 · 4,722
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
2071953 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104498 211003040002 JAMES A GREEN HIGH SCHOOL public Regular School No High 09 12 2018   grade_4 0.0   0.0                   0.0 0.0     *       0     0   0 0   0                   0 0         0   0   0
2071934 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000104540 211003040001 DOLGEVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_4 66.0                       30.0 36.0             48     15   66 66                       30 36         48   15   66
2071972 NY Herkimer   school 3600001 211003040000   DOLGEVILLE 360000105991 211003040004 DOLGEVILLE MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_4 0.0             0.0         0.0 0.0             0     0   0 0             0         0 0         0   0   0
2103151 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204500 411603040003 SAUQUOIT VALLEY HIGH SCHOOL public Regular School No High 09 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2103132 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204541 411603040001 SAUQUOIT VALLEY ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2018   grade_4 57.0   1.0         1.0     0.0   28.0 31.0     0       31     6   59 57   1         1     0   28 31     0   31   6   59
2103170 NY Oneida   school 3600002 411603040000   SAUQUOIT VALLEY 360000204761 411603040004 SAUQUOIT VALLEY MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2121068 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304542 513102040001 EDWARDS-KNOX ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_4 29.0       0.0           1.0   16.0 14.0             20     7   30 29       0           1   16 14         20   7   30
2121087 NY Saint Lawrence   school 3600003 513102040000   EDWARDS-KNOX 360000304543 513102040002 EDWARDS-KNOX JUNIOR-SENIOR HS public Regular School No High 07 12 2018   grade_4 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
2122474 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404544 530515060003 DRAPER MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2122493 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404545 530515060004 MOHONASEN SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2122455 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2122512 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404577 530515060005 PINEWOOD ELEMENTARY SCHOOL public Regular School No Elementary 03 05 2018   grade_4 174.0 5.0 12.0   1.0     4.0     7.0   103.0 100.0     *       86     37   203 174 5 12   1     4     7   103 100         86   37   203
2070965 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000500282 171102040004 BROADALBIN-PERTH HIGH SCHOOL public Regular School No High 09 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2070927 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000500283 171102040002 LEARNING COMMUN-BROADALBIN-PERTH (TH public Regular School No Elementary PK 02 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2070946 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000503206 171102040003 BROADALBIN-PERTH MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2070908 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000504421 171102040001 BROADALBIN-PERTH INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2018   grade_4 131.0 3.0 2.0         1.0         67.0 70.0     *       80     10   137 131 3 2         1         67 70         80   10   137
2109763 NY Otsego   school 3600006 472202040000   CHERRY VLY-SPRGFLD 360000600525 472202040001 CHERRY VALLEY-SPRINGFIELD CENTRAL public Regular School No Other PK 12 2018   grade_4 23.0 1.0 1.0               0.0   11.0 14.0             *     *   25 23 1 1               0   11 14                 25
2123861 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000701357 572702040002 JASPER-TROUPSBURG JUNIOR-SENIOR HS public Regular School No High 07 12 2018   grade_4 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
2123842 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000703911 572702040001 JASPER-TROUPSBURG ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_4 26.0 1.0 0.0   0.0               17.0 10.0             *     6   27 26 1 0   0               17 10             6   27
2126578 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800192 580235060004 BELLPORT MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2126616 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800193 580235060006 BELLPORT SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2126559 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800194 580235060003 BROOKHAVEN ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2126597 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No Elementary 04 05 2018   grade_4 114.0 58.0 126.0   1.0     3.0     14.0   168.0 148.0     44       192     53   316 114 58 126   1     3     14   168 148     44   192   53   316
2126540 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800196 580235060002 KREAMER STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2126635 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800197 580235060007 VERNE W CRITZ ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2063384 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_4 42.0   2.0               0.0   27.0 17.0             17     5   44 42   2               0   27 17         17   5   44
2063403 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_4 63.0 1.0 0.0   0.0     1.0     0.0   39.0 26.0             29     11   65 63 1 0   0     1     0   39 26         29   11   65
2063422 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2063441 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_4 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
2122930 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000277 541102060004 WILLIAM H GOLDING MIDDLE SCHOOL public Regular School No Middle 06 09 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2122892 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000564 541102060001 GEORGE D RYDER ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2122911 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000566 541102060002 COBLESKILL-RICHMONDVILLE HIGH SCHOOL public Regular School No High 07 12 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2122949 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001001014 541102060005 JOSEPH B RADEZ ELEMENTARY SCHOOL public Regular School No Elementary 03 08 2018   grade_4 124.0 2.0 5.0   0.0     3.0     0.0   80.0 54.0     *       81     17   134 124 2 5   0     3     0   80 54         81   17   134
2123918 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101020 573002040001 WAYLAND-COHOCTON HIGH SCHOOL public Regular School No High 09 12 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2123937 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101026 573002040002 WAYLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_4 58.0   1.0         1.0     2.0   31.0 31.0             34     12   62 58   1         1     2   31 31         34   12   62
2123956 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101042 573002040003 WAYLAND-COHOCTON MIDDLE SCHOOL public Regular School No Middle 05 08 2018   grade_4 0.0 0.0           0.0     0.0   0.0 0.0     *       0     0   0 0 0           0     0   0 0         0   0   0
2123975 NY Steuben   school 3600011 573002040000   WAYLAND-COHOCTON 360001101445 573002040004 COHOCTON ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2018   grade_4 44.0   0.0                   23.0 21.0             29     5   44 44   0                   23 21         29   5   44
2051015 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No High 06 12 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2051034 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_4 47.0   1.0   0.0           2.0   23.0 27.0             33     11   50 47   1   0           2   23 27         33   11   50
2051053 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201103 22902040003 BOLIVAR-RICHBURG PRE-K PROGRAM public Regular School No Prekindergarten PK PK 2018   grade_4 0.0                   0.0   0.0 0.0                   *   0 0                   0   0 0                 0
2084265 NY Madison   school 3600013 251400010000   ONEIDA 360001301154 251400010002 DURHAMVILLE SCHOOL public Regular School No Elementary KG 05 2018   grade_4 34.0 1.0 3.0   1.0     0.0     1.0   22.0 18.0             19     11   40 34 1 3   1     0     1   22 18         19   11   40
2084284 NY Madison   school 3600013 251400010000   ONEIDA 360001301160 251400010003 NORTH BROAD STREET SCHOOL public Regular School No Elementary KG 05 2018   grade_4 35.0 0.0 1.0   3.0     1.0     2.0   16.0 26.0             29     6   42 35 0 1   3     1     2   16 26         29   6   42
2084303 NY Madison   school 3600013 251400010000   ONEIDA 360001301167 251400010005 SENECA STREET SCHOOL public Regular School No Elementary KG 05 2018   grade_4 34.0 0.0 0.0   1.0     2.0     1.0   19.0 19.0     *       10     *   38 34 0 0   1     2     1   19 19         10       38
2084322 NY Madison   school 3600013 251400010000   ONEIDA 360001301171 251400010006 W F PRIOR ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_4 24.0 1.0 1.0   3.0           3.0   11.0 21.0             21     10   32 24 1 1   3           3   11 21         21   10   32
2084341 NY Madison   school 3600013 251400010000   ONEIDA 360001301176 251400010008 OTTO L SHORTELL MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2084360 NY Madison   school 3600013 251400010000   ONEIDA 360001301199 251400010009 ONEIDA SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2123253 NY Seneca   school 3600014 561006060000   WATERLOO 360001401425 561006060001 WATERLOO HIGH SCHOOL public Regular School No High 09 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2123272 NY Seneca   school 3600014 561006060000   WATERLOO 360001401428 561006060002 LA FAYETTE SCHOOL public Regular School No Elementary 03 05 2018   grade_4 100.0 8.0 0.0         3.0     2.0   67.0 46.0     *       *     18   113 100 8 0         3     2   67 46             18   113
2123291 NY Seneca   school 3600014 561006060000   WATERLOO 360001401431 561006060003 WATERLOO MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2123310 NY Seneca   school 3600014 561006060000   WATERLOO 360001401442 561006060004 SKOI-YASE SCHOOL public Regular School No Elementary PK 02 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2060211 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2018   grade_4 64.0 0.0 0.0   0.0     1.0     6.0   33.0 38.0     *       31     *   71 64 0 0   0     1     6   33 38         31       71
2060192 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500053 40302060001 ALLEGANY-LIMESTONE MIDDLE-HIGH public Regular School No High 06 12 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2117534 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600110 491302060006 ALGONQUIN MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2117477 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600111 491302060002 AVERILL PARK HIGH SCHOOL public Regular School No High 09 12 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2117496 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600113 491302060004 POESTENKILL ES public Regular School No Elementary KG 05 2018   grade_4 60.0 0.0 1.0         1.0     3.0   33.0 32.0             17     8   65 60 0 1         1     3   33 32         17   8   65
2117458 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600114 491302060001 SAND LAKE-MILLER HILL SCHOOL public Regular School No Elementary KG 05 2018   grade_4 64.0   1.0   0.0     0.0     6.0   43.0 28.0             26     18   71 64   1   0     0     6   43 28         26   18   71
2117515 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600115 491302060005 WEST SAND LAKE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_4 60.0 0.0 2.0         0.0     2.0   27.0 37.0     0       17     11   64 60 0 2         0     2   27 37     0   17   11   64
2050787 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2018   grade_4 33.0 0.0 0.0   0.0     0.0     0.0   21.0 12.0             23     6   33 33 0 0   0     0     0   21 12         23   6   33
2061294 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801936 60503040001 CHAUTAUQUA LAKE SECONDARY SCHOOL public Regular School No High 07 12 2018   grade_4 0.0   0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0   0   0     0     0   0 0         0   0   0
2061313 NY Chautauqua   school 3600018 60503040000   CHAUTAUQUA LAKE 360001801938 60503040002 CHAUTAUQUA LAKE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_4 48.0 0.0 2.0               0.0   29.0 21.0             20     5   50 48 0 2               0   29 21         20   5   50
2062700 NY Chenango   school 3600019 81003040000   UNADILLA VALLEY 360001901976 81003040003 UNADILLA VALLEY SECONDARY SCHOOL public Regular School No High 05 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2062719 NY Chenango   school 3600019 81003040000   UNADILLA VALLEY 360001906369 81003040006 UNADILLA VALLEY ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_4 51.0 0.0 1.0   1.0     0.0     1.0   27.0 27.0             37     11   54 51 0 1   1     0     1   27 27         37   11   54
2123481 NY Steuben   school 3600020 570603040000   CAMPBELL-SAVONA 360002000325 570603040001 CAMPBELL-SAVONA ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_4 48.0 0.0 1.0   0.0     1.0     0.0   22.0 28.0             32     7   50 48 0 1   0     1     0   22 28         32   7   50
2123500 NY Steuben   school 3600020 570603040000   CAMPBELL-SAVONA 360002000326 570603040002 CAMPBELL-SAVONA JR/SR HIGH SCHOOL public Regular School No High 07 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2130359 NY Suffolk   school 3600021 581012020000   MATTITUCK 360002101704 581012020001 MATTITUCK JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2018   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2130378 NY Suffolk   school 3600021 581012020000   MATTITUCK 360002101705 581012020002 MATTITUCK-CUTCHOGUE ELEMENTARY SCH public Regular School No Elementary KG 06 2018   grade_4 61.0 2.0 10.0         1.0         33.0 41.0     *       20     10   74 61 2 10         1         33 41         20   10   74
2130739 NY Sullivan   school 3600023 591502040000   JEFF YOUNGSVILLE 360002301358 591502040004 SULLIVAN WEST HIGH SCHOOL public Regular School No High 07 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2130720 NY Sullivan   school 3600023 591502040000   JEFF YOUNGSVILLE 360002301493 591502040003 SULLIVAN WEST ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_4 55.0 0.0 7.0   0.0     1.0     3.0   34.0 32.0     *       28     13   66 55 0 7   0     1     3   34 32         28   13   66
2060325 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404322 42302040002 CATTARAUGUS-LITTLE VALLEY ELEMENTARY public Regular School No Elementary PK 04 2018   grade_4 51.0 2.0 1.0   0.0     0.0     1.0   29.0 26.0             28     6   55 51 2 1   0     0     1   29 26         28   6   55
2060344 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404324 42302040003 CATTARAUGUS-LITTLE VALLEY HS public Regular School No High 09 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2060363 NY Cattaraugus   school 3600024 42302040000   CATTARAUGUS 360002404857 42302040004 CATTARAUGUS-LITTLE VALLEY MIDDLE SCH public Regular School No Middle 05 08 2018   grade_4 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
2069768 NY Erie   school 3600025 142601860031   CHARTER SCHOOL FOR APPLIED TE 360002504349 142601860031 CHARTER SCHOOL FOR APPLIED TECHNOLOG charter Regular School Yes Other KG 12 2018   grade_4 34.0 52.0 39.0   1.0     6.0     5.0   68.0 69.0     *       124     17   137 34 52 39   1     6     5   68 69         124   17   137
2087153 NY Monroe   school 3600026 261600860811   EUGENIO MARIA DE HOSTOS CHART 360002604363 261600860811 EUGENIO MARIA DE HOSTOS CHARTER SCHO charter Regular School Yes Other KG 10 2018   grade_4 1.0 15.0 36.0   1.0     0.0     1.0   25.0 29.0     *       41     *   54 1 15 36   1     0     1   25 29         41       54
2087172 NY Monroe   school 3600029 261600860826   GENESEE COMM CHARTER SCHOOL 360002904376 261600860826 GENESEE COMM CHARTER SCHOOL charter Regular School Yes Elementary KG 06 2018   grade_4 17.0 7.0 1.0         1.0     5.0   16.0 15.0     *       10     *   31 17 7 1         1     5   16 15         10       31
2089338 NY Nassau   school 3600030 280208860024   ROOSEVELT CHILDREN'S ACAD CHA 360003004379 280208860024 ROOSEVELT CHILDREN'S ACAD CHARTER SC charter Regular School Yes Elementary KG 08 2018   grade_4 0.0 55.0 14.0         1.0     2.0   34.0 38.0     *       61     *   72 0 55 14         1     2   34 38         61       72
2049685 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2018   grade_4 0.0 42.0 10.0         0.0     0.0   52.0       0       46     7   52 0 42 10         0     0   52       0   46   7   52
2049704 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2018   grade_4 3.0 40.0 10.0         2.0     3.0     58.0     *       49     *   58 3 40 10         2     3     58         49       58
2067621 NY Erie   school 3600035 140600860814   KING CENTER CHARTER SCHOOL 360003504336 140600860814 KING CENTER CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2018   grade_4 0.0 42.0 1.0         7.0     1.0   20.0 31.0     *       49     *   51 0 42 1         7     1   20 31         49       51
2067640 NY Erie   school 3600036 140600860817   SOUTH BUFFALO CHARTER SCHOOL 360003604337 140600860817 SOUTH BUFFALO CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2018   grade_4 46.0 24.0 27.0   1.0     0.0     1.0   47.0 52.0     *       94     10   99 46 24 27   1     0     1   47 52         94   10   99
2067659 NY Erie   school 3600038 140600860838   TAPESTRY CHARTER SCHOOL 360003804346 140600860838 TAPESTRY CHARTER SCHOOL charter Regular School Yes Other KG 12 2018   grade_4 15.0 24.0 8.0   0.0     0.0     5.0   27.0 25.0     0       34     10   52 15 24 8   0     0     5   27 25     0   34   10   52
2099750 NY New York   school 3600039 310400860806   AMBER CHARTER SCHOOL 360003904439 310400860806 AMBER CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2018   grade_4 0.0 23.0 45.0   0.0     1.0     0.0   33.0 36.0     0       59     19   69 0 23 45   0     1     0   33 36     0   59   19   69
2054796 NY Bronx   school 3600042 320900860807   BRONX PREP CHARTER SCHOOL 360004204466 320900860807 BRONX PREP CHARTER SCHOOL charter Regular School Yes High 06 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2074651 NY Kings   school 3600045 331400860809   BROOKLYN CHARTER SCHOOL 360004504493 331400860809 BROOKLYN CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2018   grade_4 0.0 29.0 5.0   0.0     1.0         15.0 20.0     *       31     *   35 0 29 5   0     1         15 20         31       35
2073701 NY Kings   school 3600046 331300860810   COMM PARTNERSHIP CHARTER SCHO 360004604487 331300860810 COMMUNITY PARTNERSHIP CHARTER charter Regular School Yes Elementary PK 08 2018   grade_4 0.0 28.0 8.0   1.0     1.0     1.0   22.0 17.0     0       36     10   39 0 28 8   1     1     1   22 17     0   36   10   39
2099769 NY New York   school 3600047 310400860812   HARBOR SCI & ARTS CHARTER SCH 360004704413 310400860812 HARBOR SCI & ARTS CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2018   grade_4 0.0 17.0 8.0   0.0     1.0     0.0   12.0 14.0     0       22     9   26 0 17 8   0     1     0   12 14     0   22   9   26
2054815 NY Bronx   school 3600048 320900860823   HARRIET TUBMAN CHARTER SCHOOL 360004804457 320900860823 HARRIET TUBMAN CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2018   grade_4 2.0 48.0 25.0   0.0     0.0     0.0   35.0 40.0     7       63     12   75 2 48 25   0     0     0   35 40     7   63   12   75
2054834 NY Bronx   school 3600049 320900860835   ICAHN CHARTER SCHOOL 1 360004904470 320900860835 ICAHN CHARTER SCHOOL 1 charter Regular School Yes Elementary KG 08 2018   grade_4   17.0 21.0   0.0     0.0         15.0 23.0     *       34     *   38   17 21   0     0         15 23         34       38
2098021 NY New York   school 3600053 310200860819   JOHN V LINDSAY WILDCAT ACAD 360005304411 310200860819 JOHN V LINDSAY WILDCAT ACAD CHARTER charter Alternative School Yes High 09 12 2018   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2051889 NY Bronx   school 3600054 320700860820   KIPP ACADEMY CHARTER SCH 360005404452 320700860820 KIPP ACADEMY CHARTER SCHOOL charter Regular School Yes Other KG 12 2018   grade_4 1.0 46.0 44.0   0.0     0.0     0.0   45.0 46.0     8       91     17   91 1 46 44   0     0     0   45 46     8   91   17   91
2115976 NY Queens   school 3600055 342900860821   MERRICK ACADEMY-QUEENS PUBLIC 360005504777 342900860821 MERRICK ACADEMY-QUEENS PUBLIC CHARTE charter Regular School Yes Elementary KG 05 2018   grade_4 0.0 83.0 3.0   0.0     2.0     2.0   44.0 46.0     *       60     24   90 0 83 3   0     2     2   44 46         60   24   90
2116983 NY Queens   school 3600057 343000860836   OUR WORLD NEIGHBORHOOD CHARTE 360005704804 343000860836 OUR WORLD NEIGHBORHOOD CHARTER SCHOO charter Regular School Yes Elementary KG 08 2018   grade_4 29.0 6.0 36.0   0.0     12.0     0.0   37.0 46.0     *       64     7   83 29 6 36   0     12     0   37 46         64   7   83
2116964 NY Queens   school 3600059 343000860822   RENAISSANCE CHARTER SCHOOL 360005904803 343000860822 RENAISSANCE CHARTER SCHOOL charter Regular School Yes Other PK 12 2018   grade_4 4.0 0.0 14.0   0.0     7.0     1.0   9.0 17.0     *       19     *   26 4 0 14   0     7     1   9 17         19       26
2129485 NY Suffolk   school 3600060 580602860032   RIVERHEAD CHARTER SCHOOL 360006004847 580602860032 RIVERHEAD CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2018   grade_4 5.0 20.0 25.0         2.0     0.0   27.0 25.0     11       39     *   52 5 20 25         2     0   27 25     11   39       52
2098990 NY New York   school 3600061 310300860804   SISULU-WALKER CHARTER SCHOOL 360006104438 310300860804 SISULU-WALKER CHARTER SCHOOL charter Regular School Yes Elementary KG 05 2018   grade_4 0.0 26.0 2.0   0.0     0.0     0.0   14.0 14.0     0       26     9   28 0 26 2   0     0     0   14 14     0   26   9   28
2053333 NY Bronx   school 3600063 320800860846   BRONX CHARTER SCHOOL-ARTS 360006304875 320800860846 BRONX CHARTER SCHOOL FOR THE ARTS charter Regular School Yes Elementary KG 06 2018   grade_4 0.0 13.0 39.0   0.0     0.0         28.0 24.0     5       47     10   52 0 13 39   0     0         28 24     5   47   10   52
2054853 NY Bronx   school 3600066 320900860839   FAMILY LIFE ACAD CHARTER I 360006604877 320900860839 FAMILY LIFE ACADEMY CHARTER I charter Regular School Yes Elementary KG 05 2018   grade_4 0.0 5.0 43.0   1.0     1.0         23.0 27.0     9       41     6   50 0 5 43   1     1         23 27     9   41   6   50
2069160 NY Erie   school 3600067 141800860044   GLOBAL CONCEPTS CHARTER SCHOO 360006704861 141800860044 GLOBAL CONCEPTS CHARTER SCHOOL charter Regular School Yes Other KG 12 2018   grade_4 58.0 11.0 7.0   0.0     0.0     0.0   37.0 39.0     11       50     5   76 58 11 7   0     0     0   37 39     11   50   5   76
2099788 NY New York   school 3600068 310400860840   HARLEM PREP CHARTER SCHOOL 360006804870 310400860840 HARLEM PREP CHARTER SCHOOL charter Regular School Yes Other KG 10 2018   grade_4 2.0 46.0 35.0   1.0     1.0     2.0   48.0 39.0     *       73     15   87 2 46 35   1     1     2   48 39         73   15   87
2106305 NY Onondaga   school 3600070 421800860845   SOUTHSIDE ACADEMY CHARTER SC 360007004898 421800860845 SOUTHSIDE ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2018   grade_4 3.0 59.0 11.0   2.0     0.0         32.0 43.0     *       74     *   75 3 59 11   2     0         32 43         74       75
2067678 NY Erie   school 3600071 140600860851   BUFFALO UNITED CHARTER SCH 360007105538 140600860851 BUFFALO UNITED CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2018   grade_4 3.0 73.0 5.0   0.0     0.0         43.0 38.0     0       74     9   81 3 73 5   0     0         43 38     0   74   9   81

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