names

40 rows where place_id = 611962

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3690951 1923332 1923332 defendant Angell Richard laborer 611962 611962 Angell, Richard, of Rydon, laborer 0
3817650 1963422 1963422 defendant Sele Thomas chaplain 611962 611962 Sele, Thomas, of Rydon, chaplain 0
3834087 1968601 1968601 defendant Sele Thomas   611962 611962 Sele, Thomas, of Rydon, clerk, bachelor of law 0
3862946 1977803 1977803 defendant Rede Thomas   611962 611962 Rede, Thomas, of Rydon, shepherd 0
3867578 1979392 1979392 defendant Lawes William laborer 611962 611962 Lawes, William, of Rydon, laborer 1
3881531 1984084 1984084 defendant Lawes William laborer 611962 611962 Lawes, William, of Rydon, laborer 1
3904316 1991692 1991692 defendant Gunby Thomas husbandman 611962 611962 Gunby, Thomas, of Rydon, husbandman 2
3904317 1991692 1991692 defendant Dowe Arthur thatcher 611962 611962 Dowe, Arthur, of Rydon, thatcher 3
3904318 1991692 1991692 defendant Lylyco Thomas husbandman 611962 611962 Lylyco, Thomas, of Rydon, husbandman 4
3944518 2005181 2005181 defendant Jervys Thomas husbandman 611962 611962 Jervys, Thomas, of Rydon, husbandman 0
4009652 2028221 2028221 defendant Dyer Thomas husbandman 611962 611962 Dyer, Thomas, of Rydon, husbandman 1
4095374 2058667 2058667 defendant Whitacre Henry husbandman 611962 611962 Whitacre, Henry, of Rydon, husbandman 1
4127546 2070142 2070142 defendant Goteham John husbandman 611962 611962 Goteham, John, of Rydon, husbandman 0
4210324 2099165 2099165 defendant Foster Lancelot yeoman 611962 611962 Foster, Lancelot, of Rydon, yeoman 2
4212763 2100003 2100003 defendant Ruckley James husbandman 611962 611962 Ruckley, James, of Rydon, husbandman 3
4213602 2100277 2100277 defendant Ruckley James husbandman 611962 611962 Ruckley, James, of Rydon, husbandman 3
4257087 2115343 2115343 defendant Holcombe John husbandman 611962 611962 Holcombe, John, of Rydon, husbandman 1
4278574 2122441 2122441 defendant Lyppyncote John yeoman 611962 611962 Lyppyncote, John, of Rydon, yeoman 3
4290953 2126826 2126826 defendant Waller Ralph esq 611962 611962 Waller, Ralph, of Rydon, esq 0
4329437 2140153 2140153 defendant Rutlage James yeoman 611962 611962 Rutlage, James, of Rydon, yeoman 2
4354126 2148669 2148669 defendant Wallour Ralph esq 611962 611962 Wallour, Ralph, of Rydon, esq 0
4354127 2148669 2148669 defendant Mason William yeoman 611962 611962 together with Mason, William, of Rydon, yeoman 1
4587136 2227381 2227381 plaintiff Hortop Richard   611962 611962 Hortop, Richard, of Rydon 0
4663094 2249921 2249921 defendant Fere Thomas   611962 611962 Fere, Thomas, of Rydon, mason 0
4663096 2249922 2249922 defendant Fere Thomas   611962 611962 Fere, Thomas, of Rydon, mason 0
4742380 2278265 2278265 defendant Ropere Henry yeoman 611962 611962 Ropere, Henry, of Rydon, yeoman 1
5019255 2362524 2362524 defendant FitzAleyn John laborer 611962 611962 FitzAleyn, John, of Rydon, laborer 2
5046060 2370449 2370449 defendant Dowebyggyng John gent 611962 611962 Dowebyggyng, John, of Rydon, gent 2
5151002 2401432 2401432 defendant Reve John smith 611962 611962 Reve, John, of Rydon, smith 4
5153858 2402283 2402283 defendant Wyndyve William husbandman 611962 611962 Wyndyve, William, of Rydon, husbandman 2
5370168 2466254 2466254 defendant Glover Edmund husbandman 611962 611962 Glover, Edmund, of Rydon, husbandman 3
5382125 2469946 2469946 defendant Page Richard husbandman 611962 611962 Page, Richard, of Rydon, husbandman 4
5390741 2472413 2472413 defendant Page Richard husbandman 611962 611962 Page, Richard, of Rydon, husbandman 2
5401642 2475534 2475534 defendant Symond Richard pulter 611962 611962 Symond, Richard, of Rydon, pulter 8
5462244 2493609 2493609 defendant Glover Edmund husbandman 611962 611962 Glover, Edmund, of Rydon, husbandman 0
5479301 2498825 2498825 defendant Byrde Richard husbandman 611962 611962 (Byrde, Richard, of Rydon, husbandman 2
5479903 2499001 2499001 defendant Byrd Richard husbandman 611962 611962 Byrd, Richard, of Rydon, husbandman 1
5498058 2504360 2504360 defendant Byrde Richard husbandman 611962 611962 Byrde, Richard, of Rydon, husbandman 1
5498998 2504635 2504635 defendant Wymbotesham John husbandman 611962 611962 Wymbotesham, John, of Rydon, husbandman 0
5558808 2522530 2522530 defendant Hakford John husbandman 611962 611962 Hakford, John, of Rydon, husbandman 2

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);