names

39 rows where place_id = 589227

✎ 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
3596952 1866677 1866677 defendant Waltam William husbandman 589227 589227 Waltam, William, of Scalby, husbandman 7
3886460 1985726 1985726 defendant Hynderwell Robert husbandman 589227 589227 Hynderwell, Robert, of Scalby, husbandman 0
4459927 2188162 2188162 plaintiff Scot William   589227 589227 Scot, William, of Scalby 0
4487475 2196798 2196798 plaintiff Smyth John   589227 589227 Smyth, John, of Scalby 0
4487476 2196798 2196798 defendant Trotte Thomas   589227 589227 Trotte, Thomas, of Scalby 0
4489376 2197397 2197397 defendant Proudefelawe Roger   589227 589227 Proudefelawe, Roger, of Scalby 0
4489859 2197536 2197536 plaintiff Trotte Thomas   589227 589227 Trotte, Thomas, of Scalby 0
4489860 2197536 2197536 defendant Smyth John   589227 589227 Smyth, John, of Scalby 0
4489861 2197536 2197536 defendant Smyth John   589227 589227 Smyth, John, of Scalby, servant of John 1
4498583 2200199 2200199 defendant Dalby Robert   589227 589227 Dalby, Robert, of Scalby, vicar 0
4514598 2204984 2204984 defendant Mannyng Thomas   589227 589227 Mannyng, Thomas, of Scalby 2
4515712 2205339 2205339 plaintiff Clerk John   589227 589227 Clerk, John, of Scalby 0
4515713 2205339 2205339 defendant Taskar William   589227 589227 Taskar, William, of Scalby 0
4522273 2207310 2207310 defendant Mannyng William   589227 589227 Mannyng, William, of Scalby 0
4540609 2212960 2212960 defendant Milner Richard   589227 589227 Milner, Richard, of Scalby 0
4571237 2222574 2222574 defendant Prowede Felawe Roger   589227 589227 Prowede Felawe, Roger, of Scalby 1
4602809 2232092 2232092 defendant Clerk William   589227 589227 Clerk, William, of Scalby 2
4605727 2232908 2232908 defendant atte Vicars Richard   589227 589227 atte Vicars, Richard, of Scalby 0
4605728 2232908 2232908 defendant Baxster John   589227 589227 Baxster, John, of Scalby 1
4626921 2239366 2239366 defendant Clerk John   589227 589227 Clerk, John, of Scalby 0
4636214 2242159 2242159 defendant Baxter John   589227 589227 Baxter, John, of Scalby 0
4637627 2242552 2242552 defendant Watson William   589227 589227 Watson, William, of Scalby 0
4638028 2242656 2242656 defendant Peresson Robert   589227 589227 Peresson, Robert, of Scalby 0
4659591 2248852 2248852 plaintiff de Fulthorp John   589227 589227 de Fulthorp, John, of Scalby 0
4702934 2266310 2266310 defendant Grayson Robert yeoman 589227 589227 Grayson, Robert, of Scalby, yeoman 0
4702935 2266310 2266310 defendant Forster Alexander yeoman 589227 589227 Forster, Alexander, of Scalby, yeoman 1
4705726 2267162 2267162 defendant Hegeson William chapman 589227 589227 Hegeson, William, of Scalby, chapman 1
4715273 2270109 2270109 defendant Gere William laborer 589227 589227 Gere, William, of Scalby, laborer 0
4733233 2275574 2275574 defendant Boury William husbandman 589227 589227 Boury, William, of Scalby, husbandman 2
4744412 2278888 2278888 defendant Bond Thomas shoemaker 589227 589227 Bond, Thomas, of Scalby, shoemaker 1
4846627 2310456 2310456 defendant Harwyth Thomas husbandman 589227 589227 Harwyth, Thomas, of Scalby, husbandman 2
4846628 2310456 2310456 defendant Yarwyth William husbandman 589227 589227 Yarwyth, William, of Scalby, husbandman 3
4853639 2312555 2312555 defendant Segode Herbert   589227 589227 Segode, Herbert, of Scalby, wright 0
4862344 2315231 2315231 plaintiff de Langton Robert   589227 589227 de Langton, Robert, of Scalby 0
5032103 2366261 2366261 defendant Yerwyth William gent 589227 589227 Yerwyth, William, of Scalby, gent 2
5048794 2371275 2371275 defendant Langton William yeoman 589227 589227 Langton, William, of Scalby, yeoman 0
5475029 2497515 2497515 defendant Jacson John yeoman 589227 589227 Jacson, John, of Scalby, yeoman 0
5486540 2500866 2500866 defendant Jacson John yeoman 589227 589227 Jacson, John, of Scalby, yeoman 0
5633628 2554515 2554515 defendant Smyth Thomas laborer 589227 589227 Smyth, Thomas, of Scalby, laborer 0

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