Checkouts By Title (Physical Items)
This dataset includes a log of all physical item checkouts from Seattle Public Library. The dataset begins with checkouts that occurring in April 2005. Data from 2005 to 2016 in this dataset is from digital artwork "Making Visible the Invisible" by studios of George Legrady. Learn more about this contribution. Renewals are not included. Have a question about this data? Ask us!
Data Notes:
There is a machine-readable data dictionary available to help you understand the collection and item codes. Access from here:
https://data.seattle.gov/Community/Integrated-Library-System-ILS-Data-Dictionary/pbt3-ytbc
Also:
1. "CheckoutDateTime" (the timestamp field) is rounded to the nearest minute.
2. "itemType" is a code from the catalog record that describes the type of item. Some of the more common codes are: acbk (adult book), acdvd (adult DVD), jcbk (children's book), accd (adult CD)
3. "Collection" is a collection code from the catalog record which describes the item. Here are some common examples: nanf (adult non-fiction), nafic(adult fiction), ncpic(children's picture book), nycomic (Young adult comic books).
4. "Subjects" includes the subjects and subject subdivisions from the item record.
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| contactPoint |
{
"fn": "David Christensen",
"@type": "vcard:Contact",
"hasEmail": "mailto:open.data@seattle.gov"
}
|
| description | This dataset includes a log of all physical item checkouts from Seattle Public Library. The dataset begins with checkouts that occurring in April 2005. Data from 2005 to 2016 in this dataset is from digital artwork "Making Visible the Invisible" by studios of George Legrady. <a href="https://shelftalkblog.wordpress.com/2022/12/06/how-a-digital-artwork-helped-the-seattle-public-library-lead-in-book-data">Learn more</a> about this contribution. Renewals are not included. Have a question about this data? Ask us! Data Notes: There is a machine-readable data dictionary available to help you understand the collection and item codes. Access from here: https://data.seattle.gov/Community/Integrated-Library-System-ILS-Data-Dictionary/pbt3-ytbc Also: 1. "CheckoutDateTime" (the timestamp field) is rounded to the nearest minute. 2. "itemType" is a code from the catalog record that describes the type of item. Some of the more common codes are: acbk (adult book), acdvd (adult DVD), jcbk (children's book), accd (adult CD) 3. "Collection" is a collection code from the catalog record which describes the item. Here are some common examples: nanf (adult non-fiction), nafic(adult fiction), ncpic(children's picture book), nycomic (Young adult comic books). 4. "Subjects" includes the subjects and subject subdivisions from the item record. |
| distribution |
[
{
"@type": "dcat:Distribution",
"mediaType": "application/json",
"describedBy": "https://cos-data.seattle.gov/api/views/5src-czff/columns.json",
"downloadURL": "https://cos-data.seattle.gov/api/views/5src-czff/rows.json?accessType=DOWNLOAD",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"mediaType": "application/rdf+xml",
"describedBy": "https://cos-data.seattle.gov/api/views/5src-czff/columns.rdf",
"downloadURL": "https://cos-data.seattle.gov/api/views/5src-czff/rows.rdf?accessType=DOWNLOAD",
"describedByType": "application/rdf+xml"
},
{
"@type": "dcat:Distribution",
"mediaType": "application/xml",
"describedBy": "https://cos-data.seattle.gov/api/views/5src-czff/columns.xml",
"downloadURL": "https://cos-data.seattle.gov/api/views/5src-czff/rows.xml?accessType=DOWNLOAD",
"describedByType": "application/xml"
},
{
"@type": "dcat:Distribution",
"mediaType": "text/csv",
"downloadURL": "https://cos-data.seattle.gov/api/views/5src-czff/rows.csv?accessType=DOWNLOAD"
}
]
|
| identifier | https://cos-data.seattle.gov/api/views/5src-czff |
| issued | 2017-03-21 |
| keyword |
[
"checkout",
"circulation",
"seattle public library",
"spl"
]
|
| landingPage | https://cos-data.seattle.gov/d/5src-czff |
| modified | 2026-02-14 |
| publisher |
{
"name": "data.seattle.gov",
"@type": "org:Organization"
}
|
| theme |
[
"Community and Culture"
]
|
| title | Checkouts By Title (Physical Items) |
