names

66 rows where place_id = 592325

✎ 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
3607344 1869957 1869957 defendant Scroger John tailor 592325 592325 Scroger, John, of Blytheburgh, tailor 3
3622517 1874579 1874579 defendant Hapton William   592325 592325 Hapton, William, of Blytheburgh 1
3622717 1874633 1874633 defendant Filpote Thomas mercer 592325 592325 Filpote, Thomas, of Blytheburgh, mercer 2
3637609 1906573 1906573 defendant Botwright Robert draper 592325 592325 Botwright, Robert, of Blytheburgh, draper 0
3637610 1906573 1906573 defendant Carver John baker 592325 592325 Carver, John, of Blytheburgh, baker 1
3664764 1914927 1914927 defendant Rede William   592325 592325 Rede, William, of Blytheburgh, "graver" 0
3764681 1946616 1946616 defendant Hapton John painter 592325 592325 Hapton, John, of Blytheburgh, painter 0
3764682 1946616 1946616 defendant Rede William carver 592325 592325 Rede, William, of Blytheburgh, carver 1
3863782 1978061 1978061 defendant Martyn Thomas butcher 592325 592325 Martyn, Thomas, of Blytheburgh, butcher 0
3878942 1983209 1983209 defendant Cappe Robert butcher 592325 592325 Cappe, Robert, of Blytheburgh, butcher 0
3878943 1983209 1983209 defendant Dandy John butcher 592325 592325 Dandy, John, of Blytheburgh, butcher 1
3891439 1987404 1987404 defendant Lawghter Robert yeoman 592325 592325 Lawghter, Robert, of Blytheburgh, yeoman 0
3891440 1987405 1987405 plaintiff Lawghter Robert yeoman 592325 592325 Lawghter, Robert, of Blytheburgh, yeoman 0
3894243 1988292 1988292 defendant Cappe Robert butcher 592325 592325 Cappe, Robert, of Blytheburgh, butcher 0
3905643 1992160 1992160 plaintiff Laughter Robert yeoman 592325 592325 Laughter, Robert, of Blytheburgh, yeoman 0
3905644 1992160 1992160 defendant Martyne Thomas butcher 592325 592325 Martyne, Thomas, of Blytheburgh, butcher 0
3905645 1992160 1992160 defendant Bennys Edward husbandman 592325 592325 Bennys, Edward, of Blytheburgh, husbandman 1
3905646 1992160 1992160 defendant Botwryght John husbandman 592325 592325 Botwryght, John, of Blytheburgh, husbandman 2
3905683 1992176 1992176 plaintiff Lawhter Robert yeoman 592325 592325 Lawhter, Robert, of Blytheburgh, yeoman 0
4019801 2031812 2031812 defendant Pycknett Robert yeoman 592325 592325 Pycknett, Robert, of Blytheburgh, yeoman 0
4521162 2206956 2206956 plaintiff Furbisshour John   592325 592325 Furbisshour, John, of Blytheburgh 0
4521166 2206958 2206958 plaintiff Furbysshour John   592325 592325 Furbysshour, John, of Blytheburgh 0
4617134 2236367 2236367 plaintiff Greyve John   592325 592325 Greyve, John, of Blytheburgh 1
4907601 2328942 2328942 defendant Smyth Ralph dyer 592325 592325 Smyth, Ralph, of Blytheburgh, dyer 1
4935981 2337652 2337652 defendant Palmer John pedder 592325 592325 Palmer, John, of Blytheburgh, pedder 0
4945515 2340576 2340576 defendant Aleyn John glover 592325 592325 Aleyn, John, of Blytheburgh, glover 1
4945516 2340576 2340576 defendant Taillour John, junior yeoman 592325 592325 Taillour, John, junior, of Blytheburgh, yeoman 2
4945517 2340576 2340576 defendant Baker Ralph baker 592325 592325 Baker, Ralph, of Blytheburgh, baker 3
4945518 2340576 2340576 defendant Scot John baker 592325 592325 Scot, John, of Blytheburgh, baker 4
4949387 2341795 2341795 defendant Segore John butcher 592325 592325 Segore, John, of Blytheburgh, butcher 0
4957355 2344162 2344162 defendant Derehawe Richard dyer 592325 592325 Derehawe, Richard, of Blytheburgh, dyer 1
5007131 2358974 2358974 plaintiff Smyth Thomas   592325 592325 Smyth, Thomas, of Blytheburgh 0
5008671 2359428 2359428 defendant Tomson Walter husbandman 592325 592325 Tomson, Walter, of Blytheburgh, husbandman 0
5025597 2364394 2364394 defendant Wymond John, senior butcher 592325 592325 Wymond, John, senior, of Blytheburgh, butcher 0
5036128 2367420 2367420 defendant Stapylton Simon turner 592325 592325 Stapylton, Simon, of Blytheburgh, turner 0
5044773 2370072 2370072 defendant Mason William husbandman 592325 592325 Mason, William, of Blytheburgh, husbandman 0
5051407 2372037 2372037 defendant Wymond John butcher 592325 592325 Wymond, John, of Blytheburgh, butcher 2
5056938 2373651 2373651 defendant Deerhawe Robert dyer 592325 592325 Deerhawe, Robert, of Blytheburgh, dyer 0
5069026 2377235 2377235 plaintiff Pyn Robert   592325 592325 Pyn, Robert, of Blytheburgh 0
5074644 2378918 2378918 defendant Rassetald Nicholas barber 592325 592325 Rassetald, Nicholas, of Blytheburgh, barber 0
5077604 2379798 2379798 defendant Wodecok William barber 592325 592325 Wodecok, William, of Blytheburgh, barber 0
5082485 2381262 2381262 defendant Wodecok William chandler 592325 592325 Wodecok, William, of Blytheburgh, chandler 0
5102777 2387230 2387230 defendant Wodecok William barber 592325 592325 Wodecok, William, of Blytheburgh, barber 0
5228107 2423827 2423827 defendant Hynby William yeoman 592325 592325 Hynby, William, of Blytheburgh, yeoman 0
5257811 2432562 2432562 defendant Whyot William carver 592325 592325 Whyot, William, of Blytheburgh, carver 0
5264185 2434557 2434557 defendant Scuttyng William yeoman 592325 592325 Scuttyng, William, of Blytheburgh, yeoman 0
5269260 2436112 2436112 defendant Stapilton Simon yeoman 592325 592325 Stapilton, Simon, of Blytheburgh, yeoman 4
5286637 2441103 2441103 plaintiff Hoo John   592325 592325 Hoo, John, of Blytheburgh 0
5293830 2443161 2443161 defendant Wyot William carpenter 592325 592325 Wyot, William, of Blytheburgh, carpenter 0
5293831 2443161 2443161 defendant Wyot John carpenter 592325 592325 Wyot, John, of Blytheburgh, carpenter 1
5308347 2447531 2447531 plaintiff (not given) John prior of Sampton 592325 592325 Sampton, John, of Blytheburgh, prior of the church of the BM 0
5324465 2452403 2452403 defendant Broun Thomas tailor 592325 592325 Broun, Thomas, of Blytheburgh, tailor 0
5329138 2453791 2453791 defendant Stapylton Simon husbandman 592325 592325 Stapylton, Simon, of Blytheburgh, husbandman 7
5337285 2456223 2456223 plaintiff Hoo John   592325 592325 Hoo, John, of Blytheburgh 1
5366904 2465299 2465299 defendant Payn William yeoman 592325 592325 Payn, William, of Blytheburgh, yeoman 0
5375650 2467976 2467976 defendant Genne Richard chapman 592325 592325 Genne, Richard, of Blytheburgh, chapman 0
5375651 2467976 2467976 defendant Fylpot Thomas mercer 592325 592325 Fylpot, Thomas, of Blytheburgh, mercer 1
5382639 2470092 2470092 defendant Wardeyn John   592325 592325 Wardeyn, John, of Blytheburgh, mason 2
5392647 2472962 2472962 defendant Wardeyn John   592325 592325 Wardeyn, John, of Blytheburgh, mason 2
5405704 2476706 2476706 defendant Wardeyn John   592325 592325 Wardeyn, John, of Blytheburgh, mason 2
5418735 2480527 2480527 defendant Wardeyn (illegible)   592325 592325 Wardeyn, _, of Blytheburgh, mason 2
5558493 2522431 2522431 defendant Stotte John smith 592325 592325 Stotte, John, of Blytheburgh, smith 2
5566172 2524702 2524702 defendant Waryn John yeoman 592325 592325 Waryn, John, of Blytheburgh, yeoman 0
5605481 2536595 2536595 defendant Boweryght Robert draper 592325 592325 Boweryght, Robert, of Blytheburgh, draper 0
5605482 2536595 2536595 defendant Beket William yeoman 592325 592325 Beket, William, of Blytheburgh, yeoman 1
5605483 2536595 2536595 defendant Carver John baker 592325 592325 Carver, John, of Blytheburgh, baker 2

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);