names

14 rows where case_id = 2520908

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5552949 2520908 2520908 plaintiff Fox Richard Bishop of Winchester   Fox, Richard, Bishop of Winchester 0
5552950 2520908 2520908 defendant Somerffeld William   606920 606920 Somerffeld, William, of Wytney, servant 0
5552951 2520908 2520908 defendant Maye Thomas     Maye, Thomas 1
5552952 2520908 2520908 defendant Rose Thomas shoemaker 606920 606920 Rose, Thomas, of Wytney, shoemaker 2
5552953 2520908 2520908 defendant Evan John laborer 606920 606920 Evan, John, of Wytney, laborer 3
5552954 2520908 2520908 defendant Dyngell Roger glover 606920 606920 Dyngell, Roger, of Wytney, glover 4
5552955 2520908 2520908 defendant Box John fuller 606920 606920 Box, John, of Wytney, fuller 5
5552956 2520908 2520908 defendant Dannyng Richard fuller 606920 606920 Dannyng, Richard, of Wytney, fuller 6
5552957 2520908 2520908 defendant Goldron John glover 606920 606920 Goldron, John, of Wytney, glover 7
5552958 2520908 2520908 defendant Bysshopp John dyer 606920 606920 Bysshopp, John, of Wytney, dyer 8
5552959 2520908 2520908 defendant Lecoke Richard weaver 606920 606920 Lecoke, Richard, of Wytney, weaver 9
5552960 2520908 2520908 defendant Ruste Richard laborer 606920 606920 Ruste, Richard, of Wytney, laborer 10
5552961 2520908 2520908 defendant Whytyng Thomas laborer 606920 606920 Whytyng, Thomas, of Wytney, laborer 11
5552962 2520908 2520908 defendant Lane John fuller 606920 606920 Lane, John, of Wytney, fuller 12

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