Data source: Big Local News · About: Big Local

4,742 rows where grade = "grade_2", state = "NY" and year = 2020 sorted by school

View and edit SQL

year

  • 2020 · 4,642

grade

  • grade_2 · 4,642
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
1609167 NY Westchester   school 3610650 660409020000   ELMSFORD 361065000838 660409020002 ALICE E GRADY ELEMENTARY SCHOOL public Regular School No Elementary 02 06 2020   grade_2 2.0 14.0 41.0         5.0     1.0   32.0 31.0     11       37     *   63 2 14 41         5     1   32 31     11   37       63
1557164 NY Kings   school 3600097 333200010000   NYC GEOG DIST #32 - BROOKLYN 360009705537 333200011554 ALL CITY LEADERSHIP SECONDARY SCH 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     0     0   0 0     0   0   0   0
1534041 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500052 40302060002 ALLEGANY-LIMESTONE ELEMENTARY public Regular School No Elementary PK 05 2020   grade_2 51.0 5.0 1.0   0.0     1.0     4.0   34.0 28.0     *       41     9   62 51 5 1   0     1     4   34 28         41   9   62
1534022 NY Cattaraugus   school 3600015 40302060000   ALLEGANY-LIMESTONE 360001500053 40302060001 ALLEGANY-LIMESTONE MIDDLE-HIGH 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         0   0   0
1598356 NY Suffolk   school 3617380 580104030000   LINDENHURST 361738001542 580104030002 ALLEGHANY AVENUE SCHOOL public Regular School No Elementary KG 05 2020   grade_2 29.0 2.0 10.0         2.0     2.0   26.0 19.0     *       19     20   45 29 2 10         2     2   26 19         19   20   45
1559881 NY Monroe   school 3623160 261401060000   PITTSFORD 362316003235 261401060001 ALLEN CREEK SCHOOL public Regular School No Elementary KG 05 2020   grade_2 39.0 1.0 0.0         4.0     4.0   24.0 24.0     *       *     *   48 39 1 0         4     4   24 24                 48
1578121 NY Onondaga   school 3621210 420303060000   NORTH SYRACUSE 362121002994 420303060001 ALLEN ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_2 64.0 1.0 2.0   0.0     9.0     8.0   45.0 39.0     9       36     11   84 64 1 2   0     9     8   45 39     9   36   11   84
1543655 NY Erie   school 3630780 142801060000   WEST SENECA 363078004140 142801060003 ALLENDALE ELMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 77.0 1.0 5.0   0.0     0.0     7.0   42.0 48.0             34     14   90 77 1 5   0     0     7   42 48         34   14   90
1524142 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_2 40.0 3.0 2.0   0.0     1.0     3.0   24.0 25.0     *       19     7   49 40 3 2   0     1     3   24 25         19   7   49
1582529 NY Oswego   school 3602820 460102040000   ALTMAR-PARISH 360282006344 460102040007 ALTMAR-PARISH-WILLIAMSTOWN ELEMEN public Regular School No Elementary PK 06 2020   grade_2 68.0 1.0 0.0   0.0     0.0     1.0   38.0 32.0             47     18   70 68 1 0   0     0     1   38 32         47   18   70
1582510 NY Oswego   school 3602820 460102040000   ALTMAR-PARISH 360282000055 460102040006 ALTMAR-PARISH-WILLIAMSTOWN JR/SR HS public Regular School No High 07 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
1562351 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001153 280201030010 ALVERTA B GRAY SCHULTZ MIDDLE SCH 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
1600750 NY Suffolk   school 3602880 580303020000   AMAGANSETT 360288000059 580303020001 AMAGANSETT SCHOOL public Regular School No Elementary PK 06 2020   grade_2 3.0 0.0 2.0               0.0   1.0 4.0     0             *   5 3 0 2               0   1 4     0           5
1610269 NY Westchester   school 3601051 660900861000   AMANI PUBLIC CHARTER SCHOOL 360105106291 660900861000 AMANI PUBLIC CHARTER SCHOOL charter Regular School Yes Middle 05 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
1573656 NY New York   school 3600039 310400860806   AMBER CHARTER EAST HARLEM 360003904439 310400860806 AMBER CHARTER SCHOOL EAST HARLEM charter Regular School Yes Elementary KG 05 2020   grade_2 1.0 29.0 64.0   1.0     2.0     0.0   53.0 44.0     6       82     18   97 1 29 64   1     2     0   53 44     6   82   18   97
1530469 NY Bronx   school 3601149 321000861074   AMBER CHARTER KINGSBRIDGE 360114906588 321000861074 AMBER CHARTER SCHOOL KINGSBRIDGE charter Regular School Yes Elementary KG 04 2020   grade_2 1.0 10.0 84.0   0.0     1.0     2.0   54.0 44.0     *       75     17   98 1 10 84   0     1     2   54 44         75   17   98
1525776 NY Bronx   school 3601119 320700861062   AMERICAN DREAM CHARTER SCHOO 360111906495 320700861062 AMERICAN DREAM CHARTER SCHOOL charter Regular School Yes Secondary 06 11 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
1569913 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007704454 310200010047 AMERICAN SIGN LANG & ENG SECONDAR public Special Education 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
1539855 NY Erie   school 3602920 140201060000   AMHERST 360292000061 140201060002 AMHERST CENTRAL 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
1539836 NY Erie   school 3602920 140201060000   AMHERST 360292004335 140201060001 AMHERST 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
1575138 NY New York   school 3600083 310600010000   NYC GEOG DIST # 6 - MANHATTAN 360008305643 310600010311 AMISTAD DUAL LANGUAGE SCHOOL public Regular School No Elementary KG 08 2020   grade_2 3.0 0.0 50.0         0.0     1.0   26.0 28.0     21       45     14   54 3 0 50         0     1   26 28     21   45   14   54
1598679 NY Suffolk   school 3602940 580106030000   AMITYVILLE 360294000063 580106030005 AMITYVILLE MEMORIAL 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
1529671 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705993 321000010344 AMPARK NEIGHBORHOOD public Regular School No Elementary PK 05 2020   grade_2 16.0 9.0 26.0   0.0     1.0     2.0   32.0 22.0     *       28     16   54 16 9 26   0     1     2   32 22         28   16   54
1561857 NY Montgomery   school 3602970 270100010000   AMSTERDAM 360297000068 270100010010 AMSTERDAM 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
1572554 NY New York   school 3600078 310300010000   NYC GEOG DIST # 3 - MANHATTAN 360007805773 310300010334 ANDERSON SCHOOL (THE) public Regular School No Elementary KG 08 2020   grade_2 26.0 0.0 5.0         14.0     13.0   29.0 29.0             *     *   58 26 0 5         14     13   29 29                 58
1538031 NY Delaware   school 3603000 120102040000   ANDES 360300000076 120102040001 ANDES CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_2 9.0 0.0 1.0               0.0   5.0 5.0             *     *   10 9 0 1               0   5 5                 10
1524408 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2020   grade_2 21.0 0.0 0.0         0.0     0.0   10.0 11.0             10     0   21 21 0 0         0     0   10 11         10   0   21
1534953 NY Cayuga   school 3629250 51901040000   UNION SPRINGS 362925003935 51901040002 ANDREW J SMITH ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 55.0 0.0 1.0         1.0     3.0   32.0 28.0     0       31     7   60 55 0 1         1     3   32 28     0   31   7   60
1599553 NY Suffolk   school 3619410 580208020000   MILLER PLACE 361941001774 580208020002 ANDREW MULLER PRIMARY SCHOOL public Regular School No Elementary KG 02 2020   grade_2 142.0 2.0 12.0   0.0     1.0     2.0   76.0 83.0     6       20     28   159 142 2 12   0     1     2   76 83     6   20   28   159
1603220 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687000471 580513030007 ANDREW T MORROW SCHOOL public Regular School No Elementary KG 06 2020   grade_2 4.0 18.0 87.0         2.0     1.0   64.0 48.0     60       82     12   112 4 18 87         2     1   64 48     60   82   12   112
1555492 NY Kings   school 3600153 332200010000   NYC GEOG DIST #22 - BROOKLYN 360015302755 332200010240 ANDRIES HUDDE 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
1529804 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703812 321000010391 ANGELO PATRI MIDDLE SCHOOL (THE) 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
1533699 NY Broome   school 3610710 31501060000   UNION-ENDICOTT 361071000845 31501060014 ANN G MCGUINNESS ELEMENTARY public Regular School No Elementary KG 05 2020   grade_2 34.0 4.0 1.0   1.0     1.0     6.0   19.0 28.0     *       11     *   47 34 4 1   1     1     6   19 28         11       47
1567025 NY Nassau   school 3617700 280503060000   LOCUST VALLEY 361770001591 280503060004 ANN MACARTHUR PRIMARY public Regular School No Elementary KG 02 2020   grade_2 51.0 1.0 17.0         5.0         35.0 39.0     5       16     6   74 51 1 17         5         35 39     5   16   6   74
1575784 NY Niagara   school 3617670 400400010000   LOCKPORT 361767001579 400400010001 ANNA MERRITT ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_2 39.0 10.0 6.0   0.0           9.0   34.0 30.0             52     8   64 39 10 6   0           9   34 30         52   8   64
1560299 NY Monroe   school 3624750 261600010000   ROCHESTER 362475003386 261600010012 ANNA MURRAY-DOUGLASS ACADEMY public Regular School No Elementary KG 08 2020   grade_2 12.0 26.0 32.0   0.0     3.0     3.0   36.0 40.0     28       62     10   76 12 26 32   0     3     3   36 40     28   62   10   76
1582016 NY Orange   school 3623520 441800050000   PORT JERVIS 362352003283 441800050001 ANNA S KUHL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   grade_2 93.0 9.0 29.0   2.0     1.0     7.0   65.0 76.0     *       97     23   141 93 9 29   2     1     7   65 76         97   23   141
1608445 NY Westchester   school 3610080 660301030000   EASTCHESTER 361008000783 660301030001 ANNE HUTCHINSON SCHOOL public Regular School No Elementary 02 06 2020   grade_2 69.0 3.0 23.0   0.0     17.0     4.0   57.0 59.0     15       *     15   116 69 3 23   0     17     4   57 59     15       15   116
1610782 NY Westchester   school 3622020 661401030000   OSSINING 362202003118 661401030006 ANNE M DORNER 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
1603258 NY Suffolk   school 3606870 580513030000   CENTRAL ISLIP 360687001061 580513030009 ANTHONY ALFANO ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_2 5.0 12.0 46.0   0.0     4.0         40.0 27.0     26       54     12   67 5 12 46   0     4         40 27     26   54   12   67
1526821 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505984 320800011376 ANTONIA PANTOJA PREP ACADEMY 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 0     0   0   0   0
1546163 NY Jefferson   school 3615300 220301060000   INDIAN RIVER 361530001286 220301060001 ANTWERP PRIMARY SCHOOL public Regular School No Elementary KG 03 2020   grade_2 34.0 2.0 6.0   1.0     1.0     4.0   23.0 25.0             26     *   48 34 2 6   1     1     4   23 25         26       48
1604968 NY Tioga   school 3622170 600601060000   OWEGO-APALACHIN 362217003136 600601060001 APALACHIN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 73.0 2.0 1.0               0.0   39.0 37.0             35     6   76 73 2 1               0   39 37         35   6   76
1603391 NY Suffolk   school 3624690 580602040000   RIVERHEAD 362469003354 580602040003 AQUEBOGUE ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2020   grade_2 37.0 8.0 51.0         3.0     2.0   46.0 55.0     27       55     15   101 37 8 51         3     2   46 55     27   55   15   101
1523211 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 1.0 31.0 9.0         1.0     1.0   22.0 21.0     *       38     *   43 1 31 9         1     1   22 21         38       43
1534573 NY Cattaraugus   school 3608970 43501060000   YORKSHRE-PIONEER 360897000683 43501060005 ARCADE ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2020   grade_2 109.0 1.0 2.0         2.0     0.0   64.0 50.0     *       61     28   114 109 1 2         2     0   64 50         61   28   114
1558741 NY Monroe   school 3612630 260501060000   GREECE 361263001031 260501060010 ARCADIA 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
1558893 NY Monroe   school 3612630 260501060000   GREECE 361263000475 260501060023 ARCADIA 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
1532540 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006266 321200010531 ARCHER ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 1.0 11.0 46.0   1.0     11.0     1.0   45.0 26.0     20       67     28   71 1 11 46   1     11     1   45 26     20   67   28   71
1563320 NY Nassau   school 3611550 280209030000   FREEPORT 361155000909 280209030001 ARCHER STREET SCHOOL public Regular School No Elementary KG 04 2020   grade_2 7.0 26.0 95.0   0.0           1.0   68.0 61.0     52       109     31   129 7 26 95   0           1   68 61     52   109   31   129
1526802 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505985 320800011367 ARCHIMEDES ACAD-MATH, SCI, TECH 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     0     0   0 0     0   0   0   0
1608939 NY Westchester   school 3603180 660405030000   ARDSLEY 360318000080 660405030001 ARDSLEY 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
1608958 NY Westchester   school 3603180 660405030000   ARDSLEY 360318000081 660405030002 ARDSLEY MIDDLE SCHOOL public Regular School No Middle 05 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
1606944 NY Washington   school 3603210 640101040000   ARGYLE 360321004850 640101040002 ARGYLE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_2 24.0 0.0 1.0         0.0     0.0   12.0 13.0             11     *   25 24 0 1         0     0   12 13         11       25
1606925 NY Washington   school 3603210 640101040000   ARGYLE 360321000083 640101040001 ARGYLE JUNIOR/SENIOR HIGH SCHOOL public Regular School No High 07 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
1597824 NY Steuben   school 3603240 571901040000   ARKPORT 360324000085 571901040004 ARKPORT CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_2 33.0 0.0 1.0   0.0     1.0     1.0   15.0 21.0     *       16     8   36 33 0 1   0     1     1   15 21         16   8   36
1539057 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000088 131601060008 ARLINGTON 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
1542667 NY Erie   school 3613350 141601060000   HAMBURG 361335001095 141601060001 ARMOR ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_2 44.0 0.0 2.0   1.0     2.0     0.0   23.0 26.0     *       16     *   49 44 0 2   1     2     0   23 26         16       49
1595259 NY Saratoga   school 3626670 520302060000   SHENENDEHOWA 362667003633 520302060003 ARONGEN ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_2 74.0 7.0 14.0         5.0     9.0   57.0 52.0     5       28     12   109 74 7 14         5     9   57 52     5   28   12   109
1598869 NY Suffolk   school 3628200 580201060000   THREE VILLAGE 362820003802 580201060003 ARROWHEAD ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_2 58.0 3.0 6.0         11.0     5.0   44.0 39.0     *       13     17   83 58 3 6         11     5   44 39         13   17   83
1571946 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007701911 310200011630 ART AND DESIGN HIGH SCHOOL public Career and Technical 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
1537195 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 64.0 2.0 1.0   1.0     0.0     4.0   34.0 38.0     *       50     14   72 64 2 1   1     0     4   34 38         50   14   72
1538981 NY Dutchess   school 3603270 131601060000   ARLINGTON 360327000086 131601060001 ARTHUR S MAY SCHOOL public Regular School No Elementary KG 05 2020   grade_2 36.0 10.0 26.0         6.0     8.0   41.0 45.0     7       42     20   86 36 10 26         6     8   41 45     7   42   20   86
1532692 NY Bronx   school 3600090 321200010000   NYC GEOG DIST #12 - BRONX 360009006218 321200011446 ARTURO A SCHOMBURG SATTELLITE-BRONX public Regular School No High 10 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
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
1531590 NY Bronx   school 3600088 321100010000   NYC GEOG DIST #11 - BRONX 360008805687 321100011299 ASTOR COLLEGIATE ACADEMY 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
1558855 NY Monroe   school 3612630 260501060000   GREECE 361263001032 260501060019 ATHENA 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
1558874 NY Monroe   school 3612630 260501060000   GREECE 361263001033 260501060020 ATHENA 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
1530488 NY Bronx   school 3601138 321000861075   ATMOSPHERE ACADEMY PUBLIC CH 360113806563 321000861075 ATMOSPHERE ACADEMY PUBLIC CHARTER charter Regular School Yes 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
1612834 NY Wyoming   school 3603420 670201060000   ATTICA 360342000097 670201060002 ATTICA ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 64.0 0.0 1.0   0.0     0.0         37.0 28.0     *       29     7   65 64 0 1   0     0         37 28         29   7   65
1612853 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 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
1612815 NY Wyoming   school 3603420 670201060000   ATTICA 360342000099 670201060001 ATTICA SENIOR 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
1534725 NY Cayuga   school 3603480 50100010000   AUBURN 360348000101 50100010013 AUBURN 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
1534706 NY Cayuga   school 3603480 50100010000   AUBURN 360348000103 50100010009 AUBURN JUNIOR HIGH SCHOOL public Regular School No Middle 07 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
1587792 NY Queens   school 3600123 342700010000   NYC GEOG DIST #27 - QUEENS 360012301912 342700011400 AUGUST MARTIN 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
1582719 NY Oswego   school 3606900 460801060000   CENTRAL SQUARE 360690000482 460801060001 AURA A COLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 53.0 1.0 0.0               0.0   32.0 22.0             31     7   54 53 1 0               0   32 22         31   7   54
1536853 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001395 90201040004 AUSABLE FORKS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_2 22.0 0.0                 1.0   11.0 12.0             14     *   23 22 0                 1   11 12         14       23
1536834 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617001396 90201040002 AUSABLE VALLEY 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
1536872 NY Clinton   school 3616170 90201040000   AUSABLE VALLEY 361617004948 90201040005 AUSABLE VALLEY MIDDLE SCHOOL public Regular School No Middle 07 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
1583650 NY Putnam   school 3618120 480101060000   MAHOPAC 361812001620 480101060002 AUSTIN ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_2 73.0 2.0 28.0         2.0     2.0   50.0 57.0     9       27     15   107 73 2 28         2     2   50 57     9   27   15   107
1558608 NY Monroe   school 3612630 260501060000   GREECE 361263001024 260501060001 AUTUMN LANE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2020   grade_2 46.0 9.0 14.0         5.0     11.0   48.0 37.0     5       45     8   85 46 9 14         5     11   48 37     5   45   8   85
1591440 NY Rensselaer   school 3600016 491302060000   AVERILL PARK 360001600111 491302060002 AVERILL PARK 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
1585056 NY Queens   school 3600098 342400010000   NYC GEOG DIST #24 - QUEENS 360009801915 342400011610 AVIATION CAREER AND TECH ED HS public Career and Technical 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
1597406 NY Steuben   school 3603630 570201040000   AVOCA 360363000117 570201040002 AVOCA CENTRAL SCHOOL public Regular School No Other PK 12 2020   grade_2 33.0 0.0 1.0   0.0     0.0     2.0   19.0 17.0             21     7   36 33 0 1   0     0     2   19 17         21   7   36
1557563 NY Livingston   school 3603660 240101040000   AVON 360366000119 240101040002 AVON 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
1557582 NY Livingston   school 3603660 240101040000   AVON 360366004863 240101040003 AVON MIDDLE SCHOOL public Regular School No Middle 05 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
1557544 NY Livingston   school 3603660 240101040000   AVON 360366000118 240101040001 AVON PRIMARY SCHOOL public Regular School No Elementary KG 04 2020   grade_2 63.0 2.0 8.0   1.0     0.0     0.0   36.0 38.0     *       33     8   74 63 2 8   1     0     0   36 38         33   8   74
1597045 NY Schuyler   school 3621630 550101040000   ODESSA MONTOUR 362163003066 550101040001 B C CATE ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2020   grade_2 60.0   1.0               1.0   33.0 29.0             44     9   62 60   1               1   33 29         44   9   62
1598052 NY Suffolk   school 3603720 580101030000   BABYLON 360372000120 580101030003 BABYLON ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2020   grade_2 81.0 2.0 19.0         3.0     1.0   55.0 51.0     *       15     14   106 81 2 19         3     1   55 51         15   14   106
1598033 NY Suffolk   school 3603720 580101030000   BABYLON 360372000121 580101030002 BABYLON JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 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
1598014 NY Suffolk   school 3603720 580101030000   BABYLON 360372000122 580101030001 BABYLON MEMORIAL GRADE SCHOOL public Regular School No Elementary 03 06 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
1590889 NY Queens   school 3600102 343000010000   NYC GEOG DIST #30 - QUEENS 360010205735 343000011580 BACCALAUREATE SCHOOL-GLOBAL ED public Regular School No High 07 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
1537176 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2020   grade_2 66.0 9.0 2.0   1.0     3.0     1.0   38.0 44.0     *       45     14   82 66 9 2   1     3     1   38 44         45   14   82
1536435 NY Chenango   school 3603810 80201040000   BAINBRIDGE GUILFRD 360381000123 80201040001 BAINBRIDGE-GUILFORD HIGH SCHOOL public Regular School No High 07 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
1563567 NY Nassau   school 3603840 280210030000   BALDWIN 360384000126 280210030012 BALDWIN 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
1563586 NY Nassau   school 3603840 280210030000   BALDWIN 360384000128 280210030013 BALDWIN SENIOR 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
1595791 NY Saratoga   school 3627240 521401040000   SOUTH GLENS FALLS 362724003714 521401040009 BALLARD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2020   grade_2 53.0   6.0               2.0   36.0 25.0             20     5   61 53   6               2   36 25         20   5   61
1571395 NY New York   school 3600077 310200010000   NYC GEOG DIST # 2 - MANHATTAN 360007705112 310200011442 BALLET TECH/NYC PS FOR DANCE public Regular School No Middle 04 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
1595658 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000148 521301060005 BALLSTON SPA MIDDLE SCHOOL public Regular School No Middle 05 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
1595601 NY Saratoga   school 3603930 521301060000   BALLSTON SPA 360393000149 521301060001 BALLSTON SPA SENIOR 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

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