names

28 rows where place_id = 587574

✎ 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
3591796 1865054 1865054 defendant Woderove Richard husbandman 587574 587574 Woderove, Richard, of Wrennyngham, husbandman 1
3591802 1865056 1865056 defendant Woderove Richard husbandman 587574 587574 Woderove, Richard, of Wrennyngham, husbandman 0
3595763 1866307 1866307 defendant Neweton William husbandman 587574 587574 Neweton, William, of Wrennyngham, husbandman 3
3815019 1962618 1962618 defendant Blome John tanner 587574 587574 Blome, John, of Wrennyngham, tanner 1
3878512 1983057 1983057 defendant Blome John tanner 587574 587574 Blome, John, of Wrennyngham, tanner 2
4043896 2040267 2040267 defendant Ruste Mathew husbandman 587574 587574 Ruste, Mathew, of Wrennyngham, husbandman 0
4084731 2054810 2054810 defendant Dabbes William yeoman 587574 587574 Dabbes, William, of Wrennyngham, yeoman 0
4110181 2063903 2063903 defendant Sheres Oliver gent 587574 587574 Sheres, Oliver, of Wrennyngham, gent 0
4183525 2089720 2089720 defendant Randall William yeoman 587574 587574 Randall, William, of Wrennyngham, yeoman 1
4191951 2092744 2092744 defendant Sheres John gent 587574 587574 Sheres, John, of Wrennyngham, gent 0
4216012 2101094 2101094 defendant Rist Robert husbandman 587574 587574 Rist, Robert, of Wrennyngham, husbandman 0
4241412 2110113 2110113 defendant Barwycke William singleman 587574 587574 Barwycke, William, of Wrennyngham, yeoman, singleman 0
4259400 2116118 2116118 defendant Alborowe Thomas tinker 587574 587574 Alborowe, Thomas, of Wrennyngham, tinker 0
4259401 2116118 2116118 defendant Ruste Robert husbandman 587574 587574 Ruste, Robert, of Wrennyngham, husbandman 1
4259949 2116298 2116298 defendant Ruste Thomas husbandman 587574 587574 Ruste, Thomas, of Wrennyngham, husbandman 1
4259950 2116298 2116298 defendant Havers Christopher husbandman 587574 587574 Havers, Christopher, of Wrennyngham, husbandman 2
4261765 2116890 2116890 defendant Havers Christopher husbandman 587574 587574 Havers, Christopher, of Wrennyngham, husbandman 2
4275745 2121465 2121465 defendant Siltopp Elias husbandman 587574 587574 Siltopp, Elias, of Wrennyngham, husbandman 0
4322524 2137945 2137945 defendant Kyddall Thomas husbandman 587574 587574 Kyddall, Thomas, of Wrennyngham, husbandman 2
4322525 2137945 2137945 defendant Havers Christopher husbandman 587574 587574 Havers, Christopher, of Wrennyngham, husbandman 3
4364309 2152297 2152297 defendant Johnson John husbandman 587574 587574 Johnson, John, of Wrennyngham, yeoman, or of Therston, husbandman 0
4377417 2156999 2156999 defendant Dabbe William yeoman 587574 587574 Dabbe, William, of Wrennyngham, yeoman 0
4391046 2161623 2161623 defendant Johnson John husbandman 587574 587574 Johnson, John, of Wrennyngham, yeoman, or of Therston, husbandman 0
4401615 2165136 2165136 defendant Syltopp Elias husbandman 587574 587574 Syltopp, Elias, of Wrennyngham, husbandman 0
4406385 2166700 2166700 defendant Wright John yeoman 587574 587574 Wright, John, of Wrennyngham, yeoman 1
5480195 2499059 2499059 defendant Neweton William husbandman 587574 587574 Neweton, William, of Wrennyngham, husbandman 0
5503287 2505938 2505938 defendant Neuton William husbandman 587574 587574 Neuton, William, of Wrennyngham, husbandman 0
5508872 2507628 2507628 defendant Woderove Richard husbandman 587574 587574 Woderove, Richard, of Wrennyngham, 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);