item

8 rows where location_code = "1padt"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: record_last_updated, checkout_statistic_group_code_num, checkin_statistics_group_code_num, last_checkout_date, last_checkin_date, checkout_total, volume_record_num, volume_record_statement, 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
10644514 450982210594 3479844 2019-12-03 2024-06-27 A000067508616 1 1padt 382 382       2024-06-05 2024-06-15 29 12 DVD/Videocassette - 999 dvd tvadult g192s8 2019 1504708 v.01
10644515 450982210595 3479844 2019-12-03 2024-06-27 A000067508624 1 1padt 481 480       2024-05-29 2024-06-08 27 15 DVD/Videocassette - 999 dvd tvadult g192s8 2019 1504708 v.01
10644545 450982210625 3479844 2019-12-03 2024-07-18 A000067508921 1 1padt 801 480       2024-06-27 2024-07-16 37 14 DVD/Videocassette - 999 dvd tvadult g192s8 2019 1504709 v.02
10644546 450982210626 3479844 2019-12-03 2024-06-27 A000067508939 1 1padt 392 390       2024-06-09 2024-06-15 23 11 DVD/Videocassette - 999 dvd tvadult g192s8 2019 1504709 v.02
10644576 450982210656 3479844 2019-12-03 2024-06-27 A000067509234 1 1padt 481 480       2024-05-29 2024-06-08 27 30 DVD/Videocassette - 999 dvd tvadult g192s8 2019 1504710 v.03
10644577 450982210657 3479844 2019-12-03 2024-08-21 A000067509242 1 1padt 330 330       2024-08-13 2024-08-16 30 10 DVD/Videocassette - 999 dvd tvadult g192s8 2019 1504710 v.03
10644607 450982210687 3479844 2019-12-03 2024-06-27 A000067509549 1 1padt 801 390       2024-06-09 2024-06-23 28 19 DVD/Videocassette - 999 dvd tvadult g192s8 2019 1504711 v.04
10644609 450982210689 3479844 2019-12-03 2024-07-27 A000067509556 1 1padt 67 1       2024-07-18 2024-07-27 32 20 DVD/Videocassette - 999 dvd tvadult g192s8 2019 1504711 v.04

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