item_view (view)
12 rows where location_code = "1bacn"
This data as json, CSV (advanced)
Suggested facets: item_format, item_status_name, last_circ_act_date, checkout_total, renewal_total, item_price, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12344826 | 3844793 | 2024-01-31 | A000082410111 | Book | 1bacn | DO NOT USE | Main Library | fiction | Tan, Sue Lynn, author. | Tales of the celestial kingdom | 1 | - | CHECK SHELVES | 0 | 0 | 24.99 | 2024 | |||||
| 12368405 | 3849170 | 2024-02-21 | A000082210909 | Book | 1bacn | DO NOT USE | Main Library | fiction | St. James, Simone, author. | Murder road | 1 | - | CHECK SHELVES | 2025-02-03 | 7 | 0 | 29.0 | 2024 | ||||
| 12395634 | 3851172 | 2024-03-19 | A000082572258 | Book | 1bacn | DO NOT USE | Main Library | fiction | Flower, Amanda, author. | To slip the bonds of Earth | 1 | - | CHECK SHELVES | 2024-08-31 | 3 | 3 | 27.0 | 2024 | ||||
| 12413463 | 3857507 | 2024-04-08 | A000083305096 | Book | 1bacn | DO NOT USE | Main Library | fiction | Higgins, Marissa, author. | A good happy girl : a novel | 1 | - | CHECK SHELVES | 2025-02-03 | 4 | 1 | 27.0 | 2024 | ||||
| 12441661 | 3875029 | 2024-05-07 | A000082860968 | Book | 1bacn | DO NOT USE | Main Library | fiction | Pruitt, Eryk, author. | Blood red summer : a thriller | 1 | - | CHECK SHELVES | 2024-08-31 | 2 | 2 | 16.99 | 2024 | ||||
| 12462154 | 3877626 | 2024-05-28 | A000083396012 | Book | 1bacn | DO NOT USE | Main Library | fiction | Goldman, Matt, 1962- author. | Still waters | 1 | - | CHECK SHELVES | 2025-02-03 | 3 | 1 | 18.99 | 2024 | ||||
| 12464538 | 3885869 | 2024-05-30 | A000083547465 | Book | 1bacn | DO NOT USE | Main Library | fiction | Hays, Kim (Mystery fiction writer), author. | A fondness for truth | 1 | - | CHECK SHELVES | 2025-02-03 | 3 | 0 | 19.95 | 2024 | ||||
| 12476077 | 3879570 | 2024-06-11 | A000083451999 | Book | 1bacn | DO NOT USE | Main Library | fiction | Hilliard, M. E., author. | Smoke and mirrors | 1 | - | CHECK SHELVES | 2024-08-31 | 2 | 0 | 30.0 | 2024 | ||||
| 12486573 | 3879653 | 2024-06-25 | A000083495467 | Book | 1bacn | DO NOT USE | Main Library | fiction | Casey, Jane (Jane E.), author. | A stranger in the family | 1 | - | CHECK SHELVES | 2024-08-31 | 4 | 0 | 30.0 | 2024 | ||||
| 12506863 | 3882454 | 2024-07-12 | A000083770679 | Book | 1bacn | DO NOT USE | Main Library | fiction | Pearse, Sarah, author. https://id.oclc.org/worldcat/entity/E39PBJyx9Qw7Wwpjx7XpmxcByd | The wilds : a novel | 1 | - | CHECK SHELVES | 2024-08-31 | 2 | 0 | 30.0 | 2024 | ||||
| 12494745 | 3581092 | 2024-07-01 | A000083711665 | Book | 1bacn | DO NOT USE | Main Library | fiction | Wilson, Diane, 1954- author. | The seed keeper : a novel | 1 | m | MISSING | 2025-01-13 | 4 | 2 | 18.0 | 2021 | ||||
| 12330534 | 3841049 | 2024-01-17 | A000082737448 | Large Print Book | 1bacn | DO NOT USE | Main Library | fiction | Segura, Jo, author. | Raiders of the lost heart | 1 | - | CHECK SHELVES | 0 | 0 | 35.99 | 2024 |
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;