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.google.com 
test www.bluecoat.com 
test www.cnn.com 
test www.gov.uk 

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