names

12 rows where place_id = 647456

✎ 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
3896289 1988970 1988970 defendant Burte William yeoman 647456 647456 (Burte, William, of Milborne Porte, yeoman 1
4063657 2047292 2047292 defendant Mennouth or Meimouth John husbandman 647456 647456 Mennouth or Meimouth, John, of Milborne Porte, husbandman 0
4170745 2085261 2085261 defendant Holwall George blacksmith 647456 647456 Holwall, George, of Milborne Porte, blacksmith 0
4216684 2101328 2101328 defendant Jerrard Robert gent 647456 647456 Jerrard, Robert, of Milborne Porte, or of Rempton, gent 0
4302915 2131142 2131142 defendant Chamberlayne Nicholas husbandman 647456 647456 Chamberlayne, Nicholas, of Milborne Porte, husbandman 0
4302916 2131142 2131142 defendant Rooe Reginald tanner 647456 647456 Rooe, Reginald, of Milborne Porte, tanner 1
4388146 2160662 2160662 defendant Collyns William yeoman 647456 647456 Collyns, William, of Milborne Porte, yeoman 0
4388148 2160663 2160663 defendant Collyns William yeoman 647456 647456 Collyns, William, of Milborne Porte, yeoman 0
5267644 2435639 2435639 defendant Dussell Robert yeoman 647456 647456 Dussell, Robert, of Milborne Porte, yeoman 0
5267645 2435639 2435639 defendant Togode William yeoman 647456 647456 Togode, William, of Milborne Porte, yeoman 1
5382411 2470029 2470029 defendant Gyldon John   647456 647456 Gyldon, John, of Milborne Porte 0
5487889 2501266 2501266 defendant Gildon John gent 647456 647456 Gildon, John, of Milborne Porte, gent 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);