Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2020 · 45,000
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
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
2500272 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_5                                                   0.0                                             0
2502774 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_6                                                   0.0                                             0
2505276 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_7                                                   0.0                                             0
2507778 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_8                                                   0.0                                             0
2510280 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_9                                                   0.0                                             0
2512782 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_10                                                   0.0                                             0
2515284 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_11                                                   0.0                                             0
2517786 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_12                                                   0.0                                             0
2474627 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   pk_12_total 246.0 6.0 103.0 0.0   12.0 1.0       4.0             11   0.3     28.7     372.0 246 6 103 0   12 1       4                       372
2477129 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2479631 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482133 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   kindergarten_full_day                                                   69.0                                             69
2484635 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   kindergarten_half_day                                                   0.0                                             0
2487137 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   ungraded                                                   42.0                                             42
2489639 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_1                                                   65.0                                             65
2492141 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_2                                                   66.0                                             66
2494643 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_3                                                   70.0                                             70
2497145 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_4                                                   60.0                                             60
2499647 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2502149 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_6                                                   0.0                                             0
2504651 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_7                                                   0.0                                             0
2507153 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_8                                                   0.0                                             0
2509655 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_9                                                   0.0                                             0
2512157 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_10                                                   0.0                                             0
2514659 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_11                                                   0.0                                             0
2517161 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_12                                                   0.0                                             0
2473810 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   pk_12_total 13.0 73.0 772.0 0.0   15.0 5.0       0.0             23.6   1.7     92.60000000000001     878.0 13 73 772 0   15 5       0                       878
2476312 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2478814 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   7.0                                             7
2481316 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   kindergarten_full_day                                                   89.0                                             89
2483818 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2486320 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   ungraded                                                   38.0                                             38
2488822 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   grade_1                                                   88.0                                             88
2491324 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   grade_2                                                   91.0                                             91
2493826 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   grade_3                                                   93.0                                             93
2496328 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   grade_4                                                   90.0                                             90

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