Name: 2018 - 2019 School Locations
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

2018 - 2019 School Locations

2018 - 2019 School Locations
Organization: City of New York
Last updated: 2020-11-10T17:01:33.503558

Tables

Table 1

@usgov.city_of_new_york_2018_2019_school_locations.table_1

307.96 kB
1,941 rows
41 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "system_code" BIGINT,
  "location_code" VARCHAR,
  "location_name" VARCHAR,
  "beds_number" BIGINT,
  "managed_by_name" VARCHAR,
  "location_type_description" VARCHAR,
  "location_category_description" VARCHAR,
  "grades_text" VARCHAR,
  "grades_final_text" VARCHAR,
  "open_date" TIMESTAMP,
  "status_descriptions" VARCHAR,
  "primary_building_code" VARCHAR,
  "primary_address_line_1" VARCHAR,
  "state_code" VARCHAR,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "community_district" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "borough_block_lot" DOUBLE,
  "nta" VARCHAR,
  "nta_name" VARCHAR,
  "principal_name" VARCHAR,
  "principal_title" VARCHAR,
  "principal_phone_number" VARCHAR,
  "fax_number" VARCHAR,
  "geographical_district_code" BIGINT,
  "admin_district_location_code" VARCHAR,
  "administrative_district_name" VARCHAR,
  "community_school_sup_name" VARCHAR,
  "field_support_center_name" VARCHAR,
  "field_support_center_leader_name" VARCHAR,
  "school_support_team_name" VARCHAR,
  "school_support_team_leader_name" VARCHAR,
  "highschool_network_location_code" VARCHAR,
  "highschool_network_name" VARCHAR,
  "highschool_network_superintendent" VARCHAR,
  "new_georeferenced_column" VARCHAR
);