Hello all, For Eddiejo: Please forward this to the Database CINC. For Ellen: For the information of the W1812-List database guru, I have limited or delimited or done some other fool thing to the fields using commas (at least I think that is what I did). Please tell me, in terms a 3d grader can understand, what I need to do to this document to simplify your putting it into a database. I have lots more to come, so hurry. I have just been working on these microfilms from the LDS Library in Salt Lake. I have not finished yet, but will start this document anyway. This is from a series of microfilms, covering the entire nation. This is for New York with a small conclusion for New Jersey only. (My document 1 of 5 Cataloging New York Military Units in the War of 1812) LDS Film #'s 1715895 thru 1715899. NARA Microcopy No. T-817 Lists of the Adjutant General's Office for Carded Records of Military Organizations: Revolutionary War through Philippine Insurrection "The Ainsworth List" Roll 23 War of 1812 New York (Lists 27-84) LDS Microfilm # 1715895 War of 1812 Catalogue of Indexes Drawer No. 20 My explanation of abbreviations: Battn=Battalion, Regt=Regiment Arty=Artillery Inf=Infantry L. Inf=Light Infantry Mtd=Mounted Cav=Cavalry My comment: The unit names were enclosed with parentheses and some abbreviations contained apostrophes which I eliminated in the interest of saving typing time and archival space. I also rearranged some data fields to facilitate data management. (ie., all listings did not maintain the same order for the fields, I corrected this to allow sorting by fields. mvp Jan 2000). My comment: Guru, do not allow anyone to convince you to move the Commanders' names, which I have listed in the remarks field, into the unit name field. NARA does not put them there and all units are not named, and/or are not named after the current commander, so this would, in some cases, provide misinformation. That can be worse than no information. The fields may require additions, we'll see what I run into. Where a unit was listed as more than one type, I have added alpha subs to the number to allow the double listing for the same unit. (Fields: no, unit no., unit name, unit type, remarks1, remarks2, remarks3 New Jersey (concluded) 4., , Abraham's Regt, Mil 5., , Andruss' Battn, Vols,,,1814 6., , Andruss' Detachment, Mil,,,1812 7., , Howell's Regt, Mil 8., , Jackson's Regt, Mil 9., , Potter's Command, Mil 10., , Read's Battn, Mil 11., , Bilderbach's Detachment, Vols, 1 Troop of Horse 12., , Maj. Gen. Shinn and Staff, Mil 13a., , Colfax's Brigade, Vols 13b., , Colfax's Brigade, Mil 14., , Elmer's Brigade, Mil 15., , Various Organizations New York (Fields: no, unit no., unit name, unit type, remarks1, remarks2, remarks3 1., 1 Battn, Late 9 Regt, , Arty 2., 1 Regt, Belknaps, Mil 3., 1 Regt, Blooms, Mil 4., 1 Regt, Davis', Mil 5., 1 Regt, Dodge's, Mil 6., 1 Regt, Harris', Mil 7., 1 Regt, Hopkins', Mil 8., 1 Regt, Laight's, Mil 9., 1 Regt, Nellis', Mil 10., 1 Regt, Sitcher's, Vol, Arty 11., 1 Regt, Van Beuren's, Mil 12., 2 Regt, , , Arty, Lt. Col. Peter Curtenius,1812 13., 2 Regt, , , Arty, Lt. Col, Horatio G. Stevens, 1814 14., 2 Regt, Bedell's, Mil 15., 2 Regt, Delameter's, Mil 16., 2 Regt, Dobbin's, Mil 17., 2 Regt, Dutton's, Mil 18., 2 Regt, Hawkins', Vols, Arty 19., 2 Regt, Mapes', Mil 20., 2 Regt, Swift's, Mil 21., 2 Regt, Van Hook's, Mil 22., 2 Regt, Ward's, Mil 23., 3 Regt, ,,Arty, Lt. Col. Andrew Sitcher, 1812 24., 3 Regt, ,,Arty, Lt. Col. Jos. O. Bogart, 1814 25a., 3 Regt,,,Arty,and L. Inf.,1813 25b., 3 Regt,,,L. Inf.,and Arty,1813 26., 3 Regt, Case's, Mil 27., 3 Regt, Denniston's, Vols 28., 3 Battn, Robert's, Mil 29., 3 Regt, Smith's, Mil 30., 3 Regt, Van Renssalaer's, Mil 31a., 3 Regt, Golden's, Mil, Arty, and Inf 31b., 5 Regt, Golden's, Mil, Inf, and Arty 32., 6 Regt, ,,Arty, Lt. Col. Stephen Thorn 33., 6 Regt, Cooley's, Mil, Arty 34., 6 Regt, , Mil, Mtd. Dragoons 35., 7 Regt,, Mil 36., 7 Regt,,,Arty, 1812 37., 7 Regt,,,Arty, Jul-Aug 1812 38., 7 Regt,,,Arty, Lt. Col. Walter Grieve, 1812 39., 7 Regt, Green's, Mil 40., 8 Regt, Miller's, Mil 41., 9 Regt 42., 9 Regt, , , Arty, Lt. Col. Simon Fleet 43., 9 Regt, Joiner's, Mil 44., 9 Regt, Vosburgh's, Mil 45., 10 Regt, Prior's, Mil 46., 11 Regt, , , Arty, Lt. Col. Harsen, 1812 47., 11 Regt, , Mil, , Jul - Aug 1812 48., 11 Regt, , , Arty, Lt. Col Harsen, 1814 49., 11 Regt, Rich's, Mil May 9, 1904 m. a. g. (transcribing archivists initials and date) Document 1 of 5 Cataloging New York Military Units for the War of 1812. Transcribed from a paper copy made from the microfilm on 14 Jan 2000 by Marianne Victory Purdy for use by War of 1812 List at rootsweb.com. Proofread by Marianne Victory Purdy End document 1 of 5 Good Hunting Marianne Victory Purdy Check my genes at: http://freepages.genealogy.rootsweb.com/~mariannevictorypurdy/