|The Coffelt Database can be searched by Name, Unit of Assignment, and/or Date Range.|
If you haven't read the instructions below,
please do so before starting a search.
| Name Searches || Date Searches ||Ground Forces || Aviation Units || Naval Forces |
No search will return more than 100 returned records. If your search exceeds this limit, you will get a message like
There are 349 qualifying records.
Return to the Search entry page and refine your search
If this occurs, return to the search entry page and take appropriate action to reduce the scope of your search. For example, a Name search on 'JONES' will result in a warning that there are 349 qualifying records. In this case, you can limit the search scope by simply adding a first name or initial. 'J' 'JONES' results in 59 qualifying records, which will be displayed. Note: SURNAME-ONLY searches will fail if there are more than 10 qualifying records.Except for Name searches, either one or two specific dates must be entered. If you do not include at least one date, the search will fail.
Name searches are pretty straight-forward ... you enter a first name or initial and a last name. However, the search program requires that the last name in entered in full - it must be exact. If you want DAVISON, you have to enter exactly that ... a search on DAVIS will not include the DAVISONs. Partial first names can be used, though.
With a Date search you can enter either a single date or a date range with specific starting and ending dates. You can also limit the search to a specific Service branch (i.e., Army, Navy, etc) in order to limit the search scope.
Unit of Assignment searches will automatically include Unit casualties within a 20-day window centered on the specified date. If you do not enter the 'CENTER' date, the search will fail.Unit searches are more difficult because the user must use the same abbreviations that we use - but you probably don't know what we use. Common abbreviations used with ground forces include
1ST INF DIV, 3RD MARDIV
Usually like 173RD ABN BDE and 199TH INF BDE, but 1ST AVIATION BDE is spelled out. USMC: 9TH MAB.
16TH INFANTRY, 26TH ARTILLERY, 1ST MARINES, 12TH AVN GRP
1ST BN, 1ST ENG BN, 1ST TANK BN, 2ND SQDN (Cavalry)
SeaBees are in NMCB-xx
HHC, A CO, B TRP, C BTRY
|Numbered Army units ||192ND AHC |
|452ND TRANS CO ||12TH AVN BN |
| || To ease this problem partial entries are accepted, so if you enter the letter "A" in the Company field you'll get "A Co" or "A Btry" as might be the case. The same is true for other fields - for instance, entering "26TH" in the Regiment field will retrieve the 26th Marines, 26th Infantry, and 26th Artillery, but entering "26TH M" is sufficient to limit results to the 26th Marines; "26TH I" will retrieve only people from the 26th Infantry; and "26TH A" will limit the result to members of the 26th Artillery.The use of partial entries can be very helpful, since many Army and Air Force units were redesignated while in Vietnam - but quite commonly the unit's number stayed the same. As an example, the "123rd Transportation Company" might have become the "123rd Aviation Company" and later still been redesignated again as the "123rd Assault Helicopter Company". A search for "123RD TRANS CO" would get the first group, "123RD AVN CO" the second, and "123RD AHC" the third ... but "123RD" by itself would get all of them (it would also get the "123RD MAINT CO", should there have been such a thing).Remember that case is not important - for our purposes "TRANS CO" and "trans co" are the same.Unit searches are divided into three types:GROUND FORCES, where the unit is specified by some combination of Company, Battalion, Regiment, Brigade, Division, and/or Major Organization.|
This search should be used for Army, Divisional Marines and Navy, and Navy SeaBees. As with Date searches, you can limit the search to a specific Service branch.
NAVY, MARINE, and AIR FORCE AVIATION UNITS, where the unit is specified by some combination of Squadron, Air Group, Air Wing, and/or Major Organization.
As with Date searches, you can limit the search to a specific Service branch.
NAVAL FORCES, where the unit is specified by some combination of Ship, Task Group, Task Force, and/or Major Organization.
Unlike the other Unit searches, this one captures all service branches in order to include Marines serving aboard ship and Air Force exchange officers flying with the Navy. This search will include aviation personnel (if any) assigned to the specified unit.
| Name Searches || Date Searches ||Ground Forces || Aviation Units || Naval Forces
© Copyright by The Coffelt Group 2003-2019
Page written on 25 Mar 2019