names

20 rows where place_id = 597595

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3629154 1903989 1903989 plaintiff Lyce Robert   597595 597595 Lyce, Robert, of North Glemham 2
3806350 1959900 1959900 defendant Knyght Nicholas husbandman 597595 597595 Knyght, Nicholas, of North Glemham, husbandman 1
3842451 1971176 1971176 defendant Dux Robert yeoman 597595 597595 Dux, Robert, of North Glemham, yeoman 0
3871844 1980821 1980821 defendant Glasyer alias Glaswryght Roger husbandman 597595 597595 Glasyer alias Glaswryght, Roger, of North Glemham, husbandman 0
3895932 1988845 1988845 defendant Dux Robert, senior yeoman 597595 597595 Dux, Robert, senior, of North Glemham, yeoman 0
3895933 1988845 1988845 defendant Dux Oliver laborer 597595 597595 Dux, Oliver, of North Glemham, laborer 1
3895934 1988845 1988845 defendant Dux Thomas laborer 597595 597595 Dux, Thomas, of North Glemham, laborer 2
3895935 1988845 1988845 defendant Dux Jude laborer 597595 597595 Dux, Jude, of North Glemham, laborer 3
4020652 2032114 2032114 plaintiff Wolnawe William yeoman 597595 597595 Wolnawe, William, of North Glemham, yeoman 0
4195675 2094042 2094042 defendant Dux Thomas yeoman 597595 597595 Dux, Thomas, of North Glemham, yeoman 1
4327806 2139623 2139623 defendant Walker Robert husbandman 597595 597595 Walker, Robert, of North Glemham, husbandman 2
4406344 2166687 2166687 defendant Hawkyn Thomas yeoman 597595 597595 Hawkyn, Thomas, of north Glemham, yeoman 3
5055745 2373288 2373288 defendant Wode Alexander yeoman 597595 597595 Wode, Alexander, of North Glemham, yeoman 1
5150490 2401278 2401278 defendant Bedon John butcher 597595 597595 Bedon, John, of North Glemham, butcher 0
5312887 2448887 2448887 defendant Dux or Duke Thomas butcher 597595 597595 Dux or Duke, Thomas, of North Glemham, butcher 0
5525522 2512575 2512575 defendant Knightys Robert husbandman 597595 597595 Knightys, Robert, of North Glemham, husbandman 0
5525523 2512575 2512575 defendant Dukkys Robert husbandman 597595 597595 Dukkys, Robert, of North Glemham, husbandman 1
5554380 2521319 2521319 defendant Knyghtys Robert yeoman 597595 597595 Knyghtys, Robert, of North Glemham, yeoman 0
5554381 2521319 2521319 defendant Duxe Thomas butcher 597595 597595 Duxe, Thomas, of North Glemham, butcher 1
5555367 2521574 2521574 defendant Wulnale Nicholas husbandman 597595 597595 Wulnale, Nicholas, of North Glemham, 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);