names

17 rows where place_id = 655019

✎ 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
3934626 2001875 2001875 defendant Pynson George smith 655019 655019 Pynson, George, of Alforde, smith 2
4056228 2044612 2044612 defendant Brantingham Robert tanner 655019 655019 Brantingham, Robert, of Alforde, tanner 1
4093969 2058169 2058169 defendant Weselhedd Anthony yeoman 655019 655019 Weselhedd, Anthony, of Alforde, yeoman 1
4098282 2059710 2059710 defendant Adams Thomas husbandman 655019 655019 Adams, Thomas, of Alforde, husbandman 0
4110148 2063892 2063892 defendant Battersbye Reginald walker 655019 655019 Battersbye, Reginald, of Alforde, walker 0
4275164 2121260 2121260 defendant Lyle Giles yeoman 655019 655019 Lyle, Giles, of Alforde, yeoman 3
4300771 2130372 2130372 defendant Flockton William husbandman 655019 655019 Flockton, William, of Alforde, husbandman 1
4333526 2141494 2141494 defendant Alam or Alain George yeoman 655019 655019 Alam or Alain, George, of Alforde, yeoman 0
4364467 2152349 2152349 defendant Crowe Thomas yeoman 655019 655019 Crowe, Thomas, of Alforde, yeoman 0
4364471 2152351 2152351 defendant Crowe Thomas yeoman 655019 655019 Crowe, Thomas, of Alforde, yeoman 0
4372695 2155312 2155312 defendant Glover Thomas tailor 655019 655019 Glover, Thomas, of Alforde, tailor 1
4378458 2157368 2157368 defendant Skipwithe John gent 655019 655019 Skipwithe, John, of Alforde, gent 0
5370701 2466426 2466426 defendant Rowet William barber 655019 655019 Rowet, William, of Alforde, barber 0
5370703 2466427 2466427 defendant Rowett William barber 655019 655019 Rowett, William, of Alforde, barber 0
5375746 2468007 2468007 defendant Route William yeoman 655019 655019 Route, William, of Alforde, yeoman 0
5484384 2500247 2500247 defendant Warde John yeoman 655019 655019 Warde, John, of Alforde, yeoman 0
5497854 2504299 2504299 defendant Warde John yeoman 655019 655019 Warde, John, of Alforde, 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);