names

54 rows where place_id = 608800

✎ 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
3675478 1918369 1918369 plaintiff Hayne John   608800 608800 Hayne, John, of Molton 0
3676545 1918708 1918708 defendant Blanke John husbandman 608800 608800 Blanke, John, of Molton, husbandman 0
3689349 1922834 1922834 defendant Broun Robert butcher 608800 608800 Broun, Robert, of Molton, butcher 0
3771616 1948821 1948821 defendant Waller John husbandman 608800 608800 Waller, John, of Molton, husbandman 2
3777409 1950681 1950681 plaintiff Clotworthe Robert   608800 608800 Clotworthe, Robert, of Molton singleman 0
3788286 1954133 1954133 defendant Whoton John husbandman 608800 608800 Whoton, John, of Molton, husbandman 0
3790467 1954840 1954840 defendant Greyner Robert clothier 608800 608800 Greyner, Robert, of Molton, clothier 0
3795799 1956553 1956553 defendant Prest Thomas husbandman 608800 608800 Prest, Thomas, of Molton, husbandman 3
3838756 1970050 1970050 plaintiff Vowtere John sherman 608800 608800 Vowtere, John, of Molton, sherman 0
3863456 1977971 1977971 plaintiff Hunt Robert   608800 608800 Hunt, Robert, of Molton 0
3888188 1986304 1986304 plaintiff Dowrege alias Doderryng John   608800 608800 Dowrege alias Doderryng, John, of Molton 0
3913625 1994895 1994895 defendant Drove John husbandman 608800 608800 Drove, John, of Molton, husbandman 0
3917905 1996351 1996351 plaintiff Hayne George   608800 608800 Hayne, George, of Molton 0
3937879 2003001 2003001 defendant Hayward John husbandman 608800 608800 Hayward, John, of Molton, husbandman 0
3942032 2004348 2004348 defendant Clerke John husbandman 608800 608800 Clerke, John, of Molton, husbandman 0
3942923 2004637 2004637 defendant Tracy George gent 608800 608800 Tracy, George, of Molton, gent 0
3977231 2016606 2016606 plaintiff Leche John   608800 608800 Leche, John, of Molton 0
3997857 2023992 2023992 defendant Smyth Thomas   608800 608800 Smyth, Thomas, of Molton, husbandman, eldest son of Thomas Smyth, of Holbytche 0
4005237 2026653 2026653 defendant Woley John yeoman 608800 608800 Woley, John, of Molton, yeoman 0
4041407 2039419 2039419 plaintiff Nettleton John gent 608800 608800 Nettleton, John, of Molton, gent 0
4050713 2042688 2042688 defendant Kyng Thomas (legal representative) 608800 608800 Kyng, Thomas, of Molton, yeoman, executor of 0
4050714 2042688 2042688 defendant Kyng William yeoman 608800 608800 Kyng, William, of Molton, yeoman 1
4051207 2042871 2042871 defendant Bigott John yeoman 608800 608800 Bigott, John, of Molton, yeoman 0
4051211 2042872 2042872 defendant Bygott John yeoman 608800 608800 Bygott, John, of Molton, yeoman 0
4051595 2042989 2042989 defendant Marshall John weaver 608800 608800 Marshall, John, of Molton, weaver 0
4079612 2053007 2053007 defendant Serolos William yeoman 608800 608800 Serolos, William, of Molton, yeoman 0
4079614 2053007 2053007 defendant Blackman Robert yeoman 608800 608800 Blackman, Robert, of Molton, yeoman 2
4081331 2053632 2053632 defendant Esson John yeoman 608800 608800 Esson, John, of Molton, yeoman 5
4101046 2060688 2060688 defendant Burton William husbandman 608800 608800 Burton, William, of Molton, husbandman 0
4101047 2060688 2060688 defendant Burton Richard husbandman 608800 608800 Burton, Richard, of Molton, husbandman 1
4127001 2069948 2069948 defendant Brunston Edmund yeoman 608800 608800 Brunston, Edmund, of Molton, yeoman 0
4150321 2078243 2078243 defendant Brunston Edmund yeoman 608800 608800 Brunston, Edmund, of Molton, yeoman 0
4173945 2086343 2086343 defendant Kydd Walter smith 608800 608800 Kydd, Walter, of Molton, smith 1
4194091 2093487 2093487 defendant Risbye Francis yeoman 608800 608800 Risbye, Francis, of Molton, yeoman 2
4212705 2099984 2099984 defendant Kecheman or Kacheman Peter yeoman 608800 608800 Kecheman or Kacheman, Peter, of Molton, yeoman 0
4278027 2122247 2122247 defendant Lawson Thomas tailor 608800 608800 Lawson, Thomas, of Molton, tailor 0
4279487 2122746 2122746 defendant Mason Robert yeoman 608800 608800 Mason, Robert, of Molton, yeoman 0
4279488 2122746 2122746 defendant Fraunces Nicholas yeoman 608800 608800 Fraunces, Nicholas, of Molton, yeoman 1
4299024 2129746 2129746 defendant Dixon Anthony yeoman 608800 608800 Dixon, Anthony, of Molton, yeoman 0
4436190 2176060 2176060 plaintiff Ros Elizabeth de   608800 608800 Ros, Elizabeth de, of Molton, formerly wife of William 0
4444691 2183318 2183318 defendant Luffe Richard   608800 608800 Luffe, Richard, of Molton 1
4444696 2183319 2183319 defendant Wymond John   608800 608800 Wymond, John, of Molton 2
4480626 2194606 2194606 defendant Pyper John   608800 608800 Pyper, John, of Molton 4
4480627 2194606 2194606 defendant Baker William   608800 608800 Baker, William, of Molton 5
4522782 2207462 2207462 defendant Palmer John   608800 608800 Palmer, John, of Molton 0
4539657 2212663 2212663 defendant Andrewes John   608800 608800 Andrewes, John, of Molton 1
4580931 2225512 2225512 defendant Pewen John   608800 608800 Pewen, John, of Molton 13
4649845 2245974 2245974 defendant Bronwyche John   608800 608800 Bronwyche, John, of Molton 0
4752789 2281272 2281272 defendant Abdy John, junior husbandman 608800 608800 Abdy, John, junior, of Molton, husbandman 2
4813093 2300210 2300210 defendant Cley John mercer 608800 608800 Cley, John, of Molton, mercer 1
4864435 2315853 2315853 defendant Walton John husbandman 608800 608800 (Walton, John, of Molton, husbandman 3
4864436 2315853 2315853 defendant Gryse Joan widow 608800 608800 Gryse, Joan, of Molton, widow 4
5140646 2398374 2398374 defendant Touker Roger husbandman 608800 608800 Touker, Roger, of Molton, husbandman 0
5237234 2426473 2426473 defendant Prowet Robert husbandman 608800 608800 Prowet, Robert, of Molton, husbandman 4

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