names

44 rows where place_id = 597025

✎ 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
3626974 1903293 1903293 defendant Simond Richard husbandman 597025 597025 Simond, Richard, of Wodford, husbandman 1
3656011 1912133 1912133 defendant May Richard husbandman 597025 597025 May, Richard, of Wodford, husbandman 0
3682819 1920731 1920731 defendant Smyth Thomas laborer 597025 597025 Smyth, Thomas, of Wodford, laborer 4
3687893 1922375 1922375 defendant Conesdewe Agnes widow 597025 597025 Conesdewe, Agnes, of Wodford, widow 1
3706853 1928431 1928431 defendant Thorley Richard gent 597025 597025 Thorley, Richard, of Wodford, gent 0
3717091 1931630 1931630 defendant Page John miller 597025 597025 Page, John, of Wodford, miller 0
3717092 1931630 1931630 defendant Gunne Walter husbandman 597025 597025 Gunne, Walter, of Wodford, husbandman 1
3754607 1943399 1943399 defendant Jane John husbandman 597025 597025 Jane, John, of Wodford, husbandman 1
3755094 1943541 1943541 defendant Deraunt Robert yeoman 597025 597025 Deraunt, Robert, of Wodford, yeoman 0
3768059 1947648 1947648 plaintiff Page John   597025 597025 Page, John, of Wodford 0
3783343 1952542 1952542 defendant Gybson Richard butcher 597025 597025 Gybson, Richard, of Wodford, butcher 1
3866647 1979077 1979077 defendant Parre Thomas yeoman 597025 597025 Parre, Thomas, of Wodford, yeoman 0
3884504 1985090 1985090 defendant Johnson Ralph yeoman 597025 597025 Johnson, Ralph, of Wodford, yeoman 0
3909428 1993453 1993453 defendant Shelley William husbandman 597025 597025 Shelley, William, of Wodford, husbandman 0
4098216 2059690 2059690 defendant Warberton Peter gent 597025 597025 Warberton, Peter, of Wodford, gent 0
4098217 2059690 2059690 defendant Corbett Thomas gent 597025 597025 Corbett, Thomas, of Wodford, gent 1
4098218 2059690 2059690 defendant Tylley Thomas miller 597025 597025 Tylley, Thomas, of Wodford, miller 2
4542670 2213595 2213595 defendant atte Ree Wiliam   597025 597025 atte Ree, Wiliam, of Wodford 2
4703041 2266334 2266334 defendant Appilton Richard   597025 597025 Appilton, Richard, of Wodford, parson 0
5002484 2357636 2357636 defendant Rypton John husbandman 597025 597025 Rypton, John, of Wodford, husbandman 0
5188488 2412351 2412351 defendant Islep William husbandman 597025 597025 Islep, William, of Wodford, husbandman 4
5188494 2412352 2412352 defendant Islep William husbandman 597025 597025 Islep, William, of Wodford, husbandman 4
5205838 2417442 2417442 defendant Islep William husbandman 597025 597025 Islep, William, of Wodford, husbandman 3
5214277 2419907 2419907 defendant Maylond John husbandman 597025 597025 Maylond, John, of Wodford, husbandman 3
5230973 2424666 2424666 defendant Peche Thomas yeoman 597025 597025 Peche, Thomas, of Wodford, yeoman 1
5233081 2425259 2425259 defendant atte Ree John husbandman 597025 597025 atte Ree, John, of Wodford, husbandman 0
5354726 2461558 2461558 defendant Grene John husbandman 597025 597025 Grene, John, of Wodford, husbandman 1
5388979 2471901 2471901 defendant Horell John hackneyman 597025 597025 Horell, John, of Wodford, hackneyman 2
5436973 2485991 2485991 defendant Smyth Richard smith 597025 597025 Smyth, Richard, of Wodford, smith 0
5505735 2506711 2506711 defendant Clyfton John husbandman 597025 597025 Clyfton, John, of Wodford, husbandman 4
5520165 2511128 2511128 defendant Simon John husbandman 597025 597025 Simon, John, of Wodford, husbandman 2
5520166 2511128 2511128 defendant Purchet Richard husbandman 597025 597025 Purchet, Richard, of Wodford, husbandman 3
5521696 2511601 2511601 defendant Howe Richard   597025 597025 Howe, Richard, of Wodford, wax chandler 2
5521698 2511601 2511601 defendant Salysbury William husbandman 597025 597025 Salysbury, William, of Wodford, husbandman 4
5572358 2526468 2526468 defendant Thorley William gent 597025 597025 Thorley, William, of Wodford, gent 0
5572359 2526468 2526468 defendant Thorley Richard gent 597025 597025 Thorley, Richard, of Wodford, gent 1
5572361 2526468 2526468 defendant Waunden John husbandman 597025 597025 Waunden, John, of Wodford, husbandman 3
5578327 2528291 2528291 defendant Wenden John butcher 597025 597025 Wenden, John, of Wodford, butcher 0
5589174 2531621 2531621 defendant Concidue Edward laborer 597025 597025 Concidue, Edward, of Wodford, laborer 0
5589175 2531621 2531621 defendant Howem Richard laborer 597025 597025 Howem Richard, of Wodford, laborer 1
5589177 2531622 2531622 defendant Conondue Edward laborer 597025 597025 Conondue, Edward, of Wodford, laborer 0
5589178 2531622 2531622 defendant Conondue Richard laborer 597025 597025 Conondue, Richard, of Wodford, laborer 1
5590941 2532143 2532143 plaintiff Standon William yeoman 597025 597025 Standon, William, of Wodford, yeoman 0
5608930 2537694 2537694 defendant Horell John   597025 597025 Horell, John, of Wodford, hakeney man 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);