names

25 rows where place_id = 621614

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3742476 1939518 1939518 plaintiff Tuston Nicholas   621614 621614 Tuston, Nicholas, of Northyham 0
3838597 1969999 1969999 plaintiff Tuston Nicholas gent 621614 621614 Tuston, Nicholas, of Northyham, gent 0
3909209 1993375 1993375 plaintiff Sharp Richard   621614 621614 Sharp, Richard, of Northyham 0
3910785 1993928 1993928 plaintiff Sharp Richard   621614 621614 Sharp, Richard, of Northyham 1
4232343 2106821 2106821 defendant Brigden Thomas yeoman 621614 621614 Brigden, Thomas, of Northyham, yeoman 0
4311096 2134031 2134031 defendant Sharpe Giles husbandman 621614 621614 Sharpe, Giles, of Northyham, husbandman 0
4354701 2148875 2148875 defendant Sharpe James gent 621614 621614 Sharpe, James, of Northyham, gent 0
4366076 2152909 2152909 defendant Robynson William yeoman 621614 621614 Robynson, William, of Northyham, yeoman 0
4473851 2192472 2192472 defendant Garton Philip   621614 621614 Garton, Philip, of Northyham, parson 0
4483934 2195667 2195667 defendant Garton Philip   621614 621614 Garton, Philip, of Northyham, parson 0
4620694 2237458 2237458 defendant Aston Robert   621614 621614 Aston, Robert, of Northyham 0
4677190 2258483 2258483 defendant Watte Richard weaver 621614 621614 Watte, Richard, of Northyham, weaver 0
4683004 2260298 2260298 defendant Croulond John   621614 621614 Croulond, John, of Northyham, parson 0
4738037 2276998 2276998 defendant Coumbere John butcher 621614 621614 Coumbere, John, of Northyham, butcher 0
4970473 2348115 2348115 defendant Okman Thomas husbandman 621614 621614 Okman, Thomas, of Northyham, husbandman 0
4970714 2348181 2348181 defendant Bate William husbandman 621614 621614 Bate, William, of Northyham, husbandman 0
4970715 2348181 2348181 defendant Porter John husbandman 621614 621614 Porter, John, of Northyham, husbandman 1
5088604 2383042 2383042 defendant Godewyn Thomas tailor 621614 621614 Godewyn, Thomas, of Northyham, tailor 0
5217634 2420890 2420890 defendant Pertryche John husbandman 621614 621614 Pertryche, John, of Northyham, husbandman 31
5411581 2478419 2478419 defendant Billyngton Thomas yeoman 621614 621614 Billyngton, Thomas, of Northyham, yeoman 0
5425904 2482708 2482708 defendant Billyngton Thomas yeoman 621614 621614 Billyngton, Thomas, of Northyham, yeoman 0
5425906 2482709 2482709 defendant Billyngton Thomas yeoman 621614 621614 Billyngton, Thomas, of Northyham, yeoman 0
5425908 2482710 2482710 defendant Billyngton Thomas yeoman 621614 621614 Billyngton, Thomas, of Northyham, yeoman 0
5502736 2505771 2505771 defendant Ryddesdale Walter husbandman 621614 621614 Ryddesdale, Walter, of Northyham, husbandman 1
5517097 2510182 2510182 defendant Reddesdale Walter yeoman 621614 621614 Reddesdale, Walter, of Northyham, yeoman 2

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