names

30 rows where place_id = 606809

✎ 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
3629588 1904111 1904111 plaintiff Danyell George (legal representative) 606809 606809 Danyell, George, of Boxley, Kent, "surweer", administratrix of 0
3647107 1909486 1909486 defendant Danyell Katherine   606809 606809 Danyell, Katherine, of Boxley, Kent, widow, dwelling at the Bull at the Rode of Grace 0
3666597 1915492 1915492 defendant Atcok Robert yeoman 606809 606809 Atcok, Robert, of Boxley, Kent, yeoman 0
3696909 1925253 1925253 defendant Skelton Thomas husbandman 606809 606809 Skelton, Thomas, of Boxley, Kent, husbandman 3
3767370 1947439 1947439 defendant Style William owner of ship called the Clement 606809 606809 Style, William, of Boxley, Kent, husbandman, owner of ship called the Clement 1
3769234 1948032 1948032 defendant Rawlyns John gent 606809 606809 Rawlyns, John, of Boxley, Kent, gent 0
3785119 1953133 1953133 defendant Style William husbandman 606809 606809 Style, William, of Boxley, Kent, husbandman 0
3794533 1956169 1956169 defendant Porter Agnes widow 606809 606809 Porter, Agnes, of Boxley, Kent, widow 0
3794535 1956170 1956170 defendant Porter Agnes widow 606809 606809 Porter, Agnes, of Boxley, Kent, widow 0
3864233 1978229 1978229 defendant Jonys Roger clerk 606809 606809 Jonys, Roger, of Boxley, Kent, clerk 4
3942201 2004410 2004410 defendant Comes John gent 606809 606809 Comes, John, of Boxley, Kent, gent 1
4380389 2158095 2158095 defendant Sparrowe Thomas laborer 606809 606809 Sparrowe, Thomas, of Boxley, Kent, laborer 0
4697878 2264831 2264831 defendant Durant Richard chapman 606809 606809 Durant, Richard, of Boxley, Kent, chapman 0
4697883 2264832 2264832 defendant Durant Richard chapman 606809 606809 Durant, Richard, of Boxley, Kent, chapman 0
5020781 2362974 2362974 defendant Snelgare Richard yeoman 606809 606809 Snelgare, Richard, of Boxley, Kent, yeoman 0
5071919 2378096 2378096 defendant Snelgare Richard   606809 606809 Snelgare, Richard, of Boxley, Kent, bailiff 0
5089022 2383166 2383166 defendant Porter John husbandman 606809 606809 Porter, John, of Boxley, Kent, husbandman 1
5120897 2392543 2392543 defendant Snelgrave Richard   606809 606809 Snelgrave, Richard, of Boxley, Kent, bailiff 0
5130280 2395339 2395339 defendant Reynford John esq 606809 606809 Reynford, John, of Boxley, Kent, esq 8
5149604 2401012 2401012 defendant Reynford John esq 606809 606809 Reynford, John, of Boxley, Kent, esq 0
5168476 2406494 2406494 defendant Reynford John esq 606809 606809 Reynford, John, of Boxley, Kent, esq 0
5244508 2428578 2428578 defendant Hogges Philip yeoman 606809 606809 Hogges, Philip, of Boxley, Kent, yeoman 1
5332604 2454818 2454818 defendant Pympe John esq 606809 606809 Pympe, John, of Boxley, Kent, esq 0
5351076 2460442 2460442 defendant Pympe John esq 606809 606809 Pympe, John, of Boxley, Kent, esq 0
5364892 2464689 2464689 defendant Beerde Thomas laborer 606809 606809 Beerde, Thomas, of Boxley, Kent, laborer 0
5366848 2465289 2465289 defendant Person John husbandman 606809 606809 Person, John, of Boxley, Kent, husbandman 1
5501820 2505495 2505495 defendant Pierson John husbandman 606809 606809 Pierson, John, of Boxley, Kent, husbandman 2
5507479 2507235 2507235 defendant Style John husbandman 606809 606809 Style, John, of Boxley, Kent, husbandman 1
5555188 2521521 2521521 defendant Brygge Robert yeoman 606809 606809 Brygge, Robert, of Boxley, Kent, yeoman 0
5555192 2521522 2521522 defendant Brygge Robert yeoman 606809 606809 Brygge, Robert, of Boxley, Kent, 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);