enrollments

Data source: Big Local News · About: Big Local

90,126 rows where state = "NJ" sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
2480392 2480392 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005852 50 Phillipsburg High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480393 2480393 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005856 70 Philipsburg Primary School   Regular School No Elementary KG 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480394 2480394 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005860 105 Phillipsburg Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480395 2480395 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005862 110 Phillipsburg Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480396 2480396 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   241.0                                             241
2480397 2480397 NJ Warren 41 school 3413260 4200   Pohatcong Twp 341326000366 40 Pohatcong Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480398 2480398 NJ Warren 41 school 3417920 5460   Warren County Vocational 341792005872 50 Warren County Vocational Technical School   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480399 2480399 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005878 50 Warren Hills Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480400 2480400 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005880 60 Warren Hills Regional Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480401 2480401 NJ Warren 41 school 3417010 5480   Washington Boro 341701005884 55 Washington Memorial Elementary School   Regular School No Elementary 03 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480402 2480402 NJ Warren 41 school 3417010 5480   Washington Boro 341701005886 60 Taylor Street Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   34.0                                             34
2480403 2480403 NJ Warren 41 school 3417160 5530   Washington Twp 341716005890 40 Brass Castle School   Regular School No Elementary 04 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480404 2480404 NJ Warren 41 school 3417160 5530   Washington Twp 341716005892 50 Port Colden School   Regular School No Elementary 01 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480405 2480405 NJ Warren 41 school 3417910 5780   White Twp 341791005894 50 White Township Consolidated School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482870 2482870 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2020   kindergarten_full_day                                                   0.0                                             0
2482871 2482871 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   26.0                                             26
2482872 2482872 NJ Warren 41 school 3400840 70   Alpha Boro 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2020   kindergarten_full_day                                                   13.0                                             13
2482873 2482873 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   kindergarten_full_day                                                   0.0                                             0
2482874 2482874 NJ Warren 41 school 3401440 280   Belvidere Town 340144005796 30 Oxford Street Elementary School   Regular School No Elementary PK 08 2020   kindergarten_full_day                                                   11.0                                             11
2482875 2482875 NJ Warren 41 school 3401800 400   Blairstown Twp 340180005800 30 Blairstown Elementary School   Regular School No Elementary PK 06 2020   kindergarten_full_day                                                   66.0                                             66
2482876 2482876 NJ Warren 41 school 3405520 1620   Franklin Twp 340552005802 50 Franklin Township School   Regular School No Elementary PK 06 2020   kindergarten_full_day                                                   20.0                                             20
2482877 2482877 NJ Warren 41 school 3405670 1670   Frelinghuysen Twp 340567005804 50 Frelinghuysen Township Elementary School   Regular School No Elementary PK 06 2020   kindergarten_full_day                                                   10.0                                             10
2482878 2482878 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2020   kindergarten_full_day                                                   0.0                                             0
2482879 2482879 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   kindergarten_full_day                                                   60.0                                             60
2482880 2482880 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621000471 40 Greenwich School   Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   70.0                                             70
2482881 2482881 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621005810 70 Stewartsville Middle School   Regular School No Middle 06 08 2020   kindergarten_full_day                                                   0.0                                             0
2482882 2482882 NJ Warren 41 school 3406300 1870   Hackettstown 340630005814 50 Hackettstown High School   Regular School No High 09 12 2020   kindergarten_full_day                                                   0.0                                             0
2482883 2482883 NJ Warren 41 school 3406300 1870   Hackettstown 340630005816 60 Hackettstown Middle School   Regular School No Middle 05 08 2020   kindergarten_full_day                                                   0.0                                             0
2482884 2482884 NJ Warren 41 school 3406300 1870   Hackettstown 340630005818 70 Hatchery Hill Elementary School   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   145.0                                             145
2482885 2482885 NJ Warren 41 school 3406300 1870   Hackettstown 340630005820 90 Willow Grove Elementary School   Regular School No Elementary 02 04 2020   kindergarten_full_day                                                   0.0                                             0
2482886 2482886 NJ Warren 41 school 3406810 2040   Harmony Twp 340681005824 30 Harmony Township School   Regular School No Elementary PK 08 2020   kindergarten_full_day                                                   24.0                                             24
2482887 2482887 NJ Warren 41 school 3407470 2250   Hope Twp 340747005826 50 Hope Township School   Regular School No Elementary PK 08 2020   kindergarten_full_day                                                   14.0                                             14
2482888 2482888 NJ Warren 41 school 3408070 2470   Knowlton Twp 340807005832 40 Knowlton Township Board Of Education   Regular School No Elementary PK 06 2020   kindergarten_full_day                                                   20.0                                             20
2482889 2482889 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900005840 50 Lopatcong Elementary School   Regular School No Elementary PK 04 2020   kindergarten_full_day                                                   0.0                                             0
2482890 2482890 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900000731 60 Lopatcong Township Middle School   Regular School No Middle 05 08 2020   kindergarten_full_day                                                   0.0                                             0
2482891 2482891 NJ Warren 41 school 3409540 2970   Mansfield Twp 340954005842 50 Mansfield Township Elementary   Regular School No Elementary PK 06 2020   kindergarten_full_day                                                   95.0                                             95
2482892 2482892 NJ Warren 41 school 3409550 3675   North Warren Regional 340955005844 50 North Warren Regional School   Regular School No High 07 12 2020   kindergarten_full_day                                                   0.0                                             0
2482893 2482893 NJ Warren 41 school 3412300 3890   Oxford Twp 341230005846 50 Oxford Central School   Regular School No Elementary PK 08 2020   kindergarten_full_day                                                   27.0                                             27
2482894 2482894 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005852 50 Phillipsburg High School   Regular School No High 09 12 2020   kindergarten_full_day                                                   0.0                                             0
2482895 2482895 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005856 70 Philipsburg Primary School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   0.0                                             0
2482896 2482896 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005860 105 Phillipsburg Elementary School   Regular School No Elementary 03 05 2020   kindergarten_full_day                                                   0.0                                             0
2482897 2482897 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005862 110 Phillipsburg Middle School   Regular School No Middle 06 08 2020   kindergarten_full_day                                                   0.0                                             0
2482898 2482898 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   199.0                                             199
2482899 2482899 NJ Warren 41 school 3413260 4200   Pohatcong Twp 341326000366 40 Pohatcong Township School   Regular School No Elementary PK 08 2020   kindergarten_full_day                                                   38.0                                             38
2482900 2482900 NJ Warren 41 school 3417920 5460   Warren County Vocational 341792005872 50 Warren County Vocational Technical School   Career and Technical School No High 09 12 2020   kindergarten_full_day                                                   0.0                                             0
2482901 2482901 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005878 50 Warren Hills Regional High School   Regular School No High 09 12 2020   kindergarten_full_day                                                   0.0                                             0
2482902 2482902 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005880 60 Warren Hills Regional Middle School   Regular School No Middle 07 08 2020   kindergarten_full_day                                                   0.0                                             0
2482903 2482903 NJ Warren 41 school 3417010 5480   Washington Boro 341701005884 55 Washington Memorial Elementary School   Regular School No Elementary 03 06 2020   kindergarten_full_day                                                   0.0                                             0
2482904 2482904 NJ Warren 41 school 3417010 5480   Washington Boro 341701005886 60 Taylor Street Elementary School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   63.0                                             63
2482905 2482905 NJ Warren 41 school 3417160 5530   Washington Twp 341716005890 40 Brass Castle School   Regular School No Elementary 04 06 2020   kindergarten_full_day                                                   56.0                                             56
2482906 2482906 NJ Warren 41 school 3417160 5530   Washington Twp 341716005892 50 Port Colden School   Regular School No Elementary 01 03 2020   kindergarten_full_day                                                   0.0                                             0
2482907 2482907 NJ Warren 41 school 3417910 5780   White Twp 341791005894 50 White Township Consolidated School   Regular School No Elementary PK 08 2020   kindergarten_full_day                                                   25.0                                             25
2485372 2485372 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2020   kindergarten_half_day                                                   0.0                                             0
2485373 2485373 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   kindergarten_half_day                                                   0.0                                             0
2485374 2485374 NJ Warren 41 school 3400840 70   Alpha Boro 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2485375 2485375 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2485376 2485376 NJ Warren 41 school 3401440 280   Belvidere Town 340144005796 30 Oxford Street Elementary School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2485377 2485377 NJ Warren 41 school 3401800 400   Blairstown Twp 340180005800 30 Blairstown Elementary School   Regular School No Elementary PK 06 2020   kindergarten_half_day                                                   0.0                                             0
2485378 2485378 NJ Warren 41 school 3405520 1620   Franklin Twp 340552005802 50 Franklin Township School   Regular School No Elementary PK 06 2020   kindergarten_half_day                                                   0.0                                             0
2485379 2485379 NJ Warren 41 school 3405670 1670   Frelinghuysen Twp 340567005804 50 Frelinghuysen Township Elementary School   Regular School No Elementary PK 06 2020   kindergarten_half_day                                                   0.0                                             0
2485380 2485380 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2020   kindergarten_half_day                                                   0.0                                             0
2485381 2485381 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   kindergarten_half_day                                                   0.0                                             0
2485382 2485382 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621000471 40 Greenwich School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2485383 2485383 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621005810 70 Stewartsville Middle School   Regular School No Middle 06 08 2020   kindergarten_half_day                                                   0.0                                             0
2485384 2485384 NJ Warren 41 school 3406300 1870   Hackettstown 340630005814 50 Hackettstown High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2485385 2485385 NJ Warren 41 school 3406300 1870   Hackettstown 340630005816 60 Hackettstown Middle School   Regular School No Middle 05 08 2020   kindergarten_half_day                                                   0.0                                             0
2485386 2485386 NJ Warren 41 school 3406300 1870   Hackettstown 340630005818 70 Hatchery Hill Elementary School   Regular School No Elementary PK 01 2020   kindergarten_half_day                                                   0.0                                             0
2485387 2485387 NJ Warren 41 school 3406300 1870   Hackettstown 340630005820 90 Willow Grove Elementary School   Regular School No Elementary 02 04 2020   kindergarten_half_day                                                   0.0                                             0
2485388 2485388 NJ Warren 41 school 3406810 2040   Harmony Twp 340681005824 30 Harmony Township School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2485389 2485389 NJ Warren 41 school 3407470 2250   Hope Twp 340747005826 50 Hope Township School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2485390 2485390 NJ Warren 41 school 3408070 2470   Knowlton Twp 340807005832 40 Knowlton Township Board Of Education   Regular School No Elementary PK 06 2020   kindergarten_half_day                                                   0.0                                             0
2485391 2485391 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900005840 50 Lopatcong Elementary School   Regular School No Elementary PK 04 2020   kindergarten_half_day                                                   50.0                                             50
2485392 2485392 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900000731 60 Lopatcong Township Middle School   Regular School No Middle 05 08 2020   kindergarten_half_day                                                   0.0                                             0
2485393 2485393 NJ Warren 41 school 3409540 2970   Mansfield Twp 340954005842 50 Mansfield Township Elementary   Regular School No Elementary PK 06 2020   kindergarten_half_day                                                   0.0                                             0
2485394 2485394 NJ Warren 41 school 3409550 3675   North Warren Regional 340955005844 50 North Warren Regional School   Regular School No High 07 12 2020   kindergarten_half_day                                                   0.0                                             0
2485395 2485395 NJ Warren 41 school 3412300 3890   Oxford Twp 341230005846 50 Oxford Central School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2485396 2485396 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005852 50 Phillipsburg High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2485397 2485397 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005856 70 Philipsburg Primary School   Regular School No Elementary KG 02 2020   kindergarten_half_day                                                   0.0                                             0
2485398 2485398 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005860 105 Phillipsburg Elementary School   Regular School No Elementary 03 05 2020   kindergarten_half_day                                                   0.0                                             0
2485399 2485399 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005862 110 Phillipsburg Middle School   Regular School No Middle 06 08 2020   kindergarten_half_day                                                   0.0                                             0
2485400 2485400 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2020   kindergarten_half_day                                                   0.0                                             0
2485401 2485401 NJ Warren 41 school 3413260 4200   Pohatcong Twp 341326000366 40 Pohatcong Township School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2485402 2485402 NJ Warren 41 school 3417920 5460   Warren County Vocational 341792005872 50 Warren County Vocational Technical School   Career and Technical School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2485403 2485403 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005878 50 Warren Hills Regional High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2485404 2485404 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005880 60 Warren Hills Regional Middle School   Regular School No Middle 07 08 2020   kindergarten_half_day                                                   0.0                                             0
2485405 2485405 NJ Warren 41 school 3417010 5480   Washington Boro 341701005884 55 Washington Memorial Elementary School   Regular School No Elementary 03 06 2020   kindergarten_half_day                                                   0.0                                             0
2485406 2485406 NJ Warren 41 school 3417010 5480   Washington Boro 341701005886 60 Taylor Street Elementary School   Regular School No Elementary PK 02 2020   kindergarten_half_day                                                   0.0                                             0
2485407 2485407 NJ Warren 41 school 3417160 5530   Washington Twp 341716005890 40 Brass Castle School   Regular School No Elementary 04 06 2020   kindergarten_half_day                                                   0.0                                             0
2485408 2485408 NJ Warren 41 school 3417160 5530   Washington Twp 341716005892 50 Port Colden School   Regular School No Elementary 01 03 2020   kindergarten_half_day                                                   0.0                                             0
2485409 2485409 NJ Warren 41 school 3417910 5780   White Twp 341791005894 50 White Township Consolidated School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2487874 2487874 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2020   ungraded                                                   2.0                                             2
2487875 2487875 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   ungraded                                                   9.0                                             9
2487876 2487876 NJ Warren 41 school 3400840 70   Alpha Boro 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2020   ungraded                                                   1.0                                             1
2487877 2487877 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   ungraded                                                   2.0                                             2
2487878 2487878 NJ Warren 41 school 3401440 280   Belvidere Town 340144005796 30 Oxford Street Elementary School   Regular School No Elementary PK 08 2020   ungraded                                                   8.0                                             8
2487879 2487879 NJ Warren 41 school 3401800 400   Blairstown Twp 340180005800 30 Blairstown Elementary School   Regular School No Elementary PK 06 2020   ungraded                                                   2.0                                             2
2487880 2487880 NJ Warren 41 school 3405520 1620   Franklin Twp 340552005802 50 Franklin Township School   Regular School No Elementary PK 06 2020   ungraded                                                   4.0                                             4
2487881 2487881 NJ Warren 41 school 3405670 1670   Frelinghuysen Twp 340567005804 50 Frelinghuysen Township Elementary School   Regular School No Elementary PK 06 2020   ungraded                                                   0.0                                             0
2487882 2487882 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2020   ungraded                                                   13.0                                             13
2487883 2487883 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   ungraded                                                   23.0                                             23

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