names

82 rows where place_id = 600629

✎ 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
3641842 1907899 1907899 defendant Beverley William husbandman 600629 600629 Beverley, William, of Kirton, husbandman 0
3641846 1907900 1907900 defendant Albon Thomas laborer 600629 600629 Albon, Thomas, of Kirton, laborer 2
3641847 1907900 1907900 defendant Beyll Thomas laborer 600629 600629 Beyll, Thomas, of Kirton, laborer 3
3641848 1907900 1907900 defendant Barfot John laborer 600629 600629 Barfot, John, of Kirton, laborer 4
3641849 1907900 1907900 defendant Eylond Thomas laborer 600629 600629 Eylond, Thomas, of Kirton, laborer 5
3641850 1907900 1907900 defendant Kechyn Thomas laborer 600629 600629 Kechyn, Thomas, of Kirton, laborer 6
3641851 1907900 1907900 defendant Hopkynson Alan, junior husbandman 600629 600629 Hopkynson, Alan, junior, of Kirton, husbandman 7
3736846 1937779 1937779 defendant Elryck alias Arley William   600629 600629 Elryck alias Arley, William, of Kirton, yeoman, son of Elryck, Thomas 1
3775523 1950088 1950088 plaintiff Bodlegh John clothier 600629 600629 Bodlegh, John, of Kirton, clothier 0
3796783 1956878 1956878 defendant Gose John husbandman 600629 600629 Gose, John, of Kirton, husbandman 0
3797051 1956959 1956959 plaintiff Freman William (legal representative) 600629 600629 Freman, William, of Kirton, yeoman, executors of 0
3798656 1957490 1957490 defendant Bullen John yeoman 600629 600629 Bullen, John, of Kirton, yeoman 0
3832200 1967983 1967983 defendant Cony Thomas, senior husbandman 600629 600629 Cony, Thomas, senior, of Kirton, husbandman 0
3881566 1984096 1984096 defendant Bayly Thomas laborer 600629 600629 Bayly, Thomas, of Kirton, laborer 0
3899605 1990087 1990087 defendant Roo John miller 600629 600629 Roo, John, of Kirton, miller 0
3899606 1990087 1990087 defendant Drew James husbandman 600629 600629 Drew, James, of Kirton, husbandman 1
3899607 1990087 1990087 defendant Hele John husbandman 600629 600629 Hele, John, of Kirton, husbandman 2
3904085 1991608 1991608 defendant Person Thomas husbandman 600629 600629 Person, Thomas, of Kirton, husbandman 0
3905474 1992101 1992101 defendant Pedder John Hisbandman 600629 600629 Pedder, John, of Kirton, Hisbandman 0
3905475 1992101 1992101 defendant Hede Thomas chaplain 600629 600629 Hede, Thomas, of Kirton, chaplain 1
3928243 1999781 1999781 defendant Brygges William chapman 600629 600629 Brygges, William, of Kirton, chapman 1
4069583 2049403 2049403 defendant Horsfall John clothier 600629 600629 Horsfall, John, of Kirton, clothier 0
4101689 2060910 2060910 defendant Steper William yeoman 600629 600629 Steper, William, of Kirton, yeoman 0
4116625 2066239 2066239 defendant Lobdon John, senior husbandman 600629 600629 Lobdon, John, senior, of Kirton, or of Crediton, Devon, husbandman 0
4116626 2066239 2066239 defendant Lobdon William laborer 600629 600629 Lobdon, William, of Kirton, laborer 1
4131505 2071587 2071587 defendant Harryson Peter yeoman 600629 600629 Harryson, Peter, of Kirton, yeoman 1
4135287 2072939 2072939 defendant Steper Richard yeoman 600629 600629 Steper, Richard, of Kirton, yeoman 0
4135289 2072940 2072940 defendant Steper William yeoman 600629 600629 Steper, William, of Kirton, yeoman 0
4155220 2079918 2079918 defendant Harryson Peter yeoman 600629 600629 Harryson, Peter, of Kirton, yeoman 1
4174134 2086407 2086407 defendant Sharpe William yeoman 600629 600629 Sharpe, William, of Kirton, yeoman 0
4182982 2089528 2089528 defendant Steeper William yeoman 600629 600629 Steeper, William, of Kirton, yeoman 0
4187218 2091021 2091021 defendant Harrison Peter yeoman 600629 600629 Harrison, Peter, of Kirton, yeoman 0
4197386 2094640 2094640 defendant Shape William yeoman 600629 600629 Shape, William, of Kirton, yeoman 0
4210820 2099343 2099343 defendant Harrison Peter yeoman 600629 600629 Harrison, Peter, of Kirton, yeoman 0
4221875 2103148 2103148 defendant Appleyard Richard cordwainer 600629 600629 Appleyard, Richard, of Kirton, cordwainer 0
4231668 2106578 2106578 defendant Hunte Alan yeoman 600629 600629 Hunte, Alan, of Kirton, yeoman 2
4239511 2109444 2109444 defendant Tonerd Anthony yeoman 600629 600629 Tonerd, Anthony, of Kirton, yeoman 0
4240606 2109841 2109841 defendant Hunte Adam yeoman 600629 600629 Hunte, Adam, of Kirton, yeoman 2
4247832 2112260 2112260 defendant Tonard Anthony yeoman 600629 600629 Tonard, Anthony, of Kirton, yeoman 0
4251706 2113560 2113560 defendant Conye Richard gent 600629 600629 Conye, Richard, of Kirton, gent 0
4261808 2116904 2116904 defendant Stevenson Thomas gent 600629 600629 Stevenson, Thomas, of Kirton, gent 0
4261811 2116904 2116904 defendant Wood William yeoman 600629 600629 Wood, William, of Kirton, yeoman 3
4277585 2122083 2122083 defendant Baylton Richard butcher 600629 600629 (Baylton, Richard, of Kirton, butcher 1
4279232 2122667 2122667 defendant Gibson Thomas husbandman 600629 600629 Gibson, Thomas, of Kirton, husbandman 0
4282319 2123716 2123716 defendant Tunard Richard yeoman 600629 600629 Tunard, Richard, of Kirton, yeoman 1
4282687 2123848 2123848 defendant Conye Roger yeoman 600629 600629 Conye, Roger, of Kirton, yeoman 0
4282689 2123849 2123849 defendant Conye Roger yeoman 600629 600629 Conye, Roger, of Kirton, yeoman 0
4291443 2127016 2127016 defendant Conye Roger yeoman 600629 600629 Conye, Roger, of Kirton, yeoman 0
4292006 2127216 2127216 defendant Skelton George yeoman 600629 600629 (Skelton, George, of Kirton, yeoman 1
4292010 2127217 2127217 defendant Skelton George yeoman 600629 600629 (Skelton, George, of Kirton, yeoman 1
4358116 2150082 2150082 defendant Howson George yeoman 600629 600629 Howson, George, of Kirton, yeoman 1
4371129 2154734 2154734 defendant Gibson Robert yeoman 600629 600629 Gibson, Robert, of Kirton, yeoman 0
4397780 2163834 2163834 defendant Ide Alexander yeoman 600629 600629 Ide, Alexander, of Kirton, yeoman 0
4567004 2221237 2221237 defendant Marsshal Robert   600629 600629 Marsshal, Robert, of Kirton 6
4646948 2245169 2245169 defendant H_ John   600629 600629 H_, John, of Kirton 1
4663791 2250159 2250159 defendant Bullok John husbandman 600629 600629 Bullok, John, of Kirton, husbandman 4
4785843 2291605 2291605 defendant Arkell Robert husbandman 600629 600629 Arkell, Robert, of Kirton, husbandman 0
4785844 2291605 2291605 defendant Cupildyk William husbandman 600629 600629 Cupildyk, William, of Kirton, husbandman 1
4785845 2291605 2291605 defendant Smyth Thomas husbandman 600629 600629 Smyth, Thomas, of Kirton, husbandman 2
4785846 2291605 2291605 defendant Smyth John husbandman 600629 600629 Smyth, John, of Kirton, husbandman 3
4802065 2296831 2296831 defendant Warner John husbandman 600629 600629 Warner, John, of Kirton, husbandman 1
4873396 2318636 2318636 defendant Smyth Richard husbandman 600629 600629 Smyth, Richard, of Kirton, husbandman 0
4873397 2318636 2318636 defendant atte Hall Richard husbandman 600629 600629 atte Hall, Richard, of Kirton, husbandman 1
4873399 2318636 2318636 defendant Takyll John clerk 600629 600629 Takyll, John, of Kirton, clerk 3
4880117 2320690 2320690 defendant Priour Thomas clerk 600629 600629 Priour, Thomas, of Kirton, clerk 2
4907740 2328983 2328983 defendant Gery Robert husbandman 600629 600629 Gery, Robert, of Kirton, husbandman 3
4919026 2332462 2332462 defendant Orchard Robert tanner 600629 600629 Orchard, Robert, of Kirton, tanner 0
4946592 2340930 2340930 defendant Carpenter William ostler 600629 600629 Carpenter, William, of Kirton, ostler 3
4982692 2351736 2351736 defendant Wodelegh John merchant 600629 600629 Wodelegh, John, of Kirton, merchant 1
4988799 2353605 2353605 defendant Swathela John husbandman 600629 600629 Swathela, John, of Kirton, husbandman 2
5036424 2367510 2367510 defendant Launcelevy John husbandman 600629 600629 Launcelevy, John, of Kirton, husbandman 1
5045648 2370332 2370332 defendant Norton Robert gent 600629 600629 Norton, Robert, of Kirton, gent 0
5128507 2394811 2394811 defendant Gater William spicer 600629 600629 Gater, William, of Kirton, spicer 1
5147654 2400451 2400451 defendant Fitz William smith 600629 600629 Fitz, William, of Kirton, smith 3
5165171 2405556 2405556 defendant Bate John yeoman 600629 600629 Bate, John, of Kirton, yeoman 1
5167266 2406156 2406156 defendant Fitz William smith 600629 600629 Fitz, William, of Kirton, smith 3
5174808 2408329 2408329 defendant Norton Robert yeoman 600629 600629 Norton, Robert, of Kirton, yeoman 3
5255587 2431865 2431865 defendant Prewe Giles   600629 600629 Prewe, Giles, of Kirton, mason 1
5263197 2434235 2434235 defendant Loke Henry husbandman 600629 600629 Loke, Henry, of Kirton, husbandman 0
5381503 2469768 2469768 defendant Milner William   600629 600629 Milner, William, of Kirton, parson 1
5442467 2487660 2487660 defendant Corbrigge John mercer 600629 600629 Corbrigge, John, of Kirton, mercer 2
5542654 2517821 2517821 defendant Wilbram Thomas, junior husbandman 600629 600629 Wilbram, Thomas, junior, of Kirton, 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);