names

49 rows where place_id = 595826

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3615929 1872622 1872622 defendant Chapman alias Sexten John farmer of Radwynter rectory 595826 595826 Chapman alias Sexten, John, of Radwynter, husbandman, farmer of Radwynter rectory 0
3622057 1874439 1874439 defendant Hopper William husbandman 595826 595826 Hopper, William, of Radwynter, husbandman 0
3622058 1874439 1874439 defendant Sexten John husbandman 595826 595826 Sexten, John, of Radwynter, husbandman 1
3630542 1904382 1904382 defendant Danbery William butcher 595826 595826 Danbery, William, of Radwynter, butcher 3
3640400 1907427 1907427 defendant Coke John husbandman 595826 595826 Coke, John, of Radwynter, husbandman 1
3744591 1940204 1940204 defendant Wolcy John tilemaker 595826 595826 Wolcy, John, of Radwynter, tilemaker 2
3790926 1954995 1954995 defendant Sexsten Robert   595826 595826 Sexsten, Robert, of radwynter, tile maker 0
3790927 1954995 1954995 defendant Lyngys John tiler 595826 595826 Lyngys, John, of Radwynter, tiler 1
3790928 1954995 1954995 defendant Howe Richard tiler 595826 595826 Howe, Richard, of Radwynter, tiler 2
3790929 1954995 1954995 defendant Webbe Thomas laborer 595826 595826 Webbe, Thomas, of Radwynter, laborer 3
3790930 1954995 1954995 defendant Reve John husbandman 595826 595826 Reve, John, of Radwynter, husbandman 4
3882549 1984427 1984427 defendant Whale William husbandman 595826 595826 Whale, William, of Radwynter, husbandman 0
3918407 1996485 1996485 defendant Smyth Thomas carpenter 595826 595826 Smyth, Thomas, of Radwynter, carpenter 0
4175399 2086864 2086864 defendant Croxall Henry yeoman 595826 595826 Croxall, Henry, of Radwynter, yeoman 0
4188317 2091417 2091417 defendant Coxweat William yeoman 595826 595826 Coxweat, William, of Radwynter, yeoman 1
4276277 2121646 2121646 defendant Wale Thomas yeoman 595826 595826 Wale, Thomas, of Radwynter, yeoman 0
4310636 2133866 2133866 defendant Leader Robert (legal representative) 595826 595826 Leader, Robert, of Radwynter, yeoman, executor of 0
4369159 2154036 2154036 defendant Hoton Robert husbandman 595826 595826 Hoton, Robert, of Radwynter, husbandman 0
4380198 2158021 2158021 defendant Reder Samuel yeoman 595826 595826 Reder, Samuel, of Radwynter, yeoman 1
4384386 2159469 2159469 defendant Wale Thomas yeoman 595826 595826 Wale, Thomas, of Radwynter, yeoman 0
4384388 2159470 2159470 defendant Wale Thomas yeoman 595826 595826 Wale, Thomas, of Radwynter, yeoman 0
4390047 2161292 2161292 defendant Searle Thomas yeoman 595826 595826 Searle, Thomas, of Radwynter, yeoman 0
4407572 2167098 2167098 defendant Holton Robert husbandman 595826 595826 Holton, Robert, of Radwynter, husbandman 2
4410365 2168065 2168065 defendant Coxwytt William yeoman 595826 595826 Coxwytt, William, of Radwynter, yeoman 0
4410368 2168066 2168066 defendant Cornell Arthur yeoman 595826 595826 Cornell, Arthur, of Radwynter, yeoman 0
4577846 2224575 2224575 defendant Reymond Richard   595826 595826 Reymond, Richard, of Radwynter 0
4577848 2224576 2224576 defendant Reymond Richard   595826 595826 Reymond, Richard, of Radwynter 0
4999085 2356604 2356604 defendant Hogge John husbandman 595826 595826 Hogge, John, of Radwynter, husbandman 0
5044311 2369930 2369930 defendant Hogg John yeoman 595826 595826 Hogg, John, of Radwynter, yeoman 0
5103847 2387549 2387549 defendant Reymond John husbandman 595826 595826 Reymond, John, of Radwynter, husbandman 1
5103848 2387549 2387549 defendant Reymond Henry husbandman 595826 595826 Reymond, Henry, of Radwynter, husbandman 2
5161046 2404334 2404334 defendant Laker William yeoman 595826 595826 Laker, William, of Radwynter, yeoman 0
5161047 2404334 2404334 defendant Trubbok Thomas yeoman 595826 595826 Trubbok, Thomas, of Radwynter, yeoman 1
5276989 2438350 2438350 defendant Petyte John husbandman 595826 595826 Petyte, John, of Radwynter, husbandman 1
5288635 2441696 2441696 defendant Petyte John husbandman 595826 595826 Petyte, John, of Radwynter, husbandman 1
5428685 2483494 2483494 defendant Coldham William husbandman 595826 595826 Coldham, William, of Radwynter, husbandman 1
5445975 2488683 2488683 defendant Goldham William husbandman 595826 595826 Goldham, William, of Radwynter, husbandman 0
5460826 2493184 2493184 defendant Goldham William husbandman 595826 595826 Goldham, William, of Radwynter, husbandman 0
5460831 2493185 2493185 defendant Goldham William husbandman 595826 595826 Goldham, William, of Radwynter, husbandman 0
5482381 2499673 2499673 defendant Ramond John yeoman 595826 595826 Ramond, John, of Radwynter, yeoman 3
5483880 2500121 2500121 defendant Coldam William husbandman 595826 595826 Coldam, William, of Radwynter, husbandman 4
5494668 2503293 2503293 defendant Sexten John laborer 595826 595826 Sexten, John, of Radwynter, laborer 0
5543466 2518073 2518073 defendant Sexten Walter husbandman 595826 595826 Sexten, Walter, of Radwynter, husbandman 3
5549758 2519961 2519961 defendant Hoppar William husbandman 595826 595826 Hoppar, William, of Radwynter, husbandman 0
5549759 2519961 2519961 defendant Sexten John husbandman 595826 595826 Sexten, John, of Radwynter, husbandman 1
5555074 2521490 2521490 defendant Sexten Walter husbandman 595826 595826 Sexten, Walter, of Radwynter, husbandman 0
5565042 2524360 2524360 defendant Wolsey William yeoman 595826 595826 Wolsey, William, of Radwynter, yeoman 4
5586311 2530758 2530758 defendant Wolsy William yeoman 595826 595826 Wolsy, William, of Radwynter, yeoman 0
5601502 2535360 2535360 defendant Sexteyn Walter husbandman 595826 595826 Sexteyn, Walter, of Radwynter, husbandman 2

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