names

39 rows where place_id = 597393

✎ 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
3628398 1903747 1903747 defendant Bradryp John husbandman 597393 597393 Bradryp, John, of Est Pennard, husbandman 0
3632327 1904932 1904932 defendant Andrewe Walter husbandman 597393 597393 Andrewe, Walter, of Est Pennard, husbandman 1
4015606 2030279 2030279 defendant Byllynge Roger husbandman 597393 597393 Byllynge, Roger, of Est Pennard, husbandman 0
4015607 2030279 2030279 defendant Byllynge Richard husbandman 597393 597393 Byllynge, Richard, of Est Pennard, husbandman 1
4063088 2047098 2047098 defendant Ryves Walter butcher 597393 597393 Ryves, Walter, of Est Pennard, butcher 0
4063089 2047098 2047098 defendant Wason Thomas yeoman 597393 597393 Wason, Thomas, of Est Pennard, yeoman 1
4122826 2068455 2068455 defendant Bucke Ralph yeoman 597393 597393 Bucke, Ralph, of Est Pennard, yeoman 0
4122828 2068456 2068456 defendant Bucke Ralph yeoman 597393 597393 Bucke, Ralph, of Est Pennard, yeoman 0
4174476 2086539 2086539 defendant More John yeoman 597393 597393 More, John, of Est pennard, yeoman 3
4180978 2088825 2088825 defendant Fyot Thomas husbandman 597393 597393 Fyot, Thomas, of East Pennard, husbandman 0
4197818 2094792 2094792 defendant Ames Thomas smith 597393 597393 Ames, Thomas, of Est Pennard, smith 0
4221730 2103094 2103094 defendant Ribes or Rives Walter yeoman 597393 597393 Ribes or Rives, Walter, of Est Pennard, yeoman 0
4242360 2110443 2110443 defendant Jollyff alias Buck Nicholas husbandman 597393 597393 Jollyff alias Buck, Nicholas, of Est Pennard, husbandman 0
4252185 2113718 2113718 defendant Jollyff alias Buck Nicholas husbandman 597393 597393 Jollyff alias Buck, Nicholas, of Est Pennard, husbandman 0
4263237 2117371 2117371 defendant Bushe William husbandman 597393 597393 Bushe, William, of East Pennard, husbandman 0
4263240 2117372 2117372 defendant Bushe William husbandman 597393 597393 Bushe, William, of East Pennard, husbandman 1
4263484 2117449 2117449 defendant Hippesley Richard gent 597393 597393 Hippesley, Richard, of East Pennard, gent 0
4288115 2125798 2125798 defendant Forde alias Symmes Henry yeoman 597393 597393 Forde alias Symmes, Henry, of Est Pennard, yeoman 0
4321251 2137524 2137524 defendant Dalton John husbandman 597393 597393 Dalton, John, of East Pennard, husbandman 0
4725592 2273291 2273291 defendant Pury John husbandman 597393 597393 Pury, John, of East Pennard, husbandman 0
4736925 2276678 2276678 defendant atte Hole Geoffrey husbandman 597393 597393 atte Hole, Geoffrey, of East Pennard, husbandman 0
5029977 2365643 2365643 defendant Walter William husbandman 597393 597393 Walter, William, of Est Pennard, husbandman 0
5240614 2427466 2427466 plaintiff Kene William   597393 597393 Kene, William, of Est Pennard 0
5281065 2439537 2439537 defendant Fareman Thomas (legal representative) 597393 597393 Fareman, Thomas, of Est Pennard, clerk, executor of 0
5281068 2439538 2439538 defendant Fareman Thomas (legal representative) 597393 597393 Fareman, Thomas, of Est Pennard, clerk, executor of 0
5290638 2442263 2442263 defendant Fareman Thomas (legal representative) 597393 597393 Fareman, Thomas, of Est Pennard, clerk, executor of 0
5314624 2449408 2449408 defendant West William husbandman 597393 597393 West, William, of Est Pennard, husbandman 0
5317235 2450236 2450236 defendant Shete John, senior husbandman 597393 597393 Shete, John, senior, of Est Pennard, husbandman 0
5317236 2450236 2450236 defendant Shete John, junior husbandman 597393 597393 Shete, John, junior, of Est Pennard, husbandman 1
5347132 2459262 2459262 defendant Stephyns Nicholas chapman 597393 597393 Stephyns, Nicholas, of Est Pennard, chapman 0
5360266 2463249 2463249 defendant Robyns William husbandman 597393 597393 Robyns, William, of Est Pennard, husbandman 3
5360268 2463249 2463249 defendant Druet John husbandman 597393 597393 Druet, John, of Est Pennard, husbandman 5
5360270 2463249 2463249 defendant Wareyn Richard yeoman 597393 597393 Wareyn, Richard, of Est Pennard, yeoman 7
5515239 2509613 2509613 defendant Drewet John husbandman 597393 597393 Drewet, John, of of Est Pennard, husbandman 0
5515240 2509613 2509613 defendant Elys Thomas husbandman 597393 597393 Elys, Thomas, of Est Pennard, husbandman 1
5515241 2509613 2509613 defendant Edmond William husbandman 597393 597393 Edmond, William, of Est Pennard, husbandman 2
5515243 2509614 2509614 defendant Dunne William husbandman 597393 597393 Dunne, William, of Est Pennard, husbandman 0
5515244 2509614 2509614 defendant Robyns William husbandman 597393 597393 Robyns, William, of Est Pennard, husbandman 1
5546874 2519086 2519086 defendant Lucas John chaplain 597393 597393 Lucas, John, of Est Pennard, chaplain 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);