Full Library Services Dataset

Demographic and asset information of public libraries

@kaggle.sahirmaharajj_library_services_dataset

Table List

1 table(66.61 KB)

Library Services 20240831

@kaggle.sahirmaharajj_library_services_dataset.library_services_20240831

66.61 KB
21 rows
105 columns
Only the first 100 columns are shown

branch Branch	webpage Webpage	address Address	city City	zip Zip	square_feet Square Feet	inventory Inventory	phone Phone	tty_phone TTY Phone	sunday_open Sunday Open	sunday_close Sunday Close	monday_open Monday Open	monday_close Monday Close	tuesday_open Tuesday Open	tuesday_close Tuesday Close	wednesday_open Wednesday Open	wednesday_close Wednesday Close	thursday_open Thursday Open	thursday_close Thursday Close	friday_open Friday Open	friday_close Friday Close	saturday_open Saturday Open	saturday_close Saturday Close	wi_fi Wi-Fi	charging Charging	go_kits Go Kits	literacy_after_school Literacy After School	collaboration Collaboration	computers Computers	discovery_room Discovery Room	n_3d_printers 3D Printers	makerspace Makerspace	e_reader E-Reader	laptops Laptops	amharic_adult Amharic Adult	amharic_child Amharic Child	chinese_adult Chinese Adult	chinese_child Chinese Child	farsi_adult Farsi Adult	farsi_child Farsi Child	french_adult French Adult	french_child French Child	korean_adult Korean Adult	korean_child Korean Child	russian_adult Russian Adult	russian_child Russian Child	spanish_adult Spanish Adult	spanish_child Spanish Child	vietnamese_adult Vietnamese Adult	vietnamese_child Vietnamese Child	metro_station Metro Station	bike_share_2 Bike Share 2	bike_share_1 Bike Share 1	bus_4 Bus 4	bus_5 Bus 5	bus_6 Bus 6	bus_7 Bus 7	bus_9 Bus 9	bus_12 Bus 12	bus_14 Bus 14	bus_15 Bus 15	bus_16 Bus 16	bus_17 Bus 17	bus_19 Bus 19	bus_20 Bus 20	bus_23 Bus 23	bus_26 Bus 26	bus_29 Bus 29	bus_33 Bus 33	bus_34 Bus 34	bus_36 Bus 36	bus_45 Bus 45	bus_47 Bus 47	bus_48 Bus 48	bus_53 Bus 53	bus_55 Bus 55	bus_56 Bus 56	bus_58 Bus 58	bus_59 Bus 59	bus_76 Bus 76	bus_90 Bus 90	bus_97 Bus 97	bus_98 Bus 98	bus_j2 Bus J2	bus_l8 Bus L8	metrobus_c2 Metrobus C2	metrobus_c4 Metrobus C4	metrobus_c8 Metrobus C8	metrobus_d5 Metrobus D5	metrobus_f4 Metrobus F4	metrobus_j2 Metrobus J2	metrobus_j3 Metrobus J3	metrobus_j4 Metrobus J4	metrobus_l8 Metrobus L8	metrobus_q1 Metrobus Q1	metrobus_q2 Metrobus Q2	metrobus_t2 Metrobus T2	metrobus_z2 Metrobus Z2	metrobus_z8 Metrobus Z8
Aspen Hill	http://montgomerycountymd.gov/Library/branches/aspenhill.html	4407 Aspen Hill Road	Rockville	20853	16100	78647	240-773-9410	301-871-2097	1	5	10	6	12	8	10	6	12	8	10	6	10	6	y	y	y	y	1	21	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	twinbrook	E. gude	taft st.	n	n	n	n	n	n	n	n	n	n	n	n	n	y	n	n	n	n	n	n	y	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n
Gaithersburg	http://montgomerycountymd.gov/Library/branches/gaithersburg.html	18330 Montgomery Village Avenue	Gaithersburg	20879	62525	153055	240-773-9490	nan	1	5	10	6	1	9	10	6	1	9	10	6	10	6	y	y	y	y	7	44	y	n	n	y	n	y	y	y	y	y	y	y	y	y	y	n	n	y	y	y	y	shady grove	shady grove metro	shady grove metro	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	y	y	y	y	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n
Maggie Nightingale	http://montgomerycountymd.gov/Library/branches/poolesville.html	19633 Fisher Avenue	Poolseville	20837	6250	38456	240-773-9550	301-972-7825			10	6	12	8	12	8	10	6	10	6	10	6	y	y	y	y		5	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	blackwell rd	broshart rd	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	y	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n
Potomac	http://montgomerycountymd.gov/Library/branches/Potomac.html	10101 Glenolden Drive	Potomac	20854	16000	92628	240-777-0690	301-765-4083	1	5	10	6	12	8	10	6	12	8	10	6	10	6	y	y	y	y		11	n	n	n	n	n	n	n	y	y	n	n	n	n	n	n	n	n	n	n	n	n	n	southwick street	old georgetown rd	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	y	n	n
White Oak	http://montgomerycountymd.gov/Library/branches/WhiteOak.html	11701 New Hampshire Avenue	Silver Spring	20904	16205	94217	240-773-9555	nan	1	5	10	6	12	8	10	6	12	8	10	6	10	6	y	y	y	y		21	n	n	n	y	n	y	y	n	n	n	n	n	n	n	n	n	n	y	y	n	n	n	walden rd	garland ave	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	y	n	n	n	n	n	n	n	n	n	y	y
Chevy Chase	http://montgomerycountymd.gov/Library/branches/chevychase.html	8005 Connecticut Avenue	Chevy Chase	20815	13656	79482	240-773-9590	nan	1	5	10	6	12	8	10	6	12	8	10	6	10	6	y	y	y	y		11	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	y	n	n	n	chevy chase drive	connecticut ave	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	y	y	n	y	n	n	n	n	n
Germantown	http://montgomerycountymd.gov/Library/branches/Germantown.html	19840 Century Blvd.	Germantown	20874	44193	176961	240-777-0110	nan	1	5	10	6	1	9	10	6	1	9	10	6	10	6	y	y	y	y	5	37	y	n	n	y	n	n	n	y	y	n	n	n	n	n	n	n	n	y	y	n	n	n	pleasant dr	king farm blvd	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	y	y	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n
Long Branch	http://montgomerycountymd.gov/Library/branches/LongBranch.html	8800 Garland Avenue	Silver Spring	20901	21034	67299	240-777-0910	301-565-7662															y	y	y	y	2	17	n	y	n	y	y	n	n	y	y	n	n	n	n	n	n	n	n	y	y	y	y	n	walden rd	garland ave	n	n	n	n	n	y	y	y	y	y	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	y	y	n	n	n	n	n	n	y	n	n	n	n	n
Olney	http://montgomerycountymd.gov/Library/branches/Olney.html	3500 Olney-Laytonsville Road	Olney	20832	22574	87423	240-773-9545	nan	1	5	10	6	1	9	10	6	1	9	10	6	10	6	y	y	y	y	2	16	n	n	n	y	n	n	n	n	n	n	n	n	n	n	n	n	n	y	y	n	n	n	eagles head ct	needwood rd	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	y	y	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n
Connie Morella	http://montgomerycountymd.gov/Library/branches/bethesda.html	7400 Arlington Road	Bethesda	20814	27280	129548	240-777-0970	nan	1	5	10	6	1	9	10	6	1	9	10	6	10	6	y	y	y	y	2	18	n	n	n	n	n	n	n	y	y	n	y	y	y	n	n	n	n	y	y	n	n	bethesda	arlington rd	bethesda ave	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	y	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n	n


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,
  "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
);