names

37 rows where place_id = 597898

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3630312 1904328 1904328 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 3
3640185 1907373 1907373 defendant Cornewall Thomas   597898 597898 Cornewall, Thomas, of Burford, Salop, knight 0
3640189 1907374 1907374 defendant Cornewall Thomas   597898 597898 Cornewall, Thomas, of Burford, Salop, knight 0
3640234 1907382 1907382 defendant Cornewall Thomas   597898 597898 Cornewall, Thomas, of Burford, Salop, knight 4
3644339 1908648 1908648 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 4
3690240 1923107 1923107 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 0
3699777 1926153 1926153 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 0
3700004 1926235 1926235 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 0
3711612 1929942 1929942 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 0
3713289 1930466 1930466 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 0
3721731 1933075 1933075 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 5
3727654 1934924 1934924 defendant Cornewall Thomas   597898 597898 Cornewall, Thomas, of Burford, Salop, knight 0
3728011 1935029 1935029 defendant Cornwale Thomas   597898 597898 Cornwale, Thomas, of Burford, Salop, knight 5
3737568 1937980 1937980 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 0
3737573 1937981 1937981 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 0
3742906 1939636 1939636 defendant Cornewell Thomas   597898 597898 Cornewell, Thomas, of Burford, Salop, knight 0
3743273 1939763 1939763 defendant Cornwall Thomas   597898 597898 Cornwall, Thomas, of Burford, Salop, knight 0
3754525 1943372 1943372 defendant Cornewall Thomas   597898 597898 Cornewall, Thomas, of Burford, Salop, knight 0
3755067 1943534 1943534 defendant Cornwall Richard esq 597898 597898 Cornwall, Richard, of Burford, Salop, esq 0
3773935 1949565 1949565 defendant Cornewall Thomas   597898 597898 Cornewall, Thomas, of Burford, Salop, knight 0
3773939 1949566 1949566 defendant Cornewall Thomas   597898 597898 Cornewall, Thomas, of Burford, Salop,knight 0
3783512 1952595 1952595 defendant Cornewall Thomas   597898 597898 Cornewall, Thomas, of Burford, Salop, knight 0
3815364 1962721 1962721 defendant Cornewall Thomas   597898 597898 Cornewall, Thomas, of Burford, Salop, knight 1
3868568 1979725 1979725 defendant Cornewall Thomas   597898 597898 Cornewall, Thomas, of Burford, Salop, knight 0
3898048 1989555 1989555 defendant Cornewall Richard   597898 597898 Cornewall, Richard, of Burford, Salop, esq, son of Cornwall, Thomas, of Burford, knight 0
4078864 2052736 2052736 defendant Wyatt Richard yeoman 597898 597898 Wyatt, Richard, of Burford, Salop, yeoman 2
4153553 2079337 2079337 defendant Cornwall Edmund esq 597898 597898 Cornwall, Edmund, of Burford, Salop, esq 0
4188686 2091523 2091523 defendant Cornewall Edmund esq 597898 597898 Cornewall, Edmund, of Burford, Salop, esq 1
4405433 2166396 2166396 defendant Pytcher Richard gent 597898 597898 Pytcher, Richard, of Burford, Salop, gent 0
4800486 2296334 2296334 defendant Moodehale Thomas clerk 597898 597898 (Moodehale, Thomas, of Burford, Salop, clerk 2
4890136 2323690 2323690 defendant Cornewaill Edmund gent 597898 597898 (Cornewaill, Edmund, of Burford, Salop, gent 1
4976193 2349831 2349831 defendant Taylour William husbandman 597898 597898 Taylour, William, of Burford, Salop, husbandman 2
5505358 2506588 2506588 defendant Cornewayle Edmund   597898 597898 Cornewayle, Edmund, of Burford, Salop, knight 1
5556523 2521871 2521871 defendant Cornewaill Thomas   597898 597898 Cornewaill, Thomas, of Burford, Salop, knight 16
5556547 2521872 2521872 defendant Cornewaill Thomas   597898 597898 Cornewaill, Thomas, of Burford, Salop, knight 16
5586167 2530715 2530715 defendant Cornewall alias Cornell Thomas   597898 597898 Cornewall alias Cornell, Thomas, of Burford, Salop, knight 0
5586172 2530717 2530717 defendant Cornewell alias Cornell Thomas   597898 597898 Cornewell alias Cornell, Thomas, of Burford, Salop, knight, Baron of Burford 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);