Started 1923, pg 17-55 | Gwulo: Old Hong Kong

Started 1923, pg 17-55

This is the latest Jurors List we're making searchable - here's how to join in, it'll only take around 30 minutes of your time.

We'll take the previous year's spreadsheet, then work through it page-by-page and edit in any changes so it matches this year's Jurors List.

Step 1. Check the comments below to see which was the last page someone has started typing. You'll work on the next page. eg if the last comment is "started page 20", you'll be working on page 21. NB we use the page number as printed at the top of the original page, not the page number as shown in the Acrobat reader.

Step 2. Click here to open up the original Jurors List document. (If you just see a 'Hong Kong Government Reports Online' screen, please click the link again. For some reason the first click doesn't always work, but the second one does.)

Step 3. Then click here to open up the spreadsheet.

Step 4. Use the "Add new comment" link below to leave a comment, 'started page ...' to let people know this page is yours. (eg "started page 16")

Step 5. Page down through the original document til you reach your page.

Step 6. Make a note of the name at the top of the page

Step 7. Find the name in the spreadsheet. At this point you'll have three options:

7.1 The name is in the spreadsheet, and all the details are already correct.
Lucky you!
- Just type your page number into the 'page' column, then skip ahead to step 8.

7.2 The name is in the spreadsheet, but one or more details are different.
eg there's a change in spelling, or they've moved to a new address, or maybe you're catching a spelling mistake in the person's name made by the previous typist, then:
- Type your page number into the first column, 'page'.
- Correct the other columns as appropriate

7.3 The name isn't in the spreadsheet
They must be a new juror, so we'll need to add them to the spreadsheet.
- Insert a new row at the right place in the spreadsheet
- Type your page number into the first column, 'page'.
The other columns should be easy to understand, but a few tips:
- 'Type': either 's' or 'c', depending on whether you're typing in the details of a Special Juror or a Common Juror. (You'll see the list is split into two sections, with Special Jurors listed first).
- The 'Name' and 'Occupation' columns just follow the information from the list, though you'll see I've split the original 'Name in Full' column into Family name and Given name columns. Similarly the Occupation column is split into Title and Company.
- The original 'Abode' column has been split into four columns. Use your judgement how to split up a given address, and don't worry about getting it right or wrong.

Other typing guidelines
- Just type exactly what you see in the Jurors List, except:
- we're not typing in any accented characters. eg for ü just type u, or foré just type e.
 - there's no need to type the final comma after a company name. eg the list shows "Gilman & Co.," but we type "Gilman & Co."

Step 8. Go to the next name in the Jurors List and repeat step 7. Repeat this until you reach the bottom of the page.

Step 9. Double-check by comparing the spreadsheet against the page in the Jurors List, line by line (it's surprisingly easy to make a mistake the first time through).

If you missed adding any lines, follow step 7.3 to add them.

If you find a line in the spreadsheet that isn't in the Jurors List, delete it from the spreadsheet (these are people that left Hong Kong since the previous year's list was published).

Step 10. Save the spreadsheet, and email it back to me at 

David's email address

I'll gather them all together and once I've received all the pages I'll format them then post them up here.

Step 11. You're done! (Note there's no need to leave any comment once the page is finished). Thanks very much for your help. I hope you'll come back again soon and help with another page.

Anything not clear? Please leave a comment below if you have any questions.

Regards, David

started page 17

started page 18

started page 19

Page 20 

started p 21

p. 22

p.23

p.24

Started p25

p. 26

27-29

Started 30

started p.31

started p.32

started p.33

started p.34

started p.35

started p.36

started p.37

started p.38 & 39

In iyom's multi-page typing above, they have used the page numbers shown in the Acrobat reader, where I had in mind to use the printed page numbers.

No problem - iyom has typed up the last pages of the list, pages 47-54 going by the printed page numbers. We'll continue typing from page 31, which starts with the line for "Hannibal, Walter Albert", then stop at page 46. At that point all the list will have been typed.

I've also added a note to the instructions at the top of the page to clarify that we're using the printed page numbers.

Regards, David

started page 31

p32

started page 33

started page 34

started page 35

started page 36

started page 37

started page 38

started page 39

started page 40

Started page 41

started page 42

started page 43

started page 44

started page 45

Started page 46

All done! Thanks for all the help, and stay tuned for the 1924 list. Regards, David