item

22 rows where location_code = "5sup"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: bib_record_num, creation_date, record_last_updated, checkout_statistic_group_code_num, checkin_statistics_group_code_num, last_checkout_date, checkout_total, renewal_total, item_format, item_status_code, price_cents, item_callnumber, 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
1813210 450973379290 2626367 2012-06-27 2023-04-28 A000023983703 1 5sup 0 0           0 0 Reference Book o 5995 686.302 l748    
1813215 450973379295 2626374 2012-06-27 2023-04-28 A000032714487 1 5sup 0 0           0 0 Reference Book o 2995 069.53 a646 c    
1813219 450973379299 2626379 2012-06-27 2021-01-01 A000023992357 1 5sup 1 1       2020-03-16 2020-08-12 1 0 Reference Book o 14596 025.84 qb217    
1813224 450973379304 2626387 2012-06-27 2023-04-28 A000023992407 1 5sup 0 0           0 0 Reference Book o 4995 720.284 qk61    
1813243 450973379323 2626411 2012-06-27 2023-04-28 A000023992415 1 5sup 0 0           0 0 Reference Book o 9500 720.284 qp945    
1813246 450973379326 2626423 2012-06-27 2023-04-28 A000032722191 1 5sup 0 0           0 0 Reference Book o 5733 771.4 qj95    
1813259 450973379339 2626455 2012-06-27 2023-04-28 A000032727265 1 5sup 0 0           0 0 Reference Book o 4500 025.84 b163    
1813263 450973379343 2626473 2012-06-27 2023-04-28 A000023991094 1 5sup 0 0           0 0 Reference Book o 6000 069.53 f635    
1813280 450973379360 2626499 2012-06-27 2023-04-28 A000024018749 1 5sup 0 0           0 0 Reference Book o 5995 686.3 qf687    
1813945 450973380025 2627429 2012-06-27 2023-04-28 A000032722209 1 5sup 0 0           0 0 Reference Book o 8000 025.84 qa288    
1813968 450973380048 2627441 2012-06-27 2023-04-28 A000023983828 1 5sup 0 0           0 0 Reference Book o 7500 002 c456    
1813979 450973380059 2627461 2012-06-27 2023-04-28 A000023996010 1 5sup 0 0           0 0 Reference Book o 1500 686.3 h823    
1814013 450973380093 2627566 2012-06-27 2021-01-01 A000023995285 1 5sup 1 1       2020-03-13 2020-08-12 1 0 Reference Book o 5400 069.53 b244    
1819865 450973385945 2634847 2012-06-27 2023-04-28 A000024020265 1 5sup 0 0           0 0 Reference Book o 8000 025.7 ql399    
1819877 450973385957 2634865 2012-06-27 2021-01-01 A000024020257 1 5sup 1 1       2020-03-13 2020-08-12 2 1 Reference Book o 3000 686.3 s653    
2761630 450974327710 1704418 2012-06-29 2023-04-28 A000023997240 1 5sup 0 0           0 0 Reference Book o 1400 025.84 t967    
2791553 450974357633 1744751 2012-06-29 2021-01-01 A000024020232 1 5sup 1 1       2020-03-13 2020-08-12 1 0 Reference Book o 3000 686.3 s653 1993 1249846 v.02
2791556 450974357636 1744751 2012-06-29 2021-01-01 A000024020240 1 5sup 1 1       2020-03-16 2020-08-12 2 1 Reference Book o 2844 686.3 s653 1993 1249847 v.03
2885467 450974451547 1362674 2012-06-29 2023-04-28 A000015083637 1 5sup 0 0           0 0 Reference Book o 10800 027.473 fp9767 1270286 2010
2888743 450974454823 1900638 2012-06-29 2021-01-01 A000023992704 1 5sup 1 1       2020-03-13 2020-08-12 1 0 Reference Book o 17500 686.300902 qs998    
11791016 450983357096 3756753 2022-09-12 2022-09-13 A000069181222 1 5sup 0 0           0 0 Reference Book o 5000 025.1 w582 2021    
11805109 450983371189 3756753 2022-09-21 2022-09-21 A000077802116 1 5sup 0 0           0 0 Book p 5000 025.1 w582 2021    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);