names

43 rows where place_id = 588901

✎ 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
3595967 1866370 1866370 defendant Trumper John yeoman 588901 588901 Trumper, John, of Strete, yeoman 1
3696205 1925034 1925034 defendant Joce John husbandman 588901 588901 Joce, John, of Strete, husbandman 3
3848336 1973055 1973055 plaintiff Hyet Robert   588901 588901 Hyet, Robert, of Strete 0
3896155 1988918 1988918 defendant Rowe Richard husbandman 588901 588901 Rowe, Richard, of Strete, husbandman 1
3952975 2008108 2008108 defendant Marsshall Richard gent 588901 588901 Marsshall, Richard, of Strete, or of Glastonbury, Soms, gent 2
3980240 2017699 2017699 plaintiff Payne Stephen yeoman 588901 588901 Payne, Stephen, of Strete, yeoman 0
4058471 2045419 2045419 plaintiff Chele John yeoman 588901 588901 Chele, John, of Strete, yeoman 0
4116100 2066052 2066052 defendant Hychyn alias Chappell Roger husbandman 588901 588901 Hychyn alias Chappell, Roger, of Strete, husbandman 0
4144442 2076219 2076219 defendant Lasmere William clerk 588901 588901 Lasmere, William, of Strete, clerk 1
4176206 2087153 2087153 defendant Ryse John husbandman 588901 588901 Ryse, John, of Strete, husbandman 0
4199492 2095372 2095372 defendant Ryce John husbandman 588901 588901 Ryce, John, of Strete, husbandman 0
4225809 2104491 2104491 defendant Whittington Francis gent 588901 588901 Whittington, Francis, of Strete, gent 0
4310908 2133965 2133965 defendant Nicholas Richard gent 588901 588901 Nicholas, Richard, of Strete, gent 0
4502901 2201484 2201484 defendant Chepman John   588901 588901 Chepman, John, of Strete 0
4513204 2204555 2204555 plaintiff Brissheford john   588901 588901 Brissheford, john, of Strete 0
4549700 2215839 2215839 defendant Brussheford John   588901 588901 Brussheford, John, of Strete 0
4549701 2215839 2215839 defendant Benet William   588901 588901 Benet, William, of Strete 1
4551348 2216360 2216360 defendant atte Nasshe John   588901 588901 atte Nasshe, John, of Strete 0
4556394 2217938 2217938 defendant Baker John   588901 588901 Baker, John, of Strete 1
4562974 2219988 2219988 defendant Smyth John   588901 588901 Smyth, John, of Strete 5
4567917 2221538 2221538 defendant Bakere John   588901 588901 Bakere, John, of Strete 0
4581568 2225680 2225680 defendant Baker John   588901 588901 Baker, John, of Strete 0
4649436 2245886 2245886 plaintiff Voweler Thomas   588901 588901 Voweler, Thomas, of Strete 0
4661993 2249591 2249591 plaintiff Felp John   588901 588901 Felp, John, of Strete 0
4661995 2249592 2249592 plaintiff Felp John   588901 588901 Felp, John, of Strete 0
4661997 2249593 2249593 plaintiff Felp John   588901 588901 Felp, John, of Strete 0
4690855 2262672 2262672 plaintiff Wodehele Roger   588901 588901 Wodehele, Roger, of Strete, parson 0
4690858 2262672 2262672 defendant Richard-servant Arnold John   588901 588901 Richard-servant Arnold, John, of Strete 2
4716339 2270424 2270424 defendant Baker Richard tanner 588901 588901 Baker, Richard, of Strete, tanner 1
4716646 2270526 2270526 plaintiff Wodehele Roger   588901 588901 Wodehele, Roger, of Strete, parson 0
4978141 2350427 2350427 defendant Brian Walter husbandman 588901 588901 Brian, Walter, of Strete, husbandman 1
5139093 2397926 2397926 defendant Lax John   588901 588901 Lax, John, of Strete, parson 0
5150994 2401430 2401430 defendant Lax John   588901 588901 Lax, John, of Strete, parson 0
5185975 2411645 2411645 defendant Lax John   588901 588901 Lax, John, of Strete, parson 0
5185993 2411652 2411652 defendant Lax John   588901 588901 Lax, John, of Strete, parson 0
5205008 2417217 2417217 defendant Lax John   588901 588901 Lax, John, of Strete, parson 0
5326094 2452898 2452898 defendant Gerveys John husbandman 588901 588901 Gerveys, John, of Strete, husbandman 0
5326097 2452899 2452899 defendant Mey Richard husbandman 588901 588901 Mey, Richard, of Strete, husbandman 1
5380637 2469510 2469510 defendant Gerveys John husbandman 588901 588901 Gerveys, John, of Strete, husbandman 0
5380639 2469511 2469511 defendant Gerveys John husbandman 588901 588901 Gerveys, John, of Strete, husbandman 0
5475764 2497749 2497749 defendant Pympyll Thomas butcher 588901 588901 Pympyll, Thomas, of Strete, butcher 1
5513588 2509100 2509100 defendant Fryser Thomas husbandman 588901 588901 Fryser, Thomas, of Strete, husbandman 0
5633139 2554367 2554367 defendant Clouter John husbandman 588901 588901 Clouter, John, of Strete, husbandman 1

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