names

16 rows where place_id = 598489

✎ 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
3632746 1905055 1905055 defendant Merycok Thomas yeoman 598489 598489 Merycok, Thomas, of Aby, yeoman 0
3755029 1943521 1943521 defendant Laughton John husbandman 598489 598489 Laughton, John, of Aby, husbandman 0
3790206 1954756 1954756 defendant Laughton John husbandman 598489 598489 Laughton, John, of Aby, husbandman 0
3985237 2019476 2019476 defendant Fresshenay Joan widow 598489 598489 Fresshenay, Joan, of Aby, widow 3
4376563 2156688 2156688 defendant Cramett John yeoman 598489 598489 Cramett, John, of Aby, yeoman 0
4610474 2234347 2234347 plaintiff Carter John   598489 598489 Carter, John, of Aby 0
4610476 2234348 2234348 plaintiff Carter John   598489 598489 Carter, John, of Aby 0
4630992 2240588 2240588 defendant Carter John   598489 598489 Carter, John, of Aby 2
4671820 2256833 2256833 defendant Sprotlyng Robert husbandman 598489 598489 Sprotlyng, Robert, of Aby, husbandman 2
4671841 2256837 2256837 defendant Aby Robert husbandman 598489 598489 Aby, Robert, of Aby, husbandman 3
4671842 2256837 2256837 defendant Aby Isabel widow & formerly wife of John de Aby 598489 598489 Aby, Isabel, of Aby, widow & formerly wife of John de Aby 4
5285452 2440766 2440766 defendant Dey Walter clerk 598489 598489 Dey, Walter, of Aby, clerk 0
5287756 2441443 2441443 defendant Dey Walter clerk 598489 598489 Dey, Walter, of Aby, clerk 1
5303102 2445918 2445918 defendant Dey Walter clerk 598489 598489 Dey, Walter, of Aby, clerk 0
5305095 2446524 2446524 defendant Dey Walter clerk 598489 598489 Dey, Walter, of Aby, clerk 0
5308260 2447502 2447502 defendant Day Walter clerk 598489 598489 Day, Walter, of Aby, clerk 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);