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

157,549 rows

View and edit SQL

Link rowid ▼ hold_id bib_record_num campus_code record_type_on_hold item_record_num volume_record_num placed_gmt is_frozen delay_days location_code expires_gmt hold_status is_ir is_ill pickup_location_code ir_pickup_location_code ir_print_name ir_delivery_stop_name is_ir_converted_request patron_is_active patron_ptype_code patron_home_library_code patron_mblock_code patron_has_over_10usd_owed
1 2707601 2621589   j   1386395 2013-01-21 16:11:15.000000 1 255     on hold 0 0 hp       0 1 0 hp - 0
2 2707604 2621589   j   1366848 2013-01-21 16:11:23.000000 1 255     on hold 0 0 hp       0 1 0 hp - 0
3 3473847 2621589   j   1386395 2013-03-11 19:09:43.000000 1 255     on hold 0 0 ch       0 1 0 pr - 0
4 3473848 2621589   j   1366848 2013-03-11 19:09:51.000000 1 255     on hold 0 0 ch       0 1 0 pr - 0
5 3473856 2823181   j   1401384 2013-03-11 19:10:11.000000 1 255     on hold 0 0 ch       0 1 0 pr - 0
6 4567573 2874477   b     2013-05-31 17:18:26.801000 1 255     on hold 0 0 cl       0 1 0 cl - 0
7 4917362 2621589   j   1386395 2013-06-22 16:27:55.000000 1 255     on hold 0 0 gr       0 1 0 gr - 0
8 4917366 2621589   j   1366848 2013-06-22 16:28:02.000000 1 255     on hold 0 0 gr       0 1 0 gr - 0
9 5661505 2676823   j   1363190 2013-08-08 17:20:58.000000 1 255     on hold 0 0 ba       0 1 0 ba - 0
10 6227057 2882648   j   1409536 2013-09-14 10:39:37.000000 1 255     on hold 0 0 cl       0 1 0 cl - 0
11 6227059 2882648   j   1409537 2013-09-14 10:39:51.000000 1 255     on hold 0 0 cl       0 1 0 cl - 0
12 8027067 2882648   j   1409536 2014-01-13 17:09:14.000000 1 255     on hold 0 0 sh       0 1 0 sm - 0
13 8314345 2927476   b     2014-01-31 11:26:51.155000 1 255     on hold 0 0 dt       0 1 0 dt - 0
14 8752867 2944390   b     2014-03-01 00:16:26.205000 1 255     on hold 0 0 ba       0 1 0 ba - 0
15 8790238 2944398   b     2014-03-03 13:10:09.802000 1 255     on hold 0 0 ha       0 0 0 mn - 0
16 8792803 2944400   b     2014-03-03 13:45:51.918000 1 255     on hold 0 0 ha       0 0 0 mn - 0
17 9063249 2663146   j   1364174 2014-03-20 18:24:41.000000 1 255     on hold 0 0 ba       0 1 0 dp - 0
18 9063254 2663146   j   1364175 2014-03-20 18:24:49.000000 1 255     on hold 0 0 ba       0 1 0 dp - 0
19 9578761 2965366   b     2014-04-25 16:04:14.666000 1 255     on hold 0 0 ba       0 1 0 ba - 0
20 9578940 2965366   b     2014-04-25 16:04:46.285000 1 255     on hold 0 0 ha       0 0 0 mn - 0
21 9581428 2965371   b     2014-04-25 16:29:44.030000 1 255     on hold 0 0 ha       0 0 0 mn - 0
22 9582257 2965371   b     2014-04-25 16:31:48.604000 1 255     on hold 0 0 dp       0 1 0 sh - 0
23 9584582 2965375   b     2014-04-25 16:54:46.258000 1 255     on hold 0 0 sh       0 1 0 sh - 0
24 10050816 2970440   b     2014-05-29 13:20:13.894000 1 255     on hold 0 0 mm       0 1 0 mm - 0
25 10051332 2970440   b     2014-05-29 13:21:29.295000 1 255     on hold 0 0 an       0 1 0 an - 0
26 10052343 2970441   b     2014-05-29 13:59:31.005000 1 255     on hold 0 0 ma       0 1 22 ma - 0
27 10253415 2929408   j   1415583 2014-06-11 13:43:02.000000 1 255     on hold 0 0 1       0 0 0 1 - 0
28 10253423 2929408   j   1415584 2014-06-11 13:43:12.000000 1 255     on hold 0 0 1       0 0 0 1 - 0
29 10253426 2929408   j   1415585 2014-06-11 13:43:18.000000 1 255     on hold 0 0 1       0 0 0 1 - 0
30 10504861 2975034   b     2014-06-27 15:56:42.275000 1 255     on hold 0 0 mt       0 1 0 mt - 0
31 10505308 2975035   b     2014-06-27 15:58:57.269000 1 255     on hold 0 0 hp       0 1 0 mo - 0
32 10505456 2975035   b     2014-06-27 15:59:30.701000 1 255     on hold 0 0 dt       0 1 0 dt - 0
33 10505748 2975035   b     2014-06-27 16:00:01.434000 1 255     on hold 0 0 mt       0 1 0 mt - 0
34 10708835 2978792   b     2014-07-11 12:45:50.020000 1 255     on hold 0 0 cl       0 1 0 cl - 0
35 10708885 2978792   b     2014-07-11 12:45:56.614000 1 255     on hold 0 0 ba       0 1 0 ba - 0
36 10895575 2980693   b     2014-07-23 13:54:38.893000 1 255     on hold 0 0 ba       0 1 0 ba - 0
37 10895693 2980693   b     2014-07-23 13:54:54.895000 1 255     on hold 0 0 ma       0 1 0 ba - 0
38 10895934 2980693   b     2014-07-23 13:55:22.657000 1 255     on hold 0 0 an       0 1 0 an - 0
39 10897803 2980693   b     2014-07-23 13:59:43.207000 1 255     on hold 0 0 wy       0 0 0 wy - 0
40 10912328 2980697   b     2014-07-24 09:42:23.890000 1 255     on hold 0 0 wy       0 0 0 wy - 0
41 10912495 2980697   b     2014-07-24 09:42:57.639000 1 255     on hold 0 0 ma       0 1 0 ba - 0
42 10913440 2980697   b     2014-07-24 09:45:09.240000 1 255     on hold 0 0 mm       0 1 0 ma - 0
43 10919932 2980699   b     2014-07-24 11:01:58.166000 1 255     on hold 0 0 an       0 1 0 an - 0
44 10921356 2980699   b     2014-07-24 11:05:09.694000 1 255     on hold 0 0 ma       0 1 0 ba - 0
45 10921886 2980699   b     2014-07-24 11:06:28.060000 1 255     on hold 0 0 mm       0 1 0 ma - 0
46 10923536 2980700   b     2014-07-24 11:45:50.286000 1 255     on hold 0 0 wy       0 0 0 wy - 0
47 11231028 1978166   b     2014-08-13 09:09:21.000000 1 255     on hold 0 0 dt       0 0 22 1 - 0
48 11348184 2929408   j   1415583 2014-08-20 15:29:23.000000 1 255     on hold 0 0 fo       0 1 0 fo - 0
49 11348194 2929408   j   1415584 2014-08-20 15:29:46.000000 1 255     on hold 0 0 fo       0 1 0 fo - 0
50 11576099 2985444   b     2014-09-04 09:47:09.296000 1 255     on hold 0 0 fo       0 1 0 fo - 0
51 11577448 2985445   b     2014-09-04 09:56:11.724000 1 255     on hold 0 0 ba       0 1 0 ba - 0
52 11577595 2985445   b     2014-09-04 09:56:43.086000 1 255     on hold 0 0 ge       0 1 0 ge - 0
53 12105184 2992960   b     2014-10-07 17:57:02.000000 1 255     on hold 0 0 cl       0 1 0 cl - 0
54 12675158 3007050   b     2014-11-13 14:53:59.866000 1 255     on hold 0 0 mm       0 1 0 ma - 0
55 12793340 3012608   b     2014-11-21 10:14:34.352000 1 255     on hold 0 0 ge       0 1 0 ge - 0
56 12793422 3012608   b     2014-11-21 10:14:40.192000 1 255     on hold 0 0 ba       0 0 0 ba - 0
57 12800991 3012612   b     2014-11-21 12:17:24.291000 1 255     on hold 0 0 mm       0 1 0 ma - 0
58 12805450 3012614   b     2014-11-21 12:50:23.516000 1 255     on hold 0 0 ge       0 1 0 ge - 0
59 12805683 3012614   b     2014-11-21 12:50:46.821000 1 255     on hold 0 0 ba       0 1 0 ba - 0
60 12816649 3012625   b     2014-11-21 14:19:58.550000 1 255     on hold 0 0 mm       0 1 0 mm - 0
61 12816822 3012625   b     2014-11-21 14:20:27.740000 1 255     on hold 0 0 ba       0 1 0 ba - 0
62 12818541 3012639   b     2014-11-21 14:29:49.666000 1 255     on hold 0 0 sh       0 0 0 gr - 0
63 13051990 2980720   b     2014-12-08 19:43:02.000000 1 255     on hold 0 0 dt       0 1 0 dt - 0
64 13427440 2660651   b     2015-01-06 16:24:38.000000 1 255     on hold 0 0 an       0 0 0 an - 0
65 13479222 3019999   b     2015-01-09 14:11:59.194000 1 255     on hold 0 0 sm       0 1 0 lv - 0
66 13481127 3020000   b     2015-01-09 14:33:15.763000 1 255     on hold 0 0 ba       0 0 0 ba - 0
67 13481172 3020000   b     2015-01-09 14:33:23.994000 1 255     on hold 0 0 an       0 1 0 an - 0
68 13488130 3020033   b     2015-01-09 16:55:56.312000 1 255     on hold 0 0 ba       0 1 0 ba - 0
69 13488498 3020087   b     2015-01-09 17:04:05.688000 1 255     on hold 0 0 1w       0 1 0 1w - 0
70 13488700 3020087   b     2015-01-09 17:04:24.391000 1 255     on hold 0 0 ba       0 0 0 ba - 0
71 13798328 3021878   b     2015-01-28 13:44:57.798000 1 255     on hold 0 0 an       0 1 0 an - 0
72 13799552 3021878   b     2015-01-28 13:47:37.997000 1 255     on hold 0 0 sm       0 1 0 sm - 0
73 14325041 3029772   b     2015-03-03 13:20:25.430000 1 255     on hold 0 0 sm       0 1 0 sm - 0
74 14325794 3029774   b     2015-03-03 13:24:41.332000 1 255     on hold 0 0 1w       0 1 0 1w - 0
75 14326444 3029774   b     2015-03-03 13:26:02.236000 1 255     on hold 0 0 sm       0 1 0 sm - 0
76 14412194 2681454   b     2015-03-09 11:16:39.000000 0 0     on hold 0 0 cv       0 0 0 cvw c 1
77 14504497 2156839   j   1432267 2015-03-15 13:21:10.000000 0 0     on hold 0 0 co       0 0 0 gr - 0
78 14770438 3037243   b     2015-04-02 11:29:00.349000 1 255     on hold 0 0 ba       0 1 0 ba - 0
79 14770615 3037243   b     2015-04-02 11:29:25.147000 1 255     on hold 0 0 1w       0 1 0 1w - 0
80 14771342 3037243   b     2015-04-02 11:31:08.426000 1 255     on hold 0 0 1w       0 1 0 1 - 0
81 14771398 3037243   b     2015-04-02 11:31:13.252000 1 255     on hold 0 0 an       0 1 0 an - 0
82 14772999 3037241   b     2015-04-02 11:39:23.846000 1 255     on hold 0 0 1w       0 1 0 1 - 0
83 14773082 3037241   b     2015-04-02 11:39:37.301000 1 255     on hold 0 0 an       0 1 0 an - 0
84 14773140 3037241   b     2015-04-02 11:39:48.831000 1 255     on hold 0 0 wh       0 1 0 wh - 0
85 14773762 3037241   b     2015-04-02 11:41:21.952000 1 255     on hold 0 0 an       0 1 0 an - 0
86 14773792 3037241   b     2015-04-02 11:41:23.301000 1 255     on hold 0 0 gr       0 0 22 gr - 0
87 14779942 3037209   b     2015-04-02 13:58:19.797000 1 255     on hold 0 0 lv       0 1 0 lv - 0
88 14780637 3037214   b     2015-04-02 14:08:04.013000 1 255     on hold 0 0 1       0 1 0 ww - 0
89 14941029 3029884   j   1440981 2015-04-14 16:26:03.000000 1 255     on hold 0 0 wh       0 1 0 pl - 0
90 15160212 3043383   b     2015-04-29 16:26:53.943000 1 255     on hold 0 0 mt       0 1 0 mt - 0
91 15160411 3043383   b     2015-04-29 16:27:32.423000 1 255     on hold 0 0 sm       0 1 0 sm - 0
92 15236296 3044474   b     2015-05-05 17:53:23.142000 1 255     on hold 0 0 ba       0 1 0 ba - 0
93 15236730 3044474   b     2015-05-05 17:54:25.409000 1 255     on hold 0 0 an       0 1 0 an - 0
94 15397067 3043199   b     2015-05-18 12:47:37.000000 1 255     on hold 0 0 co       0 0 0 co - 0
95 15397098 3019999   b     2015-05-18 12:48:55.000000 1 255     on hold 0 0 co       0 0 0 co - 0
96 15614476 3049030   b     2015-06-02 16:36:40.456000 1 255     on hold 0 0 1       0 1 0 1 - 0
97 15628005 3049026   b     2015-06-03 13:38:04.154000 1 255     on hold 0 0 1       0 1 0 1 - 0
98 15628303 3049026   b     2015-06-03 13:38:55.164000 1 255     on hold 0 0 sm       0 1 0 sm - 0
99 15632740 3049032   b     2015-06-03 15:02:33.507000 1 255     on hold 0 0 ba       0 1 0 ba - 0
100 15635865 3049034   b     2015-06-03 15:20:32.811000 1 255     on hold 0 0 md       0 1 0 md - 0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE hold (
	hold_id INTEGER, 
	bib_record_num INTEGER, 
	campus_code TEXT, 
	record_type_on_hold TEXT, 
	item_record_num INTEGER, 
	volume_record_num INTEGER, 
	placed_gmt DATETIME, 
	is_frozen BOOLEAN, 
	delay_days BIGINT, 
	location_code TEXT, 
	expires_gmt DATETIME, 
	hold_status TEXT, 
	is_ir BOOLEAN, 
	is_ill BOOLEAN, 
	pickup_location_code TEXT, 
	ir_pickup_location_code TEXT, 
	ir_print_name TEXT, 
	ir_delivery_stop_name TEXT, 
	is_ir_converted_request BOOLEAN, 
	patron_is_active BOOLEAN, 
	patron_ptype_code INTEGER, 
	patron_home_library_code TEXT, 
	patron_mblock_code TEXT, 
	patron_has_over_10usd_owed BOOLEAN
);
CREATE UNIQUE INDEX pk_hold ON hold (hold_id);
CREATE UNIQUE INDEX uc_hold_composite ON hold (hold_id, bib_record_num, placed_gmt);