names

38 rows where place_id = 792936

✎ 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
4732507 2275340 2275340 defendant Monk John clerk & parson 792936 792936 Monk, John, of Bere Ferrers, clerk & parson 1
4921282 2333166 2333166 defendant Champernon Roger esq 792936 792936 Champernon, Roger, of Bere Ferrers, esq 0
4991402 2354313 2354313 defendant Champernon Roger esq 792936 792936 Champernon, Roger, of Bere Ferrers, esq 0
5127949 2394652 2394652 defendant Tremayle Robert yeoman 792936 792936 Tremayle, Robert, of Bere Ferrers, Devon, junior, yeoman 3
5146975 2400257 2400257 plaintiff Champernon John esq 792936 792936 Champernon, John, of Bere Ferrers, esq 0
5152838 2401969 2401969 defendant Champernon Roger esq 792936 792936 Champernon, Roger, of Bere Ferrers, esq 0
5152840 2401970 2401970 defendant Champernon Roger esq 792936 792936 Champernon, Roger, of Bere Ferrers, esq 0
5155459 2402753 2402753 defendant Nygyr Balisus de merchant 792936 792936 Nygyr, Balisus de, of Bere Ferrers, merchant 0
5155566 2402785 2402785 defendant Lee Roger laborer 792936 792936 Lee, Roger, of Bere Ferrers, laborer 0
5166859 2406037 2406037 plaintiff Champernon John esq 792936 792936 Champernon, John, of Bere Ferrers, esq 0
5181989 2410483 2410483 defendant Maryner William merchant 792936 792936 Maryner, William, of Bere Ferrers, merchant 0
5189435 2412647 2412647 defendant West William laborer 792936 792936 West, William, of Bere Ferrers, laborer 2
5190031 2412827 2412827 defendant Maryner William merchant 792936 792936 Maryner, William, of Bere Ferrers, merchant 0
5190038 2412828 2412828 defendant Maryner William merchant 792936 792936 Maryner, William, of Bere Ferrers, merchant 0
5190045 2412829 2412829 defendant Maryner William merchant 792936 792936 Maryner, William, of Bere Ferrers, merchant 0
5203172 2416689 2416689 defendant Maryner William merchant 792936 792936 Maryner, William, of Bere Ferrers, merchant 0
5206499 2417633 2417633 defendant West William laborer 792936 792936 West, William, of Bere Ferrers, laborer 2
5206733 2417706 2417706 defendant Maryner William merchant 792936 792936 Maryner, William, of Bere Ferrers, merchant 0
5211721 2419168 2419168 defendant Champernon John esq 792936 792936 Champernon, John, of Bere Ferrers, esq 1
5213661 2419731 2419731 defendant Sampson John gent 792936 792936 Sampson, John, of Bere Ferrers, gent 0
5217663 2420898 2420898 defendant Lytton William yeoman 792936 792936 Lytton, William, of Bere Ferrers, yeoman 5
5217666 2420899 2420899 defendant Lytton William yeoman 792936 792936 Lytton, William, of Bere Ferrers, yeoman 1
5224624 2422873 2422873 defendant Champernon John esq 792936 792936 Champernon, John, of Bere Ferrers, esq 1
5231964 2424918 2424918 defendant Sampson John gent 792936 792936 Sampson, John, of Bere Ferrers, gent 0
5255589 2431866 2431866 defendant Sampson John gent 792936 792936 Sampson, John, of Bere Ferrers, gent 0
5255660 2431887 2431887 defendant Ryder Walter husbandman 792936 792936 Ryder, Walter, of Bere Ferrers, husbandman 0
5263485 2434327 2434327 defendant Champernoun Roger (legal representative) 792936 792936 Champernoun, Roger, of Bere Ferrers, esq, administrator of 0
5263486 2434327 2434327 defendant Champernoun John esq 792936 792936 Champernoun, John, of Bere Ferrers, esq 1
5273314 2437266 2437266 defendant Kennecote Walter clerk 792936 792936 Kennecote, Walter, of Bere Ferrers, clerk 0
5293594 2443094 2443094 defendant Crok Anthony husbandman 792936 792936 Crok, Anthony, of Bere Ferrers, husbandman 0
5293595 2443094 2443094 defendant Burgeys Walter husbandman 792936 792936 Burgeys, Walter, of Bere Ferrers, husbandman 1
5313783 2449149 2449149 defendant Kenecote Walter clerk 792936 792936 Kenecote, Walter, of Bere Ferrers, clerk 0
5354352 2461427 2461427 defendant Willughby Robert   792936 792936 Willughby, Robert, of Bere Ferrers, knight 1
5464405 2494267 2494267 defendant Lallak Thomas yeoman 792936 792936 Lallak, Thomas, of Bere Ferrers, yeoman 0
5464406 2494267 2494267 defendant Vegere Thomas yeoman 792936 792936 Vegere, Thomas, of Bere Ferrers, yeoman 1
5464407 2494267 2494267 defendant atte Wade Robert yeoman 792936 792936 atte Wade, Robert, of Bere Ferrers, yeoman 2
5591154 2532211 2532211 defendant Dunstunne John yeoman 792936 792936 Dunstunne, John, of Bere Ferrers, yeoman 0
5591155 2532211 2532211 defendant Stevon John yeoman 792936 792936 Stevon, John, of Bere Ferrers, yeoman 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);