item_view (view)

6 rows where location_code = "1cjbg"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: item_callnumber, item_status_name, last_circ_act_date, creation_date (date), last_circ_act_date (date)

item_record_num volume_record_num bib_record_num creation_date barcode item_format location_code location_name branch_name item_callnumber vol_statement best_author best_title agency_code_num item_status_code item_status_name last_circ_act_date checkout_date due_date checkout_total renewal_total item_price publish_year
8715070   3109552 2016-02-15 A000049592744 Juvenile Book 1cjbg Main - 1st Floor - Children's Library - Big Books Main Library 398.2 ffg149 ru 2015   Galdone, Paul, author, illustrator. Rumpelstiltskin 1 e EXCUSED LOSS 2025-07-01     6 9 26.99 2015
7278685   2881285 2013-08-26 A000036306579 Juvenile Book 1cjbg Main - 1st Floor - Children's Library - Big Books Main Library 551.5 ffm685 2004   Mitten, Luana K. Air around us 1 e EXCUSED LOSS 2025-07-01     11 27 20.96 2004
3357343   2356282 2012-06-30 1562460-15003 Juvenile Book 1cjbg Main - 1st Floor - Children's Library - Big Books Main Library easy   Allinson, Beverley. Effie 1 e EXCUSED LOSS 2025-06-25     12 12 19.95 1990
7260654   2356251 2013-08-14 A000038420634 Juvenile Book 1cjbg Main - 1st Floor - Children's Library - Big Books Main Library easy   Bunting, Eve, 1928-2023. Flower garden 1 e EXCUSED LOSS 2025-06-25     16 24 26.95 1999
7260689   1559803 2013-08-14 A000038420659 Juvenile Book 1cjbg Main - 1st Floor - Children's Library - Big Books Main Library easy   Pfister, Marcus. The rainbow fish 1 e EXCUSED LOSS 2025-07-01     26 53 25.0 1995
8697711   1415806 2016-02-09 A000046978102 Juvenile Book 1cjbg Main - 1st Floor - Children's Library - Big Books Main Library easy   Rey, H. A. (Hans Augusto), 1898-1977 Curious George 1 w WITHDRAWN 2024-09-11     10 16 27.0 1993

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW item_view AS select
  item.item_record_num,
  item.volume_record_num,
  item.bib_record_num,
  item.creation_date,
  item.barcode,
  item.item_format,
  item.location_code,
  location_name."name" as location_name,
  branch_name."name" as branch_name,
  item.item_callnumber,
  item.volume_record_statement as vol_statement,
  bib.best_author,
  bib.best_title,
  item.agency_code_num,
  item.item_status_code,
  item_status_property.item_status_name,
  coalesce(
    item.checkout_date,
    item.last_checkin_date,
    item.last_checkout_date
  ) as last_circ_act_date,
  item.checkout_date,
  item.due_date,
  item.checkout_total,
  item.renewal_total,
  item.price_cents / 100.0 as item_price,
  bib.publish_year
from
  item
  left outer join bib on bib.bib_record_num = item.bib_record_num
  left outer join location on location.code = item.location_code
  left outer join location_name on location_name.location_id = location.id
  left outer join branch on branch.code_num = location.branch_code_num
  left outer join branch_name on branch_name.branch_id = branch.id
  left outer join item_status_property on item_status_property.item_status_code = item.item_status_code;