names

21 rows where place_id = 591894

✎ 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
3605914 1869511 1869511 defendant Doget Thomas hosier 591894 591894 Doget, Thomas, of Wyngfeld, Suff, hosier 2
3617778 1873184 1873184 defendant Aylmer Thomas gent 591894 591894 Aylmer, Thomas, of Wyngfeld, Suff, gent 0
3617851 1873206 1873206 defendant Tower John yeoman 591894 591894 (Tower, John, of Wyngfeld, Suff, yeoman 5
3623462 1874872 1874872 defendant Conwold James tailor 591894 591894 Conwold, James, of Wyngfeld, Suff, tailor 0
3623464 1874873 1874873 defendant Conwold James tailor 591894 591894 Conwold, James, of Wyngfeld, Suff, tailor 0
3642822 1908203 1908203 defendant Wulnawe Robert yeoman 591894 591894 Wulnawe, Robert, of Wyngfeld, Suff, yeoman 1
3642826 1908204 1908204 defendant Wulnawe Robert yeoman 591894 591894 Wulnawe, Robert, of Wyngfeld, Suff, yeoman 1
3795243 1956379 1956379 defendant Wynwood Lewis gent 591894 591894 Wynwood, Lewis, of Wyngfeld, Suff, gent 0
3795247 1956380 1956380 defendant Wynwood Lewis gent 591894 591894 Wynwood, Lewis, of Wyngfeld, Suff, gent 0
3795261 1956384 1956384 defendant Wynwode Lewis gent 591894 591894 Wynwode, Lewis, of Wyngfeld, Suff, gent 0
3871461 1980699 1980699 defendant Fissher William husbandman 591894 591894 Fissher, William, of Wyngfeld, Suff, husbandman 2
3871541 1980723 1980723 defendant Palmer Stephen yeoman 591894 591894 Palmer, Stephen, of Wyngfeld, Suff, yeoman 2
3952469 2007931 2007931 defendant Jernegan Walter gent 591894 591894 Jernegan, Walter, of Wyngfeld, Suff, gent 0
4973782 2349116 2349116 defendant Treyford John yeoman 591894 591894 Treyford, John, of Wyngfeld, Suff, yeoman 0
5368385 2465726 2465726 defendant Alinotte Thomas gent 591894 591894 Alinotte, Thomas, of Wyngfeld, Suff, gent 4
5490568 2502071 2502071 defendant Kent John yeoman 591894 591894 Kent, John, of Wyngfeld, Suff, yeoman 0
5505445 2506619 2506619 defendant Kent John yeoman 591894 591894 Kent, John, of Wyngfeld, Suff, yeoman 0
5529360 2513697 2513697 defendant Aylemer Thomas gent 591894 591894 Aylemer, Thomas, of Wyngfeld, Suff, gent 0
5534520 2515343 2515343 defendant Reynsford Henry gent 591894 591894 Reynsford, Henry, of Wyngfeld, Suff, gent 0
5549189 2519808 2519808 defendant Conwald James yeoman 591894 591894 Conwald, James, of Wyngfeld, Suff, yeoman 0
5580773 2529065 2529065 defendant Payn Robert chapman 591894 591894 Payn, Robert, of Wyngfeld, Suff, chapman 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);