names

23 rows where place_id = 764906

✎ 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
4511067 2203913 2203913 defendant Stothele John   764906 764906 Stothele, John, of Repon 0
4872874 2318468 2318468 defendant Falstede Ralph husbandman 764906 764906 Falstede, Ralph, of Repon, husbandman 2
4895220 2325163 2325163 defendant Whetherby John chapman 764906 764906 Whetherby, John, of Repon, chapman 1
4895221 2325163 2325163 defendant Scroggys William chapman 764906 764906 Scroggys, William, of Repon, chapman 2
4957150 2344098 2344098 defendant Flesshewer John dyer 764906 764906 Flesshewer, John, of Repon, dyer 0
4957153 2344099 2344099 defendant Flesshowre John dyer 764906 764906 Flesshowre, John, of Repon, dyer 0
4978439 2350498 2350498 defendant Willescote alias Webster Lawrence weaver 764906 764906 Willescote alias Webster, Lawrence, of Repon, weaver 0
5074721 2378944 2378944 defendant Rygengey Thomas weaver 764906 764906 Rygengey, Thomas, of Repon, weaver 1
5132885 2396110 2396110 defendant Aish William chapman 764906 764906 Aish, William, of Repon, chapman 9
5132888 2396110 2396110 defendant Todde William chapman 764906 764906 Todde, William, of Repon, chapman 12
5132889 2396110 2396110 defendant Todde Thomas chapman 764906 764906 Todde, Thomas, of Repon, chapman 13
5153066 2402039 2402039 defendant Keton James yeoman 764906 764906 Keton, James, of Repon, yeoman 9
5153067 2402039 2402039 defendant Keton James gent 764906 764906 Keton, James, of Repon, gent 10
5153068 2402039 2402039 defendant Todde William chapman 764906 764906 Todde, William, of Repon, chapman 11
5250949 2430403 2430403 plaintiff Wrampen William merchant 764906 764906 Wrampen, William, of Repon, merchant 0
5353732 2461234 2461234 defendant Condall John glover 764906 764906 Condall, John, of Repon, glover 0
5353733 2461234 2461234 defendant Potte Robert glover 764906 764906 Potte, Robert, of Repon, glover 1
5353737 2461235 2461235 defendant Condall John glover 764906 764906 together with Condall, John, of Repon, glover 1
5353738 2461235 2461235 defendant Potte Robert glover 764906 764906 Potte, Robert, of Repon, glover 2
5355609 2461831 2461831 defendant Wilkynson John barker 764906 764906 Wilkynson, John, of Repon, barker 0
5355610 2461831 2461831 defendant Pullan Stephen barker 764906 764906 Pullan, Stephen, of Repon, barker 1
5355611 2461831 2461831 defendant Marnduke Robert barker 764906 764906 Marnduke, Robert, of Repon, barker 2
5355612 2461831 2461831 defendant Tomson William barker 764906 764906 Tomson, William, of Repon, barker 3

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