names

41 rows where place_id = 604796

✎ 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
3659317 1913174 1913174 defendant Colyder William yeoman 604796 604796 Colyder, William, of Loddon, Norf, yeoman 0
3675781 1918458 1918458 defendant Galys James   604796 604796 Galys, James, of Loddon, Norf, woolen weaver 0
3681392 1920266 1920266 defendant Rokett Robert tanner 604796 604796 Rokett, Robert, of Loddon, Norf, tanner 0
3687525 1922279 1922279 defendant Hobard Walter esq 604796 604796 Hobard, Walter, of Loddon, Norf, esq 0
3858114 1976193 1976193 defendant Hobart Walter   604796 604796 Hobart, Walter, of Loddon, Norf, knight 0
3866545 1979040 1979040 defendant Ayed Robert chapman 604796 604796 Ayed, Robert, of Loddon, Norf, chapman 2
3866550 1979041 1979041 defendant Ayed Robert chapman 604796 604796 Ayed, Robert, of Loddon, Norf, chapman 2
3889461 1986706 1986706 defendant Wodward John yeoman 604796 604796 Wodward, John, of Loddon, Norf, yeoman 0
3901016 1990567 1990567 defendant Ade Robert mercer 604796 604796 Ade, Robert, of Loddon, Norf, mercer 1
3928041 1999712 1999712 defendant Graye Thomas yeoman 604796 604796 Graye, Thomas, of Loddon, Norf, yeoman 2
3935149 2002066 2002066 defendant Hobard Henry esq 604796 604796 Hobard, Henry, of Loddon, Norf, esq 0
3946002 2005678 2005678 defendant Ayde Joan widow 604796 604796 Ayde, Joan, of Loddon, Norf, widow 0
3946379 2005805 2005805 defendant Clerk Thomas (legal representative) 604796 604796 Clerk, Thomas, of Loddon, Norf, yeoman, executors of 0
3965654 2012602 2012602 defendant Barfote John husbandman 604796 604796 Barfote, John, of Loddon, Norf, husbandman 0
3965657 2012603 2012603 defendant Barfote John husbandman 604796 604796 Barfote, John, of Loddon, Norf, husbandman 0
3984189 2019111 2019111 defendant Coode John yeoman 604796 604796 Coode, John, of Loddon, Norf, yeoman 0
4137739 2073853 2073853 defendant Clarke John yeoman 604796 604796 Clarke, John, of Loddon, Norf, yeoman 0
4158786 2081147 2081147 defendant Clarke John yeoman 604796 604796 Clarke, John, of Loddon, Norf, yeoman 0
4192404 2092898 2092898 defendant Clarke John yeoman 604796 604796 Clarke, John, of Loddon, Norf, yeoman 1
4232303 2106804 2106804 defendant Aldriche Robert yeoman 604796 604796 Aldriche, Robert, of Loddon, Norf, yeoman 2
4233019 2107056 2107056 defendant Bamburghe or Bainburghe William gent 604796 604796 Bamburghe or Bainburghe, William, of Loddon, Norf, gent 0
4243142 2110698 2110698 defendant Weste Henry clerk 604796 604796 Weste, Henry, of Loddon, Norf, clerk 0
4243803 2110908 2110908 defendant Aldridge Robert yeoman 604796 604796 Aldridge, Robert, of Loddon, Norf, yeoman 1
4253460 2114149 2114149 defendant Westoe or Wescoe Henry clerk 604796 604796 Westoe or Wescoe, Henry, of Loddon, Norf, clerk 0
4254456 2114481 2114481 defendant Aldrydge Robert yeoman 604796 604796 Aldrydge, Robert, of Loddon, Norf, yeoman 1
4287104 2125442 2125442 defendant Aldrydge or Aldrich Robert yeoman 604796 604796 Aldrydge or Aldrich, Robert, of Loddon, Norf, yeoman 0
4303547 2131366 2131366 defendant Panner Thomas husbandman 604796 604796 Panner, Thomas, of Loddon, Norf, husbandman 2
4306018 2132244 2132244 defendant Wells Owen chapman 604796 604796 Wells, Owen, of Loddon, Norf, chapman 0
4319931 2137077 2137077 defendant Wells Owen chapman 604796 604796 Wells, Owen, of Loddon, Norf, chapman 0
5076280 2379406 2379406 defendant Godewyn John yeoman 604796 604796 Godewyn, John, of Loddon, Norf, yeoman 0
5104971 2387894 2387894 defendant Mossy William butcher 604796 604796 Mossy, William, of Loddon, Norf, butcher 0
5173758 2408020 2408020 defendant Ryston John yeoman 604796 604796 Ryston, John, of Loddon, Norf, yeoman 0
5186084 2411680 2411680 defendant Swete William husbandman 604796 604796 Swete, William, of Loddon, Norf, husbandman 3
5257820 2432566 2432566 defendant Cook Robert yeoman 604796 604796 Cook, Robert, of Loddon, Norf, yeoman 0
5281460 2439646 2439646 defendant Baron Richard laborer 604796 604796 Baron, Richard, of Loddon, Norf, laborer 1
5414918 2479395 2479395 defendant Johnson William butcher 604796 604796 Johnson, William, of Loddon, Norf, butcher 0
5417043 2480009 2480009 defendant Bradstok John   604796 604796 Bradstok, John, of Loddon, Norf 0
5430878 2484177 2484177 defendant Johnson William butcher 604796 604796 Johnson, William, of Loddon, Norf, butcher 0
5548370 2519557 2519557 defendant Holme William yeoman 604796 604796 Holme, William, of Loddon, Norf, yeoman 0
5548405 2519568 2519568 defendant Holme William yeoman 604796 604796 Holme, William, of Loddon, Norf, yeoman 0
5599040 2534585 2534585 defendant Mosse Andrew butcher 604796 604796 Mosse, Andrew, of Loddon, Norf, butcher 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);