item_view (view)
4 rows where location_code = "1panf"
This data as json, CSV (advanced)
Suggested facets: item_status_name, checkout_total, renewal_total, item_price, publish_year, creation_date (date), last_circ_act_date (date), checkout_date (date), due_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11335250 | 3617225 | 2021-08-23 | A000073796726 | Book | 1panf | Main - 1st Floor - Popular Library - Nonfiction | Main Library | 700.94309 e58 2021 | English, Charlie, author. | The gallery of miracles and madness : insanity, modernism, and Hitler's war on art | 1 | - | CHECK SHELVES | 2022-03-19 | 2 | 0 | 28.0 | 2021 | ||||
| 11431333 | 3679230 | 2021-10-27 | A000074290133 | Book | 1panf | Main - 1st Floor - Popular Library - Nonfiction | Main Library | 741.5973 m391 zw 2021 | Wolk, Douglas, author. | All of the marvels : a journey to the ends of the biggest story ever told | 1 | n | BILLED | 2022-04-15 | 2022-04-15 | 2022-08-19 | 2 | 4 | 28.0 | 2021 | ||
| 10618865 | 2536711 | 2019-11-18 | A000067005522 | Book | 1panf | Main - 1st Floor - Popular Library - Nonfiction | Main Library | 813.010803 m678 2009 | Missionary no more : purple panties II, an eroticanoir.com anthology | 1 | n | BILLED | 2019-12-29 | 2019-12-29 | 2020-11-17 | 1 | 8 | 16.99 | 2009 | |||
| 11545257 | 3718534 | 2022-02-11 | A000074382229 | Book | 1panf | Main - 1st Floor - Popular Library - Nonfiction | Main Library | 202.3 p481 2022 | Peters, William J., author. | At heaven's door : what shared journeys to the afterlife teach about dying well and living better | 1 | w | WITHDRAWN | 2023-06-16 | 4 | 4 | 26.0 | 2022 |
Advanced export
JSON shape: default, array, newline-delimited
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;