names

44 rows where place_id = 612405

✎ 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
3693125 1924059 1924059 defendant Heygate John yeoman 612405 612405 Heygate, John, of Malden, Essex, yeoman 0
3800306 1958014 1958014 defendant Pyke Robert husbandman 612405 612405 Pyke, Robert, of Malden, Essex, husbandman 4
3832460 1968073 1968073 defendant Hyk Robert mariner 612405 612405 Hyk, Robert, of Malden, Essex, mariner 1
3838916 1970097 1970097 defendant Gatys John yeoman 612405 612405 Gatys, John, of Malden, Essex, yeoman 0
3850649 1973793 1973793 defendant Cookshott Robert husbandman 612405 612405 Cookshott, Robert, of Malden, Essex, husbandman 0
3858313 1976260 1976260 defendant Thorndon Richard yeoman 612405 612405 Thorndon, Richard, of Malden, Essex, yeoman 0
3948903 2006681 2006681 defendant Bennett Thomas chapman 612405 612405 Bennett, Thomas, of Malden, Essex, chapman 1
3964798 2012296 2012296 defendant Tooll or Towle Edward yeoman 612405 612405 Tooll or Towle, Edward, of Malden, Essex, yeoman 0
3977296 2016631 2016631 plaintiff Legge William butcher 612405 612405 Legge, William, of Malden, Essex, or of Thorpe, Suff, butcher 0
3989029 2020819 2020819 defendant Harrys Vincent esq 612405 612405 Harrys, Vincent, of Malden, Essex, esq 0
3989031 2020820 2020820 defendant Harrys Vincent esq 612405 612405 Harrys, Vincent, of Malden, Essex, esq 0
3993707 2022495 2022495 defendant Cooke Richard esq 612405 612405 Cooke, Richard, of Malden, Essex, esq 0
3995987 2023320 2023320 defendant Bagsha Humphrey chapman 612405 612405 Bagsha, Humphrey, of Malden, Essex, chapman 0
4000951 2025110 2025110 defendant Mychelson Andrew mariner 612405 612405 Mychelson, Andrew, of Malden, Essex, mariner 1
4019943 2031861 2031861 defendant Clarke Thomas clothier 612405 612405 Clarke, Thomas, of Malden, Essex, clothier 0
4060813 2046272 2046272 defendant Brownyng William merchant 612405 612405 Brownyng, William, of Malden, Essex, merchant 0
4097821 2059553 2059553 defendant Michelson Andrew chapman 612405 612405 Michelson, Andrew, of Malden, Essex, chapman 1
4113564 2065130 2065130 defendant Payne William chapman 612405 612405 Payne, William, of Malden, Essex, chapman 0
4116316 2066122 2066122 defendant Cooke Richard esq 612405 612405 Cooke, Richard, of Malden, Essex, esq 0
4116319 2066123 2066123 defendant Cooke Richard esq 612405 612405 Cooke, Richard, of Malden, Essex, esq 0
4138199 2074031 2074031 defendant Rampsom Anthony gent 612405 612405 Rampsom, Anthony, of Malden, Essex, gent 1
4177816 2087712 2087712 defendant Jowell or Joell Humphrey   612405 612405 Jowell or Joell, Humphrey, of Malden, Essex, surgeon 0
4190666 2092297 2092297 defendant Frye John yeoman 612405 612405 Frye, John, of Malden, Essex, yeoman 0
4202960 2096581 2096581 defendant Studde William chapman 612405 612405 Studde, William, of Malden, Essex, chapman 3
4209974 2099051 2099051 defendant Rampson Anthony gent 612405 612405 Rampson, Anthony, of Malden, Essex, gent 0
4209977 2099052 2099052 defendant Rampson Anthony gent 612405 612405 Rampson, Anthony, of Malden, Essex, gent 0
4258377 2115770 2115770 defendant Frende Edward mercer 612405 612405 Frende, Edward, of Malden, Essex, mercer 2
4270447 2119697 2119697 defendant Pamer or Painer or Panier Robert clerk 612405 612405 Pamer or Painer or Panier, Robert, of Malden, Essex, clerk 2
4270515 2119720 2119720 defendant Panter Robert clerk 612405 612405 Panter, Robert, of Malden, Essex, clerk 2
4321386 2137573 2137573 defendant Soame William Master of Arts 612405 612405 Soame, William, of Malden, Essex, Master of Arts 0
4360486 2150917 2150917 defendant Soane William clothier 612405 612405 Soane, William, of Malden, Essex, clothier 3
4397132 2163611 2163611 defendant Pasfeild George   612405 612405 Pasfeild, George, of Malden, Essex, yeoman, bailiff of Malden ex parte 0
4883641 2321796 2321796 defendant Palmer John husbandman 612405 612405 (Palmer, John, of Malden, Essex, husbandman 4
4889205 2323410 2323410 defendant Palmer John husbandman 612405 612405 (Palmer, John, of Malden, Essex, husbandman 4
4942443 2339623 2339623 defendant Snape alias Bocher John butcher 612405 612405 Snape alias Bocher, John, of Malden, Essex, butcher 0
5094011 2384646 2384646 defendant Kyng Richard yeoman 612405 612405 Kyng, Richard, of Malden, Essex, yeoman 0
5119717 2392204 2392204 defendant Gilberd Simon chapman 612405 612405 Gilberd, Simon, of Malden, Essex, chapman 0
5234191 2425590 2425590 defendant Batell John husbandman 612405 612405 Batell, John, of Malden, Essex, husbandman 0
5374585 2467657 2467657 defendant Crosse alias Andrewe John   612405 612405 Crosse alias Andrewe, John, of Malden, Essex, wax chander 2
5432019 2484544 2484544 defendant Parlek John (legal representative) 612405 612405 Parlek, John, of Malden, Essex, executor of 0
5515579 2509716 2509716 defendant Watersalle Thomas yeoman 612405 612405 Watersalle, Thomas, of Malden, Essex, yeoman 0
5590485 2531991 2531991 defendant Hardyng William   612405 612405 Hardyng, William, of Malden, Essex, merchant, administrators of 0
5590489 2531992 2531992 defendant Hardyng William   612405 612405 Hardyng, William, of Malden, Essex, merchant, administrators of 0
5593548 2532965 2532965 defendant Brus Henry chapman 612405 612405 Brus, Henry, of Malden, Essex, chapman 1

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