names

47 rows where place_id = 590487

✎ 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
3594639 1865952 1865952 defendant Hastynges John   590487 590487 Hastynges, John, of Hemmyngburgh, knight 1
3601383 1868095 1868095 defendant Hastyng Robert esq 590487 590487 (Hastyng, Robert, of Hemmyngburgh, esq 1
3604793 1869163 1869163 defendant Thomson Robert yeoman 590487 590487 Thomson, Robert, of Hemmyngburgh, yeoman 2
3613268 1871802 1871802 defendant Greystok William gent 590487 590487 Greystok, William, of Hemmyngburgh, gent 1
3829560 1967135 1967135 defendant Daull William barker 590487 590487 Daull, William, of Hemmyngburgh, barker 3
4428148 2173635 2173635 defendant Paterlage John   590487 590487 Paterlage, John, of Hemmyngburgh, son of John 0
4459836 2188130 2188130 defendant Henle John carpenter 590487 590487 (Henle, John, of Hemmyngburgh, carpenter 1
4683830 2260554 2260554 plaintiff Pikeryng Richard (legal representative) 590487 590487 Pikeryng, Richard, of Hemmyngburgh, parson, executors of 0
4683840 2260554 2260554 defendant Ty-- Robert husbandman 590487 590487 Ty--, Robert, of Hemmyngburgh, husbandman 5
4683841 2260554 2260554 defendant Grewe John husbandman 590487 590487 Grewe, John, of Hemmyngburgh, husbandman 6
4815038 2300814 2300814 defendant Spofford Robert butcher 590487 590487 Spofford, Robert, of Hemmyngburgh, butcher 0
4859743 2314413 2314413 defendant Spofford Robert husbandman 590487 590487 Spofford, Robert, of Hemmyngburgh, husbandman 0
4859745 2314413 2314413 defendant Tynde Robert husbandman 590487 590487 Tynde, Robert, of Hemmyngburgh, husbandman 2
4881828 2321215 2321215 defendant Lacy John yeoman 590487 590487 Lacy, John, of Hemmyngburgh, yeoman 1
4883045 2321620 2321620 defendant Spofforth Robert butcher 590487 590487 Spofforth, Robert, of Hemmyngburgh, butcher 2
4888725 2323263 2323263 defendant Spofforth Robert butcher 590487 590487 Spofforth, Robert, of Hemmyngburgh, butcher 2
4932860 2336664 2336664 defendant Lasty John yeoman 590487 590487 Lasty, John, of Hemmyngburgh, yeoman 0
4943746 2340011 2340011 defendant Broun Robert husbandman 590487 590487 Broun, Robert, of Hemmyngburgh, husbandman 0
4998747 2356513 2356513 defendant Spofforth Robert butcher 590487 590487 Spofforth, Robert, of Hemmyngburgh, butcher 1
5055423 2373208 2373208 defendant Glover William pulter 590487 590487 Glover, William, of Hemmyngburgh, pulter 0
5080072 2380523 2380523 defendant Godesall William husbandman 590487 590487 Godesall, William, of Hemmyngburgh, husbandman 0
5106730 2388396 2388396 defendant Jakson William yeoman 590487 590487 Jakson, William, of Hemmyngburgh, yeoman 0
5106731 2388396 2388396 defendant Osbern John yeoman 590487 590487 Osbern, John, of Hemmyngburgh, yeoman 1
5106733 2388396 2388396 defendant West James yeoman 590487 590487 West, James, of Hemmyngburgh, yeoman 3
5151155 2401478 2401478 defendant Ryffyn William husbandman 590487 590487 Ryffyn, William, of Hemmyngburgh, husbandman 0
5152828 2401966 2401966 defendant Thomasson William husbandman 590487 590487 Thomasson, William, of Hemmyngburgh, husbandman 2
5279248 2439031 2439031 defendant Ryffan Thomas butcher 590487 590487 Ryffan, Thomas, of Hemmyngburgh, butcher 0
5290911 2442345 2442345 defendant Bedell Thomas yeoman 590487 590487 Bedell, Thomas, of Hemmyngburgh, yeoman 1
5383809 2470455 2470455 plaintiff Hamylton John chaplain 590487 590487 Hamylton, John, of Hemmyngburgh, chaplain 1
5383810 2470455 2470455 defendant Goldesburgh William yeoman 590487 590487 Goldesburgh, William, of Hemmyngburgh, yeoman 0
5384353 2470612 2470612 defendant Thomson Robert husbandman 590487 590487 Thomson, Robert, of Hemmyngburgh, husbandman 2
5389292 2471982 2471982 defendant Goldisburgh William yeoman 590487 590487 Goldisburgh, William, of Hemmyngburgh, yeoman 0
5396156 2473986 2473986 defendant Thomson Robert husbandman 590487 590487 Thomson, Robert, of Hemmyngburgh, husbandman 2
5424603 2482331 2482331 defendant Huton William (legal representative) 590487 590487 Huton, William, of Hemmyngburgh, executors of 2
5443371 2487934 2487934 defendant Huton William (legal representative) 590487 590487 Huton, William, of Hemmyngburgh, executors of 2
5456126 2491749 2491749 defendant Huton William (legal representative) 590487 590487 Huton, William, of Hemmyngburgh, executors of 2
5501694 2505460 2505460 defendant Peyrson Roger chapman 590487 590487 Peyrson, Roger, of Hemmyngburgh, chapman 0
5504564 2506349 2506349 defendant Ratclyff William clerk 590487 590487 Ratclyff, William, of Hemmyngburgh, clerk 0
5504565 2506349 2506349 defendant Pereson Roger chapman 590487 590487 Pereson, Roger, of Hemmyngburgh, chapman 1
5571400 2526189 2526189 defendant Salnard Thomas tanner 590487 590487 Salnard, Thomas, of Hemmyngburgh, tanner 3
5571402 2526189 2526189 defendant Robynson Alexander husbandman 590487 590487 Robynson, Alexander, of Hemmyngburgh, husbandman 5
5571403 2526189 2526189 defendant Gregson Richard husbandman 590487 590487 Gregson, Richard, of Hemmyngburgh, husbandman 6
5573589 2526840 2526840 defendant Babthorp Thomas clerk 590487 590487 Babthorp, Thomas, of Hemmyngburgh, clerk 0
5574384 2527074 2527074 defendant Taillour John shoemaker 590487 590487 Taillour, John, of Hemmyngburgh, shoemaker 0
5574386 2527074 2527074 defendant Robynson Alexander husbandman 590487 590487 Robynson, Alexander, of Hemmyngburgh, husbandman 2
5612706 2547721 2547721 defendant Norton John de   590487 590487 Norton, John de, of Hemmyngburgh 0
5612707 2547721 2547721 defendant Pas William   590487 590487 Pas, William, of Hemmyngburgh 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);