Jurors Lists | Gwulo: Old Hong Kong

Jurors Lists

Primary tabs

Submitted by David on Sun, 2010-07-11 14:23

The Jurors Lists are a great resource for information about people, companies and places in Hong Kong.

We're currently typing them out so they are searchable on the web, but until we're finished you can find the full set (and lots more besides) at the HKGRO website. At HKGRO, search for jury list to see the lists from 1854-1893, or search for jurors list to see the lists from 1894-1941.

  • Log in or register to post comments

Comments

Submitted by tngan on Fri, 2010-10-08 12:40.

Hi there,

I was wondering..... if we could use pivot table on the lists.  Pivot table is an excellent to analyse information like these lists.

Thanks & Best Regards,

T

Submitted by David on Fri, 2010-10-08 15:41.

Thomas, I haven't used them before, so I'm not sure what the benefits are, or how easy they are to add to our website.

If you can set up a demo, or show us another site's web-page that is similar to what you have in mind, that would be helpful.

Regards, David

Submitted by annelisec on Fri, 2010-10-08 16:33.


... because they can help date when a building was built, by when it pops up on the Jury lists.  I was delighted to see Victoria Lodge and Elliott Cresent pop up and interested in the date.  Also being able to see when Woodlands was likely redeveloped was fun.

Submitted by tngan on Fri, 2010-10-08 17:19.

Hi David,

I have not seen Pivot Tables being used on websites before.  But if you could send me (or tell me how to download) one of those spreadsheets, I could create the pivot table in a new sheet and send it back to your for your reference.

I have been using pivot tables for a while, to pick on data.  It's very useful for grouping, sub-totles, and cross references.  Depending on data type you could have different views just by dragging the information, just like the demo (in the M$ link) shows you.  Say, group by company name, group by Surname, group by First Name, subtotal or a count of all grouped fields, etc.

Best Regards,

T

Submitted by annelisec on Fri, 2010-10-08 18:21.

 

You can cut-and-paste the tables on the web page directly into Excel

Submitted by David on Sun, 2010-10-10 12:57.

Hi Thomas,

Thanks for sending over the pivot table. I'm using OpenOffice, but it has something very similar. I had a quick play with it and I see now how it can be useful.

Maybe there's a way to get some similar functionality on the website, but I don't plan to look into it right now. At this point I'll let people cut & paste into a spreadsheet if they want to use this.

Regards, David

Submitted by tngan on Mon, 2010-10-11 00:57.

Dear David,

Yes, it is quite nice if one wants to sort multiple columns and change the view.  Using Pivot Tables, you could just drag the fields/columns to different locations for different views.

It would also be useful if you want to count.  In the Pivot Table I sent over, I have hidden the sub-totals.  Under M$ Excel the sub-totals are on by default.

To use Excel spreadsheet for pivot tables would have the drawback of the limited number of rows supported.  It is good to know that if the database is really big, you could also use pivot table in M$ Access.  I'm unfamiliar with the detailed functions of Open Office, but I guess it should have something similar.

Best Regards,

T

 

Submitted by Douglas on Mon, 2014-12-15 17:13.

I have searched "jurors list" at the GRO website above, and 2 separate lists come up for each year, one from the "Sessional Papers" entitled "List for 19XX Jurors" and one from the "Government Gazette" entitled "Jurors List for 19XX"; could someone tell me what the diference is between these two? Is one an internal document for LegCo, and the other a public announcement?

Submitted by David on Mon, 2014-12-15 21:05.

I'm not sure. Do their contents differ at all?

Regards, David

Submitted by Douglas on Tue, 2014-12-16 11:24.

No, the content is identical.

Submitted by David on Tue, 2014-12-16 18:04.

Then I think you're right that the jurors lists were published to LegCo first before they were made public in the Gazette. Perhaps members of Legco had the option to object to someone they thought unsuitable to be a juror?

Regards, David

Submitted by Michael Ogden on Tue, 2017-01-31 16:01.
Thank you whoever compiled from this particular list. I was able to find 49 people who worked for Chartered Bank of India, Australia and China.

Submitted by David on Tue, 2017-01-31 19:49.

That was one I did - glad it helped. If you'd like to help in return, we're just four pages away from finishing the 1922 list so if you could help type a page that'll be great: http://gwulo.com/current-j-list

Submitted by Michael Ogden on Wed, 2017-02-01 00:04.
The list appears to have now been completed on the working spreadsheet to the end of page 37

Submitted by David on Wed, 2017-02-01 16:05.

The working spreadsheet is a copy of the 1921 list, so the end of the working spreadsheet does show many of the same names you'll see on page 37 of the 1922 list.

There are still many differences though, so we're currently working through it page at a time to prepare the spreadsheet version of the 1922 list.

Submitted by howzend on Mon, 2017-07-24 22:54.

Hi David,

Someone just sent me the lists from 1924 - 1940 in PDF format. If you want them, let me know how I can send them to you.

Howard

Submitted by Admin on Mon, 2017-07-24 23:45.

Hi Howard,

Thanks for the offer. The other years' lists aren't really missing (see details of where to get them at the top of this page), just pending while we type them up. All help with typing pages gratefully received!

Regards, David