names

28 rows where place_id = 615079

✎ 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
3640695 1907532 1907532 defendant Fyppys Thomas husbandman 615079 615079 Fyppys, Thomas, of Shypton under Charewell, husbandman 0
3707027 1928483 1928483 defendant Paramore John husbandman 615079 615079 Paramore, John, of Shypton, husbandman 0
3707028 1928483 1928483 defendant Tylley John husbandman 615079 615079 Tylley, John, of Shypton, husbandman 1
3707029 1928483 1928483 defendant Browne Richard husbandman 615079 615079 Browne, Richard, of Shypton, husbandman 2
3707030 1928483 1928483 defendant Gower Richard husbandman 615079 615079 Gower, Richard, of Shypton, husbandman 3
3721193 1932929 1932929 defendant Paramore John husbandman 615079 615079 Paramore, John, of Shypton, husbandman 0
3721194 1932929 1932929 defendant Browne Richard husbandman 615079 615079 Browne, Richard, of Shypton, husbandman 1
3721195 1932929 1932929 defendant Gowre Richard husbandman 615079 615079 Gowre, Richard, of Shypton, husbandman 2
3742265 1939452 1939452 defendant Smyth William   615079 615079 Smyth, William, of Shypton, "lewter" 0
3742266 1939452 1939452 defendant Vause or Vanse Walter husbandman 615079 615079 Vause or Vanse, Walter, of Shypton, husbandman 1
3763803 1946324 1946324 defendant Dawton John innholder 615079 615079 Dawton, John, of Shypton, innholder 0
3882738 1984490 1984490 defendant Bukyngham William Wynslowe, husbandman 615079 615079 Bukyngham William, of Shypton, Wynslowe, husbandman 1
3960090 2010629 2010629 defendant Strelley Humphrey gent 615079 615079 Strelley, Humphrey, of Shypton, gent 0
4066919 2048466 2048466 defendant ap Owen Henry yeoman 615079 615079 ap Owen, Henry, of Shypton, yeoman 2
4103049 2061381 2061381 defendant Jurden Joan widow 615079 615079 Jurden, Joan, of Shypton, widow 0
4128597 2070519 2070519 defendant Knyghte alias Abyngton Roger yeoman 615079 615079 Knyghte alias Abyngton, Roger, of Shypton, yeoman 0
4147273 2077185 2077185 defendant Bayton John husbandman 615079 615079 Bayton, John, of Shypton, husbandman 0
4147275 2077186 2077186 defendant Bayton John husbandman 615079 615079 Bayton, John, of Shypton, husbandman 0
4223719 2103781 2103781 defendant Graye Walter gent 615079 615079 Graye, Walter, of Shypton, gent 0
4814111 2300513 2300513 defendant Gerveys Thomas husbandman 615079 615079 Gerveys, Thomas, of Shypton, husbandman 0
5030334 2365745 2365745 defendant Wyther John husbandman 615079 615079 Wyther, John, of Shypton, husbandman 3
5102753 2387220 2387220 defendant Clyvedon Richard, junior yeoman 615079 615079 Clyvedon, Richard, junior, of Shypton, yeoman 0
5533832 2515125 2515125 defendant Brayles John smith 615079 615079 Brayles, John, of Shypton on Stower, smith 0
5533833 2515125 2515125 defendant Bradley John husbandman 615079 615079 Bradley, John, of Shypton on Stower, husbandman 1
5537800 2516311 2516311 defendant Algarre John laborer 615079 615079 Algarre, John, of Shypton Berynger, laborer 0
5537802 2516312 2516312 defendant Algarre John laborer 615079 615079 Algarre, John, of Shypton Berynger, laborer 0
5574217 2527024 2527024 defendant Kechyn Richard tailor 615079 615079 Kechyn, Richard, of Shypton, tailor 0
5592360 2532597 2532597 plaintiff Warner William   615079 615079 Warner, William, of Shypton 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);