names

39 rows where place_id = 597736

✎ 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
3629656 1904129 1904129 defendant Blaknall Richard gent 597736 597736 Blaknall, Richard, of Wynge, gent 1
3894972 1988527 1988527 defendant Sharp Richard husbandman 597736 597736 Sharp, Richard, of Wynge, husbandman 0
3894973 1988527 1988527 defendant Banys Hugh husbandman 597736 597736 Banys, Hugh, of Wynge, husbandman 1
3935006 2002013 2002013 defendant Sharpe Richard yeoman 597736 597736 Sharpe, Richard, of Wynge, yeoman 0
3970288 2014204 2014204 plaintiff Darrell Francis gent 597736 597736 Darrell, Francis, of Wynge, gent 0
4082000 2053863 2053863 defendant Dormer Robert esq 597736 597736 Dormer, Robert, of Wynge, esq 0
4459538 2188037 2188037 defendant Dawes John   597736 597736 Dawes, John, of Wynge 0
4459541 2188038 2188038 defendant Dawes John   597736 597736 Dawes, John, of Wynge 0
4459572 2188047 2188047 defendant Dawes John   597736 597736 Dawes, John, of Wynge 0
4561524 2219539 2219539 defendant Queynton Thomas   597736 597736 Queynton, Thomas, of Wynge 0
4589636 2228126 2228126 defendant Welde Thomas   597736 597736 Welde, Thomas, of Wynge 3
4604113 2232455 2232455 plaintiff Ingrych John   597736 597736 Ingrych, John, of Wynge, parson 3
4663935 2250204 2250204 defendant Setle Stephen   597736 597736 Setle, Stephen, of Wynge, mason 1
4766048 2285371 2285371 defendant Skarle John clerk 597736 597736 Skarle, John, of Wynge, clerk 0
4816812 2301361 2301361 plaintiff Martyn Robert   597736 597736 Martyn, Robert, of Wynge, on his own account 0
4912389 2330377 2330377 defendant Sperlyng William husbandman 597736 597736 Sperlyng, William, of Wynge, husbandman 1
4958505 2344513 2344513 defendant Smalley Robert husbandman 597736 597736 Smalley, Robert, of Wynge, husbandman 0
4970446 2348107 2348107 defendant Daungevyle William husbandman 597736 597736 Daungevyle, William, of Wynge, husbandman 0
5076203 2379383 2379383 defendant Founteyn William yeoman 597736 597736 Founteyn, William, of Wynge, yeoman 0
5076204 2379383 2379383 defendant Adam John yeoman 597736 597736 Adam, John, of Wynge, yeoman 1
5112555 2390052 2390052 defendant Founteynes William merchant 597736 597736 Founteynes, William, of Wynge, merchant 0
5114331 2390585 2390585 defendant Sulesho Henry carpenter 597736 597736 Sulesho, Henry, of Wynge, carpenter 3
5117864 2391651 2391651 defendant Rokes Thomas yeoman 597736 597736 Rokes, Thomas, of Wynge, yeoman 1
5117867 2391652 2391652 defendant Rokes Thomas yeoman 597736 597736 Rokes, Thomas, of Wynge, yeoman 1
5235075 2425839 2425839 plaintiff Dangevyle John tailor 597736 597736 Dangevyle, John, of Wynge, tailor 0
5262634 2434059 2434059 defendant Tymson Robert clerk 597736 597736 Tymson, Robert, of Wynge, clerk 0
5281333 2439614 2439614 defendant Upton William smith 597736 597736 Upton, William, of Wynge, smith 0
5352680 2460929 2460929 plaintiff Fonteyn Nicholas   597736 597736 Fonteyn, Nicholas, of Wynge 0
5428735 2483507 2483507 plaintiff Funteyn Nicholas   597736 597736 Funteyn, Nicholas, of Wynge 0
5445983 2488685 2488685 plaintiff Funteyn Nicholas   597736 597736 Funteyn, Nicholas, of Wynge 0
5458603 2492467 2492467 plaintiff Frunteyn Nicholas   597736 597736 Frunteyn, Nicholas, of Wynge 0
5470273 2496028 2496028 plaintiff Funteyn Nicholas   597736 597736 Funteyn, Nicholas, of Wynge 0
5503128 2505890 2505890 defendant Blaknall Edward chapman 597736 597736 Blaknall, Edward, of Wynge, chapman 0
5509737 2507876 2507876 defendant Sare Richard husbandman 597736 597736 Sare, Richard, of Wynge, husbandman 0
5509739 2507876 2507876 defendant Trynge John husbandman 597736 597736 Trynge, John, of Wynge, husbandman 2
5515275 2509622 2509622 defendant Polyn Thomas husbandman 597736 597736 Polyn, Thomas, of Wynge, husbandman 1
5590726 2532074 2532074 defendant Blakenell Robert grasier 597736 597736 Blakenell, Robert, of Wynge, grasier 1
5601782 2535459 2535459 defendant Blaknall Richard yeoman 597736 597736 Blaknall, Richard, of Wynge, yeoman 1
5605517 2536607 2536607 defendant Blaknell Robert grasier 597736 597736 Blaknell, Robert, of Wynge, grasier 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);