names

16 rows where place_id = 619470

✎ 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
3730145 1935652 1935652 defendant Barnys Richard husbandman 619470 619470 Barnys, Richard, of Brereton, husbandman 0
3864409 1978293 1978293 defendant Barnys Richard yeoman 619470 619470 Barnys, Richard, of Brereton, yeoman 2
3877194 1982613 1982613 plaintiff Hibb or Hill John   619470 619470 Hibb or Hill, John, of Brereton 0
3877195 1982613 1982613 defendant Brande John husbandman 619470 619470 Brande, John, of Brereton, husbandman 0
3893466 1988042 1988042 defendant Hill William husbandman 619470 619470 Hill, William, of Brereton, husbandman 3
3893467 1988042 1988042 defendant Thorpe Robert husbandman 619470 619470 Thorpe, Robert, of Brereton, husbandman 4
3893468 1988042 1988042 defendant Wilke Edward husbandman 619470 619470 Wilke, Edward, of Brereton, husbandman 5
3996086 2023353 2023353 plaintiff Dale John yeoman 619470 619470 Dale, John, of Brereton, yeoman 0
4157715 2080771 2080771 defendant Webbe Ralph husbandman 619470 619470 Webbe, Ralph, of Brereton, husbandman 0
4157716 2080771 2080771 defendant Greves George laborer 619470 619470 Greves, George, of Brereton, laborer 1
4550484 2216095 2216095 plaintiff Davenport Geoffrey   619470 619470 Davenport, Geoffrey, of Brereton, parson 0
4865618 2316212 2316212 defendant Colynson John husbandman 619470 619470 Colynson, John, of Brereton, husbandman 7
5223549 2422575 2422575 defendant Brereton Robert clerk 619470 619470 Brereton, Robert, of Brereton, clerk 1
5230056 2424406 2424406 defendant Benet Alexander husbandman 619470 619470 Benet, Alexander, of Brereton, husbandman 0
5340490 2457226 2457226 defendant Brereton Andrew esq 619470 619470 Brereton, Andrew, of Brereton, esq 1
5340494 2457227 2457227 defendant Brereton Andrew esq 619470 619470 Brereton, Andrew, of Brereton, esq 1

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);