names

72 rows where place_id = 588787

✎ 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
3595590 1866250 1866250 defendant Fyssher David yeoman 588787 588787 Fyssher, David, of Est Grenewyche, Kent, yeoman 2
3622068 1874441 1874441 defendant Cressell Godfrey yeoman 588787 588787 Cressell, Godfrey, of Est Grenewyche, Kent, yeoman 3
3636557 1906227 1906227 defendant Styrley Thomas brewer 588787 588787 Styrley, Thomas, of Est Grenewyche, Kent, brewer 0
3689497 1922871 1922871 defendant Grey Richard   588787 588787 Grey, Richard, of Est Grenewyche, Kent, knight 1
3713384 1930501 1930501 defendant Nores Henry esq 588787 588787 Nores, Henry, of Est Grenewyche, Kent, esq 0
3713477 1930527 1930527 defendant Hope Richard yeoman of the crown 588787 588787 Hope, Richard, of Est Grenewyche, Kent, yeoman of the crown 0
3717171 1931657 1931657 defendant Norres Henry esq 588787 588787 Norres, Henry, of Est Grenewyche, Kent, esq 0
3717183 1931661 1931661 defendant Norres Henry esq 588787 588787 Norres, Henry, of Est Grenewyche, Kent, esq 0
3720710 1932769 1932769 defendant Nores Henry esq 588787 588787 Nores, Henry, of Est Grenewyche, Kent, esq 0
3728856 1935272 1935272 defendant Nores Henry esq 588787 588787 Nores, Henry, of Est Grenewyche, Kent, esq 1
3729025 1935326 1935326 defendant Knyvet William gent 588787 588787 Knyvet, William, of King's household, Est Grenewyche, Kent, gent 0
3731832 1936183 1936183 defendant Banester Robert clerk 588787 588787 Banester, Robert, of Est Grenewyche, Kent, clerk 0
3732246 1936325 1936325 defendant Symons William gent 588787 588787 Symons, William, of Est Grenewyche, Kent, gent 0
3735857 1937453 1937453 defendant Corpson Robert yeoman of the chamber 588787 588787 Corpson, Robert, of Est Grenewyche, Kent, yeoman of the chamber 0
3741027 1939055 1939055 defendant Palmer Robert yeoman 588787 588787 Palmer, Robert, of Est Grenewyche, Kent, yeoman 0
3755548 1943693 1943693 defendant Legh William gent 588787 588787 Legh, William, of Est Grenewyche, Kent, gent 1
3758311 1944594 1944594 defendant Gyles John gent 588787 588787 Gyles, John, of Est Grenewyche, Kent, gent 0
3760524 1945295 1945295 defendant Pye John esq 588787 588787 Pye, John, of Est Grenewyche, Kent, esq 3
3760529 1945296 1945296 defendant Pye John esq 588787 588787 Pye, John, of Est Grenewyche, Kent, esq 3
3770039 1948292 1948292 defendant Aldewen Philip yeoman 588787 588787 Aldewen, Philip, of Est Grenewyche, Kent, yeoman 0
3770199 1948347 1948347 defendant Aldwen Philip yeoman 588787 588787 Aldwen, Philip, of East Grenewyche, Kent, yeoman 0
3771850 1948885 1948885 defendant Butler William   588787 588787 Butler, William, of Est Grenewyche, Kent, sergeant at arms 0
3771855 1948886 1948886 defendant Butler William   588787 588787 Butler, William, of Est Grenewyche, Kent, sergeant at arms 0
3773037 1949269 1949269 defendant Boleyn Edward   588787 588787 Boleyn, Edward, of Est Grenewyche, Kent, knight 0
3777790 1950786 1950786 defendant Derell Edward   588787 588787 Derell, Edward, of East Grenewyche, Kent, knight 0
3780422 1951611 1951611 defendant Dudley John   588787 588787 Dudley, John, of Est Grenewyche, Kent, knight 0
3801510 1958384 1958384 defendant Browne Anthony esq 588787 588787 Browne, Anthony, of Est Grenewyche, Kent, esq 2
3801570 1958394 1958394 defendant Becka Elias yeoman of the guard 588787 588787 Becka, Elias, of Est Grenewyche, Kent, yeoman of the guard 0
3806993 1960086 1960086 defendant Bayly Richard tailor 588787 588787 Bayly, Richard, of Est Grenewyche, Kent, tailor 1
3807019 1960089 1960089 defendant Agwilliams John   588787 588787 Agwilliams, John, of Est Grenewyche, Kent, sergeant at arms 1
3807039 1960092 1960092 defendant Hogan John gent 588787 588787 Hogan, John, of Est Grenewyche, Kent, gent 3
3809955 1961001 1961001 plaintiff Boleyn William gent 588787 588787 Boleyn, William, of Est Grenewyche, Kent, gent 0
3813609 1962172 1962172 defendant Webbe Henry esq 588787 588787 Webbe, Henry, of Est Grenewyche, Kent, esq 0
3815037 1962624 1962624 defendant Howard Edmund   588787 588787 Howard, Edmund, of Est Grenewyche, Kent, knight 0
3815039 1962625 1962625 defendant Howard Edmund   588787 588787 Howard, Edmund, of Est Grenewyche, Kent, knight, Lord Howard 0
3817910 1963519 1963519 defendant Copynger John gent 588787 588787 Copynger, John, of Est Grenewyche, Kent, gent 0
3823377 1965226 1965226 defendant Wyat Thomas esq 588787 588787 Wyat, Thomas, of Est Grenewyche, Kent, esq 0
3827792 1966559 1966559 defendant Throgmorten John gent 588787 588787 Throgmorten, John, of Est Grenewyche, Kent, gent 2
3831284 1967669 1967669 defendant Howard Edward   588787 588787 Howard, Edward, of Est Grenewyche, Kent, knight 0
3848416 1973081 1973081 defendant Grene Richard gent 588787 588787 Grene, Richard, of Est Grenewyche, Kent, gent 0
3848712 1973184 1973184 defendant Walyson Christopher gent 588787 588787 Walyson, Christopher, of Est Grenewyche, Kent, gent 1
3854921 1975185 1975185 defendant Nevyll Humphrey gent 588787 588787 Nevyll, Humphrey, of Est Grenewyche, Kent, gent 0
3861321 1977257 1977257 defendant Byrd Henry   588787 588787 Byrd, Henry, of Est Grenewyche, Kent 0
3861729 1977387 1977387 defendant Alen Thomas gent 588787 588787 Alen, Thomas, of Est Grenewyche, Kent, gent 1
3862754 1977735 1977735 defendant Care Thomas gent 588787 588787 Care, Thomas, of Est Grenewyche, Kent, gent 1
3866384 1978989 1978989 defendant Whytney James esq 588787 588787 Whytney, James, of Est Grenewyche, Kent, esq 1
3871244 1980635 1980635 defendant Culpeper John gent 588787 588787 Culpeper, John, of Est Grenewyche, Kent, gent 2
3887460 1986070 1986070 defendant Foxe Edward gent 588787 588787 Foxe, Edward, of Est Grenewyche, Kent, gent 1
3895860 1988824 1988824 defendant Balard Nicholas gent 588787 588787 Balard, Nicholas, of Est Grenewyche, Kent, gent 0
3905867 1992246 1992246 defendant Drew John gent 588787 588787 Drew, John, of Est Grenewyche, Kent, gent 0
3905870 1992247 1992247 defendant Drewe John gent 588787 588787 Drewe, John, of Est Grenewyche, Kent, gent 0
3947039 2006028 2006028 defendant Ballard Nicholas gent 588787 588787 Ballard, Nicholas, of Est Grenewyche, Kent, gent 2
3958733 2010130 2010130 defendant Lyte or Light Anthony gent 588787 588787 Lyte or Light, Anthony, of East Grenewyche, Kent, gent 0
4005017 2026578 2026578 defendant Newporte Thomas gent 588787 588787 Newporte, Thomas, of Est Grenewyche, Kent, gent 0
4014026 2029751 2029751 plaintiff Sampson William   588787 588787 Sampson, William, of Est Grenewyche, Kent, baker or yeoman, administrators of 0
4080311 2053267 2053267 defendant Wyseman Robert esq 588787 588787 Wyseman, Robert, of Est Grenewyche, Kent, esq 0
4305710 2132134 2132134 defendant Orrell William yeoman 588787 588787 Orrell, William, of East Grenewyche, Kent, yeoman 1
4907516 2328914 2328914 defendant Orchard Richard   588787 588787 Orchard, Richard, of Est Grenewyche, Kent, servant 1
5096540 2385420 2385420 defendant Buk John husbandman 588787 588787 Buk, John, of Est Grenewyche, Kent, husbandman 0
5220613 2421721 2421721 defendant Cheseman Thomas gent 588787 588787 Cheseman, Thomas, of Est Grenewyche, Kent, gent 0
5234706 2425736 2425736 defendant Cheseman Thomas gent 588787 588787 Cheseman, Thomas, of Est Grenewyche, Kent, gent 0
5238967 2426988 2426988 plaintiff Hathewy John yeoman 588787 588787 Hathewy, John, of Est Grenewyche, Kent, yeoman 0
5295410 2443648 2443648 defendant Pope Robert husbandman 588787 588787 Pope, Robert, of Est Grenewyche, Kent, husbandman 0
5318213 2450542 2450542 defendant Chycheley William esq 588787 588787 Chycheley, William, of Est Grenewyche, Kent, esq 1
5323116 2451998 2451998 defendant Valans Thomas yeoman 588787 588787 Valans, Thomas, of Est Grenewyche, Kent, yeoman 0
5328615 2453637 2453637 defendant Herberd John haberdasher 588787 588787 Herberd, John, of Est Grenewyche, Kent, haberdasher 1
5357873 2462530 2462530 defendant Mychell John yeoman 588787 588787 Mychell, John, of Est Grenewyche, Kent, yeoman 0
5504384 2506288 2506288 defendant Henam John   588787 588787 Henam, John, of Est Grenewyche, Kent, car- 1
5512738 2508839 2508839 defendant Wilson Robert yeoman 588787 588787 Wilson, Robert, of Est Grenewyche, Kent, yeoman 2
5528665 2513478 2513478 defendant Kene George gent 588787 588787 Kene, George, of Est Grenewyche, Kent, gent 1
5566397 2524762 2524762 plaintiff Coke William (legal representative) 588787 588787 Coke, William, of Est Grenewyche, Kent, lighterman, executors of 0
5595145 2533450 2533450 defendant Mountford Simon gent 588787 588787 Mountford, Simon, of Est Grenewyche, Kent, gent 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);