Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_2" and state = "NY" sorted by multiracial 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
745906 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No 1.0 KG 05 2015   grade_2 44.0 5.0 6.0   0.0     0.0     9.0   39.0 25.0             48     11   64 44 5 6   0     0     9   39 25         48   11   64
755159 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000224 30200010002 CALVIN COOLIDGE SCHOOL public Regular School No 1.0 PK 05 2015   grade_2 17.0 14.0 6.0   0.0     1.0     9.0   23.0 24.0             31     7   47 17 14 6   0     1     9   23 24         31   7   47
755330 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000229 30200010022 HORACE MANN SCHOOL public Regular School No 1.0 KG 05 2015   grade_2 19.0 18.0 6.0   1.0     1.0     9.0   26.0 28.0             46     10   54 19 18 6   1     1     9   26 28         46   10   54
755501 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No 1.0 PK 03 2015   grade_2 128.0 1.0 3.0   1.0     2.0     9.0   72.0 72.0             68     19   144 128 1 3   1     2     9   72 72         68   19   144
755672 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000846 31501060001 CHARLES F JOHNSON JR ELEMENTARY SCH public Regular School No 1.0 KG 05 2015   grade_2 31.0 17.0 6.0         1.0     9.0   32.0 32.0             52     7   64 31 17 6         1     9   32 32         52   7   64
756679 NY Cayuga   school 3603480 50100010000   AUBURN 360348000102 50100010002 CASEY PARK ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_2 57.0 1.0 5.0         1.0     9.0   39.0 34.0             51     8   73 57 1 5         1     9   39 34         51   8   73
762721 NY Erie   school 3605850 140600010000   BUFFALO 360585000350 140600010059 PS 59 DR CHARLES DREW SCI MAGNET public Regular School No 1 PK 8 2015   grade_2 7.0 61.0 8.0   0.0     8.0     9.0   51.0 42.0             88     34   93 7 61 8   0     8     9   51 42         88   34   93
762968 NY Erie   school 3605850 140600010000   BUFFALO 360585004506 140600010093 SOUTHSIDE ELEMENTARY SCHOOL public Regular School No 1 PK 8 2015   grade_2 70.0 26.0 21.0   1.0     9.0     9.0   88.0 48.0             124     34   136 70 26 21   1     9     9   88 48         124   34   136
768782 NY Jefferson   school 3606630 222201060000   CARTHAGE 360663000444 222201060005 CARTHAGE ELEMENTARY SCHOOL public Regular School No 1 KG 4 2015   grade_2 73.0 5.0 8.0   1.0     0.0     9.0   50.0 46.0             50     18   96 73 5 8   1     0     9   50 46         50   18   96
781113 NY Monroe   school 3612630 260501060000   GREECE 361263001034 260501060016 HOLMES ROAD ELEMENTARY SCHOOL public Regular School No 1 PK 02 2015   grade_2 69.0 12.0 20.0         3.0     9.0   59.0 54.0             69     12   113 69 12 20         3     9   59 54         69   12   113
781322 NY Monroe   school 3609690 260801060000   EAST IRONDEQUOIT 360969004717 260801060011 HELENDALE ROAD PRIMARY SCHOOL public Regular School No 1 PK 02 2015   grade_2 44.0 17.0 23.0         3.0     9.0   46.0 50.0             54     6   96 44 17 23         3     9   46 50         54   6   96
782196 NY Monroe   school 3623160 261401060000   PITTSFORD 362316004744 261401060005 MENDON CENTER ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 98.0 3.0 6.0         18.0     9.0   75.0 59.0             *     14   134 98 3 6         18     9   75 59             14   134
783640 NY Monroe   school 3625170 261701060000   RUSH HENRIETTA 362517003486 261701060004 MONICA B LEARY ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 74.0 14.0 6.0         9.0     9.0   50.0 62.0             26     7   112 74 14 6         9     9   50 62         26   7   112
783716 NY Monroe   school 3625170 261701060000   RUSH HENRIETTA 362517004566 261701060012 EMMA E SHERMAN ELEMENTARY SCHOOL public Regular School No 1 PK 05 2015   grade_2 63.0 2.0 7.0   1.0     8.0     9.0   47.0 43.0             28     12   90 63 2 7   1     8     9   47 43         28   12   90
786642 NY Nassau   school 3611760 280218030000   GARDEN CITY 361176000947 280218030004 STRATFORD AVENUE SCHOOL public Regular School No 1 02 05 2015   grade_2 124.0 0.0 6.0         4.0     9.0   66.0 77.0             *     13   143 124 0 6         4     9   66 77             13   143
787915 NY Nassau   school 3617730 280300010000   LONG BEACH 361773001600 280300010004 WEST ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 32.0 5.0 14.0         2.0     9.0   28.0 34.0             22     10   62 32 5 14         2     9   28 34         22   10   62
792361 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702433 310200010116 PS 116 MARY LINDLEY MURRAY public Regular School No 1 PK 05 2015   grade_2 50.0 14.0 21.0   1.0     17.0     9.0   51.0 61.0             42     16   112 50 14 21   1     17     9   51 61         42   16   112
800607 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121002995 420303060002 KARL W SAILE BEAR ROAD ELEM SCHOOL public Regular School No 1 KG 04 2015   grade_2 98.0 6.0 5.0   0.0     3.0     9.0   65.0 56.0             47     21   121 98 6 5   0     3     9   65 56         47   21   121
800664 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121003003 420303060007 ROXBORO ROAD ELEMENTARY SCHOOL public Regular School No 1 KG 04 2015   grade_2 86.0 8.0 8.0   1.0     1.0     9.0   54.0 59.0             76     22   113 86 8 8   1     1     9   54 59         76   22   113
802051 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003846 421800010004 BELLEVUE ELEMENTARY SCHOOL public Regular School No 1 PK 05 2015   grade_2 13.0 41.0 15.0   0.0     0.0     9.0   33.0 45.0             69     14   78 13 41 15   0     0     9   33 45         69   14   78
802165 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003877 421800010013 SALEM HYDE ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_2 34.0 21.0 7.0   1.0     1.0     9.0   39.0 34.0             50     18   73 34 21 7   1     1     9   39 34         50   18   73
803647 NY Orange   school 3623010 440401060000   PINE BUSH 362301004820 440401060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No 1 KG 05 2015   grade_2 93.0 5.0 8.0   1.0     1.0     9.0   63.0 54.0             48     11   117 93 5 8   1     1     9   63 54         48   11   117
804540 NY Orange   school 3623520 441800050000   PORT JERVIS 362352003283 441800050001 ANNA S KUHL ELEMENTARY SCHOOL public Regular School No 1 KG 06 2015   grade_2 78.0 17.0 22.0   0.0     4.0     9.0   63.0 67.0             93     *   130 78 17 22   0     4     9   63 67         93       130
806516 NY Putnam   school 3605310 480601060000   BREWSTER 360531000267 480601060004 JOHN F KENNEDY ELEMENTARY SCHOOL public Regular School No 1 KG 02 2015   grade_2 144.0 4.0 86.0   1.0     6.0     9.0   114.0 136.0             89     24   250 144 4 86   1     6     9   114 136         89   24   250
812501 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010202451 343000010122 PS 122 MAMIE FAY public Regular School No 1 PK 08 2015   grade_2 61.0 21.0 40.0   0.0     46.0     9.0   93.0 84.0             95     31   177 61 21 40   0     46     9   93 84         95   31   177
818676 NY Schenectady   school 3600004 530515060000   MOHONASEN 360000404576 530515060001 HERMAN L BRADT ELEMENTARY SCHOOL public Regular School No 1 KG 02 2015   grade_2 192.0 3.0 10.0   0.0     3.0     9.0   109.0 108.0             97     36   217 192 3 10   0     3     9   109 108         97   36   217
818923 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003581 530600010018 JESSIE T ZOLLER SCHOOL public Regular School No 1 01 08 2015   grade_2 23.0 9.0 11.0         5.0     9.0   30.0 27.0             40     9   57 23 9 11         5     9   30 27         40   9   57
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
822875 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800194 580235060003 BROOKHAVEN ELEMENTARY SCHOOL public Regular School No 1 PK 03 2015   grade_2 54.0 27.0 57.0   4.0     6.0     9.0   79.0 78.0             101     21   157 54 27 57   4     6     9   79 78         101   21   157
827758 NY Tompkins   school 3615570 610600010000   ITHACA 361557001342 610600010011 NORTHEAST SCHOOL public Regular School No 1 KG 05 2015   grade_2 31.0 8.0 3.0   0.0     20.0     9.0   36.0 35.0             20     6   71 31 8 3   0     20     9   36 35         20   6   71
942191 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 5.0 43.0 21.0   0.0     7.0     9.0   53.0 32.0     11       60     *   85 5 43 21   0     7     9   53 32     11   60       85
942685 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2017   grade_2 41.0 2.0 9.0   0.0     0.0     9.0   33.0 28.0     *       29     10   61 41 2 9   0     0     9   33 28         29   10   61
951881 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000224 30200010002 CALVIN COOLIDGE SCHOOL public Regular School No Elementary PK 05 2017   grade_2 19.0 13.0 2.0         0.0     9.0   23.0 20.0             34     6   43 19 13 2         0     9   23 20         34   6   43
952394 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000846 31501060001 CHARLES F JOHNSON JR ELEMENTARY SCH public Regular School No Elementary KG 05 2017   grade_2 42.0 12.0 13.0   0.0     1.0     9.0   39.0 38.0     *       64     *   77 42 12 13   0     1     9   39 38         64       77
956175 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 81.0 1.0 12.0   0.0     0.0     9.0   50.0 53.0     *       69     8   103 81 1 12   0     0     9   50 53         69   8   103
957752 NY Dutchess   school 3623760 131500010000   POUGHKEEPSIE 362376003306 131500010009 MORSE YOUNG MAGNET SCHOOL public Regular School No Elementary KG 05 2017   grade_2 9.0 54.0 42.0   1.0     1.0     9.0   60.0 56.0     14       107     20   116 9 54 42   1     1     9   60 56     14   107   20   116
957847 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000093 131601060004 OVERLOOK PRIMARY SCHOOL public Regular School No Elementary KG 02 2017   grade_2 69.0 8.0 16.0         9.0     9.0   48.0 63.0     11       42     14   111 69 8 16         9     9   48 63     11   42   14   111
959538 NY Erie   school 3605850 140600010000   BUFFALO 360585000356 140600010065 PS 65 ROOSEVELT ACADEMY ECC public Regular School No Elementary PK 4 2017   grade_2 27.0 23.0 24.0   0.0     5.0     9.0   54.0 34.0     8       74     32   88 27 23 24   0     5     9   54 34     8   74   32   88
962274 NY Erie   school 3616230 142601030000   KENMORE 361623004396 142601030020 THOMAS A EDISON ELEMENTARY SCHOOL public Regular School No Elementary KG 4 2017   grade_2 106.0 2.0 8.0   0.0     0.0     9.0   63.0 62.0             44     19   125 106 2 8   0     0     9   63 62         44   19   125
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
977417 NY Monroe   school 3612630 260501060000   GREECE 361263001030 260501060006 ENGLISH VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 68.0 22.0 22.0   0.0     3.0     9.0   55.0 69.0     6       85     *   124 68 22 22   0     3     9   55 69     6   85       124
977759 NY Monroe   school 3609690 260801060000   EAST IRONDEQUOIT 360969000745 260801060005 IVAN L GREEN PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_2 62.0 19.0 37.0         3.0     9.0   70.0 60.0     9       86     8   130 62 19 37         3     9   70 60     9   86   8   130
988551 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007702152 310200010033 PS 33 CHELSEA PREP public Regular School No Elementary PK 05 2017   grade_2 32.0 17.0 30.0   0.0     24.0     9.0   54.0 58.0     7       44     18   112 32 17 30   0     24     9   54 58     7   44   18   112
991021 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802677 310300010199 PS 199 JESSIE ISADOR STRAUS public Regular School No Elementary KG 05 2017   grade_2 100.0 2.0 22.0   0.0     28.0     9.0   83.0 78.0     8       *     33   161 100 2 22   0     28     9   83 78     8       33   161
994536 NY Niagara   school 3617670 400400010000   LOCKPORT 361767001584 400400010005 GEORGE SOUTHARD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2017   grade_2 70.0 4.0 13.0   1.0     3.0     9.0   57.0 43.0     7       49     20   100 70 4 13   1     3     9   57 43     7   49   20   100
994745 NY Niagara   school 3620850 400701060000   NIAGARA WHEATFIELD 362085002948 400701060004 COLONIAL VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 63.0 2.0 1.0   1.0     0.0     9.0   35.0 41.0             51     10   76 63 2 1   1     0     9   35 41         51   10   76
994821 NY Niagara   school 3600164 400701860890   NIAGARA CHARTER SCHOOL 360016405887 400701860890 NIAGARA CHARTER SCHOOL charter Regular School Yes Elementary KG 06 2017   grade_2 7.0 25.0 8.0   2.0           9.0   18.0 33.0             41     6   51 7 25 8   2           9   18 33         41   6   51
996759 NY Onondaga   school 3630630 420101060000   WEST GENESEE 363063004116 420101060003 STONEHEDGE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 144.0 2.0 6.0   0.0     1.0     9.0   88.0 74.0     *       40     24   162 144 2 6   0     1     9   88 74         40   24   162
997424 NY Onondaga   school 3607320 420701060000   WESTHILL 360732000521 420701060002 CHERRY ROAD ELEMENTARY SCHOOL public Regular School No Elementary 02 04 2017   grade_2 94.0 4.0 5.0   1.0     3.0     9.0   53.0 63.0     *       32     *   116 94 4 5   1     3     9   53 63         32       116
998203 NY Onondaga   school 3617520 421501060000   LIVERPOOL 361752004720 421501060019 WILLOW FIELD ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_2 50.0 4.0 3.0   0.0     1.0     9.0   32.0 35.0             26     8   67 50 4 3   0     1     9   32 35         26   8   67
998355 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003881 421800010006 VAN DUYN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 12.0 44.0 5.0   1.0     1.0     9.0   41.0 31.0     *       63     20   72 12 44 5   1     1     9   41 31         63   20   72
998431 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003867 421800010012 LEMOYNE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 25.0 17.0 6.0   1.0     17.0     9.0   35.0 40.0     24       62     17   75 25 17 6   1     17     9   35 40     24   62   17   75
998735 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003869 421800010042 MCKINLEY-BRIGHTON ELEMENTARY public Regular School No Elementary PK 05 2017   grade_2 10.0 71.0 6.0   1.0     1.0     9.0   54.0 44.0     9       92     21   98 10 71 6   1     1     9   54 44     9   92   21   98
1000654 NY Orange   school 3620700 441600010000   NEWBURGH 362070002908 441600010009 HORIZON-ON-THE-HUDSON MAGNET SCHOOL public Regular School No Elementary PK 05 2017   grade_2 5.0 33.0 29.0         5.0     9.0   40.0 41.0     16       71     19   81 5 33 29         5     9   40 41     16   71   19   81
1010230 NY Rensselaer   school 3628950 491700010000   TROY 362895003913 491700010002 PS 2 public Regular School No Elementary KG 05 2017   grade_2 6.0 28.0 14.0         0.0     9.0   35.0 22.0     *       56     21   57 6 28 14         0     9   35 22         56   21   57
1015322 NY Schenectady   school 3626010 530600010000   SCHENECTADY 362601003591 530600010026 VAN CORLAER ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 23.0 15.0 11.0         4.0     9.0   29.0 33.0     *       55     *   62 23 15 11         4     9   29 33         55       62
1018932 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869004674 580232030005 TANGIER SMITH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 55.0 23.0 30.0   0.0     2.0     9.0   62.0 57.0     6       84     15   119 55 23 30   0     2     9   62 57     6   84   15   119
1020072 NY Suffolk   school 3613620 580406060000   HARBORFIELDS 361362001450 580406060001 WASHINGTON DRIVE PRIM SCH public Regular School No Elementary KG 02 2017   grade_2 136.0 10.0 38.0         8.0     9.0   111.0 90.0     13       40     39   201 136 10 38         8     9   111 90     13   40   39   201
1024689 NY Ulster   school 3618570 621001060000   MARLBORO 361857005841 621001060006 MARLBORO ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 93.0 10.0 32.0         3.0     9.0   83.0 64.0     5       71     29   147 93 10 32         3     9   83 64     5   71   29   147
1037609 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702121 321000010024 PS 24 SPUYTEN DUYVIL public Regular School No 1.0 KG 05 2016   grade_2 63.0 8.0 70.0   2.0     12.0     9.0   79.0 85.0             44     *   164 63 8 70   2     12     9   79 85         44       164
1042264 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000846 31501060001 CHARLES F JOHNSON JR ELEMENTARY SCH public Regular School No 1.0 KG 05 2016   grade_2 42.0 11.0 8.0   0.0     1.0     9.0   30.0 41.0             52     8   71 42 11 8   0     1     9   30 41         52   8   71
1042891 NY Cattaraugus   school 3621720 42400010000   OLEAN 362172003083 42400010002 WASHINGTON WEST ELEMENTARY SCHOOL public Regular School No 1.0 PK 03 2016   grade_2 51.0 5.0 7.0   0.0     1.0     9.0   40.0 33.0             53     7   73 51 5 7   0     1     9   40 33         53   7   73
1042967 NY Cattaraugus   school 3612390 42801060000   GOWANDA 361239001005 42801060001 GOWANDA ELEMENTARY SCHOOL public Regular School No 1.0 PK 04 2016   grade_2 47.0 0.0 4.0   20.0     0.0     9.0   37.0 43.0             56     17   80 47 0 4   20     0     9   37 43         56   17   80
1047128 NY Dutchess   school 3604140 130200010000   BEACON 360414000181 130200010006 SARGENT SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 26.0 10.0 14.0         1.0     9.0   34.0 26.0             29     19   60 26 10 14         1     9   34 26         29   19   60
1048192 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004025 132101060007 VASSAR ROAD ELEMENTARY SCHOOL public Regular School No 1.0 KG 3 2016   grade_2 59.0 7.0 6.0         3.0     9.0   49.0 35.0             27     14   84 59 7 6         3     9   49 35         27   14   84
1051840 NY Erie   school 3621900 142301060000   ORCHARD PARK 362190004529 142301060003 EGGERT ROAD ELEMENTARY SCHOOL public Regular School No 1.0 KG 5 2016   grade_2 80.0 0.0 2.0   0.0     4.0     9.0   46.0 49.0             14     15   95 80 0 2   0     4     9   46 49         14   15   95
1055374 NY Jefferson   school 3606630 222201060000   CARTHAGE 360663000444 222201060005 CARTHAGE ELEMENTARY SCHOOL public Regular School No 1.0 KG 4 2016   grade_2 62.0 5.0 10.0   0.0     0.0     9.0   49.0 37.0             53     15   86 62 5 10   0     0     9   49 37         53   15   86
1055450 NY Kings   school 3600091 331300010000   NYC GEOG DIST #13 - BROOKLYN 360009102064 331300010008 PS 8 ROBERT FULTON public Regular School No 1.0 KG 8 2016   grade_2 77.0 8.0 18.0   0.0     11.0     9.0   66.0 57.0             12     19   123 77 8 18   0     11     9   66 57         12   19   123
1057768 NY Kings   school 3600092 331500010000   NYC GEOG DIST #15 - BROOKLYN 360009202557 331500010154 WINDSOR TERRACE SCHOOL (THE) public Regular School No 1.0 KG 5 2016   grade_2 58.0 3.0 18.0   0.0     1.0     9.0   42.0 47.0             11     20   89 58 3 18   0     1     9   42 47         11   20   89
1068560 NY Monroe   school 3610890 261301060000   FAIRPORT 361089000859 261301060010 DUDLEY SCHOOL public Regular School No 1.0 KG 02 2016   grade_2 191.0 7.0 11.0   0.0     2.0     9.0   117.0 103.0             58     21   220 191 7 11   0     2     9   117 103         58   21   220
1072892 NY Nassau   school 3610620 280216020000   ELMONT 361062000833 280216020003 COVERT AVENUE SCHOOL public Regular School No 1.0 PK 06 2016   grade_2 16.0 11.0 46.0   0.0     20.0     9.0   52.0 50.0             65     10   102 16 11 46   0     20     9   52 50         65   10   102
1079200 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701219 310200010290 PS 290 MANHATTAN NEW SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 72.0 0.0 11.0   0.0     15.0     9.0   49.0 58.0             *     20   107 72 0 11   0     15     9   49 58             20   107
1080872 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007802327 310300010084 PS 84 LILLIAN WEBER public Regular School No 1.0 PK 05 2016   grade_2 36.0 10.0 40.0   1.0     1.0     9.0   46.0 51.0             50     21   97 36 10 40   1     1     9   46 51         50   21   97
1087560 NY Onondaga   school 3627150 420702030000   SOLVAY 362715003698 420702030001 SOLVAY ELEMENTARY SCHOOL public Regular School No 1.0 PK 03 2016   grade_2 95.0 4.0 6.0   0.0           9.0   47.0 67.0             82     12   114 95 4 6   0           9   47 67         82   12   114
1088434 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003881 421800010006 VAN DUYN ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 15.0 42.0 4.0   2.0     0.0     9.0   37.0 35.0             61     11   72 15 42 4   2     0     9   37 35         61   11   72
1088453 NY Onondaga   school 3628590 421800010000   SYRACUSE 362859003856 421800010008 EDWARD SMITH K-8 SCHOOL public Regular School No 1.0 PK 08 2016   grade_2 29.0 26.0 6.0   0.0     0.0     9.0   33.0 37.0             30     14   70 29 26 6   0     0     9   33 37         30   14   70
1089783 NY Orange   school 3607380 440201020000   CHESTER 360738000526 440201020002 CHESTER ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 33.0 5.0 18.0         4.0     9.0   31.0 38.0             30     11   69 33 5 18         4     9   31 38         30   11   69
1090258 NY Orange   school 3619320 441000010000   MIDDLETOWN 361932006448 441000010018 PRESIDENTIAL PARK ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 40.0 38.0 170.0   0.0     9.0     9.0   129.0 137.0             217     29   266 40 38 170   0     9     9   129 137         217   29   266
1091284 NY Orleans   school 3618960 450801060000   MEDINA 361896001717 450801060002 OAK ORCHARD SCHOOL public Regular School No 1.0 PK 03 2016   grade_2 87.0 11.0 7.0   1.0     0.0     9.0   65.0 50.0             80     15   115 87 11 7   1     0     9   65 50         80   15   115
1092880 NY Putnam   school 3605310 480601060000   BREWSTER 360531000267 480601060004 JOHN F KENNEDY ELEMENTARY SCHOOL public Regular School No 1.0 KG 02 2016   grade_2 110.0 5.0 94.0   0.0     5.0     9.0   122.0 101.0             82     18   223 110 5 94   0     5     9   122 101         82   18   223
1096927 NY Queens   school 3600100 342800010000   NYC GEOG DIST #28 - QUEENS 360010002384 342800010101 PS 101 SCHOOL IN THE GARDENS public Regular School No 1.0 PK 06 2016   grade_2 48.0 3.0 8.0   0.0     28.0     9.0   43.0 53.0             14     15   96 48 3 8   0     28     9   43 53         14   15   96
1102475 NY Rockland   school 3621480 500304030000   NYACK 362148003050 500304030002 LIBERTY ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 34.0 11.0 30.0         2.0     9.0   44.0 42.0             30     11   86 34 11 30         2     9   44 42         30   11   86
1109163 NY Suffolk   school 3618690 580232030000   WILLIAM FLOYD 361869005743 580232030011 NATHANIEL WOODHULL ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 71.0 13.0 38.0   0.0     3.0     9.0   65.0 69.0             73     19   134 71 13 38   0     3     9   65 69         73   19   134
1110246 NY Suffolk   school 3613620 580406060000   HARBORFIELDS 361362001450 580406060001 WASHINGTON DRIVE PRIM SCH public Regular School No 1.0 KG 02 2016   grade_2 177.0 12.0 34.0   1.0     6.0     9.0   129.0 110.0             35     41   239 177 12 34   1     6     9   129 110         35   41   239
1110645 NY Suffolk   school 3604080 580501030000   BAY SHORE 360408000170 580501030003 MARY G CLARKSON SCHOOL public Regular School No 1.0 KG 02 2016   grade_2 61.0 28.0 86.0   0.0     8.0     9.0   105.0 87.0             108     34   192 61 28 86   0     8     9   105 87         108   34   192
1114502 NY Ulster   school 3616290 620600010000   KINGSTON 361629001429 620600010011 CHAMBERS SCHOOL public Regular School No 1.0 KG 04 2016   grade_2 30.0 12.0 23.0   0.0     3.0     9.0   33.0 44.0             50     16   77 30 12 23   0     3     9   33 44         50   16   77
1114521 NY Ulster   school 3616290 620600010000   KINGSTON 361629001432 620600010012 GEORGE WASHINGTON SCHOOL public Regular School No 1.0 PK 04 2016   grade_2 16.0 9.0 17.0         1.0     9.0   23.0 29.0             41     10   52 16 9 17         1     9   23 29         41   10   52
1115015 NY Ulster   school 3621840 621201060000   ONTEORA 362184003105 621201060004 WOODSTOCK ELEMENTARY SCHOOL public Regular School No 1.0 KG 03 2016   grade_2 43.0 1.0 2.0         2.0     9.0   21.0 36.0             26     *   57 43 1 2         2     9   21 36         26       57
1117618 NY Westchester   school 3609120 660403030000   DOBBS FERRY 360912000703 660403030001 SPRINGHURST ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 55.0 5.0 26.0         9.0     9.0   52.0 52.0             19     13   104 55 5 26         9     9   52 52         19   13   104
1117770 NY Westchester   school 3603180 660405030000   ARDSLEY 360318000082 660405030003 CONCORD ROAD ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2016   grade_2 89.0 7.0 24.0         29.0     9.0   78.0 80.0             10     13   158 89 7 24         29     9   78 80         10   13   158
1119119 NY Westchester   school 3606990 661004060000   CHAPPAQUA 360699000487 661004060001 DOUGLAS G GRAFFLIN SCHOOL public Regular School No 1.0 KG 04 2016   grade_2 70.0 0.0 1.0         12.0     9.0   53.0 39.0             *     8   92 70 0 1         12     9   53 39             8   92
1433759 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_2 34.0 2.0 10.0   1.0     7.0     9.0   32.0 31.0     9       24     *   63 34 2 10   1     7     9   32 31     9   24       63
1433797 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2021   grade_2 36.0 8.0 5.0         13.0     9.0   36.0 35.0     10       26     8   71 36 8 5         13     9   36 35     10   26   8   71
1438927 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702121 321000010024 PS 24 SPUYTEN DUYVIL public Regular School No Elementary KG 05 2021   grade_2 44.0 17.0 56.0   1.0     15.0     9.0   68.0 74.0     10       46     22   142 44 17 56   1     15     9   68 74     10   46   22   142
1443183 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000232 30200010012 THEODORE ROOSEVELT SCHOOL public Regular School No Elementary PK 05 2021   grade_2 19.0 13.0 11.0   0.0     2.0     9.0   27.0 27.0     *       45     10   54 19 13 11   0     2     9   27 27         45   10   54
1443202 NY Broome   school 3604870 30200010000   BINGHAMTON 360487000235 30200010014 WOODROW WILSON SCHOOL public Regular School No Elementary KG 05 2021   grade_2 22.0 16.0 7.0         3.0     9.0   30.0 27.0     7       54     *   57 22 16 7         3     9   30 27     7   54       57
1443449 NY Broome   school 3607290 30701060000   CHENANGO VALLEY 360729000040 30701060004 PORT DICKINSON ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2021   grade_2 107.0 0.0 3.0         2.0     9.0   60.0 61.0     *       61     9   121 107 0 3         2     9   60 61         61   9   121
1444323 NY Cattaraugus   school 3612390 42801060000   GOWANDA 361239001005 42801060001 GOWANDA ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2021   grade_2 48.0   2.0   24.0           9.0   37.0 46.0             49     16   83 48   2   24           9   37 46         49   16   83
1444646 NY Cayuga   school 3603480 50100010000   AUBURN 360348000102 50100010002 CASEY PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   grade_2 51.0 6.0 2.0         1.0     9.0   33.0 36.0             54     10   69 51 6 2         1     9   33 36         54   10   69
1450783 NY Erie   school 3605850 140600010000   BUFFALO 360585000369 140600010081 PS 81 public Regular School No Elementary PK 08 2021   grade_2 21.0 29.0 12.0   0.0     7.0     9.0   44.0 34.0     *       55     16   78 21 29 12   0     7     9   44 34         55   16   78

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