names

13 rows where case_id = 2436862

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5271883 2436862 2436862 plaintiff Hert William gent 585869 585869 Hert, William, of London, gent, on his own account 0
5271884 2436862 2436862 defendant Deryk Simon yeoman 758853 758853 Deryk, Simon, of ---, yeoman 0
5271885 2436862 2436862 defendant Elton John clerk 585869 585869 Elton, John, of London, clerk 1
5271886 2436862 2436862 defendant Calcot Thomas thatcher 622042 622042 Calcot, Thomas, of Southale, thatcher 2
5271887 2436862 2436862 defendant Edward (illegible) collier 595806 595806 Edward, ----, of Kyngesbury, collier 3
5271888 2436862 2436862 defendant Hoggard Thomas fuller 866882 866882 Hoggard, Thomas, of Harrowe atte Hyll, fuller 4
5271889 2436862 2436862 defendant Whytwey Thomas gent 586175 586175 Whytwey, Thomas, of Canterbury, gent 5
5271890 2436862 2436862 defendant Rychere John clerk 866883 866883 Rychere, John, of Chelchehithe or Chelsea, clerk 6
5271891 2436862 2436862 defendant Wyld John laborer 585869 585869 Wyld, John, of London, laborer 7
5271892 2436862 2436862 defendant White Alexander clerk 617198 617198 White, Alexander, of Bekenysfeld, Bucks, clerk 8
5271893 2436862 2436862 defendant Chaverton Walter weaver 592217 592217 Chaverton, Walter, of Chichester, Sussex, weaver 9
5271894 2436862 2436862 defendant Cheverton Henry tailor 585869 585869 Cheverton, Henry, of London, tailor 10
5271895 2436862 2436862 defendant Hegger John collier 643703 643703 Hegger, John, of Kyngysbury, collier 11

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