names

37 rows where place_id = 758258

✎ 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
4452632 2185827 2185827 defendant Webbe Thomas   758258 758258 Webbe, Thomas, of Great Waldyngfeld 0
4507139 2202700 2202700 defendant Rande John, senior   758258 758258 Rande, John, senior, of Great Waldyngfeld 2
4522586 2207403 2207403 defendant Brook Thomas   758258 758258 Brook, Thomas, of Great Waldyngfeld 0
4553304 2216966 2216966 defendant Brook Thomas   758258 758258 Brook, Thomas, of Great Waldyngfeld 2
4554433 2217319 2217319 plaintiff Grotene James   758258 758258 Grotene, James, of Great Waldyngfeld, parson 0
4598683 2230826 2230826 defendant Brook Thomas   758258 758258 Brook, Thomas, of Great Waldyngfeld 0
4617859 2236587 2236587 plaintiff Grotone James (legal representative) 758258 758258 Grotone, James, of Great Waldyngfeld, executors of 0
4617863 2236588 2236588 plaintiff Grotone James (legal representative) 758258 758258 Grotone, James, of Great Waldyngfeld, parson, executors of 0
4667062 2255430 2255430 plaintiff Appilton Richard (legal representative) 758258 758258 Appilton, Richard, of Great Waldyngfeld, executors of 0
4672831 2257144 2257144 defendant Rande Adam weaver 758258 758258 Rande, Adam, of Great Waldyngfeld, weaver 2
4676864 2258384 2258384 defendant Boys John yeoman 758258 758258 Boys, John, of Great Waldyngfeld, yeoman 1
4679992 2259344 2259344 defendant Colman John yeoman 758258 758258 Colman, John, of Great Waldyngfeld, yeoman 2
4687162 2261590 2261590 defendant Colman John weaver 758258 758258 Colman, John, of Great Waldyngfeld, weaver 2
4706679 2267472 2267472 plaintiff Malcher Thomas   758258 758258 Malcher, Thomas, of Great Waldyngfeld 0
4735130 2276136 2276136 defendant Ive Robert laborer 758258 758258 Ive, Robert, of Great Waldyngfeld, laborer 1
4737589 2276866 2276866 defendant Gawge John husbandman 758258 758258 Gawge, John, of Great Waldyngfeld, husbandman 0
4737592 2276867 2276867 defendant Gawge John husbandman 758258 758258 Gawge, John, of Great Waldyngfeld, husbandman 0
4757283 2282652 2282652 defendant Sydey Richard yeoman 758258 758258 Sydey, Richard, of Great Waldyngfeld, yeoman 0
4989688 2353833 2353833 defendant Syday John, sen husbandman 758258 758258 Syday, John, sen, of Great Waldyngfeld, husbandman 2
5004218 2358126 2358126 plaintiff Ponder John   758258 758258 Ponder, John, of Great Waldyngfeld 0
5137728 2397548 2397548 defendant Salman Thomas husbandman 758258 758258 Salman, Thomas, of Great Waldyngfeld, husbandman 1
5149216 2400902 2400902 defendant Schepperd John husbandman 758258 758258 Schepperd, John, of Great Waldyngfeld, husbandman 1
5152506 2401869 2401869 defendant Penerston John husbandman 758258 758258 Penerston, John, of Great Waldyngfeld, husbandman 0
5157669 2403373 2403373 plaintiff Pellycan John   758258 758258 Pellycan, John, of Great Waldyngfeld 2
5171963 2407513 2407513 defendant Reynham Thomas husbandman 758258 758258 Reynham, Thomas, of Great Waldyngfeld, husbandman 0
5190781 2413055 2413055 defendant Reynham Thomas husbandman 758258 758258 Reynham, Thomas, of Great Waldyngfeld, husbandman 0
5190785 2413056 2413056 defendant Reynham Thomas husbandman 758258 758258 Reynham, Thomas, of Great Waldyngfeld, husbandman 0
5367922 2465592 2465592 defendant Braybrook Thomas fuller 758258 758258 Braybrook, Thomas, of Great Waldyngfeld, fuller 1
5384269 2470588 2470588 defendant Salman Thomas husbandman 758258 758258 Salman, Thomas, of Great Waldyngfeld, husbandman 2
5392648 2472963 2472963 plaintiff Seyday John yeoman 758258 758258 Seyday, John, of Great Waldyngfeld, yeoman 0
5392651 2472963 2472963 defendant Wode Thomas clthmaker 758258 758258 Wode, Thomas, of Great Waldyngfeld, clthmaker 2
5396061 2473961 2473961 defendant Salman Thomas husbandman 758258 758258 Salman, Thomas, of Great Waldyngfeld, husbandman 2
5409381 2477774 2477774 defendant Salman Thomas husbandman 758258 758258 Salman, Thomas, of Great Waldyngfeld, husbandman 2
5422896 2481804 2481804 defendant Salman Thomas husbandman 758258 758258 Salman, Thomas, of Great Waldyngfeld, husbandman 2
5471852 2496534 2496534 defendant Belcham John   758258 758258 Belcham, John, of Great Waldyngfeld, cloth maker 0
5471853 2496534 2496534 defendant Woode Thomas clothmaker 758258 758258 Woode, Thomas, of Great Waldyngfeld, clothmaker 1
5609738 2546743 2546743 defendant Clerk Nicholas   758258 758258 Clerk, Nicholas, of Great Waldyngfeld 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);