names

16 rows where place_id = 625853

✎ 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
3766754 1947263 1947263 defendant Spence Henry gent 625853 625853 Spence, Henry, of Berden, gent 0
3766755 1947263 1947263 defendant Spence Ralph gent 625853 625853 Spence, Ralph, of Berden, gent 1
3913305 1994783 1994783 defendant Cotteys John husbandman 625853 625853 Cotteys, John, of Berden, husbandman 0
4196205 2094216 2094216 defendant Meade Agnes widow 625853 625853 (Meade, Agnes, of Berden, widow 3
4523992 2207836 2207836 defendant Cokere John (legal representative) 625853 625853 Cokere, John, of Berden, executors of 0
4589337 2228041 2228041 defendant Bolyton Robert   625853 625853 Bolyton, Robert, of Berden 0
4611358 2234613 2234613 plaintiff Clerke Thomas   625853 625853 Clerke, Thomas, of Berden 0
4611360 2234613 2234613 defendant Arnold John   625853 625853 Arnold, John, of Berden 1
4844604 2309833 2309833 defendant Hoghirde John yeoman 625853 625853 Hoghirde, John, of Berden, yeoman 2
4939319 2338678 2338678 defendant Blabburn William yeoman 625853 625853 Blabburn, William, of Berden, yeoman 0
4991203 2354254 2354254 defendant Falbergh Robert, sen yeoman 625853 625853 Falbergh, Robert, sen, of Berden, yeoman 11
4991205 2354254 2354254 defendant Cokker William yeoman 625853 625853 Cokker, William, of Berden, yeoman 13
5060852 2374818 2374818 defendant Auncell Robert husbandman 625853 625853 Auncell, Robert, of Berden, husbandman 2
5178290 2409353 2409353 defendant Thuresby George gent 625853 625853 Thuresby, George, of Berden, gent 0
5178291 2409353 2409353 defendant Spence Henry gent 625853 625853 Spence, Henry, of Berden, gent 1
5285630 2440821 2440821 defendant Symson John husbandman 625853 625853 Symson, John, of Berden, 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);