names

26 rows where place_id = 614661

✎ 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
3704815 1927798 1927798 plaintiff Godden Thomas   614661 614661 Godden, Thomas, of Addyngton 0
3707139 1928519 1928519 defendant Hally Alice widow 614661 614661 Hally, Alice, of Addyngton, widow 0
3715511 1931140 1931140 defendant Bowmer John husbandman 614661 614661 Bowmer, John, of Addyngton, husbandman 0
3718860 1932176 1932176 defendant Watton Thomas gent 614661 614661 Watton, Thomas, of Addyngton, gent 0
3718861 1932176 1932176 defendant Stydolff John husbandman 614661 614661 Stydolff, John, of Addyngton, husbandman 1
3738729 1938319 1938319 defendant Eyton John husbandman 614661 614661 Eyton, John, of Addyngton, husbandman 1
3803458 1958985 1958985 defendant Bedell John   614661 614661 Bedell, John, of Addyngton, parish clerk 0
3832180 1967977 1967977 defendant White John gent 614661 614661 White, John, of Addyngton, gent 0
3848359 1973062 1973062 defendant Whyte John gent 614661 614661 Whyte, John, of Addyngton, gent 0
3853757 1974807 1974807 defendant Ardren William husbandman 614661 614661 Ardren, William, of Addyngton, husbandman 1
3884901 1985222 1985222 defendant Gamble Thomas brickmaker 614661 614661 Gamble, Thomas, of Addyngton, brickmaker 0
4031840 2036051 2036051 defendant Hartropp William yeoman 614661 614661 Hartropp, William, of Addyngton, yeoman 0
4099192 2060036 2060036 defendant Swanne Thomas bricklayer 614661 614661 Swanne, Thomas, of Addyngton, bricklayer 0
4157553 2080716 2080716 defendant Wyllard James yeoman 614661 614661 Wyllard, James, of Addyngton, yeoman 0
4281120 2123298 2123298 defendant Comfort John, junior yeoman 614661 614661 Comfort, John, junior, of Addyngton, yeoman 0
4309826 2133592 2133592 defendant Whytynge Thomas brewer 614661 614661 Whytynge, Thomas, of Addyngton, brewer 0
4371841 2154992 2154992 defendant Whytinge Thomas brewer 614661 614661 Whytinge, Thomas, of Addyngton, brewer 0
4371842 2154992 2154992 defendant Lane William bricklayer 614661 614661 Lane, William, of Addyngton, bricklayer 1
4376472 2156654 2156654 defendant Whytinge Thomas brewer 614661 614661 Whytinge, Thomas, of Addyngton, brewer 0
5399402 2474905 2474905 defendant Ardern Robert gent 614661 614661 Ardern, Robert, of Addyngton, gent 3
5426993 2483008 2483008 defendant Ardern Robert gent 614661 614661 Ardern, Robert, of Addyngton, gent 0
5497547 2504204 2504204 defendant Ardern Robert gent 614661 614661 Ardern, Robert, of Addyngton, gent 0
5512343 2508718 2508718 defendant Ardern John gent 614661 614661 Ardern, John, of Addyngton, gent 0
5519660 2510982 2510982 defendant Watton Edmund gent 614661 614661 Watton, Edmund, of Addyngton, gent 0
5607375 2537203 2537203 defendant Watton Edmund esq 614661 614661 Watton, Edmund, of Addyngton, esq 0
5607378 2537203 2537203 defendant Delton John yeoman 614661 614661 Delton, John, of Addyngton, 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);