names

116 rows where place_id = 654047

✎ 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
3930798 2000646 2000646 defendant Stevenson Thomas yeoman 654047 654047 Stevenson, Thomas, of Penrith, yeoman 2
3933988 2001668 2001668 defendant Mylner Cuthbert chapman 654047 654047 Mylner, Cuthbert, of Penrith, chapman 1
3933989 2001668 2001668 defendant Fassell Thomas chapman 654047 654047 Fassell, Thomas, of Penrith, chapman 2
3933990 2001668 2001668 defendant Jakinson Richard chapman 654047 654047 Jakinson, Richard, of Penrith, chapman 3
4311284 2134093 2134093 defendant Vayle Ellen widow 654047 654047 Vayle, Ellen, of Penrith, widow 3
4315221 2135440 2135440 defendant Robinson Anthony yeoman 654047 654047 Robinson, Anthony, of Penrith, Cumber, yeoman 0
4446645 2183868 2183868 defendant Crokewath Robert   654047 654047 Crokewath, Robert, of Penrith 0
4459925 2188161 2188161 plaintiff Scot Nicholas   654047 654047 Scot, Nicholas, of Penrith, on his own account 0
4466990 2190346 2190346 plaintiff Atkynson John   654047 654047 Atkynson, John, of Penrith 0
4474153 2192569 2192569 plaintiff del Wardrop William   654047 654047 del Wardrop, William, of Penrith 0
4479136 2194133 2194133 defendant Forster John   654047 654047 Forster, John, of Penrith 0
4479384 2194204 2194204 defendant Scot John   654047 654047 Scot, John, of Penrith 0
4510673 2203795 2203795 defendant Bristowe John de shoemaker 654047 654047 Bristowe, John de, of Penrith, shoemaker 0
4515849 2205378 2205378 defendant del More John   654047 654047 del More, John, of Penrith 0
4515850 2205378 2205378 defendant Bristowe Richard de   654047 654047 Bristowe, Richard de, of Penrith 1
4515851 2205378 2205378 defendant Bristowe John de   654047 654047 Bristowe, John de, of Penrith 2
4515852 2205378 2205378 defendant Michelman John   654047 654047 Michelman, John, of Penrith 3
4515855 2205379 2205379 defendant Plumber John   654047 654047 Plumber, John, of Penrith 0
4515856 2205379 2205379 defendant Stevenson John   654047 654047 Stevenson, John, of Penrith 1
4517289 2205808 2205808 defendant Scot John   654047 654047 Scot, John, of Penrith 0
4521730 2207129 2207129 defendant Baxster John   654047 654047 Baxster, John, of Penrith 0
4538188 2212230 2212230 defendant Bristawe Richard   654047 654047 Bristawe, Richard, of Penrith 0
4543024 2213708 2213708 plaintiff Arlosshe John de   654047 654047 Arlosshe, John de, of Penrith 0
4543026 2213709 2213709 plaintiff Arlosshe John de   654047 654047 Arlosshe, John de, of Penrith 0
4550678 2216156 2216156 defendant Barbour William   654047 654047 Barbour, William, of Penrith 0
4562383 2219794 2219794 defendant Glover John shoemaker 654047 654047 Glover, John, of Penrith, shoemaker 0
4563510 2220162 2220162 defendant T_ John   654047 654047 T_, John, of Penrith 0
4570063 2222209 2222209 defendant Holme John   654047 654047 Holme, John, of Penrith 0
4571849 2222780 2222780 plaintiff Arlossh John de   654047 654047 Arlossh, John de, of Penrith 0
4572401 2222908 2222908 plaintiff Atkynson John   654047 654047 Atkynson, John, of Penrith 0
4572403 2222908 2222908 defendant Arlos William de   654047 654047 Arlos, William de, of Penrith 1
4572404 2222908 2222908 defendant Baxter John   654047 654047 Baxter, John, of Penrith 2
4580894 2225506 2225506 plaintiff Huton Thomas de   654047 654047 (Huton, Thomas de, of Penrith 1
4586322 2227136 2227136 defendant Arlossh William   654047 654047 Arlossh, William, of Penrith 1
4590851 2228488 2228488 defendant Pakman Edward   654047 654047 Pakman, Edward, of Penrith 1
4605264 2232812 2232812 defendant Saundreson John   654047 654047 Saundreson, John, of Penrith 6
4608534 2233776 2233776 defendant Wyresdale John   654047 654047 Wyresdale, John, of Penrith 1
4627389 2239504 2239504 defendant Scarlet John   654047 654047 Scarlet, John, of Penrith 1
4628801 2239936 2239936 defendant Scot John   654047 654047 Scot, John, of Penrith 0
4635843 2242051 2242051 plaintiff Arnaldson John   654047 654047 Arnaldson, John, of Penrith 0
4639649 2243110 2243110 defendant Arlasshe John   654047 654047 Arlasshe, John, of Penrith 2
4644050 2244358 2244358 plaintiff Litster William   654047 654047 Litster, William, of Penrith 0
4644051 2244358 2244358 defendant del Bank Richard   654047 654047 del Bank, Richard, of Penrith 0
4645037 2244620 2244620 defendant Wardrop William   654047 654047 Wardrop, William, of Penrith 6
4692398 2263139 2263139 defendant Penreth Thomas   654047 654047 Penreth, Thomas, of Penrith, shoe maker 0
4694685 2263833 2263833 defendant Birde William yeoman 654047 654047 together with Birde, William, of Penrith, yeoman 2
4696610 2264417 2264417 defendant Smythson Robert chapman 654047 654047 Smythson, Robert, of Penrith, chapman 1
4703108 2266349 2266349 plaintiff (not given) John vicar of Haukyn 654047 654047 Haukyn, John, of Penrith, vicar of the church 0
4706057 2267269 2267269 defendant del Halle William yeoman 654047 654047 del Halle, William, of Penrith, yeoman 0
4706058 2267269 2267269 defendant Neweton William husbandman 654047 654047 Neweton, William, of Penrith, husbandman 1
4715251 2270100 2270100 defendant Haxby John dyer 654047 654047 Haxby, John, of Penrith, dyer 0
4719785 2271535 2271535 plaintiff Bost Agnes   654047 654047 Bost, Agnes, of Penrith 0
4719789 2271535 2271535 defendant Dobson Robert husbandman 654047 654047 Dobson, Robert, of Penrith, husbandman 3
4719790 2271536 2271536 plaintiff Bost John (legal representative) 654047 654047 Bost, John, of Penrith, executors of 0
4719795 2271536 2271536 defendant Dokwra Rober slater 654047 654047 Dokwra, Rober, of Penrith, slater 1
4721280 2271987 2271987 plaintiff Hawkyn John   654047 654047 Hawkyn, John, of Penrith, vicar 5
4722221 2272275 2272275 defendant Smalham Robert tanner 654047 654047 Smalham, Robert, of Penrith, tanner 3
4722222 2272275 2272275 defendant Taillour Robert tailor 654047 654047 Taillour, Robert, of Penrith, tailor 4
4722246 2272278 2272278 defendant Wright William yeoman 654047 654047 Wright, William, of Penrith, yeoman 0
4723181 2272562 2272562 defendant Wilson John laborer 654047 654047 Wilson, John, of Penrith, laborer 1
4723185 2272562 2272562 defendant Hyneson William laborer 654047 654047 Hyneson, William, of Penrith, laborer 5
4723186 2272562 2272562 defendant Hyneson or Hyveson Hugh mercer 654047 654047 Hyneson or Hyveson, Hugh, of Penrith, mercer 6
4723187 2272562 2272562 defendant Jakson William slater 654047 654047 Jakson, William, of Penrith, slater 7
4723188 2272562 2272562 defendant Wrangwyse Robert mercer 654047 654047 Wrangwyse, Robert, of Penrith, mercer 8
4723189 2272562 2272562 defendant Alanson William mercer 654047 654047 Alanson, William, of Penrith, mercer 9
4724340 2272910 2272910 defendant Wardropp William yeoman 654047 654047 Wardropp, William, of Penrith, yeoman 3
4727106 2273739 2273739 plaintiff Hawkyn John   654047 654047 Hawkyn, John, of Penrith, vicar 0
4727107 2273739 2273739 defendant Bertram Thomas yeoman 654047 654047 Bertram, Thomas, of Penrith, yeoman 0
4728035 2274016 2274016 plaintiff Hoton Thomas de   654047 654047 Hoton, Thomas de, of Penrith 0
4729932 2274567 2274567 defendant Bryd William yeoman 654047 654047 Bryd, William, of Penrith, yeoman 2
4729938 2274570 2274570 defendant Chapell William yeoman 654047 654047 Chapell, William, of Penrith, yeoman 0
4729939 2274570 2274570 defendant Smyth Thomas smith 654047 654047 together with Smyth, Thomas, of Penrith, smith 1
4733901 2275786 2275786 defendant Ryton William de   654047 654047 Ryton, William de, of Penrith 3
4735693 2276311 2276311 defendant Hall William de la forester 654047 654047 Hall, William de la, of Penrith, forester 0
4738735 2277203 2277203 defendant Holme John fletcher 654047 654047 Holme, John, of Penrith, fletcher 0
4755050 2281965 2281965 defendant Wright Nicholas   654047 654047 Wright, Nicholas, of Penrith, wright 0
4755051 2281965 2281965 defendant Barker John tanner 654047 654047 Barker, John, of Penrith, tanner 1
4755054 2281966 2281966 defendant Jacson John butcher 654047 654047 Jacson, John, of Penrith, butcher 1
4755055 2281966 2281966 defendant Wardrop William mercer 654047 654047 Wardrop, William, of Penrith, mercer 2
4755056 2281966 2281966 defendant Kyd Thomas tailor 654047 654047 Kyd, Thomas, of Penrith, tailor 3
4755057 2281966 2281966 defendant Dobson Richard   654047 654047 Dobson, Richard, of Penrith, shepherd 4
4755060 2281967 2281967 defendant Chapman William carrier 654047 654047 Chapman, William, of Penrith, carrier 1
4755072 2281969 2281969 defendant Arlosshe John yeoman 654047 654047 Arlosshe, John, of Penrith, yeoman 0
4757233 2282634 2282634 defendant Ormesby John   654047 654047 Ormesby, John, of Penrith, shepherd 0
4758047 2282889 2282889 defendant Gryndon John tailor 654047 654047 Gryndon, John, of Penrith, tailor 0
4758554 2283053 2283053 defendant Garth John   654047 654047 Garth, John, of Penrith, shepherd 5
4758750 2283092 2283092 defendant Skynner William skinner 654047 654047 Skynner, William, of Penrith, skinner 0
4759749 2283390 2283390 defendant Bate Nicholas   654047 654047 Bate, Nicholas, of Penrith, mason 3
4760921 2283756 2283756 defendant Rowecliff Nicholas   654047 654047 Rowecliff, Nicholas, of Penrith, shoe maker 0
4768101 2285992 2285992 defendant Arlossh William yeoman 654047 654047 Arlossh, William, of Penrith, yeoman 0
4770194 2286650 2286650 defendant Thomson Richard laborer 654047 654047 Thomson, Richard, of Penrith, laborer 0
4803863 2297383 2297383 defendant Sleddell Richard chapman 654047 654047 Sleddell, Richard, of Penrith, chapman 3
4811550 2299721 2299721 defendant Stork John tailor 654047 654047 Stork, John, of Penrith, tailor 2
4812820 2300127 2300127 defendant Hoton Edmund   654047 654047 Hoton, Edmund, of Penrith, servant 1
4819214 2302090 2302090 defendant Adamson William husbandman 654047 654047 Adamson, William, of Penrith, husbandman 0
4829221 2305180 2305180 defendant Smyth John yeoman 654047 654047 Smyth, John, of Penrith, yeoman 4
4830527 2305571 2305571 defendant Kechyn William yeoman 654047 654047 Kechyn, William, of Penrith, yeoman 3
4840229 2308491 2308491 defendant Smythson Robert yeoman 654047 654047 Smythson, Robert, of Penrith, yeoman 0
4844241 2309705 2309705 defendant Botre William de yeoman 654047 654047 Botre, William de, of Penrith, yeoman 5
4871594 2318085 2318085 defendant de Botre William yeoman 654047 654047 de Botre, William, of Penrith, yeoman 5

Next page

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