names

23 rows where place_id = 616785

✎ 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
3716134 1931335 1931335 defendant Trott John chapman 616785 616785 Trott, John, of Meryett, chapman 2
3756798 1944098 1944098 defendant Pyccher Richard husbandman 616785 616785 Pyccher, Richard, of Meryett, husbandman 1
3760810 1945385 1945385 defendant Michell Nicholas husbandman 616785 616785 Michell, Nicholas, of Meryett, husbandman 0
3760811 1945385 1945385 defendant Michell Thomas husbandman 616785 616785 Michell, Thomas, of Meryett, husbandman 1
3768840 1947901 1947901 defendant Michell Robert baker 616785 616785 Michell, Robert, of Meryett, baker 0
3772497 1949089 1949089 defendant Stacy John clerk 616785 616785 Stacy, John, of Meryett, clerk 0
3790139 1954735 1954735 defendant Stacy John clerk 616785 616785 Stacy, John, of Meryett, clerk 0
3847745 1972867 1972867 defendant Lawte Alexander husbandman 616785 616785 Lawte, Alexander, of Meryett, husbandman 1
3847746 1972867 1972867 defendant Langdon Stephen husbandman 616785 616785 Langdon, Stephen, of Meryett, husbandman 2
3886116 1985606 1985606 defendant Rowke John husbandman 616785 616785 Rowke, John, of Meryett, husbandman 1
3954895 2008779 2008779 defendant Myll William husbandman 616785 616785 Myll, William, of Meryett, husbandman 0
3954896 2008779 2008779 defendant Pyke William husbandman 616785 616785 Pyke, William, of Meryett, husbandman 1
4008328 2027744 2027744 defendant Templeman Stephen husbandman 616785 616785 Templeman, Stephen, of Meryett, husbandman 0
4008330 2027745 2027745 defendant Templeman Stephen husbandman 616785 616785 Templeman, Stephen, of Meryett, husbandman 0
4026297 2034051 2034051 defendant Michell William yeoman 616785 616785 Michell, William, of Meryett, yeoman 0
4175115 2086759 2086759 defendant Laskinge John husbandman 616785 616785 Laskinge, John, of Meryett, husbandman 3
4262948 2117271 2117271 defendant Bagwell Augustine miller 616785 616785 Bagwell, Augustine, of Meryett, miller 2
4285459 2124847 2124847 defendant Templeman Stucley husbandman 616785 616785 Templeman, Stucley, of Meryett, husbandman 2
4291225 2126928 2126928 defendant Lawrence Nicholas gent 616785 616785 Lawrence, Nicholas, of Meryett, gent 0
4291227 2126929 2126929 defendant Lawrence Nicholas gent 616785 616785 Lawrence, Nicholas, of Meryett, gent 0
4339284 2143505 2143505 defendant Aishe George fuller 616785 616785 Aishe, George, of Meryett, fuller 0
4376663 2156719 2156719 defendant Templeman Thomas husbandman 616785 616785 Templeman, Thomas, of Meryett, husbandman 2
4379961 2157935 2157935 defendant Lawrence Nicholas yeoman 616785 616785 Lawrence, Nicholas, of Meryett, yeoman 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);