names

20 rows where case_id = 2091436

✎ 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
4188388 2091436 2091436 plaintiff Wallenger James principal of Thavis Inn   Wallenger, James, principal of Thavis Inn 0
4188389 2091436 2091436 defendant Dowce George gent 585869 585869 Dowce, George, of London, gent 0
4188390 2091436 2091436 defendant Eyer Robert gent 586787 586787 Eyer, Robert, of Chesterfeld, Derbs, gent 1
4188391 2091436 2091436 defendant Hunte Thomas gent 585869 585869 Hunte, Thomas, of London, gent 2
4188392 2091436 2091436 defendant Aylemer Joshua gent 585869 585869 Aylemer, Joshua, of London, gent 3
4188393 2091436 2091436 defendant Phillips Gawin gent 587136 587136 Phillips, Gawin, of Derby, gent 4
4188394 2091436 2091436 defendant Brett Reginald gent 585869 585869 Brett, Reginald, of London, gent 5
4188395 2091436 2091436 defendant Snede George gent 639764 639764 Snede, George, of Madeley, Staffs, gent 6
4188396 2091436 2091436 defendant Musgrave Thomas gent 585869 585869 Musgrave, Thomas, of London, gent 7
4188397 2091436 2091436 defendant Cheyney Francis gent 585869 585869 Cheyney, Francis, of London, gent 8
4188398 2091436 2091436 defendant Hutton William gent 585869 585869 Hutton, William, of London, gent 9
4188399 2091436 2091436 defendant Cheke Richard gent 585869 585869 Cheke, Richard, of London, gent 10
4188400 2091436 2091436 defendant Lancaster Thomas gent 585869 585869 Lancaster, Thomas, of London, gent 11
4188401 2091436 2091436 defendant Edgecombe Edward gent 585869 585869 Edgecombe, Edward, of London, gent 12
4188402 2091436 2091436 defendant Vaughan William gent 585869 585869 Vaughan, William, of London, gent 13
4188403 2091436 2091436 defendant Buck George gent 585869 585869 Buck, George, of London, gent 14
4188404 2091436 2091436 defendant Writington Thomas gent 585869 585869 Writington, Thomas, of London, gent 15
4188405 2091436 2091436 defendant Pawle Christopher gent 585869 585869 Pawle, Christopher, of London, gent 16
4188406 2091436 2091436 defendant Cheke Thomas gent 585869 585869 Cheke, Thomas, of London, gent 17
4188407 2091436 2091436 defendant Swanne William gent 585869 585869 Swanne William, 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);