names

42 rows where place_id = 759132

✎ 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
4457723 2187426 2187426 defendant Lentestre or Leicestre Thomas   759132 759132 Lentestre or Leicestre, Thomas, of Fissherton 2
4459373 2187984 2187984 plaintiff Russell Nicholas   759132 759132 Russell, Nicholas, of Fissherton Ancher 0
4562268 2219769 2219769 defendant Dounton Walter   759132 759132 Dounton, Walter, of Fissherton 0
4582099 2225838 2225838 defendant Mulborne John   759132 759132 Mulborne, John, of Fissherton Anchier 0
4588344 2227745 2227745 defendant Mulborne John   759132 759132 Mulborne, John, of Fissherton Ancher 0
4598490 2230764 2230764 defendant Mercer Stephen   759132 759132 Mercer, Stephen, of Fissherton 0
4619490 2237088 2237088 defendant Russell Roger   759132 759132 Russell, Roger, of Fissherton 0
4655020 2247452 2247452 defendant Marleburgh Thomas hosteler 759132 759132 Marleburgh, Thomas, of Fissherton Ancher, hosteler 0
4809457 2299134 2299134 defendant Ballard William laborer 759132 759132 Ballard, William, of Fissherton Ancher, laborer 1
4825977 2304158 2304158 plaintiff Waloppe John   759132 759132 Waloppe, John, of Fissherton Ancher, mason, on his own account 0
4855065 2312934 2312934 defendant Funtell Agnes widow 759132 759132 Funtell, Agnes, of Fissherton Ahcner, widow 2
4899169 2326382 2326382 defendant Selby Robert yeoman 759132 759132 Selby, Robert, of Fissherton Ancher, yeoman 0
4919078 2332478 2332478 defendant Popyngay John husbandman 759132 759132 Popyngay, John, of Fissherton, husbandman 3
4929377 2335605 2335605 defendant Selby Robert yeoman 759132 759132 Selby, Robert, of Fissherton Ancher, yeoman 2
4931006 2336095 2336095 defendant Skynner William husbandman 759132 759132 Skynner, William, of Fissherton Anger, husbandman 2
4934339 2337129 2337129 defendant Russell William gent 759132 759132 Russell, William, of Fissherton Ancher, gent 1
4934675 2337236 2337236 defendant Bromler John baker 759132 759132 Bromler, John, of Fissherton Ancher, baker 0
4944698 2340328 2340328 defendant Whittok Simon weaver 759132 759132 Whittok, Simon, of Fissherton Ahcner, weaver 0
4948177 2341403 2341403 defendant Selby Robert yeoman 759132 759132 Selby, Robert, of Fissherton Ancher, yeoman 0
4949745 2341912 2341912 defendant Rede John husbandman 759132 759132 Rede, John, of Fissherton Ancher, husbandman 6
4953144 2342906 2342906 defendant Combe John clerk 759132 759132 Combe, John, of Fissherton Ancher, clerk 0
4953145 2342906 2342906 defendant Peny Richard husbandman 759132 759132 Peny, Richard, of Fissherton Ancher, husbandman 1
4953146 2342906 2342906 defendant Peny John husbandman 759132 759132 Peny, John, of Fissherton Ancher, husbandman 2
4953147 2342906 2342906 defendant Foxham John husbandman 759132 759132 Foxham, John, of Fissherton Ancher, husbandman 3
4953148 2342906 2342906 defendant Preston John husbandman 759132 759132 Preston, John, of Fissherton Ancher, husbandman 4
4953179 2342912 2342912 defendant Sylke John husbandman 759132 759132 Sylke, John, of Fissherton, husbandman 0
4954844 2343404 2343404 defendant Selby Robert   759132 759132 Selby, Robert, of Fissherton Ancher, bailiff 0
4976614 2349963 2349963 defendant Fox John hosier 759132 759132 Fox, John, of Fissherton Ancher, hosier 1
4977282 2350160 2350160 defendant Russell William gent 759132 759132 Russell, William, of Fissherton Aunger, gent 0
4982049 2351546 2351546 defendant Martyn William husbandman 759132 759132 Martyn, William, of Fissherton Ancher, husbandman 3
4985734 2352650 2352650 defendant Whitkok Simon ostler 759132 759132 Whitkok, Simon, of Fissherton Ancher, ostler 0
5001130 2357207 2357207 defendant Whitcok Simon weaver 759132 759132 Whitcok, Simon, of Fissherton Ancher, weaver 1
5003420 2357897 2357897 defendant Balfot William husbandman 759132 759132 Balfot, William, of Fissherton Ancher, husbandman 0
5013729 2360860 2360860 defendant Bremler John brewer 759132 759132 Bremler, John, of Fissherton Ancher, brewer 0
5036175 2367435 2367435 defendant Bremler John baker 759132 759132 Bremler, John, of Fissherton Ancher, baker 1
5037360 2367799 2367799 defendant Felde Nicholas husbandman 759132 759132 Felde, Nicholas, of Fissherton Ancher, husbandman 2
5059937 2374536 2374536 defendant Hebbe John yeoman 759132 759132 Hebbe, John, of Fissherton Ancher, yeoman 0
5508709 2507581 2507581 defendant Persons Robert yeoman 759132 759132 Persons, Robert, of Fissherton Ancher, yeoman 3
5540692 2517219 2517219 defendant Payne John sherman 759132 759132 Payne, John, of Fissherton Anger, sherman 0
5626188 2552159 2552159 defendant Milborne John gent 759132 759132 Milborne, John, of Fissherton Ancher, gent 0
5635111 2554960 2554960 defendant Ballar John fisher 759132 759132 Ballar, John, of Fissherton Ancher, fisher 7
5635112 2554960 2554960 defendant Horn John summoner 759132 759132 Horn, John, of Fissherton Ancher, summoner 8

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