names

60 rows where place_id = 596634

✎ 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
3625584 1875535 1875535 plaintiff Wrote William   596634 596634 Wrote, William, of Mundham 0
3625586 1875536 1875536 plaintiff Wrote William   596634 596634 Wrote, William, of Mundham 0
3697671 1925494 1925494 defendant Paten John brickmaker 596634 596634 Paten, John, of Mundham, brickmaker 2
3725626 1934304 1934304 defendant Downer John husbandman 596634 596634 Downer, John, of Mundham, husbandman 0
3756651 1944061 1944061 plaintiff Bab or Bak William smith 596634 596634 Bab or Bak, William, of Mundham, smith 0
3756652 1944061 1944061 plaintiff Westgate Henry husbandman 596634 596634 Westgate, Henry, of Mundham, husbandman 1
3756653 1944061 1944061 plaintiff Wroote Robert, senior husbandman 596634 596634 Wroote, Robert, senior, of Mundham, husbandman 2
3811902 1961627 1961627 defendant Brown John tailor 596634 596634 Brown, John, of Mundham, tailor 1
3863881 1978093 1978093 defendant Thakker Richard clerk 596634 596634 Thakker, Richard, of Mundham, clerk 0
3947859 2006314 2006314 defendant Curteys Robert yeoman 596634 596634 Curteys, Robert, of Mundham, yeoman 0
4012636 2029244 2029244 defendant Smythe John yeoman 596634 596634 Smythe, John, of Mundham, yeoman 1
4046470 2041187 2041187 plaintiff Smyter John   596634 596634 Smyter, John, of Mundham 0
4046472 2041188 2041188 plaintiff Smyter John   596634 596634 Smyter, John, of Mundham 0
4047111 2041413 2041413 defendant Gyldyngwater John tailor 596634 596634 Gyldyngwater, John, of Mundham, or of Saxlingham, tailor 0
4047114 2041414 2041414 defendant Gyldyngwater John tailor 596634 596634 Gyldyngwater, John, of Mundham, or of Saxlyngham, tailor 0
4071488 2050097 2050097 defendant Bemys John yeoman 596634 596634 Bemys, John, of Mundham, yeoman 0
4078050 2052452 2052452 defendant Beamys John yeoman 596634 596634 Beamys, John, of Mundham, yeoman 0
4078053 2052453 2052453 defendant Beamys John yeoman 596634 596634 Beamys, John, of Mundham, yeoman 0
4078054 2052453 2052453 defendant Beamys Francis husbandman 596634 596634 Beamys, Francis, of Mundham, husbandman 1
4091863 2057384 2057384 defendant Beamys John yeoman 596634 596634 Beamys, John, of Mundham, yeoman 1
4091868 2057386 2057386 defendant Beamys John yeoman 596634 596634 Beamys, John, of Mundham, yeoman 1
4101938 2061006 2061006 defendant Mortymer Robert husbandman 596634 596634 Mortymer, Robert, of Mundham, husbandman 2
4177531 2087619 2087619 defendant Thrower Robert, junior husbandman 596634 596634 Thrower, Robert, junior, of Mundham, husbandman 0
4187527 2091137 2091137 defendant Harborowe Thomas gent 596634 596634 Harborowe, Thomas, of Mundham, gent 1
4188727 2091536 2091536 defendant Baxter Richard husbandman 596634 596634 Baxter, Richard, of Mundham, husbandman 0
4322344 2137887 2137887 defendant Dunne Silvester husbandman 596634 596634 Dunne, Silvester, of Mundham, husbandman 2
4342873 2144781 2144781 defendant Beamys Thomas husbandman 596634 596634 Beamys, Thomas, of Mundham, husbandman 3
4355586 2149177 2149177 defendant Beamys Francis yeoman or gent 596634 596634 Beamys, Francis, of Mundham, yeoman or gent 0
4363179 2151895 2151895 defendant Coppinge Thomas husbandman 596634 596634 Coppinge, Thomas, of Mundham, husbandman 0
4363181 2151895 2151895 defendant Coppinge Katherine spinster 596634 596634 Coppinge, Katherine, of Mundham, spinster 2
4363182 2151895 2151895 defendant Palmer Edmund cordwainer 596634 596634 Palmer, Edmund, of Mundham, cordwainer 3
4363183 2151895 2151895 defendant Willison Edmund laborer 596634 596634 Willison, Edmund, of Mundham, laborer 4
4363184 2151895 2151895 defendant Coppinge Margaret widow 596634 596634 together with Coppinge, Margaret, of Mundham, widow 5
4363185 2151895 2151895 defendant Coppinge Edward husbandman 596634 596634 Coppinge, Edward, of Mundham, husbandman 6
4384925 2159649 2159649 defendant Gildenwater John husbandman 596634 596634 Gildenwater, John, of Mundham, husbandman 0
4389517 2161121 2161121 defendant Copping Margaret widow 596634 596634 Copping, Margaret, of Mundham, widow 0
4389518 2161121 2161121 defendant Copping Edward husbandman 596634 596634 Copping, Edward, of Mundham, husbandman 1
4389519 2161121 2161121 defendant Palmer William cordwainer 596634 596634 Palmer, William, of Mundham, cordwainer 2
4397802 2163842 2163842 defendant Thrower Robert, junior husbandman 596634 596634 Thrower, Robert, junior, of Mundham, husbandman 0
4408660 2167492 2167492 defendant Coppinge Edward husbandman 596634 596634 Coppinge, Edward, of Mundham, husbandman 0
4408661 2167492 2167492 defendant Coppinge William husbandman 596634 596634 Coppinge, William, of Mundham, husbandman 1
4408662 2167492 2167492 defendant Coppinge Katherine spinster 596634 596634 Coppinge, Katherine, of Mundham, spinster 2
4472684 2192124 2192124 defendant Bakere John   596634 596634 Bakere, John, of Mundham 0
4475509 2193018 2193018 defendant Westgate Robert tanner 596634 596634 Westgate, Robert, of Mundham, tanner 0
4502080 2201248 2201248 defendant Stalham John   596634 596634 Stalham, John, of Mundham, parson 1
4502964 2201497 2201497 defendant Maister John   596634 596634 Maister, John, of Mundham, parson 2
4517793 2205957 2205957 defendant Stalham John de   596634 596634 Stalham, John de, of Mundham, parson 2
4652655 2246781 2246781 defendant Bakere John (legal representative) 596634 596634 Bakere, John, of Mundham, executors of 20
4652680 2246782 2246782 defendant Bakere John (legal representative) 596634 596634 Bakere, John, of Mundham, executors of 20
4663465 2250049 2250049 defendant Here John   596634 596634 Here, John, of Mundham St Peter 2
4669607 2256205 2256205 plaintiff Bottes John   596634 596634 Bottes, John, of Mundham, vicar 0
4716637 2270522 2270522 defendant Bettes John chaplain 596634 596634 Bettes, John, of Mundham, chaplain 3
4764865 2284990 2284990 defendant Morys Richard   596634 596634 Morys, Richard, of Mundham 0
4776616 2288679 2288679 defendant Vyn Margaret widow 596634 596634 Vyn, Margaret, of Mundham, widow 1
4888456 2323188 2323188 defendant Polkyn John yeoman 596634 596634 Polkyn, John, of Mundham, yeoman 1
4956519 2343908 2343908 defendant Danell or Davell Richard husbandman 596634 596634 Danell or Davell, Richard, of Mundham, husbandman 0
5214513 2419974 2419974 defendant Canon John yeoman 596634 596634 Canon, John, of Mundham, yeoman 2
5515656 2509741 2509741 defendant Holme Reginald husbandman 596634 596634 Holme, Reginald, of Mundham, husbandman 0
5515657 2509741 2509741 defendant Holme John yeoman 596634 596634 Holme, John, of Mundham, yeoman 1
5624211 2551519 2551519 defendant Jurdon William husbandman 596634 596634 Jurdon, William, of Mundham, husbandman 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);