names

26 rows where place_id = 607952

✎ 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
3671639 1917118 1917118 defendant Stylle Thomas yeoman 607952 607952 Stylle, Thomas, of Cowden, yeoman 0
3676916 1918818 1918818 defendant Pyratt Richard laborer 607952 607952 Pyratt, Richard, of Cowden, laborer 3
3791185 1955075 1955075 defendant Wykynden William yeoman 607952 607952 Wykynden, William, of Cowden, yeoman 0
3885930 1985549 1985549 defendant Gaynesford Richard gent 607952 607952 Gaynesford, Richard, of Cowden, gent 0
3885931 1985549 1985549 defendant Gaynesford Edward gent 607952 607952 Gaynesford, Edward, of Cowden, gent 1
3913100 1994713 1994713 plaintiff Barker Marion widow 607952 607952 Barker, Marion, of Cowden, widow 0
3935917 2002328 2002328 defendant Levett William clerk 607952 607952 Levett, William, of Cowden, clerk 0
3935919 2002329 2002329 defendant Levett William clerk 607952 607952 Levett, William, of Cowden, clerk 0
3960386 2010729 2010729 defendant Wyckenden William husbandman 607952 607952 Wyckenden, William, of Cowden, husbandman 0
3988658 2020684 2020684 defendant Gaynesforthe William yeoman 607952 607952 Gaynesforthe, William, of Cowden, yeoman 2
3988662 2020685 2020685 defendant Gaynesforth William yeoman 607952 607952 Gaynesforth, William, of Cowden, yeoman 2
4010747 2028619 2028619 defendant Turnor Thomas husbandman 607952 607952 Turnor, Thomas, of Cowden, husbandman 0
4010749 2028620 2028620 defendant Turnor Thomas husbandman 607952 607952 Turnor, Thomas, of Cowden, husbandman 0
4077452 2052225 2052225 defendant Wickenden George yeoman 607952 607952 Wickenden, George, of Cowden, yeoman 0
4088878 2056324 2056324 defendant Cheseman William yeoman 607952 607952 Cheseman, William, of Cowden, or of Redderfyld, Sussex, yeoman 0
4097753 2059528 2059528 defendant Bugg John husbandman 607952 607952 Bugg, John, of Cowden, husbandman 0
4119879 2067400 2067400 defendant Devall alias Carpe Peter bellfounder 607952 607952 Devall alias Carpe, Peter, of Cowden, bellfounder 0
4153126 2079191 2079191 defendant Charte Thomas yeoman 607952 607952 Charte, Thomas, of Cowden, yeoman 0
4209132 2098743 2098743 defendant Wyckenden George yeoman 607952 607952 Wyckenden, George, of Cowden, yeoman 1
4234321 2107539 2107539 defendant Hayward Edward husbandman 607952 607952 Hayward, Edward, of Cowden, husbandman 1
4321198 2137509 2137509 defendant Kentt Edward gent 607952 607952 Kentt, Edward, of Cowden, or of Colbrooke, Hartfeld, Sussex, gent 0
4324193 2138495 2138495 defendant Swaysland John yeoman 607952 607952 Swaysland, John, of Cowden, yeoman 0
4735211 2276160 2276160 plaintiff Somere Henry   607952 607952 Somere, Henry, of Cowden 0
4735212 2276160 2276160 defendant Cochemond John butcher 607952 607952 Cochemond, John, of Cowden, butcher 0
5586077 2530685 2530685 defendant Gaynesford Nicholas gent 607952 607952 Gaynesford, Nicholas, of Cowden, gent 0
5601421 2535335 2535335 defendant Gaynesford Nicholas gent 607952 607952 Gaynesford, Nicholas, of Cowden, 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);