If you do not understand the instructions below for searching the land sale records in the various ways mentioned, just search at the above url with the more simplified instructions at the site.

I think this will work to narrow down your search criteria to include just 1000 or fewer records. (Don't know if the 1000 record barrier can be broken.) The search site limits your search to a 1000 land records in one search so you need to narrow your search.

There are two ways: one uses the county search and the other uses the spisrch (Spiree free-form).

The key to both is to always include the field name in the search criteria along with at least the month and year in any date criteria specified. Computers are extremely fast but display a high degree of stupidity. You must always remind them as to what your talking about.

I use the following logical operators in my query relations:

            AND -- means that BOTH of the conditions to the left and right MUST be true in order to select.

                          County = 59 AND date = january 1830

                          -- Would select all transactions which are from Macoupin Co from the month of January 1830. BOTH conditions must hold.

           OR -- means only ONE of the conditions must be true to select. [either the one on the left or the one on right]

                          County = 59 or date = january 1830

                     -- Would select all transactions which occured in Macoupin CO from ANY DATE and all transactions from ANY COUNTY in the state during the month of january 1830.)

I use the following relational operators:

           >             Greater than                       (Does not include the start point)
           <             Less than                             (Does not include the start point)
           =             equal to
           >=          Greater than or equal to      (Includes the start point)
           <=          Less than or equal to           (Includes the start point)

Always be sure you use a field name to the left of every relational operator:  (i.e. county = 59, date <= january 1830, etc) and when using more than one field in a search condition always use a logical operator to seperate them. (i.e. county = 59 AND date < january 1830) The example would get a listing of all transactions from Macoupin which occurred prior to January of 1830.

The trick in limiting a search to a specific period of time is to remember that you must set a lower date limit and an upper date limit AND at the same time remember not to forget to include the field name EACH time you use a relational operator. For instance: to cover the year 1830 you must begin in january 1830 (lower limit) and end with december 1830 (upper limit). To express this as a search condition do the following:

                                date >= january 1830 and date <= december 1830

Notice that the field name is repeated each time a relational operator (i.e. >=, <=) is used. Note that >= and <= are used as opposed to > and < since we want to include the start and ending points." Also the two conditions are connected with the logical operator "AND."

Lets put it all together using some examples.

SPIREE FREE-FORM METHOD: To include the transactions for Macoupin CO during the year 1830. We are look for the following:
                      1. county = 59
                      2. date >= january 1830
                      3. date <= december 1830

It is expressed as this:

county = 59 and date >= january 1830 and date <= december 1830

Another simpler way to look at this is:
                      1. county = 59
                      2. date = 1830

And can be expressed as:

                      county = 59 and date = 1830

To include the transactions for Macoupin CO during the time period which includes March of 1845 through October of 1846. We look for:

                      1. county = 59
                      2. date >= march 1845
                      3. date <= december 1846

It is expressed as this:

county = 59 and date >= march 1845 and date <= october 1846

THE COUNTY SEARCH: This is basically the same as the SPISRCH search except that you do not need to include the "county =" and the search conditon. For instance the search for transactions in 1830 would be:

                       59 and date = 1830

The search for Mar 1845 through October 1846 would be:

                       59 and date >= march 1845 and date <= october 1846

Again, don't forget to include the field names before each relational operator
(i.e. >=, <=, =) and include the "and" to connect more than one condition.

David C. Arnsmeyer
email address:
Darnsmey@ix.netcom.com

contributed by Mark W. Strohbeck <strohmw@hotmail.com>

The attached list came from Bob Bailey of the Illinois State Archives in Springfield, Illinois. They are numeric codes used to indicate the Purchasers residence in the State of Illinois, Public Domain Land Tract Sales Archive at:
gopher://gopher.uic.edu/11/library/libdb/landsale/

These are for residences other than Illinois counties. Illinois county codes are available at the site. There may be other codes also.

865 Alabama
Alaska
Arizona
113 Arkansas
California
Colorado
866 Connecticut
135 Delaware
129 Florida
133 Georgia
Hawaii
Idaho
666 Indiana
999 Illinois
134 Iowa
889 Kansas
555 Kentucky
124 Louisiana
128 Maine
137 Maryland
123 Massachusetts
111 Michigan
Minnesota
138 Mississippi
888 Missouri
Montana
Nebraska
Nevada
425 New Hampshire
127 New Jersey
New Mexico
222 New York
300 North Carolina
North Dakota
444 Ohio
Oklahoma
Oregon
333 Pennsylvania
125 Rhode Island
110 South Carolina
South Dakota
777 Tennessee
Texas
Utah
136 Vermont
335 Virginia
Washington
West Virginia
139 Wisconsin
Wyoming
126 Canada
552 Baltimore
553 Boston
560 Carmi
446 Chillicothe(O)
562 Cahokia
103 Chicago
551 Cincinatti
132 Dist. of Columbia
563 Edwardsville
559 Kaskaskia
557 Louisville(KY)
558 Nashville(TENN)
445 New Harmony (IND)
556 New Orleans
550 Philidelphia
561 Pittsburg
200 N. Y. City
554 Shawneetown
112 St. Louis
564 Newark N. J.
565 Albany, NY
114 New Haven, Conn.
201 Buffalo, NY
203 Saratoga, NY
 
 

Macoupin County, Illinois Homepage