item

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

5,515,381 rows sorted by isbn

✎ 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
8 8 1000901 1878586 2012-06-22 2020-06-29 1041694849012 1 2ea 1 1       2014-10-20 2014-11-03 1 0   Reference Book o 53 370.7 n27
13 13 1001189 1879987 2012-06-22 2020-06-29 1041710946016 1 3aa 0 0           0 0   Reference Book o 400 779.092 m6952zm
14 14 1001232 1880515 2012-06-22 2020-06-29 1041715749019 1 2ea 0 0           0 0   Reference Book o 1550 370.7 n27
15 15 1001240 1880631 2012-06-22 2020-06-29 1041716749018 1 2ea 0 0           0 0   Reference Book o 475 370.7 n27
16 16 1001256 1880784 2012-06-22 2020-06-29 1041718449013 1 2ea 0 0           0 0   Reference Book o 550 370.7 n27
17 17 1001277 1880910 2012-06-22 2020-06-29 1041719749015 1 2ea 0 0           0 0   Reference Book o 601 370.7 n27
20 20 1001680 1887484 2012-06-22 2014-06-18 1041804346016 1 3aa 0 0           0 0   Reference Book o 1550 759.3 qh148 zh
23 23 11007644 3172699 2020-12-28 2020-12-28   1 tsaar 0 0           0 0   Book p 1308 346.73052 r194
25 25 1002060 1223523 2012-06-22 2014-06-18 0922056446011 1 3ra 0 0           0 0   Music Score - 150 m4.218926 b515 co
27 27 9726272 3281921 2018-01-18 2020-01-07 A000013241740 30 nwamg 801 360       2019-04-16 2019-06-01 7 1   Magazine w 0 periodical
28 28 11007371 1014568 2020-12-28 2021-01-01 A000071210415 38 smamg 494 0 2020-12-31 2021-02-11 sm     1 0   Magazine - 0 periodical
29 29 9726274 1016583 2018-01-18 2020-07-28 A000056804826 4 baamg 123 320       2018-02-09 2018-03-05 3 0   Magazine w 0 periodical
31 31 1002879 1894215 2012-06-22 2020-03-26 1002620-497001 25 moamg 0 0           0 0   Magazine w 0 periodical
32 32 1003007 1894215 2012-06-22 2014-06-18 1002620-704001 15 geamg 0 0           0 0   Magazine - 0 periodical
33 33 1003030 1894215 2012-06-22 2020-03-19 A000014174759 30 nwamg 0 0           0 0   Magazine w 0 periodical
34 34 11007388 1023974 2020-12-28 2021-01-01 A000071210704 1 2mamh 120 0 2020-12-29 2021-02-09 ba     1 0   Magazine - 500 periodical
37 37 11007681 1302179 2020-12-28 2020-12-28   1 tsaar 0 0           0 0   Book p 2619 346.73052 qp699
40 40 7304663 2879248 2013-09-11 2020-01-13 A000038174033 33 grac 261 260       2020-01-04 2020-01-13 18 7   Music on CD - 1598 cd-popular case c337w 2013
42 42 8441269 1171446 2015-09-02 2020-10-30 A000045980398 37 whanf 800 1       2015-09-25 2020-10-30 1 1   Book e 2895 032.02 qg964
44 44 1004392 1042985 2012-06-22 2014-06-18 0903126556013 1 3la 0 0           0 0   Reference Book o 400 483.2 l712
50 50 1005317 1043043 2012-06-22 2017-01-01 0903129758012 1 2sa 800 490       2015-08-17 2015-12-28 5 6   Book - 400 696.12 q79
58 58 1005697 1917246 2012-06-22 2014-06-18 1004983-2001 1 2rar 0 0           0 0   Reference Book o 27500 780.922 qi613
62 62 7305113 2884456 2013-09-11 2020-07-10 A000036292142 26 bhad 370 130       2015-09-21 2015-09-22 26 16   DVD/Videocassette - 1999 dvd comedy a543 2013
67 67 1006635 1225581 2012-06-22 2013-01-04 0922109153143 1 3ha 0 0           0 0   Reference Book o 100 976.9 s53 1885
71 71 1007137 1225972 2012-06-22 2013-01-04 0922117848015 1 1lj 0 0           0 0   Reference Juvenile Book o 420 817.008 s422 m
73 73 1007337 1226109 2012-06-22 2013-01-04 0922120953026 1 3ha 0 0           4 0   Book - 1000 917.7311 d911
78 78 1007552 1946527 2012-06-22 2013-01-04 1042531651017 1 1fa 0 0           0 0   Reference Book o 1550 fiction
84 84 1008390 1961314 2012-06-22 2013-01-04 1049954158016 1 2sa 0 0           0 0   Reference Book o 400 615.13 w628
86 86 1008435 1962103 2012-06-22 2013-02-20 1042741560016 1 1fa 0 0           0 0   Reference Music on CD o 342 cd 10379
88 88 1008499 1962990 2012-06-22 2013-01-04 1042753056010 1 3ra 0 0           0 0   Book - 400 811.54 f352 f
89 89 8270340 3035990 2015-05-13 2020-01-07 A000044203230 14 geac 801 240       2019-03-14 2019-08-27 18 13   Music on CD - 1398 cd-country zac z13j 2015
90 90 1008877 1967884 2012-06-22 2013-01-04 1042811258012 1 2sa 0 0           0 0   Reference Book o 1550 507 f46
91 91 1008889 1967992 2012-06-22 2013-01-04 1042812358019 1 2sa 0 0           0 0   Reference Book o 1550 507 f46
92 92 1008894 1968043 2012-06-22 2013-01-04 1042812858018 1 2sa 0 0           0 0   Reference Book o 1550 507 f46
93 93 1008906 1227438 2012-06-22 2013-01-04 0922151846040 1 3aa 0 0           7 0   Book - 135 785.42 b192
94 94 1008928 1968249 2012-06-22 2013-01-04 1042830758018 1 2sa 0 0           0 0   Reference Book o 1550 507 f46
95 95 1008955 1227454 2012-06-22 2019-01-01 0922152146028 1 3ra 1 10         2018-02-24 10 0   Book - 225 791.437 b658 e
97 97 7305360 2881577 2013-09-11 2018-01-01 A000036286615 19 avad 113 110 2016-09-20 2016-10-04 1 2016-08-20 2016-08-26 85 32   DVD/Videocassette n 1998 dvd drama d6111 2013
99 99 7305366 2881577 2013-09-11 2021-01-01 A000036286672 25 smad 801 490       2020-11-17 2020-12-07 137 49   DVD/Videocassette - 1998 dvd drama d6111 2013
101 101 1009681 1975478 2012-06-22 2019-04-03 1042908157010 1 3carv 0 0           0 0   Rare Book o 1550 627.120973 u58
102 102 1009713 1975478 2012-06-22 2019-04-03 1042912557015 1 3carv 0 0           0 0   Rare Book o 1550 627.120973 u58
103 103 1009792 1975478 2012-06-22 2019-04-03 1042921257011 1 3carv 0 0           0 0   Rare Book o 1550 627.120973 u58
105 105 1009843 1975511 2012-06-23 2013-01-04 1042897358017 1 2sa 0 0           0 0   Reference Book o 1550 507 ff46 .2
107 107 1010067 1977960 2012-06-23 2013-01-04 1042945846013 1 3aa 0 0           0 0   Reference Book o 400 709.2074 a792 za2
108 108 1010208 1979450 2012-06-23 2013-01-04 1042961546018 1 3aa 0 0           0 0   Reference Book o 400 709.04 fk17
109 109 1010243 1228039 2012-06-23 2013-01-04 6802274948010 1 1lj 0 0           0 0   Juvenile Book - 395 j948
114 114 1010816 1983209 2012-06-23 2013-01-04 1011856-12001 1 2ga 0 0           0 0   Reference Book o 1000 659.058 qs785 g
115 115 1010863 1983237 2012-06-23 2013-01-04 1011859-3001 1 2ga 0 0           0 0   Reference Book o 1000 659.1 qs785
116 116 1010868 1983237 2012-06-23 2013-01-04 1011859-9001 1 2ga 0 0           0 0   Reference Book o 129900 659.1 qs785
118 118 1010938 1984235 2012-06-23 2013-01-04 1043026146018 1 3aa 0 0           0 0   Reference Book o 400 709.2074 qa342 za
120 120 1011105 1985703 2012-06-23 2013-01-04 1043046553011 1 3gar 0 0           0 0   Reference Book o 1400 929.377112 qr3232
121 121 1011078 1985403 2012-06-23 2013-01-04 1043042458017 1 2sa 0 0           0 0   Reference Book o 1550 507 f46 .1
123 123 1011207 1986964 2012-06-23 2013-01-04 1043059858018 1 2sa 0 0           0 0   Reference Book o 6000 507 f46
124 124 1011278 1987602 2012-06-23 2013-01-04 1043066346015 1 3aa 0 0           0 0   Reference Book o 400 709.040074 c3921
125 125 1011304 1987841 2012-06-23 2013-01-04 1043068753010 1 3galr 0 0           0 0   Reference Book o 400 977.211 qs642
127 127 1011692 1991269 2012-06-23 2013-01-04 1043111646013 1 3aa 0 0           0 0   Reference Book o 400 709.2074 qm829 zm3
129 129 8270424 1981622 2015-05-13 2021-01-01 A000043950922 42 grjgn 264 260       2020-12-19 2020-12-26 19 12   Juvenile Book - 999 741.5 qp7612
131 131 1011939 1004750 2012-06-23 2013-01-04 0503651249016 1 2ea 0 0           5 0   Reference Book o 1550 277.46 g81
132 132 1011993 1993795 2012-06-23 2013-01-04 1043146658017 1 2sa 0 0           0 0   Reference Book o 6000 507 f46
133 133 1012049 1994175 2012-06-23 2013-01-04 1043152358015 1 2sa 0 0           0 0   Reference Book o 1550 507 f46
137 137 1012246 1995538 2012-06-23 2013-01-04 1043174058015 1 2sa 0 0           0 0   Reference Book o 1550 507 f46
138 138 1012316 1228965 2012-06-23 2013-01-04 0922187656041 1 3la 0 0           0 0   Book - 175 822 c874 bi
140 140 11007937 2341900 2020-12-28 2021-01-01 A000071211538 38 smamg 494 0 2020-12-31 2021-02-11 sm     1 0   Magazine - 0 periodical
141 141 11007936 2341900 2020-12-28 2020-12-29 A000071211512 40 wtamg 0 0           0 0   Magazine - 0 periodical
142 142 1012635 1229137 2012-06-23 2013-01-04 0922192358013 1 2sa 0 0           1 0   Book - 500 629.2882 72.2
144 144 1012780 1004757 2012-06-23 2013-01-04 0503713452012 1 2ga 0 0           2 0   Book - 1550 326.973 r32
153 153 1013360 1758226 2012-06-23 2013-01-04 1043338058018 1 2sa 0 0           0 0   Reference Book o 1550 557.62 m67
155 155 1013512 1760694 2012-06-23 2013-01-04 1043367658019 1 2sa 0 0           0 0   Reference Book o 1550 557.46 c75
163 163 1014294 1767285 2012-06-23 2013-01-04 1043451655913 1 4cdd 0 0           28 0   Magazine o 3000 xx(1015723.89)
164 164 9239086 1014072 2017-02-06 2019-01-01 A000043316280 4 baamg 123 120       2018-06-15 2018-06-28 6 7   Magazine - 0 periodical
165 165 10053922 1014568 2018-09-24 2020-06-09 A000058636848 34 pramg 0 0           0 0   Magazine y 500 periodical
167 167 1014689 1771796 2012-06-23 2013-01-04 1043507858016 1 2sa 0 0           0 0   Reference Book o 1550 557.61 a41
169 169 9239097 1014025 2017-02-06 2019-08-05 A000043316132 4 baamg 800 370       2017-05-04 2017-09-06 7 6   Magazine w 0 periodical
170 170 1014852 1774183 2012-06-23 2013-01-04 1043532558011 1 2sa 0 0           0 0   Reference Book o 1550 557.58 qg34
173 173 9722723 2769233 2018-01-15 2021-01-01 A000059088353 2 mdadf 330 330       2020-11-04 2020-11-13 24 17   DVD/Videocassette - 1298 dvd foreign korea h831 2007
174 174 9239117 2341119 2017-02-06 2019-06-17 A000051151017 4 baamg 122 492       2018-08-04 2018-09-05 5 0   Magazine w 0 periodical
179 179 11008351 3537552 2020-12-28 2020-12-28   1 tsadn 0 0           0 0   New Release DVDs p 2127 dvd action b6181 2020
186 186 10414650 1052175 2019-06-10 2021-01-01 A000054833843 4 baamg 801 310       2019-10-31 2019-12-11 2 1   Magazine - 0 periodical
190 190 1016435 1794332 2012-06-23 2013-01-04 1043764658018 1 2sa 0 0           0 0   Reference Book o 1550 557.73 i27
191 191 1016475 1794633 2012-06-23 2013-01-04 1043767958027 1 2sa 0 0           0 0   Book - 1550 557.73 i27
192 192 1016519 1794980 2012-06-23 2013-01-04 1043771358016 1 2sa 0 0           0 0   Reference Book o 1550 557.73 i27
194 194 1016662 1796860 2012-06-23 2021-01-01 1043791960031 1 1fa 102 1 2020-12-10 2021-01-21 mm 2013-01-26 2013-01-28 8 0   Music on CD - 1498 cd 10445
201 201 1017085 1231744 2012-06-23 2013-01-04 1044733156019 1 2rar 0 0           0 0   Reference Book o 18000 801.9509 qc614
202 202 1017101 1231744 2012-06-23 2013-01-04 101906-116001 1 2rar 0 0           0 0   Reference Book o 19065 801.9509 qc614
203 203 1017126 1231744 2012-06-23 2013-01-04 101906-141001 1 2rar 0 0           0 0   Reference Book o 24300 801.9509 qc614
206 206 1017425 1231884 2012-06-23 2013-01-04 0922258058010 1 2sa 0 0           1 0   Book - 1495 541.28 69
210 210 11008201 3520723 2020-12-28 2020-12-28   1 tsadn 0 0           0 0   New Release DVDs p 2201 dvd scifi u561 2020
212 212 10052431 3374779 2018-09-21 2021-01-01 A000059542300 2 grad 261 260       2019-08-20 2019-08-26 21 16   DVD/Videocassette f 3099 dvd action s565d 2018
213 213 1018396 1232407 2012-06-23 2013-01-04 0922269546037 1 3aa 0 0           0 0   Reference Music Score o 995 m4.8 qs844 c
214 214 1018403 1232413 2012-06-23 2013-01-04 0922269651027 1 1fa 0 0           0 0   Book - 395 fiction
216 216 1018595 1043723 2012-06-23 2013-01-04 0903192458029 1 2sa 0 0           0 0   Reference Book o 495 508 qc321
219 219 10052610 3374779 2018-09-21 2021-01-01 A000059543647 28 dpad 801 200       2019-08-19 2019-08-27 17 13   DVD/Videocassette f 3099 dvd action s565d 2018
221 221 1019099 1232867 2012-06-23 2013-01-04 0922284158040 1 2sa 0 0           1 0   Reference Book o 300 623.82 qm919
224 224 11008278 3537555 2020-12-28 2020-12-28   1 tsadn 0 0           0 0   New Release DVDs p 1100 dvd action c1561 2020
229 229 11008307 3520722 2020-12-28 2020-12-28   1 tsadn 0 0           0 0   New Release DVDs p 1467 dvd musical c3671 2020
230 230 1019737 1828691 2012-06-23 2013-01-04 1044152652019 1 2ga 0 0           0 0   Reference Book o 400 333.709771 qc633
231 231 1019752 1828793 2012-06-23 2013-01-04 1044153858011 1 2sa 0 0           0 0   Book - 650 623.82 j77
232 232 10052663 3374779 2018-09-21 2021-01-01 A000059544173 37 haad 281 280       2019-09-23 2019-09-30 26 19   DVD/Videocassette f 3099 dvd action s565d 2018
233 233 1019921 1233217 2012-06-23 2017-01-01 0922294056028 1 3la 201 200       2015-01-13 2015-01-20 4 0   Book - 115 458.8 m29
236 236 7659794 2958026 2014-04-03 2021-01-01 A000040113193 1 1padm 1 10         2020-09-24 28 30   DVD/Videocassette - 2699 dvd drama h6381 2012

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