names

12 rows where place_id = 673237

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment

id ▼ case_id role surname forename occupation place_id raw_segment seq
4009155 2028042 2028042 defendant Warcoppe Henry gent 673237 673237 Warcoppe, Henry, of Aylesforde, gent 0
4045533 2040853 2040853 defendant Newington John yeoman 673237 673237 Newington, John, of Aylesforde, yeoman 0
4057220 2044968 2044968 defendant Lurchyn Stephen yeoman 673237 673237 Lurchyn, Stephen, of Aylesforde, yeoman 0
4063640 2047286 2047286 defendant Lurchen Stephen yeoman 673237 673237 Lurchen, Stephen, of Aylesforde, yeoman 0
4070752 2049834 2049834 defendant Whyskyn William yeoman 673237 673237 Whyskyn, William, of Aylesforde, yeoman 0
4090343 2056831 2056831 defendant Whisken William mariner 673237 673237 Whisken, William, of Aylesforde, mariner 0
4090535 2056897 2056897 defendant Whisken William mariner 673237 673237 Whisken, William, of Aylesforde, mariner 0
4319407 2136893 2136893 defendant Warcoppe Henry gent 673237 673237 Warcoppe, Henry, of Aylesforde, gent 0
4580901 2225508 2225508 defendant Cristyane John   673237 673237 Cristyane, John, of Aylesforde 0
4829233 2305183 2305183 defendant Northwode William laborer 673237 673237 Northwode, William, of Aylesforde, laborer 0
4892860 2324499 2324499 defendant Bocher John butcher 673237 673237 Bocher, John, of Aylesforde, butcher 0
5602982 2535819 2535819 defendant Gate Thomas butcher 673237 673237 Gate, Thomas, of Aylesforde, butcher 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);