Data source: Big Local News · About: Big Local

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

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
759382 NY Columbia   school   100308020000   BERKSHIRE   100308020002 COLUMBIA-GREENE PARTNERSHIP ACADEMY public           2015   grade_7 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
987036 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   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
1043675 NY Cayuga   school   51901040000   UNION SPRINGS   51901040006 UNION SPRINGS MIDDLE SCHOOL public           2016   grade_7 54.0 1.0 0.0         1.0     0.0   27.0 29.0             22     10   56 54 1 0         1     0   27 29         22   10   56
1047589 NY Dutchess   school   131500010000   POUGHKEEPSIE   131500010007 SMITH EARLY LEARNING CENTER public           2016   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
1456659 NY Kings   school   320700861057   NEW AMERICAN ACAD CHARTER SC   320700861057 NEW AMERICAN ACAD CHARTER SCH (THE) charter           2021   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
1555991 NY Kings   school   332300010000   NYC GEOG DIST #23 - BROOKLYN   331700011646 ASPIRATIONS DIPLOMA PLUS HIGH SCHOOL public           2020   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
2067909 NY Erie   school   140600861109   REACH ACADEMY CHARTER SCHOOL   140600861109 REACH ACADEMY CHARTER SCHOOL charter           2018   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
2106346 NY Onondaga   school   421800861124   SYRACUSE ACADEMY OF SCI-CITI   421800861124 SYRACUSE ACADEMY OF SCI-CITIZENSHIP charter           2018   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
761586 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004025 132101060007 VASSAR ROAD ELEMENTARY SCHOOL public Regular School No 1 KG 3 2015   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
761605 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004023 132101060008 SHEAFE ROAD ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
761681 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004021 132101060012 OAK GROVE ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
761700 NY Dutchess   school 3629880 132101060000   WAPPINGERS 362988004020 132101060013 MYERS CORNERS SCHOOL public Regular School No 1 KG 6 2015   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
761776 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001770 132201040002 ALDEN PLACE ELEMENTARY SCHOOL public Regular School No 1 03 5 2015   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
761795 NY Dutchess   school 3619380 132201040000   MILLBROOK 361938001771 132201040003 ELM DRIVE ELEMENTARY SCHOOL public Regular School No 1 KG 2 2015   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
761833 NY Erie   school 3602550 140101060000   ALDEN 360255000041 140101060003 ALDEN PRIMARY AT TOWNLINE public Regular School No 1 KG 3 2015   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
761928 NY Erie   school 3602920 140201060000   AMHERST 360292004378 140201060005 SMALLWOOD DRIVE SCHOOL public Regular School No 1 KG 5 2015   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
761947 NY Erie   school 3602920 140201060000   AMHERST 360292004289 140201060006 WINDERMERE BLVD SCHOOL public Regular School No 1 PK 5 2015   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
761985 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004210 140203060002 DODGE ELEMENTARY SCHOOL public Regular School No 1 KG 4 2015   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
762004 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004214 140203060003 MAPLE EAST ELEMENTARY SCHOOL public Regular School No 1 KG 4 2015   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
762042 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004212 140203060005 HEIM ELEMENTARY SCHOOL public Regular School No 1 KG 4 2015   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
762061 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004211 140203060007 FOREST ELEMENTARY SCHOOL public Regular School No 1 KG 4 2015   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
762080 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004215 140203060008 MAPLE WEST ELEMENTARY SCHOOL public Regular School No 1 KG 4 2015   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
762137 NY Erie   school 3631470 140203060000   WILLIAMSVILLE 363147004209 140203060011 COUNTRY PARKWAY ELEMENTARY SCHOOL public Regular School No 1 KG 4 2015   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
762213 NY Erie   school 3628500 140207060000   SWEET HOME 362850003827 140207060002 GLENDALE ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
762232 NY Erie   school 3628500 140207060000   SWEET HOME 362850003829 140207060003 MAPLEMERE ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
762289 NY Erie   school 3628500 140207060000   SWEET HOME 362850003833 140207060007 WILLOW RIDGE ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
762308 NY Erie   school 3628500 140207060000   SWEET HOME 362850003828 140207060008 HERITAGE HTS ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
762327 NY Erie   school 3609540 140301030000   EAST AURORA 360954000727 140301030001 PARKDALE ELEMENTARY SCHOOL public Regular School No 1 KG 4 2015   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
762384 NY Erie   school 3605850 140600010000   BUFFALO 360585003478 140600010001 DISCOVERY SCHOOL public Regular School No 1 PK 8 2015   grade_7 39.0 11.0 3.0   0.0     0.0     0.0   31.0 22.0             23     9   53 39 11 3   0     0     0   31 22         23   9   53
762403 NY Erie   school 3605850 140600010000   BUFFALO 360585000318 140600010003 D'YOUVILLE-PORTER CAMPUS public Regular School No 1 PK 8 2015   grade_7 6.0 13.0 42.0   0.0     5.0     0.0   36.0 30.0             52     12   66 6 13 42   0     5     0   36 30         52   12   66
762422 NY Erie   school 3605850 140600010000   BUFFALO 360585000295 140600010006 BUFFALO ELEM SCH OF TECHNOLOGY public Regular School No 1 PK 8 2015   grade_7 10.0 31.0 4.0   0.0     19.0     0.0   32.0 32.0             50     14   64 10 31 4   0     19     0   32 32         50   14   64
762441 NY Erie   school 3605850 140600010000   BUFFALO 360585000317 140600010017 PS 17 public Regular School No 1 PK 4 2015   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
762460 NY Erie   school 3605850 140600010000   BUFFALO 360585000323 140600010018 DR A PANTOJA COMM SCH EXCLLNCE -#18 public Regular School No 1 PK 8 2015   grade_7 5.0 25.0 10.0   0.0     13.0     0.0   25.0 28.0             48     *   53 5 25 10   0     13     0   25 28         48       53
762479 NY Erie   school 3605850 140600010000   BUFFALO 360585000324 140600010019 NATIVE AMERICAN MAGNET public Regular School No 1 PK 8 2015   grade_7 8.0 24.0 9.0   11.0     18.0     0.0   37.0 33.0             62     12   70 8 24 9   11     18     0   37 33         62   12   70
762498 NY Erie   school 3605850 140600010000   BUFFALO 360585000329 140600010027 PS 27 HILLERY PARK ACADEMY public Regular School No 1 PK 8 2015   grade_7 29.0 22.0 3.0   5.0     1.0     1.0   31.0 30.0             49     *   61 29 22 3   5     1     1   31 30         49       61
762517 NY Erie   school 3605850 140600010000   BUFFALO 360585000332 140600010031 HARRIET ROSS TUBMAN ACADEMY public Regular School No 1 PK 8 2015   grade_7 4.0 47.0 3.0   0.0     2.0     0.0   36.0 20.0             48     17   56 4 47 3   0     2     0   36 20         48   17   56
762536 NY Erie   school 3605850 140600010000   BUFFALO 360585000300 140600010032 BUILD ACADEMY public Regular School No 1 PK 8 2015   grade_7 2.0 51.0 4.0   0.0     0.0     2.0   34.0 25.0             53     19   59 2 51 4   0     0     2   34 25         53   19   59
762555 NY Erie   school 3605850 140600010000   BUFFALO 360585000333 140600010033 BILINGUAL CENTER public Regular School No 1 PK 8 2015   grade_7 21.0 6.0 24.0   0.0     1.0     2.0   28.0 26.0             49     13   54 21 6 24   0     1     2   28 26         49   13   54
762574 NY Erie   school 3605850 140600010000   BUFFALO 360585000335 140600010037 MARVA J DANIEL FUTURES PREP SCHOOL public Regular School No 1 PK 8 2015   grade_7 2.0 52.0 3.0   1.0     0.0     3.0   35.0 26.0             52     19   61 2 52 3   1     0     3   35 26         52   19   61
762593 NY Erie   school 3605850 140600010000   BUFFALO 360585000305 140600010039 DR MARTIN LUTHER KING, JR MULTICUL public Regular School No 1 PK 8 2015   grade_7 0.0 32.0 1.0   2.0     0.0     0.0   19.0 16.0             34     6   35 0 32 1   2     0     0   19 16         34   6   35
762631 NY Erie   school 3605850 140600010000   BUFFALO 360585000339 140600010043 LOVEJOY DISCOVERY SCHOOL #43 public Regular School No 1 PK 8 2015   grade_7 25.0 22.0 9.0   0.0     2.0     0.0   33.0 25.0             50     17   58 25 22 9   0     2     0   33 25         50   17   58
762650 NY Erie   school 3605850 140600010000   BUFFALO 360585000341 140600010045 INTERNATIONAL SCHOOL public Regular School No 1 PK 6 2015   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
762669 NY Erie   school 3605850 140600010000   BUFFALO 360585000346 140600010053 COMMUNITY SCHOOL #53 AT #4 public Regular School No 1 PK 8 2015   grade_7 0.0 45.0 1.0         0.0     1.0   19.0 28.0             38     9   47 0 45 1         0     1   19 28         38   9   47
762688 NY Erie   school 3605850 140600010000   BUFFALO 360585000347 140600010054 DR GEORGE BLACKMAN ECC public Regular School No 1 PK 4 2015   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
762726 NY Erie   school 3605850 140600010000   BUFFALO 360585000350 140600010059 PS 59 DR CHARLES DREW SCI MAGNET public Regular School No 1 PK 8 2015   grade_7 3.0 57.0 1.0   0.0     1.0     0.0   28.0 34.0             53     *   62 3 57 1   0     1     0   28 34         53       62
762745 NY Erie   school 3605850 140600010000   BUFFALO 360585000352 140600010061 PS 61 AT 171 public Regular School No 1 PK 4 2015   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
762764 NY Erie   school 3605850 140600010000   BUFFALO 360585000355 140600010064 PS 64 FREDERICK LAW OLMSTED public Regular School No 1 PK 4 2015   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
762783 NY Erie   school 3605850 140600010000   BUFFALO 360585000356 140600010065 PS 65 ROOSEVELT ACADEMY ECC public Regular School No 1 PK 4 2015   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
762821 NY Erie   school 3605850 140600010000   BUFFALO 360585000360 140600010069 PS 69 HOUGHTON ACADEMY public Regular School No 1 PK 8 2015   grade_7 31.0 24.0 10.0   0.0     0.0     2.0   36.0 31.0             52     29   67 31 24 10   0     0     2   36 31         52   29   67
762840 NY Erie   school 3605850 140600010000   BUFFALO 360585000363 140600010072 LORRAINE ELEMENTARY SCHOOL public Regular School No 1 PK 8 2015   grade_7 23.0 19.0 5.0   1.0     2.0     0.0   19.0 31.0             39     *   50 23 19 5   1     2     0   19 31         39       50
762859 NY Erie   school 3605850 140600010000   BUFFALO 360585000364 140600010074 PS 74 HAMLIN PARK ELEMENTARY SCHOOL public Regular School No 1 PK 8 2015   grade_7 1.0 40.0 1.0               0.0   16.0 26.0             34     7   42 1 40 1               0   16 26         34   7   42
762878 NY Erie   school 3605850 140600010000   BUFFALO 360585000310 140600010076 HERMAN BADILLO COMMUNITY SCHOOL public Regular School No 1 PK 8 2015   grade_7 3.0 12.0 67.0   0.0     4.0     1.0   42.0 45.0             80     20   87 3 12 67   0     4     1   42 45         80   20   87
762897 NY Erie   school 3605850 140600010000   BUFFALO 360585000368 140600010080 HIGHGATE HEIGHTS public Regular School No 1 PK 8 2015   grade_7 0.0 52.0 0.0   0.0     1.0     0.0   23.0 30.0             47     6   53 0 52 0   0     1     0   23 30         47   6   53
762916 NY Erie   school 3605850 140600010000   BUFFALO 360585000369 140600010081 PS 81 public Regular School No 1 PK 8 2015   grade_7 26.0 47.0 8.0   4.0     1.0     3.0   38.0 51.0             71     17   89 26 47 8   4     1     3   38 51         71   17   89
762935 NY Erie   school 3605850 140600010000   BUFFALO 360585000370 140600010082 PS 82 public Regular School No 1 PK 4 2015   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
762973 NY Erie   school 3605850 140600010000   BUFFALO 360585004506 140600010093 SOUTHSIDE ELEMENTARY SCHOOL public Regular School No 1 PK 8 2015   grade_7 77.0 25.0 18.0   2.0     10.0     5.0   65.0 72.0             108     38   137 77 25 18   2     10     5   65 72         108   38   137
762992 NY Erie   school 3605850 140600010000   BUFFALO 360585000302 140600010094 DR LYDIA T WRIGHT SCH OF EXCELLENCE public Regular School No 1 PK 8 2015   grade_7 4.0 80.0 10.0         1.0     1.0   49.0 47.0             80     26   96 4 80 10         1     1   49 47         80   26   96
763201 NY Erie   school 3605850 140600010000   BUFFALO 360585000382 140600010118 WEST HERTEL ELEMENTARY SCHOOL public Regular School No 1 PK 8 2015   grade_7 17.0 42.0 23.0   1.0     23.0     1.0   54.0 53.0             94     30   107 17 42 23   1     23     1   54 53         94   30   107
763220 NY Erie   school 3605850 140600010000   BUFFALO 360585000381 140600010119 WATERFRONT SCHOOL public Regular School No 1 PK 8 2015   grade_7 17.0 47.0 14.0   2.0     21.0     1.0   47.0 55.0             92     21   102 17 47 14   2     21     1   47 55         92   21   102
763239 NY Erie   school 3605850 140600010000   BUFFALO 360585000316 140600010122 BENNETT PARK MONTESSORI SCHOOL public Regular School No 1 PK 8 2015   grade_7 6.0 35.0 0.0   2.0     0.0     1.0   23.0 21.0             36     *   44 6 35 0   2     0     1   23 21         36       44
763258 NY Erie   school 3605850 140600010000   BUFFALO 360585001549 140600010126 STANLEY MAKOWSKI EARLY CHLDHD CTR public Regular School No 1 PK 4 2015   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
763296 NY Erie   school 3605850 140600010000   BUFFALO 360585003481 140600010129 GRABIARZ-CAMPUS SCHOOL #79 public Regular School No 1 PK 8 2015   grade_7 9.0 31.0 15.0   2.0     1.0     2.0   26.0 34.0             52     18   60 9 31 15   2     1     2   26 34         52   18   60
763315 NY Erie   school 3605850 140600010000   BUFFALO 360585005858 140600010130 FRANK A SEDITA SCHOOL #30 public Regular School No 1 PK 8 2015   grade_7 4.0 16.0 54.0   0.0     4.0     2.0   32.0 48.0             67     6   80 4 16 54   0     4     2   32 48         67   6   80
763448 NY Erie   school 3600035 140600860814   KING CENTER CHARTER SCHOOL 360003504336 140600860814 KING CENTER CHARTER SCHOOL charter Regular School Yes 1 KG 8 2015   grade_7 0.0 22.0 0.0         1.0     0.0   9.0 14.0             23     *   23 0 22 0         1     0   9 14         23       23
763467 NY Erie   school 3600036 140600860817   SOUTH BUFFALO CHARTER SCHOOL 360003604337 140600860817 SOUTH BUFFALO CHARTER SCHOOL charter Regular School Yes 1 KG 8 2015   grade_7 50.0 15.0 12.0   2.0     0.0         47.0 32.0             61     7   79 50 15 12   2     0         47 32         61   7   79
763505 NY Erie   school 3600071 140600860851   BUFFALO UNITED CHARTER SCH 360007105538 140600860851 BUFFALO UNITED CHARTER SCHOOL charter Regular School Yes 1 KG 8 2015   grade_7 0.0 74.0 1.0   1.0     0.0         39.0 37.0             70     6   76 0 74 1   1     0         39 37         70   6   76
763524 NY Erie   school 3600073 140600860856   ENTERPRISE CHARTER SCHOOL 360007305551 140600860856 ENTERPRISE CHARTER SCHOOL charter Regular School Yes 1 KG 8 2015   grade_7 1.0 28.0 11.0   0.0     0.0     0.0   19.0 21.0             38     8   40 1 28 11   0     0     0   19 21         38   8   40
763600 NY Erie   school 3600107 140600860874   WESTMINSTER COMM CHARTER SCH 360010705604 140600860874 WESTMINSTER COMMUNITY CHARTER SCHOOL charter Regular School Yes 1 KG 8 2015   grade_7 0.0 55.0 0.0         1.0     0.0   25.0 31.0             49     *   56 0 55 0         1     0   25 31         49       56
763619 NY Erie   school 3600160 140600860896   ELMWOOD VILLAGE CHARTER SCHO 360016005851 140600860896 ELMWOOD VILLAGE CHARTER SCHOOL charter Regular School Yes 1 KG 8 2015   grade_7 10.0 7.0 4.0   0.0     0.0     3.0   12.0 12.0             13     5   24 10 7 4   0     0     3   12 12         13   5   24
763638 NY Erie   school 3600970 140600860911   ALOMA D JOHNSON CHARTER 360097006034 140600860911 ALOMA D JOHNSON CHARTER SCHOOL charter Regular School Yes 1 KG 4 2015   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
763676 NY Erie   school 3601055 140600860986   WEST BUFFALO CHARTER SCHOOL 360105506298 140600860986 WEST BUFFALO CHARTER SCHOOL charter Regular School Yes 1 KG 4 2015   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
763695 NY Erie   school 3607230 140701060000   CHEEKTOWAGA 360723000511 140701060004 UNION EAST ELEMENTARY SCHOOL public Regular School No 1 PK 4 2015   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
763771 NY Erie   school 3618600 140702030000   MARYVALE 361860001679 140702030003 MARYVALE PRIMARY SCHOOL public Regular School No 1 PK 2 2015   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
763790 NY Erie   school 3618600 140702030000   MARYVALE 361860004443 140702030004 MARYVALE INTERMEDIATE SCHOOL public Regular School No 1 03 5 2015   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
763847 NY Erie   school 3607680 140703020000   CLEVELAND HILL 360768000550 140703020002 CLEVELAND HILL ELEMENTARY SCHOOL public Regular School No 1 PK 5 2015   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
763942 NY Erie   school 3609030 140707030000   DEPEW 360903000688 140707030005 CAYUGA HTS ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
763961 NY Erie   school 3627000 140709030000   SLOAN 362700003673 140709030001 THEODORE ROOSEVELT SCHOOL public Regular School No 1 PK 2 2015   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
763980 NY Erie   school 3627000 140709030000   SLOAN 362700003674 140709030002 WOODROW WILSON ELEMENTARY SCHOOL public Regular School No 1 03 5 2015   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
764037 NY Erie   school 3607590 140801060000   CLARENCE 360759000544 140801060002 HARRIS HILL ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
764056 NY Erie   school 3607590 140801060000   CLARENCE 360759000545 140801060003 LEDGEVIEW ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
764075 NY Erie   school 3607590 140801060000   CLARENCE 360759004680 140801060005 SHERIDAN HILL ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
764113 NY Erie   school 3607590 140801060000   CLARENCE 360759000541 140801060007 CLARENCE CTR ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
764170 NY Erie   school 3612990 141101060000   SPRINGVILLE-GRIFF 361299001062 141101060002 COLDEN ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   grade_7 0.0   0.0   0.0               0.0 0.0             0     0   0 0   0   0               0 0         0   0   0
764189 NY Erie   school 3612990 141101060000   SPRINGVILLE-GRIFF 361299001066 141101060003 SPRINGVILLE ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
764246 NY Erie   school 3610170 141201060000   EDEN 361017004768 141201060002 G L PRIESS PRIMARY SCHOOL public Regular School No 1 PK 2 2015   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
764265 NY Erie   school 3610170 141201060000   EDEN 361017000790 141201060005 EDEN ELEMENTARY SCHOOL public Regular School No 1 03 6 2015   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
764303 NY Erie   school 3615360 141301060000   IROQUOIS 361536001295 141301060003 MARILLA PRIMARY SCHOOL public Regular School No 1 KG 4 2015   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
764322 NY Erie   school 3615360 141301060000   IROQUOIS 361536001296 141301060004 WALES PRIMARY SCHOOL public Regular School No 1 KG 4 2015   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
764379 NY Erie   school 3615360 141301060000   IROQUOIS 361536004796 141301060007 ELMA PRIMARY SCHOOL public Regular School No 1 KG 4 2015   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
764398 NY Erie   school 3616560 141401060000   EVANS-BRANT 361656001465 141401060001 HIGHLAND ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
764436 NY Erie   school 3616560 141401060000   EVANS-BRANT 361656001467 141401060004 JOHN T WAUGH ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
764455 NY Erie   school 3616560 141401060000   EVANS-BRANT 361656001462 141401060008 A J SCHMIDT ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
764493 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000495 141501060001 HUTH ROAD SCHOOL public Regular School No 1 02 5 2015   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
764512 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000496 141501060003 KAEGEBEIN SCHOOL public Regular School No 1 02 5 2015   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
764569 NY Erie   school 3607020 141501060000   GRAND ISLAND 360702000462 141501060006 CHARLOTTE SIDWAY SCHOOL public Regular School No 1 PK 1 2015   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
764588 NY Erie   school 3613350 141601060000   HAMBURG 361335001095 141601060001 ARMOR ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
764607 NY Erie   school 3613350 141601060000   HAMBURG 361335001096 141601060002 BOSTON VALLEY ELEMENTARY SCHOOL public Regular School No 1 KG 5 2015   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
764626 NY Erie   school 3613350 141601060000   HAMBURG 361335001097 141601060003 CHARLOTTE AVENUE ELEMENTARY SCHOOL public Regular School No 1 PK 5 2015   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
764645 NY Erie   school 3613350 141601060000   HAMBURG 361335001100 141601060004 UNION PLEASANT AVENUE ELEMENTARY SCH public Regular School No 1 KG 5 2015   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
764664 NY Erie   school 3613350 141601060000   HAMBURG 361335001098 141601060006 HAMBURG MIDDLE SCHOOL public Regular School No 1 01 8 2015   grade_7 261.0 1.0 4.0   1.0     2.0     3.0   126.0 146.0             62     26   272 261 1 4   1     2     3   126 146         62   26   272

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