names

57 rows where place_id = 775895

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4627987 2239676 2239676 defendant Leytton Simon   775895 775895 Leytton, Simon, of Wysbeche, Cambs 0
4627989 2239677 2239677 defendant Leytton Simon   775895 775895 Leytton, Simon, of Wysbeche, Cambs 0
4712363 2269182 2269182 defendant Mast William shipman 775895 775895 Mast, William, of Wysbeche, Cambs, shipman 2
4714399 2269832 2269832 defendant Fyssher Thomas yeoman 775895 775895 Fyssher, Thomas, of Wysbeche, Cambs, yeoman 1
4720552 2271764 2271764 defendant Raulyn John husbandman 775895 775895 Raulyn, John, of Wysbeche, Cambs, husbandman 0
4736729 2276615 2276615 defendant Tilneye Richard husbandman 775895 775895 Tilneye, Richard, of Wysbeche, Cambs, husbandman 0
4736732 2276616 2276616 defendant Tilneye Richard husbandman 775895 775895 Tilneye, Richard, of Wysbeche, Cambs, husbandman 0
4770530 2286762 2286762 defendant Peye John yeoman 775895 775895 Peye, John, of Wysbeche, Cambs, yeoman 0
4771242 2286989 2286989 defendant Goos Gilbert yeoman 775895 775895 Goos, Gilbert, of Wysbeche, Cambs, yeoman 0
4775490 2288330 2288330 defendant Salter William   775895 775895 Salter, William, of Wysbeche, Cambs 0
4775492 2288330 2288330 defendant Fysshere Richard yeoman 775895 775895 Fysshere, Richard, of Wysbeche, Cambs, yeoman 2
4812280 2299956 2299956 defendant Haukyn Simon yeoman 775895 775895 Haukyn, Simon, of Wysbeche, Cambs, yeoman 0
4813250 2300258 2300258 defendant Fisshere Thomas fisher 775895 775895 Fisshere, Thomas, of Wysbeche, Cambs, fisher 0
4824390 2303688 2303688 defendant Fysshere Richard yeoman 775895 775895 Fysshere, Richard, of Wysbeche, Cambs, yeoman 3
4848125 2310885 2310885 defendant Owetelawe Nicholas taverner 775895 775895 Owetelawe, Nicholas, of Wysbeche, Cambs, taverner 0
4907772 2328993 2328993 defendant Joly Thomas dyer 775895 775895 Joly, Thomas, of Wysbeche, Cambs, dyer 0
4907775 2328994 2328994 defendant Joly Thomas dyer 775895 775895 Joly, Thomas, of Wysbeche, Cambs, dyer 0
4922078 2333314 2333314 defendant Mannyng Richard tanner 775895 775895 Mannyng, Richard, of Wysbeche, Cambs, tanner 0
4922084 2333317 2333317 defendant Mannyng Richard tanner 775895 775895 Mannyng, Richard, of Wysbeche, Cambs, tanner 0
4923806 2333889 2333889 defendant Orlybere Richard brewer 775895 775895 Orlybere, Richard, of Wysbeche, Cambs, brewer 0
4923807 2333889 2333889 defendant G--- Geoffrey esq 775895 775895 G---, Geoffrey, of Wysbeche, Cambs, esq 1
4930492 2335938 2335938 defendant Loveday Simon yeoman 775895 775895 Loveday, Simon, of Wysbeche, Cambs, yeoman 2
5001991 2357482 2357482 defendant Lombe Richard yeoman 775895 775895 Lombe, Richard, of Wysbeche, Cambs, yeoman 0
5001993 2357483 2357483 defendant Lombe Richard yeoman 775895 775895 Lombe, Richard, of Wysbeche, Cambs, yeoman 0
5002066 2357505 2357505 defendant Lombe Thomas grocer 775895 775895 Lombe, Thomas, of Wysbeche, Cambs, grocer 2
5002071 2357506 2357506 defendant Lombe Thomas grocer 775895 775895 Lombe, Thomas, of Wysbeche, Cambs, grocer 2
5012172 2360408 2360408 defendant Sutton Geoffrey gent alias esquire 775895 775895 Sutton, Geoffrey, of Wysbeche, Cambs, gent alias esquire 0
5038830 2368256 2368256 defendant Lombe Richard yeoman 775895 775895 Lombe, Richard, of Wysbeche, Cambs, yeoman 4
5046996 2370726 2370726 defendant Whith William gent 775895 775895 Whith, William, of Wysbeche, Cambs, gent 0
5051416 2372038 2372038 defendant Everrard John esq 775895 775895 Everrard, John, of Wysbeche, Cambs, esq 1
5147375 2400377 2400377 defendant Fox John esq 775895 775895 Fox, John, of Wysbeche, Cambs, esq 0
5147377 2400378 2400378 defendant Fox John esq 775895 775895 Fox, John, of Wysbeche, Cambs, esq 0
5157853 2403422 2403422 defendant Joly Thomas dyer 775895 775895 Joly, Thomas, of Wysbeche, Cambs, dyer 3
5164849 2405452 2405452 defendant Fox John esq 775895 775895 Fox, John, of Wysbeche, Cambs, esq 0
5167106 2406111 2406111 defendant Fox John esq 775895 775895 Fox, John, of Wysbeche, Cambs, esq 0
5167108 2406112 2406112 defendant Fox John esq 775895 775895 Fox, John, of Wysbeche, Cambs, esq 0
5173606 2407981 2407981 defendant Joly Thomas dyer 775895 775895 Joly, Thomas, of Wysbeche, Cambs, dyer 3
5190077 2412839 2412839 defendant Hakebeche John water man 775895 775895 Hakebeche, John, of Wysbeche, Cambs, water man 0
5193676 2413879 2413879 defendant Joly Thomas dyer 775895 775895 Joly, Thomas, of Wysbeche, Cambs, dyer 2
5273180 2437224 2437224 defendant Haigh John gent 775895 775895 Haigh, John, of Wysbeche, Cambs, gent 0
5273183 2437225 2437225 defendant Haugh John gent 775895 775895 Haugh, John, of Wysbeche, Cambs, gent 0
5299937 2444947 2444947 defendant Artour Edward yeoman 775895 775895 Artour, Edward, of Wysbeche, Cambs, yeoman 1
5301345 2445355 2445355 defendant Fyssher John yeoman 775895 775895 Fyssher, John, of Wysbeche, Cambs, yeoman 1
5378258 2468775 2468775 defendant Lawrens John husbandman 775895 775895 Lawrens, John, of Wysbeche, Cambs, husbandman 0
5378724 2468931 2468931 defendant Hawe Robert yeoman 775895 775895 Hawe, Robert, of Wysbeche, Cambs, yeoman 0
5398607 2474663 2474663 defendant Powedyche John   775895 775895 with Powedyche, John, of Wysbeche, Cambs, inn holder 1
5398610 2474664 2474664 defendant Powedyche John   775895 775895 Powedyche, John, of Wysbeche, Cambs, inn holder 0
5399876 2475058 2475058 defendant Pygge Robert husbandman 775895 775895 Pygge, Robert, of Wysbeche, Cambs, husbandman 1
5404295 2476305 2476305 defendant Pygge Robert husbandman 775895 775895 Pygge, Robert, of Wysbeche, Cambs, husbandman 0
5412875 2478799 2478799 defendant Pygge Robert husbandman 775895 775895 Pygge, Robert, of Wysbeche, Cambs, husbandman 0
5417449 2480138 2480138 defendant Pygge Robert husbandman 775895 775895 Pygge, Robert, of Wysbeche, Cambs, husbandman 0
5451274 2490257 2490257 defendant Fyssher John yeoman 775895 775895 Fyssher, John, of Wysbeche, Cambs, yeoman 2
5457776 2492221 2492221 defendant Thornton John yeoman 775895 775895 Thornton, John, of Wysbeche, Cambs, yeoman 3
5457777 2492221 2492221 defendant Fyssher John yeoman 775895 775895 Fyssher, John, of Wysbeche, Cambs, yeoman 4
5469555 2495816 2495816 defendant Inggram John glover 775895 775895 Inggram, John, of Wysbeche, Cambs, glover 4
5474010 2497202 2497202 defendant Pate Christopher yeoman 775895 775895 Pate, Christopher, of Wysbeche, Cambs, yeoman 0
5474874 2497468 2497468 defendant Fyssher John yeoman 775895 775895 Fyssher, John, of Wysbeche, Cambs, yeoman 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);