names

162 rows where place_id = 586420

✎ 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
3588682 1864104 1864104 defendant Lesse Robert husbandman 586420 586420 Lesse, Robert, of Est Ruston, husbandman 1
3594381 1865875 1865875 defendant Lesse Robert husbandman 586420 586420 Lesse, Robert, of Est Ruston, husbandman 1
3600388 1867767 1867767 plaintiff Wryghte John   586420 586420 Wryghte, John, of Est Ruston 0
3600393 1867767 1867767 defendant Baron William yeoman 586420 586420 (Baron, William, of Est Ruston, yeoman 4
3600399 1867768 1867768 defendant Baron William yeoman 586420 586420 (Baron, William, of Est Ruston, yeoman 4
3634846 1905697 1905697 defendant Multon Robert chaplain 586420 586420 Multon, Robert, of Est Ruston, chaplain 1
3665595 1915188 1915188 defendant Hamshire Anthony husbandman 586420 586420 Hamshire, Anthony, of East Ruston, husbandman 1
3709624 1929317 1929317 defendant Sutton John chapman 586420 586420 Sutton, John, of Est Ruston, chapman 5
3710595 1929637 1929637 defendant Warde Robert husbandman 586420 586420 Warde, Robert, of Est Ruston, husbandman 0
3711741 1929985 1929985 defendant Curteys Richard butcher 586420 586420 Curteys, Richard, of Est Ruston, butcher 0
3734858 1937144 1937144 defendant Skynner James husbandman 586420 586420 Skynner, James, of Est Ruston, husbandman 1
3734862 1937145 1937145 defendant Skynner James husbandman 586420 586420 Skynner, James, of Est Ruston, husbandman 1
3760554 1945303 1945303 plaintiff Darby Thomas (legal representative) 586420 586420 Darby, Thomas, of Est Ruston, administratrix of 0
3770497 1948456 1948456 defendant Lynsted John husbandman 586420 586420 Lynsted, John, of Est Ruston, husbandman 0
3771686 1948844 1948844 defendant Horn Nicholas husbandman 586420 586420 Horn, Nicholas, of Est Ruston, husbandman 0
3780437 1951616 1951616 defendant Swaynford Edmund husbandman 586420 586420 Swaynford, Edmund, of Est Ruston, husbandman 1
3812769 1961887 1961887 defendant Swynforth Edmund husbandman 586420 586420 Swynforth, Edmund, of Est Ruston, husbandman 0
3930125 2000421 2000421 defendant Peller Robert laborer 586420 586420 Peller, Robert, of East Ruston, laborer 1
3930126 2000421 2000421 defendant Michell Thomas husbandman 586420 586420 Michell, Thomas, of East Ruston, husbandman 2
3950310 2007192 2007192 defendant Wanforth Edmund husbandman 586420 586420 Wanforth, Edmund, of Est Ruston, husbandman 3
3950494 2007250 2007250 defendant Redberd Henry husbandman 586420 586420 Redberd, Henry, of Est Ruston, husbandman 0
3961456 2011102 2011102 plaintiff Turcock William husbandman 586420 586420 Turcock, William, of Est Ruston, husbandman 0
3961458 2011102 2011102 defendant Redberd Henry husbandman 586420 586420 Redberd, Henry, of Est Ruston, husbandman 1
3987483 2020270 2020270 defendant Morrell Andrew yeoman 586420 586420 Morrell, Andrew, of Est Ruston, yeoman 1
3987903 2020419 2020419 defendant Alphyn Edmund yeoman 586420 586420 Alphyn, Edmund, of East Ruston, yeoman 0
3991106 2021583 2021583 defendant Turcoke John tailor 586420 586420 Turcoke, John, of Est Ruston, tailor 0
3991107 2021583 2021583 defendant Warnes John husbandman 586420 586420 Warnes, John, of Est Ruston, husbandman 1
3991108 2021583 2021583 defendant Comer Henry husbandman 586420 586420 Comer, Henry, of Est Ruston, husbandman 2
3991109 2021583 2021583 defendant Thaxster Edmund cordwainer 586420 586420 Thaxster, Edmund, of Est Ruston, cordwainer 3
4004748 2026474 2026474 defendant Michell Christopher (legal representative) 586420 586420 Michell, Christopher, of Est Ruston, husbandman, executors of 0
4011776 2028948 2028948 plaintiff Postyll Simon clerk 586420 586420 Postyll, Simon, of Est Ruston, clerk 0
4017587 2030998 2030998 defendant Hurrey Thomas yeoman 586420 586420 Hurrey, Thomas, of East Ruston, yeoman 0
4017589 2030999 2030999 defendant Alphyn Edmund yeoman 586420 586420 Alphyn, Edmund, of Est Ruston, yeoman 0
4020554 2032078 2032078 defendant Hansore Thomas husbandman 586420 586420 Hansore, Thomas, of Est Ruston, husbandman 2
4020555 2032078 2032078 defendant Redberd Henry husbandman 586420 586420 Redberd, Henry, of Est Ruston, husbandman 3
4027009 2034308 2034308 defendant Turcocke William yeoman 586420 586420 Turcocke, William, of Est Ruston, yeoman 1
4027778 2034585 2034585 defendant Alphyn Edmund yeoman 586420 586420 Alphyn, Edmund, of Est Ruston, yeoman 0
4029266 2035113 2035113 defendant Turcock John tailor 586420 586420 Turcock, John, of Est Ruston, tailor 2
4034564 2037035 2037035 defendant Turcock William yeoman 586420 586420 Turcock, William, of Est Ruston, yeoman 1
4042583 2039815 2039815 defendant Alphen Edmund yeoman 586420 586420 Alphen, Edmund, of Est Ruston, yeoman 0
4045457 2040826 2040826 defendant Awphyn Edmund yeoman 586420 586420 Awphyn, Edmund, of Est Ruston, yeoman 0
4053367 2043581 2043581 defendant Crome John husbandman 586420 586420 Crome, John, of Est Ruston, husbandman 0
4060052 2045993 2045993 defendant Harryson William husbandman 586420 586420 Harryson, William, of Est Ruston, husbandman 0
4060053 2045993 2045993 defendant Kytbald Thomas husbandman 586420 586420 Kytbald, Thomas, of Est Ruston, husbandman 1
4060054 2045993 2045993 defendant Jackson Francis cordwainer 586420 586420 Jackson, Francis, of Est Ruston, cordwainer 2
4076113 2051746 2051746 defendant Thaxter Edmund cordwainer 586420 586420 Thaxter, Edmund, of Est Ruston, cordwainer 3
4076910 2052029 2052029 defendant Dade William gent 586420 586420 Dade, William, of Est Ruston, gent 0
4078127 2052482 2052482 defendant Warnes John husbandman 586420 586420 Warnes, John, of Est Ruston, husbandman 1
4078129 2052482 2052482 defendant Graye John husbandman 586420 586420 Graye, John, of Est Ruston, husbandman 3
4079534 2052978 2052978 defendant Cooke Robert husbandman 586420 586420 Cooke, Robert, of Est Ruston, husbandman 0
4079535 2052978 2052978 defendant Callowe Thomas husbandman 586420 586420 Callowe, Thomas, of Est Ruston, husbandman 1
4079536 2052978 2052978 defendant Jewell Edmund husbandman 586420 586420 Jewell, Edmund, of Est Ruston, husbandman 2
4088529 2056197 2056197 defendant Knott Michael embroiderer 586420 586420 Knott, Michael, of Est Ruston, embroiderer 0
4088531 2056198 2056198 defendant Knott Michael embroiderer 586420 586420 Knott, Michael, of Est Ruston, embroiderer 0
4088533 2056199 2056199 defendant Whitwoode George yeoman 586420 586420 Whitwoode, George, of Est Ruston, yeoman 0
4101559 2060866 2060866 defendant Dade John gent 586420 586420 Dade, John, of Est Ruston, gent 0
4111784 2064463 2064463 defendant Lamberd William husbandman 586420 586420 Lamberd, William, of Est Ruston, husbandman 3
4114842 2065596 2065596 defendant Hanford Thomas yeoman 586420 586420 Hanford, Thomas, of Est Ruston, yeoman 0
4123939 2068862 2068862 defendant Locke Thomas husbandman 586420 586420 Locke, Thomas, of Est Ruston, husbandman 0
4123940 2068862 2068862 defendant Johnsons Henry husbandman 586420 586420 Johnsons, Henry, of Est Ruston, husbandman 1
4123941 2068862 2068862 defendant Hygate Thomas husbandman 586420 586420 Hygate, Thomas, of Est Ruston, husbandman 2
4123942 2068862 2068862 defendant Bockynge Richard carpenter 586420 586420 Bockynge, Richard, of Est Ruston, carpenter 3
4123949 2068865 2068865 defendant Hygate Thomas husbandman 586420 586420 Hygate, Thomas, of Est Ruston, husbandman 0
4123950 2068865 2068865 defendant Hyrry Edmund husbandman 586420 586420 Hyrry, Edmund, of Est Ruston, husbandman 1
4139442 2074468 2074468 defendant Lamberd William husbandman 586420 586420 Lamberd, William, of Est Ruston, husbandman 1
4139443 2074468 2074468 defendant Cooke John husbandman 586420 586420 Cooke, John, of Est Ruston, husbandman 2
4139444 2074468 2074468 defendant Wylson Richard husbandman 586420 586420 Wylson, Richard, of Est Ruston, husbandman 3
4139445 2074468 2074468 defendant Tyrcocke Richard husbandman 586420 586420 Tyrcocke, Richard, of Est Ruston, husbandman 4
4144306 2076170 2076170 defendant Lancetor Anthony husbandman 586420 586420 Lancetor, Anthony, of Est Ruston, husbandman 0
4144637 2076283 2076283 defendant Ansill or Ansell John (legal representative) 586420 586420 Ansill or Ansell, John, of Est Ruston, yeoman, executors of 0
4147135 2077139 2077139 defendant Thurcocke or Turcock Henry husbandman 586420 586420 Thurcocke or Turcock, Henry, of Est Ruston, husbandman 0
4147136 2077139 2077139 defendant Pawlynge Robert husbandman 586420 586420 Pawlynge, Robert, of Est Ruston, husbandman 1
4147137 2077139 2077139 defendant Paston William husbandman 586420 586420 Paston, William, of Est Ruston, husbandman 2
4155684 2080069 2080069 defendant Witwoode George yeoman 586420 586420 Witwoode, George, of Est Ruston, yeoman 0
4166775 2083875 2083875 defendant Locke Thomas husbandman 586420 586420 Locke, Thomas, of Est Ruston, husbandman 0
4166776 2083875 2083875 defendant Wylson Richard husbandman 586420 586420 Wylson, Richard, of Est Ruston, husbandman 1
4166778 2083875 2083875 defendant Snaylwyn Edward husbandman 586420 586420 Snaylwyn, Edward, of Est Ruston, husbandman 3
4188058 2091325 2091325 defendant Lancettor Anthony yeoman 586420 586420 Lancettor, Anthony, of Est Ruston, yeoman 0
4224504 2104052 2104052 defendant Cooke John husbandman 586420 586420 Cooke, John, of Est Ruston, husbandman 0
4224505 2104052 2104052 defendant Drake John butcher 586420 586420 Drake, John, of Est Ruston, butcher 1
4229649 2105852 2105852 defendant Locke Thomas yeoman 586420 586420 Locke, Thomas, of East Ruston, yeoman 3
4251585 2113514 2113514 defendant Burton Thomas husbandman 586420 586420 Burton, Thomas, of Est Ruston, husbandman 2
4251588 2113515 2113515 defendant Woode Robert clerk 586420 586420 Woode, Robert, of Est Ruston, clerk 1
4251589 2113515 2113515 defendant Burton Thomas husbandman 586420 586420 Burton, Thomas, of Est Ruston, husbandman 2
4253143 2114048 2114048 defendant Drake John butcher 586420 586420 Drake, John, of Est Ruston, butcher 3
4254450 2114479 2114479 defendant Thaxter Robert husbandman 586420 586420 Thaxter, Robert, of East Ruston, husbandman 1
4259355 2116105 2116105 defendant Burton Thomas husbandman 586420 586420 Burton, Thomas, of Est Ruston, husbandman 0
4267693 2118826 2118826 defendant Johnson Henry laborer 586420 586420 Johnson, Henry, of Est Ruston, laborer 1
4281047 2123270 2123270 defendant Locke Thomas yeoman 586420 586420 Locke, Thomas, of Est Ruston, yeoman 3
4284932 2124660 2124660 defendant Locke Thomas yeoman 586420 586420 Locke, Thomas, of Est Ruston, yeoman 0
4284933 2124660 2124660 defendant Locke Robert yeoman 586420 586420 Locke, Robert, of Est Ruston, yeoman 1
4284934 2124660 2124660 defendant Locke Margaret spinster 586420 586420 Locke, Margaret, of Est Ruston,spinster 2
4284935 2124660 2124660 defendant Locke Alice spinster 586420 586420 Locke, Alice, of Est Ruston, spinster 3
4287970 2125744 2125744 defendant Cooke John yeoman 586420 586420 Cooke, John, of Est Ruston, yeoman 0
4291823 2127151 2127151 defendant Warnes John, junior (legal representative) 586420 586420 Warnes, John, junior, of East Ruston, husbandman, executor of 1
4291824 2127151 2127151 defendant Warnes John yeoman 586420 586420 Warnes, John, of East Ruston, yeoman 2
4312755 2134593 2134593 defendant Crowe Nicholas husbandman 586420 586420 Crowe, Nicholas, of East Ruston, husbandman 0
4319006 2136762 2136762 defendant Cooke John husbandman 586420 586420 Cooke, John, of East Ruston, husbandman 1
4324440 2138568 2138568 defendant Lawes Robert laborer 586420 586420 Lawes, Robert, of Est Ruston, laborer 1
4324582 2138613 2138613 defendant Locke Thomas yeoman 586420 586420 Locke, Thomas, of Est Ruston, yeoman 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);