names

32 rows where place_id = 587417

✎ 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
3591348 1864921 1864921 defendant Grygges John chapman 587417 587417 Grygges, John, of Stanton, Suff, chapman 1
3608654 1870367 1870367 defendant Mundys Adam, junior yeoman 587417 587417 Mundys, Adam, junior, of Stanton, Suff, yeoman 1
3633380 1905252 1905252 defendant Skot Robert carpenter 587417 587417 Skot, Robert, of Stanton, Suff, carpenter 0
3665962 1915288 1915288 defendant Balhed Robert alias Thomas yeoman 587417 587417 Balhed, Robert alias Thomas, of Stanton, suff, yeoman 0
3668348 1916048 1916048 plaintiff Aschfeld John gent 587417 587417 Aschfeld, John, of Stanton, Suff, gent 0
3673118 1917602 1917602 defendant Taillour Robert husbandman 587417 587417 Taillour, Robert, of Stanton, Suff, husbandman 3
3714502 1930832 1930832 defendant Clarke Guy mercer 587417 587417 Clarke, Guy, of Stanton, Suff, mercer 0
3729988 1935627 1935627 defendant Rokewode William gent 587417 587417 Rokewode, William, of Stanton, Suff, gent 1
3730659 1935824 1935824 defendant Drabbyll John husbandman 587417 587417 (Drabbyll, John, of Stanton, Suff, husbandman 1
3748649 1941505 1941505 defendant Clerke Guy mercer 587417 587417 Clerke, Guy, of Stanton, Suff, mercer 0
3802516 1958681 1958681 defendant Clerk Guy mercer 587417 587417 Clerk, Guy, of Stanton, Suff, mercer 1
3975608 2016032 2016032 defendant Serten Robert   587417 587417 Serten, Robert, of Stanton, Suff, clerk, parson of Wigboroughe, Essex 0
4032046 2036129 2036129 defendant Futter John (legal representative) 587417 587417 Futter, John, of Stanton, Suff, executor of 0
4034418 2036981 2036981 defendant Leverysche Thomas yeoman 587417 587417 Leverysche, Thomas, of Stanton, Suff, yeoman 0
4250202 2113049 2113049 defendant Bryce Edmund yeoman 587417 587417 Bryce, Edmund, of Stanton, Suff, yeoman 1
4264476 2117760 2117760 defendant Bryce Edmund yeoman 587417 587417 Bryce, Edmund, of Stanton, Suff, yeoman 1
4318147 2136456 2136456 defendant Goche John yeoman 587417 587417 Goche, John, of Stanton, Suff, yeoman 1
4337668 2142922 2142922 defendant Beart or Bearde John yeoman 587417 587417 Beart or Bearde, John, of Stanton, Suff, yeoman 2
4376620 2156707 2156707 defendant Taylor Edward yeoman 587417 587417 Taylor, Edward, of Stanton, Suff, yeoman 3
4405787 2166503 2166503 defendant Taylor Edward yeoman 587417 587417 Taylor, Edward, of Stanton, Suff, yeoman 3
4821577 2302830 2302830 defendant Arderne Richard gent 587417 587417 Arderne, Richard, of Stanton, Suff, gent 1
4823400 2303406 2303406 defendant Hallewyk John   587417 587417 Hallewyk, John, of Stanton, Suff, mason 0
4959190 2344718 2344718 defendant Clerk Simon husbandman 587417 587417 Clerk, Simon, of Stanton, Suff, husbandman 0
5065131 2376104 2376104 plaintiff Elys John   587417 587417 Elys, John, of Stanton, Suff 1
5095231 2385022 2385022 defendant Rollecrosse Thomas husbandman 587417 587417 Rollecrosse, Thomas, of Stanton, Suff, husbandman 2
5095235 2385023 2385023 defendant Rollecrosse Thomas husbandman 587417 587417 Rollecrosse, Thomas, of Stanton, Suff, husbandman 2
5557667 2522200 2522200 defendant Gryffyn John yeoman 587417 587417 Gryffyn, John, of Stanton, Suff, yeoman 1
5557695 2522206 2522206 defendant Gryffyn John yeoman 587417 587417 Gryffyn, John, of Stanton, Suff, yeoman 1
5569542 2525655 2525655 defendant Gryffyn John yeoman 587417 587417 Gryffyn, John, of Stanton, Suff, yeoman 0
5601519 2535366 2535366 defendant Asshefeld John gent 587417 587417 Asshefeld, John, of Stanton, Suff, gent 0
5601526 2535368 2535368 defendant Asshefeld John gent 587417 587417 Asshefeld, John, of Stanton, Suff, gent 3
5626780 2552347 2552347 defendant Balheed Thomas husbandman 587417 587417 Balheed, Thomas, of Stanton, Suff, husbandman 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);