names

16 rows where case_id = 2210644

✎ 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
4533178 2210644 2210644 plaintiff Rendelysham Richard     Rendelysham, Richard 0
4533179 2210644 2210644 plaintiff Rendelysham Christine     Christine, his wife 1
4533180 2210644 2210644 defendant Brette John   587715 587715 Brette, John, of Cokefeld 0
4533181 2210644 2210644 defendant Brette Isabel     Isabel, his wife 1
4533182 2210644 2210644 defendant Brette John son of John   Brette, John, son of John 2
4533183 2210644 2210644 defendant Falkes William   766888 766888 Falkes, William, of Erlonde 3
4533184 2210644 2210644 defendant Redere John   586180 586180 Redere, John, of Bury St Edmunds 4
4533185 2210644 2210644 defendant Redere Alice     Alice, his wife 5
4533186 2210644 2210644 defendant Bonecold John   589013 589013 Bonecold, John, of Bury 6
4533187 2210644 2210644 defendant Bonecold Margaret     Margaret, his wife 7
4533188 2210644 2210644 defendant Draweswerd Margaret servant of Walter Draweswerd   Draweswerd, Margaret, servant of Walter Draweswerd 8
4533189 2210644 2210644 defendant Ormesby Agnes chandler 589013 589013 Ormesby, Agnes, of Bury, chandler 9
4533190 2210644 2210644 defendant Threisshere Thomas   589013 589013 Threisshere, Thomas, of Bury 10
4533191 2210644 2210644 defendant Redere William   589013 589013 Redere, William, of Bury 11
4533192 2210644 2210644 defendant Redere John   589013 589013 Redere, John, of Bury, servant of William 12
4533193 2210644 2210644 defendant Broun William carter 624979 624979 Broun, William, of Bradefeld, carter 13

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