names

22 rows where place_id = 591939

✎ 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
3606045 1869557 1869557 defendant Stansted John husbandman 591939 591939 Stansted, John, of Magna Teye, husbandman 0
4780756 2289982 2289982 defendant Hoo Richard yeoman 591939 591939 Hoo, Richard, of Magna Teye, yeoman 0
4867243 2316717 2316717 defendant Stanstede John husbandman 591939 591939 Stanstede, John, of Magna Teye, husbandman 2
4867244 2316717 2316717 defendant Stanstede Eleanor widow 591939 591939 Stanstede, Eleanor, of Magna Teye, widow 3
4940112 2338935 2338935 defendant Rampton John husbandman 591939 591939 Rampton, John, of Magna Teye, husbandman 0
4950621 2342158 2342158 defendant Fuller John herder 591939 591939 Fuller, John, of Magna Teye, herder 0
4973048 2348871 2348871 defendant Bette William husbandman 591939 591939 Bette, William, of Magna Teye, husbandman 0
5029434 2365482 2365482 defendant Stanstede William husbandman 591939 591939 Stanstede, William, of Magna Teye, husbandman 3
5054713 2372987 2372987 defendant Poleyn Thomas carpenter 591939 591939 Poleyn, Thomas, of Magna Teye, carpenter 2
5094813 2384895 2384895 defendant Lenyng or Levyng John husbandman 591939 591939 Lenyng or Levyng, John, of Magna Teye, husbandman 1
5094832 2384902 2384902 defendant Lenyng or Levyng John husbandman 591939 591939 Lenyng or Levyng, John, of Magna Teye, husbandman 1
5111574 2389780 2389780 defendant Stansted John husbandman 591939 591939 Stansted, John, of Magna Teye, husbandman 1
5111578 2389781 2389781 defendant Stansted John husbandman 591939 591939 Stansted, John, of Magna Teye, husbandman 1
5253908 2431336 2431336 defendant Stansted William husbandman 591939 591939 Stansted, William, of Magna Teye, husbandman 0
5257608 2432499 2432499 defendant Coke Thomas clerk 591939 591939 Coke, Thomas, of Magna Teye, clerk 0
5282376 2439907 2439907 defendant Smyth John yeoman 591939 591939 Smyth, John, of Magna Teye, yeoman 0
5282378 2439908 2439908 defendant Smyth John yeoman 591939 591939 Smyth, John, of Magna Teye, yeoman 0
5284029 2440350 2440350 defendant Lyndwode Clement husbandman 591939 591939 Lyndwode, Clement, of Magna Teye, husbandman 4
5288247 2441579 2441579 defendant London Thomas husbandman 591939 591939 London, Thomas, of Magna Teye, husbandman 0
5293704 2443121 2443121 defendant Hikson John husbandman 591939 591939 Hikson, John, of Magna Teye, husbandman 2
5501956 2505536 2505536 plaintiff Stubbes Thomas clerk 591939 591939 Stubbes, Thomas, of Magna Teye, clerk 0
5512585 2508790 2508790 defendant Cressyld or Creffyld Robert husbandman 591939 591939 Cressyld or Creffyld, Robert, of Magna Teye, husbandman 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);