names

54 rows where place_id = 606103

✎ 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
3664039 1914702 1914702 plaintiff Randall James Master of the Fraternity & Guild of Jesus 606103 606103 Randall, James, of Baldock, Master of the Fraternity & Guild of Jesus 0
3881172 1983970 1983970 defendant Spurlyng John husbandman 606103 606103 Spurlyng, John, of Baldock, husbandman 0
3935175 2002074 2002074 defendant Jeve John brother of James 606103 606103 Jeve, John, of Baldock, yeoman, brother of James 0
3935176 2002075 2002075 plaintiff Jeve John   606103 606103 Jeve, John, of Baldock, junior, son of Edward Jeve 0
3937310 2002813 2002813 defendant Geve James gent 606103 606103 Geve, James, of Baldock, gent 0
3937311 2002813 2002813 defendant Smyth George husbandman 606103 606103 Smyth, George, of Baldock, husbandman 1
3944881 2005305 2005305 plaintiff Bennett Leonard yeoman 606103 606103 Bennett, Leonard, of Baldock, yeoman 0
3945560 2005523 2005523 defendant Jeve James gent 606103 606103 Jeve, James, of Baldock, gent 0
3946497 2005843 2005843 defendant Hawkyns Richard barber 606103 606103 Hawkyns, Richard, of Baldock, barber 0
3947391 2006162 2006162 plaintiff Cocke William   606103 606103 Cocke, William, of Baldock, malt maker 0
3959427 2010382 2010382 plaintiff Shotbolt John maltster 606103 606103 Shotbolt, John, of Baldock, maltster 0
3959920 2010566 2010566 plaintiff Sparlyng John maltmaker 606103 606103 Sparlyng, John, of Baldock, maltmaker 0
3960628 2010818 2010818 plaintiff Syll Oliver maltman 606103 606103 Syll, Oliver, of Baldock, maltman 0
3971624 2014637 2014637 plaintiff Fage Anthony yeoman 606103 606103 Fage, Anthony, of Baldock, yeoman 0
3971627 2014638 2014638 plaintiff Fage Anthony yeoman 606103 606103 Fage, Anthony, of Baldock, yeoman 0
3974405 2015621 2015621 plaintiff Spurlyng Henry maltster 606103 606103 Spurlyng, Henry, of Baldock, maltster 1
4000236 2024854 2024854 defendant Rocheford John yeoman 606103 606103 Rocheford, John, of Baldock, yeoman 0
4015990 2030411 2030411 plaintiff Spurlyng John yeoman 606103 606103 Spurlyng, John, of Baldock, yeoman 0
4041213 2039347 2039347 plaintiff Mylles John yeoman 606103 606103 Mylles, John, of Baldock, yeoman 0
4044831 2040602 2040602 plaintiff Rocheford James maltster 606103 606103 Rocheford James, of Baldock, maltster 0
4208371 2098476 2098476 defendant Bramfild James yeoman 606103 606103 Bramfild, James, of Baldock, yeoman 1
4209830 2098998 2098998 defendant Ive James gent 606103 606103 Ive, James, of Baldock, gent 1
4222091 2103218 2103218 defendant Bennett John maltster 606103 606103 Bennett, John, of Baldock, yeoman, maltster 0
4222093 2103219 2103219 defendant Bennett John maltster 606103 606103 Bennett, John, of Baldock, yeoman, maltster 0
4235440 2107964 2107964 defendant Walker Augustine maltman 606103 606103 Walker, Augustine, of Baldock, maltman 0
4276429 2121699 2121699 defendant Plomer John glover 606103 606103 Plomer, John, of Baldock, or of Sabridgworthe, glover 0
4277256 2121976 2121976 defendant Whelston John gent 606103 606103 Whelston, John, of Baldock, gent 0
4279284 2122684 2122684 defendant Bennet John innholder 606103 606103 Bennet, John, of Baldock, yeoman, innholder 0
4279509 2122752 2122752 defendant Whelston John yeoman 606103 606103 Whelston, John, of Baldock, yeoman 2
4279514 2122753 2122753 defendant Whelston John yeoman 606103 606103 Whelston, John, of Baldock, yeoman 2
4280888 2123220 2123220 defendant Underwood John yeoman 606103 606103 Underwood, John, of Baldock, yeoman 1
4281204 2123334 2123334 defendant Flecher William butcher 606103 606103 Flecher, William, of Baldock, butcher 0
4281339 2123379 2123379 defendant Shawe John   606103 606103 Shawe, John, of Baldock, collar maker 2
4281341 2123379 2123379 defendant Stubbinge Anne widow 606103 606103 Stubbinge, Anne, of Baldock, widow 4
4313738 2134912 2134912 defendant Spurlynge Henry yeoman 606103 606103 Spurlynge, Henry, of Baldock, yeoman 1
4321342 2137557 2137557 defendant Taylor alias Cadwell James yeoman 606103 606103 Taylor alias Cadwell, James, of Baldock, yeoman 0
4360831 2151040 2151040 defendant Smyth Thomas yeoman 606103 606103 Smyth, Thomas, of Baldock, yeoman 0
4364115 2152221 2152221 defendant Plomer John yeoman 606103 606103 Plomer, John, of Baldock, or of Sabridgworth, yeoman 0
4391898 2161916 2161916 defendant Hynde Edward yeoman 606103 606103 Hynde, Edward, of Baldock, yeoman 0
4401545 2165113 2165113 defendant Rochford John yeoman 606103 606103 Rochford, John, of Baldock, yeoman 0
4401548 2165114 2165114 defendant Smyth Thomas yeoman 606103 606103 Smyth, Thomas, of Baldock, yeoman 0
4509733 2203527 2203527 defendant Colle Thomas   606103 606103 Colle, Thomas, of Baldock 0
4519859 2206562 2206562 defendant Clyfton Richard   606103 606103 Clyfton, Richard, of Baldock 0
4601384 2231670 2231670 defendant Fage John   606103 606103 Fage, John, of Baldock 0
4703731 2266546 2266546 defendant Clyfton Richard   606103 606103 Clyfton, Richard, of Baldock, horse master 0
4704110 2266663 2266663 defendant Walkar William clerk 606103 606103 Walkar, William, of Baldock, clerk 0
4707778 2267798 2267798 defendant Ropere John yeoman 606103 606103 Ropere, John, of Baldock, yeoman 0
5160829 2404262 2404262 defendant Wydney Thomas yeoman 606103 606103 Wydney, Thomas, of Baldock, yeoman 2
5173382 2407921 2407921 defendant Redhode John gent 606103 606103 Redhode, John, of Baldock, gent 0
5188736 2412434 2412434 defendant Wydney Thomas husbandman 606103 606103 Wydney, Thomas, of Baldock, husbandman 0
5206237 2417559 2417559 defendant Wydney Thomas husbandman 606103 606103 Wydney, Thomas, of Baldock, husbandman 0
5206240 2417560 2417560 defendant Wydney Thomas husbandman 606103 606103 Wydney, Thomas, of Baldock, husbandman 0
5386412 2471185 2471185 defendant Witney William husbandman 606103 606103 Witney, William, of Baldock, husbandman 0
5471615 2496459 2496459 defendant Barney Thomas husbandman 606103 606103 Barney, Thomas, of Baldock, 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);