names

36 rows where place_id = 788645

✎ 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
4708850 2268136 2268136 defendant Gogeler James laborer 788645 788645 Gogeler, James, of Bekle, laborer 0
4708867 2268142 2268142 defendant Edward Richard baker 788645 788645 Edward, Richard, of Bekle, baker 0
4730531 2274747 2274747 defendant Tanhous John husbandman 788645 788645 Tanhous, John, of Bekle, husbandman 4
4807744 2298609 2298609 defendant Ludley John husbandman 788645 788645 Ludley, John, of Bekle, husbandman 0
4818707 2301937 2301937 defendant Roieon or Roidon William   788645 788645 Roieon or Roidon, William, of Bekle, parson 0
4818708 2301937 2301937 defendant Hert Thomas husbandman 788645 788645 Hert, Thomas, of Bekle, husbandman 1
4906854 2328729 2328729 defendant Holman Roger butcher 788645 788645 Holman, Roger, of Bekle, butcher 2
4914297 2330985 2330985 plaintiff Creche Richard husbandman 788645 788645 Creche, Richard, of Bekle, husbandman 0
4922164 2333346 2333346 defendant Wodehale John clerk 788645 788645 Wodehale, John, of Bekle, clerk 0
4922165 2333346 2333346 defendant Holman Roger butcher 788645 788645 Holman, Roger, of Bekle, butcher 1
4922166 2333346 2333346 defendant Byxle John husbandman 788645 788645 Byxle, John, of Bekle, husbandman 2
4922167 2333346 2333346 defendant Belcompe Robert barber 788645 788645 Belcompe, Robert, of Bekle, barber 3
4932890 2336677 2336677 defendant Brambyll Roger husbandman 788645 788645 Brambyll, Roger, of Bekle, husbandman 0
4932891 2336677 2336677 defendant Brambyll John laborer 788645 788645 Brambyll, John, of Bekle, laborer 1
4962545 2345701 2345701 defendant Bredenex John, senior husbandman 788645 788645 Bredenex, John, senior, of Bekle, husbandman 1
5002992 2357777 2357777 defendant Colyn Thomas husbandman 788645 788645 Colyn, Thomas, of Bekle, husbandman 0
5010207 2359850 2359850 defendant Wodelond John husbandman 788645 788645 Wodelond, John, of Bekle, husbandman 1
5015495 2361417 2361417 defendant Selawe John husbandman 788645 788645 Selawe, John, of Bekle, husbandman 0
5078228 2379974 2379974 defendant atte Hope John husbandman 788645 788645 atte Hope, John, of Bekle, husbandman 0
5078229 2379974 2379974 defendant Brown John, junior husbandman 788645 788645 Brown, John, junior, of Bekle, husbandman 1
5103105 2387332 2387332 defendant Wattes Stephen husbandman 788645 788645 Wattes, Stephen, of Bekle, husbandman 1
5109966 2389343 2389343 defendant Helman John husbandman 788645 788645 Helman, John, of Bekle, husbandman 0
5142081 2398804 2398804 defendant Fouder Robert husbandman 788645 788645 Fouder, Robert, of Bekle, husbandman 1
5163233 2404976 2404976 defendant Forder Robert husbandman 788645 788645 Forder, Robert, of Bekle, husbandman 1
5217611 2420890 2420890 defendant Wychard John husbandman 788645 788645 Wychard, John, of Bekle, husbandman 8
5257708 2432530 2432530 defendant Bayly Richard laborer 788645 788645 Bayly, Richard, of Bekle, laborer 4
5257709 2432530 2432530 defendant Goodgrome Richard laborer 788645 788645 Goodgrome, Richard, of Bekle, laborer 5
5260091 2433278 2433278 defendant Broke John husbandman 788645 788645 Broke, John, of Bekle, husbandman 0
5309017 2447735 2447735 defendant Broke John yeoman 788645 788645 Broke, John, of Bekle, yeoman 0
5352281 2460813 2460813 defendant Blachynden Thomas tailor 788645 788645 Blachynden, Thomas, of Bekle, tailor 1
5354072 2461337 2461337 defendant Bewes John yeoman 788645 788645 Bewes, John, of Bekle, yeoman 1
5354073 2461337 2461337 defendant Whicamore or Whitamore John yeoman 788645 788645 Whicamore or Whitamore, John, of Bekle, yeoman 2
5358068 2462591 2462591 defendant Oxenbrigge William   788645 788645 Oxenbrigge, William, of Bekle 0
5362553 2463935 2463935 defendant Bysshop Robert husbandman 788645 788645 Bysshop, Robert, of Bekle, husbandman 0
5362555 2463936 2463936 defendant Edward John tailor 788645 788645 Edward, John, of Bekle, tailor 0
5609443 2537849 2537849 defendant Goler William husbandman 788645 788645 Goler, William, of Bekle, husbandman 2

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