names

27 rows where place_id = 585874

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587400 1863704 1863704 defendant Brusellys James tailor 585874 585874 Brusellys, James, of Hatfeld Peverell, Essex, tailor 0
3712078 1930096 1930096 defendant Frognall Alexander esq 585874 585874 Frognall, Alexander, of Hatfeld Peverell, Essex, esq 4
3727294 1934811 1934811 defendant Frognall Alexander esq 585874 585874 Frognall, Alexander, of Hatfeld Peverell, Essex, esq 0
3788995 1954368 1954368 defendant Wright William smith 585874 585874 Wright, William, of Hatfeld Peverell, Essex, smith 0
3788997 1954369 1954369 defendant Wryght William smith 585874 585874 Wryght, William, of Hatfeld Peverell, Essex, smith 0
3972769 2015049 2015049 defendant Allen Christopher gent 585874 585874 Allen, Christopher, of Hatfeld Peverell, Essex, gent 0
4012543 2029210 2029210 defendant Cooke Richard esq 585874 585874 Cooke, Richard, of Hatfeld Peverell, Essex, esq 0
4012545 2029211 2029211 defendant Cooke Richard esq 585874 585874 Cooke, Richard, of Hatfeld Peverell, Essex, esq 0
4711263 2268869 2268869 defendant Hoberd Thomas tanner 585874 585874 Hoberd, Thomas, of Hatfeld Peverell, Essex, tanner 0
4711287 2268870 2268870 defendant Hoberd Thomas tanner 585874 585874 Hoberd, Thomas, of Hatfeld Peverell, Essex, tanner 0
4813176 2300236 2300236 defendant Stodhawe John gent 585874 585874 Stodhawe, John, of Hatfeld Peverell, Essex, gent 0
4825179 2303916 2303916 defendant Stodhawe John gent 585874 585874 Stodhawe, John, of Hatfeld Peverell, Essex, gent 1
4825182 2303917 2303917 defendant Stodhawe John gent 585874 585874 Stodhawe, John, of Hatfeld Peverell, Essex, gent 1
4862142 2315171 2315171 defendant Stodhawegh John gent 585874 585874 Stodhawegh, John, of Hatfeld Peverell, Essex, gent 0
4896113 2325441 2325441 defendant Stedhagh John gent 585874 585874 Stedhagh, John, of Hatfeld Peverell, Essex, gent 1
4907532 2328918 2328918 defendant Stodhagh John gent 585874 585874 Stodhagh, John, of Hatfeld Peverell, Essex, gent 1
4989810 2353870 2353870 defendant Eggefeld Robert chapman 585874 585874 Eggefeld, Robert, of Hatfeld Peverell, Essex, chapman 1
5017279 2361938 2361938 defendant Raulyn William husbandman 585874 585874 Raulyn, William, of Hatfeld Peverell, Essex, husbandman 1
5060613 2374753 2374753 defendant Full Henry husbandman 585874 585874 Full, Henry, of Hatfeld Peverell, Essex, husbandman 3
5060620 2374754 2374754 defendant Full Henry husbandman 585874 585874 Full, Henry, of Hatfeld Peverell, Essex, husbandman 3
5079871 2380459 2380459 defendant Fullere Henry, senior husbandman 585874 585874 Fullere, Henry, senior, of Hatfeld Peverell, Essex, husbandman 0
5079874 2380460 2380460 defendant Fuller Henry, senior husbandman 585874 585874 Fuller, Henry, senior, of Hatfeld Peverell, Essex, husbandman 0
5079877 2380461 2380461 defendant Fullere Henry, senior husbandman 585874 585874 Fullere, Henry, senior, of Hatfeld Peverell, Essex, husbandman 0
5421624 2481403 2481403 defendant Rawlyns John yeoman 585874 585874 Rawlyns, John, of Hatfeld Peverell, Essex, yeoman 0
5441490 2487378 2487378 defendant Rawlyns John yeoman 585874 585874 Rawlyns, John, of Hatfeld Peverell, Essex, yeoman 0
5441498 2487380 2487380 defendant Rawlyns John yeoman 585874 585874 Rawlyns, John, of Hatfeld Peverell, Essex, yeoman 0
5519493 2510939 2510939 defendant Wilmot Alexander butcher 585874 585874 Wilmot, Alexander, of Hatfeld Peverell, Essex, butcher 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);