names

44 rows where place_id = 772207

✎ 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
4586511 2227193 2227193 defendant Roude Henry (legal representative) 772207 772207 Roude, Henry, of Cleye next the sea, executors of 2
4586512 2227193 2227193 defendant Love Ralph   772207 772207 (Love, Ralph, of Cleye next the sea 3
4630303 2240389 2240389 defendant Bulwere John   772207 772207 Bulwere, John, of Cleye next the sea 0
4698111 2264896 2264896 defendant Clerk Geoffrey clerk 772207 772207 Clerk, Geoffrey, of Cleye next the Sea, clerk 0
4733293 2275589 2275589 defendant Merlond Thomas   772207 772207 Merlond, Thomas, of Cleye next the Sea, bailiff 0
4740323 2277680 2277680 defendant Peers Thomas yeoman 772207 772207 Peers, Thomas, of Cleye next the sea, yeoman 0
4740324 2277680 2277680 defendant Pynnes John yeoman 772207 772207 Pynnes, John, of Cleye next the sea, yeoman 1
4745475 2279186 2279186 defendant Noble Richard yeoman 772207 772207 Noble, Richard, of Cleye next the sea, yeoman 2
4745476 2279186 2279186 defendant Pynnes John yeoman 772207 772207 Pynnes, John, of Cleye next the sea, yeoman 3
4745909 2279309 2279309 defendant Austyn Roger yeoman 772207 772207 Austyn, Roger, of Cleye next the sea, yeoman 0
4745910 2279309 2279309 defendant Bulwere John yeoman 772207 772207 Bulwere, John, of Cleye next the sea, yeoman 1
4749557 2280352 2280352 defendant Peris Thomas yeoman 772207 772207 Peris, Thomas, of Cleye next the sea, yeoman 0
4750319 2280571 2280571 defendant Perys Thomas yeoman 772207 772207 Perys, Thomas, of Cleye next the sea, yeoman 0
4750320 2280571 2280571 defendant Dowe Nicholas yeoman 772207 772207 Dowe, Nicholas, of Cleye next the sea, yeoman 1
4754472 2281778 2281778 defendant Whyte Robert yeoman 772207 772207 Whyte, Robert, of Cleye next the sea, yeoman 0
4763981 2284726 2284726 defendant Austyn Roger yeoman 772207 772207 Austyn, Roger, of Cleye next the sea, yeoman 5
4813788 2300423 2300423 defendant Pays Richard yeoman 772207 772207 Pays, Richard, of Cleye next the sea, yeoman 0
4813789 2300423 2300423 defendant Shenfeld William husbandman 772207 772207 Shenfeld, William, of Cleye next the sea, husbandman 1
4833726 2306557 2306557 defendant Marys John   772207 772207 Marys, John, of Cleye next the Sea, servant 1
4839305 2308219 2308219 defendant Bulwere John yeoman 772207 772207 Bulwere, John, of Cleye next the Sea, yeoman 3
4923430 2333756 2333756 defendant Pers Thomas husbandman 772207 772207 Pers, Thomas, of Cleye next the sea, husbandman 0
4924683 2334155 2334155 defendant Horn Adam merchant 772207 772207 Horn, Adam, of Cleye next the sea, merchant 1
4992418 2354618 2354618 defendant Idesson Thomas yeoman 772207 772207 Idesson, Thomas, of Cleye next the Sea, yeoman 2
5041303 2369006 2369006 defendant Gyles John yeoman 772207 772207 Gyles, John, of Cleye next the sea, yeoman 0
5132087 2395877 2395877 plaintiff Hagon Alice (legal representative) 772207 772207 Hagon, Alice, of Cleye next the Sea, executors of 0
5154884 2402588 2402588 defendant Hecker Robert yeoman 772207 772207 Hecker, Robert, of Cleye next the sea, yeoman 1
5155234 2402679 2402679 defendant Fyssh James   772207 772207 Fyssh, James, of Cleye next the sea, ship wright 1
5160920 2404297 2404297 defendant Charles John husbandman 772207 772207 Charles, John, of Cleye next the sea, husbandman 3
5170160 2407003 2407003 plaintiff Hecker Robert   772207 772207 Hecker, Robert, of Cleye next the sea 0
5178123 2409307 2409307 defendant Cowper Tostantine yeoman 772207 772207 Cowper, Tostantine, of Cleye next the sea, yeoman 0
5183513 2410913 2410913 defendant Barton Ralph yeoman 772207 772207 Barton, Ralph, of Cleye next the Sea, yeoman 2
5188344 2412302 2412302 plaintiff Horn William   772207 772207 Horn, William, of Cleye next the sea 0
5198918 2415437 2415437 defendant Wagstaff Bartholomew draper 772207 772207 Wagstaff, Bartholomew, of Cleye next the Sea, draper 0
5268374 2435877 2435877 defendant Brygge John gent 772207 772207 Brygge, John, of Cleye next the sea, gent 1
5272039 2436904 2436904 defendant Paryssh Thomas yeoman 772207 772207 Paryssh, Thomas, of Cleye next the sea, yeoman 0
5273824 2437421 2437421 defendant Colman Walter clerk 772207 772207 Colman, Walter, of Cleye next the sea, clerk 1
5274409 2437594 2437594 defendant Colman Walter clerk 772207 772207 Colman, Walter, of Cleye next the sea, clerk 0
5383862 2470469 2470469 defendant Collys Thomas yeoman 772207 772207 Collys, Thomas, of Cleye next the sea, yeoman 0
5397591 2474377 2474377 defendant Broun Simon yeoman 772207 772207 Broun, Simon, of Cleye next the sea, yeoman 1
5397592 2474377 2474377 defendant Chylde Thomas yeoman 772207 772207 Chylde, Thomas, of Cleye next the sea, yeoman 2
5428689 2483495 2483495 defendant Collys Thomas yeoman 772207 772207 Collys, Thomas, of Cleye next the sea, yeoman 0
5428714 2483501 2483501 defendant Collys Thomas yeoman 772207 772207 Collys, Thomas, of Cleye next the Sea, yeoman 1
5445948 2488676 2488676 defendant Collys Thomas   772207 772207 Collys, Thomas, of Cleye next the sea 0
5445950 2488677 2488677 defendant Collys Thomas yeoman 772207 772207 Collys, Thomas, of Cleye next the Sea, yeoman 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);