names

22 rows where place_id = 753410

✎ 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
4413294 2169032 2169032 defendant Groyne Ralph le   753410 753410 Groyne, Ralph le, of Rouclyf 2
4438129 2181225 2181225 defendant Balne Thomas   753410 753410 Balne, Thomas, of Rouclyf 0
4438130 2181225 2181225 defendant Balne William de   753410 753410 Balne, William de, of Rouclyf 1
4509798 2203550 2203550 plaintiff Bache Thomas   753410 753410 Bache, Thomas, of Rouclyf 0
4518224 2206074 2206074 defendant Redenesse William   753410 753410 Redenesse, William, of Rouclyf 0
4539041 2212480 2212480 defendant Wylde John   753410 753410 Wylde, John, of Rouclyf 0
4686019 2261215 2261215 defendant Wilde Thomas husbandman 753410 753410 Wilde, Thomas, of Rouclyf, husbandman 2
4720899 2271869 2271869 defendant Thorn John husbandman 753410 753410 Thorn, John, of Rouclyf, husbandman 4
4737557 2276858 2276858 defendant Thirne John   753410 753410 Thirne, John, of Rouclyf, wright 0
4767659 2285866 2285866 defendant Brok John yeoman 753410 753410 Brok, John, of Rouclyf, yeoman 13
4774674 2288068 2288068 defendant Rouclyf John, sen husbandman 753410 753410 Rouclyf, John, sen, of Rouclyf, husbandman 0
4774826 2288118 2288118 defendant Thurstan John   753410 753410 Thurstan, John, of Rouclyf, wright 0
4792039 2293612 2293612 defendant Brok John yeoman 753410 753410 Brok, John, of Rouclyf, yeoman 13
4816223 2301159 2301159 defendant Bradley Robert husbandman 753410 753410 Bradley, Robert, of Rouclyf, husbandman 1
4816224 2301159 2301159 defendant Skynner William husbandman 753410 753410 Skynner, William, of Rouclyf, husbandman 2
4816225 2301159 2301159 defendant Baron Robert husbandman 753410 753410 Baron, Robert, of Rouclyf, husbandman 3
4816226 2301159 2301159 defendant Cole Adam husbandman 753410 753410 Cole, Adam, of Rouclyf, husbandman 4
4836172 2307295 2307295 defendant Randolf Nicholas husbandman 753410 753410 Randolf, Nicholas, of Rouclyf, husbandman 1
4854356 2312764 2312764 defendant Wright John, sen husbandman 753410 753410 Wright, John, sen, of Rouclyf, husbandman 0
4997273 2356038 2356038 defendant Ameston Richard husbandman 753410 753410 Ameston, Richard, of Rouclyf, husbandman 3
5612889 2547794 2547794 defendant Marrays John   753410 753410 Marrays, John, of Rouclyf 0
5613255 2547928 2547928 plaintiff Coup John   753410 753410 Coup, John, of Rouclyf 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);