names

27 rows where place_id = 592352

✎ 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
3607444 1869986 1869986 defendant Hert Thomas husbandman 592352 592352 Hert, Thomas, of Imyngham, husbandman 0
3853306 1974654 1974654 defendant Aunger Thomas clerk 592352 592352 Aunger, Thomas, of Imyngham, clerk 0
3853307 1974654 1974654 defendant Tharrold Robert husbandman 592352 592352 Tharrold, Robert, of Imyngham, husbandman 1
4440256 2181865 2181865 defendant Stalyner Benedict   592352 592352 Stalyner, Benedict, of Imyngham 0
4450836 2185228 2185228 defendant Stalyner Benedict   592352 592352 Stalyner, Benedict, of Imyngham 0
4488175 2197017 2197017 defendant Bradley William   592352 592352 Bradley, William, of Imyngham 2
4488181 2197018 2197018 defendant Bradeley William de   592352 592352 Bradeley, William de, of Imyngham 3
4488186 2197019 2197019 defendant Bradeley William de   592352 592352 Bradeley, William de, of Imyngham 2
4488485 2197119 2197119 plaintiff Strangman John   592352 592352 Strangman, John, of Imyngham 0
4499184 2200391 2200391 defendant Talyfer Benedict   592352 592352 Talyfer, Benedict, of Imyngham 0
4499185 2200391 2200391 defendant Pattsyn William   592352 592352 Pattsyn, William, of Imyngham 1
4543255 2213773 2213773 defendant Racy Thomas   592352 592352 Racy, Thomas, of Imyngham 0
4592053 2228869 2228869 defendant Gunwayt Peter   592352 592352 Gunwayt, Peter, of Imyngham 0
4599789 2231157 2231157 defendant Strangman Robert, sen   592352 592352 Strangman, Robert, sen, of Imyngham 0
4682519 2260158 2260158 defendant Skate John   592352 592352 Skate, John, of Imyngham, bailiff 3
4727042 2273721 2273721 defendant Scate John   592352 592352 Scate, John, of Imyngham, bailiff 1
4729223 2274360 2274360 defendant Scate John husbandman 592352 592352 Scate, John, of Imyngham, husbandman 0
4734842 2276054 2276054 defendant Strangman Richard husbandman 592352 592352 Strangman, Richard, of Imyngham, husbandman 0
4761403 2283910 2283910 defendant Scate or State John yeoman 592352 592352 Scate or State, John, of Imyngham, yeoman 0
4766117 2285393 2285393 defendant Maundevyle John husbandman 592352 592352 Maundevyle, John, of Imyngham, husbandman 0
4852680 2312259 2312259 defendant Grene Robert husbandman 592352 592352 Grene, Robert, of Imyngham, husbandman 0
4863213 2315471 2315471 defendant Seate John husbandman 592352 592352 Seate, John, of Imyngham, husbandman 3
4869199 2317341 2317341 defendant Scate John husbandman 592352 592352 Scate, John, of Imyngham, husbandman 4
4966786 2346993 2346993 defendant Skate Robert husbandman 592352 592352 Skate, Robert, of Imyngham, husbandman 9
5361829 2463728 2463728 defendant Cosyn Walter smith 592352 592352 Cosyn, Walter, of Imyngham, smith 1
5433425 2484954 2484954 defendant Hamond William yeoman 592352 592352 Hamond, William, of Imyngham, yeoman 1
5631523 2553869 2553869 plaintiff Smyth William   592352 592352 Smyth, William, of Imyngham 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);