names

53 rows where place_id = 768927

✎ 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
4553436 2217004 2217004 plaintiff Gedelyston William chaplain 768927 768927 Gedelyston, William, of Wodeham Ferrers, chaplain 0
4577720 2224537 2224537 defendant Skynner John   768927 768927 Skynner, John, of Wodeham Ferrers 0
4577722 2224538 2224538 defendant Skynner John   768927 768927 Skynner, John, of Wodeham Ferrers 0
4622307 2237957 2237957 plaintiff Lorkyn William   768927 768927 Lorkyn, William, of Wodeham Ferrers 0
4644534 2244491 2244491 plaintiff Maldon John   768927 768927 Maldon, John, of Wodeham Ferrers 0
4664410 2250347 2250347 defendant Tyffeyn William ploughman 768927 768927 Tyffeyn, William, of Wodeham Ferrers, ploughman 0
4665035 2250543 2250543 plaintiff Herde Hugh   768927 768927 Herde, Hugh, of Wodeham Ferrers 0
4665039 2250544 2250544 plaintiff Herde Hugh   768927 768927 Herde, Hugh, of Wodeham Ferrers 0
4722968 2272498 2272498 plaintiff Creket William, sen (legal representative) 768927 768927 Creket, William, sen, of Wodeham Ferrers, executors of 0
4722973 2272499 2272499 plaintiff Creket William, sen (legal representative) 768927 768927 Creket, William, sen, of Wodeham Ferrers, executors of 0
4722979 2272499 2272499 defendant Felde John   768927 768927 Felde, John, of Wodeham Ferrers, iron worker 2
4722981 2272500 2272500 plaintiff Creket William, sen (legal representative) 768927 768927 Creket, William, sen, of Wodeham Ferrers, executors of 0
4722990 2272501 2272501 plaintiff Creket William, sen (legal representative) 768927 768927 Creket, William, sen, of Wodeham Ferrers, executors of 0
4818130 2301745 2301745 defendant Benet William salter 768927 768927 Benet, William, of Wodeham Ferrers, salter 1
4950192 2342024 2342024 defendant Maughtyld William butcher 768927 768927 Maughtyld, William, of Wodeham Ferrers, butcher 0
4968450 2347530 2347530 defendant Prat Richard   768927 768927 Prat, Richard, of Wodeham Ferrers 3
5015035 2361280 2361280 defendant Bode John   768927 768927 Bode, John, of Wodeham Ferrers 0
5069680 2377429 2377429 defendant Cullyngforth Thomas husbandman 768927 768927 Cullyngforth, Thomas, of Wodeham Ferrers, husbandman 4
5090269 2383526 2383526 defendant Phylip William laborer 768927 768927 Phylip, William, of Wodeham Ferrers, laborer 1
5096334 2385359 2385359 defendant Marchaunt William drover 768927 768927 Marchaunt, William, of Wodeham Ferrers, drover 0
5099461 2386278 2386278 defendant Marchaunt William drover 768927 768927 Marchaunt, William, of Wodeham Ferrers, drover 0
5126250 2394163 2394163 defendant Tayllour Thomas husbandman 768927 768927 Tayllour, Thomas, of Wodeham Ferrers, husbandman 0
5126251 2394163 2394163 defendant Hide John husbandman 768927 768927 Hide, John, of Wodeham Ferrers, husbandman 1
5126252 2394163 2394163 defendant Spycer John husbandman 768927 768927 Spycer, John, of Wodeham Ferrers, husbandman 2
5138511 2397765 2397765 defendant Camper John laborer 768927 768927 Camper, John, of Wodeham Ferrers, laborer 0
5144922 2399664 2399664 defendant Tayllour Thomas husbandman 768927 768927 Tayllour, Thomas, of Wodeham Ferrers, husbandman 0
5144923 2399664 2399664 defendant Hyde John husbandman 768927 768927 Hyde, John, of Wodeham Ferrers, husbandman 1
5144924 2399664 2399664 defendant Spycer John husbandman 768927 768927 Spycer, John, of Wodeham Ferrers, husbandman 2
5159272 2403827 2403827 defendant Camper John laborer 768927 768927 Camper, John, of Wodeham Ferrers, laborer 0
5165592 2405679 2405679 defendant Taillour Thomas husbandman 768927 768927 Taillour, Thomas, of Wodeham Ferrers, husbandman 0
5165593 2405679 2405679 defendant Hyde John husbandman 768927 768927 Hyde, John, of Wodeham Ferrers, husbandman 1
5165594 2405679 2405679 defendant Spycer John husbandman 768927 768927 Spycer, John, of Wodeham Ferrers, husbandman 2
5179772 2409822 2409822 defendant Hyde John husbandman 768927 768927 Hyde, John, of Wodeham Ferrers, husbandman 1
5217587 2420884 2420884 defendant Benyngton Richard gent 768927 768927 Benyngton, Richard, of Wodeham Ferrers, gent 0
5220391 2421659 2421659 defendant Pecche John husbandman 768927 768927 Pecche, John, of Wodeham Ferrers, husbandman 5
5220787 2421769 2421769 defendant atte Wode John husbandman 768927 768927 atte Wode, John, of Wodeham Ferrers, husbandman 4
5231093 2424691 2424691 defendant Kynot John husbandman 768927 768927 Kynot, John, of Wodeham Ferrers, husbandman 0
5249590 2429996 2429996 defendant Atthewode John, senior husbandman 768927 768927 Atthewode, John, senior, of Wodeham Ferrers, husbandman 0
5249591 2429996 2429996 defendant Baylly Thomas husbandman 768927 768927 Baylly, Thomas, of Wodeham Ferrers, husbandman 1
5249593 2429997 2429997 defendant Atthelle John, senior husbandman 768927 768927 Atthelle, John, senior, of Wodeham Ferrers, husbandman 0
5249594 2429997 2429997 defendant Baylly Thomas husbandman 768927 768927 Baylly, Thomas, of Wodeham Ferrers, husbandman 1
5255961 2431988 2431988 defendant Welles John gent 768927 768927 Welles, John, of Wodeham Ferrers, gent 1
5272944 2437159 2437159 plaintiff Rede Roger   768927 768927 Rede, Roger, of Wodeham Ferrers 4
5272947 2437159 2437159 defendant Letyn Thomas husbandman 768927 768927 Letyn, Thomas, of Wodeham Ferrers, husbandman 0
5411481 2478390 2478390 defendant Tendryng William yeoman 768927 768927 Tendryng, William, of Wodeham Ferrers, yeoman 7
5425301 2482539 2482539 defendant Zamman Robert husbandman 768927 768927 Zamman, Robert, of Wodeham Ferrers, husbandman 0
5425754 2482672 2482672 defendant Standrope Thomas   768927 768927 Standrope, Thomas, of Wodeham Ferrers, husbandman, administrators of 5
5425756 2482672 2482672 defendant Tendryng William yeoman 768927 768927 Tendryng, William, of Wodeham Ferrers, yeoman 7
5425763 2482673 2482673 defendant Seondrope Thomas   768927 768927 Seondrope, Thomas, of Wodeham Ferrers, husbandman, administrators of 5
5475928 2497807 2497807 defendant Kynot John husbandman 768927 768927 Kynot, John, of Wodeham Ferrers, husbandman 0
5610135 2546879 2546879 plaintiff atte Heye John   768927 768927 atte Heye, John, of Wodeham Ferrers 0
5618243 2549521 2549521 defendant Bette Morris   768927 768927 Bette, Morris, of Wodeham Ferrers 0
5628858 2552996 2552996 defendant Fresyngfeld Richard esq 768927 768927 Fresyngfeld, Richard, of Wodeham Ferrers, esq 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);