names

19 rows where case_id = 2519085

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5546854 2519085 2519085 plaintiff Vyncent Richard of Holmhale     Vyncent, Richard of Holmhale 0
5546855 2519085 2519085 plaintiff Vyncent Walter   587172 587172 Vyncent, Walter, of Est Derham 1
5546856 2519085 2519085 plaintiff Vyncent Thomas   587172 587172 Vyncent, Thomas, of Est Derham 2
5546857 2519085 2519085 plaintiff Vyncent Robert   585914 585914 Vyncent, Robert, of Nekton 3
5546858 2519085 2519085 plaintiff Vyncent James   587172 587172 Vyncent, James, of Est Derham 4
5546859 2519085 2519085 plaintiff Vyncent Thomas   629904 629904 Vyncent, Thomas, of Holmhale 5
5546860 2519085 2519085 plaintiff Vyncent Robert   587209 587209 Vyncent, Robert, of Marham 6
5546861 2519085 2519085 plaintiff Vyncent William   587209 587209 Vyncent, William, of Marham 7
5546862 2519085 2519085 plaintiff Vyncent John   587209 587209 Vyncent, John, of Marham 8
5546863 2519085 2519085 plaintiff Vyncent Richard, senior   587209 587209 Vyncent, Richard, senior, of Marham 9
5546864 2519085 2519085 plaintiff Vyncent Richard, junior   587209 587209 Vyncent, Richard, junior, of Marham 10
5546865 2519085 2519085 plaintiff Vyncent John   585936 585936 Vyncent, John, of Norwich 11
5546866 2519085 2519085 plaintiff Vyncent Thomas   587209 587209 Vyncent, Thomas, of Marham 12
5546867 2519085 2519085 plaintiff Vyncent John   588697 588697 Vyncent, John, of Shuldham Thorp 13
5546868 2519085 2519085 plaintiff Vyncent Rchard   587209 587209 Vyncent, Rchard, of Marham 14
5546869 2519085 2519085 defendant Jermyn Thomas esq   Jermyn, Thomas, esq 0
5546870 2519085 2519085 defendant Drury Robert knight   Drury, Robert, knight 1
5546871 2519085 2519085 defendant Hobart James attorney   Hobart, James, attorney 2
5546872 2519085 2519085 defendant Aleyn John gent   Aleyn, John, gent 3

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