names

59 rows where place_id = 592478

✎ 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
3607812 1870095 1870095 defendant Taillour Robert tailor 592478 592478 Taillour, Robert, of Henley in Arden, tailor 2
3607845 1870103 1870103 defendant Taillour Robert tailor 592478 592478 Taillour, Robert, of Henley in Arden, tailor 1
3607848 1870104 1870104 defendant Taillour Robert tailor 592478 592478 Taillour, Robert, of Henley in Arden, tailor 1
3833695 1968467 1968467 defendant Fowler John husbandman 592478 592478 Fowler, John, of Henley in Arden, husbandman 3
3933264 2001419 2001419 defendant Dubler Thomas   592478 592478 Dubler, Thomas, of Henley in Arden 1
3945385 2005471 2005471 defendant Harper John shoemaker 592478 592478 Harper, John, of Henley in Arden, shoemaker 1
3954267 2008568 2008568 defendant Harper John shoemaker 592478 592478 Harper, John, of Henley in Arden, shoemaker 1
3954910 2008783 2008783 defendant Harper John shoemaker 592478 592478 Harper, John, of Henley in Arden, shoemaker 1
3956923 2009489 2009489 defendant Gyles Gregory butcher 592478 592478 Gyles, Gregory, of Henley in Arden, butcher 0
3956925 2009489 2009489 defendant Kyteley John butcher 592478 592478 Kyteley, John, of Henley in Arden, butcher 2
3987037 2020106 2020106 defendant Plont William husbandman 592478 592478 Plont, William, of Henley in Arden, husbandman 0
3987040 2020106 2020106 defendant Wheler John husbandman 592478 592478 Wheler, John, of Henley in Arden, husbandman 3
3990331 2021297 2021297 defendant Bellers Fulk tanner 592478 592478 Bellers, Fulk, of Henley in Arden, tanner 2
4002811 2025772 2025772 defendant Whateley John yeoman 592478 592478 Whateley, John, of Henley in Arden, yeoman 2
4002815 2025773 2025773 defendant Wheatley John yeoman 592478 592478 Wheatley, John, of Henley in Arden, yeoman 2
4023936 2033266 2033266 plaintiff Whatley John yeoman 592478 592478 Whatley, John, of Henley in Arden, yeoman 1
4059100 2045652 2045652 plaintiff Cole William carpenter 592478 592478 Cole, William, of Henley in Arden, carpenter 0
4102794 2061300 2061300 defendant Wheatley William yeoman 592478 592478 Wheatley, William, of Henley in Arden, yeoman 1
4102798 2061301 2061301 defendant Wheatlye William yeoman 592478 592478 Wheatlye, William, of Henley in Arden, yeoman 1
4106603 2062652 2062652 defendant Wheler Roland   592478 592478 Wheler, Roland, of Henley in Arden, yarn man 0
4118916 2067046 2067046 defendant Dugas alias Lucas Hugh husbandman 592478 592478 Dugas alias Lucas, Hugh, of Henley in Arden, husbandman 0
4118917 2067046 2067046 defendant Herton Thomas husbandman 592478 592478 Herton, Thomas, of Henley in Arden, husbandman 1
4118918 2067046 2067046 defendant Lye John tailor 592478 592478 Lye, John, of Henley in Arden, tailor 2
4118919 2067046 2067046 defendant Fowler Richard carpenter 592478 592478 Fowler, Richard, of Henley in Arden, carpenter 3
4118920 2067046 2067046 defendant Jecock Ellen widow 592478 592478 Jecock, Ellen, of Henley in Arden, widow 4
4118921 2067046 2067046 defendant Pryce Cecily widow 592478 592478 Pryce, Cecily, of Henley in Arden, widow 5
4141464 2075175 2075175 defendant Wheler Roland yeoman 592478 592478 Wheler, Roland, of Henley in Arden, yeoman 0
4165603 2083470 2083470 defendant Hill Christopher   592478 592478 Hill, Christopher, of Henley in Arden, wool winder 1
4166359 2083729 2083729 defendant Hill Robert baker 592478 592478 Hill, Robert, of Henley in Arden, baker 1
4166360 2083729 2083729 defendant Wheler Roland yeoman 592478 592478 Wheler, Roland, of Henley in Arden,yeoman 2
4187580 2091157 2091157 defendant Parker Richard yeoman 592478 592478 Parker, Richard, of Henley in Arden, yeoman 0
4187581 2091157 2091157 defendant Slye Richard husbandman 592478 592478 Slye, Richard, of Henley in Arden, husbandman 1
4207897 2098321 2098321 defendant Grene Richard mercer 592478 592478 Grene, Richard, of Henley in Arden, mercer 0
4207898 2098321 2098321 defendant Grene Katherine widow 592478 592478 Grene, Katherine, of Henley in Arden, widow 1
4214556 2100597 2100597 defendant Harper Thomas baker 592478 592478 Harper, Thomas, of Henley in Arden, baker 1
4224088 2103912 2103912 defendant Harper Thomas baker 592478 592478 Harper, Thomas, of Henley in Arden, baker 1
4389742 2161193 2161193 defendant Ange or Auge Richard tanner 592478 592478 Ange or Auge, Richard, of Henley in Arden, tanner 1
4389743 2161193 2161193 defendant Reve John tanner 592478 592478 Reve, John, of Henley in Arden, tanner 2
4389744 2161193 2161193 defendant Jones alias Grege Hugh butcher 592478 592478 Jones alias Grege, Hugh, of Henley in Arden, butcher 3
4389747 2161194 2161194 defendant Smyth William tanner 592478 592478 Smyth, William, of Henley in Arden, tanner 1
4389748 2161194 2161194 defendant Warde James glover 592478 592478 Warde, James, of Henley in Arden, glover 2
4482935 2195362 2195362 plaintiff Mulne Thomas atte (legal representative) 592478 592478 Mulne, Thomas atte, of Henley in Arden, executors of 0
4540711 2213000 2213000 defendant Scolard William   592478 592478 Scolard, William, of Henley in Arden 0
4678960 2259027 2259027 plaintiff Illage John   592478 592478 Illage, John, of Henley in Arden 0
4708894 2268148 2268148 plaintiff Oylege alias Yllage John vintner 592478 592478 Oylege alias Yllage, John, of Henley in Arden, vintner 0
4913275 2330652 2330652 plaintiff Clage or Glage John (legal representative) 592478 592478 Clage or Glage, John, of Henley in Arden, passenger, executors of 0
5074260 2378791 2378791 defendant Spenlove William baker 592478 592478 Spenlove, William, of Henley in Arden, baker 1
5110645 2389514 2389514 defendant Stokes John yeoman 592478 592478 Stokes, John, of Henley in Arden, yeoman 0
5110646 2389514 2389514 defendant Bate John laborer 592478 592478 Bate, John, of Henley in Arden, laborer 1
5110647 2389514 2389514 defendant Pygeon Richard laborer 592478 592478 Pygeon, Richard, of Henley in Arden, laborer 2
5360964 2463453 2463453 defendant Blount Henry ironmonger 592478 592478 Blount, Henry, of Henley in Arden, ironmonger 0
5360967 2463453 2463453 defendant Swynford William baker 592478 592478 Swynford, William, of Henley in Arden, baker 3
5443639 2488017 2488017 defendant Thorneden John husbandman 592478 592478 Thorneden, John, of Henley in Arden, husbandman 1
5445103 2488423 2488423 defendant Sampson John tanner 592478 592478 Sampson, John, of Henley in Arden, tanner 1
5456443 2491849 2491849 defendant Chester John laborer 592478 592478 Chester, John, of Henley in Arden, laborer 0
5456444 2491849 2491849 defendant Thorneden John husbandman 592478 592478 Thorneden, John, of Henley in Arden, husbandman 1
5456446 2491850 2491850 defendant Chester John laborer 592478 592478 Chester, John, of Henley in Arden, laborer 0
5456447 2491850 2491850 defendant Thorneden John husbandman 592478 592478 Thorneden, John, of Henley in Arden, husbandman 1
5589207 2531630 2531630 defendant Smyth John yeoman 592478 592478 Smyth, John, of Henley in Arden, yeoman 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);