names

46 rows where place_id = 601614

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3646250 1909217 1909217 defendant Wylkynson Edmund husbandman 601614 601614 Wylkynson, Edmund, of Tymberland, husbandman 0
3646251 1909217 1909217 defendant Langton John husbandman 601614 601614 Langton, John, of Tymberland, husbandman 1
3769230 1948030 1948030 defendant Cawde Thomas husbandman 601614 601614 Cawde, Thomas, of Tymberland, husbandman 0
3787055 1953745 1953745 defendant Cawde Thomas husbandman 601614 601614 Cawde, Thomas, of Tymberland, husbandman 0
3799170 1957651 1957651 defendant Coket Robert husbandman 601614 601614 Coket, Robert, of Tymberland, husbandman 0
3816657 1963111 1963111 defendant Coket Robert husbandman 601614 601614 Coket, Robert, of Tymberland, husbandman 0
3901203 1990627 1990627 defendant Wilson Richard husbandman 601614 601614 Wilson, Richard, of Tymberland, husbandman 0
3905472 1992100 1992100 defendant Stowbyng Thomas waterman 601614 601614 Stowbyng, Thomas, of Tymberland, waterman 0
3938631 2003263 2003263 defendant Tarratt John husbandman 601614 601614 Tarratt, John, of Tymberland, husbandman 2
4126448 2069744 2069744 defendant Seyer Thomas husbandman 601614 601614 Seyer, Thomas, of Tymberland, husbandman 0
4126450 2069744 2069744 defendant Boston Anthony husbandman 601614 601614 Boston, Anthony, of Tymberland, husbandman 2
4149714 2078025 2078025 defendant Squyer Thomas yeoman 601614 601614 Squyer, Thomas, of Tymberland, yeoman 0
4187497 2091125 2091125 defendant Hall William waterman 601614 601614 Hall, William, of Tymberland, waterman 0
4336535 2142516 2142516 defendant Grantham Ralph gent 601614 601614 Grantham, Ralph, of Tymberland, or of Heckington, gent 0
4346275 2145952 2145952 defendant Grantham Ralph yeoman 601614 601614 Grantham, Ralph, of Tymberland, yeoman 1
4362789 2151750 2151750 defendant Deddick John skipper 601614 601614 Deddick, John, of Tymberland, skipper 0
4362790 2151750 2151750 defendant Lymemaster Anthony laborer 601614 601614 Lymemaster, Anthony, of Tymberland, laborer 1
4636613 2242278 2242278 defendant Wilkynson John   601614 601614 Wilkynson, John, of Tymberland, son of John 0
4724245 2272877 2272877 defendant Castell William husbandman 601614 601614 Castell, William, of Tymberland, husbandman 0
4738504 2277134 2277134 defendant Castell William husbandman 601614 601614 Castell, William, of Tymberland, husbandman 2
4742719 2278378 2278378 defendant Catour William husbandman 601614 601614 Catour, William, of Tymberland, husbandman 2
4742721 2278378 2278378 defendant Malkynson John husbandman 601614 601614 Malkynson, John, of Tymberland, husbandman 4
4795950 2294880 2294880 plaintiff Russell John   601614 601614 Russell, John, of Tymberland 0
4801027 2296510 2296510 defendant Castell William husbandman 601614 601614 Castell, William, of Tymberland, husbandman 2
4963196 2345899 2345899 defendant Jakes Walter husbandman 601614 601614 Jakes, Walter, of Tymberland, husbandman 0
4994579 2355238 2355238 defendant Lewys John husbandman 601614 601614 Lewys, John, of Tymberland, husbandman 12
4998995 2356580 2356580 defendant Wilson John husbandman 601614 601614 Wilson, John, of Tymberland, husbandman 0
5105411 2388024 2388024 defendant Wilson John boatman 601614 601614 Wilson, John, of Tymberland, boatman 1
5388123 2471662 2471662 defendant Pope Thomas laborer 601614 601614 Pope, Thomas, of Tymberland, laborer 2
5388125 2471662 2471662 defendant Hall William laborer 601614 601614 Hall, William, of Tymberland, laborer 4
5388142 2471662 2471662 defendant Mason William laborer 601614 601614 Mason, William, of Tymberland, laborer 21
5391148 2472543 2472543 defendant Godewell John   601614 601614 Godewell, John, of Tymberland 0
5421561 2481383 2481383 defendant Godewell John husbandman 601614 601614 Godewell, John, of Tymberland, husbandman 0
5465505 2494590 2494590 defendant Williamson Richard husbandman 601614 601614 Williamson, Richard, of Tymberland, husbandman 1
5497838 2504294 2504294 defendant Vausoure John yeoman 601614 601614 (Vausoure, John, of Tymberland, yeoman 2
5497842 2504295 2504295 defendant Vausoure John yeoman 601614 601614 (Vausoure, John, of Tymberland, yeoman 2
5500502 2505089 2505089 defendant Castull Hugh husbandman 601614 601614 Castull, Hugh, of Tymberland, husbandman 1
5513176 2508969 2508969 defendant Grene John laborer 601614 601614 Grene, John, of Tymberland, laborer 2
5513177 2508969 2508969 defendant Bell Edmund laborer 601614 601614 Bell, Edmund, of Tymberland, laborer 3
5518643 2510662 2510662 defendant Jakes John husbandman 601614 601614 Jakes, John, of Tymberland, husbandman 0
5518644 2510662 2510662 defendant Hawe John husbandman 601614 601614 Hawe, John, of Tymberland, husbandman 1
5522005 2511701 2511701 defendant Johnson John yeoman 601614 601614 Johnson, John, of Tymberland, yeoman 1
5522006 2511701 2511701 defendant Habryncham John yeoman 601614 601614 Habryncham, John, of Tymberland, yeoman 2
5627664 2552624 2552624 defendant Wylkynson John husbandman 601614 601614 Wylkynson, John, of Tymberland, husbandman 2
5627670 2552624 2552624 defendant Pelson William husbandman 601614 601614 Pelson, William, of Tymberland, husbandman 8
5627671 2552624 2552624 defendant Phipson William husbandman 601614 601614 Phipson, William, of Tymberland, husbandman 9

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);