names

12 rows where case_id = 2186522

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4454823 2186522 2186522 plaintiff Marneux Thomas knight   Marneux, Thomas, knight 0
4454824 2186522 2186522 plaintiff Waldegrave Richard knight   Waldegrave, Richard, knight 1
4454825 2186522 2186522 plaintiff Swynbourn Robert knight   Swynbourn, Robert, knight 2
4454826 2186522 2186522 plaintiff Cavendyssh Andrew de knight   Cavendyssh, Andrew de, knight 3
4454827 2186522 2186522 plaintiff Bury Adam de   585869 585869 Bury, Adam de, of London 4
4454828 2186522 2186522 plaintiff Eynesham William de   585869 585869 Eynesham, William de, of London 5
4454829 2186522 2186522 plaintiff Kedyngton Robert de     Kedyngton, Robert de 6
4454830 2186522 2186522 plaintiff Peeke John   594907 594907 Peeke, John, of Cavendyssh 7
4454831 2186522 2186522 plaintiff Gerveys William     Gerveys, William 8
4454832 2186522 2186522 defendant Kersaver Walter     Kersaver, Walter 0
4454833 2186522 2186522 defendant Kersaver Matilda     Matilda, his wife 1
4454834 2186522 2186522 defendant Passefeld Joan de formerly wife of Adam   Passefeld, Joan de, formerly wife of Adam 2

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