names

24 rows where case_id = 2507482

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5508320 2507482 2507482 plaintiff Dunham John esq   Dunham, John, esq 0
5508321 2507482 2507482 defendant Baxster Thomas gent 601140 601140 Baxster, Thomas, of Bolton on Dern, gent 0
5508322 2507482 2507482 defendant Watson Christopher     Watson, Christopher 1
5508323 2507482 2507482 defendant Pygot Thomas     Pygot, Thomas 2
5508324 2507482 2507482 defendant Wade John     Wade, John 3
5508325 2507482 2507482 defendant Clerkson John     Clerkson, John 4
5508326 2507482 2507482 defendant Sisson Thomas     Sisson, Thomas 5
5508327 2507482 2507482 defendant Shepherd John     Shepherd, John 6
5508328 2507482 2507482 defendant Milner John     Milner, John 7
5508329 2507482 2507482 defendant Campion John     Campion, John 8
5508330 2507482 2507482 defendant Hall John     Hall, John 9
5508331 2507482 2507482 defendant Milner William     Milner, William 10
5508332 2507482 2507482 defendant Maweger Robert     Maweger, Robert 11
5508333 2507482 2507482 defendant Truluffe John     Truluffe, John 12
5508334 2507482 2507482 defendant Wryght John     Wryght, John 13
5508335 2507482 2507482 defendant Drake William     Drake, William 14
5508336 2507482 2507482 defendant Maweger Thomas     Maweger, Thomas 15
5508337 2507482 2507482 defendant Nelson Robert     Nelson, Robert 16
5508338 2507482 2507482 defendant Wightman Thomas     Wightman, Thomas 17
5508339 2507482 2507482 defendant Metham William     Metham, William 18
5508340 2507482 2507482 defendant Metham George     Metham, George 19
5508341 2507482 2507482 defendant Tonalcliffe Peter     Tonalcliffe, Peter 20
5508342 2507482 2507482 defendant Elys John     Elys, John 21
5508343 2507482 2507482 defendant Birde William husbandman 598839 598839 Birde, William, of Cadeby, husbandman 22

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