names

78 rows where place_id = 587062

✎ 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
3590359 1864625 1864625 defendant Caccher William yeoman 587062 587062 Caccher, William, of Totenham, Middx, yeoman 0
3609489 1870630 1870630 defendant Manser Christopher yeoman 587062 587062 Manser, Christopher, of Totenham, Middx, yeoman 0
3622083 1874445 1874445 defendant Bolton Edward gent 587062 587062 Bolton, Edward, of Totenham, Middx, gent 0
3632769 1905063 1905063 defendant Henyngham George gent 587062 587062 Henyngham, George, of Totenham, Middx, gent 1
3639092 1907048 1907048 defendant Pagyngton John husbandman 587062 587062 Pagyngton, John, of Totenham, Middx, husbandman 0
3658531 1912921 1912921 defendant Botrell Thomas gent 587062 587062 Botrell, Thomas, of Totenham, Middx, gent 0
3658540 1912924 1912924 defendant Botrell Thomas gent 587062 587062 Botrell, Thomas, of Totenham, Middx, gent 0
3720924 1932839 1932839 defendant Boterell Thomas gent 587062 587062 Boterell, Thomas, of Totenham, Middx, gent 0
3764712 1946627 1946627 plaintiff Hynnyngham George gent 587062 587062 Hynnyngham, George, of Totenham, Middx, gent 0
3767954 1947613 1947613 defendant Clerk Richard gent 587062 587062 Clerk, Richard, of Totenham, Middx, gent 0
3777057 1950571 1950571 defendant Boterell Thomas gent 587062 587062 Boterell, Thomas, of Totenham, Middx, gent 0
3781851 1952071 1952071 defendant Pakyngton William yeoman 587062 587062 Pakyngton, William, of Totenham, Middx, yeoman 0
3806968 1960082 1960082 defendant Assheby William gent 587062 587062 Assheby, William, of Totenham, Middx, gent 2
3836690 1969374 1969374 defendant Byllyngton Thomas gent 587062 587062 Byllyngton, Thomas, of Totenham, Middx, gent 2
3876762 1982469 1982469 defendant Clerke Richard gent 587062 587062 Clerke, Richard, of Totenham, Middx, gent 1
3949912 2007047 2007047 defendant Byrde Robert (legal representative) 587062 587062 Byrde, Robert, of Totenham, Middx, yeoman, executors of 0
4215933 2101069 2101069 defendant Mershe Alice widow 587062 587062 Mershe, Alice, of Totenham, Middx, widow 0
4215938 2101070 2101070 defendant Mershe Alice widow 587062 587062 Mershe, Alice, of Totenham, Middx, widow 0
4726837 2273662 2273662 defendant Whelere John yeoman 587062 587062 Whelere, John, of Totenham, Middx, yeoman 3
4734095 2275847 2275847 defendant Burton John gent 587062 587062 Burton, John, of Totenham, Middx, gent 0
4750431 2280606 2280606 defendant Burton John gent 587062 587062 Burton, John, of Totenham, Middx, gent 0
4750433 2280607 2280607 defendant Burton John gent 587062 587062 Burton, John, of Totenham, Middx, gent 0
4750903 2280747 2280747 defendant Twyford John gent 587062 587062 Twyford, John, of Totenham, Middx, gent 0
4754187 2281688 2281688 defendant Burton John esq 587062 587062 Burton, John, of Totenham, Middx, esq 0
4789547 2292803 2292803 defendant Burton John gent 587062 587062 Burton, John, of Totenham, Middx, gent 0
4811698 2299766 2299766 defendant Danyell Thomas gent 587062 587062 Danyell, Thomas, of Totenham, Middx, gent 1
4886795 2322725 2322725 defendant Lovelane or Lovelave William baker 587062 587062 Lovelane or Lovelave, William, of Totenham, Middx, baker 0
4888197 2323115 2323115 defendant Lovelane or Lovelave William baker 587062 587062 Lovelane or Lovelave, William, of Totenham, Middx, baker 0
4891545 2324093 2324093 defendant Brystowe John yeoman 587062 587062 Brystowe, John, of Totenham, Middx, yeoman 0
4901984 2327222 2327222 defendant Williamson Geoffrey yeoman 587062 587062 Williamson, Geoffrey, of Totenham, Middx, yeoman 0
4912130 2330295 2330295 defendant Bouter or Bonter William butcher 587062 587062 Bouter or Bonter, William, of Totenham, Middx, butcher 0
4916931 2331797 2331797 defendant Stubbe John carpenter 587062 587062 Stubbe, John, of Totenham, Middx, carpenter 0
4917204 2331886 2331886 defendant Brystowe John yeoman 587062 587062 Brystowe, John, of Totenham, Middx, yeoman 2
4926250 2334634 2334634 defendant Bristowe John yeoman 587062 587062 Bristowe, John, of Totenham, Middx, yeoman 1
4931344 2336183 2336183 defendant Leveyng John   587062 587062 Leveyng, John, of Totenham, Middx, tallow chandler 0
4956996 2344049 2344049 defendant William Geoffrey yeoman 587062 587062 William, Geoffrey, of Totenham, Middx, yeoman 4
4979784 2350910 2350910 defendant William Geoffrey yeoman 587062 587062 William, Geoffrey, of Totenham, Middx, yeoman 0
4997253 2356032 2356032 defendant Sawell John sawer 587062 587062 Sawell, John, of Totenham, Middx, sawer 3
4997258 2356033 2356033 defendant Sawer John sawer 587062 587062 Sawer, John, of Totenham, Middx, sawer 3
5033024 2366543 2366543 defendant Roper Richard husbandman 587062 587062 Roper, Richard, of Totenham, Middx, husbandman 1
5033034 2366544 2366544 defendant Roper Richard husbandman 587062 587062 Roper, Richard, of Totenham, Middx, husbandman 4
5039809 2368550 2368550 defendant Neweman John brewer 587062 587062 Neweman, John, of Totenham, Middx, brewer 1
5062390 2375316 2375316 defendant Burton Thomas husbandman 587062 587062 Burton, Thomas, of Totenham, Middx, husbandman 1
5102721 2387209 2387209 defendant Drayton William gent 587062 587062 Drayton, William, of Totenham, Middx, gent 0
5106221 2388258 2388258 defendant Mesendewe William husbandman 587062 587062 Mesendewe, William, of Totenham, Middx, husbandman 1
5106226 2388259 2388259 defendant Mosendewe William husbandman 587062 587062 Mosendewe, William, of Totenham, Middx, husbandman 1
5110342 2389428 2389428 defendant Stokes Richard yeoman 587062 587062 Stokes, Richard, of Totenham, Middx, or of Shaftesbury, Dorset, yeoman 0
5119095 2392022 2392022 defendant Clerk Edmund brewer 587062 587062 Clerk, Edmund, of Totenham, Middx, brewer 1
5131929 2395823 2395823 defendant Clerk Edmund husbandman 587062 587062 Clerk, Edmund, of Totenham, Middx, husbandman 0
5138916 2397881 2397881 defendant Stokes Richard baker 587062 587062 Stokes, Richard, of Totenham, Middx, baker 0
5159811 2403970 2403970 defendant Stokes Richard baker 587062 587062 Stokes, Richard, of Totenham, Middx, baker 0
5186665 2411847 2411847 defendant Clerk Edmund husbandman 587062 587062 Clerk, Edmund, of Totenham, Middx, husbandman 0
5201562 2416216 2416216 defendant Thornton Richard husbandman 587062 587062 Thornton, Richard, of Totenham, Middx, husbandman 0
5205943 2417473 2417473 defendant Ederych Maud widow 587062 587062 (Ederych, Maud, of Totenham, Middx, widow 3
5231813 2424877 2424877 defendant Ederich John butcher 587062 587062 Ederich, John, of Totenham, Middx, butcher 0
5236607 2426291 2426291 defendant Freget John   587062 587062 Freget, John, of Totenham, Middx, hermit 4
5241411 2427683 2427683 defendant Cornewayle Robert baker 587062 587062 Cornewayle, Robert, of Totenham, Middx, baker 0
5263537 2434345 2434345 defendant Drayton William gent 587062 587062 Drayton, William, of Totenham, Middx, gent 0
5277052 2438371 2438371 defendant Pygot John husbandman 587062 587062 Pygot, John, of Totenham, Middx, husbandman 3
5277056 2438372 2438372 defendant Isygot John husbandman 587062 587062 Isygot, John, of Totenham, Middx, husbandman 2
5286269 2440993 2440993 defendant Morkar John gent 587062 587062 Morkar, John, of Totenham, Middx, gent 3
5286278 2440994 2440994 defendant Morkar John gent 587062 587062 Morkar, John, of Totenham, Middx, gent 3
5294614 2443404 2443404 defendant Pygot John yeoman 587062 587062 Pygot, John, of Totenham, Middx, yeoman 0
5318012 2450474 2450474 defendant Stubbe John smith 587062 587062 Stubbe, John, of Totenham, Middx, smith 3
5326635 2453036 2453036 defendant Drayton William gent 587062 587062 Drayton, William, of Totenham, Middx, gent 0
5371159 2466566 2466566 defendant Purse William smith 587062 587062 Purse, William, of Totenham, Middx, smith 1
5371418 2466641 2466641 defendant Marten William brewer 587062 587062 Marten, William, of Totenham, Middx, brewer 3
5456429 2491843 2491843 defendant Mauncell Christopher husbandman 587062 587062 Mauncell, Christopher, of Totenham, Middx, husbandman 1
5488404 2501426 2501426 defendant Stubbe Thomas husbandman 587062 587062 Stubbe, Thomas, of Totenham, Middx, husbandman 2
5514644 2509427 2509427 defendant Robyn John husbandman 587062 587062 Robyn, John, of Totenham, Middx, husbandman 0
5514646 2509428 2509428 defendant Robyn John husbandman 587062 587062 Robyn, John, of Totenham, Middx, husbandman 0
5520643 2511280 2511280 plaintiff Burton John (legal representative) 587062 587062 Burton, John, of Totenham, Middx, smith, executors of 0
5520646 2511281 2511281 plaintiff Burton John (legal representative) 587062 587062 Burton, John, of Totenham, Middx, smith, executors of 0
5520649 2511282 2511282 plaintiff Burton John (legal representative) 587062 587062 Burton, John, of Totenham, Middx, smith, executors of 0
5549840 2519985 2519985 defendant Maykyn John yeoman 587062 587062 Maykyn, John, of Totenham, Middx, yeoman 4
5551485 2520472 2520472 defendant Pakyngton William yeoman 587062 587062 Pakyngton, William, of Totenham, Middx, yeoman 0
5569431 2525624 2525624 plaintiff Hale William husbandman 587062 587062 Hale, William, of Totenham, Middx, husbandman 0
5592575 2532668 2532668 defendant Clerke James yeoman 587062 587062 Clerke, James, of Totenham, Middx, 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);