names

24 rows where place_id = 635909

✎ 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
3827906 1966591 1966591 defendant Wentworth Thomas gent 635909 635909 Wentworth, Thomas, of Bretton, gent 1
3925248 1998756 1998756 defendant Bretton Ivon chaplain 635909 635909 Bretton, Ivon, of Bretton, chaplain 1
4041583 2039483 2039483 defendant Walker Thomas tanner 635909 635909 Walker, Thomas, of Bretton, tanner 7
4041592 2039484 2039484 defendant Walker Thomas tanner 635909 635909 Walker, Thomas, of Bretton, tanner 7
4173464 2086175 2086175 defendant Blearde John husbandman 635909 635909 Blearde, John, of Bretton, husbandman 0
4239152 2109318 2109318 defendant Stevynton John yeoman 635909 635909 Stevynton, John, of Bretton, yeoman 0
4319266 2136848 2136848 defendant Sawyer Christopher husbandman 635909 635909 Sawyer, Christopher, of Bretton, husbandman 3
4784531 2291167 2291167 defendant Beron Thomas husbandman 635909 635909 Beron, Thomas, of Bretton, husbandman 1
4816918 2301393 2301393 defendant Marsshall Jordan yeoman 635909 635909 Marsshall, Jordan, of Bretton, yeoman 1
4920384 2332892 2332892 defendant Colet John, junior husbandman 635909 635909 Colet, John, junior, of Bretton, husbandman 1
5272801 2437121 2437121 defendant Olred Robert husbandman 635909 635909 Olred, Robert, of Bretton, husbandman 3
5272802 2437121 2437121 defendant Olred Richard husbandman 635909 635909 Olred, Richard, of Bretton, husbandman 4
5272803 2437121 2437121 defendant Ryles Thomas laborer 635909 635909 Ryles, Thomas, of Bretton, laborer 5
5272814 2437123 2437123 defendant Olred Robert husbandman 635909 635909 Olred, Robert, of Bretton, husbandman 3
5272815 2437123 2437123 defendant Olred Richard, senior husbandman 635909 635909 Olred, Richard, senior, of Bretton, husbandman 4
5272816 2437123 2437123 defendant Parker John husbandman 635909 635909 Parker, John, of Bretton, husbandman 5
5272817 2437123 2437123 defendant Marsshall William husbandman 635909 635909 Marsshall, William, of Bretton, husbandman 6
5272818 2437123 2437123 defendant Ryles Thomas laborer 635909 635909 Ryles, Thomas, of Bretton, laborer 7
5496663 2503920 2503920 defendant Norrys Thomas yeoman 635909 635909 Norrys, Thomas, of Bretton, yeoman 0
5507042 2507112 2507112 defendant Treneman Richard husbandman 635909 635909 Treneman, Richard, of Bretton, husbandman 0
5507043 2507112 2507112 defendant Corndon John husbandman 635909 635909 Corndon, John, of Bretton, husbandman 1
5624661 2551652 2551652 defendant Litster John husbandman 635909 635909 Litster, John, of Bretton, husbandman 4
5624662 2551652 2551652 defendant Litster Thomas husbandman 635909 635909 Litster, Thomas, of Bretton, husbandman 5
5624663 2551652 2551652 defendant Hellewysse John husbandman 635909 635909 Hellewysse, John, of Bretton, husbandman 6

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