item_view (view)

8 rows where location_code = "2mamh"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: best_title, item_status_name, checkout_total, renewal_total, publish_year, 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
12712120 1546856 3138655 2025-02-03 A000081992325 Magazine 2mamh DO NOT USE Main Library periodical Feb 2025   Movers & makers Cincinnati. 1 - CHECK SHELVES 2025-05-05     1 1 5.0 2016
12766947 1544996 2133605 2025-03-31 A000084455825 Magazine 2mamh DO NOT USE Main Library periodical V. 71 NO. 5 May 2025   Guns magazine. 1 - CHECK SHELVES       0 0 5.0 1955
12777700 1544145 1948934 2025-04-10 A000084469867 Magazine 2mamh DO NOT USE Main Library periodical V. 2 NO. 27 Spr 2025   Fangoria. 1 - CHECK SHELVES 2025-07-05     1 0 5.0 1979
12802244 1544997 2133605 2025-05-05 A000084504622 Magazine 2mamh DO NOT USE Main Library periodical V. 71 NO. 6 Jun 2025   Guns magazine. 1 - CHECK SHELVES       0 0 5.0 1955
12823745 1547947 2133605 2025-05-28 A000084534835 Magazine 2mamh DO NOT USE Main Library periodical V. 71 NO. 7 Jul 2025   Guns magazine. 1 - CHECK SHELVES       0 0 5.0 1955
12847140 1544995 2133605 2025-06-25 A000084562240 Magazine 2mamh DO NOT USE Main Library periodical V. 71 NO. 4 Apr 2025   Guns magazine. 1 - CHECK SHELVES       0 0 5.0 1955
12861753 1547948 2133605 2025-07-11 A000084384603 Magazine 2mamh DO NOT USE Main Library periodical V. 71 NO. 8 Aug 2025   Guns magazine. 1 - CHECK SHELVES       0 0 5.0 1955
12724648 1544387 1427448 2025-02-14 A000081980197 Magazine 2mamh DO NOT USE Main Library periodical NO. 222 Spr 2025   Fine gardening. 1 t IN TRANSIT 2025-04-09     2 1 5.0 1988

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;