enrollments

Data source: Big Local News · About: Big Local

272 rows where grade = "grade_7", state = "MS" and year = 2021 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 172 ✖

grade ✖

  • grade_7 · 172 ✖
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
2244260 2244260 MS     school 2803180 5130   NEWTON MUNICIPAL SCHOOL DISTRICT 280318001179 5130006 N H PILATE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   78                                             78
2244243 2244243 MS     school 2803150 5100   NEWTON COUNTY SCHOOL DISTRICT 280315001135 5100012 NEWTON COUNTY HIGH SCHOOL   Regular School No High 06 12 2021   grade_7                                                   152                                             152
2244225 2244225 MS     school 2803600 5020   PHILADELPHIA PUBLIC SCHOOL DIST 280360000692 5020008 PHILADELPHIA HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   71                                             71
2244205 2244205 MS     school 2803060 5000   NESHOBA COUNTY SCHOOL DISTRICT 280306000990 5000006 NESHOBA CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   264                                             264
2244184 2244184 MS     school 2800196 4911   WINONA-MONTGOMERY CONSOLIDATED SD 280019601485 4911006 WINONA SECONDARY SCHOOL   Regular School No High 07 12 2021   grade_7                                                   92                                             92
2244164 2244164 MS     school 2800450 4821   AMORY SCHOOL DIST 280045000030 4821012 AMORY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   127                                             127
2244147 2244147 MS     school 2800360 4820   ABERDEEN SCHOOL DIST 280036001467 4820032 BELLE SHIVERS MIDDLE SCHOOL   Regular School No Middle 04 08 2021   grade_7                                                   95                                             95
2244123 2244123 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000582 4800020 SMITHVILLE HIGH SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   47                                             47
2244108 2244108 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000581 4800016 HATLEY HIGH SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   73                                             73
2244092 2244092 MS     school 2802940 4800   MONROE CO SCHOOL DIST 280294000580 4800012 HAMILTON HIGH SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   53                                             53
2244071 2244071 MS     school 2801950 4720   HOLLY SPRINGS SCHOOL DIST 280195001248 4720007 HOLLY SPRINGS JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   110                                             110
2244057 2244057 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000553 4700024 H. W. BYERS HIGH SCHOOL (5-12)   Regular School No High 05 12 2021   grade_7                                                   57                                             57
2244033 2244033 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285000551 4700016 POTTS CAMP HIGH SCHOOL (4-12)   Regular School No Other 04 12 2021   grade_7                                                   55                                             55
2244025 2244025 MS     school 2802850 4700   MARSHALL CO SCHOOL DIST 280285001291 4700013 BYHALIA MIDDLE SCHOOL (5-8)   Regular School No Middle 05 08 2021   grade_7                                                   127                                             127
2243998 2243998 MS     school 2801170 4620   COLUMBIA SCHOOL DISTRICT 280117000151 4620016 JEFFERSON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   119                                             119
2243967 2243967 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282001247 4600014 WEST MARION HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   115                                             115
2243955 2243955 MS     school 2802820 4600   MARION CO SCHOOL DIST 280282000545 4600008 EAST MARION HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   54                                             54
2243924 2243924 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090001394 4520018 HUEY L. PORTER MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   131                                             131
2243919 2243919 MS     school 2800900 4520   CANTON PUBLIC SCHOOL DIST 280090000103 4520016 NICHOLS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   131                                             131
2243866 2243866 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000938 4500040 OLD TOWN MIDDLE   Regular School No Middle 06 08 2021   grade_7                                                   247                                             247
2243839 2243839 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001082 4500028 MADISON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   407                                             407
2243818 2243818 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279001283 4500022 GERMANTOWN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   361                                             361
2243799 2243799 MS     school 2802790 4500   MADISON CO SCHOOL DIST 280279000989 4500014 SHIRLEY D. SIMMONS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   42                                             42
2243732 2243732 MS     school 2801200 4420   COLUMBUS MUNICIPAL SCHOOL DIST 280120001380 4420018 COLUMBUS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   279                                             279
2243700 2243700 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001128 4400018 NEW HOPE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   224                                             224
2243675 2243675 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273000531 4400012 WEST LOWNDES HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   42                                             42
2243671 2243671 MS     school 2802730 4400   LOWNDES CO SCHOOL DIST 280273001126 4400006 CALEDONIA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   200                                             200
2243631 2243631 MS     school 2800840 4320   BROOKHAVEN SCHOOL DIST 280084000090 4320004 ALEXANDER JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   231                                             231
2243620 2243620 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000516 4300020 WEST LINCOLN SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   54                                             54
2243602 2243602 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000515 4300016 LOYD STAR SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   63                                             63
2243587 2243587 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000513 4300008 ENTERPRISE SCHOOL   Regular School No Other KG 12 2021   grade_7                                                   66                                             66
2243573 2243573 MS     school 2802640 4300   LINCOLN CO SCHOOL DIST 280264000512 4300004 BOGUE CHITTO SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   72                                             72
2243560 2243560 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801522 4211032 GREENWOOD MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   214                                             214
2243532 2243532 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801518 4211020 LEFLORE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   54                                             54
2243504 2243504 MS     school 2800198 4211   GREENWOOD-LEFLORE CONSOLIDATED SD 280019801513 4211005 AMANDA ELZY JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   121                                             121
2243483 2243483 MS     school 2804320 4120   TUPELO PUBLIC SCHOOL DIST 280432000293 4120042 TUPELO MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   538                                             538
2243425 2243425 MS     school 2803090 4111   NETTLETON SCHOOL DIST 280309001160 4111010 NETTLETON INTERMEDIATE SCHOOL   Regular School No Middle 04 08 2021   grade_7                                                   104                                             104
2243387 2243387 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001325 4100027 SHANNON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   84                                             84
2243361 2243361 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000495 4100016 PLANTERSVILLE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   67                                             67
2243340 2243340 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255001276 4100007 MOOREVILLE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   *                                              
2243336 2243336 MS     school 2802550 4100   LEE COUNTY SCHOOL DISTRICT 280255000492 4100004 GUNTOWN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   262                                             262
2243327 2243327 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252000490 4000016 LEAKE COUNTY HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   68                                             68
2243313 2243313 MS     school 2802520 4000   LEAKE CO SCHOOL DIST 280252001119 4000006 LEAKE CENTRAL JUNIOR HIGH   Regular School No Middle 06 08 2021   grade_7                                                   163                                             163
2243293 2243293 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000485 3900024 TOPEKA TILTON ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   grade_7                                                   49                                             49
2243283 2243283 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000483 3900016 NEW HEBRON ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   grade_7                                                   52                                             52
2243259 2243259 MS     school 2802490 3900   LAWRENCE CO SCHOOL DIST 280249000480 3900004 ROD PAIGE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   72                                             72
2243208 2243208 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000569 3820044 NORTHWEST JUNIOR HIGH SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   170                                             170
2243197 2243197 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000564 3820024 MAGNOLIA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   124                                             124
2243184 2243184 MS     school 2802910 3820   MERIDIAN PUBLIC SCHOOL DIST 280291000559 3820004 GEORGE WASHINGTON CARVER MIDDLE   Regular School No Middle 06 08 2021   grade_7                                                   *                                              
2243163 2243163 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000471 3800016 WEST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   153                                             153
2243156 2243156 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001174 3800014 SOUTHEAST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   94                                             94
2243134 2243134 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243000568 3800010 NORTHEAST LAUDERDALE MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   151                                             151
2243109 2243109 MS     school 2802430 3800   LAUDERDALE CO SCHOOL DIST 280243001348 3800005 CLARKDALE HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   *                                              
2243093 2243093 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001507 3700025 LUMBERTON MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   51                                             51
2243076 2243076 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001254 3700022 PURVIS MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   143                                             143
2243071 2243071 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001253 3700021 OAK GROVE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   461                                             461
2243049 2243049 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240001316 3700017 SUMRALL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   169                                             169
2243001 2243001 MS     school 2802400 3700   LAMAR COUNTY SCHOOL DISTRICT 280240000464 3700004 BAXTERVILLE SCHOOL   Regular School No Elementary PK 08 2021   grade_7                                                   31                                             31
2242988 2242988 MS     school 2803450 3620   OXFORD SCHOOL DISTRICT 280345000664 3620016 OXFORD MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   307                                             307
2242955 2242955 MS     school 2802370 3600   LAFAYETTE CO SCHOOL DIST 280237000967 3600012 LAFAYETTE MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   *                                              
2242933 2242933 MS     school 2802310 3500   KEMPER CO SCHOOL DIST 280231001489 3500014 KEMPER COUNTY MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   78                                             78
2242893 2242893 MS     school 2802460 3420   LAUREL SCHOOL DISTRICT 280246001345 3420006 LAUREL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   222                                             222
2242876 2242876 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000451 3400052 WEST JONES HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   270                                             270
2242858 2242858 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000450 3400036 SOUTH JONES HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   242                                             242
2242826 2242826 MS     school 2802280 3400   JONES CO SCHOOL DIST 280228000443 3400024 NORTHEAST JONES HIGH SCHOOL   Regular School No High 07 12 2021   grade_7                                                   150                                             150
2242788 2242788 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000432 3300012 J E JOHNSON ELEMENTARY   Regular School No Elementary KG 08 2021   grade_7                                                   58                                             58
2242771 2242771 MS     school 2802250 3300   JEFFERSON DAVIS CO SCHOOL DIST 280225000430 3300004 CARVER ELEMENTARY SCHOOL   Regular School No Elementary KG 08 2021   grade_7                                                   52                                             52
2242761 2242761 MS     school 2802220 3200   JEFFERSON CO SCHOOL DIST 280222001292 3200012 JEFFERSON CO JR HI   Regular School No Middle 07 08 2021   grade_7                                                   103                                             103
2242736 2242736 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000859 3112012 STRINGER ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_7                                                   38                                             38
2242725 2242725 MS     school 2804590 3112   WEST JASPER CONSOLIDATED SCHOOLS 280459000899 3112010 BAY SPRINGS MIDDLE SCH   Regular School No Middle 06 08 2021   grade_7                                                   72                                             72
2242706 2242706 MS     school 2801380 3111   EAST JASPER CONSOLIDATED SCH DIST 280138001315 3111010 HEIDELBERG JUNIOR HIGH SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   79                                             79
2242644 2242644 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000675 3022040 GAUTIER MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   238                                             238
2242625 2242625 MS     school 2803480 3022   PASCAGOULA GAUTIER SCHOOL DIST 280348000671 3022024 WILLIAM M COLMER MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   302                                             302
2242576 2242576 MS     school 2803360 3021   OCEAN SPRINGS SCHOOL DIST 280336000934 3021022 OCEAN SPRINGS MIDDLE SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   474                                             474
2242546 2242546 MS     school 2803000 3020   MOSS POINT SEPARATE SCHOOL DIST 280300000592 3020028 MAGNOLIA MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   *                                              
2242516 2242516 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000963 3000024 ST. MARTIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   340                                             340
2242497 2242497 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216001049 3000018 VANCLEAVE MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   183                                             183
2242452 2242452 MS     school 2802160 3000   JACKSON CO SCHOOL DIST 280216000364 3000004 EAST CENTRAL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   *                                              
2242431 2242431 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000362 2900028 TREMONT ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_7                                                   28                                             28
2242416 2242416 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000361 2900024 MANTACHIE ATTENDANCE CENTER   Regular School No Other KG 12 2021   grade_7                                                   96                                             96
2242405 2242405 MS     school 2802100 2900   ITAWAMBA CO SCHOOL DIST 280210000358 2900012 ITAWAMBA ATTENDANCE CENTER   Regular School No Elementary KG 08 2021   grade_7                                                   154                                             154
2242370 2242370 MS     school 2802040 2700   HUMPHREYS CO SCHOOL DIST 280204001039 2700006 O M MC NAIR MIDDLE SCHOOL   Regular School No Middle 05 08 2021   grade_7                                                   133                                             133
2242344 2242344 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501528 2611011 S V MARSHALL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   158                                             158
2242328 2242328 MS     school 2800195 2611   HOLMES CONSOLIDATE SCHOOL DIST 280019501491 2611006 WILLIAMS-SULLIVAN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   105                                             105
2242304 2242304 MS     school 2801189 2560   MS SCH FOR THE BLIND AND DEAF 280118901194 2560004 MS SCHOOL FOR THE BLIND   Special Education School No Other 01 12 2021   grade_7                                                   *                                              
2242292 2242292 MS     school 2801189 2560   MS SCH FOR THE BLIND AND DEAF 280118901504 2560002 MS SCHOOL FOR THE DEAF   Special Education School No Other PK 12 2021   grade_7                                                   *                                              
2242276 2242276 MS     school 2800192 2535   SMILOW PREP 280019201471 2535004 JOEL E. SMILOW PREP   Regular School Yes Middle 05 08 2021   grade_7                                                   170                                             170
2242270 2242270 MS     school 2800190 2525   MIDTOWN PUBLIC CHARTER SCHOOL 280019001448 2525004 MIDTOWN PUBLIC CHARTER SCHOOL   Regular School Yes Middle 05 08 2021   grade_7                                                   72                                             72
2242246 2242246 MS     school 2801090 2521   CLINTON PUBLIC SCHOOL DIST 280109000132 2521008 CLINTON JR HI SCHOOL   Regular School No Middle 07 08 2021   grade_7                                                   451                                             451
2242222 2242222 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000421 2520086 WHITTEN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   128                                             128
2242217 2242217 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001370 2520085 CARDOZO MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   232                                             232
2242133 2242133 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000407 2520065 POWELL MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   152                                             152
2242128 2242128 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000405 2520062 PEEPLES MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   122                                             122
2242083 2242083 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001365 2520055 KIRKSEY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   104                                             104
2242069 2242069 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001155 2520052 NORTHWEST MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   110                                             110
2241947 2241947 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000380 2520023 CHASTAIN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   185                                             185
2241928 2241928 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000375 2520014 BRINKLEY MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   132                                             132
2241915 2241915 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219000372 2520010 BLACKBURN MIDDLE SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   209                                             209
2241902 2241902 MS     school 2802190 2520   JACKSON PUBLIC SCHOOL DIST 280219001385 2520006 BAILEY MIDDLE APAC SCHOOL   Regular School No Middle 06 08 2021   grade_7                                                   136                                             136
2241891 2241891 MS     school 2800188 2515   REIMAGINE PREP 280018801442 2515004 REIMAGINE PREP   Regular School Yes Middle 05 08 2021   grade_7                                                   177                                             177

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