names

60 rows where place_id = 586202

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588153 1863946 1863946 plaintiff Baron John mercer 586202 586202 Baron, John, of Westminister, mercer 0
3588155 1863947 1863947 plaintiff Baron John mercer 586202 586202 Baron, John, of Westminister, mercer 0
3588157 1863948 1863948 plaintiff Baron John mercer 586202 586202 Baron, John, of Westminister, mercer 0
3590748 1864747 1864747 defendant Legh John yeoman of the crown 586202 586202 Legh, John, of Westminister, gent, yeoman of the crown for Edw IV 0
3598724 1867228 1867228 plaintiff Stone Richard gent 586202 586202 Stone, Richard, of Westminister, gent 0
3701050 1926577 1926577 defendant Ottewell John gent 586202 586202 (Ottewell, John, of Westminister, gent 1
3708717 1929024 1929024 defendant Parker John yeoman 586202 586202 Parker, John, of Westminister, yeoman 1
3712636 1930269 1930269 plaintiff Forde John   586202 586202 Forde, John, of Westminister 2
3736505 1937665 1937665 defendant de la Rewe Elias chaplain 586202 586202 de la Rewe, Elias, of Westminister, chaplain 0
3736506 1937665 1937665 defendant Horseley Richard yeoman 586202 586202 Horseley, Richard, of Westminister, yeoman 1
3765471 1946863 1946863 defendant Wycombe Brigit widow 586202 586202 Wycombe, Brigit, of Westminister, widow 11
3852467 1974379 1974379 defendant Clerke Robert joiner 586202 586202 Clerke, Robert, of Westminister, joiner 0
4151071 2078505 2078505 defendant Reynold John yeoman 586202 586202 Reynold, John, of Westminister, yeoman 0
4268617 2119099 2119099 defendant Hunte Thomas yeoman 586202 586202 Hunte, Thomas, of Westminister, yeoman 0
4602623 2232038 2232038 defendant Kentbury Thomas   586202 586202 together with Kentbury, Thomas, of Westminister 1
4831279 2305813 2305813 defendant Garnon John yeoman 586202 586202 Garnon, John, of Westminister, yeoman 4
4850716 2311676 2311676 defendant Bocher William butcher 586202 586202 Bocher, William, of Westminister, butcher 0
5011728 2360279 2360279 defendant Hakelet Joan widow 586202 586202 Hakelet, Joan, of Westminister, widow 0
5093571 2384519 2384519 defendant Childerplawe John glasier 586202 586202 Childerplawe, John, of Westminister, glasier 0
5150581 2401313 2401313 defendant Mason William   586202 586202 Mason, William, of Westminister, mason 1
5155933 2402895 2402895 defendant Clerke Walter gent 586202 586202 Clerke, Walter, of Westminister, gent 1
5184752 2411289 2411289 defendant Tours William   586202 586202 Tours, William, of Westminister chaplain 3
5193000 2413679 2413679 defendant Brasyer Richard yeoman 586202 586202 Brasyer, Richard, of Westminister, yeoman 1
5193003 2413680 2413680 defendant Brasyer Richard yeoman 586202 586202 Brasyer, Richard, of Westminister, yeoman 1
5193006 2413681 2413681 defendant Brasyer Richard yeoman 586202 586202 Brasyer, Richard, of Westminister, yeoman 1
5193012 2413683 2413683 defendant Brasyer Richard yeoman 586202 586202 Brasyer, Richard, of Westminister, yeoman 2
5193069 2413704 2413704 defendant Hornwerk William   586202 586202 Hornwerk, William, of Westminister, mason 0
5193997 2413979 2413979 defendant Wydesay William gent 586202 586202 Wydesay, William, of Westminister, gent 0
5196897 2414844 2414844 plaintiff Standard John   586202 586202 Standard, John, of Westminister, administrators of 0
5197172 2414912 2414912 defendant Aburough John gent & King's crown valet 586202 586202 Aburough, John, of Westminister, gent & King's crown valet 0
5207959 2418061 2418061 defendant Andrewesson John tailor 586202 586202 (Andrewesson, John, of Westminister, tailor 1
5209875 2418621 2418621 plaintiff Standard John   586202 586202 Standard, John, of Westminister, administrators of 0
5210867 2418910 2418910 plaintiff Walesby William (legal representative) 586202 586202 Walesby, William, of Westminister, chaplain in the King's chapel of St Stephen, and prebendary of the prebend of Writlington, executors of 0
5210869 2418910 2418910 plaintiff Martyn Walter   586202 586202 Martyn, Walter, of Westminister, clerk in the King's free chapel of St Stephen, within the Palace 2
5211048 2418963 2418963 defendant Durana Robert yeoman 586202 586202 Durana, Robert, of Westminister, yeoman 6
5300985 2445248 2445248 defendant Chaumpeney Robert yeoman of the King Henry VI hospice 586202 586202 Chaumpeney, Robert, of Westminister, yeoman of the King Henry VI hospice 0
5312683 2448829 2448829 defendant Ynglefeld Thomas yeoman 586202 586202 Ynglefeld, Thomas, of Westminister, yeoman 0
5312684 2448829 2448829 defendant Brednex Richard yeoman 586202 586202 Brednex, Richard, of Westminister, yeoman 1
5314783 2449463 2449463 plaintiff Grene John saddler 586202 586202 Grene, John, of Westminister, saddler 1
5334374 2455352 2455352 plaintiff Faireclough John brewer 586202 586202 Faireclough, John, of Westminister, brewer 0
5342612 2457890 2457890 plaintiff Lokyngton Walter   586202 586202 Lokyngton, Walter, of Westminister 2
5347723 2459442 2459442 plaintiff Blaknall William butcher 586202 586202 Blaknall, William, of Westminister, butcher 0
5350252 2460200 2460200 defendant Ugon Eliot vintner 586202 586202 Ugon, Eliot, of Westminister, vintner 0
5354766 2461570 2461570 defendant Medway William baker 586202 586202 Medway, William, of Westminister, baker 0
5361436 2463599 2463599 defendant Ugon Eliot vintner 586202 586202 Ugon, Eliot, of Westminister, vintner 1
5396257 2474017 2474017 defendant Wade Edward baker 586202 586202 Wade, Edward, of Westminister, baker 1
5396258 2474017 2474017 defendant Freman Thomas   586202 586202 Freman, Thomas, of Westminister, gent & Receiver general to Henry Grey, Lord Codenore 2
5399555 2474953 2474953 plaintiff Eastney John   586202 586202 Eastney, John, of Westminister, abbot of St Peter's Monastery 0
5404375 2476324 2476324 defendant Thorp Noretta widow 586202 586202 Thorp, Noretta, of Westminister, widow 0
5451324 2490272 2490272 defendant Garardson Gerard shoemaker 586202 586202 Garardson, Gerard, of Westminister, shoemaker 0
5485979 2500695 2500695 defendant Pert Thomas tailor 586202 586202 Pert, Thomas, of Westminister, tailor 1
5486265 2500778 2500778 defendant Restwold Richard gent 586202 586202 Restwold, Richard, of Westminister, gent 3
5491739 2502427 2502427 plaintiff Chardeyn William (legal representative) 586202 586202 Chardeyn, William, of Westminister, tailor, executors of 0
5497611 2504228 2504228 defendant Wade Edward baker 586202 586202 Wade, Edward, of Westminister, baker 0
5518753 2510701 2510701 defendant Bocher Roger, junior butcher 586202 586202 Bocher, Roger, junior, of Westminister, butcher 0
5518754 2510701 2510701 defendant Mason John butcher 586202 586202 Mason, John, of Westminister, butcher 1
5518755 2510701 2510701 defendant Stone William butcher 586202 586202 Stone, William, of Westminister, butcher 2
5538886 2516648 2516648 defendant Swynnerton Elizabeth widow 586202 586202 Swynnerton, Elizabeth, of Westminister, widow 0
5546015 2518826 2518826 defendant Browene Robert vintner 586202 586202 Browene, Robert, of Westminister, vintner 4
5586087 2530689 2530689 defendant Hastynges Richard   586202 586202 Hastynges, Richard, of Westminister, knight 2

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