names

67 rows where place_id = 588529

✎ 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
3594818 1866008 1866008 defendant Manware William husbandman 588529 588529 Manware, William, of Eltham, Kent, husbandman 2
3595592 1866250 1866250 defendant Birde Joan widow 588529 588529 (Birde, Joan, of Eltham, Kent, widow 4
3642971 1908251 1908251 defendant Morton Thomas gent 588529 588529 Morton, Thomas, of Eltham, Kent, gent 4
3644126 1908595 1908595 defendant Morton John gent 588529 588529 Morton, John, of Eltham, Kent, gent 0
3719515 1932367 1932367 defendant Prate Elizabeth widow 588529 588529 Prate, Elizabeth, of Eltham, Kent, widow 5
3804900 1959476 1959476 defendant Bold John yeoman 588529 588529 Bold, John, of Eltham, Kent, yeoman 0
3804903 1959477 1959477 defendant Bold John yeoman 588529 588529 Bold, John, of Eltham, Kent, yeoman 0
3825187 1965744 1965744 defendant Rolte John yeoman 588529 588529 Rolte, John, of Eltham, Kent, yeoman 1
3839224 1970196 1970196 defendant Dod Ralph gent 588529 588529 Dod, Ralph, of Eltham, Kent, gent 0
3839228 1970197 1970197 defendant Dod Ralph gent 588529 588529 Dod, Ralph, of Eltham, Kent, gent 0
3855931 1975480 1975480 defendant Davye Hugh yeoman 588529 588529 Davye, Hugh, of Eltham, Kent, yeoman 2
3855935 1975481 1975481 defendant Davye Hugh yeoman 588529 588529 Davye, Hugh, of Eltham, kent, yeoman 2
3856817 1975755 1975755 defendant Davye Hugh yeoman 588529 588529 Davye, Hugh, of Eltham, Kent, yeoman 2
3886855 1985867 1985867 defendant Brykhede John esq 588529 588529 Brykhede, John, of Eltham, Kent, esq 0
3891292 1987354 1987354 defendant Brykett John gent 588529 588529 Brykett, John, of Eltham, Kent, gent 0
3915102 1995407 1995407 defendant Brykkett John esq 588529 588529 Brykkett, John, of Eltham, Kent, esq 0
4002526 2025670 2025670 plaintiff Heron Thomas esq 588529 588529 Heron, Thomas, of Eltham, Kent, esq 0
4002528 2025671 2025671 plaintiff Heron Thomas esq 588529 588529 Heron, Thomas, of Eltham, Kent, esq 0
4145498 2076582 2076582 defendant Harpar George gent 588529 588529 Harpar, George, of Eltham, Kent, gent 4
4231394 2106481 2106481 defendant Fowler Roger yeoman 588529 588529 Fowler, Roger, of Eltham, Kent, or of Comes , Suff, yeoman 0
4246869 2111927 2111927 defendant Forest John gent 588529 588529 Forest, John, of Eltham, Kent, gent 0
4246871 2111928 2111928 defendant Forest John gent 588529 588529 Forest, John, of Eltham, Kent, gent 0
4247367 2112096 2112096 defendant Forrest John gent 588529 588529 Forrest, John, of Eltham, Kent, gent 0
4251368 2113439 2113439 defendant Forrest John   588529 588529 Forrest, John, of Eltham, Kent, gwnt 0
4260061 2116332 2116332 defendant Forest John gent 588529 588529 Forest, John, of Eltham, Kent, gent 0
4265079 2117956 2117956 defendant Forrest John gent 588529 588529 Forrest, John, of Eltham, Kent, gent 0
4265256 2118022 2118022 defendant Forest John gent 588529 588529 Forest, John, of Eltham, Kent, gent 0
4272144 2120248 2120248 defendant Forrest John gent 588529 588529 Forrest, John, of Eltham, Kent, gent 0
4308091 2132974 2132974 defendant Gynokes or Eynokes Robert yeoman 588529 588529 Gynokes or Eynokes, Robert, of Eltham, Kent, yeoman 1
4308130 2132989 2132989 defendant Fowler Roger yeoman 588529 588529 Fowler, Roger, of Eltham, Kent, or of Combes, Suff, yeoman 0
4334848 2141919 2141919 defendant Twiste Lancelot gent 588529 588529 Twiste, Lancelot, of Eltham, Kent, gent 1
4358188 2150098 2150098 defendant Twiste Lancelot gent 588529 588529 Twiste, Lancelot, of Eltham, Kent, gent 1
4652709 2246783 2246783 defendant atte Ree Richard husbandman 588529 588529 atte Ree, Richard, of Eltham, Kent, husbandman 24
4661399 2249389 2249389 defendant Sharnesfeld Margaret gent 588529 588529 Sharnesfeld, Margaret, of Eltham, Kent, gent 0
4679204 2259104 2259104 defendant Sharnesfeld Margaret widow 588529 588529 Sharnesfeld, Margaret, of Eltham, Kent, widow 0
4693909 2263598 2263598 defendant Sharnesfeld Margaret widow 588529 588529 Sharnesfeld, Margaret, of Eltham, Kent, widow 0
4721740 2272135 2272135 defendant Rande John husbandman 588529 588529 Rande, John, of Eltham, Kent, husbandman 0
4760978 2283777 2283777 defendant Rande Robert yeoman 588529 588529 Rande, Robert, of Eltham, Kent, yeoman 1
4968928 2347670 2347670 defendant Fraunceys John husbandman 588529 588529 Fraunceys, John, of Eltham, Kent, husbandman 4
4969144 2347733 2347733 defendant Fraunceys John husbandman 588529 588529 Fraunceys, John, of Eltham, Kent, husbandman 3
5091833 2383994 2383994 defendant Leche David yeoman 588529 588529 Leche, David, of Eltham, Kent, yeoman 0
5109070 2389073 2389073 defendant Fraunceys John   588529 588529 Fraunceys, John, of Eltham, Kent 0
5123582 2393353 2393353 defendant A Dane John yeoman 588529 588529 A Dane, John, of Eltham, Kent, yeoman 0
5124204 2393537 2393537 defendant A Dane John yeoman 588529 588529 A Dane, John, of Eltham, Kent, yeoman 0
5152147 2401765 2401765 defendant Fraunceys John yeoman 588529 588529 Fraunceys, John, of Eltham, Kent, yeoman 0
5169018 2406670 2406670 defendant Fraunceys John, sen brewer 588529 588529 Fraunceys, John, sen, of Eltham, Kent, brewer 0
5170021 2406967 2406967 defendant Fraunceys John yeoman 588529 588529 Fraunceys, John, of Eltham, Kent, yeoman 0
5170024 2406968 2406968 defendant Fraunceys John yeoman 588529 588529 Fraunceys, John, of Eltham, Kent, yeoman 0
5185063 2411372 2411372 defendant Fraunceys John yeoman 588529 588529 Fraunceys, John, of Eltham, Kent, yeoman 0
5187361 2412028 2412028 defendant Fraunceys John yeoman 588529 588529 Fraunceys, John, of Eltham, Kent, yeoman 0
5187364 2412029 2412029 defendant Fraunceys John yeoman 588529 588529 Fraunceys, John, of Eltham, Kent, yeoman 0
5222874 2422404 2422404 defendant Kene William esq 588529 588529 Kene, William, of Eltham, Kent, esq 0
5268513 2435910 2435910 defendant Spenser Thomas husbandman 588529 588529 Spenser, Thomas, of Eltham, Kent, husbandman 0
5302525 2445727 2445727 defendant Fraunceys John yeoman 588529 588529 Fraunceys, John, of Eltham, Kent, yeoman 0
5311920 2448592 2448592 defendant Benet Peter gent 588529 588529 Benet, Peter, of Eltham, Kent, gent 0
5318517 2450634 2450634 defendant Coggar John chapman 588529 588529 Coggar, John, of Eltham, Kent, chapman 3
5321199 2451437 2451437 defendant Sunbury Roger husbandman 588529 588529 Sunbury, Roger, of Eltham, Kent, husbandman 1
5321200 2451437 2451437 defendant Upton John laborer 588529 588529 Upton, John, of Eltham, Kent, laborer 2
5329207 2453814 2453814 defendant Benet Peter gent 588529 588529 Benet, Peter, of Eltham, Kent, gent 0
5354314 2461416 2461416 defendant Netylton Robert yeoman 588529 588529 Netylton, Robert, of Eltham, Kent, yeoman 2
5479671 2498928 2498928 defendant Grene Robert butcher 588529 588529 Grene, Robert, of Eltham, Kent, butcher 4
5508587 2507549 2507549 defendant Gest Richard husbandman 588529 588529 Gest, Richard, of Eltham, Kent, husbandman 1
5536634 2515942 2515942 defendant Grene Robert (legal representative) 588529 588529 Grene, Robert, of Eltham, Kent, butcher, executrix of 2
5566714 2524862 2524862 defendant Sutton Ralph brewer 588529 588529 Sutton, Ralph, of Eltham, Kent, brewer 1
5571150 2526125 2526125 defendant Ansy or Ausy William tiler 588529 588529 Ansy or Ausy, William, of Eltham, Kent, tiler 0
5573346 2526762 2526762 defendant Annysley Thomas yeoman 588529 588529 Annysley, Thomas, of Eltham, Kent, king's household, yeoman 0
5606459 2536908 2536908 defendant Wever John husbandman 588529 588529 Wever, John, of Eltham, Kent, husbandman 4

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