item
5 rows where location_code = "1pa"
This data as json, CSV (advanced)
Suggested facets: bib_record_num, creation_date, record_last_updated, agency_code_num, checkout_statistic_group_code_num, checkin_statistics_group_code_num, checkout_total, renewal_total, item_format, item_status_code, price_cents, item_callnumber, creation_date (date), record_last_updated (date), checkout_date (date), due_date (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12131838 | 450983697918 | 3512152 | 2023-07-18 | 2024-01-01 | A000011913019 | 2 | 1pa | 0 | 0 | 2023-11-15 | 2023-12-04 | 1 | 2 | Book | - | 2795 | ||||||
| 12131843 | 450983697923 | 3512153 | 2023-07-18 | 2024-08-23 | A000011913183 | 2 | 1pa | 0 | 0 | 0 | 0 | Portable Technology Device | - | 2795 | ||||||||
| 12329785 | 450983895865 | 3840916 | 2024-01-16 | 2024-06-04 | A000082830268 | 0 | 1pa | 430 | 100 | 2024-05-16 | 2024-06-06 | os | 2024-03-13 | 2024-04-09 | 4 | 0 | Book | - | 2000 | fiction | ||
| 12329840 | 450983895920 | 3840916 | 2024-01-16 | 2024-06-04 | A000082830250 | 0 | 1pa | 430 | 330 | 2024-05-16 | 2024-06-06 | os | 2024-02-17 | 2024-03-30 | 3 | 0 | Book | - | 2000 | fiction | ||
| 12647843 | 450984213923 | 3726866 | 2024-11-21 | 2024-11-22 | A000075807752 | 1 | 1pa | 0 | 0 | 0 | 0 | Book | t | 4999 | 741.5 qm6851b10 2021 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);