names

45 rows where case_id = 2453027

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5326563 2453027 2453027 plaintiff Strelley John esq 603165 603165 Strelley, John, of Lyndeby, esq 0
5326564 2453027 2453027 defendant Hertyshyll John gent 597000 597000 Hertyshyll, John, of Claworth, gent 0
5326565 2453027 2453027 defendant Ekkyls John yeoman 597000 597000 Ekkyls, John, of Claworth, yeoman 1
5326566 2453027 2453027 defendant Williamson William, senior husbandman 597000 597000 Williamson, William, senior, of Claworth, husbandman 2
5326567 2453027 2453027 defendant Burgon Thomas husbandman 597000 597000 Burgon, Thomas, of Claworth, husbandman 3
5326568 2453027 2453027 defendant Burgon John husbandman 597000 597000 Burgon, John, of Claworth, husbandman 4
5326569 2453027 2453027 defendant Bradley John, senior husbandman 597000 597000 Bradley, John, senior, of Claworth, husbandman 5
5326570 2453027 2453027 defendant Calton Robert husbandman 597000 597000 Calton, Robert, of Claworth, husbandman 6
5326571 2453027 2453027 defendant Bette John, junior husbandman 597000 597000 Bette, John, junior, of Claworth, husbandman 7
5326572 2453027 2453027 defendant Pollard Nicholas husbandman 597000 597000 Pollard, Nicholas, of Claworth, husbandman 8
5326573 2453027 2453027 defendant Clerk William husbandman 648690 648690 Clerk, William, of Chaworth, husbandman 9
5326574 2453027 2453027 defendant Bradley John junioor, of Claworth, husbandman   Bradley, John, junioor, of Claworth, husbandman 10
5326575 2453027 2453027 defendant Dutton Robert laborer 597000 597000 Dutton, Robert, of Claworth, laborer 11
5326576 2453027 2453027 defendant Bette William husbandman 597000 597000 Bette, William, of Claworth, husbandman 12
5326577 2453027 2453027 defendant Herryson William husbandman 597000 597000 Herryson, William, of Claworth, husbandman 13
5326578 2453027 2453027 defendant Wrygh Richard husbandman 597000 597000 Wrygh, Richard, of Claworth, husbandman 14
5326579 2453027 2453027 defendant Brystowe John husbandman 597000 597000 Brystowe, John, of Claworth, husbandman 15
5326580 2453027 2453027 defendant Clynson William husbandman 597000 597000 Clynson, William, of Claworth, husbandman 16
5326581 2453027 2453027 defendant Forton Richard husbandman 597000 597000 Forton, Richard, of Claworth, husbandman 17
5326582 2453027 2453027 defendant Cressy John husbandman 597000 597000 Cressy, John, of Claworth, husbandman 18
5326583 2453027 2453027 defendant Bolton Robert husbandman 597000 597000 Bolton, Robert, of Claworth, husbandman 19
5326584 2453027 2453027 defendant Whitehorn John husbandman 597000 597000 Whitehorn, John, of Claworth, husbandman 20
5326585 2453027 2453027 defendant Stele Robert husbandman 597000 597000 Stele, Robert, of Claworth, husbandman 21
5326586 2453027 2453027 defendant Broune Thomas husbandman 597000 597000 Broune, Thomas, of Claworth, husbandman 22
5326587 2453027 2453027 defendant Roger Thomas husbandman 597000 597000 Roger, Thomas, of Claworth, husbandman 23
5326588 2453027 2453027 defendant Tomson William husbandman 597000 597000 Tomson, William, of Claworth, husbandman 24
5326589 2453027 2453027 defendant Holme Robert husbandman 597000 597000 Holme, Robert, of Claworth, husbandman 25
5326590 2453027 2453027 defendant Johnson Robert husbandman 597000 597000 Johnson, Robert, of Claworth, husbandman 26
5326591 2453027 2453027 defendant Frebur Thomas husbandman 597000 597000 Frebur, Thomas, of Claworth, husbandman 27
5326592 2453027 2453027 defendant Robynson John husbandman 597000 597000 Robynson, John, of Claworth, husbandman 28
5326593 2453027 2453027 defendant Johnson Thomas husbandman 597000 597000 Johnson,Thomas, of Claworth, husbandman 29
5326594 2453027 2453027 defendant Wryght Thomas husbandman 597000 597000 Wryght, Thomas, of Claworth, husbandman 30
5326595 2453027 2453027 defendant Wod William husbandman 597000 597000 Wod, William, of Claworth, husbandman 31
5326596 2453027 2453027 defendant Clerkson William husbandman 597000 597000 Clerkson, William, of Claworth, husbandman 32
5326597 2453027 2453027 defendant Clerkson Christopher laborer 597000 597000 Clerkson, Christopher, of Claworth, laborer 33
5326598 2453027 2453027 defendant Willyamson William, junior husbandman 597000 597000 Willyamson, William, junior, of Claworth, husbandman 34
5326599 2453027 2453027 defendant Baker John husbandman 597000 597000 Baker, John, of Claworth, husbandman 35
5326600 2453027 2453027 defendant Claworth John laborer 597000 597000 Claworth, John, of Claworth, laborer 36
5326601 2453027 2453027 defendant Doly John husbandman 622943 622943 Doly, John, of Hayton, husbandman 37
5326602 2453027 2453027 defendant Lylly Robert husbandman 622943 622943 Lylly, Robert, of Hayton, husbandman 38
5326603 2453027 2453027 defendant Lylly William husbandman 622943 622943 Lylly, William, of Hayton, husbandman 39
5326604 2453027 2453027 defendant Wilson Thomas husbandman 622943 622943 Wilson, Thomas, of Hayton, husbandman 40
5326605 2453027 2453027 defendant Walker John husbandman 622943 622943 Walker, John, of Hayton, husbandman 41
5326606 2453027 2453027 defendant Baker John, junior husbandman 622943 622943 Baker, John, junior, of Hayton, husbandman 42
5326607 2453027 2453027 defendant Clerk John husbandman 622943 622943 Clerk, John, of Hayton, husbandman 43

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);