item

11 rows where location_code = "5mkt"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: bib_record_num, creation_date, record_last_updated, barcode, item_format, item_status_code, price_cents, item_callnumber, creation_date (date), record_last_updated (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
1483922 450973050002 2340338 2012-06-26 2023-04-28 1560552-1001 1 5mkt 0 0           0 0 Reference Magazine o 0 periodical    
7536822 450979102902 2929926 2014-01-23 2014-01-28   1 5mkt 0 0           0 0 Reference Book o 4999 005.133 a325 2010    
7536844 450979102924 2929925 2014-01-23 2014-01-28   1 5mkt 0 0           0 0 Reference Book o 4499 006.7882 e77 2009    
7564459 450979130539 2929922 2014-02-04 2014-02-06 A000042251553 1 5mkt 0 0           0 0 Reference Book o 4999 006.7882 a188 zm 2010    
7610489 450979176569 2929924 2014-03-04 2014-03-10 A000039496799 1 5mkt 0 0           0 0 Reference Book o 5499 005.276 a188 zf 2012    
7635917 450979201997 2924027 2014-03-20 2014-03-21 A000039600622 1 5mkt 0 0           0 0 Reference Book o 8000 025.3 qm651 2011    
7685731 450979251811 2963713 2014-04-22 2014-04-28 A000041101130 1 5mkt 0 0           0 0 Reference Book o 5995 006.7019 s349 2012    
7808847 450979374927 2452969 2014-07-18 2014-08-18 A000042999169 1 5mkt 0 0           0 0 Reference Book o 1999 070.435 a849 1409195 2013
7808848 450979374928 2452969 2014-07-18 2014-08-18 A000042999177 1 5mkt 0 0           0 0 Reference Book o 1999 070.435 a849 1409195 2013
7808849 450979374929 2452969 2014-07-18 2014-08-18 A000042999185 1 5mkt 0 0           0 0 Reference Book o 1999 070.435 a849 1409195 2013
12530792 450984096872 3898294 2024-08-02 2024-10-21 A000083801912 1 5mkt 0 0           0 0 Book g 4999 021.20973 b228 2024    

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