names

18 rows where place_id = 755229

✎ 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
4426619 2173136 2173136 defendant Oky Roger   755229 755229 Oky, Roger, of Little Glemham 1
4426621 2173136 2173136 defendant Petristre John de   755229 755229 Petristre, John de, of Little Glemham 3
4547380 2215111 2215111 defendant Shrebbe William   755229 755229 Shrebbe, William, of Little Glemham 4
4547386 2215112 2215112 defendant Shrebbe William   755229 755229 Shrebbe, William, of Little Glemham 4
4547391 2215113 2215113 defendant Shrebbe William   755229 755229 Shrebbe, William, of Little Glemham 3
4720935 2271880 2271880 defendant Hagh John carpenter 755229 755229 Hagh, John, of Little Glemham, carpenter 0
4742217 2278213 2278213 defendant Hagh John yeoman 755229 755229 Hagh, John, of Little Glemham, yeoman 4
4758340 2282982 2282982 defendant atte Hagh John carpenter 755229 755229 atte Hagh, John, of Little Glemham, carpenter 1
4821080 2302671 2302671 defendant Boteld William yeoman 755229 755229 Boteld, William, of Little Glemham, yeoman 0
5048674 2371241 2371241 defendant Herman Thomas clerk 755229 755229 Herman, Thomas, of Little Glemham, clerk 0
5131529 2395703 2395703 defendant Malster Robert husbandman 755229 755229 Malster, Robert, of Little Glemham, husbandman 1
5144048 2399407 2399407 defendant Frere Thomas husbandman 755229 755229 Frere, Thomas, of Little Glemham, husbandman 0
5165033 2405514 2405514 defendant Frere Thomas husbandman 755229 755229 Frere, Thomas, of Little Glemham, husbandman 0
5165034 2405514 2405514 defendant Hesand Thomas husbandman 755229 755229 Hesand, Thomas, of Little Glemham, husbandman 1
5178718 2409493 2409493 defendant Frere Thomas husbandman 755229 755229 Frere, Thomas, of Little Glemham, husbandman 0
5178719 2409493 2409493 defendant Hesand Thomas husbandman 755229 755229 Hesand, Thomas, of Little Glemham, husbandman 1
5197143 2414905 2414905 defendant Frere Henry husbandman 755229 755229 Frere, Henry, of Little Glemham, husbandman 0
5205021 2417223 2417223 defendant Miller Robert husbandman 755229 755229 Miller, Robert, of Little Glemham, husbandman 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);