item_view (view)
10 rows where location_code = "1cjk"
This data as json, CSV (advanced)
Suggested facets: item_status_name, last_circ_act_date, checkout_date, due_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11340859 | 2519972 | 2021-08-27 | A000017509589 | Juvenile Kit | 1cjk | Main - 1st Floor - Children's Library - Kits | Main Library | 372.21 ffc773 2010 | Cookie comprehension [kit]. | 1 | - | CHECK SHELVES | 2021-12-08 | 2021-12-08 | 2025-04-17 | 2 | 6 | 0.0 | 2010 | |||
| 9997230 | 2520036 | 2018-08-09 | A000061762557 | Juvenile Kit | 1cjk | Main - 1st Floor - Children's Library - Kits | Main Library | 372.21 fff532 2010 | Fish counting 1, 2, 3 [kit]. | 1 | - | CHECK SHELVES | 2021-10-07 | 2021-10-07 | 2025-04-17 | 20 | 8 | 60.0 | 2010 | |||
| 9990707 | 3371987 | 2018-08-06 | A000059512527 | Juvenile Kit | 1cjk | Main - 1st Floor - Children's Library - Kits | Main Library | 372.21 ffo585 2018 | 1, 2, 3 ... look at me! [kit] : just for 1's. | 1 | - | CHECK SHELVES | 2021-10-07 | 2021-10-07 | 2025-04-17 | 19 | 12 | 60.0 | 2018 | |||
| 9996654 | 2520028 | 2018-08-09 | A000059512618 | Juvenile Kit | 1cjk | Main - 1st Floor - Children's Library - Kits | Main Library | 372.21 ffb1261 2010 | Backyard discovery [kit]. | 1 | e | EXCUSED LOSS | 2024-11-28 | 8 | 2 | 60.0 | 2010 | |||||
| 9996689 | 3371973 | 2018-08-09 | A000059512667 | Juvenile Kit | 1cjk | Main - 1st Floor - Children's Library - Kits | Main Library | 372.21 ffb263 2018 | Barnyard fun [kit] : just for 1's. | 1 | e | EXCUSED LOSS | 2024-12-20 | 11 | 1 | 60.0 | 2018 | |||||
| 9997508 | 3372053 | 2018-08-09 | A000061762680 | Juvenile Kit | 1cjk | Main - 1st Floor - Children's Library - Kits | Main Library | 372.21 ffg615 2018 | Going to the market [kit] : just for 2's. | 1 | e | EXCUSED LOSS | 2024-11-14 | 5 | 10 | 60.0 | 2018 | |||||
| 9997752 | 2520044 | 2018-08-10 | A000061763498 | Juvenile Kit | 1cjk | Main - 1st Floor - Children's Library - Kits | Main Library | 372.21 ffw924 2010 | Words, musical words [kit]. | 1 | e | EXCUSED LOSS | 2024-07-18 | 5 | 5 | 60.0 | 2010 | |||||
| 9997623 | 2520077 | 2018-08-09 | A000061763381 | Juvenile Kit | 1cjk | Main - 1st Floor - Children's Library - Kits | Main Library | 372.21 ffs669 2010 | Snake length [kit]. | 1 | n | BILLED | 2020-02-10 | 2020-02-10 | 2020-07-29 | 10 | 4 | 60.0 | 2010 | |||
| 9997740 | 3372052 | 2018-08-10 | A000061763431 | Juvenile Kit | 1cjk | Main - 1st Floor - Children's Library - Kits | Main Library | 372.21 ffw5551 2018 | What's that sound? [kit] : just for 2's. | 1 | n | BILLED | 2020-02-10 | 2020-02-10 | 2020-07-08 | 8 | 3 | 60.0 | 2018 | |||
| 9997599 | 3371991 | 2018-08-09 | A000061763282 | Juvenile Kit | 1cjk | Main - 1st Floor - Children's Library - Kits | Main Library | 372.21 ffs5292 2018 | Shapes in my world [kit] : just for 2's. | 1 | r | IN REPAIR | 2019-12-30 | 9 | 2 | 60.0 | 2018 |
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;