names

20 rows where place_id = 615658

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3710079 1929463 1929463 defendant Burwer Robert, senior yeoman 615658 615658 Burwer, Robert, senior, of Woodallyng, yeoman 0
3713038 1930403 1930403 defendant Cokeman John butcher 615658 615658 Cokeman, John, of Woodallyng, butcher 0
3723293 1933558 1933558 defendant Bulware Roger yeoman 615658 615658 Bulware, Roger, of Woodallyng, yeoman 0
3723800 1933720 1933720 defendant Bulwer Margaret widow 615658 615658 Bulwer, Margaret, of Woodallyng, widow 0
3783223 1952505 1952505 defendant Bulwer Roger yeoman 615658 615658 Bulwer, Roger, of Woodallyng, yeoman 0
3845184 1972055 1972055 plaintiff Elwyn Peter yeoman 615658 615658 Elwyn, Peter, of Woodallyng, yeoman 0
3845185 1972055 1972055 defendant Cokman John husbandman 615658 615658 Cokman, John, of Woodallyng, husbandman 0
3863352 1977939 1977939 defendant Buller William gent 615658 615658 Buller, William, of Woodallyng, gent 0
3868001 1979531 1979531 defendant Elwyn Peter butcher 615658 615658 Elwyn, Peter, of Woodallyng, butcher 0
3913099 1994712 1994712 defendant Cokeman John butcher 615658 615658 Cokeman, John, of Woodallyng, butcher 0
4056446 2044689 2044689 defendant Albe or Albey William husbandman 615658 615658 Albe or Albey, William, of Woodallyng, or of Lynge, husbandman 0
4066106 2048166 2048166 defendant Stallond Hemry yeoman 615658 615658 Stallond, Hemry, of Woodallyng, yeoman 0
4337594 2142893 2142893 defendant Bulwer William gent 615658 615658 Bulwer, William, of Woodallyng, gent 0
4355447 2149127 2149127 defendant Bulwer William gent 615658 615658 Bulwer, William, of Woodallyng, gent 0
5312986 2448915 2448915 defendant Wooderoft Thomas butcher 615658 615658 Wooderoft, Thomas, of Woodallyng, butcher 0
5410528 2478093 2478093 plaintiff Bulwer John yeoman 615658 615658 Bulwer, John, of Woodallyng, yeoman 0
5491229 2502269 2502269 plaintiff Bulwer John (legal representative) 615658 615658 Bulwer, John, of Woodallyng, executors of 0
5491241 2502270 2502270 plaintiff Bulwer John (legal representative) 615658 615658 Bulwer, John, of Woodallyng, executors of 0
5550081 2520061 2520061 plaintiff Bulwar John (legal representative) 615658 615658 Bulwar, John, of Woodallyng, yeoman, executor of 0
5550085 2520062 2520062 plaintiff Bulwar Roger   615658 615658 Bulwar, Roger, of Woodallyng 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);