names

25 rows where place_id = 591388

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604263 1868996 1868996 defendant Harryson William yeoman 591388 591388 Harryson, William, of Seyton, Rutland, yeoman 0
3718248 1931991 1931991 defendant Sheffeld John gent 591388 591388 Sheffeld, John, of Seyton, Rutland, gent 0
3784465 1952925 1952925 defendant Ilston William miller 591388 591388 Ilston, William, of Seyton, Rutland, miller 0
3840786 1970684 1970684 defendant Sheffeld alias Sevillde Edmund gent 591388 591388 Sheffeld alias Sevillde, Edmund, of Seyton, Rutland, gent 1
3921236 1997454 1997454 defendant Clypsham Nicholas yeoman 591388 591388 Clypsham, Nicholas, of Seyton, Rutland, yeoman 0
4315051 2135378 2135378 defendant Sheffeild Richard esq 591388 591388 Sheffeild, Richard, of Seyton, Rutland, esq 0
4835724 2307170 2307170 defendant Beaufo John (legal representative) 591388 591388 Beaufo, John, of Seyton, Rutland, esq, administrator of 0
4848754 2311075 2311075 defendant Bewefo William esq 591388 591388 Bewefo, William, of Seyton, Rutland, esq 0
4848773 2311077 2311077 defendant Bewefo William esq 591388 591388 Bewefo, William, of Seyton, Rutland, esq 4
5029363 2365465 2365465 defendant Beaufo William esq 591388 591388 Beaufo, William, of Seyton, Rutland, esq 0
5086200 2382360 2382360 defendant Beaufo Ralph esq 591388 591388 Beaufo, Ralph, of Seyton, Rutland, esq 1
5120869 2392535 2392535 defendant Beaufe William esq 591388 591388 Beaufe, William,of Seyton, Rutland, esq 0
5120871 2392536 2392536 defendant Beaufo William esq 591388 591388 Beaufo, William, of Seyton, Rutland, esq 0
5122567 2393032 2393032 defendant Beaufo Ralph, senior gent 591388 591388 Beaufo, Ralph, senior, of Seyton, Rutland, gent 0
5146193 2400015 2400015 defendant Beaufo Ralph gent 591388 591388 Beaufo, Ralph, of Seyton, Rutland, gent 0
5166402 2405899 2405899 defendant Beaufo Ralph gent 591388 591388 Beaufo, Ralph, of Seyton, Rutland, gent 0
5181211 2410248 2410248 defendant Beaufo Ralph gent 591388 591388 Beaufo, Ralph, of Seyton, Rutland, gent 0
5224539 2422845 2422845 defendant Beaufo Ralph gent 591388 591388 Beaufo, Ralph, of Seyton, Rutland, gent 0
5290892 2442342 2442342 defendant Metley Thomas esq 591388 591388 Metley, Thomas, of Seyton, Rutland, esq 1
5290897 2442343 2442343 defendant Metley Thomas esq 591388 591388 Metley, Thomas, of Seyton, Rutland, esq 1
5331283 2454429 2454429 defendant Kent John husbandman 591388 591388 Kent, John, of Seyton, Rutland, husbandman 0
5353717 2461227 2461227 defendant Okey Edward yeoman 591388 591388 Okey, Edward, of Seyton, Rutland, yeoman 0
5364189 2464454 2464454 defendant Metley Thomas esq 591388 591388 Metley, Thomas, of Seyton, Rutland, esq 0
5484471 2500273 2500273 defendant Beaufowe Elizabeth widow 591388 591388 Beaufowe, Elizabeth, of Seyton, Rutland, widow 1
5484610 2500322 2500322 defendant Beaufowe Elizabeth widow 591388 591388 Beaufowe, Elizabeth, of Seyton, Rutland, widow 1

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