names

124 rows where place_id = 586083

✎ 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
3587887 1863862 1863862 defendant Langton John gent 586083 586083 Langton, John, of Langton, gent 0
3587889 1863863 1863863 defendant Langton John esq 586083 586083 Langton, John, of Langton, esq 0
3614767 1872268 1872268 defendant Tenyngton Simon husbandman 586083 586083 Tenyngton, Simon, of Langton, husbandman 0
3640276 1907391 1907391 defendant Har- William husbandman 586083 586083 Har-, William, of Langton, husbandman 1
3656695 1912345 1912345 defendant Thornton John milner 586083 586083 Thornton, John, of Langton, milner 0
3696499 1925133 1925133 defendant Totheby William gent 586083 586083 Totheby, William, of Langton, gent 1
3696502 1925134 1925134 defendant Totheby William gent 586083 586083 Totheby, William, of Langton, gent 1
3753257 1942958 1942958 defendant Whityng William yeoman 586083 586083 Whityng, William, of Langton, yeoman 2
3762074 1945780 1945780 defendant Tomson John husbandman 586083 586083 Tomson, John, of Langton, husbandman 1
3789356 1954492 1954492 defendant Whityng John husbandman 586083 586083 Whityng, John, of Langton, husbandman 0
3832537 1968095 1968095 defendant Pykeryng William husbandman 586083 586083 Pykeryng, William, of Langton, husbandman 1
3911823 1994278 1994278 defendant Clement Edward gent 586083 586083 Clement, Edward, of Langton, gent 0
3923540 1998182 1998182 defendant Percy William gent 586083 586083 Percy, William, of Langton, gent 0
3923542 1998182 1998182 defendant Durant Henry laborer 586083 586083 Durant, Henry, of Langton, laborer 2
3961161 2010997 2010997 defendant Welles Richard yeoman 586083 586083 Welles, Richard, of Langton, yeoman 0
4016277 2030521 2030521 defendant Langton John, junior gent 586083 586083 (Langton, John, junior, of Langton, gent 1
4029345 2035139 2035139 defendant Rayner William husbandman 586083 586083 Rayner, William, of Langton, husbandman 0
4032005 2036115 2036115 defendant Weneham John yeoman 586083 586083 Weneham, John, of Langton, yeoman 0
4080063 2053175 2053175 plaintiff Vyncent John husbandman 586083 586083 Vyncent, John, of Langton, husbandman 0
4089419 2056502 2056502 defendant Parkinson William yeoman 586083 586083 Parkinson, William, of Langton, yeoman 2
4094254 2058279 2058279 defendant Langton John gent 586083 586083 Langton, John, of Langton, gent 3
4103804 2061634 2061634 defendant Langton John, junior gent 586083 586083 Langton, John, junior, of Langton, gent 0
4116679 2066261 2066261 defendant Danbie Lancelot gent 586083 586083 Danbie, Lancelot, of Langton, gent 0
4116680 2066261 2066261 defendant Danbye William gent 586083 586083 Danbye, William, of Langton, gent 1
4116684 2066262 2066262 defendant Danbye Lancelot gent 586083 586083 Danbye, Lancelot, of Langton, gent 0
4121025 2067808 2067808 defendant Langstafe Thomas yeoman 586083 586083 Langstafe, Thomas, of Langton, yeoman 2
4144080 2076091 2076091 defendant Lanstaffe Thomas yeoman 586083 586083 Lanstaffe, Thomas, of Langton, yeoman 2
4186723 2090846 2090846 defendant Langton John gent 586083 586083 Langton, John, of Langton, gent 3
4236920 2108490 2108490 defendant Chepman Thomas gent 586083 586083 Chepman, Thomas, of Langton, gent 1
4236922 2108490 2108490 defendant Chepman Robert yeoman 586083 586083 Chepman, Robert, of Langton, yeoman 3
4275101 2121243 2121243 defendant Langton John, senior gent 586083 586083 Langton, John, senior, of Langton, gent 1
4275179 2121263 2121263 defendant Langton John, senior gent 586083 586083 Langton, John, senior, of Langton, gent 1
4279457 2122735 2122735 defendant Berrye Anthony yeoman 586083 586083 Berrye, Anthony, of Langton, yeoman 0
4360093 2150774 2150774 defendant Hall George husbandman 586083 586083 Hall, George, of Langton, husbandman 0
4360662 2150985 2150985 defendant Kirke Uriah clerk 586083 586083 Kirke, Uriah, of Langton, or of Laughton juxta Horncastle, clerk 0
4366147 2152933 2152933 defendant Langton John gent 586083 586083 Langton, John, of Langton, gent 2
4370667 2154562 2154562 defendant Aschoughe Walter gent 586083 586083 Aschoughe, Walter, of Langton, gent 0
4409318 2167712 2167712 defendant Chapman Thomas gent 586083 586083 Chapman, Thomas, of Langton, gent 0
4461337 2188627 2188627 plaintiff Banastre Peter   586083 586083 (Banastre, Peter, of Langton, parson 1
4466205 2190093 2190093 defendant Foxholes Joan de   586083 586083 (Foxholes, Joan de, of Langton 1
4480543 2194580 2194580 defendant Kyng John   586083 586083 Kyng, John, of Langton 1
4509180 2203348 2203348 plaintiff Aswardeby Thomas   586083 586083 Aswardeby, Thomas, of Langton 0
4526686 2208627 2208627 defendant Gilliote William   586083 586083 Gilliote, William, of Langton 0
4526702 2208632 2208632 defendant Warre William   586083 586083 Warre, William, of Langton 1
4528426 2209169 2209169 defendant Colyere John   586083 586083 Colyere, John, of Langton 0
4537758 2212085 2212085 plaintiff Tatersale Walter   586083 586083 Tatersale, Walter, of Langton 0
4547283 2215085 2215085 defendant Hauley Richard   586083 586083 Hauley, Richard, of Langton 0
4569302 2221989 2221989 defendant Northorp Richard   586083 586083 Northorp, Richard, of Langton 2
4573322 2223189 2223189 defendant Mustard Thomas   586083 586083 Mustard, Thomas, of Langton 2
4576989 2224311 2224311 defendant Hawelay Richard   586083 586083 Hawelay, Richard, of Langton 0
4586397 2227160 2227160 defendant Haweley Richard   586083 586083 Haweley, Richard, of Langton 0
4588352 2227748 2227748 defendant Wyntryngham John   586083 586083 Wyntryngham, John, of Langton, parson 0
4593155 2229167 2229167 defendant Moreys Robert   586083 586083 Moreys, Robert, of Langton 0
4602119 2231886 2231886 defendant Santon John   586083 586083 Santon, John, of Langton 0
4650905 2246285 2246285 defendant Scafelay John   586083 586083 Scafelay, John, of Langton 2
4662442 2249727 2249727 plaintiff Foxholl John   586083 586083 Foxholl, John, of Langton 0
4662444 2249727 2249727 defendant Geffrayson John husbandman 586083 586083 Geffrayson, John, of Langton, husbandman 1
4665650 2250727 2250727 defendant Mustard Thomas husbandman 586083 586083 Mustard, Thomas, of Langton, husbandman 2
4681038 2259695 2259695 defendant Milne William gent 586083 586083 Milne, William, of Langton, gent 0
4697773 2264799 2264799 plaintiff Pese John tailor 586083 586083 Pese, John, of Langton, tailor 1
4713536 2269553 2269553 plaintiff Sudbery John   586083 586083 Sudbery, John, of Langton, master & clerk, parson of the church 0
4713546 2269556 2269556 plaintiff (not given) John rector of Sudbury 586083 586083 Sudbury, John, of Langton, rector of the church 0
4741269 2277943 2277943 defendant Bolton John carter 586083 586083 Bolton, John, of Langton, carter 3
4765558 2285218 2285218 plaintiff Jonson Robert (legal representative) 586083 586083 Jonson, Robert, of Langton, husbandman, executors of 0
4765561 2285218 2285218 defendant Whelewryght John husbandman 586083 586083 Whelewryght, John, of Langton, husbandman 0
4765562 2285218 2285218 defendant Wylman Richard weaver 586083 586083 Wylman, Richard, of Langton, weaver 1
4772851 2287481 2287481 defendant Belle Robert butcher 586083 586083 Belle, Robert, of Langton, butcher 0
4773094 2287555 2287555 plaintiff Sudbery John   586083 586083 Sudbery, John, of Langton, parson 0
4781369 2290183 2290183 defendant Langton John gent 586083 586083 Langton, John, of Langton, gent 0
4789914 2292915 2292915 plaintiff Jonson Robert (legal representative) 586083 586083 Jonson, Robert, of Langton, husbandman, executors of 0
4789916 2292915 2292915 defendant Whelewryght John husbandman 586083 586083 Whelewryght, John, of Langton, husbandman 0
4789917 2292915 2292915 defendant Wilman Richard weaver 586083 586083 Wilman, Richard, of Langton, weaver 1
4800778 2296431 2296431 plaintiff Welton John   586083 586083 Welton, John, of Langton 0
4805693 2297991 2297991 defendant Faukes Richard husbandman 586083 586083 Faukes, Richard, of Langton, husbandman 0
4815106 2300835 2300835 defendant Godale William husbandman 586083 586083 Godale, William, of Langton, husbandman 0
4819761 2302253 2302253 defendant Troute John merchant 586083 586083 Troute, John, of Langton, merchant 1
4819868 2302287 2302287 defendant Boket Richard husbandman 586083 586083 Boket, Richard, of Langton, husbandman 0
4856713 2313474 2313474 defendant Baudewyn John husbandman 586083 586083 Baudewyn, John, of Langton, husbandman 4
4861886 2315093 2315093 defendant Bryffeld William laborer 586083 586083 Bryffeld, William, of Langton, laborer 2
4862384 2315243 2315243 defendant Jonson William husbandman 586083 586083 Jonson, William, of Langton, husbandman 2
4862887 2315378 2315378 defendant Jonson William husbandman 586083 586083 Jonson, William, of Langton, husbandman 0
4909642 2329546 2329546 defendant Tyler William miller 586083 586083 Tyler, William, of Langton, miller 0
4948463 2341498 2341498 defendant Prynse Thomas husbandman 586083 586083 Prynse, Thomas, of Langton, husbandman 1
4949319 2341773 2341773 defendant Broun Adam   586083 586083 Broun, Adam, of Langton, chaplain, son of Broun, William 1
4973573 2349049 2349049 defendant Haweley Thomas Lincs, esq 586083 586083 Haweley Thomas, of Langton, Lincs, esq 0
4973725 2349096 2349096 defendant Kytchyn John yeoman 586083 586083 Kytchyn, John, of Langton, yeoman 0
4993890 2355041 2355041 defendant Daweson John husbandman 586083 586083 Daweson, John, of Langton, husbandman 2
5001704 2357395 2357395 defendant Wyldyng William husbandman 586083 586083 Wyldyng, William, of Langton, husbandman 3
5001705 2357395 2357395 defendant Mercer William husbandman 586083 586083 Mercer, William, of Langton, husbandman 4
5025892 2364468 2364468 defendant Cok John yeoman 586083 586083 Cok, John, of Langton, yeoman 4
5035662 2367286 2367286 defendant Wryght John husbandman 586083 586083 Wryght, John, of Langton, husbandman 0
5045460 2370272 2370272 defendant Wryght John, senior   586083 586083 Wryght, John, senior, of Langton, wheel wright 2
5045461 2370272 2370272 defendant Wright John, junior husbandman 586083 586083 Wright, John, junior, of Langton, husbandman 3
5050924 2371892 2371892 defendant Daweson Robert yeoman 586083 586083 Daweson, Robert, of Langton, yeoman 0
5050925 2371892 2371892 defendant Wryght John husbandman 586083 586083 Wryght, John, of Langton, husbandman 1
5096774 2385487 2385487 defendant Hoton Edward yeoman 586083 586083 Hoton, Edward, of Langton, yeoman 18
5110165 2389383 2389383 defendant Deny John husbandman 586083 586083 Deny, John, of Langton, husbandman 1
5148591 2400714 2400714 defendant Whitwode John gent 586083 586083 Whitwode, John, of Langton, gent 0
5148592 2400714 2400714 defendant Forster John husbandman 586083 586083 Forster, John, of Langton, husbandman 1
5183425 2410894 2410894 defendant Forster John husbandman 586083 586083 Forster, John, of Langton, husbandman 0

Next page

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