names

60 rows where place_id = 612445

✎ 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
3693284 1924109 1924109 defendant Pylsty Richard yeoman 612445 612445 Pylsty, Richard, of Southover, yeoman 0
3722436 1933277 1933277 defendant Manyng John laborer 612445 612445 Manyng, John, of Southover, laborer 1
3722437 1933277 1933277 defendant Wacombe John laborer 612445 612445 Wacombe, John, of Southover, laborer 2
3722438 1933277 1933277 defendant James John laborer 612445 612445 James, John, of Southover, laborer 3
3895668 1988754 1988754 plaintiff Stempe John, junior   612445 612445 Stempe, John, junior, of Southover 0
3980670 2017850 2017850 defendant Hersey John husbandman 612445 612445 Hersey, John, of Southover, husbandman 1
3994510 2022785 2022785 defendant Martyn Robert gent 612445 612445 Martyn, Robert, of Southover, or of Southon, Tolpendell, gent 0
4019425 2031680 2031680 defendant Martyn Robert gent 612445 612445 Martyn, Robert, of Southover, or of Tolpudel, gent 0
4059814 2045904 2045904 defendant Peverell John   612445 612445 Peverell, John, of Southover, clerk, parson of Telscombe 0
4107042 2062815 2062815 defendant Hersey John, senior yeoman 612445 612445 Hersey, John, senior, of Southover, yeoman 1
4133723 2072394 2072394 defendant Stanes Robert weaver 612445 612445 Stanes, Robert, of Southover, weaver 3
4133726 2072395 2072395 defendant Tummeroll John painter 612445 612445 Tummeroll, John, of Southover, painter 1
4134378 2072625 2072625 defendant Frauncys William miller 612445 612445 (Frauncys, William, of Southover, miller 1
4158356 2080994 2080994 defendant Frauncys William miller 612445 612445 (Frauncys, William, of Southover, miller 1
4160784 2081849 2081849 defendant Segrove Thomas husbandman 612445 612445 Segrove, Thomas, of Southover, husbandman 1
4166616 2083821 2083821 defendant Dennys Robert yeoman 612445 612445 Dennys, Robert, of Southover, yeoman 0
4169728 2084901 2084901 defendant Fawkener John miller 612445 612445 Fawkener, John, of Southover, miller 2
4170179 2085067 2085067 defendant Myller John bricklayer 612445 612445 Myller, John, of Southover, bricklayer 0
4176597 2087290 2087290 defendant Lyes John yeoman 612445 612445 Lyes, John, of Southover, yeoman 1
4177534 2087620 2087620 defendant Hersey John yeoman 612445 612445 Hersey, John, of Southover, yeoman 1
4178300 2087881 2087881 defendant Corneford Hugh yeoman 612445 612445 Corneford, Hugh, of Southover, yeoman 0
4180807 2088765 2088765 defendant Edwardes John joiner 612445 612445 Edwardes, John, of Southover, joiner 2
4180808 2088765 2088765 defendant Bassocke Thomas pointer 612445 612445 Bassocke, Thomas, of Southover, pointer 3
4181033 2088841 2088841 defendant Hersey John   612445 612445 Hersey, John, of Southover, stone heaver 2
4181618 2089056 2089056 defendant Stanes Thomas   612445 612445 Stanes, Thomas, of Southover, sailor 2
4184255 2089991 2089991 defendant Segrove Thomas husbandman 612445 612445 Segrove, Thomas, of Southover, husbandman 1
4186143 2090642 2090642 defendant Fawkener John miller 612445 612445 Fawkener, John, of Southover, miller 0
4186176 2090649 2090649 defendant Lorence Robert yeoman 612445 612445 Lorence, Robert, of Southover, yeoman 1
4223644 2103757 2103757 defendant Bassocke Thomas husbandman 612445 612445 Bassocke, Thomas, of Southover, husbandman 0
4323616 2138315 2138315 defendant Fynche Anthony gent 612445 612445 Fynche, Anthony, of Southover, gent 0
4361098 2151135 2151135 defendant Crompe John, junior   612445 612445 Crompe, John, junior, of Southover, miller, "loacher" 3
4590710 2228447 2228447 defendant Theccher John   612445 612445 Theccher, John, of Southover 2
4692130 2263068 2263068 defendant Otwey John yeoman 612445 612445 Otwey, John, of Southover, yeoman 0
4983236 2351889 2351889 defendant Staynour Simon stainer 612445 612445 Staynour, Simon, of Southover, stainer 2
5181381 2410298 2410298 defendant Crosby William (legal representative) 612445 612445 Crosby, William, of Southover, tanner, executors of 0
5376582 2468275 2468275 defendant Thatcher John gent 612445 612445 Thatcher, John, of Southover, gent 2
5376587 2468276 2468276 defendant Theocher John gent 612445 612445 (Theocher, John, of Southover, gent 1
5380978 2469616 2469616 defendant Yonge John yeoman 612445 612445 Yonge, John, of Southover, yeoman 2
5385095 2470812 2470812 plaintiff Wyldebore Thomas   612445 612445 Wyldebore, Thomas, of Southover 1
5387134 2471389 2471389 defendant Holybone Richard   612445 612445 Holybone, Richard, of Southover 1
5392761 2472999 2472999 defendant Thetcher John   612445 612445 Thetcher, John, of Southover 0
5392768 2473000 2473000 defendant Theccher John gent 612445 612445 together with Theccher, John, of Southover, gent 2
5405855 2476749 2476749 defendant Thetcher John gent 612445 612445 (Thetcher, John, of Southover, gent 1
5405861 2476750 2476750 defendant Thetcher John gent 612445 612445 Thetcher, John, of Southover, gent 2
5405867 2476751 2476751 defendant Thetcher John gent 612445 612445 Thetcher, John, of Southover, gent 2
5412589 2478709 2478709 defendant Holibone Richard husbandman 612445 612445 Holibone, Richard, of Southover, husbandman 1
5412590 2478709 2478709 defendant Meyr Richard laborer 612445 612445 Meyr, Richard, of Southover, laborer 2
5418893 2480575 2480575 defendant Theccher John gent 612445 612445 togeterh with Theccher, John, of Southover, gent 2
5418898 2480576 2480576 defendant Theccher John gent 612445 612445 (Theccher, John, of Southover, gent 1
5418904 2480577 2480577 defendant Theccher John gent 612445 612445 (Theccher, John, of Southover, gent 1
5421096 2481238 2481238 defendant Bull John carpenter 612445 612445 Bull, John, of Southover, carpenter 7
5421422 2481342 2481342 defendant Berde William barber 612445 612445 Berde, William, of Southover, barber 0
5421424 2481343 2481343 defendant Berde William barber 612445 612445 Berde, William, of Southover, barber 0
5421642 2481410 2481410 plaintiff Adam Thomas   612445 612445 Adam, Thomas, of Southover 0
5421644 2481410 2481410 defendant Broun John yeoman 612445 612445 Broun, John, of Southover, yeoman 1
5441524 2487387 2487387 plaintiff Adam Thomas   612445 612445 Adam, Thomas, of Southover 0
5454309 2491198 2491198 plaintiff Adam Thomas   612445 612445 Adam, Thomas, of Southover 0
5454311 2491198 2491198 defendant Brown John yeoman 612445 612445 Brown, John, of Southover, yeoman 1
5475100 2497540 2497540 defendant Theccher John gent 612445 612445 (Theccher, John, of Southover, gent 1
5486629 2500896 2500896 defendant Theccher John gent 612445 612445 Theccher, John, of Southover, gent 2

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