names

63 rows where place_id = 608196

✎ 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
3672571 1917418 1917418 defendant Fysshe Simon gent 608196 608196 Fysshe, Simon, of Wynchelse, Sussex, gent 1
3692310 1923764 1923764 defendant Cooke Robert yeoman 608196 608196 Cooke, Robert, of Wynchelse, Sussex, yeoman 4
3749657 1941804 1941804 defendant Fysshe Simon yeoman 608196 608196 Fysshe, Simon, of Wynchelse, Sussex, yeoman 0
3753315 1942974 1942974 defendant Fosterd Thomas gent 608196 608196 Fosterd, Thomas, of Wynchelse, Sussex, gent 3
3766685 1947241 1947241 defendant Ensyng Thomas yeoman 608196 608196 (Ensyng, Thomas, of Wynchelse, Sussex, yeoman 2
3766690 1947242 1947242 defendant Ensyng Thomas yeoman 608196 608196 (Ensyng, Thomas, of Wynchelse, Sussex, yeoman 2
3794740 1956232 1956232 plaintiff Blake John merchant 608196 608196 Blake, John, of Wynchelse, Sussex, merchant 1
3798365 1957387 1957387 defendant Ensyng Thomas gent 608196 608196 Ensyng, Thomas, of Wynchelse, Sussex, gent 0
3798815 1957544 1957544 defendant Heyman John yeoman 608196 608196 Heyman, John, of Wynchelse, Sussex, yeoman 0
3924564 1998531 1998531 defendant Lowys George gent 608196 608196 Lowys, George, of Wynchelse, Sussex, gent 1
4600197 2231290 2231290 defendant Penbrook William   608196 608196 Penbrook, William, of Wynchelse, Sussex 0
4666704 2255309 2255309 defendant Gilbert Richard merchant 608196 608196 Gilbert, Richard, of Wynchelse, Sussex, merchant 0
4672240 2256965 2256965 defendant Seynjon Edward gent 608196 608196 Seynjon, Edward, of Wynchelse, Sussex, gent 1
4672243 2256966 2256966 defendant St John Edward gent 608196 608196 St John, Edward, of Wynchelse, Sussex, gent 1
4681317 2259783 2259783 defendant Gilberd Richard merchant 608196 608196 Gilberd, Richard, of Wynchelse, Sussex, merchant 0
4691671 2262928 2262928 defendant Whytyng William baker 608196 608196 Whytyng, William, of Wynchelse, Sussex, baker 2
4734189 2275874 2275874 defendant Wade John   608196 608196 Wade, John, of Wynchelse, Sussex, parson 0
4739704 2277494 2277494 defendant Tamworth Henry draper 608196 608196 Tamworth, Henry, of Wynchelse, Sussex, draper 1
4752222 2281122 2281122 defendant Fynche William gent 608196 608196 Fynche, William, of Wynchelse, Sussex, gent 4
4752227 2281123 2281123 defendant Fynche or Fyche William gent 608196 608196 Fynche or Fyche, William, of Wynchelse, Sussex, gent 3
4773174 2287578 2287578 defendant Tomworthe Henry chapman 608196 608196 Tomworthe, Henry, of Wynchelse, Sussex, chapman 1
4776369 2288601 2288601 defendant Spencer John yeoman 608196 608196 Spencer, John, of Wynchelse, Sussex, yeoman 2
4791394 2293402 2293402 defendant Tamworth Henry chapman 608196 608196 Tamworth, Henry, of Wynchelse, Sussex, chapman 0
4834975 2306941 2306941 defendant Skele William yeoman 608196 608196 together with Skele, William, of Wynchelse, Sussex, yeoman 2
4872974 2318505 2318505 defendant Tamworth Henry husbandman 608196 608196 Tamworth, Henry, of Wynchelse, Sussex, husbandman 1
4872976 2318505 2318505 defendant Frensshe John draper 608196 608196 Frensshe, John, of Wynchelse, Sussex, draper 3
4896150 2325453 2325453 defendant Parcer John (legal representative) 608196 608196 Parcer, John, of Wynchelse, Sussex, bowyer, executors of 0
4901753 2327154 2327154 defendant Porter John (legal representative) 608196 608196 Porter, John, of Wynchelse, Sussex, bowyer, executors of 0
4926189 2334615 2334615 defendant White Richard merchant 608196 608196 White, Richard, of Wynchelse, Sussex, merchant 4
4950525 2342125 2342125 defendant Frenssh John draper 608196 608196 Frenssh, John, of Wynchelse, Sussex, or of Stronde, draper 0
5002193 2357546 2357546 defendant Corlyng Thomas merchant 608196 608196 Corlyng, Thomas, of Wynchelse, Sussex, merchant 0
5031023 2365951 2365951 defendant Long William chapman 608196 608196 Long, William, of Wynchelse, Sussex, chapman 3
5037420 2367815 2367815 defendant Grete Thomas husbandman 608196 608196 Grete, Thomas, of Wynchelse, Sussex, husbandman 0
5049669 2371524 2371524 defendant White Roger merchant 608196 608196 White, Roger, of Wynchelse, Sussex, merchant 3
5049831 2371577 2371577 defendant White Roger merchant 608196 608196 White, Roger, of Wynchelse, Sussex, merchant 3
5092596 2384210 2384210 defendant Crook alias Morys Robert merchant 608196 608196 Crook alias Morys, Robert, of Wynchelse, Sussex, merchant 2
5217254 2420780 2420780 defendant Browenyng Richard chapman 608196 608196 Browenyng, Richard, of Wynchelse, Sussex, chapman 3
5223299 2422506 2422506 defendant Frensh John gent 608196 608196 Frensh, John, of Wynchelse, Sussex, gent 4
5253595 2431234 2431234 defendant Basele Robert esq 608196 608196 Basele, Robert, of Wynchelse, Sussex, esq 0
5279858 2439189 2439189 defendant Clerk John chapman 608196 608196 Clerk, John, of Wynchelse, Sussex, chapman 1
5337627 2456322 2456322 defendant Longe William draper 608196 608196 Longe, William, of Wynchelse, Sussex, draper 1
5343588 2458181 2458181 defendant Andrewe John draper 608196 608196 Andrewe, John, of Wynchelse, Sussex, draper 1
5343597 2458183 2458183 defendant Andrewe John draper 608196 608196 Andrewe, John, of Wynchelse, Sussex, draper 2
5361384 2463580 2463580 defendant Andrewe John draper 608196 608196 Andrewe, John, of Wynchelse, Sussex, draper 4
5395257 2473717 2473717 defendant Clerk John   608196 608196 Clerk, John, of wynchelse, Sussex, sergeant 2
5408524 2477514 2477514 defendant Clerk John   608196 608196 Clerk, John, of Wynchelse, Sussex, sergeant 2
5421695 2481426 2481426 defendant Clerk John   608196 608196 Clerk, John, of Wynchelse, Sussex, sergeant 2
5437989 2486298 2486298 defendant Carvell William tailor 608196 608196 Carvell, William, of Wynchelse, Sussex, tailor 3
5452083 2490504 2490504 defendant Carvell William tailor 608196 608196 Carvell, William, of Wynchelse, Sussex, tailor 3
5464022 2494155 2494155 defendant Carvell William tailor 608196 608196 Carvell, William, of Wynchelse, Sussex, tailor 2
5475597 2497699 2497699 defendant Carnell William tailor 608196 608196 Carnell, William, of Wynchelse, Sussex, tailor 2
5510788 2508215 2508215 defendant Martham Richard merchant 608196 608196 Martham, Richard, of Wynchelse, Sussex, merchant 4
5521804 2511634 2511634 defendant Sharp John chaplain 608196 608196 Sharp, John, of Wynchelse, Sussex, chaplain 0
5539391 2516807 2516807 defendant Godard Thomas yeoman 608196 608196 Godard, Thomas, of Wynchelse, Sussex, or of Feyrfeld, Kent, yeoman 0
5570699 2525987 2525987 defendant Pett Moys yeoman 608196 608196 Pett, Moys, of Wynchelse, Sussex, yeoman 0
5579684 2528727 2528727 defendant Martham John yeoman 608196 608196 Martham, John, of Wynchelse, Sussex, yeoman 3
5579689 2528728 2528728 defendant Marcham John yeoman 608196 608196 Marcham, John, of Wynchelse, Sussex, yeoman 3
5579708 2528734 2528734 defendant Martham John yeoman 608196 608196 Martham, John, of Wynchelse, Sussex, yeoman 3
5579713 2528735 2528735 defendant Martham John yeoman 608196 608196 Martham, John, of Wynchelse, Sussex, yeoman 3
5586978 2530954 2530954 defendant Fysshe Henry merchant 608196 608196 Fysshe, Henry, of Wynchelse, Sussex, merchant 0
5588142 2531299 2531299 defendant Godard Richard yeoman 608196 608196 Godard, Richard, of Wynchelse, Sussex, yeoman 0
5598724 2534477 2534477 defendant Johnson Gilbert beer brewer 608196 608196 Johnson, Gilbert, of Wynchelse, Sussex, beer brewer 1
5633882 2554590 2554590 defendant Champayne Seman   608196 608196 Champayne, Seman, of Wynchelse, Sussex, esq, sheriff of Kent 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);