item
8 rows where location_code = "3da"
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), 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11804505 | 450983370585 | 1028148 | 2022-09-20 | 2024-03-19 | 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-10-16 | 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 | 2024-11-01 | A000061144178 | 1 | 3da | 235 | 0 | 2024-11-01 | 2024-12-13 | fo | 1 | 0 | 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 | 2024-11-12 | A000061198810 | 1 | 3da | 801 | 490 | 2024-07-03 | 2024-12-05 | sm | 2023-12-06 | 2024-07-03 | 5 | 19 | 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
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]);