names

60 rows where place_id = 593804

✎ 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
3613407 1871840 1871840 defendant Halle John husbandman 593804 593804 Halle, John, of Carsey, husbandman 1
3642659 1908149 1908149 defendant Broke Simon yeoman 593804 593804 Broke, Simon, of Carsey, yeoman 0
3642660 1908149 1908149 defendant Noke Robert husbandman 593804 593804 Noke, Robert, of Carsey, husbandman 1
3642661 1908149 1908149 defendant Smyth John carpenter 593804 593804 Smyth, John, of Carsey, carpenter 2
3693407 1924154 1924154 defendant Veer Thomas (legal representative) 593804 593804 Veer, Thomas, of Carsey, executors of 0
3699354 1926016 1926016 defendant Nokes William clothier 593804 593804 Nokes, William, of Carsey, clothier 1
3709822 1929387 1929387 defendant Ball John clothman 593804 593804 Ball, John, of Carsey, clothman 4
3824181 1965440 1965440 defendant Ballys John husbandman 593804 593804 Ballys, John, of Carsey, husbandman 2
3828465 1966776 1966776 defendant Noke Robert husbandman 593804 593804 Noke, Robert, of Carsey, husbandman 0
3828466 1966776 1966776 defendant Smyth John carpenter 593804 593804 Smyth, John, of Carsey, carpenter 1
3899378 1990005 1990005 defendant Manne James husbandman 593804 593804 Manne, James, of Carsey, husbandman 1
3932788 2001271 2001271 defendant Kyng Thomas butcher 593804 593804 Kyng, Thomas, of Carsey, butcher 0
3965161 2012424 2012424 defendant Goche Simon blacksmith 593804 593804 Goche, Simon, of Carsey, blacksmith 1
3981312 2018084 2018084 defendant Mann James husbandman 593804 593804 Mann, James, of Carsey, husbandman 0
3991558 2021741 2021741 defendant Salmon Robert laborer 593804 593804 Salmon, Robert, of Carsey, laborer 0
4000714 2025022 2025022 defendant Sares William weaver 593804 593804 Sares, William, of Carsey, weaver 1
4009976 2028334 2028334 defendant Mane James husbandman 593804 593804 Mane, James, of Carsey, husbandman 0
4015447 2030221 2030221 defendant Havell John yeoman 593804 593804 Havell, John, of Carsey, yeoman 0
4041837 2039562 2039562 defendant Mane Agnes widow 593804 593804 Mane, Agnes, of Carsey, widow 1
4064700 2047663 2047663 plaintiff Halphyn James clothier 593804 593804 Halphyn, James, of Carsey, clothier 0
4074457 2051168 2051168 defendant Potter Robert husbandman 593804 593804 Potter, Robert, of Carsey, husbandman 0
4076301 2051817 2051817 plaintiff Shercrofte Thomas clothmaker 593804 593804 Shercrofte, Thomas, of Carsey, clothmaker 0
4090230 2056792 2056792 defendant Steade Thomas laborer 593804 593804 Steade, Thomas, of Carsey, laborer 0
4090231 2056792 2056792 defendant Luson Samuel laborer 593804 593804 Luson, Samuel, of Carsey, laborer 1
4090232 2056792 2056792 defendant Man Agnes widow 593804 593804 Man, Agnes, of Carsey, widow 2
4095289 2058639 2058639 defendant Goge Simon yeoman 593804 593804 Goge, Simon, of Carsey, yeoman 0
4120449 2067591 2067591 defendant Corder Robert husbandman 593804 593804 Corder, Robert, of Carsey, husbandman 0
4129987 2071029 2071029 defendant Greene Robert yeoman 593804 593804 Greene, Robert, of Carsey, yeoman 0
4134102 2072521 2072521 defendant Corder Robert husbandman 593804 593804 Corder, Robert, of Carsey, husbandman 0
4136359 2073348 2073348 defendant Dashe Julian miller 593804 593804 Dashe, Julian, of Carsey, miller 0
4143467 2075875 2075875 defendant Corder Robert husbandman 593804 593804 Corder, Robert, of Carsey, husbandman 0
4146796 2077032 2077032 defendant Haste Thomas shoemaker 593804 593804 Haste, Thomas, of Carsey, shoemaker 1
4159116 2081259 2081259 defendant Dasshe Julian miller 593804 593804 Dasshe, Julian, of Carsey, miller 0
4165629 2083479 2083479 defendant Brice Edmund tailor 593804 593804 Brice, Edmund, of Carsey, tailor 3
4195500 2093969 2093969 defendant Barron Thomas tailor 593804 593804 Barron, Thomas, of Carsey, tailor 0
4195501 2093969 2093969 defendant Bryse Robert, junior tailor 593804 593804 Bryse, Robert, junior, of Carsey, tailor 1
4233467 2107221 2107221 defendant Upperstall John, senior husbandman 593804 593804 Upperstall, John, senior, of Carsey, husbandman 0
4233468 2107221 2107221 defendant Upperstall John, junior husbandman 593804 593804 Upperstall, John, junior, of Carsey, husbandman 1
4251625 2113526 2113526 defendant Upperstall or Upperscall John, senior husbandman 593804 593804 Upperstall or Upperscall, John, senior, of Carsey, husbandman 0
4251626 2113526 2113526 defendant Upperstall or Upperscall John, junior husbandman 593804 593804 Upperstall or Upperscall, John, junior, of Carsey, husbandman 1
4258128 2115689 2115689 defendant Marchant John tailor 593804 593804 Marchant, John, of Carsey, tailor 0
4258129 2115689 2115689 defendant Cooke Stephen clothier 593804 593804 Cooke, Stephen, of Carsey, clothier 1
4279585 2122776 2122776 defendant Goymor Thomas yeoman 593804 593804 Goymor, Thomas, of Carsey, yeoman 1
4282597 2123815 2123815 defendant Man Robert yeoman 593804 593804 Man, Robert, of Carsey, yeoman 0
4282598 2123815 2123815 defendant Fuller Robert butcher 593804 593804 Fuller, Robert, of Carsey, butcher 1
4333005 2141323 2141323 defendant Rowe Giles weaver 593804 593804 Rowe, Giles, of Carsey, weaver 3
4335533 2142160 2142160 defendant Foorthe or Forde Israel gent 593804 593804 Foorthe or Forde, Israel, of Carsey, gent 0
4352762 2148197 2148197 defendant Bryce Edmund yeoman 593804 593804 Bryce, Edmund, of Carsey, yeoman 0
4382644 2158901 2158901 defendant Warde Robert husbandman 593804 593804 Warde, Robert, of Carsey, husbandman 2
4384778 2159597 2159597 defendant Man Robert yeoman 593804 593804 Man, Robert, of Carsey, yeoman 0
4384779 2159597 2159597 defendant Hubbert John yeoman 593804 593804 Hubbert, John, of Carsey, yeoman 1
4384780 2159597 2159597 defendant Marchant George clothier 593804 593804 Marchant, George, of Carsey, clothier 2
4390311 2161381 2161381 defendant Man Robert yeoman 593804 593804 Man, Robert, of Carsey, yeoman 0
4393689 2162492 2162492 defendant Ambrosse Joseph yeoman 593804 593804 Ambrosse, Joseph, of Carsey, yeoman 0
4406596 2166773 2166773 defendant Hudson Richard husbandman 593804 593804 Hudson, Richard, of Carsey, cordwainer, or of Stanningfeilde, husbandman 0
4406601 2166774 2166774 defendant Hudson Richard husbandman 593804 593804 Hudson, Richard, of Carsey, cordwainer, or of Stanningfeilde, husbandman 0
5368118 2465655 2465655 defendant Holton Robert fuller 593804 593804 Holton, Robert, of Carsey, fuller 0
5493111 2502849 2502849 defendant Holton or Oulton Robert fuller or husbandman 593804 593804 Holton or Oulton, Robert, of Carsey, fuller or husbandman 0
5561749 2523423 2523423 defendant Hadman Robert laborer 593804 593804 Hadman, Robert, of Carsey, laborer 0
5569976 2525794 2525794 defendant Broke Simon yeoman 593804 593804 Broke, Simon, of Carsey, yeoman 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);