enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 32,945 ✖
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
745560 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
942415 942415 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2017   grade_1 2.0 75.0 1.0         0.0         36.0 42.0     0       70     *   78 2 75 1         0         36 42     0   70       78
1032133 1032133 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes 1.0 KG 08 2016   grade_1 3.0 69.0 2.0         2.0         37.0 39.0             55     *   76 3 69 2         2         37 39         55       76
1433318 1433318 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2021   grade_1 1.0 72.0 4.0   0.0     0.0     2.0   39.0 40.0     *       66     *   79 1 72 4   0     0     2   39 40         66       79
1523397 1523397 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2020   grade_1 3.0 61.0 8.0         0.0     3.0   37.0 38.0     0       71     0   75 3 61 8         0     3   37 38     0   71   0   75
2049755 2049755 NY Albany   school 3600162 10100860899   ALBANY COMMUNITY CHARTER SCH 360016205855 10100860899 ALBANY COMMUNITY CHARTER SCHOOL charter Regular School Yes Elementary KG 08 2018   grade_1 1.0 75.0 3.0         0.0     1.0   31.0 49.0     *       75     0   80 1 75 3         0     1   31 49         75   0   80
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
745579 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
942434 942434 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 09 12 2017   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
1032152 1032152 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 2016   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
1433337 1433337 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 06 12 2021   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
1523416 1523416 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 06 12 2020   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
2049774 2049774 NY Albany   school 3600945 10100860907   GREEN TECH HIGH CHARTER SCHO 360094505946 10100860907 GREEN TECH HIGH CHARTER SCHOOL charter Regular School Yes High 09 12 2018   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
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
745598 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
942453 942453 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2017   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
1032171 1032171 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes 3.0 09 12 2016   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
1433356 1433356 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2021   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
1523435 1523435 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2020   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
2049793 2049793 NY Albany   school 3601006 10100860960   ALBANY LEADERSHIP CHARTER HS 360100606202 10100860960 ALBANY LEADERSHIP CHARTER HS-GIRLS charter Regular School Yes High 09 12 2018   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
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
745617 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 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
759525 759525 NY Columbia   school 3614940 101300010000   HUDSON 361494001249 101300010001 HUDSON JR/SR 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
759544 759544 NY Columbia   school 3614940 101300010000   HUDSON 361494001250 101300010002 JOHN L EDWARDS PRIMARY SCHOOL public Regular School No 1.0 PK 02 2015   grade_1 69.0 24.0 28.0         14.0     19.0   68.0 86.0             118     25   154 69 24 28         14     19   68 86         118   25   154
759563 759563 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH INTER SCHOOL public Regular School No 1.0 03 06 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
956285 956285 NY Columbia   school 3614940 101300010000   HUDSON 361494001249 101300010001 HUDSON HIGH SCHOOL public Regular School No High 09 12 2017   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
956304 956304 NY Columbia   school 3614940 101300010000   HUDSON 361494001250 101300010002 JOHN L EDWARDS PRIMARY SCHOOL public Regular School No Elementary PK 02 2017   grade_1 64.0 26.0 26.0         11.0     24.0   75.0 76.0     9       100     17   151 64 26 26         11     24   75 76     9   100   17   151
956323 956323 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH INTER SCHOOL public Regular School No Elementary 03 05 2017   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
956342 956342 NY Columbia   school 3614940 101300010000   HUDSON 361494006579 101300010004 HUDSON JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2017   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
1046155 1046155 NY Columbia   school 3614940 101300010000   HUDSON 361494001249 101300010001 HUDSON JR/SR HIGH SCHOOL public Regular School No 3.0 07 12 2016   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
1046174 1046174 NY Columbia   school 3614940 101300010000   HUDSON 361494001250 101300010002 JOHN L EDWARDS PRIMARY SCHOOL public Regular School No 1.0 PK 02 2016   grade_1 71.0 23.0 19.0         12.0     23.0   79.0 69.0             105     18   148 71 23 19         12     23   79 69         105   18   148
1046193 1046193 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH INTER SCHOOL public Regular School No 1.0 03 06 2016   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
1447492 1447492 NY Columbia   school 3614940 101300010000   HUDSON 361494001249 101300010001 HUDSON HIGH SCHOOL public Regular School No High 09 12 2021   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
1447511 1447511 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH ELEMENTARY public Regular School No Elementary PK 05 2021   grade_1 51.0 18.0 15.0   0.0     11.0     9.0   56.0 48.0     8       59     *   104 51 18 15   0     11     9   56 48     8   59       104
1447530 1447530 NY Columbia   school 3614940 101300010000   HUDSON 361494006579 101300010004 HUDSON JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2021   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
1537514 1537514 NY Columbia   school 3614940 101300010000   HUDSON 361494001249 101300010001 HUDSON HIGH SCHOOL public Regular School No High 09 12 2020   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
1537533 1537533 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH ELEMENTARY public Regular School No Elementary PK 05 2020   grade_1 46.0 26.0 22.0   1.0     15.0     22.0   67.0 65.0     25       92     17   132 46 26 22   1     15     22   67 65     25   92   17   132
1537552 1537552 NY Columbia   school 3614940 101300010000   HUDSON 361494006579 101300010004 HUDSON JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2020   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
2063625 2063625 NY Columbia   school 3614940 101300010000   HUDSON 361494001249 101300010001 HUDSON HIGH SCHOOL public Regular School No High 09 12 2018   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
2063644 2063644 NY Columbia   school 3614940 101300010000   HUDSON 361494001250 101300010002 JOHN L EDWARDS PRIMARY SCHOOL public Regular School No Elementary PK 01 2018   grade_1 52.0 24.0 27.0         10.0     18.0   76.0 55.0     16       91     19   131 52 24 27         10     18   76 55     16   91   19   131
2063663 2063663 NY Columbia   school 3614940 101300010000   HUDSON 361494001248 101300010003 MONTGOMERY C SMITH INTER SCHOOL public Regular School No Elementary 02 05 2018   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
2063682 2063682 NY Columbia   school 3614940 101300010000   HUDSON 361494006579 101300010004 HUDSON JUNIOR HIGH SCHOOL public Regular School No Middle 06 08 2018   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
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
759582 759582 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE PRIMARYSCHOOL public Regular School No 1.0 KG 03 2015   grade_1 121.0 1.0 11.0         2.0     2.0   70.0 67.0             55     12   137 121 1 11         2     2   70 67         55   12   137
759601 759601 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001279 101401040005 ICHABOD CRANE 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
759620 759620 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE 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
759639 759639 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521006267 101401040007 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No 1.0 03 05 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
956361 956361 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE PRIMARYSCHOOL public Regular School No Elementary PK 03 2017   grade_1 110.0 2.0 10.0         0.0     1.0   68.0 55.0     9       44     15   123 110 2 10         0     1   68 55     9   44   15   123
956380 956380 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001279 101401040005 ICHABOD CRANE SENIOR HIGH SCHOOL public Regular School No High 09 12 2017   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
956399 956399 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No Middle 05 08 2017   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
956418 956418 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521006267 101401040007 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No Elementary 04 05 2017   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
1046212 1046212 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE PRIMARYSCHOOL public Regular School No 1.0 KG 03 2016   grade_1 94.0 1.0 17.0         0.0     4.0   62.0 54.0             46     9   116 94 1 17         0     4   62 54         46   9   116
1046231 1046231 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001279 101401040005 ICHABOD CRANE SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1046250 1046250 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   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
1046269 1046269 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521006267 101401040007 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No 2.0 04 05 2016   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
1447549 1447549 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_1 80.0 2.0 10.0   0.0     0.0     7.0   37.0 62.0     7       44     12   99 80 2 10   0     0     7   37 62     7   44   12   99
1447568 1447568 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001279 101401040005 ICHABOD CRANE SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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
1447587 1447587 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No Middle 04 08 2021   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
1537571 1537571 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_1 98.0 0.0 19.0   0.0     1.0     6.0   78.0 46.0     10       54     13   124 98 0 19   0     1     6   78 46     10   54   13   124
1537590 1537590 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001279 101401040005 ICHABOD CRANE SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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
1537609 1537609 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No Middle 04 08 2020   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
2063701 2063701 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001278 101401040004 ICHABOD CRANE PRIMARYSCHOOL public Regular School No Elementary KG 03 2018   grade_1 97.0 2.0 15.0   0.0     2.0     7.0   54.0 69.0     10       58     17   123 97 2 15   0     2     7   54 69     10   58   17   123
2063720 2063720 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001279 101401040005 ICHABOD CRANE SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   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
2063739 2063739 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521001277 101401040006 ICHABOD CRANE MIDDLE SCHOOL public Regular School No Middle 06 08 2018   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
2063758 2063758 NY Columbia   school 3615210 101401040000   KINDERHOOK 361521006267 101401040007 ICHABOD CRANE ELEMENTARY SCHOOL public Regular School No Elementary 04 05 2018   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
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
759658 759658 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No 1.0 KG 06 2015   grade_1 24.0 1.0 3.0         0.0     0.0   10.0 18.0             14     *   28 24 1 3         0     0   10 18         14       28
759677 759677 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON 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
956437 956437 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2017   grade_1 27.0 1.0 1.0         0.0     1.0   21.0 9.0             11     *   30 27 1 1         0     1   21 9         11       30
956456 956456 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2017   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
1046288 1046288 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_1 20.0 0.0 1.0         1.0     2.0   10.0 14.0             11     *   24 20 0 1         1     2   10 14         11       24
1046307 1046307 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No 3.0 07 12 2016   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
1447606 1447606 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2021   grade_1 33.0 0.0 0.0               3.0   17.0 19.0             19     5   36 33 0 0               3   17 19         19   5   36
1447625 1447625 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2021   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
1537628 1537628 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2020   grade_1 24.0 0.0 1.0               2.0   15.0 12.0             17     6   27 24 0 1               2   15 12         17   6   27
1537647 1537647 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2020   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
2063777 2063777 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001887 101601040002 WALTER B HOWARD ELEMENTARY SCHOOL public Regular School No Elementary PK 06 2018   grade_1 28.0 0.0 0.0               2.0   10.0 20.0             18     *   30 28 0 0               2   10 20         18       30
2063796 2063796 NY Columbia   school 3620430 101601040000   NEW LEBANON 362043001886 101601040003 NEW LEBANON JUNIOR-SENIOR HIGH SCH public Regular School No High 07 12 2018   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
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
745655 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 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
942472 942472 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2017   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
942491 942491 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary KG 06 2017   grade_1 46.0   1.0         0.0     0.0   26.0 21.0             19     *   47 46   1         0     0   26 21         19       47
1032190 1032190 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   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
1032209 1032209 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No 1.0 KG 06 2016   grade_1 55.0 0.0 0.0         0.0     0.0   30.0 25.0             23     5   55 55 0 0         0     0   30 25         23   5   55
1433375 1433375 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2021   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
1433394 1433394 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2021   grade_1 39.0 0.0 1.0         0.0     3.0   20.0 23.0     *       *     7   43 39 0 1         0     3   20 23             7   43
1523454 1523454 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2020   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
1523473 1523473 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary PK 06 2020   grade_1 48.0 1.0 2.0         0.0     0.0   24.0 27.0     *       21     6   51 48 1 2         0     0   24 27         21   6   51
2049812 2049812 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000208 10201040001 BERNE-KNOX-WESTERLO JUNIOR-SENIOR HS public Regular School No High 07 12 2018   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
2049831 2049831 NY Albany   school 3604650 10201040000   BERNE KNOX 360465000207 10201040002 BERNE-KNOX-WESTERLO ELEM SCH public Regular School No Elementary KG 06 2018   grade_1 43.0 0.0 3.0         1.0     1.0   28.0 20.0             22     7   48 43 0 3         1     1   28 20         22   7   48
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
745693 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

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