names

63 rows where place_id = 595766

✎ 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
3621805 1874357 1874357 defendant Page John husbandman 595766 595766 Page, John, of Chalke, husbandman 0
3622264 1874498 1874498 defendant Boston John husbandman 595766 595766 Boston, John, of Chalke, husbandman 0
3622507 1874577 1874577 defendant Potkyn John husbandman 595766 595766 Potkyn, John, of Chalke, husbandman 0
3622509 1874577 1874577 defendant Tebold Stephen husbandman 595766 595766 Tebold, Stephen, of Chalke, husbandman 2
3622510 1874577 1874577 defendant Girdeler John smith 595766 595766 Girdeler, John, of Chalke, smith 3
3633199 1905197 1905197 defendant Martyn Thomas husbandman 595766 595766 Martyn, Thomas, of Chalke, husbandman 1
3642682 1908157 1908157 defendant Johnson Robert yeoman 595766 595766 Johnson, Robert, of Chalke, yeoman 0
3646754 1909389 1909389 defendant Marten Richard husbandman 595766 595766 Marten, Richard, of Chalke, husbandman 0
3646756 1909390 1909390 defendant Marten Thomas, senior husbandman 595766 595766 Marten, Thomas, senior, of Chalke, husbandman 0
3654425 1911646 1911646 defendant Johnson Robert yeoman 595766 595766 Johnson, Robert, of Chalke, yeoman 0
3657437 1912586 1912586 defendant Franke Servyse yeoman 595766 595766 Franke, Servyse, of Chalke, yeoman 1
3675553 1918390 1918390 defendant Johnson Robert husbandman 595766 595766 Johnson, Robert, of Chalke, husbandman 0
3677824 1919116 1919116 defendant Martyn Thomas husbandman 595766 595766 Martyn, Thomas, of Chalke, husbandman 1
3678730 1919414 1919414 defendant Payn William husbandman 595766 595766 Payn, William, of Chalke, husbandman 3
3678731 1919414 1919414 defendant Chamber Richard husbandman 595766 595766 Chamber, Richard, of Chalke, husbandman 4
3685988 1921776 1921776 defendant Johnson Robert husbandman 595766 595766 Johnson, Robert, of Chalke, husbandman 0
3689441 1922856 1922856 defendant Johnson John laborer 595766 595766 Johnson, John, of Chalke, laborer 0
3776292 1950331 1950331 defendant Stretend Robert husbandman 595766 595766 Stretend, Robert, of Chalke, husbandman 1
3827949 1966608 1966608 plaintiff Burton John yeoman 595766 595766 Burton, John, of Chalke, yeoman 0
3881367 1984034 1984034 defendant Marten Richard husbandman 595766 595766 Marten, Richard, of Chalke, husbandman 2
3963619 2011886 2011886 defendant Parson John husbandman 595766 595766 Parson, John, of Chalke, husbandman 0
4010946 2028694 2028694 defendant Atkynson John clerk 595766 595766 Atkynson, John, of Chalke, clerk 0
4219248 2102225 2102225 defendant Imbetre Thomas yeoman 595766 595766 Imbetre, Thomas, of Chalke, yeoman 2
4322668 2137995 2137995 defendant Holewaye Henry yeoman 595766 595766 Holewaye, Henry, of Chalke, yeoman 0
4334202 2141717 2141717 defendant Hollowaye Henry yeoman 595766 595766 Hollowaye, Henry, of Chalke, yeoman 0
4365506 2152729 2152729 defendant Dan Richard yeoman 595766 595766 Dan, Richard, of Chalke, yeoman 0
4435681 2175910 2175910 defendant Regge John   595766 595766 Regge, John, of Chalke 9
4435701 2175911 2175911 defendant Regge John   595766 595766 Regge, John, of Chalke 9
4512216 2204262 2204262 defendant Hullyng John   595766 595766 Hullyng, John, of Chalke, vicar 0
4603445 2232269 2232269 defendant Chapman John   595766 595766 Chapman, John, of Chalke 0
4681289 2259774 2259774 plaintiff Martyn Richard   595766 595766 Martyn, Richard, of Chalke 0
4691896 2263001 2263001 defendant Alwyn Roger gent 595766 595766 Alwyn, Roger, of Chalke, gent 0
4741562 2278027 2278027 defendant Ewayn John husbandman 595766 595766 Ewayn, John, of Chalke, husbandman 2
4787419 2292134 2292134 defendant Frenssheman John   595766 595766 Frenssheman, John, of Chalke, groom 1
4827197 2304554 2304554 defendant Martyn William, senior laborer 595766 595766 Martyn, William, senior, of Chalke, laborer 0
4833373 2306444 2306444 defendant Derney John hosier 595766 595766 Derney, John, of Chalke, hosier 3
4849180 2311217 2311217 defendant Skynner Richard husbandman 595766 595766 Skynner, Richard, of Chalke, husbandman 2
4849182 2311217 2311217 defendant Stapill Robert husbandman 595766 595766 (Stapill, Robert, of Chalke, husbandman 4
4876841 2319727 2319727 defendant Stapull Robert husbandman 595766 595766 (Stapull, Robert, of Chalke, husbandman 2
4900532 2326809 2326809 defendant Stapull Robert husbandman 595766 595766 (Stapull, Robert, of Chalke, husbandman 3
4982895 2351794 2351794 defendant Golle John butcher 595766 595766 Golle, John, of Chalke, butcher 3
4982897 2351794 2351794 defendant Couper John   595766 595766 Couper, John, of Chalke, bailiff 5
5000930 2357152 2357152 plaintiff Martyn John   595766 595766 Martyn, John, of Chalke 0
5113508 2390338 2390338 defendant Alwyn John gent 595766 595766 Alwyn, John, of Chalke, gent 1
5159991 2404022 2404022 defendant Boston William husbandman 595766 595766 Boston, William, of Chalke, husbandman 2
5174927 2408363 2408363 defendant Boston William husbandman 595766 595766 Boston, William, of Chalke, husbandman 2
5262285 2433952 2433952 defendant Curteys John husbandman 595766 595766 Curteys, John, of Chalke, husbandman 3
5279658 2439131 2439131 defendant Greffrey Leyzonem clerk 595766 595766 Greffrey, Leyzonem, of Chalke, clerk 0
5316772 2450102 2450102 defendant Wulfe Thomas laborer 595766 595766 Wulfe, Thomas, of Chalke, laborer 0
5341027 2457394 2457394 defendant Perys Thomas laborer 595766 595766 Perys, Thomas, of Chalke, laborer 0
5367771 2465550 2465550 defendant Hall Stephen husbandman 595766 595766 Hall, Stephen, of Chalke, husbandman 0
5383350 2470317 2470317 defendant Muddell Stephen husbandman 595766 595766 Muddell, Stephen, of Chalke, husbandman 0
5386947 2471333 2471333 defendant Grygge Thomas husbandman 595766 595766 Grygge, Thomas, of Chalke, husbandman 2
5399436 2474915 2474915 defendant Grygge Thomas husbandman 595766 595766 Grygge, Thomas, of chalke, husbandman 1
5430882 2484178 2484178 defendant Grigge Thomas husbandman 595766 595766 Grigge, Thomas, of Chalke, husbandman 1
5447472 2489132 2489132 defendant Brigge Thomas husbandman 595766 595766 Brigge, Thomas, of Chalke, husbandman 1
5459938 2492901 2492901 defendant Grigge Thomas husbandman 595766 595766 Grigge, Thomas, of Chalke, husbandman 1
5476756 2498050 2498050 defendant Gryg Thomas husbandman 595766 595766 Gryg, Thomas, of Chalke, husbandman 0
5488255 2501387 2501387 defendant Grigge Thomas husbandman 595766 595766 Grigge, Thomas, of Chalke, husbandman 0
5508838 2507616 2507616 defendant Aleyn John butcher 595766 595766 Aleyn, John, of Chalke, butcher 1
5542162 2517679 2517679 defendant Alyn Richard husbandman 595766 595766 Alyn, Richard, of Chalke, husbandman 0
5542163 2517679 2517679 defendant Tebold Stephen husbandman 595766 595766 Tebold, Stephen, of Chalke, husbandman 1
5553131 2520954 2520954 defendant Saunder Robert husbandman 595766 595766 Saunder, Robert, of Chalke, husbandman 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);