names

38 rows where place_id = 587728

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592264 1865195 1865195 defendant Smalwode John yeoman 587728 587728 Smalwode, John, of Batell, yeoman 0
3592266 1865196 1865196 defendant Smalwode John yeoman 587728 587728 Smalwode, John, of Batell, yeoman 0
3606620 1869743 1869743 defendant Edward Thomas brewer 587728 587728 Edward, Thomas, of Batell, brewer 0
3607334 1869955 1869955 defendant Staple Thomas smith 587728 587728 Staple, Thomas, of Batell, smith 2
3723949 1933771 1933771 defendant Fynche Henry gent 587728 587728 Fynche, Henry, of Batell, gent 0
3725076 1934129 1934129 defendant Inholde William chaplain 587728 587728 Inholde, William, of Batell, chaplain 1
3726563 1934565 1934565 defendant Egolden John yeoman 587728 587728 Egolden, John, of Batell, yeoman 1
3742502 1939527 1939527 defendant Love John tailor 587728 587728 Love, John, of Batell, tailor 0
3742503 1939527 1939527 defendant Pylgryme Richard husbandman 587728 587728 Pylgryme, Richard, of Batell, husbandman 1
3796456 1956763 1956763 defendant Swan Richard yeoman 587728 587728 Swan, Richard, of Batell, yeoman 1
3841766 1971012 1971012 defendant Stonystrett Stephen husbandman 587728 587728 Stonystrett, Stephen, of Batell, husbandman 1
3848640 1973158 1973158 defendant Eston John beer brewer 587728 587728 Eston, John, of Batell, beer brewer 0
4581766 2225738 2225738 defendant Okekley John   587728 587728 Okekley, John, of Batell, park man 3
4733034 2275510 2275510 defendant Kyngesmylle Thomas baker 587728 587728 Kyngesmylle, Thomas, of Batell, baker 0
4935069 2337377 2337377 defendant Staple Thomas husbandman 587728 587728 Staple, Thomas, of Batell, husbandman 0
4947456 2341201 2341201 defendant Lawe Peter skinner 587728 587728 Lawe, Peter, of Batell, skinner 0
4977315 2350174 2350174 defendant Henle John yeoman 587728 587728 (Henle, John, of Batell, yeoman 1
5004309 2358153 2358153 defendant Henle John yeoman 587728 587728 (Henle, John, of Batell, yeoman 1
5065758 2376281 2376281 defendant Okherst John husbandman 587728 587728 Okherst, John, of Batell, husbandman 4
5078750 2380133 2380133 defendant Bedyngton Thomas cordwainer 587728 587728 Bedyngton, Thomas, of Batell, cordwainer 2
5236188 2426172 2426172 defendant Elfrede John laborer 587728 587728 Elfrede, John, of Batell, laborer 1
5236191 2426172 2426172 defendant Averey William laborer 587728 587728 Averey, William, of Batell, laborer 4
5257214 2432384 2432384 defendant Boweley Richard yeoman 587728 587728 Boweley, Richard, of Batell, yeoman 0
5297789 2444360 2444360 defendant Wynkfeld John baker 587728 587728 Wynkfeld, John, of Batell, baker 1
5305689 2446710 2446710 plaintiff Love John (legal representative) 587728 587728 Love, John, of Batell, executors of 0
5305693 2446710 2446710 defendant Hogge Robert husbandman 587728 587728 Hogge, Robert, of Batell, husbandman 0
5312782 2448854 2448854 defendant Hore John tailor 587728 587728 Hore, John, of Batell, tailor 4
5321451 2451507 2451507 defendant Hogge Robert yeoman 587728 587728 Hogge, Robert, of Batell, yeoman 0
5365001 2464726 2464726 defendant Mylle Alan husbandman 587728 587728 Mylle, Alan, of Batell, husbandman 0
5365002 2464726 2464726 defendant Cokeram Robert mercer 587728 587728 Cokeram, Robert, of Batell, mercer 1
5365003 2464726 2464726 defendant Rolffe John yeoman 587728 587728 Rolffe, John, of Batell, yeoman 2
5422064 2481540 2481540 defendant Wyker John husbandman 587728 587728 Wyker, John, of Batell, husbandman 0
5494402 2503229 2503229 defendant Smalwode John yeoman 587728 587728 Smalwode, John, of Batell, yeoman 0
5494412 2503233 2503233 defendant Smalwode John yeoman 587728 587728 Smalwode, John,of Batell, yeoman 1
5509456 2507807 2507807 defendant Smalwode John yeoman 587728 587728 Smalwode, John, of Batell, yeoman 0
5509458 2507808 2507808 defendant Smalwode John yeoman 587728 587728 Smalwode, John, of Batell, yeoman 0
5519933 2511073 2511073 plaintiff Boys William   587728 587728 Boys, William, of Batell 0
5529332 2513689 2513689 defendant Frensshe John yeoman 587728 587728 Frensshe, John, of Batell, 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);