item
6 rows where location_code = "1cjbg"
This data as json, CSV (advanced)
Suggested facets: creation_date, record_last_updated, checkin_statistics_group_code_num, checkout_date, due_date, last_checkout_date, last_checkin_date, item_status_code, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3357343 | 450974923423 | 2356282 | 2012-06-30 | 2025-06-25 | 1562460-15003 | 1 | 1cjbg | 801 | 0 | 2019-09-11 | 2025-06-25 | 12 | 12 | Juvenile Book | e | 1995 | easy | |||||
| 7260654 | 450978826734 | 2356251 | 2013-08-14 | 2025-06-25 | A000038420634 | 1 | 1cjbg | 801 | 0 | 2019-09-11 | 2025-06-25 | 16 | 24 | Juvenile Book | e | 2695 | easy | |||||
| 7260689 | 450978826769 | 1559803 | 2013-08-14 | 2024-12-12 | A000038420659 | 1 | 1cjbg | 801 | 467 | 2019-09-08 | 2020-06-30 | 1 | 2019-06-30 | 2019-09-01 | 26 | 53 | Juvenile Book | - | 2500 | easy | ||
| 7278685 | 450978844765 | 2881285 | 2013-08-26 | 2024-12-12 | A000036306579 | 1 | 1cjbg | 801 | 140 | 2019-09-08 | 2020-06-30 | 1 | 2018-10-22 | 2019-01-24 | 11 | 27 | Juvenile Book | - | 2096 | 551.5 ffm685 2004 | ||
| 8697711 | 450980263791 | 1415806 | 2016-02-09 | 2024-12-12 | A000046978102 | 1 | 1cjbg | 801 | 510 | 2019-09-08 | 2024-09-11 | 10 | 16 | Juvenile Book | w | 2700 | easy | |||||
| 8715070 | 450980281150 | 3109552 | 2016-02-15 | 2024-12-12 | A000049592744 | 1 | 1cjbg | 801 | 240 | 2019-09-11 | 2020-07-01 | 1 | 2019-01-28 | 2019-02-19 | 6 | 9 | Juvenile Book | - | 2699 | 398.2 ffg149 ru 2015 |
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]);