Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_1" and state = "NY"

View and edit SQL

year

grade

  • grade_1 · 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
745199 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 29.0 7.0 2.0   0.0     1.0     3.0   19.0 23.0             10     *   42 29 7 2   0     1     3   19 23         10       42
745218 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No 1.0 PK 07 2015   grade_1 19.0 28.0 15.0         8.0     7.0   44.0 33.0             53     10   77 19 28 15         8     7   44 33         53   10   77
745237 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 12.0 26.0 26.0   1.0     10.0     3.0   36.0 42.0             57     8   78 12 26 26   1     10     3   36 42         57   8   78
745256 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 53.0 17.0 8.0   0.0     10.0     5.0   56.0 37.0             23     10   93 53 17 8   0     10     5   56 37         23   10   93
745275 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No 1.0 PK 08 2015   grade_1 2.0 24.0 8.0   0.0     1.0     3.0   19.0 19.0             38     0   38 2 24 8   0     1     3   19 19         38   0   38
745294 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No 1.0 PK 06 2015   grade_1 9.0 33.0 15.0   0.0     5.0     5.0   36.0 31.0             40     5   67 9 33 15   0     5     5   36 31         40   5   67
745313 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_1 28.0 10.0 2.0   0.0     4.0     2.0   22.0 24.0             17     0   46 28 10 2   0     4     2   22 24         17   0   46
745332 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No 1.0 PK 06 2015   grade_1 17.0 33.0 9.0   0.0     15.0     4.0   48.0 30.0             48     *   78 17 33 9   0     15     4   48 30         48       78
745351 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_1 5.0 54.0 19.0   1.0     10.0     8.0   55.0 42.0             87     14   97 5 54 19   1     10     8   55 42         87   14   97
745370 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
745389 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
745408 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_1 1.0 41.0 10.0   0.0     0.0     5.0   34.0 23.0             53     5   57 1 41 10   0     0     5   34 23         53   5   57
745427 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No 1.0 PK 05 2015   grade_1 2.0 11.0 9.0         4.0     11.0   21.0 16.0             34     *   37 2 11 9         4     11   21 16         34       37
745446 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No 1.0 PK 05 2015   grade_1 7.0 39.0 11.0         0.0     7.0   27.0 37.0             56     0   64 7 39 11         0     7   27 37         56   0   64
745465 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
745484 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes 1.0 KG 04 2015   grade_1 1.0 52.0 7.0         0.0     0.0   60.0               60     *   60 1 52 7         0     0   60           60       60
745503 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes 1.0 KG 04 2015   grade_1 3.0 44.0 11.0         1.0     0.0     59.0             59     0   59 3 44 11         1     0     59         59   0   59
745522 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes 2.0 05 08 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0         0 0 0 0   0     0     0   0 0         0       0
745541 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes 1.0 KG 04 2015   grade_1 1.0 56.0 18.0   0.0     0.0     4.0   36.0 43.0             75     *   79 1 56 18   0     0     4   36 43         75       79
745560 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2015   grade_1 3.0 69.0 1.0         1.0         34.0 40.0             64     *   74 3 69 1         1         34 40         64       74
745579 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes 3.0 09 12 2015   grade_1 0.0 0.0           0.0         0.0               0     0   0 0 0           0         0           0   0   0
745598 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2015   grade_1 0.0 0.0 0.0         0.0           0.0             0     0   0 0 0 0         0           0         0   0   0
745617 NY Albany   school 3601020 10100860976   BRIGHTER CHOICE CHARTER MIDD 360102006227 10100860976 BRIGHTER CHOICE CHARTER MIDDLE-BOYS charter Regular School Yes 2.0 05 08 2015   grade_1 0.0 0.0 0.0   0.0     0.0         0.0               0     0   0 0 0 0   0     0         0           0   0   0
745636 NY Albany   school 3601021 10100860977   BRIGHTER CHOICE CHARTER MIDD 360102106231 10100860977 BRIGHTER CHOICE CHARTER MIDDLE-GIRLS charter Regular School Yes 2.0 05 08 2015   grade_1 0.0 0.0 0.0         0.0     0.0     0.0             0     0   0 0 0 0         0     0     0         0   0   0
745655 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2015   grade_1 0.0 0.0     0.0     0.0     0.0   0.0 0.0             0     0   0 0 0     0     0     0   0 0         0   0   0
745674 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No 1.0 KG 06 2015   grade_1 50.0 0.0 1.0         0.0     1.0   23.0 29.0             *     *   52 50 0 1         0     1   23 29                 52
745693 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 39.0 0.0 1.0         1.0     0.0   19.0 22.0             7     8   41 39 0 1         1     0   19 22         7   8   41
745712 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 52.0 1.0 0.0   0.0     3.0         32.0 24.0             9     *   56 52 1 0   0     3         32 24         9       56
745731 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 46.0 1.0 0.0         1.0         27.0 21.0             *     6   48 46 1 0         1         27 21             6   48
745750 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 71.0 5.0 2.0         8.0     0.0   41.0 45.0             9     9   86 71 5 2         8     0   41 45         9   9   86
745769 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
745788 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
745807 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 52.0 2.0 0.0         4.0     0.0   31.0 27.0             *     *   58 52 2 0         4     0   31 27                 58
745826 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No 3.0 09 12 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
745845 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 61.0 0.0 3.0         2.0     3.0   36.0 33.0             21     *   69 61 0 3         2     3   36 33         21       69
745864 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 61.0 3.0 7.0         0.0     2.0   36.0 37.0             28     15   73 61 3 7         0     2   36 37         28   15   73
745883 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No 2.0 06 08 2015   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
745902 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 52.0 5.0 3.0   0.0     0.0     3.0   37.0 26.0             47     *   63 52 5 3   0     0     3   37 26         47       63
745921 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 19.0 4.0 1.0               0.0   11.0 13.0             16     *   24 19 4 1               0   11 13         16       24
745940 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
745959 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
745978 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 57.0 2.0 6.0   0.0     1.0     4.0   39.0 31.0             51     8   70 57 2 6   0     1     4   39 31         51   8   70
745997 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No 1.0 PK 04 2015   grade_1 49.0 3.0 6.0         6.0     6.0   32.0 38.0             31     8   70 49 3 6         6     6   32 38         31   8   70
746016 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No 1.0 PK 04 2015   grade_1 43.0 3.0 5.0   0.0     7.0     6.0   24.0 40.0             20     6   64 43 3 5   0     7     6   24 40         20   6   64
746035 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2015   grade_1 51.0 4.0 3.0   0.0     14.0     2.0   37.0 37.0             27     *   74 51 4 3   0     14     2   37 37         27       74
746054 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746073 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2015   grade_1 35.0 5.0 2.0   0.0     9.0     1.0   22.0 30.0             *     8   52 35 5 2   0     9     1   22 30             8   52
746092 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No 1.0 KG 04 2015   grade_1 56.0 4.0 8.0         6.0     7.0   36.0 45.0             17     7   81 56 4 8         6     7   36 45         17   7   81
746111 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No 2.0 05 08 2015   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746130 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No 2.0 05 08 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746149 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No 1.0 KG 08 2015   grade_1 7.0 3.0 1.0         12.0     1.0   10.0 14.0             6     *   24 7 3 1         12     1   10 14         6       24
746168 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No 1.0 KG 06 2015   grade_1 40.0 1.0 5.0         21.0     6.0   46.0 27.0             20     12   73 40 1 5         21     6   46 27         20   12   73
746187 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No 1.0 KG 06 2015   grade_1 42.0 4.0 4.0   0.0     22.0     0.0   33.0 39.0             11     8   72 42 4 4   0     22     0   33 39         11   8   72
746206 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No 1.0 KG 06 2015   grade_1 39.0 1.0 3.0   0.0     6.0     4.0   27.0 26.0             8     *   53 39 1 3   0     6     4   27 26         8       53
746225 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No 1.0 KG 06 2015   grade_1 40.0 2.0 1.0         11.0     5.0   27.0 32.0             16     *   59 40 2 1         11     5   27 32         16       59
746244 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No 1.0 KG 06 2015   grade_1 37.0 1.0 2.0   0.0     1.0     1.0   25.0 17.0             *     *   42 37 1 2   0     1     1   25 17                 42
746263 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No 1.0 KG 06 2015   grade_1 22.0 4.0 0.0   1.0     12.0     1.0   20.0 20.0             9     9   40 22 4 0   1     12     1   20 20         9   9   40
746282 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No 2.0 07 08 2015   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746301 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746320 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 25.0 1.0 0.0         0.0     0.0   14.0 12.0             19     *   26 25 1 0         0     0   14 12         19       26
746339 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 25.0 1.0 1.0         1.0     1.0   18.0 11.0             8     *   29 25 1 1         1     1   18 11         8       29
746358 NY Albany   school 3613080 10802060000   GUILDERLAND 361308004589 10802060003 GUILDERLAND ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 55.0 2.0 4.0         25.0     1.0   47.0 40.0             15     9   87 55 2 4         25     1   47 40         15   9   87
746377 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 64.0 4.0 1.0         14.0     2.0   44.0 41.0             21     10   85 64 4 1         14     2   44 41         21   10   85
746396 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746415 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 47.0 5.0 3.0   0.0     7.0     1.0   40.0 23.0             11     11   63 47 5 3   0     7     1   40 23         11   11   63
746434 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746453 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 45.0 1.0 2.0         10.0     2.0   32.0 28.0             *     *   60 45 1 2         10     2   32 28                 60
746472 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_1 58.0 0.0 4.0   0.0     3.0     0.0   18.0 47.0             6     *   65 58 0 4   0     3     0   18 47         6       65
746491 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746510 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_1 0.0 0.0     0.0     0.0     0.0   0.0 0.0             0     0   0 0 0     0     0     0   0 0         0   0   0
746529 NY Albany   school 3630210 11200010000   WATERVLIET 363021004060 11200010002 WATERVLIET ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_1 57.0 13.0 16.0         5.0     14.0   48.0 57.0             75     12   105 57 13 16         5     14   48 57         75   12   105
746548 NY Albany   school 3630210 11200010000   WATERVLIET 363021004061 11200010010 WATERVLIET JUNIOR-SENIOR HIGH SCHOOL public Regular School No 3.0 07 12 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746567 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000045 20101040001 ALFRED-ALMOND ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2015   grade_1 45.0   0.0         2.0     2.0   25.0 24.0             21     *   49 45   0         2     2   25 24         21       49
746586 NY Allegany   school 3602700 20101040000   ALFRED ALMOND 360270000046 20101040002 ALFRED-ALMOND JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2015   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746605 NY Allegany   school 3603030 20601040000   ANDOVER 360303000077 20601040001 ANDOVER SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 22.0 0.0 0.0         0.0         8.0 14.0             13     *   22 22 0 0         0         8 14         13       22
746624 NY Allegany   school 3600017 20702040000   GENESEE VALLEY CSD 360001701925 20702040001 GENESEE VALLEY CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 33.0 0.0 1.0   0.0     0.0     0.0   22.0 12.0             25     6   34 33 0 1   0     0     0   22 12         25   6   34
746643 NY Allegany   school 3604350 20801040000   BELFAST 360435000187 20801040001 BELFAST SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 30.0   0.0               1.0   16.0 15.0             15     5   31 30   0               1   16 15         15   5   31
746662 NY Allegany   school 3606360 21102040000   CANASERAGA 360636000418 21102040001 CANASERAGA SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 14.0   0.0         0.0         8.0 6.0             6     *   14 14   0         0         8 6         6       14
746681 NY Allegany   school 3611640 21601040000   FRIENDSHIP 361164000919 21601040004 FRIENDSHIP CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 20.0   0.0               2.0   7.0 15.0             12     *   22 20   0               2   7 15         12       22
746700 NY Allegany   school 3611070 22001040000   FILLMORE 361107004552 22001040001 FILLMORE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 48.0 0.0 1.0   1.0     1.0         27.0 24.0             32     8   51 48 0 1   1     1         27 24         32   8   51
746719 NY Allegany   school 3631350 22101040000   WHITESVILLE 363135004575 22101040001 WHITESVILLE CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 14.0   1.0                   9.0 6.0             8     *   15 14   1                   9 6         8       15
746738 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000050 22302040001 CUBA-RUSHFORD HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746757 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201000051 22302040002 CUBA-RUSHFORD ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 69.0 0.0 1.0   0.0     0.0         32.0 38.0             48     11   70 69 0 1   0     0         32 38         48   11   70
746776 NY Allegany   school 3632010 22302040000   CUBA-RUSHFORD 363201004855 22302040004 CUBA-RUSHFORD MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_1 0.0 0.0 0.0         0.0     0.0   0.0 0.0             0     0   0 0 0 0         0     0   0 0         0   0   0
746795 NY Allegany   school 3626190 22401040000   SCIO 362619003604 22401040003 SCIO CENTRAL SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 26.0 1.0 1.0   0.0     0.0     1.0   17.0 12.0             21     *   29 26 1 1   0     0     1   17 12         21       29
746814 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004097 22601060002 WELLSVILLE MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746833 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004099 22601060004 WELLSVILLE SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2015   grade_1 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
746852 NY Allegany   school 3630480 22601060000   WELLSVILLE 363048004098 22601060005 WELLSVILLE ELEMENTARY SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 86.0 1.0 2.0   0.0     1.0     0.0   42.0 48.0             56     10   90 86 1 2   0     1     0   42 48         56   10   90
746871 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201092 22902040001 BOLIVAR-RICHBURG JUNIOR-SENIOR HS public Regular School No 4.0 06 12 2015   grade_1 0.0 0.0 0.0   0.0           0.0   0.0 0.0             0     0   0 0 0 0   0           0   0 0         0   0   0
746890 NY Allegany   school 3600012 22902040000   BOLIVAR-RICHBURG 360001201101 22902040002 BOLIVAR-RICHBURG ELEMENTARY SCHOOL public Regular School No 4.0 PK 12 2015   grade_1 55.0 1.0 1.0   0.0           0.0   28.0 29.0             43     9   57 55 1 1   0           0   28 29         43   9   57
746909 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402043 320700010001 PS 1 COURTLANDT SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 3.0 28.0 77.0   0.0     1.0         49.0 60.0             105     *   109 3 28 77   0     1         49 60         105       109
746928 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402056 320700010005 PS 5 PORT MORRIS public Regular School No 1.0 PK 08 2015   grade_1 1.0 19.0 51.0   0.0     0.0     1.0   37.0 35.0             63     12   72 1 19 51   0     0     1   37 35         63   12   72
746947 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402098 320700010018 PS 18 JOHN PETER ZENGER public Regular School No 1.0 PK 05 2015   grade_1 2.0 18.0 59.0   6.0     3.0     1.0   51.0 38.0             82     22   89 2 18 59   6     3     1   51 38         82   22   89
746966 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402122 320700010025 PS 25 BILINGUAL SCHOOL public Regular School No 1.0 PK 05 2015   grade_1 0.0 10.0 76.0   0.0     0.0     1.0   54.0 33.0             84     24   87 0 10 76   0     0     1   54 33         84   24   87
746985 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402138 320700010029 PS/MS 29 MELROSE SCHOOL public Regular School No 1.0 PK 08 2015   grade_1 0.0 19.0 48.0   0.0     1.0     1.0   36.0 33.0             68     16   69 0 19 48   0     1     1   36 33         68   16   69
747004 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402143 320700010030 PS 30 WILTON public Regular School No 1.0 PK 05 2015   grade_1 3.0 18.0 63.0   1.0     1.0         38.0 48.0             84     11   86 3 18 63   1     1         38 48         84   11   86
747023 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402147 320700010031 PS/MS 31 THE WILLIAM LLOYD GARRISON public Regular School No 1.0 PK 08 2015   grade_1 1.0 22.0 59.0   1.0     2.0         39.0 46.0             82     12   85 1 22 59   1     2         39 46         82   12   85
747042 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402191 320700010043 PS 43 JONAS BRONCK public Regular School No 1.0 PK 05 2015   grade_1 1.0 22.0 67.0   1.0     0.0     0.0   37.0 54.0             85     24   91 1 22 67   1     0     0   37 54         85   24   91
747061 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402218 320700010049 PS 49 WILLIS AVENUE public Regular School No 1.0 PK 05 2015   grade_1 0.0 37.0 77.0   0.0     1.0     1.0   70.0 46.0             115     28   116 0 37 77   0     1     1   70 46         115   28   116
747080 NY Bronx   school 3600084 320700010000   NYC GEOG DIST # 7 - BRONX 360008402269 320700010065 PS 65 MOTHER HALE ACADEMY public Regular School No 1.0 PK 05 2015   grade_1 0.0 21.0 41.0   0.0     4.0     0.0   38.0 28.0             66     *   66 0 21 41   0     4     0   38 28         66       66

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