names

27 rows where place_id = 613962

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3701186 1926618 1926618 defendant Holder William yeoman 613962 613962 Holder, William, of Yardley, Worcs, yeoman 3
3804171 1959237 1959237 defendant Hill Richard husbandman 613962 613962 Hill, Richard, of Yardley, Worcs, husbandman 0
3842166 1971098 1971098 defendant Jeffereys John yeoman 613962 613962 Jeffereys, John, of Yardley, Worcs, yeoman 0
3842169 1971099 1971099 defendant Praty John gent 613962 613962 Praty, John, of Yardley, Worcs, gent 0
3917358 1996164 1996164 defendant Adams Richard tiler 613962 613962 Adams, Richard, of Yardley, Worcs, tiler 0
4009945 2028321 2028321 defendant Holmes Thomas yeoman 613962 613962 Holmes, Thomas, of Yardley, Worcs, yeoman 2
4012015 2029027 2029027 plaintiff Prety Edmund yeoman 613962 613962 Prety, Edmund, of Yardley, Worcs, yeoman 0
4016912 2030749 2030749 defendant Ley Edward gusbandman 613962 613962 Ley, Edward, of Yardley, Worcs, gusbandman 0
4061487 2046509 2046509 defendant Burton George gent 613962 613962 Burton, George, of Yardley, Worcs, gent 0
4074469 2051172 2051172 defendant Poynton Ralph laborer 613962 613962 Poynton, Ralph, of Yardley, Worcs, laborer 3
4098729 2059876 2059876 defendant Holmes Richard husbandman 613962 613962 Holmes, Richard, of Yardley, Worcs, husbandman 0
4133476 2072300 2072300 defendant Holmes Thomas yeoman 613962 613962 Holmes, Thomas, of Yardley, Worcs, yeoman 0
4148915 2077739 2077739 defendant Dolphyn Ralph yeoman 613962 613962 Dolphyn, Ralph, of Yardley, Worcs, yeoman 2
4159921 2081537 2081537 defendant Swyfte Thomas yeoman 613962 613962 (Swyfte, Thomas, of Yardley, Worcs, yeoman 1
4215825 2101032 2101032 defendant Barrowe Thomas yeoman 613962 613962 Barrowe, Thomas, of Yardley, Worcs, yeoman 0
4218761 2102061 2102061 defendant Holmes Mathew yeoman 613962 613962 Holmes, Mathew, of Yardley, Worcs, yeoman 2
4219884 2102454 2102454 defendant Holmes Thomas yeoman 613962 613962 Holmes, Thomas, of Yardley, Worcs, yeoman 3
4297282 2129136 2129136 defendant Swyfte Simon yeoman 613962 613962 Swyfte, Simon, of Yardley, Worcs, yeoman 0
4336874 2142624 2142624 defendant Jefferey William yeoman 613962 613962 Jefferey, William, of Yardley, Worcs, yeoman 0
4339965 2143753 2143753 defendant Holmes Mathew yeoman 613962 613962 Holmes, Mathew, of Yardley, Worcs, yeoman 1
4353550 2148466 2148466 defendant Prettye Henry yeoman 613962 613962 Prettye, Henry, of Yardley, Worcs, yeoman 3
4367312 2153364 2153364 defendant Yardley Ralph yeoman 613962 613962 Yardley, Ralph, of Yardley, Worcs, yeoman 1
4369810 2154259 2154259 defendant Dolphyn Ralph yeoman 613962 613962 Dolphyn, Ralph, of Yardley, Worcs, yeoman 1
4392445 2162096 2162096 defendant Checklett Robert yeoman 613962 613962 Checklett, Robert, of Yardley, Worcs, yeoman 2
4410948 2168253 2168253 defendant Easte Barnaby gent 613962 613962 Easte, Barnaby, of Yardley, Worcs, gent 0
4744242 2278841 2278841 defendant Bordesley William   613962 613962 Bordesley, William, of Yardley, Worcs, husbandman & formerly of Toneworth, Warws 3
5577898 2528159 2528159 defendant Adams Robert yeoman 613962 613962 Adams, Robert, of Yardley, Worcs, yeoman 3

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