Data source: Big Local News · About: Big Local

117,510 rows where state = "TX" sorted by ccd_school_type

View and edit SQL

grade

year

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
1420285 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025912947 46802007 PEGASUS SCHOOL   Alternative School Yes High 05 12 2021   grade_7                                                   22                                             22
1420286 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025912947 46802007 PEGASUS SCHOOL   Alternative School Yes High 05 12 2021   grade_8                                                   37                                             37
1420287 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025912947 46802007 PEGASUS SCHOOL   Alternative School Yes High 05 12 2021   grade_9                                                   37                                             37
1420288 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025912947 46802007 PEGASUS SCHOOL   Alternative School Yes High 05 12 2021   grade_10                                                   25                                             25
1420289 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025912947 46802007 PEGASUS SCHOOL   Alternative School Yes High 05 12 2021   grade_11                                                   16                                             16
1420290 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025912947 46802007 PEGASUS SCHOOL   Alternative School Yes High 05 12 2021   grade_12                                                   <10                                             10
1420293 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910529 46802001 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_6                                                   <10                                             10
1420294 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910532 46802004 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_6                                                   <10                                             10
1420295 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910529 46802001 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_7                                                   <10                                             10
1420296 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910532 46802004 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_7                                                   <10                                             10
1420297 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910529 46802001 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_8                                                   10                                             10
1420298 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910532 46802004 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_8                                                   10                                             10
1420299 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910532 46802004 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_9                                                   18                                             18
1420300 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910529 46802001 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_9                                                   21                                             21
1420301 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910532 46802004 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_10                                                   20                                             20
1420302 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910529 46802001 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_10                                                   <10                                             10
1420303 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910532 46802004 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_11                                                   12                                             12
1420304 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910529 46802001 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_11                                                   <10                                             10
1420305 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025910532 46802004 TRINITY CHARTER SCHOOL   Alternative School Yes High 06 12 2021   grade_12                                                   <10                                             10
1420306 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913767 46802014 TRINITY CHARTER SCHOOL - BRENHAM C   Alternative School Yes High 08 12 2021   grade_8                                                   <10                                             10
1420307 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913767 46802014 TRINITY CHARTER SCHOOL - BRENHAM C   Alternative School Yes High 08 12 2021   grade_9                                                   13                                             13
1420308 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913767 46802014 TRINITY CHARTER SCHOOL - BRENHAM C   Alternative School Yes High 08 12 2021   grade_10                                                   10                                             10
1420309 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913767 46802014 TRINITY CHARTER SCHOOL - BRENHAM C   Alternative School Yes High 08 12 2021   grade_11                                                   <10                                             10
1420310 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913767 46802014 TRINITY CHARTER SCHOOL - BRENHAM C   Alternative School Yes High 08 12 2021   grade_12                                                   <10                                             10
1420311 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913746 46802015 TRINITY CHARTER SCHOOL - SPRING CA   Alternative School Yes Secondary 08 11 2021   grade_8                                                   <10                                             10
1420312 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913746 46802015 TRINITY CHARTER SCHOOL - SPRING CA   Alternative School Yes Secondary 08 11 2021   grade_9                                                   <10                                             10
1420313 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913746 46802015 TRINITY CHARTER SCHOOL - SPRING CA   Alternative School Yes Secondary 08 11 2021   grade_10                                                   <10                                             10
1420314 TX COMAL COUNTY   school 4800259 46802   TRINITY CHARTER SCHOOL 480025913746 46802015 TRINITY CHARTER SCHOOL - SPRING CA   Alternative School Yes Secondary 08 11 2021   grade_11                                                   <10                                             10
1420335 TX EL PASO COUNTY   school 4800106 71803   TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS 480010611212 71803002 TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS   Alternative School Yes High 09 12 2021   grade_9                                                   <20                                             20
1420336 TX EL PASO COUNTY   school 4800106 71803   TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS 480010608207 71803001 TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS   Alternative School Yes High 09 12 2021   grade_9                                                   <10                                             10
1420337 TX EL PASO COUNTY   school 4800106 71803   TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS 480010611212 71803002 TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS   Alternative School Yes High 09 12 2021   grade_10                                                   <30                                             30
1420338 TX EL PASO COUNTY   school 4800106 71803   TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS 480010608207 71803001 TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS   Alternative School Yes High 09 12 2021   grade_10                                                   <10                                             10
1420339 TX EL PASO COUNTY   school 4800106 71803   TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS 480010608207 71803001 TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS   Alternative School Yes High 09 12 2021   grade_11                                                   16                                             16
1420340 TX EL PASO COUNTY   school 4800106 71803   TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS 480010611212 71803002 TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS   Alternative School Yes High 09 12 2021   grade_11                                                   52                                             52
1420341 TX EL PASO COUNTY   school 4800106 71803   TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS 480010608207 71803001 TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS   Alternative School Yes High 09 12 2021   grade_12                                                   20                                             20
1420342 TX EL PASO COUNTY   school 4800106 71803   TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS 480010611212 71803002 TRIUMPH PUBLIC HIGH SCHOOLS-EL PAS   Alternative School Yes High 09 12 2021   grade_12                                                   32                                             32
1420343 TX WEBB COUNTY   school 4800174 240801   TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO 480017412212 240801002 TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO   Alternative School Yes High 09 12 2021   grade_9                                                   11                                             11
1420344 TX WEBB COUNTY   school 4800174 240801   TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO 480017408403 240801001 TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO   Alternative School Yes High 09 12 2021   grade_9                                                   20                                             20
1420345 TX WEBB COUNTY   school 4800174 240801   TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO 480017412212 240801002 TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO   Alternative School Yes High 09 12 2021   grade_10                                                   13                                             13
1420346 TX WEBB COUNTY   school 4800174 240801   TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO 480017408403 240801001 TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO   Alternative School Yes High 09 12 2021   grade_10                                                   22                                             22
1420347 TX WEBB COUNTY   school 4800174 240801   TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO 480017408403 240801001 TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO   Alternative School Yes High 09 12 2021   grade_11                                                   15                                             15
1420348 TX WEBB COUNTY   school 4800174 240801   TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO 480017412212 240801002 TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO   Alternative School Yes High 09 12 2021   grade_11                                                   30                                             30
1420349 TX WEBB COUNTY   school 4800174 240801   TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO 480017412212 240801002 TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO   Alternative School Yes High 09 12 2021   grade_12                                                   58                                             58
1420350 TX WEBB COUNTY   school 4800174 240801   TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO 480017408403 240801001 TRIUMPH PUBLIC HIGH SCHOOLS-LAREDO   Alternative School Yes High 09 12 2021   grade_12                                                   73                                             73
1420351 TX LUBBOCK COUNTY   school 4800142 152803   TRIUMPH PUBLIC HIGH SCHOOLS-LUBBOC 480014208326 152803001 TRIUMPH PUBLIC HIGH SCHOOLS-LUBBOC   Alternative School Yes High 09 12 2021   grade_9                                                   25                                             25
1420352 TX LUBBOCK COUNTY   school 4800142 152803   TRIUMPH PUBLIC HIGH SCHOOLS-LUBBOC 480014208326 152803001 TRIUMPH PUBLIC HIGH SCHOOLS-LUBBOC   Alternative School Yes High 09 12 2021   grade_10                                                   54                                             54
1420353 TX LUBBOCK COUNTY   school 4800142 152803   TRIUMPH PUBLIC HIGH SCHOOLS-LUBBOC 480014208326 152803001 TRIUMPH PUBLIC HIGH SCHOOLS-LUBBOC   Alternative School Yes High 09 12 2021   grade_11                                                   73                                             73
1420354 TX LUBBOCK COUNTY   school 4800142 152803   TRIUMPH PUBLIC HIGH SCHOOLS-LUBBOC 480014208326 152803001 TRIUMPH PUBLIC HIGH SCHOOLS-LUBBOC   Alternative School Yes High 09 12 2021   grade_12                                                   41                                             41
1420355 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013313801 108804004 TRIUMPH PUBLIC HIGH SCHOOLS-BROWNS   Alternative School Yes High 09 12 2021   grade_9                                                   <10                                             10
1420356 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013313801 108804004 TRIUMPH PUBLIC HIGH SCHOOLS-BROWNS   Alternative School Yes High 09 12 2021   grade_10                                                   <30                                             30
1420357 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013313801 108804004 TRIUMPH PUBLIC HIGH SCHOOLS-BROWNS   Alternative School Yes High 09 12 2021   grade_11                                                   32                                             32
1420358 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013313801 108804004 TRIUMPH PUBLIC HIGH SCHOOLS-BROWNS   Alternative School Yes High 09 12 2021   grade_12                                                   42                                             42
1420359 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013309294 108804002 TRIUMPH PUBLIC HIGH SCHOOLS-MCALLE   Alternative School Yes High 09 12 2021   grade_9                                                   <10                                             10
1420360 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013309294 108804002 TRIUMPH PUBLIC HIGH SCHOOLS-MCALLE   Alternative School Yes High 09 12 2021   grade_10                                                   <10                                             10
1420361 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013309294 108804002 TRIUMPH PUBLIC HIGH SCHOOLS-MCALLE   Alternative School Yes High 09 12 2021   grade_11                                                   33                                             33
1420362 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013309294 108804002 TRIUMPH PUBLIC HIGH SCHOOLS-MCALLE   Alternative School Yes High 09 12 2021   grade_12                                                   62                                             62
1420363 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013308280 108804001 TRIUMPH PUBLIC HIGH SCHOOLS-MERCED   Alternative School Yes High 09 12 2021   grade_9                                                   11                                             11
1420364 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013308280 108804001 TRIUMPH PUBLIC HIGH SCHOOLS-MERCED   Alternative School Yes High 09 12 2021   grade_10                                                   36                                             36
1420365 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013308280 108804001 TRIUMPH PUBLIC HIGH SCHOOLS-MERCED   Alternative School Yes High 09 12 2021   grade_11                                                   44                                             44
1420366 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013308280 108804001 TRIUMPH PUBLIC HIGH SCHOOLS-MERCED   Alternative School Yes High 09 12 2021   grade_12                                                   45                                             45
1420367 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013311872 108804003 TRIUMPH PUBLIC HIGH SCHOOLS-SAN BE   Alternative School Yes High 09 12 2021   grade_9                                                   10                                             10
1420368 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013311872 108804003 TRIUMPH PUBLIC HIGH SCHOOLS-SAN BE   Alternative School Yes High 09 12 2021   grade_10                                                   25                                             25
1420369 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013311872 108804003 TRIUMPH PUBLIC HIGH SCHOOLS-SAN BE   Alternative School Yes High 09 12 2021   grade_11                                                   43                                             43
1420370 TX HIDALGO COUNTY   school 4800133 108804   TRIUMPH PUBLIC HIGH SCHOOLS-RIO GR 480013311872 108804003 TRIUMPH PUBLIC HIGH SCHOOLS-SAN BE   Alternative School Yes High 09 12 2021   grade_12                                                   71                                             71
1420427 TX NUECES COUNTY   school 4843350 178912   TULOSO-MIDWAY ISD 484335005136 178912002 TULOSO-MIDWAY ACADEMIC CAREER CENT   Alternative School No High 10 12 2021   grade_10                                                   <10                                             10
1420428 TX NUECES COUNTY   school 4843350 178912   TULOSO-MIDWAY ISD 484335005136 178912002 TULOSO-MIDWAY ACADEMIC CAREER CENT   Alternative School No High 10 12 2021   grade_11                                                   <10                                             10
1420429 TX NUECES COUNTY   school 4843350 178912   TULOSO-MIDWAY ISD 484335005136 178912002 TULOSO-MIDWAY ACADEMIC CAREER CENT   Alternative School No High 10 12 2021   grade_12                                                   20                                             20
1420475 TX SMITH COUNTY   school 4843470 212905   TYLER ISD 484347013616 212905010 ALVIN V ANDERSON RISE ACADEMY   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1420476 TX SMITH COUNTY   school 4843470 212905   TYLER ISD 484347013616 212905010 ALVIN V ANDERSON RISE ACADEMY   Alternative School No High 09 12 2021   grade_10                                                   <20                                             20
1420477 TX SMITH COUNTY   school 4843470 212905   TYLER ISD 484347013616 212905010 ALVIN V ANDERSON RISE ACADEMY   Alternative School No High 09 12 2021   grade_11                                                   23                                             23
1420478 TX SMITH COUNTY   school 4843470 212905   TYLER ISD 484347013616 212905010 ALVIN V ANDERSON RISE ACADEMY   Alternative School No High 09 12 2021   grade_12                                                   55                                             55
1420707 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013464 240903032 CASA ESPERANZA RECOVERY HOME   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1420708 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013464 240903032 CASA ESPERANZA RECOVERY HOME   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1420709 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013464 240903032 CASA ESPERANZA RECOVERY HOME   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1420817 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365007476 240903006 JUVENILLE JUSTICE ALTERNATIVE PROG   Alternative School No High 09 12 2021   grade_9                                                   <10                                             10
1420818 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365007476 240903006 JUVENILLE JUSTICE ALTERNATIVE PROG   Alternative School No High 09 12 2021   grade_10                                                   <10                                             10
1420819 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365007476 240903006 JUVENILLE JUSTICE ALTERNATIVE PROG   Alternative School No High 09 12 2021   grade_11                                                   <10                                             10
1420820 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365007476 240903006 JUVENILLE JUSTICE ALTERNATIVE PROG   Alternative School No High 09 12 2021   grade_12                                                   <10                                             10
1420964 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013466 240903031 YOUTH RECOVERY HOME   Alternative School No High 08 12 2021   grade_8                                                   <10                                             10
1420965 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013466 240903031 YOUTH RECOVERY HOME   Alternative School No High 08 12 2021   grade_9                                                   <10                                             10
1420966 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013466 240903031 YOUTH RECOVERY HOME   Alternative School No High 08 12 2021   grade_10                                                   <10                                             10
1420967 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013466 240903031 YOUTH RECOVERY HOME   Alternative School No High 08 12 2021   grade_12                                                   <10                                             10
1420968 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013463 240903030 YOUTH VILLAGE DETENTION CENTER   Alternative School No High 06 12 2021   grade_6                                                   <10                                             10
1420969 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013463 240903030 YOUTH VILLAGE DETENTION CENTER   Alternative School No High 06 12 2021   grade_7                                                   <10                                             10
1420970 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013463 240903030 YOUTH VILLAGE DETENTION CENTER   Alternative School No High 06 12 2021   grade_9                                                   <10                                             10
1420971 TX WEBB COUNTY   school 4843650 240903   UNITED ISD 484365013463 240903030 YOUTH VILLAGE DETENTION CENTER   Alternative School No High 06 12 2021   grade_10                                                   <10                                             10
1421016 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007109074 227806017 ANNUNCIATION MATERNITY HOME   Alternative School Yes High 07 12 2021   grade_7                                                   <10                                             10
1421017 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007109074 227806017 ANNUNCIATION MATERNITY HOME   Alternative School Yes High 07 12 2021   grade_9                                                   <10                                             10
1421018 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007109074 227806017 ANNUNCIATION MATERNITY HOME   Alternative School Yes High 07 12 2021   grade_10                                                   <10                                             10
1421019 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007109074 227806017 ANNUNCIATION MATERNITY HOME   Alternative School Yes High 07 12 2021   grade_12                                                   <10                                             10
1421020 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113287 227806040 AUSTIN OAKS   Alternative School Yes Other 03 11 2021   grade_3                                                   <10                                             10
1421021 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113287 227806040 AUSTIN OAKS   Alternative School Yes Other 03 11 2021   grade_4                                                   <10                                             10
1421022 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113287 227806040 AUSTIN OAKS   Alternative School Yes Other 03 11 2021   grade_6                                                   <10                                             10
1421023 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113287 227806040 AUSTIN OAKS   Alternative School Yes Other 03 11 2021   grade_7                                                   <10                                             10
1421024 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113287 227806040 AUSTIN OAKS   Alternative School Yes Other 03 11 2021   grade_8                                                   <10                                             10
1421025 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113287 227806040 AUSTIN OAKS   Alternative School Yes Other 03 11 2021   grade_9                                                   <10                                             10
1421026 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113287 227806040 AUSTIN OAKS   Alternative School Yes Other 03 11 2021   grade_10                                                   <10                                             10
1421027 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113287 227806040 AUSTIN OAKS   Alternative School Yes Other 03 11 2021   grade_11                                                   <10                                             10
1421028 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113489 227806045 CEDAR CREST   Alternative School Yes High 06 12 2021   grade_6                                                   <10                                             10
1421029 TX TRAVIS COUNTY   school 4800071 227806   UNIVERSITY OF TEXAS UNIVERSITY CHA 480007113489 227806045 CEDAR CREST   Alternative School Yes High 06 12 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]);