item
6 rows where location_code = "1pa"
This data as json, CSV (advanced)
Suggested facets: bib_record_num, creation_date, agency_code_num, checkout_statistic_group_code_num, checkin_statistics_group_code_num, checkout_total, renewal_total, item_format, price_cents, 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 | 2025-01-01 | A000082830268 | 0 | 1pa | 430 | 100 | 2024-05-16 | 2024-06-06 | os | 2024-03-13 | 2024-04-09 | 4 | 0 | Book | - | 2000 | fiction | ||
| 12780340 | 450984346420 | 1787501 | 2025-04-14 | 2025-06-20 | A000086112440 | 1 | 1pa | 282 | 210 | 2025-06-20 | 2025-08-01 | ha | 2025-05-07 | 2025-06-14 | 3 | 0 | Book | - | 1700 | fiction | ||
| 12780341 | 450984346421 | 1787501 | 2025-04-14 | 2025-06-13 | A000086112457 | 1 | 1pa | 492 | 410 | 2025-06-13 | 2025-07-25 | sm | 2025-05-02 | 2025-06-06 | 3 | 0 | Book | - | 1700 | fiction | ||
| 12805720 | 450984371800 | 3935364 | 2025-05-07 | 2025-06-26 | A000085986265 | 1 | 1pa | 323 | 320 | 2025-06-26 | 2025-08-07 | ma | 2025-05-24 | 2025-06-23 | 2 | 0 | Book | - | 2900 | fiction |
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]);