item

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

5,515,381 rows sorted by price_cents

✎ 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
4744 4744 9740903 1101332 2018-01-30 2021-01-01 A000056805856 4 baamg 124 490       2019-05-03 2019-05-15 5 1   Magazine w 0 periodical
4887 4887 10067168 1101332 2018-10-02 2021-01-01 A000057239758 21 maamg 323 320       2019-03-02 2019-03-06 3 2   Magazine w 0 periodical
5025 5025 1364508 2449002 2012-06-24 2013-02-14 1295907-2001 199 yhbsh 0 0           0 0 0195038592 Reference Book o 0 305.420973 m439
5063 5063 1366492 2006463 2012-06-24 2013-02-14 1297309-3001 199 ytma 0 0           0 0 0300037791 Reference Book o 0 759.2 qt948 zga2
5159 5159 1373869 2056430 2012-06-24 2013-02-14 1302634-38001 199 ymhs 0 0           0 0 0933002041 Reference Book o 0 977.178 c5748
5165 5165 1374125 2058292 2012-06-24 2015-09-10 1302844-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical
5166 5166 1374112 2058201 2012-06-24 2015-09-11 1302835-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical
5167 5167 1374221 2058972 2012-06-24 2014-06-18 1302988-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical
5170 5170 1374620 2062296 2012-06-24 2013-01-05 1303430-1001 1 4da 0 0           0 0   Microfiche o 0 mfc y 4.g 74/ 7:f 73/ 9
5171 5171 1374660 2062734 2012-06-24 2013-01-05 1303469-1001 1 4da 0 0           0 0   Microfiche o 0 mfc y 4.p 96/ 11: 98- 66
5173 5173 1374905 2064872 2012-06-24 2013-01-05 1303689-1001 1 4da 0 0           0 0   Microfiche o 0 mfc y 4.g 74/ 7:h 34/ 4
5174 5174 1374974 2065450 2012-06-24 2013-01-05 1303750-1001 1 4da 0 0           0 0   Microfiche o 0 mfc y 4.c 73/ 7:s.hrg. 98- 971
5176 5176 1375162 2066990 2012-06-24 2013-01-05 1303918-1001 1 4da 0 0           0 0   Microfiche o 0 mfc y 4.w 36: 98- 74
5177 5177 1375225 2067534 2012-06-24 2013-02-07 1303971-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.sm
5180 5180 1375493 2069869 2012-06-24 2013-02-07 1304225-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.ec
5181 5181 1375595 2070825 2012-06-24 2013-01-05 1304324-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1152
5182 5182 1375715 2071837 2012-06-24 2013-01-05 1304434-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2068
5184 5184 1375940 2073846 2012-06-24 2013-01-05 1304642-1001 1 2na 0 0           0 0   Microfilm o 0 mf810 a512 ser. 2
5186 5186 1376139 2075619 2012-06-24 2013-01-05 1304829-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2163
5188 5188 1376154 2075737 2012-06-24 2013-01-05 1304841-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2231
5189 5189 1376165 2075836 2012-06-24 2013-01-05 1304851-1001 1 2na 0 0           0 0   Microfilm o 0 mf581.006
5191 5191 1376272 2076802 2012-06-24 2013-01-05 1304950-1001 1 2na 0 0           0 0   Microfilm o 0 mf034.007
5192 5192 1376383 2077795 2012-06-24 2013-01-05 1305054-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2248
5193 5193 1376461 2078536 2012-06-24 2015-09-10 1305127-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical
5194 5194 1376674 2080449 2012-06-24 2013-01-05 1305339-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2431
5195 5195 1376586 2079658 2012-06-24 2013-01-05 1305253-1001 1 2na 0 0           0 0   Microfilm o 0 mf810 a512 ser. 2 reel 495.1
5196 5196 1376691 2080596 2012-06-24 2013-01-05 1305358-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2468
5197 5197 1376787 2081491 2012-06-24 2013-02-07 1305452-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.ed
5198 5198 1376801 2081632 2012-06-24 2013-01-05 1305466-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2540
5199 5199 1376899 2082538 2012-06-24 2013-01-05 1305564-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2379
5200 5200 1377102 2084323 2012-06-24 2015-01-20 1305755-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical
5201 5201 1377180 2084796 2012-06-24 2015-09-14 1305805-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical
5203 5203 1377342 2086183 2012-06-24 2013-01-05 1305972-1001 1 2na 0 0           0 0   Microfilm o 0 mf810 a512 ser. 2 reel 552.13
5205 5205 1377628 2088775 2012-06-24 2013-02-07 1306249-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.in
5206 5206 1377726 2089609 2012-06-24 2013-02-07 1306346-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.ag
5207 5207 1377770 2089973 2012-06-24 2013-02-07 1306386-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.ag
5208 5208 1377862 2090708 2012-06-24 2013-02-07 1306467-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.f
5209 5209 1377915 2091161 2012-06-24 2013-02-07 1306516-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.f
5210 5210 1377982 2091725 2012-06-24 2017-03-15 1306577-1001 1 1zzzz 0 0           0 0   Cleanup - 0 xx(1306577.1)
5211 5211 1378090 2092695 2012-06-24 2013-02-07 1306687-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.g
5212 5212 1378296 2094607 2012-06-24 2013-02-07 1306901-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.en
5213 5213 1378278 2094459 2012-06-24 2015-09-14 1306882-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical
5214 5214 1378303 2094677 2012-06-24 2015-09-14 1306908-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical
5215 5215 1378316 2094790 2012-06-24 2015-09-14 1306921-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical
5217 5217 1378439 2095944 2012-06-24 2013-02-07 1307043-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.sm
5218 5218 1378477 2096270 2012-06-24 2013-02-07 1307079-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.sm
5219 5219 1378578 2097130 2012-06-24 2013-02-07 1307182-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.in211:
5220 5220 1378591 2097241 2012-06-24 2013-02-07 1307194-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.in
5221 5221 1378610 2097434 2012-06-24 2013-02-07 1307213-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.in
5222 5222 1378619 2097521 2012-06-24 2013-02-07 1307221-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.in
5223 5223 1378622 2097532 2012-06-24 2013-02-07 1307222-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.in
5224 5224 1378668 2097971 2012-06-24 2013-02-07 1307276-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.f
5225 5225 1378698 2098238 2012-06-24 2013-02-07 1307307-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.f
5228 5228 1378870 2099823 2012-06-25 2013-02-07 1307479-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.f
5229 5229 1378902 2100100 2012-06-25 2013-02-07 1307509-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.sm
5230 5230 1378912 2100183 2012-06-25 2013-02-07 1307518-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.j
5231 5231 1379021 2101211 2012-06-25 2013-02-07 1307649-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.j
5232 5232 1379028 2101267 2012-06-25 2013-02-07 1307655-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.j
5233 5233 1379229 2102907 2012-06-25 2013-02-07 1307853-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.n
5234 5234 1379232 2102938 2012-06-25 2013-02-07 1307856-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.n
5235 5235 1379244 2103038 2012-06-25 2013-02-07 1307867-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.in
5236 5236 1379418 2104652 2012-06-25 2013-01-05 1308054-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1243
5237 5237 1379483 2105254 2012-06-25 2013-01-05 1308120-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1274
5239 5239 1379561 2105887 2012-06-25 2015-09-14 1308209-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical
5240 5240 1379707 2107260 2012-06-25 2013-01-05 1308357-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1357
5242 5242 1379733 2107483 2012-06-25 2013-01-05 1308385-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1368
5243 5243 1379756 2107704 2012-06-25 2013-01-05 1308406-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1390
5245 5245 1379911 2109187 2012-06-25 2013-01-05 1308576-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1473
5246 5246 1380020 2110243 2012-06-25 2013-01-05 1308699-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2617
5247 5247 1380026 2110291 2012-06-25 2013-01-05 1308703-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2621
5248 5248 1380036 2110384 2012-06-25 2013-01-05 1308714-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1534
5250 5250 1380102 2110996 2012-06-25 2013-01-05 1308778-1001 1 2na 0 0           0 0   Microfilm o 0 mf117.004
5251 5251 1380152 2111409 2012-06-25 2013-01-05 1308827-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2681
5252 5252 1380282 2112545 2012-06-25 2013-01-05 1308966-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2750
5253 5253 1380385 2113528 2012-06-25 2013-02-07 1309083-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.p
5254 5254 1380457 2114073 2012-06-25 2013-02-07 1309147-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.en
5255 5255 1380533 2114767 2012-06-25 2013-01-05 1309218-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1568
5256 5256 1380562 2115036 2012-06-25 2013-01-05 1309247-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1624
5257 5257 1380706 2116363 2012-06-25 2013-01-05 1309389-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1683
5258 5258 1380880 2117884 2012-06-25 2013-01-05 1309548-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1707
5259 5259 1381017 2119099 2012-06-25 2013-01-05 1309671-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1728
5260 5260 1381031 2119216 2012-06-25 2013-01-05 1309683-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 g1735
5262 5262 1381059 2119437 2012-06-25 2013-01-05 1309711-1001 1 3ea 0 0           0 0   Microfiche o 0 mfc973 g326 lh2928
5264 5264 1381531 2122945 2012-06-25 2013-02-07 1310146-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.p
5265 5265 1381550 2123119 2012-06-25 2013-02-07 1310164-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.p
5266 5266 1381587 2123372 2012-06-25 2013-02-07 1310192-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.p
5267 5267 1381752 2124770 2012-06-25 2019-09-25 1310338-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical
5268 5268 1381867 2125743 2012-06-25 2013-02-07 1310438-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.sci
5269 5269 1381954 2126490 2012-06-25 2017-03-15 1310524-1001 1 1zzzz 0 0           0 0   Cleanup - 0 s 9185
5270 5270 1382046 2127237 2012-06-25 2013-02-07 1310611-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.d631:
5271 5271 1382155 2128182 2012-06-25 2013-02-07 1310719-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.ag
5272 5272 1382229 2128851 2012-06-25 2013-02-07 1310786-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.c
5273 5273 1382271 2129246 2012-06-25 2013-02-07 1310830-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.en
5274 5274 1382365 2130069 2012-06-25 2013-02-07 1310919-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.w
5275 5275 1382370 2130122 2012-06-25 2013-02-07 1310924-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.w
5276 5276 1382391 2130308 2012-06-25 2013-02-07 1310943-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.ag
5277 5277 1382445 2130766 2012-06-25 2013-02-07 1310991-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.sm
5278 5278 1382471 2130991 2012-06-25 2013-02-07 1311016-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.d631:
5279 5279 1382585 2131952 2012-06-25 2013-02-07 1311127-1001 1 4da 0 0           0 0   Reference Government Document o 0 y 4.w
5280 5280 1382732 2133236 2012-06-25 2014-02-17 1311279-1001 1 2na 0 0           0 0   Reference Magazine o 0 periodical

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