names

50 rows where place_id = 592226

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606992 1869850 1869850 defendant Lye John merchant 592226 592226 Lye, John, of Portesmouth, Hants, merchant 0
3647694 1909668 1909668 defendant Deryk John tailor 592226 592226 Deryk, John, of Portesmouth, Hants, tailor 5
3721696 1933071 1933071 defendant Howard Harvase yeoman of the crown 592226 592226 Howard, Harvase, of Portesmouth, Hants, yeoman of the crown 3
3747445 1941116 1941116 defendant Henton John brewer 592226 592226 Henton, John, of Portesmouth, Hants, brewer 0
3781070 1951814 1951814 defendant Bright Richard merchant 592226 592226 Bright, Richard, of Portesmouth, Hants, merchant 1
3782981 1952425 1952425 defendant A Borowe John mariner 592226 592226 A Borowe, John, of Portesmouth, Hants, mariner 0
3816579 1963086 1963086 defendant Colman Leonard yeoman 592226 592226 (Colman, Leonard, of Portesmouth, Hants, yeoman 1
3919233 1996762 1996762 defendant Orrell William gent 592226 592226 Orrell, William, of Portesmouth, Hants, gent 0
3951061 2007437 2007437 defendant Efforde John merchant 592226 592226 Efforde, John, of Portesmouth, Hants, merchant 0
3973170 2015187 2015187 defendant Ransted Richard beer brewer 592226 592226 Ransted, Richard, of Portesmouth, Hants, beer brewer 2
4079553 2052985 2052985 defendant Napper John yeoman 592226 592226 Napper, John, of Portesmouth, Hants, yeoman 0
4088306 2056111 2056111 defendant Barnell Henry (legal representative) 592226 592226 Barnell, Henry, of Portesmouth, Hants, shoemaker, executors of 0
4092389 2057581 2057581 defendant Thorney Thomas merchant 592226 592226 Thorney, Thomas, of Portesmouth, Hants, merchant 0
4125011 2069235 2069235 defendant Whyting Richard baker 592226 592226 Whyting, Richard, of Portesmouth, Hants, baker 0
4177460 2087592 2087592 defendant Woodden John merchant 592226 592226 Woodden, John, of Portesmouth, Hants, merchant 0
4207518 2098188 2098188 defendant Siegwicke or Seidgwick Richard merchant 592226 592226 Siegwicke or Seidgwick, Richard, of Portesmouth, Hants, merchant 0
4209397 2098840 2098840 defendant Browne Richard baker 592226 592226 Browne, Richard, of Portesmouth, Hants, baker 0
4311539 2134176 2134176 defendant Swayne John vintner 592226 592226 Swayne, John, of Portesmouth, Hants, yeoman, or of Brighthelmeston, vintner 0
4315839 2135647 2135647 defendant Elton Richard chapman 592226 592226 Elton, Richard, of Portesmouth, Hants, chapman 0
4333052 2141341 2141341 defendant Thorney or Thornell Thomas merchant 592226 592226 Thorney or Thornell, Thomas, of Portesmouth, Hants, merchant 1
4358095 2150074 2150074 defendant Earle Richard gent 592226 592226 Earle, Richard, of Portesmouth, Hants, or of Bowfold, Sussex, gent 0
4361075 2151129 2151129 defendant Elliott John mercer 592226 592226 Elliott, John, of Portesmouth, Hants, mercer 0
4365296 2152652 2152652 defendant Nurton William yeoman 592226 592226 Nurton, William, of Portesmouth, Hants, or of Wells, Soms, yeoman 0
4777971 2289094 2289094 defendant Lady William yeoman 592226 592226 Lady, William, of Portesmouth, Hants, yeoman 3
4882458 2321424 2321424 defendant Sampson Richard   592226 592226 Sampson, Richard, of Portesmouth, Hants 1
4883364 2321719 2321719 defendant Spynace John merchant 592226 592226 Spynace, John, of Portesmouth, Hants, merchant 0
4883625 2321794 2321794 defendant Carpenter John husbandman 592226 592226 Carpenter, John, of Portesmouth, Hants, husbandman 0
4890657 2323834 2323834 defendant Carpenter John husbandman 592226 592226 Carpenter, John, of Portesmouth, Hants, husbandman 0
4969074 2347714 2347714 defendant Estcourt Roger yeoman 592226 592226 Estcourt, Roger, of Portesmouth, Hants, yeoman 2
4974320 2349286 2349286 defendant Frere Robert gent 592226 592226 Frere, Robert, of Portesmouth, Hants, gent 0
4976966 2350065 2350065 defendant Carpenter John, senior yeoman 592226 592226 Carpenter, John, senior, of Portesmouth, Hants, yeoman 3
4976972 2350066 2350066 defendant Carpenter John, senior yeoman 592226 592226 Carpenter, John, senior, of Portesmouth, Hants, yeoman 4
4983531 2351990 2351990 defendant Foxholes John clerk 592226 592226 Foxholes, John, of Portesmouth, Hants, clerk 0
5024431 2364054 2364054 defendant Copyndale Adam merchant 592226 592226 Copyndale, Adam, of Portesmouth, Hants, merchant 0
5024433 2364055 2364055 defendant Copyndale Adam merchant 592226 592226 Copyndale, Adam, of Portesmouth, Hants, merchant 0
5036140 2367423 2367423 defendant Fersey John merchant 592226 592226 Fersey, John, of Portesmouth, Hants, merchant 0
5068937 2377209 2377209 defendant Fyrsse John merchant 592226 592226 Fyrsse, John, of Portesmouth, Hants, merchant 0
5068944 2377210 2377210 defendant Fyrsse John merchant 592226 592226 Fyrsse, John, of Portesmouth, Hants, merchant 0
5084262 2381802 2381802 defendant Vyrsy John merchant 592226 592226 Vyrsy, John, of Portesmouth, Hants, merchant 0
5101546 2386869 2386869 defendant Coleyn John merchant 592226 592226 Coleyn, John, of Portesmouth, Hants, merchant 0
5221083 2421871 2421871 defendant Wode Thomas yeoman 592226 592226 Wode, Thomas, of Portesmouth, Hants, yeoman 0
5227044 2423567 2423567 defendant Vyrsy John merchant 592226 592226 Vyrsy, John, of Portesmouth, Hants, merchant 0
5286272 2440993 2440993 defendant Elyot William clerk 592226 592226 Elyot, William, of Portesmouth, Hants, clerk 6
5286281 2440994 2440994 defendant Elyot William clerk 592226 592226 Elyot, William, of Portesmouth, Hants, clerk 6
5330408 2454174 2454174 defendant Elyot William master of Domus Dei 592226 592226 Elyot, William, of Portesmouth, Hants, clerk, master of Domus Dei 0
5349188 2459870 2459870 defendant Warde John mariner 592226 592226 Warde, John, of Portesmouth, Hants, mariner 3
5453788 2491025 2491025 defendant Elyot William master or warden of the hospital of God & St Nicholas 592226 592226 Elyot, William, of Portesmouth, Hants, clerk, master or warden of the hospital of God & St Nicholas 0
5465669 2494645 2494645 defendant Elyot William master or warden of the hospital of God & St Nicholas 592226 592226 Elyot, William, of Portesmouth, Hants, clerk, master or warden of the hospital of God & St Nicholas 0
5477174 2498181 2498181 defendant Elyot William clerk 592226 592226 Elyot, William, of Portesmouth, Hants, clerk 0
5528220 2513386 2513386 defendant Boner David yeoman 592226 592226 (Boner, David, of Portesmouth, Hants, yeoman 5

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