names

41 rows where place_id = 606628

✎ 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
3665939 1915282 1915282 plaintiff Tailour Robert   606628 606628 Tailour, Robert, of Pountfrett 0
3694601 1924514 1924514 defendant Bynnys Henry weaver 606628 606628 Bynnys, Henry, of Pountfrett, weaver 0
3694603 1924515 1924515 defendant Lee Roger weaver 606628 606628 Lee, Roger, of Pountfrett, weaver 0
3721378 1932994 1932994 defendant Warde Roger husbandman 606628 606628 Warde, Roger, of Pountfrett, husbandman 0
3728621 1935191 1935191 defendant Croser William yeoman 606628 606628 Croser, William, of Pountfrett, yeoman 1
3728622 1935191 1935191 defendant Warde Thomas yeoman 606628 606628 Warde, Thomas, of Pountfrett, yeoman 2
3738155 1938147 1938147 defendant Loft or Lost Henry esq 606628 606628 Loft or Lost, Henry, of Pountfrett, esq 0
3833333 1968353 1968353 defendant Jakson John yeoman 606628 606628 Jakson, John, of Pountfrett, yeoman 1
3872962 1981171 1981171 defendant Wilbore William merchant 606628 606628 Wilbore, William, of Pountfrett, merchant 0
3883186 1984638 1984638 plaintiff Wakefeld Peter mercer 606628 606628 Wakefeld, Peter, of Pountfrett, mercer 0
3883188 1984639 1984639 plaintiff Wakefeld Peter mercer 606628 606628 Wakefeld, Peter, of Pountfrett, mercer 0
3950623 2007289 2007289 defendant Savage Boniface yeoman 606628 606628 Savage, Boniface, of Pountfrett, yeoman 0
3950624 2007289 2007289 defendant Walton Thomas yeoman 606628 606628 Walton, Thomas, of Pountfrett, yeoman 1
4024748 2033533 2033533 defendant Savage Boniface chapman 606628 606628 Savage, Boniface, of Pountfrett, chapman 0
4030412 2035533 2035533 plaintiff Ederyngton or Etherington Peter merchant 606628 606628 Ederyngton or Etherington, Peter, of Pountfrett, merchant 0
4030859 2035702 2035702 plaintiff Etherington Peter   606628 606628 Etherington, Peter, of Pountfrett 0
4036825 2037854 2037854 defendant Ameas Thomas yeoman 606628 606628 Ameas, Thomas, of Pountfrett, yeoman 5
4066292 2048235 2048235 defendant Skelton Peter gent 606628 606628 Skelton, Peter, of Pountfrett, gent 0
4098597 2059830 2059830 defendant Wayde Thomas yeoman 606628 606628 Wayde, Thomas, of Pountfrett, yeoman 0
4098598 2059830 2059830 defendant Feylde Robert yeoman 606628 606628 Feylde, Robert, of Pountfrett, yeoman 1
4098599 2059830 2059830 defendant Smyth Richard yeoman 606628 606628 Smyth, Richard, of Pountfrett, yeoman 2
4098600 2059830 2059830 defendant Rayner William yeoman 606628 606628 Rayner, William, of Pountfrett, yeoman 3
4098604 2059831 2059831 defendant Ayre Ralph yeoman 606628 606628 together with Ayre, Ralph, of Pountfrett, yeoman 1
4098605 2059831 2059831 defendant Ayre William yeoman 606628 606628 Ayre, William, of Pountfrett, yeoman 2
4098606 2059831 2059831 defendant Armestronge John yeoman 606628 606628 Armestronge, John, of Pountfrett, yeoman 3
4121907 2068132 2068132 defendant Hypern or Hyppron Robert (legal representative) 606628 606628 Hypern or Hyppron, Robert, of Pountfrett, gent, executors of 1
4121909 2068132 2068132 defendant Abbott George yeoman 606628 606628 Abbott, George, of Pountfrett, yeoman 3
4133895 2072458 2072458 defendant Harryson William laborer 606628 606628 Harryson, William, of Pountfrett, laborer 3
4157891 2080834 2080834 defendant Otes Brian laborer 606628 606628 Otes, Brian, of Pountfrett, laborer 2
4179578 2088333 2088333 defendant Colbecke William innkeeper 606628 606628 Colbecke, William, of Pountfrett, innkeeper 0
4180062 2088505 2088505 defendant Caldbecke William gent 606628 606628 Caldbecke, William, of Pountfrett, gent 0
4180064 2088506 2088506 defendant Crosbye Thomas gent 606628 606628 Crosbye, Thomas, of Pountfrett, gent 0
4201522 2096078 2096078 defendant Hudson Edward yeoman 606628 606628 Hudson, Edward, of Pountfrett, yeoman 0
4201523 2096078 2096078 defendant Hemyngley John yeoman 606628 606628 Hemyngley, John, of Pountfrett, yeoman 1
4575583 2223874 2223874 plaintiff Bower William   606628 606628 Bower, William, of Pountfrett 0
4663449 2250044 2250044 defendant Baghill John skinner 606628 606628 Baghill, John, of Pountfrett, skinner 0
5156881 2403160 2403160 defendant Heghsam John yeoman 606628 606628 Heghsam, John, of Pountfrett, yeoman 4
5192334 2413495 2413495 defendant Frere Robert yeoman 606628 606628 Frere, Robert, of Pountfrett, yeoman 0
5221103 2421878 2421878 defendant Dylcok Thomas yeoman 606628 606628 Dylcok, Thomas, of Pountfrett, yeoman 0
5285525 2440786 2440786 plaintiff Gyseley or Eyseley John weaver 606628 606628 Gyseley or Eyseley, John, of Pountfrett, weaver 0
5347585 2459400 2459400 plaintiff Beseley John   606628 606628 Beseley, John, of Pountfrett 0

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