names

21 rows where place_id = 589592

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598087 1867029 1867029 defendant Ploket John mercer 589592 589592 Ploket, John, of Rendelesham, mercer 0
3598089 1867030 1867030 defendant Ploket John mercer 589592 589592 Ploket, John, of Rendelesham, mercer 0
3598091 1867031 1867031 defendant Ploket John mercer 589592 589592 Ploket, John, of Rendelesham, mercer 0
4686423 2261357 2261357 defendant Rendelesham John husbandman 589592 589592 Rendelesham, John, of Rendelesham, husbandman 4
4697816 2264815 2264815 defendant Rendlesham Robert husbandman 589592 589592 Rendlesham, Robert, of Rendelesham, husbandman 0
4915997 2331503 2331503 defendant Rendelesham John   589592 589592 Rendelesham, John, of Rendelesham, franklin 0
4967467 2347213 2347213 defendant Wryght John yeoman 589592 589592 Wryght, John, of Rendelesham, yeoman 0
5031579 2366099 2366099 defendant Wode Joan   589592 589592 Wode, Joan, of Rendelesham, servant 0
5053882 2372755 2372755 defendant Tytteshale Richard clerk 589592 589592 Tytteshale, Richard, of Rendelesham, clerk 3
5064385 2375892 2375892 defendant Rendelesham John, junior yeoman 589592 589592 Rendelesham, John, junior, of Rendelesham, yeoman 14
5080250 2380582 2380582 defendant Tyteshale Richard clerk 589592 589592 Tyteshale, Richard, of Rendelesham, clerk 1
5135310 2396828 2396828 defendant fitz Rauff Robert yeoman or husbandman 589592 589592 fitz Rauff, Robert, of Rendelesham, yeoman or husbandman 0
5161484 2404459 2404459 defendant Robertson Richard gent 589592 589592 Robertson, Richard, of Rendelesham, gent 0
5175874 2408626 2408626 defendant Robertson Richard gent 589592 589592 Robertson, Richard, of Rendelesham, gent 0
5197525 2415015 2415015 defendant Robertson Richard gent 589592 589592 Robertson, Richard, of Rendelesham, gent 0
5197527 2415016 2415016 defendant Robertson Richard gent 589592 589592 Robertson, Richard, of Rendelesham, gent 0
5221515 2421990 2421990 defendant Lymsy Robert husbandman 589592 589592 Lymsy, Robert, of Rendelesham, husbandman 0
5284300 2440427 2440427 defendant Lymsy Robert husbandman 589592 589592 Lymsy, Robert, of Rendelesham, husbandman 0
5287539 2441380 2441380 defendant Brasyer Walter husbandman 589592 589592 Brasyer, Walter, of Rendelesham, husbandman 1
5317321 2450260 2450260 defendant Lymsy Robert husbandman 589592 589592 Lymsy, Robert, of Rendelesham, husbandman 0
5330358 2454156 2454156 defendant Rendelesham Robert yeoman 589592 589592 Rendelesham, Robert, of Rendelesham, yeoman 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);