names

24 rows where place_id = 585904

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587463 1863727 1863727 defendant Swyft Thomas yeoman 585904 585904 Swyft, Thomas, of Berton Bendyche, yeoman 0
3587464 1863727 1863727 defendant Warthyll Thomas clerk 585904 585904 Warthyll, Thomas, of Berton Bendyche, clerk 1
3591104 1864841 1864841 defendant Lede Thomas shoemaker 585904 585904 Lede, Thomas, of Berton Bendyche, shoemaker 2
3726614 1934584 1934584 defendant Lovell Thomas   585904 585904 Lovell, Thomas, of Berton Bendyche, knight 0
4719298 2271382 2271382 defendant Bulwere William clerk 585904 585904 Bulwere, William, of Berton Bendyche, clerk 1
4719299 2271383 2271383 plaintiff Berry Thomas   585904 585904 Berry, Thomas, of Berton Bendyche 0
4719300 2271383 2271383 defendant Botiller Lawrence husbandman 585904 585904 Botiller, Lawrence, of Berton Bendyche, husbandman 0
4719876 2271562 2271562 defendant Berry Thomas yeoman 585904 585904 Berry, Thomas, of Berton Bendyche, yeoman 0
4719878 2271563 2271563 defendant Berry Thomas yeoman 585904 585904 Berry, Thomas, of Berton Bendyche, yeoman 0
4719879 2271563 2271563 defendant Fygge Walter yeoman 585904 585904 Fygge, Walter, of Berton Bendyche, yeoman 1
4760146 2283520 2283520 defendant Thacher Laurence yeoman 585904 585904 Thacher, Laurence, of Berton Bendyche, yeoman 0
4760148 2283520 2283520 defendant Bulwer John yeoman 585904 585904 Bulwer, John, of Berton Bendyche, yeoman 2
4827297 2304584 2304584 defendant Upton Richard husbandman 585904 585904 Upton, Richard, of Berton Bendyche, husbandman 1
4827298 2304584 2304584 defendant Bolwer John husbandman 585904 585904 Bolwer, John, of Berton Bendyche, husbandman 2
5075169 2379072 2379072 defendant Hexgreve or Hexgrene Robert husbandman 585904 585904 Hexgreve or Hexgrene, Robert, of Berton Bendyche, husbandman 1
5089567 2383324 2383324 defendant Heycok John, senior yeoman 585904 585904 Heycok, John, senior, of Berton Bendyche, yeoman 1
5093935 2384625 2384625 defendant Cook John yeoman 585904 585904 Cook, John, of Berton Bendyche, yeoman 0
5103733 2387514 2387514 defendant Doget William husbandman 585904 585904 Doget, William, of Berton Bendyche, husbandman 0
5241929 2427836 2427836 defendant Stonham John   585904 585904 Stonham, John, of Berton Bendyche, yeoman, son of Stonham, Geoffrey 0
5241933 2427838 2427838 defendant Sparke Robert yeoman 585904 585904 Sparke, Robert, of Berton Bendyche, yeoman 0
5260828 2433509 2433509 defendant Foxe John husbandman 585904 585904 Foxe, John, of Berton Bendyche, husbandman 2
5536363 2515860 2515860 defendant Alam William clerk 585904 585904 Alam, William, of Berton Bendyche, clerk 3
5624172 2551505 2551505 plaintiff Langdon Robert   585904 585904 Langdon, Robert, of Berton Bendyche 0
5624176 2551505 2551505 defendant Bulwer John yeoman 585904 585904 Bulwer, John, of Berton Bendyche, yeoman 3

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