names

37 rows where place_id = 653561

✎ 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
3929003 2000038 2000038 plaintiff Broughton Edmund   653561 653561 Broughton, Edmund, of Lichfield, Staffs 0
4000434 2024923 2024923 defendant Stanton Edmund gent 653561 653561 Stanton, Edmund, of Lichfield, Staffs, gent 3
4083546 2054389 2054389 defendant Slyn John chapman 653561 653561 Slyn, John, of Lichfield, Staffs, chapman 0
4084394 2054691 2054691 defendant Mastergent Richard mercer 653561 653561 Mastergent, Richard, of Lichfield, Staffs, mercer 0
4089459 2056516 2056516 defendant Mastergent Richard mercer 653561 653561 Mastergent, Richard, of Lichfield, Staffs, mercer 0
4098965 2059954 2059954 defendant Mastergent Richard mercer 653561 653561 Mastergent, Richard, of Lichfield, Staffs, mercer 0
4103684 2061595 2061595 defendant Eyre Philip gent 653561 653561 Eyre, Philip, of Lichfield, Staffs, gent 1
4106909 2062763 2062763 defendant Fowler Francis gent 653561 653561 Fowler, Francis, of Lichfield, Staffs, gent 3
4108721 2063374 2063374 defendant Mastergent Richard mercer 653561 653561 Mastergent, Richard, of Lichfield, Staffs, mercer 0
4112901 2064879 2064879 defendant Logen Thomas yeoman 653561 653561 Logen, Thomas, of Lichfield, Staffs, yeoman 0
4113068 2064940 2064940 defendant Mastergent Richard mercer 653561 653561 Mastergent, Richard, of Lichfield, Staffs, mercer 0
4117803 2066658 2066658 defendant Mastergent Richard chapman 653561 653561 Mastergent, Richard, of Lichfield, Staffs, chapman 0
4135247 2072925 2072925 defendant Bagshawe George innholder 653561 653561 Bagshawe, George, of Lichfield, Staffs, innholder 0
4159282 2081317 2081317 defendant Bagshawe George innholder 653561 653561 Bagshawe, George, of Lichfield, Staffs, innholder 0
4197047 2094520 2094520 defendant Hyll Gregory blacksmith 653561 653561 Hyll, Gregory, of Lichfield, Staffs, blacksmith 0
4293980 2127921 2127921 defendant Allen Anne widow 653561 653561 Allen, Anne, of Lichfield, Staffs, widow 2
4319365 2136881 2136881 defendant Eyre Thomas vintner 653561 653561 Eyre, Thomas, of Lichfield, Staffs, vintner 0
4356337 2149443 2149443 defendant Babington Zachary esq 653561 653561 Babington, Zachary, of Lichfield, Staffs, esq 0
4530534 2209847 2209847 defendant Laurence Robert   653561 653561 Laurence, Robert, of Lichfield, Staffs 1
4530537 2209848 2209848 defendant Laurence Robert   653561 653561 Laurence, Robert, of Lichfield, Staffs 1
4701620 2265899 2265899 defendant Rouse John yeoman 653561 653561 Rouse, John, of Lichfield, Staffs, yeoman 3
4704164 2266680 2266680 defendant Stretton Ralph merchant 653561 653561 Stretton, Ralph, of Lichfield, Staffs, merchant 0
4755842 2282207 2282207 defendant Benbowe William draper 653561 653561 Benbowe, William, of Lichfield, Staffs, draper 4
4757604 2282756 2282756 defendant Horner John husbandman 653561 653561 Horner, John, of Lichfield, Staffs, husbandman 2
4766408 2285486 2285486 defendant Hurst Robert fishmonger 653561 653561 Hurst, Robert, of Lichfield, Staffs, fishmonger 0
4766964 2285656 2285656 defendant Walsham Andrew chapman 653561 653561 Walsham, Andrew, of Lichfield, Staffs, chapman 0
4822509 2303114 2303114 defendant Gryffyth William yeoman 653561 653561 Gryffyth, William, of Lichfield, Staffs, yeoman 1
4848984 2311148 2311148 defendant Brereley Roger gent 653561 653561 Brereley, Roger, of Lichfield, Staffs, gent 1
4848987 2311149 2311149 defendant Brereley Roger gent 653561 653561 Brereley, Roger, of Lichfield, Staffs, gent 1
5046623 2370619 2370619 defendant Verney John   653561 653561 Verney, John, of Lichfield, Staffs, Dean of the Cathedral church 0
5177791 2409207 2409207 defendant Strethay John gent 653561 653561 Strethay, John, of Lichfield, Staffs, gent 3
5196721 2414790 2414790 defendant Pery Sampson hosier 653561 653561 Pery, Sampson, of Lichfield, Staffs, hosier 1
5196727 2414791 2414791 defendant Pery Sampson hosier 653561 653561 Pery, Sampson, of Lichfield, Staffs, hosier 1
5198104 2415191 2415191 defendant Stykbuk Thomas chaplain 653561 653561 Stykbuk, Thomas, of Lichfield, Staffs, chaplain 0
5198863 2415420 2415420 defendant Haywode Thomas   653561 653561 Haywode, Thomas, of Lichfield, Staffs, dean of the cathedral church of St Cedde 0
5208619 2418246 2418246 defendant Nobull Richard chapman 653561 653561 Nobull, Richard, of Lichfield, Staffs, chapman 0
5413499 2478963 2478963 defendant Swyfte Thomas mercer 653561 653561 Swyfte, Thomas, of Lichfield, Staffs, mercer 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);