names

17 rows where place_id = 763549

✎ 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
4498266 2200115 2200115 plaintiff Florkyn John draper 763549 763549 Florkyn, John, of Andevere, Hants, draper 0
4674124 2257514 2257514 defendant Eyre George mercer 763549 763549 Eyre, George, of Andevere, Hants, mercer 0
4688789 2262050 2262050 defendant Eyr George merchant 763549 763549 Eyr, George, of Andevere, Hants, merchant 0
4785416 2291459 2291459 defendant Bayly John mercer 763549 763549 Bayly, John, of Andevere, Hants, mercer 0
4793059 2293922 2293922 defendant Baille John mercer 763549 763549 Baille, John, of Andevere, Hants, mercer 1
4793062 2293923 2293923 defendant Baille John mercer 763549 763549 Baille, John, of Andevere, Hants, mercer 1
4793801 2294180 2294180 defendant Fygge John ostler 763549 763549 Fygge, John, of Andevere, Hants, ostler 0
4871010 2317907 2317907 defendant Payn Thomas gent 763549 763549 Payn, Thomas, of Andevere, Hants, gent 2
4874558 2318988 2318988 defendant Fyge John ostler 763549 763549 Fyge, John, of Andevere, Hants, ostler 0
4874856 2319076 2319076 defendant Abfold or Absold John ostler 763549 763549 Abfold or Absold, John, of Andevere, Hants, ostler 0
4874858 2319077 2319077 defendant Alfold John ostler 763549 763549 Alfold, John, of Andevere, Hants, ostler 0
4874860 2319078 2319078 defendant Alfold John ostler 763549 763549 Alfold, John, of Andevere, Hants, ostler 0
4882508 2321438 2321438 defendant Spore Walter chapman 763549 763549 Spore, Walter, of Andevere, Hants, chapman 0
4888967 2323337 2323337 defendant Spore Walter chapman 763549 763549 Spore, Walter, of Andevere, Hants, chapman 0
4941739 2339435 2339435 defendant Sondes Thomas esq 763549 763549 Sondes, Thomas, of Andevere, Hants, esq 0
5098737 2386059 2386059 defendant Wymond Richard husbandman 763549 763549 Wymond, Richard, of Andevere, Hants, husbandman 3
5453564 2490959 2490959 defendant Sandes William   763549 763549 Sandes, William, of Andevere, Hants, knight 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);