names

212 rows where place_id = 586992

✎ 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
3590168 1864564 1864564 plaintiff Coket Walter   586992 586992 Coket, Walter, of Ingham 2
3619332 1873643 1873643 defendant Clayton Richard yeoman 586992 586992 Clayton, Richard, of Ingham, yeoman 22
3619333 1873643 1873643 defendant Hall Thomas yeoman 586992 586992 Hall, Thomas, of Ingham, yeoman 23
3648512 1909934 1909934 defendant Grene John husbandman 586992 586992 Grene, John, of Ingham, husbandman 3
3671580 1917095 1917095 plaintiff Cokett Thomas   586992 586992 Cokett, Thomas, of Ingham 0
3677617 1919040 1919040 defendant Tyllott Thomas yeoman 586992 586992 Tyllott, Thomas, of Ingham, yeoman 1
3684872 1921405 1921405 defendant Catton William chaplain 586992 586992 Catton, William, of Ingham, chaplain 1
3704643 1927739 1927739 plaintiff Gardener Simon   586992 586992 Gardener, Simon, of Ingham 0
3748730 1941534 1941534 defendant Lacy William yeoman 586992 586992 Lacy, William, of Ingham, yeoman 0
3763235 1946138 1946138 defendant Lacy William yeoman 586992 586992 Lacy, William, of Ingham, yeoman 0
3794192 1956056 1956056 plaintiff Calle John gent 586992 586992 Calle, John, of Ingham, gent 0
3795194 1956363 1956363 defendant Calle John gent 586992 586992 Calle, John, of Ingham, gent 1
3801848 1958474 1958474 defendant Cokett Thomas gent 586992 586992 Cokett, Thomas, of Ingham, gent 0
3807469 1960241 1960241 plaintiff Calle John gent 586992 586992 Calle, John, of Ingham, gent 1
3851191 1973966 1973966 plaintiff Pak Richard yeoman 586992 586992 Pak, Richard, of Ingham, yeoman 0
3859754 1976762 1976762 defendant Cokett Robert (legal representative) 586992 586992 Cokett, Robert, of Ingham, gent, executors of 0
3864063 1978165 1978165 defendant Calle John gent 586992 586992 Calle, John, of Ingham, gent 1
3864723 1978397 1978397 defendant Lumkyn John husbandman 586992 586992 Lumkyn, John, of Ingham, husbandman 1
3876512 1982391 1982391 defendant Garrard Edward husbandman 586992 586992 Garrard, Edward, of Ingham, husbandman 0
3876515 1982391 1982391 defendant Curteys John husbandman 586992 586992 Curteys, John, of Ingham, husbandman 3
3880692 1983806 1983806 defendant Mylam Robert husbandman 586992 586992 Mylam, Robert, of Ingham, husbandman 3
3880697 1983807 1983807 defendant Mylam Robert husbandman 586992 586992 Mylam, Robert, of Ingham, husbandman 1
3897993 1989534 1989534 defendant Tomplyng Thomas mariner 586992 586992 Tomplyng, Thomas, of Ingham, mariner 3
3897998 1989535 1989535 defendant Tomplyng Thomas mariner 586992 586992 Tomplyng, Thomas, of Ingham, mariner 3
3915764 1995650 1995650 defendant Lumkyn John husbandman 586992 586992 Lumkyn, John, of Ingham, husbandman 0
3924334 1998446 1998446 defendant Wymond John tailor 586992 586992 Wymond, John, of Ingham, tailor 0
3959715 2010487 2010487 defendant Eyderman Francis   586992 586992 Eyderman, Francis, of Ingham, surgeon 3
3984233 2019129 2019129 defendant Cooke John husbandman 586992 586992 Cooke, John, of Ingham, husbandman 3
3991254 2021634 2021634 defendant Sayer William yeoman 586992 586992 Sayer, William, of Ingham, yeoman 2
3993089 2022279 2022279 defendant Sayer William yeoman 586992 586992 Sayer, William, of Ingham, yeoman 0
3995116 2023001 2023001 defendant Sayer William yeoman 586992 586992 Sayer, William, of Ingham, yeoman 0
4002621 2025708 2025708 defendant Aylmer William husbandman 586992 586992 Aylmer, William, of Ingham, husbandman 1
4014508 2029913 2029913 defendant Sayer William husbandman 586992 586992 Sayer, William, of Ingham, husbandman 2
4020681 2032124 2032124 defendant Kendall William husbandman 586992 586992 Kendall, William, of Ingham, husbandman 0
4020683 2032124 2032124 defendant Garre- Thomas husbandman 586992 586992 Garre-, Thomas, of Ingham, husbandman 2
4020819 2032172 2032172 defendant Sayer William yeoman 586992 586992 Sayer, William, of Ingham, yeoman 0
4023802 2033217 2033217 defendant Sayer William yeoman 586992 586992 Sayer, William, of Ingham, yeoman 2
4025100 2033638 2033638 defendant Sayer William yeoman 586992 586992 Sayer, William, of Ingham, yeoman 0
4026346 2034067 2034067 defendant Mathewe William salter 586992 586992 Mathewe, William, of Ingham, salter 4
4027010 2034308 2034308 defendant Thurgar John yeoman 586992 586992 Thurgar, John, of Ingham, yeoman 2
4027781 2034586 2034586 defendant Alphyn Miles yeoman 586992 586992 Alphyn, Miles, of Ingham, yeoman 0
4028382 2034804 2034804 plaintiff Coocke Edmund yeoman 586992 586992 Coocke, Edmund, of Ingham, yeoman 0
4028390 2034806 2034806 defendant Kake John husbandman 586992 586992 Kake, John, of Ingham, husbandman 0
4028525 2034854 2034854 defendant Sayer William yeoman 586992 586992 Sayer, William, of Ingham, yeoman 0
4034566 2037035 2037035 defendant Hadley Peter carpenter 586992 586992 Hadley, Peter, of Ingham, carpenter 3
4041390 2039412 2039412 defendant Leggatt Christopher husbandman 586992 586992 Leggatt, Christopher, of Ingham, husbandman 0
4041392 2039413 2039413 defendant Leggatt Christopher husbandman 586992 586992 Leggatt, Christopher, of Ingham, husbandman 0
4045095 2040698 2040698 defendant Sayer William yeoman 586992 586992 Sayer, William, of Ingham, yeoman 0
4045459 2040827 2040827 defendant Awphyn Miles singleman 586992 586992 Awphyn, Miles, of Ingham, yeoman, singleman 0
4057441 2045042 2045042 defendant Sutton Robert husbandman 586992 586992 Sutton, Robert, of Ingham, husbandman 3
4060443 2046137 2046137 defendant Sutton Robert husbandman 586992 586992 Sutton, Robert, of Ingham, husbandman 0
4068734 2049105 2049105 defendant Gurlyng Thomas husbandman 586992 586992 Gurlyng, Thomas, of Ingham, husbandman 0
4076597 2051929 2051929 defendant Cooke John carpenter 586992 586992 Cooke, John, of Ingham, carpenter 2
4078125 2052482 2052482 plaintiff Sutton Robert mariner 586992 586992 Sutton, Robert, of Ingham, mariner 0
4078128 2052482 2052482 defendant Symsen John   586992 586992 Symsen, John, of Ingham, sailor 2
4080495 2053336 2053336 defendant Sutton Robert husbandman 586992 586992 Sutton, Robert, of Ingham, husbandman 2
4087580 2055852 2055852 defendant Leams John, junior weaver 586992 586992 Leams, John, junior, of Ingham, weaver 1
4087581 2055852 2055852 defendant Rose John yeoman 586992 586992 Rose, John, of Ingham, yeoman 2
4091021 2057077 2057077 defendant Evererd Robert yeoman 586992 586992 Evererd, Robert, of Ingham, yeoman 3
4151522 2078654 2078654 defendant Sutton Robert husbandman 586992 586992 Sutton, Robert, of Ingham, husbandman 0
4152225 2078888 2078888 defendant Stone William mariner 586992 586992 Stone, William, of Ingham, mariner 3
4160962 2081906 2081906 defendant Sympson John tailor 586992 586992 Sympson, John, of Ingham, tailor 1
4189057 2091661 2091661 defendant Woodclyffe Henry yeoman 586992 586992 Woodclyffe, Henry, of Ingham, yeoman 0
4189059 2091662 2091662 defendant Woodclyffe Henry yeoman 586992 586992 Woodclyffe, Henry, of Ingham, yeoman 0
4189081 2091671 2091671 defendant Woodlyffe Henry yeoman 586992 586992 Woodlyffe, Henry, of Ingham, yeoman 0
4189213 2091721 2091721 defendant Woodleffe Henry husbandman 586992 586992 Woodleffe, Henry, of Ingham, husbandman 0
4189214 2091721 2091721 defendant Thornehill Roger husbandman 586992 586992 Thornehill, Roger, of Ingham, husbandman 1
4189356 2091775 2091775 defendant Stowe William husbandman 586992 586992 Stowe, William, of Ingham, husbandman 0
4212881 2100037 2100037 defendant Thornell Roger husbandman 586992 586992 Thornell, Roger, of Ingham, husbandman 0
4212882 2100037 2100037 defendant Woodliffe Henry husbandman 586992 586992 Woodliffe, Henry, of Ingham, husbandman 1
4213314 2100169 2100169 defendant Thormyll Roger husbandman 586992 586992 Thormyll, Roger, of Ingham, husbandman 0
4215958 2101074 2101074 defendant Cullynder Richard laborer 586992 586992 Cullynder, Richard, of Ingham, laborer 3
4234656 2107668 2107668 defendant Nelson Richard yeoman 586992 586992 Nelson, Richard, of Ingham, yeoman 0
4241741 2110224 2110224 defendant Busshope William yeoman 586992 586992 Busshope, William, of Ingham, yeoman 1
4249888 2112943 2112943 defendant Farrow Simon tailor 586992 586992 Farrow, Simon, of Ingham, tailor 2
4251898 2113624 2113624 defendant Busshop William yeoman 586992 586992 Busshop, William, of Ingham, yeoman 0
4258336 2115758 2115758 defendant Lawes Edward yeoman 586992 586992 Lawes, Edward, of Ingham, yeoman 3
4260737 2116556 2116556 defendant Garrarde Thomas husbandman 586992 586992 Garrarde, Thomas, of Ingham, husbandman 2
4266248 2118349 2118349 defendant Leggatt William yeoman 586992 586992 Leggatt, William, of Ingham, yeoman 0
4290813 2126771 2126771 defendant Welborne Robert yeoman 586992 586992 Welborne, Robert, of Ingham, yeoman 0
4299438 2129890 2129890 defendant Welborne Robert yeoman 586992 586992 Welborne, Robert, of Ingham, yeoman 0
4301645 2130693 2130693 defendant Boldere Henry gent 586992 586992 Boldere, Henry, of Ingham, gent 0
4311707 2134237 2134237 defendant Taylor Thomas miller 586992 586992 Taylor, Thomas, of Ingham, miller 0
4312173 2134396 2134396 defendant Wynson Blithe widow 586992 586992 Wynson, Blithe, of Ingham, widow 3
4329514 2140176 2140176 defendant Pytman Roger joiner 586992 586992 Pytman, Roger, of Ingham, joiner 2
4335205 2142050 2142050 defendant Lawes Thomas husbandman 586992 586992 Lawes, Thomas, of Ingham, husbandman 0
4338450 2143199 2143199 defendant Bates Edward yeoman 586992 586992 Bates, Edward, of Ingham, yeoman 0
4338451 2143199 2143199 defendant Dey Robert yeoman 586992 586992 Dey, Robert, of Ingham, yeoman 1
4342567 2144675 2144675 defendant Fayreman Clement husbandman 586992 586992 Fayreman, Clement, of Ingham, husbandman 0
4351873 2147894 2147894 defendant Curspe or Curste Edmund cordwainer 586992 586992 Curspe or Curste, Edmund, of Ingham, cordwainer 3
4352666 2148164 2148164 defendant Legatte William yeoman 586992 586992 Legatte, William, of Ingham, yeoman 2
4353500 2148449 2148449 defendant Boldero Henry gent 586992 586992 Boldero, Henry, of Ingham, gent 0
4355036 2148980 2148980 defendant Lawes Thomas yeoman 586992 586992 Lawes, Thomas, of Ingham, yeoman 0
4355863 2149269 2149269 defendant Boldro Henry gent 586992 586992 Boldro, Henry, of Ingham, gent 0
4356607 2149544 2149544 defendant Lawes Thomas husbandman 586992 586992 Lawes, Thomas, of Ingham, husbandman 1
4371099 2154724 2154724 defendant Morland Thomas butcher 586992 586992 Morland, Thomas, of Ingham, butcher 0
4418531 2170672 2170672 defendant Avelyne Nicholas   586992 586992 Avelyne, Nicholas, of Ingham 1
4517757 2205945 2205945 defendant Holdestowe William   586992 586992 Holdestowe, William, of Ingham 0
4524648 2208045 2208045 defendant West William   586992 586992 West, William, of Ingham 0
4556167 2217870 2217870 defendant West William   586992 586992 West, William, of Ingham 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);