names

27 rows where place_id = 660355

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3956157 2009227 2009227 defendant Hameley Richard husbandman 660355 660355 Hameley, Richard, of St Tethe, husbandman 0
3958557 2010063 2010063 defendant Posquyn alias Carveygh John husbandman 660355 660355 Posquyn alias Carveygh, John, of St Tethe, husbandman 1
3958558 2010063 2010063 defendant Yllarye William laborer 660355 660355 Yllarye, William, of St Tethe, laborer 2
3963084 2011687 2011687 defendant Hyllarye Stephen cordwainer 660355 660355 Hyllarye, Stephen, of St Tethe, cordwainer 0
4078502 2052609 2052609 defendant Hillarye Alice widow 660355 660355 Hillarye, Alice, of St Tethe, widow 0
4078503 2052609 2052609 defendant Rawe John yeoman 660355 660355 Rawe, John, of St Tethe, yeoman 1
4091259 2057163 2057163 defendant Hoskyn John husbandman 660355 660355 Hoskyn, John, of St Tethe, husbandman 0
4129485 2070849 2070849 defendant Killiowe Thomas, junior   660355 660355 Killiowe, Thomas, junior, of St Tethe, groom 0
4129486 2070849 2070849 defendant Killiowe Nicholas   660355 660355 Killiowe, Nicholas, of St Tethe, groom 1
4138464 2074123 2074123 defendant Blake Thomas husbandman 660355 660355 Blake, Thomas, of St Tethe, husbandman 0
4138465 2074123 2074123 defendant Gefferey or Jefferey John smith 660355 660355 Gefferey or Jefferey, John, of St tethe, smith 1
4138467 2074124 2074124 defendant Copson alias Trevighan John husbandman 660355 660355 Copson alias Trevighan, John, of St Tethe, husbandman 0
4138468 2074124 2074124 defendant Stere alias Bunsall Nicholas laborer 660355 660355 Stere alias Bunsall, Nicholas, of St Tethe, laborer 1
4138469 2074124 2074124 defendant Call or Cull Joan spinster 660355 660355 Call or Cull, Joan, of St Tethe, spinster 2
4152903 2079122 2079122 defendant Killiowe Thomas, senior yeoman 660355 660355 Killiowe, Thomas, senior, of St Tethe, yeoman 0
4152904 2079122 2079122 defendant Mallis William husbandman 660355 660355 Mallis, William, of St Tethe, husbandman 1
4162999 2082595 2082595 defendant Taverner Richard gent 660355 660355 Taverner, Richard, of St Tethe, gent 0
4198805 2095141 2095141 defendant Taverner Richard gent 660355 660355 Taverner, Richard, of St Tethe, gent 0
4224220 2103959 2103959 defendant Packinge or Peckinge John yeoman 660355 660355 Packinge or Peckinge, John, of St Tethe, yeoman 0
4242333 2110431 2110431 defendant Pollerd Robert husbandman 660355 660355 Pollerd, Robert, of St Tethe, husbandman 0
4389777 2161203 2161203 defendant Taverner Joan spinster 660355 660355 Taverner, Joan, of St Tethe, spinster 1
4823741 2303513 2303513 defendant Bere Thomas smith 660355 660355 Bere, Thomas, of St Tethe, smith 2
5445538 2488562 2488562 plaintiff Ferers Ralph   660355 660355 Ferers, Ralph, of St Tethe, prebendary 0
5445540 2488563 2488563 plaintiff Feres Ralph   660355 660355 Feres, Ralph, of St Tethe, prebendary 0
5495378 2503518 2503518 defendant Milward Reginald husbandman 660355 660355 Milward, Reginald, of St Tethe, husbandman 3
5558487 2522429 2522429 defendant Dawnand William, junior husbandman 660355 660355 Dawnand, William, junior, of St Tethe, husbandman 0
5558489 2522430 2522430 defendant Ronell or Rovell alias Trevyghan John husbandman 660355 660355 Ronell or Rovell alias Trevyghan, John, of St Tethe, husbandman 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);