names

21 rows where place_id = 647962

✎ 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
3899152 1989922 1989922 defendant Gryme John husbandman 647962 647962 Gryme, John, of Tytley, husbandman 3
3911498 1994164 1994164 defendant Passey John husbandman 647962 647962 Passey, John, of Tytley, husbandman 1
4011081 2028736 2028736 plaintiff Peres Thomas laborer 647962 647962 Peres, Thomas, of Tytley, laborer 0
4051497 2042953 2042953 defendant Deyouse or Deyonse William yeoman 647962 647962 Deyouse or Deyonse, William, of Tytley, yeoman 0
4052089 2043171 2043171 defendant Woodhowse Thomas yeoman 647962 647962 Woodhowse, Thomas, of Tytley, yeoman 0
4065578 2047979 2047979 defendant Deyos William cordwainer 647962 647962 Deyos, William, of Tytley, cordwainer 0
4079287 2052893 2052893 defendant Knyght Walter yeoman 647962 647962 Knyght, Walter, of Tytley, yeoman 1
4110537 2064030 2064030 defendant ap Ryce William laborer 647962 647962 ap Ryce, William, of Tytley, laborer 2
4175899 2087046 2087046 defendant Passye James tanner 647962 647962 Passye, James, of Tytley, tanner 0
4179140 2088177 2088177 defendant Deyos William yeoman 647962 647962 Deyos, William, of Tytley, yeoman 0
4180564 2088686 2088686 defendant Scandrett George yeoman 647962 647962 Scandrett, George, of Tytley, yeoman 0
4180565 2088686 2088686 defendant ap Jevan John laborer 647962 647962 ap Jevan, John, of Tytley, laborer 1
4180566 2088686 2088686 defendant ap Jevan Richard laborer 647962 647962 ap Jevan, Richard, of Tytley, laborer 2
4180567 2088686 2088686 defendant vergh Jevan Anne spinster 647962 647962 vergh Jevan, Anne, of Tytley, spinster 3
4199132 2095252 2095252 defendant Passye James tanner 647962 647962 Passye, James, of Tytley, tanner 0
4242729 2110557 2110557 defendant Godwyn John yeoman 647962 647962 Godwyn, John, of Tytley, yeoman 2
5034236 2366872 2366872 defendant Tytley William gent 647962 647962 Tytley, William, of Tytley, gent 0
5034247 2366873 2366873 defendant Tytley William gent 647962 647962 Tytley, William, of Tytley, gent 0
5274002 2437475 2437475 defendant Tytley William gent 647962 647962 Tytley, William, of Tytley, gent 0
5274006 2437476 2437476 defendant Tytley Humphrey esq 647962 647962 Tytley, Humphrey, of Tytley, esq 1
5290709 2442285 2442285 defendant Tytley Humphrey esq 647962 647962 Tytley, Humphrey, of Tytley, esq 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);