names

8 rows where place_id = 817332

✎ 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
4885727 2322410 2322410 defendant Ingilby Robert gent 817332 817332 Ingilby, Robert, of Clyfton juxta York, gent 1
4953252 2342933 2342933 defendant Lede Thomas husbandman 817332 817332 Lede, Thomas, of Clyfton juxta York, husbandman 2
5022566 2363504 2363504 defendant Spynner John   817332 817332 Spynner, John, of Clyfton juxta York, souyour or soldier 1
5022575 2363507 2363507 defendant Tesdale Henry   817332 817332 Tesdale, Henry, of Clyfton juxta York, court holder 0
5076159 2379369 2379369 defendant Pole John yeoman 817332 817332 Pole, John, of Clyfton juxta York, yeoman 12
5087634 2382768 2382768 defendant Matrasse John miller 817332 817332 Matrasse, John, of Clyfton juxta York, miller 0
5097437 2385682 2385682 defendant del Steede Thomas husbandman 817332 817332 del Steede, Thomas, of Clyfton juxta York, husbandman 1
5097443 2385683 2385683 defendant del Steede Thomas husbandman 817332 817332 del Steede, Thomas, of Clyfton juxta York, husbandman 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);