names

68 rows where place_id = 593868

✎ 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
3609064 1870492 1870492 defendant Prudde William yeoman of the crown 593868 593868 Prudde, William, of Pole, Dorset, yeoman of the crown 4
3609105 1870505 1870505 defendant Prudde William yeoman of the crown 593868 593868 Prudde, William, of Pole, Dorset, yeoman of the crown 1
3613679 1871926 1871926 plaintiff Bedford John merchant 593868 593868 Bedford, John, of Pole, Dorset, merchant 0
3614280 1872130 1872130 defendant Hardyng William gent 593868 593868 Hardyng, William, of Pole, Dorset, gent 2
3712669 1930277 1930277 plaintiff Stokker John   593868 593868 Stokker, John, of Pole, Dorset 1
3839862 1970401 1970401 defendant Phillipps Richard gent 593868 593868 Phillipps, Richard, of Pole, Dorset, gent 1
3875943 1982207 1982207 defendant White John merchant 593868 593868 White, John, of Pole, Dorset, merchant 0
3883828 1984858 1984858 plaintiff Whyte Thomas merchant 593868 593868 Whyte, Thomas, of Pole, Dorset, merchant 0
3893574 1988077 1988077 defendant Chiltern William yeoman 593868 593868 Chiltern, William, of Pole, Dorset, yeoman 1
3967596 2013301 2013301 plaintiff Byngley Thomas merchant 593868 593868 Byngley, Thomas, of Pole, Dorset, merchant 0
3972647 2015007 2015007 plaintiff Gayden Peter merchant 593868 593868 Gayden, Peter, of Pole, Dorset, merchant 0
3995703 2023208 2023208 plaintiff Crooke John merchant 593868 593868 Crooke, John, of Pole, Dorset, merchant 0
4209658 2098929 2098929 defendant Harwarde Thomas gent 593868 593868 Harwarde, Thomas, of Pole, Dorset, gent 1
4304315 2131649 2131649 defendant Browne John weaver 593868 593868 Browne, John, of Pole, Dorset, weaver 0
4781820 2290330 2290330 defendant Mody John husbandman 593868 593868 Mody, John, of Pole, Dorset, husbandman 0
4784483 2291151 2291151 defendant Hardyng Hugh merchant 593868 593868 Hardyng, Hugh, of Pole, Dorset, merchant 2
4797303 2295330 2295330 defendant Warner William merchant 593868 593868 Warner, William, of Pole, Dorset, merchant 0
4859340 2314302 2314302 defendant Warner William merchant 593868 593868 Warner, William, of Pole, Dorset, merchant 0
4945534 2340581 2340581 defendant Man John chapman 593868 593868 Man, John, of Pole, Dorset, chapman 2
4950637 2342164 2342164 defendant Welle Thomas mariner 593868 593868 Welle, Thomas, of Pole, Dorset, mariner 0
4950669 2342173 2342173 defendant Webbe Thomas mariner 593868 593868 Webbe, Thomas, of Pole, Dorset, mariner 0
4950675 2342174 2342174 defendant Hayne William merchant 593868 593868 Hayne, William, of Pole, Dorset, merchant 0
4951620 2342462 2342462 defendant Houchyns Stephen   593868 593868 Houchyns, Stephen, of Pole, Dorset, merxhant 2
4955540 2343617 2343617 defendant Man John mariner 593868 593868 Man, John, of Pole, Dorset, mariner 2
4957804 2344305 2344305 defendant White William chapman 593868 593868 White, William, of Pole, Dorset, chapman 2
4966816 2346998 2346998 defendant Elys Thomas mariner 593868 593868 Elys, Thomas, of Pole, Dorset, mariner 2
4984276 2352222 2352222 defendant Bone or Boune Robert mariner or merchant 593868 593868 Bone or Boune, Robert, of Pole, Dorset, mariner or merchant 0
4986710 2352959 2352959 defendant Boys William husbandman 593868 593868 Boys, William, of Pole, Dorset, husbandman 0
5024603 2364107 2364107 defendant Atkyn William mariner 593868 593868 Atkyn, William, of Pole, Dorset, mariner 4
5027108 2364798 2364798 defendant Webbe Thomas mariner 593868 593868 Webbe, Thomas, of Pole, Dorset, mariner 2
5032972 2366530 2366530 defendant Spadarde John merchant 593868 593868 Spadarde, John, of Pole, Dorset, merchant 0
5035210 2367162 2367162 defendant Man John mariner 593868 593868 Man, John, of Pole, Dorset, mariner 1
5053066 2372515 2372515 defendant Dyker John merchant 593868 593868 Dyker, John, of Pole, Dorset, merchant 2
5059044 2374269 2374269 defendant White William merchant 593868 593868 White, William, of Pole, Dorset, merchant 2
5067996 2376929 2376929 defendant Webbe Thomas (legal representative) 593868 593868 Webbe, Thomas, of Pole, Dorset, mariner, executrix of 0
5115535 2390970 2390970 defendant Ivye Roger gent 593868 593868 Ivye, Roger, of Pole, Dorset, gent 0
5221961 2422125 2422125 defendant Thryng Thomas husbandman 593868 593868 (Thryng, Thomas, of Pole, Dorset, husbandman 1
5226169 2423320 2423320 plaintiff Spadard John merchant 593868 593868 Spadard, John, of Pole, Dorset, merchant 0
5248465 2429677 2429677 defendant Aleyne John tailor 593868 593868 Aleyne, John, of Pole, Dorset, tailor 1
5257766 2432549 2432549 defendant Baker Thomas merchant 593868 593868 Baker, Thomas, of Pole, Dorset, merchant 3
5263887 2434463 2434463 defendant White William merchant 593868 593868 White, William, of Pole, Dorset, merchant 0
5277900 2438623 2438623 defendant Selman Richard spicer 593868 593868 Selman, Richard, of Pole, Dorset, spicer 2
5287190 2441274 2441274 plaintiff Ivye Roger (legal representative) 593868 593868 Ivye, Roger, of Pole, Dorset, esq, executrix of 0
5320253 2451144 2451144 plaintiff Ivye or Inye Roger (legal representative) 593868 593868 Ivye or Inye, Roger, of Pole, Dorset, esq, executors of 0
5332694 2454848 2454848 defendant Broke John merchant 593868 593868 Broke, John, of Pole, Dorset, merchant 0
5336929 2456114 2456114 defendant Broke John merchant 593868 593868 Broke, John, of Pole, Dorset, merchant 0
5337709 2456352 2456352 plaintiff Inye or Juye or Gee Roger (legal representative) 593868 593868 Inye or Juye or Gee, Roger, of Pole, Dorset, esq, executors of 0
5337713 2456353 2456353 plaintiff Inye or Juye or Gee Roger (legal representative) 593868 593868 Inye or Juye or Gee, Roger, of Pole, Dorset, esq, executors of 0
5337897 2456420 2456420 plaintiff Juye alias Gee Roger (legal representative) 593868 593868 Juye alias Gee, Roger, of Pole, Dorset, esq, executors of 0
5337903 2456421 2456421 plaintiff Juye or Gee Roger (legal representative) 593868 593868 Juye or Gee, Roger, of Pole, Dorset, esq, executors of 0
5349186 2459870 2459870 defendant Bolleyn William merchant 593868 593868 Bolleyn, William, of Pole, Dorset, merchant 1
5355882 2461916 2461916 defendant Broke John merchant 593868 593868 Broke, John, of Pole, Dorset, merchant 0
5479767 2498960 2498960 defendant Aleyn John merchant 593868 593868 Aleyn, John, of Pole, Dorset, merchant 0
5488998 2501580 2501580 defendant Kymer John merchant 593868 593868 Kymer, John, of Pole, Dorset, merchant 0
5489228 2501662 2501662 plaintiff Aleyn John merchant 593868 593868 Aleyn, John, of Pole, Dorset, merchant 0
5503443 2505986 2505986 defendant Kemer John merchant 593868 593868 Kemer, John, of Pole, Dorset, merchant 0
5503446 2505987 2505987 defendant Kemer John merchant 593868 593868 Kemer, John, of Pole, Dorset, merchant 0
5503449 2505988 2505988 defendant Kemer John merchant 593868 593868 Kemer, John, of Pole, Dorset, merchant 0
5503452 2505989 2505989 defendant Kemer John merchant 593868 593868 Kemer, John, of Pole, Dorset, merchant 0
5516039 2509863 2509863 defendant Kymer John gent 593868 593868 Kymer, John, of Pole, Dorset, gent 0
5517774 2510401 2510401 defendant Kemer John merchant 593868 593868 Kemer, John, of Pole, Dorset, merchant 0
5517777 2510402 2510402 defendant Kemer John merchant 593868 593868 Kemer, John, of Pole, Dorset, merchant 0
5520191 2511136 2511136 defendant Fesaunt John esq 593868 593868 Fesaunt, John, of Pole, Dorset, esq 2
5549030 2519755 2519755 defendant Whyte Thomas merchant 593868 593868 Whyte, Thomas, of Pole, Dorset, merchant 0
5555680 2521656 2521656 defendant Havelond James merchant 593868 593868 Havelond, James, of Pole, Dorset, merchant 0
5555941 2521731 2521731 defendant Jardyn Stephen merchant 593868 593868 Jardyn, Stephen, of Pole, Dorset, merchant 0
5558073 2522317 2522317 defendant Kemer John gent 593868 593868 Kemer, John, of Pole, Dorset, gent 0
5558080 2522318 2522318 defendant Kemer John gent 593868 593868 Kemer, John, of Pole, Dorset, 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);