U.S. Public Libraries Database

Explore 17,415 operating public-library outlets and 9,205 system profiles across all 50 states and D.C., with FY2024 locations, finances, and service statistics.

Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 2.0.0 dated September 2, 2026. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
Library Directory17,415 operating outlets and 9,205 system profiles, including five explicitly marked temporary system closures.
$40.00
Complete Library ResearchEverything in Library Operations, plus 9,205 service profiles and 3,803 matched historical website records, clearly labeled as unverified FY2003 evidence.
$200.00
U.S. Public Libraries Database List

U.S. Public Libraries Database v.2.0.0

17,415 Database Records

U.S. Public Libraries Database catalog icon U.S. Public Libraries Database Download

License Database Purchase Options

Pick the right license LIBRARY DIRECTORY
USAGE LICENSE
$40.00
 LIBRARY OPERATIONS
PUBLICATION LICENSE
$100.00
 COMPLETE LIBRARY RESEARCH
MASTER LICENSE
$200.00
Data Tracking Seeds
Data Modification
Importing
Exporting
Merge
Web Usage
Multiple PC's or Websites
Mobile Development
Updates Available
All Data File Formats
Custom File Formats
Distribution
Copyright Endorsement
  BUY NOW BUY NOW BUY NOW

U.S. library coverage · FY2024

Library locations connected to the systems behind them

Build directories, map service coverage and compare public-library operations with 17,415 operating outlets and 9,205 system profiles across the 50 states and District of Columbia.

17,415Operating outlets
9,205System profiles
51States and D.C.
2024Reporting year

Choose the detail your project needs

Library Directory provides locations, phone numbers, outlet types, coordinates, hours and linked administrative profiles. Library Operations adds annual revenue, expenditure and staffing. Complete Library Research adds collections, circulation, programs, attendance, technology use and clearly dated historical website references.

TableRowsContents
library_outlets17,415Operating central libraries, branches, bookmobile services and books-by-mail outlets.
library_systems9,205Administrative system profiles, including five explicitly marked temporary closures needed to preserve relationships.
library_finances9,205Annual operating and capital revenue, expenditure and staffing measures.
library_services9,205Annual collections, circulation, visits, programs, attendance and technology measures.
historical_websites3,803Dated historical website references for confidently matched current systems, not verified current contacts.

Useful details, clear limits

Five system profiles are marked temporarily closed, while operating branches remain linked. Survey nonrespondents and missing or suppressed measures are labeled. Counts describe outlets and systems separately, not a combined location total. Coordinates may identify a service base or approximate location. This is an annual reference, not a live opening-hours service.

Every tier includes UTF-8 CSV, JSON and a SQLite database containing its included tables. Historical websites are explicitly dated 2003 and unverified. Academic, school and federal library populations and territories are outside this release.

17,415 Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Public Schools Colleges Private Schools School Districts Junior Colleges Technical Schools

Table Schema Database Field Statistics

Release structure

U.S. Public Libraries Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#46
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
library_outlets17415outlet_id, system_id, outlet_name, system_name, outlet_type, address, city, state_code, postal_code, postal_extension, county_name, phone, latitude, longitude, coordinate_method, meets_public_library_definition, reporting_status, system_reporting_status, reporting_year, floor_area_sq_ft, floor_area_sq_ft_status, annual_open_hours, annual_open_hours_status, weeks_open, weeks_open_status, bookmobile_count, bookmobile_count_status
library_systems9205system_id, system_name, address, city, state_code, postal_code, postal_extension, mailing_address, mailing_city, mailing_postal_code, mailing_postal_extension, county_name, phone, latitude, longitude, coordinate_method, legal_basis, administrative_structure, meets_public_library_definition, reporting_status, reporting_year, period_start, period_end
library_finances9205system_id, reporting_year, period_start, period_end, population_served, population_served_status, librarians_with_masters_fte, librarians_with_masters_fte_status, librarians_fte, librarians_fte_status, other_staff_fte, other_staff_fte_status, total_staff_fte, total_staff_fte_status, local_operating_revenue, local_operating_revenue_status, state_operating_revenue, state_operating_revenue_status, federal_operating_revenue, federal_operating_revenue_status, other_operating_revenue, other_operating_revenue_status, total_operating_revenue, total_operating_revenue_status, salaries_expenditure, salaries_expenditure_status, benefits_expenditure, benefits_expenditure_status, staff_expenditure, staff_expenditure_status, print_material_expenditure, print_material_expenditure_status, electronic_material_expenditure, electronic_material_expenditure_status, other_material_expenditure, other_material_expenditure_status, collection_expenditure, collection_expenditure_status, other_operating_expenditure, other_operating_expenditure_status, total_operating_expenditure, total_operating_expenditure_status, local_capital_revenue, local_capital_revenue_status, state_capital_revenue, state_capital_revenue_status, federal_capital_revenue, federal_capital_revenue_status, other_capital_revenue, other_capital_revenue_status, total_capital_revenue, total_capital_revenue_status, capital_expenditure, capital_expenditure_status
library_services9205system_id, reporting_year, period_start, period_end, print_volumes, print_volumes_status, physical_audio, physical_audio_status, physical_video, physical_video_status, other_physical_items, other_physical_items_status, total_physical_items, total_physical_items_status, annual_open_hours, annual_open_hours_status, annual_visits, annual_visits_status, reference_transactions, reference_transactions_status, registered_borrowers, registered_borrowers_status, total_circulation, total_circulation_status, physical_circulation, physical_circulation_status, electronic_circulation, electronic_circulation_status, ebook_circulation, ebook_circulation_status, electronic_serial_circulation, electronic_serial_circulation_status, electronic_audio_circulation, electronic_audio_circulation_status, electronic_video_circulation, electronic_video_circulation_status, children_physical_circulation, children_physical_circulation_status, interlibrary_loans_supplied, interlibrary_loans_supplied_status, interlibrary_loans_received, interlibrary_loans_received_status, total_programs, total_programs_status, programs_ages_0_5, programs_ages_0_5_status, programs_ages_6_11, programs_ages_6_11_status, young_adult_programs, young_adult_programs_status, adult_programs, adult_programs_status, general_interest_programs, general_interest_programs_status, onsite_programs, onsite_programs_status, offsite_programs, offsite_programs_status, live_virtual_programs, live_virtual_programs_status, total_program_attendance, total_program_attendance_status, attendance_ages_0_5, attendance_ages_0_5_status, attendance_ages_6_11, attendance_ages_6_11_status, young_adult_attendance, young_adult_attendance_status, adult_attendance, adult_attendance_status, general_interest_attendance, general_interest_attendance_status, onsite_attendance, onsite_attendance_status, offsite_attendance, offsite_attendance_status, live_virtual_attendance, live_virtual_attendance_status, recorded_presentations, recorded_presentations_status, recorded_presentation_views, recorded_presentation_views_status, public_internet_computers, public_internet_computers_status, public_computer_uses, public_computer_uses_status, wifi_sessions, wifi_sessions_status
historical_websites3803system_id, system_name, historical_website, fact_year, fact_status

Release at a glance

What is inside this database

Review verified record totals, geographic coverage, classifications, and field completeness for U.S. Public Libraries Database.

17,415Operating outlets
9,205System profiles
51States and D.C.
2,024Reporting year

Geographic coverage

This release represents 51 state or territory codes. The 12 largest totals are shown below.

  • CA1,226
  • NY1,068
  • TX891
  • IL794
  • OH784
  • MI663
  • PA626
  • IA574
  • FL557
  • WI466
  • MA463
  • IN453

Table and column statistics

Select a table to review its own schema, record total, fields, distinct values, and missing-value coverage.

library outlets17,415 records · 27 fields
outlet_id
Distinct
17,415
Missing
0 (0.0%)
system_id
Distinct
9,202
Missing
0 (0.0%)
outlet_name
Distinct
15,874
Missing
0 (0.0%)
system_name
Distinct
8,427
Missing
0 (0.0%)
outlet_type
Distinct
4
Missing
0 (0.0%)
address
Distinct
16,467
Missing
0 (0.0%)
city
Distinct
9,076
Missing
0 (0.0%)
state_code
Distinct
51
Missing
0 (0.0%)
postal_code
Distinct
15,300
Missing
0 (0.0%)
postal_extension
Distinct
5,987
Missing
1,407 (8.1%)
county_name
Distinct
1,802
Missing
0 (0.0%)
phone
Distinct
16,155
Missing
98 (0.6%)
latitude
Distinct
16,741
Missing
0 (0.0%)
longitude
Distinct
16,744
Missing
0 (0.0%)
coordinate_method
Distinct
11
Missing
0 (0.0%)
meets_public_library_definition
Distinct
2
Missing
0 (0.0%)
reporting_status
Distinct
2
Missing
0 (0.0%)
system_reporting_status
Distinct
3
Missing
0 (0.0%)
reporting_year
Distinct
1
Missing
0 (0.0%)
floor_area_sq_ft
Distinct
6,769
Missing
831 (4.8%)
floor_area_sq_ft_status
Distinct
4
Missing
0 (0.0%)
annual_open_hours
Distinct
2,848
Missing
193 (1.1%)
annual_open_hours_status
Distinct
3
Missing
0 (0.0%)
weeks_open
Distinct
54
Missing
172 (1.0%)
weeks_open_status
Distinct
3
Missing
0 (0.0%)
bookmobile_count
Distinct
6
Missing
0 (0.0%)
bookmobile_count_status
Distinct
1
Missing
0 (0.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

library outletsDownload this sample CSV
outlet_idsystem_idoutlet_namesystem_nameoutlet_typeaddresscitystate_codepostal_codepostal_extensioncounty_namephonelatitudelongitudecoordinate_methodmeets_public_library_definitionreporting_statussystem_reporting_statusreporting_yearfloor_area_sq_ftfloor_area_sq_ft_statusannual_open_hoursannual_open_hours_statusweeks_openweeks_open_statusbookmobile_countbookmobile_count_status
LIB-00006258405ef9f3LIB-eadcd6966523c3f7OAKLAND PUBLIC LIBRARYYALOBUSHA COUNTY LIBRARYbranch_library324 HOLLY STREETOAKLANDMS389482886YALOBUSHA662623865134.05601496-89.91484829POINTADDRESSTruein_survey_framein_survey_frame20241680reported988reported52reported0reported
LIB-0cad6696b1e14ab5LIB-270560248a1a7251DUPONT LIBRARYPIERCE COUNTY LIBRARY SYSTEMbranch_library1540 WILMINGTON DRIVEDUPONTWA983278771PIERCE253548332647.09158711-122.6443405POINTADDRESSTruein_survey_framein_survey_frame20243610reported2492reported52reported0reported
LIB-198530218a4eb3f5LIB-735e140603548b33PEARLE L. CRAWFORD MEMORIAL LIBRARYPEARLE L. CRAWFORD MEMORIAL LIBRARYcentral_library40 SCHOFIELD AVE.DUDLEYMA015713264WORCESTER508949802142.04406357-71.89089211POINTADDRESSTruein_survey_framein_survey_frame202416750reported2202reported52reported0reported
LIB-2654845409619ed8LIB-2177f42643e29c5cROBERT J KLEBERG PUBLIC LIBRARYROBERT J KLEBERG PUBLIC LIBRARYcentral_library220 N 4TH STKINGSVILLETX783634410KLEBERG361592638127.51839074-97.87063596POINTADDRESSTruein_survey_framein_survey_frame202410250reported2124reported52reported0reported
LIB-33241f859a574cb2LIB-f86d61f705f2b55cATLANTIC PUBLIC LIBRARYATLANTIC PUBLIC LIBRARYcentral_library507 POPLAR STATLANTICIA500221254CASS712243546641.40538413-95.01444244POINTADDRESSTruein_survey_framein_survey_frame202413000reported2585reported52reported0reported
LIB-3fd5b8190d40d49aLIB-64553bb2f13c9b48DEER PARKCINCINNATI AND HAMILTON COUNTY PUBLIC LIBRARYbranch_library4020 E. GALBRAITH RD.DEER PARKOH452362324HAMILTON513369445039.20864108-84.40123741POINTADDRESSTruein_survey_framein_survey_frame202424934reported3328reported52reported0reported
LIB-4c383b553b0b3edaLIB-a5231f4f2a530ae6NEWTON COUNTY PUBLIC LIBRARYNEWTON COUNTY PUBLIC LIBRARYcentral_library212 HIGH STNEWTONTX759663216NEWTON409379830030.84972946-93.75939174POINTADDRESSTruein_survey_framein_survey_frame20249180reported1952reported52reported0reported
LIB-5921785d15e7c9b7LIB-d0bead1dc83fcbbcLAWRENCE PUBLIC LIBRARY DISTRICTLAWRENCE PUBLIC LIBRARY DISTRICTcentral_library814 12TH STREETLAWRENCEVILLEIL624392706LAWRENCE618943301638.72793197-87.68317411POINTADDRESSTruein_survey_framein_survey_frame20248937reported2130reported52reported0reported
LIB-6690e9dbcdba6400LIB-f41bc162d0680899ATHERTON LIBRARYSAN MATEO COUNTY LIBRARIESbranch_library2 DINKELSPIEL STATION LANEATHERTONCA940273801SAN MATEO833937762537.46344376-122.1968461POINTADDRESSTruein_survey_framein_survey_frame202411460reported2981reported52reported0reported
LIB-729bed4ad92f55f8LIB-0a42fa526d4d0cbaLEWISTON PUBLIC LIBRARYLEWISTON PUBLIC LIBRARYcentral_library200 LISBON STREETLEWISTONME042407234ANDROSCOGGIN207513300444.09532168-70.21638483POINTADDRESSTruein_survey_framein_survey_frame202446000reported2600reported52reported0reported
LIB-7fc98b196362444fLIB-40a4e90ca23c1ee8LES CHENEAUX COMMUNITY LIBRARYSUPERIOR DISTRICT LIBRARYbranch_library75 EAST HODECK STREETCEDARVILLEMI49719MACKINAC906484354745.99632279-84.3614273STREETADDRESSTruein_survey_framein_survey_frame20246000reported2002reported52reported0reported
LIB-8be49ae9aff49a4bLIB-1f68fdbc2b844ec6LOS LUNAS MUSEUM OF HERITAGE & ARTSLOS LUNAS PUBLIC LIBRARYbranch_library251 MAIN ST. SELOS LUNASNM870317316VALENCIA505352772034.8068275-106.7339478POINTADDRESSTruein_survey_framein_survey_frame20243242reported1820reported52reported0reported
LIB-97f467e524ca615fLIB-b6d962c88ad3dcedPERQUIMANS COUNTY LIBRARYPETTIGREW REGIONAL LIBRARYbranch_library514 S. CHURCH STREETHERTFORDNC279441225PERQUIMANS252426531936.18263623-76.46502685POINTADDRESSTruein_survey_framein_survey_frame202414705reported2269reported52reported0reported
LIB-a5dad3bd92212a1cLIB-2bac67cab2b32582CARTHAGE FREE LIBRARYCARTHAGE FREE LIBRARYcentral_library412 BUDD STREETCARTHAGENY136191287JEFFERSON315493262043.97982786-75.60947409POINTADDRESSTruein_survey_framein_survey_frame20248343reported2392reported52reported0reported
LIB-b2950b8c9f8777cfLIB-352d4581c84940aaDECATUR BRANCH LIBRARYINDIANAPOLIS PUBLIC LIBRARYbranch_library5301 KENTUCKY AVENUEINDIANAPOLISIN462213617MARION317275433039.68727872-86.27904507POINTADDRESSTruein_survey_framein_survey_frame202411500reported2652reported52reported0reported
LIB-bfad50dd8d35c2c4LIB-574fe55726ae1d5bLAKES OF THE MEADOW BRANCH LIBRARYMIAMI-DADE PUBLIC LIBRARY SYSTEMbranch_library4284 SOUTHWEST 152 AVENUEMIAMIFL33185MIAMI-DADE305222214925.72670936-80.43960572POINTADDRESSTruein_survey_framein_survey_frame20243596reported2893reported52reported0reported
LIB-cd88be2aab6cab66LIB-7ca06203b8b0a155ALTAMONT FREE LIBRARYALTAMONT FREE LIBRARYcentral_library179 MAIN STREETALTAMONTNY120097714ALBANY518861723942.70119468-74.03307338POINTADDRESSTruein_survey_framein_survey_frame20242000reported2479reported52reported0reported
LIB-da9d0e59f6da3312LIB-a5c1e01027a12f90KANOPOLIS PUBLIC LIBRARYKANOPOLIS PUBLIC LIBRARYcentral_library221 N. KANSASKANOPOLISKS674549589ELLSWORTH785472305338.71227261-98.15788269POINTADDRESSTruein_survey_framein_survey_frame2024897reported626reported50reported0reported
LIB-e794e7e37d1248c4LIB-e4746a5db4d2ea40AVON PUBLIC LIBRARYAVON PUBLIC LIBRARYcentral_library116 N. MAIN STREETAVONSD573152135BON HOMME605286376043.00433727-98.06009681POINTADDRESSTruein_survey_framein_survey_frame20242033reported1300reported52reported0reported
LIB-f40ca553626580deLIB-ed8158a45e8ac50cHUDSON LIBRARY AND HISTORICAL SOCIETYHUDSON LIBRARY AND HISTORICAL SOCIETYcentral_library96 LIBRARY STREETHUDSONOH442365122SUMMIT330653665841.24163435-81.44309237POINTADDRESSTruein_survey_framein_survey_frame202455000reported3328reported52reported0reported

Records Information

17,415 operating outlets; 9,205 system profiles, of which five are temporarily closed; 9,205 annual finance profiles; 9,205 annual service profiles; 3,803 dated historical website references. Related rows are not added to the location count.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Build a broader dataset

Extend this dataset around your project

Combine this database with compatible business, location, or specialty records. Oddity can also scope a custom package by geography, fields, format, and intended use.

Related datasetsField selectionCustom geography
Explore compatible data Discuss a custom package

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details