names

17 rows where place_id = 633734

✎ 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
3814533 1962458 1962458 defendant Pynson Thomas mercer 633734 633734 Pynson, Thomas, of Alfold, mercer 1
3889142 1986604 1986604 defendant Hamond Richard husbandman 633734 633734 Hamond, Richard, of Alfold, husbandman 0
3889143 1986604 1986604 defendant Furlonger Robert laborer 633734 633734 Furlonger, Robert, of Alfold, laborer 1
3889144 1986604 1986604 defendant Furlonger Thomas laborer 633734 633734 Furlonger, Thomas, of Alfold, laborer 2
3923796 1998264 1998264 plaintiff Stoffolde John   633734 633734 Stoffolde, John, of Alfold 0
3924729 1998586 1998586 defendant Strodwyke alias Whitspore John   633734 633734 Strodwyke alias Whitspore, John, of Alfold, glass maker 1
4056958 2044871 2044871 defendant Mower Oliver yeoman 633734 633734 Mower, Oliver, of Alfold, yeoman 2
4559844 2219030 2219030 defendant Fullere Thomas   633734 633734 Fullere, Thomas, of Alfold 0
4717264 2270730 2270730 defendant Hychecok William butcher 633734 633734 Hychecok, William, of Alfold, butcher 0
4840125 2308460 2308460 plaintiff Hichecok William   633734 633734 Hichecok, William, of Alfold 0
5021030 2363048 2363048 defendant Stapeler Richard husbandman 633734 633734 Stapeler, Richard, of Alfold, husbandman 0
5030517 2365797 2365797 defendant Knyght Thomas husbandman 633734 633734 Knyght, Thomas, of Alfold, husbandman 0
5276205 2438113 2438113 defendant Hikkys Thomas sawyer 633734 633734 Hikkys, Thomas, of Alfold, sawyer 10
5390051 2472215 2472215 defendant Hichecok Richard butcher 633734 633734 Hichecok, Richard, of Alfold, butcher 0
5458294 2492381 2492381 defendant Hichecok Richard yeoman 633734 633734 Hichecok, Richard, of Alfold, yeoman 3
5493337 2502921 2502921 defendant Birchefold Thomas carpenter 633734 633734 Birchefold, Thomas, of Alfold, carpenter 0
5624428 2551582 2551582 defendant Mose Henry husbandman 633734 633734 Mose, Henry, of Alfold, husbandman 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);