item_view (view)
6 rows where location_code = "1panr"
This data as json, CSV (advanced)
Suggested facets: item_callnumber, item_status_name, renewal_total, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3053456 | 1298838 | 1272321 | 2012-06-29 | 0957274056028 | Book | 1panr | Main - 1st Floor - Popular Library - Adult New Reader | Main Library | 428.2 qr896 | v.07 | Rubin, Dorothy. | Power English : basic language skills for adults | 1 | - | CHECK SHELVES | 2013-07-09 | 20 | 11 | 5.85 | 1989 | ||
| 3985834 | 1908498 | 2012-06-30 | 1035966856010 | Book | 1panr | Main - 1st Floor - Popular Library - Adult New Reader | Main Library | 610.14 qr529 , 1996 | Richey, Jim. | Medical language : a survival vocabulary | 1 | - | CHECK SHELVES | 2013-04-18 | 6 | 0 | 7.95 | 1996 | ||||
| 4373894 | 1082952 | 2012-06-30 | 0918383456053 | Book | 1panr | Main - 1st Floor - Popular Library - Adult New Reader | Main Library | 612.82 ql796 | Lobb, Nancy. | The five senses | 1 | - | CHECK SHELVES | 8 | 0 | 2.85 | 1982 | |||||
| 3275328 | 1072585 | 2012-06-30 | 0938505656018 | Book | 1panr | Main - 1st Floor - Popular Library - Adult New Reader | Main Library | fiction | Bosley, Judith. | Bride in pink | 1 | - | CHECK SHELVES | 31 | 0 | 3.15 | 1989 | |||||
| 9420795 | 3279029 | 2017-06-06 | A000053330999 | Book | 1panr | Main - 1st Floor - Popular Library - Adult New Reader | Main Library | fiction | McKinlay, Jenn, author. | About a dog | 1 | - | CHECK SHELVES | 2023-07-24 | 5 | 8 | 7.99 | 2017 | ||||
| 9420873 | 3279042 | 2017-06-06 | A000053331286 | Book | 1panr | Main - 1st Floor - Popular Library - Adult New Reader | Main Library | fiction | Johnson, Carrie H., author. | Cold flash | 1 | n | BILLED | 2021-05-24 | 2021-05-24 | 2021-07-05 | 9 | 45 | 9.95 | 2017 |
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;