item_view (view)
17 rows where location_code = "2ttar"
This data as json, CSV (advanced)
Suggested facets: item_format, item_callnumber, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10787516 | 3501707 | 2020-03-11 | A000068859075 | Teen Book | 2ttar | Do Not Use | Main Library | 305.800973 r463 s 2020 | Reynolds, Jason, author. | Stamped : racism, antiracism, and you: a remix of the National Book Award-winning Stamped from the beginning | 1 | - | CHECK SHELVES | 2023-05-09 | 9 | 13 | 18.99 | 2020 | ||||
| 10663180 | 3488771 | 2019-12-13 | A000065327654 | Teen Book | 2ttar | Do Not Use | Main Library | 551 d392 2011 | Denecke, Edward J. | Painless earth science | 1 | - | CHECK SHELVES | 2024-02-11 | 2 | 11 | 11.99 | 2011 | ||||
| 9660746 | 3313148 | 2017-12-05 | A000058011123 | Teen Book | 2ttar | Do Not Use | Main Library | 621.988 k76 2018 | Koch, Melissa, author. | 3D printing : the revolution in personalized manufacturing | 1 | - | CHECK SHELVES | 2019-02-13 | 4 | 2 | 37.32 | 2018 | ||||
| 10483744 | 1505702 | 3469447 | 2019-08-06 | A000062597838 | Teen Book | 2ttar | Do Not Use | Main Library | 741.5 qp973 2018 | v.01 | Pryor, Shawn, author. | F.O.R.C.E. | 1 | - | CHECK SHELVES | 2023-09-30 | 4 | 10 | 9.99 | 2018 | ||
| 10553053 | 1504842 | 3393238 | 2019-09-30 | A000065827117 | Teen Book | 2ttar | Do Not Use | Main Library | 741.5 t337 2018 | v.03 | Teshirogi, Shiori, author, artist. | Batman & the Justice League | 1 | - | CHECK SHELVES | 2020-12-10 | 2 | 6 | 12.99 | 2018 | ||
| 7592908 | 2929721 | 2014-02-24 | A000039458559 | Teen Book | 2ttar | Do Not Use | Main Library | fiction | Bass, Karen, 1962- | Graffiti knight | 1 | - | CHECK SHELVES | 0 | 0 | 14.95 | 2014 | |||||
| 8061242 | 3016848 | 2014-12-15 | A000048062061 | Teen Book | 2ttar | Do Not Use | Main Library | fiction | Dionne, Aubrie, author. | Sleeping Jenny | 1 | - | CHECK SHELVES | 2015-03-23 | 1 | 3 | 9.95 | 2014 | ||||
| 8426926 | 3072016 | 2015-08-25 | A000045170834 | Teen Book | 2ttar | Do Not Use | Main Library | fiction | Green, Dawn, author. | When Kacey left | 1 | - | CHECK SHELVES | 2015-09-14 | 1 | 0 | 12.95 | 2015 | ||||
| 9822681 | 3329677 | 2018-03-27 | A000059870560 | Teen Book | 2ttar | Do Not Use | Main Library | fiction | An, Na, 1972- author. | The place between breaths | 1 | - | CHECK SHELVES | 2023-05-06 | 8 | 10 | 17.99 | 2018 | ||||
| 10184264 | 3392040 | 2018-12-17 | A000064114335 | Teen Book | 2ttar | Do Not Use | Main Library | fiction | Higgins, Wendy, author. | Kiss collector | 1 | - | CHECK SHELVES | 2019-01-11 | 1 | 0 | 9.99 | 2018 | ||||
| 10526824 | 3466237 | 2019-09-11 | A000066130479 | Teen Book | 2ttar | Do Not Use | Main Library | fiction | Tavengerwei, Rutendo, author. | Hope is our only wing | 1 | - | CHECK SHELVES | 2019-11-02 | 1 | 0 | 18.99 | 2018 | ||||
| 11076430 | 3570590 | 2021-02-26 | A000066034317 | Teen Book | 2ttar | Do Not Use | Main Library | fiction | Perez, Marlene, author. | The afterlife of the party | 1 | - | CHECK SHELVES | 0 | 0 | 9.99 | 2021 | |||||
| 11090866 | 3570592 | 2021-03-11 | A000072127253 | Teen Book | 2ttar | Do Not Use | Main Library | fiction | Schumacher, Ashley, author. | Amelia unabridged | 1 | - | CHECK SHELVES | 2021-06-30 | 1 | 0 | 18.99 | 2021 | ||||
| 11114906 | 3571888 | 2021-03-29 | A000072210596 | Teen Book | 2ttar | Do Not Use | Main Library | fiction | Christo, Alexandra, author. | City of spells | 1 | - | CHECK SHELVES | 0 | 0 | 19.99 | 2021 | |||||
| 11144527 | 3571904 | 2021-04-20 | A000066976368 | Teen Book | 2ttar | Do Not Use | Main Library | fiction | Stolarz, Laurie Faria, 1972- author. | The last secret you'll ever keep | 1 | - | CHECK SHELVES | 2022-05-25 | 2 | 0 | 18.99 | 2021 | ||||
| 11168431 | 3576978 | 2021-05-13 | A000072304415 | Teen Book | 2ttar | Do Not Use | Main Library | fiction | Popović, Lana, author. | Poison priestess | 1 | - | CHECK SHELVES | 0 | 0 | 17.99 | 2021 | |||||
| 9412715 | 3280699 | 2017-05-31 | A000053311908 | Teen Large Print Book | 2ttar | Do Not Use | Main Library | 378.198097 qt825 2017 | Trief, Ellen, author. | College bound : a guide for students with visual impairments | 1 | - | CHECK SHELVES | 2019-10-15 | 1 | 0 | 45.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;