item

26 rows where location_code = "5lib"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: bib_record_num, creation_date, record_last_updated, agency_code_num, checkout_total, item_format, item_status_code, price_cents, item_callnumber, volume_record_num, volume_record_statement, 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
1468157 450973034237 2326559 2012-06-26 2023-04-28 1556545-1001 1 5lib 0 0           0 0 Reference Magazine o 0 periodical    
1473923 450973040003 2330228 2012-06-26 2023-04-28 1557504-1001 1 5lib 0 0           0 0 Reference Magazine o 0 periodical    
1539253 450973105333 2466001 2012-06-26 2023-04-28 1582614-1004 1 5lib 0 0           0 0 Book o 805 822.914 m824 m    
1555593 450973121673 2763136 2012-06-26 2023-04-28 1825564-1003 1 5lib 0 0           0 0 Reference Book o 1995 658.8101 c737    
1570506 450973136586 2496777 2012-06-26 2023-04-28 A000011454170 1 5lib 0 0           0 0 Reference Book o 7500 022.3 qw911    
1580631 450973146711 2520673 2012-06-26 2023-04-28 A000019795913 1 5lib 0 0           0 0 Reference Book o 6500 025.174 n739    
1661064 450973227144 2690258 2012-06-26 2023-04-28 A000027351261 1 5lib 0 0           0 0 Reference Book o 1495 327.101 d778    
1860992 450973427072 2682750 2012-06-27 2023-04-28 A000031794316 1 5lib 0 0           0 0 Reference Book o 4500 025.82 g742 b    
2885470 450974451550 1362674 2012-06-29 2023-04-28 A000015083645 1 5lib 0 0           0 0 Reference Book o 10800 027.473 fp9767 1270286 2010
2885483 450974451563 1362674 2012-06-29 2023-04-28 A000028566412 1 5lib 0 0           0 0 Reference Book o 12150 027.473 fp9767 1270287 2011
6223226 450977789306 2692756 2012-07-03 2013-01-25 A000027360643 1 5lib 0 0           2 0 Reference Book o 5000 023.9 qh155    
6926585 450978492665 2368904 2012-12-05 2025-02-27 A000037114535 32 5lib 0 0           0 0 Book p 2095 031.02 c319 1983    
7473467 450979039547 2924028 2013-12-10 2013-12-16 A000038911061 1 5lib 0 0           0 0 Reference Book o 9995 025.3 h632 2013    
7473472 450979039552 2924027 2013-12-10 2013-12-16 A000038911202 1 5lib 0 0           0 0 Reference Book o 8000 025.3 qm651 2011    
7841168 450979407248 2981399 2014-08-11 2015-04-24 A000041380536 1 5lib 0 0           0 0 Reference Book o 1999 658 l778 2008    
7841169 450979407249 2981399 2014-08-11 2015-04-24 A000041380544 1 5lib 0 0           0 0 Reference Book o 1999 658 l778 2008    
7841170 450979407250 2981399 2014-08-11 2015-04-24 A000041380551 1 5lib 0 0           0 0 Reference Book o 1999 658 l778 2008    
7845174 450979411254 2981399 2014-08-13 2024-12-12 A000041392234 1 5lib 0 0           0 0 Reference Book w 1995 658 l778 2008    
7845175 450979411255 2981399 2014-08-13 2024-12-12 A000041392242 1 5lib 0 0           0 0 Reference Book w 1995 658 l778 2008    
7845176 450979411256 2981399 2014-08-13 2015-04-24 A000041392259 1 5lib 0 0           0 0 Reference Book o 1995 658 l778 2008    
7845179 450979411259 2981399 2014-08-13 2015-04-24 A000041392275 1 5lib 0 0           0 0 Reference Book o 1995 658 l778 2008    
7845182 450979411262 2981399 2014-08-13 2015-04-24 A000041392309 1 5lib 0 0           0 0 Reference Book o 1995 658 l778 2008    
10080573 450981646653 1429955 2018-10-12 2020-01-16 A000059615270 1 5lib 0 0           0 0 Reference Book o 9200 394.205 qc487 1493769 2019
10589602 450982155682 1429955 2019-10-28 2020-01-16 A000067363889 1 5lib 0 0           0 0 Reference Book o 9500 394.205 qc487 1505934 2020
11009358 450982575438 1429955 2020-12-29 2023-04-28 A000069117705 1 5lib 0 0           0 0 Reference Book o 9800 394.205 qc487 1516609 2021
11009359 450982575439 1429955 2020-12-29 2023-04-28 A000069117713 1 5lib 0 0           0 0 Reference Book o 9800 394.205 qc487 1516609 2021

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