names

36 rows where place_id = 591451

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604462 1869064 1869064 defendant Dynne William esq 591451 591451 Dynne, William, of North Creyk, esq 0
3606264 1869626 1869626 defendant Mancer John yeoman 591451 591451 Mancer, John, of North Creyk, yeoman 0
3606808 1869801 1869801 defendant Dynne William gent 591451 591451 Dynne, William, of North Creyk, gent 7
3608262 1870239 1870239 defendant Dynne William yeoman 591451 591451 Dynne, William, of North Creyk, yeoman 0
4421366 2171587 2171587 defendant Pyroun Roger   591451 591451 Pyroun, Roger, of North Creyk, son of William 0
4428648 2173762 2173762 plaintiff Swathyng Roger de   591451 591451 Swathyng, Roger de, of North Creyk, parson 0
4501783 2201152 2201152 defendant Rose Thomas   591451 591451 Rose, Thomas, of North Creyk, parson 1
4501784 2201152 2201152 defendant Parsons-servant Robert the   591451 591451 Parsons-servant, Robert the, of North Creyk 2
4538403 2212295 2212295 defendant Godyr John   591451 591451 Godyr, John, of North Creyk 0
4585690 2226949 2226949 defendant Coo William   591451 591451 Coo, William, of North Creyk 0
4676034 2258116 2258116 plaintiff Gadyrged Robert   591451 591451 Gadyrged, Robert, of North Creyk 0
4719288 2271380 2271380 defendant Danyel William husbandman 591451 591451 Danyel, William, of North Creyk, husbandman 0
4724236 2272874 2272874 plaintiff Barry Muriel widow or relict of Thomas 591451 591451 Barry, Muriel, of North Creyk, widow or relict of Thomas 2
4727998 2274003 2274003 defendant Danyel William husbandman 591451 591451 Danyel, William, of North Creyk, husbandman 0
4741081 2277898 2277898 defendant Vaus John husbandman 591451 591451 Vaus, John, of North Creyk, husbandman 0
4741082 2277898 2277898 defendant Duce John yeoman 591451 591451 Duce, John, of North Creyk, yeoman 1
4743537 2278638 2278638 defendant Heydone Edmund laborer 591451 591451 Heydone, Edmund, of North Creyk, laborer 0
4746969 2279617 2279617 defendant Danyell William yeoman 591451 591451 Danyell, William, of North Creyk, yeoman 0
4760147 2283520 2283520 defendant Danyell William yeoman 591451 591451 Danyell, William, of North Creyk, yeoman 1
4928220 2335254 2335254 defendant Hoker James husbandman 591451 591451 Hoker, James, of North Creyk, husbandman 4
5121759 2392793 2392793 defendant Dynne Roger husbandman 591451 591451 Dynne, Roger, of North Creyk, husbandman 1
5121760 2392793 2392793 defendant Vaus Richard husbandman 591451 591451 Vaus, Richard, of North Creyk, husbandman 2
5219064 2421307 2421307 defendant Pyper John husbandman 591451 591451 Pyper, John, of North Creyk, husbandman 0
5220091 2421585 2421585 defendant Pyper John yeoman 591451 591451 Pyper, John, of North Creyk, yeoman 0
5220095 2421586 2421586 defendant Pyper John yeoman 591451 591451 Pyper, John, of North Creyk, yeoman 0
5258022 2432629 2432629 defendant Pyper John husbandman 591451 591451 Pyper, John, of North Creyk, husbandman 3
5261200 2433616 2433616 plaintiff Man William (legal representative) 591451 591451 Man, William, of North Creyk, yeoman, executor of 0
5422842 2481786 2481786 plaintiff Bekham John   591451 591451 Bekham, John, of North Creyk 0
5422845 2481787 2481787 plaintiff Bekham John   591451 591451 Bekham, John, of North Creyk 0
5484623 2500325 2500325 defendant Bekham John yeoman 591451 591451 Bekham, John, of North Creyk, yeoman 2
5512166 2508668 2508668 defendant Dynne William esq 591451 591451 Dynne, William, of North Creyk, esq 0
5512168 2508669 2508669 defendant Dynne William esq 591451 591451 Dynne, William, of North Creyk, esq 0
5512169 2508669 2508669 defendant Cosyn Richard husbandman 591451 591451 Cosyn, Richard, of North Creyk, husbandman 1
5533644 2515069 2515069 defendant Gonne John husbandman 591451 591451 Gonne, John, of North Creyk, husbandman 0
5553809 2521151 2521151 defendant Dynne William esq 591451 591451 Dynne, William, of North Creyk, esq 0
5620257 2550193 2550193 defendant Thresshebred Roger   591451 591451 Thresshebred, Roger, of North Creyk 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);