names

19 rows where place_id = 803844

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4799511 2296027 2296027 defendant Tregyllyowe Martin gent 803844 803844 Tregyllyowe, Martin, of Marghasyowe, gent 1
4799522 2296030 2296030 defendant Robynbony John merchant 803844 803844 Robynbony, John, of Marghasyowe, merchant 3
4960927 2345231 2345231 defendant Godoghan John   803844 803844 Godoghan, John, of Marghasyowe 0
4988135 2353427 2353427 defendant Tregurra Robert merchant 803844 803844 Tregurra, Robert, of Marghasyowe, merchant 0
4988137 2353428 2353428 defendant Tregurra Robert merchant 803844 803844 Tregurra, Robert, of Marghasyowe, merchant 0
4995738 2355566 2355566 defendant Boscawen Richard fisher 803844 803844 Boscawen, Richard, of Marghasyowe, fisher 0
5088461 2383000 2383000 defendant Robynvyan John mariner 803844 803844 Robynvyan, John, of Marghasyowe, mariner 3
5104832 2387850 2387850 defendant Laury Baldwin merchant 803844 803844 Laury, Baldwin, of Marghasyowe, merchant 1
5106127 2388228 2388228 defendant Clemmowe William gent 803844 803844 Clemmowe, William, of Marghasyowe, gent 1
5122025 2392856 2392856 defendant Laury Baldwin yeoman 803844 803844 Laury, Baldwin, of Marghasyowe, yeoman 1
5141048 2398503 2398503 defendant Lamy Baldus yeoman 803844 803844 Lamy, Baldus, of Marghasyowe, yeoman 1
5162226 2404681 2404681 defendant Laury Baldwin yeoman 803844 803844 Laury, Baldwin, of Marghasyowe, yeoman 1
5176362 2408775 2408775 defendant Laury Baldwin yeoman 803844 803844 Laury, Baldwin, of Marghasyowe, yeoman 1
5198361 2415271 2415271 defendant Laury Baldwin yeoman 803844 803844 Laury, Baldwin, of Marghasyowe, yeoman 1
5210495 2418803 2418803 defendant Laury Baldus yeoman 803844 803844 Laury, Baldus, of Marghasyowe, yeoman 1
5224683 2422888 2422888 defendant Janyn Philip John husbandman 803844 803844 Janyn, Philip John, of Marghasyowe, husbandman 2
5467068 2495098 2495098 defendant Uty William gent 803844 803844 Uty, William, of Marghasyowe, gent 4
5511583 2508470 2508470 defendant Avethen or Anethen Margaret widow 803844 803844 Avethen or Anethen, Margaret, of Marghasyowe, widow 0
5511586 2508470 2508470 defendant Bargoys John tailor 803844 803844 Bargoys, John, of Marghasyowe, tailor 3

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);