names

21 rows where case_id = 2197254

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4488913 2197254 2197254 plaintiff Tailboys Walter knight   Tailboys, Walter, knight 0
4488914 2197254 2197254 defendant Marton William de     Marton, William de 0
4488915 2197254 2197254 defendant Stokton Hugh de     Stokton, Hugh de 1
4488916 2197254 2197254 defendant Hugh servant of William Marton     Hugh, servant of William Marton 2
4488917 2197254 2197254 defendant Symson John   600493 600493 Symson, John, of Bolton 3
4488918 2197254 2197254 defendant Benet William   602735 602735 Benet, William, of Steton 4
4488919 2197254 2197254 defendant Shepardson John   602735 602735 Shepardson, John, of Steton 5
4488920 2197254 2197254 defendant Colton Edward de     Colton, Edward de 6
4488921 2197254 2197254 defendant Smythson John   588406 588406 Smythson, John, of Colton 7
4488922 2197254 2197254 defendant Note William   600493 600493 Note, William, of Bolton 8
4488923 2197254 2197254 defendant Apulton Brian     Apulton, Brian 9
4488924 2197254 2197254 defendant Peresson John   600493 600493 Peresson, John, of Bolton 10
4488925 2197254 2197254 defendant Thomson John   600493 600493 Thomson, John, of Bolton 11
4488926 2197254 2197254 defendant Russell William   600493 600493 Russell, William, of Bolton 12
4488927 2197254 2197254 defendant Bouland John   614195 614195 Bouland, John, of Hornyngton 13
4488928 2197254 2197254 defendant Jakeson William   602735 602735 Jakeson, William, of Steton 14
4488929 2197254 2197254 defendant Kepaus John     Kepaus, John 15
4488930 2197254 2197254 defendant Crosseby Robert     Crosseby, Robert 16
4488931 2197254 2197254 defendant Sygrave Nicholas     Sygrave, Nicholas 17
4488932 2197254 2197254 defendant Plasterer Walter     Plasterer, Walter 18
4488933 2197254 2197254 defendant Sysson John     Sysson, John 19

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