names

20 rows where place_id = 657833

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3945941 2005657 2005657 defendant Cole Richard gent 657833 657833 Cole, Richard, of Well, Soms, gent 4
3953230 2008196 2008196 defendant Ayleworth John esq 657833 657833 Ayleworth, John, of Well, Soms, esq 0
3954899 2008780 2008780 defendant Goodwyn Adrian mercer 657833 657833 Goodwyn, Adrian, of Well, Soms, mercer 1
3970901 2014387 2014387 defendant Lyny or Lyvy Andrew chapman 657833 657833 Lyny or Lyvy, Andrew, of Well, Soms, chapman 2
3990762 2021452 2021452 defendant Whyte Christopher yeoman 657833 657833 Whyte, Christopher, of Well, Soms, yeoman 1
4000578 2024976 2024976 defendant Dotherell William mercer 657833 657833 Dotherell, William, of Well, Soms, mercer 0
4006377 2027058 2027058 plaintiff Leigh Thomas gent 657833 657833 Leigh, Thomas, of Well, Soms, gent 0
4024390 2033401 2033401 defendant Foster John yeoman 657833 657833 (Foster, John, of Well, Soms, yeoman 1
4029977 2035366 2035366 defendant Selbye Robert saddler 657833 657833 Selbye, Robert, of Well, Soms, saddler 0
4035849 2037492 2037492 defendant Kynven William clerk 657833 657833 Kynven, William, of Well, Soms, clerk 1
4085151 2054972 2054972 defendant Danyell Robert butcher 657833 657833 Danyell, Robert, of Well, Soms, butcher 1
4089817 2056649 2056649 defendant Milborne Thomas gent 657833 657833 Milborne, Thomas, of Well, Soms, gent 2
4167284 2084059 2084059 defendant Roynon Bellman gent 657833 657833 Roynon, Bellman, of Well, Soms, gent 3
4188215 2091381 2091381 defendant Anmer John yeoman 657833 657833 Anmer, John, of Well, Soms, yeoman 2
4195556 2093993 2093993 defendant Roynon John gent 657833 657833 Roynon, John, of Well, Soms, gent 0
4205423 2097450 2097450 defendant Roynon John gent 657833 657833 Roynon, John, of Well, Soms, gent 1
4209818 2098993 2098993 defendant Hillacre Polidore gent 657833 657833 Hillacre, Polidore, of Well, Soms, gent 0
4329831 2140277 2140277 defendant Hawswell Hugh yeoman 657833 657833 Hawswell, Hugh, of Well, Soms, yeoman 1
4874027 2318816 2318816 defendant Taverner William taverner 657833 657833 Taverner, William, of Well, Soms, taverner 0
4884932 2322184 2322184 defendant Pedewell Richard mercer 657833 657833 Pedewell, Richard, of Well, Soms, mercer 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);