item

10 rows where location_code = "2ttro"

✎ 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, last_checkout_date, last_checkin_date, checkout_total, item_status_code, 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
10208911 450981774991 3293824 2019-01-09 2024-03-15 A000061767150 1 2ttro 1 0       2019-03-15 2024-03-14 11 0 Charging Kit e 500 charger    
10208912 450981774992 3293824 2019-01-09 2024-02-19 A000061767168 1 2ttro 1 0       2019-02-13 2024-02-16 11 0 Charging Kit e 500 charger    
10208913 450981774993 3293824 2019-01-09 2024-02-19 A000061767176 1 2ttro 1 0       2019-02-15 2024-02-16 8 0 Charging Kit e 500 charger    
10263000 450981829080 3293824 2019-02-20 2023-01-04 A000061767580 1 2ttro 1 1       2019-03-08 2023-01-04 4 0 Charging Kit $ 500 charger    
10263001 450981829081 3293824 2019-02-20 2024-02-26 A000061767598 1 2ttro 1 0       2019-02-23 2024-02-23 2 0 Charging Kit e 500 charger    
10348298 450981914378 3293824 2019-04-16 2024-05-22 A000061766137 1 2ttro 1 0       2019-05-24 2024-05-21 9 0 Charging Kit e 500 charger    
10348299 450981914379 3293824 2019-04-16 2024-05-22 A000061766145 1 2ttro 1 0       2019-05-24 2024-05-21 9 0 Charging Kit e 500 charger    
10348300 450981914380 3293824 2019-04-16 2024-07-12 A000061766152 1 2ttro 1 0       2019-07-10 2024-07-11 31 0 Charging Kit e 500 charger    
10348301 450981914381 3293824 2019-04-16 2023-10-18 A000061766160 1 2ttro 1 500       2019-07-15 2023-10-18 32 0 Charging Kit $ 500 charger    
10348302 450981914382 3293824 2019-04-16 2024-05-22 A000061766178 1 2ttro 31 0       2019-05-20 2024-05-21 11 0 Charging Kit e 500 charger    

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