names

35 rows where place_id = 610031

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3681640 1920352 1920352 plaintiff Smythe Henry yeoman 610031 610031 Smythe, Henry, of Carleton, Nhants, yeoman 0
3710543 1929619 1929619 defendant Page Richard husbandman 610031 610031 Page, Richard, of Carleton, Nhants, husbandman 0
3723277 1933553 1933553 plaintiff Palmer Thomas esq 610031 610031 Palmer, Thomas, of Carleton, Nhants, esq 0
3727764 1934954 1934954 defendant Page Richard husbandman 610031 610031 Page, Richard, of Carleton, Nhants, husbandman 0
3739146 1938454 1938454 plaintiff Palmer Thomas esq 610031 610031 Palmer, Thomas, of Carleton, Nhants, esq 0
3739148 1938455 1938455 plaintiff Palmer Thomas esq 610031 610031 Palmer, Thomas, of Carleton, Nhants, esq 0
3775742 1950163 1950163 defendant Page Richard husbandman 610031 610031 Page, Richard, of Carleton, Nhants, husbandman 0
3779506 1951313 1951313 defendant Gudman John husbandman 610031 610031 Gudman, John, of Carleton, Nhants, husbandman 1
3806712 1959998 1959998 defendant Page Richard yeoman 610031 610031 Page, Richard, of Carleton, Nhants, yeoman 0
3806716 1959999 1959999 defendant Page Richard yeoman 610031 610031 Page, Richard, of Carleton, Nhants, yeoman 0
3828655 1966840 1966840 defendant Smyth Henry husbandman 610031 610031 Smyth, Henry, of Carleton, Nhants, husbandman 1
3828658 1966841 1966841 defendant Smyth Henry husbandman 610031 610031 Smyth, Henry, of Carleton, Nhants, husbandman 1
3869988 1980204 1980204 defendant Page Richard husbandman 610031 610031 Page, Richard, of Carleton, Nhants, husbandman 0
3883766 1984838 1984838 defendant Page Richard husbandman 610031 610031 Page, Richard, of Carleton, Nhants, husbandman 0
3883769 1984839 1984839 defendant Page Richard husbandman 610031 610031 Page, Richard, of Carleton, Nhants, husbandman 0
3893170 1987956 1987956 defendant Page Richard yeoman 610031 610031 Page, Richard, of Carleton, Nhants, yeoman 0
3893482 1988047 1988047 defendant Page Richard yeoman 610031 610031 Page, Richard, of Carleton, Nhants, yeoman 0
3896725 1989114 1989114 defendant Broke Thomas gent 610031 610031 Broke, Thomas, of Carleton, Nhants, gent 0
3929638 2000262 2000262 defendant Coper Thomas chapman 610031 610031 Coper, Thomas, of Carleton, Nhants, chapman 0
4033602 2036667 2036667 defendant Mountayne John yeoman 610031 610031 Mountayne, John, of Carleton, Nhants, yeoman 1
4033661 2036689 2036689 defendant Mountayne John yeoman 610031 610031 Mountayne, John, of Carleton, Nhants, yeoman 1
4219338 2102259 2102259 defendant Lawrence Edward laborer 610031 610031 Lawrence, Edward, of Carleton, Nhants, laborer 0
4228494 2105449 2105449 defendant Esam Mark laborer 610031 610031 Esam, Mark, of Carleton, Nhants, laborer 1
4257664 2115537 2115537 defendant Ensam Mark laborer 610031 610031 Ensam, Mark, of Carleton, Nhants, laborer 1
4304415 2131681 2131681 defendant Palmer Thomas gent 610031 610031 Palmer, Thomas, of Carleton, Nhants, gent 0
4320835 2137378 2137378 defendant Page William yeoman 610031 610031 Page, William, of Carleton, Nhants, yeoman 1
4339068 2143424 2143424 defendant Palmer William gent 610031 610031 Palmer, William, of Carleton, Nhants, gent 0
4355589 2149178 2149178 defendant Palmer Thomas gent 610031 610031 Palmer, Thomas, of Carleton, Nhants, gent 0
4692353 2263126 2263126 defendant Hyskochopkyn Richard husbandman 610031 610031 Hyskochopkyn, Richard, of Carleton, Nhants, husbandman 0
4736044 2276413 2276413 defendant Palmer William gent 610031 610031 Palmer, William, of Carleton, Nhants, gent 0
4822925 2303253 2303253 defendant Palmere John gent 610031 610031 Palmere, John, of Carleton, Nhants, gent 0
4828124 2304839 2304839 defendant Palmer John gent 610031 610031 Palmer, John, of Carleton, Nhants, gent 3
4828131 2304840 2304840 defendant Palmer John gent 610031 610031 Palmer, John, of Carleton, Nhants, gent 3
5294777 2443455 2443455 defendant Palmer Robert   610031 610031 Palmer, Robert, of Carleton, Nhants 0
5565085 2524377 2524377 defendant Page Henry yeoman 610031 610031 Page, Henry, of Carleton, Nhants, yeoman 2

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