names

63 rows where place_id = 593492

✎ 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
3612085 1871425 1871425 defendant Fryth John cutler 593492 593492 Fryth, John, of Sheffeld, cutler 0
3612086 1871425 1871425 defendant Blaunche John yeoman 593492 593492 Blaunche, John, of Sheffeld, yeoman 1
3612092 1871427 1871427 defendant Fryth John cutler 593492 593492 Fryth, John, of Sheffeld, cutler 1
3612093 1871427 1871427 defendant Blaunche John yeoman 593492 593492 Blaunche, John, of Sheffeld, yeoman 2
3664017 1914693 1914693 defendant Hudson John husbandman 593492 593492 Hudson, John, of Sheffeld, husbandman 0
3726601 1934579 1934579 defendant Coke John hardwareman 593492 593492 Coke, John, of Sheffeld, hardwareman 0
3781736 1952035 1952035 plaintiff Hebson Geoffrey hardwareman 593492 593492 Hebson, Geoffrey, of Sheffeld, hardwareman 0
3782027 1952128 1952128 plaintiff Hobson Geoffrey   593492 593492 Hobson, Geoffrey, of Sheffeld 0
3782029 1952129 1952129 plaintiff Hobson Geoffrey   593492 593492 Hobson, Geoffrey, of Sheffeld 0
3789569 1954566 1954566 defendant Coke John hardwareman 593492 593492 Coke, John, of Sheffeld, hardwareman 0
3796968 1956931 1956931 defendant Tripett William yeoman 593492 593492 Tripett, William, of Sheffeld, yeoman 3
3796973 1956932 1956932 defendant Tripett William yeoman 593492 593492 Tripett, William, of Sheffeld, yeoman 3
3853642 1974768 1974768 plaintiff Sponer Hugh mercer 593492 593492 Sponer, Hugh, of Sheffeld, mercer 0
3854109 1974921 1974921 defendant Taylour John mercer 593492 593492 Taylour, John, of Sheffeld, mercer 0
3866364 1978984 1978984 defendant Knyght William fuller 593492 593492 Knyght, William, of Sheffeld, fuller 0
3899744 1990129 1990129 defendant Newbold John cutler 593492 593492 Newbold, John, of Sheffeld, cutler 1
3910193 1993722 1993722 defendant Hudd John tailor 593492 593492 Hudd, John, of Sheffeld, tailor 0
3923467 1998156 1998156 defendant Bourrons Thomas smith 593492 593492 Bourrons, Thomas, of Sheffeld, smith 1
4059998 2045972 2045972 defendant Horner Thomas yeoman 593492 593492 Horner, Thomas, of Sheffeld, yeoman 0
4060009 2045976 2045976 defendant Horner Thomas yeoman 593492 593492 Horner, Thomas, of Sheffeld, yeoman 0
4062406 2046844 2046844 defendant Shutte William   593492 593492 Shutte, William, of Sheffeld, or of Rotheram, Yorks, freemason 0
4064163 2047456 2047456 defendant Ellys Stephen laborer 593492 593492 Ellys, Stephen, of Sheffeld, laborer 7
4069997 2049558 2049558 defendant Gyll Adam yeoman 593492 593492 Gyll, Adam, of Sheffeld, yeoman 0
4069998 2049558 2049558 defendant Slacke William yeoman 593492 593492 Slacke, William, of Sheffeld, yeoman 1
4078423 2052578 2052578 defendant Fysher Thomas yeoman 593492 593492 Fysher, Thomas, of Sheffeld, yeoman 0
4084219 2054629 2054629 plaintiff Barbor Ralph yeoman 593492 593492 Barbor, Ralph, of Sheffeld, yeoman 0
4084221 2054630 2054630 plaintiff Barbor Ralph yeoman 593492 593492 Barbor, Ralph, of Sheffeld, yeoman 0
4095896 2058863 2058863 defendant Ellys Stephen laborer 593492 593492 Ellys, Stephen, of Sheffeld, laborer 3
4106118 2062481 2062481 defendant Tryppett John shoemaker 593492 593492 Tryppett, John, of Sheffeld, shoemaker 0
4106119 2062481 2062481 defendant Phyllpott John butcher 593492 593492 Phyllpott, John, of Sheffeld, butcher 1
4106120 2062481 2062481 defendant Cooke Thomas laborer 593492 593492 Cooke, Thomas, of Sheffeld, laborer 2
4111046 2064200 2064200 defendant Hobson Robert carpenter 593492 593492 Hobson, Robert, of Sheffeld, carpenter 0
4124964 2069218 2069218 defendant Brey Thomas (legal representative) 593492 593492 Brey, Thomas, of Sheffeld, gent, executor of 2
4137220 2073659 2073659 defendant Hibberd Robert carpenter 593492 593492 Hibberd, Robert, of Sheffeld, carpenter 0
4147542 2077282 2077282 defendant Shemelde Richard   593492 593492 Shemelde, Richard, of Sheffeld, shear smith 0
4149077 2077799 2077799 defendant Parlyngton William hardwareman 593492 593492 Parlyngton, William, of Sheffeld, hardwareman 0
4149078 2077799 2077799 defendant Byrley Thomas glover 593492 593492 Byrley, Thomas, of Sheffeld, glover 1
4157576 2080723 2080723 defendant Haule or Hanle James glover 593492 593492 Haule or Hanle, James, of Sheffeld, glover 0
4161610 2082130 2082130 defendant Hibberd Robert carpenter 593492 593492 Hibberd, Robert, of Sheffeld, carpenter 0
4170028 2085010 2085010 defendant Bower Robert chapman 593492 593492 Bower, Robert, of Sheffeld, chapman 0
4180134 2088531 2088531 defendant Trippett Henry cutler 593492 593492 Trippett, Henry, of Sheffeld, cutler 0
4186085 2090620 2090620 defendant Byrley Henry sheather 593492 593492 Byrley, Henry, of Sheffeld, sheather 1
4186086 2090620 2090620 defendant Ingland William cutler 593492 593492 Ingland, William, of Sheffeld, cutler 2
4193354 2093243 2093243 defendant Bower Robert chapman 593492 593492 Bower, Robert, of Sheffeld, chapman 0
4272616 2120418 2120418 defendant Ferris Thomas tailor 593492 593492 Ferris, Thomas, of Sheffeld, tailor 1
4321279 2137534 2137534 defendant Horner Thomas husbandman 593492 593492 Horner, Thomas, of Sheffeld, husbandman 1
4342866 2144779 2144779 defendant Gleidhill Henry yeoman 593492 593492 Gleidhill, Henry, of Sheffeld, yeoman 0
4355449 2149128 2149128 defendant Skynner Thomas yeoman 593492 593492 Skynner, Thomas, of Sheffeld, yeoman 0
4355450 2149128 2149128 defendant Morton Robert yeoman 593492 593492 Morton, Robert, of Sheffeld, yeoman 1
4355451 2149128 2149128 defendant Morton William yeoman 593492 593492 Morton, William, of Sheffeld, cutler, Robert, Hugh, of Sheffeld, shoemaker, yeoman 2
4410013 2167955 2167955 defendant Spencer John cutler 593492 593492 Spencer, John, of Sheffeld, cutler 0
4729447 2274422 2274422 plaintiff Ledes John de   593492 593492 Ledes, John de, of Sheffeld 0
4826541 2304337 2304337 defendant Raweson John tailor 593492 593492 Raweson, John, of Sheffeld, tailor 0
4826546 2304338 2304338 defendant Raweson John tailor 593492 593492 Raweson, John, of Sheffeld, tailor 0
4881759 2321192 2321192 defendant Chaloner John   593492 593492 Chaloner, John, of Sheffeld 0
5316290 2449958 2449958 defendant Hobson William shoemaker 593492 593492 Hobson, William, of Sheffeld, shoemaker 1
5369395 2466022 2466022 defendant Blaunche Thomas chapman 593492 593492 Blaunche, Thomas, of Sheffeld, chapman 4
5379277 2469112 2469112 defendant Hobson William   593492 593492 Hobson, William, of Sheffeld, shoe maker 0
5381854 2469865 2469865 defendant Bagge Robert yeoman 593492 593492 Bagge, Robert, of Sheffeld, yeoman 1
5499407 2504763 2504763 defendant Bygton William chapman 593492 593492 Bygton, William, of Sheffeld, chapman 1
5499412 2504764 2504764 defendant Bygton William chapman 593492 593492 Bygton, William, of Sheffeld, chapman 1
5547682 2519339 2519339 plaintiff Wright Thomas, senior   593492 593492 Wright, Thomas, senior, of Sheffeld 0
5603407 2535954 2535954 plaintiff Parker Robert   593492 593492 Parker, Robert, of Sheffeld 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);