item
13 rows where location_code = "2rard"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10000326 | 450981566406 | 3293824 | 2018-08-13 | 2023-10-18 | A000061765006 | 1 | 2rard | 1 | 1 | 2019-01-09 | 2023-10-13 | 18 | 0 | Charging Kit | z | 500 | charger | |||||
| 10000328 | 450981566408 | 3293824 | 2018-08-13 | 2023-10-20 | A000061765022 | 1 | 2rard | 1 | 0 | 2018-10-20 | 2023-10-20 | 16 | 0 | Charging Kit | - | 500 | charger | |||||
| 10000331 | 450981566411 | 3293824 | 2018-08-13 | 2024-08-01 | A000061765055 | 1 | 2rard | 1 | 0 | 2019-01-10 | 2024-01-12 | 19 | 0 | Charging Kit | e | 500 | charger | |||||
| 10106518 | 450981672598 | 3293824 | 2018-10-31 | 2024-02-05 | A000061766699 | 1 | 2rard | 61 | 0 | 2019-01-30 | 2024-02-02 | 18 | 0 | Charging Kit | e | 500 | charger | |||||
| 10106521 | 450981672601 | 3293824 | 2018-10-31 | 2024-08-01 | A000061766723 | 1 | 2rard | 61 | 0 | 2019-01-26 | 2024-01-26 | 19 | 0 | Charging Kit | e | 500 | charger | |||||
| 10106527 | 450981672607 | 3293824 | 2018-10-31 | 2024-01-01 | A000061766780 | 1 | 2rard | 1 | 1 | 2023-07-17 | 2023-07-17 | 3 | 0 | Charging Kit | - | 500 | charger | |||||
| 10225401 | 450981791481 | 3293824 | 2019-01-23 | 2024-03-15 | A000061767341 | 1 | 2rard | 1 | 0 | 2019-03-12 | 2024-03-14 | 30 | 0 | Charging Kit | e | 500 | charger | |||||
| 10225402 | 450981791482 | 3293824 | 2019-01-23 | 2024-02-19 | A000061767358 | 1 | 2rard | 1 | 0 | 2019-02-12 | 2024-02-16 | 8 | 0 | Charging Kit | e | 500 | charger | |||||
| 10225408 | 450981791488 | 3293824 | 2019-01-23 | 2024-03-15 | A000061767416 | 1 | 2rard | 61 | 0 | 2019-03-12 | 2024-03-14 | 17 | 0 | Charging Kit | e | 500 | charger | |||||
| 10225427 | 450981791507 | 3293824 | 2019-01-23 | 2024-02-26 | A000061767424 | 1 | 2rard | 1 | 0 | 2019-02-21 | 2024-02-23 | 3 | 0 | Charging Kit | e | 500 | charger | |||||
| 10291448 | 450981857528 | 3293824 | 2019-03-13 | 2024-05-06 | A000061767812 | 1 | 2rard | 61 | 0 | 2019-05-06 | 2024-05-04 | 7 | 0 | Charging Kit | e | 500 | charger | |||||
| 10291450 | 450981857530 | 3293824 | 2019-03-13 | 2024-04-19 | A000061767739 | 1 | 2rard | 1 | 0 | 2019-04-18 | 2024-04-18 | 9 | 0 | Charging Kit | e | 500 | charger | |||||
| 10291457 | 450981857537 | 3293824 | 2019-03-13 | 2024-04-12 | A000061767804 | 1 | 2rard | 1 | 0 | 2019-04-10 | 2024-04-11 | 5 | 0 | Charging Kit | e | 500 | charger |
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]);