Joe downloaded two 2005-2006 datafiles from http://www.alsde.edu/Accountability/preAccountability.asp. These are part1 and part2. With headers: "SystemName","SystemCode","SchoolName","SchoolCode","Aggregate","Grade","Subject","Level1","Level2","Level3","Level4","SchoolYear"

The SchoolCode fields does not match the NCESSCH field used by AIR.

Use the query:
LEANM,LEAID,SCHNAM,NCESSCH@1
to get a list of NCESSCH IDs for schools in the database and match by district and school names.

Matched 131 / 132 districts Did not match: 'Trussville City'

Matched 1074 / 1096 schools Did not match (school, district):

[('Evergreen Elementary School', 'Conecuh County'), ('Mount Carmel Elementary School', 'Madison County'), ('Dr. Robert W. Gilliard Elementary', 'Mobile County'), ('Pearl Haskew Elementary', 'Mobile County'), ('Robert E Lee Intermediate Elementary School', 'Mobile County'), ('ET Belsaw - Mount Vernon School', 'Mobile County'), ('Chickasaw School Of Mathematics And Science', 'Mobile County'), ('George Washington Carver Elementary School', 'Macon County'), ('Ira F Simmons Middle School', 'Hoover City'), ('De Armanville Elementary School', 'Oxford City'), ('Councill Middle School', 'Tallapoosa County'), ('Spanish Fort High School', 'Baldwin County'), ('Vaughn School', 'Baldwin County'), ('Daphne Elementary North', 'Baldwin County'), ('Corley Elementary School', 'Boaz City'), ('Hueytown Middle School', 'Jefferson County'), ('West Morgan Middle School', 'Morgan County'), ('College Street Elementary School', 'Enterprise City'), ('Phil Campbell Elementary School', 'Franklin County'), ('Crossville Elementary School', 'Dekalb County'), ('Opportunity Center at Riggins', 'Birmingham City'), ('Providence School', 'Huntsville City')]

The 2002-2005 AIR data had 1415 schools. Of these the 2006 data from the state web site matched 1074 schools and did not have the following 341 (school, district):

[('SEQUOYAH SCHOOL - CHALKVILLE CAMPUS', 'ALABAMA YOUTH SERVICES'), ('EUFAULA SCH - EUFAULA CAMPUS', 'ALA YOUTH SER'), ('WALLACE SCH - MT MEIGS CAMPUS', 'ALA YOUTH SER'), ('MCNEEL SCH - VACCA CAMPUS', 'ALA YOUTH SER'), ('ALBERTVILLE HIGH SCHOOL', 'ALBERTVILLE CITY'), ('MCCORD AVENUE ELEMENTARY SCHOOL', 'ALBERTVILLE CITY'), ('BOAZ MIDDLE SCHOOL', 'MARSHALL COUNTY'), ('BOAZ HIGH SCHOOL', 'MARSHALL COUNTY'), ('DOUGLAS HIGH SCHOOL', 'MARSHALL COUNTY'), ('KATE D SMITH DAR HIGH SCHOOL', 'MARSHALL COUNTY'), ('CORLEY ELEMENTARY SCHOOL', 'MARSHALL COUNTY'), ('MARSHALL TECHNICAL SCHOOL', 'MARSHALL COUNTY'), ('BOAZ INTERMEDIATE SCHOOL', 'MARSHALL COUNTY'), ('HOOVER HIGH SCHOOL', 'HOOVER CITY'), ('IRA F SIMMONS JR HIGH', 'HOOVER CITY'), ('BOB JONES HIGH SCHOOL', 'MADISON CITY'), ('ALABAMA SCHOOL FOR DEAF', 'AL INST DEAF AND BLIND'), ('ALABAMA SCHOOL FOR BLIND', 'AL INST DEAF AND BLIND'), ('BENJAMIN RUSSELL HIGH SCHOOL', 'ALEXANDER CITY'), ('ANDALUSIA HIGH SCHOOL', 'ANDALUSIA CITY'), ('ANNISTON HIGH SCHOOL', 'ANNISTON CITY'), ('NORWOOD ELEMENTARY SCHOOL', 'ANNISTON CITY'), ('GOALS SCHOOL', 'ANNISTON CITY'), ('ARAB HIGH SCHOOL', 'ARAB CITY'), ('ATHENS HIGH SCHOOL', 'ATHENS CITY'), ('ETOWAH HIGH SCHOOL', 'ATTALLA CITY'), ('UNIQUE SITUATIONS', 'ATTALLA CITY SCH DIST'), ('AUBURN HIGH SCHOOL', 'AUBURN CITY'), ('PRATTVILLE HIGH SCHOOL', 'AUTAUGA COUNTY'), ('BALDWIN COUNTY REGIONAL DETENTION CENTER', 'BALDWIN COUNTY'), ('ROBERTSDALE HIGH SCHOOL', 'BALDWIN COUNTY'), ('FAIRHOPE HIGH SCHOOL', 'BALDWIN COUNTY'), ('GULF SHORES HIGH SCHOOL', 'BALDWIN COUNTY'), ('DAPHNE HIGH SCHOOL', 'BALDWIN COUNTY'), ('FOLEY HIGH SCHOOL', 'BALDWIN COUNTY'), ('BALDWIN COUNTY HIGH SCHOOL', 'BALDWIN COUNTY'), ('BAKER HILL SCHOOL', 'BARBOUR COUNTY'), ('BARBOUR COUNTY HIGH SCHOOL', 'BARBOUR COUNTY'), ('CLIO SCHOOL', 'BARBOUR COUNTY'), ('LOUISVILLE HIGH SCHOOL', 'BARBOUR COUNTY'), ('REBECCA COMER SCHOOL', 'BARBOUR COUNTY'), ('CLAYTON ELEMENTARY SCHOOL', 'BARBOUR COUNTY'), ('JESS LANIER HIGH SCHOOL', 'BESSEMER CITY'), ('BIBB COUNTY HIGH SCHOOL', 'BIBB COUNTY'), ('WEST BLOCTON HIGH SCHOOL', 'BIBB COUNTY'), ('BAKER ELEMENTARY SCHOOL', 'BIRMINGHAM CITY'), ('DUPUY ALTERNATIVE SCHOOL', 'BIRMINGHAM CITY'), ('ELYTON ELEMENTARY SCHOOL', 'BIRMINGHAM CITY'), ('ENSLEY HIGH SCHOOL-MAGNET', 'BIRMINGHAM CITY'), ('HAYES MIDDLE SCHOOL', 'BIRMINGHAM CITY'), ('WOODLAWN HIGH ALTERNATIVE CENTER', 'BIRMINGHAM CITY'), ('HUFFMAN HIGH SCHOOL-MAGNET', 'BIRMINGHAM CITY'), ('LINCOLN MIDDLE SCHOOL', 'BIRMINGHAM CITY'), ('JACKSON-OLIN HIGH SCHOOL', 'BIRMINGHAM CITY'), ('PARKER HIGH SCHOOL', 'BIRMINGHAM CITY'), ('POWELL ELEMENTARY SCHOOL', 'BIRMINGHAM CITY'), ('RAMSAY HIGH SCHOOL', 'BIRMINGHAM CITY'), ('RIGGINS ELEMENTARY SCHOOL', 'BIRMINGHAM CITY'), ('RILEY ELEMENTARY SCHOOL', 'BIRMINGHAM CITY'), ('SCOTT EXTENDED DAY PROGRAM', 'BIRMINGHAM CITY'), ('SPAULDING ELEMENTARY SCHOOL', 'BIRMINGHAM CITY'), ('TUXEDO ELEMENTARY SCHOOL', 'BIRMINGHAM CITY'), ('WENONAH HIGH SCHOOL', 'BIRMINGHAM CITY'), ('WEST END HIGH SCHOOL', 'BIRMINGHAM CITY'), ('WOODLAWN HIGH SCHOOL-MAGNET', 'BIRMINGHAM CITY'), ('ALABAMA SCHOOL OF FINE ARTS JUNIOR HIGH SCHOOL', 'BIRMINGHAM CITY'), ('GEORGE WASHINGTON CARVER HIGH SCHOOL', 'BIRMINGHAM CITY'), ('ALABAMA SCHOOL OF FINE ARTS HIGH SCHOOL', 'BIRMINGHAM CITY'), ('HOMEBOUND ELEMENTARY SCHOOL', 'BIRMINGHAM CITY'), ('BLOUNT COUNTY MULTI-NEEDS CENTER', 'BLOUNT COUNTY'), ('TR MILLER HIGH SCHOOL', 'BREWTON CITY'), ('GREENVILLE HIGH SCHOOL', 'BUTLER COUNTY'), ('WO PARMER ELEMENTARY SCHOOL', 'BUTLER COUNTY'), ('COLDWATER ELEMENTARY SCHOOL', 'CALHOUN COUNTY'), ('DE ARMANVILLE JR HIGH SCH', 'CALHOUN CO'), ('LAFAYETTE HIGH SCHOOL', 'CHAMBERS COUNTY'), ('VALLEY HIGH SCHOOL', 'CHAMBERS COUNTY'), ('CHEROKEE COUNTY HIGH SCHOOL', 'CHEROKEE COUNTY'), ('JEMISON HIGH SCHOOL', 'CHILTON COUNTY'), ('CLANTON ELEMENTARY SCHOOL', 'CHILTON COUNTY'), ('CHILTON COUNTY HIGH SCHOOL', 'CHILTON COUNTY'), ('BUTLER ELEMENTARY SCHOOL', 'CHOCTAW COUNTY'), ('EAST CHOCTAW JUNIOR HIGH SCHOOL', 'CHOCTAW COUNTY'), ('LISMAN JUNIOR HIGH SCHOOL', 'CHOCTAW COUNTY'), ('CLARKE COUNTY HIGH SCHOOL', 'CLARKE COUNTY'), ('JOE M GILLMORE ELEMENTARY SCHOOL', 'CLARKE COUNTY'), ('JACKSON HIGH SCHOOL', 'CLARKE COUNTY'), ('BIBB GRAVES HIGH SCHOOL', 'CLAY COUNTY'), ('MELLOW VALLEY HIGH SCHOOL', 'CLAY COUNTY'), ('CLEBURNE COUNTY ALTERNATIVE SCHOOL', 'CLEBURNE COUNTY'), ('CHEROKEE HIGH SCHOOL', 'COLBERT COUNTY'), ('EVERGREEN JUNIOR HIGH SCHOOL', 'CONECUH COUNTY'), ('ROCKFORD ELEMENTARY SCHOOL', 'COOSA COUNTY'), ('GOODWATER ELEMENTARY SCHOOL', 'COOSA COUNTY'), ('KELLYTON ELEMENTARY SCHOOL', 'COOSA COUNTY'), ('WEST COOSA ELEMENTARY SCHOOL', 'COOSA COUNTY'), ('CENTRAL HIGH SCHOOL', 'COOSA COUNTY'), ('FLORALA HIGH SCHOOL', 'COVINGTON COUNTY'), ('CULLMAN HIGH SCHOOL', 'CULLMAN CITY'), ('FAIRVIEW HIGH SCHOOL', 'CULLMAN COUNTY'), ('GOOD HOPE HIGH SCHOOL', 'CULLMAN COUNTY'), ('HANCEVILLE HIGH SCHOOL', 'CULLMAN COUNTY'), ('LOGAN ELEMENTARY SCHOOL', 'CULLMAN COUNTY'), ('VINEMONT HIGH SCHOOL', 'CULLMAN COUNTY'), ('WEST POINT HIGH SCHOOL', 'CULLMAN COUNTY'), ('CULLMAN CHILD DEVELOPMENT CENTER', 'CULLMAN COUNTY'), ('DALE COUNTY HIGH SCHOOL', 'DALE COUNTY'), ('DALEVILLE HIGH SCHOOL', 'DALEVILLE CITY'), ('NOVA LEARNING CENTER', 'DALEVILLE CITY'), ('DALLAS COUNTY HIGH SCHOOL', 'DALLAS COUNTY'), ('SOUTHSIDE HIGH SCHOOL', 'DALLAS COUNTY'), ('ADAMSBURG SCHOOL', 'DEKALB COUNTY'), ('AUSTIN HIGH SCHOOL', 'DECATUR CITY'), ('DECATUR HIGH SCHOOL', 'DECATUR CITY'), ('DEMOPOLIS HIGH SCHOOL', 'DEMOPOLIS CITY'), ('DOTHAN HIGH SCHOOL', 'DOTHAN CITY'), ('SOUTHSIDE ELEMENTARY SCHOOL', 'DOTHAN CITY'), ('WILSON STREET ELEMENTARY SCHOOL', 'DOTHAN CITY'), ('P.A.S.S. ACAD', 'DOTHAN CITY'), ('HIGHLANDS ELEM SCH', 'DOTHAN CITY'), ('NORTHVIEW HIGH SCHOOL', 'DOTHAN CITY'), ('ELMORE COUNTY HIGH SCHOOL', 'ELMORE COUNTY'), ('HOLTVILLE HIGH SCHOOL', 'ELMORE COUNTY'), ('STANHOPE ELMORE HIGH SCHOOL', 'ELMORE COUNTY'), ('WETUMPKA HIGH SCHOOL', 'ELMORE COUNTY'), ('COL STREET ELEM SCH', 'ENTERPRISE CITY'), ('ENTERPRISE HIGH SCHOOL', 'ENTERPRISE CITY'), ('ESCAMBIA COUNTY HIGH SCHOOL', 'ESCAMBIA COUNTY'), ('FLOMATON HIGH SCHOOL', 'ESCAMBIA COUNTY'), ('W S NEAL HIGH SCHOOL', 'ESCAMBIA COUNTY'), ('GLENCOE HIGH SCHOOL', 'ETOWAH COUNTY'), ('SOUTHSIDE HIGH SCHOOL', 'ETOWAH COUNTY'), ('HOKES BLUFF HIGH SCHOOL', 'ETOWAH COUNTY'), ('EUFAULA HIGH SCHOOL', 'EUFAULA CITY'), ('FAIRFIELD HIGH PREPARATORY SCHOOL', 'FAIRFIELD CITY'), ('FAIRFIELD ALTERNATIVE SCHOOL', 'FAIRFIELD CITY'), ('FAYETTE COUNTY HIGH SCHOOL', 'FAYETTE COUNTY'), ('BRADSHAW HIGH SCHOOL', 'FLORENCE CITY'), ('BRANDON ELEMENTARY SCHOOL', 'FLORENCE CITY'), ('COFFEE HIGH SCHOOL', 'FLORENCE CITY'), ('FORT PAYNE HIGH SCHOOL', 'FORT PAYNE CITY'), ('WILLS VALLEY ELEMENTARY SCHOOL', 'FORT PAYNE CITY'), ('EMMA SANSOM HIGH SCHOOL', 'GADSDEN CITY'), ('GADSDEN HIGH SCHOOL', 'GADSDEN CITY'), ('JESSIE DEAN SMITH ELEMENTARY SCHOOL', 'GADSDEN CITY'), ('LITCHFIELD HIGH SCHOOL', 'GADSDEN CITY'), ('GENEVA HIGH SCHOOL', 'GENEVA CITY'), ('GENEVA COUNTY HIGH SCHOOL', 'GENEVA COUNTY'), ('SAMSON HIGH SCHOOL', 'GENEVA COUNTY'), ('SLOCOMB HIGH SCHOOL', 'GENEVA COUNTY'), ('GREENE COUNTY HIGH SCHOOL', 'GREENE COUNTY'), ('GUNTERSVILLE HIGH SCHOOL', 'GUNTERSVILLE CITY'), ('HARTSELLE HIGH SCHOOL', 'HARTSELLE CITY'), ('ABBEVILLE HIGH SCHOOL', 'HENRY COUNTY'), ('HEADLAND HIGH SCHOOL', 'HENRY COUNTY'), ('HOMEWOOD HIGH SCHOOL', 'HOMEWOOD CITY'), ('REHOBETH HIGH SCHOOL', 'HOUSTON COUNTY'), ('SR BUTLER HIGH SCHOOL', 'HUNTSVILLE CITY'), ('VIRGIL GRISSOM HIGH SCHOOL', 'HUNTSVILLE CITY'), ('HUNTSVILLE HIGH SCHOOL', 'HUNTSVILLE CITY'), ('JO JOHNSON HIGH SCHOOL', 'HUNTSVILLE CITY'), ('LEE HIGH SCHOOL', 'HUNTSVILLE CITY'), ('COMMUNITY INTENSIVE TREATMENT YOUTH', 'HUNTSVILLE CITY'), ('NEW CENTURY TECHNOLOGY DEMO HIGH SCHOOL', 'HUNTSVILLE CITY'), ('ROBERT NEAVES CENTER', 'HUNTSVILLE CITY'), ('CENTER FOR DEVELOPMENT LEARNING', 'HUNTSVILLE CITY'), ('NORTH JACKSON HIGH SCHOOL', 'JACKSON COUNTY'), ('WALKER HIGH SCHOOL', 'JASPER CITY'), ('CLAY-CHALKVILLE HIGH SCHOOL', 'JEFFERSON COUNTY'), ('CAHABA HEIGHTS COMMUNITY SCHOOL', 'JEFFERSON COUNTY'), ('CENTER POINT ELEMENTARY SCHOOL', 'JEFFERSON COUNTY'), ('GARDENDALE HIGH SCHOOL', 'JEFFERSON COUNTY'), ('HEWITT ELEMENTARY SCHOOL', 'JEFFERSON COUNTY'), ('HEWITT-TRUSSVILLE JUNIOR HIGH SCHOOL', 'JEFFERSON COUNTY'), ('HEWITT-TRUSSVILLE MIDDLE SCH', 'JEFFERSON CO'), ('HUEYTOWN HIGH SCHOOL', 'JEFFERSON COUNTY'), ('LEEDS ELEMENTARY SCHOOL', 'JEFFERSON COUNTY'), ('LEEDS HIGH SCHOOL', 'JEFFERSON COUNTY'), ('LEEDS MIDDLE SCHOOL', 'JEFFERSON COUNTY'), ('MORTIMER JORDAN HIGH SCHOOL', 'JEFFERSON COUNTY'), ('PINSON ELEMENTARY SCHOOL', 'JEFFERSON COUNTY'), ('PINSON VALLEY HIGH SCHOOL', 'JEFFERSON COUNTY'), ('PITTMAN MIDDLE SCH', 'JEFFERSON CO'), ('SHADES VALLEY HIGH SCHOOL', 'JEFFERSON COUNTY'), ('PAINE INTERMEDIATE SCH', 'JEFFERSON CO'), ('GRANTSWOOD COMMUNITY ELEMENTARY SCHOOL', 'JEFFERSON COUNTY'), ('HEWITT-TRUSSVILLE HIGH SCHOOL', 'JEFFERSON COUNTY'), ('MINOR HIGH SCHOOL', 'JEFFERSON COUNTY'), ('LANETT SENIOR HIGH SCHOOL', 'LANETT CITY'), ('COURTLAND HIGH SCHOOL', 'LAWRENCE COUNTY'), ('EAST LAWRENCE HIGH SCHOOL', 'LAWRENCE COUNTY'), ('BEAUREGARD HIGH SCHOOL', 'LEE COUNTY'), ('SMITHS STATION HIGH SCHOOL', 'LEE COUNTY'), ('LINDEN HIGH SCHOOL', 'LINDEN CITY'), ('CALHOUN HIGH SCHOOL', 'LOWNDES COUNTY'), ('CENTRAL HIGH SCHOOL', 'LOWNDES COUNTY'), ('RUSSELL ELEMENTARY SCHOOL', 'LOWNDES COUNTY'), ('SOUTH MACON SCH', 'MACON CO'), ('WASHINGTON PUBLIC SCH', 'MACON CO'), ('BOOKER T WASHINGTON HIGH', 'MACON COUNTY'), ('MADISON COUNTY HIGH SCHOOL', 'MADISON COUNTY'), ('HAZEL GREEN HIGH SCHOOL', 'MADISON COUNTY'), ('NEW HOPE HIGH SCHOOL', 'MADISON COUNTY'), ('SPARKMAN HIGH SCHOOL', 'MADISON COUNTY'), ('MT CARMEL ELEM SCH', 'MADISON CO'), ('BUCKHORN HIGH SCHOOL', 'MADISON COUNTY'), ('RIVERTON ELEM SCH', 'MADISON CO'), ('HAMILTON HIGH SCHOOL', 'MARION COUNTY'), ('MARION COUNTY ALTERNATIVE SCHOOL', 'MARION COUNTY'), ('PHILLIPS ELEM SCH', 'MARION CO'), ('MIDFIELD HIGH SCHOOL', 'MIDFIELD CITY'), ('ADELIA WILLIAMS ELEM SCH', 'MOBILE CO'), ('BEN C RAIN HIGH SCHOOL', 'MOBILE COUNTY'), ('BAKER HIGH SCHOOL', 'MOBILE COUNTY'), ('MATTIE T BLOUNT HIGH SCHOOL', 'MOBILE COUNTY'), ('SOUTH BROOKLEY ELEM SCH', 'MOBILE CO'), ('CHICKASAW ELEMENTARY SCHOOL', 'MOBILE COUNTY'), ('CITRONELLE HIGH SCHOOL', 'MOBILE COUNTY'), ('WP DAVIDSON HIGH SCHOOL', 'MOBILE COUNTY'), ('JOHN S SHAW HIGH SCHOOL', 'MOBILE COUNTY'), ('MARY G MONTGOMERY HIGH SCHOOL', 'MOBILE COUNTY'), ('GRAND BAY MIDDLE SCH', 'MOBILE CO'), ('MURPHY HIGH SCHOOL', 'MOBILE COUNTY'), ('ROBERT E LEE PRIMARY ELEM SCH', 'MOBILE CO'), ('JONESMCDAVID ELEMENTARY SCHOOL', 'MOBILE COUNTY'), ('SATSUMA HIGH SCHOOL', 'MOBILE COUNTY'), ('LE FLORE HIGH SCHOOL', 'MOBILE COUNTY'), ('CF VIGOR HIGH SCHOOL', 'MOBILE COUNTY'), ('LILLIE B WILLIAMSON HIGH SCHOOL', 'MOBILE COUNTY'), ('ALMA BRYANT HIGH SCHOOL', 'MOBILE COUNTY'), ('P O I N T E ACADEMY', 'MOBILE COUNTY'), ('THE PHOENIX PROGRAM', 'MOBILE COUNTY'), ('HILLSDALE ALT', 'MOBILE CO'), ('BAKER ELEMENTARY SCHOOL', 'MOBILE COUNTY'), ('ET BELSAW - MT VERNON SCH', 'MOBILE CO'), ('THEODORE HIGH SCHOOL', 'MOBILE COUNTY'), ('SW ALABAMA REGIONAL SCHOOL DEAF-BLIND', 'MOBILE COUNTY'), ('CITRONELLE MIDDLE SCHOOL', 'MOBILE COUNTY'), ('MONROE COUNTY HIGH SCHOOL', 'MONROE COUNTY'), ('FRISCO CITY ELEMENTARY SCHOOL', 'MONROE COUNTY'), ('MONROEVILLE ELEMENTARY SCHOOL', 'MONROE COUNTY'), ('NEW CHALLENGE ALTERNATIVE SCHOOL', 'MONTGOMERY COUNTY'), ('BOOKER T WASHINGTON MAGNET HIGH SCHOOL', 'MONTGOMERY COUNTY'), ('CLOVERDALE JUNIOR HIGH SCHOOL', 'MONTGOMERY COUNTY'), ('MONTGOMERY COUNTY HIGH SCHOOL', 'MONTGOMERY COUNTY'), ('CARVER SENIOR HIGH SCHOOL', 'MONTGOMERY COUNTY'), ('JEFFERSON DAVIS HIGH SCHOOL', 'MONTGOMERY COUNTY'), ('LEE HIGH SCHOOL', 'MONTGOMERY COUNTY'), ('LANIER SENIOR HIGH SCHOOL', 'MONTGOMERY COUNTY'), ('DAISY LAWRENCE BEEP', 'MONTGOMERY COUNTY'), ('LOVELESS ACADEMIC MAGNET PROGRAM HIGH SCHOOL', 'MONTGOMERY COUNTY'), ('BREWBAKER TECHNOLOGY MAGNET HIGH SCHOOL', 'MONTGOMERY COUNTY'), ('DAVIS LEARNING CENTER-BEEP', 'MONTGOMERY COUNTY'), ('PROJECT UPWARD', 'MONTGOMERY COUNTY'), ('MONTGOMERY YOUTH FACILITY', 'MONTGOMERY COUNTY'), ('DANVILLE HIGH SCHOOL', 'MORGAN COUNTY'), ('WEST MORGAN HIGH SCH', 'MORGAN CO'), ('ALBERT P BREWER HIGH SCHOOL', 'MORGAN COUNTY'), ('MOUNTAIN BROOK HIGH SCHOOL', 'MT BROOK CITY'), ('HIGHLAND PARK ELEMENTARY SCHOOL', 'MUSCLE SHOALS CITY'), ('MUSCLE SHOALS HIGH SCHOOL', 'MUSCLE SHOALS CITY'), ('WEBSTER ELEMENTARY SCHOOL', 'MUSCLE SHOALS CITY'), ('BROWN CENTER', 'OPELIKA CITY'), ('OPELIKA HIGH SCHOOL', 'OPELIKA CITY'), ('OPP HIGH SCHOOL', 'OPP CITY'), ('OXFORD HIGH SCHOOL', 'OXFORD CITY'), ('CARROLL HIGH SCHOOL', 'OZARK CITY'), ('EAST GATE SCH', 'OZARK CITY'), ('PELL CITY HIGH SCHOOL', 'PELL CITY'), ('CENTRAL HIGH SCHOOL', 'PHENIX CITY'), ('SUSIE E ALLEN ELEMENTARY SCHOOL', 'PHENIX CITY'), ('CENTRAL ELEMENTARY SCHOOL', 'PHENIX CITY'), ('LAKESIDE CENTER', 'PICKENS COUNTY'), ('PIEDMONT HIGH SCHOOL', 'PIEDMONT CITY'), ('HANDLEY HIGH SCHOOL', 'ROANOKE CITY'), ('PITTSVIEW ELEMENTARY SCHOOL', 'RUSSELL COUNTY'), ('MULTI-HANDICAPPED CENTER', 'RUSSELL COUNTY'), ('RUSSELL COUNTY JUNIOR HIGH SCHOOL', 'RUSSELL COUNTY'), ('RUSSELL COUNTY HIGH SCHOOL', 'RUSSELL COUNTY'), ('RUSSELLVILLE HIGH SCHOOL', 'RUSSELLVILLE CITY'), ('WEST ELEMENTARY SCHOOL', 'RUSSELLVILLE CITY'), ('LEWIS W PAGE ELEMENTARY SCHOOL', 'SCOTTSBORO CITY'), ('SCOTTSBORO HIGH SCHOOL', 'SCOTTSBORO CITY'), ('SELMA HIGH SCHOOL', 'SELMA CITY'), ('SHEFFIELD HIGH SCHOOL', 'SHEFFIELD CITY'), ('CHELSEA HIGH SCHOOL', 'SHELBY COUNTY'), ('SHELBY COUNTY HIGH SCHOOL', 'SHELBY COUNTY'), ('HELENA ELEMENTARY SCHOOL', 'SHELBY COUNTY'), ('MONTEVALLO HIGH SCHOOL', 'SHELBY COUNTY'), ('PELHAM HIGH SCHOOL', 'SHELBY COUNTY'), ('THOMPSON HIGH SCHOOL', 'SHELBY COUNTY'), ('VALLEY ELEMENTARY SCHOOL', 'SHELBY COUNTY'), ('OAK MOUNTAIN HIGH SCHOOL', 'SHELBY COUNTY'), ('SHELBY COUNTY INSTRUCTIONAL SERVICES CENTER-CAREER', 'SHELBY COUNTY'), ('LINDA NOLEN LEARNING CENTER', 'SHELBY COUNTY'), ('ASHVILLE HIGH SCHOOL', 'ST CLAIR COUNTY'), ('SAINT CLAIR COUNTY HIGH SCHOOL', 'ST CLAIR COUNTY'), ('SPRINGVILLE HIGH SCHOOL', 'ST CLAIR COUNTY'), ('MOODY HIGH SCHOOL', 'ST CLAIR COUNTY'), ('LIVINGSTON HIGH SCHOOL', 'SUMTER COUNTY'), ('SUMTER COUNTY HIGH SCHOOL', 'SUMTER COUNTY'), ('EAST HIGHLAND MIDDLE SCHOOL', 'SYLACAUGA CITY'), ('MOUNTAINVIEW ELEMENTARY SCHOOL', 'SYLACAUGA CITY'), ('SYLACAUGA HIGH SCHOOL', 'SYLACAUGA CITY'), ('TALLADEGA HIGH SCHOOL', 'TALLADEGA CITY'), ('DIXON MIDDLE SCHOOL', 'TALLADEGA CITY'), ('CHILDERSBURG HIGH SCHOOL', 'TALLADEGA COUNTY'), ('LINCOLN HIGH SCHOOL', 'TALLADEGA COUNTY'), ('MUNFORD HIGH SCHOOL', 'TALLADEGA COUNTY'), ('OPHELIA S HILL ELEMENTARY SCHOOL', 'TALLADEGA COUNTY'), ('TALLASSEE HIGH SCHOOL', 'TALLASSEE CITY'), ('TARRANT HIGH SCHOOL', 'TARRANT CITY'), ('THOMASVILLE HIGH SCHOOL', 'THOMASVILLE CITY'), ('CHARLES HENDERSON HIGH SCHOOL', 'TROY CITY'), ('TUSCALOOSA ALTERNATIVE LEARNING CENTER', 'TUSCALOOSA CITY'), ('CENTRAL ELEM SCH', 'TUSCALOOSA CITY'), ('CENTRAL HIGH SCHOOL WEST CAMPUS', 'TUSCALOOSA CITY'), ('OAKDALE ELEMENTARY SCHOOL', 'TUSCALOOSA CITY'), ('STAFFORD GLOBAL STUDIES CENTER', 'TUSCALOOSA CITY'), ('STILLMAN HEIGHTS ELEM SCH', 'TUSCALOOSA CITY'), ('NIGHT HIGH SCHOOL', 'TUSCALOOSA CITY'), ('CENTRAL HIGH EAST CAMPUS', 'TUSCALOOSA CITY'), ('HILLCREST HIGH SCHOOL', 'TUSCALOOSA COUNTY'), ('TUSCALOOSA COUNTY ALTERNATIVE SCHOOL', 'TUSCALOOSA COUNTY'), ('BROOKWOOD HIGH SCHOOL', 'TUSCALOOSA COUNTY'), ('HOLT HIGH SCHOOL', 'TUSCALOOSA COUNTY'), ('NORTHSIDE HIGH SCHOOL', 'TUSCALOOSA COUNTY'), ('TUSCALOOSA COUNTY HIGH SCHOOL', 'TUSCALOOSA COUNTY'), ('SPRAYBERRY REGIONAL EDUCATION CENTER', 'TUSCALOOSA COUNTY'), ('DESHLER HIGH SCHOOL', 'TUSCUMBIA CITY'), ('VESTAVIA HILLS HIGH SCHOOL', 'VESTAVIA HILLS CITY'), ('CARBON HILL HIGH SCHOOL', 'WALKER COUNTY'), ('CARBON HILL START SCHOOL', 'WALKER COUNTY'), ('WALKER COUNTY CENTER OF TECHNOLOGY', 'WALKER COUNTY'), ('CORDOVA HIGH SCHOOL', 'WALKER COUNTY'), ('CURRY HIGH SCHOOL', 'WALKER COUNTY'), ('DORA HIGH SCHOOL', 'WALKER COUNTY'), ('EMPIRE JUNIOR HIGH SCHOOL', 'WALKER COUNTY'), ('WILCOX CENTRAL HIGH SCHOOL', 'WILCOX COUNTY'), ('WINFIELD HIGH SCHOOL', 'WINFIELD CITY'), ('WINSTON COUNTY HIGH SCHOOL', 'WINSTON COUNTY')]

Note, that some school names have the word 'charter' in them but no schools in the AIR database are marked as charter schools and I didn't presume to set the charter field for 2006 based on the school name.