names

42 rows where place_id = 589234

✎ 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
3596965 1866678 1866678 defendant Madyson Richard yeoman 589234 589234 Madyson, Richard, of Lyssyngton, yeoman 6
3692077 1923691 1923691 defendant Rawlyn Andrew weaver 589234 589234 Rawlyn, Andrew, of Lyssyngton, weaver 0
3853623 1974761 1974761 defendant Raynys Robert chaplain 589234 589234 Raynys, Robert, of Lyssyngton, chaplain 0
3894095 1988242 1988242 defendant Jackeson Thomas butcher 589234 589234 Jackeson, Thomas, of Lyssyngton, butcher 1
3894096 1988242 1988242 defendant Mayre Thomas butcher 589234 589234 Mayre, Thomas, of Lyssyngton, butcher 2
3894097 1988242 1988242 defendant Neyve Ellen spinster 589234 589234 Neyve, Ellen, of Lyssyngton, spinster 3
4126902 2069915 2069915 defendant Hutton Robert clerk 589234 589234 Hutton, Robert, of Lyssyngton, clerk 1
4137052 2073602 2073602 defendant Stevenson Humphrey yeoman 589234 589234 Stevenson, Humphrey, of Lyssyngton, yeoman 0
4150267 2078224 2078224 defendant Hutton Robert clerk 589234 589234 Hutton, Robert, of Lyssyngton, clerk 1
4494327 2198917 2198917 defendant Tetteford John   589234 589234 Tetteford, John, of Lyssyngton 0
4516761 2205648 2205648 defendant Teteford John   589234 589234 Teteford, John, of Lyssyngton 0
4524387 2207966 2207966 defendant Totteforth John de   589234 589234 Totteforth, John de, of Lyssyngton, son of Roger 1
4567450 2221381 2221381 plaintiff Tetteford John   589234 589234 Tetteford, John, of Lyssyngton 0
4745115 2279078 2279078 defendant Wryght James   589234 589234 Wryght, James, of Lyssyngton, vicar 2
4822041 2302969 2302969 defendant Wrythg James   589234 589234 Wrythg, James, of Lyssyngton, vicar 0
4844719 2309866 2309866 defendant Bolton John yeoman 589234 589234 Bolton, John, of Lyssyngton, yeoman 0
4866849 2316596 2316596 defendant Nese Richard husbandman 589234 589234 Nese, Richard, of Lyssyngton, husbandman 0
4952803 2342794 2342794 defendant Mustell Wistan   589234 589234 Mustell, Wistan, of Lyssyngton, holy water clerk 1
4975739 2349704 2349704 plaintiff North John (legal representative) 589234 589234 North, John, of Lyssyngton, executor of 0
4975741 2349704 2349704 defendant Benyngworth Richard husbandman 589234 589234 Benyngworth, Richard, of Lyssyngton, husbandman 0
5000077 2356908 2356908 defendant Launce Thomas husbandman 589234 589234 Launce, Thomas, of Lyssyngton, husbandman 1
5028778 2365293 2365293 defendant Mustell Wystan husbandman 589234 589234 Mustell, Wystan, of Lyssyngton, husbandman 0
5028779 2365293 2365293 defendant Wryght Thomas husbandman 589234 589234 Wryght, Thomas, of Lyssyngton, husbandman 1
5048090 2371050 2371050 defendant Clerk Thomas husbandman 589234 589234 Clerk, Thomas, of Lyssyngton, husbandman 1
5048774 2371272 2371272 defendant Sykes Robert   589234 589234 Sykes, Robert, of Lyssyngton, vicar 0
5048775 2371272 2371272 defendant Milnar Thomas laborer 589234 589234 Milnar, Thomas, of Lyssyngton, laborer 1
5056618 2373551 2373551 defendant Panyer or Pavyer William husbandman 589234 589234 Panyer or Pavyer, William, of Lyssyngton, husbandman 1
5085983 2382292 2382292 defendant Scot James husbandman 589234 589234 Scot, James, of Lyssyngton, husbandman 2
5100224 2386505 2386505 defendant Rither Richard gent 589234 589234 Rither, Richard, of Lyssyngton, gent 1
5122604 2393043 2393043 defendant Boos William husbandman 589234 589234 Boos, William, of Lyssyngton, husbandman 4
5130007 2395262 2395262 defendant Walker William husbandman 589234 589234 Walker, William, of Lyssyngton, husbandman 4
5229650 2424292 2424292 defendant Bamburgh Robert chaplain 589234 589234 Bamburgh, Robert, of Lyssyngton, chaplain 0
5246187 2429045 2429045 defendant Bannburgh Robert chaplain 589234 589234 Bannburgh, Robert, of Lyssyngton, chaplain 0
5249369 2429932 2429932 defendant Boos William husbandman 589234 589234 Boos, William, of Lyssyngton, husbandman 7
5255463 2431831 2431831 defendant Bethom Robert yeoman 589234 589234 Bethom, Robert, of Lyssyngton, yeoman 0
5255464 2431831 2431831 defendant Dawney Thomas husbandman 589234 589234 Dawney, Thomas, of Lyssyngton, husbandman 1
5313150 2448964 2448964 defendant Rider Henry gent 589234 589234 Rider, Henry, of Lyssyngton, gent 0
5360640 2463359 2463359 defendant Engylwod William   589234 589234 Engylwod, William, of Lyssyngton, wright 0
5360641 2463359 2463359 defendant Douney Robert husbandman 589234 589234 Douney, Robert, of Lyssyngton, husbandman 1
5408422 2477490 2477490 defendant Shefeld John yeoman 589234 589234 Shefeld, John, of Lyssyngton, yeoman 1
5439323 2486691 2486691 defendant Sheffeld John yeoman 589234 589234 Sheffeld, John, of Lyssyngton, yeoman 0
5500518 2505094 2505094 defendant Sheffeld John yeoman 589234 589234 Sheffeld, John, of Lyssyngton, yeoman 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);