names

58 rows where place_id = 646398

✎ 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
3890665 1987143 1987143 defendant Blowdon Thomas innholder 646398 646398 Blowdon, Thomas, of Yevelchester, innholder 0
4089014 2056368 2056368 defendant Bonnynge Robert husbandman 646398 646398 Bonnynge, Robert, of Yevelchester, husbandman 0
4089017 2056368 2056368 defendant Tayler John yeoman 646398 646398 Tayler, John, of Yevelchester, yeoman 3
4131293 2071512 2071512 defendant Bonnynge Robert glover 646398 646398 Bonnynge, Robert, of Yevelchester, glover 1
4131294 2071512 2071512 defendant Belly Thomas carrier 646398 646398 Belly, Thomas, of Yevelchester, carrier 2
4138421 2074106 2074106 defendant Fathers John   646398 646398 Fathers, John, of Yevelchester, linen draper 0
4147097 2077128 2077128 defendant Fathers John   646398 646398 Fathers, John, of Yevelchester, linen draper 0
4155052 2079858 2079858 defendant Bonnyng Robert glover 646398 646398 Bonnyng, Robert, of Yevelchester, glover 1
4162973 2082583 2082583 defendant Fathers John   646398 646398 Fathers, John, of Yevelchester, linen draper 0
4238280 2108999 2108999 defendant Keylwaye John yeoman 646398 646398 Keylwaye, John, of Yevelchester, or of Weston Bampfilde, Soms, yeoman 0
4259762 2116236 2116236 defendant Keillway John yeoman 646398 646398 Keillway, John, of Yevelchester, or of Weston Bampfilde, Soms, yeoman 0
4310721 2133894 2133894 defendant Fathers John mercer 646398 646398 Fathers, John, of Yevelchester, mercer 0
4345040 2145540 2145540 defendant Bellye Edward yeoman 646398 646398 Bellye, Edward, of Yevelchester, yeoman 0
4357218 2149752 2149752 defendant Harrys Thomas draper 646398 646398 Harrys, Thomas, of Yevelchester, draper 0
4511422 2204014 2204014 defendant Bryce John   646398 646398 Bryce, John, of Yevelchester 1
4605829 2232936 2232936 defendant Bailly Henry   646398 646398 Bailly, Henry, of Yevelchester 0
4693517 2263475 2263475 defendant Deyer John fuller 646398 646398 Deyer, John, of Yevelchester, fuller 0
4694428 2263754 2263754 defendant Deyer John merchant 646398 646398 Deyer, John, of Yevelchester, merchant 3
4703011 2266324 2266324 defendant Bale Thomas butcher 646398 646398 Bale, Thomas, of Yevelchester, butcher 0
4703013 2266324 2266324 defendant Baker Thomas jailer 646398 646398 Baker, Thomas, of Yevelchester, jailer 2
4703262 2266398 2266398 defendant Baker Henry husbandman 646398 646398 Baker, Henry, of Yevelchester, husbandman 1
4704340 2266734 2266734 defendant Dole Richard husbandman 646398 646398 Dole, Richard, of Yevelchester, husbandman 2
4704341 2266734 2266734 defendant Folky Thomas husbandman 646398 646398 Folky, Thomas, of Yevelchester, husbandman 3
4711559 2268940 2268940 defendant Bale Thomas butcher 646398 646398 Bale, Thomas, of Yevelchester, butcher 4
4715654 2270224 2270224 defendant Baker Thomas yeoman 646398 646398 Baker, Thomas, of Yevelchester, yeoman 0
4843266 2309410 2309410 defendant Symkyns Christine widow 646398 646398 Symkyns, Christine, of Yevelchester, widow 3
5138270 2397701 2397701 defendant Veryng John yeoman 646398 646398 Veryng, John, of Yevelchester, yeoman 2
5138271 2397701 2397701 defendant Broune John   646398 646398 Broune, John, of Yevelchester, groom 3
5143001 2399077 2399077 defendant Veryng John yeoman 646398 646398 Veryng, John, of Yevelchester, yeoman 2
5143002 2399077 2399077 defendant Broune John   646398 646398 Broune, John, of Yevelchester, groom 3
5143003 2399077 2399077 defendant Waorsley John   646398 646398 Waorsley, John, of Yevelchester, groom 4
5153510 2402182 2402182 defendant Veryng Thomas husbandman 646398 646398 Veryng, Thomas, of Yevelchester, husbandman 0
5153512 2402182 2402182 defendant Philpot John husbandman 646398 646398 together with Philpot, John, of Yevelchester, husbandman 2
5159071 2403767 2403767 defendant Veryng John yeoman 646398 646398 Veryng, John, of Yevelchester, yeoman 2
5159072 2403767 2403767 defendant Broune John   646398 646398 Broune, John, of Yevelchester, groom 3
5159073 2403767 2403767 defendant Worsley John   646398 646398 Worsley, John, of Yevelchester, groom 4
5159077 2403768 2403768 defendant Veryng John yeoman 646398 646398 Veryng, John, of Yevelchester, yeoman 2
5159078 2403768 2403768 defendant worseley John   646398 646398 worseley, John, of Yevelchester, groom 3
5162161 2404667 2404667 defendant Balsam William gent 646398 646398 Balsam, William, of Yevelchester, gent 1
5162163 2404667 2404667 defendant Smyth William smith 646398 646398 Smyth, William, of Yevelchester, smith 3
5162164 2404667 2404667 defendant Yatcombe Walter husbandman 646398 646398 Yatcombe, Walter, of Yevelchester, husbandman 4
5164399 2405320 2405320 defendant Veryng John yeoman 646398 646398 Veryng, John, of Yevelchester, yeoman 2
5164400 2405320 2405320 defendant Broune John   646398 646398 Broune, John, of Yevelchester, groom 3
5164401 2405320 2405320 defendant Worsley John   646398 646398 Worsley, John, of Yevelchester, groom 4
5176350 2408772 2408772 defendant Balsham William gent 646398 646398 Balsham, William, of Yevelchester, gent 1
5176352 2408772 2408772 defendant Smyth William smith 646398 646398 Smyth, William, of Yevelchester, smith 3
5176353 2408772 2408772 defendant Yatcombe Walter husbandman 646398 646398 Yatcombe, Walter, of Yevelchester, husbandman 4
5210498 2418804 2418804 defendant Balsham William gent 646398 646398 Balsham, William, of Yevelchester, gent 1
5218902 2421253 2421253 defendant Trewelove Walter husbandman 646398 646398 Trewelove, Walter, of Yevelchester, husbandman 0
5239506 2427138 2427138 defendant Baker Thomas baker 646398 646398 Baker, Thomas, of Yevelchester, baker 4
5325400 2452683 2452683 defendant Berdon Peter yeoman 646398 646398 Berdon, Peter, of Yevelchester, yeoman 1
5421218 2481278 2481278 defendant Walford John yeoman 646398 646398 Walford, John, of Yevelchester, yeoman 1
5421220 2481279 2481279 defendant Walford John yeoman 646398 646398 Walford, John, of Yevelchester, yeoman 0
5440435 2487042 2487042 defendant Walford John yeoman 646398 646398 Walford, John, of Yevelchester, yeoman 0
5440442 2487045 2487045 defendant Walford (illegible) yeoman 646398 646398 Walford, _, of Yevelchester, yeoman 0
5486643 2500902 2500902 defendant Paxe Thomas smith 646398 646398 Paxe, Thomas, of yevelchester, smith 1
5518586 2510645 2510645 defendant Roper John roper 646398 646398 Roper, John, of Yevelchester, roper 0
5602570 2535699 2535699 defendant Wynsham Thomas yeoman 646398 646398 Wynsham, Thomas, of Yevelchester, yeoman 6

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