names

27 rows where place_id = 592176

✎ 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
3606833 1869805 1869805 defendant Metcalf John weaver 592176 592176 Metcalf, John, of Lynton, Cams, weaver 5
3630413 1904347 1904347 plaintiff Eton Thomas gent 592176 592176 Eton, Thomas, of Lynton, Cams, gent 0
3630415 1904348 1904348 plaintiff Eton Thomas gent 592176 592176 Eton, Thomas, of Lynton, Cams, gent 0
3684946 1921425 1921425 defendant Thornton John yeoman 592176 592176 Thornton, John, of Lynton, Cams, yeoman 1
3745615 1940534 1940534 defendant Fulwell Stephen yeoman 592176 592176 Fulwell, Stephen, of Lynton, Cams, yeoman 0
3815182 1962666 1962666 defendant Parrys Philip esq 592176 592176 Parrys, Philip, of Lynton, Cams, esq 0
3815187 1962667 1962667 defendant Parys Philip esq 592176 592176 Parys, Philip, of Lynton, Cams, esq 0
3857800 1976078 1976078 defendant Thornton John yeoman 592176 592176 Thornton, John, of Lynton, Cams, yeoman 2
3860382 1976967 1976967 defendant Fulwell Stephen husbandman 592176 592176 Fulwell, Stephen, of Lynton, Cams, husbandman 4
3860428 1976981 1976981 defendant Fulwell Stephen husbandman 592176 592176 Fulwell, Stephen, of Lynton, Cams, husbandman 1
3916071 1995760 1995760 defendant Fullyll Philip yeoman 592176 592176 Fullyll, Philip, of Lynton, Cams, yeoman 0
3916076 1995761 1995761 defendant Fullyll Philip yeoman 592176 592176 Fullyll, Philip, of Lynton, Cams, yeoman 1
3974664 2015706 2015706 defendant Munde Edward chapman 592176 592176 Munde, Edward, of Lynton, Cams, chapman 1
4104296 2061815 2061815 defendant Parris Ferdinand esq 592176 592176 Parris, Ferdinand, of Lynton, Cams, esq 0
4210093 2099092 2099092 defendant Chapman Alan gent 592176 592176 Chapman, Alan, of Lynton, Cams, gent 2
4325278 2138834 2138834 defendant Salmon John husbandman 592176 592176 Salmon, John, of Lynton, Cams, husbandman 2
4325512 2138908 2138908 defendant Williamson or Williams Geoffrey tanner 592176 592176 Williamson or Williams, Geoffrey, of Lynton, Cams, tanner 0
4942909 2339758 2339758 defendant Hamond Thomas barber 592176 592176 Hamond, Thomas, of Lynton, Cams, barber 1
4956786 2343987 2343987 defendant Chapman John husbandman 592176 592176 Chapman, John, of Lynton, Cams, husbandman 0
4956789 2343988 2343988 defendant Chapman John husbandman 592176 592176 Chapman, John, of Lynton, Cams, husbandman 0
5026635 2364667 2364667 defendant Parys Henry gent 592176 592176 Parys, Henry, of Lynton, Cams, gent 2
5085840 2382253 2382253 defendant Brond William barker 592176 592176 Brond, William, of Lynton, Cams, barker 0
5289980 2442073 2442073 defendant Riche alias Kylhog Thomas husbandman 592176 592176 Riche alias Kylhog, Thomas, of Lynton, Cams, husbandman 2
5325919 2452839 2452839 plaintiff Snareston Thomas gent 592176 592176 Snareston, Thomas, of Lynton, Cams, gent 0
5525747 2512642 2512642 defendant Assheby Nicholas smith 592176 592176 Assheby, Nicholas, of Lynton, Cams, smith 0
5559793 2522823 2522823 defendant Walshman John weaver 592176 592176 Walshman, John, of Lynton, Cams, weaver 0
5634331 2554724 2554724 defendant West William chapman 592176 592176 West, William, of Lynton, Cams, chapman 5

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);