item
Data source: https://ilsweb.cincinnatilibrary.org/collection-analysis-docs/
5,515,381 rows sorted by checkout_statistic_group_code_num
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
165 | 165 | 10053922 | 1014568 | 2018-09-24 | 2020-06-09 | A000058636848 | 34 | pramg | 0 | 0 | 0 | 0 | Magazine | y | 500 | periodical | ||||||
166 | 166 | 1014404 | 1768557 | 2012-06-23 | 2013-01-04 | 1015855-5001 | 1 | 3la | 0 | 0 | 0 | 0 | 0198182619 | Reference Book | o | 3500 | 820.9 o985 | |||||
167 | 167 | 1014689 | 1771796 | 2012-06-23 | 2013-01-04 | 1043507858016 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 557.61 a41 | ||||||
168 | 168 | 1014759 | 1230384 | 2012-06-23 | 2013-01-04 | 0922221849016 | 1 | 2ea | 0 | 0 | 7 | 0 | 0404567428 | Book | - | 1000 | 378.19822 d255 | |||||
170 | 170 | 1014852 | 1774183 | 2012-06-23 | 2013-01-04 | 1043532558011 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 557.58 qg34 | ||||||
176 | 176 | 1015330 | 1781516 | 2012-06-23 | 2013-01-04 | 1043613846012 | 1 | 3aa | 0 | 0 | 0 | 0 | 0893819964 | Reference Book | o | 5000 | 770.9 qa641 zp | |||||
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 | |||||||
182 | 182 | 1015714 | 1231028 | 2012-06-23 | 2013-01-04 | 0922238153014 | 1 | 3ha | 0 | 0 | 0 | 0 | 0198200862 | Reference Book | o | 5700 | 942.034 s775 | |||||
184 | 184 | 1015993 | 1043624 | 2012-06-23 | 2013-01-04 | 0903184158017 | 1 | 2sa | 0 | 0 | 1 | 0 | 0932620124 | Book | - | 612 | 641.507 82 | |||||
185 | 185 | 1016045 | 1790394 | 2012-06-23 | 2013-01-04 | 1043722152013 | 1 | 2ga | 0 | 0 | 0 | 0 | 0962111856 | Book | - | 1500 | 658.3044 qg244 | |||||
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 | ||||||
196 | 196 | 11008460 | 3570810 | 2020-12-28 | 2020-12-28 | 1 | 1pabr | 0 | 0 | 0 | 0 | 9786317398511 | Bluray | p | 1467 | |||||||
197 | 197 | 8042257 | 2553321 | 2014-12-03 | 2019-10-21 | A000040262297 | 3 | avtf | 0 | 0 | 0 | 0 | 9780758234421 | Teen Book | w | 995 | fiction | |||||
200 | 200 | 1017017 | 1800283 | 2012-06-23 | 2013-01-04 | 1043826952011 | 1 | 2ra | 0 | 0 | 2 | 0 | 0878408878 | Book | - | 5300 | 368.5728 p561 | |||||
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 | ||||||
208 | 208 | 1017755 | 1806675 | 2012-06-23 | 2013-01-04 | 1043899052012 | 1 | 2ga | 0 | 0 | 0 | 0 | 0517460858 | Book | - | 898 | 385.065 fn532 zk | |||||
209 | 209 | 1017787 | 1807054 | 2012-06-23 | 2013-01-04 | 1043903158011 | 1 | 2sa | 0 | 0 | 0 | 0 | 9241545550 | Reference Book | o | 400 | 616.707572 qd261 | |||||
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 | |||||||
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 | ||||||
217 | 217 | 1018833 | 1819721 | 2012-06-23 | 2013-01-04 | 1044048153016 | 1 | 3ha | 0 | 0 | 0 | 0 | 0875300332 | Reference Book | o | 895 | 912.755581 fa382 | |||||
218 | 218 | 1018836 | 1819750 | 2012-06-23 | 2013-01-04 | 1044048453010 | 1 | 3ha | 0 | 0 | 0 | 0 | 0875300367 | Reference Book | o | 895 | 912.75251 fa375 | |||||
220 | 220 | 1018979 | 1821348 | 2012-06-23 | 2014-09-05 | 1044065641067 | 32 | osjnf | 0 | 0 | 3 | 0 | 0516226703 | Juvenile Book | - | 1900 | 975.8 b831 | |||||
221 | 221 | 1019099 | 1232867 | 2012-06-23 | 2013-01-04 | 0922284158040 | 1 | 2sa | 0 | 0 | 1 | 0 | Reference Book | o | 300 | 623.82 qm919 | ||||||
223 | 223 | 1019187 | 1823283 | 2012-06-23 | 2013-01-04 | 1044091848025 | 1 | 1lj | 0 | 0 | 0 | 0 | 0516224786 | Juvenile Book | - | 2950 | 977.6 h345 | |||||
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 | ||||||
237 | 237 | 1020597 | 1837338 | 2012-06-23 | 2013-01-04 | 1044251358013 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 620 i28 | ||||||
238 | 238 | 1020599 | 1837355 | 2012-06-23 | 2013-01-04 | 1044251558018 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 620 i28 | ||||||
240 | 240 | 1020816 | 1839489 | 2012-06-23 | 2013-01-04 | 1044279958018 | 1 | 2sa | 0 | 0 | 0 | 0 | 0889320381 | Book | - | 895 | 688.79 w177 | |||||
242 | 242 | 1020907 | 1840590 | 2012-06-23 | 2018-07-03 | 1044292157010 | 1 | 3ca | 0 | 0 | 0 | 0 | Rare Book | o | 500 | 629.133 j29 | ||||||
243 | 243 | 1020916 | 1840784 | 2012-06-23 | 2013-01-04 | 1044294258014 | 1 | 2sa | 0 | 0 | 6 | 0 | 0387953892 | Book | - | 7495 | 576.50151 l274 | |||||
244 | 244 | 1021071 | 1842171 | 2012-06-23 | 2018-06-05 | 1023328-26001 | 28 | nrar | 0 | 0 | 0 | 0 | 1932250034 | Reference Book | o | 4800 | 929.377177 qh536 s 2003 | |||||
245 | 245 | 1021157 | 1233875 | 2012-06-23 | 2013-01-04 | 0922310549014 | 1 | 2ea | 0 | 0 | 1 | 0 | Book | - | 400 | 364.163 b995 | ||||||
246 | 246 | 1021227 | 1233906 | 2012-06-23 | 2013-01-04 | 0922311146034 | 1 | 3aa | 0 | 0 | 4 | 0 | Book | - | 1550 | 709 qj35 | ||||||
247 | 247 | 1021253 | 1844268 | 2012-06-23 | 2013-01-04 | 1044335853013 | 1 | 3ha | 0 | 0 | 0 | 0 | Book | - | 400 | 917.88830433 t969 | ||||||
248 | 248 | 1021291 | 1844722 | 2012-06-23 | 2013-01-04 | 1044341653019 | 1 | 3gar | 0 | 0 | 0 | 0 | Reference Book | o | 500 | 929.377175 qa188 b | ||||||
249 | 249 | 1021391 | 1234018 | 2012-06-23 | 2013-01-04 | 0922313653029 | 1 | 3ha | 0 | 0 | 14 | 0 | 0801834570 | Book | - | 2950 | 947.0842 s782 zsl | |||||
250 | 250 | 1021401 | 1846171 | 2012-06-23 | 2013-01-04 | 1044357456018 | 1 | 3la | 0 | 0 | 0 | 0 | Book | - | 175 | 831 r573 ma | ||||||
251 | 251 | 1021405 | 1846216 | 2012-06-23 | 2018-09-04 | 1044357853016 | 1 | 3gar | 0 | 0 | 0 | 0 | 0970798806 | Reference Book | o | 4995 | 929.37949 qg682 , 2001 | |||||
252 | 252 | 1021513 | 1234057 | 2012-06-23 | 2013-01-04 | 0959011553010 | 1 | 3ha | 0 | 0 | 0 | 0 | Reference Book | o | 28000 | 920.056 qw628 | ||||||
254 | 254 | 10706614 | 3487294 | 2020-01-17 | 2020-01-22 | A000067922122 | 1 | nrjf | 0 | 0 | 0 | 0 | 9780736439893 | Juvenile Book | - | 699 | fiction | |||||
260 | 260 | 1022055 | 1234400 | 2012-06-23 | 2013-01-04 | 0922325156011 | 1 | 3la | 0 | 0 | 0 | 0 | 0520025423 | Reference Book | o | 2000 | 818.409 c625 a2 | |||||
261 | 261 | 1022068 | 1853645 | 2012-06-23 | 2013-01-04 | 1044437952010 | 1 | 2ra | 0 | 0 | 0 | 0 | 0821353365 | Book | - | 1000 | 382.450009 qm621 | |||||
263 | 263 | 1022383 | 1858669 | 2012-06-23 | 2013-01-04 | 1044492858011 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1000 | 669.735 m587 | ||||||
264 | 264 | 1022585 | 1861809 | 2012-06-23 | 2013-01-04 | 1044529356013 | 1 | 2rar | 0 | 0 | 0 | 0 | 0787660191 | Reference Book | o | 19000 | 810.9003 qd554 | |||||
266 | 266 | 1022687 | 1234930 | 2012-06-23 | 2013-01-04 | 0922337853019 | 1 | 3ha | 0 | 0 | 0 | 0 | 0840771142 | Reference Book | o | 465 | 975.502 g475 | |||||
268 | 268 | 1022945 | 1869415 | 2012-06-23 | 2013-01-04 | 1044616158017 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 622.009 c15 | ||||||
270 | 270 | 1023042 | 1870697 | 2012-06-23 | 2013-01-04 | 1044630258017 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 622.009 c15 | ||||||
272 | 272 | 1023192 | 1235358 | 2012-06-23 | 2013-01-04 | 0922348853024 | 1 | 3ha | 0 | 0 | 0 | 0 | Book | - | 895 | 940.5472 g975 | ||||||
273 | 273 | 1023255 | 1873646 | 2012-06-23 | 2013-01-04 | 1044660658011 | 1 | 2sa | 0 | 0 | 0 | 0 | Book | - | 200 | 636.7001 b992 pe | ||||||
274 | 274 | 1023296 | 1235448 | 2012-06-23 | 2013-01-04 | 1012244158014 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 621.9 m14 | ||||||
275 | 275 | 1023298 | 1235448 | 2012-06-23 | 2013-01-04 | 1012244358010 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 621.9 m14 | ||||||
277 | 277 | 10054103 | 1642235 | 2018-09-24 | 2020-07-16 | A000058637754 | 1 | 2mamh | 0 | 0 | 0 | 0 | Magazine | w | 500 | periodical | ||||||
280 | 280 | 1023731 | 1879698 | 2012-06-23 | 2013-01-04 | 1044758356015 | 1 | 3la | 0 | 0 | 0 | 0 | 8806272357 | Reference Book | o | 2395 | 852.914 f649 xe | |||||
281 | 281 | 1023751 | 1879749 | 2012-06-23 | 2013-01-04 | 1044737658010 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 540.5 qf21 s | ||||||
284 | 284 | 1023922 | 1882823 | 2012-06-23 | 2013-01-04 | 1044772158017 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 622.009 t29 | ||||||
285 | 285 | 1024190 | 1885951 | 2012-06-23 | 2013-01-04 | 1044808658014 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 622.009 qc212 t | ||||||
286 | 286 | 1024139 | 1885576 | 2012-06-23 | 2018-08-29 | 1044804249016 | 1 | 2ea | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 378.7468 y18 zy3 , 1905 | ||||||
287 | 287 | 1024268 | 1887625 | 2012-06-23 | 2013-01-04 | 1044828746013 | 1 | 3aa | 0 | 0 | 0 | 0 | Reference Book | o | 400 | 741.94074 fs625 | ||||||
289 | 289 | 11008513 | 2524040 | 2020-12-28 | 2020-12-28 | 1 | tsad | 0 | 0 | 0 | 0 | DVD/Videocassette | p | 733 | dvd action w251 2008 | |||||||
290 | 290 | 1024525 | 1043984 | 2012-06-23 | 2013-01-04 | 0903218152051 | 1 | 2ga | 0 | 0 | 0 | 0 | Book | - | 1100 | 312.09771 qc396 p | ||||||
291 | 291 | 1024661 | 1236430 | 2012-06-23 | 2013-01-04 | 0922377052019 | 1 | 2ga | 0 | 0 | 0 | 0 | 0029193419 | Book | - | 2250 | 353.123309 l866 | |||||
293 | 293 | 11008850 | 3563369 | 2020-12-28 | 2020-12-28 | 1 | tsac | 0 | 0 | 0 | 0 | 9786318427128 | Music on CD | p | 1188 | |||||||
295 | 295 | 1024864 | 1044024 | 2012-06-23 | 2019-07-18 | 0903219441016 | 32 | osanf | 0 | 0 | 0 | 0 | 0440192242 | Book | w | 350 | fiction | |||||
296 | 296 | 1024945 | 1898753 | 2012-06-23 | 2013-01-04 | 1044957046011 | 1 | 3aa | 0 | 0 | 0 | 0 | Reference Book | o | 400 | 708.949457 k96 zk | ||||||
297 | 297 | 1025066 | 1900567 | 2012-06-23 | 2013-01-04 | 1045031358017 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 543.3 qi2 | ||||||
300 | 300 | 1025480 | 1907426 | 2012-06-23 | 2013-01-04 | 1045051749012 | 1 | 2ea | 0 | 0 | 0 | 0 | 0929874269 | Book | - | 400 | 131 s243 | |||||
301 | 301 | 11008613 | 3539727 | 2020-12-28 | 2020-12-28 | 1 | tsadn | 0 | 0 | 0 | 0 | 9786318286404 | New Release DVDs | p | 1393 | dvd drama c2462 2020 | ||||||
303 | 303 | 11008641 | 3567551 | 2020-12-28 | 2020-12-28 | 1 | tsac | 0 | 0 | 0 | 0 | Music on CD | p | 974 | ||||||||
304 | 304 | 1026170 | 1918929 | 2012-06-23 | 2013-01-04 | 1046116749013 | 1 | 2ea | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 378.744 h3398 | ||||||
305 | 305 | 1026285 | 1920724 | 2012-06-23 | 2019-05-15 | 1045205053014 | 1 | 3garo | 0 | 0 | 0 | 0 | 0195081374 | Reference Book | o | 9833 | 929.40973 qd554 , 2003 | |||||
307 | 307 | 1026326 | 1237845 | 2012-06-23 | 2013-01-04 | 0922410849017 | 1 | 2ea | 0 | 0 | 6 | 0 | 087975382X | Book | - | 1695 | 133.8 r287 | |||||
309 | 309 | 11008781 | 3546169 | 2020-12-28 | 2020-12-28 | 1 | pradn | 0 | 0 | 0 | 0 | New Release DVDs | p | 1174 | dvd comedy a4771 2019 | |||||||
311 | 311 | 1026805 | 1929075 | 2012-06-23 | 2013-01-04 | 1045292952011 | 1 | 2ga | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 658.57 m678 | ||||||
312 | 312 | 11008706 | 3563363 | 2020-12-28 | 2020-12-28 | 1 | tsac | 0 | 0 | 0 | 0 | Music on CD | p | 849 | cd-country brooks b8731fu 2020 | |||||||
314 | 314 | 2421409 | 1770915 | 2012-06-29 | 2019-04-03 | 1024619957011 | 1 | 3ca | 0 | 0 | 0 | 0 | Rare Book | o | 1550 | 977.178 qm853 za 1914 | ||||||
315 | 315 | 1027790 | 1238869 | 2012-06-23 | 2013-01-04 | 0922434146028 | 1 | 3aa | 0 | 0 | 0 | 0 | Reference Book | o | 2450 | 791.43028 qk95 zce | ||||||
316 | 316 | 1027861 | 1942116 | 2012-06-23 | 2013-01-04 | 1045439752019 | 1 | 2ra | 0 | 0 | 0 | 0 | 0198298315 | Book | - | 3995 | 328.41071 g786 zr | |||||
317 | 317 | 1027915 | 1943211 | 2012-06-23 | 2013-01-04 | 1045451052017 | 1 | 2ga | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 658.5 a51 ma | ||||||
318 | 318 | 1028007 | 1944618 | 2012-06-23 | 2018-09-04 | 1045469756021 | 1 | 3la | 0 | 0 | 0 | 0 | 880439109X | Book | - | 7995 | 858.91408 b447 xf 1994 | |||||
320 | 320 | 1028305 | 1949182 | 2012-06-23 | 2013-01-04 | 1034373-1002 | 1 | 2raoo | 0 | 0 | 0 | 0 | Book | - | 400 | 371.071273 c363 zbu2 | ||||||
321 | 321 | 1028519 | 1951389 | 2012-06-23 | 2013-01-04 | 1045547458012 | 1 | 2rar | 0 | 0 | 0 | 0 | 0240804546 | Reference Book | o | 6350 | 621.3893 qh236 | |||||
323 | 323 | 1028900 | 1955224 | 2012-06-23 | 2017-10-19 | 1045594053013 | 1 | 3ha | 0 | 0 | 0 | 0 | 029598077X | Reference Book | o | 1795 | 973 qb831 , 2001 | |||||
324 | 324 | 1028987 | 1956024 | 2012-06-23 | 2013-01-04 | 1045603046016 | 1 | 3aa | 0 | 0 | 0 | 0 | 9645533619 | Book | - | 3595 | 782.421629 t176 | |||||
326 | 326 | 1029122 | 1957765 | 2012-06-23 | 2013-01-04 | 1045623752015 | 1 | 2ga | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 658 o37 c | ||||||
327 | 327 | 1029147 | 1957890 | 2012-06-23 | 2013-01-04 | 1045626452019 | 1 | 2ga | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 658 o37 c | ||||||
328 | 328 | 1029206 | 1958536 | 2012-06-23 | 2013-01-04 | 1045635752011 | 1 | 2ga | 0 | 0 | 0 | 0 | Book | - | 1550 | 658.5 a51 mr | ||||||
330 | 330 | 1029445 | 1960544 | 2012-06-23 | 2018-09-04 | 1045658553015 | 1 | 3ha | 0 | 0 | 0 | 0 | 1587650533 | Reference Book | o | 5937 | 909.82 qg7862, 2002 | |||||
331 | 331 | 1029658 | 1963218 | 2012-06-23 | 2013-01-04 | 1045686558010 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 1550 | 693.7 qa512 | ||||||
332 | 332 | 1029714 | 1240005 | 2012-06-23 | 2019-10-21 | 0922462458022 | 1 | 2sa | 0 | 0 | 0 | 0 | Reference Book | o | 495 | 581.659097 m948 , 1960 | ||||||
336 | 336 | 1030005 | 1967908 | 2012-06-23 | 2013-01-04 | 1045747856015 | 1 | 3la | 0 | 0 | 0 | 0 | 0142001708 | Reference Book | o | 1400 | 423.1 n5323 |
Advanced export
JSON shape: default, array, newline-delimited
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" );