item

17 rows where location_code = "5hum"

✎ 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
1475063 450973041143 2330797 2012-06-26 2023-04-28 1557686-1001 1 5hum 0 0           0 0 Reference Magazine o 0 periodical    
1524397 450973090477 2446207 2012-06-26 2014-07-29 1576616-1001 1 5hum 0 0           0 0 Reference Magazine o 0 periodical    
1534252 450973100332 2110768 2012-06-26 2023-04-28 1363738-1001 1 5hum 0 0           0 0 Book o 0 344.730159 fs446    
1569556 450973135636 2494613 2012-06-26 2023-04-28 A000011589553 1 5hum 0 0           0 0 Reference Book o 5500 025.1 qs617    
1573112 450973139192 2555208 2012-06-26 2023-04-28 1596187-1001 1 5hum 0 0           0 0 Reference Magazine o 0 periodical    
1578013 450973144093 2564403 2012-06-26 2023-04-28 1598395-1001 1 5hum 0 0           0 0 Reference Book o 0 xx(1598395.1)    
1663215 450973229295 2692756 2012-06-26 2023-04-28 A000024713026 1 5hum 0 0           0 0 Reference Book o 5200 023.9 qh155    
1684270 450973250350 2729502 2012-06-26 2015-07-27 A000028516599 1 5hum 0 0           0 0 Reference Book o 9000 658.312404 qf648 2008    
1697642 450973263722 2502735 2012-06-26 2023-04-28 1646133-1001 1 5hum 0 0           0 0 Reference Book o 8995 720.87 qa191    
6770779 450978336859 2795250 2012-08-20 2021-05-03 A000031626740 1 5hum 0 0           0 0 Reference Book o 1395 128 f963 2004    
6770780 450978336860 2795250 2012-08-20 2021-05-03 A000031626757 1 5hum 0 0           0 0 Reference Book o 1395 128 f963 2004    
6771949 450978338029 2778184 2012-08-21 2014-07-14 A000032657785 1 5hum 0 0           0 0 Reference Book o 1195 658 c712 go 2005    
6772008 450978338088 2583628 2012-08-21 2013-06-05 A000032657686 1 5hum 0 0           0 0 Reference Book p 2995 658.409 b923 t    
6781106 450978347186 1995194 2012-08-28 2013-01-11 A000031424575 1 5hum 0 0           0 0 Book p 1800 658.4012 s399 j 2003    
8001472 450979567552 3006049 2014-11-06 2014-11-06   1 5hum 0 0           0 0 Reference Magazine o 0 periodical    
8948025 450980514105 3173121 2016-07-18 2016-07-18   1 5hum 0 0           0 0 Reference Magazine o 0 periodical    
9496927 450981063007 3294021 2017-08-01 2017-08-01   1 5hum 0 0           0 0 Book p 4300      

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