names

17 rows where place_id = 598228

✎ 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
3631654 1904714 1904714 defendant Hylton John husbandman 598228 598228 Hylton, John, of Maydenhed, Berks, husbandman 0
3661766 1913963 1913963 defendant Mery Richard smith 598228 598228 Mery, Richard, of Maydenhed, Berks, smith 0
3709863 1929399 1929399 defendant Deblyn or Devlyn John innholder 598228 598228 Deblyn or Devlyn, John, of Maydenhed, Berks, innholder 3
3750898 1942204 1942204 defendant Hylton John innholder 598228 598228 Hylton, John, of Maydenhed, Berks, innholder 1
3934006 2001672 2001672 defendant Myland John   598228 598228 Myland, John, of Maydenhed, Berks, brick layer 2
4080033 2053163 2053163 defendant Peck Silvester gent 598228 598228 Peck, Silvester, of Maydenhed, Berks, gent 0
4154723 2079746 2079746 defendant Dwyght David shoemaker 598228 598228 Dwyght, David, of Maydenhed, Berks, shoemaker 0
4154726 2079747 2079747 defendant Dwyght David shoemaker 598228 598228 Dwyght, David, of Maydenhed, Berks, shoemaker 0
4289706 2126382 2126382 defendant Babbe Edward   598228 598228 Babbe, Edward, of Maydenhed, Berks, wheelwright 3
4338726 2143297 2143297 defendant Pagett Charles gent 598228 598228 Pagett, Charles, of Maydenhed, Berks, gent 0
4391877 2161908 2161908 defendant Ansley or Ausley Henry gent 598228 598228 Ansley or Ausley, Henry, of Maydenhed, Berks, gent 0
5286628 2441100 2441100 defendant Taylour Thomas hosteler 598228 598228 Taylour, Thomas, of Maydenhed, Berks, hosteler 0
5535289 2515563 2515563 defendant Yonge Henry laborer 598228 598228 Yonge, Henry, of Maydenhed, Berks, laborer 1
5553675 2521111 2521111 defendant Marsshall Alice widow 598228 598228 Marsshall, Alice, of Maydenhed, Berks, widow 1
5569273 2525571 2525571 defendant Nores Robert yeoman 598228 598228 Nores, Robert, of Maydenhed, Berks, yeoman 2
5592394 2532608 2532608 defendant Hull Roland yeoman 598228 598228 Hull, Roland, of Maydenhed, Berks, yeoman 1
5592400 2532609 2532609 defendant Hull Roland yeoman 598228 598228 Hull, Roland, of Maydenhed, Berks, 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);