names

69 rows where place_id = 610712

✎ 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
3684833 1921392 1921392 defendant Hagas Christopher gent 610712 610712 Hagas, Christopher, of Esterkele, gent 0
3695163 1924708 1924708 defendant Hagas Christopher merchant 610712 610712 Hagas, Christopher, of Esterkele, merchant 0
3696545 1925149 1925149 defendant Grebby John thatcher 610712 610712 Grebby, John, of Esterkele, thatcher 0
3699999 1926233 1926233 defendant Hagas Christopher gent 610712 610712 Hagas, Christopher, of Esterkele, gent 0
3701975 1926871 1926871 defendant Bonham James yeoman 610712 610712 Bonham, James, of Esterkele, yeoman 0
3707405 1928607 1928607 defendant Coke John tailor 610712 610712 Coke, John, of Esterkele, tailor 0
3707407 1928608 1928608 defendant Coke John tailor 610712 610712 Coke, John, of Esterkele, tailor 0
3708763 1929037 1929037 defendant Taylour John draper 610712 610712 Taylour, John, of Esterkele, draper 0
3735224 1937253 1937253 defendant Burton Thomas clerk 610712 610712 Burton, Thomas, of Esterkele, clerk 0
3735225 1937253 1937253 defendant Stykney John yeoman 610712 610712 Stykney, John, of Esterkele, yeoman 1
3735226 1937253 1937253 defendant Tayllour Robert laborer 610712 610712 Tayllour, Robert, of Esterkele, laborer 2
3735227 1937253 1937253 defendant Poynton John laborer 610712 610712 Poynton, John, of Esterkele, laborer 3
3735228 1937253 1937253 defendant Taillour John, junior yeoman 610712 610712 Taillour, John, junior, of Esterkele, yeoman 4
3735229 1937253 1937253 defendant Masyng Thomas laborer 610712 610712 Masyng, Thomas, of Esterkele, laborer 5
3753258 1942958 1942958 defendant Gregby John husbandman 610712 610712 Gregby, John, of Esterkele, husbandman 3
3753738 1943110 1943110 defendant Ferrour William laborer 610712 610712 Ferrour, William, of Esterkele, laborer 3
3849293 1973372 1973372 defendant Reed John esq 610712 610712 Reed, John, of Esterkele, esq 0
3853125 1974597 1974597 defendant Benet John husbandman 610712 610712 Benet, John, of Esterkele, husbandman 0
3864398 1978290 1978290 defendant Reed John esq 610712 610712 Reed, John, of Esterkele, esq 0
3874318 1981636 1981636 defendant Morrys Robert husbandman 610712 610712 Morrys, Robert, of Esterkele, husbandman 0
3960808 2010884 2010884 defendant Taylour Thomas draper 610712 610712 Taylour, Thomas, of Esterkele, draper 0
3993218 2022319 2022319 defendant Granger Richard husbandman 610712 610712 Granger, Richard, of Esterkele, husbandman 0
4001160 2025194 2025194 defendant Halton alias Granger Richard butcher 610712 610712 Halton alias Granger, Richard, of Esterkele, butcher 0
4005697 2026810 2026810 defendant Johnson Thomas weaver 610712 610712 Johnson, Thomas, of Esterkele, weaver 0
4027856 2034610 2034610 defendant Lincoln William yeoman 610712 610712 Lincoln, William, of Esterkele, yeoman 0
4042425 2039772 2039772 defendant Kyrkeman Leonard gent 610712 610712 Kyrkeman, Leonard, of Esterkele, gent 0
4160573 2081775 2081775 defendant Kyrkman Leonard gent 610712 610712 Kyrkman, Leonard, of Esterkele, gent 0
4485861 2196286 2196286 plaintiff Robynson John clerk 610712 610712 Robynson, John, of Esterkele, clerk 0
4485862 2196286 2196286 defendant Louthe John de   610712 610712 Louthe, John de, of Esterkele 0
4489205 2197340 2197340 plaintiff Tetford Robert   610712 610712 Tetford, Robert, of Esterkele 0
4552920 2216857 2216857 defendant Smyth (illegible)   610712 610712 Smyth, _, of Esterkele 0
4552921 2216857 2216857 defendant Brew_ Thomas   610712 610712 Brew_, Thomas, of Esterkele 1
4609127 2233960 2233960 defendant Tewer Richard   610712 610712 Tewer, Richard, of Esterkele 0
4625724 2239005 2239005 defendant Herryson William   610712 610712 Herryson, William, of Esterkele 2
4687318 2261639 2261639 defendant Milner John milner 610712 610712 Milner, John, of Esterkele, milner 0
4688438 2261951 2261951 plaintiff Tetford William   610712 610712 Tetford, William, of Esterkele 0
4725074 2273138 2273138 defendant Reyd Walter husbandman 610712 610712 Reyd, Walter, of Esterkele, husbandman 0
4790213 2293022 2293022 defendant Spryng John barber 610712 610712 Spryng, John, of Esterkele, barber 3
4790214 2293022 2293022 defendant de Bleseby William husbandman 610712 610712 de Bleseby, William, of Esterkele, husbandman 4
4801617 2296690 2296690 defendant de Brigge George husbandman 610712 610712 de Brigge, George, of Esterkele, husbandman 0
4801619 2296690 2296690 defendant Brewer Roger husbandman 610712 610712 Brewer, Roger, of Esterkele, husbandman 2
4860285 2314575 2314575 defendant Grene Thomas chapman 610712 610712 Grene, Thomas, of Esterkele, chapman 0
4884329 2322004 2322004 defendant Gybson William husbandman 610712 610712 Gybson, William, of Esterkele, husbandman 2
4955308 2343544 2343544 defendant Broun John Atkynson husbandman 610712 610712 Broun, John Atkynson, of Esterkele, husbandman 2
4955580 2343633 2343633 plaintiff Tetforth William   610712 610712 Tetforth, William, of Esterkele, junior, son of Tetforth, Robert, of Esterkeell 0
4956849 2344006 2344006 defendant Owete William, senior husbandman 610712 610712 Owete, William, senior, of Esterkele, husbandman 0
4961274 2345340 2345340 defendant Kirketon Thomas clerk 610712 610712 Kirketon, Thomas, of Esterkele, clerk 1
4961279 2345341 2345341 plaintiff Blaunche John   610712 610712 Blaunche, John, of Esterkele 0
4967344 2347174 2347174 defendant Spryng Thomas laborer 610712 610712 Spryng, Thomas, of Esterkele, laborer 12
4987748 2353300 2353300 defendant Davy William husbandman 610712 610712 Davy, William, of Esterkele, husbandman 3
4987755 2353301 2353301 plaintiff Blaunche John   610712 610712 Blaunche, John, of Esterkele 0
4998429 2356409 2356409 plaintiff Grene Thomas   610712 610712 Grene, Thomas, of Esterkele 1
5008744 2359447 2359447 plaintiff Tetforth William merchant 610712 610712 Tetforth, William, of Esterkele, merchant 0
5016000 2361565 2361565 defendant Pynnar Alan yeoman 610712 610712 Pynnar, Alan, of Esterkele, yeoman 1
5024703 2364146 2364146 defendant Cook John husbandman 610712 610712 Cook, John, of Esterkele, husbandman 0
5027899 2365039 2365039 defendant Grene Thomas husbandman 610712 610712 Grene, Thomas, of Esterkele, husbandman 0
5039524 2368471 2368471 plaintiff Blaunche John   610712 610712 Blaunche, John, of Esterkele 0
5085853 2382257 2382257 defendant Tathewell William husandman 610712 610712 Tathewell, William, of Esterkele, husandman 2
5091520 2383910 2383910 defendant Grene Thomas yeoman 610712 610712 Grene, Thomas, of Esterkele, yeoman 1
5129577 2395138 2395138 defendant Byrkewode Robert husbandman 610712 610712 Byrkewode, Robert, of Esterkele, husbandman 0
5168020 2406357 2406357 defendant Byrkewode Robert husbandman 610712 610712 Byrkewode, Robert, of Esterkele, husbandman 0
5196605 2414760 2414760 defendant Twyvell William clerk 610712 610712 Twyvell, William, of Esterkele, clerk 2
5214567 2419989 2419989 defendant Moller William   610712 610712 Moller, William, of Esterkele, wright 0
5214568 2419989 2419989 defendant Grebbey William husbandman 610712 610712 Grebbey, William, of Esterkele, husbandman 1
5231308 2424755 2424755 plaintiff Blaunche John (legal representative) 610712 610712 Blaunche, John, of Esterkele, executors of 0
5263431 2434311 2434311 defendant Bocher John husbandman 610712 610712 Bocher, John, of Esterkele, husbandman 0
5489572 2501762 2501762 defendant Wryght Thomas clerk 610712 610712 Wryght, Thomas, of Esterkele, clerk 0
5528043 2513334 2513334 defendant Atkynson Thomas husbandman 610712 610712 Atkynson, Thomas, of Esterkele, husbandman 0
5552928 2520903 2520903 defendant Fowle Thomas husbandman 610712 610712 Fowle, Thomas, of Esterkele, husbandman 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);