names

15 rows where place_id = 598079

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631025 1904525 1904525 defendant Bowedon William husbandman 598079 598079 Bowedon, William, of Bryxston, husbandman 0
3695778 1924910 1924910 defendant Roo John yeoman 598079 598079 Roo, John, of Bryxston, yeoman 0
3802758 1958759 1958759 defendant Wynston Elias laborer 598079 598079 Wynston, Elias, of Bryxston, laborer 1
3802759 1958759 1958759 defendant Steerte alias Wynston Robert laborer 598079 598079 Steerte alias Wynston, Robert, of Bryxston, laborer 2
3802760 1958759 1958759 defendant Colle John laborer 598079 598079 Colle, John, of Bryxston, laborer 3
3802761 1958759 1958759 defendant Bukler John husbandman 598079 598079 Bukler, John, of Bryxston, husbandman 4
3875704 1982122 1982122 defendant Bykford William husbandman 598079 598079 Bykford, William, of Bryxston, husbandman 0
4002974 2025829 2025829 defendant Wynston Robert husbandman 598079 598079 Wynston, Robert, of Bryxston, husbandman 4
4935265 2337432 2337432 defendant Wynston Henry husbandman 598079 598079 Wynston, Henry, of Bryxston, husbandman 2
5085586 2382180 2382180 defendant Wynston John husbandman 598079 598079 Wynston, John, of Bryxston, husbandman 0
5254894 2431645 2431645 defendant Weke Richard husbandman 598079 598079 together with Weke, Richard, of Bryxston, husbandman 4
5254899 2431646 2431646 defendant Weke Richard husbandman 598079 598079 Weke, Richard, of Bryxston, husbandman 0
5522575 2511884 2511884 defendant Urrey John husbandman 598079 598079 Urrey, John, of Bryxston, husbandman 1
5522576 2511884 2511884 defendant Kaydon Richard husbandman 598079 598079 Kaydon, Richard, of Bryxston, husbandman 2
5522577 2511884 2511884 defendant Howod Richard husbandman 598079 598079 Howod, Richard, of Bryxston, husbandman 3

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