names

16 rows where place_id = 601298

✎ 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
3644727 1908757 1908757 defendant Burley Robert yeoman 601298 601298 Burley, Robert, of Tykhyll, Yorks, yeoman 5
3712276 1930153 1930153 defendant Kyng Robert husbandman 601298 601298 Kyng, Robert, of Tykhyll, Yorks, husbandman 0
3892998 1987902 1987902 defendant Stokkys John maltman 601298 601298 Stokkys, John, of Tykhyll, Yorks, maltman 0
3927479 1999536 1999536 plaintiff Assheton Robert merchant 601298 601298 Assheton, Robert, of Tykhyll, Yorks, merchant 0
4665306 2250640 2250640 defendant Tyll Richard husbandman 601298 601298 Tyll, Richard, of Tykhyll, Yorks, husbandman 0
4819755 2302251 2302251 defendant Hervy John dyer 601298 601298 Hervy, John, of Tykhyll, Yorks, dyer 3
4996334 2355761 2355761 defendant Twyer Thomas yeoman 601298 601298 Twyer, Thomas, of Tykhyll, Yorks, yeoman 2
5239965 2427265 2427265 defendant Dukmanton Robert chapman 601298 601298 Dukmanton, Robert, of Tykhyll, Yorks, chapman 0
5241679 2427773 2427773 defendant Wall John clerk 601298 601298 Wall, John, of Tykhyll, Yorks, clerk 0
5241684 2427774 2427774 defendant Wall John clerk 601298 601298 Wall, John, of Tykhyll, Yorks, clerk 0
5248772 2429761 2429761 defendant Robert Thomas yeoman 601298 601298 Robert, Thomas, of Tykhyll, Yorks, yeoman 13
5333152 2454983 2454983 defendant Saunder William mercer 601298 601298 Saunder, William, of Tykhyll, Yorks, mercer 4
5336099 2455876 2455876 defendant Boswell John mercer 601298 601298 Boswell, John, of Tykhyll, Yorks, mercer 0
5342908 2457977 2457977 defendant Lambard John gent 601298 601298 Lambard, John, of Tykhyll, Yorks, gent 1
5363469 2464223 2464223 defendant White Christopher chapman 601298 601298 White, Christopher, of Tykhyll, Yorks, chapman 1
5504057 2506186 2506186 defendant Symmes Richard chaplain 601298 601298 Symmes, Richard, of Tykhyll, Yorks, chaplain 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);