names

20 rows where place_id = 591324

✎ 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
3604070 1868941 1868941 defendant Laverok Robert husbandman 591324 591324 Laverok, Robert, of Aldam, husbandman 3
3604071 1868941 1868941 defendant Laverok John husbandman 591324 591324 Laverok, John, of Aldam, husbandman 4
3636591 1906235 1906235 defendant Draper Roger gent 591324 591324 Draper, Roger, of Aldam, gent 0
3636593 1906235 1906235 defendant Quylter John husbandman 591324 591324 Quylter, John, of Aldam, husbandman 2
3658010 1912758 1912758 defendant Betyll Thomas husbandman 591324 591324 Betyll, Thomas, of Aldam, husbandman 0
3658011 1912758 1912758 defendant Strecham Leonard carpenter 591324 591324 Strecham, Leonard, of Aldam, carpenter 1
3658015 1912760 1912760 defendant Turnbull Thomas clerk 591324 591324 Turnbull, Thomas, of Aldam, clerk 0
3786965 1953725 1953725 defendant Abell Edmund laborer 591324 591324 Abell, Edmund, of Aldam, laborer 0
3786966 1953725 1953725 defendant Oxley Thomas laborer 591324 591324 Oxley, Thomas, of Aldam, laborer 1
3813281 1962064 1962064 plaintiff Draper Roger (legal representative) 591324 591324 Draper, Roger, of Aldam, gent, executors of 0
3883316 1984685 1984685 defendant Thacker alias Artur John clerk 591324 591324 Thacker alias Artur, John, of Aldam, clerk 2
3885063 1985265 1985265 defendant Packwodde Thomas yeoman 591324 591324 Packwodde, Thomas, of Aldam, yeoman 2
4053703 2043702 2043702 defendant Thaxster Robert husbandman 591324 591324 Thaxster, Robert, of Aldam, husbandman 1
4155680 2080068 2080068 defendant Loggyn William husbandman 591324 591324 Loggyn, William, of Aldam, husbandman 0
4155681 2080068 2080068 defendant Cowaye William laborer 591324 591324 Cowaye, William, of Aldam, laborer 1
4155682 2080068 2080068 defendant Cowaye Clement laborer 591324 591324 Cowaye, Clement, of Aldam, laborer 2
4918899 2332424 2332424 defendant Tye Thomas butcher 591324 591324 Tye, Thomas, of Aldam, butcher 1
5295140 2443569 2443569 defendant Colman John yeoman 591324 591324 Colman, John, of Aldam, yeoman 0
5486982 2501002 2501002 defendant Grene Robert smith 591324 591324 Grene, Robert, of Aldam, smith 0
5589413 2531689 2531689 defendant Draper Roger gent 591324 591324 Draper, Roger, of Aldam, gent 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);