names

88 rows where place_id = 630163

✎ 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
3792839 1955610 1955610 defendant Towers Guy gent 630163 630163 Towers, Guy, of Tetney, gent 0
3840026 1970445 1970445 defendant Lockyng Robert husbandman 630163 630163 Lockyng, Robert, of Tetney, husbandman 2
3851295 1974004 1974004 defendant Tysedale John husbandman 630163 630163 Tysedale, John, of Tetney, husbandman 0
3851296 1974004 1974004 defendant Tysedale Martin salter 630163 630163 Tysedale, Martin, of Tetney, salter 1
3878223 1982964 1982964 defendant Bower Thomas husbandman 630163 630163 Bower, Thomas, of Tetney, husbandman 2
3878225 1982964 1982964 defendant Vicars Henry husbandman 630163 630163 Vicars, Henry, of Tetney, husbandman 4
3908276 1993064 1993064 defendant Darwyn Thomas gent 630163 630163 Darwyn, Thomas, of Tetney, gent 0
3908277 1993064 1993064 defendant More Roger laborer 630163 630163 More, Roger, of Tetney, laborer 1
4010713 2028603 2028603 defendant Leache William yeoman 630163 630163 Leache, William, of Tetney, yeoman 0
4010715 2028604 2028604 defendant Latche William yeoman 630163 630163 Latche, William, of Tetney, yeoman 0
4071572 2050127 2050127 defendant Gretham Edward (legal representative) 630163 630163 Gretham, Edward, of Tetney, yeoman, executrix of 1
4071573 2050127 2050127 defendant Gretham Mary widow 630163 630163 Gretham, Mary, of Tetney, widow 2
4085551 2055104 2055104 defendant Dowson Richard yeoman 630163 630163 Dowson, Richard, of Tetney, yeoman 0
4085553 2055105 2055105 defendant Dowson Richard yeoman 630163 630163 Dowson, Richard, of Tetney, yeoman 0
4086366 2055399 2055399 defendant Jekill Richard yeoman 630163 630163 Jekill, Richard, of Tetney, yeoman 0
4089217 2056429 2056429 defendant Kell Thomas husbandman 630163 630163 Kell, Thomas, of Tetney, husbandman 0
4089218 2056429 2056429 defendant Oreby Robert husbandman 630163 630163 Oreby, Robert, of Tetney, husbandman 1
4089220 2056430 2056430 defendant Kell Thomas husbandman 630163 630163 Kell, Thomas, of Tetney, husbandman 0
4089221 2056430 2056430 defendant Oreby Robert husbandman 630163 630163 Oreby, Robert, of Tetney, husbandman 1
4095672 2058783 2058783 defendant Est Nicholas husbandman 630163 630163 Est Nicholas, of Tetney, husbandman 0
4095673 2058783 2058783 defendant Tharold Henry, senior husbandman 630163 630163 Tharold, Henry, senior, of Tetney, husbandman 1
4095678 2058785 2058785 defendant Thomas Richard, junior husbandman 630163 630163 Thomas, Richard, junior, of Tetney, husbandman 0
4095679 2058785 2058785 defendant Hyll Edward husbandman 630163 630163 Hyll, Edward, of Tetney, husbandman 1
4095680 2058785 2058785 defendant Hyll John husbandman 630163 630163 Hyll, John, of Tetney, husbandman 2
4102280 2061108 2061108 defendant Leache William mercer 630163 630163 Leache, William, of Tetney, mercer 0
4125430 2069375 2069375 defendant Windle John husbandman 630163 630163 Windle, John, of Tetney, husbandman 2
4127764 2070221 2070221 defendant Myffyn Philip yeoman 630163 630163 Myffyn, Philip, of Tetney, yeoman 0
4168209 2084368 2084368 defendant Atkinson Richard husbandman 630163 630163 Atkinson, Richard, of Tetney, husbandman 1
4185154 2090314 2090314 defendant Wyndell Francis yeoman 630163 630163 Wyndell, Francis, of Tetney, yeoman 1
4185155 2090314 2090314 defendant Wyndell John yeoman 630163 630163 Wyndell, John, of Tetney, yeoman 2
4188498 2091449 2091449 defendant Teisdale Richard   630163 630163 Teisdale, Richard, of Tetney husbandman 1
4189647 2091875 2091875 defendant Myffyn Philip   630163 630163 Myffyn, Philip, of Tetney 0
4189648 2091875 2091875 defendant Teisdale Edmund yeoman 630163 630163 Teisdale, Edmund, of Tetney, yeoman 1
4189650 2091876 2091876 defendant Myffyn Philip   630163 630163 Myffyn, Philip, of Tetney 0
4189651 2091876 2091876 defendant Teisdale Edmund yeoman 630163 630163 Teisdale, Edmund, of Tetney, yeoman 1
4198978 2095200 2095200 defendant Jeckyll Richard husbandman 630163 630163 Jeckyll, Richard, of Tetney, husbandman 0
4198979 2095200 2095200 defendant Caborne Richard husbandman 630163 630163 Caborne, Richard, of Tetney, husbandman 1
4198981 2095201 2095201 defendant Myffen Philip yeoman 630163 630163 Myffen, Philip, of Tetney, yeoman 0
4227626 2105148 2105148 defendant Wyndell Thomas yeoman 630163 630163 Wyndell, Thomas, of Tetney, yeoman 0
4228729 2105533 2105533 defendant Windle Thomas yeoman 630163 630163 Windle, Thomas, of Tetney, yeoman 1
4237250 2108615 2108615 defendant Windle Thomas yeoman 630163 630163 Windle, Thomas, of Tetney, yeoman 1
4238904 2109229 2109229 defendant Windell Thomas yeoman 630163 630163 Windell, Thomas, of Tetney, yeoman 3
4239992 2109625 2109625 defendant Wyndle Thomas yeoman 630163 630163 Wyndle, Thomas, of Tetney, yeoman 0
4248235 2112401 2112401 defendant Wyndle Thomas yeoman 630163 630163 Wyndle, Thomas, of Tetney, yeoman 0
4271201 2119944 2119944 defendant Lacon Edward gent 630163 630163 Lacon, Edward, of Tetney, gent 0
4280040 2122928 2122928 defendant Grene Edward yeoman 630163 630163 Grene, Edward, of Tetney, yeoman 0
4299187 2129807 2129807 defendant Watson Richard laborer 630163 630163 Watson, Richard, of Tetney, laborer 0
4299188 2129807 2129807 defendant Nelson Thomas laborer 630163 630163 Nelson, Thomas, of Tetney, laborer 1
4329755 2140247 2140247 defendant Jeckill John yeoman 630163 630163 Jeckill, John, of Tetney, yeoman 0
4339676 2143648 2143648 defendant Lacon Edward gent 630163 630163 Lacon, Edward, of Tetney, gent 1
4355060 2148989 2148989 defendant Lacon Edward gent 630163 630163 Lacon, Edward, of Tetney, gent 0
4355061 2148989 2148989 defendant Lacon Lionel gent 630163 630163 Lacon, Lionel, of Tetney, gent 1
4362983 2151824 2151824 defendant Lacon Edward gent 630163 630163 Lacon, Edward, of Tetney, gent 0
4369323 2154092 2154092 defendant Yonge Edward yeoman 630163 630163 Yonge, Edward, of Tetney, yeoman 0
4372647 2155292 2155292 defendant Halliday Michael miller 630163 630163 Halliday, Michael, of Tetney, miller 0
4412748 2168857 2168857 defendant Ridinge Samuel yeoman 630163 630163 Ridinge, Samuel, of Tetney, yeoman 0
4756578 2282421 2282421 defendant Tetney Alan shipman 630163 630163 Tetney, Alan, of Tetney, shipman 1
4756579 2282421 2282421 defendant Tetney John de shipman 630163 630163 Tetney, John de, of Tetney, shipman 2
5044170 2369883 2369883 defendant Neuton Simon gent 630163 630163 Neuton, Simon, of Tetney, gent 2
5044171 2369883 2369883 defendant Brygge John husbandman 630163 630163 Brygge, John, of Tetney, husbandman 3
5082569 2381293 2381293 plaintiff Neweton Simon gent 630163 630163 Neweton, Simon, of Tetney, gent 1
5131935 2395825 2395825 defendant Cosyn William smith 630163 630163 Cosyn, William, of Tetney, smith 0
5131936 2395825 2395825 defendant Thorald Richard husbandman 630163 630163 Thorald, Richard, of Tetney, husbandman 1
5140160 2398221 2398221 plaintiff Stevynson Margaret widow 630163 630163 Stevynson, Margaret, of Tetney, widow 0
5151512 2401591 2401591 defendant Cosyn William smith 630163 630163 Cosyn, William, of Tetney, smith 0
5151513 2401591 2401591 defendant Thorald Richard husbandman 630163 630163 Thorald, Richard, of Tetney, husbandman 1
5169641 2406857 2406857 defendant Cosyn William smith 630163 630163 Cosyn, William, of Tetney, smith 0
5169642 2406857 2406857 defendant Thorald Richard husbandman 630163 630163 Thorald, Richard, of Tetney, husbandman 1
5243055 2428173 2428173 plaintiff Neuton Simon (legal representative) 630163 630163 Neuton, Simon, of Tetney, executor of 0
5243059 2428173 2428173 defendant Halyngton Nicholas husbandman 630163 630163 Halyngton, Nicholas, of Tetney, husbandman 2
5318802 2450714 2450714 defendant Gekyll Thomas chaplain 630163 630163 (Gekyll, Thomas, of Tetney, chaplain 1
5326352 2452968 2452968 defendant Webster John husbandman 630163 630163 Webster, John, of Tetney, husbandman 4
5330296 2454135 2454135 defendant Neuton John gent 630163 630163 Neuton, John, of Tetney, gent 0
5355564 2461811 2461811 defendant Neweton John gent 630163 630163 Neweton, John, of Tetney, or of Louth, Lincs, gent 0
5361128 2463509 2463509 defendant Waltham William husbandman 630163 630163 Waltham, William, of Tetney, husbandman 2
5361129 2463509 2463509 defendant Clerke Vincent husbandman 630163 630163 Clerke, Vincent, of Tetney, husbandman 3
5362827 2464016 2464016 defendant Waltham William husbandman 630163 630163 Waltham, William, of Tetney, husbandman 1
5362884 2464037 2464037 defendant Neuton John gent 630163 630163 Neuton, John, of Tetney, gent 0
5362886 2464038 2464038 defendant Neuton John gent 630163 630163 Neuton, John, of Tetney, gent 0
5362888 2464039 2464039 defendant Neuton John gent 630163 630163 Neuton, John, of Tetney, gent 0
5362890 2464040 2464040 defendant Neuton John gent 630163 630163 Neuton, John, of Tetney, gent 0
5362892 2464041 2464041 defendant Neuton John gent 630163 630163 Neuton, John, of Tetney, gent 0
5486965 2500997 2500997 defendant Waltham William yeoman 630163 630163 Waltham, William, of Tetney, yeoman 0
5577311 2527960 2527960 defendant Towres Thomas yeoman 630163 630163 Towres, Thomas, of Tetney, yeoman 0
5577312 2527960 2527960 defendant Clerk Thomas husbandman 630163 630163 Clerk, Thomas, of Tetney, husbandman 1
5577313 2527960 2527960 defendant Ayre Richard husbandman 630163 630163 Ayre, Richard, of Tetney, husbandman 2
5577314 2527960 2527960 defendant Jakson John husbandman 630163 630163 Jakson, John, of Tetney, husbandman 3
5586483 2530811 2530811 defendant Tayllour Thomas husbandman 630163 630163 Tayllour, Thomas, of Tetney, husbandman 2

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