names

93 rows where place_id = 594477

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3616273 1872731 1872731 plaintiff de Marnus Geoffrey merchant 594477 594477 de Marnus, Geoffrey, of Genoa, merchant 0
3657730 1912669 1912669 plaintiff de Ponte Jacob (legal representative) 594477 594477 de Ponte, Jacob, of Genoa, merchant, executor of 0
3657731 1912669 1912669 plaintiff Pansano Francisco merchant 594477 594477 Pansano, Francisco, of Genoa, merchant 1
3657733 1912670 1912670 plaintiff de Ponte Jacob (legal representative) 594477 594477 de Ponte, Jacob, of Genoa, merchant, executor of 0
3657734 1912670 1912670 plaintiff Pansano Francisco merchant 594477 594477 Pansano, Francisco, of Genoa, merchant 1
3657742 1912673 1912673 plaintiff de Vivaldi Anthonio merchant 594477 594477 de Vivaldi, Anthonio, of Genoa, merchant 0
3657746 1912674 1912674 plaintiff de Vivaldis Anthonio merchant 594477 594477 de Vivaldis, Anthonio, of Genoa, merchant 0
3657748 1912675 1912675 plaintiff de Vivaldis Antonio merchant 594477 594477 de Vivaldis, Antonio, of Genoa, merchant 0
3662161 1914083 1914083 plaintiff Marnffo Raphael merchant 594477 594477 Marnffo, Raphael, of Genoa, merchant 0
3662219 1914101 1914101 plaintiff Maruffo Raphael merchant 594477 594477 Maruffo, Raphael, of Genoa, merchant 0
3662223 1914102 1914102 plaintiff Maruffo Raphael merchant 594477 594477 Maruffo, Raphael, of Genoa, merchant 0
3662228 1914103 1914103 plaintiff Maruffo Raphael merchant 594477 594477 Maruffo, Raphael, of Genoa, merchant 0
3662230 1914104 1914104 plaintiff Maruffo Raphael merchant 594477 594477 Maruffo, Raphael, of Genoa, merchant 0
3662234 1914105 1914105 plaintiff Maruffo Raphael merchant 594477 594477 Maruffo, Raphael, of Genoa, merchant 0
3662238 1914106 1914106 plaintiff Maruffo Raphael merchant 594477 594477 Maruffo, Raphael, of Genoa, merchant 0
3662244 1914107 1914107 plaintiff Maruffo Raphael merchant 594477 594477 Maruffo, Raphael, of Genoa, merchant 0
3662249 1914108 1914108 plaintiff Maruffo Raphael merchant 594477 594477 Maruffo, Raphael, of Genoa, merchant 0
3662251 1914109 1914109 plaintiff Maruffo Raphael merchant 594477 594477 Maruffo, Raphael, of Genoa, merchant 0
3662253 1914110 1914110 plaintiff Maruffo Raphael merchant 594477 594477 Maruffo, Raphael, of Genoa, merchant 0
3662259 1914111 1914111 plaintiff Maruffo Raphaell   594477 594477 Maruffo, Raphaell, of Genoa 0
3662263 1914112 1914112 plaintiff Maruffo Raphaell   594477 594477 Maruffo, Raphaell, of Genoa 0
3664582 1914877 1914877 plaintiff Salvage Sebastian merchant 594477 594477 Salvage, Sebastian, of Genoa, merchant 0
3931315 2000764 2000764 plaintiff de Marynes Maurice   594477 594477 de Marynes, Maurice, of Genoa, merchant, alias Morris the mariner 0
4561299 2219485 2219485 defendant Mare Anthony de la merchant 594477 594477 Mare, Anthony de la, of Genoa, merchant 0
4923152 2333659 2333659 plaintiff Marchexan Percival merchant 594477 594477 Marchexan, Percival, of Genoa, merchant, on his own account 0
4923153 2333659 2333659 defendant Marchexan Percival merchant 594477 594477 Marchexan, Percival, of Genoa, merchant, on his own account 0
4923154 2333660 2333660 plaintiff Marchexan Percival merchant 594477 594477 Marchexan, Percival, of Genoa, merchant, on his own account 0
4928846 2335444 2335444 plaintiff Spinell Andrew merchant 594477 594477 Spinell, Andrew, of Genoa, merchant 0
4928850 2335445 2335445 plaintiff Spinelli Andrew merchant 594477 594477 Spinelli, Andrew, of Genoa, merchant 0
4928852 2335445 2335445 defendant Spinelli Andrew merchant 594477 594477 Spinelli, Andrew, of Genoa, merchant 0
4928854 2335446 2335446 plaintiff Spinelli Baptist merchant 594477 594477 Spinelli, Baptist, of Genoa, merchant 0
4928855 2335446 2335446 plaintiff Spinelli Andrew merchant 594477 594477 Spinelli, Andrew, of Genoa, merchant 1
4928858 2335447 2335447 plaintiff Spinelli Baptist merchant 594477 594477 Spinelli, Baptist, of Genoa, merchant 0
4928859 2335447 2335447 plaintiff Spinelli Andrew   594477 594477 Spinelli, Andrew, of Genoa, merchant, on their own account 1
4928860 2335447 2335447 defendant Spinelli Baptist merchant 594477 594477 Spinelli, Baptist, of Genoa, merchant 0
4928861 2335447 2335447 defendant Spinelli Andrew   594477 594477 Spinelli, Andrew, of Genoa, merchant, on their own account 1
4990278 2354000 2354000 plaintiff Catano Gregory   594477 594477 Catano, Gregory, of Genoa 0
4990280 2354001 2354001 plaintiff Catayn Christopher merchant 594477 594477 Catayn, Christopher, of Genoa, merchant 0
5000793 2357108 2357108 plaintiff Marcheganus Percival merchant 594477 594477 Marcheganus, Percival, of Genoa, merchant 0
5000799 2357110 2357110 plaintiff Marchexanus Percival merchant 594477 594477 Marchexanus, Percival, of Genoa, merchant 0
5007402 2359059 2359059 plaintiff Spynell Benedict (legal representative) 594477 594477 Spynell, Benedict, of Genoa, merchant, executors of 0
5007413 2359063 2359063 plaintiff Spynnla Benedict (legal representative) 594477 594477 Spynnla, Benedict, of Genoa, merchant, executors of 0
5010154 2359834 2359834 plaintiff Lercarius Baldasar merchant 594477 594477 Lercarius, Baldasar, of Genoa, merchant 1
5040824 2368872 2368872 plaintiff Cataneus Franco merchant 594477 594477 Cataneus, Franco, of Genoa, merchant 1
5040827 2368873 2368873 plaintiff Cataneus Christopher merchant 594477 594477 Cataneus, Christopher, of Genoa, merchant 0
5040829 2368874 2368874 plaintiff Cataneus Christopher merchant 594477 594477 Cataneus, Christopher, of Genoa, merchant 0
5040830 2368874 2368874 plaintiff Cataneus Francis merchant 594477 594477 Cataneus, Francis, of Genoa, merchant 1
5042337 2369314 2369314 plaintiff de Fagnano Felix merchant 594477 594477 de Fagnano, Felix, of Genoa, merchant 0
5042338 2369314 2369314 plaintiff de Catanes Francisco merchant 594477 594477 de Catanes, Francisco, of Genoa, merchant 1
5049541 2371492 2371492 plaintiff Spynull Ciprianus merchant 594477 594477 Spynull, Ciprianus, of Genoa, merchant 0
5125213 2393852 2393852 plaintiff Catan Hugh merchant 594477 594477 Catan, Hugh, of Genoa, merchant 1
5127743 2394595 2394595 plaintiff Spynell Neapolitanus merchant 594477 594477 Spynell, Neapolitanus, of Genoa, merchant 1
5127849 2394623 2394623 plaintiff Centurion Antonius merchant 594477 594477 Centurion, Antonius, of Genoa, merchant 0
5133783 2396372 2396372 plaintiff Justinian Dardo merchant 594477 594477 Justinian, Dardo, of Genoa, merchant 1
5139843 2398129 2398129 plaintiff Spynell Dun--ius merchant 594477 594477 Spynell, Dun--ius, of Genoa, merchant 0
5139844 2398129 2398129 plaintiff Spynell Ciprius merchant 594477 594477 Spynell, Ciprius, of Genoa, merchant 1
5146889 2400230 2400230 plaintiff Centurion Anthony merchant 594477 594477 Centurion, Anthony, of Genoa, merchant 0
5146892 2400231 2400231 plaintiff Centurion Galeottus merchant 594477 594477 Centurion, Galeottus, of Genoa, merchant 0
5146894 2400232 2400232 plaintiff Centurion Galeottus merchant 594477 594477 Centurion, Galeottus, of Genoa, merchant 0
5146896 2400233 2400233 plaintiff Centurion Galeottus merchant 594477 594477 Centurion, Galeottus, of Genoa, merchant 0
5146897 2400233 2400233 plaintiff Centurion Lionell merchant 594477 594477 Centurion, Lionell, of Genoa, merchant 1
5146899 2400234 2400234 plaintiff Centurion Galiotus merchant 594477 594477 Centurion, Galiotus, of Genoa, merchant 0
5146901 2400235 2400235 plaintiff Centurion Galiotus merchant 594477 594477 Centurion, Galiotus, of Genoa, merchant 0
5146903 2400236 2400236 plaintiff Centuryon Antonio merchant 594477 594477 Centuryon, Antonio, of Genoa, merchant 0
5154711 2402532 2402532 plaintiff Lomelyn John merchant 594477 594477 Lomelyn, John, of Genoa, merchant 0
5154712 2402532 2402532 plaintiff Lomelyn Osbert merchant 594477 594477 Lomelyn, Osbert, of Genoa, merchant 1
5159688 2403936 2403936 plaintiff Salnego Augustine merchant 594477 594477 Salnego, Augustine, of Genoa, merchant 0
5159689 2403936 2403936 plaintiff Caton Jugo or Ingo merchant 594477 594477 Caton, Jugo or Ingo, of Genoa, merchant 1
5166804 2406017 2406017 plaintiff Centurion Anthony merchant 594477 594477 Centurion, Anthony, of Genoa, merchant 0
5166807 2406018 2406018 plaintiff Centurion Galiottus merchant 594477 594477 Centurion, Galiottus, of Genoa, merchant 0
5166809 2406019 2406019 plaintiff Centurion Galiottus merchant 594477 594477 Centurion, Galiottus, of Genoa, merchant 0
5166811 2406020 2406020 plaintiff Centuryon Galeottus merchant 594477 594477 Centuryon, Galeottus, of Genoa, merchant 0
5166812 2406020 2406020 plaintiff Centurion Lionel merchant 594477 594477 Centurion, Lionel, of Genoa, merchant 1
5181818 2410427 2410427 plaintiff Catanei Leonard (legal representative) 594477 594477 Catanei, Leonard, of Genoa, merchant, administrator of 0
5181824 2410428 2410428 plaintiff Cataner Leonard (legal representative) 594477 594477 Cataner, Leonard, of Genoa, merchant, administrator of 0
5181888 2410450 2410450 plaintiff Centurion Galeottus merchant 594477 594477 Centurion, Galeottus, of Genoa, merchant 0
5181890 2410451 2410451 plaintiff Centurion Galeottus merchant 594477 594477 Centurion, Galeottus, of Genoa, merchant 0
5181891 2410451 2410451 plaintiff Centurion Lionell merchant 594477 594477 Centurion, Lionell, of Genoa, merchant 1
5181893 2410452 2410452 plaintiff Centuryon Antonio merchant 594477 594477 Centuryon, Antonio, of Genoa, merchant 0
5203105 2416670 2416670 plaintiff Cataneo Leonardo (legal representative) 594477 594477 Cataneo, Leonardo, of Genoa, administrator of 0
5203138 2416678 2416678 plaintiff Centurion Antonius merchant 594477 594477 Centurion, Antonius, of Genoa, merchant 0
5209298 2418453 2418453 plaintiff Salvago Augustus merchant 594477 594477 Salvago, Augustus, of Genoa, merchant 0
5209763 2418592 2418592 plaintiff Spynelli Demetrius merchant 594477 594477 Spynelli, Demetrius, of Genoa, merchant 0
5209764 2418592 2418592 plaintiff Spynelli Ciprianus merchant 594477 594477 Spynelli, Ciprianus, of Genoa, merchant 1
5209766 2418593 2418593 plaintiff Spynelli Demetrius merchant 594477 594477 Spynelli, Demetrius, of Genoa, merchant 0
5209767 2418593 2418593 plaintiff Spynelli Ciprianus merchant 594477 594477 Spynelli, Ciprianus, of Genoa, merchant 1
5221098 2421876 2421876 plaintiff Lacanelius Anthony   594477 594477 Lacanelius, Anthony, of Genoa 0
5221371 2421950 2421950 plaintiff Lecanelus Anthony   594477 594477 Lecanelus, Anthony, of Genoa 0
5470784 2496187 2496187 plaintiff Grillo Lawrence merchant 594477 594477 Grillo, Lawrence, of Genoa, merchant 0
5470787 2496188 2496188 plaintiff Grillo Lawrence merchant 594477 594477 Grillo, Lawrence, of Genoa, merchant 0
5470788 2496188 2496188 plaintiff Lertharius John Francis merchant 594477 594477 Lertharius, John Francis, of Genoa, merchant 1
5470790 2496189 2496189 plaintiff Grillo Lawrence merchant 594477 594477 Grillo, Lawrence, of Genoa, merchant 0
5470791 2496189 2496189 plaintiff Lertharius John Francis merchant 594477 594477 Lertharius, John Francis, of Genoa, merchant 1

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