names

15 rows where place_id = 624224

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3756793 1944096 1944096 defendant Balaman Christine widow 624224 624224 Balaman, Christine, of Aylesbeare, widow 1
4311131 2134043 2134043 defendant Besse alias Pearse Nicholas tailor 624224 624224 Besse alias Pearse, Nicholas, of Aylesbeare, tailor 1
4650513 2246171 2246171 defendant Clerk William baler 624224 624224 Clerk William, of Aylesbeare, baler 0
4699653 2265343 2265343 defendant Camell Thomas laborer 624224 624224 Camell, Thomas, of Aylesbeare, laborer 1
4771627 2287103 2287103 defendant Dole William   624224 624224 Dole, William, of Aylesbeare, vicar 0
5137813 2397569 2397569 defendant Byddysgate Richard   624224 624224 Byddysgate, Richard, of Aylesbeare, mason 0
5154481 2402460 2402460 plaintiff Baron Thomas husbandman 624224 624224 Baron, Thomas, of Aylesbeare, husbandman 1
5154483 2402460 2402460 plaintiff Samphord William   624224 624224 Samphord, William, of Aylesbeare 3
5154484 2402460 2402460 defendant Horne Philip husbandman 624224 624224 Horne, Philip, of Aylesbeare, husbandman 0
5245276 2428775 2428775 defendant Byttellysgate Richard   624224 624224 Byttellysgate, Richard, of Aylesbeare, freemason 0
5264527 2434659 2434659 defendant Bitellesgate Richard   624224 624224 Bitellesgate, Richard, of Aylesbeare, freemason 2
5296709 2444025 2444025 defendant Bytellysgate John   624224 624224 Bytellysgate, John, of Aylesbeare, mason 0
5305533 2446658 2446658 defendant Peke Richard husbandman 624224 624224 Peke, Richard, of Aylesbeare, husbandman 4
5357768 2462499 2462499 defendant Rondell William husbandman 624224 624224 Rondell, William, of Aylesbeare, husbandman 0
5552527 2520796 2520796 defendant Spencer Richard butcher 624224 624224 Spencer, Richard, of Aylesbeare, butcher 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);