holds_shelf

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

6,857,951 rows

✎ View and edit SQL

This data as json, CSV (advanced)

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 rRSPocM7sEcmZxysArnNfKuGatT8HxeRodJx30gemc8= 450981913174 i 10347094 1padc 1 1   1 1664352000 i ge 0   1633091701
0000056db619627a7ab7b2f6ae2a9e01 37651149 155454898037651149 1554548980 7gBabjz8XwTWgScUgeZeqO1Yejd9cKJKyRXezm92rnM= 450981216565 i 9650485 shjf 15 120   ba 1586084980 i sh 0   1554827106
00000696c59b1862fdabd16feeffb3cf 42551474 158205594642551474 1582055946 DxMtwk9Kx+YSKqXqJi0vEs4vIDXHg+uuE7XfZYu+hDk= 450980198330 i 8632250 grjeb 5 142   ch 1613591946 i gr 0   1582207502
00000864f7f4b0fae453b81fb2537576 48440199 163124188948440199 1631241889 sR8X13lOgYerVuQBaUlVW9uyRIEvR3JjY2c9g3TvLWo= 450982111813 i 10545733 mnaf 15 360   mo 1662710400 i mn 0   1631537402
00000b8aeb4c14e7ca78c67307c29902 44463838 160199717144463838 1601997171 o5ZXUkfA+TEyTO788KjG9pYjtuqE9sWBaA+nQMI4TdY= 450982125455 i 10559375 mnanf 23 350   mn   b mn 0   1601997301
00000ecdaed42842b02298baacf168df 43257188 158230274343257188 1582302743 GfLKT/aXrxfn/NWlDi6Ay7rfbg1i5lI2pBU3/iemzUc= 450982182932 i 10616852 clal 1 140   ch 1613838743 i cl 0   1594050609
00000f12fb1a91c49ac97cedfd94712f 41563434 156511385041563434 1565113850 B7GpsBf2iTYYl7ZEUawlO0IbJzKKP6DAZVf0WZEZQDY= 450982186713 i 10620633 bhaar 1 130   bh   i os 0   1577107501
000010cdc97c26994dce0bd2aa492fab 45052855 159955098645052855 1599550986 /7/F94qlgYGplcgwdK/6Ex2eUVTuagal+864GGdwmAg= 450982396209 i 10830129 dpadt 1 120   ba 1631088000 i dp 0   1606230302
0000112695f70be18860fad3e0b3e0ef 43347820 158302027943347820 1583020279 dII3xHoA5PlGCnlyuZj1V6HQ6ijFFJMrPFdYwVrTlsg= 450982336076 i 10769996 moaar 1 120   ba 1614556279 i mo 0   1594475409
000012e776046fe39b99ab0f6e97c786 44146928 159966397244146928 1599663972 NK+uR6uAzgWUT0cmSaKOyzfTooqpVAlRBCOXx2GE+cY= 450976138553 i 4572473 3ra 1 490   sm 1631174400 i lv 0   1600101902
00001431a4b42fb60ff6f911b228a8e4 37743479 155449754337743479 1554497543 p9K1591Sybfyc1SIfVp6cf8HIhYRdqmvKpQ1Bxen/Go= 450981889934 i 10323854 osjnf 32 0   1   i ch 0   1555346702
000016af8843c71af5a9644f1be76ed6 48542100 163190538348542100 1631905383 TlMPfiSFD0BRRkBY2CZVeCxPsSZVyLBkvcyX7tiPrd0= 450981879994 i 10313914 lvjf 12 100   an 1663401600 i lv 0   1632230101
00001986b72d55aea27c90d9244d2d3d 47232148 162223452347232148 1622234523 e29RMJUOxWFC6p4uF81rWdmGFAdCr9LYYGgStLRXJlc= 450977252473 i 5686393 wyad 11 390   nr 1653724800 i wy 0   1622554201
00001b58d8fb6c2adaf74c8ba9b71e40 37142653 155189696537142653 1551896965 0Fm/KFIK9M3f7mtQx0loPwQO3H+OJSqHe4r0Wru/+fA= 450981792410 i 10226330 rejbi 17 260   gr 1583432965 i re 0   1552315207
00001c4a02b07f496dde602a517383f0 36847125 155037055036847125 1550370550 Zqs3XjlIbWjf47/b6trmJ2IdsJw16Q6HBOghTizzfro= 450975476514 i 3910434 nsjnf 6 420   oa 1581906550 i ns 0   1550936407
00001ff288c8a8bd3f93c23d56f38eca 38009123 155662780138009123 1556627801 7JgQYXbr5f9us6tuLn5vWdrEk55X9wmM7x5XUauG/qE= 450981816348 i 10250268 smanf 27 480   sh 1588163801 i sm 0   1556817007
000023659c00344252ddb36d8db773e0 46897634 161957073946897634 1619570739 o6P/e2WoA5KRwkc1Z8Nhc1XA2XdjAqa0RwcosyTnliA= 450982405174 i 10839094 graf 1 260   gr 1651046400 b gr 0   1619616301
00002447be4d991220e41a3503f96aaa 42366408 158100878942366408 1581008789 gIDpgnHLRsTomaOQE6SgEP/ni5QAzKJvcCk/vWeQXUQ= 450978342805 i 6776725 wtjd 18 510   wt   b wt 0   1581022801
000025e0bda85cefba50ee1d39bf6f6e 48013771 162828202748013771 1628282027 3+WWUiLmu9QhQaTjQzHCnnWeFp8rL7V+WnOXeOhqrsM= 450977959404 i 6393324 haanf 20 490   sm 1659772800 i ha 0   1628522702
000027004e7c92f71996629cda8773ab 42273589 158050269342273589 1580502693 iMxcMCavuOVAp9x9G2shAMpW8vZnj4TyZwndeG864Qg= 450981629125 i 10063045 nwtf 2 320   ma 1612038693 i nw 0   1580834402
000029809ee81acf941e6a3370911f90 46948845 162000655246948845 1620006552 xlGygrVxplICW4HJcHRrKcpJ1wATukck4UOZIePstVY= 450976965306 i 5399226 dpanf 27 120   ba 1651542552 i dp 0   1620142202
000030adafbaf984c04a78e4788fc36f 46219557 161057283346219557 1610572833 s4V1n0L73XMHCeQHdeAl5ji3cFUlsSRGg0h4xkWAd/M= 450982527948 i 10961868 anadt 1 100   an   i 1w 0   1614627002
000031e61bffaafdf1715b757a05f96f 45914266 161219548445914266 1612195484 0/JXWcm70P4UHGKsl90f7DsLd2DriurB1w2zXLjO4kI= 450976626246 i 5060166 1lj 1 430   os 1643706000 i lv 0   1612447201
000041aad04d59c3116c54f5184fc1e5 35240619 153132205835240619 1531322058 D39Kfvy/YxrBTEJzXgNwHqgjGs4rN/syfEZ55mOl+OQ= 450981653746 i 10087666 cvaar 1 240   ge   i cv 0   1542123902
000044ae8ad4f985ce039eaea74abc8c 47686249 162577864247686249 1625778642 bVxx5a9jQ1Eikmxi4t55xJ0d/5+RD4QJ215fPPzHn00= 450975230088 i 3664008 osjnf 32 468   re 1657267200 i mo 0   1626180601
0000461974431572272528c4615199d4 38167764 155749246638167764 1557492466 NDXg0qGEAFcfoFvi2LfXhAEzvkSF1RFyStzt9L7sBjs= 450981699012 i 10132932 1fa 1 0   1 1589028466 i ge 0   1557765606
000046c90a9612155008f621d69aed83 39456637 155681976439456637 1556819764 Q+Otz+cdFevyz9uVnegbcce8GEXAYwvGv23sO1DOfHo= 450981980007 i 10413927 shadn 15 490   sm   i sh 0   1565182507
000047884998be5d55708c343ea6d829 47891009 162723785047891009 1627237850 6SsJyzRRDHz4luKa17/bV2iBiLfB+up3DuvW8HTdfc0= 450982767953 i 11201873 smaab 1 342   mm 1658736000 i sm 0   1627563601
000048d2417d42e76c1d8bd897e66281 35019898 154058796235019898 1540587962 a+XNmTFbT4FJ0PdjphZgysZLzw3wZljERvvGLsuTHt8= 450981157576 i 9591496 hpjeb 31 343   mm   i hp 0   1540910107
0000493c6e14b54dd88277aa2dee1445 35177495 154151949835177495 1541519498 PCoxjJDXMbpltQQSfR8JUHOTZ4yN6WwoPwQoHHCsnYk= 450978783553 i 7217473 mojgn 15 1   1 1573055498 i mo 0   1541688302
00004dfad07234138c84971134b38ddc 35689188 154406561535689188 1544065615 cmTvwNYuLBPe4RYUnLfDAPGNIrXZqQOs9ZQm0iK6UwU= 450972739792 i 1173712 osjex 32 430   os 1575601615 i an 0   1544538007
00004e5847a1e1d17047d9e43002408a 36254619 154047588236254619 1540475882 5+7HX9lGtbKLp8GIFe4ez/Pp6JrIQUe03vuQPH57gr8= 450981728515 i 10162435 wtadn 8 480   sh   i 1 0   1547686207
0000515f6e19daf8c2eef8291757b3a0 41841519 157808281141841519 1578082811 p7H+4ZJnDPQx1uvfQy/Im965Iv+6gtOluDPJiqoJs7U= 450976223202 i 4657122 osjnf 32 430   os 1609618811 i fo 0   1578674402
000051cd13223fe268dea1f102683913 35775265 154454787035775265 1544547870 k2BdePYUigCRO2nDgysyLz60U2TKemDDXgp0ymcrx0Q= 450974855003 i 3288923 1paho 1 470   sb   i gr 0   1545058207
0000534144562c1b74070c3a223e046f 37843132 155550353537843132 1555503535 WlrBzftG+90qDqPRq7W1D8EOklv6GHmd1jBHJXnZEWw= 450977075927 i 5509847 maad 11 100   an 1587039535 i ma 0   1555950307
000057b3d24213dab0ced6966cfe2519 39724787 155431124139724787 1554311241 Rqx0SjPZlwFs31XPFT/vr+fxvWwVBYRqGN0/TE9M2AE= 450982014094 i 10448014 anaar 1 100   an   b an 0   1566396607
00005d81e1dc0341ca7c34ee47ab4cf6 44357620 160002686744357620 1600026867 nBa4OuGo6f/2WLQGLm8+mv3VLSpPL5Oiq+PLfTPOjns= 450982473382 i 10907302 tsaar 1 0   1 1631520000 i grw 0   1601386801
00005fe29fd27148eda35fae61cc686e 45799461 161149180245799461 1611491802 wT14/18RScMiBzNIMtkSRYg0U+Di2mJ+WoEtwsIpreg= 450980241526 i 8675446 mwadt 37 360   mo 1643014800 i mw 0   1611672602
000060030ecbf57b0c0217c9c9146d24 36941234 155016766136941234 1550167661 kL+bmWiYl1/jZkJHZhKf0Emy7BOISGIP9a84QrTvcNI= 450980398776 i 8832696 1pac 1 1   1 1581703661 i sh 0   1551115206
00006394117e627d66ac2856ac7c8e92 46176374 161410353246176374 1614103532 FTtegJ6lkSt16rre5q+TItlD+A3GfsKRdiIDvGdu0AA= 450978893888 i 7327808 shtf 38 430   os 1645606800 i sh 0   1614261002
000063d3d14b5afd7f40366cfab2a999 34921195 153988347734921195 1539883477 phazs5OMF3TyW0pxZYHelJHHQkNTiS/2jJ/34pyQ4XU= 450975316464 i 3750384 1pac 1 1   1 1571419477 i wh 0   1540385706
0000651896e1d70613a56c4f51e38049 36624739 154934018936624739 1549340189 hx7oBHJXopZgs5DpaoKwegdJw4bPWZXqNY2Spm00CQc= 450979075386 i 7509306 coad 33 372   mt 1580876189 i co 0   1549552206
000067c9d9f9ed2c2ff6812ef7f3d92b 49009439 163224236349009439 1632242363 Z4eDmqvuw0JwsW3dPETmEv75NKwn8zm6/kugaK0+kBE= 450982931222 i 11365142 mdaar 1 500   wh 1663747200 i md 0   1635772802
00006b1525c0b7d9342240aa221eb366 47918502 162749960847918502 1627499608 DuB9qXcQMhuAK3M2eHCRinRBNQrcTO2+PtwO+VxdOkE= 450975421719 i 3855639 1fa 1 230   fo 1658995200 i sm 0   1627743302
00007172e2c696c52211d15dbaa5bc6b 48026042 162851718448026042 1628517184 uGj4aNj/KqQ1Z3HhUY4s8nlIRVEYkyQ3AwPVBLub5vc= 450977625815 i 6059735 shjnf 28 480   sh 1660032000 i rew 0   1628598301
000071a00a18665ae7e0d579667c47b4 38771010 155993857838771010 1559938578 9yuVWQsOfALY6Evbp4pFhuyhpprW8eFnyR2PNJjaky8= 450981893188 i 10327108 geadt 38 360   mo 1591474578 i ge 0   1561466406
000075a1aacd3e9ad74fb2f263a4b929 42648282 158240945442648282 1582409454 4hImrlAjr3qgDbk0Hwbf6k+839Dlb5c7UtlHAwU3xiU= 450981527314 i 9961234 wyjnf 20 100   an 1613945454 i wy 0   1582726801
0000763388594ccba9ac08e1dda3da14 47417134 162362896847417134 1623628968 wBg94qd6OZUYf6XHj9TV4VhecZtEKGK6APSJt8XjfDg= 450974940879 i 3374799 1pac 1 1   1 1655107200 i sm 0   1623933602
0000770f4051a795998ad81e871efaab 49295717 162925744049295717 1629257440 /xUj9F9h7Lyme8LBABtKyvkwlBK4lDwSSk9zS6qWH5M= 450983028355 i 11462275 praar 1 0   1   i pr 0   1637762701
0000777e40d7e5b926934b023498dad6 42602726 157315345942602726 1573153459 HG3bpYceC1oppYwO3sZMRe8SXvYXxP+S0MuglLD7Tx4= 450982219070 i 10652990 foadn 1 350   mn   i fo 0   1582553102
00007f55aae390b5268bc1ac6c26e6b8 41087879 157383486341087879 1573834863 ICID7FZQt7wgCcFrMWlXTvwcxtFq/5O+Z5YDuRiZaZA= 450980586603 i 9020523 baanf 2 120   ba 1605370863 b ba 0   1573847099
000080b0a237985256f8a0aada5b3aae 36020613 154644490036020613 1546444900 I/x01X+IYHrfHdS2sGsOOEPKV0+7pwnCGzy+jfFDYI0= 450981067546 i 9501466 cladt 38 120   ba   i cl 0   1546955706
00008a477b4055afc53616726e681a45 48908935 163449098448908935 1634490984 GT9OkMQIRBuDM1rrY2bwg9a6TlUfNAtWaxL9s9sxuhg= 450982982569 i 11416489 tstf 1 0   1 1665993600 i 1 0   1634826902
00008c7a58aa98ad5f1613e50b912cf8 48619551 163227242048619551 1632272420 ga+AxOa6U9xe28EGKgvrdWIYLe7tLMbyAgLItXx5JoU= 450980523151 i 8957071 osjnf 32 120   ba 1663747200 i ge 0   1632832502
00008cb7857f6a13253caa61b9f01d7c 36583241 154834080036583241 1548340800 LAf4vij/aG/1kV3ox1LMLG9ggnevxDTCgblQhdrhNTU= 450980878361 i 9312281 dtanf 19 210   dt 1553500800 b dt 0   1549121706
00008d8536f57df9e67cdd62dd7a5d41 46082000 161344413246082000 1613444132 +0tK8FlkBiildhbtDbDToytozrCo8OdEgjOMyH+ReEg= 450981688405 i 10122325 smjnf 4 300   hp 1644915600 i sm 0   1614000302
00009537f3756751e73312c36cd04b31 35833496 154508565035833496 1545085650 ntJrX0WqiDA1yI60xOvxywf8zhNjiF13m1XWysVQIJk= 450979574565 i 8008485 1padm 1 100   an 1576621650 i cl 0   1545313806
000095bbdf1df1bb09b32431f3713689 37802929 155130219937802929 1551302199 BBfAsHfvbZsMnsqAgClNL2XFdSEoLXwfpLMR4ynjQfQ= 450981895274 i 10329194 pladn 12 490   sm   i pl 0   1555605306
00009cc25ab02131c91a91070008396e 49298479 163724456849298479 1637244568 q4VO2sU8Cf14WxLMlGk3Lb57P/hTKlCm8rLr4nROli0= 450982744870 i 11178790 majho 1 210   dt 1668762000 i ma 0   1637766901
00009d3c0d18401496fa269d3d6d08a8 35670054 154230476535670054 1542304765 PG4Nlo6Rfef9fF/5rIJn7Iw/MhRHELpRZ/X6BR1G17A= 450981735017 i 10168937 maadn 35 0   1   i ma 0   1544539807
00009d5a926065ed847d513c93900c61 43967395 159846240743967395 1598462407 jnf1MmbVxhzKwInXnZfKPrWVSxICfVEFrf/f5M3TX6k= 450975841892 i 4275812 3aa 1 468   re 1629964800 i ns 0   1598708101
00009df8c83dfa2aee7b558f741ec3b9 49406967 162917096449406967 1629170964 XtFdArg+6x7Sq9QV1Pwsxk42EjkLN7AYmj88Elsi+gU= 450983037847 i 11471767 tsaar 1 0   1   i 1 0   1638830702
0000a3f2545cd75bbc3caf0da2f1e0d9 40743571 157187750140743571 1571877501 VAld5p2MHGMTC59tpuqhi9Q7W2IiKtMy+n8E6kTewNQ= 450974808609 i 3242529 1pac 1 500   wh 1603413501 i ns 0   1572097506
0000a59f2679db23d017f3ef5506ab39 39623655 156574331739623655 1565743317 3ynAc5EKvYHP7hvwuZIE9EQCngHzBVslMcQQFn4JbmY= 450982055386 i 10489306 2ra 1 0   1 1597279317 i sm 0   1566219307
0000aacfb9974234650a7b6ff166481b 42209494 157315339642209494 1573153396 L5Bc3Cyaq2ZoQHjF9QrgRQXH/H4tU1Knn6Hyq1H26BQ= 450982218911 i 10652831 readn 1 530   wy   i re 0   1580393102
0000adb46006deef3385e951c56b8d72 46893704 161955117346893704 1619551173 jeod1NvqVtyDZDNcSRoJIzFo28MA4TMqI7nhE5FrhWk= 450979713289 i 8147209 mnadt 2 390   nr   i mn 0   1619705402
0000b072ef2f46c7b992341abe376af9 46032748 161301611446032748 1613016114 JLEKRaUTRpab03ArAomEyL4emgpqf3FgvpRbeIPOPMQ= 450973303778 i 1737698 anjbi 19 490   sm 1644483600 i an 0   1613235301
0000b3c291b30d7c0206d5468b0d3f60 41011150 157343478941011150 1573434789 8GhodwtIUqd1Bl/ZwgJpUNrBvXrRwXg4R8OAAFy3LJY= 450979438609 i 7872529 dpanf 19 480   sh 1604970789 i dp 0   1573656902
0000b3fec54558b22a03deef1a4f7a26 34786574 153909381334786574 1539093813 hijJLpwURLhE5gWerlIkEpHNAO4hRLChjSMMTUnboaU= 450977905691 i 6339611 chac 19 100   an 1570629813 i ch 0   1539608401
0000b54df0c14b17289c2076a4493553 42852117 157628036042852117 1576280360 LwNtzMtw4nAxiMI2JAhrhXO4bVcbYxJSrP/Pb7341Zs= 450982210612 i 10644532 shadt 1 200   dp 1607816360 i sh 0   1583844601
0000b6507520a46557c6cda1da2b7e05 45078603 157851939945078603 1578519399 YZirPjj79LkXp39/qbfFkXhIZD8pZhbuZXi7HGuVaJk= 450982405165 i 10839085 shaar 1 490   sm   i sh 0   1606310701
0000b9ebfa8da042517fa6aca318b116 40477356 156043770540477356 1560437705 EaVep3mS4KAiIVtD6ERJpQbPAd/43iIseLwki5Eq07E= 450982042802 i 10476722 lvadn 36 300   hp   i lv 0   1570626606
0000bcfb6b4e0f5c44fae74811594d6e 36471016 154853634536471016 1548536345 wIFXlcQubO/Jxo2EaG1yIzPsGaxdJqWTG6iU78lwSRU= 450981599584 i 10033504 gradt 17 140   ch   i gr 0   1548770107
0000c001969d85b09e5c3fa2be35cffb 46836942 161905540246836942 1619055402 E+qrrulVxVZd/UShX41weq+zZlqYdw9f+uQ3honNmvU= 450981656215 i 10090135 clanf 24 100   an 1650591402 i cl 0   1619273402
0000c315af7e9dff5eaafdd51a491adc 49675149 164031562749675149 1640315627 4eV/m1EpOkA4jKqmRL8JNP0KBeZmROS5gXiayOpNCPw= 450982825200 i 11259120 smanf 1 320   ma 1671786000 i sm 0   1640957401
0000c5fb04054f1a7ef96cccf3570c17 40223181 156909429940223181 1569094299 uiIKaWGfpBwx79EYW2bMyq3+xArpkyV+ZrL5bG6h2Nw= 450977100527 i 5534447 prapl 4 360   mo 1600630299 i pr 0   1569422407
0000c7e9fcaf7c4ad63b0473a676bd6f 42816820 158342940442816820 1583429404 m1kD+wa0aLirP8qXl7GaCqrt1CP/rpVKguOXfAbn0kY= 450977849349 i 6283269 shac 27 480   sh   i 1 0   1583769602
0000c8eeb6f8df56b39635bed3baf88b 38412903 155865425538412903 1558654255 6LIKfshjbIGxQ6tEo0/iYtnkFS6XyBnnxghShv2hplY= 450980544137 i 8978057 moad 37 490   sm 1590190255 i mo 0   1559236206
0000cd225c408760ddad332956d7206f 43412917 159451839743412917 1594518397 G+mmmXBcpswSh3aQXVoDE+fykBNzJfUOpAVZL5Y5Hzg= 450981497298 i 9931218 osjse 32 430   os 1626054397 i sm 0   1594840211
0000cd379dbd3b626baea6009786a776 41215595 157461110641215595 1574611106 VZdBgtEXJ+0HQbbYGi4Ai5FU4fDIhCWng4+MtW16GoI= 450981278677 i 9712597 mnanf 2 360   mo 1606147106 i mn 0   1574867102
0000d275098e221992ef93a7504d02bf 36678596 154956822936678596 1549568229 +HDvNdRKngND9nRCeQR7pE40ib+VdeShp0QcNRvN2Wk= 450979754431 i 8188351 cladt 7 120   ba 1581104229 i cl 0   1549893602
0000d5355f31aba86995570c94538948 37889443 155130173137889443 1551301731 oqA7YkiOcAnrR8PX2h2Ghr1ijH2+O0uqnh9zxwJleZc= 450981884402 i 10318322 cladn 2 0   1   i 1 0   1556115607
0000d56e0c30074418a6be10b830f75a 45976915 161271800645976915 1612718006 lq0FegQebtCSuBmrxiqhK8vZBR+V5bAuTmuBGIA5ZVM= 450978238590 i 6672510 sbjnf 19 390   nr 1644224400 i sb 0   1612967701
0000d9aac6bd1d1be9394bc3fca35acf 49056763 163585852149056763 1635858521 DjxPD6qK7fZXZzxA7HV92Bpep8bkYA0H9MuT4M3+qMc= 450977024466 i 5458386 gejse 36 100   an 1667376000 i ge 0   1636029301
0000da839b5f5c3152fca7910664458d 45324898 159813914545324898 1598139145 ZqooezgoqeZfBMfYl6riNOJM31jyoHjH90ITOl3ETGE= 450982433047 i 10866967 foaar 1 100   an 1629675145 i fo 0   1608132601
0000e117bc512646d43b5455436cbcf6 45071550 160598202545071550 1605982025 baKWIye0V6HkSvnooEstuyc1PXy6vvhAvT6Z9Jl564I= 450979917589 i 8351509 pljf 12 100   an   i pl 0   1606748702
0000e6b39e7732dcf0c1416a26cc6fb8 36733194 154972547636733194 1549725476 bT//pebv7dSh9Jin6HlmbkZAITKdA2Xq3dhnA4oGD+4= 450974634584 i 3068504 1lj 1 320   ma 1581261476 i nr 0   1550077507
0000e89e6eaf0c21efe0f473d3f5a03a 35102769 154101078935102769 1541010789 VAVtnj3CsMBBT6EArwLx14wC5EtMFeZIt90KC1XaIjc= 450978499869 i 6933789 shanf 4 200   dp 1572546789 i sh 0   1541425206
0000eca77073304bab0e02dc45a4de55 43826803 159752819643826803 1597528196 TM2bvo3yoo4cB2r+dZTvh/5FZrExD4xCnix9RjbA1Go= 450982126288 i 10560208 osjcm 32 390   nr   b nr 0   1597528501
0000f0938290974357a47ff7315f0fb6 36779664 155010484636779664 1550104846 PpUTxgqqgLAH6+N48MNFC+21k5ELrJ4t0TMQT04c5Sg= 450977915411 i 6349331 maad 22 162   co 1581640846 b ma 0   1550106002
0000f218e8ff8bde334b72b22595cf3b 37252598 155245290337252598 1552452903 3PueFrm2yqd99VFJKCJ4Yz8ySLlSfrTRkxtFVpvvhG8= 450976203637 i 4637557 smaf 29 200   dp 1583988903 i sm 0   1553016602
0000f2219f95d3dc0eec7691342f6a81 37638909 155412635237638909 1554126352 StrSad8nU3NchNbQKywDR9XXhhzRvRoZO73fbnCHdXw= 450980101059 i 8534979 avjnf 15 240   ge   i av 0   1554905106
0000f43ddc901402f658413fa7c25803 43416944 159414238943416944 1594142389 KAJ4baj4dN2OxpirE/3SThFISQuNS5EVPzu5bGf9PVc= 450981789356 i 10223276 smjbi 37 480   sh   i sm 0   1594919410
0000f46c1142c65b99e3507231be21ee 38270569 155785898838270569 1557858988 7FJplpKD06PGr8B4ljADnooZN8+kHdahott0ZRNSGfo= 450981948278 i 10382198 dtaar 2 0   1 1589394988 i dt 0   1558438207
0000f994968019614d499794ee598e91 47496267 162435509247496267 1624355092 /cEFaUVKe7JgvVvCcxJUZxOqEL6N3QC3UEWMBGzkzEM= 450982164201 i 10598121 planf 17 260   gr 1655884800 i pl 0   1624452601
0000fd2694be83b4232caaa2e3221abb 35785418 154153342635785418 1541533426 vSafJztpA1JXGvuW+Y+GFDSiZmeK68dMZvmqrG31Lzs= 450981673600 i 10107520 graar 1 490   sm 1573069426 i grw 0   1545233106
0000fe1517ece55552471b13148b8c59 38672145 155447544738672145 1554475447 YrcissB1RJm8E0Cib3S9o9ZIq2+mxZ9XPerM+ibObbU= 450981965995 i 10399915 smadt 5 490   sm 1586011447 i rew 0   1560962406
0001059e19f7b17bbed9e1ecdf888327 43427029 158093535743427029 1580935357 /dZrCz8oVctfCChCs/6rJfKXpk66L895l/c0OBhbu6k= 450982405306 i 10839226 geaar 1 0   1   i ge 0   1594902911
00010ddad95e914f6370ee08e9bfbc11 40024670 156280795540024670 1562807955 AdT7KCdg0ZiknF8uVOTfz/w0dkNzsQahqbe34tVqKFs= 450982066442 i 10500362 maadt 14 0   1 1594343955 i ma 0   1568294107
000113d0da9a6be209616796e7f01c78 42645220 157802506142645220 1578025061 NWJ5G+9YXtr900fcX3ZfPbZ0AGn4bbz3fysmIgS731s= 450982304744 i 10738664 ghadn 1 41   1   i gh 0   1582725901

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