names

82 rows where place_id = 613981

✎ 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
3701291 1926650 1926650 defendant Teversham or Tenersham John yeoman 613981 613981 Teversham or Tenersham, John, of Lytcham, yeoman 0
3706635 1928360 1928360 defendant Feversham John innholder 613981 613981 Feversham, John, of Lytcham, innholder 0
3707561 1928660 1928660 defendant Teversham John innholder 613981 613981 Teversham, John, of Lytcham, innholder 0
3713455 1930521 1930521 defendant Stede John carpenter 613981 613981 Stede, John, of Lytcham, carpenter 0
3714759 1930918 1930918 defendant Pratte John husbandman 613981 613981 Pratte, John, of Lytcham, husbandman 2
3724798 1934040 1934040 defendant Myllys Richard mercer 613981 613981 Myllys, Richard, of Lytcham, mercer 2
3839774 1970368 1970368 defendant Constable Robert yeoman 613981 613981 Constable, Robert, of Lytcham, yeoman 2
3859306 1976603 1976603 defendant Anger Robert husbandman 613981 613981 Anger, Robert, of Lytcham, husbandman 0
3859308 1976603 1976603 defendant Constable Robert hsubandman 613981 613981 Constable, Robert, of Lytcham, hsubandman 2
3859309 1976603 1976603 defendant Rowke Richard husbandman 613981 613981 Rowke, Richard, of Lytcham, husbandman 3
3864611 1978360 1978360 defendant Constable Robert husbandman 613981 613981 Constable, Robert, of Lytcham, husbandman 0
3875975 1982215 1982215 defendant Gryggys William husbandman 613981 613981 Gryggys, William, of Lytcham, husbandman 3
3878816 1983166 1983166 defendant Pratte John (legal representative) 613981 613981 Pratte, John, of Lytcham, carver, executors of 0
3878817 1983166 1983166 defendant Bonger Lawrence clerk 613981 613981 (Bonger, Lawrence, of Lytcham, clerk 1
3878818 1983166 1983166 defendant Smyth Thomas tailor 613981 613981 Smyth, Thomas, of Lytcham, tailor 2
3878820 1983167 1983167 defendant Gryggys William yeoman 613981 613981 Gryggys, William, of Lytcham, yeoman 0
3887593 1986100 1986100 defendant Stede John carpenter 613981 613981 Stede, John, of Lytcham, carpenter 1
3898202 1989606 1989606 defendant Gold James mercer 613981 613981 Gold, James, of Lytcham, mercer 0
3911944 1994319 1994319 defendant Constable Richard husbandman 613981 613981 Constable, Richard, of Lytcham, husbandman 0
3970957 2014401 2014401 plaintiff Drake Francis (legal representative) 613981 613981 Drake, Francis, of Lytcham, executors of 0
4057918 2045216 2045216 defendant Belson Christopher cordwainer 613981 613981 Belson, Christopher, of Lytcham, cordwainer 0
4057927 2045217 2045217 defendant Mounton John beer brewer 613981 613981 Mounton, John, of Lytcham, beer brewer 2
4057949 2045224 2045224 defendant Benson Christopher shoemaker 613981 613981 Benson, Christopher, of Lytcham, shoemaker 0
4057950 2045224 2045224 defendant Benson Henry shoemaker 613981 613981 Benson, Henry, of Lytcham, shoemaker 1
4057954 2045225 2045225 defendant Benson Henry shoemaker 613981 613981 Benson, Henry, of Lytcham, shoemaker 0
4057955 2045225 2045225 defendant Benson Christopher shoemaker 613981 613981 together with Benson, Christopher, of Lytcham, shoemaker 1
4059730 2045874 2045874 defendant DraKe Richard shoemaker 613981 613981 DraKe, Richard, of Lytcham, shoemaker 1
4060361 2046107 2046107 defendant Ellwyn William husbandman 613981 613981 Ellwyn, William, of Lytcham, husbandman 0
4060363 2046108 2046108 defendant Elwyne John yeoman 613981 613981 Elwyne, John, of Lytcham, yeoman 0
4077500 2052243 2052243 defendant Elwyne William husbandman 613981 613981 Elwyne, William, of Lytcham, husbandman 0
4083856 2054498 2054498 defendant Adams Simon vintner 613981 613981 Adams, Simon, of Lytcham, vintner 3
4091995 2057432 2057432 defendant Chadwicke Robert singleman 613981 613981 Chadwicke, Robert, of Lytcham, yeoman, singleman 0
4094167 2058246 2058246 defendant Shadwick William yeoman 613981 613981 Shadwick, William, of Lytcham, yeoman 1
4133624 2072358 2072358 defendant Jenytas John, junior miller 613981 613981 Jenytas, John, junior, of Lytcham, miller 1
4143755 2075976 2075976 defendant Adams Henry yeoman 613981 613981 Adams, Henry, of Lytcham, yeoman 1
4154848 2079790 2079790 defendant Dymes John blacksmith 613981 613981 Dymes, John, of Lytcham, blacksmith 2
4158447 2081026 2081026 defendant Daniell John vintner 613981 613981 Daniell, John, of Lytcham, vintner 0
4172051 2085690 2085690 defendant Spynke Robert yeoman 613981 613981 Spynke, Robert, of Lytcham, yeoman 0
4260036 2116324 2116324 defendant Freman William yeoman 613981 613981 Freman, William, of Lytcham, yeoman 3
4274906 2121174 2121174 defendant Browne Robert chapman 613981 613981 Browne, Robert, of Lytcham, chapman 0
4274907 2121174 2121174 defendant Myndham John chapman 613981 613981 Myndham, John, of Lytcham, chapman 1
4276290 2121651 2121651 defendant Browne Richard grocer 613981 613981 Browne, Richard, of Lytcham, grocer 3
4280996 2123255 2123255 defendant Cooke Edmund vintner 613981 613981 Cooke, Edmund, of Lytcham, vintner 0
4281491 2123429 2123429 defendant Browne Richard yeoman 613981 613981 Browne, Richard, of Lytcham, yeoman 1
4281492 2123429 2123429 defendant Mendham John yeoman 613981 613981 Mendham, John, of Lytcham, yeoman 2
4283796 2124242 2124242 defendant Starr Adam yeoman 613981 613981 Starr, Adam, of Lytcham, yeoman 1
4285233 2124770 2124770 defendant Haycocke William yeoman 613981 613981 Haycocke, William, of Lytcham, yeoman 0
4287450 2125564 2125564 defendant Collyson Winifred widow 613981 613981 Collyson, Winifred, of Lytcham, widow 0
4287451 2125564 2125564 defendant Powle Oliver yeoman 613981 613981 Powle, Oliver, of Lytcham, yeoman 1
4287453 2125564 2125564 defendant Swanton Edward yeoman 613981 613981 Swanton, Edward, of Lytcham, yeoman 3
4310140 2133700 2133700 defendant Serlys Christopher butcher 613981 613981 Serlys, Christopher, of Lytcham, butcher 1
4315206 2135436 2135436 defendant Goodwyn Robert yeoman 613981 613981 Goodwyn, Robert, of Lytcham, yeoman 0
4315209 2135436 2135436 defendant Powle Christopher yeoman 613981 613981 Powle, Christopher, of Lytcham, yeoman 3
4316669 2135948 2135948 defendant Chadwicke Robert yeoman 613981 613981 Chadwicke, Robert, of Lytcham, yeoman 0
4316670 2135948 2135948 defendant Starre Adam yeoman 613981 613981 Starre, Adam, of Lytcham, yeoman 1
4325118 2138785 2138785 defendant Parker John tailor 613981 613981 Parker, John, of Lytcham, tailor 0
4325832 2139013 2139013 defendant Page James baker 613981 613981 Page, James, of Lytcham, baker 1
4326657 2139275 2139275 defendant Mendham John chapman 613981 613981 Mendham, John, of Lytcham, chapman 0
4328174 2139738 2139738 defendant Myndham John chapman 613981 613981 Myndham, John, of Lytcham, chapman 0
4331105 2140702 2140702 defendant Starre Adam yeoman 613981 613981 Starre, Adam, of Lytcham, yeoman 1
4331574 2140856 2140856 defendant Large Samuel blacksmith 613981 613981 Large, Samuel, of Lytcham, blacksmith 1
4337938 2143015 2143015 defendant Kyng John innholder 613981 613981 Kyng, John, of Lytcham, innholder 0
4344580 2145383 2145383 defendant Large Robert yeoman 613981 613981 Large, Robert, of Lytcham, yeoman 2
4350128 2147302 2147302 defendant Kinge John innkeeper 613981 613981 Kinge, John, of Lytcham, innkeeper 0
4371219 2154767 2154767 defendant Wilson Cuthbert yeoman 613981 613981 Wilson, Cuthbert, of Lytcham, or of Litleporte, Isle of Ely, Cams, yeoman 0
4385533 2159845 2159845 defendant Benson Michael brewer 613981 613981 Benson, Michael, of Lytcham, brewer 0
4395134 2162961 2162961 defendant Munes John yeoman 613981 613981 Munes, John, of Lytcham, yeoman 0
4402651 2165472 2165472 defendant Freman William grocer 613981 613981 Freman, William, of Lytcham, grocer 0
4406001 2166573 2166573 defendant Browne Richard grocer 613981 613981 Browne, Richard, of Lytcham, grocer 0
4474634 2192730 2192730 defendant Caudeler John   613981 613981 Caudeler, John, of Lytcham 0
4485067 2196027 2196027 defendant Caudeler John   613981 613981 Caudeler, John, of Lytcham 0
4551279 2216338 2216338 defendant Sadelere Reginald   613981 613981 Sadelere, Reginald, of Lytcham 0
5053430 2372630 2372630 defendant Smyth Robert smith 613981 613981 Smyth, Robert, of Lytcham, smith 3
5066331 2376458 2376458 defendant Heydon Adam laborer 613981 613981 Heydon, Adam, of Lytcham, laborer 0
5079384 2380330 2380330 defendant Basse Robert husbandman 613981 613981 Basse, Robert, of Lytcham, husbandman 0
5086152 2382346 2382346 defendant Shortwode John yeoman 613981 613981 Shortwode, John, of Lytcham, yeoman 0
5184390 2411173 2411173 defendant Germyn William chapman 613981 613981 Germyn, William, of Lytcham, chapman 0
5204954 2417195 2417195 defendant Germyn William chapman 613981 613981 Germyn, William, of Lytcham, chapman 0
5601658 2535416 2535416 plaintiff Leg John   613981 613981 Leg, John, of Lytcham 0
5601659 2535416 2535416 defendant Sarley Thomas husbandman 613981 613981 Sarley, Thomas, of Lytcham, husbandman 0
5601660 2535417 2535417 plaintiff Leg John   613981 613981 Leg, John, of Lytcham 0
5601661 2535417 2535417 defendant Sarley Thomas husbandman 613981 613981 Sarley, Thomas, of Lytcham, husbandman 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);