names

22 rows where place_id = 585963

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587589 1863766 1863766 defendant Otteray John dyer 585963 585963 Otteray, John, of Brygewater, dyer 1
3628854 1903900 1903900 plaintiff Cockys Isabel (legal representative) 585963 585963 Cockys, Isabel, of Brygewater, executrix of 0
3628855 1903900 1903900 plaintiff Cockys Robert (legal representative) 585963 585963 Cockys, Robert, of Brygewater, executors of 1
3628873 1903906 1903906 defendant Davy John merchant 585963 585963 Davy, John, of Brygewater, merchant 0
3690490 1923192 1923192 defendant Saunders John merchant 585963 585963 Saunders, John, of Brygewater, merchant 1
3692179 1923722 1923722 defendant Bevyn Thomas yeoman 585963 585963 Bevyn, Thomas, of Brygewater, yeoman 3
3716221 1931366 1931366 defendant Northern Robert husbandman 585963 585963 Northern, Robert, of Brygewater, husbandman 0
3716222 1931366 1931366 defendant Morell Hugh merchant 585963 585963 Morell, Hugh, of Brygewater, merchant 1
3716223 1931366 1931366 defendant Clement John merchant 585963 585963 Clement, John, of Brygewater, merchant 2
3720943 1932845 1932845 defendant Hopkyns Thomas mercer 585963 585963 Hopkyns, Thomas, of Brygewater, mercer 0
3723169 1933515 1933515 defendant Sely John yeoman 585963 585963 Sely, John, of Brygewater, yeoman 1
3748282 1941390 1941390 defendant Hopkyns Thomas grocer 585963 585963 Hopkyns, Thomas, of Brygewater, grocer 0
3806512 1959949 1959949 defendant Newport John chapman 585963 585963 Newport, John, of Brygewater, chapman 1
3819635 1964019 1964019 defendant Gapper Richard dyer 585963 585963 Gapper, Richard, of Brygewater, dyer 0
3835340 1968991 1968991 defendant Wever William weaver 585963 585963 Wever, William, of Brygewater, weaver 3
3837816 1969739 1969739 defendant Walshe John tailor 585963 585963 Walshe, John, of Brygewater, tailor 2
3874125 1981570 1981570 plaintiff Compton John gent 585963 585963 Compton, John, of Brygewater, gent 0
3874128 1981570 1981570 defendant Perott John yeoman 585963 585963 Perott, John, of Brygewater, yeoman 2
3914525 1995201 1995201 defendant Castylman John, junior merchant 585963 585963 Castylman, John, junior, of Brygewater, merchant 3
4712433 2269204 2269204 plaintiff Skynner John   585963 585963 Skynner, John, of Brygewater 0
5372183 2466891 2466891 plaintiff Kendal John merchant 585963 585963 Kendal, John, of Brygewater, merchant 0
5564162 2524130 2524130 defendant Appowell William merchant 585963 585963 Appowell, William, of Brygewater, merchant 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);