names

14 rows where place_id = 670369

✎ 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
3996789 2023616 2023616 plaintiff Diwyn Jerome gent 670369 670369 Diwyn, Jerome, of Wyncalton, gent 0
4052164 2043192 2043192 defendant Farley William mercer 670369 670369 Farley, William, of Wyncalton, mercer 0
4209648 2098925 2098925 defendant Vyninge Richard butcher 670369 670369 Vyninge, Richard, of Wyncalton, butcher 0
4468426 2190787 2190787 defendant Muleward Walter   670369 670369 Muleward, Walter, of Wyncalton 0
4674486 2257631 2257631 defendant Strecche William laborer 670369 670369 Strecche, William, of Wyncalton, laborer 0
4817998 2301711 2301711 defendant Burell John smith 670369 670369 Burell, John, of Wyncalton, smith 1
4948958 2341657 2341657 defendant Clement John butcher 670369 670369 Clement, John, of Wyncalton, butcher 0
5131712 2395759 2395759 defendant Elyot Simon osteler 670369 670369 Elyot, Simon, of Wyncalton, osteler 0
5131713 2395759 2395759 defendant Foxe Ellis husbandman 670369 670369 Foxe, Ellis, of Wyncalton, husbandman 1
5151239 2401508 2401508 defendant Elyot Simon ostler 670369 670369 Elyot, Simon, of Wyncalton, ostler 0
5151240 2401508 2401508 defendant Fox Ellis husbandman 670369 670369 together with Fox, Ellis, of Wyncalton, husbandman 1
5151242 2401509 2401509 defendant Foxe Ellis husbandman 670369 670369 Foxe, Ellis, of Wyncalton, husbandman 0
5151243 2401509 2401509 defendant Elyot Simon ostler 670369 670369 together with Elyot, Simon, of Wyncalton, ostler 1
5593392 2532914 2532914 defendant Vynyng Edward mercer 670369 670369 Vynyng, Edward, of Wyncalton, mercer 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);