names

32 rows where place_id = 670239

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3996212 2023394 2023394 defendant Pledge John husbandman 670239 670239 Pledge, John, of Gowtherst, husbandman 3
4029464 2035175 2035175 defendant Alcherne or Alchen James shoemaker 670239 670239 Alcherne or Alchen, James, of Gowtherst, shoemaker 0
4029467 2035175 2035175 defendant Hedge alias Pledge Henry laborer 670239 670239 Hedge alias Pledge, Henry, of Gowtherst, laborer 3
4030169 2035437 2035437 defendant Austen Richard clothier 670239 670239 Austen, Richard, of Gowtherst, clothier 0
4094983 2058534 2058534 defendant Sabbe Samuel yeoman 670239 670239 Sabbe, Samuel, of Gowtherst, yeoman 0
4113951 2065272 2065272 defendant Bereworth John yeoman 670239 670239 Bereworth, John, of Gowtherst, yeoman 0
4145137 2076459 2076459 defendant Usburne Alexander yeoman 670239 670239 Usburne, Alexander, of Gowtherst, yeoman 1
4213661 2100298 2100298 defendant Love Thomas mercer 670239 670239 Love, Thomas, of Gowtherst, mercer 0
4222922 2103505 2103505 defendant Couchman Thomas yeoman 670239 670239 Couchman, Thomas, of Gowtherst, yeoman 0
4225622 2104427 2104427 defendant Daye Henry husbandman 670239 670239 Daye, Henry, of Gowtherst, husbandman 0
4225763 2104475 2104475 defendant Coggar Stephen   670239 670239 Coggar, Stephen, of Gowtherst, scythe smith 0
4225764 2104475 2104475 defendant Pattenden Henry   670239 670239 Pattenden, Henry, of Gowtherst, yeoman, son of Henry Pattenden, of Gowtherst 1
4225766 2104476 2104476 defendant Cogger Stephen   670239 670239 Cogger, Stephen, of Gowtherst, scythe smith 0
4229629 2105848 2105848 defendant Balden Richard carpenter 670239 670239 Balden, Richard, of Gowtherst, or of Tisherst, Sussex, carpenter 0
4231438 2106497 2106497 defendant Cogger Stephen yeoman 670239 670239 Cogger, Stephen, of Gowtherst, yeoman 0
4231439 2106497 2106497 defendant Pattenden Henry yeoman 670239 670239 Pattenden, Henry, of Gowtherst, yeoman 1
4232007 2106695 2106695 defendant Broade Robert yeoman 670239 670239 Broade, Robert, of Gowtherst, yeoman 0
4232529 2106879 2106879 defendant Boockland James weaver 670239 670239 Boockland, James, of Gowtherst, weaver 0
4266183 2118329 2118329 defendant Cogger Stephen   670239 670239 Cogger, Stephen, of Gowtherst, scythe smith 0
4272699 2120438 2120438 defendant Whatman Anthony   670239 670239 Whatman, Anthony, of Gowtherst, broad weaver 0
4273949 2120832 2120832 defendant Pattenden Henry yeoman 670239 670239 Pattenden, Henry, of Gowtherst, yeoman 1
4310591 2133853 2133853 defendant Day Richard yeoman 670239 670239 Day, Richard, of Gowtherst, yeoman 0
4311786 2134258 2134258 defendant Parson William husbandman 670239 670239 Parson, William, of Gowtherst, husbandman 0
4323856 2138391 2138391 defendant Besbeche Richard butcher 670239 670239 Besbeche, Richard, of Gowtherst, butcher 1
4323857 2138391 2138391 defendant Stephyns William tailor 670239 670239 Stephyns, William, of Gowtherst, tailor 2
4330882 2140628 2140628 defendant Eves Thomas gent 670239 670239 Eves, Thomas, of Gowtherst, gent 0
4362034 2151466 2151466 defendant Parson William clothier 670239 670239 Parson, William, of Gowtherst, clothier 0
4380681 2158200 2158200 defendant Besbeache Richard butcher 670239 670239 Besbeache, Richard, of Gowtherst, butcher 0
4401665 2165154 2165154 defendant Eves Thomas gent 670239 670239 Eves, Thomas, of Gowtherst, gent 0
4401668 2165154 2165154 defendant Fowle John glover 670239 670239 Fowle, John, of Gowtherst, glover 3
5535258 2515556 2515556 defendant Rolffe James yeoman 670239 670239 Rolffe, James, of Gowtherst, yeoman 0
5535260 2515557 2515557 defendant Rolf James yeoman 670239 670239 Rolf, James, of Gowtherst, yeoman 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);