names

34 rows where place_id = 598082

✎ 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
3631033 1904527 1904527 defendant Hannes or Haimes Thomas husbandman 598082 598082 Hannes or Haimes, Thomas, of Thyrnyng, husbandman 2
3631688 1904724 1904724 defendant Anneys or Aimeys Thomas husbandman 598082 598082 Anneys or Aimeys, Thomas, of Thyrnyng, husbandman 2
3632393 1904950 1904950 defendant Hanneys Thomas husbandman 598082 598082 Hanneys, Thomas, of Thyrnyng, husbandman 2
3830700 1967485 1967485 defendant Hannes Thomas (legal representative) 598082 598082 Hannes, Thomas, of Thyrnyng, husbandman, executor of 0
3830704 1967486 1967486 defendant Hannes Thomas (legal representative) 598082 598082 Hannes, Thomas, of Thyrnyng, husbandman, executor of 0
3868002 1979531 1979531 defendant Elwyn William butcher 598082 598082 Elwyn, William, of Thyrnyng, butcher 1
3875205 1981947 1981947 plaintiff Elwyn William   598082 598082 Elwyn, William, of Thyrnyng 0
3917822 1996321 1996321 defendant Elwyn William yeoman 598082 598082 Elwyn, William, of Thyrnyng, yeoman 1
4259577 2116179 2116179 defendant Bateman William glover 598082 598082 Bateman, William, of Thyrnyng, glover 2
4421742 2171681 2171681 defendant Richard William   598082 598082 Richard, William, of Thyrnyng 1
4873149 2318553 2318553 defendant Welhouse John yeoman 598082 598082 Welhouse, John, of Thyrnyng, yeoman 3
4873150 2318553 2318553 defendant Cabbelowe Thomas yeoman 598082 598082 Cabbelowe, Thomas, of Thyrnyng, yeoman 4
4901180 2326980 2326980 defendant Colynys John husbandman 598082 598082 Colynys, John, of Thyrnyng, husbandman 9
4924825 2334198 2334198 plaintiff Osberne Thomas butcher 598082 598082 Osberne, Thomas, of Thyrnyng, butcher 0
5066046 2376369 2376369 defendant Mayson Henry husbandman 598082 598082 Mayson, Henry, of Thyrnyng, husbandman 1
5235305 2425905 2425905 defendant Alden Robert husbandman 598082 598082 Alden, Robert, of Thyrnyng, husbandman 1
5258805 2432873 2432873 defendant Fornefeld John yeoman 598082 598082 Fornefeld, John, of Thyrnyng, yeoman 2
5275339 2437860 2437860 defendant Alden Robert yeoman 598082 598082 Alden, Robert, of Thyrnyng, yeoman 0
5285828 2440880 2440880 defendant Fornfeld John yeoman 598082 598082 Fornfeld, John, of Thyrnyng, yeoman 1
5291842 2442619 2442619 defendant Alden Robert husbandman 598082 598082 Alden, Robert, of Thyrnyng, husbandman 0
5303169 2445940 2445940 defendant Alden Robert husbandman 598082 598082 Alden, Robert, of Thyrnyng, husbandman 0
5304317 2446294 2446294 defendant Parlet Richard husbandman 598082 598082 Parlet, Richard, of Thyrnyng, husbandman 0
5319751 2451001 2451001 defendant Parlet Joan spinster 598082 598082 Parlet, Joan, of Thyrnyng, spinster 0
5321502 2451523 2451523 defendant Duyke William husbandman 598082 598082 Duyke, William, of Thyrnyng, husbandman 0
5361343 2463568 2463568 defendant Talface Richard yeoman 598082 598082 Talface, Richard, of Thyrnyng, yeoman 0
5408204 2477429 2477429 defendant Redale Nicholas husbandman 598082 598082 Redale, Nicholas, of Thyrnyng, husbandman 1
5453987 2491083 2491083 defendant Redhale Nicholas husbandman 598082 598082 Redhale, Nicholas, of Thyrnyng, husbandman 1
5525915 2512697 2512697 defendant Bulware Thomas husbandman 598082 598082 Bulware, Thomas, of Thyrnyng, husbandman 0
5526568 2512878 2512878 defendant Seman Thomas thatcher 598082 598082 Seman, Thomas, of Thyrnyng, thatcher 2
5532211 2514621 2514621 defendant Overton Thomas husbandman 598082 598082 Overton, Thomas, of Thyrnyng, husbandman 0
5532934 2514842 2514842 defendant Overton Thomas husbandman 598082 598082 Overton, Thomas, of Thyrnyng, husbandman 0
5561946 2523475 2523475 defendant Crane William clerk 598082 598082 Crane, William, of Thyrnyng, clerk 0
5561953 2523476 2523476 defendant Crane William clerk 598082 598082 Crane, William, of Thyrnyng, clerk 1
5561954 2523476 2523476 defendant Crane John yeoman 598082 598082 Crane, John, of Thyrnyng, yeoman 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);