names

34 rows where place_id = 772637

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4591299 2228634 2228634 defendant Stephen John   772637 772637 Stephen, John, of Great Toryton 2
4749448 2280318 2280318 defendant Cook John clerk 772637 772637 Cook, John, of Great Toryton, clerk 2
5041830 2369154 2369154 defendant Carpenter William husbandman 772637 772637 Carpenter, William, of Great Toryton, husbandman 0
5041832 2369154 2369154 defendant Yeme Nicholas shoemaker 772637 772637 Yeme, Nicholas, of Great Toryton, shoemaker 2
5366155 2465079 2465079 defendant Blaket John yeoman 772637 772637 Blaket, John, of Great Toryton, yeoman 0
5366156 2465079 2465079 defendant Baker John tanner 772637 772637 Baker, John, of Great Toryton, tanner 1
5366157 2465079 2465079 defendant Campe Oto miller 772637 772637 Campe, Oto, of Great Toryton, miller 2
5374663 2467671 2467671 defendant Blaket John yeoman 772637 772637 Blaket, John, of Great Toryton, yeoman 0
5374664 2467671 2467671 defendant Hyne John weaver 772637 772637 Hyne, John, of Great Toryton, weaver 1
5384833 2470737 2470737 defendant Campe Otto miller 772637 772637 Campe, Otto, of Great Toryton, miller 1
5386417 2471186 2471186 defendant Chope Nicholas dyer 772637 772637 Chope, Nicholas, of Great Toryton, dyer 2
5391278 2472584 2472584 defendant Blaket John yeoman 772637 772637 Blaket, John, of Great Toryton, yeoman 0
5396848 2474184 2474184 defendant Baker John tanner 772637 772637 Baker, John, of Great Toryton, tanner 1
5396852 2474185 2474185 defendant Blaket John yeoman 772637 772637 Blaket, John, of Great Toryton, yeoman 0
5396853 2474185 2474185 defendant Baker John tanner 772637 772637 Baker, John, of Great Toryton, tanner 1
5398700 2474694 2474694 defendant Chope Nicholas dyer 772637 772637 Chope, Nicholas, of Great Toryton, dyer 2
5398706 2474696 2474696 defendant Chope Nicholas dyer 772637 772637 Chope, Nicholas, of Great Toryton, dyer 2
5401105 2475379 2475379 defendant Heyn Richard husbandman 772637 772637 Heyn, Richard, of Great Toryton, husbandman 1
5404249 2476292 2476292 defendant Blaket John yeoman 772637 772637 Blaket, John, of Great Toryton, yeoman 0
5404250 2476292 2476292 defendant Hyme John   772637 772637 Hyme, John, of Great Toryton 1
5404252 2476293 2476293 defendant Blaket John yeoman 772637 772637 Blaket, John, of Great Toryton, yeoman 0
5404253 2476293 2476293 defendant Hyne John weaver 772637 772637 Hyne, John, of Great Toryton, weaver 1
5414082 2479148 2479148 defendant Gate Roger tanner 772637 772637 Gate, Roger, of Great Toryton, tanner 0
5414119 2479157 2479157 defendant Leche Robert husbandman 772637 772637 Leche, Robert, of Great Toryton, husbandman 0
5414120 2479157 2479157 defendant Heydon Richard   772637 772637 Heydon, Richard, of Great Toryton 1
5423761 2482071 2482071 defendant Clerke John husbandman 772637 772637 Clerke, John, of Great Toryton, husbandman 4
5423762 2482071 2482071 defendant Clerke Richard tailor 772637 772637 Clerke, Richard, of Great Toryton, tailor 5
5423764 2482071 2482071 defendant Deare Richard butcher 772637 772637 Deare, Richard, of Great Toryton, butcher 7
5423765 2482071 2482071 defendant Buryman John   772637 772637 Buryman, John, of Great Toryton, hoop maker 8
5423767 2482071 2482071 defendant Rede John husbandman 772637 772637 Rede, John, of Great Toryton, husbandman 10
5429730 2483830 2483830 defendant Gate Roger tanner 772637 772637 Gate, Roger, of Great Toryton, tanner 0
5429732 2483831 2483831 defendant Morcombe John smith 772637 772637 Morcombe, John, of Great Toryton, smith 0
5429733 2483831 2483831 defendant Bastard William smith 772637 772637 Bastard, William, of Great Toryton, smith 1
5444443 2488244 2488244 defendant Chope Nicholas dyer 772637 772637 Chope, Nicholas, of Great Toryton, dyer 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);