names

15 rows where place_id = 628386

✎ 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
3782024 1952126 1952126 defendant Heyward James husbandman 628386 628386 Heyward, James, of Walton in Gordano, husbandman 0
4943809 2340028 2340028 defendant Whitebred John summoner 628386 628386 Whitebred, John, of Walton in Gordano, summoner 6
4943810 2340028 2340028 defendant Frank John husbandman 628386 628386 Frank, John, of Walton in Gordano, husbandman 7
4943824 2340028 2340028 defendant Everard Robert husbandman 628386 628386 Everard, Robert, of Walton in Gordano, husbandman 21
4949635 2341883 2341883 plaintiff Witbred John   628386 628386 Witbred, John, of Walton in Gordano 1
4950027 2341976 2341976 plaintiff Witbred John   628386 628386 Witbred, John, of Walton in Gordano 1
5213276 2419616 2419616 defendant Harley John esq 628386 628386 Harley, John, of Walton in Gordano, esq 1
5213277 2419616 2419616 defendant Dounton Walter yeoman 628386 628386 Dounton, Walter, of Walton in Gordano, yeoman 2
5213278 2419616 2419616 defendant Bolysdon Richard yeoman 628386 628386 Bolysdon, Richard, of Walton in Gordano, yeoman 3
5213279 2419616 2419616 defendant Walker Richard yeoman 628386 628386 Walker, Richard, of Walton in Gordano, yeoman 4
5213280 2419616 2419616 defendant Hurne William yeoman 628386 628386 Hurne, William, of Walton in Gordano, yeoman 5
5213281 2419616 2419616 defendant Ive William yeoman 628386 628386 Ive, William, of Walton in Gordano, yeoman 6
5213282 2419616 2419616 defendant Sore William yeoman 628386 628386 Sore, William, of Walton in Gordano, yeoman 7
5213283 2419616 2419616 defendant Janyns William yeoman 628386 628386 Janyns, William, of Walton in Gordano, yeoman 8
5213284 2419616 2419616 defendant Harleysman Hugh yeoman 628386 628386 Harleysman, Hugh, of Walton in Gordano, yeoman 9

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