enrollments

Data source: Big Local News · About: Big Local

4,719 rows where grade = "grade_1", state = "NY" and year = 2019 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 4,719 ✖

grade ✖

  • grade_1 · 4,719 ✖
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
2153172 2153172 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459000202 100308020001 BERKSHIRE JUNIOR-SENIOR HIGH SCHOOL public Special Education School No High 07 12 2019   grade_1 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
2153191 2153191 NY Columbia   school 3604590 100308020000   BERKSHIRE 360459006542 100308020002 WARREN STREET ACADEMY public Alternative School No High 07 12 2019   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
2153210 2153210 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003886 100501040003 TACONIC HILLS JUNIOR/SENIOR HIGH public Regular School No High 07 12 2019   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   0   0
2153229 2153229 NY Columbia   school 3628620 100501040000   TACONIC HILLS 362862003468 100501040006 TACONIC HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 57.0 4.0 12.0   0.0     0.0     7.0   42.0 38.0     5       51     6   80 57 4 12   0     0     7   42 38     5   51   6   80
2153248 2153248 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006321 100902040003 GERMANTOWN ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 25.0   5.0         0.0     2.0   15.0 17.0     *       16     5   32 25   5         0     2   15 17         16   5   32
2153267 2153267 NY Columbia   school 3612030 100902040000   GERMANTOWN 361203006337 100902040004 GERMANTOWN JUNIOR-SENIOR HIGH SCHOOL public Regular School No High 07 12 2019   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
2139093 2139093 NY Albany   school 3602460 10100010000   ALBANY 360246000222 10100010014 MONTESSORI MAGNET SCHOOL public Regular School No Elementary PK 05 2019   grade_1 26.0 10.0 6.0         4.0     6.0   30.0 22.0     *       20     5   52 26 10 6         4     6   30 22         20   5   52
2139112 2139112 NY Albany   school 3602460 10100010000   ALBANY 360246000020 10100010016 PINE HILLS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_1 11.0 23.0 10.0   0.0     5.0     7.0   26.0 30.0     *       38     8   56 11 23 10   0     5     7   26 30         38   8   56
2139131 2139131 NY Albany   school 3602460 10100010000   ALBANY 360246000022 10100010018 DELAWARE COMMUNITY SCHOOL public Regular School No Elementary PK 05 2019   grade_1 8.0 14.0 38.0         10.0     3.0   39.0 34.0     26       58     10   73 8 14 38         10     3   39 34     26   58   10   73
2139150 2139150 NY Albany   school 3602460 10100010000   ALBANY 360246000023 10100010019 NEW SCOTLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 35.0 13.0 15.0   0.0     11.0     8.0   36.0 46.0     *       36     *   82 35 13 15   0     11     8   36 46         36       82
2139169 2139169 NY Albany   school 3602460 10100010000   ALBANY 360246000024 10100010020 NORTH ALBANY ACADEMY public Regular School No Elementary PK 05 2019   grade_1 3.0 17.0 4.0         2.0     4.0   16.0 14.0     *       27     *   30 3 17 4         2     4   16 14         27       30
2139188 2139188 NY Albany   school 3602460 10100010000   ALBANY 360246000026 10100010023 ALBANY SCHOOL OF HUMANITIES public Regular School No Elementary PK 06 2019   grade_1 4.0 42.0 13.0   0.0     7.0     7.0   31.0 42.0     *       49     9   73 4 42 13   0     7     7   31 42         49   9   73
2139207 2139207 NY Albany   school 3602460 10100010000   ALBANY 360246000028 10100010027 EAGLE POINT ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 20.0 10.0 5.0         2.0     5.0   23.0 19.0     *       16     *   42 20 10 5         2     5   23 19         16       42
2139226 2139226 NY Albany   school 3602460 10100010000   ALBANY 360246000031 10100010028 THOMAS S O'BRIEN ACAD OF SCI & TECH public Regular School No Elementary PK 06 2019   grade_1 2.0 20.0 13.0   0.0     11.0     9.0   30.0 25.0     *       41     *   55 2 20 13   0     11     9   30 25         41       55
2139245 2139245 NY Albany   school 3602460 10100010000   ALBANY 360246000016 10100010029 GIFFEN MEMORIAL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_1 6.0 37.0 21.0   0.0     10.0     6.0   36.0 44.0     8       73     18   80 6 37 21   0     10     6   36 44     8   73   18   80
2139264 2139264 NY Albany   school 3602460 10100010000   ALBANY 360246000032 10100010030 WILLIAM S HACKETT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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   0   0
2139283 2139283 NY Albany   school 3602460 10100010000   ALBANY 360246000014 10100010034 ALBANY HIGH SCHOOL public Regular School No High 09 12 2019   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   0   0
2139302 2139302 NY Albany   school 3602460 10100010000   ALBANY 360246000015 10100010039 ARBOR HILL ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 1.0 26.0 11.0         1.0     2.0   23.0 18.0     *       37     *   41 1 26 11         1     2   23 18         37       41
2139321 2139321 NY Albany   school 3602460 10100010000   ALBANY 360246005592 10100010043 P J SCHUYLER ACHIEVEMENT ACADEMY public Regular School No Elementary PK 05 2019   grade_1 2.0 15.0 7.0   0.0     8.0     4.0   15.0 21.0     7       35     0   36 2 15 7   0     8     4   15 21     7   35   0   36
2139340 2139340 NY Albany   school 3602460 10100010000   ALBANY 360246005593 10100010044 SHERIDAN PREP ACADEMY public Regular School No Elementary PK 05 2019   grade_1 4.0 35.0 9.0   0.0     3.0     8.0   32.0 27.0     *       55     17   59 4 35 9   0     3     8   32 27         55   17   59
2139359 2139359 NY Albany   school 3602460 10100010000   ALBANY 360246005747 10100010045 MYERS MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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   0   0
2139378 2139378 NY Albany   school 3602460 10100010000   ALBANY 360246006624 10100010050 EDMUND J O'NEAL MS OF EXCELLENCE public Regular School No Middle 06 08 2019   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
2153286 2153286 NY Columbia   school 3607110 101001040000   CHATHAM 360711000502 101001040001 MARY E DARDESS ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_1 73.0 0.0 6.0   0.0     0.0     3.0   41.0 41.0     *       50     14   82 73 0 6   0     0     3   41 41         50   14   82
2153305 2153305 NY Columbia   school 3607110 101001040000   CHATHAM 360711000500 101001040002 CHATHAM HIGH SCHOOL public Regular School No High 09 12 2019   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
2153324 2153324 NY Columbia   school 3607110 101001040000   CHATHAM 360711000503 101001040006 CHATHAM MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2139397 2139397 NY Albany   school 3600032 10100860829   BRIGHTER CHOICE CHARTER-BOYS 360003204307 10100860829 BRIGHTER CHOICE CHARTER SCHOOL-BOYS charter Regular School Yes Elementary KG 05 2019   grade_1 6.0 36.0 7.0         3.0     7.0   59.0 0.0     7       56     7   59 6 36 7         3     7   59 0     7   56   7   59
2139416 2139416 NY Albany   school 3600033 10100860830   BRIGHTER CHOICE CHARTER-GIRLS 360003304311 10100860830 BRIGHTER CHOICE CHARTER SCHOOL-GIRLS charter Regular School Yes Elementary KG 05 2019   grade_1 1.0 48.0 5.0         3.0     6.0     63.0     8       58     0   63 1 48 5         3     6     63     8   58   0   63
2139435 2139435 NY Albany   school 3600128 10100860867   KIPP TECH VALLEY CHARTER SCH 360012805750 10100860867 KIPP TECH VALLEY CHARTER SCHOOL charter Regular School Yes Middle KG 08 2019   grade_1 2.0 78.0 10.0   0.0     1.0     7.0   76.0 22.0     *       71     5   98 2 78 10   0     1     7   76 22         71   5   98
2139454 2139454 NY Albany   school 3600946 10100860892   HENRY JOHNSON CHARTER SCHOOL 360094605936 10100860892 HENRY JOHNSON CHARTER SCHOOL charter Regular School Yes Elementary KG 04 2019   grade_1 3.0 49.0 13.0               8.0   33.0 40.0     *       59     *   73 3 49 13               8   33 40         59       73
2139473 2139473 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2019   grade_1 0.0 64.0 9.0         0.0     1.0   27.0 47.0     *       69     *   74 0 64 9         0     1   27 47         69       74
2139492 2139492 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 09 12 2019   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
2139511 2139511 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2019   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
2153343 2153343 NY Columbia   school 3614940 101300010000   HUDSON 361494001249 101300010001 HUDSON HIGH SCHOOL public Regular School No High 09 12 2019   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
2153362 2153362 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH ELEMENTARY public Regular School No Elementary PK 05 2019   grade_1 54.0 15.0 18.0   0.0     15.0     19.0   64.0 57.0     15       88     16   121 54 15 18   0     15     19   64 57     15   88   16   121
2153381 2153381 NY Columbia   school 3614940 101300010000   HUDSON 361494006579 101300010004 HUDSON JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2019   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   0   0
2153400 2153400 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_1 113.0 1.0 26.0   1.0     2.0     9.0   71.0 81.0     22       60     15   152 113 1 26   1     2     9   71 81     22   60   15   152
2153419 2153419 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001279 101401040005 ICHABOD CRANE SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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
2153438 2153438 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No Middle 04 08 2019   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
2153457 2153457 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2019   grade_1 27.0 0.0 0.0               0.0   15.0 12.0             12     5   27 27 0 0               0   15 12         12   5   27
2153476 2153476 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2019   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
2139530 2139530 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2019   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
2139549 2139549 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2019   grade_1 66.0 0.0 1.0         0.0     1.0   38.0 30.0             30     9   68 66 0 1         0     1   38 30         30   9   68
2139568 2139568 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000213 10306060003 ELSMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 35.0 2.0 1.0         2.0     0.0   26.0 14.0             8     7   40 35 2 1         2     0   26 14         8   7   40
2139587 2139587 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000214 10306060004 GLENMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 45.0 2.0 1.0         3.0     4.0   23.0 32.0     *       5     8   55 45 2 1         3     4   23 32         5   8   55
2139606 2139606 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000215 10306060005 HAMAGRAEL ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 43.0 1.0 2.0         1.0     1.0   31.0 17.0             6     15   48 43 1 2         1     1   31 17         6   15   48
2139625 2139625 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000216 10306060006 SLINGERLANDS ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 53.0 0.0 1.0         7.0     6.0   33.0 34.0     *       *     6   67 53 0 1         7     6   33 34             6   67
2139644 2139644 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000210 10306060007 BETHLEHEM CENTRAL MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2139663 2139663 NY Albany   school 3604710 10306060000   BETHLEHEM 360471000211 10306060008 BETHLEHEM CENTRAL SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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
2139682 2139682 NY Albany   school 3604710 10306060000   BETHLEHEM 360471006072 10306060009 EAGLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 52.0 2.0 2.0   0.0     6.0     2.0   32.0 32.0     *       7     14   64 52 2 2   0     6     2   32 32         7   14   64
2139701 2139701 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003327 10402060001 RAVENA-COEYMANS-SELKIRK SR HS public Regular School No High 09 12 2019   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
2139720 2139720 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003323 10402060002 ALBERTUS W BECKER SCHOOL public Regular School No Elementary PK 05 2019   grade_1 48.0 3.0 6.0         2.0     3.0   22.0 40.0             27     11   62 48 3 6         2     3   22 40         27   11   62
2139739 2139739 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003324 10402060003 PIETER B COEYMANS SCHOOL public Regular School No Elementary PK 05 2019   grade_1 61.0 4.0 8.0   0.0     0.0     5.0   45.0 33.0     *       52     16   78 61 4 8   0     0     5   45 33         52   16   78
2139758 2139758 NY Albany   school 3624150 10402060000   RAVENA COEYMANS 362415003326 10402060008 RAVENA-COEYMANS-SELKIRK MID SCH public Regular School No Middle 06 08 2019   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
2139777 2139777 NY Albany   school 3607980 10500010000   COHOES 360798000568 10500010005 ABRAM LANSING SCHOOL public Regular School No Elementary KG 05 2019   grade_1 44.0 4.0 8.0         0.0     10.0   33.0 33.0             24     10   66 44 4 8         0     10   33 33         24   10   66
2139796 2139796 NY Albany   school 3607980 10500010000   COHOES 360798000572 10500010006 VAN SCHAICK ISLAND SCHOOL public Regular School No Elementary KG 05 2019   grade_1 19.0 1.0 3.0         1.0     4.0   15.0 13.0             14     10   28 19 1 3         1     4   15 13         14   10   28
2139815 2139815 NY Albany   school 3607980 10500010000   COHOES 360798000569 10500010007 COHOES HIGH SCHOOL public Regular School No High 09 12 2019   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
2139834 2139834 NY Albany   school 3607980 10500010000   COHOES 360798000570 10500010008 COHOES MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2139853 2139853 NY Albany   school 3607980 10500010000   COHOES 360798004584 10500010009 HARMONY HILL SCHOOL public Regular School No Elementary KG 05 2019   grade_1 40.0 2.0 11.0   1.0     2.0     8.0   31.0 33.0     *       32     9   64 40 2 11   1     2     8   31 33         32   9   64
2139872 2139872 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004750 10601060003 ROESSLEVILLE SCHOOL public Regular School No Elementary PK 04 2019   grade_1 34.0 8.0 5.0         3.0     10.0   29.0 31.0             30     *   60 34 8 5         3     10   29 31         30       60
2139891 2139891 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004788 10601060005 SADDLEWOOD ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_1 41.0 2.0 4.0         7.0     5.0   30.0 29.0     *       21     6   59 41 2 4         7     5   30 29         21   6   59
2139910 2139910 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003711 10601060006 SHAKER ROAD ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   grade_1 36.0 1.0 5.0   0.0     8.0     6.0   25.0 31.0     6       24     *   56 36 1 5   0     8     6   25 31     6   24       56
2139929 2139929 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003704 10601060008 COLONIE CENTRAL HIGH SCHOOL public Regular School No High 09 12 2019   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   0   0
2139948 2139948 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004568 10601060010 FOREST PARK ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   grade_1 37.0 1.0 4.0         5.0     4.0   26.0 25.0             19     11   51 37 1 4         5     4   26 25         19   11   51
2139967 2139967 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004494 10601060011 VEEDER ELEMENTARY SCHOOL public Regular School No Elementary KG 04 2019   grade_1 47.0 10.0 5.0   1.0     5.0     5.0   40.0 33.0             33     18   73 47 10 5   1     5     5   40 33         33   18   73
2139986 2139986 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721003710 10601060012 SAND CREEK MIDDLE SCHOOL public Regular School No Middle 05 09 2019   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   0   0
2140005 2140005 NY Albany   school 3627210 10601060000   SOUTH COLONIE 362721004496 10601060013 LISHA KILL MIDDLE SCHOOL public Regular School No Middle 05 08 2019   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
2140024 2140024 NY Albany   school 3618990 10615020000   MENANDS 361899001719 10615020001 MENANDS SCHOOL public Regular School No Elementary KG 08 2019   grade_1 10.0 14.0 1.0   2.0     9.0     2.0   22.0 16.0     5       16     7   38 10 14 1   2     9     2   22 16     5   16   7   38
2140043 2140043 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002979 10623060002 BLUE CREEK SCHOOL public Regular School No Elementary KG 06 2019   grade_1 31.0 1.0 4.0   0.0     7.0     6.0   28.0 21.0     *       11     9   49 31 1 4   0     7     6   28 21         11   9   49
2140062 2140062 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002980 10623060003 BOGHT HILLS SCHOOL public Regular School No Elementary KG 06 2019   grade_1 46.0 3.0 6.0   0.0     28.0     4.0   39.0 48.0     7       14     13   87 46 3 6   0     28     4   39 48     7   14   13   87
2140081 2140081 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002981 10623060004 FORTS FERRY SCHOOL public Regular School No Elementary KG 06 2019   grade_1 52.0 4.0 6.0   1.0     17.0     6.0   35.0 51.0     15       29     8   86 52 4 6   1     17     6   35 51     15   29   8   86
2140100 2140100 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002983 10623060006 LATHAM RIDGE SCHOOL public Regular School No Elementary KG 06 2019   grade_1 44.0 2.0 1.0   0.0     14.0     8.0   36.0 33.0     8       22     5   69 44 2 1   0     14     8   36 33     8   22   5   69
2140119 2140119 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002984 10623060007 LOUDONVILLE SCHOOL public Regular School No Elementary KG 06 2019   grade_1 28.0 2.0 3.0   0.0     6.0     6.0   25.0 20.0     *       6     5   45 28 2 3   0     6     6   25 20         6   5   45
2140138 2140138 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002987 10623060008 SOUTHGATE SCHOOL public Regular School No Elementary KG 06 2019   grade_1 38.0 2.0 5.0   0.0     19.0     4.0   38.0 30.0     11       18     10   68 38 2 5   0     19     4   38 30     11   18   10   68
2140157 2140157 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002986 10623060009 SHAKER JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   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   0   0
2140176 2140176 NY Albany   school 3621000 10623060000   NORTH COLONIE CSD 362100002985 10623060010 SHAKER HIGH SCHOOL public Regular School No High 09 12 2019   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   0   0
2140195 2140195 NY Albany   school 3612660 10701030000   GREEN ISLAND 361266001043 10701030001 HEATLY SCHOOL public Regular School No Other PK 12 2019   grade_1 14.0 2.0 1.0         1.0     4.0   12.0 10.0             12     *   22 14 2 1         1     4   12 10         12       22
2140214 2140214 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001069 10802060001 ALTAMONT ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 39.0 5.0 3.0         1.0     3.0   26.0 25.0     *       20     6   51 39 5 3         1     3   26 25         20   6   51
2140233 2140233 NY Albany   school 3613080 10802060000   GUILDERLAND 361308004589 10802060003 GUILDERLAND ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 66.0 3.0 3.0         17.0     1.0   41.0 49.0     16       *     9   90 66 3 3         17     1   41 49     16       9   90
2140252 2140252 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001073 10802060004 WESTMERE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 69.0 7.0 2.0   0.0     5.0     2.0   43.0 42.0     11       25     *   85 69 7 2   0     5     2   43 42     11   25       85
2140271 2140271 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001070 10802060005 GUILDERLAND HIGH SCHOOL public Regular School No High 09 12 2019   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   0   0
2140290 2140290 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001072 10802060007 LYNNWOOD ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 63.0 1.0 1.0         3.0     1.0   37.0 32.0     *       11     *   69 63 1 1         3     1   37 32         11       69
2140309 2140309 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001071 10802060008 FARNSWORTH MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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   0   0
2140328 2140328 NY Albany   school 3613080 10802060000   GUILDERLAND 361308001087 10802060009 PINE BUSH ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 74.0 1.0 2.0         7.0     1.0   43.0 42.0     *       11     5   85 74 1 2         7     1   43 42         11   5   85
2140347 2140347 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003998 11003060001 VOORHEESVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2019   grade_1 81.0 0.0 1.0         2.0     6.0   45.0 45.0     *       8     17   90 81 0 1         2     6   45 45         8   17   90
2140366 2140366 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967003997 11003060002 CLAYTON A BOUTON HIGH SCHOOL public Regular School No High 09 12 2019   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
2140385 2140385 NY Albany   school 3629670 11003060000   VOORHEESVILLE 362967006128 11003060003 VOORHEESVILLE MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2153495 2153495 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000539 110101040001 CINCINNATUS ELEMENTARY SCHOOL public Regular School No Elementary PK 04 2019   grade_1 36.0 0.0 1.0               0.0   16.0 21.0             27     8   37 36 0 1               0   16 21         27   8   37
2153514 2153514 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756000540 110101040002 CINCINNATUS HIGH SCHOOL public Regular School No High 09 12 2019   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
2153533 2153533 NY Cortland   school 3607560 110101040000   CINCINNATUS 360756005573 110101040003 CINCINNATUS MIDDLE SCHOOL public Regular School No Middle 05 08 2019   grade_1 0.0                   0.0   0.0 0.0             0     0   0 0                   0   0 0         0   0   0
2153552 2153552 NY Cortland   school 3608460 110200010000   CORTLAND 360846000648 110200010003 FRANKLYN S BARRY SCHOOL public Regular School No Elementary KG 06 2019   grade_1 37.0 4.0 0.0         1.0     0.0   22.0 20.0             32     *   42 37 4 0         1     0   22 20         32       42
2153571 2153571 NY Cortland   school 3608460 110200010000   CORTLAND 360846000651 110200010004 VIRGIL ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_1 9.0 1.0 0.0               0.0   6.0 4.0             5     0   10 9 1 0               0   6 4         5   0   10
2153590 2153590 NY Cortland   school 3608460 110200010000   CORTLAND 360846000645 110200010008 ALTON B PARKER SCHOOL public Regular School No Elementary KG 06 2019   grade_1 34.0 0.0 1.0               2.0   23.0 14.0             27     *   37 34 0 1               2   23 14         27       37
2153609 2153609 NY Cortland   school 3608460 110200010000   CORTLAND 360846000650 110200010009 RANDALL SCHOOL public Regular School No Elementary KG 06 2019   grade_1 24.0 2.0 2.0         1.0     7.0   20.0 16.0     *       29     7   36 24 2 2         1     7   20 16         29   7   36
2153628 2153628 NY Cortland   school 3608460 110200010000   CORTLAND 360846000647 110200010010 F E SMITH SCHOOL public Regular School No Elementary KG 06 2019   grade_1 20.0 2.0 1.0         0.0     4.0   18.0 9.0             22     *   27 20 2 1         0     4   18 9         22       27
2153647 2153647 NY Cortland   school 3608460 110200010000   CORTLAND 360846000646 110200010011 CORTLAND HIGH SCHOOL public Regular School No High 09 12 2019   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
2153666 2153666 NY Cortland   school 3608460 110200010000   CORTLAND 360846006612 110200010012 CORTLAND JUNIOR HIGH SCHOOL public Regular School No Middle 07 08 2019   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
2153685 2153685 NY Cortland   school 3618840 110304040000   MCGRAW 361884001710 110304040001 MCGRAW ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_1 43.0   1.0               2.0   24.0 22.0             32     6   46 43   1               2   24 22         32   6   46
2153704 2153704 NY Cortland   school 3618840 110304040000   MCGRAW 361884001711 110304040002 MCGRAW SECONDARY SCHOOL public Regular School No High 06 12 2019   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
2153723 2153723 NY Cortland   school 3614640 110701060000   HOMER 361464001217 110701060001 HOMER SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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
2153742 2153742 NY Cortland   school 3614640 110701060000   HOMER 361464001214 110701060002 HOMER ELEMENTARY SCHOOL public Regular School No Elementary PK 02 2019   grade_1 99.0 1.0 2.0         2.0     1.0   57.0 48.0     *       50     7   105 99 1 2         2     1   57 48         50   7   105

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