names

25 rows where case_id = 1952239

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3782368 1952239 1952239 plaintiff Howard Edmund knight   Howard, Edmund, knight 0
3782369 1952239 1952239 plaintiff Broun Matthew knight   Broun, Matthew, knight 1
3782370 1952239 1952239 plaintiff Gaynesford John knight   Gaynesford, John, knight 2
3782371 1952239 1952239 plaintiff Walsyngham Edmund knight   Walsyngham, Edmund, knight 3
3782372 1952239 1952239 plaintiff Dawtry John knight   Dawtry, John, knight 4
3782373 1952239 1952239 plaintiff Westbroke William     Westbroke, William 5
3782374 1952239 1952239 plaintiff Byrley John     Byrley, John 6
3782375 1952239 1952239 plaintiff Lysley Thomas     Lysley, Thomas 7
3782376 1952239 1952239 plaintiff Skynner John     Skynner, John 8
3782377 1952239 1952239 defendant Bray Edmund   616598 616598 Bray, Edmund, of Stoke Dabernon, knight 0
3782378 1952239 1952239 defendant Parcenall William     Parcenall, William 1
3782379 1952239 1952239 defendant Mylsam William     Mylsam, William 2
3782380 1952239 1952239 defendant Barbour John     Barbour, John 3
3782381 1952239 1952239 defendant Blundell Henry     Blundell, Henry 4
3782382 1952239 1952239 defendant Man John     Man, John 5
3782383 1952239 1952239 defendant Smyth Philip     Smyth, Philip 6
3782384 1952239 1952239 defendant Gryffyn John     Gryffyn, John 7
3782385 1952239 1952239 defendant Grove Richard     Grove, Richard 8
3782386 1952239 1952239 defendant Hamond Henry     Hamond, Henry 9
3782387 1952239 1952239 defendant Chaynell William     Chaynell, William 10
3782388 1952239 1952239 defendant Neell Thomas     Neell, Thomas 11
3782389 1952239 1952239 defendant Lamston Richard     Lamston, Richard 12
3782390 1952239 1952239 defendant Tayllour Thomas     Tayllour, Thomas 13
3782391 1952239 1952239 defendant Bayly Robert     Bayly, Robert 14
3782392 1952239 1952239 defendant Sewar John     Sewar, John 15

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