names

48 rows where place_id = 629588

✎ 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
3789138 1954413 1954413 defendant Bakon John husbandman 629588 629588 Bakon, John, of Plumstede, husbandman 0
3819646 1964024 1964024 defendant Rygevale Richard husbandman 629588 629588 Rygevale, Richard, of Plumstede, husbandman 0
3931621 2000873 2000873 defendant Holborne John husbandman 629588 629588 Holborne, John, of Plumstede, husbandman 0
3931622 2000873 2000873 defendant Broun George husbandman 629588 629588 Broun, George, of Plumstede, husbandman 1
4435460 2175846 2175846 defendant Aiye Richard le   629588 629588 Aiye, Richard le, of Plumstede 0
4440560 2181960 2181960 defendant burgh John de   629588 629588 burgh, John de, of Plumstede 0
4503643 2201714 2201714 defendant Heygate John   629588 629588 Heygate, John, of Plumstede 0
4525666 2208328 2208328 defendant Walker Simon   629588 629588 Walker, Simon, of Plumstede 8
4533719 2210814 2210814 defendant Cheseman William   629588 629588 Cheseman, William, of Plumstede 2
4533726 2210815 2210815 defendant Cheseman William   629588 629588 Cheseman, William, of Plumstede 1
4594034 2229397 2229397 defendant Aleyn Adam   629588 629588 Aleyn, Adam, of Plumstede 3
4642350 2243883 2243883 defendant Ereth John   629588 629588 Ereth, John, of Plumstede 0
4642352 2243884 2243884 defendant Ereth John   629588 629588 Ereth, John, of Plumstede 0
4737149 2276736 2276736 defendant Wassenasshe William yeoman 629588 629588 Wassenasshe, William, of Plumstede, yeoman 1
4762848 2284363 2284363 defendant Aleyn John husbandman 629588 629588 Aleyn, John, of Plumstede, husbandman 3
4762849 2284363 2284363 defendant Aleyn Adam husbandman 629588 629588 Aleyn, Adam, of Plumstede, husbandman 4
4768268 2286044 2286044 defendant Erhithe John gent 629588 629588 Erhithe, John, of Plumstede, gent 1
4821553 2302823 2302823 defendant Erythe John gent 629588 629588 Erythe, John, of Plumstede, gent 0
4828168 2304852 2304852 defendant Marchall William husbandman 629588 629588 Marchall, William, of Plumstede, husbandman 0
4835302 2307040 2307040 defendant Copshef Simon gent 629588 629588 Copshef, Simon, of Plumstede, gent 0
4846331 2310359 2310359 defendant Marchall William husbandman 629588 629588 Marchall, William, of Plumstede, husbandman 0
4916684 2331726 2331726 defendant Gryggys John   629588 629588 Gryggys, John, of Plumstede 10
4959288 2344742 2344742 defendant Steven Thomas cordwainer 629588 629588 Steven, Thomas, of Plumstede, cordwainer 1
5026020 2364504 2364504 defendant Howelot John husbandman 629588 629588 Howelot, John, of Plumstede, husbandman 0
5039620 2368496 2368496 defendant Robert William husbandman 629588 629588 Robert, William, of Plumstede, husbandman 2
5118590 2391867 2391867 defendant Waveryng Reginald husbandman 629588 629588 Waveryng, Reginald, of Plumstede, husbandman 4
5125878 2394056 2394056 plaintiff Benet Nicholas clerk 629588 629588 Benet, Nicholas, of Plumstede, clerk 0
5144478 2399546 2399546 plaintiff Benet Nicholas clerk 629588 629588 Benet, Nicholas, of Plumstede, clerk 0
5144482 2399547 2399547 plaintiff Benet Nicholas clerk 629588 629588 Benet, Nicholas, of Plumstede, clerk 0
5144484 2399548 2399548 plaintiff Benet Nicholas clerk 629588 629588 Benet, Nicholas, of Plumstede, clerk 0
5144487 2399549 2399549 plaintiff Benet Nicholas clerk 629588 629588 Benet, Nicholas, of Plumstede, clerk 0
5159329 2403844 2403844 defendant Etewell Henry gent 629588 629588 Etewell, Henry, of Plumstede, gent 0
5161942 2404603 2404603 defendant German Robert husbandman 629588 629588 German, Robert, of Plumstede, husbandman 0
5174397 2408213 2408213 defendant Etewell Henry gent 629588 629588 Etewell, Henry, of Plumstede, gent 0
5176170 2408720 2408720 defendant German Robert husbandman 629588 629588 German, Robert, of Plumstede, husbandman 0
5179218 2409658 2409658 plaintiff Benet Nicholas clerk 629588 629588 Benet, Nicholas, of Plumstede, clerk 0
5218174 2421046 2421046 defendant Cokke John yeoman 629588 629588 Cokke, John, of Plumstede, yeoman 1
5319412 2450898 2450898 defendant Crabbe John, junior husbandman 629588 629588 Crabbe, John, junior, of Plumstede, husbandman 0
5364149 2464445 2464445 defendant atte Wode William laborer 629588 629588 atte Wode, William, of Plumstede, laborer 0
5389689 2472112 2472112 defendant Gate Richard husbandman 629588 629588 Gate, Richard, of Plumstede, husbandman 0
5389690 2472112 2472112 defendant Kynham Thomas sawyer 629588 629588 Kynham, Thomas, of Plumstede, sawyer 1
5390659 2472392 2472392 defendant London Thomas   629588 629588 London, Thomas, of Plumstede, vicar 0
5390660 2472392 2472392 defendant Cok Thomas husbandman 629588 629588 Cok, Thomas, of Plumstede, husbandman 1
5390661 2472392 2472392 defendant Dene Thomas husbandman 629588 629588 Dene, Thomas, of Plumstede, husbandman 2
5390662 2472392 2472392 defendant Cok John husbandman 629588 629588 Cok, John, of Plumstede, husbandman 3
5390663 2472392 2472392 defendant Gregge John husbandman 629588 629588 Gregge, John, of Plumstede, husbandman 4
5432033 2484549 2484549 defendant Spayne William husbandman 629588 629588 Spayne, William, of Plumstede, husbandman 0
5633056 2554341 2554341 defendant Clydero Richard esq 629588 629588 Clydero, Richard, of Plumstede, esq 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);