names

50 rows where place_id = 588289

✎ 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
3593994 1865760 1865760 defendant Byrde John laborer 588289 588289 Byrde, John, of Exeter St Sativole, laborer 1
3593995 1865760 1865760 defendant Boly John laborer 588289 588289 Boly, John, of Exeter St Sativole, laborer 2
3593996 1865760 1865760 defendant White John laborer 588289 588289 White, John, of Exeter St Sativole, laborer 3
3601476 1868117 1868117 defendant Mileton John gent 588289 588289 Mileton, John, of Exeter St Sativole, gent 0
3604629 1869110 1869110 defendant Longe Henry yeoman 588289 588289 Longe, Henry, of Exeter St Sativole, yeoman 0
3604630 1869110 1869110 defendant Fermour John yeoman 588289 588289 Fermour, John, of Exeter St Sativole, yeoman 1
3605064 1869250 1869250 defendant Myleton John gent 588289 588289 Myleton, John, of Exeter St Sativole, gent 0
3647642 1909648 1909648 defendant Kylly William tucker 588289 588289 Kylly, William, of Exeter St Sativole, tucker 0
3669768 1916490 1916490 defendant Colchard John butcher 588289 588289 Colchard, John, of Exeter St Sativole, butcher 0
3670867 1916854 1916854 defendant Pawlett William yeoman 588289 588289 Pawlett, William, of Exeter St Sativole, yeoman 0
3673177 1917623 1917623 defendant Flemyng Nicholas   588289 588289 Flemyng, Nicholas, of Exeter St Sativole 0
3681780 1920401 1920401 defendant Flemmyng Nicholas gent 588289 588289 Flemmyng, Nicholas, of Exeter St Sativole, gent 0
3691615 1923534 1923534 defendant Hewet John sherman 588289 588289 Hewet, John, of Exeter St Sativole, sherman 0
3697014 1925291 1925291 defendant Flemyng Nicholas gent 588289 588289 Flemyng, Nicholas, of Exeter St Sativole, gent 0
3702182 1926939 1926939 plaintiff Dunpayn Geoffrey   588289 588289 Dunpayn, Geoffrey, of Exeter St Sativole, freemason 1
3741447 1939192 1939192 defendant Worthe Edmund gent 588289 588289 Worthe, Edmund, of Exeter St Sativole, gent 0
3761354 1945561 1945561 defendant Shapton William gent 588289 588289 Shapton, William, of Exeter St Sativole, gent 0
3809378 1960815 1960815 defendant Pomfrett Thomas gent 588289 588289 Pomfrett, Thomas, of Exeter St Sativole, gent 1
3815484 1962757 1962757 defendant Davy John butcher 588289 588289 Davy, John, of Exeter St Sativole, butcher 0
3821451 1964602 1964602 defendant Billyng William   588289 588289 Billyng, William, of Exeter St Sativole, mason 0
3821452 1964602 1964602 defendant Saunder John   588289 588289 Saunder, John, of Exeter St Sativole, mason 1
3822568 1964961 1964961 defendant Luter Henry   588289 588289 Luter, Henry, of Exeter St Sativole, "luter" 1
3823506 1965253 1965253 defendant Clyffe John laborer 588289 588289 Clyffe, John, of Exeter St Sativole, laborer 0
3823507 1965253 1965253 defendant Clyff Margaret spinster 588289 588289 Clyff, Margaret, of Exeter St Sativole, spinster 1
3823508 1965253 1965253 defendant Englond Eleanor widow 588289 588289 Englond, Eleanor, of Exeter St Sativole, widow 2
3823509 1965253 1965253 defendant Englond Joan spinster 588289 588289 Englond, Joan, of Exeter St Sativole, spinster 3
5031187 2366001 2366001 defendant Segour Simon husbandman 588289 588289 Segour, Simon, of Exeter St Sativole, husbandman 2
5033146 2366579 2366579 defendant Broun Robert scrivener 588289 588289 Broun, Robert, of Exeter St Sativole, scrivener 0
5033150 2366579 2366579 defendant Payn Thomas fletcher 588289 588289 Payn, Thomas, of Exeter St Sativole, fletcher 4
5069482 2377370 2377370 defendant Crymell William ostler 588289 588289 Crymell, William, of Exeter St Sativole, ostler 0
5260110 2433284 2433284 defendant Swayne Henry baker 588289 588289 Swayne, Henry, of Exeter St Sativole, baker 3
5261154 2433599 2433599 defendant Wolff John laborer 588289 588289 Wolff, John, of Exeter St Sativole, laborer 0
5286497 2441056 2441056 defendant Knyght William gent 588289 588289 Knyght, William, of Exeter St Sativole, gent 0
5315399 2449664 2449664 defendant Horne Hnery weaver 588289 588289 Horne, Hnery, of Exeter St Sativole, weaver 7
5316567 2450040 2450040 defendant Forde Henry laborer 588289 588289 Forde, Henry, of Exeter St Sativole, laborer 2
5316576 2450043 2450043 defendant Pedeler Nicholas brewer 588289 588289 Pedeler, Nicholas, of Exeter St Sativole, brewer 0
5317165 2450216 2450216 defendant Baker William husbandman 588289 588289 Baker, William, of Exeter St Sativole, husbandman 1
5326179 2452924 2452924 defendant Knyght William clerk or gent 588289 588289 Knyght, William, of Exeter St Sativole, clerk or gent 0
5333763 2455171 2455171 defendant Pedeler Nicholas brewer 588289 588289 Pedeler, Nicholas, of Exeter St Sativole, brewer 0
5338606 2456646 2456646 defendant Hyllyng Robert yeoman 588289 588289 Hyllyng, Robert, of Exeter St Sativole, yeoman 0
5353617 2461203 2461203 defendant Lytell William carpenter 588289 588289 Lytell, William, of Exeter St Sativole, carpenter 1
5357061 2462268 2462268 defendant Hillyng Robert yeoman 588289 588289 Hillyng, Robert, of Exeter St Sativole, yeoman 2
5510405 2508095 2508095 defendant Swayn Henry baker 588289 588289 Swayn, Henry, of Exeter St Sativole, baker 0
5525139 2512453 2512453 defendant Mileton John esq 588289 588289 Mileton, John, of Exeter St Sativole, esq 0
5534466 2515325 2515325 defendant Taillour Robert   588289 588289 Taillour, Robert, of Exeter St Sativole, mason 0
5538588 2516550 2516550 defendant Hancok John yeoman 588289 588289 Hancok, John, of Exeter St Sativole, yeoman 0
5579465 2528656 2528656 defendant Tremayne John merchant 588289 588289 Tremayne, John, of Exeter St Sativole, merchant 0
5593886 2533076 2533076 defendant Thorne Roger carrier 588289 588289 Thorne, Roger, of Exeter St Sativole, carrier 2
5598480 2534411 2534411 defendant Worth Edmund gent 588289 588289 Worth, Edmund, of Exeter St Sativole, gent 0
5599431 2534708 2534708 defendant Clyff John tailor 588289 588289 Clyff, John, of Exeter St Sativole, tailor 0

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