enrollments

Data source: Big Local News · About: Big Local

45,036 rows where state = "NJ" and year = 2020 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 45,036 ✖
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
2474980 2474980 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   pk_12_total 3.0 17.0 72.0 0.0   1.0 0.0       0.0             53.8   1.1     54.8     93.0 3 17 72 0   1 0       0                       93
2477482 2477482 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2479984 2479984 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_half_day                                                   93.0                                             93
2482486 2482486 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten_full_day                                                   0.0                                             0
2484988 2484988 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2487490 2487490 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   ungraded                                                   0.0                                             0
2489992 2489992 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_1                                                   0.0                                             0
2492494 2492494 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_2                                                   0.0                                             0
2494996 2494996 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_3                                                   0.0                                             0
2497498 2497498 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_4                                                   0.0                                             0
2500000 2500000 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
2502502 2502502 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_6                                                   0.0                                             0
2505004 2505004 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
2507506 2507506 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_8                                                   0.0                                             0
2510008 2510008 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_9                                                   0.0                                             0
2512510 2512510 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_10                                                   0.0                                             0
2515012 2515012 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_11                                                   0.0                                             0
2517514 2517514 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_12                                                   0.0                                             0
2474514 2474514 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 180.0 73.0 303.0 0.0   3.0 1.0       21.0             22.7   2.4     85.89999999999999     581.0 180 73 303 0   3 1       21                       581
2477016 2477016 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2479518 2479518 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482020 2482020 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   5.0                                             5
2484522 2484522 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   kindergarten_half_day                                                   0.0                                             0
2487024 2487024 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   ungraded                                                   60.0                                             60
2489526 2489526 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_1                                                   134.0                                             134
2492028 2492028 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_2                                                   110.0                                             110
2494530 2494530 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_3                                                   80.0                                             80
2497032 2497032 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_4                                                   92.0                                             92
2499534 2499534 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_5                                                   100.0                                             100
2502036 2502036 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2504538 2504538 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2507040 2507040 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_8                                                   0.0                                             0
2509542 2509542 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_9                                                   0.0                                             0
2512044 2512044 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_10                                                   0.0                                             0
2514546 2514546 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_11                                                   0.0                                             0
2517048 2517048 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_12                                                   0.0                                             0
2474328 2474328 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   pk_12_total 6.0 38.0 879.0 0.0   2.0 0.0       4.0             37.6   0.6     66.8     929.0 6 38 879 0   2 0       4                       929
2476830 2476830 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2479332 2479332 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   142.0                                             142
2481834 2481834 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   kindergarten_full_day                                                   126.0                                             126
2484336 2484336 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2486838 2486838 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   ungraded                                                   23.0                                             23
2489340 2489340 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_1                                                   122.0                                             122
2491842 2491842 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_2                                                   135.0                                             135
2494344 2494344 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_3                                                   124.0                                             124
2496846 2496846 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_4                                                   134.0                                             134
2499348 2499348 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_5                                                   123.0                                             123
2501850 2501850 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_6                                                   0.0                                             0
2504352 2504352 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2506854 2506854 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_8                                                   0.0                                             0
2509356 2509356 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_9                                                   0.0                                             0
2511858 2511858 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_10                                                   0.0                                             0
2514360 2514360 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_11                                                   0.0                                             0
2516862 2516862 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_12                                                   0.0                                             0
2473506 2473506 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   pk_12_total 311.0 8.0 30.0 0.0   20.0 1.0       15.0             0   0.0     4.9     385.0 311 8 30 0   20 1       15                       385
2476008 2476008 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2478510 2478510 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2481012 2481012 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   65.0                                             65
2483514 2483514 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   kindergarten_half_day                                                   0.0                                             0
2486016 2486016 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   ungraded                                                   17.0                                             17
2488518 2488518 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_1                                                   53.0                                             53
2491020 2491020 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_2                                                   78.0                                             78
2493522 2493522 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_3                                                   49.0                                             49
2496024 2496024 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_4                                                   62.0                                             62
2498526 2498526 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_5                                                   61.0                                             61
2501028 2501028 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2503530 2503530 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2506032 2506032 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_8                                                   0.0                                             0
2508534 2508534 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_9                                                   0.0                                             0
2511036 2511036 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_10                                                   0.0                                             0
2513538 2513538 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_11                                                   0.0                                             0
2516040 2516040 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_12                                                   0.0                                             0
2473587 2473587 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   pk_12_total 2.0 20.0 28.0 0.0   1.0 0.0       0.0             0   0.0     64.7     51.0 2 20 28 0   1 0       0                       51
2476089 2476089 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2478591 2478591 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2481093 2481093 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   kindergarten_full_day                                                   0.0                                             0
2483595 2483595 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2486097 2486097 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   ungraded                                                   9.0                                             9
2488599 2488599 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_1                                                   0.0                                             0
2491101 2491101 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_2                                                   0.0                                             0
2493603 2493603 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_3                                                   0.0                                             0
2496105 2496105 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_4                                                   0.0                                             0
2498607 2498607 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_5                                                   0.0                                             0
2501109 2501109 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_6                                                   0.0                                             0
2503611 2503611 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_7                                                   2.0                                             2
2506113 2506113 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_8                                                   10.0                                             10
2508615 2508615 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_9                                                   3.0                                             3
2511117 2511117 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_10                                                   6.0                                             6
2513619 2513619 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_11                                                   13.0                                             13
2516121 2516121 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_12                                                   8.0                                             8
2475252 2475252 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   pk_12_total 107.0 323.0 220.0 1.0   7.0 1.0       2.0             10.3   0.0     53.6     661.0 107 323 220 1   7 1       2                       661
2477754 2477754 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480256 2480256 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   205.0                                             205
2482758 2482758 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   kindergarten_full_day                                                   199.0                                             199
2485260 2485260 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   kindergarten_half_day                                                   0.0                                             0
2487762 2487762 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   ungraded                                                   63.0                                             63
2490264 2490264 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_1                                                   194.0                                             194
2492766 2492766 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_2                                                   0.0                                             0
2495268 2495268 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_3                                                   0.0                                             0
2497770 2497770 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_4                                                   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]);