names

18 rows where place_id = 664287

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3972259 2014861 2014861 plaintiff Freston John esq 664287 664287 Freston, John, of Altoft, esq 0
4015623 2030285 2030285 plaintiff Smythson Thomas, junior husbandman 664287 664287 Smythson, Thomas, junior, of Altoft, husbandman 0
4033534 2036646 2036646 defendant Frobisher Edmund gent 664287 664287 Frobisher, Edmund, of Altoft, gent 9
4056460 2044695 2044695 plaintiff Brayton John gent 664287 664287 Brayton, John, of Altoft, gent 0
4056461 2044695 2044695 defendant Frobysher Edmund gent 664287 664287 Frobysher, Edmund, of Altoft, or of Hyrst, gent 0
4085132 2054965 2054965 defendant Fether Edmund yeoman 664287 664287 Fether, Edmund, of Altoft, yeoman 1
4104476 2061884 2061884 defendant Frear John yeoman 664287 664287 Frear, John, of Altoft, yeoman 2
4118034 2066734 2066734 defendant Hutchenson George   664287 664287 Hutchenson, George, of Altoft, yeoman, "badger" 0
4181359 2088961 2088961 defendant Nalson Richard yeoman 664287 664287 Nalson, Richard, of Altoft, yeoman 0
4181360 2088961 2088961 defendant Smythson Robert yeoman 664287 664287 Smythson, Robert, of Altoft, yeoman 1
4230976 2106332 2106332 defendant Sheperd Margery spinster 664287 664287 Sheperd, Margery, of Altoft, spinster 1
4248160 2112373 2112373 defendant Sheperd Margert spinster 664287 664287 Sheperd, Margert, of Altoft, spinster 1
4262685 2117190 2117190 defendant Freston John esq 664287 664287 Freston, John, of Altoft, esq 0
4267360 2118720 2118720 defendant Smythson Thomas yeoman 664287 664287 Smythson, Thomas, of Altoft, yeoman 0
4338799 2143324 2143324 defendant Shirtcliff Henry yeoman 664287 664287 Shirtcliff, Henry, of Altoft, yeoman 0
4338800 2143324 2143324 defendant Plate John yeoman 664287 664287 Plate, John, of Altoft, yeoman 1
4539476 2212602 2212602 defendant Knottyng John   664287 664287 Knottyng, John, of Altoft 2
4836416 2307364 2307364 defendant Taillour Thomas husbandman 664287 664287 Taillour, Thomas, of Altoft, husbandman 2

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