circ_leased_items

37,426 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: transaction_day (date), due_date (date)

Link rowid ▼ id transaction_day stat_group_code_num stat_group_name stat_group_location_code stat_group_branch_name op_code application_name due_date item_record_id item_record_num barcode bib_record_id bib_record_num volume_record_id volume_record_num itype_code_num item_location_code ptype_code patron_home_library_code patron_agency_code_num loanrule_code_num
1 1 217267510 2025-01-20 307 Hyde Park bkdp01 hp Hyde Park i selfcheck 2025-02-27 450983784470 12218390 L000000221580 420910620547 3825539     6 hpalc 0 hp 19 8
2 2 217267511 2025-01-20 307 Hyde Park bkdp01 hp Hyde Park i selfcheck 2025-02-27 450984171864 12605784 L000000271643 420910689034 3894026     6 hpalc 0 hp 19 8
3 3 217267579 2025-01-20 307 Hyde Park bkdp01 hp Hyde Park i selfcheck 2025-01-21 450983935451 12369371 L000000242529 420910625795 3830787     6 hpalc 0 hp 19 8
4 4 217267893 2025-01-20 307 Hyde Park bkdp01 hp Hyde Park i selfcheck 2025-01-28 450984111392 12545312 L000000266999 420910682755 3887747     6 hpalc 0 hp 19 8
5 5 217268561 2025-01-20 468 Reading bkdp02 re Reading i selfcheck 2025-03-02 450984224716 12658636 L000000282236 420910701516 3906508     6 realc 0 re 35 8
6 6 217271087 2025-01-21 237 Forest Park bkdp01 fo Forest Park i selfcheck 2025-01-18 450984185421 12619341 L900000099127 420910702363 3907355     105 foalc 0 fo 14 22
7 7 217282015 2025-01-21 300 Hyde Park hp Hyde Park i sierra 2025-01-21 450984064477 12498397 L900000094862 420910654182 3859174     105 hpalc 0 hp 19 22
8 8 217282330 2025-01-21 300 Hyde Park hp Hyde Park i sierra 2025-01-31 450984124489 12558409 L000000268177 420910682535 3887527     6 hpalc 0 hp 19 8
9 9 217283049 2025-01-21 340 Mariemont mm Mariemont i sierra 2024-12-23 450983895922 12329842 L000000234641 420910635924 3840916     6 mmalc 0 mm 23 8
10 10 217283503 2025-01-21 260 Groesbeck gr Groesbeck i sierra 2025-01-08 450983944905 12378825 L000000245761 420910641181 3846173     6 moalc 0 mo 25 8
11 11 217283665 2025-01-21 340 Mariemont mm Mariemont i sierra 2025-02-13 450983451148 11885068 L000000182162 420910557890 3762882     6 mmalc 0 mm 23 8
12 12 217283674 2025-01-21 120 Blue Ash ba Blue Ash i sierra 2025-02-08 450983967591 12401511 L000000249219 420910644172 3849164     6 hpalc 0 ba 37 8
13 13 217283770 2025-01-21 260 Groesbeck gr Groesbeck i sierra 2025-01-08 450984137267 12571187 L000000269399 420910682544 3887536     6 moalc 0 mo 25 8
14 14 217283849 2025-01-21 260 Groesbeck gr Groesbeck i sierra 2025-02-15 450984179855 12613775 L000000272823 420910696741 3901733     6 gralc 0 ww 41 8
15 15 217284002 2025-01-21 260 Groesbeck gr Groesbeck i sierra 2024-12-18 450984124476 12558396 L000000268045 420910682535 3887527     6 gralc 0 1 1 8
16 16 217284707 2025-01-21 440 Pleasant Ridge pl Pleasant Ridge i sierra 2025-02-10 450984179774 12613694 L000000275362 420910695664 3900656     6 oaalc 0 pl 33 8
17 17 217284875 2025-01-21 450 Price Hill pr Price Hill i sierra 2025-01-24 450984226859 12660779 L900000100743 420910702640 3907632     105 pralc 0 pr 34 22
18 18 217285013 2025-01-21 120 Blue Ash ba Blue Ash i sierra 2025-01-27 450984179706 12613626 L000000274688 420910695664 3900656     6 baalc 0 ba 4 8
19 19 217285428 2025-01-21 440 Pleasant Ridge pl Pleasant Ridge i sierra 2025-02-10 450983301094 11735014 L000000164863 420910536352 3741344     6 oaalc 0 pl 33 8
20 20 217285560 2025-01-21 280 Harrison ha Harrison i sierra 2025-02-14 450983606986 12040906 L000000200162 420910582126 3787118     6 haalc 0 ha 38 8
21 21 217285786 2025-01-21 440 Pleasant Ridge pl Pleasant Ridge i sierra 2025-01-27 450984137373 12571293 L900000098095 420910685464 3890456     105 plalc 0 pl 33 22
22 22 217285793 2025-01-21 440 Pleasant Ridge pl Pleasant Ridge i sierra 2025-01-21 450984049611 12483531 L900000092593 420910674716 3879708     105 plalc 0 pl 33 22
23 23 217285819 2025-01-21 530 Wyoming wy Wyoming i sierra 2025-01-25 450984096764 12530684 L000000266429 420910677730 3882722     6 wyalc 0 wy 29 8
24 24 217285859 2025-01-21 440 Pleasant Ridge pl Pleasant Ridge i sierra 2025-01-24 450984211910 12645830 L900000100552 420910695919 3900911     105 plalc 0 pl 33 22
25 25 217285884 2025-01-21 260 Groesbeck gr Groesbeck i sierra 2025-01-21 450984105662 12539582 L900000096768 420910683573 3888565     105 gralc 0 gr 17 22
26 26 217285932 2025-01-21 260 Groesbeck gr Groesbeck i sierra 2025-01-18 450984105728 12539648 L900000096438 420910681147 3886139     105 gralc 0 gr 17 22
27 27 217286131 2025-01-21 440 Pleasant Ridge pl Pleasant Ridge i sierra 2025-01-16 450984226858 12660778 L900000100735 420910702640 3907632     105 plalc 0 pl 33 22
28 28 217286213 2025-01-21 280 Harrison ha Harrison i sierra 2025-02-08 450984227438 12661358 L000000279588 420910701360 3906352     6 haalc 0 ha 18 8
29 29 217286319 2025-01-21 400 Northside ns Northside i sierra 2025-01-10 450984179581 12613501 L000000273433 420910685555 3890547     6 1palc 0 ns 29 8
30 30 217287134 2025-01-21 440 Pleasant Ridge pl Pleasant Ridge i sierra 2025-01-24 450984033554 12467474 L000000256602 420910654562 3859554     6 plalc 0 pl 33 8
31 31 217287374 2025-01-21 340 Mariemont mm Mariemont i sierra 2025-01-14 450983881785 12315705 L000000233395 420910628288 3833280     6 mmalc 0 ma 21 8
32 32 217287412 2025-01-21 280 Harrison ha Harrison i sierra 2025-02-15 450983754880 12188800 L000000219063 420910617879 3822871     6 haalc 0 ha 18 8
33 33 217288256 2025-01-21 380 Mt Washington mw Mt Washington i sierra 2025-01-21 450984211797 12645717 L000000277293 420910700801 3905793     6 mwalc 0 oa 31 8
34 34 217288452 2025-01-21 320 Madeira ma Madeira i sierra 2025-01-13 450983988141 12422061 L000000249870 420910648678 3853670     6 maalc 0 ma 21 8
35 35 217288608 2025-01-21 120 Blue Ash ba Blue Ash i sierra 2025-02-27 450984011135 12445055 L000000252007 420910650207 3855199     6 baalc 0 co 8 8
36 36 217288955 2025-01-21 380 Mt Washington mw Mt Washington i sierra 2025-01-13 450983993405 12427325 L000000250597 420910648679 3853671     6 baalc 0 mw 27 8
37 37 217289053 2025-01-21 280 Harrison ha Harrison i sierra 2025-01-18 450984064439 12498359 L900000094128 420910652877 3857869     105 haalc 0 ha 18 22
38 38 217289135 2025-01-21 1 Main 1 Main Library i sierra 2025-01-04 450984065650 12499570 L000000262147 420910651231 3856223     6 1palc 0 ns 29 8
39 39 217289290 2025-01-21 1 Main 1 Main Library i sierra 2025-01-04 450984035642 12469562 L000000255497 420910612559 3817551     6 1palc 0 ns 29 8
40 40 217289511 2025-01-21 240 Green Twp ge Green Township i sierra 2025-02-19 450984185327 12619247 L000000276097 420910695741 3900733     6 gealc 0 cv 10 8
41 41 217289614 2025-01-21 280 Harrison ha Harrison i sierra 2025-01-18 450984116069 12549989 L900000097139 420910684543 3889535     105 haalc 0 ha 18 22
42 42 217289918 2025-01-21 380 Mt Washington mw Mt Washington i sierra 2025-01-18 450984137369 12571289 L900000098053 420910685464 3890456     105 mwalc 0 mw 30 22
43 43 217290097 2025-01-21 490 Symmes Twp sm Symmes Township i sierra 2025-01-23 450984137346 12571266 L900000097824 420910685463 3890455     105 smalc 0 sm 38 22
44 44 217290101 2025-01-21 240 Green Twp ge Green Township i sierra 2025-02-19 450984029608 12463528 L000000257436 420910669667 3874659     6 gealc 0 ge 15 8
45 45 217290306 2025-01-21 490 Symmes Twp sm Symmes Township i sierra 2025-01-11 450983993522 12427442 L000000251769 420910648679 3853671     6 smalc 0 sm 38 8
46 46 217290760 2025-01-21 340 Mariemont mm Mariemont i sierra 2025-01-13 450984224687 12658607 L000000281949 420910701516 3906508     6 mmalc 0 hp 19 8
47 47 217290764 2025-01-21 240 Green Twp ge Green Township i sierra 2025-02-13 450983711275 12145195 L000000213975 420910608060 3813052     6 gealc 0 ge 15 8
48 48 217292133 2025-01-21 380 Mt Washington mw Mt Washington i sierra 2025-01-17 450984211977 12645897 L900000099937 420910703760 3908752     105 mwalc 0 mw 27 22
49 49 217292503 2025-01-20 478 St Bernard bkdp02 sb St Bernard i selfcheck 2025-02-25 450984151288 12585208 L000000270892 420910685562 3890554     6 sbalc 0 sb 5 8
50 50 217292511 2025-01-20 478 St Bernard bkdp02 sb St Bernard i selfcheck 2025-02-25 450984179786 12613706 L000000275487 420910695664 3900656     6 sbalc 0 sb 5 8
51 51 217292824 2025-01-21 100 Anderson an Anderson i sierra 2025-01-08 450984220666 12654586 L000000281170 420910701355 3906347     6 shalc 0 pr 34 8
52 52 217293118 2025-01-21 160 College Hill co College Hill i sierra 2025-01-22 450984065633 12499553 L000000261545 420910673033 3878025     6 sbalc 0 hp 19 8
53 53 217293147 2025-01-21 490 Symmes Twp sm Symmes Township i sierra 2025-01-27 450984096649 12530569 L000000265272 420910677730 3882722     6 baalc 0 ba 4 8
54 54 217293195 2025-01-21 330 Madisonville md Madisonville i sierra 2024-12-27 450983935465 12369385 L000000243097 420910582055 3787047     6 hpalc 0 hp 19 8
55 55 217293375 2025-01-21 100 Anderson an Anderson i sierra 2025-01-17 450983784410 12218330 L000000220988 420910620547 3825539     6 analc 0 an 2 8
56 56 217294035 2025-01-21 340 Mariemont mm Mariemont i sierra 2025-02-14 450984179836 12613756 L000000272633 420910696741 3901733     6 dpalc 0 co 8 8
57 57 217294099 2025-01-21 310 Loveland lv Loveland i sierra 2025-02-20 450984179910 12613830 L000000273375 420910696741 3901733     6 smalc 0 sm 38 8
58 58 217294267 2025-01-21 100 Anderson an Anderson i sierra 2025-02-21 450983763138 12197058 L000000222885 420910619616 3824608     6 mmalc 0 an 2 8
59 59 217294273 2025-01-21 220 Elmwood Place ep Elmwood Place i sierra 2025-01-25 450983904877 12338797 L000000238832 420910636555 3841547     6 sbalc 0 ep 13 8
60 60 217295033 2025-01-21 310 Loveland lv Loveland i sierra 2025-02-20 450984111447 12545367 L000000267542 420910682755 3887747     6 smalc 0 sm 38 8
61 61 217295065 2025-01-21 100 Anderson an Anderson i sierra 2025-02-15 450983721859 12155779 L000000216283 420910617988 3822980     6 analc 0 an 2 8
62 62 217295177 2025-01-21 310 Loveland lv Loveland i sierra 2025-02-14 450984137196 12571116 L000000268680 420910682544 3887536     6 baalc 0 ba 38 8
63 63 217295642 2025-01-21 100 Anderson an Anderson i sierra 2025-02-25 450984096641 12530561 L000000265199 420910677730 3882722     6 analc 0 an 27 8
64 64 217295850 2025-01-21 242 Green Twp schk02 ge Green Township o selfcheck 2025-03-04 450984220616 12654536 L000000280685 420910701355 3906347     6 gealc 0 ge 15 8
65 65 217296211 2025-01-21 100 Anderson an Anderson i sierra 2025-02-15 450984029567 12463487 L000000257022 420910669667 3874659     6 analc 0 nw 30 8
66 66 217296245 2025-01-21 242 Green Twp schk02 ge Green Township o selfcheck 2025-03-04 450984124471 12558391 L000000267997 420910682535 3887527     6 gealc 0 ge 10 8
67 67 217296497 2025-01-21 210 Delhi Twp dt Delhi Township i sierra 2025-01-13 450983914448 12348368 L000000239426 420910636778 3841770     6 dtalc 0 cv 10 8
68 68 217296645 2025-01-21 237 Forest Park bkdp01 fo Forest Park i selfcheck 2025-01-22 450984185326 12619246 L000000276089 420910695741 3900733     6 foalc 0 fo 14 8
69 69 217296914 2025-01-21 100 Anderson an Anderson i sierra 2025-02-03 450984111340 12545260 L000000266478 420910682755 3887747     6 analc 0 ge 25 8
70 70 217297162 2025-01-21 211 Delhi Twp schk01 dt Delhi Township o selfcheck 2025-03-04 450984227419 12661339 L000000279406 420910701360 3906352     6 dtalc 0 dt 12 8
71 71 217298098 2025-01-21 372 Mt Healthy schk02 mt Mt Healthy o selfcheck 2025-03-04 450984185367 12619287 L000000276493 420910695741 3900733     6 mtalc 0 mt 26 8
72 72 217298853 2025-01-21 481 Sharonville schk01 sh Sharonville o selfcheck 2025-03-04 450984179903 12613823 L000000273300 420910696741 3901733     6 shalc 0 oa 23 8
73 73 217299115 2025-01-21 493 Symmes Twp schk03 sm Symmes Township o selfcheck 2025-03-04 450984201350 12635270 L000000278879 420910691138 3896130     6 smalc 0 sm 38 8
74 74 217299743 2025-01-21 200 Deer Park dp Deer Park i sierra 2025-01-11 450984105703 12539623 L900000096180 420910681428 3886420     105 dpalc 0 oa 31 22
75 75 217300034 2025-01-21 280 Harrison ha Harrison i sierra 2025-02-11 450984151234 12585154 L000000270355 420910685562 3890554     6 haalc 0 ha 18 8
76 76 217300141 2025-01-21 422 Oakley schk02 oa Oakley o selfcheck 2025-03-04 450984096730 12530650 L000000266080 420910677730 3882722     6 oaalc 0 oa 21 8
77 77 217300544 2025-01-21 1 Main 1 Main Library i sierra 2025-01-28 450984065670 12499590 L000000262469 420910648683 3853675     6 1palc 0 1 1 8
78 78 217300782 2025-01-21 280 Harrison ha Harrison i sierra 2025-02-20 450983993448 12427368 L000000251025 420910648679 3853671     6 haalc 0 1 1 8
79 79 217301609 2025-01-21 352 Miami Twp schk02 mn Miami Township o selfcheck 2025-03-04 450984065527 12499447 L000000261883 420910673048 3878040     6 mnalc 0 mn 24 8
80 80 217301610 2025-01-21 352 Miami Twp schk02 mn Miami Township o selfcheck 2025-03-04 450983746433 12180353 L000000218073 420910617038 3822030     6 mnalc 0 mn 24 8
81 81 217301892 2025-01-21 360 Monfort Heights mo Monfort Heights i sierra 2025-01-24 450984184125 12618045 L900000099259 420910695921 3900913     105 gealc 0 mo 25 22
82 82 217302796 2025-01-21 410 Norwood nw Norwood i sierra 2025-01-27 450983993496 12427416 L000000251504 420910648679 3853671     6 nwalc 0 nw 1 8
83 83 217302965 2025-01-21 213 Delhi Twp schk03 dt Delhi Township o selfcheck 2025-01-29 450984105658 12539578 L900000096727 420910683573 3888565     105 dtalc 0 dt 12 22
84 84 217303278 2025-01-21 101 Anderson schk01 an Anderson o selfcheck 2025-03-04 450983823719 12257639 L000000227017 420910623784 3828776     6 analc 0 an 2 8
85 85 217303650 2025-01-21 520 Westwood ww Westwood i sierra 2025-01-21 450984137378 12571298 L900000098145 420910685464 3890456     105 wwalc 0 ep 13 22
86 86 217303783 2025-01-21 200 Deer Park dp Deer Park i sierra 2025-02-13 450984201258 12635178 L000000277954 420910691138 3896130     6 dpalc 0 dp 11 8
87 87 217303874 2025-01-21 242 Green Twp schk02 ge Green Township o selfcheck 2025-03-04 450984201268 12635188 L000000278051 420910691138 3896130     6 gealc 0 dt 12 8
88 88 217303971 2025-01-21 200 Deer Park dp Deer Park i sierra 2025-02-15 450984171838 12605758 L000000271387 420910689034 3894026     6 dpalc 0 dp 11 8
89 89 217303988 2025-01-21 100 Anderson an Anderson i sierra 2025-02-19 450983685915 12119835 L000000207381 420910609280 3814272     6 analc 0 an 2 8
90 90 217304135 2025-01-21 105 Anderson schk05 an Anderson o selfcheck 2025-03-04 450983721863 12155783 L000000216325 420910617988 3822980     6 analc 0 an 2 8
91 91 217304184 2025-01-21 340 Mariemont mm Mariemont i sierra 2025-01-16 450983722037 12155957 L000000215665 420910617575 3822567     6 mmalc 0 mm 23 8
92 92 217304740 2025-01-21 120 Blue Ash ba Blue Ash i sierra 2025-01-21 450984036966 12470886 L000000258582 420910673036 3878028     6 baalc 0 ba 38 8
93 93 217304803 2025-01-21 120 Blue Ash ba Blue Ash i sierra 2025-01-21 450983451098 11885018 L000000181669 420910557890 3762882     6 baalc 0 ba 38 8
94 94 217304811 2025-01-21 200 Deer Park dp Deer Park i sierra 2025-01-08 450984185417 12619337 L900000099085 420910702363 3907355     105 dpalc 0 dp 11 22
95 95 217304830 2025-01-21 380 Mt Washington mw Mt Washington i sierra 2025-02-08 450984201319 12635239 L000000278564 420910691138 3896130     6 mwalc 0 mw 27 8
96 96 217304850 2025-01-21 300 Hyde Park hp Hyde Park i sierra 2025-02-26 450983966345 12400265 L000000247593 420910644187 3849179     6 gealc 0 ge 15 8
97 97 217304958 2025-01-21 200 Deer Park dp Deer Park i sierra 2025-03-01 450984224645 12658565 L000000281527 420910701516 3906508     6 dpalc 0 dp 19 8
98 98 217305037 2025-01-21 200 Deer Park dp Deer Park i sierra 2025-02-15 450984036975 12470895 L000000258673 420910673036 3878028     6 dpalc 0 dp 11 8
99 99 217305038 2025-01-21 200 Deer Park dp Deer Park i sierra 2025-01-24 450984049523 12483443 L900000093096 420910671621 3876613     105 dpalc 0 dp 11 22
100 100 217305203 2025-01-21 260 Groesbeck gr Groesbeck i sierra 2025-01-22 450984049565 12483485 L900000092825 420910655394 3860386     105 gralc 0 bh 5 22
101 101 217305403 2025-01-21 300 Hyde Park hp Hyde Park o sierra 2025-03-04 450984096694 12530614 L000000265728 420910677730 3882722     6 hpalc 0 hp 19 8
102 102 217305439 2025-01-21 450 Price Hill pr Price Hill i sierra 2025-01-23 450984064487 12498407 L900000094961 420910654182 3859174     105 pralc 0 cv 10 22
103 103 217305634 2025-01-21 300 Hyde Park hp Hyde Park i sierra 2025-02-13 450983966361 12400281 L000000247759 420910644187 3849179     6 hpalc 0 hp 19 8
104 104 217305639 2025-01-21 300 Hyde Park hp Hyde Park i sierra 2025-02-13 450983914471 12348391 L000000239657 420910636778 3841770     6 hpalc 0 hp 19 8
105 105 217305663 2025-01-21 300 Hyde Park hp Hyde Park i sierra 2025-02-13 450983955491 12389411 L000000246629 420910644234 3849226     6 hpalc 0 hp 19 8
106 106 217306311 2025-01-21 490 Symmes Twp sm Symmes Township i sierra 2025-02-19 450984137308 12571228 L000000269803 420910682544 3887536     6 smalc 0 sm 38 8
107 107 217306316 2025-01-21 105 Anderson schk05 an Anderson i selfcheck 2025-01-14 450984171812 12605732 L000000271122 420910689034 3894026     6 analc 0 an 2 8
108 108 217306329 2025-01-21 480 Sharonville sh Sharonville i sierra 2025-02-13 450984179790 12613710 L000000275529 420910695664 3900656     6 shalc 0 sh 37 8
109 109 217306747 2025-01-21 441 Pleasant Rdge schk01 pl Pleasant Ridge o selfcheck 2025-03-04 450984201333 12635253 L000000278705 420910691138 3896130     6 plalc 0 pl 33 8
110 110 217307379 2025-01-21 120 Blue Ash ba Blue Ash i sierra 2025-01-21 450984033471 12467391 L000000255778 420910654562 3859554     6 baalc 0 sh 37 8
111 111 217307401 2025-01-21 102 Anderson schk02 an Anderson o selfcheck 2025-03-04 450984201230 12635150 L000000277673 420910691138 3896130     6 analc 0 an 2 8
112 112 217307459 2025-01-21 370 Mt Healthy mt Mt Healthy o sierra 2025-03-04 450984035741 12469661 L000000255109 420910654474 3859466     6 mtalc 0 mt 1 8
113 113 217307651 2025-01-21 261 Groesbeck schk01 gr Groesbeck o selfcheck 2025-03-04 450984227437 12661357 L000000279570 420910701360 3906352     6 gralc 0 gr 17 8
114 114 217307670 2025-01-21 324 Madeira schk04 ma Madeira o selfcheck 2025-03-04 450983784478 12218398 L000000221663 420910620547 3825539     6 maalc 0 ma 21 8
115 115 217307808 2025-01-21 121 Blue Ash schk01 ba Blue Ash o selfcheck 2025-03-04 450984011134 12445054 L000000251991 420910650207 3855199     6 baalc 0 ba 4 8
116 116 217308190 2025-01-21 401 Northside schk01 ns Northside o selfcheck 2025-03-04 450984179893 12613813 L000000273201 420910696741 3901733     6 nsalc 0 ns 29 8
117 117 217308352 2025-01-21 204 Deer Park schk04 dp Deer Park o selfcheck 2025-03-04 450984179713 12613633 L000000274753 420910695664 3900656     6 dpalc 0 lv 20 8
118 118 217308477 2025-01-21 1 Main 1 Main Library i sierra 2025-01-12 450984226865 12660785 L900000100800 420910702640 3907632     105 1palc 0 1 1 22
119 119 217308529 2025-01-21 302 Hyde Park schk02 hp Hyde Park o selfcheck 2025-03-04 450983935457 12369377 L000000242750 420910632493 3837485     6 hpalc 0 cl 9 8
120 120 217308692 2025-01-21 281 Harrison schk01 ha Harrison o selfcheck 2025-03-04 450984036997 12470917 L000000258897 420910673036 3878028     6 haalc 0 1 1 8
121 121 217308693 2025-01-21 281 Harrison schk01 ha Harrison o selfcheck 2025-03-04 450983680614 12114534 L000000208728 420910608237 3813229     6 haalc 0 1 1 8
122 122 217308769 2025-01-21 310 Loveland lv Loveland i sierra 2025-02-22 450984179870 12613790 L000000272971 420910696741 3901733     6 lvalc 0 lv 20 8
123 123 217308815 2025-01-21 200 Deer Park dp Deer Park i sierra 2025-02-25 450983904801 12338721 L000000238071 420910636555 3841547     6 dpalc 0 ba 21 8
124 124 217309150 2025-01-21 500 Walnut Hills wh Walnut Hills o sierra 2025-03-04 450984011240 12445160 L000000253054 420910650207 3855199     6 whalc 0 an 2 8
125 125 217309208 2025-01-21 200 Deer Park dp Deer Park i sierra 2025-02-24 450984036976 12470896 L000000258681 420910673036 3878028     6 dpalc 0 dp 11 8
126 126 217309225 2025-01-21 200 Deer Park dp Deer Park o sierra 2025-03-04 450984179595 12613515 L000000273573 420910685555 3890547     6 dpalc 0 dp 11 8
127 127 217309444 2025-01-21 493 Symmes Twp schk03 sm Symmes Township o selfcheck 2025-03-04 450983993522 12427442 L000000251769 420910648679 3853671     6 smalc 0 sm 38 8
128 128 217309466 2025-01-21 121 Blue Ash schk01 ba Blue Ash o selfcheck 2025-03-04 450984179819 12613739 L000000272468 420910696741 3901733     6 baalc 0 ba 4 8
129 129 217309468 2025-01-21 121 Blue Ash schk01 ba Blue Ash o selfcheck 2025-03-04 450984029573 12463493 L000000257089 420910669667 3874659     6 baalc 0 ba 4 8
130 130 217310248 2025-01-21 312 Loveland schk02 lv Loveland o selfcheck 2025-03-04 450984171867 12605787 L000000271676 420910689034 3894026     6 lvalc 0 lv 20 8
131 131 217310661 2025-01-21 520 Westwood ww Westwood o sierra 2025-01-29 450984105750 12539670 L900000096651 420910681147 3886139     105 wwalc 0 pl 33 22
132 132 217310889 2025-01-21 1 Main 1 Main Library o sierra 2025-01-29 450984116086 12550006 L900000097303 420910684543 3889535     105 1palc 0 1 1 22
133 133 217311144 2025-01-21 323 Madeira schk03 ma Madeira o selfcheck 2025-03-04 450983784480 12218400 L000000221689 420910620547 3825539     6 maalc 0 ma 21 8
134 134 217311273 2025-01-21 370 Mt Healthy mt Mt Healthy i sierra 2025-01-25 450984211976 12645896 L900000099929 420910703760 3908752     105 mtalc 0 1 1 22
135 135 217311647 2025-01-21 363 Monfort Hghts schk03 mo Monfort Heights o selfcheck 2025-03-04 450984011203 12445123 L000000252684 420910650207 3855199     6 moalc 0 mo 25 8
136 136 217311929 2025-01-21 100 Anderson an Anderson i sierra 2025-01-21 450984179766 12613686 L000000275289 420910695664 3900656     6 mwalc 0 nw 30 8
137 137 217312282 2025-01-21 211 Delhi Twp schk01 dt Delhi Township o selfcheck 2025-03-04 450983914448 12348368 L000000239426 420910636778 3841770     6 dtalc 0 dt 18 8
138 138 217312354 2025-01-21 234 Forest Park schk04 fo Forest Park o selfcheck 2025-03-04 450984137223 12571143 L000000268953 420910682544 3887536     6 foalc 0 gh 16 8
139 139 217312539 2025-01-21 300 Hyde Park hp Hyde Park i sierra 2025-02-10 450984021673 12455593 L000000253617 420910654486 3859478     6 hpalc 0 hp 19 8
140 140 217312782 2025-01-21 241 Green Twp schk01 ge Green Township o selfcheck 2025-03-04 450983988111 12422031 L000000249573 420910648678 3853670     6 gealc 0 mn 15 8
141 141 217312783 2025-01-21 241 Green Twp schk01 ge Green Township o selfcheck 2025-03-04 450984227426 12661346 L000000279471 420910701360 3906352     6 gealc 0 mn 15 8
142 142 217312785 2025-01-21 241 Green Twp schk01 ge Green Township o selfcheck 2025-03-04 450984054274 12488194 L000000259887 420910673498 3878490     6 gealc 0 mn 15 8
143 143 217313099 2025-01-21 360 Monfort Heights mo Monfort Heights i sierra 2025-01-14 450983904986 12338906 L000000237321 420910635921 3840913     6 moalc 0 mo 25 8
144 144 217313107 2025-01-21 360 Monfort Heights mo Monfort Heights i sierra 2025-02-19 450983784497 12218417 L000000221853 420910620547 3825539     6 moalc 0 ge 15 8
145 145 217313390 2025-01-21 363 Monfort Hghts schk03 mo Monfort Heights o selfcheck 2025-03-04 450983914501 12348421 L000000239954 420910636778 3841770     6 moalc 0 mo 25 8
146 146 217314608 2025-01-21 850 Sorter--xdcsort1 51   i selfcheck 2025-01-15 450984171925 12605845 L000000272252 420910689034 3894026     6 whalc 196 wh 39 1
147 147 217314660 2025-01-21 850 Sorter--xdcsort1 51   i selfcheck 2025-01-15 450984137311 12571231 L000000269837 420910682544 3887536     6 whalc 196 wh 39 1
148 148 217314947 2025-01-21 520 Westwood ww Westwood i sierra 2025-01-21 450984226863 12660783 L900000100784 420910702640 3907632     105 wwalc 0 ww 41 22
149 149 217315031 2025-01-21 520 Westwood ww Westwood o sierra 2025-01-29 450984226863 12660783 L900000100784 420910702640 3907632     105 wwalc 0 ww 41 22
150 150 217315052 2025-01-21 411 Norwood schk01 nw Norwood i selfcheck 2025-01-08 450984054309 12488229 L000000260232 420910673498 3878490     6 nwalc 0 nw 30 8
151 151 217315123 2025-01-21 411 Norwood schk01 nw Norwood o selfcheck 2025-03-04 450984054309 12488229 L000000260232 420910673498 3878490     6 nwalc 0 nw 30 8
152 152 217315330 2025-01-21 102 Anderson schk02 an Anderson i selfcheck 2025-01-28 450984065563 12499483 L000000260844 420910673033 3878025     6 analc 0 an 2 8
153 153 217315334 2025-01-21 310 Loveland lv Loveland i sierra 2025-01-16 450984220669 12654589 L000000281204 420910701355 3906347     6 smalc 0 sm 38 8
154 154 217315451 2025-01-21 310 Loveland lv Loveland i sierra 2025-02-19 450984071228 12505148 L000000262709 420910677432 3882424     6 dpalc 0 sm 38 8
155 155 217315634 2025-01-21 262 Groesbeck schk02 gr Groesbeck o selfcheck 2025-03-04 450983993447 12427367 L000000251017 420910648679 3853671     6 gralc 0 pl 25 8
156 156 217315739 2025-01-21 241 Green Twp schk01 ge Green Township o selfcheck 2025-03-04 450983711275 12145195 L000000213975 420910608060 3813052     6 gealc 0 ch 6 8
157 157 217315845 2025-01-21 280 Harrison ha Harrison i sierra 2025-02-26 450984179734 12613654 L000000274969 420910695664 3900656     6 haalc 0 ha 18 8
158 158 217315895 2025-01-21 361 Monfort Hghts schk01 mo Monfort Heights o selfcheck 2025-03-04 450984171884 12605804 L000000271841 420910689034 3894026     6 moalc 0 co 8 8
159 159 217316172 2025-01-21 200 Deer Park dp Deer Park i sierra 2025-02-15 450984179835 12613755 L000000272625 420910696741 3901733     6 dpalc 0 1w 1 8
160 160 217316237 2025-01-21 461 Reading schk01 re Reading o selfcheck 2025-03-04 450984071269 12505189 L000000263111 420910677432 3882424     6 realc 0 re 35 8
161 161 217316422 2025-01-21 490 Symmes Twp sm Symmes Township i sierra 2025-02-24 450983881831 12315751 L000000233858 420910628288 3833280     6 smalc 0 sm 38 8
162 162 217316528 2025-01-21 307 Hyde Park bkdp01 hp Hyde Park i selfcheck 2025-02-21 450983935452 12369372 L000000242537 420910625795 3830787     6 hpalc 0 hp 19 8
163 163 217316560 2025-01-21 204 Deer Park schk04 dp Deer Park o selfcheck 2025-03-04 450983966336 12400256 L000000247502 420910644187 3849179     6 dpalc 0 1w 1 8
164 164 217316650 2025-01-21 260 Groesbeck gr Groesbeck o sierra 2025-01-29 450984064406 12498326 L900000094474 420910675856 3880848     105 gralc 0 grw 17 22
165 165 217316653 2025-01-21 260 Groesbeck gr Groesbeck o sierra 2025-01-29 450984156821 12590741 L900000098277 420910700829 3905821     105 gralc 0 grw 17 22
166 166 217316901 2025-01-21 482 Sharonville schk02 sh Sharonville o selfcheck 2025-03-04 450984179790 12613710 L000000275529 420910695664 3900656     6 shalc 0 sh 37 8
167 167 217317081 2025-01-21 324 Madeira schk04 ma Madeira o selfcheck 2025-03-04 450984021684 12455604 L000000253724 420910654486 3859478     6 maalc 0 ma 21 8
168 168 217317288 2025-01-21 360 Monfort Heights mo Monfort Heights i sierra 2025-02-20 450983988157 12422077 L000000250035 420910648678 3853670     6 moalc 0 mo 25 8
169 169 217317292 2025-01-21 102 Anderson schk02 an Anderson i selfcheck 2025-01-25 450983543540 11977460 L900000070821 420910561244 3766236     105 gralc 0 an 2 22
170 170 217318003 2025-01-21 241 Green Twp schk01 ge Green Township o selfcheck 2025-03-04 450984071234 12505154 L000000262766 420910677432 3882424     6 gealc 0 ge 15 8
171 171 217318337 2025-01-21 105 Anderson schk05 an Anderson i selfcheck 2025-03-01 450984096643 12530563 L000000265215 420910677730 3882722     6 analc 0 an 2 8
172 172 217318645 2025-01-21 100 Anderson an Anderson i sierra 2025-01-17 450983655974 12089894 L000000206151 420910597361 3802353     6 analc 0 an 2 8
173 173 217318745 2025-01-21 380 Mt Washington mw Mt Washington i sierra 2025-01-21 450984111417 12545337 L000000267245 420910682755 3887747     6 mwalc 0 mw 27 8
174 174 217318847 2025-01-21 64 Main 1s schk02 1 Main Library i selfcheck 2025-01-25 450983608422 12042342 L900000075788 420910583617 3788609     105 1palc 0 1w 1 22
175 175 217319062 2025-01-21 300 Hyde Park hp Hyde Park i sierra 2025-02-22 450984224670 12658590 L000000281774 420910701516 3906508     6 hpalc 0 hp 19 8
176 176 217319433 2025-01-21 482 Sharonville schk02 sh Sharonville o selfcheck 2025-03-04 450984111446 12545366 L000000267534 420910682755 3887747     6 shalc 0 sh 37 8
177 177 217319449 2025-01-21 342 Mariemont schk02 mm Mariemont o selfcheck 2025-03-04 450984011194 12445114 L000000252593 420910650207 3855199     6 mmalc 0 mm 23 8
178 178 217319527 2025-01-21 412 Norwood schk02 nw Norwood o selfcheck 2025-03-04 450984037029 12470949 L000000259218 420910673036 3878028     6 nwalc 0 nw 30 8
179 179 217319622 2025-01-21 251 Greenhills schk01 gh Greenhills i selfcheck 2025-01-24 450984211788 12645708 L000000277202 420910700801 3905793     6 ghalc 0 gh 16 8
180 180 217319625 2025-01-21 102 Anderson schk02 an Anderson i selfcheck 2025-01-18 450984029565 12463485 L000000257006 420910669667 3874659     6 analc 0 an 2 8
181 181 217319626 2025-01-21 102 Anderson schk02 an Anderson i selfcheck 2025-01-18 450984179814 12613734 L000000272419 420910696741 3901733     6 analc 0 an 2 8
182 182 217319700 2025-01-21 102 Anderson schk02 an Anderson i selfcheck 2025-01-11 450983784414 12218334 L000000221028 420910620547 3825539     6 analc 0 an 2 8
183 183 217319804 2025-01-21 440 Pleasant Ridge pl Pleasant Ridge i sierra 2025-01-15 450984011219 12445139 L000000252841 420910650207 3855199     6 plalc 0 pl 33 8
184 184 217319926 2025-01-21 120 Blue Ash ba Blue Ash i sierra 2025-02-20 450983806809 12240729 L000000224873 420910622771 3827763     6 baalc 0 sm 38 8
185 185 217320286 2025-01-21 372 Mt Healthy schk02 mt Mt Healthy i selfcheck 2025-02-19 450984224696 12658616 L000000282038 420910701516 3906508     6 mtalc 0 mt 26 8
186 186 217320532 2025-01-21 105 Anderson schk05 an Anderson o selfcheck 2025-03-04 450984065565 12499485 L000000260869 420910673033 3878025     6 analc 0 ma 21 8
187 187 217320605 2025-01-21 242 Green Twp schk02 ge Green Township o selfcheck 2025-03-04 450984029608 12463528 L000000257436 420910669667 3874659     6 gealc 0 ge 15 8
188 188 217320825 2025-01-21 120 Blue Ash ba Blue Ash i sierra 2024-12-19 450984151202 12585122 L000000270033 420910685562 3890554     6 baalc 0 dp 11 8
189 189 217321002 2025-01-21 850 Sorter--xdcsort1 51   i selfcheck 2025-01-18 450983705606 12139526 L000000212365 420910607656 3812648     6 avalc 196 av 3 1
190 190 217321069 2025-01-21 322 Madeira schk02 ma Madeira o selfcheck 2025-03-04 450983711302 12145222 L000000214247 420910608060 3813052     6 maalc 0 ma 21 8
191 191 217321187 2025-01-21 410 Norwood nw Norwood i sierra 2024-07-09 450983806899 12240819 L000000225771 420910622771 3827763     6 nwalc 0 1 30 8
192 192 217321285 2025-01-21 242 Green Twp schk02 ge Green Township o selfcheck 2025-03-04 450984021656 12455576 L000000253443 420910654486 3859478     6 gealc 0 ge 15 8
193 193 217321405 2025-01-21 303 Hyde Park schk03 hp Hyde Park o selfcheck 2025-03-04 450984171864 12605784 L000000271643 420910689034 3894026     6 hpalc 0 hp 6 8
194 194 217321450 2025-01-21 362 Monfort Hghts schk02 mo Monfort Heights o selfcheck 2025-03-04 450984065617 12499537 L000000261388 420910673033 3878025     6 moalc 0 mo 25 8
195 195 217321465 2025-01-21 282 Harrison schk02 ha Harrison o selfcheck 2025-03-04 450984179730 12613650 L000000274928 420910695664 3900656     6 haalc 0 ha 24 8
196 196 217321732 2025-01-21 530 Wyoming wy Wyoming i sierra 2025-02-20 450983914525 12348445 L000000240192 420910636778 3841770     6 realc 0 ma 21 8
197 197 217321894 2025-01-21 340 Mariemont mm Mariemont i sierra 2025-02-22 450983690930 12124850 L000000209502 420910609337 3814329     6 analc 0 mm 2 8
198 198 217322434 2025-01-21 390 North Central nr North Central i sierra 2025-02-19 450984227479 12661399 L000000279992 420910701360 3906352     6 nralc 22 nr 1 8
199 199 217322571 2025-01-21 280 Harrison ha Harrison i sierra 2025-01-22 450984049532 12483452 L900000093187 420910671621 3876613     105 haalc 0 ha 18 22
200 200 217322620 2025-01-21 123 Blue Ash schk03 ba Blue Ash o selfcheck 2025-03-04 450984151205 12585125 L000000270066 420910685562 3890554     6 baalc 0 sm 38 8

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [circ_leased_items] (
   [id] INTEGER,
   [transaction_day] TEXT,
   [stat_group_code_num] INTEGER,
   [stat_group_name] TEXT,
   [stat_group_location_code] TEXT,
   [stat_group_branch_name] TEXT,
   [op_code] TEXT,
   [application_name] TEXT,
   [due_date] TEXT,
   [item_record_id] INTEGER,
   [item_record_num] INTEGER,
   [barcode] TEXT,
   [bib_record_id] INTEGER,
   [bib_record_num] INTEGER,
   [volume_record_id] INTEGER,
   [volume_record_num] INTEGER,
   [itype_code_num] INTEGER,
   [item_location_code] TEXT,
   [ptype_code] TEXT,
   [patron_home_library_code] TEXT,
   [patron_agency_code_num] INTEGER,
   [loanrule_code_num] INTEGER
);
CREATE INDEX [idx_circ_leased_items_bib_record_num_op_code]
    ON [circ_leased_items] ([bib_record_num], [op_code]);