names

51 rows where place_id = 626016

✎ 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
3748780 1941553 1941553 defendant Arriton Richard   626016 626016 Arriton, Richard, of Arkesden, shepherd 0
3763306 1946156 1946156 defendant Arryton Richard   626016 626016 Arryton, Richard, of Arkesden, shepherd 0
3767487 1947468 1947468 defendant Lawe Richard husbandman 626016 626016 Lawe, Richard, of Arkesden, husbandman 2
3767488 1947468 1947468 defendant Wynterflode John husbandman 626016 626016 Wynterflode, John, of Arkesden, husbandman 3
3779339 1951260 1951260 defendant Page Peter husbandman 626016 626016 Page, Peter, of Arkesden, husbandman 1
3784864 1953059 1953059 defendant Page Peter husbandman 626016 626016 Page, Peter, of Arkesden, husbandman 0
3921052 1997391 1997391 defendant Frogge Katherine widow 626016 626016 Frogge, Katherine, of Arkesden, widow 0
3921716 1997605 1997605 defendant Trygge Henry yeoman 626016 626016 Trygge, Henry, of Arkesden, yeoman 1
3923538 1998181 1998181 defendant Holden alias Seymer Thomas laborer 626016 626016 Holden alias Seymer, Thomas, of Arkesden, laborer 1
3947964 2006351 2006351 defendant Gyppes Richard yeoman 626016 626016 Gyppes, Richard, of Arkesden, yeoman 0
4526410 2208536 2208536 defendant Laurence William   626016 626016 Laurence, William, of Arkesden 1
4545409 2214488 2214488 defendant Laurence William   626016 626016 Laurence, William, of Arkesden 2
4545410 2214488 2214488 defendant Berrene John   626016 626016 Berrene, John, of Arkesden 3
4596385 2230120 2230120 defendant Laurence William   626016 626016 Laurence, William, of Arkesden 1
4646866 2245146 2245146 defendant Laurence William   626016 626016 Laurence, William, of Arkesden 0
4678777 2258966 2258966 defendant Dreye John ploughman 626016 626016 Dreye, John, of Arkesden, ploughman 0
4708918 2268158 2268158 defendant Godeman Simon husbandman 626016 626016 Godeman, Simon, of Arkesden, husbandman 2
4739645 2277473 2277473 defendant Taillour Nicholas farmer 626016 626016 Taillour, Nicholas, of Arkesden, farmer 4
4743937 2278755 2278755 defendant Laurence William husbandman 626016 626016 Laurence, William, of Arkesden, husbandman 0
4745102 2279075 2279075 defendant Good Simon yeoman 626016 626016 Good, Simon, of Arkesden, yeoman 0
4745103 2279075 2279075 defendant Sextayn John shoemaker 626016 626016 Sextayn, John, of Arkesden, shoemaker 1
4745105 2279075 2279075 defendant Sextayn Robert tailor 626016 626016 Sextayn, Robert, of Arkesden, tailor 3
4753345 2281423 2281423 defendant Freote Nicholas farmer 626016 626016 Freote, Nicholas, of Arkesden, farmer 0
4762527 2284262 2284262 defendant Warde John husbandman 626016 626016 Warde, John, of Arkesden, husbandman 0
4762528 2284262 2284262 defendant Chapman Thomas laborer 626016 626016 Chapman, Thomas, of Arkesden, laborer 1
4762532 2284262 2284262 defendant Page John laborer 626016 626016 Page, John, of Arkesden, laborer 5
4762533 2284262 2284262 defendant Stokayle John laborer 626016 626016 Stokayle, John, of Arkesden, laborer 6
4786125 2291699 2291699 defendant Sexteyn John shoemaker 626016 626016 Sexteyn, John, of Arkesden, shoemaker 0
4786126 2291699 2291699 defendant Sexteyn John   626016 626016 Sexteyn, John, of Arkesden, servant 1
4786130 2291701 2291701 defendant Godeman Thomas laborer 626016 626016 Godeman, Thomas, of Arkesden, laborer 0
4802223 2296885 2296885 defendant Goodman Thomas husbandman 626016 626016 Goodman, Thomas, of Arkesden, husbandman 3
4802224 2296885 2296885 defendant Devyle John, junior husbandman 626016 626016 Devyle, John, junior, of Arkesden, husbandman 4
4886804 2322728 2322728 defendant Pye Robert   626016 626016 Pye, Robert, of Arkesden, shepherd 1
4913281 2330654 2330654 plaintiff Claveford or Claneford Walter (legal representative) 626016 626016 Claveford or Claneford, Walter, of Arkesden, executor of 0
4913283 2330654 2330654 defendant Bledlowe John, junior husbandman 626016 626016 Bledlowe, John, junior, of Arkesden, husbandman 0
5128011 2394669 2394669 defendant Bumsted John butcher 626016 626016 Bumsted, John, of Arkesden, butcher 1
5218994 2421284 2421284 defendant Orgore John husbandman 626016 626016 Orgore, John, of Arkesden, husbandman 0
5234767 2425756 2425756 defendant Orgore Henry husbandman 626016 626016 Orgore, Henry, of Arkesden, husbandman 0
5236705 2426321 2426321 defendant Aleyn John husbandman 626016 626016 Aleyn, John, of Arkesden, husbandman 0
5246632 2429176 2429176 defendant Smyth John husbandman 626016 626016 Smyth, John, of Arkesden, husbandman 0
5246633 2429176 2429176 defendant Orgore John husbandman 626016 626016 Orgore, John, of Arkesden, husbandman 1
5246634 2429176 2429176 defendant Smyth Thomas husbandman 626016 626016 Smyth, Thomas, of Arkesden, husbandman 2
5246635 2429176 2429176 defendant Hogekyn Richard husbandman 626016 626016 Hogekyn, Richard, of Arkesden, husbandman 3
5246636 2429176 2429176 defendant Hogekyn Thomas husbandman 626016 626016 Hogekyn, Thomas, of Arkesden, husbandman 4
5246637 2429176 2429176 defendant Hoggekyn John husbandman 626016 626016 Hoggekyn, John, of Arkesden, husbandman 5
5260458 2433404 2433404 defendant Gyppes Richard husbandman 626016 626016 Gyppes, Richard, of Arkesden, husbandman 0
5290325 2442177 2442177 defendant Lawe Thomas husbandman 626016 626016 Lawe, Thomas, of Arkesden, husbandman 3
5304120 2446241 2446241 defendant Lawe John husbandman 626016 626016 Lawe, John, of Arkesden, husbandman 2
5319569 2450947 2450947 defendant Smyth John, senior husbandman 626016 626016 Smyth, John, senior, of Arkesden, husbandman 1
5447752 2489206 2489206 plaintiff Jepson Richard yeoman 626016 626016 Jepson, Richard, of Arkesden, yeoman 0
5483515 2500016 2500016 defendant Turnour Thomas husbandman 626016 626016 Turnour, Thomas, of Arkesden, 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);