names

229 rows where place_id = 589493

✎ 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
3597785 1866924 1866924 defendant Hale John butcher 589493 589493 Hale, John, of Cobham, butcher 1
3599319 1867431 1867431 defendant Wryght John husbandman 589493 589493 Wryght, John, of Cobham, husbandman 0
3613832 1871981 1871981 defendant Hiller Thomas husbandman 589493 589493 Hiller, Thomas, of Cobham, husbandman 0
3618339 1873366 1873366 defendant Burford Thomas (legal representative) 589493 589493 Burford, Thomas, of Cobham, executors of 0
3622508 1874577 1874577 defendant Hale John husbandman 589493 589493 Hale, John, of Cobham, husbandman 1
3644077 1908579 1908579 defendant Bradford John laborer 589493 589493 Bradford, John, of Cobham, laborer 1
3644621 1908729 1908729 defendant Bradford John yeoman 589493 589493 Bradford, John, of Cobham, yeoman 0
3644622 1908729 1908729 defendant Godfrey Thomas laborer 589493 589493 Godfrey, Thomas, of Cobham, laborer 1
3652277 1911050 1911050 defendant Milton Thomas husbandman 589493 589493 Milton, Thomas, of Cobham, husbandman 3
3655313 1911920 1911920 defendant Cokkys Thomas yeoman 589493 589493 Cokkys, Thomas, of Cobham, yeoman 0
3655314 1911920 1911920 defendant German Henry yeoman 589493 589493 German, Henry, of Cobham, yeoman 1
3655315 1911920 1911920 defendant German Nicholas yeoman 589493 589493 German, Nicholas, of Cobham, yeoman 2
3655316 1911920 1911920 defendant German William yeoman 589493 589493 German, William, of Cobham, yeoman 3
3656933 1912425 1912425 defendant Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight 0
3656935 1912426 1912426 defendant Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight, Lord Cobham 0
3658128 1912799 1912799 defendant Swayn Robert husbandman 589493 589493 Swayn, Robert, of Cobham, husbandman 0
3658129 1912799 1912799 defendant Bradfor John husbandman 589493 589493 Bradfor, John, of Cobham, husbandman 1
3660604 1913577 1913577 defendant Swayne Robert   589493 589493 Swayne, Robert, of Cobham 0
3662329 1914131 1914131 defendant Cobham alias Broke Thomas   589493 589493 Cobham alias Broke, Thomas, of Cobham, knight & Lord Cobham 0
3668780 1916172 1916172 defendant Breket Roger butcher 589493 589493 Breket, Roger, of Cobham, butcher 0
3682283 1920557 1920557 defendant Tremayn John yeoman 589493 589493 Tremayn, John, of Cobham, yeoman 0
3684726 1921357 1921357 defendant Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight, Lord Cobham 0
3684728 1921358 1921358 defendant Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight, Lord Cobham 0
3686492 1921926 1921926 plaintiff Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight 0
3695964 1924978 1924978 plaintiff Roke Emery (legal representative) 589493 589493 Roke, Emery, of Cobham, executors of 0
3701551 1926732 1926732 plaintiff Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight 0
3701553 1926733 1926733 plaintiff Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight 0
3708339 1928903 1928903 defendant Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight, Lord Cobham 0
3715100 1931020 1931020 plaintiff Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight, Lord Cobham 0
3720199 1932592 1932592 defendant Broke alias Cobham George   589493 589493 Broke alias Cobham, George, of Cobham, knight 1
3720203 1932593 1932593 defendant Cobham George   589493 589493 Cobham, George, of Cobham, knight, son of Broke, Thomas 1
3720217 1932597 1932597 defendant Gyrdeler Robert yeoman 589493 589493 Gyrdeler, Robert, of Cobham, yeoman 0
3725195 1934167 1934167 defendant Hamond Robert yeoman 589493 589493 Hamond, Robert, of Cobham, yeoman 0
3725560 1934285 1934285 defendant Coper John husbandman 589493 589493 Coper, John, of Cobham, husbandman 0
3726263 1934481 1934481 defendant Down Robert clerk 589493 589493 Down, Robert, of Cobham, clerk 0
3726265 1934482 1934482 defendant Downe Robert clerk 589493 589493 Downe, Robert, of Cobham, clerk 0
3736608 1937701 1937701 defendant Hychehurst John husbandman 589493 589493 Hychehurst, John, of Cobham, husbandman 0
3741114 1939083 1939083 defendant Hamond Robert yeoman 589493 589493 Hamond, Robert, of Cobham, yeoman 0
3749534 1941767 1941767 plaintiff Hunt William   589493 589493 Hunt, William, of Cobham 0
3776083 1950263 1950263 plaintiff Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight 0
3776085 1950264 1950264 plaintiff Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight 0
3793588 1955857 1955857 defendant Wylson William tailor 589493 589493 Wylson, William, of Cobham, tailor 0
3793591 1955858 1955858 defendant Wylson William tailor 589493 589493 Wylson, William, of Cobham, tailor 0
3802062 1958542 1958542 defendant Wrenne Thomas laborer 589493 589493 Wrenne, Thomas, of Cobham, laborer 1
3802063 1958542 1958542 defendant Wadbroke Emery laborer 589493 589493 Wadbroke, Emery, of Cobham, laborer 2
3802064 1958542 1958542 defendant Lambold Christopher laborer 589493 589493 Lambold, Christopher, of Cobham, laborer 3
3802065 1958542 1958542 defendant Shore Geoffrey laborer 589493 589493 Shore, Geoffrey, of Cobham, laborer 4
3810388 1961138 1961138 plaintiff Broke George   589493 589493 Broke, George, of Cobham, knight 0
3841954 1971048 1971048 defendant Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight, Lord Cobham, administrators of 0
3845694 1972200 1972200 defendant Broke Thomas esq 589493 589493 Broke, Thomas, of Cobham, esq 0
3845731 1972212 1972212 defendant Broke Thomas   589493 589493 Broke, Thomas, of Cobham, knight, Lord Cobham, administrators of 0
3889545 1986735 1986735 defendant Bulfynche John capper 589493 589493 Bulfynche, John, of Cobham, capper 0
3892930 1987883 1987883 defendant Spencer Thomas yeoman 589493 589493 Spencer, Thomas, of Cobham, yeoman 1
3995693 2023204 2023204 defendant Harper John gent 589493 589493 Harper, John, of Cobham, gent 0
4068211 2048933 2048933 plaintiff Kenaistone John (legal representative) 589493 589493 Kenaistone, John, of Cobham, administratrix of 0
4080919 2053490 2053490 defendant Wynchester Thomas yeoman 589493 589493 Wynchester, Thomas, of Cobham, yeoman 0
4109552 2063678 2063678 defendant Parker John gent 589493 589493 Parker, John, of Cobham, gent 1
4112663 2064787 2064787 defendant Herper George gent 589493 589493 Herper, George, of Cobham, gent 0
4222385 2103320 2103320 defendant Alexander Robert yeoman 589493 589493 Alexander, Robert, of Cobham, yeoman 1
4224788 2104137 2104137 defendant Maydman William husbandman 589493 589493 Maydman, William, of Cobham, husbandman 0
4224791 2104138 2104138 defendant Maydman William husbandman 589493 589493 Maydman, William, of Cobham, husbandman 0
4232970 2107040 2107040 defendant Dewe John yeoman 589493 589493 Dewe, John, of Cobham, yeoman 2
4257120 2115358 2115358 defendant Jesoppe John laborer 589493 589493 Jesoppe, John, of Cobham, laborer 1
4257121 2115358 2115358 defendant Burton Hugh laborer 589493 589493 Burton, Hugh, of Cobham, laborer 2
4315352 2135481 2135481 defendant Brooke Henry esq 589493 589493 Brooke, Henry, of Cobham, esq 1
4330468 2140488 2140488 defendant Melsom Edmund husbandman 589493 589493 Melsom, Edmund, of Cobham, husbandman 2
4390369 2161401 2161401 defendant Dalton Robert yeoman 589493 589493 Dalton, Robert, of Cobham, or of Reygate, yeoman 2
4503956 2201796 2201796 defendant Spryner Roger   589493 589493 Spryner, Roger, of Cobham 3
4503965 2201797 2201797 defendant Spryner Roger   589493 589493 Spryner, Roger, of Cobham 3
4564744 2220537 2220537 defendant Dobbe Walter   589493 589493 Dobbe, Walter, of Cobham 0
4565459 2220768 2220768 plaintiff Smyth Robert   589493 589493 Smyth, Robert, of Cobham 0
4565464 2220769 2220769 plaintiff Smyth Robert   589493 589493 Smyth, Robert, of Cobham 0
4575194 2223762 2223762 defendant Ro Walter   589493 589493 Ro, Walter, of Cobham 0
4583986 2226410 2226410 defendant Pope Roger   589493 589493 Pope, Roger, of Cobham 0
4632278 2240984 2240984 defendant Sprenere John, sen   589493 589493 Sprenere, John, sen, of Cobham 0
4656079 2247780 2247780 defendant Jamys Walter draper 589493 589493 Jamys, Walter, of Cobham, draper 1
4690148 2262473 2262473 defendant James William husbandman 589493 589493 James, William, of Cobham, husbandman 3
4696999 2264539 2264539 plaintiff Chipp Roger   589493 589493 Chipp, Roger, of Cobham 0
4709227 2268253 2268253 defendant Yong Thomas   589493 589493 Yong, Thomas, of Cobham, shoe maker 2
4734044 2275832 2275832 defendant Jocekyn Richard butcher 589493 589493 Jocekyn, Richard, of Cobham, butcher 0
4766171 2285412 2285412 defendant Broke Laurence husbandman 589493 589493 Broke, Laurence, of Cobham, husbandman 0
4787699 2292222 2292222 defendant Dobbys Walter husbandman 589493 589493 Dobbys, Walter, of Cobham, husbandman 0
4790559 2293139 2293139 defendant Broke Lawrence husbandman 589493 589493 Broke, Lawrence, of Cobham, husbandman 0
4819158 2302070 2302070 defendant Sprenere John butcher 589493 589493 Sprenere, John, of Cobham, butcher 0
4843635 2309532 2309532 defendant Joskyn Richard yeoman 589493 589493 Joskyn, Richard, of Cobham, yeoman 0
4876556 2319632 2319632 defendant Joskyn Richard yeoman 589493 589493 Joskyn, Richard, of Cobham, yeoman 0
4876557 2319632 2319632 defendant Sprever John yeoman 589493 589493 Sprever, John, of Cobham, yeoman 1
4883278 2321696 2321696 defendant Chippe Roger tailor 589493 589493 Chippe, Roger, of Cobham, tailor 0
4896984 2325706 2325706 defendant Chyppe Roger husbandman 589493 589493 Chyppe, Roger, of Cobham, husbandman 0
4906485 2328613 2328613 defendant Chyppe Roger husbandman 589493 589493 Chyppe, Roger, of Cobham, husbandman 0
4907023 2328772 2328772 defendant Braynches Robert carpenter 589493 589493 Braynches, Robert, of Cobham, carpenter 0
4924817 2334195 2334195 defendant Chippe Roger tailor 589493 589493 Chippe, Roger, of Cobham, tailor 0
4924818 2334195 2334195 defendant Chippe   tailor 589493 589493 Chippe, Salter, of Cobham, tailor 1
4924830 2334199 2334199 defendant Chippe Roger tailor 589493 589493 Chippe, Roger, of Cobham, tailor 0
4924831 2334199 2334199 defendant Chippe Walter tailor 589493 589493 Chippe, Walter, of Cobham, tailor 1
4961900 2345513 2345513 defendant Sprener or Sprever John butcher 589493 589493 Sprener or Sprever, John, of Cobham, butcher 0
4961902 2345513 2345513 defendant Stace Robert weaver 589493 589493 together with Stace, Robert, of Cobham, weaver 2
4961903 2345513 2345513 defendant Stace Walter weaver 589493 589493 Stace, Walter, of Cobham, weaver 3
4961904 2345513 2345513 defendant Stace Reginald weaver 589493 589493 Stace, Reginald, of Cobham, weaver 4
4961906 2345514 2345514 defendant Stace Robert weaver 589493 589493 Stace, Robert, of Cobham, weaver 0

Next page

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