Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_2" and state = "NY" sorted by district_nces_id descending

View and edit SQL

year

grade

  • grade_2 · 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
759377 NY Columbia   school   100308020000   BERKSHIRE   100308020002 COLUMBIA-GREENE PARTNERSHIP ACADEMY public           2015   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
987031 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   grade_2 2.0 9.0 19.0         4.0     0.0   25.0 9.0     *       26     34   34 2 9 19         4     0   25 9         26   34   34
1043670 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1047584 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1456654 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   grade_2 0.0 40.0 0.0   0.0     0.0     0.0   21.0 19.0     0       33     6   40 0 40 0   0     0     0   21 19     0   33   6   40
1555986 NY Kings   school   332300010000   NYC GEOG DIST #23 - BROOKLYN   331700011646 ASPIRATIONS DIPLOMA PLUS HIGH SCHOOL public           2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2067904 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   grade_2 0.0 0.0 0.0               0.0   0.0 0.0     0       0     0   0 0 0 0               0   0 0     0   0   0   0
2106341 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   grade_2 3.0 28.0 7.0         3.0     4.0   22.0 23.0     *       39     *   45 3 28 7         3     4   22 23         39       45
746742 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746761 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_2 46.0 0.0 1.0   0.0     1.0         24.0 24.0             28     *   48 46 0 1   0     1         24 24         28       48
746780 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
943559 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
943578 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 60.0 2.0 0.0         0.0     0.0   34.0 28.0             39     10   62 60 2 0         0     0   34 28         39   10   62
943597 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
1033277 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1033296 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   grade_2 59.0 0.0 1.0   0.0     0.0         29.0 31.0             40     12   60 59 0 1   0     0         29 31         40   12   60
1033315 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1434462 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2021   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1434481 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_2 38.0 4.0 2.0   0.0     2.0     1.0   25.0 22.0     *       31     9   47 38 4 2   0     2     1   25 22         31   9   47
1434500 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0             0     0   0 0 0 0   0     0         0 0         0   0   0
1524541 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2020   grade_2 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
1524560 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 53.0 2.0 1.0         0.0     0.0   27.0 29.0             35     19   56 53 2 1         0     0   27 29         35   19   56
1524579 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2050899 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2018   grade_2 0.0 0.0 0.0   0.0     0.0         0.0 0.0     *       0     0   0 0 0 0   0     0         0 0         0   0   0
2050918 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2018   grade_2 52.0 4.0 1.0         0.0     0.0   27.0 30.0             39     9   57 52 4 1         0     0   27 30         39   9   57
2050937 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_2 0.0 0.0 0.0   0.0               0.0 0.0     *       0     0   0 0 0 0   0               0 0         0   0   0
2140617 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2140636 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 50.0 1.0 1.0         0.0     1.0   33.0 20.0             30     9   53 50 1 1         0     1   33 20         30   9   53
2140655 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0         0.0         0.0 0.0             0     0   0 0 0 0         0         0 0         0   0   0
835073 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No 3 09 12 2015   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
835092 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No 2 06 08 2015   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
835111 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No 1 KG 03 2015   grade_2 94.0 4.0 19.0         9.0     2.0   68.0 60.0             12     13   128 94 4 19         9     2   68 60         12   13   128
835130 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No 2 04 05 2015   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
835149 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No 1 KG 03 2015   grade_2 90.0 1.0 16.0         9.0     4.0   56.0 64.0             9     18   120 90 1 16         9     4   56 64         9   18   120
1031358 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1031377 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1031396 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary KG 03 2017   grade_2 73.0 3.0 18.0         8.0     2.0   53.0 51.0     6       16     7   104 73 3 18         8     2   53 51     6   16   7   104
1031415 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2017   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1031434 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2017   grade_2 79.0 3.0 23.0         7.0     5.0   64.0 53.0     8       15     13   117 79 3 23         7     5   64 53     8   15   13   117
1121551 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121570 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121589 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No 1.0 KG 03 2016   grade_2 101.0 3.0 16.0         13.0     3.0   75.0 61.0             15     13   136 101 3 16         13     3   75 61         15   13   136
1121608 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No 2.0 04 05 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121627 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No 1.0 KG 03 2016   grade_2 73.0 3.0 20.0         2.0     2.0   50.0 50.0             9     16   100 73 3 20         2     2   50 50         9   16   100
1522603 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2021   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1522622 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1522641 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary KG 03 2021   grade_2 83.0 3.0 12.0         12.0     7.0   60.0 57.0     6       *     12   117 83 3 12         12     7   60 57     6       12   117
1522660 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2021   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
1522679 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2021   grade_2 79.0 1.0 21.0         3.0     0.0   62.0 42.0     7       11     14   104 79 1 21         3     0   62 42     7   11   14   104
1612720 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1612739 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1612758 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary KG 03 2020   grade_2 71.0 4.0 16.0         15.0     3.0   65.0 44.0     11       14     17   109 71 4 16         15     3   65 44     11   14   17   109
1612777 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2020   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
1612796 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2020   grade_2 95.0 5.0 21.0         8.0     2.0   58.0 73.0     8       13     14   131 95 5 21         8     2   58 73     8   13   14   131
2138698 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2018   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2138717 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2018   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2138736 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary KG 03 2018   grade_2 89.0 2.0 18.0         11.0     5.0   62.0 63.0     7       18     11   125 89 2 18         11     5   62 63     7   18   11   125
2138755 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2018   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2138774 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2018   grade_2 85.0 4.0 24.0         7.0     0.0   55.0 65.0     *       9     11   120 85 4 24         7     0   55 65         9   11   120
2228359 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2228378 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2228397 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary PK 03 2019   grade_2 78.0 6.0 17.0         7.0     5.0   66.0 47.0     *       19     16   113 78 6 17         7     5   66 47         19   16   113
2228416 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2019   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2228435 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2019   grade_2 88.0 0.0 19.0         5.0     1.0   47.0 66.0     *       9     8   113 88 0 19         5     1   47 66         9   8   113
780144 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No 1 KG 06 2015   grade_2 56.0   1.0         0.0     0.0   25.0 32.0             29     11   57 56   1         0     0   25 32         29   11   57
780163 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No 4 06 12 2015   grade_2 0.0 0.0           0.0     0.0   0.0 0.0             0     0   0 0 0           0     0   0 0         0   0   0
976638 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 48.0 0.0 0.0               0.0   25.0 23.0     0       20     8   48 48 0 0               0   25 23     0   20   8   48
976657 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 07 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
1066641 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2016   grade_2 46.0 0.0 2.0         0.0     0.0   29.0 19.0             25     *   48 46 0 2         0     0   29 19         25       48
1066660 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1467788 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_2 43.0 0.0 2.0   0.0     0.0     0.0   27.0 18.0     0       24     5   45 43 0 2   0     0     0   27 18     0   24   5   45
1467807 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2021   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
1557886 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 45.0 0.0 5.0   0.0           0.0   30.0 20.0     *       25     *   50 45 0 5   0           0   30 20         25       50
1557905 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 06 12 2020   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
2083940 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_2 52.0 2.0 2.0         0.0     1.0   34.0 23.0     5       32     *   57 52 2 2         0     1   34 23     5   32       57
2083959 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 07 12 2018   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2173620 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_2 55.0 0.0 0.0         0.0     1.0   32.0 24.0     0       33     9   56 55 0 0         0     1   32 24     0   33   9   56
2173639 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No High 07 12 2019   grade_2 0.0   0.0         0.0     0.0   0.0 0.0     *       0     0   0 0   0         0     0   0 0         0   0   0
834161 NY Westchester   school 3631920 662300010000   YONKERS 363192000452 662300010001 ROBERT C DODSON SCHOOL public Regular School No 1 PK 08 2015   grade_2 5.0 5.0 64.0         7.0     0.0   41.0 40.0             73     13   81 5 5 64         7     0   41 40         73   13   81
834180 NY Westchester   school 3631920 662300010000   YONKERS 363192001077 662300010002 FAMILY SCHOOL 32 public Regular School No 1 PK 08 2015   grade_2 10.0 9.0 32.0   0.0     1.0     1.0   35.0 18.0             39     14   53 10 9 32   0     1     1   35 18         39   14   53
834199 NY Westchester   school 3631920 662300010000   YONKERS 363192001527 662300010004 MONTESSORI SCHOOL 31 public Regular School No 1 PK 06 2015   grade_2 19.0 5.0 17.0   0.0     4.0     1.0   22.0 24.0             27     10   46 19 5 17   0     4     1   22 24         27   10   46
834218 NY Westchester   school 3631920 662300010000   YONKERS 363192004252 662300010005 SCHOOL 5 public Regular School No 1 PK 08 2015   grade_2 16.0 12.0 47.0   0.0     5.0     0.0   38.0 42.0             60     12   80 16 12 47   0     5     0   38 42         60   12   80
834237 NY Westchester   school 3631920 662300010000   YONKERS 363192001920 662300010007 FOXFIRE SCHOOL public Regular School No 1 PK 08 2015   grade_2 6.0 14.0 30.0         1.0     0.0   28.0 23.0             47     11   51 6 14 30         1     0   28 23         47   11   51
834256 NY Westchester   school 3631920 662300010000   YONKERS 363192004254 662300010008 PATRICIA A DICHIARO SCHOOL public Regular School No 1 PK 08 2015   grade_2 41.0 3.0 15.0   0.0     1.0     0.0   32.0 28.0             22     15   60 41 3 15   0     1     0   32 28         22   15   60
834275 NY Westchester   school 3631920 662300010000   YONKERS 363192004255 662300010009 SCHOOL 9 public Regular School No 1 PK 06 2015   grade_2 4.0 17.0 23.0   0.0     4.0     0.0   23.0 25.0             45     *   48 4 17 23   0     4     0   23 25         45       48
834294 NY Westchester   school 3631920 662300010000   YONKERS 363192004258 662300010013 SCHOOL 13 public Regular School No 1 PK 08 2015   grade_2 5.0 12.0 73.0   2.0     1.0     1.0   45.0 49.0             89     17   94 5 12 73   2     1     1   45 49         89   17   94
834313 NY Westchester   school 3631920 662300010000   YONKERS 363192004259 662300010014 ROSMARIE ANN SIRAGUSA SCHOOL public Regular School No 1 PK 06 2015   grade_2 16.0 17.0 45.0         6.0     4.0   42.0 46.0             67     11   88 16 17 45         6     4   42 46         67   11   88
834332 NY Westchester   school 3631920 662300010000   YONKERS 363192003452 662300010015 PAIDEIA SCHOOL 15 public Regular School No 1 PK 08 2015   grade_2 39.0 1.0 13.0   1.0     1.0     3.0   33.0 25.0             12     20   58 39 1 13   1     1     3   33 25         12   20   58
834351 NY Westchester   school 3631920 662300010000   YONKERS 363192004260 662300010016 SCHOOL 16 public Regular School No 1 PK 08 2015   grade_2 10.0 18.0 46.0   0.0     4.0     0.0   35.0 43.0             63     13   78 10 18 46   0     4     0   35 43         63   13   78
834370 NY Westchester   school 3631920 662300010000   YONKERS 363192004261 662300010017 SCHOOL 17 public Regular School No 1 PK 06 2015   grade_2 12.0 24.0 54.0   0.0     5.0     0.0   55.0 40.0             67     17   95 12 24 54   0     5     0   55 40         67   17   95
834389 NY Westchester   school 3631920 662300010000   YONKERS 363192004262 662300010018 SCHOLASTIC ACAD FOR ACAD EXCELLENCE public Regular School No 1 PK 08 2015   grade_2 2.0 14.0 56.0   0.0     0.0     0.0   40.0 32.0             68     5   72 2 14 56   0     0     0   40 32         68   5   72
834408 NY Westchester   school 3631920 662300010000   YONKERS 363192004263 662300010019 EUGENIO MARIA DE HOSTOS MICROSOCIETY public Regular School No 1 PK 08 2015   grade_2 5.0 5.0 45.0   0.0     2.0         31.0 26.0             55     9   57 5 5 45   0     2         31 26         55   9   57
834427 NY Westchester   school 3631920 662300010000   YONKERS 363192004264 662300010021 SCHOOL 21 public Regular School No 1 PK 06 2015   grade_2 16.0 13.0 45.0   2.0     4.0     1.0   42.0 39.0             68     7   81 16 13 45   2     4     1   42 39         68   7   81
834446 NY Westchester   school 3631920 662300010000   YONKERS 363192004265 662300010022 SCHOOL 22 public Regular School No 1 PK 06 2015   grade_2 14.0 15.0 39.0   1.0     1.0     1.0   35.0 36.0             57     18   71 14 15 39   1     1     1   35 36         57   18   71
834465 NY Westchester   school 3631920 662300010000   YONKERS 363192004266 662300010023 SCHOOL 23 public Regular School No 1 PK 08 2015   grade_2 11.0 21.0 47.0         2.0     0.0   39.0 42.0             72     15   81 11 21 47         2     0   39 42         72   15   81
834484 NY Westchester   school 3631920 662300010000   YONKERS 363192002802 662300010024 PAIDEIA SCHOOL 24 public Regular School No 1 PK 06 2015   grade_2 9.0 9.0 30.0   0.0     2.0     1.0   24.0 27.0             39     7   51 9 9 30   0     2     1   24 27         39   7   51
834503 NY Westchester   school 3631920 662300010000   YONKERS 363192004267 662300010025 MUSEUM SCHOOL 25 public Regular School No 1 PK 06 2015   grade_2 0.0 19.0 16.0         1.0     0.0   21.0 15.0             31     11   36 0 19 16         1     0   21 15         31   11   36
834522 NY Westchester   school 3631920 662300010000   YONKERS 363192004268 662300010026 CASIMIR PULASKI SCHOOL public Regular School No 1 PK 08 2015   grade_2 28.0 3.0 23.0   0.0     5.0     1.0   33.0 27.0             21     11   60 28 3 23   0     5     1   33 27         21   11   60
834541 NY Westchester   school 3631920 662300010000   YONKERS 363192004269 662300010027 MONTESSORI SCHOOL 27 public Regular School No 1 PK 06 2015   grade_2 10.0 6.0 23.0   1.0     2.0     0.0   21.0 21.0             27     5   42 10 6 23   1     2     0   21 21         27   5   42
834560 NY Westchester   school 3631920 662300010000   YONKERS 363192004270 662300010028 KAHLIL GIBRAN SCHOOL public Regular School No 1 PK 08 2015   grade_2 16.0 13.0 22.0         4.0     0.0   26.0 29.0             37     *   55 16 13 22         4     0   26 29         37       55

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