names

35 rows where place_id = 607540

✎ 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
3669666 1916452 1916452 defendant Chamber Thomas beer brewer 607540 607540 Chamber, Thomas, of Mokkyng, beer brewer 1
3669667 1916452 1916452 defendant Harvy Thomas husbandman 607540 607540 Harvy, Thomas, of Mokkyng, husbandman 2
3669671 1916453 1916453 defendant Chamber Thomas beer brewer 607540 607540 Chamber, Thomas, of Mokkyng, beer brewer 1
3669672 1916453 1916453 defendant Harvy Thomas husbandman 607540 607540 Harvy, Thomas, of Mokkyng, husbandman 2
3682577 1920656 1920656 defendant Burton William husbandman 607540 607540 Burton, William, of Mokkyng, husbandman 0
3718933 1932202 1932202 plaintiff Goodwyn John yeoman 607540 607540 Goodwyn, John, of Mokkyng, yeoman 0
3738345 1938208 1938208 defendant Wodde Roger husbandman 607540 607540 Wodde, Roger, of Mokkyng, husbandman 1
3748341 1941412 1941412 plaintiff Goodwyn John yeoman 607540 607540 Goodwyn, John, of Mokkyng, yeoman 0
3761947 1945743 1945743 defendant Slyxston John butcher 607540 607540 Slyxston, John, of Mokkyng, butcher 0
3816608 1963095 1963095 defendant Slekyston John husbandman 607540 607540 Slekyston, John, of Mokkyng, husbandman 0
4507236 2202729 2202729 plaintiff Walton John   607540 607540 Walton, John, of Mokkyng 0
4643729 2244267 2244267 defendant Hoberd John   607540 607540 Hoberd, John, of Mokkyng 0
4914962 2331187 2331187 defendant Billyngdon Willam gent 607540 607540 Billyngdon, Willam, of Mokkyng, gent 0
4943066 2339806 2339806 plaintiff Gatton William (legal representative) 607540 607540 Gatton, William, of Mokkyng, executors of 0
4968723 2347615 2347615 defendant Houbard William husbandman 607540 607540 Houbard, William, of Mokkyng, husbandman 0
5019514 2362590 2362590 defendant Byllyngdon William gent 607540 607540 Byllyngdon, William, of Mokkyng, gent 0
5036087 2367407 2367407 defendant Byllyngdon William   607540 607540 Byllyngdon, William, of Mokkyng, Essexm gent 2
5041745 2369133 2369133 defendant Gwyon John carpenter 607540 607540 Gwyon, John, of Mokkyng, carpenter 0
5058709 2374168 2374168 defendant Byllyngdon William gent 607540 607540 Byllyngdon, William, of Mokkyng, gent 0
5058711 2374169 2374169 defendant Byllyngdon William gent 607540 607540 Byllyngdon, William, of Mokkyng, gent 0
5072849 2378361 2378361 defendant Byllyngdon William gent 607540 607540 Byllyngdon, William, of Mokkyng, gent 1
5227845 2423759 2423759 defendant Hoberd William husbandman 607540 607540 Hoberd, William, of Mokkyng, husbandman 0
5271166 2436664 2436664 plaintiff Gatton John, junior gent 607540 607540 Gatton, John, junior, of Mokkyng, brother of John Gatton, senior, of Mokkyng, gent 0
5271167 2436664 2436664 defendant Gatton John, senior gent 607540 607540 Gatton, John, senior, of Mokkyng, gent 0
5378940 2469007 2469007 plaintiff Wellys Thomas   607540 607540 Wellys, Thomas, of Mokkyng 0
5391917 2472765 2472765 defendant Thurgood William husbandman 607540 607540 Thurgood, William, of Mokkyng, husbandman 3
5391918 2472765 2472765 defendant Wellys Thomas (legal representative) 607540 607540 Wellys, Thomas, of Mokkyng, executrix of 4
5418125 2480345 2480345 defendant Wellys Thomas (legal representative) 607540 607540 Wellys, Thomas, of Mokkyng, executors of 2
5418126 2480345 2480345 defendant Thurgod William   607540 607540 (Thurgod, William, of Mokkyng 3
5435893 2485678 2485678 defendant Thurgod William husbandman 607540 607540 (Thurgod, William, of Mokkyng, husbandman 2
5435898 2485679 2485679 defendant Wellys Thomas (legal representative) 607540 607540 Wellys, Thomas, of Mokkyng, executors of 2
5435899 2485679 2485679 defendant Thurgod William husbandman 607540 607540 (Thurgod, William, of Mokkyng, husbandman 3
5435904 2485680 2485680 defendant Wellys Thomas (legal representative) 607540 607540 Wellys, Thomas, of Mokkyng, executors of 2
5435905 2485680 2485680 defendant Thurgod William husbandman 607540 607540 (Thurgod, William, of Mokkyng, husbandman 3
5487565 2501175 2501175 defendant Thurgood Robert husbandman 607540 607540 Thurgood, Robert, of Mokkyng, husbandman 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);