names

35 rows where place_id = 621475

✎ 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
3741660 1939260 1939260 defendant Yllyngworth Roger husbandman 621475 621475 Yllyngworth, Roger, of Wadyngham, husbandman 2
3746239 1940732 1940732 defendant Wentworth Oliver gent 621475 621475 Wentworth, Oliver, of Wadyngham, gent 1
3759409 1944932 1944932 defendant Wentworth Oliver alias Owen gent 621475 621475 Wentworth, Oliver alias Owen, of Wadyngham, gent 0
4456614 2187091 2187091 plaintiff Nylbergh John   621475 621475 Nylbergh, John, of Wadyngham 0
4456615 2187091 2187091 defendant Clerke John   621475 621475 Clerke, John, of Wadyngham 0
4483293 2195475 2195475 plaintiff Nons or Nene Hugh   621475 621475 Nons or Nene, Hugh, of Wadyngham 0
4486830 2196597 2196597 plaintiff Segod William   621475 621475 Segod, William, of Wadyngham 0
4486831 2196597 2196597 defendant Swan Robert chapman 621475 621475 Swan, Robert, of Wadyngham, chapman 0
4516620 2205611 2205611 defendant Boys John   621475 621475 Boys, John, of Wadyngham 0
4595699 2229914 2229914 defendant Nove Roger   621475 621475 Nove, Roger, of Wadyngham 0
4650159 2246067 2246067 defendant Barowe John de   621475 621475 Barowe, John de, of Wadyngham 2
4677657 2258628 2258628 defendant Alderkirke Thomas husbandman 621475 621475 Alderkirke, Thomas, of Wadyngham, husbandman 0
4737568 2276860 2276860 defendant Taillour John husbandman 621475 621475 Taillour, John, of Wadyngham, husbandman 0
4753846 2281580 2281580 defendant Gemme or Gemune Robert husbandman 621475 621475 Gemme or Gemune, Robert, of Wadyngham, husbandman 0
4762335 2284202 2284202 defendant Chapman William husbandman 621475 621475 Chapman, William, of Wadyngham, husbandman 0
4872336 2318311 2318311 defendant Howette Robert husbandman 621475 621475 Howette, Robert, of Wadyngham, husbandman 0
4924399 2334070 2334070 defendant Howet Robert husbandman 621475 621475 Howet, Robert, of Wadyngham, husbandman 0
4940986 2339204 2339204 defendant Graunge Richard husbandman 621475 621475 Graunge, Richard, of Wadyngham, husbandman 4
4994417 2355206 2355206 defendant atte Hall William husbandman 621475 621475 atte Hall, William, of Wadyngham, husbandman 1
4994419 2355206 2355206 defendant Pecok Robert husbandman 621475 621475 Pecok, Robert, of Wadyngham, husbandman 3
5127543 2394536 2394536 defendant Byrt Richard butcher 621475 621475 Byrt, Richard, of Wadyngham, butcher 0
5146447 2400092 2400092 defendant Byrt Richard butcher 621475 621475 Byrt, Richard, of Wadyngham, butcher 0
5162992 2404904 2404904 defendant Baye John husbandman 621475 621475 Baye, John, of Wadyngham, husbandman 3
5162993 2404904 2404904 defendant Webster Robert husbandman 621475 621475 Webster, Robert, of Wadyngham, husbandman 4
5205489 2417355 2417355 defendant Byrt Richard laborer 621475 621475 Byrt, Richard, of Wadyngham, laborer 5
5213714 2419742 2419742 defendant Knot Thomas husbandman 621475 621475 Knot, Thomas, of Wadyngham, husbandman 9
5348764 2459740 2459740 defendant West Adam yeoman 621475 621475 West, Adam, of Wadyngham, yeoman 0
5348766 2459740 2459740 defendant Holdesworth William yeoman 621475 621475 Holdesworth, William, of Wadyngham, yeoman 2
5348768 2459741 2459741 defendant West Adam yeoman 621475 621475 West, Adam, of Wadyngham, yeoman 0
5348770 2459741 2459741 defendant Holdesworth William yeoman 621475 621475 Holdesworth, William, of Wadyngham, yeoman 2
5348772 2459742 2459742 defendant West Adam yeoman 621475 621475 West, Adam, of Wadyngham, yeoman 0
5348774 2459742 2459742 defendant Holdesworth William yeoman 621475 621475 Holdesworth, William, of Wadyngham, yeoman 2
5587443 2531089 2531089 defendant Halley John husbandman 621475 621475 Halley, John, of Wadyngham, husbandman 0
5606308 2536868 2536868 defendant Bailly Dunstan yeoman 621475 621475 Bailly, Dunstan, of Wadyngham, yeoman 0
5612389 2547621 2547621 defendant Skynnere Roger   621475 621475 Skynnere, Roger, of Wadyngham 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);