names

31 rows where place_id = 639829

✎ 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
3851207 1973973 1973973 defendant Halman Robert tailor 639829 639829 Halman, Robert, of Narburgh, tailor 0
3882186 1984300 1984300 plaintiff Stortwayte alias Straytwayte William clerk 639829 639829 Stortwayte alias Straytwayte, William, of Narburgh, clerk 0
3947133 2006066 2006066 plaintiff Chune John   639829 639829 Chune, John, of Narburgh, clerk, administrators of 0
4439688 2181683 2181683 defendant Batesford William   639829 639829 Batesford, William, of Narburgh 0
4506029 2202398 2202398 defendant Bonde Thomas   639829 639829 Bonde, Thomas, of Narburgh 0
4607364 2233412 2233412 defendant Reve Walter   639829 639829 Reve, Walter, of Narburgh 1
4629245 2240081 2240081 defendant Aleyn William   639829 639829 Aleyn, William, of Narburgh 0
4709444 2268309 2268309 defendant Adekyn Richard   639829 639829 Adekyn, Richard, of Narburgh, wool man 0
4731620 2275082 2275082 defendant atte Yate Adam tailor 639829 639829 atte Yate, Adam, of Narburgh, tailor 0
4749046 2280204 2280204 defendant atte Yates Adam yeoman 639829 639829 atte Yates, Adam, of Narburgh, yeoman 0
4754680 2281846 2281846 defendant Simond John   639829 639829 Simond, John, of Narburgh 1
4763299 2284509 2284509 defendant Shorthorp Richard yeoman 639829 639829 Shorthorp, Richard, of Narburgh, yeoman 3
4792990 2293898 2293898 plaintiff Narburgh William, junior   639829 639829 Narburgh, William, junior, of Narburgh 0
4828248 2304878 2304878 defendant Harleston Thomas clerk & vicar 639829 639829 Harleston, Thomas, of Narburgh, clerk & vicar 1
4880637 2320852 2320852 defendant Merton John husbandman 639829 639829 Merton, John, of Narburgh, husbandman 3
4913648 2330763 2330763 defendant Hobshoote Richard husbandman 639829 639829 Hobshoote, Richard, of Narburgh, husbandman 0
4913650 2330764 2330764 defendant Holeshorte Richard husbandman 639829 639829 Holeshorte, Richard, of Narburgh, husbandman 0
4945712 2340641 2340641 defendant Narburgh William gent 639829 639829 Narburgh, William, of Narburgh, gent 0
4966962 2347047 2347047 defendant Martyn John husbandman 639829 639829 Martyn, John, of Narburgh, husbandman 0
5030270 2365721 2365721 defendant Bell Thomas yeoman 639829 639829 Bell, Thomas, of Narburgh, yeoman 0
5030271 2365721 2365721 defendant Cok Robert smith 639829 639829 Cok, Robert, of Narburgh, smith 1
5211205 2419006 2419006 defendant Den James clerk 639829 639829 Den, James, of Narburgh, clerk 2
5339413 2456897 2456897 defendant Marham Robert husbandman 639829 639829 Marham, Robert, of Narburgh, husbandman 2
5342010 2457690 2457690 defendant Beteson alias Wryght Robert husbandman 639829 639829 Beteson alias Wryght, Robert, of Narburgh, husbandman 1
5482405 2499678 2499678 defendant Mylles Roger miller 639829 639829 Mylles, Roger, of Narburgh, miller 2
5495434 2503534 2503534 defendant Milles Roger miller 639829 639829 Milles, Roger, of Narburgh, miller 2
5559820 2522830 2522830 defendant Mandall Thomas husbandman 639829 639829 Mandall, Thomas, of Narburgh, husbandman 0
5571070 2526099 2526099 defendant Shuldham Thomas gent 639829 639829 Shuldham, Thomas, of Narburgh, gent 2
5601696 2535431 2535431 defendant Shuldham Thomas gent 639829 639829 Shuldham, Thomas, of Narburgh, gent 0
5601697 2535431 2535431 defendant Juston John husbandman 639829 639829 Juston, John, of Narburgh, husbandman 1
5625821 2552024 2552024 defendant Nooloth Robert husbandman 639829 639829 Nooloth, Robert, of Narburgh, husbandman 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);