names

22 rows where case_id = 2443638

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5295359 2443638 2443638 plaintiff Turpyn Nicholas     Turpyn, Nicholas 0
5295360 2443638 2443638 defendant Robson Thomas husbandman 800524 800524 Robson, Thomas, of Callerton, husbandman 0
5295361 2443638 2443638 defendant Richardson John yeoman 869762 869762 Richardson, John, of Echewyke, yeoman 1
5295362 2443638 2443638 defendant Richardson Roger yeoman 869762 869762 Richardson, Roger, of Echewyke, yeoman 2
5295363 2443638 2443638 defendant Mastylyon John husbandman 869762 869762 Mastylyon, John, of Echewyke, husbandman 3
5295364 2443638 2443638 defendant Elder John husbandman 869762 869762 Elder, John, of Echewyke, husbandman 4
5295365 2443638 2443638 defendant White Robert husbandman 869762 869762 White, Robert, of Echewyke, husbandman 5
5295366 2443638 2443638 defendant Walker John husbandman 869762 869762 Walker, John, of Echewyke, husbandman 6
5295367 2443638 2443638 defendant Wilkynson John husbandman 596783 596783 Wilkynson, John, of Haddon, husbandman 7
5295368 2443638 2443638 defendant Webster William husbandman 596783 596783 Webster, William, of Haddon, husbandman 8
5295369 2443638 2443638 defendant Middilton John husbandman 596783 596783 Middilton, John, of Haddon, husbandman 9
5295370 2443638 2443638 defendant Sclater Richard husbandman 596783 596783 Sclater, Richard, of Haddon, husbandman 10
5295371 2443638 2443638 defendant Button John husbandman 596783 596783 Button, John, of Haddon, husbandman 11
5295372 2443638 2443638 defendant Sclater William, junior husbandman 596783 596783 Sclater, William, junior, of Haddon, husbandman 12
5295373 2443638 2443638 defendant Webster John husbandman 596783 596783 Webster, John, of Haddon, husbandman 13
5295374 2443638 2443638 defendant Laweson Robert husbandman 775755 775755 Laweson, Robert, of Wylom, husbandman 14
5295375 2443638 2443638 defendant Symson William   775755 775755 Symson, William, of Wylom 15
5295376 2443638 2443638 defendant Grene Robert husbandman 586913 586913 Grene, Robert, of Rouchester, husbandman 16
5295377 2443638 2443638 defendant Richardson John, junior husbandman 586913 586913 Richardson, John, junior, of Rouchester, husbandman 17
5295378 2443638 2443638 defendant Colynwode Thomas husbandman 869763 869763 Colynwode, Thomas, of Nesbytte, husbandman 18
5295379 2443638 2443638 defendant Mastylyon William husbandman 869764 869764 Mastylyon, William, of Babbyngton, husbandman 19
5295380 2443638 2443638 defendant Atkynson Thomas husbandman 611978 611978 Atkynson, Thomas, of Dalton, husbandman 20

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);