names

29 rows where place_id = 591341

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604121 1868954 1868954 defendant Duke Richard yeoman 591341 591341 Duke, Richard, of Rolvenden, yeoman 0
3621193 1874171 1874171 defendant Sexten John husbandman 591341 591341 Sexten, John, of Rolvenden, husbandman 0
3718485 1932060 1932060 plaintiff Frengham William   591341 591341 Frengham, William, of Rolvenden, administrators of 0
3718487 1932060 1932060 plaintiff Newland John   591341 591341 Newland, John, of Rolvenden 2
3718491 1932060 1932060 defendant Stokwode John husbandman 591341 591341 Stokwode, John, of Rolvenden, husbandman 3
3718492 1932060 1932060 defendant Kentcham Robert husbandman 591341 591341 Kentcham, Robert, of Rolvenden, husbandman 4
3734219 1936945 1936945 plaintiff Frengham William   591341 591341 Frengham, William, of Rolvenden, administrators of 0
3734221 1936945 1936945 plaintiff Newland John   591341 591341 Newland, John, of Rolvenden 2
3734224 1936945 1936945 defendant Stokwodde John husbandman 591341 591341 Stokwodde, John, of Rolvenden, husbandman 2
3734225 1936945 1936945 defendant Kencham Robert husbandman 591341 591341 Kencham, Robert, of Rolvenden, husbandman 3
3746898 1940946 1940946 defendant Frencham William (legal representative) 591341 591341 Frencham, William, of Rolvenden, yeoman, administrator of 0
3841027 1970764 1970764 defendant Dyngleden Edward husbandman 591341 591341 Dyngleden, Edward, of Rolvenden, husbandman 2
3980428 2017768 2017768 defendant Lawles Richard yeoman 591341 591341 Lawles, Richard, of Rolvenden, yeoman 0
4152518 2078993 2078993 defendant Wasten Anthony blacksmith 591341 591341 Wasten, Anthony, of Rolvenden, blacksmith 0
4232275 2106793 2106793 defendant Preston John husbandman 591341 591341 Preston, John, of Rolvenden, husbandman 0
4314406 2135151 2135151 defendant Jening William shoemaker 591341 591341 Jening, William, of Rolvenden, shoemaker 1
4317229 2136138 2136138 defendant Potten Thomas weaver 591341 591341 Potten, Thomas, of Rolvenden, weaver 0
4648050 2245496 2245496 defendant Taillour John   591341 591341 Taillour, John, of Rolvenden 0
4699758 2265368 2265368 defendant Dalot John husbandman 591341 591341 Dalot, John, of Rolvenden, husbandman 3
4703635 2266516 2266516 defendant Caycheam Robert husbandman 591341 591341 Caycheam, Robert, of Rolvenden, husbandman 2
4728305 2274098 2274098 plaintiff Hykke John   591341 591341 Hykke, John, of Rolvenden, son of John Hykke, sen 0
4780965 2290049 2290049 defendant Broune Stephen husbandman 591341 591341 Broune, Stephen, of Rolvenden, husbandman 3
4794115 2294295 2294295 defendant Gyldeford Edward gent 591341 591341 Gyldeford, Edward, of Rolvenden, gent 0
4794149 2294306 2294306 defendant Page Thomas laborer 591341 591341 Page, Thomas, of Rolvenden, laborer 0
4794150 2294306 2294306 defendant Sturme Thomas laborer 591341 591341 Sturme, Thomas, of Rolvenden, laborer 1
4794151 2294306 2294306 defendant Ascolfe or Astolfe John laborer 591341 591341 Ascolfe or Astolfe, John, of Rolvenden, laborer 2
4845944 2310238 2310238 defendant Bisshopynden Richard fuller 591341 591341 Bisshopynden, Richard, of Rolvenden, fuller 2
5388096 2471655 2471655 defendant Hikkes Henry husbandman 591341 591341 Hikkes, Henry, of Rolvenden, husbandman 1
5544344 2518338 2518338 defendant Fermour John laborer 591341 591341 Fermour, John, of Rolvenden, laborer 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);