item

59 rows where location_code = "3caod"

✎ 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, checkout_total, item_format, price_cents, item_callnumber, volume_record_statement, 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
1471640 450973037720 2438933 2012-06-26 2023-12-07 1350528-1001 1 3caod 1 1       2021-12-09 2023-12-07 2 0 Newspaper o 0 newspaper    
1490615 450973056695 2636731 2012-06-26 2024-01-11 1797342-1001 1 3caod 1 1       2023-10-05 2024-01-11 6 0 Rare Book o 180000 598.092 ffa916 zdo    
1687323 450973253403 2734110 2012-06-26 2019-03-05 A000031268196 1 3caod 0 0           0 0 Rare Book o 1550 810.82 c625 1049418 1927a
1738801 450973304881 2524994 2012-06-27 2019-07-09 A000006401723 1 3caod 0 0           0 0 Rare Book o 50000 977.177 ffh7632 2011    
1944606 450973510686 1420680 2012-06-27 2019-03-05 0967708657010 1 3caod 0 0           0 0 Rare Book o 1550 810.82 c625    
1963615 450973529695 1436016 2012-06-27 2019-06-10 0968076257011 1 3caod 0 0           0 0 Rare Book o 1550 624.5 1867    
1963617 450973529697 1888779 2012-06-27 2019-03-05 1018299957010 1 3caod 0 0           0 0 Rare Book o 1550 810.82 b922 w    
1965830 450973531910 1891022 2012-06-27 2019-06-10 1018333357011 1 3caod 0 0           0 0 Rare Book o 1550 810.82 b972    
1993770 450973559850 1505726 2012-06-27 2019-03-05 1002433857013 1 3caod 0 0           0 0 Rare Book o 1000 810.82 f263    
2006831 450973572911 1374145 2012-06-27 2018-07-03 0952953757012 1 3caod 0 0           0 0 Rare Book o 25000 598.097 efa916 1827    
2006836 450973572916 1374145 2012-06-27 2018-07-03 0952953857010 1 3caod 0 0           0 0 Rare Book o 25000 598.097 efa916 1827    
2006839 450973572919 1374145 2012-06-27 2024-07-09 0952953957018 1 3caod 0 0           0 0 Rare Book o 25000 598.097 efa916 1827    
2006844 450973572924 1374145 2012-06-27 2024-07-09 0952954057016 1 3caod 0 0           0 0 Rare Book o 25000 598.097 efa916 1827    
2049007 450973615087 1128296 2012-06-27 2019-04-03 0977967757013 1 3caod 0 0           0 0 Rare Book o 1500 810.82 f263 1946b    
2201148 450973767228 1532739 2012-06-28 2019-03-05 1002833057032 1 3caod 0 0           0 0 Rare Book o 1550 810.82 c625    
2225890 450973791970 1561589 2012-06-28 2019-06-10 1003243257014 1 3caod 0 0           0 0 Rare Book o 250 624.230977 e45    
2225905 450973791985 1561610 2012-06-28 2019-06-10 1003243457010 1 3caod 0 0           0 0 Rare Book o 20000 624.23 e45    
2352384 450973918464 1729749 2012-06-28 2019-03-05 1005753957016 1 3caod 0 0           0 0 Rare Book o 1000 810.82 f263 w    
2359117 450973925197 1737566 2012-06-28 2019-03-05 1005875857011 1 3caod 0 0           0 0 Rare Book o 1550 810.82 f263    
2359906 450973925986 1738495 2012-06-28 2019-03-05 1005891557017 1 3caod 0 0           0 0 Rare Book o 1550 810.82 c625    
2372072 450973938152 1504331 2012-06-28 2019-03-05 1006103057010 1 3caod 0 0           0 0 Rare Book o 750 810.82 f263 w    
2376314 450973942394 1509415 2012-06-28 2019-03-05 1006171657014 1 3caod 0 0           0 0 Rare Book o 1000 810.82 f263 w    
2384744 450973950824 1521564 2012-06-28 2019-06-10 1006328657016 1 3caod 0 0           0 0 Rare Book o 39350 810.82 b972    
2406400 450973972480 1551588 2012-06-29 2019-03-05 1006779157011 1 3caod 0 0           0 0 Rare Book o 1550 979.404 g481 zg    
2406700 450973972780 1551874 2012-06-29 2019-03-05 1006784257012 1 3caod 0 0           0 0 Rare Book o 532 810.82 b922 z    
2406702 450973972782 1551874 2012-06-29 2019-03-05 1006784357010 1 3caod 0 0           0 0 Rare Book o 532 810.82 b922 z    
2408675 450973974755 1554518 2012-06-29 2019-03-05 733900-1002 1 3caod 0 0           0 0 Rare Book o 1550 810.82 f263 x    
2409291 450973975371 1555453 2012-06-29 2019-03-05 1006841257013 1 3caod 0 0           0 0 Rare Book o 1550 810.82 c625    
2409387 450973975467 1555589 2012-06-29 2019-03-05 1006842957017 1 3caod 0 0           0 0 Rare Book o 1000 810.82 f263 z    
2419264 450973985344 1568147 2012-06-29 2019-03-05 1007001357015 1 3caod 0 0           0 0 Rare Book o 1550 810.82 c625    
2419620 450973985700 1568687 2012-06-29 2019-03-05 1007006357010 1 3caod 0 0           0 0 Rare Book o 1550 810.82 f263    
2419857 450973985937 1569115 2012-06-29 2019-03-05 1007010557019 1 3caod 0 0           0 0 Rare Book o 1550 810.82 f263    
2420357 450973986437 1569878 2012-06-29 2019-03-05 1007019657018 1 3caod 0 0           0 0 Rare Book o 1550 810.82 c625    
2420426 450973986506 1569974 2012-06-29 2019-03-05 735494-1003 1 3caod 0 0           0 0 Rare Book o 1550 810.82 c625    
2431197 450973997277 1587223 2012-06-29 2019-06-10 1007239357019 1 3caod 0 0           0 0 Rare Book o 1035 810.82 b972    
2431210 450973997290 1587246 2012-06-29 2019-06-10 1007239557014 1 3caod 0 0           0 0 Rare Book o 1035 810.82 b972    
2431225 450973997305 1587276 2012-06-29 2019-06-10 1007239857018 1 3caod 0 0           0 0 Rare Book o 1550 810.82 b972    
2431229 450973997309 1587276 2012-06-29 2019-06-10 1007239857026 1 3caod 0 0           0 0 Rare Book o 1035 810.82 b972    
2435830 450974001910 1594121 2012-06-29 2019-06-10 1007330557012 1 3caod 0 0           0 0 Rare Book o 1035 810.82 b972    
2435845 450974001925 1594154 2012-06-29 2019-06-10 1007330857016 1 3caod 0 0           0 0 Rare Book o 1035 810.82 b972    
2447946 450974014026 1610845 2012-06-29 2019-03-05 1007534857010 1 3caod 0 0           0 0 Rare Book o 532 810.82 b922    
2447983 450974014063 1610927 2012-06-29 2019-03-05 1007535757011 1 3caod 0 0           0 0 Rare Book o 532 810.82 b922    
2471044 450974037124 1309987 2012-06-29 2019-06-25 377177-2003 1 3caod 0 0           0 0 Rare Book o 1550 977.1 qh85 , 1904 1402162 v.01
2598826 450974164906 1836794 2012-06-29 2018-10-29 1028618557011 1 3caod 0 0           0 0 Rare Book o 1550 940.3771 qc57 1209561 v.01
2705413 450974271493 1626878 2012-06-29 2019-03-05 0978787657011 1 3caod 0 0           0 0 Rare Book o 20000 810.82 c625    
2739917 450974305997 1253987 2012-06-29 2019-03-05 0963423457018 1 3caod 0 0           0 0 Rare Book o 895 810.82 b922 z    
2743562 450974309642 1683140 2012-06-29 2019-03-05 0979640357013 1 3caod 0 0           0 0 Rare Book o 3500 810.82 c625    
2745466 450974311546 1690901 2012-06-29 2020-01-07 0997637257012 1 3caod 1 1 2019-09-04 2019-09-25 1 2019-07-10 2019-09-04 3 0 Rare Book o 1550 599.097 ffa916 1845 1502382 v.01
2745470 450974311550 1690901 2012-06-29 2020-01-07 1038929557014 1 3caod 1 1 2019-07-10 2019-07-31 1 2019-07-05 2019-07-10 2 0 Rare Book o 1550 599.097 ffa916 1845 1502383 v.02
2762247 450974328327 1885421 2012-06-29 2020-07-31 1032516957018 1 3caod 0 0           0 0 Rare Book o 20000 810.82 c625 w 1875    
2775978 450974342058 1722821 2012-06-29 2019-03-05 0980346457016 1 3caod 0 0           0 0 Rare Book o 8500 810.82 f263    
2816419 450974382499 1524534 2012-06-29 2019-03-05 0981169357010 1 3caod 0 0           0 0 Rare Book o 1550 320.1 w45 n    
2850938 450974417018 1337079 2012-06-29 2019-03-05 0965535457018 1 3caod 0 0           0 0 Rare Book o 1350 810.82 h48 ac    
2887995 450974454075 1364244 2012-06-29 2019-03-05 0966231457013 1 3caod 0 0           0 0 Rare Book o 1550 810.82 f263    
2925141 450974491221 1389895 2012-06-29 2019-03-05 0966935557019 1 3caod 0 0           0 0 Rare Book o 1550 810.82 h48 ac    
2956546 450974522626 1717577 2012-06-29 2019-03-05 0984245857011 1 3caod 0 0           0 0 Rare Book o 1550 320.150942 a427    
2980403 450974546483 1956536 2012-06-29 2018-07-03 1039676057018 1 3caod 1 1       2015-11-10 2015-11-13 2 0 Rare Book o 10000 099 r351    
5094479 450976660559 2769893 2012-07-02 2019-04-03 A000018775700 1 3caod 0 0           0 0 Rare Book o 1550 386.2232 qp6923s    
5094993 450976661073 2769968 2012-07-02 2019-04-03 A000019027051 1 3caod 0 0           0 0 Rare Book o 5000 386.2232 ql888 s    

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