names

68 rows where place_id = 595939

✎ 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
3622461 1874562 1874562 defendant Ine or Ive or Jue Philip laborer 595939 595939 Ine or Ive or Jue, Philip, of Parva Munden, laborer 0
3628591 1903816 1903816 defendant Chapman John husbandman 595939 595939 Chapman, John, of Parva Munden, husbandman 0
3631862 1904774 1904774 defendant Plomme Thomas tilemaker 595939 595939 Plomme, Thomas, of Parva Munden, tilemaker 3
3650875 1910641 1910641 plaintiff Smyth alias Lyston John (legal representative) 595939 595939 Smyth alias Lyston, John, of Parva Munden, executors of 0
3667964 1915921 1915921 defendant Kent John smith 595939 595939 Kent, John, of Parva Munden, smith 0
3667965 1915921 1915921 defendant Chapman John husbandman 595939 595939 Chapman, John, of Parva Munden, husbandman 1
3668978 1916229 1916229 defendant Andrewe William, senior yeoman 595939 595939 Andrewe, William, senior, of Parva Munden, yeoman 0
3669746 1916485 1916485 defendant Andrewe John maltman 595939 595939 Andrewe, John, of Parva Munden, maltman 1
3672552 1917413 1917413 defendant Andrewe John husbandman 595939 595939 Andrewe, John, of Parva Munden, husbandman 0
3689223 1922795 1922795 defendant Chapman Richard yeoman 595939 595939 Chapman, Richard, of Parva Munden, yeoman 1
3692014 1923669 1923669 defendant Chapman Richard, junior yeoman 595939 595939 Chapman, Richard, junior, of Parva Munden, yeoman 2
3720427 1932669 1932669 defendant Andrewe William, senior yeoman 595939 595939 Andrewe, William, senior, of Parva Munden, yeoman 0
3736169 1937555 1937555 defendant Andrewe Wiiliam yeoman 595939 595939 Andrewe, Wiiliam, of Parva Munden, yeoman 0
3736402 1937628 1937628 defendant Chapman William   595939 595939 Chapman, William, of Parva Munden, tile maker 1
3741132 1939089 1939089 defendant More William husbandman 595939 595939 More, William, of Parva Munden, husbandman 0
3756225 1943905 1943905 plaintiff Andrewe William maltman 595939 595939 Andrewe, William, of Parva Munden, maltman 0
3767225 1947388 1947388 defendant Thirgood Thomas husbandman 595939 595939 Thirgood, Thomas, of Parva Munden, husbandman 1
3767228 1947389 1947389 defendant Thurgood Thomas husbandman 595939 595939 Thurgood, Thomas, of Parva Munden, husbandman 1
3767231 1947390 1947390 defendant Thurgood Thomas husbandman 595939 595939 Thurgood, Thomas, of Parva Munden, husbandman 1
3773679 1949486 1949486 defendant Auncell William husbandman 595939 595939 Auncell, William, of Parva Munden, husbandman 4
3774132 1949621 1949621 defendant Andrewe William, junior yeoman 595939 595939 Andrewe, William, junior, of Parva Munden, yeoman 1
3785396 1953219 1953219 defendant Kent Richard maltman 595939 595939 Kent, Richard, of Parva Munden, maltman 2
3809093 1960727 1960727 defendant Auncell Robert husbandman 595939 595939 Auncell, Robert, of Parva Munden, husbandman 2
3850547 1973759 1973759 defendant Auncell John, senior maltman 595939 595939 Auncell, John, senior, of Parva Munden, maltman 1
3910462 1993816 1993816 defendant Colt John husbandman 595939 595939 Colt, John, of Parva Munden, husbandman 0
3910463 1993816 1993816 defendant Colt Richard husbandman 595939 595939 Colt, Richard,of Parva Munden, husbandman 1
3922491 1997839 1997839 defendant Andrewe John husbandman 595939 595939 Andrewe, John, of Parva Munden, husbandman 0
4326981 2139355 2139355 defendant Ireland Edward yeoman 595939 595939 Ireland, Edward, of Parva Munden, yeoman 1
4860927 2314777 2314777 plaintiff Colt John   595939 595939 Colt, John, of Parva Munden maltman 0
4867902 2316930 2316930 defendant Wodelond John husbandman 595939 595939 Wodelond, John, of Parva Munden, husbandman 0
4882291 2321371 2321371 defendant Bartilmewe James husbandman 595939 595939 Bartilmewe, James, of Parva Munden, husbandman 0
4882292 2321371 2321371 defendant White John husbandman 595939 595939 White, John, of Parva Munden, husbandman 1
4904290 2327958 2327958 defendant Kendale John yeoman 595939 595939 Kendale, John, of Parva Munden, yeoman 0
4904291 2327958 2327958 defendant Plumme William yeoman 595939 595939 Plumme, William, of Parva Munden, yeoman 1
4904292 2327958 2327958 defendant Shapeney John yeoman 595939 595939 Shapeney, John, of Parva Munden, yeoman 2
4968556 2347562 2347562 defendant Norys Eustace   595939 595939 Norys, Eustace, of Parva Munden, servant 0
4968559 2347562 2347562 defendant Waryn Elias husbandman 595939 595939 Waryn, Elias, of Parva Munden, husbandman 3
5017908 2362120 2362120 defendant Andrewe Gilbert husbandman 595939 595939 Andrewe, Gilbert, of Parva Munden, or of Norton, husbandman 0
5063088 2375497 2375497 defendant Colt John maltman 595939 595939 Colt, John, of Parva Munden, maltman 3
5063597 2375645 2375645 defendant Deyn John laborer 595939 595939 Deyn, John, of Parva Munden, laborer 0
5101406 2386825 2386825 defendant Miller Thomas laborer 595939 595939 Miller, Thomas, of Parva Munden, laborer 0
5101407 2386825 2386825 defendant Ippeswell Walter laborer 595939 595939 Ippeswell, Walter, of Parva Munden, laborer 1
5109089 2389080 2389080 defendant Ive John potter 595939 595939 Ive, John, of Parva Munden, potter 0
5109091 2389081 2389081 defendant Wrottyng William husbandman 595939 595939 Wrottyng, William, of Parva Munden, husbandman 0
5109092 2389081 2389081 defendant Miller Robert   595939 595939 Miller, Robert, of Parva Munden, tile maker 1
5109093 2389081 2389081 defendant Plome Thomas   595939 595939 Plome, Thomas, of Parva Munden, tile maker 2
5112296 2389980 2389980 defendant Gayler William maltman 595939 595939 Gayler, William, of Parva Munden, maltman 0
5230825 2424623 2424623 defendant Symmes John maltman 595939 595939 Symmes, John, of Parva Munden, maltman 1
5244624 2428611 2428611 defendant Plomme Thomas tilemaker 595939 595939 Plomme, Thomas, of Parva Munden, tilemaker 0
5244625 2428611 2428611 defendant Miller Robert tilemaker 595939 595939 Miller, Robert, of Parva Munden, tilemaker 1
5290198 2442135 2442135 defendant Colt John maltman 595939 595939 Colt, John, of Parva Munden, maltman 1
5311761 2448542 2448542 defendant Colte John husbandman 595939 595939 Colte, John, of Parva Munden, husbandman 0
5325793 2452797 2452797 defendant Colte John husbandman 595939 595939 Colte, John, of Parva Munden, husbandman 0
5336843 2456084 2456084 defendant Stacy William husbandman 595939 595939 Stacy, William, of Parva Munden, husbandman 0
5336844 2456084 2456084 defendant Stacy Thomas husbandman 595939 595939 Stacy, Thomas, of Parva Munden, husbandman 1
5336845 2456084 2456084 defendant Averell John potter 595939 595939 Averell, John, of Parva Munden, potter 2
5345971 2458873 2458873 defendant Lauraunce William husbandman 595939 595939 Lauraunce, William, of Parva Munden, husbandman 1
5356391 2462065 2462065 defendant Cokkyshed John tailor 595939 595939 Cokkyshed, John, of Parva Munden, tailor 0
5535762 2515693 2515693 defendant Kateralle Richard clerk 595939 595939 Kateralle, Richard, of Parva Munden, clerk 0
5535763 2515693 2515693 defendant Longtre Henry yeoman 595939 595939 Longtre, Henry, of Parva Munden, yeoman 1
5536678 2515956 2515956 defendant Chapman Thomas husbandman 595939 595939 Chapman, Thomas, of Parva Munden, husbandman 1
5537634 2516261 2516261 defendant Dekynson John   595939 595939 Dekynson, John, of Parva Munden, mason 0
5544965 2518532 2518532 defendant Chapman Richard husbandman 595939 595939 Chapman, Richard, of Parva Munden, husbandman 1
5558239 2522358 2522358 defendant Aleyn William   595939 595939 Aleyn, William, of Parva Munden, mason 2
5560248 2522960 2522960 defendant Adane Thomas husbandman 595939 595939 Adane, Thomas, of Parva Munden, husbandman 0
5563124 2523809 2523809 defendant Frost William husbandman 595939 595939 Frost, William, of Parva Munden, husbandman 0
5570519 2525950 2525950 defendant Cokyshede John husbandman 595939 595939 Cokyshede, John, of Parva Munden, husbandman 0
5582576 2529618 2529618 defendant Dane Thomas yeoman 595939 595939 Dane, Thomas, of Parva Munden, yeoman 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);