names

32 rows where place_id = 589636

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598244 1867081 1867081 defendant Janyn Thomas butcher 589636 589636 Janyn, Thomas, of Soham, Cams, butcher 2
3679066 1919521 1919521 defendant Harvy William yeoman 589636 589636 Harvy, William, of Soham, Cams, yeoman 2
3679070 1919522 1919522 defendant Harvy William yeoman 589636 589636 Harvy, William, of Soham, Cams, yeoman 1
3812217 1961725 1961725 defendant Coren Oliver   589636 589636 Coren, Oliver, of Soham, Cams, professor of theology 0
3858125 1976197 1976197 plaintiff Bestney Thomas   589636 589636 Bestney, Thomas, of Soham, Cams 0
3858128 1976198 1976198 plaintiff Bestney Thomas   589636 589636 Bestney, Thomas, of Soham, Cams 0
3858131 1976199 1976199 plaintiff Bestney Thomas   589636 589636 Bestney, Thomas, of Soham, Cams 0
3858134 1976200 1976200 plaintiff Bestney Thomas   589636 589636 Bestney, Thomas, of Soham, Cams 0
3946069 2005700 2005700 defendant Barnes Edward yeoman 589636 589636 Barnes, Edward, of Soham, Cams, yeoman 0
3962604 2011512 2011512 defendant Pyckys Robert butcher 589636 589636 Pyckys, Robert, of Soham, Cams, butcher 0
3986634 2019959 2019959 defendant Bernys Edmund yeoman 589636 589636 Bernys, Edmund, of Soham, Cams,yeoman 1
3989351 2020933 2020933 defendant Potter Thomas yeoman 589636 589636 Potter, Thomas, of Soham, Cams, or of Thurlowe Magna, Suff, yeoman 0
3991386 2021673 2021673 defendant Barnes Edward gent 589636 589636 Barnes, Edward, of Soham, Cams, gent 2
3993701 2022492 2022492 defendant Barnes Edward gent 589636 589636 Barnes, Edward, of Soham, Cams, gent 0
3993703 2022493 2022493 defendant Barnes Edward gent 589636 589636 Barnes, Edward, of Soham, Cams, gent 0
4013342 2029505 2029505 defendant Potter Thomas yeoman 589636 589636 Potter, Thomas, of Soham, Cams, or of Thurlowe Magna, Suff, yeoman 0
4015519 2030247 2030247 defendant Potter Thomas yeoman 589636 589636 Potter, Thomas, of Soham, Cams, yeoman 0
4060072 2046000 2046000 defendant Potter Thomas yeoman 589636 589636 Potter, Thomas, of Soham, Cams, yeoman 0
4072915 2050610 2050610 defendant Becon John yeoman 589636 589636 Becon, John, of Soham, Cams, yeoman 1
4075939 2051695 2051695 defendant Bennytt John butcher 589636 589636 Bennytt, John, of Soham, Cams, butcher 3
4188382 2091435 2091435 defendant Pechye Robert gent 589636 589636 Pechye, Robert, of Soham, Cams, gent Covell, Francis, of Pynchbecke, Cams, gent 13
4250065 2113004 2113004 defendant Wylkyns Robert gent 589636 589636 Wylkyns, Robert, of Soham, Cams, gent 0
4264399 2117735 2117735 defendant Wilkyns Robert gent 589636 589636 Wilkyns, Robert, of Soham, Cams, gent 0
4894269 2324894 2324894 defendant Salysbury john chapman 589636 589636 Salysbury, john, of Soham, Cams, chapman 0
5267106 2435470 2435470 defendant Besteney Thomas yeoman 589636 589636 Besteney, Thomas, of Soham, Cams, yeoman 0
5283150 2440135 2440135 defendant Bestney Thomas yeoman 589636 589636 Bestney, Thomas, of Soham, Cams, yeoman 0
5283172 2440145 2440145 defendant Bestney Thomas yeoman 589636 589636 Bestney, Thomas, of Soham, Cams, yeoman 0
5343488 2458154 2458154 defendant Besteney Thomas yeoman 589636 589636 Besteney, Thomas, of Soham, Cams, yeoman 0
5360474 2463305 2463305 defendant Pate John husbandman 589636 589636 Pate, John, of Soham, Cams, husbandman 3
5360480 2463306 2463306 defendant Pate John husbandman 589636 589636 Pate, John, of Soham, Cams, husbandman 4
5518622 2510655 2510655 defendant Synys or Syvys John chaplain 589636 589636 Synys or Syvys, John, of Soham, Cams, chaplain 0
5572667 2526548 2526548 defendant Broun Thomas smith 589636 589636 Broun, Thomas, of Soham, Cams, smith 4

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