Sample Searches

Basic I Advanced

Performing a Basic Search

This search function of the ECPP database is structured around the individual records the missionaries created to document the administration of every baptism, marriage, and burial they performed in the California missions. To perform a Basic Search, first select a record type: Baptismal, Marriage, or Burials (Death). After selecting a record type, choose one of the corresponding search criterion for the selected record type. The search may be refined by adding up to 9 search criteria.

In the Basic Search you may also search for information contained in the record type subsets: the Godparents (baptism), Witnesses (marriage) and Relatives (baptism) table, however, most users will find the majority of information they seek in the baptism, marriage, or burial registers.

In the following sample search, the user is searching for a Baptismal record of Mariano Castro:

1. Select "Baptismal" under Record Type.

2. Select the criterion, "Ego's Spanish Name" and enter "Mariano."

3. Add the clause "and" and then select the second criterion, "Ego's Surname" and enter "Castro."

4. Click Find to view the results. Four records were retrieved matching the criteria. Click View in the Details column to view individual records.

5. Individual record.

Performing an Advanced Search

The ECPP provides two ways to search for records--a Basic Search described above, and an Advanced Search.  Whereas the Basic Search restricts your query to one table at a time, the Advanced Search allows you to create a search that combines fields from two tables.  Tables can only be joined by fields that have the same content in both tables; if this were not the case, the query would produce records that blend information relating to more than one individual.  To illustrate this process, a sample census report has been created showing how to create a report joining the Baptism and Death Tables. 


This report, which can be modified for other missions and years, allows users to find the approximate population of Mission San Carlos on January 1, 1800.  Note: This Advanced Search produces a final report that shows only the individuals baptized at Mission San Carlos who were linked to a burial at Mission San Carlos.  It does not include individuals who were baptized before 1/1/1800 and were buried at another mission, and it only includes people with known burial dates.  Also, this query produces the names of soldiers and settlers who may not have actually resided at San Carlos yet who were baptized and buried there.  For instance, individuals who lived on an adjacent rancho might appear in the records even though they did not actually live at the mission.


In this sample search, the Baptism table is used to select records of the individuals baptized at Mission San Carlos on or before January 1, 1800.  The Death table is then used to limit the results of the query to individuals who died after January 1, 1800 at San Carlos. 


1.  Click the Data Sources tab.  Under Table first select Baptisms, then select Deaths.  To join these tables, use the pull down menu under Join Field and click on Egos Linked Baptism.  This selects that field from the Baptism table.  Under Field, use the drop down menu and select Record Number, which is the equivalent field in the Deaths table.  Leave Join Type as the default.



2.  Next, choose fields to be incorporated into your final report.  To do this, Click the Fields tab.  In this sample, ego's full name, ethnicity, baptism mission, baptism number, baptism date and burial date have been selected.  To sort by Egos Spanish Name, check the box under Sort (A).  (A for ascending; D for descending.)



For this census report, individuals must have been baptized on or before January 1, 1800.  To filter for these individuals, Click the Filters tab.  Under Filter Field, select Egos Baptism Date (formatted).  Under Operator, select Isn't Greater Than and insert the Value(s).  In this case, 1/1/1800. 


3.  Next, restrict the search to individuals who would have been alive at that time by filtering for those only who died after 1/1/1800.  Keep in mind some burial dates were unstated or that some individuals had a partial burial date that could not be formatted.  Under Filter Field, select Burial Date (formatted), under Operator, select Blank to include any blank formatted burial dates.  Under Filter Field, select Burial Date (formatted) again.  This time, under Operator, click Is Greater Than and insert 1/1/1800 under Value(s).  This will eliminate any burials before this date.


4.  Finally, to assure that these individuals were baptized at Mission San Carlos, died at Mission San Carlos, and that the burials were linked to Mission San Carlos, filter for these as shown below.




5.  Click the Summary tab.  To get a count of the approximate population at Mission San Carlos on January 1, 1800, enter any field that is sure to have text in it and can be counted.  Because every record has a record number, it is an appropriate choice for the Count function. Under Field use the pull down menu and click on Record Number. The Description and Function will automatically be populated.




6.  Click the Preview tab to see the final report, which should appear as shown below.  Note:  To show the full report you must select All under the Results function.

For additonal search guidelines and database attributes, please visit the User Guide.


back to top


2006, Huntington Library. All rights reserved.
The Huntington Library, Art Collections, and Botanical Gardens
1151 Oxford Road, San Marino, CA 91108 Tel: 626-405-2100
Contact us