names

15 rows where case_id = 2175508

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4434375 2175508 2175508 plaintiff Knelle Edmund de knight   Knelle, Edmund de, knight 0
4434376 2175508 2175508 defendant White William   605095 605095 White, William, of Bercompe 0
4434377 2175508 2175508 defendant Depeden Richard     Depeden, Richard 1
4434378 2175508 2175508 defendant Pope Stephen     Pope, Stephen 2
4434379 2175508 2175508 defendant (illegible) Richard     _, Richard 3
4434380 2175508 2175508 defendant Brusyngden John, junior     Brusyngden, John, junior 4
4434381 2175508 2175508 defendant More William     More, William 5
4434382 2175508 2175508 defendant Boxherst John     Boxherst, John 6
4434383 2175508 2175508 defendant Fithele John de     Fithele, John de 7
4434384 2175508 2175508 defendant Kechenore John jun   Kechenore, John, jun 8
4434385 2175508 2175508 defendant Broughton William     Broughton, William 9
4434386 2175508 2175508 defendant Mot Stephen     Mot, Stephen 10
4434387 2175508 2175508 defendant Bertelot Stephen     Bertelot, Stephen 11
4434388 2175508 2175508 defendant atte Hope William     atte Hope, William 12
4434389 2175508 2175508 defendant Coumbe William     Coumbe, William 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);