names

102 rows where place_id = 591343

✎ 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
3593527 1865608 1865608 defendant Pynner alias Rogers John mercer 591343 591343 Pynner alias Rogers, John, of Chepyng Norton, Oxon, yeoman, or of Bristol, mercer 0
3604129 1868957 1868957 defendant Halyn John butcher 591343 591343 Halyn, John, of Chepyng Norton, Oxon, butcher 0
3614193 1872106 1872106 defendant Pynner alias Rogers John merchant 591343 591343 Pynner alias Rogers, John, of Chepyng Norton, Oxon, merchant 0
3614195 1872107 1872107 defendant Pynner alias Rogers John merchant 591343 591343 Pynner alias Rogers, John, of Chepyng Norton, Oxon, merchant 0
3631144 1904563 1904563 defendant Rodney John   591343 591343 Rodney, John, of Chepyng Norton, Oxon, knight 0
3641047 1907640 1907640 defendant Mytton Griggin gent 591343 591343 Mytton, Griggin, of Chepyng Norton, Oxon, gent 0
3654527 1911677 1911677 defendant Croft Hugh esq 591343 591343 Croft, Hugh, of Chepyng Norton, Oxon, esq 0
3654761 1911746 1911746 defendant Taillour Henry tailor 591343 591343 Taillour, Henry, of Chepyng Norton, Oxon, tailor 1
3668707 1916148 1916148 defendant Crofte Hugh esq 591343 591343 Crofte, Hugh, of Chepyng Norton, Oxon, esq 0
3668827 1916186 1916186 defendant Crofte Hugh esq 591343 591343 Crofte, Hugh, of Chepyng Norton, Oxon, esq 0
3677889 1919138 1919138 defendant Croft Hugh esq 591343 591343 Croft, Hugh, of Chepyng Norton, Oxon, esq 0
3683822 1921076 1921076 defendant Rodney Walter   591343 591343 Rodney, Walter, of Chepyng Norton, Oxon, knight 1
3687260 1922195 1922195 defendant Tanner John innholder 591343 591343 Tanner, John, of Chepyng Norton, Oxon, innholder 0
3708043 1928816 1928816 defendant Busby Robert husbandman 591343 591343 Busby, Robert, of Chepyng Norton, Oxon, husbandman 0
3728718 1935224 1935224 defendant Kynge Richard yeoman 591343 591343 Kynge, Richard, of Chepyng Norton, Oxon, yeoman 0
3728724 1935225 1935225 defendant Mane Richard   591343 591343 Mane, Richard, of Chepyng Norton, Oxon, yeoman, churchwarden 0
3735725 1937410 1937410 defendant Bolter William husbandman 591343 591343 Bolter, William, of Chepyng Norton, Oxon, husbandman 1
3736248 1937577 1937577 defendant Grene Richard innholder 591343 591343 Grene, Richard, of Chepyng Norton, Oxon, innholder 0
3738368 1938213 1938213 defendant Bussby Robert yeoman 591343 591343 Bussby, Robert, of Chepyng Norton, Oxon, yeoman 1
3738374 1938214 1938214 defendant Bussby Robert yeoman 591343 591343 Bussby, Robert, of Chepyng Norton, Oxon, yeoman 1
3738379 1938215 1938215 defendant Bussby Robert yeoman 591343 591343 Bussby, Robert, of Chepyng Norton, Oxon, yeoman 0
3738381 1938216 1938216 defendant Swyft Thomas yeoman 591343 591343 Swyft, Thomas, of Chepyng Norton, Oxon, yeoman 0
3745903 1940624 1940624 defendant Monke alias Bowyer John chapman 591343 591343 Monke alias Bowyer, John, of Chepyng Norton, Oxon, chapman 2
3774713 1949822 1949822 defendant Barnes William sawyer 591343 591343 Barnes, William, of Chepyng Norton, Oxon, sawyer 1
3778053 1950850 1950850 defendant Grene Richard chapman 591343 591343 Grene, Richard, of Chepyng Norton, Oxon, chapman 1
3778535 1951003 1951003 defendant Barnes William sawyer 591343 591343 Barnes, William, of Chepyng Norton, Oxon, sawyer 1
3780985 1951784 1951784 defendant Huchyn John yeoman 591343 591343 (Huchyn, John, of Chepyng Norton, Oxon, yeoman 1
3791827 1955290 1955290 defendant Grene Richard innholder 591343 591343 Grene, Richard, of Chepyng Norton, Oxon, innholder 3
3801310 1958337 1958337 defendant Busby Robert husbandman 591343 591343 Busby, Robert, of Chepyng Norton, Oxon, husbandman 0
3803699 1959072 1959072 defendant Crofte Hugh esq 591343 591343 Crofte, Hugh, of Chepyng Norton, Oxon, esq 0
3803703 1959073 1959073 defendant Crofte Hugh esq 591343 591343 Crofte, Hugh, of Chepyng Norton, Oxon, esq 0
3810915 1961314 1961314 plaintiff Busby Robert yeoman 591343 591343 Busby, Robert, of Chepyng Norton, Oxon, yeoman 0
3861593 1977337 1977337 defendant Busby Robert yeoman 591343 591343 Busby, Robert, of Chepyng Norton, Oxon, yeoman 2
3885711 1985476 1985476 defendant Barnes William mercer 591343 591343 Barnes, William, of Chepyng Norton, Oxon, mercer 2
3885715 1985477 1985477 defendant Barnes William mercer 591343 591343 Barnes, William, of Chepyng Norton, Oxon, mercer 2
3907416 1992772 1992772 defendant Pargetour Thomas yeoman 591343 591343 Pargetour, Thomas, of Chepyng Norton, Oxon, yeoman 0
3907419 1992773 1992773 defendant Pargetour alias Smyth Thomas yeoman 591343 591343 Pargetour alias Smyth, Thomas, of Chepyng Norton, Oxon, yeoman 0
3934854 2001959 2001959 defendant Heythcoke John   591343 591343 Heythcoke, John, of Chepyng Norton, Oxon, shoe maker 2
3945814 2005611 2005611 defendant Pattrike William yeoman 591343 591343 Pattrike, William, of Chepyng Norton, Oxon, yeoman 0
3962683 2011532 2011532 defendant Hardynge William yeoman 591343 591343 Hardynge, William, of Chepyng Norton, Oxon, yeoman 0
3988859 2020761 2020761 defendant Hunt Richard ironmonger 591343 591343 Hunt, Richard, of Chepyng Norton, Oxon, ironmonger 0
4018817 2031462 2031462 plaintiff Walford Edward yeoman 591343 591343 Walford, Edward, of Chepyng Norton, Oxon, yeoman 0
4045472 2040833 2040833 defendant Hunt Richard chapman 591343 591343 Hunt, Richard, of Chepyng Norton, Oxon, chapman 0
4047674 2041616 2041616 defendant Dyxson John mercer 591343 591343 Dyxson, John, of Chepyng Norton, Oxon, mercer 0
4059313 2045725 2045725 defendant Cornyshe Richard glover 591343 591343 Cornyshe, Richard, of Chepyng Norton, Oxon, glover 1
4667407 2255527 2255527 defendant Pref William yeoman 591343 591343 Pref, William, of Chepyng Norton, Oxon, yeoman 0
4752302 2281133 2281133 defendant Pruffe William yeoman 591343 591343 Pruffe, William, of Chepyng Norton, Oxon, yeoman 0
4778895 2289374 2289374 defendant Chapman John butcher 591343 591343 Chapman, John, of Chepyng Norton, Oxon, butcher 0
4797553 2295404 2295404 defendant Prof William yeoman 591343 591343 Prof, William, of Chepyng Norton, Oxon, yeoman 0
4812768 2300108 2300108 defendant Stratford Robert gent 591343 591343 Stratford, Robert, of Chepyng Norton, Oxon, gent 1
4861243 2314883 2314883 defendant Crewe Geoffrey gent 591343 591343 Crewe, Geoffrey, of Chepyng Norton, Oxon, gent 0
4912647 2330459 2330459 defendant Skarlet John spicer 591343 591343 Skarlet, John, of Chepyng Norton, Oxon, spicer 0
4917844 2332093 2332093 defendant Balle John husbandman 591343 591343 Balle, John, of Chepyng Norton, Oxon, husbandman 3
4917850 2332094 2332094 defendant Balle John, senior husbandman 591343 591343 Balle, John, senior, of Chepyng Norton, Oxon, husbandman 3
4924886 2334214 2334214 defendant Scarlet John chapman 591343 591343 Scarlet, John, of Chepyng Norton, Oxon, chapman 2
4924891 2334215 2334215 defendant Scarlet John chapman 591343 591343 Scarlet, John, of Chepyng Norton, Oxon, chapman 2
4934773 2337273 2337273 plaintiff Balle John   591343 591343 Balle, John, of Chepyng Norton, Oxon 0
4962051 2345558 2345558 defendant Scarlet John chapman 591343 591343 Scarlet, John, of Chepyng Norton, Oxon, chapman 0
4985337 2352533 2352533 defendant Aylton William chapman 591343 591343 Aylton, William, of Chepyng Norton, Oxon, chapman 0
5016947 2361851 2361851 defendant Grenehill William yeoman 591343 591343 Grenehill, William, of Chepyng Norton, Oxon, yeoman 0
5025773 2364435 2364435 defendant Yonge John chapman 591343 591343 Yonge, John, of Chepyng Norton, Oxon, chapman 0
5044597 2370017 2370017 defendant Crwe Geoffrey gent 591343 591343 Crwe, Geoffrey, of Chepyng Norton, Oxon, gent 0
5061703 2375095 2375095 defendant Barbour alias Smyth John grocer 591343 591343 Barbour alias Smyth, John, of Chepyng Norton, Oxon, grocer 0
5090546 2383619 2383619 defendant Barbour John chapman 591343 591343 Barbour, John, of Chepyng Norton, Oxon, chapman 0
5091942 2384023 2384023 defendant Barbour John chapman 591343 591343 Barbour, John, of Chepyng Norton, Oxon, chapman 0
5102727 2387210 2387210 defendant Reynold Robert weaver 591343 591343 Reynold, Robert, of Chepyng Norton, Oxon, weaver 0
5122467 2392997 2392997 defendant Pynnok John, junior chapman 591343 591343 Pynnok, John, junior, of Chepyng Norton, Oxon, chapman 1
5219448 2421414 2421414 defendant Barbour John ostler 591343 591343 Barbour, John, of Chepyng Norton, Oxon, ostler 2
5233981 2425528 2425528 defendant Knyght William chapman 591343 591343 Knyght, William, of Chepyng Norton, Oxon, chapman 1
5241201 2427633 2427633 defendant Stokes Robert merchant 591343 591343 Stokes, Robert, of Chepyng Norton, Oxon, merchant 0
5243281 2428236 2428236 defendant Grenehill William chapman 591343 591343 Grenehill, William, of Chepyng Norton, Oxon, chapman 1
5267000 2435436 2435436 defendant Coryower alias Warner John, junior yeoman 591343 591343 Coryower alias Warner, John, junior, of Chepyng Norton, Oxon, yeoman 0
5267009 2435439 2435439 defendant Warnerre alias Coryower John, senior yeoman 591343 591343 Warnerre alias Coryower, John, senior, of Chepyng Norton, Oxon, yeoman 0
5276398 2438165 2438165 defendant Hosyer Peter draper 591343 591343 Hosyer, Peter, of Chepyng Norton, Oxon, draper 2
5295933 2443800 2443800 defendant Draper alias Hosyer Peter draper 591343 591343 Draper alias Hosyer, Peter, of Chepyng Norton, Oxon, draper 1
5295936 2443801 2443801 defendant Draper alias Hosyer Peter draper 591343 591343 Draper alias Hosyer, Peter, of Chepyng Norton, Oxon, draper 1
5324369 2452376 2452376 defendant Aleyne John husbandman 591343 591343 Aleyne, John, of Chepyng Norton, Oxon, husbandman 0
5329792 2453985 2453985 defendant Lee John cordwainer 591343 591343 Lee, John, of Chepyng Norton, Oxon, cordwainer 1
5329806 2453986 2453986 defendant Lee John cordwainer 591343 591343 Lee, John, of Chepyng Norton, Oxon, cordwainer 1
5333196 2454997 2454997 defendant Coryour John chapman 591343 591343 Coryour, John, of Chepyng Norton, Oxon, chapman 3
5353651 2461212 2461212 defendant Barbour John chapman 591343 591343 Barbour, John, of Chepyng Norton, Oxon, chapman 2
5353657 2461213 2461213 defendant Barbour John chapman 591343 591343 Barbour, John, of Chepyng Norton, Oxon, chapman 2
5358750 2462797 2462797 defendant Stokes Robert woolman 591343 591343 Stokes, Robert, of Chepyng Norton, Oxon, woolman 1
5360277 2463251 2463251 defendant Alen Thomas butcher 591343 591343 Alen, Thomas, of Chepyng Norton, Oxon, butcher 0
5404707 2476425 2476425 defendant Stokes Robert   591343 591343 Stokes, Robert, of Chepyng Norton, Oxon, wool man 0
5405488 2476651 2476651 defendant Alen John butcher 591343 591343 Alen, John, of Chepyng Norton, Oxon, butcher 2
5418541 2480473 2480473 defendant Alen John butcher 591343 591343 Alen, John, of Chepyng Norton, Oxon, butcher 2
5418548 2480474 2480474 defendant Alen John butcher 591343 591343 Alen, John, of Chepyng Norton, Oxon, butcher 2
5454525 2491269 2491269 defendant Partryche William yeoman 591343 591343 Partryche, William, of Chepyng Norton, Oxon, yeoman 0
5461571 2493400 2493400 defendant Seward John yeoman 591343 591343 Seward, John, of Chepyng Norton, Oxon, yeoman 0
5466779 2495013 2495013 defendant Partryche William yeoman 591343 591343 Partryche, William, of Chepyng Norton, Oxon, yeoman 0
5497356 2504147 2504147 defendant Barbour John chapman 591343 591343 Barbour, John, of Chepyng Norton, Oxon, chapman 3
5517496 2510313 2510313 defendant Knyght William chapman 591343 591343 Knyght, William, of Chepyng Norton, Oxon, chapman 0
5517500 2510314 2510314 defendant Knyght William chapman 591343 591343 Knyght, William, of Chepyng Norton, Oxon, chapman 0
5550029 2520046 2520046 defendant Croft Hugh   591343 591343 Croft, Hugh, of Chepyng Norton, Oxon, gent, son of Croft, Richard 0
5550034 2520047 2520047 defendant Crofte Hugh   591343 591343 Crofte, Hugh, of Chepyng Norton, Oxon, gent, son of Crofte, Richard 0
5557817 2522239 2522239 defendant Crofte Hugh gent 591343 591343 Crofte, Hugh, of Chepyng Norton, Oxon, gent 3
5559228 2522665 2522665 defendant Aleyn John yeoman 591343 591343 Aleyn, John, of Chepyng Norton, Oxon, yeoman 1
5568089 2525215 2525215 defendant Haryot Adam innholder 591343 591343 Haryot, Adam, of Chepyng Norton, Oxon, innholder 0
5587825 2531208 2531208 defendant Crofte Hugh gent 591343 591343 Crofte, Hugh, of Chepyng Norton, Oxon, gent 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);