names

33 rows where place_id = 758680

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4455917 2186867 2186867 defendant Quyntyn John   758680 758680 Quyntyn, John, of Clakke 0
4464457 2189551 2189551 defendant Kyng William   758680 758680 Kyng, William, of Clakke 2
4473811 2192455 2192455 defendant Fissher William   758680 758680 Fissher, William, of Clakke 0
4532207 2210337 2210337 defendant Rogers John   758680 758680 Rogers, John, of Clakke 1
4547351 2215103 2215103 defendant Gaye John   758680 758680 Gaye, John, of Clakke 1
4547358 2215105 2215105 defendant Gore John   758680 758680 Gore, John, of Clakke 1
4564703 2220525 2220525 plaintiff Senare Alice   758680 758680 Senare, Alice, of Clakke 0
4648158 2245523 2245523 defendant Fisshere William   758680 758680 Fisshere, William, of Clakke 0
4680213 2259420 2259420 plaintiff Legardyn Mathew   758680 758680 Legardyn, Mathew, of Clakke 0
4685123 2260950 2260950 defendant Grene William husbandman 758680 758680 Grene, William, of Clakke, husbandman 0
4694985 2263925 2263925 defendant Hoper John   758680 758680 Hoper, John, of Clakke, hoop maker 0
4696708 2264448 2264448 plaintiff Chapman Richard   758680 758680 Chapman, Richard, of Clakke 0
4701311 2265809 2265809 plaintiff Fysshere William   758680 758680 Fysshere, William, of Clakke 0
4704127 2266669 2266669 plaintiff Houper William   758680 758680 Houper, William, of Clakke 0
4745303 2279139 2279139 plaintiff Fysthere William   758680 758680 Fysthere, William, of Clakke 0
4757456 2282708 2282708 defendant Croydon Robert husbandman 758680 758680 Croydon, Robert, of Clakke, husbandman 0
4779550 2289586 2289586 defendant Croydon Robert husbandman 758680 758680 together with Croydon, Robert, of Clakke, husbandman 1
4781129 2290106 2290106 plaintiff Cerney William   758680 758680 Cerney, William, of Clakke 0
4795664 2294797 2294797 defendant Smert John shoemaker 758680 758680 Smert, John, of Clakke, shoemaker 1
4824894 2303823 2303823 defendant Rogger John butcher 758680 758680 Rogger, John, of Clakke, butcher 1
4831462 2305871 2305871 defendant Rogger John butcher 758680 758680 Rogger, John, of Clakke, butcher 0
4891591 2324109 2324109 defendant atte Mille Robert husbandman 758680 758680 atte Mille, Robert, of Clakke, husbandman 0
4895387 2325219 2325219 defendant Hoper John hooper 758680 758680 Hoper, John, of Clakke, hooper 0
4964270 2346223 2346223 defendant Vyncent William   758680 758680 Vyncent, William, of Clakke, mason 1
5133477 2396283 2396283 defendant Hoper John weaver 758680 758680 Hoper, John, of Clakke, weaver 1
5147646 2400449 2400449 plaintiff Coke Ralph fishmonger 758680 758680 Coke, Ralph, of Clakke, fishmonger 0
5147648 2400450 2400450 plaintiff Coke Ralph fishmonger 758680 758680 Coke, Ralph, of Clakke, fishmonger 0
5161381 2404424 2404424 defendant Hay John yeoman 758680 758680 Hay, John, of Clakke, yeoman 0
5198691 2415371 2415371 defendant Haye John yeoman 758680 758680 Haye, John, of Clakke, yeoman 4
5210702 2418864 2418864 defendant Haye Johhn yeoman 758680 758680 Haye, Johhn, of Clakke, yeoman 6
5230703 2424592 2424592 defendant Broun Nicholas butcher 758680 758680 Broun, Nicholas, of Clakke, butcher 1
5375859 2468041 2468041 plaintiff Rogers Nicholas   758680 758680 Rogers, Nicholas, of Clakke 0
5621113 2550486 2550486 defendant Brewere Thomas   758680 758680 Brewere, Thomas, of Clakke 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);