names

58 rows where place_id = 670014

✎ 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
3995309 2023063 2023063 defendant Bakere Richard esq 670014 670014 Bakere, Richard, of Cranebrooke, esq 0
3995310 2023063 2023063 defendant Smythe John yeoman 670014 670014 Smythe, John, of Cranebrooke, yeoman 1
3995311 2023063 2023063 defendant Garbett Percival yeoman 670014 670014 Garbett, Percival, of Cranebrooke, yeoman 2
3995312 2023063 2023063 defendant Bogyn John yeoman 670014 670014 Bogyn, John, of Cranebrooke, yeoman 3
4003498 2026012 2026012 defendant Courthopp Alexander yeoman 670014 670014 Courthopp, Alexander, of Cranebrooke, yeoman 0
4003500 2026013 2026013 defendant Courthopp Alexander yeoman 670014 670014 Courthopp, Alexander, of Cranebrooke, yeoman 0
4014575 2029934 2029934 defendant Eynkyn or Gynkyn Robert fuller 670014 670014 Eynkyn or Gynkyn, Robert, of Cranebrooke, fuller 1
4014613 2029948 2029948 defendant Eynken or Gynken Robert fuller 670014 670014 Eynken or Gynken, Robert, of Cranebrooke, fuller 1
4045187 2040733 2040733 defendant Henley Henry clothier 670014 670014 Henley, Henry, of Cranebrooke, clothier 0
4045188 2040733 2040733 defendant Bodyll William carpenter 670014 670014 Bodyll, William, of Cranebrooke, carpenter 1
4061035 2046354 2046354 defendant Dorley Thomas husbandman 670014 670014 Dorley, Thomas, of Cranebrooke, husbandman 1
4114782 2065575 2065575 defendant Love John gent 670014 670014 Love, John, of Cranebrooke, gent 0
4114783 2065575 2065575 defendant Glover Richard yeoman 670014 670014 Glover, Richard, of Cranebrooke, yeoman 1
4121883 2068124 2068124 defendant Collyer William husbandman 670014 670014 Collyer, William, of Cranebrooke, husbandman 0
4129632 2070904 2070904 defendant Harrys Richard husbandman 670014 670014 Harrys, Richard, of Cranebrooke, husbandman 0
4143117 2075762 2075762 defendant Baker Thomas yeoman 670014 670014 Baker, Thomas, of Cranebrooke, yeoman 0
4143118 2075762 2075762 defendant Adams Christopher yeoman 670014 670014 Adams, Christopher, of Cranebrooke, yeoman 1
4143136 2075770 2075770 defendant Couchman Edward clothier 670014 670014 Couchman, Edward, of Cranebrooke, clothier 0
4156032 2080182 2080182 defendant Cooke Richard clothier 670014 670014 Cooke, Richard, of Cranebrooke, clothier 3
4164305 2083036 2083036 defendant Reynold Thomas yeoman 670014 670014 Reynold, Thomas, of Cranebrooke, yeoman 0
4180711 2088736 2088736 defendant Kelsden Henry clothier 670014 670014 Kelsden, Henry, of Cranebrooke, clothier 0
4183860 2089847 2089847 defendant Peers Robert laborer 670014 670014 Peers, Robert, of Cranebrooke, laborer 0
4224083 2103910 2103910 defendant Lyne Joseph yeoman 670014 670014 Lyne, Joseph, of Cranebrooke, yeoman 0
4226937 2104894 2104894 defendant Prettye Thomas clothier 670014 670014 Prettye, Thomas, of Cranebrooke, clothier 0
4229203 2105697 2105697 defendant Weller John yeoman 670014 670014 Weller, John, of Cranebrooke, yeoman 0
4229429 2105776 2105776 defendant Jerratt William clothier 670014 670014 Jerratt, William, of Cranebrooke, clothier 0
4229717 2105874 2105874 defendant Prettye Thomas clothier 670014 670014 Prettye, Thomas, of Cranebrooke, clothier 0
4230038 2105997 2105997 defendant Berms or Bearmes Arthur husbandman 670014 670014 Berms or Bearmes, Arthur, of Cranebrooke, husbandman 0
4233576 2107263 2107263 defendant Sharpye John clothier 670014 670014 Sharpye, John, of Cranebrooke, clothier 0
4249410 2112788 2112788 defendant Oxenbridge Roger sherman 670014 670014 Oxenbridge, Roger, of Cranebrooke, sherman 0
4250072 2113007 2113007 plaintiff Bigge Robert yeoman 670014 670014 Bigge, Robert, of Cranebrooke, yeoman 0
4257128 2115361 2115361 defendant Rogers William clothier 670014 670014 Rogers, William, of Cranebrooke, clothier 1
4270677 2119773 2119773 defendant Tull John yeoman 670014 670014 Tull, John, of Cranebrooke, yeoman 0
4278396 2122379 2122379 defendant Birche Richard vlothier 670014 670014 Birche, Richard, of Cranebrooke, vlothier 0
4315786 2135630 2135630 defendant Holden Richard yeoman 670014 670014 Holden, Richard, of Cranebrooke, yeoman 0
4317078 2136087 2136087 defendant Hore Robert husbandman 670014 670014 Hore, Robert, of Cranebrooke, husbandman 0
4317079 2136087 2136087 defendant Harman Thomas husbandman 670014 670014 Harman, Thomas, of Cranebrooke, husbandman 1
4320154 2137149 2137149 defendant Homewood John tailor 670014 670014 Homewood, John, of Cranebrooke, tailor 2
4320567 2137286 2137286 defendant Cloke Hamon   670014 670014 Cloke, Hamon, of Cranebrooke, yeoman, bailiff 0
4320568 2137286 2137286 defendant Swaynsland John shoemaker 670014 670014 Swaynsland, John, of Cranebrooke, shoemaker 1
4323572 2138300 2138300 defendant Weller John clothier 670014 670014 Weller, John, of Cranebrooke, clothier 0
4332189 2141061 2141061 defendant Bodell John carpenter 670014 670014 Bodell, John, of Cranebrooke, carpenter 0
4332190 2141061 2141061 defendant Younge John clothier 670014 670014 Younge, John, of Cranebrooke, clothier 1
4334029 2141662 2141662 defendant Smyth Anthony carrier 670014 670014 Smyth, Anthony, of Cranebrooke, carrier 0
4359199 2150448 2150448 defendant Morrys Stephen husbandman 670014 670014 Morrys, Stephen, of Cranebrooke, husbandman 0
4359342 2150500 2150500 defendant Lyne Joseph yeoman 670014 670014 Lyne, Joseph, of Cranebrooke, yeoman 0
4359952 2150724 2150724 defendant Carpenter Thomas husbandman 670014 670014 Carpenter, Thomas, of Cranebrooke, husbandman 1
4362026 2151462 2151462 defendant Messenge Nicholas forgeman 670014 670014 Messenge, Nicholas, of Cranebrooke, forgeman 3
4367524 2153439 2153439 defendant Cowchman Alexander gent 670014 670014 Cowchman, Alexander, of Cranebrooke, gent 0
4370791 2154605 2154605 defendant Batherst Robert clothier 670014 670014 Batherst, Robert, of Cranebrooke, clothier 0
4371311 2154805 2154805 defendant Terrye Ralph yeoman 670014 670014 Terrye, Ralph, of Cranebrooke, yeoman 0
4371312 2154805 2154805 defendant Banck Anthony husbandman 670014 670014 Banck, Anthony, of Cranebrooke, husbandman 1
4373292 2155516 2155516 defendant Tanner James tailor 670014 670014 Tanner, James, of Cranebrooke, tailor 0
4373293 2155516 2155516 defendant Haselden Margery widow 670014 670014 Haselden, Margery, of Cranebrooke, widow 1
4376450 2156647 2156647 defendant Modle Hugh yeoman 670014 670014 Modle, Hugh, of Cranebrooke, yeoman 0
4383907 2159321 2159321 defendant Morris Stephen husbandman 670014 670014 Morris, Stephen, of Cranebrooke, husbandman 0
4383922 2159326 2159326 defendant Lyne Joseph yeoman 670014 670014 Lyne, Joseph, of Cranebrooke, yeoman 0
4389086 2160978 2160978 defendant Lyne George carrier 670014 670014 Lyne, George, of Cranebrooke, carrier 3

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