item

6 rows where location_code = "1panr"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: creation_date, checkout_statistic_group_code_num, checkin_statistics_group_code_num, renewal_total, 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
3053456 450974619536 1272321 2012-06-29 2013-07-09 0957274056028 1 1panr 43 1       2013-05-07 2013-07-09 20 11 Book - 585 428.2 qr896 1298838 v.07
3275328 450974841408 1072585 2012-06-30 2013-01-07 0938505656018 1 1panr 0 0           31 0 Book - 315 fiction    
3985834 450975551914 1908498 2012-06-30 2019-09-03 1035966856010 1 1panr 31 1       2013-04-13 2013-04-18 6 0 Book - 795 610.14 qr529 , 1996    
4373894 450975939974 1082952 2012-06-30 2013-01-08 0918383456053 1 1panr 0 0           8 0 Book - 285 612.82 ql796    
9420795 450980986875 3279029 2017-06-06 2023-07-27 A000053330999 1 1panr 430 200       2018-02-05 2023-07-24 5 8 Book - 799 fiction    
9420873 450980986953 3279042 2017-06-06 2022-01-01 A000053331286 1 1panr 530 530 2021-05-24 2021-07-05 wy 2021-01-26 2021-05-24 9 45 Book - 995 fiction    

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]);