names

45 rows where place_id = 588907

✎ 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
3595981 1866373 1866373 defendant Lunte Robert merchant 588907 588907 Lunte, Robert, of Wodebrigge, merchant 2
3595982 1866373 1866373 defendant Annotte John   588907 588907 Annotte, John, of Wodebrigge, tallow chandler 3
3597123 1866724 1866724 defendant Ony or Ovy Richard yeoman 588907 588907 Ony or Ovy, Richard, of Wodebrigge, yeoman 2
3597376 1866801 1866801 defendant Smyth Walter husbandman 588907 588907 Smyth, Walter, of Wodebrigge, husbandman 0
3604037 1868929 1868929 defendant Mylam Thomas yeoman 588907 588907 Mylam, Thomas, of Wodebrigge, yeoman 0
3688478 1922551 1922551 defendant Bele William beer brewer or merchant 588907 588907 Bele, William, of Wodebrigge, beer brewer or merchant 0
3776902 1950516 1950516 plaintiff Cantell Robert   588907 588907 Cantell, Robert, of Wodebrigge 0
4458316 2187639 2187639 defendant Cokes William   588907 588907 Cokes, William, of Wodebrigge 0
4676483 2258257 2258257 defendant Mason William   588907 588907 Mason, William, of Wodebrigge, mason 3
4743294 2278564 2278564 defendant Esex William glover 588907 588907 Esex, William, of Wodebrigge, glover 2
4772722 2287441 2287441 defendant Loof Robert yeoman 588907 588907 Loof, Robert, of Wodebrigge, yeoman 0
4862945 2315391 2315391 defendant Plomer John yeoman 588907 588907 Plomer, John, of Wodebrigge, yeoman 9
4867701 2316868 2316868 defendant Dethe Nicholas smith 588907 588907 Dethe, Nicholas, of Wodebrigge, smith 3
4933851 2336967 2336967 defendant Bool John chandler 588907 588907 Bool, John, of Wodebrigge, chandler 0
4942616 2339660 2339660 defendant Cook John butcher 588907 588907 Cook, John, of Wodebrigge, butcher 0
4949476 2341830 2341830 defendant Alvard Benedict tailor 588907 588907 Alvard, Benedict, of Wodebrigge, tailor 0
4952050 2342583 2342583 defendant Dool John chandler 588907 588907 Dool, John, of Wodebrigge, chandler 0
4966371 2346874 2346874 defendant Lepere Ralph yeoman 588907 588907 Lepere, Ralph, of Wodebrigge, yeoman 0
5037602 2367872 2367872 defendant Deyth John smith 588907 588907 Deyth, John, of Wodebrigge, smith 0
5121192 2392627 2392627 defendant Cogman Richard dyer 588907 588907 Cogman, Richard, of Wodebrigge, dyer 2
5132863 2396105 2396105 defendant Alvard Benedict yeoman 588907 588907 Alvard, Benedict, of Wodebrigge, yeoman 0
5142869 2399043 2399043 defendant Cogman Richard dyer 588907 588907 Cogman, Richard, of Wodebrigge, dyer 0
5164231 2405275 2405275 defendant Gogman Richard dyer 588907 588907 Gogman, Richard, of Wodebrigge, dyer 0
5384964 2470772 2470772 defendant Coiruch William butcher 588907 588907 Coiruch, William, of Wodebrigge, butcher 1
5403503 2476072 2476072 defendant Waryn William fletcher 588907 588907 Waryn, William, of Wodebrigge, fletcher 0
5423176 2481894 2481894 defendant Pertriche William butcher 588907 588907 Pertriche, William, of Wodebrigge, butcher 0
5428487 2483446 2483446 defendant More Robert   588907 588907 More, Robert, of Wodebrigge, paten maker 0
5428490 2483447 2483447 defendant More Robert   588907 588907 More, Robert, of Wodebrigge, paten maker 0
5447844 2489237 2489237 defendant Cady or Oady John   588907 588907 Cady or Oady, John, of Wodebrigge 0
5460243 2492998 2492998 defendant Kempe Thomas (legal representative) 588907 588907 Kempe, Thomas, of Wodebrigge, yeoman, executors of 0
5460244 2492998 2492998 defendant Cady John yeoman 588907 588907 (Cady, John, of Wodebrigge, yeoman 1
5471882 2496543 2496543 defendant Kempe Thomas (legal representative) 588907 588907 Kempe, Thomas, of Wodebrigge, yeoman, executors of 0
5471883 2496543 2496543 defendant Cady John yeoman 588907 588907 (Cady, John, of Wodebrigge, yeoman 1
5487451 2501143 2501143 defendant Brame or Braine John yeoman 588907 588907 Brame or Braine, John, of Wodebrigge, yeoman 0
5487452 2501143 2501143 defendant Bulle John yeoman 588907 588907 Bulle, John, of Wodebrigge, yeoman 1
5487453 2501143 2501143 defendant Lunt Robert yeoman 588907 588907 Lunt, Robert, of Wodebrigge, yeoman 2
5487454 2501143 2501143 defendant Pygot Nicholas yeoman 588907 588907 Pygot, Nicholas, of Wodebrigge, yeoman 3
5487455 2501143 2501143 defendant Bele William yeoman 588907 588907 Bele, William, of Wodebrigge, yeoman 4
5487456 2501143 2501143 defendant Bulle William dyer 588907 588907 Bulle, William, of Wodebrigge, dyer 5
5487457 2501143 2501143 defendant Cantell Robert yeoman 588907 588907 Cantell, Robert, of Wodebrigge, yeoman 6
5487458 2501143 2501143 defendant Godyng Robert yeoman 588907 588907 Godyng, Robert, of Wodebrigge, yeoman 7
5496888 2503999 2503999 defendant Lopham Robert fishmonger 588907 588907 Lopham, Robert, of Wodebrigge, fishmonger 1
5497490 2504191 2504191 defendant Goodyng Robert husbandman 588907 588907 Goodyng, Robert, of Wodebrigge, husbandman 0
5538351 2516481 2516481 defendant Partyche William (legal representative) 588907 588907 Partyche, William, of Wodebrigge, butcher, executors of 0
5538352 2516481 2516481 defendant Partryche Robert butcher 588907 588907 (Partryche, Robert, of Wodebrigge, 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);