text: INSERT INTO media VALUES ("ltr_tip1952","letter","1777-09-30","Skippack","PA","US","Tim","Pickering",NULL,"Anthony","Wayne",NULL,"individual",NULL,"Tim Pickering letter to Anthony Wayne","ltr_tip1952.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,34,0);
  INSERT INTO media VALUES ("ltr_tip2085","letter","1795-08-25","Philadelphia","PA","US","Timothy","Pickering",NULL,"John Quincy","Adams",NULL,"individual",NULL,"The first part of the business, for which you are called to London by my letter of the 14 instant, is the exchange of ratifications of the late treaty between the United States and Great Britain.","ltr_tip2085.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,33,0);
  INSERT INTO media VALUES ("ltr_tip2109","letter","1796-06-00","Philadelphia","PA","US","Timothy","Pickering",NULL,"John Quincy","Adams",NULL,"individual",NULL,"the President with the advice and consent of the Senate of the United States, has appointed you their Minister Plenipotentiary to Portugal...","ltr_tip2109.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,33,0);
  INSERT INTO media VALUES ("ltr_tip3700","letter","1780-08-11","Philadelphia","PA","US","Timothy","Pickering","","George","Washington","","individual","","You will doubtless, ere this reaches you, have been informed that Congress have been pleased to appoint me Quartermaster-General.","ltr_tip3700.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_tip3701","letter","1781-02-18","Newburg","","US","Timothy","Pickering","","George","Washington","","individual","","General Knox informed me, to-day, that no artillery was to go from hence. I had previously ordered fifty draught-horses to be impressed for transporting the artillery, ammunition, and tents.","ltr_tip3701.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_tip3702","letter","1781-04-14","Newburg","","US","Timothy","Pickering","","George","Washington","","individual","","I had the honor to inform you, on my return from Philadelphia, of what passed there relative to the means of procuring the numerous supplies requisite in my department for the ensuing campaign -  and was unhappy that no prospect was presented of my ob","ltr_tip3702.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_tip3703","letter","1781-07-00","","","US","Timothy","Pickering","","George","Washington","","individual","","General Knox has called on me to-day, respecting a provision of horses for the light artillery. I have authorized Colonel Hughes to purchase one hundred for that service only","ltr_tip3703.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_tip3704","letter","1781-10-05","","","US","Timothy","Pickering","","George","Washington","","individual","","I immediately waited on the Intendant with Count Chastellux's letter, reciting the agreement he had made with me respecting the future employment of the vessels, and desiring him to pay me two thousand dollars","ltr_tip3704.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_tip3705","letter","1781-10-23","","","US","Timothy","Pickering","","George","Washington","","individual","","At Gloucester the dragoon horses, with their accoutrements, and the wagonhorses and wagons, were delivered up that day, and the whole committed by Colonel Dearborn to militia guards.","ltr_tip3705.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_tip3706","letter","1782-02-08","Philadelphia","PA","US","Timothy","Pickering","","George","Washington","","On considering the mode m","","description","ltr_tip3706.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_tip3707","letter","1782-02-23","Philadelphia","PA","US","Timothy","Pickering","","George","Washington","","individual","","Your Excellency advised that the ox-teams should be assembled by the middle of May last year. I would request your direction for the present year on this head. The longer their assembling is delayed, consistent with the expected operations, the bette","ltr_tip3707.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_tip3708","letter","1783-01-18","Newburg","","US","Timothy","Pickering","","George","Washington","","individual","","Your Excellency had but just left my quarters this evening, when a Deputy-Sheriff of Ulster arrested me. He showed me a writ, of which I beg leave to inclose a copy.","ltr_tip3708.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_tip3709","letter","1782-05-29","Philadelphia","PA","US","Timothy","Pickering","","George","Washington","","individual","","While the Financier held up to my view the prospect of supplies, I presented the same to Colonel Hughes and at my own office, and thereby kept alive the hopes of the public creditors","ltr_tip3709.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_tip4000","letter","1814-10-22","Washington","MD","US","Timothy","Pickering","","John","Jay","","individual","","While the proposition respecting an Indian boundary was declared to be a sine qua non, the boundary itself admitted of modification -  and as within it, we are called upon to relinquish only our right of pre-emption","ltr_tip4000.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,37,0);
  INSERT INTO media VALUES ("ltr_tip4300","letter","1790-12-31","Philadelphia","PA","US","Timothy","Pickering","","George","Washington","","individual","","I have this moment received and read your very obliging letter of this date, expressing your entire approbation of my conduct in the conference, which, by your orders, I have lately held with the Seneca Indians.","ltr_tip4300.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,60,0);
  INSERT INTO media VALUES ("ltr_tip4301","letter","1791-01-15","Philadelphia","PA","US","Timothy","Pickering","","George","Washington","","individual","","General Knox informed me, that it would be agreeable to you that I should undertake the Superintendency of the northern Indians -  I mean particularly the Six Nations.","ltr_tip4301.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,60,0);
  INSERT INTO media VALUES ("ltr_tip4302","letter","1796-07-27","Philadelphia","PA","US","Timothy","Pickering","","George","Washington","","individual","","Mr. Donaldson had gone to Leghorn with orders from Mr. Barlow to transmit two hundred thousand dollars to Algiers, which would procure the redemption of our captive citizens","ltr_tip4302.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,60,0);
  INSERT INTO media VALUES ("ltr_tip4950","letter","1763-02-14","Harvard College","MA","US","Timothy","Pickering","","Timothy","Pickering","Sr","individual","","It is the common opinion of people that to play a game at cards is (almost) an unpardonable crime. But what renders it more odious than other diversions ?","ltr_tip4950.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4951","letter","1772-07-08","Salem","MA","US","Timothy","Pickering","","Andrew","Oliver","","individual","","You must, Sir, ere now apprehend the design of this letter, if you have never heard that I am desirous of being appointed joint Clerk with Mr. Bowditch.","ltr_tip4951.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4952","letter","1774-03-21","Salem","MA","US","Timothy","Pickering","","James","Latham","","individual","","When you have informed me of your design in making this request, I shall be able to give you a further answer.","ltr_tip4952.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4953","letter","1774-08-25","Salem","MA","US","Timothy","Pickering","","Paine","Wingate","","individual","","It will he agreeable to you to have an authentic account of the recent transactions in this town.","ltr_tip4953.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4954","letter","1812-04-06","Wenham","MA","US","Timothy","Pickering","","Jacob","Dodge","","individual","","...induces me to present to you my correspondence with Governor Sullivan, in which I have stated the circumstances respecting my conduct on the day of the battle of Lexington, not a syllable of which, to my knowledge, has ever been contradicted","ltr_tip4954.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4955","letter","1775-04-26","Salem","MA","US","Timothy","Pickering","","Paine","Wingate","","individual","","I am still of opinion that a pacification upon honorable terms is practicable. This opinion I declared in the council of war at Cambridge last Thursday","ltr_tip4955.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4956","letter","1775-05-02","Salem","MA","US","Timothy","Pickering","","","Higginson","","individual","","You as rightly as fully believe that we feel a sincere friendship for each other -  and let it be lasting as our lives. I regret the separation which probably must soon take place -  but God grant it may be a short one.","ltr_tip4956.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4957","letter","1775-10-16","Salem","MA","US","Timothy","Pickering","","Samuel","Holten","","individual","","I cannot forbear expressing my surprise at the principle advanced by a certain gentleman, with respect to the appointment of civil officers.","ltr_tip4957.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4958","letter","1776-01-31","Salem","MA","US","Timothy","Pickering","","George","Washington","","individual","","We were therefore induced to try another method, and the Committee of Safety gave the enlisting orders to a worthy man and good soldier who had served as a Lieutenant in the army the last campaign, and offered a month's pay in advance to all who woul","ltr_tip4958.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4959","letter","1777-01-12","Danbury","CT","US","Timothy","Pickering","","Rebecca","Pickering","","individual","","I arrived at Danbury on Thursday night, the 2d of January, in company with General Lincoln, who, going on the next day for Peekskill, directed me to tarry here, to forward the militia as they arrived.","ltr_tip4959.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4960","letter","1777-01-14","Bedford","NY","US","Timothy","Pickering","","Rebecca","Pickering","","individual","","Yesterday I walked from Danbury to this place twenty long miles in company with Mr. Cabot and two other gentlemen.","ltr_tip4960.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4961","letter","1777-04-09","Salem","MA","US","Timothy","Pickering","","George","Washington","","individual","","I esteem it a singular honor done me by your Excellency in offering me the post of Adjutant-General -  and it pains me sensibly that I am obliged to decline it.","ltr_tip4961.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4962","letter","1777-04-14","Salem","MA","US","Timothy","Pickering","","George","Washington","","individual","","I sent, by the express, an answer to your letter respecting the office of Adjutant-General, and gave what appeared to me sufficient reasons to excuse my declining to accept it -  but I have since been uneasy lest you should deem them otherwise","ltr_tip4962.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4963","letter","1777-05-07","Boston","MA","US","Timothy","Pickering","","George","Washington","","individual","","And since, notwithstanding all my objections, tis your Excellency's pleasure, I am happy to declare my acceptance of it. At the same time, I am constrained, from my real feelings, again to express my fears that I shall fall short of your Excellency's","ltr_tip4963.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4964","letter","1777-05-23","Middlebrook","NJ","US","Timothy","Pickering","","Rebecca","Pickering","","individual","","I embrace the first opportunity since my arrival here to write you. I am very happy in the General's family. His secretaries and aides-de-camp are gentlemen of education, and of the most polite, obliging manners.","ltr_tip4964.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4965","letter","1777-07-06","Morristown","NJ","US","Timothy","Pickering","","Rebecca","Pickering","","individual","","The enemy having entirely quitted Jersey, and the General suspecting they might go up the North River, the army moved up from Middle Brook, last Thursday, to this place, to be nearer to Peekskill.","ltr_tip4965.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4966","letter","1777-07-26","Morristown","NJ","US","Timothy","Pickering","","Rebecca","Pickering","","individual","","But, having advanced a dozen miles into the Clove, we halted, having reason to doubt, from the enemy's movements and the best intelligence we could obtain, whether they were bound up the North River or to the eastward, or not.","ltr_tip4966.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4967","letter","1777-08-01","Philadelphia","PA","US","Timothy","Pickering","","Rebecca","Pickering","","individual","","Last night the General and his family arrived here. Yesterday morn ing, about half after nine o clock, an express came to the General to inform him of the arrival of the enemy's fleet at the Capes of the river.","ltr_tip4967.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4968","letter","1777-09-25","Potsgrove","PA","US","Timothy","Pickering","","","Pickering","","individual","","Although our loss in the battle of Brandywine was not so great as the enemy's, yet since then it has been much larger - I mean by straggling and desertions","ltr_tip4968.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4969","letter","1777-11-04","Whitemarsh","PA","US","Timothy","Pickering","","Rebecca","Pickering","","individual","","pleased as I am with this proof of your fond affection, I do not wish you to indulge such melancholy thoughts. I know tis difficult to control the mind.","ltr_tip4969.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4970","letter","1777-11-15","Whitemarsh","PA","US","Timothy","Pickering","","Henry","Laurens","","individual","","I was honored with your favor of the 8th instant, en closing a minute of Congress intimating my appointment to the Board of War.","ltr_tip4970.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4971","letter","1777-11-18","Whitemarsh","PA","US","Timothy","Pickering","","Rebecca","Pickering","","individual","","Colonel Harrison yesterday went to Reading to see General Mifflin, being in some doubt whether to accept or not. I hope ardently that he will, because he is a sensible, a diligent, a most worthy, honest man","ltr_tip4971.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4972","letter","1777-12-21","Valley Forge","PA","US","Timothy","Pickering","","Rebecca","Pickering","","individual","","You tell me you embraced the opportunity by Mr. Goodhue to write to me, though you had nothing new to acquaint me with -  and yet you filled up nearly three pages.","ltr_tip4972.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  INSERT INTO media VALUES ("ltr_tip4973","letter","1777-12-24","Valley Forge","PA","US","Timothy","Pickering","","Rebecca","Pickering","","individual","","How many parents hearts have been rent with grief, how many widowed mates, how many spotless virgins (like the drooping lilies), have bowed their heads, oppressed with sorrow, at the loss of children, husbands, lovers !","ltr_tip4973.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,76,0);
  