names

47 rows where place_id = 644971

✎ 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
3664369 1914806 1914806 plaintiff Rolfe William   644971 644971 Rolfe, William, of Keynesham, Abbot of the Monastery of St Mary 0
3664371 1914807 1914807 plaintiff Rolfe William   644971 644971 Rolfe, William, of Keynesham, abbot of the Monastery of the Blessed Mary 0
3883024 1984588 1984588 defendant Waryngton Thomas tucker 644971 644971 Waryngton, Thomas, of Keynesham, tucker 0
3893062 1987927 1987927 defendant Wheler John husbandman 644971 644971 Wheler, John, of Keynesham, husbandman 0
3893064 1987927 1987927 defendant Asshelyn Thomas fuller 644971 644971 Asshelyn, Thomas, of Keynesham, fuller 2
3893312 1987994 1987994 defendant Panter John gent 644971 644971 Panter, John, of Keynesham, gent 1
3921139 1997422 1997422 defendant Netherwey John husbandman 644971 644971 Netherwey, John, of Keynesham, husbandman 2
4455448 2186706 2186706 defendant Hernon William   644971 644971 Hernon, William, of Keynesham 0
4455449 2186706 2186706 defendant Fysshere William   644971 644971 Fysshere, William, of Keynesham 1
4484240 2195771 2195771 plaintiff Pederton Richard   644971 644971 Pederton, Richard, of Keynesham 0
4521318 2207011 2207011 defendant Cook Robert   644971 644971 Cook, Robert, of Keynesham 0
4557105 2218151 2218151 defendant Husee Henry   644971 644971 Husee, Henry, of Keynesham 0
4560452 2219210 2219210 defendant Bowode Alexander   644971 644971 Bowode, Alexander, of Keynesham 3
4582172 2225862 2225862 defendant Samme John   644971 644971 Samme, John, of Keynesham 1
4728762 2274232 2274232 defendant Knyght Robert sheerman 644971 644971 Knyght, Robert, of Keynesham, sheerman 0
4733319 2275597 2275597 defendant Clyve Thomas   644971 644971 Clyve, Thomas, of Keynesham, abbot of the monastery of the BM 0
4765767 2285289 2285289 defendant Webbe Richard fuller 644971 644971 Webbe, Richard, of Keynesham, fuller 0
4768433 2286099 2286099 defendant Uphill Thomas husbandman 644971 644971 Uphill, Thomas, of Keynesham, husbandman 0
4768435 2286100 2286100 defendant Uphill Thomas husbandman 644971 644971 Uphill, Thomas, of Keynesham, husbandman 0
4776596 2288672 2288672 defendant Datebon Henry husbandman 644971 644971 Datebon, Henry, of Keynesham, husbandman 0
4785779 2291590 2291590 plaintiff Filipot John   644971 644971 Filipot, John, of Keynesham 0
4793028 2293910 2293910 defendant Milward Richard   644971 644971 Milward, Richard, of Keynesham, millward 0
4812132 2299906 2299906 plaintiff Grender William tailor 644971 644971 Grender, William, of Keynesham, tailor, on his own account 0
4844305 2309727 2309727 defendant Chewe William butcher 644971 644971 Chewe, William, of Keynesham, butcher 0
4844306 2309727 2309727 defendant Herfewe Thomas brewer 644971 644971 Herfewe, Thomas, of Keynesham, brewer 1
4862026 2315137 2315137 defendant Payntour Robert woolmonger 644971 644971 Payntour, Robert, of Keynesham, or of Bristol, woolmonger 0
4912813 2330504 2330504 defendant Clerk John brewer 644971 644971 Clerk, John, of Keynesham, brewer 0
4922610 2333484 2333484 defendant Frensshe John mercer 644971 644971 Frensshe, John, of Keynesham, mercer 1
4922631 2333488 2333488 defendant Frensshe John mercer 644971 644971 Frensshe, John, of Keynesham, mercer 1
5038210 2368063 2368063 defendant Ryall John cordwainer 644971 644971 Ryall, John, of Keynesham, cordwainer 4
5054386 2372889 2372889 defendant Blaket alias Blakhed James chaplain 644971 644971 Blaket alias Blakhed, James, of Keynesham, chaplain 0
5054387 2372889 2372889 defendant West John, senior brewer 644971 644971 West, John, senior, of Keynesham, brewer 1
5054390 2372890 2372890 defendant Blaket James chaplain 644971 644971 Blaket, James, of Keynesham, clerk, chaplain 0
5054391 2372890 2372890 defendant West John, senior brewer 644971 644971 West, John, senior, of Keynesham, brewer 1
5054574 2372941 2372941 defendant Lloide Thomas tailor 644971 644971 Lloide, Thomas, of Keynesham, tailor 0
5141191 2398547 2398547 plaintiff Tyler Thomas   644971 644971 Tyler, Thomas, of Keynesham, abbot of the church of BM 0
5227910 2423778 2423778 defendant Nele John brewer 644971 644971 Nele, John, of Keynesham, brewer 0
5227911 2423778 2423778 defendant Knyfe Thomas brewer 644971 644971 Knyfe, Thomas, of Keynesham, brewer 1
5295426 2443654 2443654 defendant Harbowe or Harvowe Thomas, junior brewer 644971 644971 Harbowe or Harvowe, Thomas, junior, of Keynesham, brewer 0
5312717 2448841 2448841 defendant Wroxhale John tailor 644971 644971 Wroxhale, John, of Keynesham, tailor 0
5314340 2449308 2449308 defendant Hurne Thomas tucker 644971 644971 Hurne, Thomas, of Keynesham, tucker 0
5326679 2453049 2453049 defendant Mody Thomas clothier 644971 644971 Mody, Thomas, of Keynesham, clothier 0
5374769 2467702 2467702 defendant Nelee Thomas smith 644971 644971 Nelee, Thomas, of Keynesham, smith 1
5423296 2481928 2481928 defendant Batte John clerk & vicar 644971 644971 Batte, John, of Keynesham, clerk & vicar 0
5499468 2504784 2504784 defendant Nele John smith 644971 644971 Nele, John, of Keynesham, smith 1
5574971 2527252 2527252 defendant Arnold Elizabeth widow 644971 644971 Arnold, Elizabeth, of Keynesham, widow 0
5605054 2536451 2536451 defendant Panter William yeoman 644971 644971 Panter, William, of Keynesham, yeoman 3

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