names

64 rows where place_id = 589217

✎ 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
3596927 1866672 1866672 defendant Hert Thomas yeoman 589217 589217 Hert, Thomas, of Smethe, yeoman 0
3597769 1866921 1866921 defendant Hert Thomas yeoman 589217 589217 Hert, Thomas, of Smethe, yeoman 0
3597770 1866921 1866921 defendant Godyn Thomas husbandman 589217 589217 Godyn, Thomas, of Smethe, husbandman 1
3597849 1866946 1866946 defendant Vagge Robert yeoman 589217 589217 Vagge, Robert, of Smethe, yeoman 1
3599482 1867479 1867479 defendant Adam John butcher 589217 589217 Adam, John, of Smethe, butcher 1
3612528 1871550 1871550 defendant Hert Richard, senior yeoman 589217 589217 Hert, Richard, senior, of Smethe, yeoman 0
3612530 1871551 1871551 defendant Hert Richard, senior yeoman 589217 589217 Hert, Richard, senior, of Smethe, yeoman 0
3615592 1872516 1872516 defendant Lorans William husbandman 589217 589217 Lorans, William, of Smethe, husbandman 0
3624647 1875243 1875243 defendant Hert Thomas baker 589217 589217 Hert, Thomas, of Smethe, baker 2
3624648 1875243 1875243 defendant Elne or Elve Alexander laborer 589217 589217 Elne or Elve, Alexander, of Smethe, laborer 3
3735984 1937492 1937492 defendant Blakburn Mathew yeoman 589217 589217 Blakburn, Mathew, of Smethe, yeoman 3
3782174 1952177 1952177 defendant Scotte John   589217 589217 Scotte, John, of Smethe, knight 0
3799596 1957795 1957795 defendant Scotte John   589217 589217 Scotte, John, of Smethe, knight 1
3872373 1980983 1980983 defendant Fagge John husbandman 589217 589217 Fagge, John, of Smethe, husbandman 0
3875026 1981874 1981874 defendant Hacche William husbandman 589217 589217 Hacche, William, of Smethe, husbandman 1
3993281 2022340 2022340 plaintiff Castell Thomas (legal representative) 589217 589217 Castell, Thomas, of Smethe, yeoman, executor of 0
4065430 2047927 2047927 defendant Blessenden John yeoman 589217 589217 Blessenden, John, of Smethe, yeoman 2
4065431 2047927 2047927 defendant Brownynge William yeoman 589217 589217 Brownynge, William, of Smethe, yeoman 3
4183400 2089673 2089673 defendant Cooke Edward cooper 589217 589217 Cooke, Edward, of Smethe, cooper 0
4472789 2192160 2192160 plaintiff Copherst Gilbert   589217 589217 Copherst, Gilbert, of Smethe 0
4550229 2216016 2216016 defendant Englissh Walter   589217 589217 Englissh, Walter, of Smethe 0
4654053 2247153 2247153 defendant Cophirst John tailor 589217 589217 Cophirst, John, of Smethe, tailor 0
4717399 2270781 2270781 defendant Crosby Richard dyer 589217 589217 Crosby, Richard, of Smethe, dyer 2
4750885 2280741 2280741 defendant atte Stokke John husbandman & sonof Thomas 589217 589217 atte Stokke, John, of Smethe, husbandman & sonof Thomas 1
4782581 2290565 2290565 defendant Crosby Richard wooder 589217 589217 Crosby, Richard, of Smethe, wooder 0
4795075 2294606 2294606 defendant Crosby Richard dyer 589217 589217 Crosby, Richard, of Smethe, dyer 0
4798294 2295655 2295655 defendant Lonkestre Thomas chaplain 589217 589217 Lonkestre, Thomas, of Smethe, chaplain 0
4848192 2310906 2310906 defendant Colvyle John miller 589217 589217 Colvyle, John, of Smethe, miller 0
4848202 2310909 2310909 defendant Hobbyng John miller 589217 589217 Hobbyng, John, of Smethe, miller 2
4875803 2319394 2319394 defendant Colvyle John miller 589217 589217 Colvyle, John, of Smethe, miller 0
4915806 2331442 2331442 defendant Kenet William butcher 589217 589217 Kenet, William, of Smethe, butcher 0
4924172 2334003 2334003 defendant Wykes Thomas laborer 589217 589217 Wykes, Thomas, of Smethe, laborer 1
4948693 2341574 2341574 defendant Walton Edmund gent 589217 589217 Walton, Edmund, of Smethe, gent 0
4990777 2354144 2354144 defendant Vagge William husbandman 589217 589217 Vagge, William, of Smethe, husbandman 1
5035008 2367098 2367098 defendant Hoochon John husbandman 589217 589217 Hoochon, John, of Smethe, husbandman 3
5103000 2387299 2387299 defendant Parys John husbandman 589217 589217 Parys, John, of Smethe, husbandman 0
5103001 2387299 2387299 defendant Webbe John weaver 589217 589217 Webbe, John, of Smethe, weaver 1
5106165 2388241 2388241 defendant Passhele John esq 589217 589217 Passhele, John, of Smethe, esq 0
5107960 2388768 2388768 defendant Hechon Richard husbandman 589217 589217 Hechon, Richard, of Smethe, husbandman 0
5182490 2410634 2410634 defendant Parys John husbandman 589217 589217 Parys, John, of Smethe, husbandman 0
5322835 2451910 2451910 defendant Clerk Thomas husbandman 589217 589217 Clerk, Thomas, of Smethe, husbandman 0
5322836 2451910 2451910 defendant Laurence Thomas husbandman 589217 589217 Laurence, Thomas, of Smethe, husbandman 1
5322838 2451911 2451911 defendant Clerk Thomas husbandman 589217 589217 Clerk, Thomas, of Smethe, husbandman 0
5322839 2451911 2451911 defendant Laurence Thomas husbandman 589217 589217 Laurence, Thomas, of Smethe, husbandman 1
5423835 2482085 2482085 defendant Laurens Thomas husbandman 589217 589217 Laurens, Thomas, of Smethe, husbandman 0
5423836 2482085 2482085 defendant Hert Richard husbandman 589217 589217 Hert, Richard, of Smethe, husbandman 1
5423837 2482085 2482085 defendant May James husbandman 589217 589217 May, James, of Smethe, husbandman 2
5432054 2484555 2484555 defendant Blakebourne William draper 589217 589217 Blakebourne, William, of Smethe, draper 0
5460608 2493118 2493118 defendant Blakebourne William draper 589217 589217 Blakebourne, William, of Smethe, draper 0
5490262 2501975 2501975 defendant Vagge Lawrence husbandman 589217 589217 Vagge, Lawrence, of Smethe, husbandman 0
5490264 2501975 2501975 defendant Stokke John husbandman 589217 589217 Stokke, John, of Smethe, husbandman 2
5498122 2504383 2504383 defendant Vagge Robert yeoman 589217 589217 Vagge, Robert, of Smethe, yeoman 1
5499662 2504841 2504841 defendant Hert Thomas yeoman 589217 589217 Hert, Thomas, of Smethe, yeoman 1
5509856 2507921 2507921 defendant May William yeoman 589217 589217 May, William, of Smethe, yeoman 1
5509859 2507922 2507922 defendant May William yeoman 589217 589217 May, William, of Smethe, yeoman 1
5511220 2508352 2508352 defendant Webbe John   589217 589217 Webbe, John, of Smethe, holy water clerk 1
5514207 2509288 2509288 defendant Hert Thomas yeoman 589217 589217 Hert, Thomas, of Smethe, yeoman 0
5514595 2509412 2509412 defendant Herte Richard yeoman 589217 589217 Herte, Richard, of Smethe, yeoman 0
5514596 2509412 2509412 defendant Herte Thomas yeoman 589217 589217 Herte, Thomas, of Smethe, yeoman 1
5560259 2522963 2522963 defendant Laurence William yeoman 589217 589217 Laurence, William, of Smethe, yeoman 0
5575178 2527325 2527325 defendant Hert Richard yeoman 589217 589217 Hert, Richard, of Smethe, yeoman 0
5601737 2535445 2535445 plaintiff Lewkenore Reginald gent 589217 589217 Lewkenore, Reginald, of Smethe, gent 0
5625097 2551786 2551786 defendant Copherst John, junior carter 589217 589217 Copherst, John, junior, of Smethe, carter 0
5634908 2554910 2554910 defendant Copherst John tailor 589217 589217 Copherst, John, of Smethe, tailor 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);