names

43 rows where place_id = 602498

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3650435 1910504 1910504 defendant Torsheld John husbandman 602498 602498 Torsheld, John, of Althorp, husbandman 0
3656462 1912268 1912268 defendant Mellyng John   602498 602498 Mellyng, John, of Althorp, Shepherd 1
3708124 1928839 1928839 defendant Childe Edmund husbandman 602498 602498 Childe, Edmund, of Althorp, husbandman 0
3708126 1928840 1928840 defendant Chylde Edmund husbandman 602498 602498 Chylde, Edmund, of Althorp, husbandman 0
3708128 1928841 1928841 defendant Chylde Edmund husbandman 602498 602498 Chylde, Edmund, of Althorp, husbandman 0
3708130 1928842 1928842 defendant Chylde Edmund husbandman 602498 602498 Chylde, Edmund, of Althorp, husbandman 0
3796485 1956772 1956772 defendant Spencer William   602498 602498 Spencer, William, of Althorp, knight 0
3899063 1989896 1989896 defendant Dey John yeoman 602498 602498 Dey, John, of Althorp, yeoman 0
4423194 2172112 2172112 plaintiff Holt John de   602498 602498 Holt, John de, of Althorp, parson 1
4423197 2172113 2172113 plaintiff Holt John de   602498 602498 Holt, John de, of Althorp, parson 1
4424134 2172404 2172404 plaintiff Holt John de   602498 602498 Holt, John de, of Althorp, parson 0
4424136 2172405 2172405 plaintiff Holt John de   602498 602498 Holt, John de, of Althorp, parson 0
4453401 2186068 2186068 defendant Beltoft Robert de   602498 602498 Beltoft, Robert de, of Althorp 1
4459944 2188167 2188167 defendant Beltist Robert de   602498 602498 Beltist, Robert de, of Althorp 1
4527590 2208907 2208907 defendant Dirre William   602498 602498 Dirre, William, of Althorp 2
4554771 2217420 2217420 defendant Dyrre William   602498 602498 Dyrre, William, of Althorp 3
4554777 2217421 2217421 defendant Dyrre William   602498 602498 Dyrre, William, of Althorp 3
4587282 2227429 2227429 defendant Warde John   602498 602498 Warde, John, of Althorp 0
4587283 2227429 2227429 defendant Cokes Hugh   602498 602498 Cokes, Hugh, of Althorp 1
4707293 2267658 2267658 defendant Frost William yeoman 602498 602498 Frost, William, of Althorp, yeoman 1
4747815 2279868 2279868 defendant Drory John yeoman 602498 602498 Drory, John, of Althorp, yeoman 1
4751688 2280982 2280982 defendant Deye Richard laborer 602498 602498 Deye, Richard, of Althorp, laborer 3
4802759 2297049 2297049 plaintiff atte Halle Thomas   602498 602498 atte Halle, Thomas, of Althorp, parson 0
4802762 2297050 2297050 plaintiff atte Halle Thomas   602498 602498 atte Halle, Thomas, of Althorp, parson 0
4813421 2300310 2300310 defendant Frost William yeoman 602498 602498 Frost, William, of Althorp, yeoman 4
4813422 2300310 2300310 defendant Dalymond William yeoman 602498 602498 Dalymond, William, of Althorp, yeoman 5
4816896 2301388 2301388 defendant Frost William husbandman 602498 602498 Frost, William, of Althorp, husbandman 1
4834603 2306826 2306826 defendant atte Hall Thomas   602498 602498 atte Hall, Thomas, of Althorp, parson 0
4855099 2312945 2312945 defendant Jakson John chaplain 602498 602498 Jakson, John, of Althorp, chaplain 0
4868893 2317247 2317247 defendant Frost William yeoman 602498 602498 Frost, William, of Althorp, yeoman 0
4874520 2318974 2318974 defendant Frost William yeoman 602498 602498 Frost, William, of Althorp, yeoman 1
4901203 2326986 2326986 defendant Crabgate John husbandman 602498 602498 Crabgate, John, of Althorp, husbandman 9
4908534 2329227 2329227 plaintiff atte Hall Thomas (legal representative) 602498 602498 atte Hall, Thomas, of Althorp, parson, executor of 0
4928668 2335393 2335393 defendant Travers Thomas husbandman 602498 602498 Travers, Thomas, of Althorp, husbandman 0
4963936 2346124 2346124 defendant Borey Henry yeoman 602498 602498 Borey, Henry, of Althorp, yeoman 1
4969985 2347973 2347973 defendant Bolsore Robert yeoman 602498 602498 Bolsore, Robert, of Althorp, yeoman 0
4982744 2351749 2351749 defendant Inglysshe Richard shoemaker 602498 602498 Inglysshe, Richard, of Althorp, shoemaker 0
5104249 2387666 2387666 defendant Harpour John husbandman 602498 602498 Harpour, John, of Althorp, husbandman 0
5115281 2390897 2390897 defendant Collys Simon laborer 602498 602498 Collys, Simon, of Althorp, laborer 1
5290236 2442147 2442147 plaintiff Nevill John esq 602498 602498 Nevill, John, of Althorp, esq 0
5462424 2493661 2493661 defendant Eye Richard husbandman 602498 602498 Eye, Richard, of Althorp, husbandman 1
5551098 2520345 2520345 defendant Catesby John (legal representative) 602498 602498 Catesby, John, of Althorp, esq, executor of 0
5551099 2520345 2520345 defendant Catesby John esq 602498 602498 Catesby, John, of Althorp, esq 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);