item

22 rows where location_code = "1paes"

✎ 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, last_checkout_date, last_checkin_date, checkout_total, renewal_total, item_format, item_status_code, 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
1880262 450973446342 2712677 2012-06-27 2021-01-01 A000024424954 1 1paes 1 10         2019-08-05 3 1 Book on CD - 4400 cd-language english l438so 2008 v. 1    
1880296 450973446376 2712726 2012-06-27 2013-10-29 A000024424814 1 1paes 0 0           0 0 Book on CD - 4400 cd-language english l438j 2008 v. 2    
3662442 450975228522 1290569 2012-06-30 2019-06-06 0944168956018 1 1paes 0 0           41 0 Book - 895 428.24 ql743 , 1979    
3743415 450975309495 2460563 2012-06-30 2019-06-10 1580206-1002 1 1paes 0 0           8 0 Book - 3200 423.951 k16 , 2004    
4101496 450975667576 2548885 2012-06-30 2025-06-11 1594859-1001 1 1paes 211 210       2025-04-30 2025-06-04 29 21 Book - 1750 428.0071 qt253 , 1996    
4101532 450975667612 2548896 2012-06-30 2023-03-01 1594867-1002 1 1paes 800 1       2011-10-10 2021-08-27 2 16 Book - 1500 428.2 qk25 , 2004    
4101544 450975667624 2548896 2012-06-30 2023-03-01 1594867-2002 1 1paes 800 1       2011-10-10 2021-08-27 9 22 Book - 1500 428.2 qk25 , 2004    
4480069 450976046149 2611247 2012-06-30 2019-06-06 A000000828376 1 1paes 1 490       2013-07-30 2014-02-06 26 9 Book - 453 428.3461 l332 h 2002    
4490937 450976057017 2165674 2012-06-30 2024-12-12 1048435856024 1 1paes 1 1       2014-03-14 2017-03-28 23 1 Book n 941 428.3441 m974 , 2003    
4677951 450976244031 2241471 2012-06-30 2019-06-06 1049400456014 1 1paes 0 0           19 1 Book - 1080 428.24951 z63 , 2002    
4678135 450976244215 2241722 2012-06-30 2019-06-06 1049403256015 1 1paes 1 490       2012-10-02 2012-11-12 48 21 Book - 1500 428.34951 w749 , 2003    
4877924 450976444004 2735804 2012-07-01 2015-08-28 1633557-1001 1 1paes 0 0           12 0 Book - 1964 433.21 o98 s    
4877927 450976444007 2735819 2012-07-01 2014-06-01 1633562-1001 1 1paes 1 410       2013-11-13 2014-05-29 8 1 Book - 1140 469.321 d546    
6404853 450977970933 2532158 2012-07-03 2025-06-23 A000014983944 1 1paes 1 230 2025-06-23 2025-07-07 ww 2022-11-07 2023-01-09 64 21 DVD - 1000 dvd 428.34 e762 2001 1368153 v.03
6404900 450977970980 2532158 2012-07-03 2022-01-01 A000014984025 1 1paes 230 230       2021-05-10 2021-07-20 62 29 DVD - 1000 dvd 428.34 e762 2001 1368161 v.11
6404905 450977970985 2532158 2012-07-03 2019-07-12 A000014984033 1 1paes 1 1       2017-06-03 2017-06-17 42 17 DVD - 1000 dvd 428.34 e762 2001 1368162 v.12
7101020 450978667100 2532158 2013-04-22 2025-06-23 A000035177542 1 1paes 1 230 2025-06-23 2025-07-07 ww 2023-05-11 2023-06-26 18 9 DVD - 1000 dvd 428.34 e762 2001 1368154 v.04
7101021 450978667101 2532158 2013-04-22 2025-06-26 A000035177559 1 1paes 1 520       2025-04-11 2025-06-24 11 4 DVD - 1000 dvd 428.34 e762 2001 1368155 v.05
7628147 450979194227 2948290 2014-03-14 2023-06-28 A000039580485 1 1paes 1 1       2018-09-17 2018-09-25 2 0 Book on CD - 4400 cd-language english l438ta 2008 v. 01    
7628149 450979194229 2948292 2014-03-14 2014-03-21 A000039580501 1 1paes 0 0           0 0 Book on CD - 4400 cd-language english l438ta 2008 v. 02    
10197450 450981763530 3407955 2018-12-31 2025-06-26 A000064171897 1 1paes 520 520       2025-04-11 2025-06-24 4 2 Book on CD - 2000 cd-language english i51r3 2018    
10197455 450981763535 3407956 2018-12-31 2024-01-01 A000064171848 1 1paes 851 850       2023-03-21 2023-03-23 5 0 Book on CD - 1999 cd-language english i51r2 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]);