names

5 rows where place_id = 668778

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3990449 2021335 2021335 defendant Risedon Walter weaver 668778 668778 Risedon, Walter, of Paynton, Devon, weaver 12
4011628 2028901 2028901 defendant Wilkins John husbandman 668778 668778 Wilkins, John, of Paynton, Devon, husbandman 0
4024358 2033392 2033392 defendant Rysedon Walter husbandman 668778 668778 Rysedon, Walter, of Paynton, Devon, husbandman 6
4290185 2126557 2126557 defendant Furnys John tailor 668778 668778 Furnys, John, of Paynton, Devon, tailor 3
4932463 2336549 2336549 defendant Pytte Richard shipman 668778 668778 Pytte, Richard, of Paynton, Devon, shipman 0

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