enrollments

Data source: Big Local News · About: Big Local

4,760 rows where grade = "grade_7" and state = "TX" sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,760 ✖
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 ▼
1374431 1374431 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2021   grade_7                                                   <10                                             10
1374459 1374459 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744009497 221901008 JUVENILE DETENTION CENTER   Alternative School No Secondary 07 11 2021   grade_7                                                   <10                                             10
1374522 1374522 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007123 221901003 WOODSON CENTER FOR EXCELLENCE   Alternative School No High 06 12 2021   grade_7                                                   <10                                             10
1374530 1374530 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009308164 57814001 DALLAS COUNTY JUVENILE JUSTICE   Alternative School Yes High 05 12 2021   grade_7                                                   <10                                             10
1374542 1374542 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009312112 57814003 MEDLOCK YOUTH VILLAGE   Alternative School Yes High 07 12 2021   grade_7                                                   <10                                             10
1374869 1374869 TX HARRIS COUNTY   school 4807710 101902   ALDINE ISD 480771000075 101902108 LANE SCHOOL   Special Education School No Other PK 12 2021   grade_7                                                   <10                                             10
1375306 1375306 TX HARRIS COUNTY   school 4800035 101815   ALIEF MONTESSORI COMMUNITY SCHOOL 480003507914 101815101 ALIEF MONTESSORI COMMUNITY SCHOOL   Regular School Yes Elementary PK 08 2021   grade_7                                                   10                                             10
1376057 1376057 TX LAMB COUNTY   school 4808160 140901   AMHERST ISD 480816000188 140901001 AMHERST SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1376132 1376132 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 06 12 2021   grade_7                                                   <10                                             10
1376176 1376176 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831006642 20902002 STUDENT ALTERNATIVE CTR   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1376215 1376215 TX COLLIN COUNTY   school 4808340 43902   ANNA ISD 480834010492 43902197 SPECIAL PROG CTR/J J A E P   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1377080 1377080 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894009076 227901012 ALTERNATIVE LEARNING CENTER   Alternative School No Secondary 07 11 2021   grade_7                                                   <10                                             10
1377103 1377103 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No High 05 12 2021   grade_7                                                   <10                                             10
1377695 1377695 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2021   grade_7                                                   <10                                             10
1377873 1377873 TX CASS COUNTY   school 4809090 34902   AVINGER ISD 480909000378 34902001 AVINGER SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1377895 1377895 TX MCLENNAN COUNTY   school 4809150 161918   AXTELL ISD 480915006358 161918199 WACO CTR FOR YOUTH   Alternative School No High 06 12 2021   grade_7                                                   <10                                             10
1378047 1378047 TX CHAMBERS COUNTY   school 4809450 36902   BARBERS HILL ISD 480945011547 36902005 ALTERNATIVE SCHOOL   Alternative School No Secondary 07 11 2021   grade_7                                                   <10                                             10
1378073 1378073 TX CHAMBERS COUNTY   school 4809450 36902   BARBERS HILL ISD 480945013300 36902006 HIGHPOINT   Alternative School No Middle 07 07 2021   grade_7                                                   <10                                             10
1378316 1378316 TX JEFFERSON COUNTY   school 4809670 123910   BEAUMONT ISD 480967006510 123910006 PATHWAYS LEARNING CTR   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1378401 1378401 TX CLAY COUNTY   school 4809750 39904   BELLEVUE ISD 480975000446 39904001 BELLEVUE SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   10                                             10
1378943 1378943 TX BROWN COUNTY   school 4810380 25904   BLANKET ISD 481038005661 25904001 BLANKET SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   10                                             10
1379348 1379348 TX SOMERVELL COUNTY   school 4800214 213801   BRAZOS RIVER CHARTER SCHOOL 480021408907 213801001 BRAZOS RIVER CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_7                                                   <10                                             10
1379423 1379423 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No Other 04 12 2021   grade_7                                                   <10                                             10
1379621 1379621 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155013892 25908004 DAVINCI   Alternative School No Secondary 07 11 2021   grade_7                                                   <10                                             10
1379626 1379626 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155013724 25908003 GENESIS CAMPUS   Alternative School No Other 04 11 2021   grade_7                                                   <10                                             10
1380117 1380117 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179008456 21902014 BRAZOS CO JUVENILE DETENTION CENTE   Alternative School No Other 04 12 2021   grade_7                                                   <10                                             10
1380135 1380135 TX BRAZOS COUNTY   school 4811790 21902   BRYAN ISD 481179007816 21902012 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1380678 1380678 TX ROBERTSON COUNTY   school 4812540 198902   CALVERT ISD 481254000756 198902101 CALVERT SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   10                                             10
1381236 1381236 TX TARRANT COUNTY   school 4813170 220917   CASTLEBERRY ISD 481317007446 220917004 T R U C E LEARNING CTR   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1381432 1381432 TX TRINITY COUNTY   school 4813380 228904   CENTERVILLE ISD 481338000839 228904001 CENTERVILLE H S   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1381628 1381628 TX SAN SABA COUNTY   school 4813740 206903   CHEROKEE ISD 481374000866 206903001 CHEROKEE SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1382216 1382216 TX LIBERTY COUNTY   school 4814370 146901   CLEVELAND ISD 481437007381 146901003 DISCIPLINARY ALTERNATIVE EDUCATION   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1382618 1382618 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 06 12 2021   grade_7                                                   <10                                             10
1382886 1382886 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other KG 12 2021   grade_7                                                   <10                                             10
1383082 1383082 TX MONTGOMERY COUNTY   school 4815000 170902   CONROE ISD 481500007998 170902201 JUVENILE DETENTION CTR   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1383819 1383819 TX HALE COUNTY   school 4815360 95902   COTTON CENTER ISD 481536001112 95902001 COTTON CENTER SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1384049 1384049 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 12 2021   grade_7                                                   <10                                             10
1384094 1384094 TX FOARD COUNTY   school 4815870 78901   CROWELL ISD 481587001153 78901001 CROWELL SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1384300 1384300 TX SMITH COUNTY   school 4800034 212801   CUMBERLAND ACADEMY 480003413578 212801102 THE LEADERSHIP ACADEMY   Regular School Yes Elementary KG 08 2021   grade_7                                                   <10                                             10
1385478 1385478 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other KG 12 2021   grade_7                                                   <10                                             10
1385842 1385842 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006965 57905030 MAYA ANGELOU H S   Alternative School No Secondary 07 10 2021   grade_7                                                   <10                                             10
1386370 1386370 TX LIPSCOMB COUNTY   school 4816320 148905   DARROUZETT ISD 481632001699 148905101 DARROUZETT SCHOOLS   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1386398 1386398 TX DAWSON COUNTY   school 4816350 58902   DAWSON ISD 481635001399 58902001 DAWSON SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1386649 1386649 TX HUDSPETH COUNTY   school 4816650 115903   DELL CITY ISD 481665001429 115903001 DELL CITY SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1386747 1386747 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007581 61901006 DENTON CO J J A E P   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1386818 1386818 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674003735 61901040 JOE DALE SPARKS CAMPUS   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1386824 1386824 TX DENTON COUNTY   school 4816740 61901   DENTON ISD 481674007265 61901005 LESTER DAVIS   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1387126 1387126 TX GALVESTON COUNTY   school 4817070 84901   DICKINSON ISD 481707007290 84901012 GALVESTON CO DETENTION CTR   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1387604 1387604 TX TARRANT COUNTY   school 4817700 220918   EAGLE MT-SAGINAW ISD 481770007447 220918003 ALTER DISCIPLINE CAMPUS   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1387955 1387955 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785007517 15911005 BEXAR COUNTY LRN CTR   Alternative School No Secondary 07 11 2021   grade_7                                                   <10                                             10
1387960 1387960 TX BEXAR COUNTY   school 4817850 15911   EAST CENTRAL ISD 481785008449 15911003 EAST CENTRAL CHOICE PROGAM   Alternative School No Secondary 07 11 2021   grade_7                                                   <10                                             10
1388070 1388070 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800001596 68901004 ALTER ED CTR   Alternative School No Secondary 06 11 2021   grade_7                                                   <10                                             10
1388622 1388622 TX HIDALGO COUNTY   school 4818180 108904   EDINBURG CISD 481818007651 108904039 J J A E P   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1388962 1388962 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830003812 71902025 DELTA ACADEMY   Alternative School No Middle 05 11 2021   grade_7                                                   <10                                             10
1389235 1389235 TX EL PASO COUNTY   school 4818300 71902   EL PASO ISD 481830006945 71902027 TELLES ACADEMY   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1389444 1389444 TX ERATH COUNTY   school 4800159 72802   ERATH EXCELS ACADEMY INC 480015912097 72802002 COASTAL HORIZONS ACADEMY   Alternative School Yes High 07 12 2021   grade_7                                                   <10                                             10
1389465 1389465 TX NACOGDOCHES COUNTY   school 4818660 174910   ETOILE ISD 481866001747 174910101 ETOILE EL   Regular School No Elementary PK 08 2021   grade_7                                                   <10                                             10
1389581 1389581 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004907909 101811001 HARRIS COUNTY JUVENILE DETENTION C   Alternative School Yes High 07 12 2021   grade_7                                                   <10                                             10
1389588 1389588 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908231 101811004 HARRIS COUNTY YOUTH VILLAGE   Alternative School Yes High 06 12 2021   grade_7                                                   <10                                             10
1389594 1389594 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908233 101811006 LEADERSHIP ACADEMY   Alternative School Yes High 07 12 2021   grade_7                                                   <10                                             10
1389618 1389618 TX SHELBY COUNTY   school 4818840 210906   EXCELSIOR ISD 481884001762 210906101 EXCELSIOR EL   Regular School No Elementary PK 08 2021   grade_7                                                   10                                             10
1389628 1389628 TX LAVACA COUNTY   school 4818890 143906   EZZELL ISD 481889001764 143906101 EZZELL EL   Regular School No Elementary PK 08 2021   grade_7                                                   <10                                             10
1389771 1389771 TX FAYETTE COUNTY   school 4819280 75901   FLATONIA ISD 481928012888 75901103 WHISPERING HILLS ACHIEVEMENT CENTE   Alternative School No Other 04 12 2021   grade_7                                                   <10                                             10
1389818 1389818 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935008091 247901003 WILSON CO J J A E P   Alternative School No Secondary 07 11 2021   grade_7                                                   <10                                             10
1389856 1389856 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944009239 77901004 FLOYDADA ISD DAEP   Alternative School No Middle 05 11 2021   grade_7                                                   <10                                             10
1389882 1389882 TX MONTAGUE COUNTY   school 4819530 169910   FORESTBURG ISD 481953001808 169910001 FORESTBURG SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   10                                             10
1390110 1390110 TX FORT BEND COUNTY   school 4819650 79907   FORT BEND ISD 481965007605 79907010 FORT BEND CO ALTER   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1390549 1390549 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other KG 12 2021   grade_7                                                   <10                                             10
1390555 1390555 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021058 220905212 BRIDGE ASSOC   Alternative School No Secondary 07 11 2021   grade_7                                                   <10                                             10
1390690 1390690 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005469 220905024 DETENT CTR   Alternative School No High 06 12 2021   grade_7                                                   <10                                             10
1390839 1390839 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other PK 12 2021   grade_7                                                   <10                                             10
1390853 1390853 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970009035 220905040 JUVENILE JUSTICE ALTERNATIVE ED PR   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1390956 1390956 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001835 220905018 MIDDLE LVL LRN CTR   Alternative School No Middle 07 07 2021   grade_7                                                   <10                                             10
1392021 1392021 TX HARRIS COUNTY   school 4820250 101910   GALENA PARK ISD 482025006973 101910006 HIGHPOINT SCHOOL EAST (DAEP)   Alternative School No Middle 07 07 2021   grade_7                                                   <10                                             10
1393509 1393509 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142006970 57910004 LYNDON B JOHNSON DAEP   Alternative School No High 06 12 2021   grade_7                                                   <10                                             10
1393921 1393921 TX HUNT COUNTY   school 4821720 116905   GREENVILLE ISD 482172007361 116905004 GREENVILLE ALTERNATIVE EDUCATIONAL   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1394090 1394090 TX COMANCHE COUNTY   school 4821990 47903   GUSTINE ISD 482199002215 47903001 GUSTINE SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1394104 1394104 TX KING COUNTY   school 4822020 135001   GUTHRIE CSD 482202002217 135001001 GUTHRIE SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   10                                             10
1394125 1394125 TX LAVACA COUNTY   school 4822120 143901   HALLETTSVILLE ISD 482212009327 143901002 G O A L S PROGRAM   Alternative School No Elementary 01 07 2021   grade_7                                                   <10                                             10
1394322 1394322 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247009123 15904047 FENLEY TRANSITIONAL MIDDLE   Alternative School No Middle 06 07 2021   grade_7                                                   <10                                             10
1394344 1394344 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247007799 15904045 HAC DAEP MIDDLE   Alternative School No Middle 07 08 2021   grade_7                                                   <10                                             10
1394563 1394563 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253006940 31903118 SECONDARY ALTER CTR   Alternative School No High 06 12 2021   grade_7                                                   <10                                             10
1395323 1395323 TX DONLEY COUNTY   school 4822850 65902   HEDLEY ISD 482285002317 65902001 HEDLEY SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1395523 1395523 TX GALVESTON COUNTY   school 4823160 84903   HIGH ISLAND ISD 482316002351 84903001 HIGH ISLAND SCHOOL   Regular School No Other PK 12 2021   grade_7                                                   <10                                             10
1395731 1395731 TX HIDALGO COUNTY   school 4800065 108802   HORIZON MONTESSORI PUBLIC SCHOOLS 480006510814 108802101 HORIZON MONTESSORI   Regular School Yes Elementary PK 08 2021   grade_7                                                   <10                                             10
1395741 1395741 TX HIDALGO COUNTY   school 4800065 108802   HORIZON MONTESSORI PUBLIC SCHOOLS 480006513976 108802104 HORIZON MONTESSORI - PEARLAND   Regular School Yes Elementary PK 08 2021   grade_7                                                   <10                                             10
1395760 1395760 TX HIDALGO COUNTY   school 4800065 108802   HORIZON MONTESSORI PUBLIC SCHOOLS 480006512111 108802103 HORIZON MONTESSORI III   Regular School Yes Elementary PK 08 2021   grade_7                                                   10                                             10
1396070 1396070 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364006270 101912013 COMMUNITY SERVICES-SEC   Alternative School No Other 01 12 2021   grade_7                                                   <10                                             10
1396399 1396399 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364011265 101912351 HARPER DAEP   Alternative School No High 06 12 2021   grade_7                                                   <10                                             10
1397203 1397203 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364007018 101912069 SOAR CTR   Special Education School No Other PK 12 2021   grade_7                                                   <10                                             10
1397510 1397510 TX BOWIE COUNTY   school 4823700 19913   HUBBARD ISD 482370002624 19913101 HUBBARD ISD   Regular School No Elementary PK 08 2021   grade_7                                                   <10                                             10
1398860 1398860 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005309121 15808003 JHW INSPIRE ACADEMY - HAYS COUNTY   Alternative School Yes High 07 12 2021   grade_7                                                   <10                                             10
1398873 1398873 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2021   grade_7                                                   <10                                             10
1398879 1398879 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 06 12 2021   grade_7                                                   <10                                             10
1399614 1399614 TX ATASCOSA COUNTY   school 4824960 7902   JOURDANTON ISD 482496007778 7902005 ATASCOSA COUNTY JUVENILE JUSTICE C   Alternative School No Secondary 07 11 2021   grade_7                                                   <10                                             10
1400294 1400294 TX HARRIS COUNTY   school 4825170 101914   KATY ISD 482517005516 101914003 OPPORT AWARENESS CTR   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1401571 1401571 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574007642 101915037 HARRIS CO JJAEP   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1401597 1401597 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574008632 101915038 K E KAUFMAN ALTERNATIVE EDUCATION   Alternative School No High 06 12 2021   grade_7                                                   <10                                             10
1402060 1402060 TX HIDALGO COUNTY   school 4826130 108912   LA JOYA ISD 482613009585 108912005 HOPE ACADEMY   Alternative School No High 07 12 2021   grade_7                                                   <10                                             10
1402280 1402280 TX WILSON COUNTY   school 4826310 247903   LA VERNIA ISD 482631007500 247903002 FLORESVILLE ALTERNATIVE EDUCATION   Alternative School No Secondary 07 11 2021   grade_7                                                   <10                                             10

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