names

24 rows where place_id = 611016

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3686381 1921897 1921897 defendant Smyth William husbandman 611016 611016 Smyth, William, of Grotton, husbandman 5
3686382 1921897 1921897 defendant Mayot William husbandman 611016 611016 Mayot, William, of Grotton, husbandman 6
3686383 1921897 1921897 defendant Watson Thomas husbandman 611016 611016 Watson, Thomas, of Grotton, husbandman 7
3686384 1921897 1921897 defendant Mayott John, junior husbandman 611016 611016 Mayott, John, junior, of Grotton, husbandman 8
3719937 1932505 1932505 defendant Gale William clothmaker 611016 611016 Gale, William, of Grotton, clothmaker 2
3760790 1945378 1945378 plaintiff Dogett Richard   611016 611016 Dogett, Richard, of Grotton 0
3799492 1957760 1957760 plaintiff Dogett Richard clothmaker 611016 611016 Dogett, Richard, of Grotton, clothmaker 1
3813181 1962033 1962033 defendant Patton Richard husbandman 611016 611016 Patton, Richard, of Grotton, husbandman 2
3813182 1962033 1962033 defendant Cooke Robert sherman 611016 611016 Cooke, Robert, of Grotton, sherman 3
3813188 1962035 1962035 plaintiff Dogett Richard clothman 611016 611016 Dogett, Richard, of Grotton, clothman 0
3813190 1962036 1962036 plaintiff Dogett Richard clothman 611016 611016 Dogett, Richard, of Grotton, clothman 0
3844841 1971930 1971930 plaintiff Dogett Richard clothier 611016 611016 Dogett, Richard, of Grotton, clothier 0
3898867 1989825 1989825 defendant Goche William husbandman 611016 611016 Goche, William, of Grotton, husbandman 1
3909703 1993554 1993554 defendant Lord Henry weaver 611016 611016 Lord, Henry, of Grotton, weaver 1
3949339 2006840 2006840 plaintiff Dyxon Oliver clothier 611016 611016 Dyxon, Oliver, of Grotton, clothier 0
3952999 2008116 2008116 defendant Dogett John   611016 611016 Dogett, John, of Grotton, gent, son of Richard 0
4037338 2038017 2038017 defendant Cooe John clothier 611016 611016 Cooe, John, of Grotton, clothier 0
4324498 2138584 2138584 defendant Meatt Thomas husbandman 611016 611016 Meatt, Thomas, of Grotton, husbandman 0
4324499 2138584 2138584 defendant Willott Hugh husbandman 611016 611016 Willott, Hugh, of Grotton, husbandman 1
4324500 2138584 2138584 defendant Meatt Richard husbandman 611016 611016 Meatt, Richard, of Grotton, husbandman 2
4324501 2138584 2138584 defendant Staley Thomas husbandman 611016 611016 Staley, Thomas, of Grotton, husbandman 3
4345975 2145853 2145853 defendant Heath John husbandman 611016 611016 Heath John, of Grotton, husbandman 1
4345976 2145853 2145853 defendant Watson Thomas husbandman 611016 611016 Watson, Thomas, of Grotton, husbandman 2
5150138 2401179 2401179 defendant Doxey Richard husbandman 611016 611016 Doxey, Richard, of Grotton, 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);