names

16 rows where place_id = 635297

✎ 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
3824511 1965537 1965537 defendant Sewall William husbandman 635297 635297 Sewall, William, of Occolt, husbandman 3
3824512 1965537 1965537 defendant Coo John husbandman 635297 635297 Coo, John, of Occolt, husbandman 4
3824513 1965537 1965537 defendant Gobett John husbandman 635297 635297 Gobett, John, of Occolt, husbandman 5
3824514 1965537 1965537 defendant Bukston John   635297 635297 Bukston, John, of Occolt, ploughwright 6
3848755 1973195 1973195 defendant Denny George husbandman 635297 635297 Denny, George, of Occolt, husbandman 0
3855362 1975318 1975318 defendant Roser James husbandman 635297 635297 Roser, James, of Occolt, husbandman 1
3915416 1995523 1995523 defendant Goddard John butcher 635297 635297 Goddard, John, of Occolt, butcher 0
4032860 2036408 2036408 plaintiff Goddard John yeoman 635297 635297 Goddard, John, of Occolt, yeoman 0
4032862 2036409 2036409 plaintiff Goddard John yeoman 635297 635297 Goddard, John, of Occolt, yeoman 0
4042935 2039950 2039950 defendant Brome Thomas yeoman 635297 635297 Brome, Thomas, of Occolt, yeoman 1
4042940 2039951 2039951 defendant Brome Thomas yeoman 635297 635297 Brome, Thomas, of Occolt, yeoman 1
4067079 2048524 2048524 defendant Brome Thomas yeoman 635297 635297 Brome, Thomas, of Occolt, yeoman 1
4336544 2142518 2142518 defendant Hubbard William yeoman 635297 635297 Hubbard, William, of Occolt, yeoman 2
4336545 2142518 2142518 defendant Reade John yeoman 635297 635297 Reade, John, of Occolt, yeoman 3
4336553 2142518 2142518 defendant Grater Robert husbandman 635297 635297 Grater, Robert, of Occolt, husbandman 11
5511408 2508413 2508413 defendant Laurence William husbandman 635297 635297 Laurence, William, of Occolt, husbandman 1

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