home / collection-2021-01-04

item

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

5,515,381 rows sorted by agency_code_num

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid item_record_num bib_record_num creation_date record_last_updated barcode agency_code_num ▼ location_code checkout_statistic_group_code_num checkin_statistics_group_code_num checkout_date due_date patron_branch_code last_checkout_date last_checkin_date checkout_total renewal_total isbn item_format item_status_code price_cents item_callnumber
3236561 3236561 5014279 2583263 2012-07-02 2020-06-12 A000019751916 0 1cjnf 800 1       2015-03-03 2020-06-12 15 11 031610826X Juvenile Book e 499 796.357092 r662 zst
976260 976260 10428644 3452538 2019-06-20 2020-02-26 A000065125546 0 1fa 0 0           0 0 9780062859358 Book - 1699 fiction
122241 122241 3775449 1813614 2012-06-30 2021-01-01 1034831448020 0 1lj 201 200       2019-02-01 2019-02-05 22 6 0374324239 Juvenile Book - 1500 easy
402199 402199 5747095 2696889 2012-07-03 2020-01-07 1685213-1001 0 1lj 490 490       2019-11-16 2019-12-17 28 10 9780525476474 Juvenile Book - 1699 easy
554882 554882 3942348 2517087 2012-06-30 2021-01-01 1588670-1001 0 1lj 142 140       2020-10-13 2020-11-13 36 16 0152164456 Juvenile Book - 952 easy
568475 568475 4829874 2710770 2012-07-01 2021-01-01 1628325-1001 0 1lj 801 100       2020-03-12 2020-07-17 14 9 1561453315 Juvenile Book - 864 594 s584 2005
731853 731853 4344875 1592603 2012-06-30 2015-10-26 1003765548014 0 1lj 152 420       2014-09-27 2014-11-11 34 11 1566740681 Juvenile Book - 1295 easy
984362 984362 3786341 1817731 2012-06-30 2015-10-26 1034885648020 0 1lj 800 490       2014-06-18 2014-07-16 12 4 0374383006 Juvenile Book - 1600 easy
1423283 1423283 4585788 2631729 2012-06-30 2020-09-11 1612133-1001 0 1lj 1 140       2016-10-26 2016-12-09 41 5 1582349681 Juvenile Book - 864 easy
1608310 1608310 5857763 2573705 2012-07-03 2021-01-01 1659344-1001 0 1lj 105 100       2020-03-05 2020-03-06 25 8 0374370311 Juvenile Book - 867 easy
2008329 2008329 7813976 2976554 2014-07-23 2020-01-07 A000041970450 0 1lj 801 480       2019-04-27 2019-05-30 6 3 9781561457571 Juvenile Book - 1695 599 s584 2014
2821643 2821643 6562960 2553688 2012-07-03 2015-10-26 A000019919687 0 1lj 800 480       2014-02-22 2014-03-12 5 1 9781596434387 Juvenile Book - 1599 easy
2881704 2881704 3967850 2000268 2012-06-30 2019-01-01 1046229648011 0 1lj 151 120       2018-07-25 2018-08-03 44 4 1582348502 Juvenile Book - 1595 easy
3309365 3309365 3756921 1903927 2012-06-30 2021-01-01 1045013248012 0 1lj 801 300       2020-07-21 2020-09-25 57 6 0375806091 Juvenile Book - 1995 easy
3670334 3670334 5312562 2784869 2012-07-02 2021-01-01 1704454-1001 0 1lj 340 340       2020-07-11 2020-08-11 17 4 9781592700677 Juvenile Book - 1695 easy
3670905 3670905 5366566 2507364 2012-07-02 2021-01-01 1646842-1001 0 1lj 801 440       2019-05-04 2019-06-07 19 13 1561453587 Juvenile Book - 864 599.2 s584 2006
3777515 3777515 7461340 2915324 2013-12-02 2018-01-01 A000038875357 0 1lj 440 440       2017-08-05 2017-08-16 3 1 9781452109145 Juvenile Book - 1699 easy
4146518 4146518 1815532 2629056 2012-06-27 2020-01-07 A000024342602 0 1lj 1 1       2019-11-10 2019-12-10 9 10 9780761375647 Juvenile Book - 1795 easy
4177018 4177018 4235792 2091223 2012-06-30 2018-01-01 1047447248022 0 1lj 100 100       2017-05-11 2017-05-11 12 1 078680453X Juvenile Book - 1599 easy
4698743 4698743 4653151 2226392 2012-06-30 2021-01-01 1049211448010 0 1lj 801 1 2020-08-24 2020-12-31 ha 2018-09-11 2018-09-12 28 17 1561453013 Juvenile Book - 1595 595.3 s584 2004
4774085 4774085 3649695 1857432 2012-06-30 2021-01-01 1044479748011 0 1lj 801 310       2020-10-16 2020-11-05 29 12 1561450383 Juvenile Book - 1595 595.4 s584 2003
5304295 5304295 4808034 2697887 2012-07-01 2018-01-01 1625832-1001 0 1lj 522 520       2016-09-13 2016-09-30 23 8 1402728719 Juvenile Book - 810 easy
5478150 5478150 7311957 2877660 2013-09-13 2021-01-01 A000036275204 0 1lj 391 390       2020-11-30 2020-12-15 7 5 9780374319038 Juvenile Book - 1799 easy
5329195 5329195 10532738 3474618 2019-09-16 2021-01-01 A000063214219 0 1paha 801 10       2019-12-13 2020-01-27 4 2 9780800736538 Book - 2499 fiction
29444 29444 10439066 3446367 2019-06-27 2021-01-01 L000000003012 0 1palc 1 1       2020-03-03 2020-10-13 5 0 9781538729748 Leased Book w 2000 359.0092 m174 zm 2019
29455 29455 10439044 3415903 2019-06-27 2021-01-01 L000000002790 0 1palc 41 1       2020-07-01 2020-07-10 5 0 9781538761410 Leased Book w 2000 fiction
29467 29467 10439058 3422386 2019-06-27 2021-01-01 L000000002931 0 1palc 44 1       2019-11-04 2019-11-12 6 0 9781501111822 Leased Book w 2000 fiction
33301 33301 10439015 3422382 2019-06-27 2021-01-01 L000000002501 0 1palc 1 140 2020-02-12 2020-07-11 1 2019-07-11 2019-07-24 2 0 9780525535942 Leased Book n 2000 fiction
77695 77695 10961979 3538241 2020-11-13 2021-01-01 L000000031757 0 1palc 44 1 2020-12-18 2021-01-29 1 2020-11-19 2020-11-30 2 0 9781538751947 Leased Book - 2000 fiction
77785 77785 10962473 3537867 2020-11-13 2020-11-16 L000000024356 0 1palc 0 0           0 0 9780063046108 Leased Book - 2000 941.085092 h323 zs 2020
78320 78320 10592785 3458342 2019-10-29 2021-01-01 L000000005744 0 1palc 1 1       2020-02-22 2020-09-21 3 1 9781451642292 Leased Book w 2000 306.7082 t121 2019
80020 80020 10980183 3537553 2020-12-01 2021-01-01 L900000011874 0 1palc 1 1 2020-12-23 2020-12-31 cv 2020-12-04 2020-12-23 2 0   Leased DVD - 2000 dvd horror b658 2020
80108 80108 10980689 3537558 2020-12-01 2021-01-01 L900000014662 0 1palc 1 1 2020-12-23 2020-12-31 pr 2020-12-12 2020-12-23 3 0   Leased DVD - 2000 dvd horror i624 2020
87073 87073 11010786 3543109 2020-12-29 2020-12-31 L000000051201 0 1palc 0 0           0 0 9780735224650 Leased Book - 2000 fiction
115560 115560 10438915 3224900 2019-06-27 2021-01-01 L000000001503 0 1palc 1 1 2020-01-28 2020-07-06 1 2019-12-27 2020-01-27 8 1 9780399588174 Leased Book n 2000 791.45028 n739 zn 2016
115565 115565 10439002 3415902 2019-06-27 2021-01-01 L000000002378 0 1palc 1 1       2020-02-23 2020-06-17 4 0 9780525536581 Leased Book w 2000 fiction
115579 115579 10439046 3415903 2019-06-27 2021-01-01 L000000002816 0 1palc 42 310       2020-03-13 2020-07-20 6 0 9781538761410 Leased Book w 2000 fiction
120816 120816 10450490 3446363 2019-07-09 2021-01-01 L000000003806 0 1palc 1 1       2020-06-22 2020-07-27 5 0 9781101947869 Leased Book w 2000 364.15232 m465 zc 2019
150974 150974 10467034 3426321 2019-07-22 2021-01-01 L000000004424 0 1palc 1 44       2020-02-26 2020-09-14 5 1 9781250178954 Leased Book w 2000 155.33382 k48 zk 2019
162627 162627 10577731 3451325 2019-10-18 2021-01-01 L000000004606 0 1palc 11 150       2020-02-29 2020-07-18 5 0 9780451494344 Leased Book w 2000 fiction
166257 166257 10980185 3537553 2020-12-01 2021-01-03 L900000011890 0 1palc 41 1 2020-12-21 2020-12-29 1 2020-12-02 2020-12-21 2 0   Leased DVD - 2000 dvd horror b658 2020
166285 166285 10980273 3520724 2020-12-01 2021-01-01 L900000013821 0 1palc 41 44 2020-12-29 2021-01-06 1 2020-12-04 2020-12-23 2 0   Leased DVD - 2000 dvd children d664 2020
166294 166294 10980538 3537554 2020-12-01 2021-01-03 L900000011353 0 1palc 44 0 2020-12-11 2020-12-19 1     1 0   Leased DVD - 2000 dvd horror b813 2020
166384 166384 10980994 3519857 2020-12-01 2021-01-01 L900000000737 0 1palc 41 0 2020-12-23 2020-12-31 1     1 0   Leased DVD - 2000 dvd drama l778991 2020
201957 201957 10438969 3449710 2019-06-27 2021-01-01 L000000002048 0 1palc 41 0 2019-07-21 2019-09-01 1     1 0 9781635573404 Leased Book n 2000 fiction
201989 201989 10439032 3425844 2019-06-27 2021-01-01 L000000002675 0 1palc 41 150       2020-08-05 2020-12-22 10 0 9781984822178 Leased Book - 2000 fiction
205666 205666 10438977 3381067 2019-06-27 2021-01-01 L000000002121 0 1palc 42 100       2020-02-14 2020-07-24 5 0 9781501161155 Leased Book w 2000 818.602 b279 2018
232864 232864 10813014 3511078 2020-06-22 2020-12-22 L000000006064 0 1palc 0 0           0 0 9780802148537 Leased Book w 2000 fiction
237757 237757 10467027 3452103 2019-07-22 2021-01-01 L000000004358 0 1palc 44 330       2020-02-24 2020-07-31 5 0 9781524759780 Leased Book w 2000 fiction
249445 249445 10577777 3461506 2019-10-18 2021-01-01 L000000005066 0 1palc 41 1 2020-07-21 2020-08-11 ep 2020-02-23 2020-06-15 6 0 9781501188770 Leased Book n 2000 fiction
251190 251190 10592732 3469725 2019-10-29 2021-01-01 L000000005223 0 1palc 44 210       2020-09-21 2020-09-28 6 0 9781250265708 Leased Book w 2000 fiction
253115 253115 10980688 3537558 2020-12-01 2020-12-18 L900000014654 0 1palc 0 0           0 0   Leased DVD - 2000 dvd horror i624 2020
253125 253125 10980687 3537558 2020-12-01 2021-01-03 L900000014647 0 1palc 43 1 2020-12-28 2021-01-05 1 2020-12-07 2020-12-17 2 0   Leased DVD - 2000 dvd horror i624 2020
253156 253156 10980929 3537552 2020-12-01 2021-01-03 L900000015842 0 1palc 44 44 2020-12-28 2021-01-05 pl 2020-12-28 2020-12-28 4 0   Leased DVD - 2000 dvd action b6181 2020
255625 255625 11006764 3554075 2020-12-23 2020-12-29 L000000049627 0 1palc 0 0           0 0 9780062955456 Leased Book - 2000 fiction
288379 288379 10438947 3412414 2019-06-27 2021-01-01 L000000001826 0 1palc 1 180       2020-03-01 2020-07-14 6 0 9781400209606 Leased Book w 2000 158.1082 h743 2019
288386 288386 10439062 3446366 2019-06-27 2021-01-01 L000000002972 0 1palc 44 44       2020-08-17 2020-08-24 5 0 9780062863157 Leased Book w 2000 355.699092 c851 2019
288397 288397 10439038 3410171 2019-06-27 2021-01-01 L000000002733 0 1palc 41 1       2019-07-13 2019-07-13 1 0 9781496716149 Leased Book - 2000 fiction
335480 335480 10577723 3466284 2019-10-18 2021-01-01 L000000004523 0 1palc 44 44       2020-02-21 2020-02-28 4 0 9780062678287 Leased Book w 2000 fiction
336798 336798 10962389 3538227 2020-11-13 2020-11-16 L000000023515 0 1palc 0 0           0 0 9781501193699 Leased Book - 2000 fiction
336799 336799 10962390 3538227 2020-11-13 2021-01-01 L000000023523 0 1palc 1 0 2020-12-10 2021-01-21 1     1 0 9781501193699 Leased Book - 2000 fiction
337179 337179 10963408 3536286 2020-11-13 2021-01-01 L000000034538 0 1palc 44 0 2020-12-18 2021-01-29 an     1 0 9780525536291 Leased Book - 2000 fiction
337424 337424 10592755 3470040 2019-10-29 2021-01-01 L000000005447 0 1palc 41 1 2020-01-28 2020-07-06 1 2019-12-16 2020-01-28 3 0 9780399590597 Leased Book n 2000 fiction
339117 339117 10980534 3537554 2020-12-01 2021-01-01 L900000011312 0 1palc 44 1 2020-12-23 2020-12-31 1 2020-12-10 2020-12-23 2 0   Leased DVD - 2000 dvd horror b813 2020
374632 374632 10438916 3336822 2019-06-27 2021-01-01 L000000001511 0 1palc 1 170       2020-06-17 2020-11-21 7 0 9780316556347 Leased Book w 2000 fiction
374638 374638 10438973 3443848 2019-06-27 2021-01-01 L000000002089 0 1palc 41 180       2020-02-19 2020-02-29 4 0 9781250112095 Leased Book w 2000 791.4572 v671 zs 2019
374656 374656 10439040 3410171 2019-06-27 2021-01-01 L000000002758 0 1palc 1 320       2020-03-13 2020-07-13 6 0 9781496716149 Leased Book w 2000 fiction
375859 375859 10442047 3427242 2019-06-28 2021-01-01 L000000003657 0 1palc 510 510       2020-02-19 2020-08-29 8 0 9780316419826 Leased Book w 2000 fiction
410003 410003 10467019 3450648 2019-07-22 2021-01-01 L000000004275 0 1palc 44 440       2020-12-10 2020-12-18 6 0 9780735214484 Leased Book - 2000 153.9 e64 2019
421739 421739 10577761 3465521 2019-10-18 2021-01-01 L000000004903 0 1palc 1 158       2020-10-06 2020-12-15 6 0 9780525509288 Leased Book - 2000 305.800973 k33 h 2019
425343 425343 10980533 3537554 2020-12-01 2021-01-01 L900000011304 0 1palc 44 1       2020-12-03 2020-12-23 1 0   Leased DVD - 2000 dvd horror b813 2020
425351 425351 10980630 3520722 2020-12-01 2021-01-03 L900000013227 0 1palc 1 0 2020-12-21 2020-12-29 mt     1 0   Leased DVD - 2000 dvd musical c3671 2020
425396 425396 10980926 3537552 2020-12-01 2021-01-01 L900000015818 0 1palc 1 1 2020-12-14 2020-12-22 ns 2020-12-03 2020-12-14 2 0   Leased DVD - 2000 dvd action b6181 2020
427820 427820 11006761 3554075 2020-12-23 2020-12-29 L000000049593 0 1palc 0 0           0 0 9780062955456 Leased Book - 2000 fiction
460681 460681 10438946 3412414 2019-06-27 2021-01-01 L000000001818 0 1palc 42 440       2020-02-06 2020-07-14 8 0 9781400209606 Leased Book w 2000 158.1082 h743 2019
464398 464398 10438894 3427682 2019-06-27 2021-01-01 L000000001297 0 1palc 42 1       2019-07-11 2019-07-29 2 0 9780062853370 Leased Book - 2000 fiction
496050 496050 10467028 3452070 2019-07-22 2021-01-01 L000000004366 0 1palc 1 210       2019-11-12 2019-12-07 3 0 9780593132951 Leased Book w 2000 782.420973 m479 2019
508789 508789 10962099 3538238 2020-11-13 2021-01-01 L000000030155 0 1palc 1 1 2020-12-14 2021-01-25 1 2020-12-01 2020-12-08 2 0 9781250207234 Leased Book - 2000 fiction
509320 509320 10592726 3470856 2019-10-29 2021-01-01 L000000005165 0 1palc 1 100       2020-10-13 2020-10-31 4 0 9780062271662 Leased Book w 2000 fiction
509480 509480 10592771 3472759 2019-10-29 2021-01-01 L000000005603 0 1palc 41 0 2020-01-06 2020-07-06 1     1 0 9780812996838 Leased Book n 2000 956.704434 m444 zm 2019
511111 511111 10980274 3520724 2020-12-01 2021-01-01 L900000013839 0 1palc 44 1       2020-12-03 2020-12-28 1 0   Leased DVD - 2000 dvd children d664 2020
511113 511113 10980690 3537558 2020-12-01 2021-01-01 L900000014670 0 1palc 1 180 2020-12-29 2021-01-06 ww 2020-12-03 2020-12-14 2 0   Leased DVD - 2000 dvd horror i624 2020
511185 511185 10980683 3537558 2020-12-01 2021-01-01 L900000014605 0 1palc 1 1 2020-12-30 2021-01-07 1 2020-12-03 2020-12-19 2 0   Leased DVD - 2000 dvd horror i624 2020
546243 546243 10439033 3425844 2019-06-27 2021-01-01 L000000002683 0 1palc 42 300       2020-02-23 2020-06-22 9 0 9781984822178 Leased Book w 2000 fiction
546254 546254 10438948 3412414 2019-06-27 2021-01-01 L000000001834 0 1palc 41 11       2019-11-11 2020-02-27 4 0 9781400209606 Leased Book w 2000 158.1082 h743 2019
546264 546264 10438995 3425143 2019-06-27 2021-01-01 L000000002303 0 1palc 1 1 2020-08-04 2020-09-15 1 2020-07-01 2020-07-10 9 1 9781328662057 Leased Book n 2000 616.891409 g686 zg 2019
546267 546267 10439037 3410171 2019-06-27 2021-01-01 L000000002725 0 1palc 41 420       2019-10-10 2020-01-08 4 0 9781496716149 Leased Book w 2000 fiction
546276 546276 10439057 3422386 2019-06-27 2021-01-01 L000000002923 0 1palc 1 380       2019-09-28 2019-11-25 3 0 9781501111822 Leased Book w 2000 fiction
576603 576603 10813025 3501666 2020-06-22 2021-01-01 L000000005975 0 1palc 44 530       2020-11-06 2020-12-23 3 0 9781250236609 Leased Book - 2000 fiction
593379 593379 10577781 3461506 2019-10-18 2021-01-01 L000000005108 0 1palc 1 1 2020-02-07 2020-07-14 cv 2020-01-13 2020-01-28 4 0 9781501188770 Leased Book n 2000 fiction
594635 594635 10962684 3538219 2020-11-13 2021-01-01 L000000020107 0 1palc 41 0 2020-12-07 2021-01-19 1w     1 0 9781250145239 Leased Book - 2000 fiction
595280 595280 10592736 3470961 2019-10-29 2021-01-01 L000000005264 0 1palc 42 410       2020-02-03 2020-03-06 4 0 1501190628 Leased Book w 2000 fiction
595867 595867 10994364 3557566 2020-12-14 2021-01-03 L900000016790 0 1palc 43 0 2020-12-28 2021-01-05 1     1 0   Leased DVD - 2000 dvd suspense u57 2020
597011 597011 10980139 3523830 2020-12-01 2021-01-01 L900000011130 0 1palc 41 1       2020-12-09 2020-12-22 1 0 9786318096522 Leased DVD - 2000 dvd horror t955 2020
597086 597086 10980933 3537552 2020-12-01 2021-01-01 L900000015883 0 1palc 41 1 2020-12-23 2020-12-31 1 2020-12-03 2020-12-23 2 0   Leased DVD - 2000 dvd action b6181 2020
597097 597097 10980924 3537552 2020-12-01 2021-01-03 L900000015792 0 1palc 41 1 2020-12-28 2021-01-05 wh 2020-12-03 2020-12-14 2 0   Leased DVD - 2000 dvd action b6181 2020
599192 599192 11000728 3554960 2020-12-17 2021-01-01 L000000041772 0 1palc 44 0 2020-12-28 2021-02-08 ww     1 0 9780316628242 Leased Book - 2000 814.54 s447 be 2020
604121 604121 11010783 3543109 2020-12-29 2020-12-31 L000000051177 0 1palc 0 0           0 0 9780735224650 Leased Book - 2000 fiction
632599 632599 10438979 3381067 2019-06-27 2021-01-01 L000000002147 0 1palc 41 1       2020-01-29 2020-07-02 4 0 9781501161155 Leased Book w 2000 818.602 b279 2018
633930 633930 10442032 3422389 2019-06-28 2021-01-01 L000000003509 0 1palc 1 450       2019-11-03 2019-11-12 2 0 9780399585364 Leased Book w 2000 fiction

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE item (
	item_record_num BIGINT, 
	bib_record_num BIGINT, 
	creation_date TEXT, 
	record_last_updated TEXT, 
	barcode TEXT, 
	agency_code_num BIGINT, 
	location_code TEXT, 
	checkout_statistic_group_code_num BIGINT, 
	checkin_statistics_group_code_num BIGINT, 
	checkout_date TEXT, 
	due_date TEXT, 
	patron_branch_code TEXT, 
	last_checkout_date TEXT, 
	last_checkin_date TEXT, 
	checkout_total BIGINT, 
	renewal_total BIGINT, 
	isbn TEXT, 
	item_format TEXT, 
	item_status_code TEXT, 
	price_cents BIGINT, 
	item_callnumber TEXT
);
CREATE INDEX "idx_item_item_format_item_status_location_code_item_callnumber" ON "item" (
    "location_code",
    "item_format",
    "item_status_code",
    "item_callnumber"
);
CREATE INDEX "idx_item_bib_record_num" ON "item" (
    "bib_record_num"
);
CREATE INDEX "idx_item_item_record_num" ON "item" (
    "item_record_num"
);
CREATE INDEX "idx_item_agency_code_num_location_code" ON "item" (
    "agency_code_num",
    "location_code"
);
CREATE INDEX "idx_item_barcode" ON "item" (
    "barcode"
);
Powered by Datasette · Query took 580.218ms · Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/