names

49 rows where place_id = 614984

✎ 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
3706521 1928325 1928325 plaintiff Irby Anthony gent 614984 614984 Irby, Anthony, of Swynshed, gent 0
3706527 1928326 1928326 defendant Morefote Robert laborer 614984 614984 Morefote, Robert, of Swynshed, laborer 2
3713260 1930456 1930456 defendant Alyer Richard husbandman 614984 614984 Alyer, Richard, of Swynshed, husbandman 1
3715276 1931066 1931066 defendant Proctour Lambert yeoman 614984 614984 Proctour, Lambert, of Swynshed, yeoman 0
3719354 1932339 1932339 plaintiff Halgh John (legal representative) 614984 614984 Halgh, John, of Swynshed, executor of 0
3723984 1933784 1933784 defendant Farndall John husbandman 614984 614984 Farndall, John, of Swynshed, husbandman 1
3756961 1944155 1944155 defendant Broune Margery widow 614984 614984 Broune, Margery, of Swynshed, widow 0
3756962 1944155 1944155 defendant Broune William gent 614984 614984 Broune, William, of Swynshed, gent 1
3798767 1957530 1957530 defendant Maye Henry laborer 614984 614984 Maye, Henry, of Swynshed, laborer 0
3798768 1957530 1957530 defendant Maye William laborer 614984 614984 Maye, William, of Swynshed, laborer 1
3798769 1957530 1957530 defendant Bothe Simon laborer 614984 614984 Bothe, Simon, of Swynshed, laborer 2
3875108 1981909 1981909 defendant Hune Thomas husbandman 614984 614984 Hune, Thomas, of Swynshed, husbandman 0
3900116 1990262 1990262 plaintiff Browne William mercer 614984 614984 Browne, William, of Swynshed, mercer 0
3961820 2011234 2011234 defendant Coocke John husbandman 614984 614984 Coocke, John, of Swynshed, husbandman 0
3980351 2017741 2017741 defendant Powell Robert tailor 614984 614984 Powell, Robert, of Swynshed, tailor 5
3990841 2021480 2021480 defendant Marchant Thomas yeoman 614984 614984 Marchant, Thomas, of Swynshed, yeoman 3
3991870 2021848 2021848 defendant Holland Thomas, junior esq 614984 614984 Holland, Thomas, junior, of Swynshed, esq 0
4006608 2027140 2027140 defendant Clay Thomas yeoman 614984 614984 Clay, Thomas, of Swynshed, yeoman 0
4009337 2028104 2028104 defendant Ferryman Robert cordwainer 614984 614984 Ferryman, Robert, of Swynshed, cordwainer 0
4009339 2028105 2028105 defendant Feryman Robert cordwainer 614984 614984 Feryman, Robert, of Swynshed, cordwainer 0
4012370 2029145 2029145 defendant Grenefeld Robert weaver 614984 614984 Grenefeld, Robert, of Swynshed, weaver 1
4021083 2032263 2032263 defendant Ferryman Robert cordwainer 614984 614984 Ferryman, Robert, of Swynshed, cordwainer 1
4033839 2036754 2036754 defendant Salomon John laborer 614984 614984 Salomon, John, of Swynshed, laborer 0
4060638 2046206 2046206 defendant Howson John clerk 614984 614984 Howson, John, of Swynshed, clerk 0
4077149 2052111 2052111 plaintiff Smythe Thomas gent 614984 614984 Smythe, Thomas, of Swynshed, gent 0
4077151 2052112 2052112 plaintiff Smythe Thomas gent 614984 614984 Smythe, Thomas, of Swynshed, gent 0
4077182 2052124 2052124 defendant Elward Richard laborer 614984 614984 Elward, Richard, of Swynshed, laborer 0
4110544 2064032 2064032 defendant Allenson Gregory husbandman 614984 614984 Allenson, Gregory, of Swynshed, husbandman 1
4110546 2064032 2064032 defendant Sharle John husbandman 614984 614984 Sharle, John, of Swynshed, husbandman 3
4111079 2064215 2064215 defendant Ferryman Robert shoemaker 614984 614984 Ferryman, Robert, of Swynshed, shoemaker 0
4156306 2080278 2080278 defendant Gunne Henry husbandman 614984 614984 Gunne, Henry, of Swynshed, husbandman 0
4173951 2086344 2086344 defendant Molton Thomas husbandman 614984 614984 Molton, Thomas, of Swynshed, husbandman 2
4366374 2153013 2153013 defendant Growbye William yeoman 614984 614984 Growbye, William, of Swynshed, yeoman 1
4555717 2217721 2217721 defendant Holwyn William laborer 614984 614984 Holwyn, William, of Swynshed, laborer 1
4715057 2270036 2270036 defendant West John husbandman 614984 614984 West, John, of Swynshed, husbandman 0
4764920 2285006 2285006 plaintiff Holand John   614984 614984 Holand, John, of Swynshed 0
4858681 2314089 2314089 defendant Wilson Richard yeoman 614984 614984 Wilson, Richard, of Swynshed, yeoman 0
4871113 2317941 2317941 defendant Wolmer John gent 614984 614984 Wolmer, John, of Swynshed, gent 0
4881748 2321188 2321188 defendant Mores John husbandman 614984 614984 Mores, John, of Swynshed, husbandman 0
5136644 2397240 2397240 plaintiff Overton William   614984 614984 Overton, William, of Swynshed 0
5152739 2401943 2401943 defendant Perche John   614984 614984 Perche, John, of Swynshed, rope maker 0
5157214 2403251 2403251 plaintiff Overton William gent 614984 614984 Overton, William, of Swynshed, gent 0
5157216 2403252 2403252 plaintiff Overton William gent 614984 614984 Overton, William, of Swynshed, gent 0
5161135 2404355 2404355 defendant Fryth Thomas gent 614984 614984 Fryth, Thomas, of Swynshed, gent 2
5173213 2407879 2407879 plaintiff Ovyrton William gent 614984 614984 Ovyrton, William, of Swynshed, gent 0
5184089 2411081 2411081 defendant Loxsmyth John   614984 614984 Loxsmyth, John, of Swynshed, husb 5
5204152 2416967 2416967 defendant Loxsmyth John husbandman 614984 614984 Loxsmyth, John, of Swynshed, husbandman 5
5490484 2502047 2502047 defendant Garard Stephen husbandman 614984 614984 (Garard, Stephen, of Swynshed, husbandman 1
5505401 2506603 2506603 defendant Garard Stephen husbandman 614984 614984 (Garard, Stephen, of Swynshed, husbandman 1

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