FamilySearch Wiki:Wiki Project Norway Census Codes

Norway Census District Codes
Project Leader: Amber Larsen Purpose: The purpose of this project is to compile Spreadsheet: Spreadsheet link Archives Website: Website link

Part 1: Spreadsheet
1. Open the Spreadsheet, and make sure you are on Sheet 1.

2. Scroll down until you get to the last content added to the sheet (see example below).



3. Identify the Code of the last-entered content in the "Code" column
 * Example above: the last-entered code would be 411.

Part 2: Archives Website
4. Open the Archives Website link. It should take you directly to the page giving the results of the 1891 Norway Census information.

5. Scroll down the list of results in the Archives Website (or use Ctrl + F) to find the Code number of the last-entered content from step 3 above. You'll begin with the next city/code in the list of results.

6. In the Spreadsheet, find the first row underneath the most recently-added content, and click on the cell in that row in the "Code" column (see example below)



7. In that cell, type the number of the next city in the list of results on the Archives website. (see example below)



8. Typing in the number from the Archives Website list will automatically populate the Spreadsheet with the name associated with that code with the corresponding code from the "Code" tab (see below).



9. Compare the name of the city from the Archives website with the name automatically generated by the Spreadsheet from step 8. If the names are different, continue to step 10. If the names are a match, skip to step 12.

10. If the city names are different, go to the "Code" sheet of the Spreadsheet, and Ctrl + F for the city code number to easily navigate to the respective cell in the sheet.

11. Type the correct name of the city in the cell in the "Kommune 1" column.

Part 3: Add Info to the Spreadsheet
12. Back on the Archives website, click on "Browse scans" for the city (see example below). This will take you to the Details page.



13. On the Details page, look in the left-hand column of the table and find the "Hovedlister" entries. Copy all of the content ONLY for the rows that are titled "Hovedlister" (see example below).



14. Paste the text you copied into Notepad (if you have a Windows computer, you can find Notepad by searching for it in the Windows start menu).
 * NOTE: the code needs to be Pasted into Notepad before it can be put into the Spreadsheet because adding it to Notepad removes all extraneous font and style code that would mess with the Spreadsheet formatting.



15. After you have Copied and Pasted the code into Notepad, Copy the code from Notepad and Paste it into the empty cell in the "List" column next to the first entry of the associated City name (see example below)



16. Continue to the next city in the Archives website list, and start again at step 1.