Data source: Big Local News · About: Big Local

4,747 rows where grade = "grade_2", state = "NY" and year = 2016 sorted by district_nces_id descending

View and edit SQL

year

  • 2016 · 4,747

grade

  • grade_2 · 4,747
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
1043670 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1047584 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1033277 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1033296 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   grade_2 59.0 0.0 1.0   0.0     0.0         29.0 31.0             40     12   60 59 0 1   0     0         29 31         40   12   60
1033315 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 04 08 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1121551 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121570 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121589 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No 1.0 KG 03 2016   grade_2 101.0 3.0 16.0         13.0     3.0   75.0 61.0             15     13   136 101 3 16         13     3   75 61         15   13   136
1121608 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No 2.0 04 05 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121627 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No 1.0 KG 03 2016   grade_2 73.0 3.0 20.0         2.0     2.0   50.0 50.0             9     16   100 73 3 20         2     2   50 50         9   16   100
1066641 NY Livingston   school 3631950 241701040000   YORK 363195004278 241701040003 YORK CENTRAL ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2016   grade_2 46.0 0.0 2.0         0.0     0.0   29.0 19.0             25     *   48 46 0 2         0     0   29 19         25       48
1066660 NY Livingston   school 3631950 241701040000   YORK 363195004279 241701040004 YORK MIDDLE/HIGH SCHOOL public Regular School No 3.0 07 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1120620 NY Westchester   school 3631920 662300010000   YONKERS 363192000452 662300010001 ROBERT C DODSON SCHOOL public Regular School No 1.0 PK 08 2016   grade_2 2.0 9.0 83.0   0.0     2.0     0.0   51.0 45.0             87     15   96 2 9 83   0     2     0   51 45         87   15   96
1120639 NY Westchester   school 3631920 662300010000   YONKERS 363192001077 662300010002 FAMILY SCHOOL 32 public Regular School No 1.0 PK 08 2016   grade_2 12.0 16.0 23.0   0.0     5.0     1.0   30.0 27.0             40     9   57 12 16 23   0     5     1   30 27         40   9   57
1120658 NY Westchester   school 3631920 662300010000   YONKERS 363192001527 662300010004 MONTESSORI SCHOOL 31 public Regular School No 1.0 PK 06 2016   grade_2 12.0 9.0 27.0   1.0     3.0     1.0   31.0 22.0             29     8   53 12 9 27   1     3     1   31 22         29   8   53
1120677 NY Westchester   school 3631920 662300010000   YONKERS 363192004252 662300010005 SCHOOL 5 public Regular School No 1.0 PK 08 2016   grade_2 6.0 12.0 52.0   0.0     1.0     3.0   39.0 35.0             55     11   74 6 12 52   0     1     3   39 35         55   11   74
1120696 NY Westchester   school 3631920 662300010000   YONKERS 363192001920 662300010007 WILLIAM BOYCE THOMPSON SCHOOL public Regular School No 1.0 PK 08 2016   grade_2 5.0 12.0 36.0         0.0     0.0   34.0 19.0             49     18   53 5 12 36         0     0   34 19         49   18   53
1120715 NY Westchester   school 3631920 662300010000   YONKERS 363192004254 662300010008 PATRICIA A DICHIARO SCHOOL public Regular School No 1.0 PK 08 2016   grade_2 34.0 1.0 21.0   1.0     2.0     0.0   38.0 21.0             26     19   59 34 1 21   1     2     0   38 21         26   19   59
1120734 NY Westchester   school 3631920 662300010000   YONKERS 363192004255 662300010009 SCHOOL 9 public Regular School No 1.0 PK 06 2016   grade_2 4.0 12.0 36.0         2.0     1.0   31.0 24.0             48     10   55 4 12 36         2     1   31 24         48   10   55
1120753 NY Westchester   school 3631920 662300010000   YONKERS 363192004258 662300010013 SCHOOL 13 public Regular School No 1.0 PK 08 2016   grade_2 5.0 10.0 64.0   1.0     0.0     1.0   37.0 44.0             71     12   81 5 10 64   1     0     1   37 44         71   12   81
1120772 NY Westchester   school 3631920 662300010000   YONKERS 363192004259 662300010014 ROSMARIE ANN SIRAGUSA SCHOOL public Regular School No 1.0 PK 06 2016   grade_2 12.0 12.0 61.0         2.0     0.0   39.0 48.0             57     13   87 12 12 61         2     0   39 48         57   13   87
1120791 NY Westchester   school 3631920 662300010000   YONKERS 363192003452 662300010015 PAIDEIA SCHOOL 15 public Regular School No 1.0 PK 08 2016   grade_2 38.0 2.0 14.0   0.0     1.0     2.0   29.0 28.0             17     17   57 38 2 14   0     1     2   29 28         17   17   57
1120810 NY Westchester   school 3631920 662300010000   YONKERS 363192004260 662300010016 SCHOOL 16 public Regular School No 1.0 PK 08 2016   grade_2 7.0 23.0 51.0   0.0     5.0     0.0   36.0 50.0             75     6   86 7 23 51   0     5     0   36 50         75   6   86
1120829 NY Westchester   school 3631920 662300010000   YONKERS 363192004261 662300010017 SCHOOL 17 public Regular School No 1.0 PK 06 2016   grade_2 8.0 13.0 33.0   1.0     1.0     2.0   30.0 28.0             47     6   58 8 13 33   1     1     2   30 28         47   6   58
1120848 NY Westchester   school 3631920 662300010000   YONKERS 363192004262 662300010018 SCHOLASTIC ACAD FOR ACAD EXCELLENCE public Regular School No 1.0 PK 08 2016   grade_2 1.0 9.0 70.0   0.0     0.0     1.0   49.0 32.0             74     8   81 1 9 70   0     0     1   49 32         74   8   81
1120867 NY Westchester   school 3631920 662300010000   YONKERS 363192004263 662300010019 EUGENIO MARIA DE HOSTOS MICROSOCIETY public Regular School No 1.0 PK 08 2016   grade_2 2.0 7.0 70.0   0.0     3.0     0.0   41.0 41.0             77     10   82 2 7 70   0     3     0   41 41         77   10   82
1120886 NY Westchester   school 3631920 662300010000   YONKERS 363192004264 662300010021 SCHOOL 21 public Regular School No 1.0 PK 06 2016   grade_2 16.0 12.0 40.0   0.0     4.0     3.0   37.0 38.0             57     5   75 16 12 40   0     4     3   37 38         57   5   75
1120905 NY Westchester   school 3631920 662300010000   YONKERS 363192004265 662300010022 SCHOOL 22 public Regular School No 1.0 PK 06 2016   grade_2 10.0 20.0 46.0   0.0     5.0     0.0   42.0 39.0             61     10   81 10 20 46   0     5     0   42 39         61   10   81
1120924 NY Westchester   school 3631920 662300010000   YONKERS 363192004266 662300010023 SCHOOL 23 public Regular School No 1.0 PK 08 2016   grade_2 4.0 9.0 39.0   0.0     1.0     2.0   32.0 23.0             48     9   55 4 9 39   0     1     2   32 23         48   9   55
1120943 NY Westchester   school 3631920 662300010000   YONKERS 363192002802 662300010024 PAIDEIA SCHOOL 24 public Regular School No 1.0 PK 06 2016   grade_2 10.0 16.0 39.0   1.0     1.0     1.0   37.0 31.0             55     16   68 10 16 39   1     1     1   37 31         55   16   68
1120962 NY Westchester   school 3631920 662300010000   YONKERS 363192004267 662300010025 MUSEUM SCHOOL 25 public Regular School No 1.0 PK 06 2016   grade_2 2.0 37.0 15.0         1.0     0.0   28.0 27.0             43     19   55 2 37 15         1     0   28 27         43   19   55
1120981 NY Westchester   school 3631920 662300010000   YONKERS 363192004268 662300010026 CASIMIR PULASKI SCHOOL public Regular School No 1.0 PK 08 2016   grade_2 26.0 5.0 20.0   0.0     6.0     1.0   32.0 26.0             20     *   58 26 5 20   0     6     1   32 26         20       58
1121000 NY Westchester   school 3631920 662300010000   YONKERS 363192004269 662300010027 MONTESSORI SCHOOL 27 public Regular School No 1.0 PK 06 2016   grade_2 3.0 10.0 32.0   0.0     1.0     1.0   27.0 20.0             37     *   47 3 10 32   0     1     1   27 20         37       47
1121019 NY Westchester   school 3631920 662300010000   YONKERS 363192004270 662300010028 KAHLIL GIBRAN SCHOOL public Regular School No 1.0 PK 08 2016   grade_2 14.0 5.0 24.0         9.0     2.0   32.0 22.0             40     *   54 14 5 24         9     2   32 22         40       54
1121038 NY Westchester   school 3631920 662300010000   YONKERS 363192004271 662300010029 SCHOOL 29 public Regular School No 1.0 PK 08 2016   grade_2 4.0 7.0 22.0   1.0     5.0     0.0   20.0 19.0             33     11   39 4 7 22   1     5     0   20 19         33   11   39
1121057 NY Westchester   school 3631920 662300010000   YONKERS 363192004272 662300010030 SCHOOL 30 public Regular School No 1.0 PK 08 2016   grade_2 33.0 11.0 30.0   0.0     5.0     2.0   39.0 42.0             34     9   81 33 11 30   0     5     2   39 42         34   9   81
1121076 NY Westchester   school 3631920 662300010000   YONKERS 363192004242 662300010033 ENRICO FERMI SCHOOL-PERF ARTS public Regular School No 1.0 PK 08 2016   grade_2 0.0 10.0 91.0   0.0     0.0         50.0 51.0             91     14   101 0 10 91   0     0         50 51         91   14   101
1121095 NY Westchester   school 3631920 662300010000   YONKERS 363192004249 662300010036 CROSS HILL ACADEMY public Regular School No 1.0 PK 07 2016   grade_2 3.0 27.0 30.0   0.0     5.0     1.0   38.0 28.0             57     16   66 3 27 30   0     5     1   38 28         57   16   66
1121114 NY Westchester   school 3631920 662300010000   YONKERS 363192004243 662300010037 GORTON HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1121133 NY Westchester   school 3631920 662300010000   YONKERS 363192004245 662300010038 LINCOLN HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121152 NY Westchester   school 3631920 662300010000   YONKERS 363192004251 662300010040 SAUNDERS TRADES & TECH SR HIGH SCH public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121171 NY Westchester   school 3631920 662300010000   YONKERS 363192004250 662300010043 ROOSEVELT HIGH SCHOOL - EARLY COLLEG public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121190 NY Westchester   school 3631920 662300010000   YONKERS 363192004247 662300010044 YONKERS MONTESSORI ACADEMY public Regular School No 4.0 PK 12 2016   grade_2 36.0 11.0 38.0   0.0     2.0     0.0   39.0 48.0             37     14   87 36 11 38   0     2     0   39 48         37   14   87
1121209 NY Westchester   school 3631920 662300010000   YONKERS 363192004853 662300010045 CEDAR PLACE ELEMENTARY SCHOOL public Regular School No 1.0 PK 08 2016   grade_2 2.0 15.0 64.0   0.0     1.0     1.0   40.0 43.0             73     18   83 2 15 64   0     1     1   40 43         73   18   83
1121228 NY Westchester   school 3631920 662300010000   YONKERS 363192004248 662300010046 MLK JR HIGH TECH & COMPUTER MAGNE public Regular School No 1.0 PK 08 2016   grade_2 2.0 25.0 26.0   0.0     1.0     0.0   25.0 29.0             49     *   54 2 25 26   0     1     0   25 29         49       54
1121247 NY Westchester   school 3631920 662300010000   YONKERS 363192004539 662300010047 PEARLS HAWTHORNE SCHOOL public Regular School No 1.0 PK 08 2016   grade_2 30.0 11.0 33.0   0.0     21.0     6.0   38.0 63.0             24     *   101 30 11 33   0     21     6   38 63         24       101
1121266 NY Westchester   school 3631920 662300010000   YONKERS 363192004574 662300010048 YONKERS HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121285 NY Westchester   school 3631920 662300010000   YONKERS 363192000448 662300010050 RIVERSIDE HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121304 NY Westchester   school 3631920 662300010000   YONKERS 363192005591 662300010055 YONKERS MIDDLE SCHOOL public Regular School No 2.0 07 08 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1121323 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No 3.0 07 12 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1121342 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY public Regular School No 1.0 PK 06 2016   grade_2 1.0 8.0 24.0   0.0     3.0     2.0   19.0 19.0             34     *   38 1 8 24   0     3     2   19 19         34       38
1121361 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No 1.0 PK 01 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1121760 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No 1.0 KG 08 2016   grade_2 17.0 0.0 0.0   0.0               10.0 7.0             10     *   17 17 0 0   0               10 7         10       17
1100043 NY Rensselaer   school 3631830 490804020000   WYNANTSKILL 363183004238 490804020002 GARDNER-DICKINSON SCHOOL public Regular School No 1.0 KG 08 2016   grade_2 33.0 2.0 0.0   0.0     0.0     1.0   19.0 17.0             13     6   36 33 2 0   0     0     1   19 17         13   6   36
1107491 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004234 580109020001 MARTIN LUTHER KING ELEMENTARY SCHOOL public Regular School No 1.0 02 04 2016   grade_2 1.0 117.0 116.0         0.0     3.0   129.0 108.0             224     29   237 1 117 116         0     3   129 108         224   29   237
1107510 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004237 580109020003 WYANDANCH MEMORIAL HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1107529 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180004235 580109020004 MILTON L OLIVE MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1107548 NY Suffolk   school 3631800 580109020000   WYANDANCH 363180005838 580109020006 LA FRANCIS HARDIMAN ELEMENTARY SCH public Regular School No 1.0 PK 01 2016   grade_2 0.0 0.0 0.0               0.0   0.0 0.0             0     0   0 0 0 0               0   0 0         0   0   0
1092519 NY Otsego   school 3631740 472506040000   WORCESTER 363174004232 472506040001 WORCESTER SCHOOL public Regular School No 4.0 PK 12 2016   grade_2 24.0 0.0 0.0                   17.0 7.0             13     6   24 24 0 0                   17 7         13   6   24
1072664 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004226 280214030001 FRANKLIN EARLY CHILDHOOD CENTER public Regular School No 1.0 PK 02 2016   grade_2 1.0 0.0 0.0         0.0     0.0   1.0 0.0             *     *   1 1 0 0         0     0   1 0                 1
1072683 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004228 280214030002 HEWLETT ELEMENTARY SCHOOL public Regular School No 1.0 02 05 2016   grade_2 55.0 5.0 19.0   1.0     8.0     3.0   47.0 44.0             *     *   91 55 5 19   1     8     3   47 44                 91
1072702 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004229 280214030003 OGDEN ELEMENTARY SCHOOL public Regular School No 1.0 02 05 2016   grade_2 47.0 14.0 14.0   0.0     17.0     0.0   48.0 44.0             29     10   92 47 14 14   0     17     0   48 44         29   10   92
1072721 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004230 280214030006 WOODMERE MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1072740 NY Nassau   school 3631710 280214030000   HEWLETT WOODMERE 363171004227 280214030007 GEORGE W HEWLETT HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1054139 NY Greene   school 3631590 191401040000   WINDHAM ASHLAND 363159004225 191401040001 WINDHAM ASHLAND CENTRAL SCHOOL public Regular School No 4.0 KG 12 2016   grade_2 18.0 0.0 1.0   0.0     0.0     0.0   10.0 9.0             0     *   19 18 0 1   0     0     0   10 9         0       19
1085413 NY Niagara   school 3631560 401501060000   WILSON 363156004221 401501060002 WILSON ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 66.0 0.0 1.0   1.0     0.0     1.0   38.0 31.0             39     11   69 66 0 1   1     0     1   38 31         39   11   69
1085432 NY Niagara   school 3631560 401501060000   WILSON 363156004223 401501060003 WILSON HIGH SCHOOL public Regular School No 4.0 06 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1052676 NY Essex   school 3631500 151701040000   WILLSBORO 363150004220 151701040001 WILLSBORO CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_2 20.0       0.0           0.0   8.0 12.0             13     *   20 20       0           0   8 12         13       20
1048572 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004216 140203060001 MILL MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1048591 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004210 140203060002 DODGE ELEMENTARY SCHOOL public Regular School No 1.0 KG 4 2016   grade_2 73.0 5.0 4.0         8.0     4.0   53.0 41.0             19     15   94 73 5 4         8     4   53 41         19   15   94
1048610 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004214 140203060003 MAPLE EAST ELEMENTARY SCHOOL public Regular School No 1.0 KG 4 2016   grade_2 92.0 4.0 1.0   2.0     16.0     3.0   60.0 58.0             *     15   118 92 4 1   2     16     3   60 58             15   118
1048629 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004219 140203060004 WILLIAMSVILLE SOUTH HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1048648 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004212 140203060005 HEIM ELEMENTARY SCHOOL public Regular School No 1.0 KG 4 2016   grade_2 97.0 1.0 9.0   0.0     14.0     7.0   67.0 61.0             19     11   128 97 1 9   0     14     7   67 61         19   11   128
1048667 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004211 140203060007 FOREST ELEMENTARY SCHOOL public Regular School No 1.0 KG 4 2016   grade_2 102.0 6.0 7.0   0.0     5.0     6.0   66.0 60.0             28     14   126 102 6 7   0     5     6   66 60         28   14   126
1048686 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004215 140203060008 MAPLE WEST ELEMENTARY SCHOOL public Regular School No 1.0 KG 4 2016   grade_2 89.0 4.0 0.0         11.0     7.0   45.0 66.0             14     5   111 89 4 0         11     7   45 66         14   5   111
1048705 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004213 140203060009 HEIM MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1048724 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004218 140203060010 WILLIAMSVILLE NORTH HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1048743 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004209 140203060011 COUNTRY PARKWAY ELEMENTARY SCHOOL public Regular School No 1.0 KG 4 2016   grade_2 72.0 7.0 6.0         34.0     2.0   74.0 47.0             15     8   121 72 7 6         34     2   74 47         15   8   121
1048762 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004756 140203060012 CASEY MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1048781 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004217 140203060013 WILLIAMSVILLE EAST HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1048800 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147000457 140203060015 TRANSIT MIDDLE SCHOOL public Regular School No 2.0 05 8 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1116687 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004204 651402040001 WILLIAMSON MIDDLE SCHOOL public Regular School No 2.0 05 08 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1116706 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004206 651402040002 WILLIAMSON SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
1116725 NY Wayne   school 3631440 651402040000   WILLIAMSON 363144004205 651402040003 WILLIAMSON ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_2 71.0 0.0 8.0   0.0     0.0     1.0   38.0 42.0             40     13   80 71 0 8   0     0     1   38 42         40   13   80
1100024 NY Rensselaer   school 3631410 490801080000   NO GREENBUSH COM 363141004203 490801080001 NORTH GREENBUSH SCHOOL public Regular School No 1.0 KG 01 2016   grade_2 0.0                       0.0 0.0                   *   0 0                       0 0                 0
1042207 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004201 31401060002 TIOUGHNIOGA RIVERSIDE ACADEMY public Regular School No 2.0 04 08 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1042226 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004202 31401060004 WHITNEY POINT SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1042245 NY Broome   school 3631380 31401060000   WHITNEY POINT 363138004199 31401060005 CARYL E ADAMS PRIMARY SCHOOL public Regular School No 1.0 PK 03 2016   grade_2 108.0 0.0 1.0   1.0     0.0     3.0   62.0 51.0             80     19   113 108 0 1   1     0     3   62 51         80   19   113
1033258 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2016   grade_2 11.0   1.0                   6.0 6.0             *     *   12 11   1                   6 6                 12
1086686 NY Oneida   school 3631320 412902060000   WHITESBORO 363132004193 412902060002 MARCY ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 45.0 1.0 0.0         0.0     3.0   28.0 21.0             21     8   49 45 1 0         0     3   28 21         21   8   49
1086705 NY Oneida   school 3631320 412902060000   WHITESBORO 363132004192 412902060003 HARTS HILL SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 52.0 0.0 3.0               1.0   29.0 27.0             13     7   56 52 0 3               1   29 27         13   7   56
1086724 NY Oneida   school 3631320 412902060000   WHITESBORO 363132004191 412902060005 DEERFIELD ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 52.0 1.0 4.0         0.0     1.0   31.0 27.0             24     *   58 52 1 4         0     1   31 27         24       58
1086743 NY Oneida   school 3631320 412902060000   WHITESBORO 363132004196 412902060006 WHITESBORO MIDDLE SCHOOL public Regular School No 2.0 07 08 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1086762 NY Oneida   school 3631320 412902060000   WHITESBORO 363132004194 412902060007 PARKWAY MIDDLE SCHOOL public Regular School No 2.0 06 06 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1086781 NY Oneida   school 3631320 412902060000   WHITESBORO 363132004197 412902060008 WHITESBORO HIGH SCHOOL public Regular School No 3.0 09 12 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1086800 NY Oneida   school 3631320 412902060000   WHITESBORO 363132004195 412902060009 WESTMORELAND ROAD ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 69.0 1.0 4.0   0.0     0.0     0.0   39.0 35.0             39     13   74 69 1 4   0     0     0   39 35         39   13   74
1116117 NY Washington   school 3631290 641701060000   WHITEHALL 363129004189 641701060001 WHITEHALL ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2016   grade_2 62.0 1.0 0.0         0.0         31.0 32.0             43     5   63 62 1 0         0         31 32         43   5   63
1116136 NY Washington   school 3631290 641701060000   WHITEHALL 363129004190 641701060002 WHITEHALL JR-SR HIGH SCHOOL public Regular School No 4.0 05 12 2016   grade_2 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
1120487 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004755 662200010001 CHURCH STREET SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 20.0 20.0 68.0         5.0     5.0   60.0 58.0             66     13   118 20 20 68         5     5   60 58         66   13   118
1120506 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004179 662200010002 GEORGE WASHINGTON SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 22.0 12.0 70.0         3.0     4.0   61.0 50.0             69     7   111 22 12 70         3     4   61 50         69   7   111

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