names

94 rows where place_id = 597809

✎ 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
3629924 1904214 1904214 defendant Harrys John husbandman 597809 597809 Harrys, John, of Wolpet, husbandman 2
4463904 2189388 2189388 plaintiff Wade Jacob   597809 597809 Wade, Jacob, of Wolpet 0
4470220 2191334 2191334 defendant Mayner William butcher 597809 597809 Mayner, William, of Wolpet, butcher 1
4470226 2191335 2191335 defendant Mayner William butcher 597809 597809 Mayner, William, of Wolpet, butcher 1
4471626 2191789 2191789 defendant Clortone John   597809 597809 Clortone, John, of Wolpet, plough man 0
4494572 2198993 2198993 defendant Man William   597809 597809 Man, William, of Wolpet 3
4505769 2202313 2202313 defendant Broun Walter   597809 597809 Broun, Walter, of Wolpet 6
4581246 2225602 2225602 defendant Edward Robert   597809 597809 Edward, Robert, of Wolpet 0
4584605 2226603 2226603 defendant Wade James   597809 597809 Wade, James, of Wolpet 0
4591760 2228778 2228778 defendant Man William   597809 597809 Man, William, of Wolpet 2
4604959 2232712 2232712 defendant Edward Robert   597809 597809 together with Edward, Robert, of Wolpet 2
4605792 2232925 2232925 defendant Baldewyne Edmund   597809 597809 Baldewyne, Edmund, of Wolpet 0
4613616 2235272 2235272 defendant Weybrede Henry   597809 597809 Weybrede, Henry, of Wolpet 2
4627532 2239542 2239542 defendant Bocher Walter   597809 597809 Bocher, Walter, of Wolpet 6
4647353 2245281 2245281 defendant Catour Walter butcher 597809 597809 Catour, Walter, of Wolpet, butcher 0
4648140 2245516 2245516 defendant Bother Walter   597809 597809 Bother, Walter, of Wolpet 0
4703860 2266586 2266586 defendant Welde John mercer 597809 597809 Welde, John, of Wolpet, mercer 2
4712593 2269258 2269258 defendant Cakat John weaver 597809 597809 Cakat, John, of Wolpet, weaver 0
4712594 2269258 2269258 defendant Baldewyne Edmund gelder 597809 597809 Baldewyne, Edmund, of Wolpet, gelder 1
4741964 2278148 2278148 plaintiff Brynglove Gilbert   597809 597809 Brynglove, Gilbert, of Wolpet 0
4743629 2278666 2278666 defendant Bryngelove Gilbert husbandman 597809 597809 Bryngelove, Gilbert, of Wolpet, husbandman 1
4755474 2282091 2282091 plaintiff Aubre William   597809 597809 Aubre, William, of Wolpet 0
4797026 2295232 2295232 defendant atte Welle Simon husbandman 597809 597809 atte Welle, Simon, of Wolpet, husbandman 0
4807912 2298659 2298659 defendant Bullyng William husbandman 597809 597809 Bullyng, William, of Wolpet, husbandman 1
4816558 2301270 2301270 defendant Cokerell John shoemaker 597809 597809 Cokerell, John, of Wolpet, shoemaker 2
4896856 2325673 2325673 defendant Smyth Peter smith 597809 597809 Smyth, Peter, of Wolpet, smith 3
4947007 2341055 2341055 defendant Tryplowe John husbandman 597809 597809 Tryplowe, John, of Wolpet, husbandman 2
4966353 2346871 2346871 defendant Calfhawe William yeoman 597809 597809 Calfhawe, William, of Wolpet, yeoman 1
4966358 2346872 2346872 defendant Falfhawe William clerk 597809 597809 Falfhawe, William, of Wolpet, clerk 1
4975888 2349749 2349749 defendant Calfhawe William husbandman 597809 597809 Calfhawe, William, of Wolpet, husbandman 0
4981488 2351373 2351373 defendant Heed Richard yeoman 597809 597809 Heed, Richard, of Wolpet, yeoman 1
4994214 2355145 2355145 defendant Coket John chapman 597809 597809 Coket, John, of Wolpet, chapman 0
4994216 2355145 2355145 defendant Goche Peter smith 597809 597809 Goche, Peter, of Wolpet, smith 2
4996942 2355940 2355940 defendant Aubry William husbandman 597809 597809 Aubry, William, of Wolpet, husbandman 1
4996944 2355940 2355940 defendant Lane James husbandman 597809 597809 together with Lane, James, of Wolpet, husbandman 3
4996945 2355940 2355940 defendant Joynour Adam shoemaker 597809 597809 Joynour, Adam, of Wolpet, shoemaker 4
5012837 2360586 2360586 defendant Rag John husbandman 597809 597809 Rag, John, of Wolpet, husbandman 4
5046730 2370646 2370646 defendant Hert John yeoman 597809 597809 Hert, John, of Wolpet, yeoman 1
5111180 2389659 2389659 plaintiff Hellys John   597809 597809 Hellys, John, of Wolpet 0
5118319 2391794 2391794 plaintiff Reynold William (legal representative) 597809 597809 Reynold, William, of Wolpet, executors of 0
5118320 2391794 2391794 plaintiff Reynold Richard   597809 597809 (Reynold, Richard, of Wolpet 1
5119854 2392241 2392241 plaintiff Smyth Thomas, junior   597809 597809 Smyth, Thomas, junior, of Wolpet 0
5119856 2392242 2392242 plaintiff Smyth Thomas, junior woolman 597809 597809 Smyth, Thomas, junior, of Wolpet, woolman 0
5125196 2393847 2393847 defendant Bode Ralph tanner 597809 597809 Bode, Ralph, of Wolpet, tanner 0
5125197 2393847 2393847 defendant Lane John husbandman 597809 597809 Lane, John, of Wolpet, husbandman 1
5125198 2393847 2393847 defendant Cokeman Beatrice widow 597809 597809 Cokeman, Beatrice, of Wolpet, widow 2
5125199 2393847 2393847 defendant Boys Margery widow 597809 597809 Boys, Margery, of Wolpet, widow 3
5125200 2393848 2393848 plaintiff Aubre William   597809 597809 Aubre, William, of Wolpet 0
5125201 2393848 2393848 defendant Cokeman Roger (legal representative) 597809 597809 Cokeman, Roger, of Wolpet, administratrix of 0
5125202 2393848 2393848 defendant Cokeman Beatrice widow 597809 597809 Cokeman, Beatrice, of Wolpet, widow 1
5125203 2393848 2393848 defendant Boys John (legal representative) 597809 597809 Boys, John, of Wolpet, administratrix of 2
5125204 2393848 2393848 defendant boys Margery widow 597809 597809 boys, Margery, of Wolpet, widow 3
5126028 2394098 2394098 plaintiff Lane James   597809 597809 Lane, James, of Wolpet 3
5144654 2399594 2399594 plaintiff Lane James   597809 597809 Lane, James, of Wolpet 3
5144661 2399595 2399595 plaintiff Lane James   597809 597809 Lane, James, of Wolpet 3
5161044 2404333 2404333 defendant Bode Ralph tanner 597809 597809 Bode, Ralph, of Wolpet, tanner 0
5175622 2408554 2408554 defendant Bode Ralph tanner 597809 597809 Bode, Ralph, of Wolpet, tanner 0
5179451 2409725 2409725 plaintiff Lane James   597809 597809 Lane, James, of Wolpet 3
5196987 2414863 2414863 defendant Bode Ralph tanner 597809 597809 Bode, Ralph, of Wolpet, tanner 0
5218476 2421135 2421135 defendant Geffrey William cordwainer 597809 597809 Geffrey, William, of Wolpet, cordwainer 0
5222060 2422155 2422155 defendant Baldewyn John husbandman 597809 597809 Baldewyn, John, of Wolpet, husbandman 0
5222061 2422155 2422155 defendant Parker John husbandman 597809 597809 Parker, John, of Wolpet, husbandman 1
5225867 2423239 2423239 plaintiff Smyth alias Bloys Thomas clothmaker 597809 597809 Smyth alias Bloys, Thomas, of Wolpet, clothmaker 0
5242804 2428099 2428099 defendant Lane James husbandman 597809 597809 Lane, James, of Wolpet, husbandman 3
5245932 2428971 2428971 defendant Mey William yeoman 597809 597809 Mey, William, of Wolpet, yeoman 0
5249488 2429961 2429961 defendant Wellys John yeoman 597809 597809 Wellys, John, of Wolpet, yeoman 1
5262350 2433972 2433972 defendant Auncell Denis carpenter 597809 597809 Auncell, Denis, of Wolpet, carpenter 3
5269268 2436113 2436113 defendant Beket John   597809 597809 Beket, John, of Wolpet, wheel wright 2
5277711 2438568 2438568 plaintiff Awbry William   597809 597809 Awbry, William, of Wolpet 0
5277712 2438568 2438568 defendant Parker John husbandman 597809 597809 Parker, John, of Wolpet, husbandman 0
5277713 2438568 2438568 defendant Haukyn John chaplain 597809 597809 Haukyn, John, of Wolpet, chaplain 1
5278793 2438906 2438906 plaintiff Bloys or Bleyse Thomas woolman or yeoman 597809 597809 Bloys or Bleyse, Thomas, of Wolpet, or of Ipswich, woolman or yeoman 0
5278794 2438906 2438906 defendant Mundeforth John yeoman 597809 597809 Mundeforth, John, of Wolpet, yeoman 0
5278796 2438906 2438906 defendant Coket Simon husbandman 597809 597809 Coket, Simon, of Wolpet, husbandman 2
5278797 2438906 2438906 defendant Beverley Henry sherman 597809 597809 Beverley, Henry, of Wolpet, sherman 3
5313263 2449004 2449004 plaintiff Bloys or Bleyse Thomas yeoman or woolman 597809 597809 Bloys or Bleyse, Thomas, of Wolpet, yeoman or woolman 0
5316483 2450011 2450011 defendant Lynton Robert clerk 597809 597809 Lynton, Robert, of Wolpet, clerk 0
5384276 2470589 2470589 defendant Damsell Thomas husbandman 597809 597809 Damsell, Thomas, of Wolpet, husbandman 3
5384279 2470590 2470590 defendant Lacforth Thomas pewterer 597809 597809 Lacforth, Thomas, of Wolpet, pewterer 0
5386587 2471229 2471229 defendant Revell Thomas smith 597809 597809 Revell, Thomas, of Wolpet, smith 10
5396068 2473962 2473962 defendant Damsell Thomas husbandman 597809 597809 Damsell, Thomas, of Wolpet, husbandman 3
5396077 2473964 2473964 defendant Latforth Thomas pewterer 597809 597809 Latforth, Thomas, of Wolpet, pewterer 0
5409358 2477770 2477770 defendant Damsell Thomas husbandman 597809 597809 Damsell, Thomas, of Wolpet, husbandman 3
5409367 2477772 2477772 defendant Lacforth Thomas pewterer 597809 597809 Lacforth, Thomas, of Wolpet, pewterer 0
5411977 2478535 2478535 defendant Revell Thomas smith 597809 597809 Revell, Thomas, of Wolpet, smith 10
5422883 2481801 2481801 defendant Damsell Thomas husbandman 597809 597809 Damsell, Thomas, of Wolpet, husbandman 2
5422889 2481803 2481803 defendant Lacforth Thomas pewterer 597809 597809 Lacforth, Thomas, of Wolpet, pewterer 0
5478252 2498522 2498522 defendant Lakforth Guy pewterer 597809 597809 Lakforth, Guy, of Wolpet, pewterer 1
5522262 2511780 2511780 defendant Floro Robert yeoman 597809 597809 Floro, Robert, of Wolpet, yeoman 0
5539629 2516876 2516876 defendant Bawode or Cawode John laborer 597809 597809 Bawode or Cawode, John, of Wolpet, laborer 3
5579641 2528716 2528716 defendant Bawde John husbandman 597809 597809 Bawde, John, of Wolpet, husbandman 2
5626070 2552115 2552115 defendant Foulere Walter   597809 597809 Foulere, Walter, of Wolpet, cook 0
5626200 2552162 2552162 defendant Weybrede Henry husbandman 597809 597809 Weybrede, Henry, of Wolpet, husbandman 0
5629584 2553241 2553241 defendant Bocher alias Catour Walter   597809 597809 Bocher alias Catour, Walter, of Wolpet 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);