names

17 rows where place_id = 647849

✎ 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
3898526 1989718 1989718 defendant Chamond Richard esq 647849 647849 Chamond, Richard, of Efford, esq 3
4327290 2139453 2139453 defendant Hals Grenvile gent 647849 647849 Hals, Grenvile, of Efford, gent 0
4768645 2286173 2286173 defendant Whitelegh Walter gent 647849 647849 Whitelegh, Walter, of Efford, gent 0
4819540 2302189 2302189 defendant Stephen Nicholas yeoman 647849 647849 Stephen, Nicholas, of Efford, yeoman 2
4844629 2309839 2309839 defendant Manler or Mauler Richard husbandman 647849 647849 Manler or Mauler, Richard, of Efford, husbandman 0
4900832 2326891 2326891 defendant Whitelee Walter esq 647849 647849 Whitelee, Walter, of Efford, esq 0
4900833 2326891 2326891 defendant Whitelee John gent 647849 647849 Whitelee, John, of Efford, gent 1
4927873 2335153 2335153 defendant Whytlegh Walter   647849 647849 Whytlegh, Walter, of Efford, gent, son & heir of Peter Whitelegh 0
4947311 2341152 2341152 defendant Whitelegh Walter gent 647849 647849 Whitelegh, Walter, of Efford, gent 0
4999621 2356763 2356763 defendant Whitlegh Walter gent 647849 647849 Whitlegh, Walter, of Efford, gent 0
5003946 2358045 2358045 defendant Whitelegh Walter esq 647849 647849 Whitelegh, Walter, of Efford, esq 0
5003948 2358046 2358046 defendant Whitelegh Walter esq 647849 647849 Whitelegh, Walter, of Efford, esq 0
5026555 2364647 2364647 defendant Whytlegh Walter gent 647849 647849 Whytlegh, Walter, of Efford, gent 0
5249751 2430047 2430047 defendant Stephyn John husbandman 647849 647849 Stephyn, John, of Efford, husbandman 0
5249752 2430047 2430047 defendant Lylle Roger husbandman 647849 647849 Lylle, Roger, of Efford, husbandman 1
5482880 2499824 2499824 defendant Baweden Walter husbandman 647849 647849 Baweden, Walter, of Efford, husbandman 0
5541621 2517486 2517486 defendant Trerys John Arundell   647849 647849 Trerys, John Arundell, of Efford, knight 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);