names

47 rows where place_id = 616851

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3716472 1931444 1931444 defendant Myll George yeoman 616851 616851 Myll, George, of Martley, yeoman 7
3751221 1942306 1942306 defendant Harrys Margery widow 616851 616851 Harrys, Margery, of Martley, widow 0
3751222 1942306 1942306 defendant Harris Edward husbandman 616851 616851 Harris, Edward, of Martley, husbandman 1
3764847 1946672 1946672 defendant Kyrry Edmund husbandman 616851 616851 Kyrry, Edmund, of Martley, husbandman 0
3764848 1946672 1946672 defendant Brownyng Edmund laborer 616851 616851 Brownyng, Edmund, of Martley, laborer 1
3764849 1946672 1946672 defendant Brytton Thomas laborer 616851 616851 Brytton, Thomas, of Martley, laborer 2
3767317 1947422 1947422 defendant Harrys Margery widow 616851 616851 Harrys, Margery, of Martley, widow 0
3767318 1947422 1947422 defendant Harrys Edward husbandman 616851 616851 Harrys, Edward, of Martley, husbandman 1
3781188 1951855 1951855 defendant Tyllam Percival husbandman 616851 616851 Tyllam, Percival, of Martley, husbandman 0
3806665 1959981 1959981 defendant Hawkyns Thomas husbandman 616851 616851 Hawkyns, Thomas, of Martley, husbandman 0
3890577 1987112 1987112 defendant Harreys Edward yeoman 616851 616851 Harreys, Edward, of Martley, yeoman 0
3890579 1987112 1987112 defendant Fydo John husbandman 616851 616851 Fydo, John, of Martley, husbandman 2
3988193 2020524 2020524 defendant Chappell Grancis husbandman 616851 616851 Chappell, Grancis, of Martley, husbandman 0
4004234 2026292 2026292 defendant Alderne Thomas yeoman 616851 616851 Alderne, Thomas, of Martley, yeoman 0
4058428 2045401 2045401 defendant Chappell Edward (legal representative) 616851 616851 Chappell, Edward, of Martley, yeoman, executrix of 0
4058429 2045401 2045401 defendant Chappell Anne widow 616851 616851 Chappell, Anne, of Martley, widow 1
4166579 2083806 2083806 defendant Churche William husbandman 616851 616851 Churche, William, of Martley, husbandman 1
4228009 2105272 2105272 defendant Jones Francis clerk 616851 616851 Jones, Francis, of Martley, clerk 0
4229200 2105696 2105696 defendant Noxon Thomas husbandman 616851 616851 Noxon, Thomas, of Martley, husbandman 0
4231814 2106624 2106624 defendant Dowghtie William yeoman 616851 616851 Dowghtie, William, of Martley, yeoman 1
4233251 2107142 2107142 defendant Jones Francis clerk 616851 616851 Jones, Francis, of Martley, clerk 1
4240662 2109859 2109859 defendant Doughtie William yeoman 616851 616851 Doughtie, William, of Martley, yeoman 1
4241874 2110274 2110274 defendant Jones Francis clerk 616851 616851 Jones, Francis, of Martley, clerk 1
4249160 2112704 2112704 defendant Dowghtie William yeoman 616851 616851 Dowghtie, William, of Martley, yeoman 0
4270172 2119609 2119609 defendant Jones Francis clerk 616851 616851 Jones, Francis, of Martley, clerk 0
4280709 2123157 2123157 defendant Jones Francis clerk 616851 616851 Jones, Francis, of Martley, clerk 0
4280711 2123158 2123158 defendant Smithes John yeoman 616851 616851 Smithes, John, of Martley, yeoman 0
4293934 2127903 2127903 defendant Noyton Thomas husbandman 616851 616851 Noyton, Thomas, of Martley, husbandman 0
4294113 2127974 2127974 defendant Harrys Edward yeoman 616851 616851 Harrys, Edward, of Martley, yeoman 0
4295942 2128647 2128647 defendant Harris alias Rive Richard yeoman 616851 616851 Harris alias Rive, Richard, of Martley, or of Boddington, Glos, yeoman 0
4312001 2134332 2134332 defendant Noxton Thomas husbandman 616851 616851 Noxton, Thomas, of Martley, husbandman 0
4331590 2140863 2140863 defendant Jones Francis clerk 616851 616851 Jones, Francis, of Martley, clerk 0
4331920 2140971 2140971 defendant Jones Francis clerk 616851 616851 Jones, Francis, of Martley, clerk 0
4401707 2165166 2165166 defendant Jones Francis clerk 616851 616851 Jones, Francis, of Martley, clerk 0
4401708 2165166 2165166 defendant Howells Walter yeoman 616851 616851 Howells, Walter, of Martley, yeoman 1
4845209 2310014 2310014 defendant Hornere Richard husbandman 616851 616851 Hornere, Richard, of Martley, husbandman 0
5098915 2386113 2386113 defendant Lyngen Thomas yeoman 616851 616851 Lyngen, Thomas, of Martley, yeoman 3
5098916 2386113 2386113 defendant Lyngen Richard laborer 616851 616851 Lyngen, Richard, of Martley, laborer 4
5098917 2386113 2386113 defendant Dorset Hugh laborer 616851 616851 Dorset, Hugh, of Martley, laborer 5
5098918 2386113 2386113 defendant Lewys Thomas laborer 616851 616851 Lewys, Thomas, of Martley, laborer 6
5098919 2386113 2386113 defendant Howell John laborer 616851 616851 Howell, John, of Martley, laborer 7
5098920 2386113 2386113 defendant Howell Henry laborer 616851 616851 Howell, Henry, of Martley, laborer 8
5098922 2386113 2386113 defendant Smyth William husbandman 616851 616851 Smyth, William, of Martley, husbandman 10
5322040 2451663 2451663 defendant Houseman Thomas yeoman 616851 616851 Houseman, Thomas, of Martley, yeoman 0
5375505 2467928 2467928 defendant Chapell John husbandman 616851 616851 Chapell, John, of Martley, husbandman 0
5526456 2512840 2512840 defendant Acton Thomas gent 616851 616851 Acton, Thomas, of Martley, gent 2
5526457 2512840 2512840 defendant Ketylby John, junior gent 616851 616851 Ketylby, John, junior, of Martley, gent 3

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