names

35 rows where place_id = 605921

✎ 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
3663379 1914470 1914470 defendant Myghellys Robert yeoman 605921 605921 Myghellys, Robert, of Gunton, Norf, yeoman 0
3694312 1924426 1924426 defendant Barney Robert esq 605921 605921 Barney, Robert, of Gunton, Norf, esq 0
3722934 1933438 1933438 defendant Barney Ralph esq 605921 605921 Barney, Ralph, of Gunton, Norf, esq 0
3777156 1950607 1950607 defendant Alger Henry   605921 605921 Alger, Henry, of Gunton, Norf, wheelwright 0
3811701 1961556 1961556 defendant Begot Nicholas   605921 605921 Begot, Nicholas, of Gunton, Norf, mason 0
3811703 1961557 1961557 defendant Begot Nicholas   605921 605921 Begot, Nicholas, of Gunton, Norf, mason 0
3871684 1980766 1980766 defendant Bigott Nicholas   605921 605921 Bigott, Nicholas, of Gunton, Norf, mason 1
3944377 2005130 2005130 plaintiff Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 0
3945301 2005438 2005438 defendant Lymsey Edward esq 605921 605921 Lymsey, Edward, of Gunton, Norf, esq 1
3977796 2016804 2016804 defendant Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 0
3984128 2019088 2019088 defendant Lynsey Edward esq 605921 605921 Lynsey, Edward, of Gunton, Norf, esq 0
4177164 2087485 2087485 defendant Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 1
4213795 2100343 2100343 defendant Payne John husbandman 605921 605921 Payne, John, of Gunton, Norf, husbandman 0
4243700 2110882 2110882 defendant Barnye Martin esq 605921 605921 Barnye, Martin, of Gunton, Norf, esq 0
4243705 2110883 2110883 defendant Barnye Martin esq 605921 605921 Barnye, Martin, of Gunton, Norf, esq 0
4243717 2110885 2110885 defendant Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 0
4243722 2110886 2110886 defendant Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 0
4243727 2110887 2110887 defendant Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 0
4254299 2114438 2114438 defendant Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 0
4254304 2114439 2114439 defendant Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 0
4254309 2114440 2114440 defendant Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 0
4254314 2114441 2114441 defendant Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 0
4254319 2114442 2114442 defendant Barnye Martin esq 605921 605921 Barnye, Martin, of Gunton, Norf, esq 0
4358030 2150051 2150051 defendant Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 1
4382428 2158824 2158824 defendant Barney Martin esq 605921 605921 Barney, Martin, of Gunton, Norf, esq 1
4837051 2307546 2307546 defendant Clerk Robert husbandman 605921 605921 Clerk, Robert, of Gunton, Norf, husbandman 1
4995379 2355460 2355460 defendant Rake John husbandman 605921 605921 Rake, John, of Gunton, Norf, husbandman 1
4995380 2355460 2355460 defendant Jekkes Robert yeoman 605921 605921 Jekkes, Robert, of Gunton, Norf, yeoman 2
5056994 2373672 2373672 defendant Harpour John yeoman 605921 605921 Harpour, John, of Gunton, Norf, yeoman 2
5305883 2446748 2446748 defendant Stanton John   605921 605921 Stanton, John, of Gunton, Norf, parson & clerk 0
5371413 2466640 2466640 defendant Fuller William clerk 605921 605921 Fuller, William, of Gunton, Norf, clerk 0
5376907 2468373 2468373 defendant Barnard John gent 605921 605921 Barnard, John, of Gunton, Norf, gent 0
5451731 2490392 2490392 defendant Bernard John gent 605921 605921 Bernard, John, of Gunton, Norf, gent 0
5463697 2494057 2494057 defendant Barnard John gent 605921 605921 Barnard, John, of Gunton, Norf, gent 0
5475273 2497591 2497591 defendant Barnard John gent 605921 605921 Barnard, John, of Gunton, Norf, 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);