names

92 rows where place_id = 600332

✎ 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
3640642 1907514 1907514 defendant Colt George husbandman 600332 600332 Colt, George, of Yaldyng, husbandman 0
3646320 1909240 1909240 defendant Wenborne William chapman 600332 600332 Wenborne, William, of Yaldyng, chapman 0
3647994 1909775 1909775 defendant Colt William (legal representative) 600332 600332 Colt, William, of Yaldyng, butcher, executor of 0
3648001 1909776 1909776 defendant Colt William (legal representative) 600332 600332 Colt, William, of Yaldyng, butcher, executor of 0
3649375 1910193 1910193 defendant Colt Thomas butcher 600332 600332 Colt, Thomas, of Yaldyng, butcher 1
3650038 1910380 1910380 defendant Colt Robert husbandman 600332 600332 Colt, Robert, of Yaldyng, husbandman 0
3650040 1910381 1910381 defendant Colt William husbandman 600332 600332 Colt, William, of Yaldyng, husbandman 0
3655881 1912093 1912093 defendant Codde Robert husbandman 600332 600332 Codde, Robert, of Yaldyng, husbandman 0
3655882 1912093 1912093 defendant at Hasshe John laborer 600332 600332 at Hasshe, John, of Yaldyng, laborer 1
3656381 1912241 1912241 defendant Bate Richard weaver 600332 600332 Bate, Richard, of Yaldyng, weaver 3
3665447 1915141 1915141 defendant Ougle John butcher 600332 600332 Ougle, John, of Yaldyng, butcher 3
3675273 1918305 1918305 defendant Wysse John laborer 600332 600332 Wysse, John, of Yaldyng, laborer 3
3676582 1918714 1918714 defendant Codde William husbandman 600332 600332 Codde, William, of Yaldyng, husbandman 0
3676658 1918738 1918738 defendant Codde William husbandman 600332 600332 Codde, William, of Yaldyng, husbandman 0
3680781 1920070 1920070 defendant Weller George summoner 600332 600332 Weller, George, of Yaldyng, summoner 0
3688150 1922444 1922444 defendant Colt George husbandman 600332 600332 Colt, George, of Yaldyng, husbandman 0
3688153 1922445 1922445 defendant Holbroke Edward   600332 600332 Holbroke, Edward, of Yaldyng, wax chandler 0
3694089 1924356 1924356 defendant Terry Robert carpenter 600332 600332 Terry, Robert, of Yaldyng, carpenter 0
3700022 1926241 1926241 defendant Symmyng Simon husbandman 600332 600332 Symmyng, Simon, of Yaldyng, husbandman 0
3706197 1928225 1928225 defendant Codde William yeoman 600332 600332 Codde, William, of Yaldyng, yeoman 1
3706198 1928225 1928225 defendant Codde Robert miller 600332 600332 Codde, Robert, of Yaldyng, miller 2
3708081 1928828 1928828 defendant Alchyn Philip tailor 600332 600332 Alchyn, Philip, of Yaldyng, tailor 1
3716253 1931376 1931376 defendant Colte Thomas yeoman 600332 600332 Colte, Thomas, of Yaldyng, yeoman 0
3716254 1931376 1931376 defendant Colte Richard butcher 600332 600332 Colte, Richard, of Yaldyng, butcher 1
3726021 1934412 1934412 defendant Codde William yeoman 600332 600332 Codde, William, of Yaldyng, yeoman 3
3726963 1934701 1934701 defendant Stace John husbandman 600332 600332 Stace, John, of Yaldyng, husbandman 0
3738548 1938264 1938264 defendant Lorkyn Richard yeoman 600332 600332 Lorkyn, Richard, of Yaldyng, yeoman 0
3769131 1947999 1947999 defendant A Downe Thomas tanner 600332 600332 A Downe, Thomas, of Yaldyng, tanner 1
3769132 1947999 1947999 defendant Gratford John, junior husbandman 600332 600332 Gratford, John, junior, of Yaldyng, husbandman 2
3792126 1955390 1955390 defendant Hubard William   600332 600332 Hubard, William, of Yaldyng, tile maker 0
3797506 1957112 1957112 defendant Codde William yeoman 600332 600332 Codde, William, of Yaldyng, yeoman 0
3799783 1957853 1957853 defendant Stace John husbandman 600332 600332 Stace, John, of Yaldyng, husbandman 0
3807388 1960219 1960219 defendant Stace John husbandman 600332 600332 Stace, John, of Yaldyng, husbandman 0
3808721 1960606 1960606 defendant Fuller John tanner 600332 600332 Fuller, John, of Yaldyng, tanner 3
3818583 1963714 1963714 defendant Stace John husbandman 600332 600332 Stace, John, of Yaldyng, husbandman 0
3820947 1964446 1964446 defendant Ferys Thomas   600332 600332 Ferys, Thomas, of Yaldyng, tallow chandler 0
3820953 1964448 1964448 defendant Ferys Thomas   600332 600332 Ferys, Thomas, of Yaldyng, tallow chandler 1
3829416 1967088 1967088 defendant Bukland William husbandman 600332 600332 Bukland, William, of Yaldyng, husbandman 0
3829417 1967088 1967088 defendant Edmede George yeoman 600332 600332 Edmede, George, of Yaldyng, yeoman 1
3837118 1969510 1969510 defendant Bukland William husbandman 600332 600332 Bukland, William, of Yaldyng, husbandman 0
3853708 1974790 1974790 defendant Assheton John laborer 600332 600332 Assheton, John, of Yaldyng, laborer 3
3853709 1974790 1974790 defendant Kennard Thomas butcher 600332 600332 Kennard, Thomas, of Yaldyng, butcher 4
3864025 1978149 1978149 defendant Heryng John husbandman 600332 600332 Heryng, John, of Yaldyng, husbandman 2
3866155 1978909 1978909 defendant Stace John husbandman 600332 600332 Stace, John, of Yaldyng, husbandman 0
3909752 1993570 1993570 plaintiff Stace John   600332 600332 Stace, John, of Yaldyng 0
3912776 1994605 1994605 defendant Parfote William husbandman 600332 600332 Parfote, William, of Yaldyng, husbandman 2
3915522 1995560 1995560 defendant Fyssenden Andrew smith 600332 600332 Fyssenden, Andrew, of Yaldyng, smith 2
3915523 1995560 1995560 defendant Becher John smith 600332 600332 Becher, John, of Yaldyng, smith 3
3915524 1995560 1995560 defendant Welche Stephen husbandman 600332 600332 Welche, Stephen, of Yaldyng, husbandman 4
3919187 1996744 1996744 defendant Apsley Robert butcher 600332 600332 Apsley, Robert, of Yaldyng, butcher 1
3988820 2020747 2020747 defendant Cleve Florence widow 600332 600332 Cleve, Florence, of Yaldyng, widow 0
4007671 2027532 2027532 defendant Byrchett John yeoman 600332 600332 Byrchett, John, of Yaldyng, yeoman 0
4009660 2028224 2028224 defendant Elffycke Thomas yeoman 600332 600332 Elffycke, Thomas, of Yaldyng, yeoman 0
4031923 2036083 2036083 defendant Furmyng Andrew yeoman 600332 600332 Furmyng, Andrew, of Yaldyng, yeoman 0
4032076 2036140 2036140 defendant Furmynger Richard yeoman 600332 600332 Furmynger, Richard, of Yaldyng, yeoman 1
4049305 2042198 2042198 defendant Rychard Thomas tanner 600332 600332 Rychard, Thomas, of Yaldyng, tanner 0
4049306 2042198 2042198 defendant Poulter John yeoman 600332 600332 Poulter, John, of Yaldyng, yeoman 1
4049307 2042198 2042198 defendant Fowsden Thomas yeoman 600332 600332 Fowsden, Thomas, of Yaldyng, yeoman 2
4075263 2051457 2051457 defendant Burchett John yeoman 600332 600332 Burchett, John, of Yaldyng, yeoman 0
4145122 2076454 2076454 defendant Skelton Stephen yeoman 600332 600332 Skelton, Stephen, of Yaldyng, yeoman 1
4153600 2079351 2079351 defendant Acton Richard clothier 600332 600332 Acton, Richard, of Yaldyng, clothier 0
4203605 2096817 2096817 defendant Maye Arthur yeoman 600332 600332 Maye, Arthur, of Yaldyng, yeoman 1
4217037 2101454 2101454 defendant Goodden Thomas butcher 600332 600332 Goodden, Thomas, of Yaldyng, butcher 0
4217038 2101454 2101454 defendant Apsley Robert butcher 600332 600332 Apsley, Robert, of Yaldyng, butcher 1
4234444 2107587 2107587 plaintiff Fleete William clothier 600332 600332 Fleete, William, of Yaldyng, clothier 0
4234445 2107587 2107587 defendant Langley Thomas husbandman 600332 600332 Langley, Thomas, of Yaldyng, husbandman 0
4314003 2135005 2135005 defendant Stace Mathew yeoman 600332 600332 Stace, Mathew, of Yaldyng, yeoman 0
4323364 2138232 2138232 defendant Stace Mathew husbandman 600332 600332 Stace, Mathew, of Yaldyng, husbandman 2
4380740 2158224 2158224 defendant Flete Jeremy clothier 600332 600332 Flete, Jeremy, of Yaldyng, clothier 0
4380741 2158224 2158224 defendant Flete Ezechial clothier 600332 600332 Flete, Ezechial, of Yaldyng, clothier 1
4380743 2158225 2158225 defendant Skelton Stephen tailor 600332 600332 Skelton, Stephen, of Yaldyng, tailor 0
4380745 2158225 2158225 defendant Flete Ezechial clothier 600332 600332 Flete, Ezechial, of Yaldyng, clothier 2
4389694 2161181 2161181 defendant Wyborne or Wybarne Benjamin carpenter 600332 600332 Wyborne or Wybarne, Benjamin, of Yaldyng, clothier, carpenter 1
4400669 2164814 2164814 defendant Knatt Paul tailor 600332 600332 Knatt, Paul, of Yaldyng, tailor 0
4872763 2318432 2318432 defendant Waldok William pulter 600332 600332 Waldok, William, of Yaldyng, pulter 1
4972617 2348742 2348742 defendant Broke John husbandman 600332 600332 Broke, John, of Yaldyng, husbandman 2
4990453 2354057 2354057 defendant Bouryng John   600332 600332 Bouryng, John, of Yaldyng, park man 0
4998891 2356552 2356552 defendant Brok John husbandman 600332 600332 Brok, John, of Yaldyng, husbandman 2
5020172 2362789 2362789 defendant Warbleton Alice widow 600332 600332 Warbleton, Alice, of Yaldyng, widow 0
5150559 2401305 2401305 defendant Cotyng William tanner 600332 600332 Cotyng, William, of Yaldyng, tanner 0
5150560 2401305 2401305 defendant Rolf Thomas   600332 600332 Rolf, Thomas, of Yaldyng, wheel wright 1
5235669 2426012 2426012 defendant Pyx Richard yeoman 600332 600332 Pyx, Richard, of Yaldyng, yeoman 1
5259821 2433193 2433193 defendant Godyng Thomas   600332 600332 Godyng, Thomas, of Yaldyng, court holder 2
5278653 2438863 2438863 defendant Pyx Richard husbandman 600332 600332 Pyx, Richard, of Yaldyng, husbandman 0
5301174 2445310 2445310 defendant Snelle John smith 600332 600332 Snelle, John, of Yaldyng, smith 4
5394829 2473590 2473590 defendant Colk William butcher 600332 600332 Colk, William, of Yaldyng, butcher 2
5493935 2503092 2503092 defendant Bourdefeld John husbandman 600332 600332 Bourdefeld, John, of Yaldyng, husbandman 0
5534097 2515200 2515200 defendant Ryng George husbandman 600332 600332 Ryng, George, of Yaldyng, husbandman 1
5551466 2520466 2520466 defendant Gartford John husbandman 600332 600332 Gartford, John, of Yaldyng, husbandman 0
5556084 2521774 2521774 defendant Arkynbold John yeoman 600332 600332 Arkynbold, John, of Yaldyng, yeoman 1
5576976 2527844 2527844 defendant Waren John husbandman 600332 600332 Waren, John, of Yaldyng, husbandman 1
5619183 2549847 2549847 defendant Yong William   600332 600332 Yong, William, of Yaldyng 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);