item

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

5,703,117 rows sorted by record_last_updated

✎ 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
177 177 1015435 1782831 2012-06-23 2013-01-04 1043627158016 1 2sa 0 0           0 0   Reference Book o 1550 557.59 f63 .1
252 252 1250651 2142457 2012-06-24 2013-01-04 7900110452012 1 2ga 0 0           0 0   Reference Book o 250 331.89 r643
280 280 1017806 1807471 2012-06-23 2013-01-04 1043907246010 1 3aa 0 0           0 0   Reference Book o 1550 708.14778 qc357
284 284 1021290 1844698 2012-06-23 2013-01-04 1044341249016 1 2ra 0 0           0 0 1574411411 Book - 2995 027.4764 qd145 zh
398 398 1016730 1798033 2012-06-23 2013-01-04 1043803351013 1 1fa 0 0           5 0 0060512113 Book - 2495 fiction
433 433 1031328 1984530 2012-06-23 2013-01-04 1045934458013 1 2sa 0 0           0 0 0333145305 Reference Book o 1550 520 fc782 re
437 437 1046015 2138899 2012-06-23 2013-01-04 1048077252011 1 2ga 0 0           0 0 0833034413 Reference Book o 1000 358.044011 qe96
443 443 1035123 2010136 2012-06-23 2013-01-04 1046491752012 1 2ra 0 0           0 0 0815782063 Book - 6000 327.73051 s944
496 496 1036953 2033387 2012-06-23 2013-01-04 1046773156015 1 3la 0 0           4 0 9646796230 Book - 657 pe b
564 564 1039989 1245920 2012-06-23 2013-01-04 0922605049027 1 2ea 0 0           0 0 0226268829 Reference Book o 2250 371.009174 f969
621 621 1045311 2132243 2012-06-23 2013-01-04 1047997252010 1 2ga 0 0           0 0 9241590564 Reference Book o 400 333.9117 k69
729 729 1054704 2237601 2012-06-23 2013-01-04 1049345658013 1 2sa 0 0           2 0 0781725429 Book - 3695 616.0076 qa696
768 768 1057616 2271452 2012-06-23 2013-01-04 1049775546019 1 3aa 0 0           0 0 0226740641 Reference Book o 5500 720.9773 c532
789 789 1030127 1969196 2012-06-23 2013-01-04 1045766251015 1 1fa 0 0           3 0 0803495978 Book - 1995 fiction
826 826 1060298 2295937 2012-06-23 2013-01-04 1100902249017 1 2ea 0 0           0 0   Reference Book o 1550 133.4 m62 e
842 842 1060770 2299304 2012-06-23 2013-01-04 1202626749015 1 2ea 0 0           0 0   Reference Book o 1550 264.03 qh27
867 867 1067551 2329441 2012-06-23 2013-01-04 2171302353013 1 3ha 0 0           0 0 0834300516 Reference Book o 499 031 f982 f
876 876 1061855 2307182 2012-06-23 2013-01-04 1501811649033 1 2ea 0 0           1 0   Book - 1550 150 y47
900 900 1063172 2316476 2012-06-23 2013-01-04 1900464049014 1 2ea 0 0           0 0   Book - 1550 197 z83
914 914 1063683 2320157 2012-06-23 2013-01-04 2001280049012 1 2ea 0 0           0 0   Reference Book o 1550 025 b74
988 988 1076142 2379075 2012-06-23 2013-01-04 3100619652014 1 2ga 0 0           0 0   Reference Book o 1550 341.6 d25
990 990 1066027 2326251 2012-06-23 2013-01-04 2101161952019 1 2ga 0 0           0 0   Book - 459 331.8 w36 .1
1084 1084 1070415 2345079 2012-06-23 2013-01-04 2402482656028 1 3la 0 0           0 0   Book - 75 822 b275 m
1138 1138 1088923 2002061 2012-06-23 2013-01-04 4200464952037 1 2ga 0 0           0 0   Book - 375 327.47 d14
1239 1239 1079766 1013544 2012-06-23 2013-01-04 0991743352015 1 2ga 0 0           0 0   Reference Book o 1170 338.91094 qe89
1315 1315 1100005 2067897 2012-06-23 2013-01-04 5100101152018 1 2ga 0 0           0 0   Reference Book o 300 332.61 l833
1354 1354 1087076 2445928 2012-06-23 2013-01-04 4002782052015 1 2ga 0 0           0 0   Book - 125 323.354 s21
1421 1421 1091641 2014946 2012-06-23 2013-01-04 4400871949069 1 2ea 0 0           0 0   Book - 125 268.432 s664 p
1424 1424 1107014 2119300 2012-06-23 2013-01-04 5401217946040 1 3aa 0 0           0 0   Reference Book o 300 724.9 g87 s
1434 1434 1107351 2121791 2012-06-23 2013-01-04 5500031652013 1 2ga 0 0           0 0   Book - 850 338.1 r962
1510 1510 1111454 2151774 2012-06-23 2013-01-04 5601126852078 1 2ga 0 0           0 0   Book - 450 325.26 w292
1540 1540 1113135 2160989 2012-06-23 2013-01-04 5700647852011 1 2ga 0 0           0 0   Reference Book o 125 331.811 qc874
1627 1627 1118140 2192140 2012-06-23 2013-01-04 5900043456017 1 3la 0 0           2 0   Book - 750 821.08 h838
1721 1721 1113537 2163786 2012-06-23 2013-01-04 5700839652013 1 2ga 0 0           0 0   Book - 1550 331.252 n277
1852 1852 1088750 2001672 2012-06-23 2013-01-04 4105203649036 1 2ea 0 0           1 0   Book - 350 394.2663 h765
1860 1860 1132031 2279362 2012-06-23 2013-01-04 6201510156019 1 3la 0 0           0 0   Book - 495 823 a933 zb
1910 1910 1134383 2294012 2012-06-23 2013-01-04 6300406752012 1 2ga 0 0           0 0   Book - 595 338.973 s364
1932 1932 1072865 2358782 2012-06-23 2013-01-04 2702636849043 1 2ea 0 0           0 0   Book - 90 170 d17
2045 2045 1140531 2331175 2012-06-23 2013-01-04 6401222352019 1 2ga 0 0           0 0   Reference Book o 1000 330.951 l783
2054 2054 1135903 2302805 2012-06-23 2013-01-04 6301116052016 1 2ga 0 0           0 0   Book - 600 329.944 m619
2097 2097 1076128 2378992 2012-06-23 2013-01-04 3100594552015 1 2ga 0 0           3 0   Book - 1060 322 b25
2099 2099 1143202 2347205 2012-06-23 2013-01-04 6402117352015 1 2ga 0 0           3 0   Book - 1550 658 64.35
2114 2114 1138323 2317383 2012-06-23 2013-01-04 6302017849013 1 2ea 0 0           1 0   Book - 595 259 s921
2159 2159 1140239 2329372 2012-06-23 2013-01-04 6401138849033 1 2ea 0 0           0 0   Reference Book o 495 133.07 p915
2211 2211 1147677 2374365 2012-06-23 2013-01-04 6501831452017 1 2ga 0 0           0 0   Book - 6000 338.9018 h628
2248 2248 1150672 2390955 2012-06-23 2013-01-04 6506411552011 1 2ga 0 0           0 0   Book - 200 338.47684 c287
2269 2269 1143918 2351431 2012-06-23 2013-01-04 6402395246012 1 3aa 0 0           0 0   Book - 495 791.4309 s331
2291 2291 1144454 1037217 2012-06-23 2013-01-04 0923666452019 1 2ga 0 0           2 0   Reference Book o 400 331.40973 qj62
2307 2307 1082026 2416723 2012-06-23 2013-01-04 3602491152013 1 2ga 0 0           1 0   Book - 250 330.9744 c78 e
2331 2331 1146043 2364829 2012-06-23 2013-01-04 6501263052012 1 2ga 0 0           1 0   Book - 250 328.73 c593 co
2397 2397 1084718 2432691 2012-06-23 2013-01-04 3802893252011 1 2ga 0 0           2 0   Book - 200 323.65 w95 h
2402 2402 1160517 2007826 2012-06-23 2013-01-04 6701556952015 1 2ga 0 0           0 0   Book - 750 325.342 m152
2415 2415 1161748 2016169 2012-06-23 2013-01-04 6702091651013 1 1fa 0 0           2 0   Book - 395 fiction
2421 2421 1155131 2417190 2012-06-23 2013-01-04 6602140752012 1 2ga 0 0           0 0   Reference Book o 1295 333.91003 v294
2434 2434 1085407 2436969 2012-06-23 2013-01-04 3901529249019 1 2ea 0 0           0 0   Book - 100 233.5 t45 s
2534 2534 1090003 2006126 2012-06-23 2013-01-04 4300263952012 1 2ga 0 0           0 0   Reference Book o 1550 338.52 p92
2703 2703 1174127 2101127 2012-06-23 2013-01-04 6901973749024 1 2ea 0 0           1 0   Book - 1550 200.1 s826
2723 2723 1210670 2486876 2012-06-24 2013-01-04 7501489852012 1 2ga 0 0           3 0 0472735209 Book - 1195 323.445 p849
2778 2778 1191043 1053529 2012-06-23 2013-01-04 0924118656017 1 3la 0 0           0 0 0198158114 Reference Book o 5500 843.1 l247 zk
2794 2794 1191814 1053804 2012-06-23 2013-01-04 0924127351121 1 1fa 0 0           3 0   Book - 1000 fiction
2968 2968 1190769 1053442 2012-06-23 2013-01-04 0924123562010 1 2na 0 0           0 0   Reference Book o 6000 071.446 qc555
2973 2973 1100775 2073312 2012-06-23 2013-01-04 5101018349010 1 2ea 0 0           0 0   Book - 275 151.2 v542
2991 2991 1191486 1053687 2012-06-23 2013-01-04 0924123651011 1 1fa 0 0           0 0   Book - 1311 fiction
3051 3051 1101686 2079944 2012-06-23 2013-01-04 5200169252013 1 2ga 0 0           0 0   Book - 500 658.83 58.4
3058 3058 1102056 2082633 2012-06-23 2013-01-04 5200589452011 1 2ga 0 0           0 0   Book - 395 320.15 z82
3080 3080 1205163 2482853 2012-06-24 2013-01-04 7407536652019 1 2ga 0 0           0 0 0870131842 Book - 1000 658.322 74.1
3145 3145 1199206 2478754 2012-06-24 2013-01-04 7400009849022 1 2ea 0 0           2 0 0396069495 Book - 595 241.52 s531
3201 3201 1211226 2487325 2012-06-24 2013-01-04 7501920552015 1 2ga 0 0           5 0 0393087301 Book - 1595 301.364 d752
3221 3221 1109537 2137874 2012-06-23 2013-01-04 5502056649015 1 2ea 0 0           0 0   Book - 480 266 k86
3251 3251 1216996 2491374 2012-06-24 2013-01-04 7530838852019 1 2ga 0 0           1 0 0140217924 Book - 350 338.98 g464
3260 3260 1208606 2485373 2012-06-24 2013-01-04 7500193856012 1 3la 0 0           0 0 025335580X Reference Book o 1750 895.11008 s958 e
3277 3277 1209712 2486170 2012-06-24 2013-01-04 7500900652019 1 2ga 0 0           0 0   Book - 1550 342.7309 qf712
3281 3281 1110486 1047503 2012-06-23 2013-01-04 0903373846018 1 3aa 0 0           0 0 0872730859 Reference Book o 1550 769.952 b872
3284 3284 1110467 2144706 2012-06-23 2013-01-04 5600702949027 1 2ea 0 0           0 0   Reference Book o 500 248.4 g626
3341 3341 1216745 2491176 2012-06-24 2013-01-04 7517808156018 1 3la 0 0           0 0 0877491569 Reference Book o 695 823.912 d754 zhar
3353 3353 1218701 2495091 2012-06-24 2013-01-04 7600698349016 1 2ea 0 0           3 0 047153899X Book - 750 155.2 ql754
3397 3397 1113401 2162952 2012-06-23 2013-01-04 5700769652017 1 2ga 0 0           0 0   Reference Book o 900 333.5 l622
3436 3436 1115396 2175108 2012-06-23 2013-01-04 5800327249015 1 2ea 0 0           0 0   Book - 600 150 w49 ee
3441 3441 1226466 2529700 2012-06-24 2013-01-04 7615075852010 1 2ga 0 0           0 0   Book - 1200 658.1512 q76 .1
3518 3518 1229825 2003759 2012-06-24 2013-01-04 7700903652012 1 2ga 0 0           0 0 0670435848 Book - 1495 333.7 qa474
3576 3576 1231035 2009607 2012-06-24 2013-01-04 7701624352015 1 2ga 0 0           7 0 0891587470 Book - 4125 320.981 f648
3630 3630 1244349 2102305 2012-06-24 2013-01-04 7802686151012 1 1fa 0 0           0 0 0670287202 Book - 995 fiction
3642 3642 1244333 1072808 2012-06-24 2013-01-04 0924631858017 1 2sa 0 0           1 0   Book - 100 540.7 29
3827 3827 1245869 1052116 2012-06-24 2013-01-04 0999940052015 1 2ga 0 0           0 0   Reference Book o 1000 368 n275
3828 3828 1245826 2112935 2012-06-24 2013-01-04 7805741552025 1 2ga 0 0           2 0 0896960110 Book - 1550 332.024 h259
3873 3873 1260833 2206438 2012-06-24 2013-01-04 7913487052018 1 2ga 0 0           1 0 0394315553 Book - 295 320.5 r491
3892 3892 1248863 2130649 2012-06-24 2013-01-04 7812921852019 1 2ga 0 0           0 0   Book - 275 330.01 c663
3951 3951 1134053 2291966 2012-06-23 2013-01-04 6300006660029 1 1fa 0 0           12 0   LP Record - 795 s 06195
3975 3975 1134983 2297462 2012-06-23 2013-01-04 6300832249013 1 2ea 0 0           0 0   Reference Book o 860 232.9 k83
4034 4034 1272060 2278208 2012-06-24 2013-01-04 8100123249013 1 2ea 0 0           3 0 0912700106 Book - 2250 025.302 c791
4035 4035 1255263 1076528 2012-06-24 2013-01-04 0924726153019 1 3ha 0 0           0 0 0805767606 Reference Book o 1095 942.082 qc563 zw
4096 4096 1277251 2309520 2012-06-24 2013-01-04 8101908752015 1 2ga 0 0           0 0 0844734802 Book - 225 327.569401 c766
4100 4100 1259130 2195758 2012-06-24 2013-01-04 7907952146016 1 3aa 0 0           0 0   Reference Book o 1495 739.7 qr661
4187 4187 1263417 2223055 2012-06-24 2013-01-04 8000852346016 1 3aa 0 0           0 0 0824094611 Reference Book o 8000 780.96 m568
4260 4260 1265726 2236552 2012-06-24 2013-01-04 8001680556016 1 3la 0 0           0 0 0805773223 Reference Book o 995 813.52 t672 zb
4332 4332 1270329 2266216 2012-06-24 2013-01-04 8006678749010 1 2ea 0 0           0 0 0873030621 Book - 450 266.97 g597
4357 4357 1272571 2281142 2012-06-24 2013-01-04 8100281256016 1 3la 0 0           29 0 0804421870 Book - 1095 813.52 w464 ze
4360 4360 1157352 2428096 2012-06-23 2013-01-04 6603059049010 1 2ea 0 0           3 0   Book - 595 254.02 b727
4452 4452 1160238 2006404 2012-06-23 2013-01-04 6701484852022 1 2ga 0 0           0 0   Book - 495 320.94 c596
4473 4473 1279331 1085505 2012-06-24 2013-01-04 0924954246014 1 3aa 0 0           0 0   Reference Book o 150 787.9 qh894

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"
);
CREATE INDEX "idx_item_item_format" ON "item" (
    "item_format"
);