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

6,686,439 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 XhMVDOpHpN9a2lMR3/Glf2kXV9EUGvcA1jD+USA/u0s= 450981590764 i 10024684 baadn 3 120   ba 1567013252 b ba 0   1539730507
00011a2fdbfd84c26f01eae92e19c3c1 42622079 157867442642622079 1578674426 1958wdq/0mG8ZsDUZH2mWGB7fGY0yWBxdMpqHzwt5qU= 450982318372 i 10752292 dpaar 1 530   wy 1610210426 i dp 0   1582558501
00011df483bf31e368f8e20f21d0dac0 35534639 154351496835534639 1543514968 KkQwUaQnCjFYf1tgsbOKyopv3LVc5dq2V7z1k2KpN+4= 450980097785 i 8531705 maaho 7 310   lv 1575050968 i ma 0   1543675806
00011e61e1046fab0b616a49410f2be6 37142801 155172997737142801 1551729977 ShU7mUXE6l5m3fhqwnb/f3xFNifuebly4/S3b8B8cUU= 450981505654 i 9939574 osjeb 32 430   os   i pl 0   1552062906
0001213db7ce18745dbc8939bcd77ffd 48743301 163346094548743301 1633460945 jq9gmYCjwPneNGkq9PN7rVmP4/BcZnaHY10v7DVq4lg= 450976208499 i 4642419 shjho 4 490   sm   i sh 0   1633610701
00012484dd2c1a99530802582185e794 43338520 159404798843338520 1594047988 IwHJos7mOzlyb7llFp56JO7FNae4l8u5wBA3sSPnd8U= 450982009330 i 10443250 gead 12 240   ge 1625583988 b ge 0   1594059009
0001292abcb7c5469f211ed9b3c4983e 46419523 161572089446419523 1615720894 HPyZaHJlLRfro7eEaVsZe+OqkFnyQ8FyzpM0mCZviSg= 450979279628 i 7713548 3ra 1 360   mo 1647244800 i sm 0   1615985702
00012fd871b4e7e5f62f13070ffdb322 38178503 155761505038178503 1557615050 BADKF7n02xIlTc7ciAm6WVu1HrhAcohwXn/SPhk/U9I= 450981389252 i 9823172 1cj 1 520   ww 1589151050 i sm 0   1557839407
0001310c35a8aa150994aa1fe2cbf7f9 40992928 157324002140992928 1573240021 QD4cRjqSGnnbJEQ9T5P/+mjz95MbDOoYKq18OONfCMs= 450977867309 i 6301229 anjf 30 101   an 1604776021 b an 0   1573324207
0001366d58476c43a92de89e6cfe89a9 45703932 161084575745703932 1610845757 LDg9SftG8ma7g0/5OcC2fAzWwS18iaLrWm9DUt5eM38= 450981962057 i 10395977 smad 5 490   sm 1642323600 b sm 0   1610912102
00013edbdfe9be03f6835b58183a4ca5 47828477 161859772147828477 1618597721 yOKW4m3OTIna58FVzbx0PWi1w42O426rOpDEn/WxIxE= 450982745308 i 11179228 chadn 1 420   oa   i ch 0   1627131601
0001409677849b37ae3a47d81c3df722 41042784 157352782641042784 1573527826 reTiMnrDBPsn/PctQsXndR4aZfY0OGS188y3cV0hLYc= 450981598372 i 10032292 shadt 20 390   nr 1605063826 i sh 0   1573739400
00014291dcf691c79aa6e1a680d15269 49221718 163360473349221718 1633604733 2swWOjuv8j8w3iWifBUScfh00gc+Hhs4ZFnx7HxBYR4= 450983012244 i 11446164 mmaar 1 0   1 1665129600 i mm 0   1637154902
000146dc83b150c7a1277114390ac764 36363041 154809608236363041 1548096082 9zADq/rBnjAXN9E5FihaiR1g/Lxv9ULDhR+6xa7bbR8= 450975836111 i 4270031 crjeb 6 440   pl 1579632082 i cr 0   1548431102
0001472ac3cd565cb0ef3ba9c56dc1a8 35959032 154602934935959032 1546029349 kJOXZmADbuOffxUfL6IDIr5cc+dHPaMwbLIdb7zdAbM= 450978391028 i 6824948 sbad 13 230   fo 1577565349 i sb 0   1546712101
00014c55e5a491a2bf48d96f358a3048 41355923 156951978341355923 1569519783 lwiRWktIo/w5j9DjU3oGBPwgG3oI+pCHA4BotKu2yJo= 450982170297 i 10604217 lvadn 21 380   mw   i lv 0   1575729002
00014e6c8b82c85c99d4d7feddf9da78 45511059 160954090945511059 1609540909 V2Y/oVgYUPV76s1S+iCNIXPX2IhhHEfXBfqhQB2CAlQ= 450982484276 i 10918196 wyjeb 1 260   gr 1641027600 i wy 0   1609779901
00014fb91705d6589a09c1ac721d427a 49061964 163584967449061964 1635849674 3JOiz/iz7PJ/Tkw+qEMZlU/L7rrwFcrk5qCegGiGvSE= 450976290063 i 4723983 osal 32 10   1 1667376000 i an 0   1636039801
000150b364d8a5e91c43a09b6c426da1 40856147 157252632840856147 1572526328 qved1L8x/N1xn0S7xL5ibVKM7Z7p5o9kWgj8e0wRObg= 450981082751 i 9516671 wyac 10 105   an 1604062328 i wy 0   1572962706
0001521517a02f63086fcbadd1384551 35054524 154084135735054524 1540841357 /5d9o/ux41qpsShieEbf+Erat6z7NK7ZFOk2KC0G5Us= 450975609540 i 4043460 anjer 38 260   gr   i an 0   1540992602
0001565ef2f4193e6adb16da7afb8d51 47637519 162558127047637519 1625581270 tC/iY79Gd24TkbzPubRfs/v/ngUqNlmoZeLvLQL3LZs= 450982659797 i 11093717 dtaar 1 210   dt   b dt 0   1625581802
000157326486e55c74d0576cdf2b1f58 46027557 161282372446027557 1612823724 5hdnnAK2cgUDZAHKP/iNurZ61e5NhKhIw2ZeTmrbi6Y= 450976312771 i 4746691 1paab 1 490   sm 1644310800 i sm 0   1613137501
00015ca4a42f44c9e48a6ab352cb5644 41646173 157739908241646173 1577399082 qXWI4x3dvo5wOritVqaqjoGUWxyvQ4Gy1wh54qGuFsE= 450981128781 i 9562701 mojf 23 850   dc 1608935082 b mo 0   1577402101
000163fceb28297535b05141427595bb 44843104 160459209944843104 1604592099 P7ycqtRbDx/5S0sSo0yFa6QE6NoveIXruFcKLL1WYzc= 450980750765 i 9184685 smjeb 25 490   sm 1636128099 b sm 0   1604610302
0001659f589a7619fa7f15892f5f0f55 41098081 157391992341098081 1573919923 2zfMzMXGXP+7qp0Sr+detcrxFD3txuRbZPtA1hGKLD4= 450978078084 i 6512004 nwjeb 33 440   pl 1605455923 i nw 0   1574351101
0001668def3788a49e758d6d3ee0ba1d 35741913 154449836835741913 1544498368 MLvX7Mb1hnUFho4sYSVtM7lxo2kDUuXS5XjLAY1nm/M= 450972691073 i 1124993 1cjho 1 360   mo 1576034368 i oa 0   1544798701
00016c438eb95fa8681fa2a83151e8a0 40158503 155732997840158503 1557329978 yRVKND0u19BZE64oZnKbs+rph+nN8yM2vGlTrJNIH/U= 450982068905 i 10502825 geaf 1 0   1   i ge 0   1569070207
00016f8e21ff3b372db01434344dc984 44477669 160201478744477669 1602014787 wjESC3XMbDaJ5tjHPztLcsrJehkwgyp89llQOg/HlE4= 450980187133 i 8621053 lvjab 2 320   ma 1633550787 i lv 0   1602087001
0001710a579b23977eb8ae6773903240 41985661 157554812441985661 1575548124 O2C2iiIjFuD/2zKgIX1pM76WJqN0eDTtcq2ZgdnIC4A= 450982081998 i 10515918 2raar 1 320   ma 1607084124 i wy 0   1579182301
00017182e35b7cb27c8f0cf5222dab87 42996765 158412218042996765 1584122180 qFpGpGzyZ5nMrmofxPkcd2+rrA26saeZw60OS9G7N2w= 450982036898 i 10470818 gradt 33 269   grw 1615658180 i grw 0   1593561009
000171be7465d0ffa75640c978fa08d2 36567311 154898946736567311 1548989467 hTLZNacg4M1L/jCMlhi748p2Sg3Y1OpgTneYjmfon9M= 450981230031 i 9663951 wyaf 21 230   fo 1580525467 i wy 0   1549295102
00017259a992680dafdd1213ef7e3bb1 46915096 161444828546915096 1614448285 zEX3hUUxKOkGRn6Na45VAadDmYeG37xzSwAKBOtMFK4= 450982711398 i 11145318 tsjbi 1 0   1 1645952400 i 1w 0   1619799902
0001791de35bf6f4757de7d0f6e73e69 34795230 153926967734795230 1539269677 fNQXNyxvFHIzAsruSzsaUmdJN/2Mh4PfR4S+ZtoqFIM= 450974846500 i 3280420 1lj 1 0   1 1570805677 i an 0   1539623106
000179653b50b62293d61821bf9c03f3 36231908 154730344536231908 1547303445 dqxfKHMJqZmib4xfwhmbbtosbYvRStHyqdVPTiTBUuk= 450978809818 i 7243738 cljf 1 260   gr 1578839445 i cl 0   1547646906
0001797a61ae22c0077260a29d4b3753 40391520 156954256940391520 1569542569 gc87k3WjWRYGAUcWtacKWEmynvnaG7oYlkj7CZk6EUY= 450977607187 i 6041107 smac 38 230   fo 1601078569 i sm 0   1570193406
00017d6bc7dbe4b25ceadcd3df0ce1f6 41952845 157844414341952845 1578444143 eTH1k2EDUhMk4dLzg3LEl6YOJ9PSxrOMQHF5ZMOU3Io= 450982242460 i 10676380 baaar 1 0   1 1609980143 i ba 0   1579098302
00017df54ccc7f595cb02db4bd799d5b 42302860 158069593342302860 1580695933 ywewNV7ZlG504i8sz5F32wsCxO4q6UF9JRkl8TukFHg= 450975071615 i 3505535 1lj 1 362   mo 1612231933 i dt 0   1580917202
000180034bedea52ac3ea96172d571e7 49124778 163621410049124778 1636214100 D5NVRUtVaPzG23AgkVr5b7dTdwNlXenrjf3AgMu0j7Q= 450978282693 i 6716613 1padc 1 520   ww   i ns 0   1636554601
0001818b32828e1c5f45b286381128aa 37227017 155223956837227017 1552239568 80+flwG3SuZU/sWJZzQeGZnKrXutdQtboMLeL/N+qp0= 450975993558 i 4427478 majnf 37 420   oa 1583775568 i ma 0   1552582206
000183ccc3824dd1c3096d03466061f1 44084156 159930930744084156 1599309307 3VtNUUM1757R70BicZ+xBlM7SgM154dRrGNKno0cSMA= 450975229869 i 3663789 cljnf 23 100   an 1630845307 i cl 0   1599661501
0001849b2f0fd762cd710372ee96dc60 47800625 162661002447800625 1626610024 on6R9C4RogFcB8e0gxAKwW2xWAz1BAH+VzGdIZGCGHE= 450977621038 i 6054958 1padt 1 393   nr 1658146024 i an 0   1626888001
000186c27a6c965b82198a8e3d226924 44338943 160087636544338943 1600876365 lvj7WSpiY1uD/HYzHbxVgQ1Wzzl1ZU2ABZawkaOK/90= 450981852398 i 10286318 hpad 21 1   1 1632384000 i hp 0   1601398202
0001891c33217040049c513a4d97447e 40428270 157013632340428270 1570136323 +lvU9/aw94GKm3h4h1riLG+rZfyempp4QDK58hk0hKI= 450981031761 i 9465681 wtad 6 510   wt   i 1w 0   1570627506
0001898fec8ae43b7add61786eb33a3a 37479229 155360216337479229 1553602163 +zsamBaH19qTIF3sH1fwT//YHNQcCmU9LGYZSYuS4rg= 450978874565 i 7308485 smjgn 38 310   lv 1585138163 i sm 0   1554140702
00018afdca8c00f70901081a1f5110ce 48864441 163417254948864441 1634172549 kfj9+LjMayqIsP2aPiXORkUWW7cLWJ1wFklT7cWIOdU= 450982886000 i 11319920 smjer 1 380   mw 1665648000 i sm 0   1634646302
000190a07a0b009a9e1417dcbb119bcc 47446407 162303489847446407 1623034898 Sr1NDYMaVRIfLHoTlvzh+jdNMrUpfVU9Jqsg42mp7Dw= 450980829583 i 9263503 moanf 2 100   an 1654502400 i mo 0   1624019701
0001913b806e2249e8e0ffbfc422a2c2 38233473 154700704038233473 1547007040 D3rvQRYMYHqnw7/Vz6dyBfiZOEoWQQF+De2/T4y035s= 450981920051 i 10353971 foaar 1 0   1   i fo 0   1558459207
000193c389f05b19ca2c937b972a6b1b 35841645 154517965535841645 1545179655 qlhfjAjNjd691bnA9UZ/YQp0QQXtbJrCfc+eJdJ2A7o= 450981268848 i 9702768 chjf 40 0   1   i ch 0   1545402602
00019663896419d5a8e2fcc76d17a56c 35863225 154516408335863225 1545164083 ciDi3IMxJ9IBAuDBMb2jDp+VBMv8KYYmgTvztcvp09g= 450979125220 i 7559140 nwjf 7 490   sm   i nw 0   1545831902
000196ace94f0a4c3376336c9fae0fbe 44216280 159983794144216280 1599837941 MWOuCM9HC2+m16opiNrKe42KQ/DbbHYt8tzjNDcRPig= 450982458958 i 10892878 1pabr 1 0   1 1631347200 i mm 0   1600694402
000198b9d790093929b7d27bf49f891f 40142011 156870684740142011 1568706847 WWBcdz5tmy8FNOf9fiK8iqq3NhNEeozhHoC5nqdTsJQ= 450981995696 i 10429616 readt 37 462   re 1600242847 i 1 0   1568913006
00019b59d26b30c592bd20fad07fd5d5 43669254 159647163743669254 1596471637 WVb//hGkZwpf/6156QJgj9YXYoUV9jCCyakULU0IplM= 450975436068 i 3869988 nsjeb 35 390   nr 1628007637 i ns 0   1596634514
00019bc367e12fe9a09361303f818d14 43037370 159122892543037370 1591228925 j5qThJg0B4CU2Pn5xU6cQ5ISM8W5ZBBniHVL+4fvpuc= 450981723277 i 10157197 bajec 20 430   os 1622764925 i ba 0   1593029107
00019c42988c0b027a5df5cc265ea0a3 44739062 160383406344739062 1603834063 mtP8ZyIkWX27J1YXzNEzPFVVlW3H8ltOYPeWulhqTpA= 450981639572 i 10073492 ghad 24 260   gr   i gh 0   1603981202
00019f47ca0dcc51734846f06201d36d 46360147 161542362746360147 1615423627 aKGAhRyat1yVO2tV0pMKdrwJ2OYRhcJ7tl1kHM/M+vA= 450980085005 i 8518925 moad 14 280   ha 1646902800 i cvw 0   1615557602
0001a00e8dff8fe584354b36641e4597 43024691 159138339143024691 1591383391 5wRb/Okhuypt3ThSuz6TZJAk606GE1Mzvy15/ybMJSQ= 450981373675 i 9807595 osjf 32 240   ge 1622919391 i ba 0   1593450308
0001a1b74be3b13c59b94c09bebdc8c4 40118203 156850081940118203 1568500819 3z5B00KDVyPDbCgCvby7gQye7i/nbDKyaru1S140+NY= 450975906447 i 4340367 1pac 1 100   an 1600036819 i lv 0   1568821206
0001a2bef0af71b6b42ea41faaa89e85 47586560 162500245147586560 1625002451 AePfUAj44MkR48zZXZJ+xReVdzmEFRcn9FZAHZaunxo= 450982587542 i 11021462 osjnf 32 10   1 1656489600 b 1 0   1625074202
0001a4811c1c75d7d872a4dfaf138c7f 46906651 161954986046906651 1619549860 Psp25dhcSv3RaFuhTrW6qckAV+UOb6RPBxitlIj4ILs= 450980109765 i 8543685 1pac 1 490   sm 1651085860 i an 0   1619705101
0001a94a86954c48fb4575eb3081bef4 43892566 158344480643892566 1583444806 owpSRaaqUcEyySDbF/oRAFE/QTMfnRiBer0hs1yHrEs= 450982439977 i 10873897 shaar 1 0   1   i sh 0   1598360702
0001abeb15af9b046adec6df4c1743a6 37286188 154283145437286188 1542831454 51WopDsrHOeRRsbDaZ2HeRev8prdJVAB9jSWKqM3Rb4= 450981689512 i 10123432 baac 17 300   hp 1574367454 i ba 0   1553013002
0001af43068232dff88d2e76df972fa8 40950532 157309514540950532 1573095145 v/V+SxznBdn8/stunj43LffeDmJ6NvWytodUDy1nCzA= 450977665356 i 6099276 hptf 20 340   mm 1604631145 i hp 0   1573312206
0001af9814ae86c1e42ca2272e8bdd29 47336250 161073484447336250 1610734844 ulD6tdGTZbYn0ewT3SbsiPSZw+j5z/vGPViqP24HZbE= 450982626243 i 11060163 gradn 1 260   gr 1642237200 i dtw 0   1623243001
0001aff1745ff6112698d76653de3606 35547724 154353782335547724 1543537823 qg0uzFQUP//txjqwhh0Prvh0bwjSSgUUbASJ8jGlRVM= 450979854657 i 8288577 cladf 4 120   ba 1575073823 i cl 0   1543851002
0001b1496adac710b1a3109d8ae52e1b 41353747 157541865841353747 1575418658 xvlvAqA91bDjnZsTNyERXMBUJvx3DUhmjptKz5pDKpc= 450980991795 i 9425715 baaf 10 100   an 1606954658 i ba 0   1575745502
0001b820c765674bf9ff96817f942c56 35863662 154533721535863662 1545337215 kBMdFZXI/B8jxoTECyVOP6HadznTRcMo3fVFhWLhA7M= 450981309286 i 9743206 cradn 15 170   cr   i 1 0   1545491407
0001b8fce1ea818b095dfb23e379f1fa 41935613 157878346441935613 1578783464 zo2JHe6Z6mFDyZYQ1vUrF9ajLBBmICfKVi9LkWYyYh4= 450975198714 i 3632634 osjbi 32 430   os 1610319464 b 1 0   1578855901
0001bb29a50ff802b1e0026c17e9d1d1 42138280 157990201142138280 1579902011 W2GtfuR75Ac4aRAH+Gz/dfYx0CIOLZ+ruw7c6rjRmS8= 450981423860 i 9857780 nrjgn 42 390   nr   b nr 0   1579905302
0001bb37f736436450b16c6f05e91619 48300245 162994680948300245 1629946809 b34n0U9Nnszsvb+8sbGWCPtThZhBXqQ/6HcqA6+MwfE= 450981145981 i 9579901 dtjf 7 530   wy 1661414400 i dt 0   1630500002
0001bddc807604f6beea7f7858f8fa27 37405446 155326995637405446 1553269956 WzJ/3h2InqVmBB06qDgjQsxQeqZpeWB1U+AFE+0AxqA= 450981727397 i 10161317 nwadc 37 380   mw 1584805956 i nw 0   1553609107
0001c010fd73da6aa5caee30d87c1760 36092223 154672828636092223 1546728286 w5jWGiwznZfLKCnlSKAZWNI5XtVPsRlR05IIWPSE1Ts= 450979835889 i 8269809 shjeb 28 120   ba 1578264286 i sh 0   1547138702
0001c19b6429647dcd096835e3ef06ec 44384429 160141199544384429 1601411995 WFGebVXgN6zQbF0EIt8j/ezP4encQ6iqCWYxH7SeuSQ= 450981704577 i 10138497 cladt 15 150   cl 1632902400 i grw 0   1601558402
0001c1a58b95285f53bedef853dd93bd 45494039 160934312545494039 1609343125 81UKNu7Wo0lp4lDGQT1/jlJC7Tp+4WOz1xNcSpwLmGg= 450976145718 i 4579638 anjnf 21 490   sm 1640854800 i anw 0   1609865101
0001c373f001d977b26174336f7b15c3 35447553 154284152235447553 1542841522 pibnygALhg17jISwelAVQm4vC95FdjmPkMmcvoMH854= 450980866258 i 9300178 cvad 21 400   ns 1574377522 i cvw 0   1543328406
0001c526a88681b132a52720c1c253c6 46279344 161454299446279344 1614542994 bJ1YA2F3aRG1iQZxsDRYqTYe3d/VMo+q8a2SSsC6fxk= 450981850283 i 10284203 shaf 23 280   ha 1646038800 i sh 0   1614960902
0001c5f889a6214387e6c6cac15c6c3c 41469981 157488175041469981 1574881750 34vFo/0BxpoBLH49LQEjwTc1s0rqr+kajGuWmP0+YW4= 450979625518 i 8059438 mmaf 21 360   mo   i mm 0   1576507501
0001c7f7d58bb288734836c930aef566 36704647 154850778636704647 1548507786 v1Sf2oEoVuMNz/T/8o0Nobd3FRLCeZjtSjlfbWSga88= 450981808254 i 10242174 mnanf 24 0   1 1580043786 b mn 0   1549730406
0001c9de7ddcf6536dbfc0adad8b78fa 48975304 163519488048975304 1635194880 ETJINtm165/gw3aVAn4VphUG1bthZJcCF+4tEU4pt/Q= 450982191309 i 10625229 smal 1 1   1   i sm 0   1635425402
0001cb14246f0921aa79af2b93eb0569 37761513 155503162337761513 1555031623 DCKIyfRn+EoKnIQzjLZIF79gu6ZzdbIObxfQhZ7cvj0= 450979559046 i 7992966 3ra 1 160   co 1586567623 i dt 0   1555424706
0001d2ff53197ff11502e38108744230 34806511 153937157534806511 1539371575 TPqBARqi7Ci3c1z89i5i/j4BHWoldOU4kXy3qjsC03w= 450977985653 i 6419573 bajeb 2 130   bh   i ba 0   1539620406
0001d3e5812bcb05378602c0cb7927a8 44732818 160375603044732818 1603756030 Va3DM0EiEQvRXTkHwOGz1LM0giCqpraTrMO+GLCxEfA= 450974670903 i 3104823 2ea 1 0   1 1635292030 i hp 0   1603904701
0001d4e3d09370717fd4a4f45e2ff852 45897790 161203661945897790 1612036619 rqZXBeG4WIJrZn07DpY4JMvmQIBlvKpvKzCitdtsvvU= 450979557894 i 7991814 2tttw 1 360   mo   i sh 0   1612370102
0001db4d516d9ed0ccdafdbf14ad8bc1 48689658 163286263648689658 1632862636 lj/8cyDZ7iDT1CmY0+Norvop5QGPVabwXif8mxvPM2w= 450982916478 i 11350398 coaar 1 260   gr 1664352000 i co 0   1633184102
0001dbb9c1a06609ddc2f4edb3e118d4 39244422 156375929039244422 1563759290 xRzWfGo5enNdrP2dfqO7+Cc5JGkGqaU1wDGg0r9tN3s= 450976165789 i 4599709 cvac 42 182   cv 1595295290 b cv 0   1563806407
0001dd60780c97de92d51ec7ca567ed8 39039759 156267084339039759 1562670843 En2rA5XAtZs/F1KaiRyj2tUD+PH4qRb+FHzuSmy9QFI= 450975471337 i 3905257 1paho 1 440   pl 1594206843 i ba 0   1562864106
0001e12b9f0d73452ed838eea7e9173e 39738353 156632747839738353 1566327478 MLh92Sa1XCH6c3nnrYalo5fp70vCKs39aNMsnigxTig= 450981986173 i 10420093 bajf 18 280   ha   i ba 0   1566825606
0001e1b34cf31bb51aa730a592537bc1 47807834 162675382947807834 1626753829 bsLxL5Q37hH2a7jTQFtSevx4a0PqVxqKzEpEtqSWDYs= 450982621658 i 11055578 cvaf 1 280   ha 1658304000 i cv 0   1626870902
0001e2deab18e5b3fb856b1d99bf5c09 45865235 161194865145865235 1611948651 dxpfsnxRE54DELOfjf1jnIQW0Nzlqcw+N2PHpxaeVN4= 450982007939 i 10441859 majer 42 120   ba 1643446800 i ma 0   1612188302
0001e487910c78467a364437ecbd9aff 44847907 160148403544847907 1601484035 2eypO8bguPnG/5DHneyWVD2AHVPZwP1P8THULgPI6E4= 450975605402 i 4039322 hpjho 12 380   mw 1632988800 i hp 0   1604929202
0001ea8814ff3d9ca2b4d930fa988e7e 46702298 161799949046702298 1617999490 xjQZ7Nz2vU0hCGUG3vkgPBYElI+7O7OlAjNapd+7a44= 450974988683 i 3422603 1lj 1 440   pl 1649491200 i mn 0   1618323002
0001eace5d684f4bf37e37c0a87a1df7 36402036 154820713336402036 1548207133 y5/QTgWZWVwFgrX5B0GoaG7TgfiFgvtppdGf21UO6m4= 450976365497 i 4799417 1fa 1 1   1 1579743133 i sh 0   1548437401
0001ee7a60e705ff3291caf50baaead0 37422243 155340606937422243 1553406069 fZ4AMdgB73mQUQIwk3lKasr1J9TbQwqYIWaFbBrQxzk= 450976438023 i 4871943 shac 38 480   sh 1584942069 i 1w 0   1553630407
0001f03f6b528f55f207f89b7fb59cfe 37840203 154700737437840203 1547007374 YNF06EINTbDWTlTJRDVuOeZo73IW5Vn9cNefg4h6QFM= 450981882339 i 10316259 baaar 1 0   1   i ba 0   1555937101
0001f38af12f9d018588eaa32b79842c 39020769 156245475939020769 1562454759 Zs8umfnJK0BDVC27wz1y3bW5p2fTlUDDykJbht/m2HI= 450980662784 i 9096704 anac 35 320   ma 1593990759 i an 0   1562783107
0001f3c594f228c928e43e7cf0a2cb33 47505337 162439169447505337 1624391694 P24Qqq7jI4cT9RF9g0zjaDEz4c+12mXZUJpzRX/s69M= 450981453567 i 9887487 baac 15 120   ba 1655927694 b ba 0   1624396502
0001f88e0c9ee110cdd7df565c056d01 48150536 162922250548150536 1629222505 8vcwTUFT0K4N1DTUWmvCAW2Sp7hk/0v1apJ3vq24Sio= 450980150435 i 8584355 1fa 1 142   ch   i pl 0   1629384002
0001fa5d15d60c679a0d675a4e3a5b80 46008261 161289325046008261 1612893250 Instst0ZfE/7j/bghWxgIQRnnSkbJGHN7r7qQKQsOgE= 450982336570 i 10770490 geanf 1 310   lv 1644397200 i ge 0   1613136902
0001fe3128080c0f9c08da293f8b171a 45730053 161102081345730053 1611020813 AROYgJHzTq/CgDfkDp3nRKY9XapLA6LyXvmzOiUuyd0= 450981270748 i 9704668 1padt 1 300   hp 1642496400 i wy 0   1611240602
0002027c7282e2189631010c9f5fc39c 39145017 156311472939145017 1563114729 IQ/JhASbHQ66ctG9IR/3yumPnsmACVe5npoqYxIEmOk= 450979769897 i 8203817 baal 25 220   ep 1594650729 i ba 0   1563384906
000203e55dffbc8df8539780f74c9c2a 36515509 154108368736515509 1541083687 8bIy4BJI+H2t0IP1zGZxHjCr2B3xd/Lp8iZmiAD2yrs= 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
);