names

60 rows where place_id = 590003

✎ 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
3599562 1867500 1867500 defendant Browene Richard yeoman 590003 590003 Browene, Richard, of tateshale, yeoman 3
3687907 1922379 1922379 defendant Tyndale Roland gent 590003 590003 Tyndale, Roland, of Tateshale, gent 0
3695473 1924806 1924806 defendant Sewell John laborer 590003 590003 Sewell, John, of Tateshale, laborer 3
3698120 1925638 1925638 defendant Funk John butcher 590003 590003 Funk, John, of Tateshale, butcher 0
3698121 1925638 1925638 defendant Freshemere William husbandman 590003 590003 Freshemere, William, of Tateshale, husbandman 1
3699620 1926107 1926107 defendant Tyndale Roland gent 590003 590003 Tyndale, Roland, of Tateshale, gent 0
3711820 1930012 1930012 plaintiff Tyndale Philip gent 590003 590003 Tyndale, Philip, of Tateshale, gent 0
3711821 1930012 1930012 defendant Holt Richard yeoman 590003 590003 Holt, Richard, of Tateshale, yeoman 0
3739978 1938725 1938725 plaintiff Ramsey John clerk 590003 590003 Ramsey, John, of Tateshale, clerk 0
3782787 1952364 1952364 plaintiff Jakson Robert laborer 590003 590003 Jakson, Robert, of Tateshale, laborer 0
3803253 1958922 1958922 plaintiff Ramsey John clerk 590003 590003 Ramsey, John, of Tateshale, clerk 0
3829963 1967265 1967265 defendant Holt Richard husbandman 590003 590003 Holt, Richard, of Tateshale, husbandman 0
3829964 1967265 1967265 defendant Randall Richard husbandman 590003 590003 Randall, Richard, of Tateshale, husbandman 1
3837508 1969638 1969638 defendant Clynton Edward   590003 590003 Clynton, Edward, of Tateshale, knight, Lord Clynton 0
4467514 2190520 2190520 defendant Bomour Richard   590003 590003 Bomour, Richard, of Tateshale 0
4473309 2192311 2192311 plaintiff Cromwell Ralph de   590003 590003 Cromwell, Ralph de, of Tateshale, knight 0
4473312 2192312 2192312 plaintiff Cromwell Ralph de   590003 590003 Cromwell, Ralph de, of Tateshale, knight 0
4473314 2192313 2192313 plaintiff Cromwell Ralph de   590003 590003 Cromwell, Ralph de, of Tateshale, knight 0
4473317 2192314 2192314 plaintiff Cromwell Ralph de   590003 590003 Cromwell, Ralph de, of Tateshale, knight 0
4473319 2192315 2192315 plaintiff Cromwell Ralph de   590003 590003 Cromwell, Ralph de, of Tateshale, knight 0
4473321 2192316 2192316 plaintiff Cromwell Ralph de   590003 590003 Cromwell, Ralph de, of Tateshale, knight 0
4473325 2192317 2192317 plaintiff Cromwell Ralph de   590003 590003 Cromwell, Ralph de, of Tateshale, knight 0
4512781 2204432 2204432 plaintiff Bramelay John   590003 590003 Bramelay, John, of Tateshale 0
4523423 2207646 2207646 defendant Bramley John   590003 590003 Bramley, John, of Tateshale 0
4852465 2312189 2312189 plaintiff Goouk Thomas   590003 590003 Goouk, Thomas, of Tateshale 2
4897498 2325878 2325878 defendant Forest William chaplain 590003 590003 Forest, William, of Tateshale, chaplain 0
4943912 2340061 2340061 defendant Underwod John husbandman 590003 590003 Underwod, John, of Tateshale, son of Underwod, Thomas, of Gamelston, husbandman 0
5101672 2386909 2386909 defendant Sawer Robert tiler 590003 590003 Sawer, Robert, of Tateshale, tiler 10
5102479 2387127 2387127 plaintiff Bethum William esq 590003 590003 Bethum, William, of Tateshale, esq 0
5107854 2388735 2388735 defendant Giltofte John butcher 590003 590003 Giltofte, John, of Tateshale, butcher 1
5107855 2388735 2388735 defendant Giltofte William laborer 590003 590003 Giltofte, William, of Tateshale, laborer 2
5107856 2388735 2388735 defendant Giltofte Robert laborer 590003 590003 Giltofte, Robert, of Tateshale, laborer 3
5117910 2391667 2391667 defendant Wryght Thomas husbandman 590003 590003 Wryght, Thomas, of Tateshale, husbandman 0
5117911 2391667 2391667 defendant Wryght John laborer 590003 590003 Wryght, John, of Tateshale, laborer 1
5121161 2392615 2392615 defendant Whelpyngton Peter laborer 590003 590003 Whelpyngton, Peter, of Tateshale, laborer 1
5126014 2394093 2394093 plaintiff Bethum William esq 590003 590003 Bethum, William, of Tateshale, esq 0
5126016 2394094 2394094 plaintiff Bethum William esq 590003 590003 Bethum, William, of Tateshale, esq 0
5169701 2406879 2406879 plaintiff Gygur John   590003 590003 Gygur, John, of Tateshale, master or warden, chaplain of the college or house of alms, of Holy Trinity 0
5182539 2410645 2410645 defendant Hoberd John   590003 590003 Hoberd, John, of Tateshale, boat man 2
5187118 2411960 2411960 defendant Saperton William yeoman 590003 590003 Saperton, William, of Tateshale, yeoman 3
5217068 2420732 2420732 defendant Holand Henry yeoman 590003 590003 Holand, Henry, of Tateshale, yeoman 1
5229520 2424246 2424246 defendant Hubbard John yeoman 590003 590003 Hubbard, John, of Tateshale, yeoman 0
5271550 2436774 2436774 defendant Taverner Nicholas yeoman 590003 590003 Taverner, Nicholas, of Tateshale, yeoman 1
5302492 2445715 2445715 defendant Whitby Stephen gent 590003 590003 Whitby, Stephen, of Tateshale, gent 0
5340112 2457117 2457117 defendant Leke Henry   590003 590003 Leke, Henry, of Tateshale, freemason 1
5343860 2458266 2458266 defendant Aby Thomas barber 590003 590003 Aby, Thomas, of Tateshale, barber 0
5370675 2466418 2466418 plaintiff Gygur John clerk & Warden of the College of the Holy Trinity 590003 590003 Gygur, John, of Tateshale, clerk & Warden of the College of the Holy Trinity 0
5388055 2471644 2471644 plaintiff Gigur John   590003 590003 Gigur, John, of Tateshale, warden of Holy Trinity College 0
5388127 2471662 2471662 defendant Fyssher (illegible) laborer 590003 590003 Fyssher, _, of Tateshale, laborer 6
5401058 2475368 2475368 plaintiff Gygur John   590003 590003 Gygur, John, of Tateshale, warden of the College of the Holy Trinity 0
5414089 2479151 2479151 plaintiff Gygur John   590003 590003 Gygur, John, of Tateshale, warden of Holy Trinity College 0
5427774 2483266 2483266 plaintiff Eygur John   590003 590003 Eygur, John, of Tateshale, warden of Holy Trinity College 0
5446205 2488751 2488751 plaintiff Gigur John   590003 590003 Gigur, John, of Tateshale, warden of Holy Trinity college 0
5446631 2488884 2488884 plaintiff Gygur John   590003 590003 Gygur, John, of Tateshale, warden of Holy Trinity College 0
5459250 2492671 2492671 plaintiff Gygur John   590003 590003 Gygur, John, of Tateshale, warden of Holy Trinity College 0
5470900 2496227 2496227 plaintiff Gygur John   590003 590003 Gygur, John, of Tateshale, warden of Holy Trinity College 0
5482742 2499784 2499784 plaintiff Hoberd John   590003 590003 Hoberd, John, of Tateshale 0
5487129 2501048 2501048 defendant Conny Thomas mercer 590003 590003 Conny, Thomas, of Tateshale, mercer 0
5589028 2531578 2531578 defendant Fryston William buther 590003 590003 Fryston, William, of Tateshale, buther 1
5600319 2534988 2534988 plaintiff Hevyn Edward (legal representative) 590003 590003 Hevyn, Edward, of Tateshale, gent, executors of 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);