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

5,708,270 rows

View and edit SQL

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
1 2892664 1765401 2012-06-29 2013-01-06 1016667653013 1 3ha 0 0           0 0   Book - 375 917.3 b468
2 2892912 1625197 2012-06-29 2018-12-04 1000401957013 1 3ca 0 0           0 0   Rare Book o 1550 336.77178 qd751
3 2892753 1765549 2012-06-29 2013-01-06 1016669453016 1 3ha 0 0           0 0   Reference Book o 1550 916.2 fe323
4 2892768 1367927 2012-06-29 2013-01-06 0966322856016 1 3ra 0 0           4 0 0374123020 Book - 2495 834.914 w853 xs
5 2892769 1623608 2012-06-29 2013-01-06 1026746752017 1 2ga 0 0           0 0   Reference Book o 1000 328.730761 qc749
6 2893033 1625397 2012-06-29 2013-01-06 1000404251018 1 1fa 0 0           15 0 1877946915 Book - 2200 fiction
7 2893289 1368342 2012-06-29 2013-01-06 0966337649018 1 2ea 0 0           0 0   Book - 1000 301.44096 s678
8 7057013 2831979 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
9 2588870 1818085 2012-06-29 2019-01-01 1028394951024 1 1fa 1 10         2018-08-06 12 2 0312872313 Book - 2495 fiction
10 2893392 1624351 2012-06-29 2013-01-06 0982866353013 1 2rar 0 0           0 0 0684192799 Reference Book o 9975 939.4 qc582
11 2893584 1626290 2012-06-29 2013-01-06 1000413553016 1 3ha 0 0           0 0   Book - 1550 901 w11 .1
12 2893661 1368547 2012-06-29 2019-08-19 0966344746013 1 3aa 0 0           0 0 051758008X Reference Book o 995 745.1 k88 g, 1992
13 2893958 1918395 2012-06-29 2019-09-03 1036073158019 1 2sa 0 0           0 0   Reference Book o 400 607.34 ql888 zw, 1973
14 2894088 1767565 2012-06-29 2018-05-22 1016693857018 1 3ca 0 0           0 0   Rare Book o 1550 269.2092 h362 zh
15 2893885 1368733 2012-06-29 2019-07-09 0966349153017 1 3ea 0 0           0 0   Reference Book o 1550 977.17 qp972 , 1992
16 1032647 1998633 2012-06-23 2019-02-26 1046139056016 1 3ra 801 1       2018-07-21 2019-02-26 2 8 0791450899 Book - 1995 809.93355 e14
17 2893997 1767470 2012-06-29 2018-12-04 1016692657013 1 3ca 0 0           0 0   Rare Book o 1550 741.69 qa345
18 8390185 3074870 2015-08-04 2018-07-30   50 vidow 0 0           0 0   Downloadable Music v 0 emusic
19 2894762 1921072 2012-06-29 2013-01-06 1036102946012 1 3aa 0 0           0 0   Book - 400 759.3 qs333
20 2894294 1369109 2012-06-29 2013-01-06 0966357656026 1 3la 0 0           0 0 0878754318 Reference Book o 3500 821.7 w926 zmcg
21 2894550 1627630 2012-06-29 2013-01-06 1000435453013 1 3ha 0 0           0 0   Book - 1550 909 z58
22 2894574 1625788 2012-06-29 2013-01-06 0982889252010 1 2ga 0 0           0 0   Reference Book o 1550 330 e19
23 2894748 1768462 2012-06-29 2013-01-06 1016705053010 1 3ha 0 0           1 0   Book - 450 917 m64 g2
24 2894787 1627952 2012-06-29 2013-01-06 1000439356014 1 3la 0 0           0 0   Reference Book o 1550 842 v688 c
25 2894957 1768808 2012-06-29 2013-01-06 1016710046017 1 3aa 0 0           0 0 0313290636 Reference Book o 5995 792.089924 n154
26 2894678 1369388 2012-06-29 2013-01-06 0966364358012 1 2sa 0 0           3 0   Book - 1200 575 h114 pe
27 2894852 1628064 2012-06-29 2013-01-06 1000440458023 1 2sa 0 0           0 0   Reference Book o 500 597 62
28 2895024 1768838 2012-06-29 2013-01-06 1016711653019 1 3ha 0 0           0 0   Reference Book o 555 917.1 qe56
29 2895201 1197578 2012-06-29 2018-11-15 0912135656011 1 3la 0 0           0 0   Reference Book o 1350 808.8 g787 , 1952
30 8390214 3074899 2015-08-04 2018-07-30   50 vidow 0 0           0 0   Downloadable Music v 0 emusic
31 2895165 1769041 2012-06-29 2021-11-19 1016713953011 1 3ha 100 100       2021-10-24 2021-11-14 1 0   Book - 400 917.1 p88
32 2895349 1197578 2012-06-29 2018-11-15 0935635856013 1 3la 0 0           0 0   Reference Book o 1550 808.8 g787 , 1952
33 2895697 1128172 2012-06-29 2013-01-06 0919574952017 1 2ga 0 0           0 0 019825492X Book - 6900 341.75 b972
34 3281083 1077935 2012-06-30 2013-01-07 0938639752014 1 2ga 0 0           5 0 0313266859 Book - 3795 327.7307293 s372
35 2892705 1624813 2012-06-29 2013-01-06 1000396652017 1 2ga 0 0           0 0   Reference Book o 1550 345.22 qo4 .15
36 2893034 1766014 2012-06-29 2013-01-06 1016674953018 1 3ha 0 0           0 0   Reference Book o 1550 915.403 i39
37 2892839 1913986 2012-06-29 2013-01-06 1036026252018 1 2ra 0 0           0 0 0195211286 Book - 4800 382.9 t763
38 3281121 1246707 2012-06-30 2013-01-07 0929003949013 1 2ea 0 0           18 0 0914814184 Book - 1195 797.124 m835
39 7057087 2832053 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
40 7057049 2832015 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
41 8390131 3074816 2015-08-04 2018-07-30   50 vidow 0 0           0 0   Downloadable Music v 0 emusic
42 2895636 1369783 2012-06-29 2013-01-06 0966375449016 1 2ea 0 0           0 0   Reference Book o 300 366 w37 p2
43 1678299 2321869 2012-06-26 2013-02-12 1495640-1001 1 4da 0 0           0 0   Reference Government Document o 0 ga 1.13:hehs-98-25
44 1148946 2381983 2012-06-23 2013-01-04 6502227151023 1 1fa 0 0           0 0   Book - 495 fiction
45 2892679 1913378 2012-06-29 2013-01-06 1036019452013 1 3ea 0 0           0 0   Reference Book o 400 307.341609 qh9951
46 2893326 1368383 2012-06-29 2013-01-06 0966338557012 1 3ca 0 0           0 0   Rare Book o 3750 655.14 ff25
47 2892898 1914259 2012-06-29 2013-01-06 1036029453019 1 3gar 0 0           0 0 0897252446 Reference Book o 4950 929.308931 b959
48 2895417 1769369 2012-06-29 2013-01-06 1016717253012 1 3ha 0 0           0 0   Book - 1550 916.8 w73
49 2895487 1769490 2012-06-29 2013-01-06 1016718553014 1 3ha 0 0           1 0   Book - 1550 915.489 qw473
50 2895395 1197578 2012-06-29 2018-11-15 0935636756014 1 3la 0 0           0 0   Reference Book o 1550 808.8 g787 , 1952
51 2895998 1770227 2012-06-29 2019-04-30 1016727453016 1 3ha 0 0           0 0   Reference Book o 1950 917.3 qc65 1964
52 2895975 1629736 2012-06-29 2013-01-06 1000466552014 1 2ga 0 0           0 0   Reference Book o 1550 368.3 a85
53 1148947 2381983 2012-06-23 2013-01-04 6502227151049 1 1fa 0 0           0 0   Book - 195 fiction
54 2892885 1623690 2012-06-29 2019-07-09 0982841717019 21 maar 0 0           51 0 0964743310 Reference Book o 2695 977.178 qw854 , 1995
55 2896141 1370223 2012-06-29 2013-01-06 0966387458013 1 2sa 0 0           0 0 9024737079 Reference Book o 13400 620.1126 b865
56 2892862 1623649 2012-06-29 2013-01-06 0982841952012 1 2ga 0 0           0 0   Reference Book o 7000 382.097305 qs617
57 2893112 1368195 2012-06-29 2013-01-06 0966330458011 1 2sa 0 0           0 0   Reference Book o 500 595.780972 fb615
58 3121050 1310731 2012-06-29 2017-01-01 0958339546029 1 3aa 441 440       2015-05-16 2015-06-01 20 0 1881021009 Book - 2495 779.24 qs312
59 2894209 1627202 2012-06-29 2013-01-06 1000426953013 1 3ha 0 0           0 0   Reference Book o 1550 908 r65
60 2893070 1625471 2012-06-29 2018-07-03 1000404957010 1 3ca 0 0           0 0   Rare Book o 1550 657 1875
61 2896131 1199716 2012-06-29 2013-01-06 0921453158013 1 2sa 0 0           5 0   Book - 1495 548 66
62 2895092 1197578 2012-06-29 2018-11-15 0912134056015 1 3la 0 0           0 0   Reference Book o 1350 808.8 g787 , 1952
63 2895067 1768866 2012-06-29 2013-01-06 1016711953013 1 3ha 0 0           0 0   Reference Book o 1550 917.1 f59
64 2895208 1197578 2012-06-29 2018-11-15 0912135756019 1 3la 0 0           0 0   Reference Book o 1350 808.8 g787 , 1952
65 2896308 1370351 2012-06-29 2013-01-06 0966390658013 1 2sa 0 0           1 0   Book - 400 621.20971 m682
66 2896191 1629985 2012-06-29 2013-01-06 1000476952014 1 2ga 0 0           0 0   Reference Book o 750 368.3 d92
67 7057108 2832074 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
68 2893096 1914850 2012-06-29 2013-01-06 1036036056011 1 3la 0 0           0 0 0816038503 Reference Book o 6500 818.309 qp743 zs
69 2896686 1630332 2012-06-29 2013-01-06 1000493852015 1 2ga 0 0           0 0   Reference Book o 600 368.3 n2772l
70 2896564 1630267 2012-06-29 2013-01-06 1000491252010 1 2ga 0 0           0 0   Reference Book o 1550 368.3 n27
71 2895546 1769566 2012-06-29 2013-01-06 1016719353018 1 3ha 0 0           0 0   Book - 250 916.82 n45 g
72 8390143 3074828 2015-08-04 2018-07-30   50 vidow 0 0           0 0   Downloadable Music v 0 emusic
73 2895633 1070771 2012-06-29 2013-01-06 0918079952019 1 2ga 0 0           3 0   Book - 6000 658.4 68.3
74 2893468 1368417 2012-06-29 2013-01-06 0966340758012 1 2sa 0 0           0 0   Reference Book o 175 629.19 q47 .1
75 2893480 1368428 2012-06-29 2013-01-06 0966341558015 1 2sa 0 0           0 0   Reference Book o 500 629.13335 q64 .2
76 8207839 3037437 2015-03-31 2018-07-30   50 vidow 0 0           0 0 9781624231803 Downloadable Book v 0 ebook
77 2896297 1770700 2012-06-29 2013-01-06 1016733253012 1 3ha 0 0           0 0   Book - 125 917.19 g82 n
78 2896252 1630042 2012-06-29 2013-01-06 1000478449019 1 2ea 0 0           0 0   Book - 1550 172.1 t89
79 2896558 1628126 2012-06-29 2013-01-06 0982926846014 1 3aa 0 0           0 0   Music Score - 125 m2.24 qb118 c10
80 2896756 1771504 2012-06-29 2013-01-06 1016742453017 1 3ha 0 0           0 0   Reference Book o 1550 917.13 m81
81 2896785 1370664 2012-06-29 2013-01-06 0966399953027 1 3ha 0 0           0 0   Book - 200 920 h314 .1
82 2896886 1630472 2012-06-29 2013-01-06 1000497153014 1 3ha 0 0           0 0   Book - 1550 910 m87 .1
83 2897170 1370807 2012-06-29 2013-01-06 0966404046015 1 3aa 0 0           0 0   Reference Book o 795 741.6097 qg766
84 2893805 1625025 2012-06-29 2013-01-06 0982874017014 21 majr 0 0           0 0 0803718403 Reference Juvenile Book o 1395 easy
85 2893812 1625025 2012-06-29 2013-01-06 0982874048019 1 1lj 0 0           0 0 0803718403 Reference Juvenile Book o 1395 easy
86 2894015 1625267 2012-06-29 2013-01-06 0982879752011 1 2ga 0 0           0 0   Reference Book o 1550 328.7721 e
87 2894163 1767653 2012-06-29 2013-01-06 1016694932018 37 shjr 0 0           0 0 189960751X Reference Juvenile Book o 1095 easy
88 2894244 1369059 2012-06-29 2013-01-06 0966356549016 1 2ea 0 0           0 0 0801427738 Book - 5195 361.763209 m773 zm
89 2894371 1625639 2012-06-29 2013-01-06 0982885352012 1 2ga 0 0           0 0   Book - 395 330 fb932
90 2894292 1627373 2012-06-29 2018-02-15 1000430753011 1 3ha 0 0           0 0   Reference Book o 795 909 p975
91 2894489 1625711 2012-06-29 2014-10-28 0982886351013 1 1fa 0 0           28 0 0688141250 Book - 2300 fiction
92 1988265 1596479 2012-06-27 2014-07-08 0986205858012 1 2sa 0 0           0 0   Reference Book o 1550 540.3 1882
93 2894503 1625726 2012-06-29 2013-01-06 0982886552016 1 2ga 0 0           0 0   Book - 1550 320.80973 e46
94 2895299 1923051 2012-06-29 2013-01-06 1036127352014 1 2ga 0 0           0 0 1563113600 Book - 4995 363.286097 fu58 zu
95 2895716 1769825 2012-06-29 2019-04-29 1016722353013 1 3ha 0 0           0 0   Reference Book o 1550 917.12 b98 1904
96 2895747 1629548 2012-06-29 2013-01-06 1000459852017 1 2ga 0 0           0 0   Book - 1550 335 k211
97 1374564 1121286 2012-06-24 2019-01-15 0925869852010 1 2ga 801 490       2018-12-14 2019-01-11 34 1   Book - 395 355.31 j93
98 7057160 2832126 2013-03-23 2018-07-27   50 vidow 0 0           0 0   Downloadable Book v 0  
99 2897668 1371220 2012-06-29 2013-01-06 0966413352016 1 2ga 0 0           4 0 0201550695 Book - 2495 352.650973 w727
100 2898369 1371805 2012-06-29 2013-01-06 0966427958014 1 2sa 0 0           2 0   Book - 1550 576.82 d228 zd

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