names

43 rows where place_id = 758298

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4452870 2185908 2185908 defendant Fraunceys Robert   758298 758298 Fraunceys, Robert, of Derbyshire 5
4453144 2185990 2185990 defendant Cruson Roger   758298 758298 Cruson, Roger, of Derbyshire, knight 0
4453328 2186048 2186048 defendant Fraunceys Robert   758298 758298 Fraunceys, Robert, of Derbyshire 1
4453333 2186049 2186049 defendant Fraunceys Robert   758298 758298 Fraunceys, Robert, of Derbyshire 1
4454287 2186362 2186362 defendant Chesham John   758298 758298 Chesham, John, of Derbyshire 0
4474657 2192736 2192736 defendant Broun Adam brother of John 758298 758298 Broun, Adam, of Derbyshire, brother of John 1
4477715 2193696 2193696 defendant Balle John   758298 758298 Balle, John, of Derbyshire 4
4489262 2197362 2197362 defendant Sole Robert   758298 758298 Sole, Robert, of Derbyshire 0
4504964 2202094 2202094 defendant Langford Nicholas   758298 758298 Langford, Nicholas, of Derbyshire, knight 1
4515833 2205373 2205373 defendant Mountgomery Bartholomew   758298 758298 Mountgomery, Bartholomew, of Derbyshire 1
4534341 2211006 2211006 defendant Cryche William   758298 758298 Cryche, William, of Derbyshire 0
4557325 2218230 2218230 defendant Kynder Thomas   758298 758298 Kynder, Thomas, of Derbyshire 0
4557330 2218231 2218231 defendant Kynder Thomas   758298 758298 Kynder, Thomas, of Derbyshire 0
4558634 2218654 2218654 defendant Vernon Fulk esq 758298 758298 Vernon, Fulk, of Derbyshire, esq 0
4573150 2223135 2223135 defendant Ripton John   758298 758298 Ripton, John, of Derbyshire 0
4573152 2223136 2223136 defendant Ripton John   758298 758298 Ripton, John, of Derbyshire 0
4573154 2223137 2223137 defendant Rypton John   758298 758298 Rypton, John, of Derbyshire 0
4609100 2233950 2233950 defendant Heuster John merchant 758298 758298 Heuster, John, of Derbyshire, merchant 0
4617371 2236446 2236446 defendant Stranlee John   758298 758298 Stranlee, John, of Derbyshire, knight 5
4617377 2236447 2236447 defendant Fritwell Richard   758298 758298 Fritwell, Richard, of Derbyshire 4
4625606 2238968 2238968 defendant Stranle Hugh esq 758298 758298 Stranle, Hugh, of Derbyshire, esq 0
4625610 2238969 2238969 defendant Straule Hugh esq 758298 758298 Straule, Hugh, of Derbyshire, esq 0
4642668 2243971 2243971 defendant Fynderne John   758298 758298 Fynderne, John, of Derbyshire 0
4650100 2246046 2246046 defendant Irland John esq 758298 758298 Irland, John, of Derbyshire, esq 2
4650198 2246080 2246080 defendant Fynderne John de   758298 758298 Fynderne, John de, of Derbyshire 0
4665576 2250706 2250706 defendant Herdewyk Roger gent 758298 758298 Herdewyk, Roger, of Derbyshire, gent 0
4705144 2266979 2266979 defendant Mountgomery Nicholas, junior   758298 758298 Mountgomery, Nicholas, junior, of Derbyshire, knight 1
4751869 2281040 2281040 defendant Kneveton Henry esq 758298 758298 Kneveton, Henry, of Derbyshire, esq 0
4783529 2290865 2290865 defendant de Fyndern John   758298 758298 de Fyndern, John, of Derbyshire, esq, administrators of 0
4820547 2302496 2302496 defendant Astleye Thomas esq 758298 758298 Astleye, Thomas, of Derbyshire, esq 0
4881450 2321100 2321100 defendant Mountgomery Nicholas   758298 758298 Mountgomery, Nicholas, of Derbyshire, knight 0
4986995 2353053 2353053 defendant Ireton Richard gent 758298 758298 Ireton, Richard, of Derbyshire, gent 1
4997740 2356179 2356179 defendant Bagshawe Benedict   758298 758298 Bagshawe, Benedict, of Derbyshire 0
5137995 2397620 2397620 defendant Tebalde Thomas husbandman 758298 758298 Tebalde, Thomas, of Derbyshire, husbandman 2
5387304 2471440 2471440 defendant Parker William husbandman 758298 758298 Parker, William, of Derbyshire, husbandman 0
5387377 2471459 2471459 defendant Maryot William husbandman 758298 758298 Maryot, William, of Derbyshire, husbandman 5
5394176 2473395 2473395 plaintiff Walker Richard (legal representative) 758298 758298 Walker, Richard, of Derbyshire, clerk, administrator of 0
5400177 2475123 2475123 defendant Walker Richard (legal representative) 758298 758298 Walker, Richard, of Derbyshire, clerk, administrator of 0
5407312 2477155 2477155 plaintiff Walker Richard (legal representative) 758298 758298 Walker, Richard, of Derbyshire, clerk, administrator of 0
5411379 2478362 2478362 defendant Blak_ Thomas husbandman 758298 758298 Blak_, Thomas, of Derbyshire, husbandman 0
5420550 2481070 2481070 plaintiff Walker Richard (legal representative) 758298 758298 Walker, Richard, of Derbyshire, clerk, administrator of 0
5439374 2486712 2486712 plaintiff Walker Richard (legal representative) 758298 758298 Walker, Richard, of Derbyshire, clerk, administrator of 0
5451932 2490460 2490460 defendant Leche Philip esq 758298 758298 Leche, Philip, of Derbyshire, esq 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);