item_view (view)

21 rows where location_code = "1hjoo"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: item_format, item_callnumber, best_author, best_title, item_status_name, 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
4617674   1933614 2012-06-30 1039407256012 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.1 qb881 p, 1990   Brown, Tim. Patterns in spelling 1 m MISSING 2024-01-04     20 18 10.25 1990
4617708   1933630 2012-06-30 1039407756011 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.1 qb881 , 1992   Brown, Tim. Structures in spelling : words with prefixes, roots, and suffixes 1 o LIBRARY USE ONLY       24 4 10.25 1992
4617702   1933623 2012-06-30 1039407656021 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.1 qb881 , 1992a   Brown, Tim. Structures in spelling : words with prefixes, roots, and suffixes 1 o LIBRARY USE ONLY       14 1 16.0 1992
4617666   1933614 2012-06-30 1039407056016 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.1 qb881 p, 1990   Brown, Tim. Patterns in spelling 1 o LIBRARY USE ONLY       17 1 10.25 1990
4617690   1933614 2012-06-30 1039407456018 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.1 qb881 p, 1990   Brown, Tim. Patterns in spelling 1 o LIBRARY USE ONLY 2013-04-17     12 1 10.25 1990
4223645   2571051 2012-06-30 1599776-1001 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.1 qw424 w, 1984   Weinstein, Marcia. The "write" way to spell : volume I, workbook 1 o LIBRARY USE ONLY       5 2 15.17 1984
1654923   2719678 2012-06-26 1630239-1001 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.1 qw424 w2 , 2001   Weinstein, Marcia. The "write" way to spell : volume II, workbook 1 o LIBRARY USE ONLY 2013-11-25     8 0 15.17 2001
2955767   1823154 2012-06-29 1038020956016 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.24 qc951 , 1991     Crossroads. 1 o LIBRARY USE ONLY       6 0 9.95 1991
4384837   1823154 2012-06-30 1038020756010 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.24 qc951 , 1991     Crossroads. 1 o LIBRARY USE ONLY       19 0 9.95 1991
4384843   1823154 2012-06-30 1038020856018 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.24 qc951 , 1991     Crossroads. 1 o LIBRARY USE ONLY       14 0 9.95 1991
4384848   1823154 2012-06-30 1038021056014 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.24 qc951 , 1991     Crossroads. 1 o LIBRARY USE ONLY       9 0 9.95 1991
2235772 1129642 1209103 2012-06-28 0912679556015 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.6 qh535 v.01 Herber, Harold L. Learning your language : listening, speaking, reading, writing 1 o LIBRARY USE ONLY       9 0 15.5 1964
2235775 1129643 1209103 2012-06-28 0912679656013 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.6 qh535 v.02 Herber, Harold L. Learning your language : listening, speaking, reading, writing 1 o LIBRARY USE ONLY       7 0 15.5 1964
2235790 1129645 1209103 2012-06-28 0912679856019 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.6 qh535 v.04 Herber, Harold L. Learning your language : listening, speaking, reading, writing 1 o LIBRARY USE ONLY       11 0 15.5 1964
2235794 1129646 1209103 2012-06-28 0912679956017 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.6 qh535 v.05 Herber, Harold L. Learning your language : listening, speaking, reading, writing 1 o LIBRARY USE ONLY       11 0 15.5 1964
2235797 1129647 1209103 2012-06-28 0912680056013 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.6 qh535 v.06 Herber, Harold L. Learning your language : listening, speaking, reading, writing 1 o LIBRARY USE ONLY       1 0 15.5 1964
3051502   2020117 2012-06-29 8700229256034 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.62 qh966   Hurst, John A. Horses, bats, and Christmas trees 1 o LIBRARY USE ONLY       25 0 7.95 1987
4070492   1068327 2012-06-30 0918019656035 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.62 qh966 f   Hurst, John A. Famous Americans 1 o LIBRARY USE ONLY       28 0 7.95 1987
3051519   2020140 2012-06-29 8700229756017 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.62 qh966 j   Hurst, John A. Inventions and discoveries 1 o LIBRARY USE ONLY       25 0 7.95 1987
4070529   1068342 2012-06-30 0918019856015 Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 428.62 qh966 m   Hurst, John A. More inventions and discoveries 1 o LIBRARY USE ONLY       19 0 7.95 1987
1455968   2560786 2012-06-26 1782516-1001 Reference Juvenile Book 1hjoo Main - 1st Floor - Adult Learning and Literacies - On Order Juvenile Main Library 929.2 qk297 zr   Ratcliffe, Susan Kellar, 1941- Michael Kellar and Catharine Monroe of Fairfax County, Virginia : their family and descendants, 1760-2002 1 o LIBRARY USE ONLY       0 0 26.65 2002

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;