names

61 rows where place_id = 588703

✎ 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
3595316 1866166 1866166 defendant Jacop Richard butcher 588703 588703 Jacop, Richard, of Criditon, butcher 5
4632139 2240930 2240930 defendant Clyve William   588703 588703 Clyve, William, of Criditon 0
4632142 2240931 2240931 defendant Clyve Willia   588703 588703 Clyve, Willia, of Criditon 0
4632144 2240932 2240932 defendant Clyve William   588703 588703 Clyve, William, of Criditon 0
4664075 2250252 2250252 defendant Hugh Walter carpenter 588703 588703 Hugh, Walter, of Criditon, carpenter 2
4664076 2250253 2250253 plaintiff Haddon Robert   588703 588703 Haddon, Robert, of Criditon 0
4664081 2250253 2250253 defendant Dyer William laborer 588703 588703 Dyer, William, of Criditon, laborer 4
4664873 2250493 2250493 plaintiff Headdon Robert   588703 588703 Headdon, Robert, of Criditon 0
4686602 2261419 2261419 defendant Corbyn John shoemaker 588703 588703 Corbyn, John, of Criditon, shoemaker 0
4686606 2261419 2261419 defendant Brere Hugh butcher 588703 588703 Brere, Hugh, of Criditon, butcher 4
4779403 2289542 2289542 defendant Fennycombe Richard husbandman 588703 588703 Fennycombe, Richard, of Criditon, husbandman 0
4779409 2289543 2289543 defendant Fennycombe Richard husbandman 588703 588703 Fennycombe, Richard, of Criditon, husbandman 0
4788278 2292405 2292405 plaintiff Heddon Robert mercer 588703 588703 Heddon, Robert, of Criditon, mercer 0
4795447 2294728 2294728 defendant York William   588703 588703 York, William, of Criditon 0
4887533 2322938 2322938 defendant Bolepitte John clerk 588703 588703 Bolepitte, John, of Criditon, clerk 0
4887536 2322938 2322938 defendant Huchon John husbandman 588703 588703 Huchon, John, of Criditon, husbandman 3
4907133 2328794 2328794 defendant Heddon John chapman 588703 588703 Heddon, John, of Criditon, chapman 0
4920412 2332901 2332901 defendant Fox Robert tailor 588703 588703 Fox, Robert, of Criditon, tailor 0
4920413 2332901 2332901 defendant goodle John baker 588703 588703 goodle, John, of Criditon, baker 1
4920414 2332901 2332901 defendant Stoddon John weaver 588703 588703 Stoddon, John, of Criditon, weaver 2
4944326 2340201 2340201 plaintiff Happer John   588703 588703 Happer, John, of Criditon 0
4944327 2340201 2340201 defendant York Walter husbandman 588703 588703 York, Walter, of Criditon, husbandman 0
4950404 2342092 2342092 defendant Newysham Richard yeoman 588703 588703 Newysham, Richard, of Criditon, yeoman 0
4952964 2342848 2342848 defendant Prestecote John yeoman 588703 588703 Prestecote, John, of Criditon, yeoman 0
4955987 2343757 2343757 defendant Baker John butcher 588703 588703 Baker, John, of Criditon, butcher 3
4955988 2343757 2343757 defendant Taillour John tailor 588703 588703 Taillour, John, of Criditon, tailor 4
4955993 2343758 2343758 defendant Chamberleyn Richard tailor 588703 588703 Chamberleyn, Richard, of Criditon, tailor 3
4957961 2344350 2344350 defendant Vele William (legal representative) 588703 588703 Vele, William, of Criditon, brewer, executors of 0
4964156 2346190 2346190 defendant Mabbe Mathew shoemaker 588703 588703 Mabbe, Mathew, of Criditon, shoemaker 0
4964157 2346190 2346190 defendant Frende Hugh tanner 588703 588703 Frende, Hugh, of Criditon, tanner 1
4964158 2346190 2346190 defendant Anthony Richard carpenter 588703 588703 Anthony, Richard, of Criditon, carpenter 2
4964209 2346197 2346197 defendant Mabbe Mathew shoemaker 588703 588703 Mabbe, Mathew, of Criditon, shoemaker 0
4964210 2346197 2346197 defendant Frende Hugh tanner 588703 588703 Frende, Hugh, of Criditon, tanner 1
4964211 2346197 2346197 defendant Anthony Richard carpenter 588703 588703 Anthony, Richard, of Criditon, carpenter 2
4970452 2348109 2348109 defendant Torner Robert yeoman 588703 588703 Torner, Robert, of Criditon, yeoman 1
4977196 2350137 2350137 defendant Gay Walter ostler 588703 588703 Gay, Walter, of Criditon, ostler 0
4985216 2352509 2352509 defendant Clyfton John   588703 588703 Clyfton, John, of Criditon, bailiff 0
5003464 2357908 2357908 defendant Prye John gent 588703 588703 (Prye, John, of Criditon, gent 1
5038257 2368079 2368079 plaintiff York William   588703 588703 York, William, of Criditon 0
5087517 2382727 2382727 defendant Warde Walter mercer 588703 588703 Warde, Walter, of Criditon, mercer 0
5106853 2388431 2388431 defendant Broune Walter laborer 588703 588703 Broune, Walter, of Criditon, laborer 1
5218939 2421265 2421265 defendant Bryan Robert butcher 588703 588703 Bryan, Robert, of Criditon, butcher 0
5252165 2430790 2430790 defendant Torner Robert butcher 588703 588703 Torner, Robert, of Criditon, butcher 0
5258188 2432681 2432681 defendant Mounston William butcher 588703 588703 Mounston, William, of Criditon, butcher 0
5258788 2432868 2432868 defendant Parys Robert yeoman 588703 588703 Parys, Robert, of Criditon, yeoman 0
5261358 2433660 2433660 defendant Grenevile William yeoman 588703 588703 Grenevile, William, of Criditon, yeoman 0
5267794 2435688 2435688 defendant Parys Robert yeoman 588703 588703 Parys, Robert, of Criditon, yeoman 0
5286552 2441075 2441075 defendant Lasky Thomas tucker 588703 588703 Lasky, Thomas, of Criditon, tucker 0
5292870 2442908 2442908 defendant Lasky Thomas baker 588703 588703 Lasky, Thomas, of Criditon, baker 0
5295781 2443760 2443760 plaintiff Walrond John   588703 588703 Walrond, John, of Criditon 0
5349289 2459905 2459905 defendant Samson John weaver 588703 588703 Samson, John, of Criditon, weaver 0
5350341 2460228 2460228 defendant Sampson John weaver 588703 588703 Sampson, John, of Criditon, weaver 2
5354051 2461330 2461330 plaintiff Hacche Elizabeth (legal representative) 588703 588703 Hacche, Elizabeth, of Criditon, administrator of 0
5354052 2461330 2461330 plaintiff Parys Robert   588703 588703 Parys, Robert, of Criditon 1
5613122 2547883 2547883 plaintiff Cook John merchant 588703 588703 Cook, John, of Criditon, merchant 0
5624352 2551561 2551561 defendant Drake Stephen clerk 588703 588703 Drake, Stephen, of Criditon, clerk 2
5624356 2551562 2551562 defendant Drake Stephen clerk 588703 588703 Drake, Stephen, of Criditon, clerk 2
5625263 2551840 2551840 defendant Sutton William clerk 588703 588703 Sutton, William, of Criditon, clerk 0
5625265 2551841 2551841 defendant Sutton William clerk 588703 588703 Sutton, William, of Criditon, clerk 0
5636443 2555351 2555351 defendant Carpenter William carpenter 588703 588703 Carpenter, William, of Criditon, carpenter 0
5636444 2555351 2555351 defendant Gerneys or Gerveys John husbandman 588703 588703 Gerneys or Gerveys, John, of Criditon, husbandman 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);