names

29 rows where place_id = 599904

✎ 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
3638759 1906941 1906941 defendant Smyth George gent 599904 599904 Smyth, George, of South Elkyngton, gent 0
3650887 1910643 1910643 defendant Morley Oliver husbandman 599904 599904 Morley, Oliver, of South Elkyngton, husbandman 0
3667511 1915780 1915780 defendant Chapman   laborer 599904 599904 Chapman, , of South Elkyngton, laborer 0
3818145 1963589 1963589 defendant Lyndley John husbandman 599904 599904 Lyndley, John, of South Elkyngton, husbandman 0
3818147 1963590 1963590 defendant Lyndley John husbandman 599904 599904 Lyndley, John, of South Elkyngton, husbandman 0
3897684 1989433 1989433 defendant Yong Oswald laborer 599904 599904 Yong, Oswald, of South Elkyngton, laborer 2
4015284 2030160 2030160 defendant Arneway Robert gent 599904 599904 Arneway, Robert, of South Elkyngton, gent 0
4092697 2057699 2057699 defendant Sergeon John   599904 599904 Sergeon, John, of South Elkyngton, husbandman, bachelor 0
4092700 2057700 2057700 defendant Sergeon Richard husbandman 599904 599904 Sergeon, Richard, of South Elkyngton, husbandman 0
4092701 2057700 2057700 defendant Sergeon William   599904 599904 Sergeon, William, of South Elkyngton, husbandman, son of Richard 1
4092702 2057700 2057700 defendant Sergeon John   599904 599904 Sergeon, John, of South Elkyngton, husbandman, son of Richard 2
4362080 2151480 2151480 defendant Reade Thomas clerk 599904 599904 Reade, Thomas, of South Elkyngton, clerk 0
4838929 2308108 2308108 defendant Smyth John smith 599904 599904 Smyth, John, of South Elkyngton, smith 0
4869944 2317574 2317574 defendant Sutton Robert tailor 599904 599904 Sutton, Robert, of South Elkyngton, tailor 2
4881077 2320992 2320992 defendant Cade John laborer 599904 599904 Cade, John, of South Elkyngton, laborer 2
5095698 2385163 2385163 plaintiff Smyth John   599904 599904 Smyth, John, of South Elkyngton 0
5110140 2389377 2389377 defendant Freman John husbandman 599904 599904 Freman, John, of South Elkyngton, husbandman 1
5129015 2394971 2394971 plaintiff Cowke Richard   599904 599904 Cowke, Richard, of South Elkyngton, vicar 0
5129016 2394971 2394971 plaintiff Bekerynge John yeoman 599904 599904 Bekerynge, John, of South Elkyngton, yeoman 1
5148238 2400625 2400625 plaintiff Cowyke Richard   599904 599904 Cowyke, Richard, of South Elkyngton, vicar 0
5148239 2400625 2400625 plaintiff Bekerynge John yeoman 599904 599904 Bekerynge, John, of South Elkyngton, yeoman 1
5377840 2468649 2468649 defendant Bekeryng Robert husbandman 599904 599904 Bekeryng, Robert, of South Elkyngton, husbandman 10
5377841 2468649 2468649 defendant Warde John husbandman 599904 599904 Warde, John, of South Elkyngton, husbandman 11
5377842 2468649 2468649 defendant Elfyn William husbandman 599904 599904 Elfyn, William, of South Elkyngton, husbandman 12
5377855 2468650 2468650 defendant Bekeryng Robert husbandman 599904 599904 Bekeryng, Robert, of South Elkyngton, husbandman 10
5377856 2468650 2468650 defendant Warde John husbandman 599904 599904 Warde, John, of South Elkyngton, husbandman 11
5377857 2468650 2468650 defendant Elfyn William husbandman 599904 599904 Elfyn, William, of South Elkyngton, husbandman 12
5412534 2478694 2478694 defendant Wyswall Richard yeoman 599904 599904 Wyswall, Richard, of South Elkyngton, yeoman 3
5575144 2527312 2527312 plaintiff Smyth George   599904 599904 Smyth, George, of South Elkyngton 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);