About this Dataset

Oregon Public Library Statistics

The State Library of Oregon collects annual service measures, financial data, and other statistics from all legally-established public libraries in the state, as per Oregon Revised Statue 357.520 (Annual report). The data reporting period matches the state fiscal year (July 1 through June 30). This dataset includes all Oregon Public Library Statistical Report data from each year starting in FY2009-2010, and is updated annually. Reporting periods are identified as the year the report was submitted (i.e., FY2009-2010 data is identified as 2010 in the Year column).
Organization: State of Oregon
Last updated: 2023-05-20T11:16:02.465218

Tables

Table 1

@usgov.state_of_oregon_oregon_public_library_statistics.table_1

769.32 kB
2,047 rows
181 columns

CREATE TABLE table_1 (
  "libid" VARCHAR,
  "year" BIGINT,
  "libraryname" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "zip" DOUBLE,
  "mailingaddress" VARCHAR,
  "mailingcity" VARCHAR,
  "mailingzip" DOUBLE,
  "county" VARCHAR,
  "phone" VARCHAR,
  "distcoop" VARCHAR,
  "centrallibrary" BIGINT,
  "branches" BIGINT,
  "bookmobiles" BIGINT,
  "registeredusers" DOUBLE,
  "registeredusersadded" DOUBLE,
  "librariansalamls" DOUBLE,
  "librarianstotal" DOUBLE,
  "otherstaff" DOUBLE,
  "volunteers" DOUBLE,
  "volunteerhours" DOUBLE,
  "friendsgroup" VARCHAR,
  "foundation" VARCHAR,
  "staffpositionsft" DOUBLE,
  "staffpositionsptunder20" DOUBLE,
  "staffpositionsptover20" DOUBLE,
  "staffpositionstemponcall" DOUBLE,
  "revenuecity" DOUBLE,
  "revenuecounty" DOUBLE,
  "revenuedistrict" DOUBLE,
  "revenuestate" DOUBLE,
  "revenuelsta" DOUBLE,
  "revenueerate" VARCHAR,
  "revenueotherfed" DOUBLE,
  "revenueotheroperating" DOUBLE,
  "captialrevenuelocal" DOUBLE,
  "capitalrevenuestate" DOUBLE,
  "capitalrevenuefed" DOUBLE,
  "capitalrevenueother" DOUBLE,
  "expendituressalarieswages" DOUBLE,
  "expendituresbenefits" DOUBLE,
  "expendituresprintmaterials" DOUBLE,
  "expendituresperiodicals" DOUBLE,
  "expenditureselectronicmaterials" DOUBLE,
  "expendituresothermaterials" DOUBLE,
  "expendituresotheroperating" DOUBLE,
  "expendituresservicecharges" VARCHAR,
  "capitalexpendituresconstruction" DOUBLE,
  "capitalexpendituresequipment" DOUBLE,
  "capitalexpendituresother" DOUBLE,
  "collectionbooks" DOUBLE,
  "collectionbooksadded" DOUBLE,
  "collectionphysicalaudio" DOUBLE,
  "collectionphysicalaudioadded" DOUBLE,
  "collectionvideosphysical" DOUBLE,
  "collectionvideosphysicaladded" DOUBLE,
  "collectionothermaterials" DOUBLE,
  "collectionothermaterialsadded" DOUBLE,
  "collectionebooksodlc" DOUBLE,
  "collectionebooksodlcadded" DOUBLE,
  "collectionebookslocal" DOUBLE,
  "collectionebookslocaladded" DOUBLE,
  "collectionaudiobooksodlc" DOUBLE,
  "collectionaudiobooksodlcadded" DOUBLE,
  "collectionaudiobookslocal" DOUBLE,
  "collectionaudiobookslocaladded" DOUBLE,
  "collectiondigitalvideosodlc" DOUBLE,
  "collectiondigitalvideosodlcadded" DOUBLE,
  "collectiondigitalvideoslocal" DOUBLE,
  "collectiondigitalvideoslocaladded" DOUBLE,
  "collectionphysicalspanish" DOUBLE,
  "collectiondigitalspanish" DOUBLE,
  "collectionotherlanguages" VARCHAR,
  "collectiondatabaseslocal" DOUBLE,
  "collectiondatabaseslocaladded" DOUBLE,
  "collectionstatewidedatabases" DOUBLE,
  "collectionstatewidedatabasesadded" DOUBLE,
  "databaseusagestatewide" DOUBLE,
  "databaseusagelocal" DOUBLE,
  "circadult" DOUBLE,
  "circadultrenewals" DOUBLE,
  "circya" DOUBLE,
  "circyarenewals" DOUBLE,
  "circchildrens" DOUBLE,
  "circchildrensrenewals" DOUBLE,
  "circothermaterials" DOUBLE,
  "circothermaterialsrenewals" DOUBLE,
  "circnoagecategory" DOUBLE,
  "circnoagecategoryrenewals" DOUBLE,
  "circodlc" DOUBLE,
  "circecontentlocal" DOUBLE,
  "circnetworkloans" DOUBLE,
  "circillloans" DOUBLE,
  "circnetworkborrows" DOUBLE,
  "circillborrows" DOUBLE,
  "circnonresidents" DOUBLE,
  "referencetransactions" DOUBLE,
  "referencetransactionsmethod" VARCHAR,
  "meetingroomuse" DOUBLE
);