names

63 rows where place_id = 618125

✎ 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
3594498 1865910 1865910 defendant Alowe William husbandman 618125 618125 Alowe, William, of Magna Stanmer, husbandman 0
3603085 1868631 1868631 defendant Prat Mathew yeoman 618125 618125 Prat, Mathew, of Magna Stanmer, yeoman 0
3615783 1872578 1872578 defendant Prat Mathew yeoman 618125 618125 Prat, Mathew, of Magna Stanmer, yeoman 0
3673948 1917890 1917890 defendant Androwe alias Smyth Ralph husbandman 618125 618125 Androwe alias Smyth, Ralph, of Magna Lyvermer, husbandman 0
3722969 1933449 1933449 defendant Aulet Richard husbandman 618125 618125 Aulet, Richard, of Magna Lymber, husbandman 0
3722970 1933449 1933449 defendant Newton Richard, senior husbandman 618125 618125 Newton, Richard, senior, of Magna Lymber, husbandman 1
3722971 1933449 1933449 defendant Dawton Robert carpenter 618125 618125 Dawton, Robert, of Magna Lymber, carpenter 2
3722972 1933449 1933449 defendant Abenton John pardoner 618125 618125 Abenton, John, of Magna Lymber, pardoner 3
3754702 1943431 1943431 defendant Awlet Richard yeoman 618125 618125 Awlet, Richard, of Magna Limber, yeoman 2
3757547 1944338 1944338 defendant Crowder Hugh husbandman 618125 618125 Crowder, Hugh, of Magna Lymber, husbandman 0
3757548 1944338 1944338 defendant Sergeand Richard husbandman 618125 618125 Sergeand, Richard, of Magna Lymber, husbandman 1
3757549 1944338 1944338 defendant Howme William weaver 618125 618125 Howme, William, of Magna Lymber, weaver 2
3779299 1951249 1951249 defendant Crowder Hugh husbandman 618125 618125 Crowder, Hugh, of Magna Lymber, husbandman 1
3779300 1951249 1951249 defendant Allott Robert husbandman 618125 618125 Allott, Robert, of Magna Lymber, husbandman 2
3838203 1969864 1969864 defendant Wykes John thatcher 618125 618125 Wykes, John, of Magna Lyvermer, thatcher 0
3864738 1978402 1978402 defendant Everson John husbandman 618125 618125 Everson, John, of Magna Lymber, husbandman 0
3904385 1991713 1991713 defendant Ireland Richard husbandman 618125 618125 Ireland, Richard, of Magna Ower, husbandman 0
3904386 1991713 1991713 defendant Elbastone Robert husbandman 618125 618125 Elbastone, Robert, of Magna Ower, husbandman 1
3904389 1991713 1991713 defendant Tabberer Richard laborer 618125 618125 Tabberer, Richard, of Magna Ower, laborer 4
3964515 2012190 2012190 plaintiff Assheton Ralph esq 618125 618125 Assheton, Ralph, of Magna Leaver, esq 0
4035515 2037375 2037375 defendant Holmes Christopher yeoman 618125 618125 Holmes, Christopher, of Magna Lymber, yeoman 0
4069837 2049495 2049495 defendant Chamberleyn William yeoman 618125 618125 Chamberleyn, William, of Magna Lymber, yeoman 0
4071090 2049962 2049962 defendant Grymbald James husbandman 618125 618125 Grymbald, James, of Magna Lymber, husbandman 0
4119913 2067411 2067411 defendant Holmes James husbandman 618125 618125 Holmes, James, of Magna Limber, husbandman 0
4119914 2067411 2067411 defendant Smyth Martin husbandman 618125 618125 Smyth, Martin, of Magna Lymber, husbandman 1
4126912 2069918 2069918 defendant Towle John yeoman 618125 618125 Towle, John, of Magna Lymber, yeoman 0
4132916 2072097 2072097 defendant Chamberlayn William yeoman 618125 618125 Chamberlayn, William, of Magna Lymber, yeoman 0
4136491 2073393 2073393 defendant Chamberlayne William yeoman 618125 618125 Chamberlayne, William, of Magna Limber, yeoman 0
4136492 2073393 2073393 defendant Cooke Hugh yeoman 618125 618125 Cooke, Hugh, of Magna Limber, yeoman 1
4137694 2073837 2073837 defendant Chamberlayne William yeoman 618125 618125 Chamberlayne, William, of Magna Limber, yeoman 0
4145945 2076737 2076737 defendant Chamberlayne William yeoman 618125 618125 Chamberlayne, William, of Magna Lymber, yeoman 0
4148865 2077725 2077725 defendant Chamberlayne William yeoman 618125 618125 Chamberlayne, William, of Magna Limber, yeoman 0
4148866 2077725 2077725 defendant Cooke Hugh yeoman 618125 618125 Cooke, Hugh, of Magna Limber, yeoman 1
4179475 2088298 2088298 defendant Sergeant Benedict yeoman 618125 618125 Sergeant, Benedict, of Magna Lymber, or of Thornton Curtas, yeoman 0
4180560 2088684 2088684 defendant Surdeball Mathew husbandman 618125 618125 Surdeball, Mathew, of Magna Limber, husbandman 2
4181330 2088952 2088952 defendant Chamberlayne Richard husbandman 618125 618125 Chamberlayne, Richard, of Magna Limber, husbandman 1
4185888 2090558 2090558 defendant Towle John husbandman 618125 618125 Towle, John, of Magna Lymber, husbandman 6
4185904 2090562 2090562 defendant Towle John husbandman 618125 618125 Towle, John, of Magna Lymber, husbandman 5
4189544 2091842 2091842 defendant Sergeant Benedict yeoman 618125 618125 Sergeant, Benedict, of Magna Limber, yeoman 0
4189546 2091843 2091843 defendant Sergeaunt Benedict husbandman 618125 618125 Sergeaunt, Benedict, of Magna Lymber, husbandman 0
4202998 2096598 2096598 defendant Chamberlayne Robert husbandman 618125 618125 Chamberlayne, Robert, of Magna Limber, husbandman 0
4228275 2105372 2105372 defendant Steper Edward yeoman 618125 618125 Steper, Edward, of Magna Lymber, yeoman 0
4228279 2105373 2105373 defendant Tolle James yeoman 618125 618125 Tolle, James, of Magna Lymber, yeoman 0
4234642 2107663 2107663 defendant Dent John laborer 618125 618125 Dent, John, of Magna Lymber, laborer 0
4236474 2108331 2108331 defendant Lorde Robert clerk 618125 618125 Lorde, Robert, of Magna Lymber, clerk 0
4257324 2115426 2115426 defendant Steper Edward yeoman 618125 618125 Steper, Edward, of Magna Lymber, yeoman 0
4257328 2115427 2115427 defendant Tole James yeoman 618125 618125 Tole, James, of Magna Lymber, yeoman 0
4298420 2129537 2129537 defendant Deane Brian clerk 618125 618125 Deane, Brian, of Magna Lymber, clerk 0
4796990 2295217 2295217 defendant Webbe John clothmaker 618125 618125 Webbe, John, of Magna Kayfer, clothmaker 0
4798012 2295563 2295563 defendant Trubbok Thomas tiler 618125 618125 Trubbok, Thomas, of Magna Radwynter, tiler 0
4863509 2315557 2315557 defendant Dummesby John laborer 618125 618125 Dummesby, John, of Magna Stanmer, laborer 0
4939079 2338607 2338607 defendant Whiche William husbandman 618125 618125 together with Whiche, William, of Magna Stanmer, husbandman 1
5013532 2360798 2360798 defendant Smythe Henry husbandman 618125 618125 Smythe, Henry, of Magna Lyvermer, husbandman 0
5119119 2392026 2392026 defendant Honchon or Houchon Edmund husbandman 618125 618125 Honchon or Houchon, Edmund, of Magna Levermer, husbandman 0
5119120 2392026 2392026 defendant Bole Edmund husbandman 618125 618125 Bole, Edmund, of Magna Levermer, husbandman 1
5119121 2392026 2392026 defendant Poule Thomas woolman 618125 618125 Poule, Thomas, of Magna Levermer, woolman 2
5343152 2458049 2458049 defendant Croke Thomas, junior yeoman 618125 618125 Croke, Thomas, junior, of Magna Stanmer, yeoman 0
5508266 2507469 2507469 defendant Wyseman John husbandman 618125 618125 Wyseman, John, of Magna Levermer, husbandman 1
5594903 2533376 2533376 defendant Simond Thomas husbandman 618125 618125 Simond, Thomas, of Magna Lemner, husbandman 0
5594904 2533376 2533376 defendant Correy John husbandman 618125 618125 Correy, John, of Magna Lemner, husbandman 1
5595518 2533548 2533548 defendant Simond Thomas husbandman 618125 618125 Simond, Thomas, of Magna Levermer, husbandman 0
5595519 2533548 2533548 defendant Correy John husbandman 618125 618125 Correy, John, of Magna Levermer, husbandman 1
5600808 2535140 2535140 defendant Martyn John husbandman 618125 618125 Martyn, John, of Magna Corner, 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);