Data source: Big Local News · About: Big Local

4,722 rows where grade = "grade_2", state = "NY" and year = 2017 sorted by ccd_school_low_grade descending

View and edit SQL

year

  • 2017 · 4,722

grade

  • grade_2 · 4,722
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
942039 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2017   grade_2 28.0 7.0 3.0   0.0     6.0     2.0   29.0 17.0     5       10     *   46 28 7 3   0     6     2   29 17     5   10       46
942058 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 14.0 30.0 22.0   0.0     7.0     4.0   38.0 39.0     *       43     10   77 14 30 22   0     7     4   38 39         43   10   77
942077 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 12.0 17.0 32.0   0.0     10.0     5.0   37.0 39.0     31       51     8   76 12 17 32   0     10     5   37 39     31   51   8   76
942096 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 41.0 21.0 9.0   0.0     2.0     7.0   45.0 35.0     5       27     13   80 41 21 9   0     2     7   45 35     5   27   13   80
942115 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 08 2017   grade_2 6.0 33.0 8.0         0.0     1.0   30.0 18.0     6       28     5   48 6 33 8         0     1   30 18     6   28   5   48
942153 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 17.0 12.0 6.0   0.0     6.0     1.0   26.0 16.0     8       19     0   42 17 12 6   0     6     1   26 16     8   19   0   42
942172 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2017   grade_2 12.0 27.0 10.0   0.0     16.0     2.0   43.0 24.0     5       35     *   67 12 27 10   0     16     2   43 24     5   35       67
942191 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 5.0 43.0 21.0   0.0     7.0     9.0   53.0 32.0     11       60     *   85 5 43 21   0     7     9   53 32     11   60       85
942248 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 6.0 39.0 11.0   0.0     1.0     3.0   29.0 31.0     *       44     14   60 6 39 11   0     1     3   29 31         44   14   60
942267 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2017   grade_2 5.0 24.0 6.0   0.0     3.0     5.0   24.0 19.0     7       30     *   43 5 24 6   0     3     5   24 19     7   30       43
942286 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2017   grade_2 9.0 52.0 13.0   0.0     1.0     8.0   48.0 35.0     7       63     12   83 9 52 13   0     1     8   48 35     7   63   12   83
942666 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2017   grade_2 53.0 0.0 2.0         1.0     3.0   29.0 30.0     *       25     11   59 53 0 2         1     3   29 30         25   11   59
942685 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2017   grade_2 41.0 2.0 9.0   0.0     0.0     9.0   33.0 28.0     *       29     10   61 41 2 9   0     0     9   33 28         29   10   61
942818 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2017   grade_2 47.0 6.0 11.0         4.0     7.0   38.0 37.0             28     7   75 47 6 11         4     7   38 37         28   7   75
942837 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2017   grade_2 41.0 5.0 6.0         5.0     5.0   32.0 30.0             8     7   62 41 5 6         5     5   32 30         8   7   62
943141 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2017   grade_2 16.0 0.0 0.0         0.0     0.0   6.0 10.0     *       8     *   16 16 0 0         0     0   6 10         8       16
943350 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 45.0 20.0 10.0         4.0     15.0   52.0 42.0     5       68     13   94 45 20 10         4     15   52 42     5   68   13   94
943388 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_2 35.0 0.0 1.0         2.0     1.0   18.0 21.0             19     5   39 35 0 1         2     1   18 21         19   5   39
943426 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No Other PK 12 2017   grade_2 29.0 0.0           0.0         12.0 17.0             17     *   29 29 0           0         12 17         17       29
943445 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 30.0 0.0 0.0   0.0     1.0     0.0   17.0 14.0             20     *   31 30 0 0   0     1     0   17 14         20       31
943464 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No Other PK 12 2017   grade_2 30.0   0.0               0.0   17.0 13.0             19     *   30 30   0               0   17 13         19       30
943483 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No Other PK 12 2017   grade_2 18.0 0.0 0.0         0.0         9.0 9.0             11     *   18 18 0 0         0         9 9         11       18
943502 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 23.0 0.0 2.0               0.0   12.0 13.0             21     *   25 23 0 2               0   12 13         21       25
943521 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 44.0 1.0 2.0   0.0     0.0         24.0 23.0             28     *   47 44 1 2   0     0         24 23         28       47
943540 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 17.0   0.0                   7.0 10.0             11     *   17 17   0                   7 10         11       17
943578 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 60.0 2.0 0.0         0.0     0.0   34.0 28.0             39     10   62 60 2 0         0     0   34 28         39   10   62
943616 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No Other PK 12 2017   grade_2 19.0 0.0 0.0   0.0     0.0     0.0   10.0 9.0             14     *   19 19 0 0   0     0     0   10 9         14       19
943654 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 88.0 1.0 0.0   1.0     0.0     1.0   38.0 53.0     *       61     17   91 88 1 0   1     0     1   38 53         61   17   91
943692 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No Elementary PK 08 2017   grade_2 54.0   0.0   1.0           0.0   23.0 32.0             44     8   55 54   0   1           0   23 32         44   8   55
943711 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402043 320700010001 PS 1 COURTLANDT SCHOOL public Regular School No Elementary PK 05 2017   grade_2 1.0 16.0 72.0   0.0     0.0     0.0   42.0 47.0     30       88     26   89 1 16 72   0     0     0   42 47     30   88   26   89
943730 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402056 320700010005 PS 5 PORT MORRIS public Regular School No Elementary PK 08 2017   grade_2 7.0 19.0 52.0   0.0     0.0     0.0   49.0 29.0     24       76     21   78 7 19 52   0     0     0   49 29     24   76   21   78
943749 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402098 320700010018 PS 18 JOHN PETER ZENGER public Regular School No Elementary PK 05 2017   grade_2 3.0 29.0 75.0   2.0     7.0     0.0   67.0 49.0     45       113     30   116 3 29 75   2     7     0   67 49     45   113   30   116
943768 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No Elementary PK 05 2017   grade_2 0.0 10.0 68.0   0.0     2.0     1.0   43.0 38.0     13       79     22   81 0 10 68   0     2     1   43 38     13   79   22   81
943787 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402138 320700010029 PS/MS 29 MELROSE SCHOOL public Regular School No Elementary PK 08 2017   grade_2 3.0 24.0 51.0   0.0     1.0     1.0   40.0 40.0     13       76     19   80 3 24 51   0     1     1   40 40     13   76   19   80
943806 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402143 320700010030 PS 30 WILTON public Regular School No Elementary PK 05 2017   grade_2 3.0 20.0 69.0   0.0     3.0     1.0   48.0 48.0     18       87     19   96 3 20 69   0     3     1   48 48     18   87   19   96
943825 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402147 320700010031 PS/MS 31 WILLIAM LLOYD GARRISON public Regular School No Elementary PK 08 2017   grade_2 2.0 23.0 51.0   1.0     3.0     0.0   39.0 41.0     15       76     13   80 2 23 51   1     3     0   39 41     15   76   13   80
943844 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No Elementary PK 05 2017   grade_2 0.0 21.0 50.0   0.0     0.0         38.0 33.0     12       70     16   71 0 21 50   0     0         38 33     12   70   16   71
943863 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402218 320700010049 PS 49 WILLIS AVENUE public Regular School No Elementary PK 05 2017   grade_2 0.0 32.0 87.0   0.0     0.0     1.0   63.0 57.0     22       119     32   120 0 32 87   0     0     1   63 57     22   119   32   120
943882 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402269 320700010065 PS 65 MOTHER HALE ACADEMY public Regular School No Elementary PK 05 2017   grade_2 0.0 29.0 38.0   0.0     3.0     1.0   32.0 39.0     10       71     20   71 0 29 38   0     3     1   32 39     10   71   20   71
943920 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402556 320700010154 PS 154 JONATHAN D HYATT public Regular School No Elementary PK 05 2017   grade_2 0.0 24.0 28.0   0.0     0.0     0.0   26.0 26.0     8       52     12   52 0 24 28   0     0     0   26 26     8   52   12   52
943939 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405533 320700010157 PS 157 GROVE HILL public Regular School No Elementary PK 05 2017   grade_2 1.0 26.0 75.0   0.0     0.0     2.0   54.0 50.0     10       101     22   104 1 26 75   0     0     2   54 50     10   101   22   104
943958 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402578 320700010161 PS 161 PONCE DE LEON SCHOOL public Regular School No Elementary PK 05 2017   grade_2 0.0 22.0 54.0   0.0     0.0     0.0   39.0 37.0     15       73     22   76 0 22 54   0     0     0   39 37     15   73   22   76
943996 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008405118 320700010179 PS 179 public Regular School No Elementary PK 05 2017   grade_2 0.0 5.0 45.0   0.0     0.0     3.0   24.0 29.0     22       53     13   53 0 5 45   0     0     3   24 29     22   53   13   53
944053 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008403738 320700010277 PS 277 public Regular School No Elementary PK 05 2017   grade_2 0.0 13.0 53.0   1.0     0.0     1.0   42.0 26.0     12       68     20   68 0 13 53   1     0     1   42 26     12   68   20   68
944129 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406382 320700010359 CONCOURSE VILLAGE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 2.0 20.0 36.0   0.0     1.0     0.0   23.0 36.0     12       55     20   59 2 20 36   0     1     0   23 36     12   55   20   59
944148 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008406041 320700010369 YOUNG LEADERS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 1.0 5.0 33.0               0.0   17.0 22.0     23       39     12   39 1 5 33               0   17 22     23   39   12   39
944623 NY Bronx   school 3600960 320700860925   MOTT HAVEN ACADEMY CHARTER S 360096006013 320700860925 MOTT HAVEN ACADEMY CHARTER SCHOOL charter Regular School Yes Elementary PK 05 2017   grade_2 1.0 16.0 33.0   2.0     0.0     0.0   30.0 22.0     13       50     18   52 1 16 33   2     0     0   30 22     13   50   18   52
944661 NY Bronx   school 3601001 320700860957   ACADEMIC LEADERSHIP CHARTER 360100106154 320700860957 ACADEMIC LEADERSHIP CHARTER SCHOOL charter Regular School Yes Elementary PK 08 2017   grade_2 0.0 19.0 36.0   0.0     0.0     1.0   26.0 30.0     14       54     7   56 0 19 36   0     0     1   26 30     14   54   7   56
944699 NY Bronx   school 3601044 320700861005   NYC MONTESSORI CHARTER SCHOO 360104406248 320700861005 NYC MONTESSORI CHARTER SCHOOL charter Regular School Yes Elementary PK 05 2017   grade_2 0.0 17.0 32.0   0.0     0.0     1.0   30.0 20.0     15       47     18   50 0 17 32   0     0     1   30 20     15   47   18   50
944908 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502168 320800010036 PS 36 UNIONPORT public Regular School No Elementary PK 05 2017   grade_2 3.0 13.0 72.0   4.0     24.0     0.0   58.0 58.0     19       70     24   116 3 13 72   4     24     0   58 58     19   70   24   116
944927 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502211 320800010048 PS 48 JOSEPH R DRAKE public Regular School No Elementary PK 05 2017   grade_2 2.0 27.0 97.0   1.0     2.0     1.0   74.0 56.0     32       113     43   130 2 27 97   1     2     1   74 56     32   113   43   130
944946 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502264 320800010062 PS 62 INOCENSIO CASANOVA public Regular School No Elementary PK 05 2017   grade_2 6.0 20.0 97.0   0.0     1.0     0.0   75.0 49.0     19       123     48   124 6 20 97   0     1     0   75 49     19   123   48   124
944965 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502285 320800010069 PS 69 JOURNEY PREP SCHOOL public Regular School No Elementary PK 05 2017   grade_2 1.0 11.0 75.0   0.0     1.0     1.0   41.0 48.0     6       81     23   89 1 11 75   0     1     1   41 48     6   81   23   89
944984 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502293 320800010071 PS 71 ROSE E SCALA public Regular School No Elementary PK 08 2017   grade_2 35.0 9.0 144.0   2.0     10.0     2.0   109.0 93.0     29       161     41   202 35 9 144   2     10     2   109 93     29   161   41   202
945003 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502295 320800010072 PS 72 DR WILLIAM DORNEY public Regular School No Elementary PK 05 2017   grade_2 2.0 20.0 91.0   0.0     2.0         54.0 61.0     *       90     37   115 2 20 91   0     2         54 61         90   37   115
945022 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502302 320800010075 PS 75 SCHOOL OF RESEARCH-DISCOVERY public Regular School No Elementary PK 05 2017   grade_2 3.0 25.0 68.0   0.0     1.0     0.0   47.0 50.0     21       75     28   97 3 25 68   0     1     0   47 50     21   75   28   97
945041 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502354 320800010093 PS 93 ALBERT G OLIVER public Regular School No Elementary PK 05 2017   grade_2 0.0 30.0 17.0   1.0           0.0   23.0 25.0     *       31     13   48 0 30 17   1           0   23 25         31   13   48
945060 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502380 320800010100 PS 100 ISAAC CLASON public Regular School No Elementary PK 05 2017   grade_2 1.0 25.0 51.0   2.0     0.0     1.0   40.0 40.0     *       58     22   80 1 25 51   2     0     1   40 40         58   22   80
945098 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502401 320800010107 PS 107 public Regular School No Elementary PK 05 2017   grade_2 4.0 30.0 62.0   0.0     0.0     0.0   48.0 48.0     10       96     36   96 4 30 62   0     0     0   48 48     10   96   36   96
945117 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502441 320800010119 EMMETT W BASSETT SCHOOL public Regular School No Elementary PK 05 2017   grade_2 15.0 19.0 72.0   4.0     47.0     0.0   79.0 78.0     45       109     27   157 15 19 72   4     47     0   79 78     45   109   27   157
945174 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502479 320800010130 PS 130 ABRAM STEVENS HEWITT public Regular School No Elementary PK 05 2017   grade_2 2.0 22.0 51.0   0.0     1.0         33.0 43.0     24       54     22   76 2 22 51   0     1         33 43     24   54   22   76
945212 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502505 320800010138 PS 138 SAMUEL RANDALL public Regular School No Elementary PK 05 2017   grade_2 1.0 30.0 60.0   2.0     3.0     1.0   51.0 46.0     *       92     20   97 1 30 60   2     3     1   51 46         92   20   97
945231 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502509 320800010140 PS 140 EAGLE SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_2 0.0 53.0 74.0   0.0     0.0     0.0   71.0 56.0     20       119     29   127 0 53 74   0     0     0   71 56     20   119   29   127
945250 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502530 320800010146 PS 146 EDWARD COLLINS public Regular School No Elementary PK 05 2017   grade_2 0.0 27.0 49.0   1.0     1.0     0.0   36.0 42.0     14       76     21   78 0 27 49   1     1     0   36 42     14   76   21   78
945269 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502547 320800010152 PS 152 EVERGREEN public Regular School No Elementary PK 05 2017   grade_2 2.0 30.0 115.0   1.0     1.0     0.0   64.0 85.0     51       127     31   149 2 30 115   1     1     0   64 85     51   127   31   149
945288 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008502632 320800010182 PS 182 public Regular School No Elementary PK 05 2017   grade_2 7.0 37.0 83.0   0.0     15.0     1.0   72.0 71.0     14       115     26   143 7 37 83   0     15     1   72 71     14   115   26   143
945345 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505123 320800010304 PS 304 EARLY CHILDHOOD SCHOOL public Regular School No Elementary PK 05 2017   grade_2 25.0 3.0 38.0   0.0     8.0     1.0   41.0 34.0     *       54     24   75 25 3 38   0     8     1   41 34         54   24   75
945383 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505655 320800010333 PS 333 MUSEUM SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_2 2.0 12.0 67.0   0.0     1.0     0.0   43.0 39.0     25       71     29   82 2 12 67   0     1     0   43 39     25   71   29   82
945402 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008505656 320800010335 ACADEMY OF THE ARTS (THE) public Regular School No Elementary PK 05 2017   grade_2 1.0 16.0 33.0   0.0           0.0   24.0 26.0     7       48     16   50 1 16 33   0           0   24 26     7   48   16   50
945478 NY Bronx   school 3600085 320800010000   NYC GEOG DIST # 8 - BRONX 360008506506 320800010392 BRONX DELTA SCHOOL public Regular School No Elementary PK 05 2017   grade_2 8.0 3.0 25.0         2.0     1.0   21.0 18.0     *       30     11   39 8 3 25         2     1   21 18         30   11   39
946010 NY Bronx   school 3600986 320800860940   GIRLS PREP CHARTER-BRONX 360098606161 320800860940 GIRLS PREP CHARTER SCH-BRONX charter Regular School Yes Elementary PK 08 2017   grade_2 1.0 13.0 60.0   0.0     1.0     2.0   0.0 77.0     8       67     9   77 1 13 60   0     1     2   0 77     8   67   9   77
946124 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605191 320900010004 PS/MS 4 CROTONA PARK WEST public Regular School No Elementary PK 08 2017   grade_2 1.0 30.0 21.0   0.0     1.0         36.0 17.0     6       53     11   53 1 30 21   0     1         36 17     6   53   11   53
946181 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602133 320900010028 PS 28 MOUNT HOPE public Regular School No Elementary PK 05 2017   grade_2 2.0 20.0 112.0         1.0     0.0   79.0 56.0     48       128     39   135 2 20 112         1     0   79 56     48   128   39   135
946219 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602188 320900010042 PS 42 CLAREMONT public Regular School No Elementary PK 05 2017   grade_2 0.0 28.0 32.0   0.0     0.0         31.0 29.0     15       60     14   60 0 28 32   0     0         31 29     15   60   14   60
946238 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602232 320900010053 PS 53 BASHEER QUISIM public Regular School No Elementary PK 05 2017   grade_2 3.0 56.0 104.0   0.0     2.0     0.0   84.0 81.0     42       144     30   165 3 56 104   0     2     0   84 81     42   144   30   165
946257 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602238 320900010055 PS 55 BENJAMIN FRANKLIN public Regular School No Elementary PK 05 2017   grade_2 2.0 55.0 50.0         0.0         53.0 54.0     13       101     18   107 2 55 50         0         53 54     13   101   18   107
946276 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602250 320900010058 PS 58 public Regular School No Elementary PK 06 2017   grade_2 2.0 22.0 57.0   0.0     2.0     1.0   45.0 39.0     19       75     24   84 2 22 57   0     2     1   45 39     19   75   24   84
946295 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008605561 320900010063 PS 63 AUTHOR'S ACADEMY public Regular School No Elementary PK 05 2017   grade_2 4.0 37.0 44.0   1.0     0.0     0.0   51.0 35.0     25       84     18   86 4 37 44   1     0     0   51 35     25   84   18   86
946333 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602298 320900010073 PS 73 BRONX public Regular School No Elementary PK 05 2017   grade_2 0.0 31.0 97.0   1.0     0.0     2.0   70.0 61.0     46       117     33   131 0 31 97   1     0     2   70 61     46   117   33   131
946352 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602338 320900010088 PS 88 S SILVERSTEIN LITTLE SPARROW public Regular School No Elementary PK 03 2017   grade_2   8.0 23.0         0.0     0.0   13.0 18.0     5       *     *   31   8 23         0     0   13 18     5           31
946371 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602410 320900010109 PS 109 SEDGWICK public Regular School No Elementary PK 05 2017   grade_2 0.0 14.0 76.0   0.0               45.0 45.0     36       83     19   90 0 14 76   0               45 45     36   83   19   90
946390 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602413 320900010110 PS 110 THEODORE SCHOENFELD public Regular School No Elementary PK 05 2017   grade_2 5.0 30.0 53.0         0.0         46.0 42.0     20       82     19   88 5 30 53         0         46 42     20   82   19   88
946447 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602465 320900010126 PS 126 DR MARJORIE H DUNBAR public Regular School No Elementary PK 06 2017   grade_2 3.0 22.0 77.0   0.0     1.0     0.0   44.0 59.0     28       102     13   103 3 22 77   0     1     0   44 59     28   102   13   103
946485 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602486 320900010132 PS 132 GARRETT A MORGAN public Regular School No Elementary PK 05 2017   grade_2 0.0 31.0 43.0   0.0     0.0         39.0 35.0     12       64     18   74 0 31 43   0     0         39 35     12   64   18   74
946523 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602583 320900010163 PS 163 ARTHUR A SCHOMBERG public Regular School No Elementary PK 05 2017   grade_2 2.0 35.0 48.0   0.0     1.0         37.0 49.0     40       86     17   86 2 35 48   0     1         37 49     40   86   17   86
946561 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604459 320900010199 PS 199 SHAKESPEARE SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_2 3.0 41.0 92.0   1.0     2.0         73.0 66.0     47       139     35   139 3 41 92   1     2         73 66     47   139   35   139
946580 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008604808 320900010204 PS 204 MORRIS HEIGHTS public Regular School No Elementary PK 05 2017   grade_2 1.0 23.0 72.0   0.0     0.0     0.0   50.0 46.0     9       75     20   96 1 23 72   0     0     0   50 46     9   75   20   96
946694 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008602751 320900010236 PS 236 LANGSTON HUGHES public Regular School No Elementary PK 05 2017   grade_2 2.0 13.0 34.0   0.0     0.0     0.0   24.0 25.0     7       48     12   49 2 13 34   0     0     0   24 25     7   48   12   49
946713 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606391 320900010274 NEW AMERICAN ACAD-R CLEMENTE STATE public Regular School No Elementary PK 05 2017   grade_2 2.0 42.0 85.0   1.0     0.0     0.0   72.0 58.0     41       120     41   130 2 42 85   1     0     0   72 58     41   120   41   130
946922 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606132 320900010443 FAMILY SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_2 2.0 23.0 49.0   1.0     7.0     0.0   40.0 42.0     37       73     22   82 2 23 49   1     7     0   40 42     37   73   22   82
946941 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606121 320900010449 GRANT AVENUE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 0.0 23.0 46.0   2.0     5.0     1.0   35.0 42.0     14       76     17   77 0 23 46   2     5     1   35 42     14   76   17   77
946998 NY Bronx   school 3600086 320900010000   NYC GEOG DIST # 9 - BRONX 360008606312 320900010555 MOUNT EDEN CHILDREN'S ACADEMY public Regular School No Elementary PK 05 2017   grade_2 0.0 9.0 59.0   0.0     0.0     0.0   32.0 36.0     23       65     16   68 0 9 59   0     0     0   32 36     23   65   16   68
947663 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008705137 321000010003 PS 3 RAUL JULIA MICRO SOCIETY public Regular School No Elementary PK 08 2017   grade_2 0.0 8.0 26.0   0.0     1.0         16.0 19.0     6       34     5   35 0 8 26   0     1         16 19     6   34   5   35
947720 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702067 321000010009 PS 9 RYER AVENUE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 2.0 19.0 96.0   0.0     0.0     0.0   61.0 56.0     56       107     25   117 2 19 96   0     0     0   61 56     56   107   25   117
947758 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702179 321000010020 PS/MS 20 PO GEORGE J WERDAN III public Regular School No Elementary PK 08 2017   grade_2 10.0 13.0 88.0   4.0     7.0     0.0   71.0 51.0     33       117     35   122 10 13 88   4     7     0   71 51     33   117   35   122
947777 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700130 321000010023 PS 23 NEW CHILDREN'S SCHOOL (THE) public Regular School No Elementary PK 05 2017   grade_2 0.0 22.0 41.0   0.0     2.0     1.0   23.0 43.0     17       57     16   66 0 22 41   0     2     1   23 43     17   57   16   66
947815 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702150 321000010032 PS 32 BELMONT public Regular School No Elementary PK 05 2017   grade_2 3.0 32.0 107.0   0.0     2.0     0.0   64.0 80.0     26       143     37   144 3 32 107   0     2     0   64 80     26   143   37   144
947834 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008702155 321000010033 PS 33 TIMOTHY DWIGHT public Regular School No Elementary PK 05 2017   grade_2 4.0 11.0 131.0   3.0     3.0     1.0   80.0 73.0     41       115     30   153 4 11 131   3     3     1   80 73     41   115   30   153
947910 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008700127 321000010051 PS 51 BRONX NEW SCHOOL public Regular School No Elementary PK 05 2017   grade_2 0.0 14.0 25.0   0.0     1.0         17.0 23.0     *       35     5   40 0 14 25   0     1         17 23         35   5   40
947929 NY Bronx   school 3600087 321000010000   NYC GEOG DIST #10 - BRONX 360008703783 321000010054 PS/IS 54 public Regular School No Elementary PK 05 2017   grade_2 1.0 23.0 49.0   0.0     2.0         42.0 33.0     18       74     12   75 1 23 49   0     2         42 33     18   74   12   75

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