Data source: Big Local News · About: Big Local

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

View and edit SQL

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
987027 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   grade_1 0.0 16.0 25.0         0.0     0.0   37.0 4.0     13       33     41   41 0 16 25         0     0   37 4     13   33   41   41
987028 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987029 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987030 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987031 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   grade_2 2.0 9.0 19.0         4.0     0.0   25.0 9.0     *       26     34   34 2 9 19         4     0   25 9         26   34   34
987032 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   grade_3 0.0 2.0 5.0         0.0     0.0   7.0 0.0     *       5     7   7 0 2 5         0     0   7 0         5   7   7
987033 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987034 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987035 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987036 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987037 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987038 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987039 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   kindergarten_full_day 0.0 9.0 21.0         1.0     0.0   26.0 5.0     12       20     31   31 0 9 21         1     0   26 5     12   20   31   31
987040 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987041 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   pk_12_total 7.0 90.0 154.0         12.0     1.0   215.0 49.0     77       191     264   264 7 90 154         12     1   215 49     77   191   264   264
987042 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987043 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
987044 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           2017   ungraded_elementary 5.0 54.0 84.0         7.0     1.0   120.0 31.0     40       107     151   151 5 54 84         7     1   120 31     40   107   151   151
987045 NY New York   school   307500010000   NYC SPEC SCHOOLS - DIST 75   307500012469 BRONX SCHOOL FOR CONTINUOUS LEARNING public           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
962422 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 2017   grade_1 69.0 1.0 6.0   1.0     0.0     7.0   44.0 40.0             56     10   84 69 1 6   1     0     7   44 40         56   10   84
962423 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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   0
962424 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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   0
962425 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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   0
962426 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 2017   grade_2 64.0 4.0 7.0   0.0     0.0     3.0   35.0 43.0             46     12   78 64 4 7   0     0     3   35 43         46   12   78
962427 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 2017   grade_3 70.0 3.0 3.0   0.0     1.0     6.0   44.0 39.0             57     11   83 70 3 3   0     1     6   44 39         57   11   83
962428 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 2017   grade_4 53.0 1.0 1.0   1.0     1.0     2.0   31.0 28.0             36     10   59 53 1 1   1     1     2   31 28         36   10   59
962429 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 2017   grade_5 73.0 5.0 3.0   0.0     0.0     3.0   43.0 41.0             59     13   84 73 5 3   0     0     3   43 41         59   13   84
962430 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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
962431 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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
962432 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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
962433 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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   0
962434 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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
962435 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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
962436 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 2017   pk_12_total 329.0 14.0 20.0   2.0     2.0     21.0   197.0 191.0             254     56   388 329 14 20   2     2     21   197 191         254   56   388
962437 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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
962438 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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
962439 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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
962440 NY Erie   school 3630780 142801060000   WEST SENECA 363078004152 142801060008 WINCHESTER ELEMENTARY SCHOOL public Regular School No Elementary 01 5 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   0
972093 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 2017   grade_1 0.0 0.0 1.0   0.0     0.0         1.0 0.0     0       *     0   1 0 0 1   0     0         1 0     0       0   1
972094 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 2017   grade_10 1.0 55.0 17.0   1.0     2.0         40.0 36.0     *       65     9   76 1 55 17   1     2         40 36         65   9   76
972095 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 2017   grade_11 0.0 61.0 18.0   0.0     1.0         45.0 35.0     0       69     *   80 0 61 18   0     1         45 35     0   69       80
972096 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 2017   grade_12 0.0 81.0 17.0   1.0     2.0         58.0 43.0     *       82     7   101 0 81 17   1     2         58 43         82   7   101
972097 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 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
972098 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 2017   grade_3 0.0 1.0 0.0   0.0     0.0         0.0 1.0     0       0     0   1 0 1 0   0     0         0 1     0   0   0   1
972099 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 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
972100 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 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
972101 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 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
972102 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 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
972103 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 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
972104 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 2017   grade_9 0.0 29.0 11.0   1.0     0.0         24.0 17.0     *       *     *   41 0 29 11   1     0         24 17                 41
972105 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 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
972106 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 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
972107 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 2017   pk_12_total 1.0 227.0 64.0   3.0     5.0         168.0 132.0     10       254     24   300 1 227 64   3     5         168 132     10   254   24   300
972108 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 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
972109 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 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
972110 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 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
972111 NY Kings   school 3600150 331900860891   UFT CHARTER SCHOOL 360015005825 331900860891 UFT CHARTER SCHOOL charter Regular School Yes Other 01 12 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
982315 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2017   grade_1 51.0 3.0 8.0         2.0     1.0   22.0 43.0     6       10     *   65 51 3 8         2     1   22 43     6   10       65
982316 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982317 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982318 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982319 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2017   grade_2 48.0 2.0 11.0         3.0     2.0   34.0 32.0     6       13     *   66 48 2 11         3     2   34 32     6   13       66
982320 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2017   grade_3 41.0 1.0 19.0         5.0     2.0   31.0 37.0     13       16     *   68 41 1 19         5     2   31 37     13   16       68
982321 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2017   grade_4 44.0 0.0 13.0         0.0     1.0   30.0 28.0     *       13     *   58 44 0 13         0     1   30 28         13       58
982322 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2017   grade_5 60.0 1.0 16.0         0.0     4.0   50.0 31.0     8       16     21   81 60 1 16         0     4   50 31     8   16   21   81
982323 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2017   grade_6 46.0 0.0 4.0         1.0     0.0   31.0 20.0     *       7     6   51 46 0 4         1     0   31 20         7   6   51
982324 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982325 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982326 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982327 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982328 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982329 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 2017   pk_12_total 290.0 7.0 71.0         11.0     10.0   198.0 191.0     38       75     39   389 290 7 71         11     10   198 191     38   75   39   389
982330 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982331 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982332 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982333 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003060 280211030002 SCHOOL 2 public Regular School No Elementary 01 06 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
982334 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2017   grade_1 68.0 3.0 12.0         3.0     3.0   52.0 37.0     *       5     *   89 68 3 12         3     3   52 37         5       89
982335 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982336 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982337 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982338 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2017   grade_2 65.0 3.0 25.0         3.0     2.0   49.0 49.0     *       11     11   98 65 3 25         3     2   49 49         11   11   98
982339 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2017   grade_3 84.0 3.0 13.0         3.0     5.0   65.0 43.0     *       16     19   108 84 3 13         3     5   65 43         16   19   108
982340 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2017   grade_4 50.0 1.0 11.0         3.0     2.0   36.0 31.0     0       5     *   67 50 1 11         3     2   36 31     0   5       67
982341 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2017   grade_5 80.0 0.0 12.0         4.0     2.0   52.0 46.0     *       9     *   98 80 0 12         4     2   52 46         9       98
982342 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2017   grade_6 50.0 5.0 9.0         2.0     3.0   33.0 36.0     *       17     7   69 50 5 9         2     3   33 36         17   7   69
982343 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982344 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982345 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982346 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982347 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982348 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 2017   pk_12_total 397.0 15.0 82.0         18.0     17.0   287.0 242.0     14       63     48   529 397 15 82         18     17   287 242     14   63   48   529
982349 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982350 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982351 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982352 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157003061 280211030003 SCHOOL 3 public Regular School No Elementary 01 06 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
982353 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 2017   grade_1 43.0 0.0 3.0         2.0     0.0   28.0 20.0     *       *     11   48 43 0 3         2     0   28 20             11   48
982354 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 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
982355 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 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
982356 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 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
982357 NY Nassau   school 3621570 280211030000   OCEANSIDE 362157004527 280211030004 SCHOOL 4 public Regular School No Elementary 01 06 2017   grade_2 32.0 2.0 5.0         3.0     1.0   23.0 20.0     *       7     *   43 32 2 5         3     1   23 20         7       43

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