names

75 rows where place_id = 607216

✎ 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
3668226 1916008 1916008 defendant Bety John, senior husbandman 607216 607216 Bety, John, senior, of Olton, husbandman 1
3675784 1918459 1918459 defendant Askewe Thomas yeoman 607216 607216 Askewe, Thomas, of Olton, yeoman 0
3675785 1918459 1918459 defendant Glover Thomas laborer 607216 607216 Glover, Thomas, of Olton, laborer 1
3675786 1918459 1918459 defendant Pope Thomas laborer 607216 607216 Pope, Thomas, of Olton, laborer 2
3675799 1918464 1918464 defendant Hunton Richard husbandman 607216 607216 Hunton, Richard, of Olton, husbandman 0
3676026 1918539 1918539 defendant Askewe Thomas yeoman 607216 607216 Askewe, Thomas, of Olton, yeoman 0
3676027 1918539 1918539 defendant Glover Thomas laborer 607216 607216 Glover, Thomas, of Olton, laborer 1
3676028 1918539 1918539 defendant Pope Thomas laborer 607216 607216 Pope, Thomas, of Olton, laborer 2
3676072 1918552 1918552 defendant Askewe Thomas yeoman 607216 607216 Askewe, Thomas, of Olton, yeoman 0
3747030 1940988 1940988 defendant More Anthony husbandman 607216 607216 More, Anthony, of Olton, husbandman 2
3747031 1940988 1940988 defendant Dobson Gilbert husbandman 607216 607216 Dobson, Gilbert, of Olton, husbandman 3
3760568 1945305 1945305 defendant Clareborowe John husbandman 607216 607216 Clareborowe, John, of Olton, husbandman 7
3779751 1951401 1951401 defendant Berne John yeoman 607216 607216 Berne, John, of Olton, yeoman 1
3780884 1951755 1951755 defendant Fuller Nicholas (legal representative) 607216 607216 Fuller, Nicholas, of Olton, clerk, administrator of 0
3789542 1954555 1954555 defendant Abettys Roger carpenter 607216 607216 Abettys, Roger, of Olton, carpenter 1
3802500 1958678 1958678 defendant Burne John husbandman 607216 607216 Burne, John, of Olton, husbandman 4
3841088 1970786 1970786 defendant Nycolls John   607216 607216 Nycolls, John, of Olton, worsted weaver 0
3867179 1979260 1979260 plaintiff Rumpe Edward   607216 607216 Rumpe, Edward, of Olton 0
3876157 1982273 1982273 defendant Inglott Henry husbandman 607216 607216 Inglott, Henry, of Olton, husbandman 1
3895225 1988610 1988610 defendant Borne John yeoman 607216 607216 Borne, John, of Olton, yeoman 1
3908406 1993107 1993107 defendant Arteys Augustine husbandman 607216 607216 Arteys, Augustine, of Olton, husbandman 2
4016109 2030458 2030458 plaintiff Starky John esq 607216 607216 Starky, John, of Olton, esq 0
4085687 2055151 2055151 defendant Dobson George, senior yeoman 607216 607216 Dobson, George, senior, of Olton, yeoman 0
4104989 2062059 2062059 defendant Broke John husbandman 607216 607216 Broke, John, of Olton, husbandman 0
4104993 2062060 2062060 defendant Broke John husbandman 607216 607216 Broke, John, of Olton, husbandman 1
4169267 2084754 2084754 defendant Danyell John husbandman 607216 607216 Danyell, John, of Olton, husbandman 0
4170215 2085080 2085080 defendant Hynde Thomas husbandman 607216 607216 Hynde, Thomas, of Olton, husbandman 0
4172676 2085903 2085903 defendant Crosse Thomas yeoman 607216 607216 Crosse, Thomas, of Olton, yeoman 0
4175739 2086987 2086987 defendant Danyell John husbandman 607216 607216 Danyell, John, of Olton, husbandman 2
4304149 2131583 2131583 defendant Carter Thomas yeoman 607216 607216 Carter, Thomas, of Olton, yeoman 2
4304150 2131583 2131583 defendant Browne Thomas husbandman 607216 607216 Browne, Thomas, of Olton, husbandman 3
4312487 2134503 2134503 defendant Wysdam James yeoman 607216 607216 Wysdam, James, of Olton, yeoman 1
4326514 2139229 2139229 defendant Lyster Roger laborer 607216 607216 Lyster, Roger, of Olton, laborer 3
4406346 2166688 2166688 defendant Brooke Thomas yeoman 607216 607216 Brooke, Thomas, of Olton, yeoman 0
4420105 2171190 2171190 plaintiff Bradewell John de   607216 607216 Bradewell, John de, of Olton, parson 0
4428163 2173641 2173641 defendant Heyward Thomas le   607216 607216 Heyward, Thomas le, of Olton 3
4431537 2174632 2174632 plaintiff Bradewell John de   607216 607216 Bradewell, John de, of Olton, parson 0
4461830 2188764 2188764 defendant Sweteman Richard   607216 607216 Sweteman, Richard, of Olton 2
4536194 2211597 2211597 plaintiff Spryng Reginald   607216 607216 Spryng, Reginald, of Olton 0
4536198 2211597 2211597 defendant Ewell John   607216 607216 Ewell, John, of Olton 3
4599622 2231096 2231096 defendant Boteller William   607216 607216 Boteller, William, of Olton 2
4683079 2260324 2260324 defendant Fustan John yeoman 607216 607216 Fustan, John, of Olton, yeoman 2
4699118 2265189 2265189 plaintiff Edryche William   607216 607216 Edryche, William, of Olton 1
4724870 2273074 2273074 defendant Ardeslowe John chaplain 607216 607216 Ardeslowe, John, of Olton, chaplain 5
4726035 2273428 2273428 defendant Wormebrigge John ploughtman 607216 607216 Wormebrigge, John, of Olton, ploughtman 4
4766107 2285390 2285390 defendant Fuston John husbandman 607216 607216 Fuston, John, of Olton, husbandman 0
4787066 2292017 2292017 defendant Hulle John husbandman 607216 607216 Hulle, John, of Olton, husbandman 4
4836840 2307485 2307485 plaintiff Fastolf John   607216 607216 Fastolf, John, of Olton 0
4836844 2307485 2307485 defendant Hakon Henry husbandman 607216 607216 Hakon, Henry, of Olton, husbandman 0
4836845 2307486 2307486 plaintiff Fastolf John   607216 607216 Fastolf, John, of Olton 0
4836849 2307486 2307486 defendant Hakon Henry husbandman 607216 607216 Hakon, Henry, of Olton, husbandman 0
4854427 2312779 2312779 defendant Dobson William husbandman 607216 607216 Dobson, William, of Olton, husbandman 0
4854643 2312827 2312827 defendant Sawer Henry husbandman 607216 607216 Sawer, Henry, of Olton, husbandman 0
4864104 2315751 2315751 plaintiff Fastolf John esq 607216 607216 Fastolf, John, of Olton, esq 0
4967588 2347248 2347248 plaintiff Fastolf John esq 607216 607216 Fastolf, John, of Olton, esq 0
4989260 2353720 2353720 defendant Fastolf Katherine   607216 607216 Fastolf, Katherine, of Olton, formerly wife of John Fastolf, 3
5055407 2373200 2373200 defendant Dykkes Alan husbandman 607216 607216 Dykkes, Alan, of Olton, husbandman 1
5092437 2384166 2384166 defendant Reder Thomas husbandman 607216 607216 Reder, Thomas, of Olton, husbandman 2
5098600 2386022 2386022 defendant Fastolf John (legal representative) 607216 607216 Fastolf, John, of Olton, executors of 4
5221827 2422082 2422082 defendant Wynston Henry smith 607216 607216 Wynston, Henry, of Olton, smith 0
5284905 2440605 2440605 defendant Herman Robert husbandman 607216 607216 Herman, Robert, of Olton, husbandman 6
5315075 2449563 2449563 defendant Langle Stephen husbandman 607216 607216 Langle, Stephen, of Olton, husbandman 0
5349925 2460107 2460107 defendant Herman Robert husbandman 607216 607216 Herman, Robert, of Olton, husbandman 0
5349926 2460107 2460107 defendant Knobbyng John husbandman 607216 607216 Knobbyng, John, of Olton, husbandman 1
5349927 2460107 2460107 defendant Langlyff Stephen husbandman 607216 607216 Langlyff, Stephen, of Olton, husbandman 2
5349931 2460108 2460108 defendant Herman Robert husbandman 607216 607216 Herman, Robert, of Olton, husbandman 0
5349932 2460108 2460108 defendant Knobbyng John husbandman 607216 607216 Knobbyng, John, of Olton, husbandman 1
5349933 2460108 2460108 defendant Langlyff Stephen husbandman 607216 607216 Langlyff, Stephen, of Olton, husbandman 2
5372596 2467028 2467028 defendant Emery Richard yeoman 607216 607216 Emery, Richard, of Olton, yeoman 0
5372598 2467029 2467029 defendant Emery Richard yeoman 607216 607216 Emery, Richard, of Olton, yeoman 0
5392586 2472947 2472947 defendant Taillour Richard carpenter 607216 607216 Taillour, Richard, of Olton, carpenter 1
5564203 2524139 2524139 defendant Nicols Edmund   607216 607216 Nicols, Edmund, of Olton, wax chandler 2
5588855 2531525 2531525 defendant Emere William husbandman 607216 607216 Emere, William, of Olton, husbandman 1
5588856 2531525 2531525 defendant Hall Richard husbandman 607216 607216 Hall, Richard, of Olton, husbandman 2
5609975 2546825 2546825 defendant Swetman Richard   607216 607216 Swetman, Richard, of Olton 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);