names

43 rows where place_id = 591804

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605640 1869429 1869429 defendant Yong Richard husbandman 591804 591804 Yong, Richard, of Tryng, Herts, husbandman 0
3627510 1903461 1903461 defendant Barbour Thomas tiler 591804 591804 Barbour, Thomas, of Tryng, Herts, tiler 3
3629676 1904135 1904135 defendant Barbour Thomas tiler 591804 591804 Barbour, Thomas, of Tryng, Herts, tiler 1
3630291 1904322 1904322 defendant Hill Thomas maltman 591804 591804 Hill, Thomas, of Tryng, Herts, maltman 0
3637843 1906652 1906652 defendant Rampton William mercer 591804 591804 Rampton, William, of Tryng, Herts, mercer 3
3659643 1913271 1913271 defendant Rampton William chapman 591804 591804 Rampton, William, of Tryng, Herts, chapman 1
3660826 1913652 1913652 defendant Hyll Thomas husbandman 591804 591804 Hyll, Thomas, of Tryng, Herts, husbandman 0
3667959 1915919 1915919 defendant Bowley Thomas husbandman 591804 591804 Bowley, Thomas, of Tryng, Herts, husbandman 1
3669572 1916419 1916419 defendant Hill Thomas husbandman 591804 591804 Hill, Thomas, of Tryng, Herts, husbandman 2
3671064 1916918 1916918 defendant Downefeld William shoemaker 591804 591804 Downefeld, William, of Tryng, Herts, shoemaker 0
3683573 1920995 1920995 defendant Whelpley Thomas shoemaker 591804 591804 Whelpley, Thomas, of Tryng, Herts, shoemaker 0
3701269 1926640 1926640 defendant Hychecok William maltman 591804 591804 Hychecok, William, of Tryng, Herts, maltman 0
3736142 1937545 1937545 defendant Colyns John maltman 591804 591804 Colyns, John, of Tryng, Herts, maltman 0
3750128 1941955 1941955 defendant Grover Miles gent 591804 591804 Grover, Miles, of Tryng, Herts, gent 0
3763129 1946099 1946099 defendant Deye William yeoman 591804 591804 Deye, William, of Tryng, Herts, yeoman 0
3765445 1946857 1946857 defendant Grover Miles gent 591804 591804 Grover, Miles, of Tryng, Herts, gent 0
3772904 1949224 1949224 defendant Daye William husbandman 591804 591804 Daye, William, of Tryng, Herts, husbandman 0
3772906 1949225 1949225 defendant Daye William husbandman 591804 591804 Daye, William, of Tryng, Herts, husbandman 0
3783510 1952594 1952594 defendant Grover Miles gent 591804 591804 Grover, Miles, of Tryng, Herts, gent 0
3791860 1955300 1955300 defendant Daye William yeoman 591804 591804 Daye, William, of Tryng, Herts, yeoman 0
3855184 1975254 1975254 defendant Hyll Thomas husbandman 591804 591804 Hyll, Thomas, of Tryng, Herts, husbandman 0
3866103 1978893 1978893 defendant Terry John chapman 591804 591804 Terry, John, of Tryng, Herts, chapman 4
3886343 1985686 1985686 defendant Foster Thomas dyer 591804 591804 Foster, Thomas, of Tryng, Herts, dyer 1
3908033 1992981 1992981 defendant Seyster Hugh husbandman 591804 591804 Seyster, Hugh, of Tryng, Herts, husbandman 2
3915996 1995734 1995734 defendant Robyns John husbandman 591804 591804 Robyns, John, of Tryng, Herts, husbandman 0
3927862 1999656 1999656 defendant Robyns John husbandman 591804 591804 Robyns, John, of Tryng, Herts, husbandman 0
3947440 2006177 2006177 defendant Grace William, junior miller 591804 591804 Grace, William, junior, of Tryng, Herts, miller 0
4027174 2034365 2034365 defendant Saunders William clerk 591804 591804 Saunders, William, of Tryng, Herts, clerk 0
4027177 2034366 2034366 defendant Saunders William clerk 591804 591804 Saunders, William, of Tryng, Herts, clerk 0
4747347 2279727 2279727 defendant Salwey Thomas yeoman 591804 591804 Salwey, Thomas, of Tryng, Herts, yeoman 1
4934575 2337206 2337206 defendant Passemere Robert gent 591804 591804 Passemere, Robert, of Tryng, Herts, gent 4
5093802 2384587 2384587 defendant Waryn Edmund yeoman 591804 591804 Waryn, Edmund, of Tryng, Herts, yeoman 1
5096339 2385360 2385360 defendant Geman Henry glover 591804 591804 Geman, Henry, of Tryng, Herts, glover 2
5155967 2402902 2402902 defendant Mowis Henry turner 591804 591804 Mowis, Henry, of Tryng, Herts, turner 4
5237850 2426653 2426653 defendant Sende Thomas, senior yeoman 591804 591804 Sende, Thomas, senior, of Tryng, Herts, yeoman 4
5275600 2437929 2437929 defendant Barlowe John gent 591804 591804 Barlowe, John, of Tryng, Herts, gent 0
5275602 2437930 2437930 defendant Barlowe John gent 591804 591804 Barlowe, John, of Tryng, Herts, gent 0
5275711 2437960 2437960 defendant Hatton John yeoman 591804 591804 Hatton, John, of Tryng, Herts, yeoman 3
5339768 2457012 2457012 defendant Wryght Thomas husbandman 591804 591804 Wryght, Thomas, of Tryng, Herts, husbandman 2
5339774 2457013 2457013 defendant Wryght Thomas husbandman 591804 591804 Wryght, Thomas, of Tryng, Herts, husbandman 2
5354407 2461446 2461446 defendant Lake Thomas husbandman 591804 591804 Lake, Thomas, of Tryng, Herts, husbandman 1
5354411 2461448 2461448 defendant Lake Thomas husbandman 591804 591804 Lake, Thomas, of Tryng, Herts, husbandman 0
5579341 2528618 2528618 plaintiff Bisshop Robert husbandman 591804 591804 Bisshop, Robert, of Tryng, Herts, 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);