Working with Custom Filters in the Data Web (Helpful Hint)

Selecting multiple categories

A filter in the form "EIN IN ('01223344','023343543'...)" is MUCH more efficient than "EIN='01223344' OR EIN = '023343543'...". One test found that the former approach with a list of 73 EINs took 3 seconds to complete, while the latter took 150 seconds.

This form can be used to select multiple ZIP codes (ZIP5 IN ('20036','20037...)) county FIPS codes, states, NTEE codes, etc.

Working with Wildcards

To select all records with 'CHILD' in the name:


Added 07/21/2003 by tpollak, Modified 06/05/2006 by jauer


No comments.

Please login to add your own comments.