Data source: Big Local News · About: Big Local

5,234 rows where grade = "grade_6" and state = "TX" sorted by ccd_school_type

View and edit SQL

year

grade

  • grade_6 · 5,234
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
1374430 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007449 221901006 DAEP   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1374521 TX TAYLOR COUNTY   school 4807440 221901   ABILENE ISD 480744007123 221901003 WOODSON CENTER FOR EXCELLENCE   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1374529 TX DALLAS COUNTY   school 4800093 57814   ACADEMY FOR ACADEMIC EXCELLENCE 480009308164 57814001 DALLAS COUNTY JUVENILE JUSTICE   Alternative School Yes High 05 12 2021   grade_6                                                   <10                                             10
1374569 TX HARRIS COUNTY   school 4800032 101810   ACADEMY OF ACCELERATED LEARNING IN 480003208585 101810002 ACADEMY OF ACCELERATED LEARNING   Alternative School Yes Elementary PK 07 2021   grade_6                                                   75                                             75
1376131 TX BRAZORIA COUNTY   school 4808310 20902   ANGLETON ISD 480831007814 20902004 BRAZORIA CO JUVENILE DETENTION   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1376297 TX HILL COUNTY   school 4808520 109912   AQUILLA ISD 480852010845 109912010 HILL CO J J A E P   Alternative School No Middle 06 06 2021   grade_6                                                   <10                                             10
1377102 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005646 227901250 AUSTIN ST HOSPITAL   Alternative School No High 05 12 2021   grade_6                                                   <10                                             10
1377666 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894011354 227901028 RICHARDS SCH FOR YOUNG WOMEN LEADE   Alternative School No High 06 12 2021   grade_6                                                   140                                             140
1377694 TX TRAVIS COUNTY   school 4808940 227901   AUSTIN ISD 480894005396 227901251 ROSEDALE   Alternative School No Other PK 12 2021   grade_6                                                   <10                                             10
1377894 TX MCLENNAN COUNTY   school 4809150 161918   AXTELL ISD 480915006358 161918199 WACO CTR FOR YOUTH   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1378647 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022709011 193801001 BIG SPRINGS CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_6                                                   13                                             13
1378660 TX REAL COUNTY   school 4800227 193801   BIG SPRINGS CHARTER SCHOOL 480022711321 193801101 HILL COUNTRY YOUTH RANCH   Alternative School Yes Other KG 12 2021   grade_6                                                   14                                             14
1379284 TX OLDHAM COUNTY   school 4811040 180901   BOYS RANCH ISD 481104005141 180901041 BLAKEMORE MIDDLE   Alternative School No Middle 06 08 2021   grade_6                                                   <10                                             10
1379347 TX SOMERVELL COUNTY   school 4800214 213801   BRAZOS RIVER CHARTER SCHOOL 480021408907 213801001 BRAZOS RIVER CHARTER SCHOOL   Alternative School Yes Other KG 12 2021   grade_6                                                   <10                                             10
1379422 TX BRAZORIA COUNTY   school 4811190 20905   BRAZOSPORT ISD 481119007528 20905004 LIGHTHOUSE LEARNING CENTER - DAEP   Alternative School No Other 04 12 2021   grade_6                                                   <10                                             10
1379625 TX BROWN COUNTY   school 4811550 25908   BROOKESMITH ISD 481155013724 25908003 GENESIS CAMPUS   Alternative School No Other 04 11 2021   grade_6                                                   <10                                             10
1380688 TX HARRIS COUNTY   school 4800124 101837   CALVIN NELMS CHARTER SCHOOLS 480012409258 101837041 CALVIN NELMS MIDDLE   Alternative School Yes Middle 06 08 2021   grade_6                                                   40                                             40
1380881 TX RANDALL COUNTY   school 4812810 191901   CANYON ISD 481281005172 191901003 YOUTH CTR OF HIGH PLAINS   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1381956 TX GALVESTON COUNTY   school 4814280 84910   CLEAR CREEK ISD 481428009498 84910008 CLEAR PATH ALTERNATIVE SCHOOL   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1382617 TX COMAL COUNTY   school 4814730 46902   COMAL ISD 481473012361 46902206 COMAL DISCIPLINE CENTER   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1382885 TX HARRIS COUNTY   school 4800127 101842   COMQUEST ACADEMY 480012708255 101842001 COMQUEST ACADEMY   Alternative School Yes Other KG 12 2021   grade_6                                                   <10                                             10
1384048 TX CROSBY COUNTY   school 4800001 54901   CROSBYTON CISD 480000103621 54901200 SP ED CO-OP   Alternative School No Other PK 12 2021   grade_6                                                   <10                                             10
1385477 TX DALLAS COUNTY   school 4816230 57905   DALLAS ISD 481623006391 57905099 HOSPITAL/HOMEBOUND   Alternative School No Other KG 12 2021   grade_6                                                   <10                                             10
1387400 TX NUECES COUNTY   school 4800025 178801   DR M L GARZA-GONZALEZ CHARTER SCHO 480002507411 178801001 DR M L GARZA-GONZALEZ CHARTER SCHO   Alternative School Yes Elementary PK 08 2021   grade_6                                                   24                                             24
1387410 TX HARRIS COUNTY   school 4800263 101856   DRAW ACADEMY 480026310720 101856101 DRAW ACADEMY   Alternative School Yes Elementary PK 08 2021   grade_6                                                   62                                             62
1388069 TX ECTOR COUNTY   school 4818000 68901   ECTOR COUNTY ISD 481800001596 68901004 ALTER ED CTR   Alternative School No Secondary 06 11 2021   grade_6                                                   <10                                             10
1389587 TX HARRIS COUNTY   school 4800049 101811   EXCEL ACADEMY 480004908231 101811004 HARRIS COUNTY YOUTH VILLAGE   Alternative School Yes High 06 12 2021   grade_6                                                   <10                                             10
1389770 TX FAYETTE COUNTY   school 4819280 75901   FLATONIA ISD 481928012888 75901103 WHISPERING HILLS ACHIEVEMENT CENTE   Alternative School No Other 04 12 2021   grade_6                                                   <10                                             10
1389790 TX WILSON COUNTY   school 4819350 247901   FLORESVILLE ISD 481935007499 247901002 FLORESVILLE ALTER CTR   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1389855 TX FLOYD COUNTY   school 4819440 77901   FLOYDADA ISD 481944009239 77901004 FLOYDADA ISD DAEP   Alternative School No Middle 05 11 2021   grade_6                                                   <10                                             10
1390548 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970001832 220905104 BOULEVARD HEIGHTS   Alternative School No Other KG 12 2021   grade_6                                                   <10                                             10
1390616 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021056 220905210 CHILDREN'S MEDICAL CTR   Alternative School No Other KG 12 2021   grade_6                                                   <10                                             10
1390689 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005469 220905024 DETENT CTR   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1390810 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005395 220905062 INT'L NEWCOMER ACAD   Alternative School No Middle 06 09 2021   grade_6                                                   21                                             21
1390838 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970005717 220905026 JO KELLY SP ED   Alternative School No Other PK 12 2021   grade_6                                                   <10                                             10
1391286 TX TARRANT COUNTY   school 4819700 220905   FORT WORTH ISD 481970021057 220905211 WOMEN'S HAVEN   Alternative School No Other KG 09 2021   grade_6                                                   <10                                             10
1392107 TX GALVESTON COUNTY   school 4820280 84902   GALVESTON ISD 482028012288 84902007 AIM COLLEGE & CAREER PREP   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1392629 TX NACOGDOCHES COUNTY   school 4820400 174903   GARRISON ISD 482040011313 174903003 NACOGDOCHES COUNTY DAEP COOP   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1392698 TX BEXAR COUNTY   school 4800014 15802   GEORGE GERVIN ACADEMY 480001410415 15802004 RUTH JONES MCCLENDON MIDDLE   Alternative School Yes High 06 12 2021   grade_6                                                   37                                             37
1392705 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002007304 101804001 GEORGE I SANCHEZ CHARTER   Alternative School Yes Other PK 12 2021   grade_6                                                   56                                             56
1392712 TX HARRIS COUNTY   school 4800020 101804   GEORGE I SANCHEZ CHARTER 480002013387 101804004 GEORGE I SANCHEZ NORTH   Alternative School Yes Secondary 06 11 2021   grade_6                                                   51                                             51
1392835 TX WILLIAMSON COUNTY   school 4820600 246904   GEORGETOWN ISD 482060001018 246904199 WILLIAMSON CO JUVENILE DETENTION C   Alternative School No Secondary 06 11 2021   grade_6                                                   <10                                             10
1393200 TX HARRIS COUNTY   school 4821150 101911   GOOSE CREEK CISD 482115008605 101911006 POINT ALTERNATIVE CENTER   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1393508 TX DALLAS COUNTY   school 4821420 57910   GRAND PRAIRIE ISD 482142006970 57910004 LYNDON B JOHNSON DAEP   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1394171 TX HARRISON COUNTY   school 4822170 102904   HALLSVILLE ISD 482217012918 102904010 TEXAS VIRTUAL ACADEMY AT HALLSVILL   Alternative School No Other 03 12 2021   grade_6                                                   1024                                             1024
1394321 TX BEXAR COUNTY   school 4822470 15904   HARLANDALE ISD 482247009123 15904047 FENLEY TRANSITIONAL MIDDLE   Alternative School No Middle 06 07 2021   grade_6                                                   <10                                             10
1394562 TX CAMERON COUNTY   school 4822530 31903   HARLINGEN CISD 482253006940 31903118 SECONDARY ALTER CTR   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1395437 TX BEXAR COUNTY   school 4800080 15815   HERITAGE ACADEMY 480008013778 15815042 HERITAGE ACADEMY OF DEL RIO MIDDLE   Alternative School Yes Middle 04 08 2021   grade_6                                                   52                                             52
1395440 TX BEXAR COUNTY   school 4800080 15815   HERITAGE ACADEMY 480008011924 15815104 HERITAGE ACADEMY OF SAN ANTONIO   Alternative School Yes Middle 06 06 2021   grade_6                                                   13                                             13
1396386 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364012602 101912456 H S AHEAD ACADEMY   Alternative School No Middle 06 08 2021   grade_6                                                   50                                             50
1396398 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364011265 101912351 HARPER DAEP   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1396624 TX HARRIS COUNTY   school 4823640 101912   HOUSTON ISD 482364008608 101912340 LAS AMERICAS   Alternative School No Middle 04 08 2021   grade_6                                                   <30                                             30
1397689 TX HARRIS COUNTY   school 4823910 101913   HUMBLE ISD 482391012774 101913015 HUMBLE COMMUNITY LEARNING CENTER   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1398872 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005313328 15808012 JHW INSPIRE ACADEMY - LEGACY RANCH   Alternative School Yes Other KG 12 2021   grade_6                                                   <10                                             10
1398878 TX BEXAR COUNTY   school 4800053 15808   INSPIRE ACADEMIES 480005312039 15808007 JHW INSPIRE ACADEMY - ROCKDALE   Alternative School Yes High 06 12 2021   grade_6                                                   <10                                             10
1399462 TX DALLAS COUNTY   school 4800098 57819   JEAN MASSIEU ACADEMY 480009808169 57819001 JEAN MASSIEU ACADEMY   Alternative School Yes Other PK 12 2021   grade_6                                                   13                                             13
1400839 TX HAYS COUNTY   school 4801447 105803   KI CHARTER ACADEMY 480144713122 105803001 KI CHARTER ACADEMY   Alternative School Yes Other 01 12 2021   grade_6                                                   16                                             16
1400872 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566002861 14906022 ADVENTHEALTH SCHOOL   Alternative School No Other 02 12 2021   grade_6                                                   <10                                             10
1400954 TX BELL COUNTY   school 4825660 14906   KILLEEN ISD 482566000118 14906009 GATEWAY MIDDLE   Alternative School No Middle 06 08 2021   grade_6                                                   <10                                             10
1401596 TX HARRIS COUNTY   school 4825740 101915   KLEIN ISD 482574008632 101915038 K E KAUFMAN ALTERNATIVE EDUCATION   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1402467 TX FORT BEND COUNTY   school 4826580 79901   LAMAR CISD 482658006739 79901004 ALTERNATIVE LEARNING CENTER   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1402894 TX WEBB COUNTY   school 4826790 240901   LAREDO ISD 482679007475 240901007 F S LARA ACADEMY   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1403220 TX WILLIAMSON COUNTY   school 4827030 246913   LEANDER ISD 482703013720 246913014 LEANDER EXTENDED OPPORTUNITY   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1403704 TX DENTON COUNTY   school 4827300 61902   LEWISVILLE ISD 482730006744 61902005 LEARNING CTR   Alternative School No Other 01 12 2021   grade_6                                                   12                                             12
1404833 TX LUBBOCK COUNTY   school 4828500 152901   LUBBOCK ISD 482850003208 152901007 PRIORITY INTERVENTION ACADEMY   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1406333 TX KENDALL COUNTY   school 4801404 130801   MEADOWLAND CHARTER DISTRICT 480140412137 130801001 OAKS ACADEMY   Alternative School Yes Other 01 11 2021   grade_6                                                   <10                                             10
1406906 TX MIDLAND COUNTY   school 4800148 165802   MIDLAND ACADEMY CHARTER SCHOOL 480014808336 165802101 MIDLAND ACADEMY CHARTER SCHOOL   Alternative School Yes Elementary PK 08 2021   grade_6                                                   32                                             32
1407896 TX MILLS COUNTY   school 4831920 167902   MULLIN ISD 483192013338 167902056 PARKVIEW SCHOOL - LEVELLAND   Alternative School No Other 03 12 2021   grade_6                                                   <10                                             10
1408336 TX MONTGOMERY COUNTY   school 4832400 170908   NEW CANEY ISD 483240007079 170908002 THE LEARNING CTR   Alternative School No Other 02 12 2021   grade_6                                                   <10                                             10
1408395 TX BEXAR COUNTY   school 4800061 15805   NEW FRONTIERS PUBLIC SCHOOLS INC 480006111122 15805041 FRANK L MADLA ACCELERATED COLLEGIA   Alternative School Yes Elementary PK 08 2021   grade_6                                                   55                                             55
1408595 TX BEXAR COUNTY   school 4832940 15910   NORTH EAST ISD 483294006889 15910053 ALTER MIDDLE   Alternative School No Middle 06 08 2021   grade_6                                                   <10                                             10
1409446 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312003715 15915004 HOLMGREEN CENTER   Alternative School No Other PK 12 2021   grade_6                                                   <10                                             10
1409765 TX BEXAR COUNTY   school 4833120 15915   NORTHSIDE ISD 483312002944 15915013 REDDIX CENTER   Alternative School No Other PK 12 2021   grade_6                                                   <10                                             10
1410360 TX BELL COUNTY   school 4800235 14804   ORENDA CHARTER SCHOOL 480023511986 14804002 NEW HORIZONS   Alternative School Yes Other 01 11 2021   grade_6                                                   13                                             13
1410901 TX HARRIS COUNTY   school 4834320 101917   PASADENA ISD 483432010777 101917055 THE SUMMIT (INTERMEDIATE)   Alternative School No Middle 05 08 2021   grade_6                                                   <10                                             10
1411118 TX DALLAS COUNTY   school 4800029 57802   PEGASUS SCHOOL OF LIBERAL ARTS AND 480002907561 57802001 PEGASUS CHARTER H S   Alternative School Yes Other KG 12 2021   grade_6                                                   46                                             46
1412398 TX JEFFERSON COUNTY   school 4835430 123908   PORT NECHES-GROVES ISD 483543008310 123908003 JEFFERSON CO J J A E P   Alternative School No Middle 06 10 2021   grade_6                                                   <10                                             10
1412836 TX BELL COUNTY   school 4800076 14803   PRIORITY CHARTER SCHOOLS 480007608098 14803101 TEMPLE CHARTER ACADEMY   Alternative School Yes Other PK 12 2021   grade_6                                                   28                                             28
1413119 TX VAN ZANDT COUNTY   school 4800171 234801   RANCH ACADEMY 480017108398 234801001 RANCH ACADEMY   Alternative School Yes High 06 12 2021   grade_6                                                   <10                                             10
1414051 TX COKE COUNTY   school 4837380 41902   ROBERT LEE ISD 483738008476 41902180 WALL SP PROG   Alternative School No Middle 06 06 2021   grade_6                                                   <10                                             10
1414052 TX MCLENNAN COUNTY   school 4837410 161922   ROBINSON ISD 483741008985 161922004 CHALLENGE ACADEMY   Alternative School No Middle 06 07 2021   grade_6                                                   <10                                             10
1415069 TX TOM GREEN COUNTY   school 4838700 226903   SAN ANGELO ISD 483870005460 226903038 CARVER ALTER LRN CTR   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1415522 TX BEXAR COUNTY   school 4838730 15907   SAN ANTONIO ISD 483873021101 15907195 JUVENILE DETENT CTR   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1417393 TX EL PASO COUNTY   school 4840710 71909   SOCORRO ISD 484071016996 71909003 KEYS ACAD   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1417857 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006310419 15807005 NEW DIRECTIONS   Alternative School Yes High 06 12 2021   grade_6                                                   <10                                             10
1417889 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006309118 15807004 SOUTHWEST PREPARATORY SCHOOL-NORTH   Alternative School Yes Other 03 12 2021   grade_6                                                   19                                             19
1417903 TX BEXAR COUNTY   school 4800063 15807   SOUTHWEST PREPARATORY SCHOOL 480006308433 15807002 SOUTHWEST PREPARATORY SOUTHEAST CA   Alternative School Yes Other PK 12 2021   grade_6                                                   <10                                             10
1417910 TX HARRIS COUNTY   school 4800125 101838   SOUTHWEST SCHOOL 480012511234 101838041 DISCOVERY MIDDLE   Alternative School Yes Middle 06 08 2021   grade_6                                                   <80                                             80
1417923 TX HARRIS COUNTY   school 4800125 101838   SOUTHWEST SCHOOL 480012508252 101838004 PHOENIX SCHOOL AT SOUTHWEST SCHOOL   Alternative School Yes Other KG 12 2021   grade_6                                                   <10                                             10
1418718 TX STERLING COUNTY   school 4841550 216901   STERLING CITY ISD 484155009373 216901180 WALL SPECIAL PROGRAMS   Alternative School No Elementary 01 07 2021   grade_6                                                   <10                                             10
1419108 TX BELL COUNTY   school 4842330 14909   TEMPLE ISD 484233008430 14909005 WHEATLEY ALTERNATIVE EDUCATION CEN   Alternative School No Other KG 11 2021   grade_6                                                   <10                                             10
1419252 TX BOWIE COUNTY   school 4842480 19907   TEXARKANA ISD 484248013901 19907006 ESCHOOL PREP   Alternative School No High 05 12 2021   grade_6                                                   50                                             50
1419384 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016311503 221801011 AMARILLO COLLEGIATE ACADEMY   Alternative School Yes Other KG 12 2021   grade_6                                                   34                                             34
1419572 TX TAYLOR COUNTY   school 4800163 221801   TEXAS COLLEGE PREPARATORY ACADEMIE 480016309583 221801022 ISCHOOL VIRTUAL ACADEMY OF TEXAS   Alternative School Yes Other 03 12 2021   grade_6                                                   287                                             287
1419769 TX HAYS COUNTY   school 4800194 105802   TEXAS PREPARATORY SCHOOL 480019408645 105802041 TEXAS PREPARATORY SCHOOL   Alternative School Yes Elementary KG 06 2021   grade_6                                                   <10                                             10
1419790 TX MONTGOMERY COUNTY   school 4800151 170801   TEXAS SERENITY ACADEMY 480015111306 170801003 TEXAS SERENITY ACADEMY   Alternative School Yes Elementary KG 08 2021   grade_6                                                   57                                             57
1419851 TX HARRIS COUNTY   school 4801418 101864   THE LAWSON ACADEMY 480141812485 101864041 THE LAWSON ACADEMY   Alternative School Yes Middle 06 08 2021   grade_6                                                   56                                             56
1419857 TX HARRIS COUNTY   school 4801434 101868   THE PRO-VISION ACADEMY 480143412953 101868002 PRO-VISION MIDDLE   Alternative School Yes Middle 03 08 2021   grade_6                                                   40                                             40
1420273 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913198 46802011 AZLEWAY - WILLOW BEND   Alternative School Yes High 05 12 2021   grade_6                                                   <10                                             10
1420284 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025912947 46802007 PEGASUS SCHOOL   Alternative School Yes High 05 12 2021   grade_6                                                   <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]);