text: INSERT INTO media VALUES ("jrn_smd7800","journal","1862-03-09","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","HERE I am, at your service, Madame Idleness, waiting for any suggestion it may please you to put in my weary brain, as a means to pass this dull, cloudy Sunday afternoon","jrn_smd7800.txt","hans.brough@yahoo.com",NULL,20120331172523,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7801","journal","1862-04-07","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Until that dreary 1861, I had no idea of sorrow or grief. . . . How I love to think of myself at that time! Not as myself, but as some happy, careless child who danced through life","jrn_smd7801.txt","hans.brough@yahoo.com",NULL,20120331173108,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7802","journal","1862-04-12","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Day before yesterday, just about this time of evening, as I came home from the graveyard, Jimmy unexpectedly came in.","jrn_smd7802.txt","hans.brough@yahoo.com",NULL,20120331173108,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7803","journal","1862-04-16","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Among the many who visited us, in the beginning of 1861, there was Mr. Bradford. I took a dislike to him the first time I ever saw him","jrn_smd7803.txt","hans.brough@yahoo.com",NULL,20120331173108,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7804","journal","1862-04-17","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","What was the use of throwing a nice, big cannon ball, that might have knocked a man down, away on that poor little fellow, when a pea from a popgun would have made the same impression?","jrn_smd7804.txt","hans.brough@yahoo.com",NULL,20120331173108,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7805","journal","1862-04-18","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Another date in Hal's short history! I see myself walking home with Mr. McG just after sun down, meeting Miriam and Dr. Woods at the gate","jrn_smd7805.txt","hans.brough@yahoo.com",NULL,20120331173108,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7806","journal","1862-04-26","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","There is no word in the English language that can express the state in which we are, and have been, these last three days.","jrn_smd7806.txt","hans.brough@yahoo.com",NULL,20120331173108,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7807","journal","1862-04-27","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","What a day! Last night came a dispatch that New Orleans was under British protection, and could not be bombarded","jrn_smd7807.txt","hans.brough@yahoo.com",NULL,20120331173108,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7808","journal","1862-05-05","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Vile old Yankee boats, four in number, passed up this morning without stopping.","jrn_smd7808.txt","hans.brough@yahoo.com",NULL,20120331173108,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7809","journal","1862-05-09","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Our lawful (?) owners have at last arrived. About sunset, day before yesterday, the Iroquois anchored here, and a graceful young Federal stepped ashore, carrying a Yankee flag over his shoulder","jrn_smd7809.txt","hans.brough@yahoo.com",NULL,20120331173108,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7810","journal","1862-05-10","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","What tales they had to tell! They were on the wharf, and saw the ships sail up the river, saw the broadside fired into Will Pinckney's regiment","jrn_smd7810.txt","hans.brough@yahoo.com",NULL,20120331174052,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7811","journal","1862-05-11","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","I am disgusted with myself. No unusual thing, but I am peculiarly disgusted this time.","jrn_smd7811.txt","hans.brough@yahoo.com",NULL,20120331174052,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7812","journal","1862-05-14","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","I am beginning to believe that we are even of more importance in Baton Rouge than we thought we were.","jrn_smd7812.txt","hans.brough@yahoo.com",NULL,20120331174052,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7813","journal","1862-05-17","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Four days ago the Yankees left us, to attack Vicksburg, leaving their flag flying in the Garrison without a man to guard it, and with the understanding that the town would be held responsible for it.","jrn_smd7813.txt","hans.brough@yahoo.com",NULL,20120331174052,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7814","journal","1862-05-21","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","I have had such a search for shoes this week that I am disgusted with shopping.","jrn_smd7814.txt","hans.brough@yahoo.com",NULL,20120331174052,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7815","journal","1862-05-27","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","The cry is 'Ho! for Greenwell!' Very probably this day week will see us there. I don't want to go.","jrn_smd7815.txt","hans.brough@yahoo.com",NULL,20120331174052,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7816","journal","1862-05-30","Greenwell","LA","US","Sarah","Dawson","","","","","individual","","After all our trials and tribulations, here we are at last, and no limbs lost ! How many weeks ago was it since I wrote here?","jrn_smd7816.txt","hans.brough@yahoo.com",NULL,20120331174052,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7817","journal","1862-05-31","Greenwell","LA","US","Sarah","Dawson","","","","","individual","","It was long after nine when we got there, and my first act was to look around the deserted house. What a scene of confusion! armoirs spread open, with clothes tumbled in every direction...","jrn_smd7817.txt","hans.brough@yahoo.com",NULL,20120331174052,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7818","journal","1862-06-01","Greenwell","LA","US","Sarah","Dawson","","","","","individual","","From the news brought by one or two persons who managed to reach here yesterday, I am more uneasy about mother and the girls. A gentleman tells me that no one is permitted to leave without a pass","jrn_smd7818.txt","hans.brough@yahoo.com",NULL,20120331174052,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7819","journal","1862-06-03","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Well! Day before yesterday, I almost vowed I would not return, and last evening I reached here.","jrn_smd7819.txt","hans.brough@yahoo.com",NULL,20120331174052,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7820","journal","1862-06-04","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Our condition is desperate. Beauregard is about attacking these Federals. They say he is coming from Corinth, and the fight will be in town. If true, we are lost again.","jrn_smd7820.txt","hans.brough@yahoo.com",NULL,20120331190254,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7821","journal","1862-06-05","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Beauregard is undoubtedly coming to attack Baton Rouge - his fire would burn the town, if the gunboats do not - the Yankees will shell, at all events, if forced to retire.","jrn_smd7821.txt","hans.brough@yahoo.com",NULL,20120331190255,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7822","journal","1862-06-06","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","We dined at Mrs. Brunot's yesterday, and sitting on the gallery later, had the full benefit of a Yankee drill.","jrn_smd7822.txt","hans.brough@yahoo.com",NULL,20120331190255,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7823","journal","1862-06-08","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Yesterday General Williams sent a barrel of flour to mother, accompanied by a note begging her to accept it 'in consideration of the present condition of the circulating currency,'","jrn_smd7823.txt","hans.brough@yahoo.com",NULL,20120331190255,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7824","journal","1862-06-10","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","This morning while I was attending to my flowers . . . several soldiers stopped in front of me, and holding on the fence, commenced to talk about some brave Colonel, and a shooting affair last night.","jrn_smd7824.txt","hans.brough@yahoo.com",NULL,20120331190255,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7825","journal","1862-06-11","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Last evening mother and Miriam went to the Arsenal to see if they would be allowed to do any thing for the prisoners.","jrn_smd7825.txt","hans.brough@yahoo.com",NULL,20120331190255,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7826","journal","1862-06-16","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Thanks to my liberal supply of pens, ink, and paper, how many inexpressibly dreary days I have filled up to my own satisfaction, if not to that of others!","jrn_smd7826.txt","hans.brough@yahoo.com",NULL,20120331190255,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7827","journal","1862-06-16","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Do I consider the female who could spit in a gentleman's face, merely because he wore United States buttons, as a fit associate for me?","jrn_smd7827.txt","hans.brough@yahoo.com",NULL,20120331190255,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7828","journal","1862-06-17","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Yesterday, and day before, boats were constantly arriving and troops embarking from here, destined for Vicksburg.","jrn_smd7828.txt","hans.brough@yahoo.com",NULL,20120331190255,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7829","journal","1862-06-18","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","How long, O how long, is it since I have lain down in peace, thinking, 'This night I will rest in safety'? Certainly not since the fall of Fort Jackson.","jrn_smd7829.txt","hans.brough@yahoo.com",NULL,20120331190255,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7830","journal","1862-06-19","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","We after discovered that the man was drunk, and had cursed the woman of the grog-shop, whereupon her husband had pitched him out in the street, where they found him.","jrn_smd7830.txt","hans.brough@yahoo.com",NULL,20120331190304,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7831","journal","1862-06-26","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Yesterday morning, just as I stepped out of bed I heard the report of four cannon fired in rapid succession, and everybody asked everybody else, 'Did you hear that?'","jrn_smd7831.txt","hans.brough@yahoo.com",NULL,20120331190304,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7832","journal","1862-06-27","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","A proclamation of Van Dorn has just been smuggled into town, that advises all persons living with in eight miles of the Mississippi to remove into the interior...","jrn_smd7832.txt","hans.brough@yahoo.com",NULL,20120331190304,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7833","journal","1862-06-29","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","'Any more, Mr. Lincoln, any more?' can't you leave our racked homes in repose? We are all wild.","jrn_smd7833.txt","hans.brough@yahoo.com",NULL,20120331190304,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7834","journal","1862-06-30","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","As a specimen of the humanity of General Butler, let me record a threat of his uttered with all the force and meaning language can convey, and certainly enough to strike terror in the hearts of frail women...","jrn_smd7834.txt","hans.brough@yahoo.com",NULL,20120331190304,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7835","journal","1862-07-01","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","These officers say the women talk too much, which is undeniable. They then said, they meant to get up a sewing society, and place in it...","jrn_smd7835.txt","hans.brough@yahoo.com",NULL,20120331190304,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7836","journal","1862-07-03","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Another day of sickening suspense. This evening, about three, came the rumor that there was to be an attack on the town to-night, or early in the morning","jrn_smd7836.txt","hans.brough@yahoo.com",NULL,20120331190304,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7837","journal","1862-07-04","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Here I am, and still alive, having wakened but once in the night, and that only in consequence of Louis and Morgan crying...","jrn_smd7837.txt","hans.brough@yahoo.com",NULL,20120331190304,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7838","journal","1862-07-06","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","...Butler has sentenced Mrs. Phillips for laughing while the corpse of a Federal officer was passing...","jrn_smd7838.txt","hans.brough@yahoo.com",NULL,20120331190304,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7839","journal","1862-07-07","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","He says a boat from Mobile reached the city Saturday evening, and the captain told Mr. La Noue that he brought an extra from the former place, containing news of McClellan's surrender with his entire army...","jrn_smd7839.txt","hans.brough@yahoo.com",NULL,20120331190304,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7840","journal","1862-07-09","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","If ever I saw two mortified, hangdog-looking men, they were these two as they took their way home. Was it not shocking?","jrn_smd7840.txt","hans.brough@yahoo.com",NULL,20120331191523,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7841","journal","1862-07-10","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","A proclamation is out announcing that any one talking about the war, or present state of affairs, will be 'summarily' dealt with.","jrn_smd7841.txt","hans.brough@yahoo.com",NULL,20120331191523,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7842","journal","1862-07-11","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","A letter from George this morning! It was written on the 20th of June, and he speaks of being on crutches in consequence of his horse having fallen with him...","jrn_smd7842.txt","hans.brough@yahoo.com",NULL,20120331191523,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7843","journal","1862-06-12","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","I grow desperate when I read these Northern papers reviling and abusing us, reproaching us for being broken and dispersed, taunting us with their victories...","jrn_smd7843.txt","hans.brough@yahoo.com",NULL,20120331191523,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7844","journal","1862-07-13","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","I have been reading that old disguster, Boswell. Bah ! I have no patience with the toady !","jrn_smd7844.txt","hans.brough@yahoo.com",NULL,20120331191523,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7845","journal","1862-07-14","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Another pleasant excitement. News has just arrived that Scott's cavalry was having a hard fight with the Yankees eight miles from town.","jrn_smd7845.txt","hans.brough@yahoo.com",NULL,20120331191523,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7846","journal","1862-07-17","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","It is decided that I am to go to New Orleans next week. I hardly know which I dislike most, going or staying. I know I shall be dreadfully homesick","jrn_smd7846.txt","hans.brough@yahoo.com",NULL,20120331191523,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7847","journal","1862-07-20","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Last night the town was in a dreadful state of excitement. Before sunset a regiment, that had been camped out of town, came in, and pitched their tents around the new theatre, in front of our church.","jrn_smd7847.txt","hans.brough@yahoo.com",NULL,20120331191523,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7848","journal","1862-07-21","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","If we could keep all the dispatches that have passed between us since the battle of the forts, what a collection of absurdity and contradiction it would be!","jrn_smd7848.txt","hans.brough@yahoo.com",NULL,20120331191523,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7849","journal","1862-07-22","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","The excitement is on the increase, I think. Everybody is crazy to leave town.","jrn_smd7849.txt","hans.brough@yahoo.com",NULL,20120331191523,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7850","journal","1862-07-24","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","Where shall I begin the story of my wanderings? I don't know that it has a beginning, it is all so hurried and confused.","jrn_smd7850.txt","hans.brough@yahoo.com",NULL,20120403094038,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7851","journal","1862-07-25","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","An old gentleman stopped here just now in a carriage and asked to see me. Such a sad, sick old man!","jrn_smd7851.txt","hans.brough@yahoo.com",NULL,20120403094038,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7852","journal","1862-07-27","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","have my bird back! As I waked this morning, I heard a well-known chirp in the streets...","jrn_smd7852.txt","hans.brough@yahoo.com",NULL,20120403094038,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7853","journal","1862-07-29","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","This town, with its ten thousand soldiers, is more quiet than it was with the old population of seven thousand citizens.","jrn_smd7853.txt","hans.brough@yahoo.com",NULL,20120403094038,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7854","journal","1862-07-31","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","I believe I forgot to mention one little circumstance in my account of that first night at the Deaf and Dumb Asylum, which at the time struck me with extreme disgust.","jrn_smd7854.txt","hans.brough@yahoo.com",NULL,20120403094038,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7855","journal","1862-08-02","Baton Rouge","LA","US","Sarah","Dawson","","","","","individual","","I did not notice the report of the attack that was prophesied for night before last, and went to bed without gathering my clothes.","jrn_smd7855.txt","hans.brough@yahoo.com",NULL,20120403094038,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7856","journal","1862-08-03","Westover","LA","US","Sarah","Dawson","","","","","individual","","As we reached the ferry, I discovered I had lost the pass, and had to walk back and search for it...","jrn_smd7856.txt","hans.brough@yahoo.com",NULL,20120403094038,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7857","journal","1862-08-04","Westover","LA","US","Sarah","Dawson","","","","","individual","","HERE we are at Dr. Nolan's plantation, with Baton Rouge lying just seven miles from us to the east. We can surely hear the cannon from here.","jrn_smd7857.txt","hans.brough@yahoo.com",NULL,20120403094038,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7858","journal","1862-08-05","Westover","LA","US","Sarah","Dawson","","","","","individual","","About half-past nine, as we got up from the breakfast table, a guerrilla told us the ram Arkansas was lying a few miles below, on her way to cooperate with Breckinridge...","jrn_smd7858.txt","hans.brough@yahoo.com",NULL,20120403094038,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7859","journal","1862-08-06","Westover","LA","US","Sarah","Dawson","","","","","individual","","We six madcaps got in the carriage and buggy, and rode off in search of news.","jrn_smd7859.txt","hans.brough@yahoo.com",NULL,20120403094038,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7860","journal","1862-08-07","Westover","LA","US","Sarah","Dawson","","","","","individual","","Last night, shortly after we got in bed, we were roused by loud cannonading towards Baton Rouge, and running out on the small balcony up here, saw the light of a great fire...","jrn_smd7860.txt","hans.brough@yahoo.com",NULL,20120403094046,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7861","journal","1862-08-08","Westover","LA","US","Sarah","Dawson","","","","","individual","","Again last night, about nine, we heard cannon in Baton Rouge, and watched the flashes,, which preceded the reports by a minute, at least, for a long time.","jrn_smd7861.txt","hans.brough@yahoo.com",NULL,20120403094046,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7862","journal","1862-08-09","Westover","LA","US","Sarah","Dawson","","","","","individual","","To our great surprise, Charlie came in this morning from the other side. He was in the battle, and General Carter, and dozens of others that we did not think of.","jrn_smd7862.txt","hans.brough@yahoo.com",NULL,20120403094046,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7863","journal","1862-08-10","Westover","LA","US","Sarah","Dawson","","","","","individual","","...last evening, about six o clock, as we sat reading, sewing, and making lint in the parlor, we heard a tremendous shell whizzing past...","jrn_smd7863.txt","hans.brough@yahoo.com",NULL,20120403094046,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7864","journal","1862-08-11","Randallsons Landing","LA","US","Sarah","Dawson","","","","","I saw another instance of","","description","jrn_smd7864.txt","hans.brough@yahoo.com",NULL,20120403094046,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7865","journal","1862-08-12","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Another resting-place! Out of reach of shells for the first time since last April! For how long, I wonder? For wherever we go, we bring shells and Yankees.","jrn_smd7865.txt","hans.brough@yahoo.com",NULL,20120403094046,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7866","journal","1862-08-13","Linwood","LA","US","Sarah","Dawson","","","","","individual","","I am in despair. Miss Jones, who has just made her escape from town, brings a most dreadful account.","jrn_smd7866.txt","hans.brough@yahoo.com",NULL,20120403094046,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7867","journal","1862-08-17","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Thursday, we heard from a lady just from town that our house was standing the day before, which somewhat consoled us for the loss of our silver and clothing - but yesterday came the tidings of new afflictions.","jrn_smd7867.txt","hans.brough@yahoo.com",NULL,20120403094046,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7868","journal","1862-08-18","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Yesterday, two Colonels, Shields and Breaux, both of whom distinguished themselves in the battle of Baton Rouge, dined here.","jrn_smd7868.txt","hans.brough@yahoo.com",NULL,20120403094046,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7869","journal","1862-08-20","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Last evening, after hard labor at pulling molasses candy, needing some relaxation after our severe exertions, we determined to have some fun...","jrn_smd7869.txt","hans.brough@yahoo.com",NULL,20120403094046,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7870","journal","1862-08-21","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Miriam and mother are going to Baton Rouge in a few hours, to see if anything can be saved from the general wreck.","jrn_smd7870.txt","hans.brough@yahoo.com",NULL,20120403094054,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7871","journal","1862-08-23","Linwood","LA","US","Sarah","Dawson","","","","","individual","","He confirms the story about all the convicts being set free, and the town being pillaged by the negroes and the rest of the Yankees.","jrn_smd7871.txt","hans.brough@yahoo.com",NULL,20120403094054,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7872","journal","1862-08-24","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Soon after dinner yesterday two soldiers stopped here, and requested permission to remain all night.","jrn_smd7872.txt","hans.brough@yahoo.com",NULL,20120403094054,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7873","journal","1862-08-25","Linwood","LA","US","Sarah","Dawson","","","","","individual","","She says when she entered the house, she burst into tears at the desolation. It was one scene of ruin. Libraries emptied, china smashed, sideboards split open with axes...","jrn_smd7873.txt","hans.brough@yahoo.com",NULL,20120403094054,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7874","journal","1862-08-28","Linwood","LA","US","Sarah","Dawson","","","","","individual","","I saw the first Yankee camp that Will Pinckney and Colonel Bird had set fire to the day of the battle. Such a shocking sight of charred wood, burnt clothes, tents, and all imaginable articles strewn around...","jrn_smd7874.txt","hans.brough@yahoo.com",NULL,20120403094054,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7875","journal","1862-08-29","Clinton","LA","US","Sarah","Dawson","","","","","individual","","Yesterday I was interrupted while writing, to pack up for another move, it being impossible to find a boarding-house in the neighborhood.","jrn_smd7875.txt","hans.brough@yahoo.com",NULL,20120403094054,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7876","journal","1862-08-30","Clinton","LA","US","Sarah","Dawson","","","","","individual","","Still no prospect of a lodging - so here we remain. I never before lived in a house without a balcony, and have only now found out how inconvenient it is.","jrn_smd7876.txt","hans.brough@yahoo.com",NULL,20120403094054,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7877","journal","1862-09-01","Clinton","LA","US","Sarah","Dawson","","","","","individual","","How shockingly I write! Will I ever again have a desk or a table to write on? At present, my seat is a mattress, and my knee my desk - and that is about the only one I have had since the 2d of August.","jrn_smd7877.txt","hans.brough@yahoo.com",NULL,20120403094054,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7878","journal","1862-09-03","Clinton","LA","US","Sarah","Dawson","","","","","individual","","But if we get home, what will we do for bedding? The Yankees did not leave us a single comfort, and only two old bars and a pair of ragged sheets..","jrn_smd7878.txt","hans.brough@yahoo.com",NULL,20120403094054,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7879","journal","1862-09-04","Clinton","LA","US","Sarah","Dawson","","","","","individual","","I hear to-day that the Brunots have returned to Baton Rouge, determined to await the grand finale there. They, and two other families, alone remain.","jrn_smd7879.txt","hans.brough@yahoo.com",NULL,20120403094054,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7880","journal","1862-09-06","Beech Grove","LA","US","Sarah","Dawson","","","","","individual","","General Carter, who spent the evening with us day before yesterday, remarked that the first thing he heard as he reached town was that all the gentlemen and ladies of Clinton were hunting for country lodgings for us.","jrn_smd7880.txt","hans.brough@yahoo.com",NULL,20120403094102,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7881","journal","1862-09-09","Clinton","LA","US","Sarah","Dawson","","","","","individual","","It is said the enemy were cut off from Washington, and that we were pursuing them. O my brothers! If God will only spare them!","jrn_smd7881.txt","hans.brough@yahoo.com",NULL,20120403094102,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7882","journal","1862-09-10","Clinton","LA","US","Sarah","Dawson","","","","","individual","","We cannot do too much, or even enough, for our soldiers. I believe that is the universal sentiment of the women of the South.","jrn_smd7882.txt","hans.brough@yahoo.com",NULL,20120403094103,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7883","journal","1862-09-14","Clinton","LA","US","Sarah","Dawson","","","","","individual","","There is one thing in which Sophie and I agree, and that is in making Stonewall Jackson our hero.","jrn_smd7883.txt","hans.brough@yahoo.com",NULL,20120403094103,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7884","journal","1862-09-16","Clinton","LA","US","Sarah","Dawson","","","","","individual","","Go or stay, the danger seems the same. Shall we go, then, for variety, or die here of stagnation while waiting for the Yankees to make up their minds?","jrn_smd7884.txt","hans.brough@yahoo.com",NULL,20120403094103,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7885","journal","1862-09-17","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Many soldiers were aboard on their way to Port Hudson, to rejoin their companies. One gallant one offered me a drink of water from his canteen, which I accepted out of mere curiosity...","jrn_smd7885.txt","hans.brough@yahoo.com",NULL,20120403094103,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7886","journal","1862-09-02","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Does it not seem that this war will sweep off all who are nearest and dearest, as well as most worthy of life, leaving only those you least care for, unharmed?","jrn_smd7886.txt","hans.brough@yahoo.com",NULL,20120403094103,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7887","journal","1862-09-21","Linwood","LA","US","Sarah","Dawson","","","","","individual","","...to add to our distress the odor of broiled chicken and hot biscuit was wafted up stairs, after a while, in the most provoking way.","jrn_smd7887.txt","hans.brough@yahoo.com",NULL,20120403094103,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7888","journal","1862-09-24","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Now, in present phraseology, 'Confederate' means anything that is rough, unfinished, unfashionable, or poor.","jrn_smd7888.txt","hans.brough@yahoo.com",NULL,20120403094103,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7889","journal","1862-09-26","Linwood","LA","US","Sarah","Dawson","","","","","individual","","...to-day we hear that McClellan's army has been cut to pieces - but whether it is the same old fight or a new one, I cannot as yet learn - for reliable information is not easily obtained in America at this period.","jrn_smd7889.txt","hans.brough@yahoo.com",NULL,20120403094103,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7890","journal","1862-09-27","Linwood","LA","US","Sarah","Dawson","","","","","individual","","I often wonder how lies first came into the world, and whether those who originate them do not believe them as firmly as any one else would believe truth.","jrn_smd7890.txt","hans.brough@yahoo.com",NULL,20120406094128,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7891","journal","1862-09-28","Linwood","LA","US","Sarah","Dawson","","","","","individual","","We were roused up at four o'clock last night by the arrival of Lydia and Eugene Carter... of course, there was very little sleep for any of us, so anxious were we to hear the news they brought.","jrn_smd7891.txt","hans.brough@yahoo.com",NULL,20120406094128,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7892","journal","1862-09-03","Linwood","LA","US","Sarah","Dawson","","","","","individual","","This Kentuckian pronunciation grates 'hairshly' on my Southern ears.","jrn_smd7892.txt","hans.brough@yahoo.com",NULL,20120406094129,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7893","journal","1862-10-01","Linwood","LA","US","Sarah","Dawson","","","","","individual","","A dispatch just received from Gibbes, from Mobile, on his way home. I am so happy!","jrn_smd7893.txt","hans.brough@yahoo.com",NULL,20120406094129,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7894","journal","1862-10-02","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Why was I denied the education that would enable me to be the equal of such a man as Colonel Breaux and the others? He says the woman's mind is the same as the man's, originally - it is only education that creates the difference.","jrn_smd7894.txt","hans.brough@yahoo.com",NULL,20120406094129,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7895","journal","1862-10-04","Linwood","LA","US","Sarah","Dawson","","","","","individual","","While Anna and Miriam went out riding last evening, just as I put down my pen, I went out for a solitary walk down the road that Gibbes would have to pass - but saw nothing of the carriage.","jrn_smd7895.txt","hans.brough@yahoo.com",NULL,20120406094129,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7896","journal","1862-10-06","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Last night, I actually drew from Gibbes the outlines of Jackson's campaign.","jrn_smd7896.txt","hans.brough@yahoo.com",NULL,20120406094129,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7897","journal","1862-10-09","Linwood","LA","US","Sarah","Dawson","","","","","individual","","I never was known to laugh aloud, no matter how intense might have been my mirth...","jrn_smd7897.txt","hans.brough@yahoo.com",NULL,20120406094129,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7898","journal","1862-10-11","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Oh, how willingly I would return to the old wreck of our home! All its desolation could not be half so unendurable as Clinton.","jrn_smd7898.txt","hans.brough@yahoo.com",NULL,20120406094129,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7899","journal","1862-10-16","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Night before last Lydia got playing the piano for me in the darkened parlor, and the old tunes from her dear little fingers sent me off in a sea of dreams.","jrn_smd7899.txt","hans.brough@yahoo.com",NULL,20120406094129,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7900","journal","1862-10-18","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Last night mother arrived from Clinton with Gibbes","jrn_smd7900.txt","hans.brough@yahoo.com",NULL,20120407110243,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7901","journal","1862-10-18","Clinton","LA","US","Sarah","Dawson","","","","","individual","","I hardly know which I was most amused by: the giddy, lively girls to my right, or the two ladies to my left who were as cross and ill-natured as two old cats...","jrn_smd7901.txt","hans.brough@yahoo.com",NULL,20120407110243,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7902","journal","1862-10-22","Linwood","LA","US","Sarah","Dawson","","","","","individual","","We left Clinton this morning, and have just now arrived by the cars.","jrn_smd7902.txt","hans.brough@yahoo.com",NULL,20120407110243,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7903","journal","1862-10-24","Linwood","LA","US","Sarah","Dawson","","","","","individual","","A letter from Jimmy, the first we have received since New Orleans fell. It was dated the 10th inst., and he spoke of being on the eve of running the blockade...","jrn_smd7903.txt","hans.brough@yahoo.com",NULL,20120407110243,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7904","journal","1862-10-26","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Everything points to a speedy attack on Port Hudson. Rumors reach us from New Orleans of extensive preparations by land and water, and of the determination to burn Clinton...","jrn_smd7904.txt","hans.brough@yahoo.com",NULL,20120407110243,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7905","journal","1862-11-02","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Yesterday was a day of novel sensations to me. First came a letter from mother announcing her determination to return home, and telling us to be ready next week.","jrn_smd7905.txt","hans.brough@yahoo.com",NULL,20120407110243,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7906","journal","1862-11-04","Linwood","LA","US","Sarah","Dawson","","","","","individual","","O what a glorious time we had yesterday ! First, there were those two gentlemen to be entertained all day, which was rather a stretch, I confess, so I stole away for a while.","jrn_smd7906.txt","hans.brough@yahoo.com",NULL,20120407110243,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7907","journal","1862-11-06","Linwood","LA","US","Sarah","Dawson","","","","","individual","","We three girls fancied a walk last evening, and immediately after dinner prepared to walk to Mrs. Breaux's, only a mile, and get her to come to the sugar-house.","jrn_smd7907.txt","hans.brough@yahoo.com",NULL,20120407110243,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7908","journal","1862-11-09","Linwood","LA","US","Sarah","Dawson","","","","","individual","","And to think old Abe wants to deprive us of all that fun! No more cotton, sugar-cane, or ric! No more old black aunties or uncles! No more rides in mule teams, no more songs in the cane-field...","jrn_smd7908.txt","hans.brough@yahoo.com",NULL,20120407110243,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7909","journal","1862-11-10","Linwood","LA","US","Sarah","Dawson","","","","","individual","","In spite of its being Sunday, no sooner was dinner concluded yesterday than we adjourned, as usual, to the sugar-house to see how much damage we could do.","jrn_smd7909.txt","hans.brough@yahoo.com",NULL,20120407110243,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7910","journal","1862-11-12","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Once more a cripple and consigned to my bed, for how long, Heaven only knows.","jrn_smd7910.txt","hans.brough@yahoo.com",NULL,20120407110253,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7911","journal","1862-11-15","Linwood","LA","US","Sarah","Dawson","","","","","individual","","I think I grow no better rapidly. Fortunately on Wednesday night they succeeded in turning me over - for my poor elbows, having lost all their skin, were completely used up.","jrn_smd7911.txt","hans.brough@yahoo.com",NULL,20120407110253,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7912","journal","1862-11-16","Linwood","LA","US","Sarah","Dawson","","","","","individual","","What if the fight should come off before I can walk? It takes three people to raise me whenever it is necessary for me to move - I am worse than helpless.","jrn_smd7912.txt","hans.brough@yahoo.com",NULL,20120407110253,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7913","journal","1862-11-18","Linwood","LA","US","Sarah","Dawson","","","","","individual","","A note just came from mother, telling me that the most awful Yankees were coming to burn Linwood and take Port Hudson...","jrn_smd7913.txt","hans.brough@yahoo.com",NULL,20120407110253,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7914","journal","1862-11-21","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Lying on my face, as it were, with my poor elbows for a support, I try to pass away these lonely hours.","jrn_smd7914.txt","hans.brough@yahoo.com",NULL,20120407110253,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7915","journal","1862-12-04","Linwood","LA","US","Sarah","Dawson","","","","","individual","","A rapid step was heard in the hall - the bride groom had come!","jrn_smd7915.txt","hans.brough@yahoo.com",NULL,20120407110253,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7916","journal","1862-12-07","Linwood","LA","US","Sarah","Dawson","","","","","individual","","With a forced laugh he said, 'Where is my bride? Pshaw! I know she has gone to Clinton!","jrn_smd7916.txt","hans.brough@yahoo.com",NULL,20120407110253,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7917","journal","1862-12-12","Linwood","LA","US","Sarah","Dawson","","","","","individual","","My cripple friend that I mentioned so far back continues to send me the most affecting messages.","jrn_smd7917.txt","hans.brough@yahoo.com",NULL,20120407110253,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7918","journal","1862-12-14","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Yesterday evening, some time before sunset, Mr. Enders was announced, to our great surprise, as we knew he had been in Clinton all the week...","jrn_smd7918.txt","hans.brough@yahoo.com",NULL,20120407110253,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7919","journal","1862-12-26","Linwood","LA","US","Sarah","Dawson","","","","","individual","","We had an exquisite Christmas gift the night before, a magnificent serenade, a compliment from Colonel Breaux.","jrn_smd7919.txt","hans.brough@yahoo.com",NULL,20120407110253,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7920","journal","1863-01-01","Linwood","LA","US","Sarah","Dawson","","","","","individual","","1863! Why I have hardly become accustomed to writing 62 yet! Where has this year gone?","jrn_smd7920.txt","hans.brough@yahoo.com",NULL,20120407110302,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7921","journal","1863-01-04","Linwood","LA","US","Sarah","Dawson","","","","","individual","","One just from Baton Rouge tells us that my presentiment about our house is verified - Yankees do inhabit it, a Yankee colonel and his wife.","jrn_smd7921.txt","hans.brough@yahoo.com",NULL,20120407110302,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7922","journal","1863-01-15","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Two months last Sunday since I have been lying here a cripple, and I am not yet able to take a step.","jrn_smd7922.txt","hans.brough@yahoo.com",NULL,20120407110302,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7923","journal","1863-01-19","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Wheeled into the parlor, there I beheld not my friend alone, but several other individuals whose presence rather startled me.","jrn_smd7923.txt","hans.brough@yahoo.com",NULL,20120407110302,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7924","journal","1863-01-22","Linwood","LA","US","Sarah","Dawson","","","","","individual","","...I can't help wondering if he would be sticky if I touch him. Indeed, I think his hands stick, at least - for when he told me good-bye, it was with the greatest difficulty that I extracted mine from his grasp...","jrn_smd7924.txt","hans.brough@yahoo.com",NULL,20120407110302,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7925","journal","1863-01-23","Linwood","LA","US","Sarah","Dawson","","","","","individual","","A very few people have been insolent enough to say to me, 'Your brother is as good a Yankee as any.' My blood boils as I answer, 'Let him be President Lincoln if he will, and I would love him the same.","jrn_smd7925.txt","hans.brough@yahoo.com",NULL,20120407110302,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7926","journal","1863-01-03","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Some one suggested calling the Spirits, which game I had imagined 'played out' long ago - and we derived a great deal of amusement from it. Six of us around a small table invoked them with the usual ceremony.","jrn_smd7926.txt","hans.brough@yahoo.com",NULL,20120407110302,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7927","journal","1863-02-05","Linwood","LA","US","Sarah","Dawson","","","","","individual","","A letter from Lavinia has come to me all the way from California. How happy it made me, though written so long ago!","jrn_smd7927.txt","hans.brough@yahoo.com",NULL,20120407110302,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7928","journal","1863-02-09","Linwood","LA","US","Sarah","Dawson","","","","","individual","","A letter from my dear little Jimmy! How glad I am, words could not express. This is the first since he arrived in England...","jrn_smd7928.txt","hans.brough@yahoo.com",NULL,20120407110302,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7929","journal","1863-02-18","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Gibbes has gone back to his regiment.","jrn_smd7929.txt","hans.brough@yahoo.com",NULL,20120407110302,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7930","journal","1863-02-22","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Mother has come to me! O how glad I was to see her this morning!","jrn_smd7930.txt","hans.brough@yahoo.com",NULL,20120409100759,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7931","journal","1863-02-23","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Here goes! News has been received that the Yankees are already packed, ready to march against us at any hour.","jrn_smd7931.txt","hans.brough@yahoo.com",NULL,20120409100759,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7932","journal","1863-02-24","Linwood","LA","US","Sarah","Dawson","","","","","individual","","All our friends would be so disappointed at not having an opportunity of saying good-bye.","jrn_smd7932.txt","hans.brough@yahoo.com",NULL,20120409100759,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7933","journal","1863-02-25","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Here we are still, in spite of our expectations.","jrn_smd7933.txt","hans.brough@yahoo.com",NULL,20120409100759,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7934","journal","1863-03-10","Linwood","LA","US","Sarah","Dawson","","","","","individual","","I had so many nice things to say which now, alas, are knocked forever from my head. when news came that the Yankees were advancing on us, and were already within fifteen miles.","jrn_smd7934.txt","hans.brough@yahoo.com",NULL,20120409100759,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7935","journal","1863-03-14","Linwood","LA","US","Sarah","Dawson","","","","","individual","","They are coming! The Yankees are coming at last! For four or five hours the sound of their cannon has assailed our ears. There! that one shook my bed!","jrn_smd7935.txt","hans.brough@yahoo.com",NULL,20120409100759,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7936","journal","1863-03-15","Linwood","LA","US","Sarah","Dawson","","","","","individual","","To my unspeakable surprise, I waked up this morning and found myself alive.","jrn_smd7936.txt","hans.brough@yahoo.com",NULL,20120409100759,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7937","journal","1863-03-17","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Yankees have gone back to Baton Rouge, hearing we had sixty thousand men coming down after them. I believe I am positively disappointed! I did want to see them soundly thrashed!","jrn_smd7937.txt","hans.brough@yahoo.com",NULL,20120409100759,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7938","journal","1863-03-25","Linwood","LA","US","Sarah","Dawson","","","","","individual","","Those vile Yankees have been threatening Ponchatoula, and his battery, with a regiment of infantry, was on its way there to drive them back.","jrn_smd7938.txt","hans.brough@yahoo.com",NULL,20120409100759,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7939","journal","1863-03-31","Linwood","LA","US","Sarah","Dawson","","","","","individual","","'To be, or not to be - that's the question.' Whether tis nobler in the Confederacy to suffer the pangs of unappeasable hunger and never-ending trouble, or to take passage to a Yankee port, and there remaining, end them.","jrn_smd7939.txt","hans.brough@yahoo.com",NULL,20120409100759,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7940","journal","1863-04-07","Linwood","LA","US","Sarah","Dawson","","","","","individual","","I believe that it is for true that we are to leave for New Orleans, via Clinton and Ponchatoula, this evening.","jrn_smd7940.txt","hans.brough@yahoo.com",NULL,20120409100807,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7941","journal","1863-04-08","Clinton","LA","US","Sarah","Dawson","","","","","individual","","What a delightful sensation is motion, after five months inaction!","jrn_smd7941.txt","hans.brough@yahoo.com",NULL,20120409100807,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7942","journal","1863-04-12","Madisonville","LA","US","Sarah","Dawson","","","","","individual","","'...don't pay any attention to her. Pick her up, just as you would a child,' said my incorrigible mother.","jrn_smd7942.txt","hans.brough@yahoo.com",NULL,20120409100807,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7943","journal","1863-04-13","Madisonville","LA","US","Sarah","Dawson","","","","","individual","","I don't know how any one can believe the whole world so wicked - for my part I have met none but the kindest people imaginable - I don't know any wicked ones.","jrn_smd7943.txt","hans.brough@yahoo.com",NULL,20120409100807,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7944","journal","1863-04-14","Madisonville","LA","US","Sarah","Dawson","","","","","individual","","Ah! another delightful glimpse of society has been offered to our charmed view. Such a treat has not often fallen to our lot.","jrn_smd7944.txt","hans.brough@yahoo.com",NULL,20120409100807,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7945","journal","1863-04-16","Madisonville","LA","US","Sarah","Dawson","","","","","individual","","Mr. Halsey brought us each a little tortoise-shellring he had made for us by his camp-fire, as a keep sake, and of course we promised to wear them for him, particularly as they make our hands look as white as possible.","jrn_smd7945.txt","hans.brough@yahoo.com",NULL,20120409100807,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7946","journal","1863-04-18","Bonfouca","LA","US","Sarah","Dawson","","","","","individual","","I have read descriptions of such houses and people, but I have not often seen them. The man and his wife were perfect specimens of the low Canadian, speaking only French.","jrn_smd7946.txt","hans.brough@yahoo.com",NULL,20120409100807,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7947","journal","1863-04-18","Bonfouca","LA","US","Sarah","Dawson","","","","","individual","","Friday morning we arose and prepared to resume our journey for Bonfouca, twenty-three miles away.","jrn_smd7947.txt","hans.brough@yahoo.com",NULL,20120409100807,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7948","journal","1863-04-22","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Yesterday we arrived - I thought we should never get here. Monday we had almost given up in despair, believing the schooner would never return.","jrn_smd7948.txt","hans.brough@yahoo.com",NULL,20120409100807,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7949","journal","1863-04-26","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","I am getting well! Bless the Lord, O my soul! Life, health, and happiness dawn on my trembling view again!","jrn_smd7949.txt","hans.brough@yahoo.com",NULL,20120409100807,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7950","journal","1863-04-03","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","To-day, thousands of families, from the most respectable down to the least, all who have had the firmness to register themselves enemies to the United States, are ordered to leave the city before the fifteenth of May.","jrn_smd7950.txt","hans.brough@yahoo.com",NULL,20120410104747,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7951","journal","1863-06-09","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","There are no Southern young men left in town, and those who remain would hardly be received with civility by Miriam and myself.","jrn_smd7951.txt","hans.brough@yahoo.com",NULL,20120410104747,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7952","journal","1863-06-14","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","If I was a man, if I had the blessed privilege of fighting, I would be on the breastworks, or perchance on the water batteries under Colonel Steadman's command. But as I was unfortunately born a woman, I stay home and pray with heart and soul.","jrn_smd7952.txt","hans.brough@yahoo.com",NULL,20120410104748,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7953","journal","1863-06-17","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Lydia has another boy! Letter has just come, and I am demented about my new godchild!","jrn_smd7953.txt","hans.brough@yahoo.com",NULL,20120410104748,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7954","journal","1863-06-21","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","How about that oath of allegiance? is what I frequently ask myself, and always an uneasy qualm of conscience troubles me. Guilty or not guilty of perjury?","jrn_smd7954.txt","hans.brough@yahoo.com",NULL,20120410104748,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7955","journal","1863-06-26","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","It is so delightful to see these frightened Yankees! One has only to walk downtown to be satisfied of the alarm that reigns.","jrn_smd7955.txt","hans.brough@yahoo.com",NULL,20120410104748,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7956","journal","1863-07-10","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Day before yesterday came tidings that Vicksburg had fallen on the 4th inst. The 'Era' poured out extras, and sundry little popguns fizzled out salutes. All who doubted the truth of the report and were brave enough to say so were fined or imprisoned","jrn_smd7956.txt","hans.brough@yahoo.com",NULL,20120410104748,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7957","journal","1863-07-10","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","What a scene I have just witnessed! A motley crew of thousands of low people of all colors parading the streets with flags, torches, music, and all other accompaniments, shouting, screaming, exulting over the fall of Port Hudson and Vicksburg.","jrn_smd7957.txt","hans.brough@yahoo.com",NULL,20120410104748,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7958","journal","1863-07-15","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Dreadful news has come of the defeat of Lee at Gettysburg. Think I believe it all? He may have been defeated - but not one of these reports of total overthrow and rout do I credit.","jrn_smd7958.txt","hans.brough@yahoo.com",NULL,20120410104748,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7959","journal","1863-07-18","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","It began by Miriam sending Mr. Conn a box of cigars when she was on Canal the other day, with a note saying we would be delighted to assist him in anyway. Poor creature!","jrn_smd7959.txt","hans.brough@yahoo.com",NULL,20120410104748,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7960","journal","1863-07-23","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Put a creature you don't care for in the least, in a situation that commands sympathy, and nine out of ten girls will fall desperately in love.","jrn_smd7960.txt","hans.brough@yahoo.com",NULL,20120411095652,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7961","journal","1863-08-14","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","DOOMED to be bored! To-night Miriam drags me to a soiree musicale","jrn_smd7961.txt","hans.brough@yahoo.com",NULL,20120411095652,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7962","journal","1863-00-16","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Coming out of church this morning with Miriam, a young lady ran up with an important air, as though about to create a sensation.","jrn_smd7962.txt","hans.brough@yahoo.com",NULL,20120411095653,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7963","journal","1863-08-24","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","I consider myself outrageously imposed upon! I am so indignant that I have spent a whole evening making faces at myself.","jrn_smd7963.txt","hans.brough@yahoo.com",NULL,20120411095653,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7964","journal","1863-09-10","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","O my prophetic soul! part of your forebodings are already verified! And in what an unpleasant way!","jrn_smd7964.txt","hans.brough@yahoo.com",NULL,20120411095653,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7965","journal","1863-00-25","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Write me down a witch, a prophetess, or what you will. I am certainly something! All has come to pass on that very disagreeable subject very much as I feared.","jrn_smd7965.txt","hans.brough@yahoo.com",NULL,20120411095653,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7966","journal","1863-10-06","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","I hope this will be the last occasion on which I shall refer to the topic to which this unfortunate book seems to have been devoted.","jrn_smd7966.txt","hans.brough@yahoo.com",NULL,20120411095653,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7967","journal","1863-11-09","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Another odd link of the old, stale story has come to me, all the way from New York.","jrn_smd7967.txt","hans.brough@yahoo.com",NULL,20120411095653,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7968","journal","1863-11-22","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","A report has just reached us that my poor dear Gibbes has been taken prisoner along with the rest of Hayes's brigade.","jrn_smd7968.txt","hans.brough@yahoo.com",NULL,20120411095653,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7969","journal","1863-11-26","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Brother has applied to have him paroled and sent here, or even imprisoned here, if he cannot be paroled.","jrn_smd7969.txt","hans.brough@yahoo.com",NULL,20120411095653,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7970","journal","1863-11-30","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Our distress about Gibbes has been somewhat relieved by good news from Jimmy.","jrn_smd7970.txt","hans.brough@yahoo.com",NULL,20120411095702,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7971","journal","1863-12-31","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","The last of eighteen sixty-three is passing away as I write...","jrn_smd7971.txt","hans.brough@yahoo.com",NULL,20120411095702,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7972","journal","1864-02-03","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Not dead! not dead! O my God! Gibbes is not dead! Where O dear God ! Another?","jrn_smd7972.txt","hans.brough@yahoo.com",NULL,20120411095702,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7973","journal","1864-03-00","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Dead! Dead! Both dead! O my brothers! What have we lived for except you?","jrn_smd7973.txt","hans.brough@yahoo.com",NULL,20120411095702,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7974","journal","1864-11-02","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","This morning we heard Jimmy is engaged to Helen Trenholm, daughter of the Secretary of the Confederate States.","jrn_smd7974.txt","hans.brough@yahoo.com",NULL,20120411095702,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7975","journal","1864-12-31","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","O sad, dreary, fearful Old Year! I see you go with pain! Bitter as you have been, how do we know what the coming one has in store for us?","jrn_smd7975.txt","hans.brough@yahoo.com",NULL,20120411095702,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7976","journal","1865-04-19","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Thursday the 13th came the dreadful tidings of the surrender of Lee and his army on the 9th. Everybody cried, but I would not, satisfied that God will still save us, even though all should apparently be lost.","jrn_smd7976.txt","hans.brough@yahoo.com",NULL,20120411095702,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7977","journal","1865-04-22","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","For the more violently 'Secesh ' the inmates, the more thankful they are for Lincoln's death, the more profusely the houses are decked with the emblems of woe.","jrn_smd7977.txt","hans.brough@yahoo.com",NULL,20120411095702,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7978","journal","1865-05-02","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","While praying for the return of those who have fought so nobly for us, how I have dreaded their first days at home!","jrn_smd7978.txt","hans.brough@yahoo.com",NULL,20120411095702,NULL,71,0);
  INSERT INTO media VALUES ("jrn_smd7979","journal","1865-06-15","New Orleans","LA","US","Sarah","Dawson","","","","","individual","","Our Confederacy has gone with one crash - the report of the pistol fired at Lincoln.","jrn_smd7979.txt","hans.brough@yahoo.com",NULL,20120411095702,NULL,71,0);
  