names

46 rows where place_id = 621051

✎ 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
3739197 1938476 1938476 defendant Wylson Margaret widow 621051 621051 Wylson, Margaret, of Trowell, widow 1
3748716 1941528 1941528 defendant Wollamate Robert yeoman 621051 621051 Wollamate, Robert, of Trowell, yeoman 0
3749984 1941914 1941914 defendant Waterhowse Percival husbandman 621051 621051 Waterhowse, Percival, of Trowell, husbandman 0
3749985 1941914 1941914 defendant Waterhowse Emmot singlewoman 621051 621051 Waterhowse, Emmot, of Trowell, singlewoman 1
3771312 1948718 1948718 defendant Padeley Richard clerk 621051 621051 Padeley, Richard, of Trowell, clerk 0
3771314 1948719 1948719 defendant Padley Richard clerk 621051 621051 Padley, Richard, of Trowell, clerk 0
3937605 2002908 2002908 defendant Wright Richard butcher 621051 621051 Wright, Richard, of Trowell, butcher 6
4099882 2060282 2060282 defendant Eaton William husbandman 621051 621051 Eaton, William, of Trowell, husbandman 0
4099883 2060282 2060282 defendant Slacke Thomas clerk 621051 621051 Slacke, Thomas, of Trowell, clerk 1
4221351 2102967 2102967 defendant Lacye Christopher husbandman 621051 621051 Lacye, Christopher, of Trowell, husbandman 0
4279335 2122698 2122698 defendant Brymesley Jervace gent 621051 621051 Brymesley, Jervace, of Trowell, gent 1
4373560 2155611 2155611 defendant Towne or Toone Richard gent 621051 621051 Towne or Toone, Richard, of Trowell, gent 0
4379502 2157754 2157754 defendant Cowper Robert husbandman 621051 621051 Cowper, Robert, of Trowell, husbandman 0
4379503 2157754 2157754 defendant Sneythe Nicholas husbandman 621051 621051 together with Sneythe, Nicholas, of Trowell, husbandman 1
4387177 2160364 2160364 defendant Tone Richard yeoman 621051 621051 Tone, Richard, of Trowell, yeoman 0
4531950 2210259 2210259 defendant Milner Robert   621051 621051 Milner, Robert, of Trowell 0
4583420 2226234 2226234 defendant Mason Thomas   621051 621051 Mason, Thomas, of Trowell 0
4607305 2233396 2233396 defendant Smyth Adam   621051 621051 Smyth, Adam, of Trowell 0
4730310 2274679 2274679 defendant Pirie Roger butcher 621051 621051 Pirie, Roger, of Trowell, butcher 1
4750521 2280635 2280635 defendant Belleshore Thomas husbandman 621051 621051 Belleshore, Thomas, of Trowell, husbandman 0
4751985 2281075 2281075 defendant Burnet William yeoman 621051 621051 Burnet, William, of Trowell, yeoman 0
4770587 2286779 2286779 defendant Smert John   621051 621051 Smert, John, of Trowell, mason 0
4772951 2287511 2287511 defendant Hawesok Robert   621051 621051 Hawesok, Robert, of Trowell, mason 3
4861848 2315083 2315083 defendant Metam Richard husbandman 621051 621051 Metam, Richard, of Trowell, husbandman 0
4872966 2318502 2318502 defendant Repton John yeoman 621051 621051 Repton, John, of Trowell, yeoman 0
4978096 2350413 2350413 defendant Shawe John yeoman 621051 621051 Shawe, John, of Trowell, yeoman 0
4978097 2350413 2350413 defendant Awesok Robert yeoman 621051 621051 Awesok, Robert, of Trowell, yeoman 1
4978098 2350413 2350413 defendant Bramcote John laborer 621051 621051 Bramcote, John, of Trowell, laborer 2
4978099 2350413 2350413 defendant Bardall John weaver 621051 621051 Bardall, John, of Trowell, weaver 3
4978100 2350413 2350413 defendant Smyth Robert husbandman 621051 621051 Smyth, Robert, of Trowell, husbandman 4
4992393 2354611 2354611 defendant Shawe John   621051 621051 Shawe, John, of Trowell 0
5066913 2376629 2376629 defendant Raulyn William husbandman 621051 621051 Raulyn, William, of Trowell, husbandman 1
5094906 2384925 2384925 defendant Blyborowe Robert laborer 621051 621051 Blyborowe, Robert, of Trowell, laborer 1
5403106 2475971 2475971 defendant Parker Richard yeoman 621051 621051 Parker, Richard, of Trowell, yeoman 2
5403120 2475974 2475974 defendant George Thomas carrier 621051 621051 George, Thomas, of Trowell, carrier 0
5416137 2479757 2479757 defendant Parker Richard yeoman 621051 621051 Parker, Richard, of Trowell, yeoman 2
5431300 2484309 2484309 defendant George Thomas husbandman 621051 621051 George, Thomas, of Trowell, husbandman 0
5432814 2484782 2484782 defendant George Thomas carrier 621051 621051 George, Thomas, of Trowell, carrier 0
5432825 2484784 2484784 defendant George Thomas carrier 621051 621051 George, Thomas, of Trowell, carrier 0
5432866 2484796 2484796 defendant Parker Richard yeoman 621051 621051 Parker, Richard, of Trowell, yeoman 2
5484156 2500190 2500190 defendant Branston Thomas yeoman 621051 621051 Branston, Thomas, of Trowell, yeoman 4
5484162 2500191 2500191 defendant Branston Thomas yeoman 621051 621051 Branston, Thomas, of Trowell, yeoman 4
5492088 2502545 2502545 defendant Parker Richard yeoman 621051 621051 Parker, Richard, of Trowell, yeoman 1
5492094 2502546 2502546 defendant Parker Richard yeoman 621051 621051 Parker, Richard, of Trowell, yeoman 1
5597874 2534234 2534234 defendant Kirkby John husbandman 621051 621051 Kirkby, John, of Trowell, husbandman 0
5599015 2534574 2534574 defendant Grey Henry, junior gent 621051 621051 Grey, Henry, junior, of Trowell, gent 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);