item

21 rows where location_code = "1hjoo"

✎ 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, item_status_code, price_cents, item_callnumber, creation_date (date), record_last_updated (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
1455968 450973022048 2560786 2012-06-26 2013-01-05 1782516-1001 1 1hjoo 0 0           0 0 Reference Juvenile Book o 2665 929.2 qk297 zr    
1654923 450973221003 2719678 2012-06-26 2020-02-24 1630239-1001 1 1hjoo 1 1       2013-11-12 2013-11-25 8 0 Book o 1517 428.1 qw424 w2 , 2001    
2235772 450973801852 1209103 2012-06-28 2020-02-24 0912679556015 1 1hjoo 0 0           9 0 Book o 1550 428.6 qh535 1129642 v.01
2235775 450973801855 1209103 2012-06-28 2020-02-24 0912679656013 1 1hjoo 0 0           7 0 Book o 1550 428.6 qh535 1129643 v.02
2235790 450973801870 1209103 2012-06-28 2020-02-24 0912679856019 1 1hjoo 0 0           11 0 Book o 1550 428.6 qh535 1129645 v.04
2235794 450973801874 1209103 2012-06-28 2020-02-24 0912679956017 1 1hjoo 0 0           11 0 Book o 1550 428.6 qh535 1129646 v.05
2235797 450973801877 1209103 2012-06-28 2020-02-24 0912680056013 1 1hjoo 0 0           1 0 Book o 1550 428.6 qh535 1129647 v.06
2955767 450974521847 1823154 2012-06-29 2020-02-24 1038020956016 1 1hjoo 0 0           6 0 Book o 995 428.24 qc951 , 1991    
3051502 450974617582 2020117 2012-06-29 2020-02-24 8700229256034 1 1hjoo 0 0           25 0 Book o 795 428.62 qh966    
3051519 450974617599 2020140 2012-06-29 2020-02-24 8700229756017 1 1hjoo 0 0           25 0 Book o 795 428.62 qh966 j    
4070492 450975636572 1068327 2012-06-30 2020-02-24 0918019656035 1 1hjoo 0 0           28 0 Book o 795 428.62 qh966 f    
4070529 450975636609 1068342 2012-06-30 2020-02-24 0918019856015 1 1hjoo 0 0           19 0 Book o 795 428.62 qh966 m    
4223645 450975789725 2571051 2012-06-30 2020-02-24 1599776-1001 1 1hjoo 0 0           5 2 Book o 1517 428.1 qw424 w, 1984    
4384837 450975950917 1823154 2012-06-30 2020-02-24 1038020756010 1 1hjoo 0 0           19 0 Book o 995 428.24 qc951 , 1991    
4384843 450975950923 1823154 2012-06-30 2020-02-24 1038020856018 1 1hjoo 0 0           14 0 Book o 995 428.24 qc951 , 1991    
4384848 450975950928 1823154 2012-06-30 2020-02-24 1038021056014 1 1hjoo 0 0           9 0 Book o 995 428.24 qc951 , 1991    
4617666 450976183746 1933614 2012-06-30 2020-02-24 1039407056016 1 1hjoo 0 0           17 1 Book o 1025 428.1 qb881 p, 1990    
4617674 450976183754 1933614 2012-06-30 2024-01-04 1039407256012 1 1hjoo 800 1       2011-09-28 2024-01-04 20 18 Book m 1025 428.1 qb881 p, 1990    
4617690 450976183770 1933614 2012-06-30 2020-02-24 1039407456018 1 1hjoo 1 1       2011-10-10 2013-04-17 12 1 Book o 1025 428.1 qb881 p, 1990    
4617702 450976183782 1933623 2012-06-30 2020-02-24 1039407656021 1 1hjoo 0 0           14 1 Book o 1600 428.1 qb881 , 1992a    
4617708 450976183788 1933630 2012-06-30 2020-02-24 1039407756011 1 1hjoo 0 0           24 4 Book o 1025 428.1 qb881 , 1992    

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