Jurors Lists


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,


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

... 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.

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,



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

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

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,



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?

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

Regards, David

No, the content is identical.

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

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.

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

The list appears to have now been completed on the working spreadsheet to the end of page 37

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.

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.


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