names

45 rows where place_id = 597819

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3629979 1904228 1904228 defendant Crabtre John sherman 597819 597819 Crabtre, John, of Warley, sherman 1
3663567 1914534 1914534 defendant Whyte John husbandman 597819 597819 Whyte, John, of Warley, husbandman 0
3665522 1915168 1915168 defendant Lougbothom Richard yeoman 597819 597819 Lougbothom, Richard, of Warley, yeoman 2
3691824 1923603 1923603 defendant Cottrell Thomas yeoman 597819 597819 Cottrell, Thomas, of Warley, yeoman 0
3695080 1924673 1924673 defendant Whyte John   597819 597819 Whyte, John, of Warley, spoke hewer 0
3750780 1942169 1942169 plaintiff Mawde John   597819 597819 Mawde, John, of Warley 0
3750781 1942169 1942169 defendant Crabtre John (legal representative) 597819 597819 Crabtre, John, of Warley, butcher, executors of 0
3757089 1944199 1944199 defendant Crowder John clothman 597819 597819 Crowder, John, of Warley, clothman 0
3757090 1944199 1944199 defendant Crowder William clothman 597819 597819 Crowder, William, of Warley, clothman 1
3776524 1950410 1950410 defendant Spurer Edward beer brewer 597819 597819 Spurer, Edward, of Warley, beer brewer 1
3803147 1958887 1958887 defendant Longbothom Richard yeoman 597819 597819 Longbothom, Richard, of Warley, yeoman 0
3805979 1959806 1959806 plaintiff Tyrrell John esq 597819 597819 Tyrrell, John, of Warley, esq 0
3805984 1959807 1959807 plaintiff Tyrrell John esq 597819 597819 Tyrrell, John, of Warley, esq 0
3806649 1959975 1959975 defendant Hadley William yeoman 597819 597819 Hadley, William, of Warley, yeoman 3
3817306 1963323 1963323 defendant Witwang Nicholas sherman 597819 597819 Witwang, Nicholas, of Warley, sherman 4
3817584 1963407 1963407 defendant Beamount John yeoman 597819 597819 Beamount, John, of Warley, yeoman 0
3824226 1965456 1965456 plaintiff Hypkys John husbandman 597819 597819 Hypkys, John, of Warley, husbandman 2
3824230 1965456 1965456 defendant Hadley William yeoman 597819 597819 Hadley, William, of Warley, yeoman 3
3832695 1968152 1968152 defendant Whyte Philip yeoman 597819 597819 Whyte, Philip, of Warley, yeoman 2
3900803 1990499 1990499 defendant Warley George gent 597819 597819 Warley, George, of Warley, gent 0
3940158 2003726 2003726 defendant Deyn Gilbert yeoman 597819 597819 Deyn, Gilbert, of Warley, yeoman 0
3941957 2004320 2004320 defendant Mawde Elizabeth widow 597819 597819 Mawde, Elizabeth, of Warley, widow 0
3941958 2004320 2004320 defendant Mawde Edward clothier 597819 597819 Mawde, Edward, of Warley, clothier 1
3967141 2013134 2013134 defendant Russon William dryver or drover 597819 597819 Russon, William, of Warley, dryver or drover 0
3976838 2016470 2016470 defendant Midgeley Richard clothier 597819 597819 Midgeley, Richard, of Warley, clothier 2
4080700 2053407 2053407 defendant Murgatroyde Edmund yeoman 597819 597819 Murgatroyde, Edmund, of Warley, yeoman 0
4107214 2062876 2062876 defendant Hopkys George nailer 597819 597819 Hopkys, George, of Warley, or of Wednesbury, nailer 1
4164280 2083028 2083028 defendant Longbothome Edward yeoman 597819 597819 Longbothome, Edward, of Warley, yeoman 2
4169565 2084862 2084862 defendant Whyte John yeoman 597819 597819 Whyte, John, of Warley, yeoman 0
4169566 2084862 2084862 defendant White Thomas yeoman 597819 597819 White, Thomas, of Warley, yeoman 1
4169567 2084862 2084862 defendant Hipkys Nicholas nailer 597819 597819 Hipkys, Nicholas, of Warley, nailer 2
4169571 2084864 2084864 defendant White John yeoman 597819 597819 White, John, of Warley, yeoman 0
4169573 2084864 2084864 defendant Hopkys Nicholas nailer 597819 597819 Hopkys, Nicholas, of Warley, nailer 2
4388392 2160752 2160752 defendant Hanmer David gent 597819 597819 Hanmer, David, of Warley, gent 0
4395199 2162983 2162983 defendant Mawde Richard yeoman 597819 597819 Mawde, Richard, of Warley, yeoman 1
4667838 2255645 2255645 defendant Haldeworth John husbandman 597819 597819 Haldeworth, John, of Warley, husbandman 3
4667839 2255645 2255645 defendant Maude John husbandman 597819 597819 Maude, John, of Warley, husbandman 4
5308598 2447605 2447605 plaintiff Shawe Richard   597819 597819 Shawe, Richard, of Warley 0
5308600 2447606 2447606 plaintiff Shawe Richard   597819 597819 Shawe, Richard, of Warley 0
5308602 2447607 2447607 plaintiff Shawe Richard   597819 597819 Shawe, Richard, of Warley 0
5317876 2450432 2450432 defendant Faux Thomas saddler 597819 597819 Faux, Thomas, of Warley, saddler 3
5352914 2460998 2460998 defendant Warward John wheeler 597819 597819 Warward, John, of Warley, wheeler 2
5451427 2490301 2490301 defendant Shagh Christopher yeoman 597819 597819 Shagh, Christopher, of Warley, yeoman 1
5463446 2493976 2493976 defendant Shawe Christopher yeoman 597819 597819 Shawe, Christopher, of Warley, yeoman 1
5525358 2512520 2512520 defendant Brokysbank John yeoman 597819 597819 Brokysbank, John, of Warley, yeoman 1

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