names

7 rows where place_id = 602208

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648972 1910066 1910066 defendant Payne John yeoman 602208 602208 Payne, John, of South Weld, yeoman 0
4986457 2352877 2352877 defendant Nevelok Walter husbandman 602208 602208 Nevelok, Walter, of South Weld, husbandman 0
4986458 2352877 2352877 defendant Nevelok Thomas husbandman 602208 602208 Nevelok, Thomas, of South Weld, husbandman 1
4986459 2352877 2352877 defendant Nevelok Henry husbandman 602208 602208 Nevelok, Henry, of South Weld, husbandman 2
5289119 2441824 2441824 defendant Godyll Henry mariner 602208 602208 Godyll, Henry, of South Weld, mariner 3
5289124 2441825 2441825 defendant Godyll Henry mariner 602208 602208 Godyll, Henry, of South Weld, mariner 3
5438983 2486580 2486580 defendant Tryppe John fishmonger 602208 602208 Tryppe, John, of South Weld, fishmonger 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);