names

64 rows where place_id = 591767

✎ 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
3605515 1869389 1869389 defendant Couper Thomas clothmaker 591767 591767 Couper, Thomas, of Byldeston, clothmaker 0
3609309 1870570 1870570 plaintiff Hamond William   591767 591767 Hamond, William, of Byldeston 3
3874202 1981595 1981595 defendant Gybroke John shoemaker 591767 591767 Gybroke, John, of Byldeston, shoemaker 1
4139877 2074629 2074629 defendant Ashby John shoemaker 591767 591767 Ashby, John, of Byldeston, shoemaker 0
4352736 2148187 2148187 defendant Corbolde John yeoman 591767 591767 Corbolde, John, of Byldeston, yeoman 0
4382150 2158723 2158723 defendant Pott Edmund yeoman 591767 591767 Pott, Edmund, of Byldeston, yeoman 0
4390131 2161321 2161321 defendant Corbolde John yeoman 591767 591767 Corbolde, John, of Byldeston, yeoman 0
4390194 2161343 2161343 defendant Pott or Pottes Edmund innholder 591767 591767 Pott or Pottes, Edmund, of Byldeston, innholder 0
4408673 2167496 2167496 defendant Grinwood Thomas clothier 591767 591767 Grinwood, Thomas, of Byldeston, clothier 0
4411638 2168489 2168489 defendant Ely William tanner 591767 591767 Ely, William, of Byldeston, tanner 1
4460638 2188385 2188385 plaintiff Skyp John   591767 591767 Skyp, John, of Byldeston 0
4544181 2214096 2214096 plaintiff Bargh Robert   591767 591767 Bargh, Robert, of Byldeston 0
4554567 2217357 2217357 defendant Bevys John   591767 591767 Bevys, John, of Byldeston 2
4652901 2246842 2246842 plaintiff Bargh Thomas   591767 591767 Bargh, Thomas, of Byldeston 0
4655712 2247669 2247669 defendant Smyth John smith 591767 591767 Smyth, John, of Byldeston, smith 1
4671661 2256783 2256783 plaintiff Chapman John   591767 591767 Chapman, John, of Byldeston 0
4672272 2256976 2256976 plaintiff Gerveys John   591767 591767 Gerveys, John, of Byldeston 1
4678529 2258890 2258890 defendant Broun Thomas taverner 591767 591767 Broun, Thomas, of Byldeston, taverner 3
4693277 2263399 2263399 plaintiff Bargh Robert   591767 591767 Bargh, Robert, of Byldeston 0
4697667 2264762 2264762 defendant Howard Thomas yeoman 591767 591767 Howard, Thomas, of Byldeston, yeoman 0
4722586 2272380 2272380 defendant Howard Thomas yeoman 591767 591767 Howard, Thomas, of Byldeston, yeoman 0
4728422 2274123 2274123 defendant Cook Thomas yeoman 591767 591767 Cook, Thomas, of Byldeston, yeoman 0
4728423 2274123 2274123 defendant Talbot Simon yeoman 591767 591767 Talbot, Simon, of Byldeston, yeoman 1
4744301 2278855 2278855 defendant Markeday Robert dyer 591767 591767 Markeday, Robert, of Byldeston, dyer 4
4745353 2279149 2279149 defendant Howard Thomas mercer 591767 591767 Howard, Thomas, of Byldeston, mercer 0
4767003 2285668 2285668 defendant Cok Laurence carpenter 591767 591767 Cok, Laurence, of Byldeston, carpenter 0
4777726 2289026 2289026 defendant Wryghte Lawrence   591767 591767 Wryghte, Lawrence, of Byldeston, wright 2
4838081 2307831 2307831 defendant Borell John baker 591767 591767 Borell, John, of Byldeston, baker 0
4931364 2336190 2336190 defendant Strut John chapman 591767 591767 Strut, John, of Byldeston, chapman 0
4934932 2337330 2337330 plaintiff Baron John   591767 591767 Baron, John, of Byldeston 0
4947565 2341233 2341233 defendant Howell Geoffrey sherman 591767 591767 Howell, Geoffrey, of Byldeston, sherman 0
4949721 2341906 2341906 defendant Mynton Robert butcher 591767 591767 Mynton, Robert, of Byldeston, butcher 0
4972058 2348579 2348579 plaintiff Jerveys John, senior   591767 591767 Jerveys, John, senior, of Byldeston 0
4972062 2348580 2348580 plaintiff Jerveys John, senior   591767 591767 Jerveys, John, senior, of Byldeston 0
4985676 2352630 2352630 defendant Whytop William yeoman 591767 591767 Whytop, William, of Byldeston, yeoman 0
4997213 2356020 2356020 defendant Skippelond John merchant 591767 591767 Skippelond, John, of Byldeston, merchant 2
5003404 2357892 2357892 defendant Ordryche John shoemaker 591767 591767 Ordryche, John, of Byldeston, shoemaker 3
5012835 2360586 2360586 defendant Whitop William yeoman 591767 591767 Whitop, William, of Byldeston, yeoman 2
5033721 2366741 2366741 plaintiff Spycer Thomas   591767 591767 Spycer, Thomas, of Byldeston 0
5039578 2368485 2368485 defendant Howell Geoffrey chapman 591767 591767 Howell, Geoffrey, of byldeston, chapman 1
5112040 2389908 2389908 plaintiff Horold John mercer 591767 591767 Horold, John, of Byldeston,or of Clare, senior, mercer 0
5115450 2390945 2390945 plaintiff Motte John (legal representative) 591767 591767 Motte, John, of Byldeston, executors of 0
5194589 2414149 2414149 defendant Rauff Thomas carpenter 591767 591767 Rauff, Thomas, of Byldeston, carpenter 0
5214775 2420044 2420044 defendant Baron John fisher 591767 591767 Baron, John, of Byldeston, or of Bury St Edmunds, Suff, fisher 0
5222755 2422372 2422372 plaintiff Motte John (legal representative) 591767 591767 Motte, John, of Byldeston, executors of 0
5227655 2423710 2423710 defendant Mylner William husbandman 591767 591767 Mylner, William, of Byldeston, husbandman 0
5232764 2425167 2425167 defendant Goodale John carpenter 591767 591767 Goodale, John, of Byldeston, carpenter 0
5271333 2436708 2436708 defendant Ra---- Walter carpenter 591767 591767 Ra----, Walter, of Byldeston, carpenter 4
5279924 2439204 2439204 defendant Lanesdale Robert carpenter 591767 591767 Lanesdale, Robert, of Byldeston, carpenter 0
5292489 2442800 2442800 defendant Rolf Thomas carpenter 591767 591767 Rolf, Thomas, of Byldeston, carpenter 2
5292490 2442800 2442800 defendant Dyer John dyer 591767 591767 Dyer, John, of Byldeston, dyer 3
5326112 2452901 2452901 defendant Spryng Geoffrey weaver 591767 591767 Spryng, Geoffrey, of Byldeston, weaver 1
5332379 2454750 2454750 plaintiff Clement alias Goodale John carpenter 591767 591767 Clement alias Goodale, John, of Byldeston, carpenter 0
5343325 2458103 2458103 defendant Gosselyn John weaver 591767 591767 Gosselyn, John, of Byldeston, weaver 1
5343327 2458103 2458103 defendant Illy Thomas fuller 591767 591767 Illy, Thomas, of Byldeston, fuller 3
5352684 2460930 2460930 defendant Batayle Thomas fuller 591767 591767 Batayle, Thomas, of Byldeston, fuller 1
5352685 2460930 2460930 defendant Hamond William clothmaker 591767 591767 Hamond, William, of Byldeston, clothmaker 2
5373535 2467321 2467321 defendant Taillour Robert seaver 591767 591767 Taillour, Robert, of Byldeston, seaver 0
5500869 2505203 2505203 defendant Rowe John husbandman 591767 591767 Rowe, John, of Byldeston, husbandman 0
5506911 2507078 2507078 plaintiff Coke John   591767 591767 Coke, John, of Byldeston 0
5506913 2507078 2507078 defendant Kenyng alias Barker John clothmaker 591767 591767 Kenyng alias Barker, John, of Byldeston, clothmaker 1
5576739 2527771 2527771 defendant Cooke Margery widow 591767 591767 Cooke, Margery, of Byldeston, widow 1
5595285 2533473 2533473 defendant Lawman Robert butcher 591767 591767 Lawman, Robert, of Byldeston, butcher 0
5606379 2536889 2536889 defendant Chylton William sherman 591767 591767 (Chylton, William, of Byldeston, sherman 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);