names

165 rows where place_id = 588924

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596010 1866380 1866380 defendant Apryce John gent 588924 588924 Apryce, John, of Farnham, gent 2
3600506 1867806 1867806 defendant Nunnys William miller 588924 588924 Nunnys, William, of Farnham, miller 0
3600750 1867892 1867892 defendant Aylewarde Simon gent 588924 588924 Aylewarde, Simon, of Farnham, gent 0
3600764 1867899 1867899 defendant Aylward Simon gent 588924 588924 Aylward, Simon, of Farnham, gent 0
3603373 1868727 1868727 defendant Colvyle Richard husbandman 588924 588924 Colvyle, Richard, of Farnham, husbandman 0
3628617 1903825 1903825 defendant Quynby Henry clothman 588924 588924 Quynby, Henry, of Farnham, clothman 0
3631698 1904726 1904726 defendant Chamberleyn Thomas tailor 588924 588924 Chamberleyn, Thomas, of Farnham, tailor 1
3632050 1904841 1904841 defendant Stanton John yeoman 588924 588924 Stanton, John, of Farnham, yeoman 1
3633831 1905392 1905392 defendant Theyre Stephen butcher 588924 588924 Theyre, Stephen, of Farnham, butcher 1
3637433 1906514 1906514 defendant Battyll William, senior yeoman 588924 588924 Battyll, William, senior, of Farnham, yeoman 0
3665016 1915003 1915003 defendant Wayford John   588924 588924 Wayford, John, of Farnham, cloth man 3
3676299 1918630 1918630 defendant Theyre Stephen butcher 588924 588924 Theyre, Stephen, of Farnham, butcher 0
3690212 1923097 1923097 defendant Handrowe John (legal representative) 588924 588924 Handrowe, John, of Farnham, administrator of 3
3699933 1926210 1926210 defendant Brewyn John gent 588924 588924 (Brewyn, John, of Farnham, gent 1
3704388 1927672 1927672 defendant Turner George fuller 588924 588924 Turner, George, of Farnham, fuller 0
3704389 1927672 1927672 defendant Turner John fuller 588924 588924 Turner, John, of Farnham, fuller 1
3704390 1927672 1927672 defendant Creswll Oliver fuller 588924 588924 Creswll, Oliver, of Farnham, fuller 2
3735446 1937323 1937323 defendant Wydoson Reginald clothier 588924 588924 Wydoson, Reginald, of Farnham, clothier 0
3744845 1940287 1940287 defendant Avenell John baker 588924 588924 Avenell, John, of Farnham, baker 0
3775807 1950182 1950182 defendant Dayer Stephen butcher 588924 588924 Dayer, Stephen, of Farnham, butcher 0
3794594 1956187 1956187 defendant Awsten Richard innholder 588924 588924 Awsten, Richard, of Farnham, innholder 1
3794596 1956188 1956188 defendant Sperge John fuller 588924 588924 Sperge, John, of Farnham, fuller 0
3832599 1968119 1968119 plaintiff Huntley John   588924 588924 Huntley, John, of Farnham 0
3897223 1989289 1989289 plaintiff Westwood Nicholas   588924 588924 Westwood, Nicholas, of Farnham 0
3908249 1993056 1993056 defendant Rede John barber 588924 588924 Rede, John, of Farnham, barber 0
3908250 1993056 1993056 defendant Bankys Hugh mercer 588924 588924 Bankys, Hugh, of Farnham, mercer 1
3921963 1997689 1997689 defendant Grenyng John fuller 588924 588924 Grenyng, John, of Farnham, fuller 0
3983918 2019016 2019016 defendant Bery Ralph yeoman 588924 588924 Bery, Ralph, of Farnham, yeoman 0
4002407 2025639 2025639 defendant Baynbrigg or Benbryk Ralph yeoman 588924 588924 Baynbrigg or Benbryk, Ralph, of Farnham, yeoman 1
4002412 2025640 2025640 defendant Baynbrigg or Benbryk Ralph yeoman 588924 588924 Baynbrigg or Benbryk, Ralph, of Farnham, yeoman 1
4002417 2025641 2025641 defendant Baynbrygge or Benbricke Ralph yeoman 588924 588924 Baynbrygge or Benbricke, Ralph, of Farnham, yeoman 1
4025594 2033809 2033809 defendant Brooke Roger husbandman 588924 588924 Brooke, Roger, of Farnham, husbandman 0
4129587 2070885 2070885 defendant Smithe Thomas husbandman 588924 588924 Smithe, Thomas, of Farnham, husbandman 2
4196510 2094322 2094322 defendant Kyrley Walter husbandman 588924 588924 Kyrley, Walter, of Farnham, husbandman 0
4196511 2094322 2094322 defendant Kyrley Richard husbandman 588924 588924 Kyrley, Richard, of Farnham, husbandman 1
4224736 2104122 2104122 defendant More John chapman 588924 588924 More, John, of Farnham, chapman 0
4226440 2104718 2104718 defendant Browne Thomas husbandman 588924 588924 Browne, Thomas, of Farnham, husbandman 0
4325090 2138774 2138774 defendant Smythe Nicholas husbandman 588924 588924 Smythe, Nicholas, of Farnham, husbandman 2
4453984 2186262 2186262 defendant Serle Wiliam   588924 588924 Serle, Wiliam, of Farnham 1
4459524 2188034 2188034 defendant Thame John   588924 588924 Thame, John, of Farnham 0
4459535 2188036 2188036 defendant Thame John   588924 588924 Thame, John, of Farnham 1
4459555 2188043 2188043 defendant Thame John   588924 588924 Thame, John, of Farnham 2
4459562 2188045 2188045 defendant Thame John   588924 588924 Thame, John, of Farnham 0
4459579 2188049 2188049 defendant Thame John   588924 588924 Thame, John, of Farnham 2
4459586 2188051 2188051 defendant Thame John   588924 588924 Thame, John, of Farnham 0
4463126 2189167 2189167 defendant Blockelegh John   588924 588924 Blockelegh, John, of Farnham 0
4463127 2189167 2189167 defendant Neweman John   588924 588924 Neweman, John, of Farnham 1
4463128 2189167 2189167 defendant Spore Christine   588924 588924 Spore, Christine, of Farnham 2
4485344 2196116 2196116 defendant Ouldene William   588924 588924 Ouldene, William, of Farnham 5
4510409 2203713 2203713 defendant Sompnour Henry   588924 588924 Sompnour, Henry, of Farnham 1
4510412 2203714 2203714 defendant Sompnour Henry   588924 588924 Sompnour, Henry, of Farnham 1
4512946 2204481 2204481 defendant Dane William   588924 588924 Dane, William, of Farnham 1
4560253 2219157 2219157 plaintiff Myriel John   588924 588924 Myriel, John, of Farnham 0
4592281 2228933 2228933 defendant Barret William   588924 588924 Barret, William, of Farnham 0
4602352 2231952 2231952 defendant Yonge Richard   588924 588924 Yonge, Richard, of Farnham 0
4608973 2233909 2233909 defendant Neel John   588924 588924 Neel, John, of Farnham 0
4614758 2235628 2235628 defendant Shire John   588924 588924 Shire, John, of Farnham 0
4634762 2241722 2241722 defendant Shere John   588924 588924 Shere, John, of Farnham 0
4634802 2241735 2241735 plaintiff Wylday John   588924 588924 Wylday, John, of Farnham 0
4652042 2246573 2246573 plaintiff atte Dane Richard, junior   588924 588924 atte Dane, Richard, junior, of Farnham 0
4653179 2246930 2246930 defendant Mascall John husbandman 588924 588924 Mascall, John, of Farnham, husbandman 0
4653180 2246930 2246930 defendant Dene Edward husbandman 588924 588924 Dene, Edward, of Farnham, husbandman 1
4653181 2246930 2246930 defendant Baldewyne John husbandman 588924 588924 Baldewyne, John, of Farnham, husbandman 2
4657293 2248172 2248172 defendant Mascall John husbandman 588924 588924 Mascall, John, of Farnham, husbandman 0
4671236 2256658 2256658 defendant Neel John Surr, ostler 588924 588924 Neel John, of Farnham, Surr, ostler 3
4678780 2258967 2258967 defendant Twythever Robert husbandman 588924 588924 Twythever, Robert, of Farnham, husbandman 0
4681842 2259933 2259933 defendant Bailly John farmer 588924 588924 Bailly, John, of Farnham, farmer 0
4698783 2265100 2265100 defendant Laurens John chapman 588924 588924 Laurens, John, of Farnham, chapman 3
4704792 2266877 2266877 defendant Laurence John husbandman 588924 588924 Laurence, John, of Farnham, husbandman 0
4708032 2267885 2267885 plaintiff Muryell John   588924 588924 Muryell, John, of Farnham 0
4708033 2267885 2267885 defendant Cartere John husbandman 588924 588924 Cartere, John, of Farnham, husbandman 0
4708034 2267885 2267885 defendant Twychene Robert yeoman 588924 588924 Twychene, Robert, of Farnham, yeoman 1
4708035 2267885 2267885 defendant Tilye William husbandman 588924 588924 Tilye, William, of Farnham, husbandman 2
4718427 2271101 2271101 plaintiff Bakere William   588924 588924 Bakere, William, of Farnham 0
4718428 2271101 2271101 defendant Deynes William clerk 588924 588924 Deynes, William, of Farnham, clerk 0
4723853 2272763 2272763 defendant Gynger Wiliam   588924 588924 Gynger, Wiliam, of Farnham, holy water clerk 1
4730707 2274802 2274802 defendant Webbe John weaver 588924 588924 Webbe, John, of Farnham, weaver 0
4732685 2275403 2275403 defendant Twychever Robert husbandman 588924 588924 Twychever, Robert, of Farnham, husbandman 0
4735221 2276163 2276163 defendant Fykes John yeoman 588924 588924 Fykes, John, of Farnham, yeoman 1
4778158 2289160 2289160 defendant Kayme William smith 588924 588924 Kayme, William, of Farnham, smith 3
4778159 2289160 2289160 defendant Melerst John, junior laborer 588924 588924 Melerst, John, junior, of Farnham, laborer 4
4792293 2293678 2293678 defendant Osteler Thomas ostler 588924 588924 Osteler, Thomas, of Farnham, ostler 0
4840611 2308603 2308603 plaintiff Horne Peter   588924 588924 Horne, Peter, of Farnham 0
4853391 2312473 2312473 defendant Dudwell William tailor 588924 588924 Dudwell, William, of Farnham, tailor 0
4856659 2313460 2313460 defendant South Henry laborer 588924 588924 South, Henry, of Farnham, laborer 0
4856660 2313460 2313460 defendant Pilleshurst Thomas fuller 588924 588924 Pilleshurst, Thomas, of Farnham, fuller 1
4856661 2313460 2313460 defendant Osteler John skinner 588924 588924 Osteler, John, of Farnham, skinner 2
4867855 2316919 2316919 plaintiff Horne Peter   588924 588924 Horne, Peter, of Farnham 0
4896934 2325692 2325692 defendant Hatte John weaver 588924 588924 Hatte, John, of Farnham, weaver 0
4913927 2330864 2330864 defendant Gafayre Philip ostler 588924 588924 Gafayre, Philip, of Farnham, ostler 0
4931369 2336192 2336192 defendant Fyssn John clothmaker 588924 588924 Fyssn, John, of Farnham, clothmaker 1
4931374 2336193 2336193 defendant Fyssh John clothmaker 588924 588924 Fyssh, John, of Farnham, clothmaker 1
4971205 2348326 2348326 defendant Hat John weaver 588924 588924 Hat, John, of Farnham, weaver 1
4984939 2352426 2352426 defendant Antersey Richard laborer 588924 588924 Antersey, Richard, of Farnham, laborer 0
4984941 2352427 2352427 defendant Lyncher Thomas tailor 588924 588924 Lyncher, Thomas, of Farnham, tailor 0
5006680 2358850 2358850 defendant Coke Philip husbandman 588924 588924 Coke, Philip, of Farnham, husbandman 1
5011217 2360136 2360136 defendant Stonard Robert husbandman 588924 588924 Stonard, Robert, of Farnham, husbandman 0
5011218 2360136 2360136 defendant Benet John weaver 588924 588924 Benet, John, of Farnham, weaver 1
5018072 2362169 2362169 defendant Ram or Rain John fuller 588924 588924 Ram or Rain, John, of Farnham, fuller 0
5048204 2371093 2371093 defendant Burgeys Richard   588924 588924 Burgeys, Richard, of Farnham, bailiff 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);