School Building Technology Survey

CREATE TABLE table_1 (
  "year" DOUBLE,
  "esd" DOUBLE,
  "district" VARCHAR,
  "school" VARCHAR,
  "k_12_total_enrollment" DOUBLE,
  "do_teacher_librarians_have_a_role_in_supporting_techno_14124a98" DOUBLE  -- Do Teacher Librarians Have A Role In Supporting Technology Integration In Your Building?,
  "number_of_classrooms_including_portables_used_as_class_95b775e4" DOUBLE  -- Number Of Classrooms (including Portables Used As Classrooms, Labs, And Library),
  "number_of_classrooms_with_wired_or_wireless_internet_access" DOUBLE,
  "does_this_building_have_a_wide_area_network_wan_link_t_84a5cf65" DOUBLE  -- Does This Building Have A Wide-Area Network (WAN) Link To Your District Office ?,
  "less_than_10_mb" DOUBLE,
  "n_10_99_mb" DOUBLE  -- 10-99 MB,
  "n_100_999_mb" DOUBLE  -- 100-999 MB,
  "n_1_gb_or_higher" DOUBLE  -- 1 GB Or Higher,
  "does_your_building_provide_wireless_access_to_the_internet" DOUBLE  -- Does Your Building Provide Wireless Access To The Internet?,
  "one_classroom_or_meeting_room_only" DOUBLE  -- One Classroom Or Meeting Room Only?,
  "more_than_one_classroom_or_meeting_room_but_not_building_wide" DOUBLE  -- More Than One Classroom Or Meeting Room, But Not Building-wide?,
  "central_areas_throughout_building_but_not_one_wap_classroom" DOUBLE  -- Central Areas Throughout Building (but Not One WAP/classroom)?,
  "the_entire_building" DOUBLE  -- The Entire Building?,
  "number_of_assistive_adaptive_technology_devices_for_de_2d7d55a4" DOUBLE  -- Number Of Assistive/adaptive Technology Devices For Dedicated Use By Students With An IEP Or 504 :,
  "number_of_students_with_school_or_district_provided_e__d4d74fa9" DOUBLE  -- Number Of Students With School-(or District) Provided E-mail Accounts,
  "do_you_have_one_or_more_grades_in_your_school_that_hav_d541d68c" DOUBLE  -- Do You Have One Or More Grades In Your School That Have A One-to-one Initiative (e.g., Laptops, Tablets, Netbooks)?,
  "if_yes_please_describe" VARCHAR  -- If Yes, Please Describe:,
  "if_yes_are_students_allowed_to_take_devices_home" DOUBLE  -- If Yes, Are Students Allowed To Take Devices Home?,
  "n__list_other_district_owned_wireless_handheld_devices_2f6053ae" VARCHAR  -- List Other District-owned Wireless Handheld Devices That You Make Available For Instructional Use:,
  "number_of_instructional_laptops" DOUBLE,
  "number_of_instructional_desktops" DOUBLE,
  "number_of_instructional_netbooks" DOUBLE,
  "number_of_instructional_tablets" DOUBLE,
  "number_of_instructional_thin_clients" DOUBLE,
  "number_of_windows_xp_os" DOUBLE,
  "number_of_windows_7_os" DOUBLE,
  "number_of_windows8_8_1_os" DOUBLE,
  "number_of_windows_10_os" DOUBLE,
  "number_of_other_windows_os" DOUBLE,
  "number_of_linux_os" DOUBLE,
  "number_of_mac_os_x_10_4_or_lower" DOUBLE,
  "number_of_mac_os_x_10_5_or_higher" DOUBLE,
  "number_of_ios" DOUBLE,
  "number_of_android" DOUBLE,
  "number_of_google_chrome" DOUBLE,
  "devices_with_screen_resolution_less_than_1024_x_768" DOUBLE,
  "devices_with_screen_resolution_1024_x_768_or_higher" DOUBLE,
  "devices_with_screen_size_less_than_9_5_inch" DOUBLE,
  "devices_with_screen_size_10_inch_or_larger" DOUBLE,
  "devices_with_ram_less_than_1_gb" DOUBLE,
  "devices_with_ram_1_gb_or_higher" DOUBLE,
  "number_of_multimedia_projectors" DOUBLE  -- Number Of Multimedia Projectors:,
  "number_of_digital_media_receivers_e_g_apple_tv" DOUBLE  -- Number Of Digital Media Receivers (e.g., Apple TV):,
  "number_of_flat_panel_displays_used_for_displaying_teac_84f5af1b" DOUBLE  -- Number Of Flat Panel Displays Used For Displaying Teacher Lessons (32 Inches Or Larger):,
  "number_of_document_cameras" DOUBLE  -- Number Of Document Cameras:,
  "number_of_whole_classroom_interactive_devices_i_e_smar_18e83572" DOUBLE  -- Number Of Whole Classroom Interactive Devices (i.e., SMARTBoards, Promethean, Hitachi, Etc.),
  "number_of_mobile_and_wireless_interactive_slates_or_ta_a1771541" DOUBLE  -- Number Of Mobile And Wireless Interactive Slates Or Tablets (for Example, Mobi, Airliners, IPad):,
  "number_of_student_response_systems_number_of_sets_not__ebc459f7" DOUBLE  -- Number Of Student Response Systems (number Of Sets, Not Individual Responder Units):,
  "number_of_learning_environments_that_provide_a_classro_ac96c6e9" DOUBLE  -- Number Of Learning Environments That Provide A Classroom Amplification System,
  "districtwanspeed" VARCHAR,
  "schoolwirelessscope" VARCHAR
);