names

29 rows where place_id = 612742

✎ 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
3694795 1924578 1924578 defendant Greed John husbandman 612742 612742 Greed, John, of Westlegh, husbandman 5
3745855 1940607 1940607 defendant Mayge Roger   612742 612742 Mayge, Roger, of Westlegh, groom 0
3815093 1962642 1962642 defendant Byrd Richard husbandman 612742 612742 Byrd, Richard, of Westlegh, husbandman 1
3815094 1962642 1962642 defendant Borage Richard, senior husbandman 612742 612742 Borage, Richard, senior, of Westlegh, husbandman 2
3815095 1962642 1962642 defendant Borage Richard, junior husbandman 612742 612742 Borage, Richard, junior, of Westlegh, husbandman 3
3815096 1962642 1962642 defendant Webber John husbandman 612742 612742 Webber, John, of Westlegh, husbandman 4
3815098 1962642 1962642 defendant Dyker Thomas husbandman 612742 612742 Dyker, Thomas, of Westlegh, husbandman 6
3815099 1962642 1962642 defendant Coche William husbandman 612742 612742 Coche, William, of Westlegh, husbandman 7
3831441 1967718 1967718 defendant Rowe John clerk of the said parish 612742 612742 Rowe, John, of Westlegh, clerk of the said parish 0
3836661 1969369 1969369 defendant Gyfford Roger gent 612742 612742 Gyfford, Roger, of Westlegh, gent 0
3901514 1990731 1990731 defendant Byrde Richard husbandman 612742 612742 Byrde, Richard, of Westlegh, husbandman 1
3955579 2009021 2009021 plaintiff Mayne John tailor 612742 612742 Mayne, John, of Westlegh, tailor 0
4749011 2280195 2280195 defendant Strodkesworthy Hugh husbandman 612742 612742 Strodkesworthy, Hugh, of Westlegh, husbandman 1
4890198 2323705 2323705 defendant Holcombe John butcher 612742 612742 Holcombe, John, of Westlegh, butcher 0
4965702 2346666 2346666 defendant Pyttyng John husbandman 612742 612742 Pyttyng, John, of Westlegh, husbandman 0
5167852 2406310 2406310 defendant Leche William husbandman 612742 612742 Leche, William, of Westlegh, husbandman 0
5203887 2416889 2416889 defendant Leche William husbandman 612742 612742 Leche, William, of Westlegh, husbandman 0
5318527 2450638 2450638 defendant Bodyche Henry husbandman 612742 612742 Bodyche, Henry, of Westlegh, husbandman 0
5318529 2450639 2450639 defendant Bodyche Henry husbandman 612742 612742 Bodyche, Henry, of Westlegh, husbandman 0
5363247 2464159 2464159 defendant Levyngton Thomas husbandman 612742 612742 Levyngton, Thomas, of Westlegh, husbandman 1
5482842 2499815 2499815 defendant Richard Nicholas husbandman 612742 612742 Richard, Nicholas, of Westlegh, husbandman 0
5515967 2509841 2509841 defendant Pynhorwode John husbandman 612742 612742 Pynhorwode, John, of Westlegh, husbandman 0
5515968 2509841 2509841 defendant Kytte John husbandman 612742 612742 Kytte, John, of Westlegh, husbandman 1
5515969 2509841 2509841 defendant Jule Walter husbandman 612742 612742 Jule, Walter, of Westlegh, husbandman 2
5515970 2509841 2509841 defendant Jule Thomas husbandman 612742 612742 Jule, Thomas, of Westlegh, husbandman 3
5515971 2509841 2509841 defendant Lete Elias tailor 612742 612742 Lete, Elias, of Westlegh, tailor 4
5515972 2509841 2509841 defendant Beryman William laborer 612742 612742 Beryman, William, of Westlegh, laborer 5
5515973 2509841 2509841 defendant Geryng Peter husbandman 612742 612742 Geryng, Peter, of Westlegh, husbandman 6
5522482 2511850 2511850 defendant Willemer John gent 612742 612742 Willemer, John, of Westlegh, gent 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);