names

31 rows where place_id = 596783

✎ 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
3626166 1903046 1903046 defendant Vernon Richard esq 596783 596783 Vernon, Richard, of Haddon, esq 1
3626168 1903046 1903046 defendant Founder Hugh yeoman 596783 596783 Founder, Hugh, of Haddon, yeoman 3
3672185 1917300 1917300 defendant Ingram John husbandman 596783 596783 Ingram, John,of Haddon, husbandman 0
3682629 1920675 1920675 defendant Ingram John husbandman 596783 596783 Ingram, John, of Haddon, husbandman 0
3744368 1940139 1940139 defendant Maycok Ralph   596783 596783 Maycok, Ralph, of Haddon, shepherd 0
3744371 1940139 1940139 defendant Coffyn William esq 596783 596783 Coffyn, William, of Haddon, esq 3
3756657 1944062 1944062 defendant Moycok Ralph   596783 596783 Moycok, Ralph, of Haddon, shepherd 0
3756660 1944062 1944062 defendant Coffyn William esq 596783 596783 Coffyn, William, of Haddon, esq 3
4368840 2153909 2153909 defendant Manners John   596783 596783 (Manners, John, of Haddon, Derbs esq 1
4430784 2174385 2174385 defendant Straunge John le   596783 596783 Straunge, John le, of Haddon 0
4455166 2186616 2186616 defendant Cravenhurst Roger   596783 596783 Cravenhurst, Roger, of Haddon, parson 0
4509730 2203526 2203526 plaintiff Averey William   596783 596783 Averey, William, of Haddon 0
4604531 2232583 2232583 defendant Geffon Thomas   596783 596783 Geffon, Thomas, of Haddon 3
4662196 2249651 2249651 defendant Haddon Richard   596783 596783 Haddon, Richard, of Haddon 0
4662197 2249651 2249651 defendant Craas Reginald   596783 596783 Craas, Reginald, of Haddon 1
4670760 2256532 2256532 defendant Ingram John milner 596783 596783 Ingram, John, of Haddon, milner 0
4725723 2273333 2273333 defendant Gilberd Thomas husbandman 596783 596783 Gilberd, Thomas, of Haddon, husbandman 1
5032772 2366474 2366474 defendant Prykbrowde Adam yeoman 596783 596783 Prykbrowde, Adam, of Haddon, yeoman 3
5032790 2366477 2366477 defendant Prykbrowde Adam yeoman 596783 596783 Prykbrowde, Adam, of Haddon, yeoman 3
5070070 2377541 2377541 defendant Palmer Roger gent 596783 596783 Palmer, Roger, of Haddon, gent 0
5070074 2377542 2377542 defendant Vernon John esq 596783 596783 Vernon, John, of Haddon, esq 1
5240653 2427478 2427478 defendant Chapell Thomas husbandman 596783 596783 Chapell, Thomas, of Haddon, husbandman 1
5295367 2443638 2443638 defendant Wilkynson John husbandman 596783 596783 Wilkynson, John, of Haddon, husbandman 7
5295368 2443638 2443638 defendant Webster William husbandman 596783 596783 Webster, William, of Haddon, husbandman 8
5295369 2443638 2443638 defendant Middilton John husbandman 596783 596783 Middilton, John, of Haddon, husbandman 9
5295370 2443638 2443638 defendant Sclater Richard husbandman 596783 596783 Sclater, Richard, of Haddon, husbandman 10
5295371 2443638 2443638 defendant Button John husbandman 596783 596783 Button, John, of Haddon, husbandman 11
5295372 2443638 2443638 defendant Sclater William, junior husbandman 596783 596783 Sclater, William, junior, of Haddon, husbandman 12
5295373 2443638 2443638 defendant Webster John husbandman 596783 596783 Webster, John, of Haddon, husbandman 13
5561142 2523235 2523235 defendant Shelton John yeoman 596783 596783 Shelton, John, of Haddon, yeoman 4
5630896 2553674 2553674 defendant Waryn John husbandman 596783 596783 Waryn, John, of Haddon, husbandman 1

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