Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_7" and state = "NY" sorted by rowid descending

View and edit SQL

year

grade

  • grade_7 · 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
2228744 NY Yates   school 3609390 680801040000   DUNDEE 360939000716 680801040002 DUNDEE ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
2228725 NY Yates   school 3609390 680801040000   DUNDEE 360939000717 680801040001 DUNDEE JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_7 34.0 0.0 1.0   1.0     0.0     2.0   21.0 17.0             21     *   38 34 0 1   1     0     2   21 17         21       38
2228706 NY Yates   school 3622740 680601060000   PENN YAN 362274003201 680601060005 PENN YAN ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 0.0   0.0         0.0     0.0   0.0 0.0     0       0     0   0 0   0         0     0   0 0     0   0   0   0
2228687 NY Yates   school 3622740 680601060000   PENN YAN 362274003202 680601060002 PENN YAN MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 91.0 1.0 2.0         0.0     3.0   46.0 51.0     *       53     10   97 91 1 2         0     3   46 51         53   10   97
2228668 NY Yates   school 3622740 680601060000   PENN YAN 362274003200 680601060001 PENN YAN ACADEMY public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2228649 NY Wyoming   school 3629940 671501040000   WARSAW 362994004030 671501040002 WARSAW MIDDLE/SENIOR HIGH SCHOOL public Regular School No High 06 12 2019   grade_7 63.0 0.0 1.0         0.0     3.0   36.0 31.0     *       32     11   67 63 0 1         0     3   36 31         32   11   67
2228630 NY Wyoming   school 3629940 671501040000   WARSAW 362994004029 671501040001 WARSAW ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_7 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     *       *     *   1 1 0 0   0     0     0   0 1                 1
2228611 NY Wyoming   school 3622770 671201060000   PERRY 362277003204 671201060002 PERRY JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   grade_7 54.0 0.0 5.0         0.0     2.0   33.0 28.0     *       29     8   61 54 0 5         0     2   33 28         29   8   61
2228592 NY Wyoming   school 3622770 671201060000   PERRY 362277003203 671201060001 PERRY ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2228573 NY Wyoming   school 3631860 671002040000   WYOMING 363186004240 671002040001 WYOMING CENTRAL SCHOOL public Regular School No Elementary KG 08 2019   grade_7 13.0 0.0 0.0   0.0               6.0 7.0             8     *   13 13 0 0   0               6 7         8       13
2228554 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713003229 670401040003 LETCHWORTH MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_7 65.0 1.0 0.0         0.0     0.0   30.0 36.0     *       *     7   66 65 1 0         0     0   30 36             7   66
2228535 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713004301 670401040002 LETCHWORTH ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2228516 NY Wyoming   school 3617130 670401040000   LETCHWORTH 361713001516 670401040001 LETCHWORTH SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0         0.0         0.0 0.0     *       0     0   0 0 0 0         0         0 0         0   0   0
2228497 NY Wyoming   school 3603420 670201060000   ATTICA 360342000098 670201060004 ATTICA JUNIOR HIGH SCHOOL public Regular School No Middle 05 08 2019   grade_7 89.0 0.0 3.0               2.0   44.0 50.0             34     23   94 89 0 3               2   44 50         34   23   94
2228478 NY Wyoming   school 3603420 670201060000   ATTICA 360342000097 670201060002 ATTICA ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     *       0     0   0 0 0 0   0     0     0   0 0         0   0   0
2228459 NY Wyoming   school 3603420 670201060000   ATTICA 360342000099 670201060001 ATTICA SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2228440 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004283 662402060005 MOHANSIC SCHOOL public Regular School No Elementary KG 03 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2228421 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004281 662402060004 CROMPOND SCHOOL public Regular School No Elementary 04 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2228402 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004280 662402060003 BROOKSIDE SCHOOL public Regular School No Elementary PK 03 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2228383 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004282 662402060002 MILDRED E STRANG MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 171.0 8.0 49.0   0.0     23.0     8.0   127.0 132.0     5       *     39   259 171 8 49   0     23     8   127 132     5       39   259
2228364 NY Westchester   school 3631980 662402060000   YORKTOWN 363198004284 662402060001 YORKTOWN HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2228345 NY Westchester   school 3616620 662401060000   LAKELAND 361662001479 662401060010 WALTER PANAS HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2228326 NY Westchester   school 3616620 662401060000   LAKELAND 361662001471 662401060009 BENJAMIN FRANKLIN ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
2228307 NY Westchester   school 3616620 662401060000   LAKELAND 361662001472 662401060008 LAKELAND-COPPER BEECH MIDDLE SCH public Regular School No Middle 06 08 2019   grade_7 297.0 20.0 100.0   1.0     21.0     10.0   230.0 219.0     *       110     64   449 297 20 100   1     21     10   230 219         110   64   449
2228288 NY Westchester   school 3616620 662401060000   LAKELAND 361662001475 662401060007 LAKELAND HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2228269 NY Westchester   school 3616620 662401060000   LAKELAND 361662001478 662401060005 VAN CORTLANDTVILLE SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2228250 NY Westchester   school 3616620 662401060000   LAKELAND 361662001476 662401060004 LINCOLN TITUS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2228231 NY Westchester   school 3616620 662401060000   LAKELAND 361662001473 662401060003 GEORGE WASHINGTON ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2228212 NY Westchester   school 3616620 662401060000   LAKELAND 361662001477 662401060001 THOMAS JEFFERSON ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
2228193 NY Westchester   school 3600155 662300860862   CHARTER SCH-EDUC EXCELLENCE 360015505844 662300860862 CHARTER SCH-EDUC EXCELLENCE charter Regular School Yes Elementary KG 08 2019   grade_7 0.0 36.0 46.0         1.0     1.0   46.0 38.0     *       71     7   84 0 36 46         1     1   46 38         71   7   84
2228174 NY Westchester   school 3631920 662300010000   YONKERS 363192006557 662300010058 YONKERS EARLY CHILDHOOD ACADEMY public Regular School No Elementary PK 02 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2228155 NY Westchester   school 3631920 662300010000   YONKERS 363192006281 662300010057 THOMAS CORNELL ACADEMY public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2228136 NY Westchester   school 3631920 662300010000   YONKERS 363192006001 662300010056 PALISADE PREPARATORY SCHOOL public Regular School No High 07 12 2019   grade_7 18.0 41.0 98.0   0.0     10.0     3.0   99.0 71.0     23       161     38   170 18 41 98   0     10     3   99 71     23   161   38   170
2228117 NY Westchester   school 3631920 662300010000   YONKERS 363192005591 662300010055 YONKERS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 40.0 67.0 124.0   1.0     18.0     3.0   119.0 134.0     20       228     52   253 40 67 124   1     18     3   119 134     20   228   52   253
2228098 NY Westchester   school 3631920 662300010000   YONKERS 363192000448 662300010050 RIVERSIDE HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2228079 NY Westchester   school 3631920 662300010000   YONKERS 363192004574 662300010048 YONKERS HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2228060 NY Westchester   school 3631920 662300010000   YONKERS 363192004539 662300010047 PEARLS HAWTHORNE SCHOOL public Regular School No Elementary PK 08 2019   grade_7 25.0 11.0 36.0         22.0     6.0   46.0 54.0     0       39     10   100 25 11 36         22     6   46 54     0   39   10   100
2228041 NY Westchester   school 3631920 662300010000   YONKERS 363192004248 662300010046 MLK JR HIGH TECH & COMPUTER MAGNE public Regular School No Elementary PK 08 2019   grade_7 2.0 23.0 44.0   0.0     1.0     1.0   42.0 29.0     7       68     19   71 2 23 44   0     1     1   42 29     7   68   19   71
2228022 NY Westchester   school 3631920 662300010000   YONKERS 363192004853 662300010045 CESAR E CHAVEZ SCHOOL public Regular School No Elementary PK 08 2019   grade_7 2.0 9.0 55.0   0.0     1.0     0.0   33.0 34.0     7       65     12   67 2 9 55   0     1     0   33 34     7   65   12   67
2228003 NY Westchester   school 3631920 662300010000   YONKERS 363192004247 662300010044 YONKERS MONTESSORI ACADEMY public Regular School No Other PK 12 2019   grade_7 51.0 18.0 67.0   0.0     3.0     0.0   68.0 71.0     8       92     25   139 51 18 67   0     3     0   68 71     8   92   25   139
2227984 NY Westchester   school 3631920 662300010000   YONKERS 363192004250 662300010043 ROOSEVELT HIGH SCHOOL - EARLY COLLEG public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227965 NY Westchester   school 3631920 662300010000   YONKERS 363192004251 662300010040 SAUNDERS TRADES & TECH SR HIGH SCH public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227946 NY Westchester   school 3631920 662300010000   YONKERS 363192004245 662300010038 LINCOLN HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2227927 NY Westchester   school 3631920 662300010000   YONKERS 363192004243 662300010037 GORTON HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227908 NY Westchester   school 3631920 662300010000   YONKERS 363192004249 662300010036 CROSS HILL ACADEMY public Regular School No Elementary PK 08 2019   grade_7 1.0 19.0 29.0   2.0     1.0     0.0   31.0 21.0     *       47     9   52 1 19 29   2     1     0   31 21         47   9   52
2227889 NY Westchester   school 3631920 662300010000   YONKERS 363192004242 662300010033 ENRICO FERMI SCHOOL-PERF ARTS public Regular School No Elementary PK 08 2019   grade_7 3.0 14.0 104.0   0.0     1.0     0.0   62.0 60.0     50       118     9   122 3 14 104   0     1     0   62 60     50   118   9   122
2227870 NY Westchester   school 3631920 662300010000   YONKERS 363192004272 662300010030 SCHOOL 30 public Regular School No Elementary PK 08 2019   grade_7 22.0 4.0 28.0         3.0     3.0   23.0 37.0     *       45     *   60 22 4 28         3     3   23 37         45       60
2227851 NY Westchester   school 3631920 662300010000   YONKERS 363192004271 662300010029 SCHOOL 29 public Regular School No Elementary PK 08 2019   grade_7 9.0 23.0 22.0   0.0     6.0     0.0   28.0 32.0     *       54     7   60 9 23 22   0     6     0   28 32         54   7   60
2227832 NY Westchester   school 3631920 662300010000   YONKERS 363192004270 662300010028 KAHLIL GIBRAN SCHOOL public Regular School No Elementary PK 08 2019   grade_7 21.0 7.0 22.0         6.0     0.0   33.0 23.0     *       42     9   56 21 7 22         6     0   33 23         42   9   56
2227813 NY Westchester   school 3631920 662300010000   YONKERS 363192004269 662300010027 MONTESSORI SCHOOL 27 public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227794 NY Westchester   school 3631920 662300010000   YONKERS 363192004268 662300010026 CASIMIR PULASKI SCHOOL public Regular School No Elementary PK 08 2019   grade_7 29.0 9.0 41.0         6.0     0.0   47.0 38.0     5       52     29   85 29 9 41         6     0   47 38     5   52   29   85
2227775 NY Westchester   school 3631920 662300010000   YONKERS 363192004267 662300010025 MUSEUM SCHOOL 25 public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2227756 NY Westchester   school 3631920 662300010000   YONKERS 363192002802 662300010024 PAIDEIA SCHOOL 24 public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227737 NY Westchester   school 3631920 662300010000   YONKERS 363192004266 662300010023 SCHOOL 23 public Regular School No Elementary PK 08 2019   grade_7 6.0 13.0 37.0   1.0     3.0     0.0   28.0 32.0     10       60     *   60 6 13 37   1     3     0   28 32     10   60       60
2227718 NY Westchester   school 3631920 662300010000   YONKERS 363192004265 662300010022 SCHOOL 22 public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227699 NY Westchester   school 3631920 662300010000   YONKERS 363192004264 662300010021 SCHOOL 21 public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227680 NY Westchester   school 3631920 662300010000   YONKERS 363192004263 662300010019 EUGENIO MARIA DE HOSTOS MICROSOCIETY public Regular School No Elementary PK 08 2019   grade_7 0.0 8.0 48.0   0.0     4.0     0.0   32.0 28.0     12       58     *   60 0 8 48   0     4     0   32 28     12   58       60
2227661 NY Westchester   school 3631920 662300010000   YONKERS 363192004262 662300010018 SCHOLASTIC ACAD FOR ACAD EXCELLENCE public Regular School No Elementary PK 08 2019   grade_7 1.0 11.0 55.0   0.0     2.0     0.0   28.0 41.0     9       67     11   69 1 11 55   0     2     0   28 41     9   67   11   69
2227642 NY Westchester   school 3631920 662300010000   YONKERS 363192004261 662300010017 SCHOOL 17 public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227623 NY Westchester   school 3631920 662300010000   YONKERS 363192004260 662300010016 SCHOOL 16 public Regular School No Elementary PK 08 2019   grade_7 6.0 17.0 29.0         6.0     1.0   31.0 28.0     *       50     *   59 6 17 29         6     1   31 28         50       59
2227604 NY Westchester   school 3631920 662300010000   YONKERS 363192003452 662300010015 PAIDEIA SCHOOL 15 public Regular School No Elementary PK 08 2019   grade_7 39.0 7.0 23.0   0.0     3.0     3.0   46.0 29.0     5       43     34   75 39 7 23   0     3     3   46 29     5   43   34   75
2227585 NY Westchester   school 3631920 662300010000   YONKERS 363192004259 662300010014 ROSMARIE ANN SIRAGUSA SCHOOL public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227566 NY Westchester   school 3631920 662300010000   YONKERS 363192004258 662300010013 SCHOOL 13 public Regular School No Elementary PK 08 2019   grade_7 6.0 5.0 46.0   0.0     1.0     1.0   33.0 26.0     9       59     5   59 6 5 46   0     1     1   33 26     9   59   5   59
2227547 NY Westchester   school 3631920 662300010000   YONKERS 363192004255 662300010009 SCHOOL 9 public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227528 NY Westchester   school 3631920 662300010000   YONKERS 363192004254 662300010008 PATRICIA A DICHIARO SCHOOL public Regular School No Elementary PK 08 2019   grade_7 40.0 1.0 17.0   0.0     2.0     0.0   26.0 34.0     0       25     15   60 40 1 17   0     2     0   26 34     0   25   15   60
2227509 NY Westchester   school 3631920 662300010000   YONKERS 363192001920 662300010007 WILLIAM BOYCE THOMPSON SCHOOL public Regular School No Elementary PK 08 2019   grade_7 2.0 23.0 31.0   0.0     1.0     0.0   30.0 27.0     7       54     25   57 2 23 31   0     1     0   30 27     7   54   25   57
2227490 NY Westchester   school 3631920 662300010000   YONKERS 363192004252 662300010005 SCHOOL 5 public Regular School No Elementary PK 08 2019   grade_7 16.0 7.0 31.0   0.0     5.0     0.0   31.0 28.0     *       47     8   59 16 7 31   0     5     0   31 28         47   8   59
2227471 NY Westchester   school 3631920 662300010000   YONKERS 363192001527 662300010004 MONTESSORI SCHOOL 31 public Regular School No Elementary PK 06 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227452 NY Westchester   school 3631920 662300010000   YONKERS 363192001077 662300010002 FAMILY SCHOOL 32 public Regular School No Elementary PK 08 2019   grade_7 15.0 10.0 40.0   1.0     7.0     0.0   35.0 38.0     6       64     28   73 15 10 40   1     7     0   35 38     6   64   28   73
2227433 NY Westchester   school 3631920 662300010000   YONKERS 363192000452 662300010001 ROBERT C DODSON SCHOOL public Regular School No Elementary PK 08 2019   grade_7 3.0 1.0 81.0   1.0     2.0         40.0 48.0     32       82     *   88 3 1 81   1     2         40 48     32   82       88
2227414 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004177 662200010012 WHITE PLAINS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 109.0 67.0 329.0         25.0     19.0   266.0 283.0     76       350     79   549 109 67 329         25     19   266 283     76   350   79   549
2227395 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004188 662200010011 WHITE PLAINS SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227376 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004185 662200010006 RIDGEWAY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2227357 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004184 662200010005 POST ROAD SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2227338 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004181 662200010003 MAMARONECK AVENUE SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2227319 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004179 662200010002 GEORGE WASHINGTON SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2227300 NY Westchester   school 3631260 662200010000   WHITE PLAINS 363126004755 662200010001 CHURCH STREET SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2227281 NY Westchester   school 3627180 662101060000   SOMERS 362718003702 662101060004 SOMERS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 216.0 1.0 13.0         9.0     5.0   141.0 103.0     *       31     48   244 216 1 13         9     5   141 103         31   48   244
2227262 NY Westchester   school 3627180 662101060000   SOMERS 362718003701 662101060003 SOMERS INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227243 NY Westchester   school 3627180 662101060000   SOMERS 362718003700 662101060002 PRIMROSE SCHOOL public Regular School No Elementary KG 02 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2227224 NY Westchester   school 3627180 662101060000   SOMERS 362718003703 662101060001 SOMERS SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2227205 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003565 662001030011 SCARSDALE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 254.0 5.0 28.0         76.0     19.0   201.0 181.0     *             34   382 254 5 28         76     19   201 181             34   382
2227186 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003566 662001030010 SCARSDALE SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0             0   0 0 0 0   0     0     0   0 0     0       0   0
2227167 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003564 662001030005 QUAKER RIDGE SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0             0   0 0 0 0   0     0     0   0 0     0       0   0
2227148 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003563 662001030004 HEATHCOTE SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
2227129 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003562 662001030003 GREENACRES SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0   0.0         0.0     0.0   0.0 0.0     0             0   0 0   0         0     0   0 0     0       0   0
2227110 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003561 662001030002 FOX MEADOW SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0             0   0 0 0 0   0     0     0   0 0     0       0   0
2227091 NY Westchester   school 3625950 662001030000   SCARSDALE 362595003560 662001030001 EDGEWOOD SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0             0   0 0 0 0         0     0   0 0     0       0   0
2227072 NY Westchester   school 3624630 661905020000   BLIND BROOK-RYE 362463005483 661905020003 BLIND BROOK-RYE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 79.0 1.0 3.0   0.0     6.0     12.0   48.0 53.0     *       *     8   101 79 1 3   0     6     12   48 53             8   101
2227053 NY Westchester   school 3624630 661905020000   BLIND BROOK-RYE 362463003350 661905020002 BLIND BROOK HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     *       0     0   0 0 0 0         0     0   0 0         0   0   0
2227034 NY Westchester   school 3624630 661905020000   BLIND BROOK-RYE 362463003351 661905020001 BRUNO M PONTERIO RIDGE STREET SCHOO public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2227015 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003277 661904030010 PORT CHESTER MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 51.0 12.0 279.0   2.0     2.0     1.0   176.0 171.0     *       254     43   347 51 12 279   2     2     1   176 171         254   43   347
2226996 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003278 661904030008 PORT CHESTER SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2226977 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003279 661904030006 THOMAS A EDISON SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2226958 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003276 661904030005 PARK AVENUE SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2226939 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003274 661904030004 KING STREET SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2226920 NY Westchester   school 3623460 661904030000   PORT CHESTER-RYE 362346003273 661904030003 JOHN F KENNEDY ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
2226901 NY Westchester   school 3625290 661901030000   RYE NECK 362529002771 661901030005 DANIEL WARREN ELEMENTARY SCHOOL public Regular School No Elementary KG 02 2019   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0     0       0     0   0 0 0 0   0     0     0   0 0     0   0   0   0
2226882 NY Westchester   school 3625290 661901030000   RYE NECK 362529003495 661901030004 RYE NECK MIDDLE SCHOOL public Regular School No Middle 06 08 2019   grade_7 84.0 6.0 24.0         8.0     9.0   79.0 52.0     *       18     11   131 84 6 24         8     9   79 52         18   11   131
2226863 NY Westchester   school 3625290 661901030000   RYE NECK 362529003496 661901030002 RYE NECK SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   grade_7 0.0 0.0 0.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]);