names

18 rows where case_id = 2186944

✎ 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
4456144 2186944 2186944 plaintiff Neuton Richard de (legal representative) 586286 586286 Neuton, Richard de, of Boston, executors of 0
4456145 2186944 2186944 plaintiff Rochefard John     (Rochefard, John 1
4456146 2186944 2186944 plaintiff Rochefard Alice     Alice, his wife 2
4456147 2186944 2186944 defendant Belle William   758715 758715 Belle, William, of Snartfard 0
4456148 2186944 2186944 defendant Ormesby Richard de     Ormesby, Richard de 1
4456149 2186944 2186944 defendant Ardenr Robert   644749 644749 Ardenr, Robert, of Thoresway, parson 2
4456150 2186944 2186944 defendant Bynbrok Rawlin de     Bynbrok, Rawlin de 3
4456151 2186944 2186944 defendant Neuton Thomas de     Neuton, Thomas de 4
4456152 2186944 2186944 defendant Walens Richard   758717 758717 Walens, Richard, of Leek, marshall 5
4456153 2186944 2186944 defendant Conde Alicme   586286 586286 Conde, Alicme, of Boston 6
4456154 2186944 2186944 defendant Lyster Thomas   586286 586286 Lyster, Thomas, of Boston 7
4456155 2186944 2186944 defendant Hed Walter     Hed, Walter 8
4456156 2186944 2186944 defendant Perkyn Alan     Perkyn, Alan 9
4456157 2186944 2186944 defendant Wyssenden William clerk 586846 586846 Wyssenden, William, of Lincoln, clerk 10
4456158 2186944 2186944 defendant Menot Thomas     Menot, Thomas 11
4456159 2186944 2186944 defendant Poke John     Poke, John 12
4456160 2186944 2186944 defendant -usl-y John de     -usl-y, John de 13
4456161 2186944 2186944 defendant Menethorp John     Menethorp, John 14

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