names

49 rows where place_id = 586164

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588063 1863916 1863916 defendant Kynnesforthe Thomas chapman 586164 586164 Kynnesforthe, Thomas, of Henley in Ardern, chapman 4
3588585 1864074 1864074 defendant Staunton Walter yeoman 586164 586164 (Staunton, Walter, of Henley in Ardern, yeoman 1
3643007 1908260 1908260 defendant Jamys alias Tayllour John butcher 586164 586164 Jamys alias Tayllour, John, of Henley in Ardern, butcher 0
3643287 1908325 1908325 defendant Smyth John yeoman 586164 586164 Smyth, John, of Henley in Ardern, yeoman 1
3693469 1924170 1924170 defendant Brereton Robert gent 586164 586164 Brereton, Robert, of Henley in Ardern, gent 0
3695127 1924694 1924694 defendant Benett Thomas dyer 586164 586164 Benett, Thomas, of Henley in Ardern, dyer 0
3734881 1937149 1937149 defendant Page William smith 586164 586164 Page, William, of Henley in Ardern, smith 2
3788830 1954309 1954309 defendant Cowper William tanner 586164 586164 Cowper, William, of Henley in Ardern, tanner 1
3897286 1989311 1989311 defendant Johnson John smith 586164 586164 Johnson, John, of Henley in Ardern, smith 1
4470751 2191505 2191505 plaintiff Felton Simon   586164 586164 Felton, Simon, of Henley in Ardern 1
4608013 2233625 2233625 defendant Barbour Thomas   586164 586164 Barbour, Thomas, of Henley in Ardern 2
4615676 2235905 2235905 plaintiff Felton Simon   586164 586164 Felton, Simon, of Henley in Ardern 0
4615682 2235907 2235907 plaintiff Swetton John   586164 586164 Swetton, John, of Henley in Ardern 1
4641198 2243518 2243518 plaintiff Felton Simon   586164 586164 Felton, Simon, of Henley in Ardern 0
4661478 2249418 2249418 plaintiff Elege John   586164 586164 Elege, John, of Henley in Ardern 0
4722556 2272369 2272369 defendant Cokkus John tanner 586164 586164 Cokkus, John, of Henley in Ardern, tanner 1
4731455 2275038 2275038 defendant Pulton Thomas husbandman 586164 586164 Pulton, Thomas, of Henley in Ardern, husbandman 0
4746823 2279572 2279572 defendant Barker John tanner 586164 586164 Barker, John, of Henley in Ardern, tanner 0
4755038 2281961 2281961 defendant Pakwode Richard skinner 586164 586164 Pakwode, Richard, of Henley in Ardern, skinner 2
4825098 2303892 2303892 defendant Leyburn John tanner 586164 586164 Leyburn, John, of Henley in Ardern, tanner 0
4838903 2308099 2308099 defendant Porry Thomas butcher 586164 586164 Porry, Thomas, of Henley in Ardern, butcher 0
4838904 2308099 2308099 defendant Barbour Edmund barber 586164 586164 Barbour, Edmund, of Henley in Ardern, barber 1
4838906 2308099 2308099 defendant Goldsmyth Agnes single woman 586164 586164 Goldsmyth, Agnes, of Henley in Ardern, single woman 3
4839618 2308308 2308308 defendant Wever John weaver 586164 586164 Wever, John, of Henley in Ardern, weaver 0
4850118 2311497 2311497 defendant Child Roger husbandman 586164 586164 Child, Roger, of Henley in Ardern, husbandman 0
4850120 2311498 2311498 defendant Chyld Roger husbandman 586164 586164 Chyld, Roger, of Henley in Ardern, husbandman 0
4866126 2316377 2316377 defendant Porrey Thomas butcher 586164 586164 Porrey, Thomas, of Henley in Ardern, butcher 0
4866127 2316377 2316377 defendant Barbour Edmund barber 586164 586164 Barbour, Edmund, of Henley in Ardern, barber 1
4866128 2316377 2316377 defendant Goldsmyth Agnes singlewoman 586164 586164 Goldsmyth, Agnes, of Henley in Ardern, singlewoman 2
4926461 2334696 2334696 defendant Porrey Thomas summoner 586164 586164 Porrey, Thomas, of Henley in Ardern, summoner 0
4932361 2336517 2336517 defendant Scarlet Edmund husbandman 586164 586164 Scarlet, Edmund, of Henley in Ardern, husbandman 1
4936784 2337883 2337883 defendant Hynton Thomas yeoman 586164 586164 Hynton, Thomas, of Henley in Ardern, yeoman 0
4966634 2346956 2346956 defendant Porrey John butcher 586164 586164 Porrey, John, of Henley in Ardern, butcher 0
5040106 2368639 2368639 defendant Deyster Richard glover 586164 586164 Deyster, Richard, of Henley in Ardern, glover 1
5070869 2377782 2377782 plaintiff Shyngey John (legal representative) 586164 586164 Shyngey, John, of Henley in Ardern, executors of 0
5118454 2391835 2391835 defendant Porrey John butcher 586164 586164 Porrey, John, of Henley in Ardern, butcher 0
5219006 2421289 2421289 defendant Taillour John butcher 586164 586164 Taillour, John, of Henley in Ardern, butcher 0
5231716 2424845 2424845 defendant Barbour Edmund barber 586164 586164 Barbour, Edmund, of Henley in Ardern, barber 1
5239927 2427254 2427254 defendant Blount William smith 586164 586164 Blount, William, of Henley in Ardern, smith 1
5274711 2437681 2437681 defendant Taillour David tailor 586164 586164 (Taillour, David, of Henley in Ardern, tailor 2
5310645 2448220 2448220 defendant Barker John husbandman 586164 586164 Barker, John, of Henley in Ardern, husbandman 2
5316480 2450010 2450010 defendant Smyth Thomas (legal representative) 586164 586164 Smyth, Thomas, of Henley in Ardern, executrix of 0
5331352 2454453 2454453 defendant Blunte Henry chapman 586164 586164 Blunte, Henry, of Henley in Ardern, chapman 0
5331354 2454454 2454454 defendant Blunte Henry chapman 586164 586164 Blunte, Henry, of Henley in Ardern, chapman 0
5361413 2463591 2463591 plaintiff Stokes John   586164 586164 Stokes, John, of Henley in Ardern 0
5362523 2463929 2463929 defendant Reynold William   586164 586164 Reynold, William, of Henley in Ardern 0
5378348 2468808 2468808 defendant Blythe Thomas husbandman 586164 586164 Blythe, Thomas, of Henley in Ardern, husbandman 0
5378350 2468809 2468809 defendant Blythe Thomas husbandman 586164 586164 Blythe, Thomas, of Henley in Ardern, husbandman 0
5563669 2523983 2523983 defendant Hall Thomas butcher 586164 586164 Hall, Thomas, of Henley in Ardern, butcher 1

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);