names

26 rows where place_id = 700562

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4122413 2068325 2068325 defendant Dawe Thomas tailor 700562 700562 Dawe, Thomas, of Wellington, Soms, or of Sampford Peverell, Devon, tailor 1
4134013 2072497 2072497 defendant Cape alias Perrye Hugh husbandman 700562 700562 Cape alias Perrye, Hugh, of Wellington, Soms, husbandman 0
4134022 2072499 2072499 defendant Denham Robert tanner 700562 700562 Denham, Robert, of Wellington, Soms, tanner 0
4134026 2072500 2072500 defendant Dynham John tanner 700562 700562 Dynham, John, of Wellington, Soms, tanner 0
4170871 2085301 2085301 defendant Woode Robert butcher 700562 700562 Woode, Robert, of Wellington, Soms, butcher 3
4177613 2087647 2087647 defendant Gyfford Lawrence merchant 700562 700562 Gyfford, Lawrence, of Wellington, Soms, merchant 0
4188137 2091352 2091352 defendant Pyrrey or Perrye alias Cape Hugh husbandman 700562 700562 Pyrrey or Perrye alias Cape, Hugh, of Wellington, Soms, husbandman 0
4193439 2093271 2093271 defendant Hitchcocke John chapman 700562 700562 Hitchcocke, John, of Wellington, Soms, chapman 0
4207151 2098046 2098046 defendant Cape alias Perry Hugh yeoman 700562 700562 Cape alias Perry, Hugh, of Wellington, Soms, yeoman 0
4207782 2098284 2098284 defendant Greneslade John chapman 700562 700562 Greneslade, John, of Wellington, Soms, chapman 2
4213704 2100310 2100310 defendant Clapham Edward vintner 700562 700562 Clapham, Edward, of Wellington, Soms, vintner 0
4213706 2100311 2100311 defendant Clapham Edward yeoman 700562 700562 Clapham, Edward, of Wellington, Soms, yeoman 0
4218968 2102129 2102129 defendant Oland Robert clothier 700562 700562 Oland, Robert, of Wellington, Soms, clothier 0
4261136 2116693 2116693 defendant Best Richard, senior gent 700562 700562 Best, Richard, senior, of Wellington, Soms, gent 0
4307660 2132817 2132817 defendant Jefferie William husbandman 700562 700562 Jefferie, William, of Wellington, Soms, husbandman 0
4334519 2141818 2141818 defendant Bartlett Henry husbandman 700562 700562 Bartlett, Henry, of Wellington, Soms, husbandman 0
4374379 2155903 2155903 defendant Awtrye Thomas gent 700562 700562 Awtrye, Thomas, of Wellington, Soms, gent 0
4386014 2160010 2160010 defendant Perie Thomas gent 700562 700562 Perie, Thomas, of Wellington, Soms, gent 0
4391833 2161893 2161893 defendant Strawbridge Raphael merchant or mercer 700562 700562 Strawbridge, Raphael, of Wellington, Soms, merchant or mercer 1
4391840 2161895 2161895 defendant Strawbredge Raphael merchant 700562 700562 Strawbredge, Raphael, of Wellington, Soms, merchant 1
4412083 2168634 2168634 defendant Calwaye William dyer 700562 700562 Calwaye, William, of Wellington, Soms, dyer 0
4717061 2270665 2270665 defendant Brabbe John hostiler 700562 700562 Brabbe, John, of Wellington, Soms, hostiler 0
4766931 2285646 2285646 defendant Goddeslond Thomas tailor 700562 700562 Goddeslond, Thomas, of Wellington, Soms, tailor 1
4848297 2310938 2310938 defendant Goddeslond Thomas tailor 700562 700562 Goddeslond, Thomas, of Wellington, Soms, tailor 2
5186032 2411661 2411661 defendant Richard John drover 700562 700562 Richard, John, of Wellington, Soms, drover 3
5209376 2418479 2418479 defendant Pery Robert yeoman 700562 700562 Pery, Robert, of Wellington, Soms, 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);