text: INSERT INTO media VALUES ("ltr_rhl1925","letter","1762-08-27","Westmoreland","VA","US","Richard","Lee",NULL,"James","Abercrombie",NULL,"individual",NULL,"I know not any person to whom I can, with more propriety, apply for an application in my behalf, that I may be appointed to fill the next vacancy...","ltr_rhl1925.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1926","letter","1762-08-27","Westmoreland","VA","US","Richard","Lee",NULL,"Thomas","Cummings",NULL,"individual",NULL,"I entreat the favour of you, to exert your friendship that I might be appointed in Mr. -'s place.","ltr_rhl1926.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1927","letter","1764-05-31","Chantilly","VA","US","Richard","Lee",NULL,"","",NULL,"individual",NULL,"Richard Henry Lee letter a to gentlemen in London... Many late determinations of the great, on your side of the water, seem to prove a resolution, to oppress North America with the iron hand of power...","ltr_rhl1927.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1928","letter","1765-07-04","Chantilly","VA","US","Richard","Lee",NULL,"","",NULL,"individual",NULL,"I had been informed of the fatal blow given to American liberty, by the ever to be detested stamp act.","ltr_rhl1928.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1929","letter","1765-00-00","Chantilly","VA","US","Richard","Lee",NULL,"","",NULL,"individual",NULL,"Richard Henry Lee open letter to people of Virginia.","ltr_rhl1929.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1930","letter","1767-00-00","Westmoreland","VA","US","Richard","Lee",NULL,"Charles","Camden",NULL,"individual",NULL,"America in particular, must ever regard your lordship, as the patron of its liberty, best possession of human nature.","ltr_rhl1930.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1931","letter","1767-06-01","Chantilly","VA","US","Richard","Lee",NULL,"Edmund","Jenings",NULL,"individual",NULL,"having a great veneration for the character of Lord Camden, particularly for his honourable support of America's liberty against the stamp act...","ltr_rhl1931.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1932","letter","1769-05-31","Chantilly","VA","US","Richard","Lee",NULL,"Edmund","Jenings",NULL,"individual",NULL,"The gentlemen of Westmoreland, desire me to return their hearty thanks to you, for your very genteel present of Lord Chatham's picture.","ltr_rhl1932.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1933","letter","1768-03-27","Chantilly","VA","US","Richard","Lee",NULL,"","",NULL,"individual",NULL,"a prudent man should lend his assistance to extinguish the flames, which had invaded the house of his next door neighbour, and not coldly wait, until the flame had reached his own...","ltr_rhl1933.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1934","letter","1768-07-25","Chantilly","VA","US","Richard","Lee",NULL,"John","Dickinson",NULL,"individual",NULL,"I acknowledge great obligation to you, for the wise and welltimed care, you have taken of our common liberty.","ltr_rhl1934.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1935","letter","1768-11-26","Chantilly","VA","US","Richard","Lee",NULL,"John","Dickinson",NULL,"individual",NULL,"with so potent and so flourishing a people, as those of Pennsylvania, to be silent, when the liberty of America is thus dangerously invaded...","ltr_rhl1935.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1936","letter","1769-05-31","Chantilly","VA","US","Richard","Lee",NULL,"","",NULL,"individual",NULL,"Richard Henry Lee letter to the Earl of Shelbohne... These proceedings rny lord, may, to some, appear the overflowings of a seditious and disloyal madness...","ltr_rhl1936.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1937","letter","1768-05-00","Chantilly","VA","US","Richard","Lee",NULL,"","FOTHERGILI",NULL,"individual",NULL,"When, therefore, my brother, Dr. Lee, informed me that you wished to have some wine from our native grape...","ltr_rhl1937.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1938","letter","1773-02-04","Chantilly","VA","US","Richard","Lee",NULL,"Samuel","Adams",NULL,"individual",NULL,"I should be extremely glad, sir, when your leisure permits, to have as true a state of the matter, as the public with you, has been furnished...","ltr_rhl1938.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1939","letter","1773-04-04","Chantilly","VA","US","Richard","Lee",NULL,"John","Dickinson",NULL,"individual",NULL,"In this quarter, much alarm has been created by a new court of criminal jurisdiction, which it is said, has lately been opened in Rhode Island.","ltr_rhl1939.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1940","letter","1774-06-23","Chantilly","VA","US","Richard","Lee",NULL,"Samuel","Adams",NULL,"individual",NULL,"The day before we were dissolved, I had prepared a set of resolutions, the two last of which, were thus expressed...","ltr_rhl1940.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1941","letter","1777-02-11","Philadelphia","VA","US","Richard","Lee",NULL,"","",NULL,"individual",NULL,"I would go to every extremity to serve my friend, and the able friend of liberty and mankind.","ltr_rhl1941.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1943","letter","1779-10-07","Chantilly","VA","US","Richard","Lee",NULL,"Herri","Lauhens",NULL,"individual",NULL,"I feel myself interested in the establishment of a wise and free republican government in Massachusetts...","ltr_rhl1943.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1942","letter","1779-08-07","Chantilly","VA","US","Richard","Lee",NULL,"","",NULL,"individual",NULL,"I am clearly of opinion, that if Mr. ' Clearly-out-of-order,' remains much longer in Congress, the United States will have cause to rue it bitterly.","ltr_rhl1942.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1944","letter","1792-11-05","Chantilly","VA","US","Richard","Lee",NULL,"","",NULL,"individual",NULL,"Richard Henry Lee letter to Speaker of the House of Delegates... I have ever thought, that the best reward for public service, is the approbation of our country","ltr_rhl1944.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl1945","letter","1792-11-05","Chantilly","VA","US","Richard","Lee",NULL,"","",NULL,"individual",NULL,"Richard Henry Lee letter to Speaker of the Senate... I feel, as I ought to do, the highest sense of obligation, for the honour conferred upon me...","ltr_rhl1945.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,106,0);
  INSERT INTO media VALUES ("ltr_rhl3000","letter","1775-08-01","Philadelphia","PA","US","Richard","Lee","","George","Washington","","individual","","We understand here, that batteries may be constructed at the entrance of the Bay of Boston, so as to prevent the egress and regress of any ships what ever.","ltr_rhl3000.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,88,0);
  INSERT INTO media VALUES ("ltr_rhl3001","letter","1775-09-26","Philadelphia","PA","US","Richard","Lee","","George","Washington","","individual","","We have no late accounts from England - but from what we have had that can be relied on, it seems almost certain, that our enemies there must shortly meet with a total overthrow.","ltr_rhl3001.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,88,0);
  INSERT INTO media VALUES ("ltr_rhl3002","letter","1775-10-22","Philadelphia","PA","US","Richard","Lee","","George","Washington","","individual","","Great bodies, you know, move slow, and it is as sure, that the most palpable and glorious events may be delayed, and the best causes finally lost by slow, timid, and indecisive counsels.","ltr_rhl3002.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,88,0);
  INSERT INTO media VALUES ("ltr_rhl3003","letter","1775-12-06","Philadelphia","PA","US","Richard","Lee","","George","Washington","","individual","","The proclamation, there alluded to, we have seen. It proclaims martial law through Virginia, and orders freedom to all the slaves, calling their masters rebels, &c.","ltr_rhl3003.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,88,0);
  INSERT INTO media VALUES ("ltr_rhl3004","letter","1776-06-13","Philadelphia","PA","US","Richard","Lee","","George","Washington","","individual","","I am informed that a certain Mr. Eustace, now in New York, but some time ago with Lord Dunmore, is acquainted with a practice that prevailed, of taking letters out of the post-office in Virginia, and carrying them to Dunmore for his perusal","ltr_rhl3004.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,88,0);
  INSERT INTO media VALUES ("ltr_rhl3005","letter","1777-04-10","Philadelphia","PA","US","Richard","Lee","","George","Washington","","individual","","My wishes are, Sir, and I think they correspond with the true interests of America, that you should quickly be possessed of a strong army - that your powers might be such as to gratify your wishes of crushing our enemies","ltr_rhl3005.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,88,0);
  INSERT INTO media VALUES ("ltr_rhl3200","letter","1777-10-20","York","NY","US","Richard","Lee","","George","Washington","","individual","","was a good deal surprised to find you had been told that Congress had appointed General Conway a Major-General. No such appointment has been made - nor do I believe it will","ltr_rhl3200.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,73,0);
  INSERT INTO media VALUES ("ltr_rhl3201","letter","1777-10-20","York","NY","US","Richard","Lee","","George","Washington","","individual","","General Conway has not lately been mentioned in Congress, nor has there been much talk of an Adjutant-General, since it is not certainly known whether Colonel Pickering will accept his new appointment.","ltr_rhl3201.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,73,0);
  INSERT INTO media VALUES ("ltr_rhl3202","letter","1778-05-16","York","NY","US","Richard","Lee","","George","Washington","","individual","","Give me leave, dear Sir, to congratulate you on the happy event of our treaty with France being so effectually concluded. Congress have ratified it on their part","ltr_rhl3202.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,73,0);
  INSERT INTO media VALUES ("ltr_rhl3203","letter","1778-10-05","Philadelphia","PA","US","Richard","Lee","","George","Washington","","I hope the measures you h","","description","ltr_rhl3203.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,73,0);
  INSERT INTO media VALUES ("ltr_rhl3700","letter","1781-06-12","Chantilly","VA","US","Richard","Lee","","George","Washington","","individual","","Virginia, it is true, has nine times the number of men that now threaten its ruin - but they are dispersed, unarmed, without system, government, and very little probability at present of the Legislature assembling.","ltr_rhl3700.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_rhl3701","letter","1781-09-17","Epping Forest","VA","US","Richard","Lee","","George","Washington","","individual","","I assure you. Sir, the Commissaries' and Quartermasters' departments in the State, so far as I have observed them, have in every thing been the reverse of right","ltr_rhl3701.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_rhl3702","letter","1781-10-12","Chantilly","VA","US","Richard","Lee","","George","Washington","","individual","","By this time, I hope his Lordship begins seriously to repent the Quixote part that he has been acting in America. Surely the rage of despotism must be cooled by the total defeat of those great hopes, which have been entertained of southern conquest","ltr_rhl3702.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,59,0);
  INSERT INTO media VALUES ("ltr_rhl4300","letter","1784-07-22","Chantilly","VA","US","Richard","Lee","","George","Washington","","individual","","The very great respect that I shall ever pay to your recommendations, would have been very sufficient to have procured my exertions in favor of Mr. Paine, independent of his great public merits in our revolution.","ltr_rhl4300.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,60,0);
  INSERT INTO media VALUES ("ltr_rhl4301","letter","1785-05-03","New York","NY","US","Richard","Lee","","George","Washington","","individual","","We are amused here with an account, that does not indeed come officially to us, hut however in such a way as to merit attention.","ltr_rhl4301.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,60,0);
  INSERT INTO media VALUES ("ltr_rhl4302","letter","1787-07-15","New York","NY","US","Richard","Lee","","George","Washington","","individual","","I have the honor to inclose to you an ordinance, that we have just passed in Congress, for establishing a temporary Government beyond the Ohio, as a measure preparatory to the sale of the lands.","ltr_rhl4302.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,60,0);
  INSERT INTO media VALUES ("ltr_rhl4303","letter","1787-10-11","New York","NY","US","Richard","Lee","","George","Washington","","individual","","We have the pleasure to see the first act of Congress for selling federal lands, north-west of the Ohio, becoming productive very fast, a large sum of public securities being already paid in upon the first sales","ltr_rhl4303.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,60,0);
  INSERT INTO media VALUES ("ltr_rhl4304","letter","1789-04-06","New York","NY","US","Richard","Lee","","George","Washington","","individual","","On this day we went to business - and, to my very great satisfaction, I heard a unanimous vote of the electing States in favor of calling you to the honorable office of President of the United States.","ltr_rhl4304.txt","hans.brough@yahoo.com",NULL,20090802183836,NULL,60,0);
  