item_view (view)
22 rows where location_code = "2ttrf"
This data as json, CSV (advanced)
Suggested facets: creation_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11897855 | 1532405 | 3767917 | 2022-12-05 | A000078271428 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.01 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897856 | 1532406 | 3767917 | 2022-12-05 | A000078271436 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.02 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897857 | 1532407 | 3767917 | 2022-12-05 | A000078271444 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.03 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897858 | 1532408 | 3767917 | 2022-12-05 | A000078271451 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.04 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897859 | 1532409 | 3767917 | 2022-12-05 | A000078271469 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.05 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897860 | 1532410 | 3767917 | 2022-12-05 | A000078271477 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.06 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897861 | 1532411 | 3767917 | 2022-12-05 | A000078271485 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.07 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897862 | 1532412 | 3767917 | 2022-12-05 | A000078271493 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.08 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897863 | 1532413 | 3767917 | 2022-12-05 | A000078271501 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.09 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897864 | 1532414 | 3767917 | 2022-12-05 | A000078271519 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.10 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897865 | 1532415 | 3767917 | 2022-12-05 | A000078271527 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.11 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897866 | 1532416 | 3767917 | 2022-12-05 | A000078271535 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.12 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897867 | 1532417 | 3767917 | 2022-12-05 | A000078271543 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.13 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897868 | 1532418 | 3767917 | 2022-12-05 | A000078271550 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.14 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897869 | 1532419 | 3767917 | 2022-12-05 | A000078271568 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.15 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897870 | 1532420 | 3767917 | 2022-12-05 | A000078271576 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.16 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897871 | 1532421 | 3767917 | 2022-12-05 | A000078271584 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.17 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897872 | 1532422 | 3767917 | 2022-12-05 | A000078271592 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.18 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897873 | 1532423 | 3767917 | 2022-12-05 | A000078271600 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.19 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897874 | 1532424 | 3767917 | 2022-12-05 | A000078271618 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.20 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897875 | 1532425 | 3767917 | 2022-12-05 | A000078271626 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.21 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 | ||||
| 11897876 | 1532426 | 3767917 | 2022-12-05 | A000078271634 | Reference Juvenile Book | 2ttrf | Main - 2nd Floor - TeenSpot - Floor Reference | Main Library | 031 qw92 2023 | v.22 | The World Book encyclopedia. | 1 | o | LIBRARY USE ONLY | 0 | 0 | 1139.05 | 2023 |
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;