enrollments

Data source: Big Local News · About: Big Local

33,145 rows where grade = "grade_2" and state = "NY" sorted by district_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 33,045 ✖
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
1544814 1544814 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000503206 171102040003 BROADALBIN-PERTH MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
1544833 1544833 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000500282 171102040004 BROADALBIN-PERTH HIGH SCHOOL public Regular School No High 09 12 2020   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
2070906 2070906 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000504421 171102040001 BROADALBIN-PERTH INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2018   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
2070925 2070925 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000500283 171102040002 LEARNING COMMUN-BROADALBIN-PERTH (TH public Regular School No Elementary PK 02 2018   grade_2 124.0 1.0 0.0   0.0     0.0     0.0   70.0 55.0     *       57     13   125 124 1 0   0     0     0   70 55         57   13   125
2070944 2070944 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000503206 171102040003 BROADALBIN-PERTH MIDDLE SCHOOL public Regular School No Middle 06 08 2018   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
2070963 2070963 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000500282 171102040004 BROADALBIN-PERTH HIGH SCHOOL public Regular School No High 09 12 2018   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
2160643 2160643 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000504421 171102040001 BROADALBIN-PERTH INTERMEDIATE SCHOOL public Regular School No Elementary 03 05 2019   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
2160662 2160662 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000500283 171102040002 LEARNING COMMUN-BROADALBIN-PERTH (TH public Regular School No Elementary PK 02 2019   grade_2 118.0 1.0 0.0         2.0     2.0   59.0 64.0     *       59     5   123 118 1 0         2     2   59 64         59   5   123
2160681 2160681 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000503206 171102040003 BROADALBIN-PERTH MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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
2160700 2160700 NY Fulton   school 3600005 171102040000   BROADALBIN-PERTH 360000500282 171102040004 BROADALBIN-PERTH HIGH SCHOOL public Regular School No High 09 12 2019   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
806136 806136 NY Otsego   school 3600006 472202040000   CHERRY VLY-SPRGFLD 360000600525 472202040001 CHERRY VALLEY-SPRINGFIELD CENTRAL public Regular School No 4 PK 12 2015   grade_2 34.0 0.0 0.0               1.0   16.0 19.0             22     *   35 34 0 0               1   16 19         22       35
1002421 1002421 NY Otsego   school 3600006 472202040000   CHERRY VLY-SPRGFLD 360000600525 472202040001 CHERRY VALLEY-SPRINGFIELD CENTRAL public Regular School No Other PK 12 2017   grade_2 31.0 0.0 0.0         0.0     0.0   16.0 15.0             21     *   31 31 0 0         0     0   16 15         21       31
1092500 1092500 NY Otsego   school 3600006 472202040000   CHERRY VLY-SPRGFLD 360000600525 472202040001 CHERRY VALLEY-SPRINGFIELD CENTRAL public Regular School No 4.0 PK 12 2016   grade_2 31.0 1.0 1.0         0.0     0.0   14.0 19.0             11     5   33 31 1 1         0     0   14 19         11   5   33
1493419 1493419 NY Otsego   school 3600006 472202040000   CHERRY VLY-SPRGFLD 360000600525 472202040001 CHERRY VALLEY-SPRINGFIELD CENTRAL public Regular School No Other PK 12 2021   grade_2 32.0 0.0 0.0               3.0   17.0 18.0             16     *   35 32 0 0               3   17 18         16       35
1583593 1583593 NY Otsego   school 3600006 472202040000   CHERRY VLY-SPRGFLD 360000600525 472202040001 CHERRY VALLEY-SPRINGFIELD CENTRAL public Regular School No Other PK 12 2020   grade_2 34.0 0.0 0.0               0.0   15.0 19.0             19     8   34 34 0 0               0   15 19         19   8   34
2109761 2109761 NY Otsego   school 3600006 472202040000   CHERRY VLY-SPRGFLD 360000600525 472202040001 CHERRY VALLEY-SPRINGFIELD CENTRAL public Regular School No Other PK 12 2018   grade_2 33.0 0.0 1.0               0.0   21.0 13.0             14     6   34 33 0 1               0   21 13         14   6   34
2199327 2199327 NY Otsego   school 3600006 472202040000   CHERRY VLY-SPRGFLD 360000600525 472202040001 CHERRY VALLEY-SPRINGFIELD CENTRAL public Regular School No Other PK 12 2019   grade_2 43.0 0.0 0.0         0.0     0.0   27.0 16.0             30     9   43 43 0 0         0     0   27 16         30   9   43
820120 820120 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000703911 572702040001 JASPER-TROUPSBURG ELEMENTARY SCHOOL public Regular School No 1 PK 06 2015   grade_2 42.0 0.0 0.0         0.0         23.0 19.0             30     8   42 42 0 0         0         23 19         30   8   42
820139 820139 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000701357 572702040002 JASPER-TROUPSBURG JUNIOR-SENIOR HS public Regular School No 3 07 12 2015   grade_2 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
1016462 1016462 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000703911 572702040001 JASPER-TROUPSBURG ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2017   grade_2 37.0 0.0                     21.0 16.0             23     7   37 37 0                     21 16         23   7   37
1016481 1016481 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000701357 572702040002 JASPER-TROUPSBURG JUNIOR-SENIOR HS public Regular School No High 07 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
1106560 1106560 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000703911 572702040001 JASPER-TROUPSBURG ELEMENTARY SCHOOL public Regular School No 1.0 PK 06 2016   grade_2 31.0 0.0 0.0         0.0         19.0 12.0             19     6   31 31 0 0         0         19 12         19   6   31
1106579 1106579 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000701357 572702040002 JASPER-TROUPSBURG JUNIOR-SENIOR HS public Regular School No 3.0 07 12 2016   grade_2 0.0 0.0           0.0         0.0 0.0             0     0   0 0 0           0         0 0         0   0   0
1507726 1507726 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000703911 572702040001 JASPER-TROUPSBURG ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2021   grade_2 28.0       0.0           0.0   10.0 18.0             18     9   28 28       0           0   10 18         18   9   28
1507745 1507745 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000701357 572702040002 JASPER-TROUPSBURG JUNIOR-SENIOR HS public Regular School No High 07 12 2021   grade_2 0.0       0.0     0.0         0.0 0.0             0     0   0 0       0     0         0 0         0   0   0
1597862 1597862 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000703911 572702040001 JASPER-TROUPSBURG ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2020   grade_2 28.0 0.0 1.0   0.0           0.0   19.0 10.0             15     *   29 28 0 1   0           0   19 10         15       29
1597881 1597881 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000701357 572702040002 JASPER-TROUPSBURG JUNIOR-SENIOR HS public Regular School No High 07 12 2020   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
2123840 2123840 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000703911 572702040001 JASPER-TROUPSBURG ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2018   grade_2 26.0 0.0 0.0   0.0               14.0 12.0             16     6   26 26 0 0   0               14 12         16   6   26
2123859 2123859 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000701357 572702040002 JASPER-TROUPSBURG JUNIOR-SENIOR HS public Regular School No High 07 12 2018   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
2213482 2213482 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000703911 572702040001 JASPER-TROUPSBURG ELEMENTARY SCHOOL public Regular School No Elementary KG 06 2019   grade_2 33.0   0.0   0.0     0.0         18.0 15.0             21     11   33 33   0   0     0         18 15         21   11   33
2213501 2213501 NY Steuben   school 3600007 572702040000   JASPER-TRPSBRG 360000701357 572702040002 JASPER-TROUPSBURG JUNIOR-SENIOR HS public Regular School No High 07 12 2019   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
822856 822856 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800196 580235060002 KREAMER STREET ELEMENTARY SCHOOL public Regular School No 1 KG 03 2015   grade_2 38.0 20.0 30.0   2.0     2.0     3.0   42.0 53.0             57     7   95 38 20 30   2     2     3   42 53         57   7   95
822875 822875 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800194 580235060003 BROOKHAVEN ELEMENTARY SCHOOL public Regular School No 1 PK 03 2015   grade_2 54.0 27.0 57.0   4.0     6.0     9.0   79.0 78.0             101     21   157 54 27 57   4     6     9   79 78         101   21   157
822894 822894 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800192 580235060004 BELLPORT MIDDLE SCHOOL public Regular School No 2 06 08 2015   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
822913 822913 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No 2 04 05 2015   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
822932 822932 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800193 580235060006 BELLPORT SENIOR HIGH SCHOOL public Regular School No 3 09 12 2015   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
822951 822951 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800197 580235060007 VERNE W CRITZ ELEMENTARY SCHOOL public Regular School No 1 KG 03 2015   grade_2 47.0 8.0 28.0   1.0     3.0     4.0   43.0 48.0             *     *   91 47 8 28   1     3     4   43 48                 91
1019141 1019141 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800196 580235060002 KREAMER STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2017   grade_2 28.0 19.0 36.0   1.0     5.0     6.0   51.0 44.0     16       64     6   95 28 19 36   1     5     6   51 44     16   64   6   95
1019160 1019160 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800194 580235060003 BROOKHAVEN ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2017   grade_2 44.0 22.0 45.0         3.0     4.0   53.0 65.0     19       80     13   118 44 22 45         3     4   53 65     19   80   13   118
1019179 1019179 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800192 580235060004 BELLPORT 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 0 0   0     0     0   0 0     0   0   0   0
1019198 1019198 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No Elementary 04 05 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   0   0
1019217 1019217 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800193 580235060006 BELLPORT SENIOR 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   0   0
1019236 1019236 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800197 580235060007 VERNE W CRITZ ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2017   grade_2 33.0 11.0 40.0   0.0     2.0     12.0   42.0 56.0     22       71     19   98 33 11 40   0     2     12   42 56     22   71   19   98
1109296 1109296 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800196 580235060002 KREAMER STREET ELEMENTARY SCHOOL public Regular School No 1.0 KG 03 2016   grade_2 37.0 23.0 28.0   0.0     3.0     4.0   42.0 53.0             54     8   95 37 23 28   0     3     4   42 53         54   8   95
1109315 1109315 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800194 580235060003 BROOKHAVEN ELEMENTARY SCHOOL public Regular School No 1.0 PK 03 2016   grade_2 61.0 15.0 60.0   0.0     3.0     6.0   86.0 59.0             85     22   145 61 15 60   0     3     6   86 59         85   22   145
1109334 1109334 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800192 580235060004 BELLPORT MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   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
1109353 1109353 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No 2.0 04 05 2016   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
1109372 1109372 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800193 580235060006 BELLPORT SENIOR HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1109391 1109391 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800197 580235060007 VERNE W CRITZ ELEMENTARY SCHOOL public Regular School No 1.0 KG 03 2016   grade_2 41.0 18.0 45.0   1.0     1.0     7.0   59.0 54.0             70     18   113 41 18 45   1     1     7   59 54         70   18   113
1510424 1510424 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800196 580235060002 KREAMER STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 33.0 15.0 35.0   0.0     1.0     6.0   54.0 36.0     12       50     13   90 33 15 35   0     1     6   54 36     12   50   13   90
1510443 1510443 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800194 580235060003 BROOKHAVEN ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2021   grade_2 42.0 26.0 51.0   0.0     2.0     4.0   70.0 55.0     30       77     16   125 42 26 51   0     2     4   70 55     30   77   16   125
1510462 1510462 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800192 580235060004 BELLPORT MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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   0   0
1510481 1510481 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No Elementary 04 05 2021   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
1510500 1510500 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800193 580235060006 BELLPORT SENIOR HIGH SCHOOL public Regular School No High 09 12 2021   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   0   0
1510519 1510519 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800197 580235060007 VERNE W CRITZ ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2021   grade_2 20.0 7.0 36.0   0.0     0.0     2.0   33.0 32.0     18       37     10   65 20 7 36   0     0     2   33 32     18   37   10   65
1600560 1600560 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800196 580235060002 KREAMER STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_2 46.0 14.0 28.0   1.0     4.0     7.0   49.0 51.0     15       60     17   100 46 14 28   1     4     7   49 51     15   60   17   100
1600579 1600579 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800194 580235060003 BROOKHAVEN ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2020   grade_2 39.0 14.0 56.0   0.0     0.0     4.0   59.0 54.0     28       75     20   113 39 14 56   0     0     4   59 54     28   75   20   113
1600598 1600598 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800192 580235060004 BELLPORT MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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   0   0
1600617 1600617 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No Elementary 04 05 2020   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
1600636 1600636 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800193 580235060006 BELLPORT SENIOR HIGH SCHOOL public Regular School No High 09 12 2020   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   0   0
1600655 1600655 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800197 580235060007 VERNE W CRITZ ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2020   grade_2 21.0 12.0 54.0   0.0           5.0   49.0 43.0     30       67     19   92 21 12 54   0           5   49 43     30   67   19   92
2126538 2126538 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800196 580235060002 KREAMER STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 28.0 23.0 27.0   0.0     2.0     2.0   34.0 48.0     13       *     6   82 28 23 27   0     2     2   34 48     13       6   82
2126557 2126557 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800194 580235060003 BROOKHAVEN ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2018   grade_2 45.0 20.0 43.0         2.0     7.0   57.0 60.0     *       70     25   117 45 20 43         2     7   57 60         70   25   117
2126576 2126576 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800192 580235060004 BELLPORT MIDDLE SCHOOL public Regular School No Middle 06 08 2018   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   0   0
2126595 2126595 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No Elementary 04 05 2018   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   0   0
2126614 2126614 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800193 580235060006 BELLPORT SENIOR HIGH SCHOOL public Regular School No High 09 12 2018   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   0   0
2126633 2126633 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800197 580235060007 VERNE W CRITZ ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2018   grade_2 38.0 12.0 32.0         2.0     3.0   43.0 44.0     18       48     16   87 38 12 32         2     3   43 44     18   48   16   87
2216180 2216180 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800196 580235060002 KREAMER STREET ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 34.0 12.0 40.0         3.0     3.0   38.0 54.0     13       57     15   92 34 12 40         3     3   38 54     13   57   15   92
2216199 2216199 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800194 580235060003 BROOKHAVEN ELEMENTARY SCHOOL public Regular School No Elementary PK 03 2019   grade_2 26.0 21.0 57.0         0.0     4.0   51.0 57.0     28       83     15   108 26 21 57         0     4   51 57     28   83   15   108
2216218 2216218 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800192 580235060004 BELLPORT MIDDLE SCHOOL public Regular School No Middle 06 08 2019   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   0   0
2216237 2216237 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800195 580235060005 FRANK P LONG INTERMEDIATE SCH public Regular School No Elementary 04 05 2019   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   0   0
2216256 2216256 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800193 580235060006 BELLPORT SENIOR HIGH SCHOOL public Regular School No High 09 12 2019   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   0   0
2216275 2216275 NY Suffolk   school 3600008 580235060000   SOUTH COUNTRY 360000800197 580235060007 VERNE W CRITZ ELEMENTARY SCHOOL public Regular School No Elementary KG 03 2019   grade_2 20.0 9.0 32.0         0.0     6.0   39.0 28.0     11       43     7   67 20 9 32         0     6   39 28     11   43   7   67
759282 759282 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_2 60.0 0.0 1.0         1.0         26.0 36.0             31     5   62 60 0 1         1         26 36         31   5   62
759301 759301 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2015   grade_2 59.0 0.0 0.0               0.0   33.0 26.0             32     5   59 59 0 0               0   33 26         32   5   59
759320 759320 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No 3.0 09 12 2015   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
759339 759339 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No 2.0 06 08 2015   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
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
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
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
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
1045912 1045912 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 50.0 0.0 3.0               0.0   35.0 18.0             29     6   53 50 0 3               0   35 18         29   6   53
1045931 1045931 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No 1.0 KG 05 2016   grade_2 57.0   0.0               0.0   36.0 21.0             *     *   57 57   0               0   36 21                 57
1045950 1045950 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No 3.0 09 12 2016   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
1045969 1045969 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No 2.0 06 08 2016   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
1447287 1447287 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_2 61.0   0.0         0.0     2.0   32.0 31.0             24     6   63 61   0         0     2   32 31         24   6   63
1447306 1447306 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2021   grade_2 51.0   1.0   0.0           2.0   34.0 20.0             21     *   54 51   1   0           2   34 20         21       54
1447325 1447325 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2021   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
1447344 1447344 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2021   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
1537271 1537271 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 53.0   0.0         0.0     1.0   33.0 21.0             20     *   54 53   0         0     1   33 21         20       54
1537290 1537290 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2020   grade_2 48.0   0.0   1.0           1.0   26.0 24.0             16     *   50 48   0   1           1   26 24         16       50
1537309 1537309 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2020   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
1537328 1537328 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2020   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
2063382 2063382 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 56.0   0.0               1.0   29.0 28.0             26     *   57 56   0               1   29 28         26       57
2063401 2063401 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary KG 05 2018   grade_2 65.0 0.0 0.0   0.0     0.0     2.0   28.0 39.0             29     *   67 65 0 0   0     0     2   28 39         29       67
2063420 2063420 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2018   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
2063439 2063439 NY Clinton   school 3600009 91402060000   SARANAC 360000904670 91402060007 SARANAC MIDDLE SCHOOL public Regular School No Middle 06 08 2018   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
2153100 2153100 NY Clinton   school 3600009 91402060000   SARANAC 360000904666 91402060002 MORRISONVILLE ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 49.0   0.0               1.0   23.0 27.0             22     5   50 49   0               1   23 27         22   5   50
2153119 2153119 NY Clinton   school 3600009 91402060000   SARANAC 360000904668 91402060004 SARANAC ELEMENTARY SCHOOL public Regular School No Elementary PK 05 2019   grade_2 64.0   0.0   0.0     0.0     1.0   25.0 40.0             32     5   65 64   0   0     0     1   25 40         32   5   65
2153138 2153138 NY Clinton   school 3600009 91402060000   SARANAC 360000904669 91402060005 SARANAC HIGH SCHOOL public Regular School No High 09 12 2019   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

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