item
11 rows where location_code = "1cjbg"
This data as json, CSV (advanced)
Suggested facets: creation_date, record_last_updated, checkout_statistic_group_code_num, checkin_statistics_group_code_num, checkout_date, due_date, last_checkout_date, last_checkin_date, renewal_total, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3357343 | 450974923423 | 2356282 | 2012-06-30 | 2021-05-24 | 1562460-15003 | 1 | 1cjbg | 801 | 1 | 2019-09-11 | 2020-06-22 | 1 | 2016-05-25 | 2016-05-27 | 12 | 12 | Juvenile Book | - | 1995 | easy | ||
| 4442974 | 450976009054 | 1712393 | 2012-06-30 | 2024-08-01 | 542757-12009 | 1 | 1cjbg | 801 | 0 | 2018-10-19 | 2024-05-16 | 17 | 34 | Juvenile Book | e | 2695 | easy | |||||
| 7260654 | 450978826734 | 2356251 | 2013-08-14 | 2021-05-24 | A000038420634 | 1 | 1cjbg | 801 | 390 | 2019-09-11 | 2020-06-27 | 1 | 2019-04-17 | 2019-05-29 | 16 | 24 | Juvenile Book | - | 2695 | easy | ||
| 7260689 | 450978826769 | 1559803 | 2013-08-14 | 2021-05-24 | 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 | 2021-05-24 | 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 | ||
| 8554483 | 450980120563 | 3109549 | 2015-11-10 | 2024-08-01 | A000048860761 | 1 | 1cjbg | 801 | 230 | 2019-01-27 | 2024-04-25 | 13 | 8 | Juvenile Book | e | 1999 | easy | |||||
| 8697711 | 450980263791 | 1415806 | 2016-02-09 | 2024-09-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 | 2021-05-24 | 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 | ||
| 9164001 | 450980730081 | 3109550 | 2016-12-12 | 2024-08-01 | A000046935391 | 1 | 1cjbg | 801 | 0 | 2018-09-14 | 2024-04-11 | 3 | 8 | Juvenile Book | e | 1595 | easy | |||||
| 9493730 | 450981059810 | 2725881 | 2017-07-28 | 2024-08-01 | A000055621270 | 1 | 1cjbg | 801 | 0 | 2018-09-14 | 2024-04-11 | 7 | 13 | Juvenile Book | e | 2699 | easy | |||||
| 12164043 | 450983730123 | 3826502 | 2023-08-16 | 2024-05-28 | A000080051818 | 1 | 1cjbg | 501 | 500 | 2023-09-09 | 2023-09-28 | 1 | 0 | Juvenile Book | - | 1799 | 782.42166 c777 2023 |
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]);