names

23 rows where place_id = 663908

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3970694 2014340 2014340 defendant Willoughby Henry gent 663908 663908 Willoughby, Henry, of Netherton, Worcs, gent 1
3980817 2017903 2017903 defendant Lyde George yeoman 663908 663908 Lyde, George, of Netherton, Worcs, yeoman 0
4005919 2026889 2026889 defendant Atkys William yeoman 663908 663908 Atkys, William, of Netherton, Worcs, yeoman 0
4012496 2029191 2029191 plaintiff Rainsforde Paul gent 663908 663908 Rainsforde, Paul, of Netherton, Worcs, gent 0
4012646 2029248 2029248 plaintiff Raynesford Paul gent 663908 663908 Raynesford, Paul, of Netherton, Worcs, gent 0
4012651 2029249 2029249 plaintiff Raynesford Paul gent 663908 663908 Raynesford, Paul, of Netherton, Worcs, gent 0
4012656 2029250 2029250 plaintiff Raynesford Paul gent 663908 663908 Raynesford, Paul, of Netherton, Worcs, gent 0
4012678 2029257 2029257 defendant Ramesford or Rainesford Paul gent 663908 663908 Ramesford or Rainesford, Paul, of Netherton, Worcs, gent 0
4012690 2029263 2029263 plaintiff Raynsford Paul gent 663908 663908 Raynsford, Paul, of Netherton, Worcs, gent 0
4012694 2029264 2029264 plaintiff Raynsford Paul gent 663908 663908 Raynsford, Paul, of Netherton, Worcs, gent 0
4012699 2029265 2029265 plaintiff Raynsford Paul gent 663908 663908 Raynsford, Paul, of Netherton, Worcs, gent 0
4018420 2031320 2031320 defendant Ramsford or Rainsford Paul gent 663908 663908 Ramsford or Rainsford, Paul, of Netherton, Worcs, gent 0
4023813 2033222 2033222 defendant Etkys William yeoman 663908 663908 Etkys, William, of Netherton, Worcs, yeoman 0
4044228 2040389 2040389 plaintiff Ramsford Paul gent 663908 663908 Ramsford, Paul, of Netherton, Worcs, gent 0
4044234 2040391 2040391 plaintiff Ramsforde or Rainsforde Paul gent 663908 663908 Ramsforde or Rainsforde, Paul, of Netherton, Worcs, gent 0
4048156 2041777 2041777 defendant Raynesford Paul gent 663908 663908 Raynesford, Paul, of Netherton, Worcs, gent 0
4048159 2041778 2041778 defendant Raynesford Paul gent 663908 663908 Raynesford, Paul, of Netherton, Worcs, gent 0
4086079 2055293 2055293 defendant Atkys William yeoman 663908 663908 Atkys, William, of Netherton, Worcs, yeoman 0
4121933 2068141 2068141 defendant Atkys William yeoman 663908 663908 Atkys, William, of Netherton, Worcs, yeoman 0
4127687 2070195 2070195 defendant Atkys William yeoman 663908 663908 Atkys, William, of Netherton, Worcs, yeoman 0
4173731 2086269 2086269 defendant Blyssard Thomas husbandman 663908 663908 Blyssard, Thomas, of Netherton, Worcs, husbandman 1
4178286 2087876 2087876 defendant Etkys William yeoman 663908 663908 Etkys, William, of Netherton, Worcs, yeoman 1
4191600 2092622 2092622 defendant Wylloughbye Henry gent 663908 663908 Wylloughbye, Henry, of Netherton, Worcs, gent 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);