Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/

6,722,751 rows

View and edit SQL

hash_row ▼ hold_id local_hold_id placed_epoch patron_record_hash record_id record_type_code record_num item_location_code agency_code_num checkin_statistics_group_code_num checkin_statistics_group_name s_location_code expires_epoch status pickup_location_code is_deleted deleted_epoch modified_epoch
000000ba314d2510e1d5788fde6311da 48668488 163286069548668488 1632860695 Ik+jhvoWMXqYp95AhcGkMxo7xKWFbS47ljMA8YKidHA= 450981913174 i 10347094 1padc 1 1   1 1664352000 i ge 0   1633091701
0000056db619627a7ab7b2f6ae2a9e01 37651149 155454898037651149 1554548980 szFihkqaTvaxB9S288WFtbeAw+GfO7Vgd0p9BK5csEE= 450981216565 i 9650485 shjf 15 120   ba 1586084980 i sh 0   1554827106
00000696c59b1862fdabd16feeffb3cf 42551474 158205594642551474 1582055946 UpacktloHYN8DV41S7Kx05TV/PCXI1P3V+ZRaiHUEZ8= 450980198330 i 8632250 grjeb 5 142   ch 1613591946 i gr 0   1582207502
00000864f7f4b0fae453b81fb2537576 48440199 163124188948440199 1631241889 jDBnrEzLzXAxnZND/8z16JKN9G6Y3hNdW6cI4BiixJc= 450982111813 i 10545733 mnaf 15 360   mo 1662710400 i mn 0   1631537402
00000b8aeb4c14e7ca78c67307c29902 44463838 160199717144463838 1601997171 9MRRdL3jupuMNHyEwE5WjSZzLOiwMbDxIVvbh9SGaLk= 450982125455 i 10559375 mnanf 23 350   mn   b mn 0   1601997301
00000ecdaed42842b02298baacf168df 43257188 158230274343257188 1582302743 +zvI+NKOLpDFqreoyCv6FTX1cFYafP5AMbJq/llqj9s= 450982182932 i 10616852 clal 1 140   ch 1613838743 i cl 0   1594050609
00000f12fb1a91c49ac97cedfd94712f 41563434 156511385041563434 1565113850 YokAVjB3/VCPPjKh/25KvavElb0RO3cLcnTXjs4Jd4w= 450982186713 i 10620633 bhaar 1 130   bh   i os 0   1577107501
000010cdc97c26994dce0bd2aa492fab 45052855 159955098645052855 1599550986 loZyuoRuzwkK5Bd7gobMELaOKw/l1BoVem1agI6+8mw= 450982396209 i 10830129 dpadt 1 120   ba 1631088000 i dp 0   1606230302
0000112695f70be18860fad3e0b3e0ef 43347820 158302027943347820 1583020279 GG8JwIJTeDR41Cz7SoypUcgZ1zPfo8Z6EFU5tfQtmsA= 450982336076 i 10769996 moaar 1 120   ba 1614556279 i mo 0   1594475409
000012e776046fe39b99ab0f6e97c786 44146928 159966397244146928 1599663972 FARMNiZRFoZYlZivUTjtiQ2+oXHbP+71fINuoaVWQsk= 450976138553 i 4572473 3ra 1 490   sm 1631174400 i lv 0   1600101902
00001431a4b42fb60ff6f911b228a8e4 37743479 155449754337743479 1554497543 2vVDrlA7xZVLSQDQ9D/YXn3vibBLToFJCoj8ykM133g= 450981889934 i 10323854 osjnf 32 0   1   i ch 0   1555346702
000016af8843c71af5a9644f1be76ed6 48542100 163190538348542100 1631905383 x7Wj1J4cuggE0PCbz9a+iievKyoEzamEEV3sNe+1GwU= 450981879994 i 10313914 lvjf 12 100   an 1663401600 i lv 0   1632230101
00001986b72d55aea27c90d9244d2d3d 47232148 162223452347232148 1622234523 hiVOUHLwYZGXcgc/y/2UzfmsUybl0fBV+p/unpnOy1Q= 450977252473 i 5686393 wyad 11 390   nr 1653724800 i wy 0   1622554201
00001b58d8fb6c2adaf74c8ba9b71e40 37142653 155189696537142653 1551896965 q7rKZIxGouCHtsNfRbsKuj0zpd6F1wlUyPQ3A1kgqT4= 450981792410 i 10226330 rejbi 17 260   gr 1583432965 i re 0   1552315207
00001c4a02b07f496dde602a517383f0 36847125 155037055036847125 1550370550 nmr50Eb/UPA+YBpa4XJKcxwGHYTP+Bs40c8MTJNKfQI= 450975476514 i 3910434 nsjnf 6 420   oa 1581906550 i ns 0   1550936407
00001ff288c8a8bd3f93c23d56f38eca 38009123 155662780138009123 1556627801 9eEt4NzeQjlvvzjDMgq/QWJg+1i6lpqvXzWmWzUBRzw= 450981816348 i 10250268 smanf 27 480   sh 1588163801 i sm 0   1556817007
000023659c00344252ddb36d8db773e0 46897634 161957073946897634 1619570739 G++bekYvS/wRF84UEO8Wk0Mqxhtrp0euSxfTBLq7/NQ= 450982405174 i 10839094 graf 1 260   gr 1651046400 b gr 0   1619616301
00002447be4d991220e41a3503f96aaa 42366408 158100878942366408 1581008789 HUFg53JaDEchggGt3OSzxYH1lPkyF9MxX7yIniB8WlI= 450978342805 i 6776725 wtjd 18 510   wt   b wt 0   1581022801
000025e0bda85cefba50ee1d39bf6f6e 48013771 162828202748013771 1628282027 N2rRqTcCi0lLsG0+Ht5kNEmVBhPsYlRcxksiuLcnc8w= 450977959404 i 6393324 haanf 20 490   sm 1659772800 i ha 0   1628522702
000027004e7c92f71996629cda8773ab 42273589 158050269342273589 1580502693 lHp3vKdpq6I/LTCTmx18eNCyybiwFJqs0KcEk0P4/EA= 450981629125 i 10063045 nwtf 2 320   ma 1612038693 i nw 0   1580834402
000029809ee81acf941e6a3370911f90 46948845 162000655246948845 1620006552 dRMv/08uSr/wvaDTbez8g1I4z5OpDP7TePEwmKwzuAM= 450976965306 i 5399226 dpanf 27 120   ba 1651542552 i dp 0   1620142202
000030adafbaf984c04a78e4788fc36f 46219557 161057283346219557 1610572833 xPIM0LJDJaxZtgkRhYzimQu1+29yLZ2qmSPVKSiEjF8= 450982527948 i 10961868 anadt 1 100   an   i 1w 0   1614627002
000031e61bffaafdf1715b757a05f96f 45914266 161219548445914266 1612195484 xwyBo/RO/+62ZS2oMEj8RI25j2kW09apzgNwH4+JikE= 450976626246 i 5060166 1lj 1 430   os 1643706000 i lv 0   1612447201
000041aad04d59c3116c54f5184fc1e5 35240619 153132205835240619 1531322058 KUJG0zCtfKqDEf4JxHdH0LyHtiWqVPe9ESnSMzW1NCk= 450981653746 i 10087666 cvaar 1 240   ge   i cv 0   1542123902
000044ae8ad4f985ce039eaea74abc8c 47686249 162577864247686249 1625778642 DBBQ8oA0WDU6x0psu5KljlrjDCDMs7zA9LS9SqSPzkM= 450975230088 i 3664008 osjnf 32 468   re 1657267200 i mo 0   1626180601
0000461974431572272528c4615199d4 38167764 155749246638167764 1557492466 2Z+TP8HQvwB4XgWPaq305rnW5AaAi+1Ycrpf1Rh6T5g= 450981699012 i 10132932 1fa 1 0   1 1589028466 i ge 0   1557765606
000046c90a9612155008f621d69aed83 39456637 155681976439456637 1556819764 Bxr6+Ca0MhXHJVILgHRO2yLHUwC1MysuHShdygyWIuM= 450981980007 i 10413927 shadn 15 490   sm   i sh 0   1565182507
000047884998be5d55708c343ea6d829 47891009 162723785047891009 1627237850 kfQAN7HRC0rY57Ucrbm78IXilvCWMG4JKzQhbATHRtE= 450982767953 i 11201873 smaab 1 342   mm 1658736000 i sm 0   1627563601
000048d2417d42e76c1d8bd897e66281 35019898 154058796235019898 1540587962 3M5HyIrFrI5jVEBYI1mWk72484J13qxSU8MpC2PbYIE= 450981157576 i 9591496 hpjeb 31 343   mm   i hp 0   1540910107
0000493c6e14b54dd88277aa2dee1445 35177495 154151949835177495 1541519498 69/DPZq//GTqq6HNLrGFirRioRZdFFRvF+EnFOrFKK4= 450978783553 i 7217473 mojgn 15 1   1 1573055498 i mo 0   1541688302
00004dfad07234138c84971134b38ddc 35689188 154406561535689188 1544065615 cXh6CD4X9G6uEnFy7XU7VfY1jvawHItHzMlNsEsEMCk= 450972739792 i 1173712 osjex 32 430   os 1575601615 i an 0   1544538007
00004e5847a1e1d17047d9e43002408a 36254619 154047588236254619 1540475882 gvAXOJNayKtJIhMYzPXzmEtQ22BXMLQA1bSQnZ7AxNU= 450981728515 i 10162435 wtadn 8 480   sh   i 1 0   1547686207
0000515f6e19daf8c2eef8291757b3a0 41841519 157808281141841519 1578082811 9gE4joXj4TzYdhI23K0fpup4918rHOLGmmdtCNhRjFc= 450976223202 i 4657122 osjnf 32 430   os 1609618811 i fo 0   1578674402
000051cd13223fe268dea1f102683913 35775265 154454787035775265 1544547870 7IdAflalM7qwNYSsuNyK5GnKeO109afS0fNsXSZr6vk= 450974855003 i 3288923 1paho 1 470   sb   i gr 0   1545058207
0000534144562c1b74070c3a223e046f 37843132 155550353537843132 1555503535 hFDo9AvERP3P3Ir6SEpdxye+VAw27O5LRHkFOobKzTM= 450977075927 i 5509847 maad 11 100   an 1587039535 i ma 0   1555950307
000057b3d24213dab0ced6966cfe2519 39724787 155431124139724787 1554311241 LXmlTjs5bFEJ01dFH9U7PFDsubTaBPAdXKdjG0mFv0A= 450982014094 i 10448014 anaar 1 100   an   b an 0   1566396607
00005d81e1dc0341ca7c34ee47ab4cf6 44357620 160002686744357620 1600026867 22DyNJ81rOXqI06XYLpMQaCOG86q1hGs3769/fgEUE0= 450982473382 i 10907302 tsaar 1 0   1 1631520000 i grw 0   1601386801
00005fe29fd27148eda35fae61cc686e 45799461 161149180245799461 1611491802 E1wUE1ofDvRwy5ykq+VByXFNoqDqURoag7Ztyg81BfQ= 450980241526 i 8675446 mwadt 37 360   mo 1643014800 i mw 0   1611672602
000060030ecbf57b0c0217c9c9146d24 36941234 155016766136941234 1550167661 ictoFWz8lHWn1tm4HRtaDG1J5gUaJSJ93e/iOqEeDV8= 450980398776 i 8832696 1pac 1 1   1 1581703661 i sh 0   1551115206
00006394117e627d66ac2856ac7c8e92 46176374 161410353246176374 1614103532 oCK5flVN1STGwO7j/zlr2h6j3SNL5XbMRToQI4nUf8Y= 450978893888 i 7327808 shtf 38 430   os 1645606800 i sh 0   1614261002
000063d3d14b5afd7f40366cfab2a999 34921195 153988347734921195 1539883477 Gc76YHj2BPLOn/Up4NGQ3kmkXntjWm43w4Cmdbw+bcc= 450975316464 i 3750384 1pac 1 1   1 1571419477 i wh 0   1540385706
0000651896e1d70613a56c4f51e38049 36624739 154934018936624739 1549340189 fDa2nP31L4d4WJhqaZyZvpMKplNPhDZp3P6TAoZaiWg= 450979075386 i 7509306 coad 33 372   mt 1580876189 i co 0   1549552206
000067c9d9f9ed2c2ff6812ef7f3d92b 49009439 163224236349009439 1632242363 G8GSG62dYu/H46BTiV6HzRXo/veKl+R//qqQE+2CmF8= 450982931222 i 11365142 mdaar 1 500   wh 1663747200 i md 0   1635772802
00006b1525c0b7d9342240aa221eb366 47918502 162749960847918502 1627499608 o6BpS13HKVLYKh7jogVnpCHAWPpOpwdtkQJ970cJ0BU= 450975421719 i 3855639 1fa 1 230   fo 1658995200 i sm 0   1627743302
00007172e2c696c52211d15dbaa5bc6b 48026042 162851718448026042 1628517184 e01nB9iHI37705NG+R8AXGdU1FpXWvVDwsjc+l2enR0= 450977625815 i 6059735 shjnf 28 480   sh 1660032000 i rew 0   1628598301
000071a00a18665ae7e0d579667c47b4 38771010 155993857838771010 1559938578 +D0AbUGKyaoQgmZWCkoYpfkn3qIR/kguI0bj+6MwLGc= 450981893188 i 10327108 geadt 38 360   mo 1591474578 i ge 0   1561466406
000075a1aacd3e9ad74fb2f263a4b929 42648282 158240945442648282 1582409454 6AwRuANlnRmDboMO9JNVG/sjqyZ8E44T55wE2up7K5A= 450981527314 i 9961234 wyjnf 20 100   an 1613945454 i wy 0   1582726801
0000763388594ccba9ac08e1dda3da14 47417134 162362896847417134 1623628968 iBLihlD547vcSdmmUTtrBPu/UAHDfFzX2DBgpvrjiso= 450974940879 i 3374799 1pac 1 1   1 1655107200 i sm 0   1623933602
0000770f4051a795998ad81e871efaab 49295717 162925744049295717 1629257440 LorGwJY7C8/wMKTlgqzu8x1cg/N/Y+fu3fEZ4uYFxDs= 450983028355 i 11462275 praar 1 0   1   i pr 0   1637762701
0000777e40d7e5b926934b023498dad6 42602726 157315345942602726 1573153459 +BCATRvy3ujW/dmWH1/ALO1P2P9qiI3nbGCdNuzwLew= 450982219070 i 10652990 foadn 1 350   mn   i fo 0   1582553102
00007f55aae390b5268bc1ac6c26e6b8 41087879 157383486341087879 1573834863 0xYuDaV9SUhGVJrDeG/nM1L0fnEQHB43aVMM9rNRbWk= 450980586603 i 9020523 baanf 2 120   ba 1605370863 b ba 0   1573847099
000080b0a237985256f8a0aada5b3aae 36020613 154644490036020613 1546444900 oyP/78o8VoCt833X3psgsZJ8i6Mb9E18IIURhFggr/8= 450981067546 i 9501466 cladt 38 120   ba   i cl 0   1546955706
00008a477b4055afc53616726e681a45 48908935 163449098448908935 1634490984 9Ffu0Yi4z/0dNGbkmu8V7hBkMoZasspWJRx8D8GaC/0= 450982982569 i 11416489 tstf 1 0   1 1665993600 i 1 0   1634826902
00008c7a58aa98ad5f1613e50b912cf8 48619551 163227242048619551 1632272420 dKrQniuvz8sBslVJEtUg+qAjE+j8GX25QDGH07lGEEU= 450980523151 i 8957071 osjnf 32 120   ba 1663747200 i ge 0   1632832502
00008cb7857f6a13253caa61b9f01d7c 36583241 154834080036583241 1548340800 ak/3c3JZxXMl0AE6rnUwMyCyXAb1tmAfMmlcDY3UWGw= 450980878361 i 9312281 dtanf 19 210   dt 1553500800 b dt 0   1549121706
00008d8536f57df9e67cdd62dd7a5d41 46082000 161344413246082000 1613444132 KL64sgw4Y8Lq4CzKr4RkPm6UQ8R6700LZrlsnMIeeb0= 450981688405 i 10122325 smjnf 4 300   hp 1644915600 i sm 0   1614000302
00009537f3756751e73312c36cd04b31 35833496 154508565035833496 1545085650 6S7/9XxpJaehO+YFOn5RyjsXakXipQMNO4Zr/FMhgxU= 450979574565 i 8008485 1padm 1 100   an 1576621650 i cl 0   1545313806
000095bbdf1df1bb09b32431f3713689 37802929 155130219937802929 1551302199 P6z95FO5aEPt1di3zW9GjJ6j02MLg8Z0w/KP8wvvuDs= 450981895274 i 10329194 pladn 12 490   sm   i pl 0   1555605306
00009cc25ab02131c91a91070008396e 49298479 163724456849298479 1637244568 PAfpWyzwI55IuQ+1EqvaREEgidvJ94RpNVSuFsnzUQU= 450982744870 i 11178790 majho 1 210   dt 1668762000 i ma 0   1637766901
00009d3c0d18401496fa269d3d6d08a8 35670054 154230476535670054 1542304765 HlTx2aQChU2dcw54Bh1CwjYW2XAg2BfLsbp4Zdz4954= 450981735017 i 10168937 maadn 35 0   1   i ma 0   1544539807
00009d5a926065ed847d513c93900c61 43967395 159846240743967395 1598462407 PjX+qXM07+3x4pSJ0vnyESNJ4jiuBoshNXlbTCg7/CM= 450975841892 i 4275812 3aa 1 468   re 1629964800 i ns 0   1598708101
0000a3f2545cd75bbc3caf0da2f1e0d9 40743571 157187750140743571 1571877501 lbsVHyITwu6x2M2LIfBDKVFTiMHVwda2ixwXYfYtlzE= 450974808609 i 3242529 1pac 1 500   wh 1603413501 i ns 0   1572097506
0000a59f2679db23d017f3ef5506ab39 39623655 156574331739623655 1565743317 6GiHywkr5UwMC1Kz3J6IkHaVTgHGJiPEFQQMREIvSN4= 450982055386 i 10489306 2ra 1 0   1 1597279317 i sm 0   1566219307
0000aacfb9974234650a7b6ff166481b 42209494 157315339642209494 1573153396 HBvONSy0yHjBPOl2wjWL1AQAMraDpp+i3pbLSfDEOJI= 450982218911 i 10652831 readn 1 530   wy   i re 0   1580393102
0000adb46006deef3385e951c56b8d72 46893704 161955117346893704 1619551173 C1J7a8b9cYUn4fXeMnVzj06/jx0yHOKisxRDZVpeMWk= 450979713289 i 8147209 mnadt 2 390   nr   i mn 0   1619705402
0000b072ef2f46c7b992341abe376af9 46032748 161301611446032748 1613016114 YdKqMP/n33+b+HgaSsS1VScqdDyTllwS6V05MHt9fq8= 450973303778 i 1737698 anjbi 19 490   sm 1644483600 i an 0   1613235301
0000b3c291b30d7c0206d5468b0d3f60 41011150 157343478941011150 1573434789 fkcuz581kLNnu/MR+FjFdKgcr9gbN5aQur+pM5j3NPc= 450979438609 i 7872529 dpanf 19 480   sh 1604970789 i dp 0   1573656902
0000b3fec54558b22a03deef1a4f7a26 34786574 153909381334786574 1539093813 XX2Ka07Az2g970xJBGbQAtlQ4kgrGQTt9EADzWNiILA= 450977905691 i 6339611 chac 19 100   an 1570629813 i ch 0   1539608401
0000b54df0c14b17289c2076a4493553 42852117 157628036042852117 1576280360 dK0FwrX4/HjPwX2Y9ye8wW3oLp7sh1IGarCJ2y9peTw= 450982210612 i 10644532 shadt 1 200   dp 1607816360 i sh 0   1583844601
0000b6507520a46557c6cda1da2b7e05 45078603 157851939945078603 1578519399 +SuAqsR6TDsH79SlzRTvdv/eREitlg6rFE404vKk53c= 450982405165 i 10839085 shaar 1 490   sm   i sh 0   1606310701
0000b9ebfa8da042517fa6aca318b116 40477356 156043770540477356 1560437705 U/jBDbdrOnhtJOON4HxNo0B2/DzpFClYTdKb9wnULls= 450982042802 i 10476722 lvadn 36 300   hp   i lv 0   1570626606
0000bcfb6b4e0f5c44fae74811594d6e 36471016 154853634536471016 1548536345 kHD4rzGk7Ur+8G5HuUzTHYQr6N7qEclvQ9ZDnAFKoU8= 450981599584 i 10033504 gradt 17 140   ch   i gr 0   1548770107
0000c001969d85b09e5c3fa2be35cffb 46836942 161905540246836942 1619055402 jr2L7FV/BaaNf8pkPJmcIQfBPyEsR+IcI0n9pnNP5dg= 450981656215 i 10090135 clanf 24 100   an 1650591402 i cl 0   1619273402
0000c5fb04054f1a7ef96cccf3570c17 40223181 156909429940223181 1569094299 ZYRnbhfot4zQGXMJUSSAnMy0y8J26WdU2QQtVGtlosM= 450977100527 i 5534447 prapl 4 360   mo 1600630299 i pr 0   1569422407
0000c7e9fcaf7c4ad63b0473a676bd6f 42816820 158342940442816820 1583429404 bj/+bI3r/cztMf50f2grD4aNPUzPVhbHGHr95Ezcp5I= 450977849349 i 6283269 shac 27 480   sh   i 1 0   1583769602
0000c8eeb6f8df56b39635bed3baf88b 38412903 155865425538412903 1558654255 ktbk4mLXCxyvrK7AA5Ew8oqKUHq0qi/l17ca1JgMnFg= 450980544137 i 8978057 moad 37 490   sm 1590190255 i mo 0   1559236206
0000cd225c408760ddad332956d7206f 43412917 159451839743412917 1594518397 ip7e4JvCpphKRsjYeITbFCj18wjMka8xl6t3LnWi/Yg= 450981497298 i 9931218 osjse 32 430   os 1626054397 i sm 0   1594840211
0000cd379dbd3b626baea6009786a776 41215595 157461110641215595 1574611106 vmMLBtzIUE75ccrKbGipsKAn2FYT0mIQhDVlNjpRXsU= 450981278677 i 9712597 mnanf 2 360   mo 1606147106 i mn 0   1574867102
0000d275098e221992ef93a7504d02bf 36678596 154956822936678596 1549568229 3DdjrQUs/krjudbFE4wfSymRyiYfNrpk5QbSMkpGMno= 450979754431 i 8188351 cladt 7 120   ba 1581104229 i cl 0   1549893602
0000d5355f31aba86995570c94538948 37889443 155130173137889443 1551301731 cni6NpWJKOdM4HA4HE6vPIgEIkhwysrUSGDioaVzIYg= 450981884402 i 10318322 cladn 2 0   1   i 1 0   1556115607
0000d56e0c30074418a6be10b830f75a 45976915 161271800645976915 1612718006 fNOpq82Ka0Pxs4pZFkax1PVbBByJumRLMHsvF1O+uN0= 450978238590 i 6672510 sbjnf 19 390   nr 1644224400 i sb 0   1612967701
0000d9aac6bd1d1be9394bc3fca35acf 49056763 163585852149056763 1635858521 tL1xq8ZQR5/LRcGNGuqObNn8ecf35EgpUgA0xKc6udY= 450977024466 i 5458386 gejse 36 100   an 1667376000 i ge 0   1636029301
0000da839b5f5c3152fca7910664458d 45324898 159813914545324898 1598139145 AS5wZTBgnvKlvyme1aIoylP6PgSkrRvUoM5ckbcTtYw= 450982433047 i 10866967 foaar 1 100   an 1629675145 i fo 0   1608132601
0000e117bc512646d43b5455436cbcf6 45071550 160598202545071550 1605982025 qdi/qNRROT967vtmAsOGmG1aDFkyHn5CHnhYaxYrfGE= 450979917589 i 8351509 pljf 12 100   an   i pl 0   1606748702
0000e6b39e7732dcf0c1416a26cc6fb8 36733194 154972547636733194 1549725476 15rt29S2AAhG5+oy0NWLynqOXK7e/1gtQ8lRyIRgG5Q= 450974634584 i 3068504 1lj 1 320   ma 1581261476 i nr 0   1550077507
0000e89e6eaf0c21efe0f473d3f5a03a 35102769 154101078935102769 1541010789 jy8DxCp2SGHw1+0rP89gHWkWSKzy8bUqrEiOuYS6vYc= 450978499869 i 6933789 shanf 4 200   dp 1572546789 i sh 0   1541425206
0000eca77073304bab0e02dc45a4de55 43826803 159752819643826803 1597528196 3T/wcnXsdgkMf84uOjNmhyU5Fm7u5dxEHUmCBM93tIc= 450982126288 i 10560208 osjcm 32 390   nr   b nr 0   1597528501
0000f0938290974357a47ff7315f0fb6 36779664 155010484636779664 1550104846 96G+ciDyxqUs6gJdm2XVmrPg2nzOpJwCooxaSUuItQE= 450977915411 i 6349331 maad 22 162   co 1581640846 b ma 0   1550106002
0000f218e8ff8bde334b72b22595cf3b 37252598 155245290337252598 1552452903 0MgKTbAGLVAyWmZ6FmbVFnuQgR6r7JuZPFHsvUICqlg= 450976203637 i 4637557 smaf 29 200   dp 1583988903 i sm 0   1553016602
0000f2219f95d3dc0eec7691342f6a81 37638909 155412635237638909 1554126352 HmpgI2B/k2Gq1vQs+aONXi1Cv2pifdMkTRqxIrl5J7E= 450980101059 i 8534979 avjnf 15 240   ge   i av 0   1554905106
0000f43ddc901402f658413fa7c25803 43416944 159414238943416944 1594142389 w0jMPX0PUuuyFTVTs/5OdUy1YYg0+MvB/K290Q8WESU= 450981789356 i 10223276 smjbi 37 480   sh   i sm 0   1594919410
0000f46c1142c65b99e3507231be21ee 38270569 155785898838270569 1557858988 ZEMfvLLGMH297alp+a+Xa1FZSTT0EzNg2JUYR79C9q4= 450981948278 i 10382198 dtaar 2 0   1 1589394988 i dt 0   1558438207
0000f994968019614d499794ee598e91 47496267 162435509247496267 1624355092 XqSXlBq5Nc1juvH38U+7lPSQk7lMf6I5d2EEwrrJ5zk= 450982164201 i 10598121 planf 17 260   gr 1655884800 i pl 0   1624452601
0000fd2694be83b4232caaa2e3221abb 35785418 154153342635785418 1541533426 r/CzaeKAD8asnIB2s6rQCQnW1GAon7J+RV0D1f3pBYw= 450981673600 i 10107520 graar 1 490   sm 1573069426 i grw 0   1545233106
0000fe1517ece55552471b13148b8c59 38672145 155447544738672145 1554475447 b19xE/DYPIhrdjJYtAPtE8BWQBxeDHA0GyPg1mX1744= 450981965995 i 10399915 smadt 5 490   sm 1586011447 i rew 0   1560962406
0001059e19f7b17bbed9e1ecdf888327 43427029 158093535743427029 1580935357 AByKF2HsgH202jlMatCDoeQx10iiVT1RkjZHNXIIBmY= 450982405306 i 10839226 geaar 1 0   1   i ge 0   1594902911
00010ddad95e914f6370ee08e9bfbc11 40024670 156280795540024670 1562807955 3VK6mF9F5LtgMVhU5Lh2XlA4b5IT54EKddwmPzHZqRA= 450982066442 i 10500362 maadt 14 0   1 1594343955 i ma 0   1568294107
000113d0da9a6be209616796e7f01c78 42645220 157802506142645220 1578025061 esOj7tx0HsDmUhtfAAg4JYUGac2TG85JyynkXUJqPyA= 450982304744 i 10738664 ghadn 1 41   1   i gh 0   1582725901
00011541ed9fb81968804b9262820f1f 48695842 162946552948695842 1629465529 9IZsL0XkXd7lEAM1Y92kF3Ur4LeoUAd+pwR5v6fsgjs= 450982964031 i 11397951 tsadn 1 0   1   i 1w 0   1633449302
000115b956fd01dbd24843a62c630214 36704737 154968498536704737 1549684985 Pyb7e7Th7iUDKbHl7CMXGufMhkzFrbQWcmOrPGwRTdU= 450980619176 i 9053096 anad 38 100   an 1581220985 b an 0   1549730406

Next page

Advanced export

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

CSV options:

CREATE TABLE "holds_shelf" (
    `hold_id` INTEGER,
    `local_hold_id` INTEGER,
    `hash_row` TEXT UNIQUE PRIMARY KEY, -- so we can track changes made to the row
    `placed_epoch` INTEGER,
    `patron_record_hash` TEXT, -- 
    -- `patron_record_id` INTEGER,
    -- `patron_record_num` INTEGER,
    `record_id` INTEGER,
    `record_type_code` TEXT,
    `record_num` INTEGER,
    `item_location_code` TEXT,
    `agency_code_num` INTEGER,
    `checkin_statistics_group_code_num` INTEGER,
    `checkin_statistics_group_name` TEXT,
    `s_location_code` TEXT,
    -- `is_frozen` INTEGER,
    -- `delay_days` INTEGER,
    `expires_epoch` INTEGER,
    `status` INTEGER,
    -- `is_ir` INTEGER,
    `pickup_location_code` TEXT,
    -- `is_ill` INTEGER,
    -- `note` TEXT,
    -- `ir_pickup_location_code` TEXT,
    -- `ir_print_name` TEXT,
    -- `is_ir_converted_request` INTEGER,
    -- `patron_records_display_order` INTEGER,
    -- `records_display_order` INTEGER,
    `is_deleted` INTEGER NOT NULL DEFAULT 0,
    `deleted_epoch` INTEGER,
    `modified_epoch` INTEGER
);