names

38 rows where place_id = 589004

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596240 1866451 1866451 defendant A Wode John husbandman 589004 589004 A Wode, John, of Stondon, Herts, husbandman 0
3605163 1869279 1869279 defendant Benet Richard husbandman 589004 589004 Benet, Richard, of Stondon, Herts, husbandman 2
3606514 1869709 1869709 defendant Ederyche William miller 589004 589004 Ederyche, William, of Stondon, Herts, miller 0
3832913 1968219 1968219 defendant Rawlyn Walter cordwainer 589004 589004 Rawlyn, Walter, of Stondon, Herts, cordwainer 0
3833010 1968244 1968244 defendant Rawlyn Walter cordwainer 589004 589004 Rawlyn, Walter, of Stondon, Herts, cordwainer 0
3875797 1982157 1982157 defendant Bedyll Nicholas upholsterer 589004 589004 Bedyll, Nicholas, of Stondon, Herts, upholsterer 0
3885024 1985250 1985250 defendant Danyell John yeoman 589004 589004 Danyell, John, of Stondon, Herts, yeoman 4
3890556 1987104 1987104 plaintiff Hower Thomas gent 589004 589004 Hower, Thomas, of Stondon, Herts, gent 0
3895827 1988811 1988811 defendant Chamberleyn Thomas husbandman 589004 589004 Chamberleyn, Thomas, of Stondon, Herts, husbandman 0
3902977 1991224 1991224 defendant Wyderall Richard yeoman 589004 589004 Wyderall, Richard, of Stondon, Herts, yeoman 0
3905054 1991953 1991953 defendant Howe Thomas   589004 589004 Howe, Thomas, of Stondon, Herts 0
3944204 2005078 2005078 defendant Brett John (legal representative) 589004 589004 Brett, John, of Stondon, Herts, yeoman or maltman, executors of 0
3962500 2011478 2011478 defendant Warde John yeoman 589004 589004 Warde, John, of Stondon, Herts, yeoman 0
3962503 2011479 2011479 plaintiff Wetherall Richard (legal representative) 589004 589004 Wetherall, Richard, of Stondon, Herts, gent, executor of 0
4011411 2028860 2028860 defendant Brett Robert maltman 589004 589004 Brett, Robert, of Stondon, Herts, maltman 0
4034134 2036870 2036870 defendant Bret Robert maltman 589004 589004 Bret, Robert, of Stondon, Herts, maltman 0
4034136 2036871 2036871 defendant Brett William maltman 589004 589004 Brett, William, of Stondon, Herts, maltman 0
4091535 2057265 2057265 defendant Worland Richard tanner 589004 589004 Worland, Richard, of Stondon, Herts, tanner 0
4120029 2067451 2067451 defendant Brett Nicholas tailor 589004 589004 Brett, Nicholas, of Stondon, Herts, tailor 0
4336090 2142357 2142357 defendant Ade alias Hoye Thomas husbandman 589004 589004 Ade alias Hoye, Thomas, of Stondon, Herts, husbandman 0
4383587 2159220 2159220 defendant Awdie alias Hoye Thomas tailor 589004 589004 Awdie alias Hoye, Thomas, of Stondon, Herts, tailor 0
4655753 2247683 2247683 defendant Flexham Thomas maltman 589004 589004 Flexham, Thomas, of Stondon, Herts, maltman 0
4878472 2320210 2320210 defendant Taylour John husbandman 589004 589004 Taylour, John, of Stondon, Herts, husbandman 3
4971393 2348371 2348371 defendant Rugwyn John, junior gent 589004 589004 Rugwyn, John, junior, of Stondon, Herts, gent 1
5052005 2372213 2372213 defendant Orknay John chaplain 589004 589004 Orknay, John, of Stondon, Herts, chaplain 0
5124291 2393551 2393551 defendant Ledys Thomas chapman 589004 589004 Ledys, Thomas, of Stondon, Herts, chapman 0
5130638 2395451 2395451 defendant Halden William husbandman 589004 589004 Halden, William, of Stondon, Herts, husbandman 0
5150079 2401161 2401161 defendant Halden William husbandman 589004 589004 Halden, William, of Stondon, Herts, husbandman 0
5150081 2401162 2401162 defendant Halden William husbandman 589004 589004 Halden, William, of Stondon, Herts, husbandman 0
5168776 2406598 2406598 defendant Halden William husbandman 589004 589004 Halden, William, of Stondon, Herts, husbandman 0
5217408 2420828 2420828 defendant Asteley Philip gent 589004 589004 Asteley, Philip, of Stondon, Herts, gent 0
5225031 2422992 2422992 defendant Greme Robert wheeler 589004 589004 Greme, Robert, of Stondon, Herts, wheeler 1
5236794 2426345 2426345 defendant Neweman John husbandman 589004 589004 Neweman, John, of Stondon, Herts, husbandman 1
5449776 2489823 2489823 defendant Sefferey Henry   589004 589004 Sefferey, Henry, of Stondon, Herts, vicar 1
5461932 2493512 2493512 defendant Seffrey Henry clerk & vicar 589004 589004 Seffrey, Henry, of Stondon, Herts, clerk & vicar 1
5461937 2493513 2493513 defendant Geffrey Henry clerk & vicar 589004 589004 Geffrey, Henry, of Stondon, Herts, clerk & vicar 1
5514279 2509316 2509316 defendant Bryan John husbandman 589004 589004 Bryan, John, of Stondon, Herts, husbandman 0
5608478 2537551 2537551 defendant Russhe Robert yeoman 589004 589004 Russhe, Robert, of Stondon, Herts, 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);