names

66 rows where place_id = 595716

✎ 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
3621604 1874298 1874298 defendant Arblaster Thomas clothman 595716 595716 Arblaster, Thomas, of Neylond, Suff, clothman 0
3621609 1874299 1874299 defendant Arblaster Thomas clothman 595716 595716 Arblaster, Thomas, of Neylond, Suff, clothman 0
3623142 1874760 1874760 plaintiff Samown Richard   595716 595716 Samown, Richard, of Neylond, Suff 0
3656280 1912210 1912210 defendant Hamond George clerk 595716 595716 Hamond, George, of Neylond, Suff, clerk 0
3656282 1912211 1912211 defendant Hamond George clerk 595716 595716 Hamond, George, of Neylond, Suff, clerk 0
3673021 1917569 1917569 defendant Coke John weaver 595716 595716 Coke, John, of Neylond, Suff, weaver 1
3675171 1918266 1918266 defendant Roos Stephen clothmaker 595716 595716 Roos, Stephen, of Neylond, Suff, clothmaker 2
3728804 1935256 1935256 plaintiff Abell John (legal representative) 595716 595716 Abell, John, of Neylond, Suff, clothman, executor of 0
3791696 1955248 1955248 defendant Couper Robert clothmaker 595716 595716 Couper, Robert, of Neylond, Suff, clothmaker 0
3799410 1957737 1957737 defendant Tropp or Throp John clerk 595716 595716 Tropp or Throp, John, of Neylond, Suff, clerk 0
3818369 1963643 1963643 defendant Abell Edmund yeoman 595716 595716 Abell, Edmund, of Neylond, Suff, yeoman 12
3842057 1971069 1971069 defendant Mall John clothmaker 595716 595716 Mall, John, of Neylond, Suff, clothmaker 0
3844665 1971875 1971875 defendant Roos Robert clothier 595716 595716 Roos, Robert, of Neylond, Suff, clothier 0
3870754 1980464 1980464 defendant Parysse Thomas   595716 595716 Parysse, Thomas, of Neylond, Suff 0
3898105 1989574 1989574 defendant Planpen John, junior husbandman 595716 595716 Planpen, John, junior, of Neylond, Suff, husbandman 0
3912308 1994447 1994447 defendant Baker William mercer 595716 595716 Baker, William, of Neylond, Suff, mercer 1
3912995 1994679 1994679 defendant Smythe John clothier 595716 595716 Smythe, John, of Neylond, Suff, clothier 2
3965166 2012426 2012426 defendant Rosse Edward gent 595716 595716 Rosse, Edward, of Neylond, Suff, gent 0
4405042 2166261 2166261 defendant Bone Thomas baker 595716 595716 Bone, Thomas, of Neylond, Suff, baker 0
4685570 2261081 2261081 plaintiff Rysyng John   595716 595716 Rysyng, John, of Neylond, Suff 0
4739795 2277523 2277523 defendant Prentys Simon butcher 595716 595716 Prentys, Simon, of Neylond, Suff, butcher 0
4902179 2327292 2327292 defendant Fewer John spicer 595716 595716 Fewer, John, of Neylond, Suff, spicer 4
4906268 2328550 2328550 defendant Gybon John butcher 595716 595716 Gybon, John, of Neylond, Suff, butcher 0
5044669 2370037 2370037 defendant Wright John barber 595716 595716 Wright, John, of Neylond, Suff, barber 0
5060527 2374728 2374728 defendant Newelond Richard fuller 595716 595716 Newelond, Richard, of Neylond, Suff, fuller 0
5064137 2375814 2375814 defendant Brook John merchant 595716 595716 Brook, John, of Neylond, Suff, merchant 0
5093701 2384556 2384556 defendant Hamond John clothmaker 595716 595716 Hamond, John, of Neylond, Suff, clothmaker 3
5104169 2387645 2387645 defendant Hamond William clothmaker 595716 595716 Hamond, William, of Neylond, Suff, clothmaker 0
5113747 2390414 2390414 defendant Sampson Roger husbandman 595716 595716 Sampson, Roger, of Neylond, Suff, husbandman 0
5133979 2396434 2396434 defendant Gylys Roger husbandman 595716 595716 Gylys, Roger, of Neylond, Suff, husbandman 0
5138775 2397839 2397839 defendant Neulond Richard   595716 595716 Neulond, Richard, of Neylond, Suff 1
5224767 2422914 2422914 defendant Hamond William yeoman 595716 595716 Hamond, William, of Neylond, Suff, yeoman 0
5267068 2435459 2435459 defendant Smyth alias Cordewaner Robert (legal representative) 595716 595716 Smyth alias Cordewaner, Robert, of Neylond, Suff, executors of 0
5276302 2438140 2438140 defendant Terry (illegible) tailor 595716 595716 Terry, ----, of Neylond, Suff, tailor 1
5299075 2444712 2444712 defendant Clerk Robert yeoman 595716 595716 Clerk, Robert, of Neylond, Suff, yeoman 1
5332247 2454712 2454712 defendant Aylmer John fuller 595716 595716 Aylmer, John, of Neylond, Suff, fuller 3
5332257 2454714 2454714 defendant Aylmere John fuller 595716 595716 Aylmere, John, of Neylond, Suff, fuller 2
5335914 2455811 2455811 defendant Balston John clothmaker 595716 595716 Balston, John, of Neylond, Suff, clothmaker 0
5359458 2462995 2462995 defendant Bolthode William dyer 595716 595716 Bolthode, William, of Neylond, Suff, dyer 2
5367760 2465546 2465546 defendant Browen Geoffrey husbandman 595716 595716 Browen, Geoffrey, of Neylond, Suff, husbandman 0
5367849 2465571 2465571 plaintiff Cook John   595716 595716 Cook, John, of Neylond, Suff 0
5367851 2465572 2465572 plaintiff Cook John   595716 595716 Cook, John, of Neylond, Suff 0
5375747 2468008 2468008 plaintiff Reygnham Robert   595716 595716 Reygnham, Robert, of Neylond, Suff, cloth maker 0
5375749 2468009 2468009 plaintiff Reygnham Robert   595716 595716 Reygnham, Robert, of Neylond, Suff, cloth maker 0
5413463 2478953 2478953 defendant Spore William clothmaker 595716 595716 Spore, William, of Neylond, Suff, clothmaker 2
5425613 2482642 2482642 plaintiff Coke John   595716 595716 Coke, John, of Neylond, Suff 0
5428776 2483521 2483521 defendant (illegible) William clothmaker 595716 595716 _, William, of Neylond, Suff, clothmaker 2
5428782 2483522 2483522 defendant Spore William clothmaker 595716 595716 Spore, William, of Neylond, Suff, clothmaker 2
5439119 2486623 2486623 defendant Stapull John weaver 595716 595716 Stapull, John, of Neylond, Suff, weaver 5
5444256 2488189 2488189 plaintiff Cook John   595716 595716 Cook, John, of Neylond, Suff 0
5444261 2488190 2488190 plaintiff Cook John   595716 595716 Cook, John, of Neylond, Suff 0
5449361 2489699 2489699 defendant Terry Robert husbandman 595716 595716 Terry, Robert, of Neylond, Suff, husbandman 0
5452986 2490772 2490772 defendant Stapull John weaver 595716 595716 Stapull, John, of Neylond, Suff, weaver 4
5464938 2494425 2494425 defendant Stapull John weaver 595716 595716 Stapull, John, of Neylond, Suff, weaver 4
5464944 2494426 2494426 defendant Stapull John weaver 595716 595716 Stapull, John, of Neylond, Suff, weaver 4
5485994 2500699 2500699 plaintiff Reyngnham Robert clothmaker 595716 595716 Reyngnham, Robert, of Neylond, Suff, clothmaker 0
5487963 2501287 2501287 defendant Hamond John gent 595716 595716 Hamond, John, of Neylond, Suff, gent 3
5495444 2503539 2503539 plaintiff Hatche Nicholas clothmaker 595716 595716 Hatche, Nicholas, of Neylond, Suff, clothmaker 0
5501801 2505493 2505493 defendant Gerveys John clothman 595716 595716 Gerveys, John, of Neylond, Suff, clothman 1
5521217 2511452 2511452 defendant Arblastyr Thomas gent 595716 595716 Arblastyr, Thomas, of Neylond, Suff, gent 0
5523171 2512077 2512077 defendant Hache Nicholas, junior clothmaker 595716 595716 Hache, Nicholas, junior, of Neylond, Suff, clothmaker 0
5523526 2512188 2512188 defendant Hache Richard, junior clothmaker 595716 595716 Hache, Richard, junior, of Neylond, Suff, clothmaker 0
5527876 2513286 2513286 defendant Arblaster Thomas gent 595716 595716 Arblaster, Thomas, of Neylond, Suff, gent 2
5539118 2516717 2516717 defendant Smyth James chapman 595716 595716 Smyth, James, of Neylond, Suff, chapman 0
5578119 2528226 2528226 plaintiff Abell John   595716 595716 Abell, John, of Neylond, Suff 0
5601576 2535386 2535386 defendant Stanysby Roger yeoman 595716 595716 (Stanysby, Roger, of Neylond, Suff, yeoman 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);