California Wildfire Contact and Organization Advanced Searches

Nick Mills
Nick Mills Blackbaud Employee
Eighth Anniversary Kudos 1 Name Dropper Participant
in Blackbaud Grantmaking™ General Discussions

Good afternoon,

In light of the wildfires currently devastating the Los Angeles area, we have written two Advanced Searches that can be used to locate Contacts and Organizations in your database that have an address in one of the affected Zip Codes.

These lists could then be used for communications about any emergency relief programs your organization may be running, or simply to reach out to affected individuals and organizations to see how you might offer assistance.

Please note: The list of affected zip codes came from https://safeguardproperties.com/california-wildfires-information-updated-fire-maps/ and appears to have been last updated on January 8, 2025. If additional zip codes are affected, these advanced searches will need to be modified to add new zip codes. You can easily add additional zip codes by adding the 5-digit zip code between two single quotes/apostrophes (e.g. ‘xxxxx’) and adding that value to the comma separated list (e.g. ‘91189’,’91199’,’xxxxx’).

For adding a zip code for Contacts, make sure you’re adding in your additional value to ALL 4 groupings of zip codes. Organizations only have one comma-separated list to modify.

For Contacts:

  1. Click the Full Search link in the upper right-hand corner of the Grantmaking screen
  2. Click Contacts on the left side of the screen
  3. Click the Advanced link in the lower right-hand corner of the pop-up screen
  4. Paste the following code into the Advanced box and click the Search button:

Primary_Mailing_Address.Zip_Postal_Code in ('90263','90272','90290','91342','91344','91392','91001','91003','91011','91012','91020','91021','91024','91025','91101','91102','91103','91104','91105','91106','91107','91108','91109','91110','91114','91115','91116','91117','91121','91123','91124','91125','91126','91129','91182','91184','91185','91188','91189','91199') OR Office_Address.Zip_Postal_Code IN ('90263','90272','90290','91342','91344','91392','91001','91003','91011','91012','91020','91021','91024','91025','91101','91102','91103','91104','91105','91106','91107','91108','91109','91110','91114','91115','91116','91117','91121','91123','91124','91125','91126','91129','91182','91184','91185','91188','91189','91199') OR Home_Address.Zip_Postal_Code IN ('90263','90272','90290','91342','91344','91392','91001','91003','91011','91012','91020','91021','91024','91025','91101','91102','91103','91104','91105','91106','91107','91108','91109','91110','91114','91115','91116','91117','91121','91123','91124','91125','91126','91129','91182','91184','91185','91188','91189','91199') OR Alternate_Address.Zip_Postal_Code IN ('90263','90272','90290','91342','91344','91392','91001','91003','91011','91012','91020','91021','91024','91025','91101','91102','91103','91104','91105','91106','91107','91108','91109','91110','91114','91115','91116','91117','91121','91123','91124','91125','91126','91129','91182','91184','91185','91188','91189','91199')

For Organizations:

  1. Click the Full Search link in the upper right-hand corner the Grantmaking screen
  2. Click Organizations on the left side of the screen
  3. Click the Advanced link in the lower right-hand corner of the pop-up screen
  4. Paste the following code into the Advanced box and click the Search button:

Addresses.Zip_Postal_Code IN ('90263','90272','90290','91342','91344','91392','91001','91003','91011','91012','91020','91021','91024','91025','91101','91102','91103','91104','91105','91106','91107','91108','91109','91110','91114','91115','91116','91117','91121','91123','91124','91125','91126','91129','91182','91184','91185','91188','91189','91199')

Categories