names

36 rows where place_id = 602734

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3651486 1910825 1910825 defendant Teyngate John dyer 602734 602734 Teyngate, John, of Bawtre, dyer 0
3656711 1912351 1912351 defendant Riche Nicholas yeoman 602734 602734 Riche, Nicholas, of Bawtre, yeoman 0
3671447 1917050 1917050 defendant Riche Nicholas yeoman 602734 602734 Riche, Nicholas, of Bawtre, yeoman 0
3678473 1919322 1919322 defendant Pawson Nicholas yeoman 602734 602734 Pawson, Nicholas, of Bawtre, yeoman 0
3717490 1931757 1931757 defendant Shaa John tailor 602734 602734 Shaa, John, of Bawtre, tailor 0
3732916 1936518 1936518 defendant Morton Charles gent 602734 602734 Morton, Charles, of Bawtre, gent 1
3743104 1939697 1939697 defendant Wryght Thomas tanner 602734 602734 Wryght, Thomas, of Bawtre, tanner 2
3749488 1941750 1941750 defendant Holbek Thomas yeoman 602734 602734 Holbek, Thomas, of Bawtre, yeoman 1
3774410 1949719 1949719 defendant Morton Charles gent 602734 602734 Morton, Charles, of Bawtre, gent 0
3778929 1951126 1951126 defendant Whitehede Henry butcher 602734 602734 Whitehede, Henry, of Bawtre, butcher 0
3785038 1953103 1953103 defendant Ranes Robert glover 602734 602734 Ranes, Robert, of Bawtre, glover 0
3785039 1953103 1953103 defendant Mabile Thomas laborer 602734 602734 Mabile, Thomas, of Bawtre, laborer 1
3785040 1953103 1953103 defendant Rede John carpenter 602734 602734 Rede, John, of Bawtre, carpenter 2
3791255 1955099 1955099 defendant Hobson Thomas butcher 602734 602734 Hobson, Thomas, of Bawtre, butcher 0
3792139 1955395 1955395 defendant Morton Charles gent 602734 602734 Morton, Charles, of Bawtre, gent 0
3792141 1955396 1955396 defendant Morton Charles gent 602734 602734 Morton, Charles, of Bawtre, gent 0
3806524 1959954 1959954 defendant Wadeson Miles yeoman 602734 602734 Wadeson, Miles, of Bawtre, yeoman 0
3807046 1960094 1960094 defendant Vescy Lancelot gent 602734 602734 Vescy, Lancelot, of Bawtre, gent 0
3807529 1960262 1960262 defendant Wadeson Miles draper 602734 602734 Wadeson, Miles, of Bawtre, draper 0
3815199 1962671 1962671 defendant Wadeson Miles laborer 602734 602734 Wadeson, Miles, of Bawtre, laborer 0
3832860 1968202 1968202 defendant Morton Charles esq 602734 602734 Morton, Charles, of Bawtre, esq 0
3839501 1970280 1970280 defendant Morton Charles esq 602734 602734 Morton, Charles, of Bawtre, esq 0
3840267 1970525 1970525 defendant Rede John carpenter 602734 602734 Rede, John, of Bawtre, carpenter 0
3841532 1970932 1970932 defendant Shay John husbandman 602734 602734 Shay, John, of Bawtre, husbandman 0
3841533 1970932 1970932 defendant Hobson Thomas husbandman 602734 602734 Hobson, Thomas, of Bawtre, husbandman 1
3850560 1973765 1973765 defendant Vescy Lancelot yeoman 602734 602734 Vescy, Lancelot, of Bawtre, yeoman 0
3850561 1973765 1973765 defendant Davyson John yeoman 602734 602734 Davyson, John, of Bawtre, yeoman 1
3855087 1975222 1975222 defendant Morton Charles esq 602734 602734 Morton, Charles, of Bawtre, esq 0
3856480 1975655 1975655 defendant Morton Charles esq 602734 602734 Morton, Charles, of Bawtre, esq 0
3892451 1987719 1987719 defendant Eledell Richard   602734 602734 Eledell, Richard, of Bawtre 0
3938561 2003239 2003239 defendant Gleydell Edward laborer 602734 602734 Gleydell, Edward, of Bawtre, laborer 0
4616792 2236253 2236253 defendant Morton Robert   602734 602734 Morton, Robert, of Bawtre 0
4641667 2243664 2243664 defendant Morton Robert   602734 602734 Morton, Robert, of Bawtre 0
4800578 2296363 2296363 plaintiff Wath Thomas merchant 602734 602734 Wath, Thomas, of Bawtre, merchant 0
5145787 2399905 2399905 defendant Walron Henry yeoman 602734 602734 Walron, Henry, of Bawtre, yeoman 3
5166132 2405828 2405828 defendant Walfon Henry yeoman 602734 602734 Walfon, Henry, of Bawtre, yeoman 6

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