names

11 rows where case_id = 2419742

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5213704 2419742 2419742 plaintiff Boys Walter     Boys, Walter 0
5213705 2419742 2419742 defendant Boys Thomas gent 765220 765220 Boys, Thomas, of Welyngoure, gent 0
5213706 2419742 2419742 defendant Roos Alice widow 765220 765220 Roos, Alice, of Welyngoure, widow 1
5213707 2419742 2419742 defendant Clerk John husbandman 765220 765220 Clerk, John, of Welyngoure, husbandman 2
5213708 2419742 2419742 defendant Thomson Richard husbandman 765220 765220 Thomson, Richard, of Welyngoure, husbandman 3
5213709 2419742 2419742 defendant Veysy Richard husbandman 765220 765220 Veysy, Richard, of Welyngoure, husbandman 4
5213710 2419742 2419742 defendant Whasshyngburgh Simon husbandman 589914 589914 Whasshyngburgh, Simon, of Navenby, husbandman 5
5213711 2419742 2419742 defendant Gregge Robert husbandman 589914 589914 Gregge, Robert, of Navenby, husbandman 6
5213712 2419742 2419742 defendant Eston John husbandman 630650 630650 Eston, John, of Grayngham, husbandman 7
5213713 2419742 2419742 defendant Vikers Henry husbandman 630650 630650 Vikers, Henry, of Grayngham, husbandman 8
5213714 2419742 2419742 defendant Knot Thomas husbandman 621475 621475 Knot, Thomas, of Wadyngham, husbandman 9

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