names

99 rows where place_id = 604340

✎ 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
3657704 1912660 1912660 plaintiff de Berd Remerus merchant 604340 604340 de Berd, Remerus, of Florence, merchant 0
3657705 1912660 1912660 plaintiff de Berd Peter merchant 604340 604340 de Berd, Peter, of Florence, merchant 1
3657724 1912667 1912667 plaintiff de Pelli Barnardo merchant 604340 604340 de Pelli, Barnardo, of Florence, merchant 0
3657725 1912667 1912667 plaintiff Rowse John merchant 604340 604340 Rowse, John, of Florence, merchant 1
3657727 1912668 1912668 plaintiff de Pilli Barnardo merchant 604340 604340 de Pilli, Barnardo, of Florence, merchant 0
3657728 1912668 1912668 plaintiff Rowse John merchant 604340 604340 Rowse, John, of Florence, merchant 1
3658925 1913053 1913053 plaintiff Friscobaldi Leonardo merchant 604340 604340 Friscobaldi, Leonardo, of Florence, merchant 0
3955238 2008897 2008897 plaintiff Manelli Angelus   604340 604340 Manelli, Angelus, of Florence 0
4414566 2169460 2169460 plaintiff Dyne James   604340 604340 Dyne, James, of Florence 0
4422196 2171813 2171813 plaintiff Dyne James   604340 604340 Dyne, James, of Florence 0
4432794 2175013 2175013 plaintiff Dyne James   604340 604340 Dyne, James, of Florence 0
4437419 2176450 2176450 defendant Dyne James   604340 604340 Dyne, James, of Florence 0
4450258 2185039 2185039 defendant Bernard Paul (legal representative) 604340 604340 Bernard, Paul, of Florence, merchant, executors of 0
4471833 2191854 2191854 defendant Catticant Verus   604340 604340 Catticant, Verus, of Florence 0
4492710 2198421 2198421 plaintiff Alberti Gerard de member of the Guild of Albertines 604340 604340 Alberti, Gerard de, of Florence, member of the Guild of Albertines, on his own account 0
4492715 2198423 2198423 plaintiff Albertis Philip   604340 604340 Albertis, Philip, of Florence 1
4492718 2198424 2198424 plaintiff Albertis Philip   604340 604340 Albertis, Philip, of Florence 1
4666840 2255354 2255354 plaintiff Albertis Alexander de merchant 604340 604340 Albertis, Alexander de, of Florence, merchant 0
4666841 2255354 2255354 plaintiff Morellys Walbert   604340 604340 Morellys, Walbert, of Florence, merchant, on their own accounts 1
4706889 2267535 2267535 defendant John Alexander broker 604340 604340 John, Alexander, of Florence, merchant, alias of London, broker 0
4713375 2269506 2269506 plaintiff Villani Dominic merchant 604340 604340 Villani, Dominic, of Florence, merchant 1
4730481 2274730 2274730 defendant John Alexander merchant & broker 604340 604340 John, Alexander, of Florence, merchant & broker 0
4730483 2274731 2274731 defendant John Alexander merchant & broker 604340 604340 John, Alexander, of Florence, merchant & broker 0
4754848 2281895 2281895 plaintiff Albertis Philip merchant 604340 604340 Albertis, Philip, of Florence, merchant 0
4754849 2281895 2281895 plaintiff Morellis Paul de merchant 604340 604340 Morellis, Paul de, of Florence, merchant & "genperavus" of John de Florence, merchant 1
4774172 2287905 2287905 plaintiff Turnabone Stephen merchant 604340 604340 Turnabone, Stephen, of Florence, merchant 0
4774173 2287905 2287905 plaintiff Spinelyn Marcus merchant 604340 604340 Spinelyn, Marcus, of Florence, merchant 1
4774174 2287905 2287905 plaintiff Ferentyn Alexander merchant 604340 604340 Ferentyn, Alexander, of Florence, merchant 2
4821868 2302914 2302914 plaintiff Saty Philip   604340 604340 Saty, Philip, of Florence, on his own account 0
4828189 2304860 2304860 plaintiff Albertis Philip merchant 604340 604340 Albertis, Philip, of Florence, merchant 0
4828190 2304860 2304860 plaintiff Seraill Franciscus merchant 604340 604340 Seraill, Franciscus, of Florence, merchant 1
4836820 2307477 2307477 plaintiff Farrentius Alexander merchant 604340 604340 Farrentius, Alexander, of Florence, merchant 0
4837025 2307538 2307538 plaintiff Ferrancius Alexander merchant 604340 604340 Ferrancius, Alexander, of Florence, merchant 0
4837027 2307539 2307539 plaintiff Ferrancius Alexander merchant 604340 604340 Ferrancius, Alexander, of Florence, merchant 0
4837029 2307540 2307540 plaintiff Ferrantinus Alexander merchant 604340 604340 Ferrantinus, Alexander, of Florence, merchant 0
4842853 2309306 2309306 plaintiff Luca George de   604340 604340 Luca, George de, of Florence 0
4842854 2309306 2309306 plaintiff Morell Paul merchant 604340 604340 Morell, Paul, of Florence, merchant 1
4988088 2353411 2353411 plaintiff Bormoeis Benedict de merchant 604340 604340 Bormoeis, Benedict de, of Florence, merchant 0
5001096 2357197 2357197 defendant Albertis Thomas de merchant 604340 604340 Albertis, Thomas de, of Florence, merchant 0
5001098 2357198 2357198 defendant Baron Lyzato Peter de merchant 604340 604340 Baron Lyzato, Peter de, of Florence, merchant 0
5001100 2357199 2357199 defendant Bartuly Saty Peter de merchant 604340 604340 Bartuly Saty, Peter de, of Florence, merchant 0
5001101 2357199 2357199 defendant Allertys Thomas de merchant 604340 604340 Allertys, Thomas de, of Florence, merchant 1
5035590 2367270 2367270 defendant de Barde Anthony broker 604340 604340 de Barde, Anthony, of Florence, or of London, broker 0
5039774 2368539 2368539 plaintiff Boremeis Benedict merchant 604340 604340 Boremeis, Benedict, of Florence, merchant 0
5039776 2368540 2368540 plaintiff Boremeis Benedict merchant 604340 604340 Boremeis, Benedict, of Florence, merchant 0
5042319 2369308 2369308 plaintiff de Albertis Thomas   604340 604340 de Albertis, Thomas, of Florence 0
5042320 2369308 2369308 defendant Boromeis Benedict merchant 604340 604340 Boromeis, Benedict, of Florence, merchant 0
5042326 2369310 2369310 plaintiff de Boromeis Benedictus merchant 604340 604340 de Boromeis, Benedictus, of Florence, merchant 0
5042328 2369311 2369311 plaintiff de Boromeis Benedictus merchant 604340 604340 de Boromeis, Benedictus, of Florence, merchant 0
5124716 2393705 2393705 plaintiff Aldebrandini Angelo Donatus merchant 604340 604340 Aldebrandini, Angelo Donatus, of Florence, merchant 0
5124719 2393706 2393706 plaintiff Aldebrandini Angelo Donatus merchant 604340 604340 Aldebrandini, Angelo Donatus, of Florence, merchant 0
5124720 2393706 2393706 plaintiff Strossini Ludovici merchant 604340 604340 Strossini, Ludovici, of Florence, merchant 1
5124724 2393707 2393707 plaintiff Aldebrandini Angelo Donatus merchant 604340 604340 Aldebrandini, Angelo Donatus, of Florence, merchant 0
5124725 2393707 2393707 plaintiff Strossini Ludovici merchant 604340 604340 Strossini, Ludovici, of Florence, merchant 1
5124729 2393708 2393708 plaintiff Aldebrandini Angelo merchant 604340 604340 Aldebrandini, Angelo, of Florence, merchant 0
5129607 2395149 2395149 plaintiff de Benyngfyne Leonardo merchant 604340 604340 de Benyngfyne, Leonardo, of Florence, merchant 0
5129610 2395150 2395150 plaintiff de Benyngsyne Leonardo merchant 604340 604340 de Benyngsyne, Leonardo, of Florence, merchant 0
5140317 2398274 2398274 plaintiff Strossini Ludovici merchant 604340 604340 Strossini, Ludovici, of Florence, merchant 0
5143062 2399097 2399097 plaintiff Nory Simon merchant 604340 604340 Nory, Simon, of Florence, merchant 1
5143308 2399180 2399180 plaintiff Aldebrand Angelus Donatus merchant 604340 604340 Aldebrand, Angelus Donatus, of Florence, merchant 0
5143311 2399181 2399181 plaintiff Aldebrande Angelus merchant 604340 604340 Aldebrande, Angelus, of Florence, merchant 0
5144515 2399555 2399555 plaintiff Benynsyne Leonard merchant 604340 604340 Benynsyne, Leonard, of Florence, merchant 0
5149242 2400911 2400911 plaintiff Donatus de Aldebrand Angelus merchant 604340 604340 Donatus de Aldebrand, Angelus, of Florence, merchant 0
5149245 2400912 2400912 plaintiff Donatus de Aldebrand Angelus merchant 604340 604340 Donatus de Aldebrand, Angelus, of Florence, merchant 0
5149246 2400912 2400912 plaintiff Strossis Ludovicus de merchant 604340 604340 Strossis, Ludovicus de, of Florence, merchant 1
5149250 2400913 2400913 plaintiff Donatus de Aldebrand Angelus merchant 604340 604340 Donatus de Aldebrand, Angelus, of Florence, merchant 0
5149251 2400913 2400913 plaintiff Strossis Ludovicus de merchant 604340 604340 Strossis, Ludovicus de, of Florence, merchant 1
5149256 2400914 2400914 plaintiff Strossis Ludovic merchant 604340 604340 Strossis, Ludovic, of Florence, merchant 1
5149261 2400915 2400915 plaintiff Strossis Ludovic merchant 604340 604340 Strossis, Ludovic, of Florence, merchant 1
5161425 2404442 2404442 plaintiff Strosse Ludovick de merchant 604340 604340 Strosse, Ludovick de, of Florence, merchant 0
5161427 2404443 2404443 plaintiff Strossis Ludovic de merchant 604340 604340 Strossis, Ludovic de, of Florence, merchant 0
5161429 2404444 2404444 plaintiff Strossis Ludovic de merchant 604340 604340 Strossis, Ludovic de, of Florence, merchant 0
5161431 2404445 2404445 plaintiff Strossis Ludovic de merchant 604340 604340 Strossis, Ludovic de, of Florence, merchant 0
5161433 2404446 2404446 plaintiff Strossis Ludovic de merchant 604340 604340 Strossis, Ludovic de, of Florence, merchant 0
5161435 2404447 2404447 plaintiff Strossis Ludovic de merchant 604340 604340 Strossis, Ludovic de, of Florence, merchant 0
5161440 2404448 2404448 plaintiff Strossyn Luigi de merchant 604340 604340 Strossyn, Luigi de, of Florence, merchant 0
5164479 2405342 2405342 plaintiff Nory Simon merchant 604340 604340 Nory, Simon, of Florence, merchant 1
5175822 2408612 2408612 plaintiff Strooijs Ludovic de merchant 604340 604340 Strooijs, Ludovic de, of Florence, merchant 0
5175827 2408613 2408613 plaintiff Strossis Ludovic de merchant 604340 604340 Strossis, Ludovic de, of Florence, merchant 0
5175829 2408614 2408614 plaintiff Strossis Ludovic merchant 604340 604340 Strossis, Ludovic, of Florence, merchant 0
5175834 2408615 2408615 plaintiff Strossys Ludovic merchant 604340 604340 Strossys, Ludovic, of Florence, merchant 0
5177688 2409168 2409168 plaintiff Nory Simon merchant 604340 604340 Nory, Simon, of Florence, merchant 1
5193444 2413809 2413809 defendant Donato de Aldibrand Angelus merchant 604340 604340 Donato de Aldibrand, Angelus, of Florence, merchant 0
5197416 2414987 2414987 plaintiff Strossis Ludovic de merchant 604340 604340 Strossis, Ludovic de, of Florence, merchant 0
5197418 2414988 2414988 plaintiff Strossys or Strosfys Ludovic merchant 604340 604340 Strossys or Strosfys, Ludovic, of Florence, merchant 0
5197428 2414990 2414990 plaintiff Strossys Ludovic de merchant 604340 604340 Strossys, Ludovic de, of Florence, merchant 0
5197433 2414991 2414991 plaintiff Strossys Ludovicus de merchant 604340 604340 Strossys, Ludovicus de, of Florence, merchant 0
5210085 2418682 2418682 plaintiff Strossys Ludovic de merchant 604340 604340 Strossys, Ludovic de, of Florence, merchant 0
5210087 2418683 2418683 plaintiff Strossys Ludovicus merchant 604340 604340 Strossys, Ludovicus, of Florence, merchant 0
5269366 2436136 2436136 plaintiff Camgiam Geogio merchant 604340 604340 Camgiam, Geogio, of Florence, merchant 0
5269367 2436136 2436136 plaintiff Bardua Lawrence merchant 604340 604340 Bardua, Lawrence, of Florence, merchant 1
5421805 2481458 2481458 plaintiff Altount Stoldus de merchant 604340 604340 Altount, Stoldus de, of Florence, merchant 0
5421808 2481459 2481459 plaintiff Altount Stoldus de merchant 604340 604340 Altount, Stoldus de, of Florence, merchant 0
5426849 2482973 2482973 plaintiff De_e Honofrius Jacob merchant 604340 604340 De_e, Honofrius Jacob, of Florence, merchant 0
5444863 2488354 2488354 plaintiff Dene Humphrey James merchant 604340 604340 Dene, Humphrey James, of Florence, merchant 0
5454413 2491229 2491229 plaintiff Altome Stoldus de merchant 604340 604340 Altome, Stoldus de, of Florence, merchant 0
5454415 2491230 2491230 plaintiff Altona Stoldus de merchant 604340 604340 Altona, Stoldus de, of Florence, merchant 0
5457525 2492147 2492147 plaintiff Dene Honofriuis James merchant 604340 604340 Dene, Honofriuis James, of Florence, merchant 0
5457527 2492148 2492148 plaintiff Dene James merchant 604340 604340 Dene, James, of Florence, 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);