names

79 rows where place_id = 588871

✎ 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
3587630 1863775 1863775 defendant Ayherst John yeoman 588871 588871 Ayherst, John, of Lynsted or of Tenham, yeoman 0
3595851 1866341 1866341 defendant Grensted John, junior husbandman 588871 588871 Grensted, John, junior, of Lynsted, husbandman 1
3617321 1873042 1873042 defendant Tilly John gent 588871 588871 Tilly, John, of Lynsted, gent 3
3624235 1875110 1875110 defendant Henden John butcher 588871 588871 Henden, John, of Lynsted, butcher 3
3627867 1903575 1903575 defendant Assheley Joan widow 588871 588871 Assheley, Joan, of Lynsted, widow 3
3628215 1903683 1903683 defendant Norton Thomas husbandman 588871 588871 Norton, Thomas, of Lynsted, husbandman 0
3638406 1906833 1906833 defendant Leane John husbandman 588871 588871 Leane, John, of Lynsted, husbandman 0
3638765 1906943 1906943 defendant Leane or Leave John, junior yeoman 588871 588871 Leane or Leave, John, junior, of Lynsted, yeoman 1
3639637 1907205 1907205 defendant Leane John, junior yeoman 588871 588871 Leane, John, junior, of Lynsted, yeoman 1
3644429 1908676 1908676 defendant Burward Robert husbandman 588871 588871 Burward, Robert, of Lynsted, husbandman 1
3653528 1911371 1911371 defendant Newland John yeoman 588871 588871 Newland, John, of Lynsted, yeoman 0
3658425 1912886 1912886 plaintiff Everard Ralph gent 588871 588871 Everard, Ralph, of Lynsted, gent 0
3658999 1913080 1913080 defendant Downe William husbandman 588871 588871 Downe, William, of Lynsted, husbandman 0
3689300 1922818 1922818 plaintiff Everard Ralph gent 588871 588871 Everard, Ralph, of Lynsted, gent 0
3689303 1922819 1922819 plaintiff Everard Ralph gent 588871 588871 Everard, Ralph, of Lynsted, gent 0
3694156 1924378 1924378 plaintiff Motte Richard yeoman 588871 588871 Motte, Richard, of Lynsted, yeoman 0
3713811 1930618 1930618 defendant Asshle John husbandman 588871 588871 (Asshle, John, of Lynsted, husbandman 3
3722674 1933356 1933356 plaintiff Motte Richard   588871 588871 Motte, Richard, of Lynsted 0
3723004 1933460 1933460 defendant Motte Geoffrey husbandman 588871 588871 Motte, Geoffrey, of Lynsted, husbandman 1
3728966 1935306 1935306 defendant Taylour Robert husbandman 588871 588871 Taylour, Robert, of Lynsted, husbandman 2
3733668 1936772 1936772 defendant Sancrofte Thomas laborer 588871 588871 Sancrofte, Thomas, of Lynsted, laborer 0
3738519 1938257 1938257 plaintiff Motte Richard   588871 588871 Motte, Richard, of Lynsted 0
3740305 1938833 1938833 defendant Holman John butcher 588871 588871 Holman, John, of Lynsted, butcher 0
3756491 1944004 1944004 defendant Barker John butcher 588871 588871 Barker, John, of Lynsted, butcher 0
3761368 1945566 1945566 defendant Boroward Robert husbandman 588871 588871 Boroward, Robert, of Lynsted, husbandman 0
3769513 1948126 1948126 defendant Holman John butcher 588871 588871 Holman, John, of Lynsted, butcher 3
3781134 1951834 1951834 defendant Hawke John husbandman 588871 588871 Hawke, John, of Lynsted, husbandman 1
3820419 1964268 1964268 defendant Holman John butcher 588871 588871 Holman, John, of Lynsted, butcher 0
3878945 1983210 1983210 defendant Hawky John husbandman 588871 588871 Hawky, John, of Lynsted, husbandman 0
3893387 1988020 1988020 defendant Jenyng William husbandman 588871 588871 Jenyng, William, of Lynsted, husbandman 1
3933103 2001365 2001365 defendant Garrolde Henry husbandman 588871 588871 Garrolde, Henry, of Lynsted, husbandman 0
3939837 2003623 2003623 defendant Garard Henry husbandman 588871 588871 Garard, Henry, of Lynsted, husbandman 0
4006712 2027180 2027180 defendant Rooper John esq 588871 588871 Rooper, John, of Lynsted, esq 0
4212242 2099829 2099829 defendant Withe or Writhe Richard carpenter 588871 588871 Withe or Writhe, Richard, of Lynsted, carpenter 1
4216100 2101122 2101122 defendant Clarke Roger husbandman 588871 588871 Clarke, Roger, of Lynsted, husbandman 3
4651756 2246509 2246509 defendant Cotyng Robert husbandman 588871 588871 Cotyng, Robert, of Lynsted, husbandman 2
4934409 2337153 2337153 defendant Lord Robert husbandman 588871 588871 Lord, Robert, of Lynsted, husbandman 3
4938124 2338304 2338304 defendant Typynden Robert gent 588871 588871 Typynden, Robert, of Lynsted, gent 2
4938152 2338310 2338310 defendant Typynden Robert gent 588871 588871 Typynden, Robert, of Lynsted, gent 2
5009705 2359721 2359721 defendant Skykker Thomas husbandman 588871 588871 Skykker, Thomas, of Lynsted, husbandman 0
5009707 2359721 2359721 defendant Maylym John husbandman 588871 588871 Maylym, John, of Lynsted, husbandman 2
5010030 2359801 2359801 defendant Dodman Richard weaver 588871 588871 Dodman, Richard, of Lynsted, weaver 0
5064757 2375999 2375999 defendant Stonepyk Simon laborer 588871 588871 Stonepyk, Simon, of Lynsted, laborer 0
5118667 2391889 2391889 defendant Goldman Richard glover 588871 588871 Goldman, Richard, of Lynsted, glover 0
5128563 2394832 2394832 plaintiff Coliere John, senior   588871 588871 Coliere, John, senior, of Lynsted, husbandman & Lenham, yeoman, administrators of 0
5128565 2394832 2394832 defendant Mayleffe John husbandman 588871 588871 Mayleffe, John, of Lynsted, husbandman 0
5128566 2394832 2394832 defendant Mayleffe Thomas husbandman 588871 588871 Mayleffe, Thomas, of Lynsted, husbandman 1
5128567 2394832 2394832 defendant Bedill Richard husbandman 588871 588871 Bedill, Richard, of Lynsted, husbandman 2
5128568 2394832 2394832 defendant Kenewogth Thomas   588871 588871 Kenewogth, Thomas, of Lynsted 3
5147780 2400492 2400492 defendant Bedell Richard husbandman 588871 588871 Bedell, Richard, of Lynsted, husbandman 0
5167341 2406182 2406182 defendant Bedell Richard husbandman 588871 588871 Bedell, Richard, of Lynsted, husbandman 0
5262967 2434161 2434161 defendant Maylyf John husbandman 588871 588871 Maylyf, John, of Lynsted, husbandman 0
5262968 2434161 2434161 defendant Maylyf Thomas husbandman 588871 588871 Maylyf, Thomas, of Lynsted, husbandman 1
5262970 2434161 2434161 defendant Kenworth Thomas husbandman 588871 588871 Kenworth, Thomas, of Lynsted, husbandman 3
5276511 2438203 2438203 defendant Bellam John clerk 588871 588871 Bellam, John, of Lynsted, clerk 0
5317921 2450446 2450446 defendant Neweland Richard husbandman 588871 588871 Neweland, Richard, of Lynsted, husbandman 0
5373293 2467247 2467247 defendant Cook William yeoman 588871 588871 Cook, William, of Lynsted, yeoman 1
5375551 2467943 2467943 defendant Everard Henry yeoman 588871 588871 Everard, Henry, of Lynsted, yeoman 0
5480362 2499108 2499108 plaintiff Everard Henry   588871 588871 (Everard, Henry, of Lynsted 1
5490804 2502142 2502142 defendant Bix John roper 588871 588871 Bix, John, of Lynsted, roper 0
5496039 2503707 2503707 defendant Hoke Thomas husbandman 588871 588871 Hoke, Thomas, of Lynsted, husbandman 0
5498567 2504515 2504515 defendant Sennycolas Thomas gent 588871 588871 Sennycolas, Thomas, of Lynsted, gent 1
5511013 2508285 2508285 defendant Hoke Thomas husbandman 588871 588871 Hoke, Thomas, of Lynsted, husbandman 0
5513233 2508988 2508988 defendant Sennycholas Thomas gent 588871 588871 Sennycholas, Thomas, of Lynsted, gent 1
5523459 2512164 2512164 defendant Cotyng John yeoman 588871 588871 Cotyng, John, of Lynsted, yeoman 0
5526083 2512735 2512735 defendant Marler Richard yeoman 588871 588871 Marler, Richard, of Lynsted, yeoman 0
5526084 2512735 2512735 defendant Ruste Henry laborer 588871 588871 Ruste, Henry, of Lynsted, laborer 1
5530462 2514044 2514044 defendant Marler Richard husbandman 588871 588871 Marler, Richard, of Lynsted, husbandman 0
5530464 2514045 2514045 defendant Marler Richard husbandman 588871 588871 Marler, Richard, of Lynsted, husbandman 0
5530465 2514045 2514045 defendant Rust Henry laborer 588871 588871 Rust, Henry, of Lynsted, laborer 1
5530467 2514046 2514046 defendant Pye Richard laborer 588871 588871 Pye, Richard, of Lynsted, laborer 0
5530468 2514046 2514046 defendant Rust Henry laborer 588871 588871 Rust, Henry, of Lynsted, laborer 1
5530760 2514138 2514138 plaintiff Ryder Thomas   588871 588871 Ryder, Thomas, of Lynsted 0
5555304 2521553 2521553 defendant Cotyng John husbandman 588871 588871 Cotyng, John, of Lynsted, husbandman 0
5572839 2526607 2526607 defendant Courtfeld John yeoman 588871 588871 Courtfeld, John, of Lynsted, yeoman 2
5575887 2527535 2527535 defendant Aissheby William husbandman 588871 588871 Aissheby, William, of Lynsted, husbandman 2
5576812 2527793 2527793 defendant Wynston Richard saddler 588871 588871 Wynston, Richard, of Lynsted, saddler 0
5576813 2527793 2527793 defendant Weston John gent 588871 588871 Weston, John, of Lynsted, gent 1
5604800 2536367 2536367 defendant Burward Robert husbandman 588871 588871 Burward, Robert, of Lynsted, husbandman 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);