names

18 rows where case_id = 2225512

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4580914 2225512 2225512 plaintiff Dodyngton John clerk   Dodyngton, John, clerk, executors of 0
4580915 2225512 2225512 plaintiff Haukyn Lawrence clerk   (Haukyn, Lawrence, clerk 1
4580916 2225512 2225512 plaintiff Clyve William clerk   Clyve, William, clerk 2
4580917 2225512 2225512 plaintiff fitz Herbert Nicholas     fitz Herbert, Nicholas 3
4580918 2225512 2225512 defendant Bampfeld Thomas     Bampfeld, Thomas 0
4580919 2225512 2225512 defendant Bowod Nicholas     Bowod, Nicholas 1
4580920 2225512 2225512 defendant Dowere Ralph master   Dowere, Ralph, master 2
4580921 2225512 2225512 defendant Sutton William     Sutton, William 3
4580922 2225512 2225512 defendant James William   624220 624220 James, William, of Crukern 4
4580923 2225512 2225512 defendant Newecomb   butcher   Newecomb, butcher 5
4580924 2225512 2225512 defendant Neel Richard   601443 601443 Neel, Richard, of Toppesham 6
4580925 2225512 2225512 defendant More Richard clerk   More, Richard, clerk 7
4580926 2225512 2225512 defendant Hode John, sen   771695 771695 Hode, John, sen, of Cowyk Street 8
4580927 2225512 2225512 defendant Stil John   642626 642626 Stil, John, of Stokelond 9
4580928 2225512 2225512 defendant Paderda Noel (legal representative)   Paderda, Noel, executrix of 10
4580929 2225512 2225512 defendant Paderda Joan formerly wife of Noel   Paderda, Joan, formerly wife of Noel 11
4580930 2225512 2225512 defendant Spryngalt Richard clerk   Spryngalt, Richard, clerk 12
4580931 2225512 2225512 defendant Pewen John   608800 608800 Pewen, John, of Molton 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);