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
00011a17df87194337236192cdfd6836 34857522 153547725234857522 1535477252 rWVgylDTNLcvnY9Yk2Ejvtj35qUE1GduxPP5M2ShnuY= 450981590764 i 10024684 baadn 3 120   ba 1567013252 b ba 0   1539730507
00011a2fdbfd84c26f01eae92e19c3c1 42622079 157867442642622079 1578674426 6EMAoJo1nsz9SiDnooFi7ePivamEwpQLgdpD8gDpFJY= 450982318372 i 10752292 dpaar 1 530   wy 1610210426 i dp 0   1582558501
00011df483bf31e368f8e20f21d0dac0 35534639 154351496835534639 1543514968 jVsyoepJDxAyqXYx6yoUqvoAHuP8rrM4GGo9ECPopTc= 450980097785 i 8531705 maaho 7 310   lv 1575050968 i ma 0   1543675806
00011e61e1046fab0b616a49410f2be6 37142801 155172997737142801 1551729977 3fVJHGLcXwVgCa/MLI1JKrdZj3pXWeWqAv4LV6bI+ww= 450981505654 i 9939574 osjeb 32 430   os   i pl 0   1552062906
0001213db7ce18745dbc8939bcd77ffd 48743301 163346094548743301 1633460945 YYaELKh8gBCAUU6OGOoFl0WwJn9kStVahNizfjRa58g= 450976208499 i 4642419 shjho 4 490   sm   i sh 0   1633610701
00012484dd2c1a99530802582185e794 43338520 159404798843338520 1594047988 zQBY1SkZsoa74t67jcSGGqvYJUeTERe4cAbUjsvMKCo= 450982009330 i 10443250 gead 12 240   ge 1625583988 b ge 0   1594059009
0001292abcb7c5469f211ed9b3c4983e 46419523 161572089446419523 1615720894 kODOQOnt/Qw9qd9+us9Ph/ITHzMx48S0lQYlbGw6M9M= 450979279628 i 7713548 3ra 1 360   mo 1647244800 i sm 0   1615985702
00012fd871b4e7e5f62f13070ffdb322 38178503 155761505038178503 1557615050 T0BiG6+lXM0IVTDaMfk6VUHt3DDppSvegx/JEH4+e+s= 450981389252 i 9823172 1cj 1 520   ww 1589151050 i sm 0   1557839407
0001310c35a8aa150994aa1fe2cbf7f9 40992928 157324002140992928 1573240021 OaunINjTTg23YizE0/uHzpZT9Kj3RVFSR49pJzCSgUU= 450977867309 i 6301229 anjf 30 101   an 1604776021 b an 0   1573324207
0001366d58476c43a92de89e6cfe89a9 45703932 161084575745703932 1610845757 eWx1bD22CBmMI8wXMWAx65CWFQYFq7vYGMPOUOI6h10= 450981962057 i 10395977 smad 5 490   sm 1642323600 b sm 0   1610912102
00013edbdfe9be03f6835b58183a4ca5 47828477 161859772147828477 1618597721 ChwGJMltay10HQEbyKk9YRAMMe21e5iCPZaRSc2V4DE= 450982745308 i 11179228 chadn 1 420   oa   i ch 0   1627131601
0001409677849b37ae3a47d81c3df722 41042784 157352782641042784 1573527826 M7PnEocmRGjmRvCB99PlIww1dSDiJcgiDZAGpVbVW9s= 450981598372 i 10032292 shadt 20 390   nr 1605063826 i sh 0   1573739400
00014291dcf691c79aa6e1a680d15269 49221718 163360473349221718 1633604733 hXsvIQCTnjicnUxdnfP2Mf5CyBe6cnuP+IimvTuSmV0= 450983012244 i 11446164 mmaar 1 0   1 1665129600 i mm 0   1637154902
000146dc83b150c7a1277114390ac764 36363041 154809608236363041 1548096082 SgOeMU/NeuANTcDKhL8yspEcAo2QsiMly9Mh403xDFM= 450975836111 i 4270031 crjeb 6 440   pl 1579632082 i cr 0   1548431102
0001472ac3cd565cb0ef3ba9c56dc1a8 35959032 154602934935959032 1546029349 Dcu+SGbykf2WfbJ4hHz0gY/v15ZDoDGC484eT5002GQ= 450978391028 i 6824948 sbad 13 230   fo 1577565349 i sb 0   1546712101
00014c55e5a491a2bf48d96f358a3048 41355923 156951978341355923 1569519783 0C3iUVYMlRX2B0QVDCFsx/CQT+aioOibEbLJuxgab/g= 450982170297 i 10604217 lvadn 21 380   mw   i lv 0   1575729002
00014e6c8b82c85c99d4d7feddf9da78 45511059 160954090945511059 1609540909 Nbs7pxoCNq1PibWcuA0tTBrofDv439t62QwO5SAoojY= 450982484276 i 10918196 wyjeb 1 260   gr 1641027600 i wy 0   1609779901
00014fb91705d6589a09c1ac721d427a 49061964 163584967449061964 1635849674 jjDWyg8f3BJh8eW3YpEX+MWdPlgzxewyr9kKtOELmC4= 450976290063 i 4723983 osal 32 10   1 1667376000 i an 0   1636039801
000150b364d8a5e91c43a09b6c426da1 40856147 157252632840856147 1572526328 LNTGWh00TG1U5N+fO0OPZ9vfNe6Xtjr98ESaYm/6Gbs= 450981082751 i 9516671 wyac 10 105   an 1604062328 i wy 0   1572962706
0001521517a02f63086fcbadd1384551 35054524 154084135735054524 1540841357 /bKpJpVsvgxZFXIQgJStbz1utrdkAVzLmnWtpEOA9CM= 450975609540 i 4043460 anjer 38 260   gr   i an 0   1540992602
0001565ef2f4193e6adb16da7afb8d51 47637519 162558127047637519 1625581270 uqz20pRFP+HBnAVLjXrUUGGFaX460LN4STeoLUYXJ2U= 450982659797 i 11093717 dtaar 1 210   dt   b dt 0   1625581802
000157326486e55c74d0576cdf2b1f58 46027557 161282372446027557 1612823724 PbNxwgKOGfr9ezgSwzpQ9JVr0dB1R+IVU2JZwaBrwD0= 450976312771 i 4746691 1paab 1 490   sm 1644310800 i sm 0   1613137501
00015ca4a42f44c9e48a6ab352cb5644 41646173 157739908241646173 1577399082 J3xZ4yJmg6ue3CQWYgFRCUSIWPsEhw6EJZoS9fKVZi0= 450981128781 i 9562701 mojf 23 850   dc 1608935082 b mo 0   1577402101
000163fceb28297535b05141427595bb 44843104 160459209944843104 1604592099 oDv+Luwq0t7uI5GB74eDxxFe8AHrgQBwsGRzIu8rt2k= 450980750765 i 9184685 smjeb 25 490   sm 1636128099 b sm 0   1604610302
0001659f589a7619fa7f15892f5f0f55 41098081 157391992341098081 1573919923 +yMi8cllG0OmTYVlFBNBwy/crfRz44kwlqHFqk0f8w0= 450978078084 i 6512004 nwjeb 33 440   pl 1605455923 i nw 0   1574351101
0001668def3788a49e758d6d3ee0ba1d 35741913 154449836835741913 1544498368 Ec8YjlmSTCP33fpXUM+JhgKcy25LujJTiugsodEbfWI= 450972691073 i 1124993 1cjho 1 360   mo 1576034368 i oa 0   1544798701
00016c438eb95fa8681fa2a83151e8a0 40158503 155732997840158503 1557329978 afwmvSIOnHr6GHXy1Pb+JfYaC+d5lxZJyNvtmYa+zy4= 450982068905 i 10502825 geaf 1 0   1   i ge 0   1569070207
00016f8e21ff3b372db01434344dc984 44477669 160201478744477669 1602014787 MjCVkvp+LUZIJa2m5bOdJ8Y3A2YBEc1q3aCyHRmcM7U= 450980187133 i 8621053 lvjab 2 320   ma 1633550787 i lv 0   1602087001
0001710a579b23977eb8ae6773903240 41985661 157554812441985661 1575548124 oZOdBiLZmRN97IuWpn5kpMRcBWn0ydH6uiZonuoqVgI= 450982081998 i 10515918 2raar 1 320   ma 1607084124 i wy 0   1579182301
00017182e35b7cb27c8f0cf5222dab87 42996765 158412218042996765 1584122180 yOn8I2CFMsmMI4MkqHCPJUF8Tll59+UnwXLiXKt7oiA= 450982036898 i 10470818 gradt 33 269   grw 1615658180 i grw 0   1593561009
000171be7465d0ffa75640c978fa08d2 36567311 154898946736567311 1548989467 YvpCqgEwjiWoyUD9KKnUjGuZLx+gF6vwZnf1Yc++B34= 450981230031 i 9663951 wyaf 21 230   fo 1580525467 i wy 0   1549295102
00017259a992680dafdd1213ef7e3bb1 46915096 161444828546915096 1614448285 wJBHl+pmRI11h5BZ/S3RnVEYzpHvgwMpy+5Vb+Bn4s8= 450982711398 i 11145318 tsjbi 1 0   1 1645952400 i 1w 0   1619799902
0001791de35bf6f4757de7d0f6e73e69 34795230 153926967734795230 1539269677 RFqZhq0ymWef8Q2ZHAdAHKMUdX4m0agDDltrZP/7KSY= 450974846500 i 3280420 1lj 1 0   1 1570805677 i an 0   1539623106
000179653b50b62293d61821bf9c03f3 36231908 154730344536231908 1547303445 oO9glv1iTjh5pltriZdGlE6Jljhivr4VFbz6x7JH5DA= 450978809818 i 7243738 cljf 1 260   gr 1578839445 i cl 0   1547646906
0001797a61ae22c0077260a29d4b3753 40391520 156954256940391520 1569542569 yYaQ2BKB/F5WmZ7cCk4RjtgpjWyzWYhaUfsp7JcW2Yo= 450977607187 i 6041107 smac 38 230   fo 1601078569 i sm 0   1570193406
00017d6bc7dbe4b25ceadcd3df0ce1f6 41952845 157844414341952845 1578444143 ZRupYWmQDum/s8Uv6WYqOhQlIpWkEoK7MZVZQsEia/0= 450982242460 i 10676380 baaar 1 0   1 1609980143 i ba 0   1579098302
00017df54ccc7f595cb02db4bd799d5b 42302860 158069593342302860 1580695933 Uz3ZV3Qfbd+LjzD+spEqRQR0lBwTnjloH4MDuNbH1N0= 450975071615 i 3505535 1lj 1 362   mo 1612231933 i dt 0   1580917202
000180034bedea52ac3ea96172d571e7 49124778 163621410049124778 1636214100 yzG+JRbBL8j3MsH+uaqGixbF+2beF2gyBx7BNSYJ1QM= 450978282693 i 6716613 1padc 1 520   ww   i ns 0   1636554601
0001818b32828e1c5f45b286381128aa 37227017 155223956837227017 1552239568 X4dDJric33uSjN36tCtSSHM/4tBVmn+Zp62VooCC1u4= 450975993558 i 4427478 majnf 37 420   oa 1583775568 i ma 0   1552582206
000183ccc3824dd1c3096d03466061f1 44084156 159930930744084156 1599309307 IEvUYUWHHkWkzLO63RS3nFfR9ovTdCjHo2UTAMA6TbY= 450975229869 i 3663789 cljnf 23 100   an 1630845307 i cl 0   1599661501
0001849b2f0fd762cd710372ee96dc60 47800625 162661002447800625 1626610024 WGhkyWRvl/nFoO4tN383SzZmIwDggZW22PUNVNUXJG8= 450977621038 i 6054958 1padt 1 393   nr 1658146024 i an 0   1626888001
000186c27a6c965b82198a8e3d226924 44338943 160087636544338943 1600876365 vVNfOio/0XnChisyrQnKVR8LBLQ9zyd4VsYctbySfws= 450981852398 i 10286318 hpad 21 1   1 1632384000 i hp 0   1601398202
0001891c33217040049c513a4d97447e 40428270 157013632340428270 1570136323 xPIM0LJDJaxZtgkRhYzimQu1+29yLZ2qmSPVKSiEjF8= 450981031761 i 9465681 wtad 6 510   wt   i 1w 0   1570627506
0001898fec8ae43b7add61786eb33a3a 37479229 155360216337479229 1553602163 ocQSOX58aLQYWqouO2d+K9Tlhf7XINWdw4bNOnaAhpU= 450978874565 i 7308485 smjgn 38 310   lv 1585138163 i sm 0   1554140702
00018afdca8c00f70901081a1f5110ce 48864441 163417254948864441 1634172549 oCct0+jhR8s1mwU1diw3zPwKKGMLMwbaFyK8hPBo8h0= 450982886000 i 11319920 smjer 1 380   mw 1665648000 i sm 0   1634646302
000190a07a0b009a9e1417dcbb119bcc 47446407 162303489847446407 1623034898 ThIV6qhPCxMXKas2SG1/eTnTzI+5iyMbPEWwARCyw0c= 450980829583 i 9263503 moanf 2 100   an 1654502400 i mo 0   1624019701
0001913b806e2249e8e0ffbfc422a2c2 38233473 154700704038233473 1547007040 Tgf1UkCAOYNISTJzAg3mGAGN1Q4GvTgfvkz7d6hllM4= 450981920051 i 10353971 foaar 1 0   1   i fo 0   1558459207
000193c389f05b19ca2c937b972a6b1b 35841645 154517965535841645 1545179655 2vVDrlA7xZVLSQDQ9D/YXn3vibBLToFJCoj8ykM133g= 450981268848 i 9702768 chjf 40 0   1   i ch 0   1545402602
00019663896419d5a8e2fcc76d17a56c 35863225 154516408335863225 1545164083 zvU71Z7I0rMIz4NZZKpJFotyai2m7TxLi2IFXqVqBvE= 450979125220 i 7559140 nwjf 7 490   sm   i nw 0   1545831902
000196ace94f0a4c3376336c9fae0fbe 44216280 159983794144216280 1599837941 DCOKr7NYiT2hiQSiI8WOniU0ndDkl2QnbMs2tbPp1Wk= 450982458958 i 10892878 1pabr 1 0   1 1631347200 i mm 0   1600694402
000198b9d790093929b7d27bf49f891f 40142011 156870684740142011 1568706847 syr0njqO2hpp4njPs1JP4reQ8Grb1cxZYxVeP+hqhuw= 450981995696 i 10429616 readt 37 462   re 1600242847 i 1 0   1568913006
00019b59d26b30c592bd20fad07fd5d5 43669254 159647163743669254 1596471637 ++/BonebA5Woq5zIb03aO23MP3ABmBT4B9iFZfaeq9I= 450975436068 i 3869988 nsjeb 35 390   nr 1628007637 i ns 0   1596634514
00019bc367e12fe9a09361303f818d14 43037370 159122892543037370 1591228925 n2yK0ZxwfbsGsQnWjyR5og6zEpnQuXq/cYaVAj14tfs= 450981723277 i 10157197 bajec 20 430   os 1622764925 i ba 0   1593029107
00019c42988c0b027a5df5cc265ea0a3 44739062 160383406344739062 1603834063 vVlZ0bKpQKovPbmJCu3G27O6vTl7/KB40N0SwQBMqWA= 450981639572 i 10073492 ghad 24 260   gr   i gh 0   1603981202
00019f47ca0dcc51734846f06201d36d 46360147 161542362746360147 1615423627 XTET36f2LA0J/R5hTRtC/mXT0TNePq+twUCZn2URjoA= 450980085005 i 8518925 moad 14 280   ha 1646902800 i cvw 0   1615557602
0001a00e8dff8fe584354b36641e4597 43024691 159138339143024691 1591383391 iTmY4lJn6RNjMuhDrsEhmux2nJ5fT4nN2tbTsg+9jxU= 450981373675 i 9807595 osjf 32 240   ge 1622919391 i ba 0   1593450308
0001a1b74be3b13c59b94c09bebdc8c4 40118203 156850081940118203 1568500819 aivC3mbJJPg9M+s5x9lx0u5OeHT5SS2i4xhNQKWkGfg= 450975906447 i 4340367 1pac 1 100   an 1600036819 i lv 0   1568821206
0001a2bef0af71b6b42ea41faaa89e85 47586560 162500245147586560 1625002451 1ITN6ZuT8ZFNEhuxwMw4fyV3lthtYUiQCSKlpMfcC2g= 450982587542 i 11021462 osjnf 32 10   1 1656489600 b 1 0   1625074202
0001a4811c1c75d7d872a4dfaf138c7f 46906651 161954986046906651 1619549860 lpIyiybFi/OkLrU0MntnzZREeag6fB9K7db35kBTWoQ= 450980109765 i 8543685 1pac 1 490   sm 1651085860 i an 0   1619705101
0001a94a86954c48fb4575eb3081bef4 43892566 158344480643892566 1583444806 rDcfe3SK2lFW15vztye67aE7v3j7UohiEtiDuif9kP8= 450982439977 i 10873897 shaar 1 0   1   i sh 0   1598360702
0001abeb15af9b046adec6df4c1743a6 37286188 154283145437286188 1542831454 uUtNMdcSn9kGPQ1/3ImdZGJMouFC+TBTyBAxO/reTuI= 450981689512 i 10123432 baac 17 300   hp 1574367454 i ba 0   1553013002
0001af43068232dff88d2e76df972fa8 40950532 157309514540950532 1573095145 cUfMwh3XUmAynyUs2SOnTUGkysFCjVZPk1PwK+y48XE= 450977665356 i 6099276 hptf 20 340   mm 1604631145 i hp 0   1573312206
0001af9814ae86c1e42ca2272e8bdd29 47336250 161073484447336250 1610734844 SsD57ysDPLMQ+mNAelroahNGTLD1XLUxLEtax0L6rcU= 450982626243 i 11060163 gradn 1 260   gr 1642237200 i dtw 0   1623243001
0001aff1745ff6112698d76653de3606 35547724 154353782335547724 1543537823 fDO2RsL5ej3FbY3J0S5BWQ3uH1n6zWbhPqhj00Z5ktg= 450979854657 i 8288577 cladf 4 120   ba 1575073823 i cl 0   1543851002
0001b1496adac710b1a3109d8ae52e1b 41353747 157541865841353747 1575418658 PMH31Cy4TSVmYXAnUQHMt+FICa2p/Wn5qzSuK6SqvLQ= 450980991795 i 9425715 baaf 10 100   an 1606954658 i ba 0   1575745502
0001b820c765674bf9ff96817f942c56 35863662 154533721535863662 1545337215 YJrb1+tfMUXDK/7rKUGPjGivFTiosMdYdR/54T+hrpE= 450981309286 i 9743206 cradn 15 170   cr   i 1 0   1545491407
0001b8fce1ea818b095dfb23e379f1fa 41935613 157878346441935613 1578783464 ITRFTb7pXGVsMCa5zQHcWctK+DYwq9ydmVmHsCBjzG4= 450975198714 i 3632634 osjbi 32 430   os 1610319464 b 1 0   1578855901
0001bb29a50ff802b1e0026c17e9d1d1 42138280 157990201142138280 1579902011 P5JEzmLQE4GbGCSiYz0rE1HTbn4VPzFt2m1Yq+YFfa8= 450981423860 i 9857780 nrjgn 42 390   nr   b nr 0   1579905302
0001bb37f736436450b16c6f05e91619 48300245 162994680948300245 1629946809 O+AgURtuNy5S/s2xfZ7G838QOe/ToU+QNQ1NOkzAKEk= 450981145981 i 9579901 dtjf 7 530   wy 1661414400 i dt 0   1630500002
0001bddc807604f6beea7f7858f8fa27 37405446 155326995637405446 1553269956 66mfOPV679iOhaT7Vj1y2qDkyY95Ul2VSaciZ6BtABY= 450981727397 i 10161317 nwadc 37 380   mw 1584805956 i nw 0   1553609107
0001c010fd73da6aa5caee30d87c1760 36092223 154672828636092223 1546728286 XfKz6J5sn7hWPmxA3sSunWOGRYBSuDf7gsU39Zt0ik8= 450979835889 i 8269809 shjeb 28 120   ba 1578264286 i sh 0   1547138702
0001c19b6429647dcd096835e3ef06ec 44384429 160141199544384429 1601411995 ZrRRX/5DmYiibaUwYIFz9yDxKLX+UPslsyDg3UOjSW0= 450981704577 i 10138497 cladt 15 150   cl 1632902400 i grw 0   1601558402
0001c1a58b95285f53bedef853dd93bd 45494039 160934312545494039 1609343125 RMN11Dn/A1s/5rY6jRL5Gb/GgA5CafBA5HckYx0TtWk= 450976145718 i 4579638 anjnf 21 490   sm 1640854800 i anw 0   1609865101
0001c373f001d977b26174336f7b15c3 35447553 154284152235447553 1542841522 Nt9RhR4Cqf7lWiVsM2P5jRikezP55Q29NT+D4qohsm0= 450980866258 i 9300178 cvad 21 400   ns 1574377522 i cvw 0   1543328406
0001c526a88681b132a52720c1c253c6 46279344 161454299446279344 1614542994 R+VSMMJ85HVpy9TazjhxdehnUk6KJJsoT5XFNnNQQTc= 450981850283 i 10284203 shaf 23 280   ha 1646038800 i sh 0   1614960902
0001c5f889a6214387e6c6cac15c6c3c 41469981 157488175041469981 1574881750 BLjgg3oMdDUVIj6NQCsybetAtieBjLh4V0eXoYRMlBI= 450979625518 i 8059438 mmaf 21 360   mo   i mm 0   1576507501
0001c7f7d58bb288734836c930aef566 36704647 154850778636704647 1548507786 Zy5bH1bRLF5RWnfHDXrmgmqGZH7vCQOHMsu9jqxnh30= 450981808254 i 10242174 mnanf 24 0   1 1580043786 b mn 0   1549730406
0001c9de7ddcf6536dbfc0adad8b78fa 48975304 163519488048975304 1635194880 s4o8gyYJBEl6j3pUcMmb9AgeWal/D4xdgzlHeLqmYHk= 450982191309 i 10625229 smal 1 1   1   i sm 0   1635425402
0001cb14246f0921aa79af2b93eb0569 37761513 155503162337761513 1555031623 WVWWbuTgjcFJTXmsYuUZ9cvriAmRLMvGgS5LANs5NLM= 450979559046 i 7992966 3ra 1 160   co 1586567623 i dt 0   1555424706
0001d2ff53197ff11502e38108744230 34806511 153937157534806511 1539371575 UuXi9wKqRDOq011WaZG2cnoQIlrIliXxqvtiiWhlANc= 450977985653 i 6419573 bajeb 2 130   bh   i ba 0   1539620406
0001d3e5812bcb05378602c0cb7927a8 44732818 160375603044732818 1603756030 urlxbZDxllcln6h0z5/pELt3u/1zHLQE0qvdphj3QJQ= 450974670903 i 3104823 2ea 1 0   1 1635292030 i hp 0   1603904701
0001d4e3d09370717fd4a4f45e2ff852 45897790 161203661945897790 1612036619 CNsyuEuvxQt13bmgaI5VuZkDuiHkrTk/d9U94T1S0Ec= 450979557894 i 7991814 2tttw 1 360   mo   i sh 0   1612370102
0001db4d516d9ed0ccdafdbf14ad8bc1 48689658 163286263648689658 1632862636 ZUMW8KGmNL4F3I7y+2GmX9Ecy+9jovg5VWr3rSO4evI= 450982916478 i 11350398 coaar 1 260   gr 1664352000 i co 0   1633184102
0001dbb9c1a06609ddc2f4edb3e118d4 39244422 156375929039244422 1563759290 EEtYyrmvxK8b7/urozDJ1doZgoXyBvMRZdwz+ua+WkQ= 450976165789 i 4599709 cvac 42 182   cv 1595295290 b cv 0   1563806407
0001dd60780c97de92d51ec7ca567ed8 39039759 156267084339039759 1562670843 wTa0xTNBbvzEAEep3x6g8j0FmBSTd6CbdlZ8qoO5oeE= 450975471337 i 3905257 1paho 1 440   pl 1594206843 i ba 0   1562864106
0001e12b9f0d73452ed838eea7e9173e 39738353 156632747839738353 1566327478 zE6KucMAI1LdxoIw2rAM5ZWn+/Z0R7Sj2dWgv2muBTY= 450981986173 i 10420093 bajf 18 280   ha   i ba 0   1566825606
0001e1b34cf31bb51aa730a592537bc1 47807834 162675382947807834 1626753829 RsNwHn0uRcQF8NWwaHrEQeQJ7W0SQItUAEZMG1T77W8= 450982621658 i 11055578 cvaf 1 280   ha 1658304000 i cv 0   1626870902
0001e2deab18e5b3fb856b1d99bf5c09 45865235 161194865145865235 1611948651 QtdWZfq9gCCZGhwWbD2gWY3Ruhx/DE3ViSHxu7HQ6yc= 450982007939 i 10441859 majer 42 120   ba 1643446800 i ma 0   1612188302
0001e487910c78467a364437ecbd9aff 44847907 160148403544847907 1601484035 LzvkVRAMXqJruMhgRgn/eE0yH8YGiwBH3wW4OZ8Arbc= 450975605402 i 4039322 hpjho 12 380   mw 1632988800 i hp 0   1604929202
0001ea8814ff3d9ca2b4d930fa988e7e 46702298 161799949046702298 1617999490 vmcZRQac7+zFD1TzfuPjwfFq4NDCeqKqAXtzXiGFRWs= 450974988683 i 3422603 1lj 1 440   pl 1649491200 i mn 0   1618323002
0001eace5d684f4bf37e37c0a87a1df7 36402036 154820713336402036 1548207133 Yz7ihlToqNaCrIruows+bd2TVrlYR7aPQfZJ4765A8A= 450976365497 i 4799417 1fa 1 1   1 1579743133 i sh 0   1548437401
0001ee7a60e705ff3291caf50baaead0 37422243 155340606937422243 1553406069 2OzpEnsS8I/RUEts1P4xwmzmo1eMHwVA8xHk87gxAng= 450976438023 i 4871943 shac 38 480   sh 1584942069 i 1w 0   1553630407
0001f03f6b528f55f207f89b7fb59cfe 37840203 154700737437840203 1547007374 YGAOHUWq3l9Y+NJVPPyD0P/3u7TI2FThP80UOLYWF1E= 450981882339 i 10316259 baaar 1 0   1   i ba 0   1555937101
0001f38af12f9d018588eaa32b79842c 39020769 156245475939020769 1562454759 ff9Z0r23rfvx1XeYauTTS8IbjOyU/3d8ujNqKC84zzg= 450980662784 i 9096704 anac 35 320   ma 1593990759 i an 0   1562783107
0001f3c594f228c928e43e7cf0a2cb33 47505337 162439169447505337 1624391694 LF5oNGnMa4xt7geSXDhtWPicdi7luxQKoUt8lK+imT8= 450981453567 i 9887487 baac 15 120   ba 1655927694 b ba 0   1624396502
0001f88e0c9ee110cdd7df565c056d01 48150536 162922250548150536 1629222505 2rStrV6+r1GpqF5fiZ1O0cEFV2lb2c9TrjJ33CYqSwk= 450980150435 i 8584355 1fa 1 142   ch   i pl 0   1629384002
0001fa5d15d60c679a0d675a4e3a5b80 46008261 161289325046008261 1612893250 EKKXsNSHi+woaG+bvl1XfL8pADqIG/yT32iDKSFXslQ= 450982336570 i 10770490 geanf 1 310   lv 1644397200 i ge 0   1613136902
0001fe3128080c0f9c08da293f8b171a 45730053 161102081345730053 1611020813 exI1uA8fK0pPfy+YG0iSc00k0t0DchqxJStsAe+qw20= 450981270748 i 9704668 1padt 1 300   hp 1642496400 i wy 0   1611240602
0002027c7282e2189631010c9f5fc39c 39145017 156311472939145017 1563114729 0y5kC3b8jQUGrqnqMLnpW2yTeLRVZtkgR18HYVsxXSo= 450979769897 i 8203817 baal 25 220   ep 1594650729 i ba 0   1563384906
000203e55dffbc8df8539780f74c9c2a 36515509 154108368736515509 1541083687 VO1SSo17YhsVkYlSxZC+Pd+Zk5wBGb85dAmAMOjnOr8= 450981745947 i 10179867 dtadn 40 390   nr   i dt 0   1548948907

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