names

35 rows where place_id = 776667

✎ 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
4636301 2242188 2242188 plaintiff Ballby Franciscus merchant 776667 776667 Ballby, Franciscus, of Venice, merchant 0
4696545 2264394 2264394 defendant Dode Antonius merchant 776667 776667 Dode, Antonius, of Venice, merchant 0
4922152 2333341 2333341 defendant Spanula Antonio merchant 776667 776667 Spanula, Antonio, of Venice, merchant 0
4951375 2342393 2342393 defendant Bosykke Dominic mariner 776667 776667 Bosykke, Dominic, of Venice, mariner 1
4951376 2342393 2342393 defendant de Danyell Nicholas mariner 776667 776667 de Danyell, Nicholas, of Venice, mariner 2
4951377 2342393 2342393 defendant Motefo Nicholas mariner 776667 776667 Motefo, Nicholas, of Venice, mariner 3
5041859 2369164 2369164 plaintiff Cormerus Federicus merchant 776667 776667 Cormerus, Federicus, of Venice, merchant 0
5041861 2369165 2369165 plaintiff Corner or Corver Frederic merchant 776667 776667 Corner or Corver, Frederic, of Venice, merchant 0
5042157 2369263 2369263 plaintiff Cuner Francisco merchant 776667 776667 Cuner, Francisco, of Venice, merchant 0
5046294 2370524 2370524 plaintiff Maunche or Mannche John merchant 776667 776667 Maunche or Mannche, John, of Venice, merchant 0
5128659 2394864 2394864 plaintiff Conteryn Bertucio merchant 776667 776667 Conteryn, Bertucio, of Venice, merchant 0
5135853 2397000 2397000 plaintiff Moresyn Anthony merchant 776667 776667 Moresyn, Anthony, of Venice, merchant 0
5153658 2402226 2402226 plaintiff Justman Dardo merchant 776667 776667 Justman, Dardo, of Venice, merchant 1
5156131 2402953 2402953 plaintiff Moresyn Anthony merchant 776667 776667 Moresyn, Anthony, of Venice, merchant 0
5170990 2407240 2407240 plaintiff Justinian Humphrey merchant 776667 776667 Justinian, Humphrey, of Venice, merchant 0
5170991 2407240 2407240 plaintiff Justinian Dardus merchant 776667 776667 Justinian, Dardus, of Venice, merchant 1
5172446 2407668 2407668 plaintiff Morsyn Anthony merchant 776667 776667 Morsyn, Anthony, of Venice, merchant 0
5173903 2408065 2408065 plaintiff Pounte Nicholas de merchant 776667 776667 Pounte, Nicholas de, of Venice, merchant 0
5186692 2411854 2411854 plaintiff Gryt Homobono merchant 776667 776667 Gryt, Homobono, of Venice, merchant 0
5186693 2411854 2411854 plaintiff Justinano Humphrey merchant 776667 776667 Justinano, Humphrey, of Venice, merchant 1
5186696 2411855 2411855 plaintiff Gryt Homobono merchant 776667 776667 Gryt, Homobono, of Venice, merchant 0
5186697 2411855 2411855 plaintiff Justinanus Humphrey merchant 776667 776667 Justinanus, Humphrey, of Venice, merchant 1
5189137 2412555 2412555 plaintiff Justinano Dardus merchant 776667 776667 Justinano, Dardus, of Venice, merchant 0
5189139 2412556 2412556 plaintiff Justinian Dardus merchant 776667 776667 Justinian, Dardus, of Venice, merchant 0
5204403 2417037 2417037 plaintiff Eryt or Gryt Homobonus or Homeltonus merchant 776667 776667 Eryt or Gryt, Homobonus or Homeltonus, of Venice, merchant 0
5204404 2417037 2417037 plaintiff Justinanus Humphrey merchant 776667 776667 Justinanus, Humphrey, of Venice, merchant 1
5205263 2417295 2417295 plaintiff Grit Homobonus merchant 776667 776667 Grit, Homobonus, of Venice, merchant 0
5205264 2417295 2417295 plaintiff Justinanus Humphrey merchant 776667 776667 Justinanus, Humphrey, of Venice, merchant 1
5206386 2417602 2417602 plaintiff Justinano Dardo merchant 776667 776667 Justinano, Dardo, of Venice, merchant 0
5206388 2417603 2417603 plaintiff Justinanus Dardus merchant 776667 776667 Justinanus, Dardus, of Venice, merchant 0
5270271 2436406 2436406 plaintiff de Peysaro Marcus merchant 776667 776667 de Peysaro, Marcus, of Venice, merchant 0
5270274 2436407 2436407 plaintiff de Peysaro Marcus merchant 776667 776667 de Peysaro, Marcus, of Venice, merchant 0
5276234 2438118 2438118 plaintiff Vatacins Peter merchant 776667 776667 Vatacins, Peter, of Venice, merchant 0
5450396 2490006 2490006 plaintiff Priorli Francis de merchant 776667 776667 Priorli, Francis de, of Venice, merchant 0
5462553 2493712 2493712 plaintiff Prioli Franciscus de merchant 776667 776667 Prioli, Franciscus de, of Venice, merchant 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);