names

27 rows where place_id = 593819

✎ 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
3613451 1871853 1871853 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 0
3613573 1871893 1871893 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 0
3613575 1871894 1871894 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 0
3613576 1871894 1871894 defendant Roo Robert husbandman 593819 593819 Roo, Robert, of Tyssyngton, husbandman 1
3613577 1871894 1871894 defendant Barton Robert husbandman 593819 593819 Barton, Robert, of Tyssyngton, husbandman 2
3613578 1871894 1871894 defendant Lout Robert husbandman 593819 593819 Lout, Robert, of Tyssyngton, husbandman 3
3613579 1871894 1871894 defendant Alsop Roger husbandman 593819 593819 Alsop, Roger, of Tyssyngton, husbandman 4
3617038 1872951 1872951 defendant Bersford Robert gent 593819 593819 Bersford, Robert, of Tyssyngton, gent 0
3617234 1873015 1873015 defendant Beresford Robert gent 593819 593819 Beresford, Robert, of Tyssyngton, gent 0
3621180 1874168 1874168 defendant Dursford Robert gent 593819 593819 Dursford, Robert, of Tyssyngton, gent 0
3640848 1907582 1907582 defendant FitzHarbert Rowland gent 593819 593819 FitzHarbert, Rowland, of Tyssyngton, gent 1
3689676 1922930 1922930 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 0
3706962 1928460 1928460 defendant FitzHerbert Roland gent 593819 593819 FitzHerbert, Roland, of Tyssyngton, gent 1
3706966 1928461 1928461 defendant FitzHerbert Roland gent 593819 593819 FitzHerbert, Roland, of Tyssyngton, gent 1
3718032 1931934 1931934 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 0
3728391 1935124 1935124 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 0
3756675 1944066 1944066 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 3
4085910 2055238 2055238 defendant Toppleys Anne widow 593819 593819 Toppleys, Anne, of Tyssyngton, widow 2
4635189 2241846 2241846 defendant Blount William   593819 593819 Blount, William, of Tyssyngton 0
5278508 2438822 2438822 defendant Toples John husbandman 593819 593819 Toples, John, of Tyssyngton, husbandman 0
5283867 2440312 2440312 defendant FitzHerbert Nicholas gent 593819 593819 FitzHerbert, Nicholas, of Tyssyngton, gent 0
5538747 2516602 2516602 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 0
5548832 2519703 2519703 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 0
5579386 2528632 2528632 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 0
5592114 2532524 2532524 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 0
5595739 2533585 2533585 defendant FitzHerbert Robert gent 593819 593819 FitzHerbert, Robert, of Tyssyngton, gent 0
5603107 2535858 2535858 defendant Alsop Thomas yeoman 593819 593819 Alsop, Thomas, of Tyssyngton, yeoman 1

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