names

61 rows where place_id = 618316

✎ 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
3723852 1933739 1933739 defendant Rede John husbandman 618316 618316 Rede, John, of Warbleton, husbandman 0
3753347 1942985 1942985 defendant Banys John yeoman 618316 618316 Banys, John, of Warbleton, yeoman 1
3858185 1976216 1976216 defendant Marten Thomas carpenter 618316 618316 Marten, Thomas, of Warbleton, carpenter 2
3861209 1977225 1977225 defendant Alman James yeoman 618316 618316 Alman, James, of Warbleton, yeoman 1
3927660 1999589 1999589 defendant Woodman Richard yeoman 618316 618316 Woodman, Richard, of Warbleton, yeoman 0
3980271 2017710 2017710 defendant Aleberye Robert husbandman 618316 618316 Aleberye, Robert, of Warbleton, husbandman 0
4031365 2035890 2035890 defendant Cheyney Richard esq 618316 618316 Cheyney, Richard, of Warbleton, esq 0
4031366 2035890 2035890 defendant Collyns Hugh yeoman 618316 618316 Collyns, Hugh, of Warbleton, yeoman 1
4031367 2035890 2035890 defendant Holbeme William yeoman 618316 618316 Holbeme, William, of Warbleton, yeoman 2
4031368 2035890 2035890 defendant Holbeme John yeoman 618316 618316 Holbeme, John, of Warbleton, yeoman 3
4031369 2035890 2035890 defendant Aweekes John yeoman 618316 618316 Aweekes, John, of Warbleton, yeoman 4
4031370 2035890 2035890 defendant Haward Richard yeoman 618316 618316 Haward, Richard, of Warbleton, yeoman 5
4031371 2035890 2035890 defendant Wymble John yeoman 618316 618316 Wymble, John, of Warbleton, yeoman 6
4031372 2035890 2035890 defendant Byssinden John yeoman 618316 618316 Byssinden, John, of Warbleton, yeoman 7
4031373 2035890 2035890 defendant Gardyner Thomas husbandman 618316 618316 Gardyner, Thomas, of Warbleton, husbandman 8
4065638 2048001 2048001 defendant Holbeme John yeoman 618316 618316 Holbeme, John, of Warbleton, yeoman 0
4065642 2048002 2048002 defendant Durrant John husbandman 618316 618316 Durrant, John, of Warbleton, husbandman 0
4073231 2050717 2050717 defendant Bysshopenden John yeoman 618316 618316 Bysshopenden, John, of Warbleton, yeoman 2
4073232 2050717 2050717 defendant Pettytt John yeoman 618316 618316 Pettytt, John, of Warbleton, yeoman 3
4081122 2053560 2053560 defendant Bysshoppenden Alexander sherman 618316 618316 Bysshoppenden, Alexander, of Warbleton, sherman 1
4081921 2053837 2053837 defendant Symmes John yeoman 618316 618316 Symmes, John, of Warbleton, yeoman 0
4093177 2057877 2057877 defendant Wallopp John yeoman 618316 618316 Wallopp, John, of Warbleton, yeoman 1
4093181 2057878 2057878 defendant Wallopp John yeoman 618316 618316 Wallopp, John, of Warbleton, yeoman 0
4097614 2059473 2059473 defendant West William yeoman 618316 618316 West, William, of Warbleton, yeoman 2
4097716 2059514 2059514 defendant Avery Edward yeoman 618316 618316 Avery, Edward, of Warbleton, yeoman 0
4109650 2063708 2063708 plaintiff Rolfe William (legal representative) 618316 618316 Rolfe, William, of Warbleton, forgemaster, administratrix of 0
4158949 2081196 2081196 defendant Brownyng John husbandman 618316 618316 Brownyng, John, of Warbleton, husbandman 2
4167884 2084251 2084251 defendant Peckham Richard husbandman 618316 618316 Peckham, Richard, of Warbleton, husbandman 2
4171010 2085343 2085343 defendant A Reede John yeoman 618316 618316 A Reede, John, of Warbleton, yeoman 2
4173674 2086246 2086246 defendant Ellys Richard yeoman 618316 618316 Ellys, Richard, of Warbleton, yeoman 0
4173997 2086360 2086360 defendant Stace alias Shether William yeoman 618316 618316 Stace alias Shether, William, of Warbleton, yeoman 2
4174010 2086362 2086362 defendant Cade Mathew collier 618316 618316 Cade, Mathew, of Warbleton, collier 3
4174014 2086363 2086363 defendant Armytage Nicholas blacksmith 618316 618316 Armytage, Nicholas, of Warbleton, blacksmith 1
4174861 2086676 2086676 defendant Durrant John yeoman 618316 618316 Durrant, John, of Warbleton, yeoman 1
4179244 2088218 2088218 defendant Lanckeford or Lauckeford Richard husbandman 618316 618316 Lanckeford or Lauckeford, Richard, of Warbleton, husbandman 0
4206380 2097774 2097774 defendant Byshopenden John husbandman 618316 618316 Byshopenden, John, of Warbleton, husbandman 2
4229692 2105866 2105866 defendant Elyard Thomas tailor 618316 618316 Elyard, Thomas, of Warbleton, tailor 0
4231577 2106544 2106544 defendant Herryott Robert yeoman 618316 618316 Herryott, Robert, of Warbleton, yeoman 0
4234951 2107775 2107775 defendant Comper John tanner 618316 618316 Comper, John, of Warbleton, tanner 0
4259847 2116265 2116265 defendant Elyard or Elyat Thomas tailor 618316 618316 Elyard or Elyat, Thomas, of Warbleton, tailor 0
4283981 2124314 2124314 defendant Pettyt John yeoman 618316 618316 Pettyt, John, of Warbleton, yeoman 2
4286616 2125259 2125259 defendant Swetman John husbandman 618316 618316 Swetman, John, of Warbleton, husbandman 2
4310493 2133823 2133823 defendant Browne William carpenter 618316 618316 Browne, William, of Warbleton, carpenter 0
4315677 2135594 2135594 defendant Ellyott alias Elieard Thomas tailor 618316 618316 Ellyott alias Elieard, Thomas, of Warbleton, tailor 2
4318669 2136639 2136639 defendant Durrant William husbandman 618316 618316 Durrant, William, of Warbleton, husbandman 0
4318670 2136639 2136639 defendant Reade Richard carpenter 618316 618316 Reade, Richard, of Warbleton, carpenter 1
4340894 2144088 2144088 defendant Browne Richard (legal representative) 618316 618316 Browne, Richard, of Warbleton, joiner, executors of 0
4340895 2144088 2144088 defendant Tharpe Richard weaver 618316 618316 (Tharpe, Richard, of Warbleton, weaver 1
4359840 2150682 2150682 defendant Tarpe Richard weaver 618316 618316 Tarpe, Richard, of Warbleton, weaver 0
4360861 2151052 2151052 defendant Avery Thomas husbandman 618316 618316 Avery, Thomas, of Warbleton, husbandman 0
4362931 2151802 2151802 defendant Morrell Simon collier 618316 618316 Morrell, Simon, of Warbleton, collier 0
4366415 2153031 2153031 defendant Cade Mathew collier 618316 618316 Cade, Mathew, of Warbleton, collier 0
4366416 2153031 2153031 defendant Cade William collier 618316 618316 Cade, William, of Warbleton, collier 1
4370358 2154452 2154452 defendant Lewes John collier 618316 618316 Lewes, John, of Warbleton, collier 0
4377240 2156934 2156934 defendant Danne Jasper husbandman 618316 618316 together with Danne, Jasper, of Warbleton, husbandman 2
4378497 2157381 2157381 defendant Sheather alias Stace William yeoman 618316 618316 Sheather alias Stace, William, of Warbleton, yeoman 0
4378500 2157382 2157382 defendant Bodge John husbandman 618316 618316 Bodge, John, of Warbleton, husbandman 1
4403204 2165642 2165642 defendant Holman Thomas (legal representative) 618316 618316 Holman, Thomas, of Warbleton, husbandman, administrator of 0
4403205 2165642 2165642 defendant Holman John husbandman 618316 618316 Holman, John, of Warbleton, husbandman 1
4709624 2268372 2268372 defendant Lande Nicholas husbandman 618316 618316 Lande, Nicholas, of Warbleton, husbandman 1
4709627 2268373 2268373 defendant Lande Nicholas husbandman 618316 618316 Lande, Nicholas, of Warbleton, husbandman 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);