names

38 rows where case_id = 1874162

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621116 1874162 1874162 plaintiff Mordaunt William     Mordaunt, William 0
3621117 1874162 1874162 defendant Forster Nicholas yeoman 595588 595588 Forster, Nicholas, of Gemyngham, Norf, yeoman 0
3621118 1874162 1874162 defendant Stone Stephen gent 585869 585869 Stone, Stephen, of London, gent 1
3621119 1874162 1874162 defendant Hosy Thomas esq 595589 595589 Hosy, Thomas, of Shapwike, Dorset, esq 2
3621120 1874162 1874162 defendant Clarell James gent 585869 585869 Clarell, James, of London, gent 3
3621121 1874162 1874162 defendant Kyng Richard yeoman 595590 595590 Kyng, Richard, of Beeston juxta Mare, Norf, yeoman 4
3621122 1874162 1874162 defendant Worseley Ralph gent 595591 595591 Worseley, Ralph, of Kyngeston Lacy, Dorset, gent 5
3621123 1874162 1874162 defendant Fenys Thomas esq 595592 595592 Fenys, Thomas, of Echynham, Sussex, esq 6
3621124 1874162 1874162 defendant Bronde Richard fishmonger 585869 585869 Bronde, Richard, of London, fishmonger 7
3621125 1874162 1874162 defendant Middelton William esq 595593 595593 Middelton, William, of Sombourn, Hants, esq 8
3621126 1874162 1874162 defendant Birde John yeoman 588643 588643 Birde, John, of Walden, Essex, yeoman 9
3621127 1874162 1874162 defendant Brounesmyth Thomas yeoman 586312 586312 Brounesmyth, Thomas, of Walden, yeoman 10
3621128 1874162 1874162 defendant Trewelof John yeoman 595594 595594 Trewelof, John, of Hungerford, Derbs, yeoman 11
3621129 1874162 1874162 defendant Fairwell Thomas yeoman 595595 595595 Fairwell, Thomas, of Westcote, Wilts, yeoman 12
3621130 1874162 1874162 defendant Atwelle Thomas prior of Lewes Priory   Atwelle, Thomas, prior of Lewes Priory 13
3621131 1874162 1874162 defendant Thorp William yeoman 595596 595596 Thorp, William, of Uplamborn, Dorset, yeoman 14
3621132 1874162 1874162 defendant Bruett William yeoman 586312 586312 Bruett, William, of Walden, yeoman 15
3621133 1874162 1874162 defendant Alenson Richard yeoman 595590 595590 Alenson, Richard, of Beeston juxta Mare, Norf, yeoman 16
3621134 1874162 1874162 defendant Hall John yeoman 595597 595597 Hall, John, of Raundes, Nhants, yeoman 17
3621135 1874162 1874162 defendant Gaynesford George gent 595598 595598 Gaynesford, George, of Hampton Poill, Oxon, gent 18
3621136 1874162 1874162 defendant Selby John yeoman 586058 586058 Selby, John, of Enfeld, Middx, yeoman 19
3621137 1874162 1874162 defendant Blakbourn Walter yeoman 595599 595599 Blakbourn, Walter, of Wardyngton, Nhants, yeoman 20
3621138 1874162 1874162 defendant Gile Nicholas yeoman 595600 595600 Gile, Nicholas, of Kyngeston Lacy, yeoman 21
3621139 1874162 1874162 defendant Germyn Thomas yeoman 590901 590901 Germyn, Thomas, of Thetford, Norf, yeoman 22
3621140 1874162 1874162 defendant Chambre Richard yeoman 595601 595601 Chambre, Richard, of Hynton, Berks, yeoman 23
3621141 1874162 1874162 defendant Sclater Robert yeoman 595599 595599 Sclater, Robert, of Wardyngton, Nhants, yeoman 24
3621142 1874162 1874162 defendant Hall Elizabeth widow 595117 595117 Hall, Elizabeth, of Everley, Wilts, widow 25
3621143 1874162 1874162 defendant London Thomas yeoman 595602 595602 London, Thomas, of Raundes, yeoman 26
3621144 1874162 1874162 defendant Alenson Lawrence yeoman 595603 595603 Alenson, Lawrence, of North Erpyngham, Norf, yeoman 27
3621145 1874162 1874162 defendant Clere Robert   589339 589339 Clere, Robert, of Ormesby, Norf, knight 28
3621146 1874162 1874162 defendant Benstede Edward esq 595605 595605 Benstede, Edward, of hertfordyngbury, Herts, esq 29
3621147 1874162 1874162 defendant Kidwelly Morgan gent 585869 585869 Kidwelly, Morgan, of London, gent 30
3621148 1874162 1874162 defendant Chaundeler John yeoman 595606 595606 Chaundeler, John, of manyngford, Dorset, yeoman 31
3621149 1874162 1874162 defendant Pope John yeoman 595607 595607 Pope, John, of Seeford, Sussex, yeoman 32
3621150 1874162 1874162 defendant Grefyn Ema widow 595608 595608 Grefyn, Ema, of Braybroke, Nhants, widow 33
3621151 1874162 1874162 defendant Wirall William yeoman 589072 589072 Wirall, William, of Sutton, Beds, yeoman 34
3621152 1874162 1874162 defendant Henege William gent 585869 585869 Henege, William, of London, gent 35
3621153 1874162 1874162 defendant Colyns Thomas chapman 595609 595609 Colyns, Thomas, of Higham Ferrers, Nhants, chapman 36

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