item

102 rows where location_code = "3gard"

✎ 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, renewal_total, item_format, item_status_code, 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
1000124 450972566204 1870204 2012-06-22 2025-02-27 1041604053010 1 3gard 0 0           0 0 Reference Book o 400 977.1 h67 , v. 20, no. 1 1000001 v.20 no.01
1018413 450972584493 1813670 2012-06-23 2024-12-12 1043979853024 1 3gard 1 1 2016-04-12 2019-05-21 dc 2016-04-04 2016-04-12 4 5 Reference Book o 400 917.71780443 g326    
1096865 450972662945 2049363 2012-06-23 2013-01-04 4900582253024 1 3gard 0 0           21 0 Reference Book o 450 917.68 f29 t    
1170246 450972736326 2074205 2012-06-23 2013-01-04 6803069453042 1 3gard 0 0           0 0 Reference Book o 850 973.52471 qo37    
1228846 450972794926 1067136 2012-06-24 2013-01-04 0924473353234 1 3gard 0 0           0 0 Reference Book o 3995 977.178 qg459 1988    
1293213 450972859293 2415915 2012-06-24 2019-06-17 8205064652115 1 3gard 0 0           0 0 Reference Book o 1495 977.178 qs582 1982    
1452370 450973018450 2555051 2012-06-26 2016-09-06 1781471-1001 1 3gard 0 0           0 0 Globe o 4997 523.30223 r425 1970    
1452374 450973018454 2555130 2012-06-26 2016-09-06 1781484-1001 1 3gard 0 0           0 0 Globe o 12000 523.430223 r425 1993    
1455928 450973022008 2560690 2012-06-26 2013-01-05 1782496-1001 1 3gard 0 0           0 0 Globe o 4995 912 r425 l    
1455934 450973022014 2560697 2012-06-26 2016-09-06 1782498-1001 1 3gard 0 0           0 0 Globe o 4995 912 n277 g 1984    
1457816 450973023896 2563471 2012-06-26 2016-09-06 1783011-1001 1 3gard 0 0           0 0 Globe o 6699 912 n277 g 1961    
1457823 450973023903 2563477 2012-06-26 2016-09-06 1783012-1001 1 3gard 0 0           0 0 Globe o 60000 523.8 r187 1977    
1458275 450973024355 2564584 2012-06-26 2013-01-05 1783213-1001 1 3gard 0 0           0 0 Globe o 50000 912 r425    
1460891 450973026971 2568909 2012-06-26 2013-01-05 1784014-1001 1 3gard 0 0           0 0 Globe o 4999 912 r425    
1480627 450973046707 2617622 2012-06-26 2021-01-27 1793671-1003 1 3gard 0 0           0 0 Reference Book o 5000 929.2 qb959 zb 2008    
1485153 450973051233 1110086 2012-06-26 2018-09-04 0931881853028 1 3gard 0 0           0 0 Reference Book o 3571 973.74 u58 1491860 Index
1534978 450973101058 2464143 2012-06-26 2019-01-01 1581450-1003 1 3gard 1 1       2018-09-13 2018-09-19 1 0 Reference Book o 2195 912.77177 qr187 , 2004    
1542548 450973108628 2493134 2012-06-26 2013-01-05 1583709-1001 1 3gard 0 0           0 0 Reference Book o 4995 929.1072073 qa538    
1549175 450973115255 2755015 2012-06-26 2022-02-01 A000026260059 1 3gard 0 0           0 0 Reference Book o 5000 917.717806 qd114 1988 index    
1582649 450973148729 2530801 2012-06-26 2013-01-05 A000014975387 1 3gard 0 0           0 0 Reference Book o 200 338.097717 qa883 1038445 2011
1610658 450973176738 2629817 2012-06-26 2013-01-05 1611769-2001 1 3gard 0 0           0 0 Reference Book o 3595 912.43 ffa191    
1731061 450973297141 2574033 2012-06-27 2013-01-05 1659409-1001 1 3gard 0 0           0 0 Map o 1550 912.73 m297    
1745886 450973311966 2537685 2012-06-27 2013-01-05 A000028700656 1 3gard 0 0           0 0 Reference Book o 3000 929.20973 qf974 1053481 v.02
1752844 450973318924 3220568 2012-06-27 2016-09-27 1668989-2003 1 3gard 0 0           0 0 Map - 1550 912.77178 t743 1792    
1829731 450973395811 2746012 2012-06-27 2013-01-05 1695166-1001 1 3gard 0 0           0 0 Book o 537 912.77252 c581    
1920303 450973486383 2712431 2012-06-27 2013-01-05 1747989-1001 1 3gard 0 0           0 0 Reference Book o 600 929.377115 qh522 j    
1948681 450973514761 1002792 2012-06-27 2014-05-21 0935573653018 1 3gard 0 0           0 0 Reference Book o 500 016.97710025 p564    
1951822 450973517902 1004990 2012-06-27 2016-12-13 0935680353056 1 3gard 0 0           0 0 Reference Book o 1500 920 qj62 1872a    
1969486 450973535566 1440148 2012-06-27 2013-01-05 0968176353017 1 3gard 0 0           0 0 Reference Book o 1350 974.818 qk29 1073316 v.01
1969490 450973535570 1440148 2012-06-27 2013-01-05 0968176553012 1 3gard 0 0           0 0 Reference Book o 1350 974.818 qk29 1073317 v.02
1969494 450973535574 1440148 2012-06-27 2013-01-05 0968176753018 1 3gard 0 0           0 0 Reference Book o 1350 974.818 qk29 1073318 v.03
2010061 450973576141 1623383 2012-06-27 2025-02-25 0986585852015 1 3gard 0 0           0 0 Reference Book o 100 977.178020922 fc574 1960    
2022616 450973588696 1058216 2012-06-27 2013-01-05 0955970253014 1 3gard 0 0           0 0 Reference Book o 5500 016.9292 qd238    
2114533 450973680613 1121841 2012-06-27 2013-01-05 0907577253012 1 3gard 0 0           0 0 Reference Book o 2915 974.812 qm788 1101585 v.01
2114534 450973680614 1121841 2012-06-27 2013-01-05 0907577353010 1 3gard 0 0           0 0 Reference Book o 2915 974.812 qm788 1101586 v.02
2155098 450973721178 1454750 2012-06-27 2013-01-05 0948683953012 1 3gard 0 0           0 0 Reference Book o 1500 974.8190043931 qw427    
2164584 450973730664 1136055 2012-06-27 2013-01-05 0909293253011 1 3gard 0 0           0 0 Reference Book o 1950 929.309771 qp882 e    
2204424 450973770504 1953448 2012-06-28 2013-01-05 1019279453012 1 3gard 0 0           0 0 Reference Book o 2550 974.812 ql256    
2210286 450973776366 1960008 2012-06-28 2013-01-05 1019387953010 1 3gard 0 0           0 0 Reference Book o 1250 974.8 qs846 pen 1124550 v.01
2210289 450973776369 1960008 2012-06-28 2013-01-05 1019388053018 1 3gard 0 0           0 0 Reference Book o 1250 974.8 qs846 pen 1124552 v.02
2210292 450973776372 1960008 2012-06-28 2013-01-05 1019388153016 1 3gard 0 0           0 0 Reference Book o 1250 974.8 qs846 pen 1124553 v.03
2210298 450973776378 1960008 2012-06-28 2013-01-05 1019388253014 1 3gard 0 0           0 0 Reference Book o 1250 974.8 qs846 pen 1124554 v.04
2212075 450973778155 1962158 2012-06-28 2013-01-05 1019416253010 1 3gard 0 0           0 0 Reference Book o 600 974.813 qw523    
2212091 450973778171 1962173 2012-06-28 2013-01-05 1019416553013 1 3gard 0 0           0 0 Reference Book o 1550 974.814 qj8 1125073 v.02
2212094 450973778174 1962173 2012-06-28 2013-01-05 1019416653011 1 3gard 0 0           0 0 Reference Book o 1550 974.814 qj8 1125075 v.03
2212121 450973778201 1962196 2012-06-28 2013-01-05 1019416953015 1 3gard 0 0           0 0 Reference Book o 1875 974.814 qp173 1125095 v.01
2212126 450973778206 1962196 2012-06-28 2013-01-05 1019417053013 1 3gard 0 0           0 0 Reference Book o 1875 974.814 qp173 1125096 v.02
2212203 450973778283 1962266 2012-06-28 2013-01-05 1019417853016 1 3gard 0 0           0 0 Reference Book o 1550 974.815 qe47    
2212405 450973778485 1962531 2012-06-28 2013-01-05 1019420753013 1 3gard 0 0           0 0 Reference Book o 400 974.816 qb716    
2212510 450973778590 1962669 2012-06-28 2013-01-05 1019422453018 1 3gard 0 0           0 0 Reference Book o 7500 974.817 qh673    
2212524 450973778604 1962676 2012-06-28 2013-01-05 1019422553015 1 3gard 0 0           0 0 Reference Book o 1750 974.817 qs297 1125218 v.01
2212527 450973778607 1962676 2012-06-28 2013-01-05 1019422653013 1 3gard 0 0           0 0 Reference Book o 1750 974.817 qs297 1125219 v.02
2213345 450973779425 1963687 2012-06-28 2013-01-05 1019434053012 1 3gard 0 0           0 0 Reference Book o 1550 974.831 qm49    
2214221 450973780301 1964678 2012-06-28 2013-01-05 1019444953011 1 3gard 0 0           0 0 Reference Book o 250 974.831 qm49    
2222590 450973788670 1558095 2012-06-28 2013-01-05 1003196453016 1 3gard 0 0           0 0 Reference Book o 2500 974.812 qg558    
2235096 450973801176 1487254 2012-06-28 2013-01-06 1016054253013 1 3gard 0 0           0 0 Reference Book o 3500 352.387213 qs7241 1129576 4th_ed. 1998
2262410 450973828490 1831810 2012-06-28 2013-01-06 1041143453010 1 3gard 0 0           0 0 Reference Book o 1295 929.1072073 c698    
2306908 450973872988 1282568 2012-06-28 2025-02-27 474949-1002 1 3gard 0 0           0 0 Book o 1550 974.827 qr64 1147181 v.01
2306917 450973872997 1282568 2012-06-28 2025-02-27 474949-2002 1 3gard 0 0           0 0 Book o 1550 974.827 qr64 1147183 v.02
2306922 450973873002 1282568 2012-06-28 2025-02-27 474949-3002 1 3gard 0 0           0 0 Book o 1550 974.827 qr64 1147185 v.03
2320316 450973886396 1214284 2012-06-28 2019-08-26 0913005453026 1 3gard 0 0           0 0 Reference Book o 3595 911 qs54 1980    
2357353 450973923433 1088885 2012-06-28 2013-01-06 0936790352012 1 3gard 0 0           0 0 Reference Book o 17500 333.330977 efr288 1159652 v.03 Aerial map
2398420 450973964500 1346114 2012-06-29 2013-01-06 0972259453017 1 3gard 0 0           0 0 Reference Book o 7000 974.832 qb812    
2425772 450973991852 1577372 2012-06-29 2013-01-06 1007120553015 1 3gard 0 0           0 0 Reference Book o 5545 016.9293415 qr988    
2449624 450974015704 1613822 2012-06-29 2013-01-06 1007569953015 1 3gard 0 0           0 0 Reference Book o 1550 917.7199 a9    
2465188 450974031268 1849226 2012-06-29 2013-01-06 1025581553019 1 3gard 0 0           0 0 Reference Book o 4625 974.802 qk28    
2517819 450974083899 1343312 2012-06-29 2013-01-06 0959157053023 1 3gard 0 0           0 0 Reference Book o 1795 929.1072073 l187    
2526674 450974092754 1722940 2012-06-29 2013-01-06 1009203153010 1 3gard 0 0           0 0 Reference Book o 1550 974.81005 qp451 1195517 v.05 1927
2526678 450974092758 1722940 2012-06-29 2013-01-06 1014011353018 1 3gard 0 0           0 0 Reference Book o 1550 974.81005 qp451 1195518 v.03-04:no.01 1924:Aug.-1926:Apr.
2526680 450974092760 1722940 2012-06-29 2013-01-06 1016111953019 1 3gard 0 0           0 0 Reference Book o 2550 974.81005 qp451 1195519 v.12:no.3/4 1934:Oct.
2526683 450974092763 1722940 2012-06-29 2013-01-06 1016127253016 1 3gard 0 0           0 0 Reference Book o 1550 974.81005 qp451 1195520 v.01 1921:Dec.-1922:Dec.
2526688 450974092768 1722940 2012-06-29 2013-01-06 1016127553019 1 3gard 0 0           0 0 Reference Book o 1300 974.81005 qp451 1195521 v.02 1923
2556997 450974123077 1370828 2012-06-29 2013-01-06 0959866353029 1 3gard 0 0           0 0 Reference Book o 200 016.929373 qu58    
2557000 450974123080 1370828 2012-06-29 2013-01-06 0959866353037 1 3gard 0 0           0 0 Reference Book o 200 016.929373 qu58    
2618741 450974184821 1418060 2012-06-29 2013-01-06 0961090253017 1 3gard 0 0           0 0 Reference Book o 6168 974.8 qr561    
2618745 450974184825 1418060 2012-06-29 2013-01-06 0961090353015 1 3gard 0 0           0 0 Reference Book o 6166 974.8 qr561    
2618749 450974184829 1418060 2012-06-29 2013-01-06 0961090453013 1 3gard 0 0           0 0 Reference Book o 6166 974.8 qr561    
2620046 450974186126 1878932 2012-06-29 2025-02-26 1029141553014 1 3gard 0 0           0 0 Reference Book o 5000 917.71003 o96    
2652827 450974218907 1945891 2012-06-29 2013-01-06 1029987353016 1 3gard 0 0           0 0 Reference Book o 1050 974.812 qh449 h    
2672460 450974238540 1456846 2012-06-29 2013-01-06 0962139953013 1 3gard 0 0           0 0 Reference Book o 40665 912.77178 efc574    
2672461 450974238541 1456846 2012-06-29 2013-01-06 0962140253015 1 3gard 0 0           0 0 Reference Book o 40666 912.77178 efc574    
2672464 450974238544 1456846 2012-06-29 2013-01-06 0962140353013 1 3gard 0 0           0 0 Reference Book o 40665 912.77178 efc574    
2684230 450974250310 1714582 2012-06-29 2013-01-06 1012556353013 1 3gard 0 0           0 0 Reference Book o 3349 929.1072 qs751    
2746482 450974312562 1258721 2012-06-29 2013-01-06 0963542653018 1 3gard 0 0           0 0 Reference Book o 1200 974.812 qm429    
2757351 450974323431 1815797 2012-06-29 2013-01-06 1014000553016 1 3gard 0 0           0 0 Reference Book o 4600 974.81005 qp45 a 1242752 v.01-03 1894:Sept.-1901:Apr.
2773809 450974339889 1909255 2012-06-29 2023-02-07 1032805549013 1 3gard 0 0           0 0 Reference Book o 168100 305.896 qs369 zs 1991 index    
2798207 450974364287 1957140 2012-06-29 2013-01-06 1033440753036 1 3gard 0 0           0 0 Reference Book o 1550 974.822 qn87 1251176 v.01
2798215 450974364295 1957149 2012-06-29 2013-01-06 1033440853018 1 3gard 0 0           0 0 Reference Book o 1550 974.822 qn87 1251177 v.01 suppl.
2798223 450974364303 1957161 2012-06-29 2013-01-06 1033440953016 1 3gard 0 0           0 0 Reference Book o 1550 974.822 qn87 1251178 v.02
2801233 450974367313 1301544 2012-06-29 2025-02-25 0964615753016 1 3gard 0 0           0 0 Reference Book o 1550 974.816 qh6731    
2802819 450974368899 1019159 2012-06-29 2018-01-01 0901325753027 1 3gard 1 1       2016-09-14 2016-09-30 4 1 Reference Book o 75 977 b219    
2812522 450974378602 1892053 2012-06-29 2013-01-06 1015074553014 1 3gard 0 0           0 0 Reference Book o 2050 974.813 qc915 t    
2814421 450974380501 1980089 2012-06-29 2013-01-06 1033785949017 1 3gard 0 0           0 0 Reference Book o 1995 282.77178 fh972 h    
2843250 450974409330 1332566 2012-06-29 2025-02-25 0965418553024 1 3gard 0 0           0 0 Reference Book o 1550 974.811 qy73 1261441 v.01
2843257 450974409337 1332566 2012-06-29 2025-02-25 0965418653022 1 3gard 0 0           0 0 Reference Book o 1550 974.811 qy73 1261442 v.02
2857272 450974423352 1950169 2012-06-29 2013-01-06 1015935153012 1 3gard 0 0           0 0 Reference Book o 3050 974.815 qw825    
2911111 450974477191 1794443 2012-06-29 2015-03-26 810196-6001 1 3gard 0 0           0 0 Reference Book o 1000 338.709771 ffb979    
2941876 450974507956 1782328 2012-06-29 2013-01-06 1037511853013 1 3gard 0 0           0 0 Reference Book o 850 974.812 qh449 s    
2947675 450974513755 1700198 2012-06-29 2017-01-18 0984012752015 1 3gard 0 0           0 0 Reference Book o 1550 349.77178 c574 a 1835    
3109627 450974675707 1662430 2012-06-29 2019-07-09 0983440053012 1 3gard 0 0           1 0 Reference Book o 2645 977.178 ft384 , 1995    
4190288 450975756368 1992241 2012-06-30 2018-03-22 1036980153046 1 3gard 0 0           32 5 Reference Book o 4499 929.10285 qh859 c    
8131865 450979697945 3021447 2015-02-06 2018-07-03 A000048412126 1 3gard 0 0           0 0 Reference Book o 0 016.30460973 qu58 1971    

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