2021 DOE Middle School Directory by US Government | Demographics and Population Studies

About this Dataset

2021 DOE Middle School Directory

Directory of Department of Education Schools in 2021.
Organization: City of New York
Last updated: 2020-11-10T17:02:51.384565
Tags: directory, doe, education, middle-school, schools

Tables

Table 1

@usgov.city_of_new_york_2021_doe_middle_school_directory.table_1

615.64 KB
474 rows
327 columns


CREATE TABLE table_1 (
  "district" BIGINT,
  "schooldbn" VARCHAR,
  "name" VARCHAR,
  "overview" VARCHAR,
  "neighborhood" VARCHAR,
  "address" VARCHAR,
  "sharedbuilding" VARCHAR,
  "accessibility_description" VARCHAR,
  "telephone" VARCHAR,
  "independentwebsite" VARCHAR,
  "url" VARCHAR,
  "subway" VARCHAR,
  "bus" VARCHAR,
  "code_prog1" VARCHAR,
  "name_prog1" VARCHAR,
  "admissionsmethod_prog1" VARCHAR,
  "geapps_prog1" DOUBLE,
  "swdapps_prog1" DOUBLE,
  "geappsperseat_prog1" DOUBLE,
  "swdappsperseat_prog1" DOUBLE,
  "swdseats_prog1" DOUBLE,
  "geseats_prog1" DOUBLE,
  "gefilled_prog1" VARCHAR,
  "swdfilled_prog1" VARCHAR,
  "eligibility_prog1" VARCHAR,
  "priority1_prog1" VARCHAR,
  "priority2_prog1" VARCHAR,
  "priority3_prog1" VARCHAR,
  "priority4_prog1" VARCHAR,
  "priority5_prog1" VARCHAR,
  "priority6_prog1" VARCHAR,
  "priority7_prog1" VARCHAR,
  "code_prog2" VARCHAR,
  "name_prog2" VARCHAR,
  "admissionsmethod_prog2" VARCHAR,
  "geapps_prog2" DOUBLE,
  "swdapps_prog2" DOUBLE,
  "geappsperseat_prog2" DOUBLE,
  "swdappsperseat_prog2" DOUBLE,
  "swdseats_prog2" DOUBLE,
  "geseats_prog2" DOUBLE,
  "gefilled_prog2" VARCHAR,
  "swdfilled_prog2" VARCHAR,
  "eligibility_prog2" VARCHAR,
  "priority1_prog2" VARCHAR,
  "priority2_prog2" VARCHAR,
  "priority3_prog2" VARCHAR,
  "priority4_prog2" VARCHAR,
  "priority5_prog2" VARCHAR,
  "priority6_prog2" VARCHAR,
  "priority7_prog2" VARCHAR,
  "code_prog3" VARCHAR,
  "name_prog3" VARCHAR,
  "admissionsmethod_prog3" VARCHAR,
  "geapps_prog3" DOUBLE,
  "swdapps_prog3" DOUBLE,
  "geappsperseat_prog3" DOUBLE,
  "swdappsperseat_prog3" DOUBLE,
  "swdseats_prog3" DOUBLE,
  "geseats_prog3" DOUBLE,
  "gefilled_prog3" VARCHAR,
  "swdfilled_prog3" VARCHAR,
  "eligibility_prog3" VARCHAR,
  "priority1_prog3" VARCHAR,
  "priority2_prog3" VARCHAR,
  "priority3_prog3" VARCHAR,
  "priority4_prog3" VARCHAR,
  "priority5_prog3" VARCHAR,
  "priority6_prog3" VARCHAR,
  "priority7_prog3" VARCHAR,
  "code_prog4" VARCHAR,
  "name_prog4" VARCHAR,
  "admissionsmethod_prog4" VARCHAR,
  "geapps_prog4" DOUBLE,
  "swdapps_prog4" DOUBLE,
  "geappsperseat_prog4" DOUBLE,
  "swdappsperseat_prog4" DOUBLE,
  "swdseats_prog4" DOUBLE,
  "geseats_prog4" DOUBLE,
  "gefilled_prog4" VARCHAR,
  "swdfilled_prog4" VARCHAR,
  "eligibility_prog4" VARCHAR,
  "priority1_prog4" VARCHAR,
  "priority2_prog4" VARCHAR,
  "priority3_prog4" VARCHAR,
  "priority4_prog4" VARCHAR,
  "priority5_prog4" VARCHAR,
  "priority6_prog4" VARCHAR,
  "priority7_prog4" VARCHAR,
  "code_prog5" VARCHAR,
  "name_prog5" VARCHAR,
  "admissionsmethod_prog5" VARCHAR,
  "geapps_prog5" DOUBLE,
  "swdapps_prog5" DOUBLE,
  "geappsperseat_prog5" DOUBLE,
  "swdappsperseat_prog5" DOUBLE,
  "swdseats_prog5" DOUBLE,
  "geseats_prog5" DOUBLE,
  "gefilled_prog5" VARCHAR,
  "swdfilled_prog5" VARCHAR
);