names

34 rows where place_id = 601977

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3647887 1909734 1909734 defendant Bronde Thomas husbandman 601977 601977 Bronde, Thomas, of Westwyke, husbandman 0
3752589 1942738 1942738 defendant Cok John   601977 601977 Cok, John, of Westwyke, worsted weaver 1
3758021 1944493 1944493 defendant Feld John husbandman 601977 601977 Feld, John, of Westwyke, husbandman 2
3783054 1952452 1952452 defendant Bettys James husbandman 601977 601977 Bettys, James, of Westwyke, husbandman 3
3794550 1956176 1956176 defendant Withes Ralph yeoman 601977 601977 Withes, Ralph, of Westwyke, yeoman 0
3819531 1963986 1963986 defendant Cokke John   601977 601977 Cokke, John, of Westwyke, worsted weaver 1
3837938 1969779 1969779 defendant Wymer Thomas   601977 601977 Wymer, Thomas, of Westwyke, worsted weaver 0
3847184 1972675 1972675 defendant Coke Thomas husbandman 601977 601977 Coke, Thomas, of Westwyke, husbandman 0
3847185 1972675 1972675 defendant Cocke Robert   601977 601977 Cocke, Robert, of Westwyke, worsted weaver 1
3882298 1984337 1984337 defendant Wyme Thomas   601977 601977 Wyme, Thomas, of Westwyke, worsted weaver 3
3882302 1984338 1984338 defendant Wymere Thomas   601977 601977 Wymere, Thomas, of Westwyke, worsted weaver 2
3882686 1984475 1984475 defendant Tucke Christopher   601977 601977 Tucke, Christopher, of Westwyke, worsted weaver 0
3895658 1988752 1988752 defendant Robbys John   601977 601977 Robbys, John, of Westwyke, worsted weaver 0
3976044 2016188 2016188 defendant Skottowe John   601977 601977 Skottowe, John, of Westwyke, worsted weaver 2
3980268 2017709 2017709 defendant Tukke Thomas   601977 601977 Tukke, Thomas, of Westwyke, worsted weaver 0
3980269 2017709 2017709 defendant Tukke Edmund   601977 601977 Tukke, Edmund, of Westwyke, worsted weaver 1
4604935 2232705 2232705 defendant Cok Richard   601977 601977 Cok, Richard, of Westwyke 1
4799855 2296137 2296137 defendant Milaton Richard gent 601977 601977 Milaton, Richard, of Westwyke, gent 0
4943814 2340028 2340028 defendant Walsheman John husbandman 601977 601977 Walsheman, John, of Westwyke, husbandman 11
4948991 2341672 2341672 plaintiff Mileton William   601977 601977 Mileton, William, of Westwyke 0
4969739 2347896 2347896 defendant Batteshill John husbandman 601977 601977 Batteshill, John, of Westwyke, husbandman 9
5134151 2396485 2396485 defendant White Walter husbandman 601977 601977 White, Walter, of Westwyke, husbandman 0
5154090 2402354 2402354 defendant Whyte Walter husbandman 601977 601977 Whyte, Walter, of Westwyke, husbandman 0
5398506 2474631 2474631 defendant Feyth John, senior yeoman 601977 601977 Feyth, John, senior, of Westwyke, yeoman 0
5411621 2478431 2478431 defendant Feyth John, sen yeoman 601977 601977 Feyth, John, sen, of Westwyke, yeoman 0
5425958 2482722 2482722 defendant Feyth John yeoman 601977 601977 Feyth, John, of Westwyke, yeoman 0
5444251 2488187 2488187 defendant Feyth John, sen yeoman 601977 601977 Feyth, John, sen, of Westwyke, yeoman 0
5456989 2491996 2491996 defendant Feyth John, sen yeoman 601977 601977 Feyth, John, sen, of Westwyke, yeoman 0
5471059 2496284 2496284 defendant Harryes Alice widow 601977 601977 Harryes, Alice, of Westwyke, widow 0
5483789 2500096 2500096 defendant Gase John husbandman 601977 601977 Gase, John, of Westwyke, husbandman 4
5495292 2503489 2503489 defendant Millaton John gent 601977 601977 Millaton, John, of Westwyke, gent 0
5510293 2508058 2508058 defendant Millaton John gent 601977 601977 Millaton, John, of Westwyke, gent 0
5572687 2526555 2526555 defendant Cokke Thomas   601977 601977 Cokke, Thomas, of Westwyke, worsted weaver 0
5577186 2527915 2527915 defendant Cooke Thomas   601977 601977 Cooke, Thomas, of Westwyke, worsted weaver 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);