Dataset: Library Usage

About this Dataset

Library Usage

The Integrated Library System (ILS) is composed of bibliographic records including inventoried items, and patron records including circulation data.
The data is used in the daily operation of the library, including circulation, online public catalog, cataloging, acquisitions, collection development, processing, and serials control.
This dataset represents the usage of inventoried items by active patrons. Per the California State Library definition, San Francisco Public Library defines active patrons as a) patrons with unexpired library cards and b) patrons who had circulation activity within the last three years.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:51.322149
Tags: circulation, library, patron

Tables

Table 1

@usgov.city_of_san_francisco_library_usage.table_1

1.94 MB
450359 rows
11 columns


CREATE TABLE table_1 (
  "patron_type_definition" VARCHAR,
  "total_checkouts" BIGINT,
  "total_renewals" BIGINT,
  "age_range" VARCHAR,
  "home_library_definition" VARCHAR,
  "circulation_active_month" VARCHAR,
  "circulation_active_year" VARCHAR,
  "notice_preference_definition" VARCHAR,
  "provided_email_address" BOOLEAN,
  "year_patron_registered" BIGINT,
  "within_san_francisco_county" VARCHAR
);