names

31 rows where place_id = 626805

✎ 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
3772402 1949056 1949056 defendant Colle William chaplain 626805 626805 Colle, William, of Shepey, chaplain 1
3786786 1953664 1953664 defendant Fawkener William husbandman 626805 626805 Fawkener, William, of Shepey, husbandman 0
4444262 2183191 2183191 defendant Carter John   626805 626805 Carter, John, of Shepey, son of Geoffrey 1
4544278 2214125 2214125 defendant Kyng John chaplain 626805 626805 Kyng, John, of Shepey, chaplain 2
4544279 2214125 2214125 defendant Flaundres John   626805 626805 Flaundres, John, of Shepey 3
4544280 2214125 2214125 defendant Orme William   626805 626805 Orme, William, of Shepey 4
4554716 2217400 2217400 defendant Kyng John chaplain 626805 626805 Kyng, John, of Shepey, chaplain 2
4554717 2217400 2217400 defendant Flaundres John   626805 626805 Flaundres, John, of Shepey 3
4554718 2217400 2217400 defendant Orme William   626805 626805 Orme, William, of Shepey 4
4579054 2224928 2224928 defendant Warde Nicholas chaplain 626805 626805 Warde, Nicholas, of Shepey, chaplain 0
4671735 2256804 2256804 defendant Holten William husbandman 626805 626805 Holten, William, of Shepey, husbandman 0
4671736 2256804 2256804 defendant Sedmanton William husbandman 626805 626805 Sedmanton, William, of Shepey, husbandman 1
4675781 2258033 2258033 defendant Flaundres Margaret widow & formerly wife of John Flaundres 626805 626805 Flaundres, Margaret, of Shepey, widow & formerly wife of John Flaundres 0
4711226 2268862 2268862 defendant Toky John husbandman 626805 626805 Toky, John, of Shepey, husbandman 0
4719252 2271367 2271367 defendant Merlyn William weaver 626805 626805 Merlyn, William, of Shepey, weaver 1
4756460 2282388 2282388 plaintiff Beneyt William   626805 626805 Beneyt, William, of Shepey 0
4777085 2288815 2288815 defendant Flaundres John wingleman 626805 626805 Flaundres, John, of Shepey, wingleman 1
4777086 2288815 2288815 defendant Smyth Thomas clerk 626805 626805 Smyth, Thomas, of Shepey, clerk 2
4778450 2289239 2289239 plaintiff Beneyt William   626805 626805 Beneyt, William, of Shepey 0
4786238 2291738 2291738 defendant Taillour Richard husbandman 626805 626805 Taillour, Richard, of Shepey, husbandman 1
4936998 2337946 2337946 defendant Tokye Richard husbandman 626805 626805 Tokye, Richard, of Shepey, husbandman 0
4942181 2339542 2339542 defendant Whithull Richard gent 626805 626805 Whithull, Richard, of Shepey, gent 0
4967815 2347317 2347317 defendant Whithill Richard gent 626805 626805 Whithill, Richard, of Shepey, gent 0
4969681 2347878 2347878 defendant Benet William gent 626805 626805 Benet, William, of Shepey, gent 0
5290478 2442220 2442220 defendant atte Hyde John husbandman 626805 626805 atte Hyde, John, of Shepey, husbandman 0
5290482 2442221 2442221 defendant atte Hyde John husbandman 626805 626805 atte Hyde, John, of Shepey, husbandman 0
5290488 2442222 2442222 defendant atte Hyde John husbandman 626805 626805 together with atte Hyde, John, of Shepey, husbandman 2
5388711 2471826 2471826 defendant Toky Thomas chaplain 626805 626805 Toky, Thomas, of Shepey, chaplain 0
5388712 2471826 2471826 defendant Toky John husbandman 626805 626805 Toky, John, of Shepey, husbandman 1
5413938 2479099 2479099 defendant Malpas Robert mercer 626805 626805 Malpas, Robert, of Shepey, mercer 0
5562509 2523634 2523634 defendant Pashley Clement husbandman 626805 626805 Pashley, Clement, of Shepey, husbandman 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);