names

21 rows where place_id = 661478

✎ 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
3960873 2010901 2010901 defendant Cleare George husbandman 661478 661478 Cleare, George, of Frettenham, husbandman 1
3992222 2021984 2021984 defendant Cooke Robert butcher 661478 661478 Cooke, Robert, of Frettenham, butcher 0
3996688 2023579 2023579 defendant Wynsdon Thomas yeoman 661478 661478 Wynsdon, Thomas, of Frettenham, yeoman 1
4007348 2027409 2027409 defendant Warlyth Robert turner 661478 661478 Warlyth, Robert, of Frettenham, turner 2
4007354 2027410 2027410 defendant Wurlych Robert turner 661478 661478 Wurlych, Robert, of Frettenham, turner 2
4009666 2028227 2028227 defendant Palmer Ambrose clerk 661478 661478 Palmer, Ambrose, of Frettenham, clerk 0
4009978 2028335 2028335 defendant Palmer Ambrose clerk 661478 661478 Palmer, Ambrose, of Frettenham, clerk 0
4075954 2051698 2051698 defendant Goffe James yeoman 661478 661478 Goffe, James, of Frettenham, yeoman 1
4087431 2055798 2055798 defendant Cock Robert butcher 661478 661478 Cock, Robert, of Frettenham, butcher 1
4159171 2081274 2081274 defendant Morrys Robert husbandman 661478 661478 Morrys, Robert, of Frettenham, husbandman 1
4166481 2083774 2083774 defendant Newton John   661478 661478 Newton, John, of Frettenham husbandman 0
4166547 2083795 2083795 defendant Nawton John husbandman 661478 661478 Nawton, John, of Frettenham, husbandman 1
4193002 2093118 2093118 defendant Drury Henry gent 661478 661478 Drury, Henry, of Frettenham, gent 0
4200025 2095560 2095560 defendant Wylson Thomas husbandman 661478 661478 Wylson, Thomas, of Frettenham, husbandman 0
4208267 2098441 2098441 defendant Bankes Roger husbandman 661478 661478 Bankes, Roger, of Frettenham, husbandman 3
4258901 2115948 2115948 defendant Reymers Henry husbandman 661478 661478 Reymers, Henry, of Frettenham, husbandman 5
4277290 2121987 2121987 defendant Moore Ambrose yeoman 661478 661478 Moore, Ambrose, of Frettenham, yeoman 2
4284458 2124491 2124491 defendant Reymer Henry yeoman 661478 661478 Reymer, Henry, of Frettenham, yeoman 0
4327369 2139478 2139478 defendant Raymers Henry husbandman 661478 661478 Raymers, Henry, of Frettenham, husbandman 0
4344724 2145435 2145435 defendant Peeke William gent 661478 661478 Peeke, William, of Frettenham, gent 0
4344725 2145435 2145435 defendant Gosse John gent 661478 661478 Gosse, John, of Frettenham, gent 1

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