names

16 rows where place_id = 829819

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4978254 2350444 2350444 defendant Panter alias Bolmere John yeoman 829819 829819 Panter alias Bolmere, John, of Magna Berdfeld, yeoman 4
5019751 2362656 2362656 defendant Stobard Edward husbandman 829819 829819 Stobard, Edward, of Magna Berdfeld, husbandman 1
5019757 2362657 2362657 defendant Stobard Edward husbandman 829819 829819 Stobard, Edward, of Magna Berdfeld, husbandman 1
5254560 2431548 2431548 defendant Bendelowe Christopher husbandman 829819 829819 Bendelowe, Christopher, of Magna Berdfeld, husbandman 0
5254561 2431548 2431548 defendant Wendon William husbandman 829819 829819 Wendon, William, of Magna Berdfeld, husbandman 1
5254562 2431548 2431548 defendant Mersshe Thomas husbandman 829819 829819 Mersshe, Thomas, of Magna Berdfeld, husbandman 2
5254563 2431548 2431548 defendant Taillour William husbandman 829819 829819 Taillour, William, of Magna Berdfeld, husbandman 3
5254564 2431548 2431548 defendant Wright William husbandman 829819 829819 Wright, William, of Magna Berdfeld, husbandman 4
5254565 2431548 2431548 defendant Bertelot John   829819 829819 Bertelot, John, of Magna Berdfeld, wheelwright 5
5254566 2431548 2431548 defendant Mors John husbandman 829819 829819 Mors, John, of Magna Berdfeld, husbandman 6
5254567 2431548 2431548 defendant Holde John tailor 829819 829819 Holde, John, of Magna Berdfeld, tailor 7
5254568 2431548 2431548 defendant Munde John husbandman 829819 829819 Munde, John, of Magna Berdfeld, husbandman 8
5254569 2431548 2431548 defendant Borley James husbandman 829819 829819 Borley, James, of Magna Berdfeld, husbandman 9
5254570 2431548 2431548 defendant Barell John husbandman 829819 829819 Barell, John, of Magna Berdfeld, husbandman 10
5264408 2434624 2434624 plaintiff Serle John, senior   829819 829819 Serle, John, senior, of Magna Berdfeld 0
5343580 2458179 2458179 defendant Dyer Richard yeoman 829819 829819 Dyer, Richard, of Magna Berdfeld, yeoman 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);