names

23 rows where place_id = 612464

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3693432 1924161 1924161 defendant Jurden William yeoman 612464 612464 Jurden, William, of Elnestowe, yeoman 0
3707621 1928681 1928681 defendant Jorden William yeoman 612464 612464 Jorden, William, of Elnestowe, yeoman 0
4065414 2047920 2047920 defendant Gray Dorothy widow 612464 612464 Dorothy his wife, alias Dorothy Hudson, of Elnestowe, widow 1
4138339 2074075 2074075 defendant Grey Lionel   612464 612464 Grey, Lionel, of Elnestowe, yeoman, servant to Lady Radclyffe of Elnestowe 2
4160763 2081843 2081843 defendant Gostwyck William gent 612464 612464 Gostwyck, William, of Elnestowe, gent 1
4173177 2086075 2086075 defendant Gagell or Eagell George carpenter 612464 612464 Gagell or Eagell, George, of Elnestowe, carpenter 1
4173178 2086075 2086075 defendant Mylward William laborer 612464 612464 Mylward, William, of Elnestowe, laborer 2
4215699 2100989 2100989 defendant Sutton Thomas laborer 612464 612464 Sutton, Thomas, of Elnestowe, laborer 0
4215701 2100990 2100990 defendant Sutton Thomas laborer 612464 612464 Sutton, Thomas, of Elnestowe, laborer 0
4215702 2100990 2100990 defendant Holloway Hugh shoemaker 612464 612464 Holloway, Hugh, of Elnestowe, shoemaker 1
4218972 2102131 2102131 defendant Ballard Anthony yeoman 612464 612464 Ballard, Anthony, of Elnestowe, yeoman 0
4218973 2102131 2102131 defendant Cranfeild Thomas yeoman 612464 612464 Cranfeild, Thomas, of Elnestowe, yeoman 1
4218974 2102131 2102131 defendant Dennocke William yeoman 612464 612464 Dennocke, William, of Elnestowe, yeoman 2
4218976 2102132 2102132 defendant Ballard Anthony yeoman 612464 612464 Ballard, Anthony, of Elnestowe, yeoman 0
4218977 2102132 2102132 defendant Cranfeld Thomas yeoman 612464 612464 Cranfeld, Thomas, of Elnestowe, yeoman 1
4218978 2102132 2102132 defendant Dennocke William yeoman 612464 612464 Dennocke, William, of Elnestowe, yeoman 2
4780030 2289757 2289757 plaintiff Broun Thomas   612464 612464 Broun, Thomas, of Elnestowe 0
4781416 2290195 2290195 defendant Boteler John yeoman 612464 612464 Boteler, John, of Elnestowe, yeoman 0
5037977 2367990 2367990 defendant Goldyngton Maud widow 612464 612464 Goldyngton, Maud, of Elnestowe, widow 0
5114168 2390544 2390544 defendant Verney John   612464 612464 Verney, John, of Elnestowe, mason 0
5336576 2456003 2456003 defendant Roder Thomas husbandman 612464 612464 Roder, Thomas, of Elnestowe, husbandman 0
5600565 2535067 2535067 defendant Markyate Henry husbandman 612464 612464 Markyate, Henry, of Elnestowe, husbandman 0
5604539 2536281 2536281 defendant Snowe William tailor 612464 612464 Snowe, William, of Elnestowe, tailor 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);