names

23 rows where place_id = 594354

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615736 1872563 1872563 defendant Doget Reginald mariner 594354 594354 Doget, Reginald, of Orford, Suff, mariner 0
3991526 2021728 2021728 defendant Cawson Roger husbandman 594354 594354 Cawson, Roger, of Orford, Suff, husbandman 0
3992025 2021913 2021913 defendant Cawson Roger husbandman 594354 594354 Cawson, Roger, of Orford, Suff, husbandman 0
3998011 2024047 2024047 defendant Rashe Anthony esq 594354 594354 Rashe, Anthony, of Orford, Suff, esq 0
4000522 2024957 2024957 defendant Baly Urian yeoman 594354 594354 Baly, Urian, of Orford, Suff, yeoman 1
4004139 2026254 2026254 defendant Lonne or Loune John yeoman 594354 594354 Lonne or Loune, John, of Orford, Suff, yeoman 0
4056070 2044557 2044557 defendant Pers Robert, senior mariner 594354 594354 Pers, Robert, senior, of Orford, Suff, mariner 0
4076957 2052043 2052043 defendant Ballett Edward roper 594354 594354 Ballett, Edward, of Orford, Suff, roper 1
4135997 2073210 2073210 defendant Cuttinge John gent 594354 594354 Cuttinge, John, of Orford, Suff, gent 0
4207479 2098170 2098170 defendant Cuttinge John gent 594354 594354 Cuttinge, John, of Orford, Suff, gent 0
4237345 2108650 2108650 defendant Aylmer John brewer 594354 594354 Aylmer, John, of Orford, Suff, brewer 1
4270345 2119662 2119662 defendant Aylemer John brewer 594354 594354 Aylemer, John, of Orford, Suff, brewer 1
4761434 2283920 2283920 defendant Hygham Richard yeoman 594354 594354 Hygham, Richard, of Orford, Suff, yeoman 0
4772487 2287359 2287359 defendant Chamberleyn Richard mariner 594354 594354 Chamberleyn, Richard, of Orford, Suff, mariner 1
4807816 2298629 2298629 defendant Boteler Edmund shipman 594354 594354 Boteler, Edmund, of Orford, Suff, shipman 0
4809285 2299076 2299076 defendant Prudman Thomas yeoman 594354 594354 Prudman, Thomas, of Orford, Suff, yeoman 4
4811141 2299593 2299593 defendant Higham William (legal representative) 594354 594354 Higham, William, of Orford, Suff, chapman, executor of 0
5262904 2434139 2434139 defendant Mannyng Richard yeoman 594354 594354 Mannyng, Richard, of Orford, Suff, yeoman 0
5535609 2515665 2515665 defendant Russhe Thomas gent 594354 594354 Russhe, Thomas, of Orford, Suff, gent 10
5535629 2515666 2515666 defendant Russhe Thomas gent 594354 594354 Russhe, Thomas, of Orford, Suff, gent 10
5568698 2525395 2525395 defendant Russhe Thomas gent 594354 594354 Russhe, Thomas, of Orford, Suff, gent 3
5584932 2530365 2530365 defendant Russhe Thomas gent 594354 594354 Russhe, Thomas, of Orford, Suff, gent 4
5601882 2535483 2535483 defendant Russhe Thomas gent 594354 594354 Russhe, Thomas, of Orford, Suff, gent 5

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