names

76 rows where place_id = 602462

✎ 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
3650246 1910448 1910448 defendant Harres Nicholas yeoman 602462 602462 Harres, Nicholas, of Haveryng, yeoman 0
3768966 1947946 1947946 defendant Goldan John laborer 602462 602462 Goldan, John, of Haveryng, laborer 1
3797039 1956954 1956954 defendant Turke John husbandman 602462 602462 Turke, John, of Haveryng at Bower, husbandman 0
3797040 1956954 1956954 defendant Skeyll John husbandman 602462 602462 Skeyll, John, of Haveryng at Bower, husbandman 1
3799632 1957808 1957808 defendant Holand John yeoman 602462 602462 Holand, John, of Haveryng at Bower, yeoman 0
3812123 1961703 1961703 defendant Brewer John tanner 602462 602462 Brewer, John, of Haveryng at Bower, tanner 0
4433688 2175302 2175302 defendant Heyward William de   602462 602462 Heyward, William de, of Haveryng, son of John 0
4461856 2188774 2188774 defendant Gaal John   602462 602462 Gaal, John, of Haveryng 0
4469444 2191106 2191106 plaintiff Bokyngham John   602462 602462 Bokyngham, John, of Haveryng 0
4472232 2191983 2191983 defendant Howe John   602462 602462 Howe, John, of Haveryng 1
4498486 2200173 2200173 defendant Heyward Nicholas   602462 602462 Heyward, Nicholas, of Haveryng 1
4521472 2207058 2207058 defendant Stanstede Robert powder maker 602462 602462 Stanstede, Robert, of Haveryng, powder maker 2
4537342 2211948 2211948 defendant Wryght John   602462 602462 Wryght, John, of Haveryng 0
4545024 2214364 2214364 defendant Whytlok John, sen   602462 602462 Whytlok, John, sen, of Haveryng 2
4561108 2219429 2219429 defendant Swan Richard   602462 602462 Swan, Richard, of Haveryng 2
4633101 2241220 2241220 defendant Smyth John   602462 602462 Smyth, John, of Haveryng 0
4649780 2245960 2245960 defendant Smyth Thomas   602462 602462 Smyth, Thomas, of Haveryng 0
4661908 2249571 2249571 defendant Berdefeld John tanner 602462 602462 Berdefeld, John, of Haveryng, tanner 0
4664289 2250313 2250313 defendant Mirable John husbandman 602462 602462 Mirable, John, of Haveryng, husbandman 0
4694537 2263787 2263787 defendant Broket Hugh husbandman 602462 602462 Broket, Hugh, of Haveryng, husbandman 2
4719253 2271368 2271368 plaintiff Berneman Adam   602462 602462 Berneman, Adam, of Haveryng 0
4735841 2276358 2276358 defendant Role Thomas yeoman 602462 602462 Role, Thomas, of Haveryng, yeoman 0
4735843 2276359 2276359 defendant Role Thomas yeoman 602462 602462 Role, Thomas, of Haveryng, yeoman 0
4746465 2279457 2279457 defendant Marschall John, junior husbandman 602462 602462 Marschall, John, junior, of Haveryng, husbandman 2
4793480 2294070 2294070 defendant Caps Nicholas husbandman 602462 602462 Caps, Nicholas, of Haveryng, husbandman 0
4793482 2294070 2294070 defendant Marchall John, junior collier 602462 602462 Marchall, John, junior, of Haveryng, collier 2
4793483 2294070 2294070 defendant Blythe John laborer 602462 602462 Blythe, John, of Haveryng, laborer 3
4862313 2315222 2315222 defendant Cokermouth William yeoman 602462 602462 Cokermouth, William, of Haveryng, yeoman 0
4862314 2315222 2315222 defendant Holwell John husbandman 602462 602462 Holwell, John, of Haveryng, husbandman 1
4862315 2315222 2315222 defendant Romayn Robert husbandman 602462 602462 Romayn, Robert, of Haveryng, husbandman 2
4862316 2315222 2315222 defendant Peiot or Perot John husbandman 602462 602462 Peiot or Perot, John, of Haveryng, husbandman 3
4862318 2315223 2315223 defendant Cokermouth William yeoman 602462 602462 Cokermouth, William, of Haveryng, yeoman 0
4862319 2315223 2315223 defendant Holwell John husbandman 602462 602462 Holwell, John, of Haveryng, husbandman 1
4862320 2315223 2315223 defendant Romayn Robert husbandman 602462 602462 Romayn, Robert, of Haveryng, husbandman 2
4862321 2315223 2315223 defendant Perot John husbandman 602462 602462 Perot, John, of Haveryng, husbandman 3
4897072 2325739 2325739 defendant Holwell John husbandman 602462 602462 Holwell, John, of Haveryng, husbandman 0
4902149 2327283 2327283 plaintiff Quilter John   602462 602462 Quilter, John, of Haveryng 0
4925907 2334533 2334533 defendant Wolff John yeoman 602462 602462 Wolff, John, of Haveryng, yeoman 1
4940314 2338993 2338993 defendant Rothyng William husbandman 602462 602462 Rothyng, William, of Haveryng, husbandman 1
4947524 2341219 2341219 defendant Berneman John husbandman 602462 602462 Berneman, John, of Haveryng, husbandman 0
4990042 2353932 2353932 defendant Lenyng John husbandman 602462 602462 Lenyng, John, of Haveryng atte Bower, husbandman 1
5002887 2357749 2357749 defendant Wyche Richard clerk 602462 602462 Wyche, Richard, of Haveryng atte Bower, clerk 0
5044627 2370024 2370024 defendant --are John husbandman 602462 602462 --are, John, of Haveryng atte Bower, husbandman 0
5083912 2381691 2381691 defendant Cappes John, senior collier 602462 602462 Cappes, John, senior, of Haveryng, collier 0
5104523 2387753 2387753 plaintiff Cappes Thomas   602462 602462 Cappes, Thomas, of Haveryng 0
5125646 2393989 2393989 defendant Auger William husbandman 602462 602462 Auger, William, of Haveryng, husbandman 4
5128019 2394672 2394672 defendant Brock John tanner 602462 602462 Brock, John, of Haveryng, tanner 1
5128020 2394672 2394672 defendant Person Richard husbandman 602462 602462 Person, Richard, of Haveryng, husbandman 2
5128021 2394672 2394672 defendant Fowlere Richard smith 602462 602462 Fowlere, Richard, of Haveryng, smith 3
5139499 2398038 2398038 defendant Hewet James butcher 602462 602462 Hewet, James, of Haveryng atte Bower, butcher 2
5142830 2399031 2399031 defendant Dreywode William husbandman 602462 602462 Dreywode, William, of Haveryng, husbandman 1
5144275 2399480 2399480 defendant Neweman Thomas, sen (legal representative) 602462 602462 Neweman, Thomas, sen, of Haveryng, executors of 1
5144278 2399480 2399480 defendant Angor William, sen   602462 602462 Angor, William, sen, of Haveryng 4
5147100 2400290 2400290 defendant Brook John tanner 602462 602462 Brook, John, of Haveryng, tanner 1
5147101 2400290 2400290 defendant Person Richard husbandman 602462 602462 Person, Richard, of Haveryng, husbandman 2
5147102 2400290 2400290 defendant Fowlere Richard smith 602462 602462 Fowlere, Richard, of Haveryng, smith 3
5147104 2400291 2400291 defendant Wylott Stephen husbandman 602462 602462 Wylott, Stephen, of Haveryng, husbandman 0
5147105 2400291 2400291 defendant Brook John tanner 602462 602462 Brook, John, of Haveryng, tanner 1
5147106 2400291 2400291 defendant Person Richard husbandman 602462 602462 Person, Richard, of Haveryng, husbandman 2
5147107 2400291 2400291 defendant Fowlere Richard smith 602462 602462 Fowlere, Richard, of Haveryng, smith 3
5158134 2403497 2403497 defendant Hierde Thomas yeoman 602462 602462 Hierde, Thomas, of Haveryng, yeoman 0
5164187 2405265 2405265 defendant Drywode William husbandman 602462 602462 Drywode, William, of Haveryng, husbandman 1
5165078 2405531 2405531 defendant Hierde Thomas yeoman 602462 602462 Hierde, Thomas, of Haveryng, yeoman 0
5180988 2410178 2410178 defendant Halle William husbandman 602462 602462 Halle, William, of Haveryng, husbandman 3
5180994 2410179 2410179 defendant Halle William husbandman 602462 602462 Halle, William, of Haveryng, husbandman 3
5193930 2413954 2413954 defendant Heerde Thomas yeoman 602462 602462 Heerde, Thomas, of Haveryng, yeoman 0
5202704 2416554 2416554 defendant Halle William husbandman 602462 602462 Halle, William, of Haveryng, husbandman 3
5215715 2420320 2420320 defendant Hawkyn John husbandman 602462 602462 Hawkyn, John, of Haveryng, husbandman 0
5235457 2425948 2425948 defendant Legatte John, junior yeoman 602462 602462 Legatte, John, junior, of Haveryng, yeoman 1
5235458 2425948 2425948 defendant Wattis John husbandman 602462 602462 Wattis, John, of Haveryng, husbandman 2
5291945 2442651 2442651 plaintiff Raynold John yeoman 602462 602462 Raynold, John, of Haveryng, yeoman 0
5378137 2468740 2468740 plaintiff Thursby William tailor 602462 602462 Thursby, William, of Haveryng atte Bower, tailor 0
5485882 2500670 2500670 plaintiff Reed Roger (legal representative) 602462 602462 Reed, Roger, of Haveryng, executors of 0
5485896 2500673 2500673 plaintiff Reede Roger (legal representative) 602462 602462 Reede, Roger, of Haveryng, executors of 0
5507049 2507113 2507113 plaintiff Collyngham John (legal representative) 602462 602462 Collyngham, John, of Haveryng at Bower, executor of 0
5510378 2508086 2508086 defendant Middelton Thomas yeoman 602462 602462 Middelton, Thomas, of Haveryng, yeoman 1

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