names

59 rows where place_id = 608362

✎ 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
3673371 1917689 1917689 defendant Ellys John maltman 608362 608362 Ellys, John, of Borne, maltman 0
3706599 1928349 1928349 defendant Alfray Thomas cooper 608362 608362 Alfray, Thomas, of Borne, cooper 0
3710271 1929528 1929528 defendant Alfrey William joiner 608362 608362 Alfrey, William, of Borne, joiner 0
3861692 1977371 1977371 defendant Hawkys Henry yeoman 608362 608362 Hawkys, Henry, of Borne, yeoman 0
3862661 1977705 1977705 defendant Harvy John yeoman 608362 608362 Harvy, John, of Borne, yeoman 0
3886622 1985777 1985777 plaintiff Byrde Richard   608362 608362 Byrde, Richard, of Borne, 0
3893347 1988009 1988009 defendant Chase Richard husbandman 608362 608362 Chase, Richard, of Borne, husbandman 0
3916512 1995900 1995900 plaintiff Forster Adam   608362 608362 Forster, Adam, of Borne, gent, collector of the King's benevolence 0
3916517 1995901 1995901 plaintiff Forster Adam   608362 608362 Forster, Adam, of Borne, gent, collector of the King's benevolence 0
3920888 1997330 1997330 defendant Carter William husbandman 608362 608362 Carter, William, of Borne, husbandman 5
3920889 1997330 1997330 defendant Wheteley John   608362 608362 Wheteley, John, of Borne, horse courser 6
3929245 2000125 2000125 defendant Elderwell John husbandman 608362 608362 Elderwell, John, of Borne, husbandman 0
3929250 2000126 2000126 defendant Elderwell John husbandman 608362 608362 Elderwell, John, of Borne, husbandman 0
3929251 2000126 2000126 defendant Elderwell Baldwyn husbandman 608362 608362 Elderwell, Baldwyn, of Borne, husbandman 1
3950245 2007172 2007172 defendant Crunden Alice widow 608362 608362 Crunden, Alice, of Borne, widow 0
3976683 2016417 2016417 defendant Gotesm William Lincs, yeoman 608362 608362 Gotesm William, of Borne, Lincs, yeoman 13
4021408 2032382 2032382 plaintiff Wylshire George butcher 608362 608362 Wylshire, George, of Borne, butcher 0
4041901 2039589 2039589 defendant Eldred Robert yeoman 608362 608362 Eldred, Robert, of Borne, yeoman 0
4041902 2039589 2039589 defendant Lenton John laborer 608362 608362 Lenton, John, of Borne, laborer 1
4069974 2049547 2049547 defendant Huet Samuel husbandman 608362 608362 Huet, Samuel, of Borne, husbandman 0
4114943 2065634 2065634 defendant Hudson Robert husbandman 608362 608362 Hudson, Robert, of Borne, husbandman 0
4121199 2067877 2067877 defendant Samsonne William husbandman 608362 608362 Samsonne, William, of Borne, or of Muston, Leics, husbandman 0
4121200 2067877 2067877 defendant Prate John gent 608362 608362 Prate, John, of Borne, or of Muston, gent 1
4129642 2070909 2070909 defendant Bacon Thomas yeoman 608362 608362 Bacon, Thomas, of Borne, yeoman 0
4131139 2071454 2071454 defendant Foldington William butcher 608362 608362 Foldington, William, of Borne, butcher 0
4132534 2071951 2071951 defendant Alwood Constantine laborer 608362 608362 Alwood, Constantine, of Borne, laborer 0
4139346 2074437 2074437 defendant Smythergill Henry shoemaker 608362 608362 Smythergill, Henry, of Borne, shoemaker 0
4139347 2074437 2074437 defendant Harryson William yeoman 608362 608362 Harryson, William, of Borne, yeoman 1
4142469 2075537 2075537 defendant More George, junior gent 608362 608362 More, George, junior, of Borne, gent 2
4151275 2078568 2078568 defendant Mascall Nicholas yeoman 608362 608362 Mascall, Nicholas, of Borne, yeoman 0
4152347 2078930 2078930 defendant Cotton Robert esq 608362 608362 Cotton, Robert, of Borne, or of London St Bartholomew, esq 0
4174438 2086527 2086527 defendant Marshe William glover 608362 608362 Marshe, William, of Borne, glover 0
4174898 2086685 2086685 defendant Eldred Robert gent 608362 608362 Eldred, Robert, of Borne, gent 0
4176841 2087368 2087368 defendant Clarke alias Newton Thomas yeoman 608362 608362 Clarke alias Newton, Thomas, of Borne, yeoman 0
4177035 2087441 2087441 defendant Bacon Thomas yeoman 608362 608362 Bacon, Thomas, of Borne, yeoman 0
4180480 2088653 2088653 defendant Plommer Walter glover 608362 608362 Plommer, Walter, of Borne, glover 1
4182945 2089514 2089514 defendant Cantyn or Cautyn Robert yeoman 608362 608362 Cantyn or Cautyn, Robert, of Borne, yeoman 0
4198247 2094935 2094935 defendant Eldred Robert gent 608362 608362 Eldred, Robert, of Borne, gent 0
4200023 2095559 2095559 defendant Cotton Robert esq 608362 608362 Cotton, Robert, of Borne, or of London St Bartholomew the Great, esq 0
4222028 2103195 2103195 defendant Plomer John butcher 608362 608362 Plomer, John, of Borne, butcher 0
4265109 2117969 2117969 defendant Kinge Elizabeth (legal representative) 608362 608362 Kinge, Elizabeth, of Borne, widow, executor of 0
4265110 2117969 2117969 defendant Marshe William   608362 608362 Marshe, William, of Borne, Lincs innholder 1
4274496 2121027 2121027 defendant Warde Humphrey yeoman 608362 608362 Warde, Humphrey, of Borne, yeoman 0
4296551 2128867 2128867 defendant Moore Edward gent 608362 608362 Moore, Edward, of Borne, gent 0
4345934 2145841 2145841 defendant Browne John gent 608362 608362 Browne, John, of Borne, gent 2
4345939 2145843 2145843 defendant Corney Robert tanner 608362 608362 Corney, Robert, of Borne, tanner 0
4352327 2148050 2148050 defendant Barton alias Allen Edward butcher 608362 608362 Barton alias Allen, Edward, of Borne, butcher 0
4381625 2158538 2158538 defendant Smyth Thomas husbandman 608362 608362 Smyth, Thomas, of Borne, husbandman 0
4808097 2298707 2298707 defendant Freman John butcher 608362 608362 Freman, John, of Borne, butcher 1
4942649 2339673 2339673 defendant Dagwelle Stephen fuller 608362 608362 Dagwelle, Stephen, of Borne, fuller 0
4993827 2355025 2355025 defendant Hygon Robert husbandman 608362 608362 Hygon, Robert, of Borne, husbandman 0
5499577 2504820 2504820 defendant Shorte William husbandman 608362 608362 Shorte, William, of Borne, husbandman 0
5499578 2504820 2504820 defendant Horsam John husbandman 608362 608362 Horsam, John, of Borne, husbandman 1
5499579 2504820 2504820 defendant Shorte Henry husbandman 608362 608362 Shorte, Henry, of Borne, husbandman 2
5499580 2504820 2504820 defendant Shorter Henry tailor 608362 608362 Shorter, Henry, of Borne, tailor 3
5499581 2504820 2504820 defendant Shorte Alice single woman 608362 608362 Shorte, Alice, of Borne, single woman 4
5575200 2527332 2527332 defendant Baker John husbandman 608362 608362 Baker, John, of Borne, husbandman 2
5580459 2528974 2528974 defendant Snodon Richard husbandman 608362 608362 Snodon, Richard, of Borne, husbandman 0
5600466 2535030 2535030 defendant Edward Ralph husbandman 608362 608362 Edward, Ralph, of Borne, 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);