names

64 rows where place_id = 589724

✎ 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
3598507 1867161 1867161 defendant Darley Thomas husbandman 589724 589724 Darley, Thomas, of Bledlowe, husbandman 0
3600449 1867787 1867787 defendant Darley Thomas husbandman 589724 589724 Darley, Thomas, of Bledlowe, husbandman 1
3600450 1867787 1867787 defendant Darley Thomas, senior husbandman 589724 589724 Darley, Thomas, senior, of Bledlowe, husbandman 2
3600452 1867787 1867787 defendant Darley John husbandman 589724 589724 Darley, John, of Bledlowe, husbandman 4
3606794 1869798 1869798 defendant Derbyn John husbandman 589724 589724 Derbyn, John, of Bledlowe, husbandman 1
3606795 1869798 1869798 defendant Dyrley John husbandman 589724 589724 Dyrley, John, of Bledlowe, husbandman 2
3625632 1875550 1875550 defendant Parker Richard husbandman 589724 589724 Parker, Richard, of Bledlowe, or of Saunderton, husbandman 2
3669349 1916352 1916352 defendant Howse Richard laborer 589724 589724 Howse, Richard, of Bledlowe, laborer 0
3719545 1932377 1932377 defendant Smyth John husbandman 589724 589724 Smyth, John, of Bledlowe, husbandman 2
3719549 1932379 1932379 defendant Smyth John husbandman 589724 589724 Smyth, John, of Bledlowe, husbandman 0
3750282 1942005 1942005 defendant Smyth Lawrence husbandman 589724 589724 (Smyth, Lawrence, of Bledlowe, husbandman 1
3750284 1942005 1942005 defendant Smyth John husbandman 589724 589724 Smyth, John, of Bledlowe, husbandman 3
3765707 1946940 1946940 defendant Smyth Lawrence husbandman 589724 589724 (Smyth, Lawrence, of Bledlowe, husbandman 1
3765709 1946940 1946940 defendant Smyth John husbandman 589724 589724 Smyth, John, of Bledlowe, husbandman 3
3782462 1952257 1952257 defendant Laurence alias Smyth John husbandman 589724 589724 Laurence alias Smyth, John, of Bledlowe, husbandman 0
3788284 1954132 1954132 defendant Johnson John husbandman 589724 589724 Johnson, John, of Bledlowe, husbandman 0
3826918 1966269 1966269 defendant Stevyns John husbandman 589724 589724 Stevyns, John, of Bledlowe, husbandman 1
3836060 1969190 1969190 defendant Stevyns John husbandman 589724 589724 Stevyns, John, of Bledlowe, husbandman 0
3859283 1976597 1976597 defendant Stevyns John, junior husbandman 589724 589724 Stevyns, John, junior, of Bledlowe, husbandman 0
3878473 1983044 1983044 defendant Smyth Lawrence husbandman 589724 589724 Smyth, Lawrence, of Bledlowe, husbandman 2
3881782 1984159 1984159 defendant Fellowe Thomas   589724 589724 Fellowe, Thomas, of Bledlowe, parish clerk 0
3905760 1992203 1992203 defendant Smythe John husbandman 589724 589724 Smythe, John, of Bledlowe, husbandman 0
3973508 2015304 2015304 defendant Fleccher John husbandman 589724 589724 Fleccher, John, of Bledlowe, husbandman 2
4030847 2035697 2035697 plaintiff Este Edward   589724 589724 Este, Edward, of Bledlowe, Bucks gent 0
4231412 2106487 2106487 defendant Francklyn Henry   589724 589724 Francklyn, Henry, of Bledlowe, yeoman, his son 1
4716578 2270504 2270504 defendant Destill John husbandman 589724 589724 Destill, John, of Bledlowe, husbandman 0
4812622 2300064 2300064 defendant Cokeman John husbandman 589724 589724 Cokeman, John, of Bledlowe, husbandman 0
4842877 2309314 2309314 defendant Coltman John husbandman 589724 589724 Coltman, John, of Bledlowe, husbandman 0
4842878 2309314 2309314 defendant Parmenter John husbandman 589724 589724 Parmenter, John, of Bledlowe, husbandman 1
4859712 2314406 2314406 defendant Coltman or Coleman John husbandman 589724 589724 Coltman or Coleman, John, of Bledlowe, husbandman 0
4859713 2314406 2314406 defendant Tryppe William husbandman 589724 589724 Tryppe, William, of Bledlowe, husbandman 1
4871343 2318005 2318005 defendant Spaynell John clerk 589724 589724 Spaynell, John, of Bledlowe, clerk 0
4871344 2318005 2318005 defendant Hychecok William husbandman 589724 589724 Hychecok, William, of Bledlowe, husbandman 1
4972657 2348754 2348754 defendant Semer Henry husbandman 589724 589724 Semer, Henry, of Bledlowe, husbandman 3
5072519 2378267 2378267 defendant Bocher Robert butcher 589724 589724 Bocher, Robert, of Bledlowe, butcher 0
5151926 2401700 2401700 defendant Angewyn William husbandman 589724 589724 Angewyn, William, of Bledlowe, husbandman 0
5151927 2401700 2401700 defendant Broun Thomas husbandman 589724 589724 Broun, Thomas, of Bledlowe, husbandman 1
5169906 2406931 2406931 defendant Angewyn William husbandman 589724 589724 Angewyn, William, of Bledlowe, husbandman 0
5169907 2406931 2406931 defendant Broun Thomas husbandman 589724 589724 Broun, Thomas, of Bledlowe, husbandman 1
5169913 2406931 2406931 defendant Wever Thomas weaver 589724 589724 Wever, Thomas, of Bledlowe, weaver 7
5187078 2411950 2411950 defendant Angewyn William husbandman 589724 589724 Angewyn, William, of Bledlowe, husbandman 0
5187079 2411950 2411950 defendant Broun Thomas husbandman 589724 589724 Broun, Thomas, of Bledlowe, husbandman 1
5205468 2417352 2417352 defendant Broun Thomas husbandman 589724 589724 Broun, Thomas, of Bledlowe, husbandman 1
5205473 2417352 2417352 defendant Wever Thomas weaver 589724 589724 Wever, Thomas, of Bledlowe, weaver 6
5226330 2423368 2423368 defendant Parmyter John husbandman 589724 589724 Parmyter, John, of Bledlowe, husbandman 1
5226331 2423368 2423368 defendant Smyth William husbandman 589724 589724 Smyth, William, of Bledlowe, husbandman 2
5226332 2423368 2423368 defendant Edmond William husbandman 589724 589724 Edmond, William, of Bledlowe, husbandman 3
5240948 2427556 2427556 defendant Trype John husbandman 589724 589724 Trype, John, of Bledlowe, husbandman 1
5258628 2432820 2432820 defendant Emond William husbandman 589724 589724 Emond, William, of Bledlowe, husbandman 0
5424104 2482169 2482169 defendant Brien Richard gent 589724 589724 Brien, Richard, of Bledlowe, gent 0
5424108 2482171 2482171 defendant Bryan Richard gent 589724 589724 Bryan, Richard, of Bledlowe, gent 0
5443087 2487841 2487841 defendant Brian Richard gent 589724 589724 Brian, Richard, of Bledlowe, gent 0
5443099 2487847 2487847 defendant Brian Richard gent 589724 589724 Brian, Richard, of Bledlowe, gent 0
5455792 2491633 2491633 defendant Bryan Richard gent 589724 589724 Bryan, Richard, of Bledlowe, gent 0
5455801 2491637 2491637 defendant Bryan Richard gent 589724 589724 Bryan, Richard, of Bledlowe, gent 0
5455803 2491638 2491638 defendant Bryan Richard gent 589724 589724 Bryan, Richard, of Bledlowe, gent 0
5455805 2491639 2491639 defendant Bryan Richard gent 589724 589724 Bryan, Richard, of Bledlowe, gent 0
5467659 2495256 2495256 defendant Bryan Richard gent 589724 589724 Bryan, Richard, of Bledlowe, gent 0
5482520 2499714 2499714 defendant Vachell Margaret widow 589724 589724 Vachell, Margaret, of Bledlowe, widow 0
5482521 2499714 2499714 defendant Pierson John husbandman 589724 589724 Pierson, John, of Bledlowe, husbandman 1
5491106 2502236 2502236 defendant Humfrey Thomas husbandman 589724 589724 Humfrey, Thomas, of Bledlowe, husbandman 0
5492493 2502668 2502668 plaintiff Costard William   589724 589724 Costard, William, of Bledlowe 0
5497317 2504135 2504135 defendant Pierson John husbandman 589724 589724 Pierson, John, of Bledlowe, husbandman 1
5534647 2515378 2515378 defendant Witney Thomas yeoman 589724 589724 Witney, Thomas, of Bledlowe, yeoman 1

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