names

21 rows where case_id = 2194428

✎ 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
4480057 2194428 2194428 plaintiff Kirkbride Richard knight   Kirkbride, Richard, knight 0
4480058 2194428 2194428 defendant Wilson John   761569 761569 Wilson, John, of Scoterdby 0
4480059 2194428 2194428 defendant Richardson John   761570 761570 Richardson, John, of Kyrke Levyngton 1
4480060 2194428 2194428 defendant Andreweson John   761571 761571 Andreweson, John, of Kirke Levyngton 2
4480061 2194428 2194428 defendant Sprote Robert     Sprote, Robert 3
4480062 2194428 2194428 defendant Philippeson Robert     Philippeson, Robert 4
4480063 2194428 2194428 defendant Mulcastre Walter     Mulcastre, Walter 5
4480064 2194428 2194428 defendant Gibson William     Gibson, William 6
4480065 2194428 2194428 defendant Wilkynson William   761568 761568 Wilkynson, William, of Scaleby 7
4480066 2194428 2194428 defendant Stell John     Stell, John 8
4480067 2194428 2194428 defendant Lamley William de     Lamley, William de 9
4480068 2194428 2194428 defendant Thomson Robert   761572 761572 Thomson, Robert, of Ascanby 10
4480069 2194428 2194428 defendant Walby Hugh de     Walby, Hugh de 11
4480070 2194428 2194428 defendant Huwetson John   761573 761573 Huwetson, John, of Comquyntyn or Cumwhitton 12
4480071 2194428 2194428 defendant Philipson Richard   761572 761572 Philipson, Richard, of Ascanby 13
4480072 2194428 2194428 defendant Lamley Thomas de     Lamley, Thomas de 14
4480073 2194428 2194428 defendant del More Andrew     del More, Andrew 15
4480074 2194428 2194428 defendant Thomlynson John   761574 761574 Thomlynson, John, of Ascanby. Taillour, Richard, of Scaleby 16
4480075 2194428 2194428 defendant Taillour Patrick     Taillour, Patrick 17
4480076 2194428 2194428 defendant Jonesson William   761568 761568 Jonesson, William, of Scaleby 18
4480077 2194428 2194428 defendant del Wate Henry     del Wate, Henry 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);