names

35 rows where place_id = 615971

✎ 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
3711757 1929991 1929991 defendant Wattis Richard yeoman 615971 615971 Wattis, Richard, of St Lawrence, yeoman 0
3717663 1931819 1931819 defendant Stone John husbandman 615971 615971 Stone, John, of St Lawrence, husbandman 1
3717664 1931819 1931819 defendant Foorde William husbandman 615971 615971 Foorde, William, of St Lawrence, husbandman 2
3717666 1931819 1931819 defendant Baker Robert husbandman 615971 615971 Baker, Robert, of St Lawrence, husbandman 4
3776740 1950470 1950470 defendant Wattys Richard yeoman 615971 615971 Wattys, Richard, of St Lawrence, yeoman 0
3776741 1950470 1950470 defendant Roke John yeoman 615971 615971 Roke, John, of St Lawrence, yeoman 1
3780184 1951528 1951528 defendant Wattys Richard yeoman 615971 615971 Wattys, Richard, of St Lawrence, yeoman 0
3780187 1951528 1951528 defendant Pauley Henry laborer 615971 615971 Pauley, Henry, of St Lawrence, laborer 3
3780189 1951529 1951529 defendant Wattys Richard yeoman 615971 615971 Wattys, Richard, of St Lawrence, yeoman 0
3780192 1951529 1951529 defendant Pauley Henry laborer 615971 615971 Pauley, Henry, of St Lawrence, laborer 3
3783888 1952734 1952734 defendant Wattys Richard, senior   615971 615971 Wattys, Richard, senior, of St Lawrence 0
3787517 1953885 1953885 defendant Wattys Richard yeoman 615971 615971 Wattys, Richard, of St Lawrence, yeoman 0
3885863 1985528 1985528 defendant Opy Thomas dyer 615971 615971 Opy, Thomas, of St Lawrence, dyer 1
4092204 2057513 2057513 defendant Flamacke John yeoman 615971 615971 Flamacke, John, of St Lawrence, yeoman 0
4178887 2088093 2088093 defendant Wise John husbandman 615971 615971 Wise, John, of St Lawrence, husbandman 1
4203000 2096599 2096599 defendant Stretton John gent 615971 615971 Stretton, John, of St Lawrence, clerk, or of Langford, Essex, gent 0
4654427 2247260 2247260 defendant Ysot John yeoman 615971 615971 Ysot, John, of St Lawrence, yeoman 1
4683454 2260426 2260426 defendant Isot John yeoman 615971 615971 Isot, John, of St Lawrence, yeoman 3
4721051 2271919 2271919 defendant Neyler John laborer 615971 615971 Neyler, John, of St Lawrence, laborer 1
4734509 2275959 2275959 defendant Isot John   615971 615971 Isot, John, of St Lawrence, bailiff 0
4749985 2280469 2280469 defendant Joot John yeoman 615971 615971 Joot, John, of St Lawrence, yeoman 6
4777452 2288942 2288942 defendant Bacheler Godeleva draper 615971 615971 Bacheler, Godeleva, of St Lawrence, widow of Bacheler, Robert, draper 0
5019301 2362533 2362533 defendant Maldon John husbandman 615971 615971 Maldon, John, of St Lawrence, husbandman 1
5305906 2446751 2446751 defendant Kent William dyer 615971 615971 Kent, William, of St Lawrence, dyer 1
5423731 2482063 2482063 defendant Pauly John dyer 615971 615971 Pauly, John, of St Lawrence, dyer 0
5423733 2482063 2482063 defendant Ryccheowe Richard   615971 615971 Ryccheowe, Richard, of St Lawrence, mason 2
5425534 2482613 2482613 defendant Rery William yeoman 615971 615971 Rery, William, of St Lawrence, yeoman 0
5445332 2488501 2488501 defendant Pauly John dyer 615971 615971 Pauly, John, of St Lawrence, dyer 0
5445334 2488501 2488501 defendant Ry_ Richard   615971 615971 Ry_, Richard, of St Lawrence, mason 2
5466353 2494874 2494874 defendant Tomlyn Robert husbandman 615971 615971 Tomlyn, Robert, of St Lawrence, husbandman 1
5472748 2496817 2496817 defendant Kyng Percival chaplain 615971 615971 Kyng, Percival, of St Lawrence, chaplain 1
5472749 2496817 2496817 defendant Allond Stephen husbandman 615971 615971 Allond, Stephen, of St Lawrence, husbandman 2
5532302 2514644 2514644 plaintiff Thomas Robert   615971 615971 Thomas, Robert, of St Lawrence 0
5549070 2519769 2519769 defendant Dyer Robert dyer 615971 615971 Dyer, Robert, of St Lawrence, dyer 1
5573517 2526816 2526816 defendant Pawle John dyer 615971 615971 Pawle, John, of St Lawrence, dyer 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);