names

62 rows where place_id = 593170

✎ 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
3610779 1871036 1871036 defendant Jaxson Robert clerk 593170 593170 Jaxson, Robert, of Wynferthyng, clerk 0
3610780 1871036 1871036 defendant Jaxson Henry husbandman 593170 593170 Jaxson, Henry, of Wynferthyng, husbandman 1
3610781 1871036 1871036 defendant Jaxson Richard laborer 593170 593170 Jaxson, Richard, of Wynferthyng, laborer 2
3750984 1942235 1942235 defendant Goos William, junior   593170 593170 Goos, William, junior, of Wynferthyng, wheelwright 0
3759410 1944933 1944933 plaintiff Clerke Robert   593170 593170 Clerke, Robert, of Wynferthyng 0
3767293 1947414 1947414 defendant Lawnceter Richard tailor 593170 593170 Lawnceter, Richard, of Wynferthyng, tailor 0
3777624 1950752 1950752 defendant Goose William   593170 593170 Goose, William, of Wynferthyng, wheelwright 0
3779666 1951373 1951373 defendant Kyng Richard thatcher 593170 593170 Kyng, Richard, of Wynferthyng, thatcher 0
3780783 1951724 1951724 defendant Martyn William husbandman 593170 593170 Martyn, William, of Wynferthyng, husbandman 4
3781385 1951919 1951919 defendant Jamys James (legal representative) 593170 593170 Jamys, James, of Wynferthyng, executor of 0
3791386 1955140 1955140 defendant Goos William   593170 593170 Goos, William, of Wynferthyng, wheelwright 5
3793106 1955704 1955704 defendant Goose William   593170 593170 Goose, William, of Wynferthyng, wheelwright 0
3857003 1975823 1975823 plaintiff Clerke Robert   593170 593170 Clerke, Robert, of Wynferthyng 1
3875003 1981865 1981865 defendant Fletcher Thomas husbandman 593170 593170 Fletcher, Thomas, of Wynferthyng, husbandman 1
3881498 1984076 1984076 defendant Goos William   593170 593170 Goos, William, of Wynferthyng, wheelwright 1
4074077 2051021 2051021 defendant Flynt John husbandman 593170 593170 Flynt, John, of Wynferthyng, husbandman 3
4497661 2199916 2199916 defendant Kareman Henry   593170 593170 Kareman, Henry, of Wynferthyng 0
4514688 2205011 2205011 defendant Carman Henry   593170 593170 Carman, Henry, of Wynferthyng 1
4514691 2205012 2205012 defendant Carman Henry   593170 593170 Carman, Henry, of Wynferthyng 1
4546337 2214792 2214792 defendant Cook Henry   593170 593170 Cook, Henry, of Wynferthyng 0
4585750 2226965 2226965 defendant Bakere John   593170 593170 Bakere, John, of Wynferthyng 5
4672438 2257032 2257032 defendant Saxby Robert   593170 593170 Saxby, Robert, of Wynferthyng, wright 3
4672451 2257035 2257035 defendant Saxby Robert   593170 593170 Saxby, Robert, of Wynferthyng, wright 3
4680042 2259364 2259364 defendant Goos John sponer or shingle maker 593170 593170 Goos, John, of Wynferthyng, sponer or shingle maker 0
4781688 2290285 2290285 defendant Spencer Edward butcher 593170 593170 Spencer, Edward, of Wynferthyng, butcher 0
4781689 2290285 2290285 defendant Barbour Thomas yeoman 593170 593170 Barbour, Thomas, of Wynferthyng, yeoman 1
4793330 2294012 2294012 defendant Cook John yeoman 593170 593170 Cook, John, of Wynferthyng, yeoman 1
4852483 2312197 2312197 defendant Nobys John laborer 593170 593170 Nobys, John, of Wynferthyng, laborer 0
4889747 2323588 2323588 defendant Londale John husbandman 593170 593170 Londale, John, of Wynferthyng, husbandman 0
4891698 2324146 2324146 plaintiff Clare John   593170 593170 Clare, John, of Wynferthyng 0
4897871 2325995 2325995 plaintiff Clare John   593170 593170 Clare, John, of Wynferthyng 0
4897876 2325996 2325996 plaintiff Clare John   593170 593170 Clare, John, of Wynferthyng 0
4905148 2328211 2328211 plaintiff Clare John   593170 593170 Clare, John, of Wynferthyng 0
4905794 2328415 2328415 plaintiff Clare John   593170 593170 Clare, John, of Wynferthyng 0
4971867 2348518 2348518 defendant Clare John (legal representative) 593170 593170 Clare, John, of Wynferthyng, yeoman, executors of 0
4971868 2348518 2348518 defendant Cley Robert clerk 593170 593170 (Cley, Robert, of Wynferthyng, clerk 1
4971870 2348518 2348518 defendant Goos Robert husbandman 593170 593170 Goos, Robert, of Wynferthyng, husbandman 3
5019324 2362542 2362542 defendant Clare John (legal representative) 593170 593170 Clare, John, of Wynferthyng, yeoman, executors of 0
5019325 2362542 2362542 defendant Davy Robert clerk 593170 593170 (Davy, Robert, of Wynferthyng, clerk 1
5019326 2362542 2362542 defendant Goos Robert husbandman 593170 593170 Goos Robert, of Wynferthyng, husbandman 2
5019327 2362542 2362542 defendant Walkler George husbandman 593170 593170 Walkler, George, of Wynferthyng, husbandman 3
5044208 2369897 2369897 plaintiff Halle John   593170 593170 Halle, John, of Wynferthyng, son of Thomas & Margaret 2
5069326 2377315 2377315 defendant Smyth Robert turner 593170 593170 Smyth, Robert, of Wynferthyng, turner 1
5074901 2378997 2378997 defendant Smyth Robert husbandman 593170 593170 Smyth, Robert, of Wynferthyng, husbandman 0
5085038 2382035 2382035 defendant Cook Thomas   593170 593170 Cook, Thomas, of Wynferthyng, husbandma 2
5093049 2384356 2384356 defendant Gurnay Henry weaver 593170 593170 Gurnay, Henry, of Wynferthyng, weaver 1
5210963 2418938 2418938 defendant Westmyll John yeoman 593170 593170 Westmyll, John, of Wynferthyng, yeoman 0
5271909 2436868 2436868 defendant Clerk Richard husbandman 593170 593170 Clerk, Richard, of Wynferthyng, husbandman 0
5271910 2436868 2436868 defendant Clerk alias Gye William husbandman 593170 593170 Clerk alias Gye, William, of Wynferthyng, husbandman 1
5276647 2438251 2438251 defendant Gye William husbandman 593170 593170 (Gye, William, of Wynferthyng, husbandman 1
5296877 2444077 2444077 defendant Broun William laborer 593170 593170 Broun, William, of Wynferthyng, laborer 0
5296880 2444077 2444077 defendant Broun John laborer 593170 593170 Broun, John, of Wynferthyng, laborer 3
5300238 2445036 2445036 defendant John Hugh yeoman 593170 593170 John, Hugh, of Wynferthyng, yeoman 3
5304958 2446487 2446487 defendant Brome William laborer 593170 593170 Brome, William, of Wynferthyng, laborer 0
5341024 2457393 2457393 defendant Royce Edmund husbandman 593170 593170 Royce, Edmund, of Wynferthyng, husbandman 0
5341025 2457393 2457393 defendant Royce William laborer or singleman 593170 593170 Royce, William, of Wynferthyng, laborer or singleman 1
5346111 2458921 2458921 defendant John Hugh yeoman 593170 593170 John, Hugh, of Wynferthyng, yeoman 1
5365852 2464973 2464973 defendant Eye William husbandman 593170 593170 Eye, William, of Wynferthyng, husbandman 4
5507314 2507184 2507184 defendant John Hugh yeoman 593170 593170 John, Hugh, of Wynferthyng, yeoman 0
5530356 2514005 2514005 defendant Nooloth John yeoman 593170 593170 Nooloth, John, of Wynferthyng, yeoman 1
5546987 2519124 2519124 defendant Noloth John yeoman 593170 593170 Noloth, John, of Wynferthyng, yeoman 0
5634347 2554731 2554731 defendant Goos John husbandman 593170 593170 Goos, John, of Wynferthyng, 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);