{"id":421,"date":"2021-01-24T20:42:03","date_gmt":"2021-01-24T20:42:03","guid":{"rendered":"http:\/\/drstephenrobertson.com\/hist395\/?page_id=421"},"modified":"2024-12-02T17:49:42","modified_gmt":"2024-12-02T17:49:42","slug":"dataset-instructions","status":"publish","type":"page","link":"https:\/\/drstephenrobertson.com\/hist395\/dataset-instructions\/","title":{"rendered":"Dataset Instructions"},"content":{"rendered":"

Go to the dataset template (titled ‘Updated Dataset Assignment’)<\/a><\/p>\n

Click on File, select Make a copy, and give it the name of your dataset \u2013 crime_newspaper title — then select folder on your drive to save it to your Google Drive, so you can add your data to it<\/p>\n

\"\"<\/p>\n

There are 3 stories included as examples; add your data below them, and once you\u2019re done, come back and delete the 3 rows (NB the titles of each column are the fields they will map on to in Omeka – DO NOT CHANGE THEM<\/strong>)<\/p>\n

    \n
  1. \n
      \n
    1. Column A: Title of story<\/li>\n
    2. Column B: Title of newspaper \u2013 include the abbreviation for the state in brackets. This will be the same for every row, so just enter it in row one, and when all the rows are entered, return to row one, click on the this field \u2013 a blue line will appear around the field, with a blue square in the bottom right corner \u2013 click on the square and drag it to the bottom row in your data. That will fill all the rows with the value in the first row<\/li>\n
    3. Column C: date of the story \u2013 make sure you use the format YYYY-MM-DD<\/li>\n
    4. Column D: the page that the story appears on in the newspaper<\/li>\n
    5. Column E: the link to the page in Chronicling America \u2013 use the link that appears under the image of the page<\/li>\n
    6. Column F: first either \u201cIn-state\u201d or \u201cOut-of-state\u201d depending on whether the crime in the story takes place in the state in which the newspaper is published or outside that state; then a ; & a space<\/strong>, and then the address of the crime \u2013 that could be a street address or just a town, with the abbreviation for the state<\/li>\n
    7. Column G: the crime. This will be the same for every row, so just enter it in row one, and when all the rows are entered, return to row one, click on the this field \u2013 a blue line will appear around the field, with a blue square in the bottom right corner \u2013 click on the square and drag it to the bottom row in your data. That will fill all the rows with the value in the first row<\/li>\n
    8. Column H: keywords that provide details of the crime (not race and gender because they are in the next columns). The examples include information about age of the victim (child), the nature of the assault (Biting, Beating), who was involved (Celebrity, Caregiver). Try to include more than one keyword for each crime. Make sure you separate each keyword with a ; & a space.<\/li>\n
    9. Column I: The race of the alleged offender: Black, white, Chinese, Mexican etc. Use the phrasing “Black alleged victim,” etc. If this information is not in your story, leave it blank<\/li>\n
    10. Column J: The gender of the alleged offender: either \u201cMale alleged offender\u201d or \u201cFemale alleged offender.” If this information is not in your story, leave it blank.<\/li>\n
    11. Column K: The race of the alleged victim: Black, white, Chinese, Mexican etc. Use the same phrasing as in column I: eg Black alleged victim. If this information is not in your story, leave it blank.<\/li>\n
    12. Column L: The gender of the alleged victim: either \u201cMale alleged victim\u201d or \u201cFemale alleged victim.” If this information is not in your story, leave it blank.<\/li>\n
    13. Column M: the law enforcement involved: police, sheriff, private detective, mob. If this information is not in your story, leave it blank<\/li>\n
    14. Column N: the stage of the legal system: crime, extralegal (eg lynching), arrest, arraignment (held for trial), trial, sentencing.<\/li>\n
    15. Column O: the corrected text of your story\n
        \n
      1. In Chronicling America, click on the Image w\/Text link at the top of the window<\/li>\n
      2. In the OCR window, use your search term (eg assault) to find the text of your story<\/li>\n
      3. Cut and paste that text into a Word document<\/li>\n
      4. Correct any errors in the text \u2013 look at the image of the newspaper to get the correct text<\/li>\n
      5. Select Save as, and save as a Plain Text (.txt) file (keep these files)<\/li>\n
      6. Copy and paste the text into Column K<\/li>\n<\/ol>\n<\/li>\n
      7. Column P: word length of the story \u2013 use the Word count tool in Word to find the length<\/li>\n
      8. Column Q: Paste the link to the pdf of the story: in Chronicling America, scroll down to the Download box, check PDF is selected and click GO, then copy the link from your browser into this column (the url should begin ’tile.loc.gov’)<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

        When all your data is entered, click on File, select Download as, and then Comma-Separated Value, and download the sheet to your desktop<\/p>\n

        \"\"<\/p>\n

        Email your csv file to Professor Robertson<\/p>\n","protected":false},"excerpt":{"rendered":"

        Go to the dataset template (titled ‘Updated Dataset Assignment’) Click on File, select Make a copy, and give it the name of your dataset \u2013 crime_newspaper title — then select folder on your drive to…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"fullwidth.php","meta":{"footnotes":""},"class_list":["post-421","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/pages\/421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/comments?post=421"}],"version-history":[{"count":14,"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/pages\/421\/revisions"}],"predecessor-version":[{"id":609,"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/pages\/421\/revisions\/609"}],"wp:attachment":[{"href":"https:\/\/drstephenrobertson.com\/hist395\/wp-json\/wp\/v2\/media?parent=421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}