Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_2 · 33,045
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
815408 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034001871 500101060001 LITTLE TOR ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 39.0 1.0 7.0         5.0     1.0   28.0 25.0             *     *   53 39 1 7         5     1   28 25                 53
815465 NY Rockland   school 3620340 500101060000   CLARKSTOWN 362034001870 500101060007 LINK ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 41.0 3.0 7.0         6.0     0.0   31.0 26.0             *     9   57 41 3 7         6     0   31 26             9   57
816035 NY Rockland   school 3621480 500304030000   NYACK 362148003052 500304030004 UPPER NYACK SCHOOL public Regular School No 1 KG 07 2015   grade_2 26.0 14.0 11.0         5.0     3.0   21.0 38.0             *     5   59 26 14 11         5     3   21 38             5   59
816529 NY Rockland   school 3627810 500402060000   EAST RAMAPO 362781003769 500402060016 ELMWOOD ELEMENTARY SCHOOL public Regular School No 1 KG 06 2015   grade_2 8.0 0.0 0.0         0.0     0.0   5.0 3.0             *     8   8 8 0 0         0     0   5 3             8   8
818182 NY Saratoga   school 3630060 522101030000   WATERFORD 363006004041 522101030005 WATERFORD-HALFMOON ELEMENTARY public Regular School No 1 KG 06 2015   grade_2 45.0 0.0 1.0   0.0     1.0     1.0   30.0 18.0             *     *   48 45 0 1   0     1     1   30 18                 48
818220 NY Schenectady   school 3605940 520101060000   BURNT HILLS 360594000385 520101060002 CHARLTON HTS ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 69.0 0.0 1.0         1.0     1.0   35.0 37.0             *     17   72 69 0 1         1     1   35 37             17   72
818372 NY Schenectady   school 3626310 530202060000   SCOTIA GLENVILLE 362631003605 530202060002 GLENDAAL SCHOOL public Regular School No 1 KG 05 2015   grade_2 38.0 0.0 1.0         1.0     0.0   22.0 18.0             *     *   40 38 0 1         1     0   22 18                 40
818467 NY Schenectady   school 3620880 530301060000   NISKAYUNA 362088000276 530301060001 BIRCHWOOD ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 26.0 2.0 3.0         9.0     3.0   19.0 24.0             *     5   43 26 2 3         9     3   19 24             5   43
818524 NY Schenectady   school 3620880 530301060000   NISKAYUNA 362088002957 530301060004 HILLSIDE SCHOOL public Regular School No 1 KG 05 2015   grade_2 50.0 1.0 4.0         6.0     5.0   35.0 31.0             *     7   66 50 1 4         6     5   35 31             7   66
819151 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000564 541102060001 GEORGE D RYDER ELEMENTARY SCHOOL public Regular School No 1 PK 03 2015   grade_2 111.0 1.0 8.0         0.0     1.0   63.0 58.0             *     11   121 111 1 8         0     1   63 58             11   121
819170 NY Schoharie   school 3600010 541102060000   COBLSKL-RCHMDVL 360001000566 541102060002 COBLESKILL-RICHMONDVILLE HIGH SCHOOL public Regular School No 4 02 12 2015   grade_2 2.0 0.0 0.0         0.0     0.0   2.0 0.0             *     *   2 2 0 0         0     0   2 0                 2
820766 NY Suffolk   school 3608310 580105030000   COPIAGUE 360831000612 580105030002 GREAT NECK ROAD ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 13.0 17.0 47.0         1.0     0.0   37.0 41.0             *     *   78 13 17 47         1     0   37 41                 78
820861 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000064 580106030001 NORTHEAST SCHOOL public Regular School No 1 PK 02 2015   grade_2 0.0 0.0 1.0   0.0     0.0     0.0   0.0 1.0             *     *   1 0 0 1   0     0     0   0 1                 1
820899 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000066 580106030003 PARK AVENUE SCHOOL public Regular School No 4 02 09 2015   grade_2 0.0 0.0 1.0   0.0     0.0     0.0   1.0 0.0             *     *   1 0 0 1   0     0     0   1 0                 1
821146 NY Suffolk   school 3628200 580201060000   THREE VILLAGE 362820003804 580201060004 NASSAKEAG ELEMENTARY SCHOOL public Regular School No 1 KG 06 2015   grade_2 66.0 0.0 3.0         8.0     1.0   30.0 48.0             *     10   78 66 0 3         8     1   30 48             10   78
821222 NY Suffolk   school 3628200 580201060000   THREE VILLAGE 362820003803 580201060008 MINNESAUKE ELEMENTARY SCHOOL public Regular School No 1 KG 06 2015   grade_2 72.0 1.0 3.0         2.0     3.0   36.0 45.0             *     7   81 72 1 3         2     3   36 45             7   81
822229 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920001741 580211060017 NEW LANE MEMORIAL ELEMENTARY SCHOOL public Regular School No 1 01 06 2015   grade_2 115.0 2.0 35.0         11.0     9.0   78.0 94.0             *     *   172 115 2 35         11     9   78 94                 172
822248 NY Suffolk   school 3619200 580211060000   MIDDLE COUNTRY 361920004343 580211060018 UNITY DRIVE KINDERGARTEN-PRE K public Regular School No 1 PK 02 2015   grade_2 0.0 0.0 1.0         0.0     0.0   1.0 0.0             *     *   1 0 0 1         0     0   1 0                 1
822951 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800197 580235060007 VERNE W CRITZ ELEMENTARY SCHOOL public Regular School No 1 KG 03 2015   grade_2 47.0 8.0 28.0   1.0     3.0     4.0   43.0 48.0             *     *   91 47 8 28   1     3     4   43 48                 91
823027 NY Suffolk   school 3629760 580302080000   WAINSCOTT 362976003999 580302080001 WAINSCOTT SCHOOL public Regular School No 1 KG 03 2015   grade_2 0.0   2.0         0.0     0.0   0.0 2.0             *     *   2 0   2         0     0   0 2                 2
823103 NY Suffolk   school 3625380 580305020000   SAG HARBOR 362538003515 580305020001 SAG HARBOR ELEMENTARY SCHOOL public Regular School No 1 PK 05 2015   grade_2 68.0 2.0 19.0         0.0         42.0 47.0             *     *   89 68 2 19         0         42 47                 89
823236 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000574 580402060002 LLOYD HARBOR SCHOOL public Regular School No 1 02 06 2015   grade_2 58.0 0.0 3.0         3.0     3.0   30.0 37.0             *     *   67 58 0 3         3     3   30 37                 67
823255 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801000575 580402060003 WEST SIDE SCHOOL public Regular School No 1 02 06 2015   grade_2 40.0 0.0 2.0         2.0     1.0   23.0 22.0             *     *   45 40 0 2         2     1   23 22                 45
823293 NY Suffolk   school 3608010 580402060000   COLD SPRING HARBOR 360801001044 580402060005 GOOSEHILL PRIMARY CENTER public Regular School No 1 KG 01 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
823502 NY Suffolk   school 3621270 580404030000   NORTHPORT 362127003034 580404030004 NORWOOD AVENUE SCHOOL public Regular School No 1 KG 05 2015   grade_2 62.0 0.0 1.0         1.0     3.0   34.0 33.0             *     8   67 62 0 1         1     3   34 33             8   67
823521 NY Suffolk   school 3621270 580404030000   NORTHPORT 362127003035 580404030005 OCEAN AVENUE SCHOOL public Regular School No 1 KG 05 2015   grade_2 51.0 1.0 4.0   0.0     1.0     1.0   22.0 36.0             *     *   58 51 1 4   0     1     1   22 36                 58
823616 NY Suffolk   school 3621270 580404030000   NORTHPORT 362127003026 580404030011 BELLEROSE ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 57.0 0.0 6.0         1.0     0.0   39.0 25.0             *     7   64 57 0 6         1     0   39 25             7   64
823882 NY Suffolk   school 3608130 580410030000   COMMACK 360813004382 580410030005 INDIAN HOLLOW SCHOOL public Regular School No 1 KG 02 2015   grade_2 72.0   5.0         6.0     1.0   47.0 37.0             *     6   84 72   5         6     1   47 37             6   84
824395 NY Suffolk   school 3609720 580503030000   EAST ISLIP 360972000746 580503030001 CONNETQUOT ELEMENTARY SCHOOL public Regular School No 1 PK 02 2015   grade_2 91.0 4.0 26.0   0.0     1.0     5.0   59.0 68.0             *     14   127 91 4 26   0     1     5   59 68             14   127
824509 NY Suffolk   school 3625920 580504030000   SAYVILLE 362592003554 580504030001 CHERRY AVENUE ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 59.0 0.0 4.0         0.0     4.0   24.0 43.0             *     *   67 59 0 4         0     4   24 43                 67
824604 NY Suffolk   school 3604110 580505020000   BAYPORT BLUE POINT 360411000174 580505020002 BLUE POINT ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 30.0   1.0   0.0     0.0     1.0   16.0 16.0             *     6   32 30   1   0     0     1   16 16             6   32
825269 NY Suffolk   school 3605280 580512030000   BRENTWOOD 360528000257 580512030010 PINE PARK ELEMENTARY SCHOOL public Regular School No 1 KG 02 2015   grade_2 2.0 1.0 0.0   0.0     0.0     0.0   3.0 0.0             *     *   3 2 1 0   0     0     0   3 0                 3
825858 NY Suffolk   school 3626640 580701020000   SHELTER ISLAND 362664003632 580701020001 SHELTER ISLAND SCHOOL public Regular School No 4 PK 12 2015   grade_2 6.0 0.0 3.0               0.0   5.0 4.0             *     *   9 6 0 3               0   5 4                 9
826010 NY Suffolk   school 3627060 580801060000   SMITHTOWN 362706003677 580801060015 BRANCH BROOK ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 50.0 0.0 4.0         6.0     0.0   33.0 27.0             *     *   60 50 0 4         6     0   33 27                 60
826219 NY Suffolk   school 3624420 580901020000   REMSENBURG 362442003339 580901020001 REMSENBURG-SPEONK ELEMENTARY SCH public Regular School No 1 KG 06 2015   grade_2 19.0 1.0 3.0         0.0     0.0   9.0 14.0             *     *   23 19 1 3         0     0   9 14                 23
826580 NY Suffolk   school 3609900 580917020000   EAST QUOGUE 360990000764 580917020001 EAST QUOGUE SCHOOL public Regular School No 1 KG 06 2015   grade_2 42.0 2.0 17.0         0.0     1.0   30.0 32.0             *     7   62 42 2 17         0     1   30 32             7   62
826599 NY Suffolk   school 3621930 581002020000   OYSTERPONDS 362193003114 581002020001 OYSTERPONDS ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_2 9.0   4.0               2.0   7.0 8.0             *     *   15 9   4               2   7 8                 15
827150 NY Tioga   school 3630270 600101060000   WAVERLY 363027004068 600101060004 LINCOLN STREET ELEMENTARY SCHOOL public Regular School No 1 PK 02 2015   grade_2 2.0 0.0 0.0               0.0   1.0 1.0             *     *   2 2 0 0               0   1 1                 2
828898 NY Warren   school 3605010 630101040000   BOLTON 360501000240 630101040001 BOLTON CENTRAL SCHOOL public Regular School No 4 PK 12 2015   grade_2 6.0 0.0 0.0         0.0         3.0 3.0             *     0   6 6 0 0         0         3 3             0   6
829107 NY Warren   school 3613110 630801040000   HADLEY LUZERNE 361311001074 630801040002 HADLEY-LUZERNE ELEMENTARY SCHOOL public Regular School No 1 PK 02 2015   grade_2 40.0 0.0 4.0                   20.0 24.0             *     9   44 40 0 4                   20 24             9   44
829449 NY Washington   school 3613830 641001040000   HARTFORD 361383001129 641001040001 HARTFORD MIDDLE/HIGH SCHOOL public Regular School No 4 02 12 2015   grade_2 1.0 0.0 0.0         0.0     0.0   0.0 1.0             *     0   1 1 0 0         0     0   0 1             0   1
829582 NY Washington   school 3623970 641401040000   PUTNAM 362397003313 641401040001 PUTNAM CENTRAL SCHOOL public Regular School No 1 PK 06 2015   grade_2 3.0                       1.0 2.0             *     *   3 3                       1 2                 3
830095 NY Wayne   school 3622380 650901060000   PALMYRA-MACEDON 362238003151 650901060003 PALMYRA-MACEDON PRIMARY SCHOOL public Regular School No 1 KG 02 2015   grade_2 130.0 1.0 3.0   0.0     0.0     1.0   61.0 74.0             *     *   135 130 1 3   0     0     1   61 74                 135
830437 NY Westchester   school 3616080 660101030000   KATONAH LEWISBORO 361608001391 660101030002 KATONAH ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 55.0 2.0 9.0   0.0     3.0     0.0   27.0 42.0             *     12   69 55 2 9   0     3     0   27 42             12   69
830494 NY Westchester   school 3616080 660101030000   KATONAH LEWISBORO 361608001393 660101030006 MEADOW POND ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 55.0 1.0 3.0         1.0     1.0   29.0 32.0             *     9   61 55 1 3         1     1   29 32             9   61
830513 NY Westchester   school 3619950 660102060000   BEDFORD 361995004831 660102060001 BEDFORD VILLAGE ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 45.0 0.0 4.0         1.0     1.0   26.0 25.0             *     *   51 45 0 4         1     1   26 25                 51
830570 NY Westchester   school 3619950 660102060000   BEDFORD 361995001825 660102060004 POUND RIDGE ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 47.0   5.0         1.0     0.0   30.0 23.0             *     7   53 47   5         1     0   30 23             7   53
830836 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008004767 660301030004 WAVERLY EARLY CHLDHD CENTER public Regular School No 1 KG 01 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
830950 NY Westchester   school 3605640 660303030000   BRONXVILLE 360564000291 660303030002 BRONXVILLE 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
831026 NY Westchester   school 3628650 660401030000   TARRYTOWN 362865003891 660401030002 W L MORSE SCHOOL public Regular School No 1 01 02 2015   grade_2 56.0 7.0 134.0   0.0     3.0     7.0   98.0 109.0             *     *   207 56 7 134   0     3     7   98 109                 207
831330 NY Westchester   school 3603180 660405030000   ARDSLEY 360318000082 660405030003 CONCORD ROAD ELEMENTARY SCHOOL public Regular School No 1 KG 04 2015   grade_2 107.0 7.0 19.0         23.0     2.0   88.0 70.0             *     11   158 107 7 19         23     2   88 70             11   158
831577 NY Westchester   school 3612400 660410020000   GREENBURGH-GRAHAM 361240001008 660410020001 ZICCOLELLA ELEMENTARY SCHOOL public Special Education School No 4 KG 11 2015   grade_2 1.0 4.0 2.0   0.0     0.0         6.0 1.0             *     7   7 1 4 2   0     0         6 1             7   7
831615 NY Westchester   school 3610140 660411020000   GREENBURGH 11 361014000343 660411020002 GREENBURGH ELEVEN ELEMENTARY SCHOOL public Special Education School No 1 KG 07 2015   grade_2 0.0 0.0 1.0                   1.0               *     *   1 0 0 1                   1                   1
831805 NY Westchester   school 3613740 660501060000   HARRISON 361374001125 660501060005 PURCHASE SCHOOL public Regular School No 1 KG 05 2015   grade_2 53.0 1.0 0.0         3.0     2.0   31.0 28.0             *     11   59 53 1 0         3     2   31 28             11   59
831919 NY Westchester   school 3618240 660701030000   MAMARONECK 361824001649 660701030004 MURRAY AVENUE SCHOOL public Regular School No 1 KG 05 2015   grade_2 90.0   8.0         13.0     7.0   55.0 63.0             *     9   118 90   8         13     7   55 63             9   118
832052 NY Westchester   school 3623340 660802040000   POCANTICO HILLS 362334003267 660802040001 POCANTICO HILLS CENTRAL SCHOOL public Regular School No 1 PK 08 2015   grade_2 15.0 6.0 6.0   1.0     4.0     2.0   15.0 19.0             *     *   34 15 6 6   1     4     2   15 19                 34
832660 NY Westchester   school 3606990 661004060000   CHAPPAQUA 360699000487 661004060001 DOUGLAS G GRAFFLIN SCHOOL public Regular School No 1 KG 04 2015   grade_2 79.0 1.0 4.0         13.0     2.0   55.0 44.0             *     *   99 79 1 4         13     2   55 44                 99
832679 NY Westchester   school 3606990 661004060000   CHAPPAQUA 360699000489 661004060002 ROARING BROOK SCHOOL public Regular School No 1 KG 04 2015   grade_2 72.0 2.0 4.0   0.0     13.0     5.0   49.0 47.0             *     *   96 72 2 4   0     13     5   49 47                 96
832736 NY Westchester   school 3606990 661004060000   CHAPPAQUA 360699000491 661004060005 WESTORCHARD SCHOOL public Regular School No 1 KG 04 2015   grade_2 55.0 2.0 4.0   0.0     8.0     1.0   28.0 42.0             *     6   70 55 2 4   0     8     1   28 42             6   70
832869 NY Westchester   school 3620490 661100010000   NEW ROCHELLE 362049004400 661100010009 WILLIAM B WARD ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 72.0 33.0 49.0         9.0     0.0   88.0 75.0             *     21   163 72 33 49         9     0   88 75             21   163
833040 NY Westchester   school 3621180 661301040000   NORTH SALEM 362118002992 661301040002 PEQUENAKONCK ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 52.0 1.0 7.0         0.0     1.0   35.0 26.0             *     8   61 52 1 7         0     1   35 26             8   61
833192 NY Westchester   school 3605340 661402020000   BRIARCLIFF MANOR 360534000270 661402020001 TODD ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 73.0 4.0 8.0         15.0     1.0   61.0 40.0             *     *   101 73 4 8         15     1   61 40                 101
833230 NY Westchester   school 3605340 661402020000   BRIARCLIFF MANOR 360534002762 661402020004 BRIARCLIFF 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
833363 NY Westchester   school 3622680 661601030000   PELHAM 362268003185 661601030001 COLONIAL SCHOOL public Regular School No 1 KG 05 2015   grade_2 38.0 1.0 4.0         0.0     3.0   23.0 23.0             *     *   46 38 1 4         0     3   23 23                 46
833401 NY Westchester   school 3622680 661601030000   PELHAM 362268003189 661601030003 PROSPECT HILL SCHOOL public Regular School No 1 KG 05 2015   grade_2 46.0 2.0 3.0         1.0     1.0   31.0 22.0             *     6   53 46 2 3         1     1   31 22             6   53
833420 NY Westchester   school 3622680 661601030000   PELHAM 362268003190 661601030004 SIWANOY SCHOOL public Regular School No 1 KG 05 2015   grade_2 42.0 1.0 7.0         3.0     2.0   29.0 26.0             *     5   55 42 1 7         3     2   29 26             5   55
833477 NY Westchester   school 3625260 661800010000   RYE 362526003489 661800010001 MIDLAND SCHOOL public Regular School No 1 KG 05 2015   grade_2 76.0 1.0 1.0   0.0     6.0     1.0   51.0 34.0             *     *   85 76 1 1   0     6     1   51 34                 85
833496 NY Westchester   school 3625260 661800010000   RYE 362526003490 661800010002 MILTON SCHOOL public Regular School No 1 KG 05 2015   grade_2 67.0 0.0 1.0   0.0     7.0         39.0 36.0             *     8   75 67 0 1   0     7         39 36             8   75
833515 NY Westchester   school 3625260 661800010000   RYE 362526003491 661800010003 OSBORN SCHOOL public Regular School No 1 KG 05 2015   grade_2 82.0 1.0 5.0         16.0     2.0   59.0 47.0             *     5   106 82 1 5         16     2   59 47             5   106
833800 NY Westchester   school 3624630 661905020000   BLIND BROOK-RYE 362463005483 661905020003 BLIND BROOK-RYE 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
834921 NY Westchester   school 3616620 662401060000   LAKELAND 361662001477 662401060001 THOMAS JEFFERSON ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 59.0 2.0 15.0   2.0     3.0     3.0   33.0 51.0             *     10   84 59 2 15   2     3     3   33 51             10   84
834959 NY Westchester   school 3616620 662401060000   LAKELAND 361662001476 662401060004 LINCOLN TITUS ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 54.0 4.0 11.0   1.0     1.0     1.0   34.0 38.0             *     7   72 54 4 11   1     1     1   34 38             7   72
835035 NY Westchester   school 3616620 662401060000   LAKELAND 361662001471 662401060009 BENJAMIN FRANKLIN ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 57.0 3.0 9.0   0.0     2.0     1.0   38.0 34.0             *     9   72 57 3 9   0     2     1   38 34             9   72
942514 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 41.0 1.0 0.0         1.0     5.0   28.0 20.0             *     10   48 41 1 0         1     5   28 20             10   48
943008 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2017   grade_2 50.0 4.0 4.0   0.0     16.0     2.0   42.0 34.0     *       *     *   76 50 4 4   0     16     2   42 34                 76
946086 NY Bronx   school 3601096 320800861044   SUCCESS ACAD CHARTER SCH-BR 3 360109606390 320800861044 SUCCESS ACAD CHARTER SCH-BRONX 3 charter Regular School Yes Elementary KG 04 2017   grade_2 0.0 35.0 30.0   2.0     0.0     0.0   39.0 28.0     *       *     14   67 0 35 30   2     0     0   39 28             14   67
946143 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602073 320900010011 PS 11 HIGHBRIDGE public Regular School No Elementary KG 05 2017   grade_2 0.0 39.0 65.0   0.0     0.0     0.0   51.0 53.0     27       *     21   104 0 39 65   0     0     0   51 53     27       21   104
946200 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602160 320900010035 PS 35 FRANZ SIEGEL public Regular School No Elementary KG 05 2017   grade_2 2.0 23.0 65.0   0.0     1.0     0.0   42.0 49.0     28       *     24   91 2 23 65   0     1     0   42 49     28       24   91
946352 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602338 320900010088 PS 88 S SILVERSTEIN LITTLE SPARROW public Regular School No Elementary PK 03 2017   grade_2   8.0 23.0         0.0     0.0   13.0 18.0     5       *     *   31   8 23         0     0   13 18     5           31
949601 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008802364 321100010096 PS 96 RICHARD RODGERS public Regular School No Elementary KG 05 2017   grade_2 15.0 41.0 80.0   1.0     6.0     0.0   73.0 70.0     16       *     *   143 15 41 80   1     6     0   73 70     16           143
952432 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071006576 31501060007 LINNAEUS W WEST SCHOOL public Alternative School No Other 02 09 2017   grade_2 3.0 0.0 1.0               1.0   3.0 2.0             *     5   5 3 0 1               1   3 2             5   5
952546 NY Broome   school 3615900 31502060000   JOHNSON CITY 361590001374 31502060003 JOHNSON CITY ELEM/PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 94.0 20.0 18.0   1.0     13.0     19.0   85.0 80.0     13       *     11   165 94 20 18   1     13     19   85 80     13       11   165
953230 NY Cattaraugus   school 3607440 43011020000   RANDOLPH ACAD UFSD 360744004507 43011020001 RANDOLPH ACADEMY public Regular School No Other KG 12 2017   grade_2 0.0 0.0 1.0   2.0           0.0   3.0 0.0             *     *   3 0 0 1   2           0   3 0                 3
955415 NY Chenango   school 3621330 81200050000   NORWICH 362133003042 81200050002 STANFORD J GIBSON PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 121.0 2.0 2.0         0.0     5.0   82.0 48.0     *       *     28   130 121 2 2         0     5   82 48             28   130
956650 NY Cortland   school 3618840 110304040000   MCGRAW 361884001710 110304040001 MCGRAW ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 38.0   0.0               2.0   20.0 20.0             *     *   40 38   0               2   20 20                 40
958322 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988001118 132101060006 KINRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2017   grade_2 1.0 0.0 0.0         0.0     1.0   2.0 0.0             *     *   2 1 0 0         0     1   2 0                 2
958588 NY Erie   school 3602550 140101060000   ALDEN 360255000041 140101060003 ALDEN PRIMARY AT TOWNLINE public Regular School No Elementary KG 2 2017   grade_2 115.0 0.0 2.0               2.0   65.0 54.0     *       *     13   119 115 0 2               2   65 54             13   119
959709 NY Erie   school 3605850 140600010000   BUFFALO 360585000371 140600010084 PS 84 public Special Education School No Other KG 12 2017   grade_2 1.0 1.0 0.0         0.0     0.0   1.0 1.0     0       *     *   2 1 1 0         0     0   1 1     0           2
960906 NY Erie   school 3607590 140801060000   CLARENCE 360759004680 140801060005 SHERIDAN HILL ELEMENTARY SCHOOL public Regular School No Elementary KG 5 2017   grade_2 54.0 2.0 5.0         10.0     2.0   33.0 40.0     *       *     *   73 54 2 5         10     2   33 40                 73
961096 NY Erie   school 3610170 141201060000   EDEN 361017000790 141201060005 EDEN ELEMENTARY SCHOOL public Regular School No Elementary KG 8 2017   grade_2 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0             *     *   1 1 0 0   0     0     0   0 1                 1
961571 NY Erie   school 3611670 141604060000   FRONTIER 361167000924 141604060005 CLOVERBANK ELEMENTARY SCHOOL public Regular School No Elementary PK 5 2017   grade_2 66.0 1.0 2.0         0.0     4.0   35.0 38.0             *     *   73 66 1 2         0     4   35 38                 73
962521 NY Erie   school 3630780 142801060000   WEST SENECA 363078004147 142801060017 NORTHWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 4 2017   grade_2 66.0 9.0 4.0   0.0     7.0     3.0   49.0 40.0     9       *     *   89 66 9 4   0     7     3   49 40     9           89
962540 NY Erie   school 3630780 142801060000   WEST SENECA 363078004754 142801060018 WEST ELEMENTARY SCHOOL public Regular School No Elementary KG 5 2017   grade_2 93.0 0.0 1.0   0.0     0.0     4.0   52.0 46.0             *     *   98 93 0 1   0     0     4   52 46                 98
962673 NY Essex   school 3620730 151001040000   NEWCOMB 362073002918 151001040001 NEWCOMB CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 5.0   0.0         0.0         3.0 2.0             *     0   5 5   0         0         3 2             0   5
962711 NY Essex   school 3616500 151102040000   LAKE PLACID 361650001459 151102040002 LAKE PLACID ELEMENTARY SCHOOL public Regular School No Elementary KG 5 2017   grade_2 42.0   0.0         1.0     1.0   22.0 22.0     *       *     5   44 42   0         1     1   22 22             5   44
962996 NY Franklin   school 3625740 161401060000   SARANAC LAKE 362574003533 161401060001 PETROVA ELEMENTARY SCHOOL public Regular School No Elementary KG 5 2017   grade_2 53.0 1.0 2.0   0.0           1.0   32.0 25.0             *     *   57 53 1 2   0           1   32 25                 57
963376 NY Fulton   school 3615980 170600010000   JOHNSTOWN 361598001383 170600010004 PLEASANT AVENUE SCHOOL public Regular School No Elementary PK 3 2017   grade_2 3.0 0.0 0.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 3 0 0   0     0     0   2 1                 3
964364 NY Hamilton   school 3617760 200701040000   LONG LAKE 361776001601 200701040001 LONG LAKE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 4.0                       2.0 2.0             *     0   4 4                       2 2             0   4
964383 NY Hamilton   school 3630450 200901040000   WELLS 363045004096 200901040001 WELLS SCHOOL public Regular School No Other PK 12 2017   grade_2 4.0 0.0 0.0                   3.0 1.0             *     *   4 4 0 0                   3 1                 4
966169 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009105901 331300011492 ACADEMY OF ARTS AND LETTERS public Regular School No Elementary KG 8 2017   grade_2 31.0 10.0 2.0   1.0     2.0     9.0   26.0 29.0     *       *     9   55 31 10 2   1     2     9   26 29             9   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]);