names

65 rows where place_id = 586329

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588444 1864034 1864034 defendant Lane John yeoman 586329 586329 Lane, John, of Cobham, Kent, yeoman 3
3598746 1867234 1867234 defendant Brook John   586329 586329 Brook, John, of Cobham, Kent, knight, Lord Cobham 0
3608694 1870379 1870379 defendant Bradford John yeoman 586329 586329 Bradford, John, of Cobham, Kent, yeoman 0
3623036 1874730 1874730 defendant Hale John husbandman 586329 586329 Hale, John, of Cobham, Kent, husbandman 2
3623067 1874737 1874737 defendant Hale John husbandman 586329 586329 Hale, John, of Cobham, Kent, husbandman 1
3624891 1875320 1875320 defendant Dobbys John yeoman 586329 586329 Dobbys, John, of Cobham, Kent, yeoman 0
3628302 1903715 1903715 defendant Russell John husbandman 586329 586329 Russell, John, of Cobham, Kent, husbandman 0
3646719 1909374 1909374 defendant Broke Thomas   586329 586329 Broke, Thomas, of Cobham, Kent, knight 0
3663870 1914637 1914637 defendant Broke Thomas   586329 586329 Broke, Thomas, of Cobham, Kent, knight, son & heir of John Broke, knight 0
3664602 1914883 1914883 defendant Stacy Richard yeoman 586329 586329 Stacy, Richard, of Cobham, Kent, yeoman 0
3676017 1918537 1918537 defendant Broke Thomas gent 586329 586329 Broke, Thomas, of Cobham, Kent, gent 0
3720198 1932592 1932592 defendant Broke alias Cobham Edward   586329 586329 Broke alias Cobham, Edward, of Cobham, Kent, knight 0
3720202 1932593 1932593 defendant Broke alias Cobham Edward   586329 586329 Broke alias Cobham, Edward, of Cobham, Kent, knight 0
3720220 1932598 1932598 defendant Broke Thomas   586329 586329 Broke, Thomas, of Cobham, Kent, knight 0
3720707 1932768 1932768 defendant Broke Thomas   586329 586329 Broke, Thomas, of Cobham, Kent, knight, Lord Cobham 0
3723127 1933500 1933500 defendant Broke Thomas   586329 586329 Broke, Thomas, of Cobham, Kent, knight 0
3743893 1939975 1939975 defendant Broke George   586329 586329 Broke, George, of Cobham, Kent, knight, son of Broke, Thomas 0
3754002 1943202 1943202 defendant Stephyns Thomas husbandman 586329 586329 Stephyns, Thomas, of Cobham, Kent, husbandman 0
3761314 1945543 1945543 defendant Cromer George   586329 586329 Cromer, George, of Cobham, Kent, clerk, Archbishop of Armagh 0
3770890 1948583 1948583 defendant Mullard John yeoman 586329 586329 Mullard, John, of Cobham, Kent, yeoman 1
3770893 1948584 1948584 defendant Mullard John yeoman 586329 586329 Mullard, John, of Cobham, Kent, yeoman 1
3788239 1954118 1954118 defendant Harper Nicholas gent 586329 586329 Harper, Nicholas, of Cobham, Kent, gent 3
3816480 1963061 1963061 defendant Broke George   586329 586329 Broke, George, of Cobham, Kent, knight, son of Broke, Thomas, Lord Cobham 0
3819523 1963984 1963984 defendant Broke George   586329 586329 Broke, George, of Cobham, Kent, knight 0
3904668 1991817 1991817 defendant Goldwyn William gent 586329 586329 Goldwyn, William, of Cobham, Kent, gent 0
3949877 2007032 2007032 defendant Bouchier George gent 586329 586329 Bouchier, George, of Cobham, Kent, gent 1
3960258 2010684 2010684 defendant Delowne James gardiner 586329 586329 Delowne, James, of Cobham, Kent, gardiner 0
3982132 2018369 2018369 defendant Broke alias Cobham George esq 586329 586329 Broke alias Cobham, George, of Cobham, Kent, esq 0
3982141 2018372 2018372 defendant Broke alias Calle George esq 586329 586329 Broke alias Calle, George, of Cobham, Kent, esq 0
4029297 2035122 2035122 defendant Harper John gent 586329 586329 Harper, John, of Cobham, Kent, gent 0
4029541 2035203 2035203 defendant Harper John gent 586329 586329 Harper, John, of Cobham, Kent, gent 0
4146145 2076800 2076800 defendant Cobham John esq 586329 586329 Cobham, John, of Cobham, Kent, esq 0
4171142 2085374 2085374 defendant Cobham John esq 586329 586329 Cobham, John, of Cobham, Kent, esq 0
4175434 2086878 2086878 defendant West Henry gent 586329 586329 West, Henry, of Cobham, Kent, gent 3
4315349 2135480 2135480 defendant Brooke William   586329 586329 Brooke, William, of Cobham, Kent, knight 0
4315351 2135481 2135481 defendant Brooke William   586329 586329 Brooke, William, of Cobham, Kent, knight 0
4315364 2135484 2135484 defendant Brooke Henry esq 586329 586329 Brooke, Henry, of Cobham, Kent, esq 0
4396008 2163241 2163241 defendant Brooke Henry esq 586329 586329 Brooke, Henry, of Cobham, Kent, esq 1
5195259 2414359 2414359 defendant Chippe Walter (legal representative) 586329 586329 Chippe, Walter, of Cobham, Kent, husbandman, executrix of 4
5240488 2427431 2427431 defendant Dobbys John husbandman 586329 586329 Dobbys, John, of Cobham, Kent, husbandman 0
5240490 2427432 2427432 defendant Dobbys John husbandman 586329 586329 Dobbys, John, of Cobham, Kent, husbandman 0
5264041 2434512 2434512 defendant Hale John butcher 586329 586329 Hale, John, of Cobham, Kent, butcher 0
5264045 2434513 2434513 defendant Hale John butcher 586329 586329 Hale, John, of Cobham, Kent, butcher 0
5268920 2436020 2436020 defendant Smyth Henry   586329 586329 Smyth, Henry, of Cobham, Kent 0
5292579 2442825 2442825 defendant Hale John butcher 586329 586329 Hale, John, of Cobham, Kent, butcher 2
5297774 2444353 2444353 defendant Wryght Nicholas yeoman 586329 586329 Wryght, Nicholas, of Cobham, Kent, yeoman 1
5299529 2444839 2444839 defendant Dobbys John yeoman 586329 586329 Dobbys, John, of Cobham, Kent, yeoman 2
5309012 2447734 2447734 defendant Wryght Nicholas yeoman 586329 586329 Wryght, Nicholas, of Cobham, Kent, yeoman 1
5309700 2447937 2447937 defendant Dobbys John yeoman 586329 586329 Dobbys, John, of Cobham, Kent, yeoman 0
5319165 2450828 2450828 defendant Dobbys John husbandman 586329 586329 Dobbys, John, of Cobham, Kent, husbandman 0
5358933 2462843 2462843 defendant Raynforth Richard gent 586329 586329 Raynforth, Richard, of Cobham, Kent, gent 0
5375261 2467847 2467847 defendant Hale John yeoman 586329 586329 Hale, John, of Cobham, Kent, yeoman 0
5459096 2492616 2492616 defendant Cobham William gent 586329 586329 Cobham, William, of Cobham, Kent, gent 2
5477912 2498419 2498419 defendant Dobbes John yeoman 586329 586329 Dobbes, John, of Cobham, Kent, yeoman 0
5500606 2505118 2505118 defendant Dobbes John, senior yeoman 586329 586329 Dobbes, John, senior, of Cobham, Kent, yeoman 0
5500613 2505119 2505119 defendant Dobbes John, senior yeoman 586329 586329 Dobbes, John, senior, of Cobham, Kent, yeoman 0
5511958 2508597 2508597 defendant Smyth Thomas yeoman 586329 586329 Smyth, Thomas, of Cobham, Kent, yeoman 0
5511962 2508598 2508598 defendant Smyth Thomas yeoman 586329 586329 Smyth, Thomas, of Cobham, Kent, yeoman 0
5521369 2511500 2511500 defendant Koste John husbandman 586329 586329 Koste, John, of Cobham, Kent, husbandman 4
5532479 2514703 2514703 defendant Burford John tanner 586329 586329 Burford, John, of Cobham, Kent, tanner 2
5532485 2514704 2514704 defendant Burford John tanner 586329 586329 Burford, John, of Cobham, Kent, tanner 2
5533542 2515039 2515039 defendant Joskyn Richard tailor 586329 586329 Joskyn, Richard, of Cobham, Kent, tailor 1
5551493 2520475 2520475 defendant Hale John gent 586329 586329 Hale, John, of Cobham, Kent, gent 0
5554104 2521241 2521241 defendant Dobbys John yeoman 586329 586329 Dobbys, John, of Cobham, Kent, yeoman 0
5590233 2531916 2531916 defendant Holte Robert gent 586329 586329 Holte, Robert, of Cobham, Kent, gent 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);