item

8 rows where location_code = "3da"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: creation_date, record_last_updated, checkout_statistic_group_code_num, checkin_statistics_group_code_num, checkout_total, renewal_total, item_status_code, price_cents, 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
11804505 450983370585 1028148 2022-09-20 2025-01-01 A000061144145 1 3da 150 158       2024-03-02 2024-03-16 1 0 Book - 1550 977.199 c57 w    
11804508 450983370588 2976938 2022-09-20 2024-12-13 A000061144152 1 3da 801 210       2023-02-07 2023-08-04 1 6 Book w 1550 917.71780443 qd971 2014    
11804510 450983370590 1600446 2022-09-20 2022-09-28 A000061144160 1 3da 0 0           0 0 Book - 1550 917.71780443 qd971 1998    
11804511 450983370591 1217956 2022-09-20 2025-01-01 A000061144178 1 3da 801 237       2024-11-01 2024-12-12 1 1 Book - 1550 r282.77143 a923    
11804515 450983370595 2548576 2022-09-20 2022-09-28 A000061144186 1 3da 0 0           0 0 Book - 1550 396.06 qc574 zh 1994    
11897252 450983463332 3772319 2022-12-05 2022-12-09 A000061147734 1 3da 0 0           0 0 Book - 1550 976.25061092 l475 zl 1984    
12015062 450983581142 3807335 2023-03-24 2025-04-16 A000061198810 1 3da 801 120       2025-02-03 2025-04-09 7 22 Book - 2995 629.222097 qb737 v 2020    
12050818 450983616898 3813034 2023-05-01 2024-01-26 A000061169019 1 3da 801 210       2023-12-05 2024-01-22 1 1 Book - 495 917.4461 b151 1993    

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