enrollments

Data source: Big Local News · About: Big Local

89,718 rows where state = "NY" and year = 2017 sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 89,718 ✖
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
956038 956038 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 54.0   1.0               1.0   30.0 26.0             24     *   56 54   1               1   30 26         24       56
956039 956039 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_10 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956040 956040 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_11 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956041 956041 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_12 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956042 956042 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 54.0   0.0               1.0   24.0 31.0             29     8   55 54   0               1   24 31         29   8   55
956043 956043 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_3 46.0   2.0               0.0   29.0 19.0             19     5   48 46   2               0   29 19         19   5   48
956044 956044 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 63.0   1.0               0.0   28.0 36.0             29     10   64 63   1               0   28 36         29   10   64
956045 956045 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_5 46.0   1.0               0.0   18.0 29.0             13     *   47 46   1               0   18 29         13       47
956046 956046 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_6 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956047 956047 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956048 956048 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_8 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956049 956049 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_9 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956050 956050 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   kindergarten_full_day 61.0   1.0               0.0   31.0 31.0             32     *   62 61   1               0   31 31         32       62
956051 956051 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   kindergarten_half_day 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956052 956052 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 324.0   6.0               2.0   160.0 172.0             146     31   332 324   6               2   160 172         146   31   332
956053 956053 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pre_kindergarten_full_day 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956054 956054 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pre_kindergarten_half_day 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956055 956055 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   ungraded_elementary 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956056 956056 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   ungraded_secondary 0.0   0.0               0.0   0.0 0.0             0     0   0 0   0               0   0 0         0   0   0
956057 956057 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_1 63.0   0.0         0.0     1.0   24.0 40.0             25     0   64 63   0         0     1   24 40         25   0   64
956058 956058 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_10 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956059 956059 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_11 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956060 956060 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_12 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956061 956061 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_2 56.0   1.0         0.0     2.0   32.0 27.0             24     6   59 56   1         0     2   32 27         24   6   59
956062 956062 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_3 60.0   0.0         1.0     0.0   40.0 21.0             24     8   61 60   0         1     0   40 21         24   8   61
956063 956063 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_4 59.0   1.0         0.0     2.0   37.0 25.0             33     10   62 59   1         0     2   37 25         33   10   62
956064 956064 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_5 54.0   0.0         0.0     4.0   31.0 27.0             25     *   58 54   0         0     4   31 27         25       58
956065 956065 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_6 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956066 956066 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_7 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956067 956067 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_8 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956068 956068 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   grade_9 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956069 956069 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   kindergarten_full_day 64.0   0.0         0.0     1.0   25.0 40.0             *     *   65 64   0         0     1   25 40                 65
956070 956070 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   kindergarten_half_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956071 956071 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pk_12_total 358.0   2.0         1.0     10.0   189.0 182.0             155     33   371 358   2         1     10   189 182         155   33   371
956072 956072 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pre_kindergarten_full_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956073 956073 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   pre_kindergarten_half_day 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956074 956074 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   ungraded_elementary 2.0   0.0         0.0     0.0   0.0 2.0             *     *   2 2   0         0     0   0 2                 2
956075 956075 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2017   ungraded_secondary 0.0   0.0         0.0     0.0   0.0 0.0             0     0   0 0   0         0     0   0 0         0   0   0
956076 956076 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC 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
956077 956077 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_10 111.0 1.0 2.0   0.0     0.0     0.0   53.0 61.0             54     22   114 111 1 2   0     0     0   53 61         54   22   114
956078 956078 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_11 109.0 1.0 0.0   0.0     1.0     1.0   56.0 56.0             *     18   112 109 1 0   0     1     1   56 56             18   112
956079 956079 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_12 95.0 1.0 0.0   0.0     0.0     1.0   42.0 55.0             40     *   97 95 1 0   0     0     1   42 55         40       97
956080 956080 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_2 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956081 956081 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_3 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956082 956082 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_4 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956083 956083 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_5 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956084 956084 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_6 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956085 956085 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_7 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956086 956086 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_8 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956087 956087 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   grade_9 100.0 2.0 1.0   1.0     1.0     0.0   59.0 46.0             39     24   105 100 2 1   1     1     0   59 46         39   24   105
956088 956088 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956089 956089 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956090 956090 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   pk_12_total 417.0 5.0 3.0   1.0     2.0     2.0   211.0 219.0             173     80   430 417 5 3   1     2     2   211 219         173   80   430
956091 956091 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   pre_kindergarten_full_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956092 956092 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   pre_kindergarten_half_day 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956093 956093 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   ungraded_elementary 0.0 0.0 0.0   0.0     0.0     0.0   0.0 0.0             0     0   0 0 0 0   0     0     0   0 0         0   0   0
956094 956094 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2017   ungraded_secondary 2.0 0.0 0.0   0.0     0.0     0.0   1.0 1.0             *     *   2 2 0 0   0     0     0   1 1                 2
956095 956095 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE 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
956096 956096 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_10 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956097 956097 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_11 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956098 956098 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_12 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956099 956099 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_2 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956100 956100 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_3 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956101 956101 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_4 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956102 956102 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_5 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956103 956103 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_6 101.0 0.0 1.0                   51.0 51.0             43     24   102 101 0 1                   51 51         43   24   102
956104 956104 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_7 90.0 2.0 1.0                   48.0 45.0             44     20   93 90 2 1                   48 45         44   20   93
956105 956105 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_8 102.0 2.0 2.0                   54.0 52.0             42     17   106 102 2 2                   54 52         42   17   106
956106 956106 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   grade_9 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956107 956107 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   kindergarten_full_day 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956108 956108 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   kindergarten_half_day 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956109 956109 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pk_12_total 298.0 4.0 4.0                   156.0 150.0             134     66   306 298 4 4                   156 150         134   66   306
956110 956110 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pre_kindergarten_full_day 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956111 956111 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   pre_kindergarten_half_day 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956112 956112 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_elementary 0.0 0.0 0.0                   0.0 0.0             0     0   0 0 0 0                   0 0         0   0   0
956113 956113 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2017   ungraded_secondary 5.0 0.0 0.0                   3.0 2.0             5     5   5 5 0 0                   3 2         5   5   5
955943 955943 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_1 63.0 5.0 0.0         1.0     2.0   37.0 34.0     *       48     15   71 63 5 0         1     2   37 34         48   15   71
955944 955944 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_10 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955945 955945 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_11 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955946 955946 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_12 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955947 955947 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_2 56.0 6.0 1.0         6.0     0.0   39.0 30.0     *       39     19   69 56 6 1         6     0   39 30         39   19   69
955948 955948 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_3 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955949 955949 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_4 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955950 955950 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_5 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955951 955951 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_6 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955952 955952 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_7 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955953 955953 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_8 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955954 955954 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   grade_9 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955955 955955 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   kindergarten_full_day 59.0 4.0 0.0         2.0     0.0   33.0 32.0     *       36     13   65 59 4 0         2     0   33 32         36   13   65
955956 955956 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   kindergarten_half_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955957 955957 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   pk_12_total 204.0 19.0 1.0         11.0     2.0   125.0 112.0     7       135     59   237 204 19 1         11     2   125 112     7   135   59   237
955958 955958 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   pre_kindergarten_full_day 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955959 955959 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   pre_kindergarten_half_day 26.0 4.0 0.0         2.0     0.0   16.0 16.0     0       12     12   32 26 4 0         2     0   16 16     0   12   12   32
955960 955960 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   ungraded_elementary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955961 955961 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003258 91200010001 BAILEY AVENUE SCHOOL public Regular School No Elementary PK 02 2017   ungraded_secondary 0.0 0.0 0.0         0.0     0.0   0.0 0.0     0       0     0   0 0 0 0         0     0   0 0     0   0   0   0
955962 955962 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_1 70.0 1.0 0.0         0.0         38.0 33.0     *       53     17   71 70 1 0         0         38 33         53   17   71
955963 955963 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_10 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
955964 955964 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_11 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
955965 955965 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_12 0.0 0.0 0.0         0.0         0.0 0.0     0       0     0   0 0 0 0         0         0 0     0   0   0   0
955966 955966 NY Clinton   school 3623280 91200010000   PLATTSBURGH 362328003260 91200010003 ARTHUR P MOMOT ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2017   grade_2 64.0 2.0 0.0         0.0         30.0 36.0     *       52     14   66 64 2 0         0         30 36         52   14   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]);