names

52 rows where place_id = 602035

✎ 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
3648164 1909821 1909821 defendant Beste John, junior laborer 602035 602035 Beste, John, junior, of Chevenyng, laborer 1
3666216 1915382 1915382 defendant Smyth John yeoman 602035 602035 Smyth, John, of Chevenyng, yeoman 0
3678337 1919278 1919278 defendant Smyth William husbandman 602035 602035 Smyth, William, of Chevenyng, husbandman 0
3678338 1919278 1919278 defendant Smyth Robert husbandman 602035 602035 Smyth, Robert, of Chevenyng, husbandman 1
3752910 1942836 1942836 plaintiff Myllys John gent 602035 602035 Myllys, John, of Chevenyng, gent 1
3811621 1961532 1961532 defendant Benett Edmund husbandman 602035 602035 Benett, Edmund, of Chevenyng, husbandman 0
3886749 1985826 1985826 defendant Myllys John, senior gent 602035 602035 Myllys, John, senior, of Chevenyng, gent 0
3886750 1985826 1985826 defendant Waston John gent 602035 602035 Waston, John, of Chevenyng, gent 1
4046547 2041215 2041215 plaintiff Smyth John yeoman 602035 602035 Smyth, John, of Chevenyng, yeoman 0
4046549 2041216 2041216 plaintiff Smyth John yeoman 602035 602035 Smyth, John, of Chevenyng, yeoman 0
4121959 2068154 2068154 defendant Gilberd John gent 602035 602035 Gilberd, John, of Chevenyng, gent 0
4134953 2072821 2072821 defendant Robynson Robert laborer 602035 602035 Robynson, Robert, of Chevenyng, laborer 0
4134954 2072821 2072821 defendant Smyth Henry laborer 602035 602035 Smyth, Henry, of Chevenyng, laborer 1
4134955 2072821 2072821 defendant Thomas Robert laborer 602035 602035 Thomas, Robert, of Chevenyng, laborer 2
4228962 2105612 2105612 defendant Rumney Richard butcher 602035 602035 Rumney, Richard, of Chevenyng, butcher 0
4310267 2133744 2133744 defendant Rumney Richard butcher 602035 602035 Rumney, Richard, of Chevenyng, butcher 0
4567775 2221488 2221488 plaintiff Tooth John   602035 602035 Tooth, John, of Chevenyng 0
4610218 2234279 2234279 defendant Toth Thomas   602035 602035 Toth, Thomas, of Chevenyng 1
4746712 2279533 2279533 defendant Waldere William ripier 602035 602035 Waldere, William, of Chevenyng, ripier 0
4762256 2284176 2284176 defendant Harveys John husbandman 602035 602035 Harveys, John, of Chevenyng, husbandman 0
4834058 2306659 2306659 defendant Typpyng William yeoman 602035 602035 Typpyng, William, of Chevenyng, yeoman 0
4863813 2315655 2315655 defendant Wodeward Simpon husbandman 602035 602035 Wodeward, Simpon, of Chevenyng, husbandman 0
4863815 2315655 2315655 defendant Grenfeld Thomas husbandman 602035 602035 Grenfeld, Thomas, of Chevenyng, husbandman 2
4863816 2315655 2315655 defendant Ryer Thomas husbandman 602035 602035 Ryer, Thomas, of Chevenyng, husbandman 3
4863817 2315655 2315655 defendant Kyngedoune Stephen husbandman 602035 602035 Kyngedoune, Stephen, of Chevenyng, husbandman 4
4937103 2337975 2337975 defendant Harveys or Harneys John husbandman 602035 602035 Harveys or Harneys, John, of Chevenyng, husbandman 0
4976862 2350029 2350029 defendant Wodeward Simon yeoman 602035 602035 Wodeward, Simon, of Chevenyng, yeoman 0
4979467 2350815 2350815 defendant Wodeward Simon husbandman 602035 602035 Wodeward, Simon, of Chevenyng, husbandman 0
5005337 2358464 2358464 defendant Wodeward Simon husbandman 602035 602035 Wodeward, Simon, of chevenyng, husbandman 0
5052741 2372415 2372415 defendant Wodeward John yeoman 602035 602035 Wodeward, John, of Chevenyng, yeoman 2
5052764 2372421 2372421 defendant Wodeward John yeoman 602035 602035 Wodeward, John, of Chevenyng, yeoman 2
5084882 2381983 2381983 defendant Aylnoth John husbandman 602035 602035 Aylnoth, John, of Chevenyng, husbandman 0
5106892 2388444 2388444 defendant Wodeward John husbandman 602035 602035 Wodeward, John, of Chevenyng, husbandman 0
5147261 2400341 2400341 defendant Wodeward John husbandman 602035 602035 Wodeward, John, of Chevenyng, husbandman 1
5149770 2401069 2401069 defendant Wodeward Simon (legal representative) 602035 602035 Wodeward, Simon, of Chevenyng, executors of 0
5149772 2401069 2401069 defendant Wodeward John laborer 602035 602035 Wodeward, John, of Chevenyng, laborer 2
5149773 2401069 2401069 defendant Wodeward William husbandman 602035 602035 Wodeward, William, of Chevenyng, husbandman 3
5150925 2401408 2401408 defendant Bryd John haberdasher 602035 602035 Bryd, John, of Chevenyng, haberdasher 2
5153393 2402146 2402146 defendant Page Richard   602035 602035 Page, Richard, of Chevenyng, tile maker 3
5167029 2406090 2406090 defendant Wodeward John husbandman 602035 602035 Wodeward, John, of Chevenyng, husbandman 1
5203306 2416729 2416729 defendant Wodeward John husbandman 602035 602035 Wodeward, John, of Chevenyng, husbandman 0
5212037 2419260 2419260 defendant Skele John butcher 602035 602035 Skele, John, of Chevenyng, butcher 1
5340982 2457379 2457379 defendant Norwode Robert laborer 602035 602035 Norwode, Robert, of Chevenyng, laborer 1
5340983 2457379 2457379 defendant atte Myll Ralph (legal representative) 602035 602035 atte Myll, Ralph, of Chevenyng, executrix of 2
5340984 2457379 2457379 defendant Harvey Elizabeth widow 602035 602035 Harvey, Elizabeth, of Chevenyng, widow 3
5340986 2457380 2457380 defendant Norwode Robert laborer 602035 602035 Norwode, Robert, of Chevenyng, laborer 0
5373495 2467307 2467307 defendant Baker William laborer 602035 602035 Baker, William, of Chevenyng, laborer 0
5496814 2503973 2503973 defendant Haccher Richard husbandman 602035 602035 (Haccher, Richard, of Chevenyng, husbandman 1
5496815 2503973 2503973 defendant Palmer John husbandman 602035 602035 Palmer, John, of Chevenyng, husbandman 2
5513326 2509020 2509020 defendant Birde Robert yeoman 602035 602035 Birde, Robert, of Chevenyng, yeoman 0
5519355 2510900 2510900 defendant Baker William husbandman 602035 602035 Baker, William, of Chevenyng, husbandman 3
5629997 2553383 2553383 defendant Bentle Lawrence roper 602035 602035 Bentle, Lawrence, of Chevenyng, roper 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);