item
22 rows where location_code = "anjbg"
This data as json, CSV (advanced)
Suggested facets: bib_record_num, creation_date, record_last_updated, agency_code_num, 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_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1493608 | 450973059688 | 2356282 | 2012-06-26 | 2024-10-23 | 1562460-15001 | 1 | anjbg | 104 | 100 | 2024-10-03 | 2024-10-23 | 6 | 4 | Juvenile Book | - | 1995 | easy | |||||
| 1764807 | 450973330887 | 2633281 | 2012-06-27 | 2024-09-30 | 1672758-1002 | 1 | anjbg | 801 | 490 | 2024-05-22 | 2024-06-20 | 18 | 11 | Juvenile Book | w | 1339 | easy | |||||
| 5172425 | 450976738505 | 2633257 | 2012-07-02 | 2024-11-21 | A000026900894 | 6 | anjbg | 801 | 100 | 2024-10-12 | 2024-12-14 | an | 2024-09-11 | 2024-09-30 | 26 | 27 | Juvenile Book | - | 1739 | easy | ||
| 8554655 | 450980120735 | 3109558 | 2015-11-10 | 2024-11-20 | A000048860340 | 18 | anjbg | 480 | 850 | 2024-10-13 | 2024-10-14 | 32 | 12 | Juvenile Book | - | 2699 | easy | |||||
| 9212880 | 450980778960 | 2773688 | 2017-01-18 | 2024-10-08 | A000054957113 | 14 | anjbg | 100 | 100 | 2024-09-11 | 2024-09-30 | 24 | 7 | Juvenile Book | f | 2499 | easy | |||||
| 9828940 | 450981395020 | 2986760 | 2018-03-30 | 2021-01-01 | A000058448473 | 4 | anjbg | 801 | 440 | 2020-07-15 | 2020-09-15 | an | 2019-08-16 | 2019-10-14 | 8 | 1 | Juvenile Book | - | 2099 | easy | ||
| 10228268 | 450981794348 | 2633311 | 2019-01-24 | 2024-01-18 | A000062863222 | 38 | anjbg | 801 | 100 | 2020-08-11 | 2020-12-23 | 4 | 8 | Juvenile Book | w | 2499 | 597.89139 fff876 2002 | |||||
| 10926207 | 450982492287 | 3001023 | 2020-10-13 | 2024-04-03 | A000070119716 | 1 | anjbg | 103 | 102 | 2023-11-06 | 2023-12-13 | 5 | 8 | Juvenile Book | w | 2699 | easy | |||||
| 10926208 | 450982492288 | 3001023 | 2020-10-13 | 2024-11-15 | A000070119724 | 1 | anjbg | 104 | 104 | 2024-11-15 | 2024-11-15 | 14 | 4 | Juvenile Book | - | 2699 | easy | |||||
| 10926250 | 450982492330 | 1357314 | 2020-10-13 | 2024-11-15 | A000070825767 | 1 | anjbg | 104 | 104 | 2024-11-15 | 2024-11-15 | 22 | 17 | Juvenile Book | - | 2699 | easy | |||||
| 10987475 | 450982553555 | 3109561 | 2020-12-07 | 2024-11-16 | A000070715232 | 1 | anjbg | 801 | 103 | 2024-09-16 | 2024-12-09 | 1 | 2024-08-27 | 2024-09-09 | 19 | 12 | Juvenile Book | - | 2699 | easy | ||
| 10987478 | 450982553558 | 3109561 | 2020-12-07 | 2024-11-13 | A000070715265 | 1 | anjbg | 104 | 100 | 2024-11-13 | 2024-12-26 | oa | 2024-10-02 | 2024-11-04 | 25 | 13 | Juvenile Book | - | 2699 | easy | ||
| 11211966 | 450982778046 | 3109549 | 2021-06-21 | 2024-09-06 | A000072945670 | 1 | anjbg | 103 | 102 | 2024-08-16 | 2024-09-05 | 23 | 5 | Juvenile Book | w | 1999 | easy | |||||
| 11639983 | 450983206063 | 2456773 | 2022-05-05 | 2024-11-03 | A000075895765 | 1 | anjbg | 801 | 102 | 2024-09-03 | 2024-11-26 | an | 2024-08-30 | 2024-08-30 | 6 | 5 | Juvenile Book | - | 2499 | easy | ||
| 11983290 | 450983549370 | 2658715 | 2023-02-24 | 2024-11-21 | A000079013118 | 1 | anjbg | 102 | 850 | 2024-11-21 | 2025-01-02 | an | 2024-10-23 | 2024-10-24 | 23 | 7 | Juvenile Book | - | 2699 | easy | ||
| 11983291 | 450983549371 | 2658715 | 2023-02-24 | 2024-04-03 | A000079013126 | 1 | anjbg | 100 | 100 | 2024-01-29 | 2024-03-04 | 6 | 3 | Juvenile Book | w | 2699 | easy | |||||
| 12010157 | 450983576237 | 2365548 | 2023-03-20 | 2024-11-16 | A000079039048 | 1 | anjbg | 801 | 100 | 2024-09-16 | 2024-12-09 | 1 | 2024-08-16 | 2024-09-12 | 13 | 6 | Juvenile Book | - | 2499 | easy | ||
| 12164404 | 450983730484 | 2684787 | 2023-08-16 | 2024-10-25 | A000080058896 | 1 | anjbg | 104 | 850 | 2024-10-25 | 2024-12-06 | an | 2024-10-21 | 2024-10-23 | 21 | 4 | Juvenile Book | - | 2699 | easy | ||
| 12257964 | 450983824044 | 1335152 | 2023-11-03 | 2024-10-17 | A000082344187 | 1 | anjbg | 104 | 100 | 2024-09-10 | 2024-09-23 | 3 | 4 | Juvenile Book | w | 2699 | easy | |||||
| 12257983 | 450983824063 | 2725881 | 2023-11-03 | 2024-11-21 | A000082344260 | 1 | anjbg | 100 | 100 | 2024-11-21 | 2024-11-21 | 7 | 7 | Juvenile Book | - | 2699 | easy | |||||
| 12343822 | 450983909902 | 2356320 | 2024-01-30 | 2024-11-04 | A000082448665 | 1 | anjbg | 105 | 100 | 2024-11-04 | 2024-12-16 | an | 2024-10-26 | 2024-11-01 | 8 | 3 | Juvenile Book | - | 2499 | easy | ||
| 12589363 | 450984155443 | 2986760 | 2024-09-30 | 2024-11-21 | A000062215795 | 1 | anjbg | 801 | 0 | 2024-10-12 | 2024-12-14 | an | 1 | 1 | Juvenile Book | - | 2099 | easy |
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]);