names

41 rows where place_id = 609534

✎ 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
3678893 1919467 1919467 defendant Taverner John husbandman 609534 609534 Taverner, John, of Standon, husbandman 0
3739367 1938519 1938519 defendant Kyrkby John tanner 609534 609534 Kyrkby, John, of Standon, tanner 1
3739368 1938519 1938519 defendant Clevenger William tailor 609534 609534 Clevenger, William, of Standon, tailor 2
3790329 1954793 1954793 defendant Bedell Robert husbandman 609534 609534 Bedell, Robert, of Standon, husbandman 0
3810153 1961066 1961066 plaintiff Boverey Nicholas   609534 609534 Boverey, Nicholas, of Standon 0
3817410 1963359 1963359 defendant Lamkyn John yeoman 609534 609534 Lamkyn, John, of Standon, yeoman 0
3832089 1967941 1967941 defendant Braughyng Richard gent 609534 609534 Braughyng, Richard, of Standon, gent 0
3836568 1969340 1969340 defendant Grene William yeoman 609534 609534 Grene, William, of Standon, yeoman 1
3836569 1969340 1969340 defendant Bedill George yeoman 609534 609534 Bedill, George, of Standon, yeoman 2
3869875 1980170 1980170 defendant Isake John husbandman 609534 609534 Isake, John, of Standon, husbandman 0
3869876 1980170 1980170 defendant Barre Nicholas husbandman 609534 609534 Barre, Nicholas, of Standon, husbandman 1
3869877 1980170 1980170 defendant Kyrby Nicholas husbandman 609534 609534 Kyrby, Nicholas, of Standon, husbandman 2
3898337 1989654 1989654 defendant Gyll Peter   609534 609534 Gyll, Peter, of Standon, horse courser 0
3900533 1990407 1990407 defendant Hawkyns John husbandman 609534 609534 Hawkyns, John, of Standon, husbandman 1
3900534 1990407 1990407 defendant Kyng John husbandman 609534 609534 Kyng, John, of Standon, husbandman 2
4135709 2073098 2073098 defendant Arundell Walter yeoman 609534 609534 Arundell, Walter, of Standon, yeoman 1
4172590 2085871 2085871 defendant Dawderne Henry tanner 609534 609534 Dawderne, Henry, of Standon, tanner 0
4235756 2108076 2108076 defendant Simson Thomas miller 609534 609534 Simson, Thomas, of Standon, miller 0
4279408 2122719 2122719 defendant Danyell John yeoman 609534 609534 Danyell, John, of Standon, yeoman 0
4279410 2122719 2122719 defendant Grene Henry yeoman 609534 609534 Grene, Henry, of Standon, yeoman 2
4310821 2133930 2133930 defendant Thorley William yeoman 609534 609534 Thorley, William, of Standon, yeoman 1
4323484 2138274 2138274 defendant Rymmer John butcher 609534 609534 Rymmer, John, of Standon, butcher 0
4378606 2157421 2157421 defendant Smythe Edmund yeoman 609534 609534 Smythe, Edmund, of Standon, yeoman 2
4398819 2164186 2164186 defendant Addams Thomas butcher 609534 609534 Addams, Thomas, of Standon, butcher 0
4409424 2167748 2167748 defendant Cawdewall Henry yeoman 609534 609534 Cawdewall, Henry, of Standon, yeoman 0
4417082 2170212 2170212 defendant Burdeyn John   609534 609534 Burdeyn, John, of Standon 0
4646562 2245059 2245059 defendant Brugge John esq 609534 609534 Brugge, John, of Standon, esq 1
5094280 2384733 2384733 defendant Tournour Thomas husbandman 609534 609534 Tournour, Thomas, of Standon, husbandman 0
5199745 2415674 2415674 plaintiff Colman John   609534 609534 Colman, John, of Standon 3
5211233 2419015 2419015 plaintiff Colman John   609534 609534 Colman, John, of Standon 3
5272601 2437061 2437061 defendant Strode John husbandman 609534 609534 Strode, John, of Standon, husbandman 4
5366780 2465267 2465267 defendant Rogers Thomas yeoman 609534 609534 Rogers, Thomas, of Standon, yeoman 1
5366788 2465268 2465268 defendant Toers Thomas yeoman 609534 609534 Toers, Thomas, of Standon, yeoman 1
5384032 2470519 2470519 defendant Sefferey Henry clerk 609534 609534 Sefferey, Henry, of Standon, clerk 0
5384036 2470521 2470521 defendant Sefferey Henry clerk 609534 609534 Sefferey, Henry, of Standon, clerk 0
5390479 2472339 2472339 defendant Broke Robert maltman 609534 609534 Broke, Robert, of Standon, maltman 0
5506229 2506869 2506869 defendant Danyell William yeoman 609534 609534 Danyell, William, of Standon, yeoman 0
5514104 2509259 2509259 defendant Asteley John esq 609534 609534 Asteley, John, of Standon, esq 0
5518519 2510622 2510622 defendant Noke John husbandman 609534 609534 Noke, John, of Standon, husbandman 1
5591063 2532184 2532184 defendant Feld William husbandman 609534 609534 Feld, William, of Standon, husbandman 0
5603063 2535842 2535842 defendant Syrell Richard husbandman 609534 609534 Syrell, Richard, of Standon, husbandman 1

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