names

24 rows where place_id = 764448

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4506182 2202443 2202443 defendant Frouland John   764448 764448 Frouland, John, of Frome in Selwood 0
4549431 2215767 2215767 defendant Honycote John   764448 764448 Honycote, John, of Frome in Selwood 5
4558959 2218765 2218765 defendant Maunsell Edward   764448 764448 Maunsell, Edward, of Frome in Selwood 2
4580051 2225248 2225248 defendant Beche John   764448 764448 Beche, John, of Frome in Selwood 0
4590509 2228394 2228394 defendant Skynner Thomas   764448 764448 Skynner, Thomas, of Frome in Selwood 2
4591827 2228798 2228798 defendant Alym John de   764448 764448 Alym, John de, of Frome in Selwood 0
4748907 2280172 2280172 defendant Anglesey alias Tanner John husbandman 764448 764448 Anglesey alias Tanner, John, of Frome in Selwood, husbandman 2
4761511 2283943 2283943 defendant Puttok John dyer 764448 764448 Puttok, John, of Frome in Selwood, dyer 3
4767539 2285823 2285823 defendant Sandres Thomas husbandman 764448 764448 together with Sandres, Thomas, of Frome in Selwood, husbandman 1
4772317 2287306 2287306 defendant Broun John dyer 764448 764448 Broun, John, of Frome in Selwood, dyer 0
5010459 2359932 2359932 defendant Forster Thomas dyer 764448 764448 Forster, Thomas, of Frome in Selwood, dyer 3
5211353 2419049 2419049 defendant Osteler Thomas dyer 764448 764448 Osteler, Thomas, of Frome in Selwood, dyer 1
5298989 2444686 2444686 defendant Touker Walter yeoman 764448 764448 Touker, Walter, of Frome in Selwood, yeoman 0
5298990 2444686 2444686 defendant Crase Thomas gent 764448 764448 together with Crase, Thomas, of Frome in Selwood, gent 1
5298991 2444686 2444686 defendant Leversegge William gent 764448 764448 Leversegge, William, of Frome in Selwood, gent 2
5298993 2444687 2444687 defendant Touker Walter yeoman 764448 764448 Touker, Walter, of Frome in Selwood, yeoman 0
5298994 2444687 2444687 defendant Crase Thomas gent 764448 764448 together with Crase, Thomas, of Frome in Selwood, gent 1
5298995 2444687 2444687 defendant Leversegge William gent 764448 764448 Leversegge, William, of Frome in Selwood, gent 2
5300254 2445040 2445040 defendant Bythewode Nicholas fuller 764448 764448 Bythewode, Nicholas, of Frome in Selwood, fuller 1
5300263 2445040 2445040 defendant Loder Geoffrey husbandman 764448 764448 Loder, Geoffrey, of Frome in Selwood, husbandman 10
5300786 2445195 2445195 defendant Touker Walter yeoman 764448 764448 Touker, Walter, of Frome in Selwood, yeoman 0
5300802 2445197 2445197 defendant Touker Walter yeoman 764448 764448 Touker, Walter, of Frome in Selwood, yeoman 0
5300803 2445197 2445197 defendant Leversegge William gent 764448 764448 Leversegge, William, of Frome in Selwood, gent 1
5436733 2485914 2485914 defendant Smale John fuller 764448 764448 Smale, John, of Frome in Selwood, fuller 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);