names

68 rows where place_id = 600424

✎ 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
3640986 1907621 1907621 defendant Wryght Roger miller 600424 600424 Wryght, Roger, of Latton, miller 0
3645230 1908915 1908915 defendant Sabbysford Thomas husbandman 600424 600424 Sabbysford, Thomas, of Latton, husbandman 1
3688049 1922426 1922426 defendant Tyesse John husbandman 600424 600424 Tyesse, John, of Latton, husbandman 1
3688051 1922426 1922426 defendant Baker Thomas, senior husbandman 600424 600424 Baker, Thomas, senior, of Latton, husbandman 3
3717523 1931768 1931768 defendant Blynkynsop Robert laborer 600424 600424 Blynkynsop, Robert, of Latton, laborer 0
3730866 1935880 1935880 defendant Gladwyn John, junior husbandman 600424 600424 Gladwyn, John, junior, of Latton, husbandman 0
3763323 1946160 1946160 defendant Solby Thomas husbandman 600424 600424 Solby, Thomas, of Latton, husbandman 3
3828132 1966667 1966667 defendant Cootes Thomas miller 600424 600424 Cootes, Thomas, of Latton, miller 0
3843024 1971347 1971347 defendant Cootys Thomas miller 600424 600424 Cootys, Thomas, of Latton, miller 1
3874562 1981712 1981712 defendant Pery John husbandman 600424 600424 Pery, John, of Latton, husbandman 0
3898078 1989567 1989567 defendant Hoye William yeoman 600424 600424 Hoye, William, of Latton, yeoman 0
3900182 1990285 1990285 defendant Cotes Thomas miller 600424 600424 Cotes, Thomas, of Latton, miller 0
3912331 1994455 1994455 defendant Hoye William yeoman 600424 600424 Hoye, William, of Latton, yeoman 0
4055897 2044491 2044491 plaintiff Bond Richard (legal representative) 600424 600424 Bond, Richard, of Latton, gent, executrix of 0
4080375 2053296 2053296 defendant Altham James esq 600424 600424 Altham, James, of Latton, esq 0
4080376 2053296 2053296 defendant Altham Edward gent 600424 600424 Altham, Edward, of Latton, gent 1
4080377 2053296 2053296 defendant Dowdale Henry yeoman 600424 600424 Dowdale, Henry, of Latton, yeoman 2
4080378 2053296 2053296 defendant Kendall Henry yeoman 600424 600424 Kendall, Henry, of Latton, yeoman 3
4080379 2053296 2053296 defendant Baker Thomas yeoman 600424 600424 Baker, Thomas, of Latton, yeoman 4
4080380 2053296 2053296 defendant Hatche Thomas yeoman 600424 600424 Hatche, Thomas, of Latton, yeoman 5
4080381 2053296 2053296 defendant Waddyngton Andrew gent 600424 600424 Waddyngton, Andrew, of Latton, gent 6
4080382 2053296 2053296 defendant Godderd William yeoman 600424 600424 Godderd, William, of Latton, yeoman 7
4080383 2053296 2053296 defendant Abbat Nicholas yeoman 600424 600424 Abbat, Nicholas, of Latton, yeoman 8
4080384 2053296 2053296 defendant Gullefer Henry laborer 600424 600424 Gullefer, Henry, of Latton, laborer 9
4080385 2053296 2053296 defendant Clarke John husbandman 600424 600424 Clarke, John, of Latton, husbandman 10
4080386 2053296 2053296 defendant Godfrey Walter yeoman 600424 600424 Godfrey, Walter, of Latton, yeoman 11
4080389 2053296 2053296 defendant Kente John yeoman 600424 600424 Kente, John, of Latton, yeoman 14
4206546 2097837 2097837 defendant Reynold Thomas laborer 600424 600424 Reynold, Thomas, of Latton, laborer 4
4206551 2097838 2097838 defendant Reynold Thomas laborer 600424 600424 Reynold, Thomas, of Latton, laborer 3
4206565 2097839 2097839 defendant Reyn- Thomas husbandman 600424 600424 Reyn-, Thomas, of Latton, husbandman 11
4206566 2097839 2097839 defendant Flettcher Robert laborer 600424 600424 Flettcher, Robert, of Latton, laborer 12
4206582 2097840 2097840 defendant Reynold Thomas husbandman 600424 600424 Reynold, Thomas, of Latton, husbandman 11
4206583 2097840 2097840 defendant Fletcher Robert laborer 600424 600424 Fletcher, Robert, of Latton, laborer 12
4485115 2196047 2196047 plaintiff Prior Peter   600424 600424 Prior, Peter, of Latton 0
4507402 2202779 2202779 plaintiff Webbe Robert   600424 600424 Webbe, Robert, of Latton 0
4507404 2202780 2202780 plaintiff Webbe Robert   600424 600424 Webbe, Robert, of Latton 0
4540228 2212845 2212845 defendant Wryght Robert   600424 600424 Wryght, Robert, of Latton 3
4540234 2212846 2212846 defendant Wryght Robert   600424 600424 Wryght, Robert, of Latton 3
4629384 2240119 2240119 defendant Trappere William   600424 600424 Trappere, William, of Latton 0
4758036 2282885 2282885 defendant Panter Walter husbandman 600424 600424 Panter, Walter, of Latton, husbandman 0
4813283 2300269 2300269 defendant George John husbandman 600424 600424 George, John, of Latton, husbandman 0
4965522 2346606 2346606 defendant Ingram John husbandman 600424 600424 together with Ingram, John, of Latton, husbandman 4
4992963 2354780 2354780 defendant Gladewyn Nicholas husbandman 600424 600424 Gladewyn, Nicholas, of Latton, husbandman 0
5025327 2364299 2364299 defendant Denton John husbandman 600424 600424 Denton, John, of Latton, husbandman 1
5342972 2457993 2457993 defendant Profote John yeoman 600424 600424 Profote, John, of Latton, yeoman 0
5342973 2457993 2457993 defendant Adam Thomas husbandman 600424 600424 Adam, Thomas, of Latton, husbandman 1
5357797 2462510 2462510 defendant Say Walter clerk 600424 600424 Say, Walter, of Latton, clerk 0
5366765 2465263 2465263 defendant Burton Thomas miller 600424 600424 Burton, Thomas, of Latton, miller 0
5366775 2465266 2465266 defendant Burton Thomas miller 600424 600424 Burton, Thomas,of Latton, miller 0
5370583 2466387 2466387 defendant Curtene Robert husbandman 600424 600424 Curtene, Robert, of Latton, husbandman 3
5380583 2469498 2469498 defendant Burton Thomas   600424 600424 Burton, Thomas, of Latton 0
5383217 2470273 2470273 defendant Baker Robert husbandman 600424 600424 Baker, Robert, of Latton, husbandman 0
5384392 2470623 2470623 defendant Burton Thomas miller 600424 600424 Burton, Thomas, of Latton, miller 0
5385374 2470894 2470894 defendant Burton Thomas miller 600424 600424 Burton, Thomas, of Latton, miller 0
5394387 2473461 2473461 defendant Purfote John butcher 600424 600424 Purfote, John, of Latton, butcher 0
5397544 2474372 2474372 defendant Purfote John butcher 600424 600424 Purfote, John, of Latton, butcher 0
5410686 2478139 2478139 defendant Purfote John butcher 600424 600424 Purfote, John, of Latton, butcher 0
5410688 2478140 2478140 defendant Purfote John butcher 600424 600424 Purfote, John, of Latton, butcher 0
5410690 2478141 2478141 defendant Purfote John butcher 600424 600424 Purfote, John, of Latton, butcher 0
5417295 2480092 2480092 defendant Purfote John husbandman 600424 600424 Purfote, John, of Latton, husbandman 1
5492959 2502801 2502801 defendant Purfote John yeoman 600424 600424 Purfote, John, of Latton, yeoman 0
5498616 2504528 2504528 defendant Shered Thomas husbandman 600424 600424 Shered, Thomas, of Latton, husbandman 3
5517814 2510414 2510414 defendant Prudfote John yeoman 600424 600424 Prudfote, John, of Latton, yeoman 0
5544834 2518492 2518492 defendant Gesop John husbandman 600424 600424 Gesop, John, of Latton, husbandman 3
5544835 2518492 2518492 defendant Adam Thomas husbandman 600424 600424 Adam, Thomas, of Latton, husbandman 4
5573491 2526806 2526806 defendant Beverley Robert clerk 600424 600424 Beverley, Robert, of Latton, clerk 2
5582600 2529624 2529624 defendant Smyth John husbandman 600424 600424 Smyth, John, of Latton, husbandman 3
5608883 2537678 2537678 defendant Curtes Robert husbandman 600424 600424 Curtes, Robert, of Latton, husbandman 3

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);