names

58 rows where place_id = 586788

✎ 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
3589624 1864397 1864397 defendant Bell John yeoman 586788 586788 Bell, John, of Tadcastre, yeoman 0
3637733 1906615 1906615 defendant Dawson William butcher 586788 586788 Dawson, William, of Tadcastre, butcher 0
3648423 1909908 1909908 defendant Barker Robert yeoman 586788 586788 Barker, Robert, of Tadcastre, yeoman 0
3648424 1909908 1909908 defendant Siddall Robert yeoman 586788 586788 Siddall, Robert, of Tadcastre, yeoman 1
3681104 1920171 1920171 defendant Thornton Henry yeoman 586788 586788 Thornton, Henry, of Tadcastre, yeoman 0
3753891 1943164 1943164 defendant Laycok John pewterer 586788 586788 Laycok, John, of Tadcastre, pewterer 0
3771053 1948634 1948634 defendant Laycok John pewterer 586788 586788 Laycok, John, of Tadcastre, pewterer 0
4485061 2196025 2196025 defendant Harden Thomas   586788 586788 Harden, Thomas, of Tadcastre 2
4503789 2201749 2201749 plaintiff Porter Thomas   586788 586788 Porter, Thomas, of Tadcastre 0
4534246 2210976 2210976 defendant Harden Thomas   586788 586788 Harden, Thomas, of Tadcastre 2
4655275 2247536 2247536 defendant Warde John husbandman 586788 586788 Warde, John, of Tadcastre, husbandman 0
4681864 2259941 2259941 defendant Warde John husbandman 586788 586788 Warde, John, of Tadcastre, husbandman 0
4688018 2261824 2261824 defendant Clerk Richard husbandman 586788 586788 Clerk, Richard, of Tadcastre, husbandman 0
4688019 2261824 2261824 defendant Clerk William laborer 586788 586788 Clerk, William, of Tadcastre, laborer 1
4688020 2261824 2261824 defendant Dale Robert de husbandman 586788 586788 Dale, Robert de, of Tadcastre, husbandman 2
4688021 2261824 2261824 defendant Graunge John husbandman 586788 586788 Graunge, John, of Tadcastre, husbandman 3
4750926 2280753 2280753 defendant Graunge Nicholas husbandman 586788 586788 Graunge, Nicholas, of Tadcastre, husbandman 1
4758283 2282966 2282966 defendant Blays Richard yeoman 586788 586788 Blays, Richard, of Tadcastre, yeoman 1
4786611 2291863 2291863 defendant Mollyngton Margery   586788 586788 Mollyngton, Margery, of Tadcastre, servant 0
4797752 2295476 2295476 defendant Soureby John laborer 586788 586788 Soureby, John, of Tadcastre, laborer 2
4799327 2295965 2295965 defendant Sampson John walker 586788 586788 Sampson, John, of Tadcastre, walker 1
4860431 2314628 2314628 plaintiff Clerk Richard   586788 586788 Clerk, Richard, of Tadcastre 0
4886058 2322498 2322498 defendant Coke John butcher 586788 586788 Coke, John, of Tadcastre, butcher 1
4903171 2327601 2327601 defendant Pannall William yeoman 586788 586788 Pannall, William, of Tadcastre, yeoman 3
4947352 2341166 2341166 defendant Blakburn John   586788 586788 Blakburn, John, of Tadcastre, "flesshewer" or butcher 0
4954267 2343249 2343249 defendant Taillour John laborer 586788 586788 Taillour, John, of Tadcastre, laborer 0
4969697 2347882 2347882 defendant Mersshall Robert laborer 586788 586788 Mersshall, Robert, of Tadcastre, laborer 0
4969698 2347882 2347882 defendant Chereburgh John laborer 586788 586788 Chereburgh, John, of Tadcastre, laborer 1
4969700 2347883 2347883 defendant Shutteley John quarrier 586788 586788 Shutteley, John, of Tadcastre, quarrier 0
4978357 2350478 2350478 defendant Walton Robert fisher 586788 586788 Walton, Robert, of Tadcastre, fisher 1
4978360 2350478 2350478 defendant Blakburn John butcher 586788 586788 Blakburn, John, of Tadcastre, butcher 4
4978361 2350478 2350478 defendant Marshall William smith 586788 586788 Marshall, William, of Tadcastre, smith 5
4978362 2350478 2350478 defendant Kilburn William weaver 586788 586788 Kilburn, William, of Tadcastre, weaver 6
4978363 2350478 2350478 defendant Cherybought Thomas butcher 586788 586788 Cherybought, Thomas, of Tadcastre, butcher 7
4978364 2350478 2350478 defendant Saddeler Thomas saddler 586788 586788 Saddeler, Thomas, of Tadcastre, saddler 8
4978365 2350478 2350478 defendant Sowter Christopher shoemaker 586788 586788 Sowter, Christopher, of Tadcastre, shoemaker 9
4978366 2350478 2350478 defendant Oxton William weaver 586788 586788 Oxton, William, of Tadcastre, weaver 10
4978367 2350478 2350478 defendant Skelton William, junior laborer 586788 586788 Skelton, William, junior, of Tadcastre, laborer 11
4978369 2350478 2350478 defendant Webster WIlliam weaver 586788 586788 Webster, WIlliam, of Tadcastre, weaver 13
4978370 2350478 2350478 defendant Soureby John weaver 586788 586788 Soureby, John, of Tadcastre, weaver 14
4978371 2350478 2350478 defendant Selby John walker 586788 586788 Selby, John, of Tadcastre, walker 15
4978372 2350478 2350478 defendant Walker John walker 586788 586788 Walker, John, of Tadcastre, walker 16
4978373 2350478 2350478 defendant Cartwryght John   586788 586788 Cartwryght, John, of Tadcastre, cartwright 17
5026911 2364739 2364739 defendant Bradley John miller 586788 586788 Bradley, John, of Tadcastre, miller 0
5054687 2372979 2372979 defendant Brun William gent 586788 586788 Brun, William, of Tadcastre, gent 0
5069946 2377503 2377503 defendant Blakburn John butcher 586788 586788 Blakburn, John, of Tadcastre, butcher 2
5081707 2381031 2381031 defendant Lounde Thomas laborer 586788 586788 Lounde, Thomas, of Tadcastre, laborer 9
5120245 2392358 2392358 defendant Stopper Alan husbandman 586788 586788 Stopper, Alan, of Tadcastre, husbandman 3
5265850 2435072 2435072 defendant Coke John yeoman 586788 586788 Coke, John, of Tadcastre, yeoman 0
5359981 2463159 2463159 defendant Denys Richard weaver 586788 586788 Denys, Richard, of Tadcastre, weaver 0
5390822 2472440 2472440 defendant Jakson Thomas yeoman 586788 586788 Jakson, Thomas, of Tadcastre, yeoman 4
5492912 2502789 2502789 defendant Couk or Conk John yeoman 586788 586788 Couk or Conk, John, of Tadcastre, yeoman 0
5503018 2505853 2505853 defendant Robson Robert husbandman 586788 586788 Robson, Robert, of Tadcastre, husbandman 4
5513060 2508938 2508938 defendant Jakson John merchant 586788 586788 Jakson, John, of Tadcastre, merchant 1
5521464 2511531 2511531 plaintiff Clevyland William clerk 586788 586788 Clevyland, William, of Tadcastre, clerk 0
5569827 2525749 2525749 defendant Reame Robert yeoman 586788 586788 Reame, Robert, of Tadcastre, yeoman 0
5592059 2532508 2532508 defendant Dawson William butcher 586788 586788 Dawson, William, of Tadcastre, butcher 2
5613220 2547918 2547918 defendant Kirkeby John de   586788 586788 Kirkeby, John de, of Tadcastre 3

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