names

21 rows where case_id = 2091437

✎ 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
4188408 2091437 2091437 plaintiff Wallenger James principal of Thavis Inn   Wallenger, James, principal of Thavis Inn 0
4188409 2091437 2091437 defendant Francklyn Eldred gent 603960 603960 Francklyn, Eldred, of Kings Lynne, gent 0
4188410 2091437 2091437 defendant Bate Anthony gent 711346 711346 Bate, Anthony, of Burlingham, norf, gent 1
4188411 2091437 2091437 defendant Francklyn William gent 603960 603960 Francklyn, William, of Kings Lynne, gent 2
4188412 2091437 2091437 defendant Awbery James gent 711347 711347 Awbery, James, of Smalborowe, Norf, gent 3
4188413 2091437 2091437 defendant Denny Firmus gent 590396 590396 Denny, Firmus, of Wymondham, Norf, gent 4
4188414 2091437 2091437 defendant Bedingfeld john gent 594474 594474 Bedingfeld, john, of Horsforde, Norf, gent 5
4188415 2091437 2091437 defendant Arnold Richard   596323 596323 Arnold, Richard, of Cromer, Norf gent 6
4188416 2091437 2091437 defendant Whitinge Walter gent 711349 711349 Whitinge, Walter, of Metton, Norf, gent 7
4188417 2091437 2091437 defendant Brigg George gent 711350 711350 Brigg, George, of Wood norton, norf, gent 8
4188418 2091437 2091437 defendant Palmer Robert gent 585869 585869 Palmer, Robert, of London, gent 9
4188419 2091437 2091437 defendant Hayward Nicholas gent 585869 585869 Hayward, Nicholas, of London, gent 10
4188420 2091437 2091437 defendant Dale Robert gent 585869 585869 Dale, Robert, of London, gent 11
4188421 2091437 2091437 defendant Royden Mathew gent 585869 585869 Royden, Mathew, of London, gent 12
4188422 2091437 2091437 defendant Greneham Francis gent 585869 585869 Greneham, Francis, of London, gent 13
4188423 2091437 2091437 defendant Floure Thomas gent 585869 585869 Floure, Thomas, of London, gent 14
4188424 2091437 2091437 defendant Clarckson William gent 585869 585869 Clarckson, William, of London, gent 15
4188425 2091437 2091437 defendant Lyngen William gent 585869 585869 Lyngen, William, of London, gent 16
4188426 2091437 2091437 defendant Sherington Edward gent 585869 585869 Sherington, Edward, of London, gent 17
4188427 2091437 2091437 defendant Conyars Tristram gent 585869 585869 Conyars, Tristram, of London, gent 18
4188428 2091437 2091437 defendant White Humphrey gent 585869 585869 White, Humphrey, of London, gent 19

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