names

40 rows where place_id = 603193

✎ 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
3653818 1911454 1911454 defendant Orenge Richard merchant 603193 603193 Orenge, Richard, of Saltaysshe, merchant 0
3662036 1914060 1914060 defendant Hodge John merchant 603193 603193 Hodge, John, of Saltaysshe, merchant 0
3892004 1987576 1987576 defendant Jakman Robert yeoman 603193 603193 Jakman, Robert, of Saltaysshe, yeoman 1
3898541 1989722 1989722 defendant Lambarte Richard merchant 603193 603193 Lambarte, Richard, of Saltaysshe, merchant 0
3972664 2015014 2015014 defendant Hyll Thomas, junior merchant 603193 603193 Hyll, Thomas, junior, of Saltaysshe, merchant 0
4058813 2045547 2045547 plaintiff Clewbery Henry   603193 603193 Clewbery, Henry, of Saltaysshe 0
4712679 2269281 2269281 defendant Marcowe Thomas yeoman 603193 603193 Marcowe, Thomas, of Saltaysshe, yeoman 0
4723361 2272615 2272615 defendant Peers William tailor 603193 603193 Peers, William, of Saltaysshe, tailor 0
4807726 2298605 2298605 defendant Kyston John mariner 603193 603193 Kyston, John, of Saltaysshe, mariner 0
4818220 2301775 2301775 defendant Robyn Joan widow 603193 603193 Robyn, Joan, of Saltaysshe, widow 1
4855426 2313057 2313057 defendant Whitcherche John yeoman 603193 603193 Whitcherche, John, of Saltaysshe, yeoman 0
4860954 2314786 2314786 defendant Bustard Richard mariner 603193 603193 Bustard, Richard, of Saltaysshe, mariner 0
4947562 2341232 2341232 defendant Robyn John mariner 603193 603193 Robyn, John, of Saltaysshe, mariner 0
5004898 2358330 2358330 defendant Bayly Richard baker 603193 603193 Bayly, Richard, of Saltaysshe, baker 0
5004899 2358330 2358330 defendant Eston John ostler 603193 603193 Eston, John, of Saltaysshe, ostler 1
5061986 2375186 2375186 defendant Fissher Henry husbandman 603193 603193 Fissher, Henry, of Saltaysshe, husbandman 2
5111675 2389812 2389812 defendant Toker William mariner 603193 603193 Toker, William, of Saltaysshe, mariner 5
5111680 2389813 2389813 defendant Toker William mariner 603193 603193 Toker, William, of Saltaysshe, mariner 3
5128892 2394935 2394935 defendant Slugge Richard merchant 603193 603193 Slugge, Richard, of Saltaysshe, merchant 4
5131574 2395716 2395716 defendant Toker William   603193 603193 Toker, William, of Saltaysshe, administrators of 4
5132917 2396120 2396120 defendant Godyng William merchant 603193 603193 Godyng, William, of Saltaysshe, merchant 0
5181987 2410482 2410482 defendant Howe Robert skinner 603193 603193 Howe, Robert, of Saltaysshe, skinner 0
5249145 2429871 2429871 plaintiff Toker William   603193 603193 Toker, William, of Saltaysshe, administrators of 0
5249149 2429872 2429872 plaintiff Toker William   603193 603193 Toker, William, of Saltaysshe, administrators of 0
5277086 2438385 2438385 defendant Harry William merchant 603193 603193 Harry, William, of Saltaysshe, merchant 0
5311285 2448404 2448404 defendant Revyll Thomas merchant 603193 603193 Revyll, Thomas, of Saltaysshe, merchant 1
5311988 2448611 2448611 defendant Conyngham William barber 603193 603193 Conyngham, William, of Saltaysshe, barber 0
5311992 2448612 2448612 defendant Conyngham William barber 603193 603193 Conyngham, William, of Saltaysshe, barber 0
5323925 2452238 2452238 plaintiff Peyk or Pyke William, senior (legal representative) 603193 603193 Peyk or Pyke, William, senior, of Saltaysshe, father of Peyk, Richard, of Saltayssh, Cornw, singleman, executors of 0
5324843 2452505 2452505 defendant Renell or Revell William merchant 603193 603193 Renell or Revell, William, of Saltaysshe, merchant 0
5324844 2452505 2452505 defendant Renell or Revell Thomas merchant 603193 603193 Renell or Revell, Thomas, of Saltaysshe, merchant 1
5324848 2452506 2452506 defendant Renell or Revell William merchant 603193 603193 Renell or Revell, William, of Saltaysshe, merchant 0
5324849 2452506 2452506 defendant Renell or Revell Thomas merchant 603193 603193 Renell or Revell, Thomas, of Saltaysshe, merchant 1
5336902 2456104 2456104 defendant Quarell William tailor 603193 603193 Quarell, William, of Saltaysshe, tailor 1
5345607 2458786 2458786 defendant Whyte John mariner 603193 603193 Whyte, John, of Saltaysshe, mariner 0
5372362 2466951 2466951 defendant Hoyge John merchant 603193 603193 Hoyge, John, of Saltaysshe, merchant 0
5373029 2467155 2467155 defendant Wotton John mercer 603193 603193 Wotton, John, of Saltaysshe, mercer 0
5419876 2480860 2480860 defendant Leche Thomas   603193 603193 Leche, Thomas, of Saltaysshe 0
5477694 2498347 2498347 defendant Agys Nicholas mariner 603193 603193 Agys, Nicholas, of Saltaysshe, mariner 4
5499295 2504732 2504732 plaintiff Phylip John   603193 603193 Phylip, John, of Saltaysshe 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);