names

68 rows where place_id = 591868

✎ 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
3605835 1869493 1869493 defendant Birde Philip husbandman 591868 591868 Birde, Philip, of Eltham, husbandman 0
3641756 1907873 1907873 defendant Vaghan John gent 591868 591868 Vaghan, John, of Eltham, gent 0
3656813 1912385 1912385 defendant Broun John butcher 591868 591868 Broun, John, of Eltham, butcher 5
3670345 1916677 1916677 defendant Franceys John husbandman 591868 591868 Franceys, John, of Eltham, husbandman 0
3670346 1916677 1916677 defendant Plomme John   591868 591868 Plomme, John, of Eltham, cook 1
3670394 1916696 1916696 plaintiff Browne John yeoman 591868 591868 Browne, John, of Eltham, yeoman 0
3670395 1916696 1916696 defendant Fraunceys John yeoman 591868 591868 Fraunceys, John, of Eltham, yeoman 0
3672884 1917532 1917532 defendant Vaugham John gent 591868 591868 Vaugham, John, of Eltham, gent 0
3721353 1932985 1932985 defendant Rases Richard husbandman 591868 591868 Rases, Richard, of Eltham, husbandman 3
3721404 1933002 1933002 defendant Rases Richard husbandman 591868 591868 Rases, Richard, of Eltham, husbandman 3
4002524 2025669 2025669 plaintiff Heron Thomas   591868 591868 Heron, Thomas, of Eltham, Kent esq 0
4050083 2042457 2042457 defendant Graunt William collier 591868 591868 Graunt, William, of Eltham, collier 0
4135253 2072927 2072927 defendant Baker William yeoman 591868 591868 Baker, William, of Eltham, yeoman 2
4227855 2105224 2105224 defendant Snoxsell alias Snockson Edward Yeoman of the Tower of London 591868 591868 Snoxsell alias Snockson, Edward, of Eltham, Yeoman of the Tower of London 0
4256553 2115161 2115161 defendant Snoxell Edward Yeoman of the Tower of London 591868 591868 Snoxell, Edward, of Eltham, yeoman, Yeoman of the Tower of London 0
4457429 2187334 2187334 defendant Fydn William   591868 591868 Fydn, William, of Eltham 0
4488179 2197018 2197018 defendant Rate John   591868 591868 Rate, John, of Eltham 1
4504798 2202041 2202041 plaintiff Sculle John   591868 591868 Sculle, John, of Eltham 0
4576842 2224262 2224262 defendant Whistylby John   591868 591868 Whistylby, John, of Eltham 2
4576845 2224262 2224262 defendant Parker John   591868 591868 Parker, John, of Eltham 5
4610205 2234275 2234275 defendant atte Ree Richard   591868 591868 atte Ree, Richard, of Eltham 0
4610206 2234275 2234275 defendant Bocher Roger   591868 591868 Bocher, Roger, of Eltham 1
4638306 2242749 2242749 defendant atte Ree Richard   591868 591868 atte Ree, Richard, of Eltham 0
4651533 2246484 2246484 defendant atte Ree Richard husbandman 591868 591868 atte Ree, Richard, of Eltham, husbandman 0
4651534 2246484 2246484 defendant Parker John husbandman 591868 591868 Parker, John, of Eltham, husbandman 1
4652711 2246783 2246783 defendant Neweman John miller 591868 591868 Neweman, John, of Eltham, miller 26
4698636 2265051 2265051 defendant Parker John husbandman 591868 591868 Parker, John, of Eltham, husbandman 2
4737152 2276737 2276737 defendant Sharnesfeld Margaret   591868 591868 Sharnesfeld, Margaret, of Eltham, Kent, gentlewoman, formerly wife of Nicholas Sharnesfeld, knight 0
4774886 2288138 2288138 defendant Scull John husbandman 591868 591868 Scull, John, of Eltham, husbandman 0
4826531 2304333 2304333 defendant Wodcok John yeoman 591868 591868 Wodcok, John, of Eltham, yeoman 2
4836485 2307390 2307390 defendant Rand Robert   591868 591868 Rand, Robert, of Eltham 1
4836494 2307390 2307390 defendant Merfyn Robert gent 591868 591868 Merfyn, Robert, of Eltham, gent 10
4836495 2307390 2307390 defendant Wodecok John yeoman 591868 591868 Wodecok, John, of Eltham, yeoman 11
4836496 2307390 2307390 defendant atte Ree Richard yeoman 591868 591868 atte Ree, Richard, of Eltham, yeoman 12
4836499 2307391 2307391 defendant Rand Robert   591868 591868 Rand, Robert, of Eltham 1
4836508 2307391 2307391 defendant Merfyn Robert gent 591868 591868 Merfyn, Robert, of Eltham, gent 10
4836509 2307391 2307391 defendant Wodecok John yeoman 591868 591868 Wodecok, John, of Eltham, yeoman 11
4836510 2307391 2307391 defendant atte Ree Richard yeoman 591868 591868 atte Ree, Richard, of Eltham, yeoman 12
4894492 2324949 2324949 defendant Cheseman Roger husbandman 591868 591868 Cheseman, Roger, of Eltham, husbandman 0
5060043 2374568 2374568 defendant Lexham Robert husbandman 591868 591868 Lexham, Robert, of Eltham, husbandman 0
5060046 2374569 2374569 defendant Maneware Thomas laborer 591868 591868 Maneware, Thomas, of Eltham, laborer 0
5061200 2374933 2374933 defendant Mose John butcher 591868 591868 Mose, John, of Eltham, butcher 0
5063897 2375734 2375734 defendant Fraunceys John husbandman 591868 591868 Fraunceys, John, of Eltham, husbandman 0
5073621 2378594 2378594 defendant Mose John butcher 591868 591868 Mose, John, of Eltham, butcher 1
5073624 2378595 2378595 defendant Mose John butcher 591868 591868 Mose, John, of Eltham, butcher 1
5091837 2383994 2383994 defendant Michell Robert yeoman 591868 591868 Michell, Robert, of Eltham, yeoman 4
5116027 2391115 2391115 defendant Keen William esq 591868 591868 Keen, William, of Eltham, esq 0
5120057 2392304 2392304 defendant Manward Thomas husbandman 591868 591868 Manward, Thomas, of Eltham, husbandman 2
5139206 2397957 2397957 defendant Fraunceys John husbandman 591868 591868 Fraunceys, John, of Eltham, husbandman 0
5160081 2404048 2404048 defendant Fraunceys John husbandman 591868 591868 Fraunceys, John, of Eltham, husbandman 0
5195926 2414553 2414553 defendant Fraunceys John husbandman 591868 591868 Fraunceys, John, of Eltham, husbandman 0
5222430 2422270 2422270 defendant Pope John husbandman 591868 591868 Pope, John, of Eltham, husbandman 0
5285837 2440883 2440883 defendant Tyrvyn Thomas yeoman 591868 591868 Tyrvyn, Thomas, of Eltham, yeoman 0
5321201 2451437 2451437 defendant Manward John yeoman 591868 591868 Manward, John, of Eltham, yeoman 3
5321202 2451437 2451437 defendant Dene Bernard laborer 591868 591868 Dene, Bernard, of Eltham, laborer 4
5367971 2465607 2465607 defendant Torold Thomas laborer 591868 591868 Torold, Thomas, of Eltham, laborer 0
5432048 2484553 2484553 defendant Styleman Christopher husbandman 591868 591868 Styleman, Christopher, of Eltham, husbandman 0
5460606 2493117 2493117 defendant Styleman Christopher husbandman 591868 591868 Styleman, Christopher, of Eltham, husbandman 0
5469284 2495742 2495742 defendant Styleman Christopher husbandman 591868 591868 Styleman, Christopher, of Eltham, husbandman 0
5471254 2496339 2496339 defendant Grene Robert butcher 591868 591868 Grene, Robert, of Eltham, butcher 0
5516103 2509886 2509886 defendant Homan Bartholomew husbandman 591868 591868 Homan, Bartholomew, of Eltham, husbandman 0
5516104 2509886 2509886 defendant Hoghan Roger   591868 591868 Hoghan, Roger, of Eltham 1
5516105 2509886 2509886 defendant Cheseman Thomas husbandman 591868 591868 Cheseman, Thomas, of Eltham, husbandman 2
5529410 2513711 2513711 defendant Annesley Thomas yeoman 591868 591868 Annesley, Thomas, of Eltham, yeoman 0
5536635 2515942 2515942 defendant Grene Joan widow 591868 591868 Grene, Joan, of Eltham, widow 3
5536646 2515944 2515944 defendant Taillour Thomas tailor 591868 591868 Taillour, Thomas, of Eltham, tailor 4
5536684 2515959 2515959 defendant Broun John yeoman 591868 591868 Broun, John, of Eltham, yeoman 0
5545771 2518754 2518754 defendant Stodard John yeoman 591868 591868 Stodard, John, of Eltham, yeoman 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);