names

64 rows where place_id = 592729

✎ 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
3608653 1870367 1870367 defendant Basse Richard chaplain 592729 592729 Basse, Richard, of Asshill, chaplain 0
3643081 1908278 1908278 plaintiff Coo Thomas (legal representative) 592729 592729 Coo, Thomas, of Asshill, administratrix of 0
3681395 1920267 1920267 defendant Constable Andrew husbandman 592729 592729 Constable, Andrew, of Asshill, husbandman 0
3684415 1921257 1921257 defendant Roome Robert husbandman 592729 592729 Roome, Robert, of Asshill, husbandman 0
3716918 1931578 1931578 defendant Beales Thomas clerk 592729 592729 Beales, Thomas, of Asshill, clerk 0
3728181 1935075 1935075 defendant Beales Thomas clerk 592729 592729 Beales, Thomas, of Asshill, clerk 0
3733782 1936818 1936818 defendant Fletcher Robert   592729 592729 Fletcher, Robert, of Asshill, shepherd 1
3741572 1939234 1939234 defendant Mayewe Richard husbandman 592729 592729 Mayewe, Richard, of Asshill, husbandman 1
3757605 1944358 1944358 defendant Duffeld John husbandman 592729 592729 Duffeld, John, of Asshill, husbandman 1
3797326 1957053 1957053 defendant Route or Ronte Robert husbandman 592729 592729 Route or Ronte, Robert, of Asshill, husbandman 1
3802491 1958676 1958676 defendant Fletcher Robert   592729 592729 Fletcher, Robert, of Asshill, shepherd 7
3861798 1977411 1977411 defendant Childerhous William husbandman 592729 592729 Childerhous, William, of Asshill, husbandman 0
3869648 1980091 1980091 defendant Ynglysshe John, senior smith 592729 592729 Ynglysshe, John, senior, of Asshill, smith 0
3961418 2011087 2011087 defendant Munsawe Thomas husbandman 592729 592729 Munsawe, Thomas, of Asshill, husbandman 0
3967900 2013401 2013401 plaintiff Cannon John yeoman 592729 592729 Cannon, John, of Asshill, yeoman 0
4004398 2026353 2026353 plaintiff Jakeler Thomas yeoman 592729 592729 Jakeler, Thomas, of Asshill, yeoman 0
4004401 2026354 2026354 plaintiff Jakeler Thomas yeoman 592729 592729 Jakeler, Thomas, of Asshill, yeoman 0
4057919 2045216 2045216 defendant Colvyn or Colkyn Richard miller 592729 592729 Colvyn or Colkyn, Richard, of Asshill, miller 1
4089076 2056386 2056386 defendant Hachall Robert yeoman 592729 592729 Hachall, Robert, of Asshill, yeoman 0
4182140 2089231 2089231 defendant Wadham George gent 592729 592729 Wadham, George, of Asshill, gent 0
4231472 2106507 2106507 defendant Newporte Robert miller 592729 592729 Newporte, Robert, of Asshill, miller 2
4329245 2140093 2140093 defendant Bysshoppe Ralph blacksmith 592729 592729 Bysshoppe, Ralph, of Asshill, blacksmith 2
4709145 2268225 2268225 defendant Bailly Thomas husbandman 592729 592729 Bailly, Thomas, of Asshill, husbandman 3
4811692 2299765 2299765 defendant Coo Henry yeoman 592729 592729 Coo, Henry, of Asshill, yeoman 9
4824032 2303592 2303592 defendant Malverne Nicholas yeoman 592729 592729 Malverne, Nicholas, of Asshill, yeoman 0
4847446 2310704 2310704 defendant Englyssh John   592729 592729 Englyssh, John, of Asshill, bailiff 0
4887245 2322849 2322849 defendant Koo Henry yeoman 592729 592729 Koo, Henry, of Asshill, yeoman 0
4887246 2322849 2322849 defendant Bokkyng Thomas husbandman 592729 592729 Bokkyng, Thomas, of Asshill, husbandman 1
4943631 2339979 2339979 defendant atte Well Geoffrey chaplain 592729 592729 atte Well, Geoffrey, of Asshill, chaplain 0
4971954 2348548 2348548 defendant Cook Nicholas, junior husbandman 592729 592729 Cook, Nicholas, junior, of Asshill, husbandman 1
5013333 2360737 2360737 plaintiff atte Welle Geoffrey chaplain 592729 592729 atte Welle, Geoffrey, of Asshill, chaplain 0
5036357 2367485 2367485 defendant Oldman John husbandman 592729 592729 Oldman, John, of Asshill, husbandman 0
5042692 2369421 2369421 defendant Hake Thomas laborer 592729 592729 Hake, Thomas, of Asshill, laborer 1
5066778 2376591 2376591 defendant Gille William laborer 592729 592729 Gille, William, of Asshill, laborer 1
5071291 2377910 2377910 defendant Coo John husbandman 592729 592729 Coo, John, of Asshill, husbandman 0
5074781 2378961 2378961 defendant Malverne Henry yeoman 592729 592729 Malverne, Henry, of Asshill, yeoman 1
5075998 2379314 2379314 plaintiff atte Well Geoffrey chaplain 592729 592729 atte Well, Geoffrey, of Asshill, chaplain 0
5076001 2379315 2379315 plaintiff atte Well Geoffrey chaplain 592729 592729 atte Well, Geoffrey, of Asshill, chaplain 0
5081285 2380913 2380913 defendant Lyes William yeoman 592729 592729 Lyes, William, of Asshill, yeoman 2
5090060 2383464 2383464 defendant Coo John chapman 592729 592729 Coo, John, of Asshill, chapman 0
5148394 2400664 2400664 defendant Lyes William yeoman 592729 592729 Lyes, William, of Asshill, yeoman 12
5167682 2406269 2406269 defendant Lyes William yeoman 592729 592729 Lyes, William, of Asshill, yeoman 12
5243478 2428288 2428288 defendant Malvern Henry husbandman 592729 592729 Malvern, Henry, of Asshill, husbandman 2
5243893 2428407 2428407 defendant Doget John yeoman 592729 592729 Doget, John, of Asshill, yeoman 0
5243894 2428407 2428407 defendant atte Hill Thomas husbandman 592729 592729 atte Hill, Thomas, of Asshill, husbandman 1
5246922 2429264 2429264 defendant Malvern Nicholas yeoman 592729 592729 Malvern, Nicholas, of Asshill, yeoman 0
5246923 2429264 2429264 defendant Malvern John butcher 592729 592729 Malvern, John, of Asshill, butcher 1
5341816 2457634 2457634 defendant Malvern Henry yeoman 592729 592729 Malvern, Henry, of Asshill, yeoman 1
5348907 2459788 2459788 defendant Hoggeson William gent 592729 592729 Hoggeson, William, of Asshill, gent 0
5349802 2460074 2460074 defendant Hoggeson William gent 592729 592729 Hoggeson, William, of Asshill, gent 0
5349963 2460119 2460119 defendant Hoggeson William gent 592729 592729 Hoggeson, William, of Asshill, gent 0
5349976 2460123 2460123 defendant Hoggeson William gent 592729 592729 Hoggeson, William, of Asshill, gent 0
5349993 2460127 2460127 defendant Hoggeson William gent 592729 592729 Hoggeson, William, of Asshill, gent 0
5352710 2460937 2460937 defendant Miles James yeoman 592729 592729 Miles, James, of Asshill, yeoman 2
5352711 2460937 2460937 defendant Smyth Robert yeoman 592729 592729 Smyth, Robert, of Asshill, yeoman 3
5355833 2461898 2461898 defendant Hoggeson William gent 592729 592729 Hoggeson, William, of Asshill, gent 0
5379371 2469140 2469140 defendant Smyth Robert yeoman 592729 592729 Smyth, Robert, of Asshill, yeoman 2
5410536 2478095 2478095 defendant Smyth Robert yeoman 592729 592729 Smyth, Robert, of Asshill, yeoman 0
5483777 2500093 2500093 defendant Ives Richard husbandman 592729 592729 Ives, Richard, of Asshill, husbandman 1
5504831 2506431 2506431 defendant Coo Richard yeoman 592729 592729 Coo, Richard, of Asshill, yeoman 0
5545532 2518681 2518681 defendant Thaxter John chaplain 592729 592729 Thaxter John, of Asshill, chaplain 2
5546093 2518854 2518854 defendant Knebull Thomas clerk 592729 592729 Knebull, Thomas, of Asshill, clerk 0
5546515 2518981 2518981 defendant Watson George yeoman 592729 592729 Watson, George, of Asshill, yeoman 2
5593296 2532884 2532884 defendant Rome Robert husbandman 592729 592729 Rome, Robert, of Asshill, husbandman 2

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