names

66 rows where place_id = 587112

✎ 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
3590498 1864673 1864673 defendant Wyskey Henry yeoman 587112 587112 Wyskey, Henry, of Axmyster, yeoman 1
3590499 1864673 1864673 defendant Baker John yeoman 587112 587112 Baker, John, of Axmyster, yeoman 2
3590500 1864673 1864673 defendant Thomas John yeoman 587112 587112 Thomas, John, of Axmyster, yeoman 3
3590501 1864673 1864673 defendant Blakealler John yeoman 587112 587112 Blakealler, John, of Axmyster, yeoman 4
3590502 1864673 1864673 defendant Frye Philip yeoman 587112 587112 Frye, Philip, of Axmyster, yeoman 5
3590503 1864673 1864673 defendant Mighell Mathew yeoman 587112 587112 Mighell, Mathew, of Axmyster, yeoman 6
3595103 1866099 1866099 defendant Hogge Henry yeoman 587112 587112 Hogge, Henry, of Axmyster, yeoman 1
3610903 1871083 1871083 defendant Were Nicholas chapman 587112 587112 Were, Nicholas, of Axmyster, chapman 0
3618455 1873399 1873399 defendant Coryngdon John mercer 587112 587112 Coryngdon, John, of Axmyster, mercer 4
3618456 1873399 1873399 defendant Lokyer William smith 587112 587112 Lokyer, William, of Axmyster, smith 5
3618457 1873399 1873399 defendant Mallak Henry husbandman 587112 587112 Mallak, Henry, of Axmyster, husbandman 6
3618461 1873399 1873399 defendant Tochyng or Tothyng John miller 587112 587112 Tochyng or Tothyng, John, of Axmyster, miller 10
3672308 1917340 1917340 defendant Lang Thomas husbandman 587112 587112 Lang, Thomas, of Axmyster, husbandman 0
3691580 1923524 1923524 defendant Copp John merchant 587112 587112 Copp, John, of Axmyster, merchant 1
3691583 1923525 1923525 defendant Pevys or Penys Robert merchant 587112 587112 Pevys or Penys, Robert, of Axmyster, merchant 0
3735668 1937390 1937390 defendant Copp or Copper John merchant 587112 587112 Copp or Copper, John, of Axmyster, merchant 1
3738812 1938345 1938345 defendant Warryng John yeoman 587112 587112 Warryng, John, of Axmyster, yeoman 0
3751219 1942305 1942305 defendant Long Edith widow 587112 587112 Long, Edith, of Axmyster, widow 0
3804438 1959327 1959327 defendant Locke John merchant 587112 587112 Locke, John, of Axmyster, merchant 0
3808087 1960421 1960421 defendant Locke John merchant 587112 587112 Locke, John, of Axmyster, merchant 0
3819808 1964076 1964076 defendant Lock Thomas merchant 587112 587112 Lock, Thomas, of Axmyster, merchant 1
3868606 1979739 1979739 defendant Newton William husbandman 587112 587112 Newton, William, of Axmyster, husbandman 0
3868607 1979739 1979739 defendant Dyllyng John husbandman 587112 587112 Dyllyng, John, of Axmyster, husbandman 1
3882200 1984305 1984305 defendant Lyllyng alias Uplyme Walter laborer 587112 587112 Lyllyng alias Uplyme, Walter, of Axmyster, laborer 1
3887903 1986203 1986203 defendant Locke John messenger 587112 587112 Locke, John, of Axmyster, messenger 0
3898028 1989547 1989547 defendant Danyell Henry husbandman 587112 587112 Danyell, Henry, of Axmyster, husbandman 0
3963821 2011948 2011948 defendant Stevans Gregory yeoman 587112 587112 Stevans, Gregory, of Axmyster, yeoman 2
3981228 2018048 2018048 plaintiff Pyn Richard tailor 587112 587112 Pyn, Richard, of Axmyster, tailor 0
3982380 2018471 2018471 defendant Longe William merchant 587112 587112 Longe, William, of Axmyster, merchant 0
4017926 2031126 2031126 defendant Burley alias Smyth William smith 587112 587112 Burley alias Smyth, William, of Axmyster, smith 0
4027874 2034618 2034618 defendant Garrys John shoemaker 587112 587112 Garrys, John, of Axmyster, shoemaker 1
4258565 2115831 2115831 defendant Selwood John husbandman 587112 587112 Selwood, John, of Axmyster, husbandman 3
4684691 2260813 2260813 defendant Deigher (illegible) laborer 587112 587112 Deigher, ----, of Axmyster, laborer 1
4684692 2260813 2260813 defendant Snell John carpenter 587112 587112 Snell, John, of Axmyster, carpenter 2
4879883 2320623 2320623 defendant Lederad Roger esq 587112 587112 Lederad, Roger, of Axmyster, esq 0
4956963 2344039 2344039 defendant Skynner Robert skinner 587112 587112 Skynner, Robert, of Axmyster, skinner 1
4964362 2346256 2346256 defendant Bateman John tucker 587112 587112 Bateman, John, of Axmyster, tucker 0
4980979 2351244 2351244 defendant Bateman John tucker 587112 587112 Bateman, John, of Axmyster, tucker 0
4982010 2351538 2351538 defendant Lamport Alan   587112 587112 Lamport, Alan, of Axmyster, bailiff 0
5015186 2361328 2361328 defendant Crandon William weaver 587112 587112 Crandon, William, of Axmyster, weaver 5
5017808 2362089 2362089 defendant Bateman John tucker 587112 587112 Bateman, John, of Axmyster, tucker 2
5017813 2362090 2362090 defendant Bateman John tucker 587112 587112 Bateman, John, of Axmyster, tucker 2
5022976 2363629 2363629 defendant Crandon William weaver 587112 587112 Crandon, William, of Axmyster, weaver 4
5059015 2374261 2374261 defendant Mallok Henry husbandman 587112 587112 Mallok, Henry, of Axmyster, husbandman 0
5059016 2374261 2374261 defendant Mallok William   587112 587112 Mallok, William, of Axmyster, groom 1
5059017 2374261 2374261 defendant Mallok Thomas   587112 587112 Mallok, Thomas, of Axmyster, groom 2
5108895 2389021 2389021 defendant Parrok William husbandman 587112 587112 Parrok, William,of Axmyster, husbandman 1
5257556 2432482 2432482 defendant Sayer John husbandman 587112 587112 Sayer, John, of Axmyster, husbandman 5
5288288 2441594 2441594 defendant Payn John yeoman 587112 587112 Payn, John, of Axmyster, or of Mynchynghome, yeoman 4
5290905 2442344 2442344 defendant Tanner William tanner 587112 587112 Tanner, William, of Axmyster, tanner 3
5340354 2457188 2457188 defendant Slade John yeoman 587112 587112 Slade, John, of Axmyster, yeoman 0
5374207 2467533 2467533 defendant Coke John laborer 587112 587112 Coke, John, of Axmyster, laborer 2
5395678 2473845 2473845 defendant Ceppe John chapman 587112 587112 Ceppe, John, of Axmyster, chapman 2
5395682 2473846 2473846 defendant Ceppe John chapman 587112 587112 Ceppe, John, of Axmyster, chapman 2
5433614 2485019 2485019 defendant Coppe Thomas mercer 587112 587112 Coppe, Thomas, of Axmyster, mercer 0
5477924 2498422 2498422 defendant Muttelbury John yeoman 587112 587112 Muttelbury, John, of Axmyster, yeoman 3
5494143 2503152 2503152 defendant Lokyer John yeoman 587112 587112 Lokyer, John, of Axmyster, yeoman 0
5494144 2503152 2503152 defendant Frensheman Michael laborer 587112 587112 Frensheman, Michael, of Axmyster, laborer 1
5494145 2503152 2503152 defendant Artour John laborer 587112 587112 Artour, John, of Axmyster, laborer 2
5509120 2507706 2507706 defendant Frenshman Michael laborer 587112 587112 Frenshman, Michael, of Axmyster, laborer 0
5509121 2507706 2507706 defendant Arthour John laborer 587112 587112 Arthour, John, of Axmyster, laborer 1
5525956 2512712 2512712 defendant Lokyer William husbandman 587112 587112 Lokyer, William, of Axmyster, husbandman 0
5545477 2518666 2518666 defendant Negh John weaver 587112 587112 Negh, John, of Axmyster, weaver 1
5574492 2527104 2527104 defendant Stone John husbandman 587112 587112 Stone, John, of Axmyster, husbandman 1
5595485 2533537 2533537 defendant Slade John, junior   587112 587112 Slade, John, junior, of Axmyster, groom 1
5606929 2537058 2537058 defendant Oxenbere William husbandman 587112 587112 Oxenbere, William, of Axmyster, 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);