Name: Full Library Services Dataset
Creator: Kaggle
License: https://www.apache.org/licenses/

About this Dataset

Full Library Services Dataset

This dataset contains information about each library, such as the branch name, address, city, ZIP code, square footage, inventory size, contact details, accessibility features, and available public transportation options. Additionally, the it contains geographical data like latitude and longitude, which can be used for spatial analysis or mapping purposes. I believe there is several analyses can be performed to derive meaningful insights such as:

Geospatial Analysis: To visualize the geographic distribution of library branches and assess their accessibility in relation to population density and public transportation options.
Descriptive Statistics: To summarize the central tendencies, variability, and overall distribution of key variables such as inventory size, square footage, and population size.
Correlation Analysis: To identify relationships between different variables, such as the relationship between inventory size and square footage or between population size and the number of available library services.
Resource Utilization Analysis: To evaluate how efficiently each library branch utilizes its space and inventory in serving the local community.

Tables

Library Services 20240831

@kaggle.sahirmaharajj_library_services_dataset.library_services_20240831

68.21 kB
21 rows
105 columns

CREATE TABLE library_services_20240831 (
  "branch" VARCHAR,
  "webpage" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip" BIGINT,
  "square_feet" BIGINT,
  "inventory" BIGINT,
  "population_size" VARCHAR,
  "phone" VARCHAR,
  "tty_phone" VARCHAR,
  "sunday_open" DOUBLE,
  "sunday_close" DOUBLE,
  "monday_open" DOUBLE,
  "monday_close" DOUBLE,
  "tuesday_open" DOUBLE,
  "tuesday_close" DOUBLE,
  "wednesday_open" DOUBLE,
  "wednesday_close" DOUBLE,
  "thursday_open" DOUBLE,
  "thursday_close" DOUBLE,
  "friday_open" DOUBLE,
  "friday_close" DOUBLE,
  "saturday_open" DOUBLE,
  "saturday_close" DOUBLE,
  "wi_fi" VARCHAR,
  "charging" VARCHAR,
  "go_kits" VARCHAR,
  "literacy_after_school" VARCHAR,
  "collaboration" BIGINT,
  "computers" DOUBLE,
  "discovery_room" VARCHAR,
  "n_3d_printers" VARCHAR  -- 3D Printers,
  "makerspace" VARCHAR,
  "e_reader" VARCHAR,
  "laptops" VARCHAR,
  "amharic_adult" VARCHAR,
  "amharic_child" VARCHAR,
  "chinese_adult" VARCHAR,
  "chinese_child" VARCHAR,
  "farsi_adult" VARCHAR,
  "farsi_child" VARCHAR,
  "french_adult" VARCHAR,
  "french_child" VARCHAR,
  "korean_adult" VARCHAR,
  "korean_child" VARCHAR,
  "russian_adult" VARCHAR,
  "russian_child" VARCHAR,
  "spanish_adult" VARCHAR,
  "spanish_child" VARCHAR,
  "vietnamese_adult" VARCHAR,
  "vietnamese_child" VARCHAR,
  "metro_station" VARCHAR,
  "bike_share_2" VARCHAR,
  "bike_share_1" VARCHAR,
  "bus_4" VARCHAR,
  "bus_5" VARCHAR,
  "bus_6" VARCHAR,
  "bus_7" VARCHAR,
  "bus_9" VARCHAR,
  "bus_12" VARCHAR,
  "bus_14" VARCHAR,
  "bus_15" VARCHAR,
  "bus_16" VARCHAR,
  "bus_17" VARCHAR,
  "bus_19" VARCHAR,
  "bus_20" VARCHAR,
  "bus_23" VARCHAR,
  "bus_26" VARCHAR,
  "bus_29" VARCHAR,
  "bus_33" VARCHAR,
  "bus_34" VARCHAR,
  "bus_36" VARCHAR,
  "bus_45" VARCHAR,
  "bus_47" VARCHAR,
  "bus_48" VARCHAR,
  "bus_53" VARCHAR,
  "bus_55" VARCHAR,
  "bus_56" VARCHAR,
  "bus_58" VARCHAR,
  "bus_59" VARCHAR,
  "bus_76" VARCHAR,
  "bus_90" VARCHAR,
  "bus_97" VARCHAR,
  "bus_98" VARCHAR,
  "bus_j2" VARCHAR,
  "bus_l8" VARCHAR,
  "metrobus_c2" VARCHAR,
  "metrobus_c4" VARCHAR,
  "metrobus_c8" VARCHAR,
  "metrobus_d5" VARCHAR,
  "metrobus_f4" VARCHAR,
  "metrobus_j2" VARCHAR,
  "metrobus_j3" VARCHAR,
  "metrobus_j4" VARCHAR,
  "metrobus_l8" VARCHAR,
  "metrobus_q1" VARCHAR,
  "metrobus_q2" VARCHAR,
  "metrobus_t2" VARCHAR,
  "metrobus_z2" VARCHAR,
  "metrobus_z8" VARCHAR
);