names

36 rows where case_id = 2209074

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename

id ▼ case_id role surname forename occupation place_id raw_segment seq
4528109 2209074 2209074 plaintiff Malerbe William deputy sheriff   Malerbe, William, deputy sheriff, executors of 0
4528110 2209074 2209074 plaintiff Malerbe Joan formerly wife of William   (Malerbe, Joan, formerly wife of William 1
4528111 2209074 2209074 plaintiff Hille Robert   603556 603556 Hille, Robert, of Gydesham 2
4528112 2209074 2209074 plaintiff Bone John chaplain   Bone, John, chaplain 3
4528113 2209074 2209074 defendant Mountesdon Richard     Mountesdon, Richard 0
4528114 2209074 2209074 defendant Colyford John     Colyford, John 1
4528115 2209074 2209074 defendant Jon William     Jon, William 2
4528116 2209074 2209074 defendant Hope David     Hope, David 3
4528117 2209074 2209074 defendant Asshelegh Benedict     Asshelegh, Benedict 4
4528118 2209074 2209074 defendant Derby William     Derby, William 5
4528119 2209074 2209074 defendant Maynard John     Maynard, John 6
4528120 2209074 2209074 defendant Denbold Geoffrey     Denbold, Geoffrey 7
4528121 2209074 2209074 defendant Foleslo John     Foleslo, John 8
4528122 2209074 2209074 defendant Alyan John     Alyan, John 9
4528123 2209074 2209074 defendant Lucy John     Lucy, John 10
4528124 2209074 2209074 defendant Cruwys John     Cruwys, John 11
4528125 2209074 2209074 defendant Burnard Richard     Burnard, Richard 12
4528126 2209074 2209074 defendant Denssh John     Denssh, John 13
4528127 2209074 2209074 defendant Halghwill John     Halghwill, John 14
4528128 2209074 2209074 defendant Panyter Nicholas     Panyter, Nicholas 15
4528129 2209074 2209074 defendant Derte William     Derte, William 16
4528130 2209074 2209074 defendant Helier Walter   599723 599723 Helier, Walter, of Plympton 17
4528131 2209074 2209074 defendant Hunte Randolf     Hunte, Randolf 18
4528132 2209074 2209074 defendant Helier Walter     Helier, Walter 19
4528133 2209074 2209074 defendant Cok Richard     Cok, Richard 20
4528134 2209074 2209074 defendant Hunte Thomas     Hunte, Thomas 21
4528135 2209074 2209074 defendant Bydewill William     Bydewill, William 22
4528136 2209074 2209074 defendant Croke Robert     Croke, Robert 23
4528137 2209074 2209074 defendant Hesill John     Hesill, John 24
4528138 2209074 2209074 defendant Cokesden John     Cokesden, John 25
4528139 2209074 2209074 defendant Dare Thomas     Dare, Thomas 26
4528140 2209074 2209074 defendant Strete John     Strete, John 27
4528141 2209074 2209074 defendant Borne Richard     Borne, Richard 28
4528142 2209074 2209074 defendant Tudde Richard     Tudde, Richard 29
4528143 2209074 2209074 defendant Stoke John     Stoke, John 30
4528144 2209074 2209074 defendant Archebold Robert     Archebold, Robert 31

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