names

123 rows where place_id = 592523

✎ 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
3607961 1870141 1870141 plaintiff Smyth Henry   592523 592523 Smyth, Henry, of Walpoll 0
3654072 1911536 1911536 plaintiff Alen Thomas (legal representative) 592523 592523 Alen, Thomas, of Walpoll, yeoman, executor of 0
3654074 1911536 1911536 defendant Andrewe John brewer 592523 592523 Andrewe, John, of Walpoll, brewer 0
3725283 1934199 1934199 defendant Smyth John yeoman 592523 592523 Smyth, John, of Walpoll, yeoman 0
3992651 2022120 2022120 plaintiff Butler Maurice yeoman 592523 592523 Butler, Maurice, of Walpoll, yeoman 0
3992652 2022120 2022120 defendant Feane or Phane Roger husbandman 592523 592523 Feane or Phane, Roger, of Walpoll, husbandman 0
4237088 2108553 2108553 defendant Chauntins Robert yeoman 592523 592523 Chauntins, Robert, of Walpoll, yeoman 0
4567183 2221297 2221297 defendant Smyth John   592523 592523 Smyth, John, of Walpoll 0
4567184 2221297 2221297 defendant Chapman Robert   592523 592523 Chapman, Robert, of Walpoll 1
4599700 2231123 2231123 defendant Cook Geoffrey   592523 592523 Cook, Geoffrey, of Walpoll 1
4600223 2231299 2231299 defendant Broun Robert   592523 592523 Broun, Robert, of Walpoll 2
4601741 2231763 2231763 defendant Godefrey John   592523 592523 Godefrey, John, of Walpoll 0
4618181 2236694 2236694 plaintiff Halle Thomas   592523 592523 Halle, Thomas, of Walpoll 0
4644823 2244551 2244551 defendant Millere Henry   592523 592523 Millere, Henry, of Walpoll 4
4646158 2244949 2244949 defendant Mayson Walter   592523 592523 Mayson, Walter, of Walpoll 2
4647539 2245339 2245339 defendant Bulmere John   592523 592523 Bulmere, John, of Walpoll 3
4664020 2250232 2250232 defendant Dewe Richard yeoman 592523 592523 Dewe, Richard, of Walpoll, yeoman 4
4664021 2250232 2250232 defendant Amy Adam yeoman 592523 592523 Amy, Adam, of Walpoll, yeoman 5
4664185 2250287 2250287 plaintiff Halle Thomas   592523 592523 Halle, Thomas, of Walpoll 0
4664186 2250287 2250287 defendant Dod William husbandman 592523 592523 Dod, William, of Walpoll, husbandman 0
4678063 2258749 2258749 defendant Fuller Edmund fuller 592523 592523 Fuller, Edmund, of Walpoll, fuller 0
4698074 2264885 2264885 defendant Reve Adam husbandman 592523 592523 Reve, Adam, of Walpoll, husbandman 0
4699810 2265386 2265386 defendant Dewe Thomas husbandman 592523 592523 Dewe, Thomas, of Walpoll, husbandman 3
4712337 2269173 2269173 defendant Damet Thomas husbandman 592523 592523 Damet, Thomas, of Walpoll, husbandman 0
4714779 2269955 2269955 plaintiff Tunnek John   592523 592523 Tunnek, John, of Walpoll 0
4714780 2269955 2269955 defendant Wyot Adam husbandman 592523 592523 Wyot, Adam, of Walpoll, husbandman 0
4714781 2269955 2269955 defendant Dewe Richard husbandman 592523 592523 Dewe, Richard, of Walpoll, husbandman 1
4727594 2273872 2273872 plaintiff Heyward Thomas   592523 592523 Heyward, Thomas, of Walpoll 0
4727596 2273873 2273873 plaintiff Heyward Thomas   592523 592523 Heyward, Thomas, of Walpoll 0
4730029 2274594 2274594 defendant Cheyles John yeoman 592523 592523 Cheyles, John, of Walpoll, yeoman 0
4730030 2274594 2274594 defendant Halle Thomas yeoman 592523 592523 Halle, Thomas, of Walpoll, yeoman 1
4730034 2274595 2274595 defendant Grigge Robert yeoman 592523 592523 Grigge, Robert, of Walpoll, yeoman 0
4730035 2274595 2274595 defendant Snellyng Margaret widow 592523 592523 Snellyng, Margaret, of Walpoll, widow 1
4730036 2274595 2274595 defendant Perysson John yeoman 592523 592523 Perysson, John, of Walpoll, yeoman 2
4730037 2274595 2274595 defendant Godfreyson John yeoman 592523 592523 Godfreyson, John, of Walpoll, yeoman 3
4737674 2276890 2276890 defendant Fouke Thomas husbandman 592523 592523 Fouke, Thomas, of Walpoll, husbandman 0
4745255 2279121 2279121 defendant Ken Henry yeoman 592523 592523 Ken, Henry, of Walpoll, yeoman 0
4745256 2279121 2279121 defendant Ken John yeoman 592523 592523 Ken, John, of Walpoll, yeoman 1
4773553 2287699 2287699 defendant Creyk John husbandman 592523 592523 Creyk, John, of Walpoll, husbandman 1
4773665 2287736 2287736 defendant Mullere Henry husbandman 592523 592523 Mullere, Henry, of Walpoll, husbandman 1
4773666 2287736 2287736 defendant Cok John husbandman 592523 592523 Cok, John, of Walpoll, husbandman 2
4798287 2295653 2295653 defendant Osteler Roger yeoman 592523 592523 Osteler, Roger, of Walpoll, yeoman 1
4800086 2296207 2296207 defendant Mabbesson Robert husbandman 592523 592523 Mabbesson, Robert, of Walpoll, husbandman 4
4800087 2296207 2296207 defendant Tomson William husbandman 592523 592523 Tomson, William, of Walpoll, husbandman 5
4807152 2298436 2298436 defendant Brook John husbandman 592523 592523 Brook, John, of Walpoll, husbandman 4
4843377 2309444 2309444 defendant Bulwere William husbandman 592523 592523 Bulwere, William, of Walpoll, husbandman 0
4874971 2319119 2319119 defendant Mayesson Walter husbandman 592523 592523 Mayesson, Walter, of Walpoll, husbandman 2
4962530 2345695 2345695 defendant Pepyr Geoffrey husbandman 592523 592523 Pepyr, Geoffrey, of Walpoll, husbandman 4
4962819 2345791 2345791 defendant Reve Richard husbandman 592523 592523 Reve, Richard, of Walpoll, husbandman 2
4970087 2348004 2348004 defendant Busshe Alan husbandman 592523 592523 Busshe, Alan, of Walpoll, husbandman 0
4988352 2353486 2353486 plaintiff Bowr Peter   592523 592523 Bowr, Peter, of Walpoll, vicar 0
4989032 2353657 2353657 defendant Raulyn John husbandman 592523 592523 Raulyn, John, of Walpoll, husbandman 2
4989033 2353657 2353657 defendant Barbour Richard barber 592523 592523 Barbour, Richard, of Walpoll, barber 3
4990537 2354076 2354076 defendant Caly John yeoman 592523 592523 Caly, John, of Walpoll, yeoman 1
4991119 2354234 2354234 defendant Hall Thomas ostler 592523 592523 Hall, Thomas, of Walpoll, ostler 0
4995846 2355604 2355604 plaintiff Froste Peter chaplain 592523 592523 Froste, Peter, of Walpoll, chaplain 2
4995847 2355604 2355604 plaintiff Geyton Ralph   592523 592523 Geyton, Ralph, of Walpoll 3
4995848 2355604 2355604 defendant Caly John husbandman 592523 592523 Caly, John, of Walpoll, husbandman 0
4995850 2355605 2355605 plaintiff Boure Peter   592523 592523 (Boure, Peter, of Walpoll, chaplain, formerly vicar 1
4995851 2355605 2355605 plaintiff Froste Peter chaplain 592523 592523 Froste, Peter, of Walpoll, chaplain 2
4995852 2355605 2355605 plaintiff Geyton Ralph   592523 592523 Geyton, Ralph, of Walpoll 3
4995853 2355605 2355605 defendant Caly John husbandman 592523 592523 Caly, John, of Walpoll, husbandman 0
5005878 2358620 2358620 defendant Kyng John chapman 592523 592523 Kyng, John, of Walpoll, chapman 2
5027658 2364966 2364966 defendant Thormer John tailor 592523 592523 Thormer, John, of Walpoll, tailor 0
5035378 2367206 2367206 plaintiff Thomson William   592523 592523 Thomson, William, of Walpoll 0
5062005 2375191 2375191 defendant Brame or Braine John sawyer 592523 592523 Brame or Braine, John, of Walpoll, sawyer 0
5064341 2375881 2375881 plaintiff Lane Thomas yeoman 592523 592523 Lane, Thomas, of Walpoll, yeoman 0
5069605 2377407 2377407 plaintiff Miller John   592523 592523 Miller, John, of Walpoll 1
5069606 2377407 2377407 defendant Smyth Thomas husbandman 592523 592523 Smyth, Thomas, of Walpoll, husbandman 0
5069607 2377407 2377407 defendant Barton Thomas husbandman 592523 592523 Barton, Thomas, of Walpoll, husbandman 1
5073599 2378586 2378586 defendant Ferthyng Richard husbandman 592523 592523 Ferthyng, Richard, of Walpoll, husbandman 0
5076426 2379449 2379449 defendant Reve Adam husbandman 592523 592523 Reve, Adam, of Walpoll, husbandman 0
5101365 2386811 2386811 defendant Reve Adam husbandman 592523 592523 Reve, Adam, of Walpoll, husbandman 0
5101366 2386811 2386811 defendant Kenell or Kevell John husbandman 592523 592523 Kenell or Kevell, John, of Walpoll, husbandman 1
5106757 2388402 2388402 defendant Bulwer John husbandman 592523 592523 Bulwer, John, of Walpoll, husbandman 1
5111063 2389624 2389624 defendant Kenetor Kenell John yeoman 592523 592523 Kenetor Kenell, John, of Walpoll, yeoman 2
5121062 2392589 2392589 defendant Tassh William husbandman 592523 592523 Tassh, William, of Walpoll, husbandman 0
5121786 2392804 2392804 plaintiff Tomson William   592523 592523 Tomson, William, of Walpoll 0
5121788 2392805 2392805 plaintiff Tomson William (legal representative) 592523 592523 Tomson, William, of Walpoll, executor of 0
5121789 2392805 2392805 plaintiff Tomson Peter   592523 592523 Tomson, Peter, of Walpoll 1
5176715 2408874 2408874 defendant Kene Richard husbandman 592523 592523 Kene, Richard, of Walpoll, husbandman 0
5213261 2419613 2419613 defendant Wright John husbandman 592523 592523 Wright, John, of Walpoll, husbandman 0
5213262 2419613 2419613 defendant Neuhous Thomas husbandman 592523 592523 Neuhous, Thomas, of Walpoll, husbandman 1
5213264 2419613 2419613 defendant Chamberleyn Robert husbandman 592523 592523 (Chamberleyn, Robert, of Walpoll, husbandman 3
5220764 2421763 2421763 defendant Matheye William husbandman 592523 592523 Matheye, William, of Walpoll, husbandman 0
5229990 2424385 2424385 plaintiff Talyour John   592523 592523 Talyour, John, of Walpoll 3
5236743 2426331 2426331 defendant Felyp John husbandman 592523 592523 Felyp, John, of Walpoll, husbandman 0
5250477 2430255 2430255 defendant Genne John (legal representative) 592523 592523 Genne, John, of Walpoll, husbandman, executors of 1
5255352 2431789 2431789 defendant Lane Thomas, senior yeoman 592523 592523 Lane, Thomas, senior, of Walpoll, yeoman 0
5275316 2437853 2437853 defendant Calnysberd Richard husbandman 592523 592523 Calnysberd, Richard, of Walpoll, husbandman 0
5275318 2437854 2437854 defendant Calmsberd Richard husbandman 592523 592523 Calmsberd, Richard, of Walpoll, husbandman 0
5284006 2440346 2440346 defendant Lane William husbandman 592523 592523 Lane, William, of Walpoll, husbandman 2
5284007 2440346 2440346 defendant Kynne Richard husbandman 592523 592523 Kynne, Richard, of Walpoll, husbandman 3
5284008 2440346 2440346 defendant Bekyr Thomas husbandman 592523 592523 Bekyr, Thomas, of Walpoll, husbandman 4
5292179 2442708 2442708 defendant Mey William husbandman 592523 592523 Mey, William, of Walpoll, husbandman 1
5292180 2442708 2442708 defendant Ferlyng William husbandman 592523 592523 Ferlyng, William, of Walpoll, husbandman 2
5295775 2443759 2443759 defendant Rokby Richard butcher 592523 592523 Rokby, Richard, of Walpoll, butcher 0
5295776 2443759 2443759 defendant Blomfeld Stephen smith 592523 592523 Blomfeld, Stephen, of Walpoll, smith 1
5295777 2443759 2443759 defendant Thormer John laborer 592523 592523 Thormer, John, of Walpoll, laborer 2
5295778 2443759 2443759 defendant Mey Adam laborer 592523 592523 Mey, Adam, of Walpoll, laborer 3

Next page

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