names

20 rows where place_id = 607289

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3668514 1916109 1916109 defendant Hunt Henry husbandman 607289 607289 Hunt, Henry, of Parva Brykhyll, husbandman 0
3697154 1925331 1925331 defendant Wrynkelowe Robert tailor 607289 607289 Wrynkelowe, Robert, of Parva Brykhyll, tailor 1
3701703 1926775 1926775 defendant Tykkyll Ralph clerk 607289 607289 Tykkyll, Ralph, of Parva Brykhyll, clerk 0
3701707 1926775 1926775 defendant Wynkeley Robert tailor 607289 607289 Wynkeley, Robert, of Parva Brykhyll, tailor 4
3701708 1926775 1926775 defendant Snappe William yeoman 607289 607289 Snappe, William, of Parva Brykhyll, yeoman 5
3737130 1937848 1937848 defendant Farleton Ralph tailor 607289 607289 Farleton, Ralph, of Parva Brykhyll, tailor 3
3768700 1947857 1947857 defendant Merydale Humphrey yeoman 607289 607289 Merydale, Humphrey, of Parva Brykhyll, yeoman 2
3776125 1950276 1950276 defendant Dutton David yeoman 607289 607289 Dutton, David, of Parva Brykhyll, yeoman 0
3844921 1971954 1971954 defendant Baddysley William yeoman 607289 607289 Baddysley, William, of Parva Brykhyll, yeoman 1
3853759 1974808 1974808 defendant Pagnam alias London Henry glover 607289 607289 Pagnam alias London, Henry, of Parva Brykhyll, glover 0
3855539 1975374 1975374 defendant Warner Richard laborer 607289 607289 Warner, Richard, of Parva Brykhyll, laborer 2
3855644 1975404 1975404 defendant Byrche David barber 607289 607289 Byrche, David, of Parva Brykhyll, barber 0
3855645 1975404 1975404 defendant Pagnam Henry glover 607289 607289 Pagnam, Henry, of Parva Brykhyll, glover 1
3856416 1975630 1975630 defendant Dutton William yeoman 607289 607289 Dutton, William, of Parva Brykhyll, yeoman 0
3856418 1975631 1975631 defendant Wryght William innholder 607289 607289 Wryght, William, of Parva Brykhyll, innholder 0
3859910 1976819 1976819 defendant Broke Richard   607289 607289 Broke, Richard, of Parva Brykhyll, horse courser 0
3877784 1982809 1982809 defendant Hull John butcher 607289 607289 Hull, John, of Parva Brykhyll, butcher 0
5220133 2421595 2421595 defendant Wolsale alias Webbe Richard husbandman 607289 607289 Wolsale alias Webbe, Richard, of Parva Brykhyll, husbandman 2
5482379 2499673 2499673 defendant A Gurne John yeoman 607289 607289 A Gurne, John, of Parva Brykhyll, yeoman 1
5558190 2522345 2522345 defendant Comyn Gilbert yeoman 607289 607289 Comyn, Gilbert, of Parva Brykhyll, yeoman 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);