names

49 rows where place_id = 604628

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3658686 1912972 1912972 plaintiff FitzJames Richard   604628 604628 FitzJames, Richard, of London, Bishop 0
3658692 1912973 1912973 plaintiff FitzJames Richard   604628 604628 FitzJames, Richard, of London, Bishop 0
3658698 1912974 1912974 plaintiff FitzJames Richard   604628 604628 FitzJames, Richard, of London, Bishop 0
3660022 1913398 1913398 defendant fitz James Richard   604628 604628 fitz James, Richard, of London, bishop 1
3661415 1913843 1913843 plaintiff (illegible) Richard   604628 604628 ( --, Richard, of London, Bishop 1
4470119 2191306 2191306 plaintiff Braybroke Robert   604628 604628 Braybroke, Robert, of London, bishop 0
4512947 2204482 2204482 plaintiff Braybrook Robert   604628 604628 Braybrook, Robert, of London, bishop 0
4512949 2204483 2204483 plaintiff Braybrook Robert   604628 604628 Braybrook, Robert, of London, bishop 0
4512951 2204484 2204484 plaintiff Braybrook Robert   604628 604628 Braybrook, Robert, of London, bishop 0
4546236 2214769 2214769 plaintiff Braybrok Robert   604628 604628 Braybrok, Robert, of London, bishop 0
4601591 2231721 2231721 plaintiff Walden Roger (legal representative) 604628 604628 Walden, Roger, of London, bishop, executors of 0
4601601 2231722 2231722 plaintiff Walden Roger (legal representative) 604628 604628 Walden, Roger, of London, bishop, executors of 0
4611403 2234626 2234626 plaintiff Clifford Richard   604628 604628 Clifford, Richard, of London, bishop 0
4747260 2279704 2279704 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop 0
4747262 2279705 2279705 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop 0
4747264 2279706 2279706 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop, formerly bishop of Chichester 0
4747270 2279707 2279707 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop, formerly bishop of Chichester 0
4747273 2279708 2279708 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop, formerly bishop of Chichester 0
4747279 2279709 2279709 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop, formerly bishop of Chichester 0
4747285 2279710 2279710 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop, formerly bishop of Chichester 0
4747291 2279711 2279711 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop, formerly bishop of Chichester 0
4747294 2279712 2279712 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop, formerly bishop of Chichester 0
4747298 2279713 2279713 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop, formerly bishop of Chichester 0
4747300 2279714 2279714 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop, formerly bishop of Chichester 0
4747303 2279715 2279715 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop, formerly bishop of Chichester 0
4747309 2279716 2279716 plaintiff Kemp John   604628 604628 Kemp, John, of London, bishop, formerly bishop of Chichester 0
4747317 2279718 2279718 plaintiff Kempe John   604628 604628 Kempe, John, of London, bishop 0
4747331 2279723 2279723 plaintiff Kempe John   604628 604628 Kempe, John, of London, bishop, formerly bishop of Rochester 0
4812225 2299939 2299939 plaintiff Grey William   604628 604628 Grey, William, of London, bishop 0
4812228 2299940 2299940 plaintiff Grey William   604628 604628 Grey, William, of London, bishop 0
4824911 2303829 2303829 defendant Grey William   604628 604628 Grey, William, of London, bishop 0
5045291 2370218 2370218 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5133821 2396385 2396385 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 1
5133824 2396386 2396386 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 1
5133828 2396387 2396387 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5133830 2396388 2396388 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5133832 2396389 2396389 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5133834 2396390 2396390 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5133837 2396391 2396391 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5133840 2396392 2396392 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5133844 2396393 2396393 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5133847 2396394 2396394 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5270705 2436535 2436535 plaintiff Kempe Thomas   604628 604628 (Kempe, Thomas, of London, bishop 1
5270711 2436536 2436536 plaintiff Kempe Thomas   604628 604628 (Kempe, Thomas, of London, bishop 1
5272581 2437055 2437055 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5372175 2466888 2466888 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5372177 2466889 2466889 plaintiff Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0
5375409 2467898 2467898 defendant Kempe Thomas   604628 604628 Kempe, Thomas, of London, Bishop 0
5477392 2498254 2498254 defendant Kempe Thomas   604628 604628 Kempe, Thomas, of London, bishop 0

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