names

51 rows where place_id = 596391

✎ 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
3624535 1875211 1875211 defendant Costantyne Robert husbandman 596391 596391 Costantyne, Robert, of geywode, husbandman 0
3664571 1914873 1914873 defendant Fysshm Adam tanner 596391 596391 Fysshm, Adam, of Geywode, tanner 0
3692956 1923997 1923997 defendant Holden Simon yeoman 596391 596391 Holden, Simon, of Geywode, yeoman 0
4616661 2236213 2236213 defendant Trouthe Geoffrey   596391 596391 Trouthe, Geoffrey, of Geywode 0
4646156 2244949 2244949 defendant Malyns Thomas   596391 596391 Malyns, Thomas, of Geywode 0
4677027 2258432 2258432 defendant Wayte John husbandman 596391 596391 Wayte, John, of Geywode, husbandman 2
4677035 2258433 2258433 defendant Wayte John husbandman 596391 596391 Wayte, John, of Geywode, husbandman 2
4683632 2260482 2260482 defendant Catton John   596391 596391 Catton, John, of Geywode, notary 3
4727400 2273816 2273816 defendant Raulyn Geoffrey weaver 596391 596391 Raulyn, Geoffrey, of Geywode, weaver 3
4727401 2273816 2273816 defendant Burmond William yeoman 596391 596391 Burmond, William, of Geywode, yeoman 4
4736730 2276615 2276615 defendant Clerk John husbandman 596391 596391 Clerk, John, of Geywode, husbandman 1
4736733 2276616 2276616 defendant Clerk John husbandman 596391 596391 Clerk, John, of Geywode, husbandman 1
4763918 2284708 2284708 defendant Clerk John yeoman 596391 596391 Clerk, John, of Geywode, yeoman 1
4763919 2284708 2284708 defendant Miller Robert husbandman 596391 596391 Miller, Robert, of Geywode, husbandman 2
4772675 2287425 2287425 defendant Malyns Thomas husbandman 596391 596391 Malyns, Thomas, of Geywode, husbandman 0
4812358 2299977 2299977 defendant Joce John slater 596391 596391 Joce, John, of Geywode, slater 5
4850316 2311555 2311555 defendant Weston Richard yeoman 596391 596391 Weston, Richard, of Geywode, yeoman 0
4875994 2319452 2319452 defendant Bernard Thomas yeoman 596391 596391 Bernard, Thomas, of Geywode, yeoman 2
4880412 2320782 2320782 defendant Madour William fuller 596391 596391 Madour, William, of Geywode, fuller 0
4882311 2321378 2321378 plaintiff Bernard Thomas   596391 596391 Bernard, Thomas, of Geywode 0
4924499 2334101 2334101 defendant Dowedeney Thomas yeoman 596391 596391 Dowedeney, Thomas, of Geywode, yeoman 0
4924500 2334101 2334101 defendant Stestoon Richard yeoman 596391 596391 Stestoon, Richard, of Geywode, yeoman 1
4929944 2335776 2335776 defendant Bowdy Thomas yeoman 596391 596391 Bowdy, Thomas, of Geywode, yeoman 0
4935868 2337608 2337608 defendant Weston Richard yeoman 596391 596391 Weston, Richard, of Geywode, yeoman 0
4936573 2337821 2337821 defendant Dondeney or Doudeney Thomas husbandman 596391 596391 Dondeney or Doudeney, Thomas, of Geywode, husbandman 0
4936574 2337821 2337821 defendant Madir William husbandman 596391 596391 Madir, William, of Geywode, husbandman 1
4946049 2340750 2340750 defendant Madowere William fuller 596391 596391 Madowere, William, of Geywode, fuller 0
4954096 2343191 2343191 defendant Dowedeney Thomas yeoman 596391 596391 Dowedeney, Thomas, of Geywode, yeoman 1
5100827 2386657 2386657 defendant Kirstede Edmund merchant 596391 596391 Kirstede, Edmund, of Geywode, yeoman, or of Bishops Lenn, merchant 0
5102831 2387245 2387245 defendant Seyver John yeoman 596391 596391 Seyver, John, of Geywode, yeoman 1
5104468 2387734 2387734 defendant Seyver John husbandman 596391 596391 Seyver, John, of Geywode, husbandman 2
5115255 2390888 2390888 defendant Adam Geoffrey clerk 596391 596391 Adam, Geoffrey, of Geywode, clerk 0
5115258 2390888 2390888 defendant Constantyn Thomas gent 596391 596391 Constantyn, Thomas, of Geywode, gent 3
5118634 2391881 2391881 defendant Wayte Katherine   596391 596391 Wayte, Katherine, of Geywode, widow of Wayte, John, of Geywode 1
5179849 2409841 2409841 defendant Seyver John husbandman 596391 596391 Seyver, John, of Geywode, husbandman 0
5179850 2409841 2409841 defendant Mersham John salter 596391 596391 Mersham, John, of Geywode, salter 1
5179853 2409842 2409842 defendant Seyver John husbandman 596391 596391 Seyver, John, of Geywode, husbandman 0
5179854 2409842 2409842 defendant Mersham John salter 596391 596391 Mersham, John, of Geywode, salter 1
5179899 2409858 2409858 defendant Costantyne Thomas gent 596391 596391 Costantyne, Thomas, of Geywode, gent 1
5202088 2416377 2416377 defendant Seyver John husbandman 596391 596391 Seyver, John, of Geywode, husbandman 0
5202089 2416377 2416377 defendant Mersham John salter 596391 596391 Mersham, John, of Geywode, salter 1
5214264 2419904 2419904 defendant Heynes William husbandman 596391 596391 Heynes, William, of Geywode, husbandman 0
5257847 2432576 2432576 defendant Dowedy John husbandman 596391 596391 Dowedy, John, of Geywode, husbandman 0
5519274 2510873 2510873 defendant Constantyn Robert husbandman 596391 596391 Constantyn, Robert, of Geywode, husbandman 3
5538103 2516407 2516407 defendant Foster Richard husbandman 596391 596391 Foster, Richard, of Geywode, husbandman 1
5597854 2534227 2534227 defendant Metton Robert husbandman 596391 596391 Metton, Robert, of Geywode, husbandman 0
5607779 2537340 2537340 defendant Johnson Robert yeoman 596391 596391 Johnson, Robert, of Geywode, yeoman 0
5607780 2537340 2537340 defendant Bray John tanner 596391 596391 Bray, John, of Geywode, tanner 1
5607781 2537340 2537340 defendant White Henry laborer 596391 596391 White, Henry, of Geywode, laborer 2
5607782 2537340 2537340 defendant Blode Henry laborer 596391 596391 Blode, Henry, of Geywode, laborer 3
5607783 2537340 2537340 defendant Wheteley Robert laborer 596391 596391 Wheteley, Robert, of Geywode, laborer 4

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