names

47 rows where place_id = 594153

✎ 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
3614768 1872268 1872268 defendant Webster alias Howe John husbandman 594153 594153 Webster alias Howe, John, of Blyton, husbandman 1
3625109 1875388 1875388 defendant Balderston John (legal representative) 594153 594153 Balderston, John, of Blyton, husbandman, executors of 0
3779437 1951293 1951293 defendant Ruston John husbandman 594153 594153 Ruston, John, of Blyton, husbandman 0
3779438 1951293 1951293 defendant Blande Thomas husbandman 594153 594153 Blande, Thomas, of Blyton, husbandman 1
4161496 2082095 2082095 defendant Wray Humphrey yeoman 594153 594153 Wray, Humphrey, of Blyton, yeoman 2
4165856 2083556 2083556 defendant Rowghton William chapman 594153 594153 Rowghton, William, of Blyton, chapman 0
4189876 2091959 2091959 defendant Wraye Robert clerk 594153 594153 Wraye, Robert, of Blyton, or of Glentworth, clerk 0
4238878 2109221 2109221 defendant Wharlton Christopher yeoman 594153 594153 Wharlton, Christopher, of Blyton, yeoman 1
4247342 2112088 2112088 defendant Wharlton Christopher yeoman 594153 594153 Wharlton, Christopher, of Blyton, yeoman 1
4359632 2150606 2150606 defendant Devyas John roper 594153 594153 Devyas, John, of Blyton, yeoman, roper 0
4428254 2173668 2173668 defendant Leycestre Roger de   594153 594153 Leycestre, Roger de, of Blyton 1
4660999 2249264 2249264 defendant Draper John husbandman 594153 594153 Draper, John, of Blyton, husbandman 2
4665349 2250650 2250650 defendant Lamkyn William husbandman 594153 594153 Lamkyn, William, of Blyton, husbandman 2
4675244 2257868 2257868 defendant Lamkyn William   594153 594153 Lamkyn, William, of Blyton, groom 2
4676754 2258351 2258351 defendant Stokwyth Thomas   594153 594153 Stokwyth, Thomas, of Blyton, franklin 0
4680117 2259391 2259391 defendant Stokwyth Thomas gent 594153 594153 Stokwyth, Thomas, of Blyton, gent 0
4682517 2260158 2260158 defendant Lamkyn William   594153 594153 Lamkyn, William, of Blyton, bailiff 1
4694696 2263837 2263837 defendant Coke William weaver 594153 594153 Coke, William, of Blyton, weaver 1
4725669 2273315 2273315 defendant Welby William dyer 594153 594153 Welby, William, of Blyton, dyer 1
4727219 2273774 2273774 defendant Everarde William husbandman 594153 594153 Everarde, William, of Blyton, husbandman 0
4736338 2276495 2276495 defendant Lamkyn William yeoman 594153 594153 Lamkyn, William, of Blyton, yeoman 0
4736341 2276496 2276496 defendant Lamkyn William yeoman 594153 594153 Lamkyn, William, of Blyton, yeoman 0
4736344 2276497 2276497 defendant Lamkyn William yeoman 594153 594153 Lamkyn, William, of Blyton, yeoman 0
4750739 2280699 2280699 defendant Carbonell Thomas   594153 594153 Carbonell, Thomas, of Blyton, bailiff 2
4799107 2295897 2295897 defendant Routhe John yeoman 594153 594153 Routhe, John, of Blyton, yeoman 0
4850025 2311475 2311475 defendant Stokewyth Thomas husbandman 594153 594153 Stokewyth, Thomas, of Blyton, husbandman 0
4863507 2315556 2315556 defendant Stokkyth Thomas gent 594153 594153 Stokkyth, Thomas, of Blyton, gent 2
4878074 2320094 2320094 defendant Stokwyth Thomas husbandman 594153 594153 Stokwyth, Thomas, of Blyton, husbandman 0
4914544 2331070 2331070 defendant Raynald Thomas husbandman 594153 594153 Raynald, Thomas, of Blyton, husbandman 0
4932858 2336663 2336663 defendant Reynald Thomas husbandman 594153 594153 Reynald, Thomas, of Blyton, husbandman 0
4940984 2339204 2339204 defendant Reynald Thomas husbandman 594153 594153 Reynald, Thomas, of Blyton, husbandman 2
4940985 2339204 2339204 defendant Watkynson John husbandman 594153 594153 Watkynson, John, of Blyton, husbandman 3
4966790 2346994 2346994 defendant Watkynson John husbandman 594153 594153 Watkynson, John, of Blyton, husbandman 2
4966791 2346994 2346994 defendant Watkynson Nicholas husbandman 594153 594153 Watkynson, Nicholas, of Blyton, husbandman 3
4980238 2351033 2351033 defendant Brantyngham Richard husbandman 594153 594153 Brantyngham, Richard, of Blyton, husbandman 1
4981294 2351327 2351327 defendant Reynald Thomas husbandman 594153 594153 Reynald, Thomas, of Blyton, husbandman 0
5050817 2371866 2371866 defendant Courtenay Robert husbandman 594153 594153 Courtenay, Robert, of Blyton, husbandman 1
5083224 2381480 2381480 defendant Bole John, junior husbandman 594153 594153 Bole, John, junior, of Blyton, husbandman 0
5119755 2392217 2392217 plaintiff Clare Edmund   594153 594153 Clare, Edmund, of Blyton 2
5236299 2426205 2426205 defendant Bole John husbandman 594153 594153 Bole, John, of Blyton, husbandman 1
5363131 2464123 2464123 defendant Crane Richard husbandman 594153 594153 Crane, Richard, of Blyton, husbandman 0
5363132 2464123 2464123 defendant Crane John husbandman 594153 594153 Crane, John, of Blyton, husbandman 1
5363133 2464123 2464123 defendant Reynold William husbandman 594153 594153 Reynold, William, of Blyton, husbandman 2
5363134 2464123 2464123 defendant Baroclogh William weaver 594153 594153 Baroclogh, William, of Blyton, weaver 3
5363135 2464123 2464123 defendant Bland Adam husbandman 594153 594153 Bland, Adam, of Blyton, husbandman 4
5610617 2547046 2547046 defendant atte Lane Thomas   594153 594153 atte Lane, Thomas, of Blyton 0
5610619 2547047 2547047 defendant Lane Thomas atte   594153 594153 Lane, Thomas atte, of Blyton 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);