names

37 rows where place_id = 609635

✎ 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
3679472 1919646 1919646 defendant Olyver Edmund yeoman 609635 609635 Olyver, Edmund, of Wymborn Mynster, yeoman 0
3715385 1931097 1931097 defendant Jenyns William husbandman 609635 609635 Jenyns, William, of Wymborn Mynster, husbandman 0
3715386 1931097 1931097 defendant Jenyns Matilda widow 609635 609635 Jenyns, Matilda, of Wymborn Mynster, widow 1
3737542 1937976 1937976 defendant Herberd Thomas innholder 609635 609635 Herberd, Thomas, of Wymborn Mynster, innholder 2
3933112 2001367 2001367 defendant Myles Bartholomew tanner 609635 609635 Myles, Bartholomew, of wymborn, Mynster, tanner 2
4148337 2077550 2077550 defendant Pynton John cordwainer 609635 609635 Pynton, John, of Wymborn Mynster, cordwainer 0
4148338 2077550 2077550 defendant Pynton Christian spinster 609635 609635 Pynton, Christian, of Wymborn Mynster, spinster 1
4199370 2095332 2095332 defendant Bugge Thomas yeoman 609635 609635 Bugge, Thomas, of Wymborn Mynster, yeoman 0
4225050 2104231 2104231 defendant Bryan Morgan joiner 609635 609635 Bryan, Morgan, of Wymborn Mynster, joiner 0
4304455 2131698 2131698 defendant Dackham Henry gent 609635 609635 Dackham, Henry, of Wymborn Mynster, gent 1
4461799 2188754 2188754 defendant Corston Richard   609635 609635 Corston, Richard, of Wymborn Minster 0
4555256 2217577 2217577 defendant Adam John butcher 609635 609635 Adam, John, of Wymborn Mynster, butcher 0
4572024 2222817 2222817 defendant Scote John   609635 609635 Scote, John, of Wymborn 0
4714076 2269731 2269731 defendant Pyle John tanner 609635 609635 Pyle, John, of Wymborn Minster, tanner 0
4815114 2300836 2300836 defendant Bovayr Richard tailor 609635 609635 Bovayr, Richard, of Wymborn Minster, tailor 4
4815115 2300836 2300836 defendant Fletcher Roger fletcher 609635 609635 Fletcher, Roger, of Wymborn Minster, fletcher 5
4872716 2318417 2318417 defendant Hille John chapman 609635 609635 Hille, John, of Wymborn, chapman 0
5049028 2371344 2371344 defendant Bageworth William butcher 609635 609635 Bageworth, William, of Wymborn Minster, butcher 0
5148593 2400714 2400714 defendant Barbour John yeoman 609635 609635 together with Barbour, John, of Wymborn Mynster, yeoman 2
5183427 2410894 2410894 defendant Barbour John yeoman 609635 609635 Barbour, John, of Wymborn Minster, yeoman 2
5183453 2410900 2410900 defendant Barbour John yeoman 609635 609635 Barbour, John, of Wymborn Minster, yeoman 2
5312050 2448635 2448635 defendant Goffe John laborer 609635 609635 Goffe, John, of Wymborn Mynster, laborer 0
5312051 2448635 2448635 defendant Gaskyn Henry laborer 609635 609635 Gaskyn, Henry, of Wymborn Mynster, laborer 1
5362587 2463947 2463947 defendant Fuell or Fewell William smith 609635 609635 Fuell or Fewell, William, of Wymborn Mynster, smith 1
5432473 2484685 2484685 defendant Puttok John mercer 609635 609635 Puttok, John, of Wymborn Mynster, mercer 0
5446350 2488803 2488803 defendant Gracyan Lucy   609635 609635 Gracyan, Lucy, of Wymborn Mynster 0
5446787 2488938 2488938 defendant Pattok John mercer 609635 609635 Pattok, John, of Wymborn Minster, mercer 0
5452918 2490752 2490752 defendant (illegible) John (legal representative) 609635 609635 _, John, of Wymborn Minster, dyer, executrix of 0
5456883 2491964 2491964 defendant Ewe Edward of tanner 609635 609635 Ewe, Edward of, of Wymborn Mynster, tanner 0
5456884 2491964 2491964 defendant Ingram Nicholas weaver 609635 609635 Ingram, Nicholas, of Wymborn Mynster, weaver 1
5460046 2492935 2492935 defendant Stephyns William tanner 609635 609635 Stephyns, William, of Wymborn Mynster, tanner 0
5460860 2493197 2493197 defendant Raule Richard butcher 609635 609635 Raule, Richard, of Wymborn Minster, butcher 0
5468747 2495581 2495581 defendant Ingram Nicholas weaver 609635 609635 Ingram, Nicholas, of Wymborn, Mynster, weaver 1
5498273 2504441 2504441 defendant Rokell William husbandman 609635 609635 Rokell, William, of Wymborn Mynster, husbandman 0
5516366 2509951 2509951 defendant Vyke Simon weaver 609635 609635 Vyke, Simon, of Wymborn Mynster, weaver 0
5557799 2522234 2522234 plaintiff Norton John   609635 609635 Norton, John, of Wymborn Mynster 0
5557801 2522235 2522235 plaintiff Norton John clothier 609635 609635 Norton, John, of Wymborn Mynster, clothier 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);