Public Libraries

State of Connecticut

@usgov.state_of_connecticut_public_libraries_b1aaf

Table List

1 table(513.09 KB)

Table 1

@usgov.state_of_connecticut_public_libraries_b1aaf.table_1

513.09 KB
5105 rows
29 columns

fiscal_year Fiscal Year	library Library	county County	principal_public Principal Public?	aenglc_rank AENGLC Rank	population_of_service_area Population Of Service Area	total_library_visits Total Library Visits	library_visits_per_capita_served Library Visits Per Capita Served	total_registered_borrowers Total Registered Borrowers	percent_of_residents_with_library_cards Percent Of Residents With Library Cards	reference_questions Reference Questions	reference_questions_per_capita_served Reference Questions Per Capita Served	total_circulation Total Circulation	circulation_per_capita_served Circulation Per Capita Served	total_programs_synchronous_prerecorded Total Programs (Synchronous + Prerecorded)	total_program_attendance_views Total Program Attendance & Views	total_program_attendance_views_per_capita_served Total Program Attendance & Views Per Capita Served	total_collection Total Collection	collection_per_capita_served Collection Per Capita Served	total_operating_income Total Operating Income	operating_income_per_capita Operating Income Per Capita	town_tax_appropriation_for_library Town Tax Appropriation For Library	tax_appropriation_per_capita_served Tax Appropriation Per Capita Served	library_materials_expenditures Library Materials Expenditures	wages_salaries_expenditures Wages & Salaries Expenditures	operating_expenditures Operating Expenditures	operating_expenditures_per_capita Operating Expenditures Per Capita
1996	Andover	Tolland	P	109	2815	15000	5.3	1313	0.47	499	0.2	17028	5.6	117	860	0.3	15285	5.4	56300	20	52915	18.8	10073	30996	44290	15.7
1996	Ansonia	New Haven	P	158	17825	91756	5.1	6952	0.39			71301	3.5	153	4525	0.3	63685	3.6	320679	17.99	323503	18.15	45874	201621	270658	15.2
1996	Ashford-Babcock	Windham	P	131	3969	8665	2.2	1360	0.34	207	0.1	34574	8.6	22	780	0.2	23818	6	111699	28.14	106713	26.89	11508	62295	82769	20.9
1996	Avon	Hartford	P	19	14143	162893	11.5	8808	0.62	15283	1.1	226137	11.9	345	9501	0.7	74903	5.3	685678	48.48	602831	42.62	92711	340400	516583	36.5
1996	Beacon Falls	New Haven	P	129	5351	7000	1.3	1379	0.26	400	0.1	8880	1.7	22	223		10042	1.9	40806	7.63	39256	7.34	4298	21585	39165	7.3
1996	Berlin-Peck	Hartford	P	52	16792			8142	0.48	6081	0.4	217517	11.6	376			92322	5.5	638641	38.03	643771	38.34	92877	320919	480642	28.6
1996	Bethany - Clark	New Haven	P	54	4845	19500	4	3100	0.64	696	0.1	40500	8.3	45	395	0.1	32178	6.6	46497	9.6	36483	7.53	9848	21720	39231	8.1
1996	Bethel	Fairfield	P	74	17921	155316	8.7	12546	0.7	16796	0.9	136014	6.7	186	4706	0.3	83123	4.6	375789	20.97	371859	20.75	89167	229724	364548	20.3
1996	Bethlehem	Litchfield	P	73	3324	17478	5.3	1952	0.59			33532	9.9	37	670	0.2	22966	6.9	62571	18.82	56000	16.85	5551	37448	47980	14.4
1996	Bloomfield - Prosser	Hartford	P	55	18546			9156	0.49	15408	0.8	194144	8.4	418	9935	0.5	118282	6.4	708697	38.21	694710	37.46	88610	531196	678787	36.6


CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "library" VARCHAR,
  "county" VARCHAR,
  "principal_public" VARCHAR,
  "aenglc_rank" DOUBLE,
  "population_of_service_area" DOUBLE,
  "total_library_visits" DOUBLE,
  "library_visits_per_capita_served" DOUBLE,
  "total_registered_borrowers" DOUBLE,
  "percent_of_residents_with_library_cards" DOUBLE,
  "registrations_per_capita_served" VARCHAR,
  "reference_questions" DOUBLE,
  "reference_questions_per_capita_served" DOUBLE,
  "total_circulation" DOUBLE,
  "circulation_per_capita_served" DOUBLE,
  "total_programs_synchronous_prerecorded" DOUBLE,
  "total_program_attendance_views" DOUBLE,
  "total_program_attendance_views_per_capita_served" DOUBLE,
  "use_of_public_internet_computers" DOUBLE,
  "total_collection" DOUBLE,
  "collection_per_capita_served" DOUBLE,
  "total_operating_income" DOUBLE,
  "operating_income_per_capita" DOUBLE,
  "town_tax_appropriation_for_library" DOUBLE,
  "tax_appropriation_per_capita_served" DOUBLE,
  "library_materials_expenditures" DOUBLE,
  "wages_salaries_expenditures" DOUBLE,
  "operating_expenditures" DOUBLE,
  "operating_expenditures_per_capita" DOUBLE
);