names

30 rows where case_id = 1910284

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3649720 1910284 1910284 plaintiff Ratclyff Robert     Ratclyff, Robert 0
3649721 1910284 1910284 defendant Myatte James yeoman 600935 600935 Myatte, James, of Wursburgdale, Yorks, yeoman 0
3649722 1910284 1910284 defendant Grene Thomas yeoman 600936 600936 Grene, Thomas, of Kysburgh, Yorks, yeoman 1
3649723 1910284 1910284 defendant Rysheton John gent 600937 600937 Rysheton, John, of Byrtwythall, Yorks, gent 2
3649724 1910284 1910284 defendant Burdett Richard gent 600938 600938 Burdett, Richard, of Denby Hall, Yorks, gent 3
3649725 1910284 1910284 defendant Wodcok Henry yeoman 600939 600939 Wodcok, Henry, of Denbe, yeoman 4
3649726 1910284 1910284 defendant Swyft Richard yeoman 586016 586016 Swyft, Richard, of Denby, yeoman 5
3649727 1910284 1910284 defendant Sparke Robert yeoman 600940 600940 Sparke, Robert, of Darton, Yorks, yeoman 6
3649728 1910284 1910284 defendant Parkyn John yeoman 600941 600941 Parkyn, John, of Barnsley, yeoman 7
3649729 1910284 1910284 defendant Marsden James yeoman 600942 600942 Marsden, James, of Carlecotes, Yorks, yeoman 8
3649730 1910284 1910284 defendant Lowe Ralph     Lowe, Ralph 9
3649731 1910284 1910284 defendant Hurst Ralph     Hurst, Ralph 10
3649732 1910284 1910284 defendant Berde Thomas     Berde, Thomas 11
3649733 1910284 1910284 defendant Robert Thomas     Robert, Thomas 12
3649734 1910284 1910284 defendant Stanyford Richard     Stanyford, Richard 13
3649735 1910284 1910284 defendant Grene William     Grene, William 14
3649736 1910284 1910284 defendant Denby Robert     Denby, Robert 15
3649737 1910284 1910284 defendant Sonyar Richard     Sonyar, Richard 16
3649738 1910284 1910284 defendant Adde Richard     Adde, Richard 17
3649739 1910284 1910284 defendant Yssotte Richard     Yssotte, Richard 18
3649740 1910284 1910284 defendant Webster Richard     Webster, Richard 19
3649741 1910284 1910284 defendant Shepard Richard     Shepard, Richard 20
3649742 1910284 1910284 defendant Hagh James     Hagh, James 21
3649743 1910284 1910284 defendant Byngley Christopher     Byngley, Christopher 22
3649744 1910284 1910284 defendant Jekynson John     Jekynson, John 23
3649745 1910284 1910284 defendant Preest William     Preest, William 24
3649746 1910284 1910284 defendant Hyll Thomas     Hyll, Thomas 25
3649747 1910284 1910284 defendant Lee Thomas     Lee, Thomas 26
3649748 1910284 1910284 defendant Smavent John     Smavent, John 27
3649749 1910284 1910284 defendant Marshall Richard     Marshall, Richard 28

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