item

10 rows where location_code = "5dir"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: bib_record_num, creation_date, record_last_updated, checkout_statistic_group_code_num, checkin_statistics_group_code_num, checkout_total, renewal_total, item_format, price_cents, item_callnumber, creation_date (date), record_last_updated (date), checkout_date (date), due_date (date), last_checkout_date (date), last_checkin_date (date)

item_record_num ▼ item_record_id bib_record_num creation_date record_last_updated barcode agency_code_num location_code checkout_statistic_group_code_num checkin_statistics_group_code_num checkout_date due_date patron_branch_code last_checkout_date last_checkin_date checkout_total renewal_total item_format item_status_code price_cents item_callnumber volume_record_num volume_record_statement
1123719 450972689799 2227610 2012-06-23 2023-04-28 6001198057012 1 5dir 0 0           0 0 Book o 615 025.7 l98 c    
1573048 450973139128 2502146 2012-06-26 2023-04-28 A000022444293 1 5dir 0 0           0 0 Reference Book o 2695 612.80285 c311 2010    
2815930 450974382010 1191804 2012-06-29 2023-04-28 A000018645291 1 5dir 0 0           0 0 Reference Book o 32900 027.073 qa512 1255435 64th_ed. 2011/12 v.01
2815941 450974382021 1191804 2012-06-29 2023-04-28 A000018645309 1 5dir 0 0           0 0 Reference Book o 32900 027.073 qa512 1255436 64th_ed. 2011/12 v.02
7166496 450978732576 1191804 2013-05-28 2013-05-29 A000037595840 1 5dir 0 0           0 0 Reference Book o 36950 027.073 qa512 1406126 66th_ed. 2013/14 v.01
7166497 450978732577 1191804 2013-05-28 2013-05-29 A000037595857 1 5dir 0 0           0 0 Reference Book o 36950 027.073 qa512 1406127 66th_ed. 2013/14 v.02
8875383 450980441463 1191804 2016-06-02 2023-04-28 A000050102672 1 5dir 0 0           0 0 Reference Book o 37905 027.073 qa512 1461628 69th_ed. 2016/17 v.01
8875384 450980441464 1191804 2016-06-02 2023-04-28 A000050102680 1 5dir 0 0           0 0 Reference Book o 37905 027.073 qa512 1461629 69th_ed. 2016/17 v.02
9162915 450980728995 3234113 2016-12-09 2021-01-01 A000054273743 1 5dir 1 1 2019-04-12 2020-07-03 1 2017-12-13 2019-04-12 4 19 Reference Book o 4800 027.625 qb168 2015    
9995191 450981561271 3371974 2018-08-08 2018-08-08 A000061507689 1 5dir 0 0           0 0 Reference Book o 39900 658.4056 qp961 2018    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [item] (
   [item_record_num] INTEGER PRIMARY KEY,
   [item_record_id] INTEGER,
   [bib_record_num] INTEGER,
   [creation_date] TEXT,
   [record_last_updated] TEXT,
   [barcode] TEXT,
   [agency_code_num] INTEGER,
   [location_code] TEXT,
   [checkout_statistic_group_code_num] INTEGER,
   [checkin_statistics_group_code_num] INTEGER,
   [checkout_date] TEXT,
   [due_date] TEXT,
   [patron_branch_code] TEXT,
   [last_checkout_date] TEXT,
   [last_checkin_date] TEXT,
   [checkout_total] INTEGER,
   [renewal_total] INTEGER,
   [item_format] TEXT,
   [item_status_code] TEXT,
   [price_cents] INTEGER,
   [item_callnumber] TEXT,
   [volume_record_num] INTEGER,
   [volume_record_statement] TEXT
);
CREATE INDEX [idx_item_item_format_location_code]
    ON [item] ([item_format], [location_code]);
CREATE INDEX [idx_item_item_status_code]
    ON [item] ([item_status_code]);
CREATE INDEX [idx_item_item_format_item_status_location_code_item_callnumber]
    ON [item] ([location_code], [item_format], [item_status_code], [item_callnumber]);
CREATE INDEX [idx_item_bib_record_num]
    ON [item] ([bib_record_num]);
CREATE INDEX [idx_item_item_record_num]
    ON [item] ([item_record_num]);
CREATE INDEX [idx_item_agency_code_num_location_code]
    ON [item] ([agency_code_num], [location_code]);
CREATE INDEX [idx_item_barcode]
    ON [item] ([barcode]);
CREATE INDEX [idx_item_item_format]
    ON [item] ([item_format]);
CREATE INDEX [idx_item_creation_date]
    ON [item] ([creation_date]);
CREATE INDEX [idx_item_bib_record_num_item_status_code]
    ON [item] ([bib_record_num], [item_status_code]);