names

49 rows where place_id = 588635

✎ 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
3595117 1866104 1866104 defendant Jowell Edwmund shoemaker 588635 588635 Jowell, Edwmund, of Est Harlyng, shoemaker 0
3600536 1867815 1867815 plaintiff Wyngfeld Anne widow 588635 588635 Wyngfeld, Anne, of Est Harlyng, widow 0
3664687 1914907 1914907 defendant Flour Adam husbandman 588635 588635 Flour, Adam, of Est Harlyng, husbandman 0
3696289 1925060 1925060 defendant Bullok John smith 588635 588635 Bullok, John, of Est Harlyng, smith 0
3768375 1947753 1947753 defendant Hille John laborer 588635 588635 Hille, John, of Est Harlyng, laborer 0
3791853 1955297 1955297 defendant Wylkynson Simon husbandman 588635 588635 Wylkynson, Simon, of Est Harlyng, husbandman 2
3801299 1958333 1958333 plaintiff Mondys John mercer 588635 588635 Mondys, John, of Est Harlyng, mercer 0
3807928 1960369 1960369 defendant Walsche John yeoman 588635 588635 Walsche, John, of Est Harlyng, yeoman 0
3871519 1980718 1980718 defendant Menycke John yeoman 588635 588635 Menycke, John, of Est Harlyng, yeoman 1
3871520 1980718 1980718 defendant Saunders Robert yeoman 588635 588635 Saunders, Robert, of Est Harlyng, yeoman 2
3945851 2005623 2005623 defendant Hamlett Andrew yeoman 588635 588635 Hamlett, Andrew, of Est Harlyng, yeoman 1
3954875 2008772 2008772 plaintiff Lovell Thomas   588635 588635 Lovell, Thomas, of Est Harlyng, knight 0
3956314 2009271 2009271 defendant Asshewell William   588635 588635 Asshewell, William, of Est Harlyng, shepherd 0
3977630 2016747 2016747 plaintiff Lovell Thomas   588635 588635 Lovell, Thomas, of Est Harlyng, knight 0
3980819 2017904 2017904 defendant Roberdson John smith 588635 588635 Roberdson, John, of Est Harlyng, smith 0
4045759 2040930 2040930 defendant Porter Richard draper 588635 588635 Porter, Richard, of Est Harlyng, draper 0
4052866 2043460 2043460 defendant Pollard William husbandman 588635 588635 Pollard, William, of Est Harlyng, husbandman 3
4151847 2078758 2078758 defendant Hawkyns John yeoman 588635 588635 Hawkyns, John, of Est Harlyng, yeoman 0
4326368 2139183 2139183 defendant Crosse Robert husbandman 588635 588635 Crosse, Robert, of East Harlyng, husbandman 1
4385625 2159875 2159875 defendant Vowell Robert gent 588635 588635 Vowell, Robert, of East Harlyng, gent 1
4530171 2209725 2209725 defendant Drewe James   588635 588635 Drewe, James, of East Harlyng, bailiff 0
4611653 2234706 2234706 defendant Gylmyn John, sen   588635 588635 Gylmyn, John, sen, of East Harlyng 1
4747599 2279806 2279806 defendant Dowe Thomas yeoman & son of John Dowe 588635 588635 Dowe, Thomas, of East Harlyng, yeoman & son of John Dowe 0
4747600 2279806 2279806 defendant Caudeler John yeoman 588635 588635 Caudeler, John, of East Harlyng, yeoman 1
4747601 2279806 2279806 defendant Dowe John yeoman & son of John Dowe 588635 588635 Dowe, John, of East Harlyng, yeoman & son of John Dowe 2
4747602 2279806 2279806 defendant Byllerne Thomas yeoman & son of John Byllerne 588635 588635 Byllerne, Thomas, of East Harlyng, yeoman & son of John Byllerne 3
4852233 2312127 2312127 defendant Scot Walter butcher 588635 588635 Scot, Walter, of East Harlyng, butcher 1
4867175 2316693 2316693 defendant Notyngham John yeoman 588635 588635 (Notyngham, John, of Est Harlyng, yeoman 2
4867176 2316693 2316693 defendant Gylmy John scrivener 588635 588635 Gylmy, John, of Est Harlyng, scrivener 3
4877874 2320037 2320037 defendant Cusshon John yeoman 588635 588635 Cusshon, John, of Est Harlyng, yeoman 1
4895366 2325210 2325210 defendant Billerne Thomas yeoman 588635 588635 Billerne, Thomas, of Est Harlyng, yeoman 1
4901234 2326994 2326994 defendant Aleyn Thomas husbandman 588635 588635 Aleyn, Thomas, of Est Harlyng, husbandman 1
4902450 2327381 2327381 defendant Payn Thomas smith 588635 588635 Payn, Thomas, of Est Harlyng, smith 0
4905151 2328211 2328211 defendant Prylle John husbandman 588635 588635 Prylle, John, of Est Harlyng, husbandman 2
4928321 2335282 2335282 defendant Harre William yeoman 588635 588635 Harre, William, of East Harlyng, yeoman 0
4928322 2335282 2335282 defendant Harre Robert yeoman 588635 588635 Harre, Robert, of East Harlyng, yeoman 1
4928323 2335282 2335282 defendant Waryn Geoffrey weaver 588635 588635 Waryn, Geoffrey, of East Harlyng, weaver 2
4938180 2338319 2338319 defendant Aleyn William   588635 588635 Aleyn, William, of Est Harlyng husbandman 0
4972698 2348768 2348768 defendant Couper Edmund clerk 588635 588635 Couper, Edmund, of Est Harlyng, clerk 0
4976588 2349957 2349957 defendant Porter John miller 588635 588635 Porter, John, of Est Harlyng, miller 4
5003560 2357936 2357936 defendant Porter John miller 588635 588635 Porter, John, of East Harlyng, miller 5
5115756 2391038 2391038 defendant Sekford George, junior gent 588635 588635 Sekford, George, junior, of Est Harlyng, gent 0
5115758 2391038 2391038 defendant Tery John yeoman 588635 588635 Tery, John, of Est Harlyng, yeoman 2
5225580 2423154 2423154 defendant Preston William gent 588635 588635 Preston, William, of Est Harlyng, gent 5
5255762 2431923 2431923 defendant Reedham Richard chaplain 588635 588635 Reedham, Richard, of Est Harlyng, chaplain 0
5365205 2464790 2464790 defendant Jowell Edmund   588635 588635 Jowell, Edmund, of East Harlyng, shoe maker 0
5496424 2503838 2503838 defendant Jowell Edmund shoemaker 588635 588635 Jowell, Edmund, of Est Harlyng, shoemaker 1
5574119 2526995 2526995 defendant Person James chapman 588635 588635 Person, James, of Est Harlyng, chapman 1
5626879 2552380 2552380 defendant Cove Richard yeoman 588635 588635 Cove, Richard, of Est Harlyng, yeoman 2

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