names

71 rows where place_id = 595717

✎ 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
3597553 1866857 1866857 defendant Drye Ralph yeoman of the crown 595717 595717 Drye, Ralph, of Walsyngham, Norf, gent, yeoman of the crown 4
3597557 1866858 1866858 defendant Drye Ralph yeoman of the crown 595717 595717 Drye, Ralph, of Walsyngham, Norf, gent, yeoman of the crown 2
3621605 1874298 1874298 defendant Lyon John innholder 595717 595717 Lyon, John, of Walsyngham, Norf, innholder 1
3662796 1914282 1914282 defendant Drye James   595717 595717 Drye, James, of Walsyngham, Norf, inn holder 1
3662812 1914285 1914285 defendant Copyng Richard   595717 595717 Copyng, Richard, of Walsyngham, Norf, inn holder 1
3667023 1915629 1915629 defendant Smyth John chapman 595717 595717 Smyth, John, of Walsyngham, Norf, chapman 0
3667065 1915637 1915637 defendant Smyth John chapman 595717 595717 Smyth, John, of Walsyngham, Norf, chapman 0
3667070 1915638 1915638 defendant Smyth John chapman 595717 595717 Smyth, John, of Walsyngham, Norf, chapman 0
3669987 1916559 1916559 defendant Doddyng Robert yeoman 595717 595717 Doddyng, Robert, of Walsyngham, Norf, yeoman 1
3669991 1916560 1916560 defendant Duddyng Robert yeoman 595717 595717 Duddyng, Robert, of Walsyngham, Norf, yeoman 1
3697535 1925450 1925450 defendant Curteys Thomas innholder 595717 595717 (Curteys, Thomas, of Walsyngham, Norf, innholder 2
3711002 1929752 1929752 defendant Gysborugh George mercer 595717 595717 Gysborugh, George, of Walsyngham, Norf, mercer 2
3711008 1929753 1929753 defendant Gisborugh George mercer 595717 595717 Gisborugh, George, of Walsyngham, Norf, mercer 1
3716506 1931458 1931458 defendant Hart John innholder 595717 595717 Hart, John, of Walsyngham, Norf, innholder 0
3720411 1932663 1932663 defendant Maltbye William draper 595717 595717 Maltbye, William, of Walsyngham, Norf, draper 0
3732267 1936333 1936333 plaintiff Copynger Elizabeth innholder 595717 595717 Copynger, Elizabeth, of Walsyngham, Norf, widow, innholder 0
3735686 1937396 1937396 defendant Clyfton John yeoman 595717 595717 Clyfton, John, of Walsyngham, Norf, yeoman 0
3771960 1948923 1948923 defendant Malbe or Malle William draper 595717 595717 Malbe or Malle, William, of Walsyngham, Norf, draper 0
3777171 1950613 1950613 defendant Coke Thomas chapman 595717 595717 Coke, Thomas, of Walsyngham, Norf, chapman 0
3784048 1952791 1952791 defendant Woderoffe William chapman 595717 595717 Woderoffe, William, of Walsyngham, Norf, chapman 1
3803331 1958939 1958939 defendant Porter James mercer 595717 595717 Porter, James, of Walsyngham, Norf, mercer 0
3842130 1971089 1971089 defendant Reynold William draper 595717 595717 Reynold, William, of Walsyngham, Norf, draper 0
3871412 1980687 1980687 defendant Crome Edmund mercer 595717 595717 Crome, Edmund, of Walsyngham, Norf, mercer 1
3921123 1997415 1997415 defendant Danby William yeoman 595717 595717 Danby, William, of Walsyngham, Norf, yeoman 0
3933759 2001586 2001586 defendant Chapman Richard chapman 595717 595717 Chapman, Richard, of Walsyngham, Norf, chapman 0
3951539 2007593 2007593 defendant Sydney Thomas gent 595717 595717 Sydney, Thomas, of Walsyngham, Norf, gent 0
3958644 2010098 2010098 defendant Dragley John yeoman 595717 595717 Dragley, John, of Walsyngham, Norf, yeoman 1
3961648 2011175 2011175 defendant Tryndell Thomas gent 595717 595717 Tryndell, Thomas, of Walsyngham, Norf, gent 1
3966191 2012804 2012804 defendant Poope Thomas innholder 595717 595717 Poope, Thomas, of Walsyngham, Norf, innholder 2
4012461 2029180 2029180 defendant Mynne Nicholas esq 595717 595717 Mynne, Nicholas, of Walsyngham, Norf, esq 1
4018686 2031416 2031416 defendant Davye William gent 595717 595717 Davye, William, of Walsyngham, Norf, gent 2
4042693 2039862 2039862 defendant Mynne Nicholas esq 595717 595717 Mynne, Nicholas, of Walsyngham, Norf, esq 0
4100021 2060336 2060336 defendant Buck John yeoman 595717 595717 Buck, John, of Walsyngham, Norf, yeoman 1
4263910 2117587 2117587 defendant Day George saddler 595717 595717 Day, George, of Walsyngham, Norf, saddler 3
4317100 2136096 2136096 defendant Mynne Elizabeth widow 595717 595717 Mynne, Elizabeth, of Walsyngham, Norf, widow 0
4720275 2271683 2271683 defendant Risto_ William   595717 595717 Risto_, William, of Walsyngham, Norf, bourdoure or embroiderer 0
4720277 2271684 2271684 defendant Ristoft William   595717 595717 Ristoft, William, of Walsyngham, Norf, bourdoure 0
4769582 2286464 2286464 defendant Palmer Thomas chapman 595717 595717 Palmer, Thomas, of Walsyngham, Norf, chapman 3
4805251 2297843 2297843 defendant Morlee John merchant 595717 595717 Morlee, John, of Walsyngham, Norf, merchant 0
4805253 2297844 2297844 defendant Morlee John merchant 595717 595717 Morlee, John, of Walsyngham, Norf, merchant 0
4883420 2321737 2321737 defendant Parker Nicholas taverner 595717 595717 Parker, Nicholas, of Walsyngham, Norf, taverner 1
4889043 2323363 2323363 defendant Parker Nicholas taverner 595717 595717 Parker, Nicholas, of Walsyngham, Norf, taverner 1
4927754 2335117 2335117 defendant Morlay William ostler 595717 595717 Morlay, William, of Walsyngham, Norf, ostler 2
4975340 2349582 2349582 defendant Whynne John husbandman 595717 595717 Whynne, John, of Walsyngham, Norf, husbandman 0
4975342 2349583 2349583 defendant Whynne John husbandman 595717 595717 Whynne, John, of Walsyngham, Norf, husbandman 0
5118848 2391946 2391946 defendant Spycer Nicholas spicer 595717 595717 Spycer, Nicholas, of Walsyngham, Norf, spicer 1
5118859 2391948 2391948 defendant Spycer Nicholas spicer 595717 595717 Spycer, Nicholas, of Walsyngham, Norf, spicer 1
5188772 2412445 2412445 defendant Gylys Robert chapman 595717 595717 Gylys, Robert, of Walsyngham, Norf, chapman 1
5228428 2423920 2423920 defendant Farewell Robert yeoman 595717 595717 Farewell, Robert, of Walsyngham, Norf, yeoman 0
5246213 2429052 2429052 defendant Spycer Nicholas spicer 595717 595717 Spycer, Nicholas, of Walsyngham, Norf, spicer 1
5268080 2435781 2435781 defendant Haryngton Thomas yeoman 595717 595717 Haryngton, Thomas, of Walsyngham, Norf, yeoman 0
5270205 2436383 2436383 defendant Osbern (illegible) gent 595717 595717 Osbern, ---, of Walsyngham, Norf, gent 4
5284231 2440408 2440408 defendant Colles Bartholomew mercer 595717 595717 Colles, Bartholomew, of Walsyngham, Norf, mercer 0
5288418 2441631 2441631 defendant Geddyng Godfrey husbandman 595717 595717 Geddyng, Godfrey, of Walsyngham, Norf, husbandman 3
5297915 2444398 2444398 defendant Denham Geoffrey mercer 595717 595717 Denham, Geoffrey, of Walsyngham, Norf, mercer 0
5302099 2445583 2445583 defendant Denham Geoffrey mercer 595717 595717 Denham, Geoffrey, of Walsyngham, Norf, mercer 0
5340553 2457242 2457242 defendant Warner Thomas chapman 595717 595717 Warner, Thomas, of Walsyngham, Norf, chapman 1
5447075 2489013 2489013 defendant Caudeler Nicholas yeoman 595717 595717 Caudeler, Nicholas, of Walsyngham, Norf, yeoman 0
5470522 2496103 2496103 defendant Myno William mercer 595717 595717 Myno, William, of Walsyngham, Norf, mercer 2
5481925 2499525 2499525 defendant Myne William mercer 595717 595717 Myne, William, of Walsyngham, Norf, mercer 2
5497969 2504338 2504338 defendant Matsall Thomas chapman 595717 595717 Matsall, Thomas, of Walsyngham, Norf, chapman 3
5509509 2507818 2507818 defendant Knefton Richard chandler 595717 595717 Knefton, Richard, of Walsyngham, Norf, chandler 1
5509519 2507819 2507819 defendant Knefton Richard chandler 595717 595717 Knefton, Richard, of Walsyngham, Norf, chandler 1
5510148 2508009 2508009 defendant Harvy Richard laborer 595717 595717 Harvy, Richard, of Walsyngham, Norf, laborer 0
5521690 2511599 2511599 defendant Drye James   595717 595717 Drye, James, of Walsyngham, Norf, innholder, at sign of the Bull 0
5531358 2514329 2514329 defendant Copynger Richard innholder 595717 595717 Copynger, Richard, of Walsyngham, Norf, innholder 0
5533405 2514999 2514999 defendant Sheryngham Edmund yeoman 595717 595717 Sheryngham, Edmund, of Walsyngham, Norf, yeoman 0
5535135 2515517 2515517 defendant Goddyng Edward yeoman 595717 595717 Goddyng, Edward, of Walsyngham, Norf, yeoman 2
5581797 2529382 2529382 defendant Copynger Richard innholder 595717 595717 Copynger, Richard, of Walsyngham, Norf, innholder 0
5581799 2529383 2529383 defendant Copynger Richard innholder 595717 595717 Copynger, Richard, of Walsyngham, Norf, innholder 0
5581801 2529384 2529384 defendant Drie James innholder 595717 595717 Drie, James, of Walsyngham, Norf, innholder 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);