item_view (view)
8 rows where location_code = "1cjwb"
This data as json, CSV (advanced)
Suggested facets: item_callnumber, item_status_name, last_circ_act_date, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11117084 | 3589507 | 2021-03-31 | A000071845350 | Audio Enabled Juvenile Book | 1cjwb | Main - 1st Floor - Popular Library - Wonderbooks | Main Library | wb easy | Blabey, Aaron, author. | Pig the winner | 1 | $ | LOST AND PAID | 2023-05-28 | 1 | 5 | 44.99 | 2021 | ||||
| 10973926 | 3566429 | 2020-11-23 | A000069035824 | Audio Enabled Juvenile Book | 1cjwb | Main - 1st Floor - Popular Library - Wonderbooks | Main Library | wb easy | Cline-Ransome, Lesa, author. | Overground railroad | 1 | - | CHECK SHELVES | 2020-12-29 | 2020-12-29 | 2021-07-13 | 1 | 8 | 54.99 | 2020 | ||
| 10473574 | 3452666 | 2019-07-25 | A000064772983 | Audio Enabled Juvenile Book | 1cjwb | Main - 1st Floor - Popular Library - Wonderbooks | Main Library | wb s b easy | Brown, Monica, 1969- author. | Marisol McDonald and the monster | 1 | - | CHECK SHELVES | 2019-10-01 | 2019-10-01 | 2020-07-06 | 2 | 4 | 41.84 | 2019 | ||
| 10473530 | 3452649 | 2019-07-25 | A000065491013 | Audio Enabled Juvenile Book | 1cjwb | Main - 1st Floor - Popular Library - Wonderbooks | Main Library | wb easy | Levine, Ellen, author. | Henry's freedom box | 1 | e | EXCUSED LOSS | 2024-11-14 | 1 | 1 | 37.19 | 2019 | ||||
| 10473564 | 3452664 | 2019-07-25 | A000064783063 | Audio Enabled Juvenile Book | 1cjwb | Main - 1st Floor - Popular Library - Wonderbooks | Main Library | wb easy | de la Pena, Matt, author, narrator. | Love | 1 | e | EXCUSED LOSS | 2024-11-21 | 2 | 1 | 46.49 | 2019 | ||||
| 11105878 | 3589499 | 2021-03-19 | A000072160775 | Audio Enabled Juvenile Book | 1cjwb | Main - 1st Floor - Popular Library - Wonderbooks | Main Library | wb easy | Arnold, Tedd, author, illustrator. | I spy Fly Guy! | 1 | n | BILLED | 2021-06-16 | 2021-06-16 | 2021-09-29 | 1 | 3 | 39.99 | 2021 | ||
| 10473605 | 3452678 | 2019-07-25 | A000064771381 | Audio Enabled Juvenile Book | 1cjwb | Main - 1st Floor - Popular Library - Wonderbooks | Main Library | wb easy | Brown, Peter, author. | You Will Be My Friend! | 1 | z | CLMS RETD | 2024-01-31 | 3 | 1 | 46.49 | 2019 | ||||
| 10473572 | 3452665 | 2019-07-25 | A000064772975 | Audio Enabled Juvenile Book | 1cjwb | Main - 1st Floor - Popular Library - Wonderbooks | Main Library | wb s l easy | Colato Lainez, Rene, author, translator. | Mama the alien | 1 | z | CLMS RETD | 2024-01-31 | 4 | 8 | 41.84 | 2019 |
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;