names

63 rows where place_id = 603679

✎ 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
3655372 1911940 1911940 plaintiff Bonuyse Antonio merchant 603679 603679 Bonuyse, Antonio, of Luca, merchant 0
3656430 1912255 1912255 plaintiff Cavalari Antonio merchant 603679 603679 Cavalari, Antonio, of Luca, merchant 0
3670914 1916870 1916870 plaintiff Campwyche John   603679 603679 Campwyche, John, of Luca 0
4432148 2174840 2174840 plaintiff Choche Guy de la merchant 603679 603679 Choche, Guy de la, of Luca, merchant 0
4469627 2191165 2191165 plaintiff Bosano Bartholomew de merchant 603679 603679 Bosano, Bartholomew de, of Luca, merchant 0
4548475 2215465 2215465 plaintiff Christopher Angelus merchant 603679 603679 Christopher, Angelus, of Luca, merchant 0
4579798 2225169 2225169 plaintiff Cristofre Angelus merchant 603679 603679 Cristofre, Angelus, of Luca, merchant 0
4579801 2225170 2225170 plaintiff Cristofre Angelus merchant 603679 603679 Cristofre, Angelus, of Luca, merchant 0
4607898 2233588 2233588 plaintiff Boby Edmund merchant 603679 603679 Boby, Edmund, of Luca, merchant 0
4608526 2233773 2233773 plaintiff Bovy Gao merchant 603679 603679 Bovy, Gao, of Luca, merchant 0
4608528 2233774 2233774 plaintiff Bovy George merchant 603679 603679 Bovy, George, of Luca, merchant 0
4637443 2242503 2242503 plaintiff Bovy George merchant 603679 603679 Bovy, George, of Luca, merchant 0
5046453 2370581 2370581 plaintiff Michell Nicholas (legal representative) 603679 603679 Michell, Nicholas, of Luca, merchant, executor of 0
5048846 2371287 2371287 defendant Dane Mathew merchant 603679 603679 Dane, Mathew, of Luca, merchant 0
5138994 2397898 2397898 plaintiff Gentili Manfred merchant 603679 603679 Gentili, Manfred, of Luca, merchant 1
5155830 2402866 2402866 plaintiff Michell Francis merchant 603679 603679 Michell, Francis, of Luca, merchant 0
5155831 2402866 2402866 plaintiff Schiatis Bartholomew merchant 603679 603679 Schiatis, Bartholomew, of Luca, merchant 1
5159872 2403984 2403984 plaintiff Sciatis Bartholomew merchant 603679 603679 Sciatis, Bartholomew, of Luca, merchant 0
5159873 2403984 2403984 plaintiff Gentili Manfred merchant 603679 603679 Gentili, Manfred, of Luca, merchant 1
5172290 2407620 2407620 plaintiff Michell Francis merchant 603679 603679 Michell, Francis, of Luca, merchant 0
5172291 2407620 2407620 plaintiff Sciatis Bartholomew merchant 603679 603679 Sciatis, Bartholomew, of Luca, merchant 1
5174847 2408338 2408338 plaintiff Schiatis Bartholomew merchant 603679 603679 Schiatis, Bartholomew, of Luca, merchant 0
5174849 2408339 2408339 plaintiff Schiatis Bartholomew merchant 603679 603679 Schiatis, Bartholomew, of Luca, merchant 0
5174857 2408341 2408341 plaintiff Sciatis Bartholomew merchant 603679 603679 Sciatis, Bartholomew, of Luca, merchant 0
5174858 2408341 2408341 plaintiff Gentili Manfred merchant 603679 603679 Gentili, Manfred, of Luca, merchant 1
5191590 2413281 2413281 plaintiff Michell Francisco merchant 603679 603679 Michell, Francisco, of Luca, merchant 0
5191591 2413281 2413281 plaintiff Schiatis Bartholomew   603679 603679 Schiatis, Bartholomew, of Luca 1
5195691 2414483 2414483 plaintiff Schiatus Bartholomew merchant 603679 603679 Schiatus, Bartholomew, of Luca, merchant 0
5195708 2414487 2414487 plaintiff Sciatis Bartholomew merchant 603679 603679 Sciatis, Bartholomew, of Luca, merchant 0
5195709 2414487 2414487 plaintiff Gentili Manfred merchant 603679 603679 Gentili, Manfred, of Luca, merchant 1
5267816 2435696 2435696 plaintiff (illegible)     603679 603679 ----, of Luca 0
5271236 2436680 2436680 plaintiff Gentili Humphrey merchant 603679 603679 Gentili, Humphrey, of Luca, merchant 0
5271239 2436681 2436681 plaintiff Gentili Humphrey merchant 603679 603679 Gentili, Humphrey, of Luca, merchant 0
5271241 2436682 2436682 plaintiff Gentili Humphrey merchant 603679 603679 Gentili, Humphrey, of Luca, merchant 0
5271243 2436683 2436683 plaintiff Gentili Manfred merchant 603679 603679 Gentili, Manfred, of Luca, merchant 0
5271248 2436685 2436685 plaintiff Gentilis Humphrey merchant 603679 603679 Gentilis, Humphrey, of Luca, merchant 0
5275006 2437770 2437770 plaintiff Schiatis Bartholomew merchant 603679 603679 Schiatis, Bartholomew, of Luca, merchant 0
5275007 2437770 2437770 plaintiff Gentili Humphrey merchant 603679 603679 Gentili, Humphrey, of Luca, merchant 1
5275202 2437824 2437824 plaintiff Shiatis Bartholomew merchant 603679 603679 Shiatis, Bartholomew, of Luca, merchant 0
5275204 2437825 2437825 plaintiff Shiatis Bartholomew merchant 603679 603679 Shiatis, Bartholomew, of Luca, merchant 0
5275205 2437825 2437825 plaintiff Gentilis Manfred alias Humphrey merchant 603679 603679 Gentilis, Manfred alias Humphrey, of Luca, merchant 1
5275209 2437826 2437826 plaintiff Shiatis Bartholomew merchant 603679 603679 Shiatis, Bartholomew, of Luca, merchant 0
5275210 2437826 2437826 plaintiff Gentilis Manfred alias Humphrey merchant 603679 603679 Gentilis, Manfred alias Humphrey, of Luca, merchant 1
5303064 2445906 2445906 plaintiff Gentili Manfred merchant 603679 603679 Gentili, Manfred, of Luca, merchant 0
5308708 2447642 2447642 plaintiff Gentill Humphrey merchant 603679 603679 Gentill, Humphrey, of Luca, merchant 1
5308710 2447643 2447643 plaintiff Shyatis Bartholomew merchant 603679 603679 Shyatis, Bartholomew, of Luca, merchant 0
5308711 2447643 2447643 plaintiff Gentill Humphrey merchant 603679 603679 Gentill, Humphrey, of Luca, merchant 1
5373662 2467361 2467361 plaintiff Michell Michael merchant 603679 603679 Michell, Michael, of Luca, merchant 0
5388041 2471638 2471638 plaintiff Gentill Humphrey   603679 603679 Gentill, Humphrey, of Luca 0
5409881 2477925 2477925 plaintiff Bounysy Ludovicus merchant 603679 603679 Bounysy, Ludovicus, of Luca, merchant 0
5423398 2481959 2481959 plaintiff Bonnysy Lewis merchant 603679 603679 Bonnysy, Lewis, of Luca, merchant 0
5423527 2482000 2482000 plaintiff Bounysy Lewis merchant 603679 603679 Bounysy, Lewis, of Luca, merchant 0
5441414 2487351 2487351 plaintiff _ll Nicholas   603679 603679 _ll, Nicholas, of Luca 0
5441415 2487351 2487351 plaintiff Bonvysy Lewis merchant 603679 603679 Bonvysy, Lewis, of Luca, merchant 1
5442704 2487730 2487730 plaintiff Bonevyse Ludovicus merchant 603679 603679 Bonevyse, Ludovicus, of Luca, merchant 0
5455395 2491527 2491527 plaintiff Bonewyse Lewis merchant 603679 603679 Bonewyse, Lewis, of Luca, merchant 0
5461295 2493324 2493324 plaintiff Michell Michael merchant 603679 603679 Michell, Michael, of Luca, merchant 0
5461296 2493324 2493324 plaintiff Bonnysy Lewis merchant 603679 603679 Bonnysy, Lewis, of Luca, merchant 1
5467230 2495143 2495143 plaintiff Bonewise Lewis merchant 603679 603679 Bonewise, Lewis, of Luca, merchant 0
5470445 2496080 2496080 plaintiff Giglys Sebastian merchant 603679 603679 Giglys, Sebastian, of Luca, merchant 1
5472922 2496858 2496858 plaintiff Michell Michael merchant 603679 603679 Michell, Michael, of Luca, merchant 0
5472923 2496858 2496858 plaintiff Bomry Lewis merchant 603679 603679 Bomry, Lewis, of Luca, merchant 1
5619647 2550001 2550001 plaintiff Portico Guido de   603679 603679 Portico, Guido de, of Luca 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);