names

37 rows where place_id = 655255

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3935532 2002194 2002194 defendant Torpe Christopher husbandman 655255 655255 Torpe, Christopher, of Wadherst, husbandman 0
3986606 2019948 2019948 plaintiff Whitfeld Robert   655255 655255 Whitfeld, Robert, of Wadherst 0
3986608 2019949 2019949 plaintiff Whitfilde Robert clothier 655255 655255 Whitfilde, Robert, of Wadherst, clothier 0
3987020 2020099 2020099 plaintiff Woodgate Peter   655255 655255 Woodgate, Peter, of Wadherst 0
4058298 2045354 2045354 defendant Clyff William husbandman 655255 655255 Clyff, William, of Wadherst, husbandman 0
4058299 2045354 2045354 defendant Ford Thomas husbandman 655255 655255 Ford, Thomas, of Wadherst, husbandman 1
4071010 2049931 2049931 defendant Yonge Amos husbandman 655255 655255 Yonge, Amos, of Wadherst, husbandman 1
4092615 2057667 2057667 defendant Turke Daniel yeoman 655255 655255 Turke, Daniel, of Wadherst, yeoman 0
4092616 2057667 2057667 defendant Markwyck Gregory yeoman 655255 655255 Markwyck, Gregory, of Wadherst, yeoman 1
4093179 2057877 2057877 defendant Clarke Philip yeoman 655255 655255 Clarke, Philip, of Wadherst, yeoman 3
4093183 2057878 2057878 defendant Clarke Philip yeoman 655255 655255 Clarke, Philip, of Wadherst, yeoman 2
4187789 2091232 2091232 defendant Turke Daniel   655255 655255 Turke, Daniel, of Wadherst, yeoman, administrators of 1
4191459 2092581 2092581 defendant Apse John yeoman 655255 655255 Apse, John, of Wadherst, yeoman 0
4233148 2107101 2107101 defendant Norton Thomas, senior yeoman 655255 655255 Norton, Thomas, senior, of Wadherst, yeoman 2
4233149 2107101 2107101 defendant Norton Thomas, junior   655255 655255 Norton, Thomas, junior, of Wadherst, yeoman, his son 3
4242964 2110641 2110641 defendant Rofe or Rolfe Gregory   655255 655255 Rofe or Rolfe, Gregory, of Wadherst, or of Maighfeild Sussex, yeoma 1
4253125 2114043 2114043 defendant Rofe or Rolfe Gregory yeoman 655255 655255 Rofe or Rolfe, Gregory, of Wadherst, or of Maighfeld, Sussex, yeoman 1
4317494 2136233 2136233 defendant Gosson John mercer 655255 655255 Gosson, John, of Wadherst, mercer 2
4359371 2150511 2150511 defendant Lewes John joiner 655255 655255 Lewes, John, of Wadherst, joiner 2
4370825 2154619 2154619 defendant Downe Christopher husbandman 655255 655255 Downe, Christopher, of Wadherst, husbandman 0
4373566 2155613 2155613 defendant Beale Henry husbandman 655255 655255 Beale, Henry, of Wadherst, husbandman 0
4379970 2157938 2157938 defendant Parrys Robert, junior tailor 655255 655255 Parrys, Robert, junior, of Wadherst, tailor 0
4497303 2199801 2199801 defendant atte Stelde Reverehall John   655255 655255 atte Stelde Reverehall, John, of Wadherst 0
4535646 2211424 2211424 defendant Sacry John   655255 655255 Sacry, John, of Wadherst 2
4543644 2213907 2213907 defendant atte Wode Richard   655255 655255 atte Wode, Richard, of Wadherst 0
4715879 2270280 2270280 plaintiff Wayneborne John   655255 655255 Wayneborne, John, of Wadherst 0
4737220 2276761 2276761 defendant Wenbourne John laborer 655255 655255 Wenbourne, John, of Wadherst, laborer 0
4737221 2276761 2276761 defendant Baker Thomas tiler 655255 655255 Baker, Thomas, of Wadherst, tiler 1
4867494 2316801 2316801 defendant Becher John smith 655255 655255 Becher, John, of Wadherst, smith 0
4957478 2344207 2344207 defendant Freke Thomas husbandman 655255 655255 Freke, Thomas, of Wadherst, husbandman 0
4957479 2344207 2344207 defendant Freke Robert yeoman 655255 655255 Freke, Robert, of Wadherst, yeoman 1
5228929 2424065 2424065 defendant Kyngwode Thomas tanner 655255 655255 Kyngwode, Thomas, of Wadherst, tanner 0
5228930 2424065 2424065 defendant Berworth Henry yeoman 655255 655255 Berworth, Henry, of Wadherst, yeoman 1
5512593 2508793 2508793 defendant Bate Nicholas husbandman 655255 655255 Bate, Nicholas, of Wadherst, husbandman 2
5512594 2508793 2508793 defendant Bartlot John husbandman 655255 655255 Bartlot, John, of Wadherst, husbandman 3
5579349 2528621 2528621 plaintiff Blachemerden John tailor 655255 655255 Blachemerden, John, of Wadherst, tailor 0
5636091 2555245 2555245 defendant Veregge William draper 655255 655255 Veregge, William, of Wadherst, draper 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);