The best way to find out the up-to-date category of a single URL is by checking https://sitereview.bluecoat.com.

If you have a long list of URLs, it might be too repetitive to do this one at a time on the site.

One simple alternative, is to test the URLs in the ProxySG command line.

1. Ensure the BCWF database is up-to-date.

2. Prepare a list like this: 
test www.example.com 
test www.example1.com 
test www.example2.com 
test www.example3.com 

3. Paste them in the CLI and you will get the following output:
ProxySG#(config content-filter)test www.example.com 
Testing URL 'http://www.example.com/' 
category: Search Engines/Portals 
ProxySG#(config content-filter)test www.example1.com 
Testing URL 'http://www.example1.com/' 
category: Technology/Internet 
ProxySG#(config content-filter)test www.example2.com 
Testing URL 'http://www.example2.com/' 
category: News/Media 
ProxySG#(config content-filter)test www.example3.com 
Testing URL 'http://www.example3.com/' 
category: Government/Legal