names

41 rows where place_id = 590624

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601810 1868224 1868224 defendant Haler William yeoman 590624 590624 Haler, William, of Brencheley, yeoman 1
3657967 1912744 1912744 defendant Lorkyn Richard husbandman 590624 590624 Lorkyn, Richard, of Brencheley, husbandman 0
3705478 1928004 1928004 defendant Stonarde Thomas husbandman 590624 590624 Stonarde, Thomas, of Brencheley, husbandman 1
3711354 1929858 1929858 plaintiff Sympcok alias Symond William (legal representative) 590624 590624 Sympcok alias Symond, William, of Brencheley, administrator of 0
3711357 1929858 1929858 defendant Gough John fuller 590624 590624 Gough, John, of Brencheley, fuller 1
3711358 1929858 1929858 defendant Shynfeld Richard fuller 590624 590624 Shynfeld, Richard, of Brencheley, fuller 2
3717988 1931922 1931922 defendant Andrewe Edmund weaver 590624 590624 Andrewe, Edmund, of Brencheley, weaver 2
3724561 1933966 1933966 defendant Langley Thomas   590624 590624 Langley, Thomas, of Brencheley, cook 4
3726166 1934450 1934450 plaintiff Sympcok alias Symond William (legal representative) 590624 590624 Sympcok alias Symond, William, of Brencheley, administrator of 0
3726169 1934450 1934450 defendant Gough John fuller 590624 590624 Gough, John, of Brencheley, fuller 1
3726170 1934450 1934450 defendant Shynfeld Richard fuller 590624 590624 Shynfeld, Richard, of Brencheley, fuller 2
3732049 1936255 1936255 defendant Godfrey Nicholas cooper 590624 590624 Godfrey, Nicholas, of Brencheley, cooper 1
3740466 1938875 1938875 defendant Langley Thomas   590624 590624 Langley, Thomas, of Brencheley, cook 1
3740637 1938934 1938934 plaintiff Sandell William, junior   590624 590624 Sandell, William, junior, of Brencheley 0
3791409 1955150 1955150 defendant Harvy Thomas weaver 590624 590624 Harvy, Thomas, of Brencheley, weaver 0
3791410 1955150 1955150 defendant Worme John   590624 590624 Worme, John, of Brencheley, wheelwright 1
3791411 1955150 1955150 defendant Shenfeld Richard sherman 590624 590624 Shenfeld, Richard, of Brencheley, sherman 2
3864024 1978149 1978149 defendant Congeherst Edmund tailor 590624 590624 Congeherst, Edmund, of Brencheley, tailor 1
3891065 1987278 1987278 defendant Haler John husbandman 590624 590624 (Haler, John, of Brencheley, husbandman 1
3908499 1993140 1993140 defendant Haler Robert smith 590624 590624 Haler, Robert, of Brencheley, smith 2
3915520 1995560 1995560 defendant Sellerste Thomas butcher 590624 590624 Sellerste, Thomas, of Brencheley, butcher 0
3915521 1995560 1995560 defendant Munde Richard weaver 590624 590624 Munde, Richard, of Brencheley, weaver 1
3932663 2001221 2001221 defendant Pynson John husbandman 590624 590624 Pynson, John, of Brencheley, husbandman 0
3941503 2004168 2004168 defendant Elsey Stephen   590624 590624 Elsey, Stephen, of Brencheley, "pocher" or poacher 0
3942365 2004460 2004460 defendant Gybbon George butcher 590624 590624 Gybbon, George, of Brencheley, butcher 2
4132733 2072032 2072032 defendant Grenewood Roger turner 590624 590624 Grenewood, Roger, of Brencheley, turner 0
4145136 2076459 2076459 defendant Woodgate John yeoman 590624 590624 Woodgate, John, of Brencheley, yeoman 0
4166724 2083857 2083857 defendant Taylor John husbandman 590624 590624 Taylor, John, of Brencheley, husbandman 1
4223514 2103714 2103714 defendant Styles John, junior yeoman 590624 590624 Styles, John, junior, of Brencheley, yeoman 2
4223518 2103715 2103715 defendant Styles John, junior yeoman 590624 590624 Styles, John, junior, of Brencheley, yeoman 2
4229768 2105893 2105893 defendant Salman Jerome husbandman 590624 590624 Salman, Jerome, of Brencheley, husbandman 0
4306579 2132437 2132437 defendant Evans Henry husbandman 590624 590624 Evans, Henry, of Brencheley, husbandman 0
4306580 2132437 2132437 defendant Fytsole Petronilla widow 590624 590624 Fytsole, Petronilla, of Brencheley, widow 1
4315949 2135691 2135691 defendant Lamporn Roland tailor 590624 590624 Lamporn, Roland, of Brencheley, tailor 0
4381987 2158662 2158662 defendant Hughes Lewis clerk 590624 590624 Hughes, Lewis, of Brencheley, clerk 1
4381988 2158662 2158662 defendant Johnson Thomas (legal representative) 590624 590624 Johnson, Thomas, of Brencheley, gent, administratrix of 2
4381989 2158662 2158662 defendant Johnson Mary widow 590624 590624 Johnson, Mary, of Brencheley, widow 3
4390423 2161416 2161416 defendant Jonson Anne widow 590624 590624 Jonson, Anne, of Brencheley, widow 1
5109596 2389238 2389238 defendant Danne Thomas laborer 590624 590624 Danne, Thomas, of Brencheley, laborer 0
5109597 2389238 2389238 defendant Danne Roger laborer 590624 590624 Danne, Roger, of Brencheley, laborer 1
5592938 2532789 2532789 defendant Burre Robert husbandman 590624 590624 Burre, Robert, of Brencheley, 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);