About this Dataset

Oklahoma Public School Site Directory

Contact information for Oklahoma State Department of Education (SDE) accredited, public education sites in Oklahoma, including: website address, contact information and administrators, among other categories.
Organization: State of Oklahoma
Last updated: 2021-08-07T14:59:58.924192
Tags: directory, public-school

Tables

Oklahoma Public School Site Directory (August 2015)

@usgov.state_of_oklahoma_oklahoma_public_school_site_directory.oklahoma_public_school_site_directory_august_2015

109.77 kB
1,806 rows
14 columns

CREATE TABLE oklahoma_public_school_site_directory_august_2015 (
  "county_name" VARCHAR,
  "district_name" VARCHAR,
  "co_dist_code" VARCHAR,
  "site_code" BIGINT,
  "school_site" VARCHAR,
  "total_enrollment" DOUBLE,
  "telephone" VARCHAR,
  "principal" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_state" VARCHAR,
  "mailing_zip" DOUBLE,
  "grades_low_high" VARCHAR  -- Grades (Low-High),
  "certified_staff" BIGINT
);

Oklahoma Public School Site Directory (January 2016)

@usgov.state_of_oklahoma_oklahoma_public_school_site_directory.oklahoma_public_school_site_directory_january_2016

142.07 kB
1,830 rows
15 columns

CREATE TABLE oklahoma_public_school_site_directory_january_2016 (
  "county" VARCHAR,
  "district" VARCHAR,
  "co_dist_code" VARCHAR,
  "site_code" DOUBLE,
  "school_site" VARCHAR,
  "total_enrollment" DOUBLE,
  "telephone" VARCHAR,
  "principal" VARCHAR,
  "principle_s_email" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_state" VARCHAR,
  "mailing_zip" DOUBLE,
  "grades_low_high" VARCHAR  -- Grades (Low-High),
  "certified_staff" DOUBLE
);

Oklahoma Public School Site Directory (June 2018)

@usgov.state_of_oklahoma_oklahoma_public_school_site_directory.oklahoma_public_school_site_directory_june_2018

178.62 kB
1,859 rows
19 columns

CREATE TABLE oklahoma_public_school_site_directory_june_2018 (
  "county_name" VARCHAR,
  "district_name" VARCHAR,
  "co_dist_code" VARCHAR,
  "site_code" DOUBLE,
  "school_site" VARCHAR,
  "total_enrollment" DOUBLE,
  "telephone" VARCHAR,
  "principal" VARCHAR,
  "principal_s_email" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_state" VARCHAR,
  "mailing_zip" VARCHAR,
  "physical_address" VARCHAR,
  "physical_city" VARCHAR,
  "physical_state" VARCHAR,
  "physical_zip" VARCHAR,
  "grades_low_high" VARCHAR  -- Grades (Low-High),
  "certified_staff" DOUBLE
);

Oklahoma Public School Site Directory (March 2017)

@usgov.state_of_oklahoma_oklahoma_public_school_site_directory.oklahoma_public_school_site_directory_march_2017

135.74 kB
1,837 rows
15 columns

CREATE TABLE oklahoma_public_school_site_directory_march_2017 (
  "coname" VARCHAR,
  "distname" VARCHAR,
  "textbox37" VARCHAR,
  "site" BIGINT,
  "schname" VARCHAR,
  "enrollment" VARCHAR,
  "phone1" VARCHAR,
  "principal" VARCHAR,
  "principalemail" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "board_president" VARCHAR,
  "certified_staff" BIGINT
);

Oklahoma Public School Site Directory (November 2015)

@usgov.state_of_oklahoma_oklahoma_public_school_site_directory.oklahoma_public_school_site_directory_november_2015

141.83 kB
1,829 rows
15 columns

CREATE TABLE oklahoma_public_school_site_directory_november_2015 (
  "district" VARCHAR,
  "school_site" VARCHAR,
  "co_dist_code" VARCHAR,
  "site_code" BIGINT,
  "enrollment" DOUBLE,
  "certified_staff" BIGINT,
  "grades_low_high" VARCHAR  -- Grades (Low-High),
  "telephone" VARCHAR,
  "mailing_address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "county" VARCHAR,
  "principal" VARCHAR,
  "principal_email" VARCHAR
);

Oklahoma Public School Site Directory (November 2016)

@usgov.state_of_oklahoma_oklahoma_public_school_site_directory.oklahoma_public_school_site_directory_november_2016

142.65 kB
1,838 rows
15 columns

CREATE TABLE oklahoma_public_school_site_directory_november_2016 (
  "coname" VARCHAR,
  "distname" VARCHAR,
  "co_dist_code" VARCHAR,
  "site" BIGINT,
  "schname" VARCHAR,
  "enrollment" DOUBLE,
  "phone1" VARCHAR,
  "principal" VARCHAR,
  "principalemail" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "board_president" VARCHAR,
  "certified_staff" BIGINT
);

Oklahoma Public School Site Directory (November 2017)

@usgov.state_of_oklahoma_oklahoma_public_school_site_directory.oklahoma_public_school_site_directory_november_2017

136.73 kB
1,855 rows
16 columns

CREATE TABLE oklahoma_public_school_site_directory_november_2017 (
  "county_name" VARCHAR,
  "district_name" VARCHAR,
  "co_dist_code" VARCHAR,
  "site_code" DOUBLE,
  "school_site" VARCHAR,
  "total_enrollment" VARCHAR,
  "telephone" VARCHAR,
  "principal" VARCHAR,
  "principal_s_email" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_state" VARCHAR,
  "mailing_zip" DOUBLE,
  "grades_low_high" VARCHAR  -- Grades (Low-High),
  "certified_staff" DOUBLE,
  "unnamed_15" VARCHAR  -- Unnamed: 15
);

Oklahoma Public School Site Directory (November 2018)

@usgov.state_of_oklahoma_oklahoma_public_school_site_directory.oklahoma_public_school_site_directory_november_2018

179.78 kB
1,880 rows
19 columns

CREATE TABLE oklahoma_public_school_site_directory_november_2018 (
  "county_name" VARCHAR,
  "district_name" VARCHAR,
  "co_dist_code" VARCHAR,
  "site_code" DOUBLE,
  "school_site" VARCHAR,
  "total_enrollment" DOUBLE,
  "telephone" VARCHAR,
  "principal" VARCHAR,
  "principal_s_email" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_state" VARCHAR,
  "mailing_zip" VARCHAR,
  "physical_address" VARCHAR,
  "physical_city" VARCHAR,
  "physical_state" VARCHAR,
  "physical_zip" VARCHAR,
  "grades_low_high" VARCHAR  -- Grades (Low-High),
  "certified_staff" DOUBLE
);