names

38 rows where place_id = 586407

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588645 1864090 1864090 defendant Chapman Edmund butcher 586407 586407 Chapman, Edmund, of Botysdale, butcher 3
3592214 1865181 1865181 defendant Burgeys John tailor 586407 586407 Burgeys, John, of Botysdale, tailor 2
3592218 1865182 1865182 defendant Burgeys John tailor 586407 586407 Burgeys, John, of Botysdale, tailor 2
3616411 1872769 1872769 defendant Clerk Edmund   586407 586407 Clerk, Edmund, of Botysdale, parchment maker 2
3620472 1873979 1873979 defendant Wykys William, senior yeoman 586407 586407 Wykys, William, senior, of Botysdale, yeoman 3
3649933 1910345 1910345 defendant Hyll Gilbert husbandman 586407 586407 Hyll, Gilbert, of Botysdale, husbandman 0
3649935 1910346 1910346 defendant Jamys Walter hatmaker 586407 586407 Jamys, Walter, of Botysdale, hatmaker 0
3650554 1910540 1910540 defendant Archer Thomas shoemaker 586407 586407 Archer, Thomas, of Botysdale, shoemaker 3
3650812 1910618 1910618 defendant Revett Thomas husbandman 586407 586407 Revett, Thomas, of Botysdale, husbandman 0
3731523 1936088 1936088 defendant Cage Thomas thatcher 586407 586407 Cage, Thomas, of Botysdale, thatcher 1
3745617 1940535 1940535 defendant Harvy John gent 586407 586407 Harvy, John, of Botysdale, gent 0
3769365 1948074 1948074 defendant Hervy John gent 586407 586407 Hervy, John, of Botysdale, gent 0
4188068 2091328 2091328 defendant Whighte Robert weaver 586407 586407 Whighte, Robert, of Botysdale, weaver 3
4202494 2096411 2096411 defendant Peake Richard husbandman 586407 586407 Peake, Richard, of Botysdale, husbandman 3
4202743 2096503 2096503 defendant Rychard Roger butcher 586407 586407 Rychard, Roger, of Botysdale, butcher 1
4210353 2099178 2099178 defendant Harvye Edmund gent 586407 586407 Harvye, Edmund, of Botysdale, gent 0
4244786 2111243 2111243 defendant Turnor Thomas laborer 586407 586407 Turnor, Thomas, of Botysdale, laborer 2
4276616 2121756 2121756 defendant Tooke John husbandman 586407 586407 Tooke, John, of Botysdale, husbandman 1
4768748 2286203 2286203 defendant Panyermaker William panyer maker 586407 586407 Panyermaker, William, of Botysdale, panyer maker 0
4768750 2286203 2286203 defendant Fox John husbandman 586407 586407 Fox, John, of Botysdale, husbandman 2
4916972 2331812 2331812 defendant Norton Robert yoeman 586407 586407 Norton, Robert, of Botysdale, yoeman 0
4922139 2333336 2333336 defendant Galt Henry husbandman 586407 586407 Galt, Henry, of Botysdale, husbandman 0
4940129 2338942 2338942 defendant Bettys Geoffrey chandler 586407 586407 Bettys, Geoffrey, of Botysdale, chandler 0
5002744 2357711 2357711 defendant Caudeler William chapman 586407 586407 Caudeler, William, of Botysdale, chapman 4
5134351 2396543 2396543 defendant Ducheman alias Herryson John   586407 586407 Ducheman alias Herryson, John, of Botysdale, shoe maker 1
5152405 2401835 2401835 defendant Goldfynche William butcher 586407 586407 Goldfynche, William, of Botysdale, butcher 0
5154256 2402402 2402402 defendant Ducheman John shoemaker 586407 586407 Ducheman, John, of Botysdale, shoemaker 1
5496562 2503885 2503885 defendant Hoo James chandler 586407 586407 Hoo, James, of Botysdale, chandler 1
5502743 2505773 2505773 defendant Martyn John gent 586407 586407 Martyn, John, of Botysdale, gent 1
5541448 2517438 2517438 defendant Drory Edmund husbandman 586407 586407 Drory, Edmund, of Botysdale, husbandman 0
5541450 2517439 2517439 defendant Mastyr John clerk 586407 586407 Mastyr, John, of Botysdale, clerk 0
5542256 2517709 2517709 defendant Penne Richard innholder 586407 586407 Penne, Richard, of Botysdale, innholder 0
5542258 2517710 2517710 defendant Penne Richard innholder 586407 586407 Penne, Richard, of Botysdale, innholder 0
5547675 2519335 2519335 defendant Aleyn Ralph yeoman 586407 586407 Aleyn, Ralph, of Botysdale, yeoman 1
5551450 2520460 2520460 defendant Lyng Thomas husbandman 586407 586407 Lyng, Thomas, of Botysdale, husbandman 2
5568732 2525403 2525403 defendant Penne Richard (legal representative) 586407 586407 Penne, Richard, of Botysdale, yeoman, executors of 0
5568734 2525403 2525403 defendant Garrynton William yeoman 586407 586407 Garrynton, William, of Botysdale, yeoman 2
5587719 2531174 2531174 defendant Hobard John butcher 586407 586407 Hobard, John, of Botysdale, butcher 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);