enrollments

Data source: Big Local News · About: Big Local

90,079 rows where state = "NY" and year = 2021 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 89,979 ✖
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
1454774 1454774 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   grade_3 106.0 22.0 22.0   2.0     1.0     4.0   97.0 60.0     8       *     17   157 106 22 22   2     1     4   97 60     8       17   157
1454775 1454775 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   grade_4 117.0 23.0 13.0   1.0     1.0     4.0   87.0 72.0     *       100     26   159 117 23 13   1     1     4   87 72         100   26   159
1454776 1454776 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   grade_5 1.0 0.0 0.0   0.0     0.0     0.0   0.0 1.0     0       0     0   1 1 0 0   0     0     0   0 1     0   0   0   1
1454777 1454777 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1454778 1454778 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1454779 1454779 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1454780 1454780 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1454781 1454781 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1454782 1454782 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1454783 1454783 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   pk_12_total 342.0 71.0 58.0   4.0     3.0     18.0   276.0 220.0     14       321     52   496 342 71 58   4     3     18   276 220     14   321   52   496
1454784 1454784 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1454785 1454785 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1454786 1454786 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   ungraded_elementary 1.0 0.0 0.0   0.0     0.0     0.0   1.0 0.0     0       *     *   1 1 0 0   0     0     0   1 0     0           1
1454787 1454787 NY Genesee   school 3603990 180300010000   BATAVIA 360399000160 180300010001 JOHN KENNEDY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1461343 1461343 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   grade_1 0.0 4.0 0.0   0.0     0.0     0.0   2.0 2.0     *       *     0   4 0 4 0   0     0     0   2 2             0   4
1461344 1461344 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1461345 1461345 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1461346 1461346 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1461347 1461347 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   grade_2 0.0 1.0 0.0   0.0     0.0     0.0   0.0 1.0     *       *     0   1 0 1 0   0     0     0   0 1             0   1
1461348 1461348 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1461349 1461349 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1461350 1461350 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   grade_5 0.0 23.0 2.0   0.0     0.0     0.0   16.0 9.0     *       *     5   25 0 23 2   0     0     0   16 9             5   25
1461351 1461351 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   grade_6 1.0 57.0 4.0   0.0     1.0     0.0   26.0 37.0     *       46     14   63 1 57 4   0     1     0   26 37         46   14   63
1461352 1461352 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   grade_7 0.0 63.0 4.0   1.0     0.0     1.0   33.0 36.0     *       44     17   69 0 63 4   1     0     1   33 36         44   17   69
1461353 1461353 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   grade_8 0.0 49.0 4.0   3.0     0.0     1.0   29.0 28.0     *       40     10   57 0 49 4   3     0     1   29 28         40   10   57
1461354 1461354 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1461355 1461355 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1461356 1461356 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1461357 1461357 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   pk_12_total 1.0 197.0 14.0   4.0     1.0     2.0   106.0 113.0     *       148     46   219 1 197 14   4     1     2   106 113         148   46   219
1461358 1461358 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1461359 1461359 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1461360 1461360 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1461361 1461361 NY Kings   school 3601143 331700861086   ACHIEVEMENT FIRST VOYAGER 360114306591 331700861086 ACHIEVEMENT FIRST VOYAGER CHARTER charter Regular School Yes Middle 01 08 2021   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
1472059 1472059 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   grade_1 1.0 20.0 75.0   0.0     1.0     1.0   47.0 51.0     50       *     6   98 1 20 75   0     1     1   47 51     50       6   98
1472060 1472060 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472061 1472061 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472062 1472062 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472063 1472063 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   grade_2 0.0 25.0 67.0   1.0     0.0     2.0   46.0 49.0     47       64     14   95 0 25 67   1     0     2   46 49     47   64   14   95
1472064 1472064 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   grade_3 0.0 35.0 89.0   1.0     1.0     1.0   76.0 51.0     70       87     18   127 0 35 89   1     1     1   76 51     70   87   18   127
1472065 1472065 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   grade_4 1.0 27.0 77.0   0.0     0.0     4.0   57.0 52.0     44       86     *   109 1 27 77   0     0     4   57 52     44   86       109
1472066 1472066 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   grade_5 0.0 42.0 90.0   2.0     0.0     3.0   69.0 68.0     48       102     5   137 0 42 90   2     0     3   69 68     48   102   5   137
1472067 1472067 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   grade_6 3.0 22.0 72.0   0.0     1.0     0.0   47.0 51.0     *       76     *   98 3 22 72   0     1     0   47 51         76       98
1472068 1472068 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472069 1472069 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472070 1472070 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472071 1472071 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472072 1472072 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472073 1472073 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   pk_12_total 5.0 172.0 472.0   4.0     3.0     11.0   344.0 323.0     297       480     52   667 5 172 472   4     3     11   344 323     297   480   52   667
1472074 1472074 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472075 1472075 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472076 1472076 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   ungraded_elementary 0.0 1.0 2.0   0.0     0.0     0.0   2.0 1.0     *       *     *   3 0 1 2   0     0     0   2 1                 3
1472077 1472077 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001150 280201030001 JOSEPH MCNEIL SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472078 1472078 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   grade_1 0.0 22.0 44.0   0.0     0.0     4.0   36.0 34.0     34       56     *   70 0 22 44   0     0     4   36 34     34   56       70
1472079 1472079 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472080 1472080 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472081 1472081 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472082 1472082 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   grade_2 1.0 17.0 49.0   0.0     3.0     0.0   31.0 39.0     40       47     7   70 1 17 49   0     3     0   31 39     40   47   7   70
1472083 1472083 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   grade_3 0.0 22.0 61.0   0.0     0.0     0.0   47.0 36.0     49       60     9   83 0 22 61   0     0     0   47 36     49   60   9   83
1472084 1472084 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   grade_4 1.0 27.0 56.0   0.0     2.0     1.0   44.0 43.0     38       66     10   87 1 27 56   0     2     1   44 43     38   66   10   87
1472085 1472085 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   grade_5 2.0 36.0 60.0   0.0     2.0     0.0   54.0 46.0     26       79     11   100 2 36 60   0     2     0   54 46     26   79   11   100
1472086 1472086 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   grade_6 6.0 30.0 48.0   1.0     2.0     0.0   42.0 45.0     8       72     *   87 6 30 48   1     2     0   42 45     8   72       87
1472087 1472087 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472088 1472088 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472089 1472089 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472090 1472090 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472091 1472091 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472092 1472092 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   pk_12_total 10.0 154.0 318.0   1.0     9.0     5.0   254.0 243.0     195       380     44   497 10 154 318   1     9     5   254 243     195   380   44   497
1472093 1472093 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472094 1472094 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472095 1472095 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472096 1472096 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001151 280201030002 DAVID PATERSON SCHOOL public Regular School No Elementary 01 06 2021   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   0   0
1472097 1472097 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_1 1.0 16.0 57.0   0.0     2.0     2.0   36.0 42.0     29       63     *   78 1 16 57   0     2     2   36 42     29   63       78
1472098 1472098 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472099 1472099 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472100 1472100 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472101 1472101 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_2 1.0 20.0 57.0   1.0     0.0     3.0   45.0 37.0     37       53     *   82 1 20 57   1     0     3   45 37     37   53       82
1472102 1472102 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_3 0.0 15.0 61.0   1.0     1.0     2.0   46.0 34.0     33       57     7   80 0 15 61   1     1     2   46 34     33   57   7   80
1472103 1472103 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_4 0.0 17.0 61.0   0.0     0.0     3.0   40.0 41.0     27       59     10   81 0 17 61   0     0     3   40 41     27   59   10   81
1472104 1472104 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   grade_5 3.0 27.0 55.0   1.0     0.0     2.0   47.0 41.0     *       73     11   88 3 27 55   1     0     2   47 41         73   11   88
1472105 1472105 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472106 1472106 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472107 1472107 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472108 1472108 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472109 1472109 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472110 1472110 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472111 1472111 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   pk_12_total 5.0 98.0 297.0   3.0     3.0     13.0   220.0 199.0     152       315     47   419 5 98 297   3     3     13   220 199     152   315   47   419
1472112 1472112 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472113 1472113 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472114 1472114 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   ungraded_elementary 0.0 3.0 6.0   0.0     0.0     1.0   6.0 4.0     *       10     10   10 0 3 6   0     0     1   6 4         10   10   10
1472115 1472115 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001155 280201030003 JACKSON MAIN ELEMENTARY SCHOOL public Regular School No Elementary 01 05 2021   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   0   0
1472116 1472116 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2021   grade_1 0.0 6.0 61.0   2.0     2.0         35.0 36.0     42       55     *   71 0 6 61   2     2         35 36     42   55       71
1472117 1472117 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2021   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
1472118 1472118 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2021   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
1472119 1472119 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2021   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
1472120 1472120 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2021   grade_2 0.0 5.0 50.0   0.0     0.0         29.0 26.0     38       45     7   55 0 5 50   0     0         29 26     38   45   7   55
1472121 1472121 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2021   grade_3 0.0 13.0 61.0   0.0     0.0         36.0 38.0     35       60     10   74 0 13 61   0     0         36 38     35   60   10   74
1472122 1472122 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2021   grade_4 1.0 12.0 56.0   0.0     0.0         44.0 25.0     *       58     8   69 1 12 56   0     0         44 25         58   8   69
1472123 1472123 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2021   grade_5 4.0 13.0 61.0   0.0     0.0         45.0 33.0     32       62     23   78 4 13 61   0     0         45 33     32   62   23   78
1472124 1472124 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2021   grade_6 0.0 7.0 39.0   0.0     1.0         21.0 26.0     *       *     0   47 0 7 39   0     1         21 26             0   47
1472125 1472125 NY Nassau   school 3614130 280201030000   HEMPSTEAD 361413001156 280201030004 BARACK OBAMA ELEMEN SCHOOL public Regular School No Elementary 01 06 2021   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

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