names

20 rows where case_id = 2005489

✎ 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
3945435 2005489 2005489 plaintiff Bowyer Andrew gent   Bowyer, Andrew, gent 0
3945436 2005489 2005489 defendant Langtree Thomas gent 653577 653577 Langtree, Thomas, of Langtree, Lancs, gent 0
3945437 2005489 2005489 defendant Squyer John gent 589346 589346 Squyer, John, of Northfeld, Worcs, gent 1
3945438 2005489 2005489 defendant Edgeworthe Edward   586152 586152 Edgeworthe, Edward, of Warwick 2
3945439 2005489 2005489 defendant Audeley Philip gent 657711 657711 Audeley, Philip, of Pagrave, Norf, gent 3
3945440 2005489 2005489 defendant Ashton Edmund gent 657712 657712 Ashton, Edmund, of Elfham, Lancs, gent 4
3945441 2005489 2005489 defendant Tanfeld Clement gent 654304 654304 Tanfeld, Clement, of Gayton, Nhants, gent 5
3945442 2005489 2005489 defendant Kyndelmershe Robert gent 657277 657277 Kyndelmershe, Robert, of Dunmowe Magna, Essex, gent 6
3945443 2005489 2005489 defendant Chapman Thomas gent 588081 588081 Chapman, Thomas, of Cambridge, gent 7
3945444 2005489 2005489 defendant Felton Edmund gent 606862 606862 Felton, Edmund, of Pentlowe, Essex, gent: Leveriche, Henry, of Stanwicke, Nhants, gent 8
3945445 2005489 2005489 defendant Francke alias Franckelyn Baldwin gent 587845 587845 Francke alias Franckelyn, Baldwin, of Uston, Devon, gent 9
3945446 2005489 2005489 defendant Beduls Thomas of Bedford gent   Beduls, Thomas of Bedford, gent 10
3945447 2005489 2005489 defendant Symnell Richard gent 586470 586470 Symnell, Richard, of Colchester, gent 11
3945448 2005489 2005489 defendant Dalyson Edward   683396 683396 Dalyson, Edward, of Cranesley, Nhants, genty 12
3945449 2005489 2005489 defendant Souche John gent 657715 657715 Souche, John, of Anstre, Wilts, gent 13
3945450 2005489 2005489 defendant Rydgeley William gent 657716 657716 Rydgeley, William, of Sheston, Staffs, gent 14
3945451 2005489 2005489 defendant Lewes Thomas gent 651532 651532 Lewes, Thomas, of Maghen, Monmouth, gent 15
3945452 2005489 2005489 defendant Yelf John   586318 586318 Yelf, John, of Worcester 16
3945453 2005489 2005489 defendant Eccleshall Roger gent 657717 657717 Eccleshall, Roger, of Tonge, Salop, gent 17
3945454 2005489 2005489 defendant Lane John gent 585869 585869 Lane, John, of London, gent 18

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