collection-2021-01-04

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

This data as json, CSV

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	isbn	item_format	item_status_code	price_cents	item_callnumber
4	9725942	3308074	2018-01-18	2019-01-01	A000059083057	1	hpaf	302	300				2018-06-16	2018-07-11	5	9781250161536	Book	-	2799	fiction
5	1000643	1222702	2012-06-22	2020-06-29	0922035548010	1	1lj	180	210				2018-03-28	2018-03-30	16	0894902180	Juvenile Book	-	995	553
6	1000656	1875349	2012-06-22	2020-06-29	1041659856028	1	3la	0	0						0	0313312389	Reference Book	w	2450	812.54 w727 zti
7	1000855	1877885	2012-06-22	2020-06-29	1041687053010	1	3ha	324	320				2014-05-07	2014-05-13	6	0802117236	Book	-	2300	958.1046 a547
8	1000901	1878586	2012-06-22	2020-06-29	1041694849012	1	2ea	1	1				2014-10-20	2014-11-03	1		Reference Book	o	53	370.7 n27
11	1001009	1879080	2012-06-22	2020-06-29	1041701149018	1	2rar	0	0						0	0787640042	Reference Book	o	7100	282.03 qn5322, 2002
13	1001189	1879987	2012-06-22	2020-06-29	1041710946016	1	3aa	0	0						0		Reference Book	o	400	779.092 m6952zm
14	1001232	1880515	2012-06-22	2020-06-29	1041715749019	1	2ea	0	0						0		Reference Book	o	1550	370.7 n27
15	1001240	1880631	2012-06-22	2020-06-29	1041716749018	1	2ea	0	0						0		Reference Book	o	475	370.7 n27
16	1001256	1880784	2012-06-22	2020-06-29	1041718449013	1	2ea	0	0						0		Reference Book	o	550	370.7 n27
17	1001277	1880910	2012-06-22	2020-06-29	1041719749015	1	2ea	0	0						0		Reference Book	o	601	370.7 n27
18	1001335	1881666	2012-06-22	2020-06-29	1041727251020	1	1fa	0	0						5	0871138557	Book	-	2400	fiction
19	1001449	1883495	2012-06-22	2020-06-29	1041752852015	1	2ga	0	0						0	0833031996	Reference Book	o	1000	363.2876 qk21 s
20	1001680	1887484	2012-06-22	2014-06-18	1041804346016	1	3aa	0	0						0		Reference Book	o	1550	759.3 qh148 zh
22	1001845	1223437	2012-06-22	2014-06-18	0922053746017	1	3aa	1	0					2013-07-11	10	0531099369	Book	-	895	780.9202 b732 c
23	11007644	3172699	2020-12-28	2020-12-28		1	tsaar	0	0						0		Book	p	1308	346.73052 r194
24	11004495	3560152	2020-12-22	2020-12-31	A000070285095	1	bajer	0	0						0	9781534486249	Juvenile Book	-	1799	easy
25	1002060	1223523	2012-06-22	2014-06-18	0922056446011	1	3ra	0	0						0		Music Score	-	150	m4.218926 b515 co
28	11007371	1014568	2020-12-28	2021-01-01	A000071210415	38	smamg	494	0	2020-12-31	2021-02-11	sm			1		Magazine	-	0	periodical
29	9726274	1016583	2018-01-18	2020-07-28	A000056804826	4	baamg	123	320				2018-02-09	2018-03-05	3		Magazine	w	0	periodical
31	1002879	1894215	2012-06-22	2020-03-26	1002620-497001	25	moamg	0	0						0		Magazine	w	0	periodical
32	1003007	1894215	2012-06-22	2014-06-18	1002620-704001	15	geamg	0	0						0		Magazine	-	0	periodical
33	1003030	1894215	2012-06-22	2020-03-19	A000014174759	30	nwamg	0	0						0		Magazine	w	0	periodical
34	11007388	1023974	2020-12-28	2021-01-01	A000071210704	1	2mamh	120	0	2020-12-29	2021-02-09	ba			1		Magazine	-	500	periodical
35	1003158	1895150	2012-06-22	2014-06-18	A000005115647	1	2kt	0	0						0	1569716692	Teen Book	-	1095	741.5 f961 2002
37	11007681	1302179	2020-12-28	2020-12-28		1	tsaar	0	0						0		Book	p	2619	346.73052 qp699
43	1004321	1898032	2012-06-22	2014-06-18	1041975152011	1	2ga	0	0						0	0833031635	Reference Book	o	1000	359.332 u58 zo
44	1004392	1042985	2012-06-22	2014-06-18	0903126556013	1	3la	0	0						0		Reference Book	o	400	483.2 l712
46	9726141	2564077	2018-01-18	2021-01-01	A000059129934	1	1fa	123	120				2019-07-08	2019-07-31	10	9780061671784	Book	-	1599	fiction
52	1005516	1224690	2012-06-22	2014-06-18	0922087658014	1	2sa	0	0						10	0812105222	Book	-	1175	571.45 qp695
53	11007509	3548794	2020-12-28	2020-12-30	A000070280823	1	dtaar	0	0						0	9781250272614	Book	!	2899	fiction
54	1005594	1224756	2012-06-22	2014-06-18	0922089058015	1	2sa	0	0						0	0851315054	Reference Book	o	1250	571.319665 s668
55	1005615	1916502	2012-06-22	2014-06-18	1042177646016	1	3ra	0	0						0	0873387104	Book	-	2900	709.2 w338 zc
57	1005685	1917164	2012-06-22	2014-06-18	1042188751029	1	1fa	0	0						5	0805069046	Book	-	2500	fiction
58	1005697	1917246	2012-06-22	2014-06-18	1004983-2001	1	2rar	0	0						0		Reference Book	o	27500	780.922 qi613
59	1005726	1917664	2012-06-22	2014-06-18	1042197158018	1	2sa	0	0						0	0966974409	Reference Book	o	1995	621.38103 m734
60	11002771	3558996	2020-12-21	2020-12-21		1	tsadt	0	0						0	9781531712686	DVD/Videocassette	p	2568	dvd tvadult r6281 2020
64	1006254	1926390	2012-06-22	2014-06-18	1042292446011	1	3aa	0	0						0	1878617451	Reference Book	o	5500	782.42168 qs392
65	1006399	1928271	2012-06-22	2019-01-16	1042311952015	1	2ra	1	10					2019-01-16	9	0195134737	Book	-	3500	320.520973 s366
67	1006635	1225581	2012-06-22	2013-01-04	0922109153143	1	3ha	0	0						0		Reference Book	o	100	976.9 s53 1885
68	1006678	1933350	2012-06-22	2013-01-04	1042366158013	1	2ra	0	0						7	0632048867	Book	-	3795	571.84 h437
69	1006815	1935403	2012-06-22	2013-01-04	1042388452014	1	2ra	0	0						0	0275976386	Book	-	6495	324.973092 d743 m
71	1007137	1225972	2012-06-22	2013-01-04	0922117848015	1	1lj	0	0						0		Reference Juvenile Book	o	420	817.008 s422 m
73	1007337	1226109	2012-06-22	2013-01-04	0922120953026	1	3ha	0	0						4		Book	-	1000	917.7311 d911
74	1007348	1943324	2012-06-22	2013-01-04	1042493752019	1	2rar	0	0						0	0816045690	Reference Book	o	6000	359.984097 qu58 zs
75	1007393	1943831	2012-06-22	2013-01-04	1042499451012	1	1fa	0	0						2	1566891337	Book	-	1400	fiction
78	1007552	1946527	2012-06-22	2013-01-04	1042531651017	1	1fa	0	0						0		Reference Book	o	1550	fiction
79	1007606	1947366	2012-06-22	2013-01-04	1042541446010	1	3aa	0	0						0	0938903055	Reference Book	o	400	709.22074 n233 zn
80	11003934	3551963	2020-12-21	2020-12-30	A000070281961	1	tsjbd	0	0						0	9781426339028	Juvenile Book	t	799	easy
81	10710390	3482045	2020-01-20	2021-01-01	A000067920670	1	nraf	390	390				2020-02-28	2020-07-06	1	9781601620934	Book	-	2595	fiction
82	1008056	1226764	2012-06-22	2013-01-04	0922137052010	1	2ga	0	0						0	0877222673	Book	-	3495	320.973 k291
83	1008046	1226754	2012-06-22	2013-01-04	0922136758013	1	2sa	0	0						16	0830697888	Book	-	995	621.381532 79
84	1008390	1961314	2012-06-22	2013-01-04	1049954158016	1	2sa	0	0						0		Reference Book	o	400	615.13 w628
85	1008403	1961758	2012-06-22	2013-01-04	1042736253015	1	2rar	0	0						0	157607207X	Reference Book	o	8500	978.00202 qz53
86	1008435	1962103	2012-06-22	2013-02-20	1042741560016	1	1fa	0	0						0		Reference Music on CD	o	342	cd 10379
87	1008496	1962896	2012-06-22	2015-01-30	1042751953028	1	3ha	0	0						0	0313281122	Reference Book	o	17500	903 j58
88	1008499	1962990	2012-06-22	2013-01-04	1042753056010	1	3ra	0	0						0		Book	-	400	811.54 f352 f
90	1008877	1967884	2012-06-22	2013-01-04	1042811258012	1	2sa	0	0						0		Reference Book	o	1550	507 f46
91	1008889	1967992	2012-06-22	2013-01-04	1042812358019	1	2sa	0	0						0		Reference Book	o	1550	507 f46
92	1008894	1968043	2012-06-22	2013-01-04	1042812858018	1	2sa	0	0						0		Reference Book	o	1550	507 f46
93	1008906	1227438	2012-06-22	2013-01-04	0922151846040	1	3aa	0	0						7		Book	-	135	785.42 b192
94	1008928	1968249	2012-06-22	2013-01-04	1042830758018	1	2sa	0	0						0		Reference Book	o	1550	507 f46
95	1008955	1227454	2012-06-22	2019-01-01	0922152146028	1	3ra	1	10					2018-02-24	10		Book	-	225	791.437 b658 e
96	1009102	1970085	2012-06-22	2013-01-04	1042838351014	1	1fa	0	0						8	1860466303	Book	-	400	fiction
98	1009180	1971245	2012-06-22	2013-01-04	1042852746024	1	3aa	0	0						0	1578064538	Reference Book	o	3500	781.650922 s745
100	1009447	1973984	2012-06-22	2013-01-04	1042880846010	1	3aa	0	0						0	8487342884	Reference Book	o	400	709.2074 qi24 zi
101	1009681	1975478	2012-06-22	2019-04-03	1042908157010	1	3carv	0	0						0		Rare Book	o	1550	627.120973 u58
102	1009713	1975478	2012-06-22	2019-04-03	1042912557015	1	3carv	0	0						0		Rare Book	o	1550	627.120973 u58
103	1009792	1975478	2012-06-22	2019-04-03	1042921257011	1	3carv	0	0						0		Rare Book	o	1550	627.120973 u58
104	1009885	1975877	2012-06-23	2017-01-01	1042912951028	1	1fa	400	400				2015-08-11	2015-11-06	10	0743214447	Book	-	2400	fiction
105	1009843	1975511	2012-06-23	2013-01-04	1042897358017	1	2sa	0	0						0		Reference Book	o	1550	507 ff46 .2
106	1010031	1977559	2012-06-23	2013-01-04	1042941746019	1	3aa	0	0						0	290143262X	Reference Book	o	400	759.4 s223 zs
107	1010067	1977960	2012-06-23	2013-01-04	1042945846013	1	3aa	0	0						0		Reference Book	o	400	709.2074 a792 za2
108	1010208	1979450	2012-06-23	2013-01-04	1042961546018	1	3aa	0	0						0		Reference Book	o	400	709.04 fk17
109	1010243	1228039	2012-06-23	2013-01-04	6802274948010	1	1lj	0	0						0		Juvenile Book	-	395	j948
113	7643460	2958134	2014-03-25	2019-06-14	A000042382747	6	wtjeb	510	1				2014-05-19	2019-06-14	5	9780544142282	Juvenile Book	e	1699	easy
114	1010816	1983209	2012-06-23	2013-01-04	1011856-12001	1	2ga	0	0						0		Reference Book	o	1000	659.058 qs785 g
115	1010863	1983237	2012-06-23	2013-01-04	1011859-3001	1	2ga	0	0						0		Reference Book	o	1000	659.1 qs785
116	1010868	1983237	2012-06-23	2013-01-04	1011859-9001	1	2ga	0	0						0		Reference Book	o	129900	659.1 qs785
117	1010872	1983398	2012-06-23	2020-08-17	1043014946015	1	3aa	0	0						0	4118926733	Music Score	-	3500	m4.21858 p964 c3
118	1010938	1984235	2012-06-23	2013-01-04	1043026146018	1	3aa	0	0						0		Reference Book	o	400	709.2074 qa342 za
119	1010949	1984347	2012-06-23	2013-01-04	1043027246015	1	3aa	0	0						0	0899510523	Reference Book	o	400	779.074794 qo58
120	1011105	1985703	2012-06-23	2013-01-04	1043046553011	1	3gar	0	0						0		Reference Book	o	1400	929.377112 qr3232
121	1011078	1985403	2012-06-23	2013-01-04	1043042458017	1	2sa	0	0						0		Reference Book	o	1550	507 f46 .1
122	1011179	1986916	2012-06-23	2020-02-12	1043059405018	7	clar	0	0						1	1882203917	Reference Book	o	3495	027.477178 fp976 zf 2003
123	1011207	1986964	2012-06-23	2013-01-04	1043059858018	1	2sa	0	0						0		Reference Book	o	6000	507 f46
124	1011278	1987602	2012-06-23	2013-01-04	1043066346015	1	3aa	0	0						0		Reference Book	o	400	709.040074 c3921
125	1011304	1987841	2012-06-23	2013-01-04	1043068753010	1	3galr	0	0						0		Reference Book	o	400	977.211 qs642
126	1011652	1228613	2012-06-23	2013-01-04	0922177856015	1	3la	0	0						0	0842500790	Reference Book	o	1495	813.52 qb972 zp
127	1011692	1991269	2012-06-23	2013-01-04	1043111646013	1	3aa	0	0						0		Reference Book	o	400	709.2074 qm829 zm3
128	1011721	1228659	2012-06-23	2013-01-04	0922178953019	1	3ha	0	0						5	0393056295	Book	-	895	979.2 p485
130	1011803	1992230	2012-06-23	2013-01-04	1043123751017	1	1fa	0	0						11	0393049787	Book	-	2595	fiction
131	1011939	1004750	2012-06-23	2013-01-04	0503651249016	1	2ea	0	0						5		Reference Book	o	1550	277.46 g81
132	1011993	1993795	2012-06-23	2013-01-04	1043146658017	1	2sa	0	0						0		Reference Book	o	6000	507 f46
133	1012049	1994175	2012-06-23	2013-01-04	1043152358015	1	2sa	0	0						0		Reference Book	o	1550	507 f46
137	1012246	1995538	2012-06-23	2013-01-04	1043174058015	1	2sa	0	0						0		Reference Book	o	1550	507 f46
138	1012316	1228965	2012-06-23	2013-01-04	0922187656041	1	3la	0	0						0		Book	-	175	822 c874 bi
139	1012378	1996565	2012-06-23	2013-01-04	1043189558017	1	2sa	0	0						0	0821823264	Reference Book	o	6000	510.8 qa51 m
140	11007937	2341900	2020-12-28	2021-01-01	A000071211538	38	smamg	494	0	2020-12-31	2021-02-11	sm			1		Magazine	-	0	periodical
141	11007936	2341900	2020-12-28	2020-12-29	A000071211512	40	wtamg	0	0						0		Magazine	-	0	periodical
142	1012635	1229137	2012-06-23	2013-01-04	0922192358013	1	2sa	0	0						1		Book	-	500	629.2882 72.2

collection-2021-01-04

Custom SQL query returning 101 rows (hide)