names

20 rows where place_id = 646685

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3892362 1987696 1987696 defendant Crofte Thomas gent 646685 646685 Crofte, Thomas, of Wigmore, gent 1
3897127 1989256 1989256 defendant Bedford Hugh husbandman 646685 646685 Bedford, Hugh, of Wigmore, husbandman 0
3897845 1989484 1989484 defendant Lewys David husbandman 646685 646685 Lewys, David, of Wigmore, husbandman 0
3897847 1989485 1989485 defendant Lewys David husbandman 646685 646685 Lewys, David, of Wigmore, husbandman 0
3897848 1989485 1989485 defendant Collyns John husbandman 646685 646685 Collyns, John, of Wigmore, husbandman 1
3897849 1989485 1989485 defendant Tyler Roger husbandman 646685 646685 Tyler, Roger, of Wigmore, husbandman 2
3897850 1989485 1989485 defendant Downe John tailor 646685 646685 Downe, John, of Wigmore, tailor 3
3898820 1989808 1989808 defendant Crofte Thomas gent 646685 646685 Crofte, Thomas, of Wigmore, gent 0
3898821 1989808 1989808 defendant Johns alias Jones Richard husbandman 646685 646685 Johns alias Jones, Richard, of Wigmore, husbandman 1
3898822 1989808 1989808 defendant Kyng John husbandman 646685 646685 Kyng, John, of Wigmore, husbandman 2
3911509 1994167 1994167 defendant Gryffyth Richard yeoman 646685 646685 Gryffyth, Richard, of Wigmore, yeoman 0
3911510 1994167 1994167 defendant Patty William yeoman 646685 646685 Patty, William, of Wigmore, yeoman 1
3911511 1994167 1994167 defendant Smart Henry yeoman 646685 646685 Smart, Henry, of Wigmore, yeoman 2
3932817 2001276 2001276 defendant Griffyth Richard yeoman 646685 646685 Griffyth, Richard, of Wigmore, yeoman 11
3963062 2011680 2011680 defendant Downe John husbandman 646685 646685 Downe, John, of Wigmore, husbandman 0
3963063 2011680 2011680 defendant Legge Edward gent 646685 646685 Legge, Edward, of Wigmore, gent 1
3963064 2011680 2011680 defendant Mason John yeoman 646685 646685 Mason, John, of Wigmore, yeoman 2
3963065 2011680 2011680 defendant Heryette William yeoman 646685 646685 Heryette, William, of Wigmore, yeoman 3
4090000 2056706 2056706 defendant Counde John husbandman 646685 646685 Counde, John, of Wigmore, husbandman 1
4409068 2167638 2167638 defendant Buckenill John, senior yeoman 646685 646685 Buckenill, John, senior, of Wigmore, yeoman 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);