names

44 rows where place_id = 614065

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3701780 1926804 1926804 defendant George John yeoman 614065 614065 George, John, of Ekynton, yeoman 1
3716269 1931382 1931382 defendant Fissher Hugh laborer 614065 614065 Fissher, Hugh, of Ekynton, laborer 0
3716270 1931382 1931382 defendant Wheler Robert laborer 614065 614065 Wheler, Robert, of Ekynton, laborer 1
3716271 1931382 1931382 defendant Fyssher John laborer 614065 614065 Fyssher, John, of Ekynton, laborer 2
3965370 2012503 2012503 defendant Bayly Robert husbandman 614065 614065 Bayly, Robert, of Ekynton, husbandman 0
3965371 2012503 2012503 defendant Bayly Edward husbandman 614065 614065 Bayly, Edward, of Ekynton, husbandman 1
4420657 2171358 2171358 defendant Frene Roger de   614065 614065 Frene, Roger de, of Ekynton, parson of half the church 0
4420662 2171360 2171360 defendant Frene Roger de   614065 614065 Frene, Roger de, of Ekynton, parson of half the church 0
4425490 2172798 2172798 plaintiff Marschal Philip   614065 614065 Marschal, Philip, of Ekynton, son of John 0
4447532 2184143 2184143 plaintiff Elyott Robert   614065 614065 Elyott, Robert, of Ekynton 0
4497514 2199865 2199865 defendant G-- William   614065 614065 G--, William, of Ekynton 2
4518838 2206257 2206257 defendant Gefcok William   614065 614065 Gefcok, William, of Ekynton 0
4539315 2212555 2212555 defendant Tybbes John   614065 614065 Tybbes, John, of Ekynton 0
4583569 2226281 2226281 defendant Saunderson William   614065 614065 Saunderson, William, of Ekynton 4
4611446 2234641 2234641 defendant Bollesovere Robert   614065 614065 Bollesovere, Robert, of Ekynton 0
4654978 2247440 2247440 defendant Sporne John yeoman 614065 614065 Sporne, John, of Ekynton, yeoman 2
4662166 2249641 2249641 defendant Bollessover John yeoman 614065 614065 Bollessover, John, of Ekynton, yeoman 1
4662167 2249641 2249641 defendant Bollessover Robert yeoman 614065 614065 Bollessover, Robert, of Ekynton, yeoman 2
4662576 2249764 2249764 defendant Bollessover John yeoman 614065 614065 Bollessover, John, of Ekynton, yeoman 2
4662577 2249764 2249764 defendant Bollessover Robert yeoman 614065 614065 Bollessover, Robert, of Ekynton, yeoman 3
4681336 2259787 2259787 defendant Hopkynson James tailor 614065 614065 Hopkynson, James, of Ekynton, tailor 0
4693212 2263378 2263378 defendant Mors William husbandman 614065 614065 Mors, William, of Ekynton, husbandman 0
4693213 2263378 2263378 defendant Jakeman Robert husbandman 614065 614065 Jakeman, Robert, of Ekynton, husbandman 1
4693214 2263378 2263378 defendant Gerveys Walter husbandman 614065 614065 together with Gerveys, Walter, of Ekynton, husbandman 2
4693215 2263378 2263378 defendant Phelpes Thomas husbandman 614065 614065 Phelpes, Thomas, of Ekynton, husbandman 3
4693216 2263378 2263378 defendant Smyth John husbandman 614065 614065 Smyth, John, of Ekynton, husbandman 4
4693217 2263378 2263378 defendant Quynt John husbandman 614065 614065 Quynt, John, of Ekynton, husbandman 5
4693219 2263379 2263379 defendant Gerveys Walter husbandman 614065 614065 Gerveys, Walter, of Ekynton, husbandman 0
4693220 2263379 2263379 defendant Phelpes Thomas husbandman 614065 614065 Phelpes, Thomas, of Ekynton, husbandman 1
4693221 2263379 2263379 defendant Smyth John husbandman 614065 614065 Smyth, John, of Ekynton, husbandman 2
4693222 2263379 2263379 defendant Quynt John husbandman 614065 614065 Quynt, John, of Ekynton, husbandman 3
4702007 2266037 2266037 defendant Dyot John husbandman 614065 614065 Dyot, John, of Ekynton, husbandman 3
4771267 2286993 2286993 defendant Horseknave Richard collier 614065 614065 Horseknave, Richard, of Ekynton, collier 4
4850138 2311504 2311504 defendant Weble John husbandman 614065 614065 Weble, John, of Ekynton, husbandman 0
4850139 2311504 2311504 defendant Bonde John husbandman 614065 614065 Bonde, John, of Ekynton, husbandman 1
4945034 2340431 2340431 defendant Motforde Thomas yeoman 614065 614065 Motforde, Thomas, of Ekynton, yeoman 1
5195302 2414374 2414374 defendant Hewys Lawrence yeoman 614065 614065 Hewys, Lawrence, of Ekynton, yeoman 0
5310588 2448203 2448203 defendant Bonde John husbandman 614065 614065 Bonde, John, of Ekynton, husbandman 0
5342938 2457983 2457983 defendant Faukes Thomas husbandman 614065 614065 Faukes, Thomas, of Ekynton, husbandman 0
5494238 2503180 2503180 defendant Handy Richard husbandman 614065 614065 Handy, Richard, of Ekynton, husbandman 0
5561578 2523373 2523373 defendant Wodward John husbandman 614065 614065 Wodward, John, of Ekynton, husbandman 0
5599172 2534620 2534620 defendant Millyngton Thomas laborer 614065 614065 Millyngton, Thomas, of Ekynton, laborer 0
5599173 2534620 2534620 defendant Millar Thomas laborer 614065 614065 Millar, Thomas, of Ekynton, laborer 1
5636221 2555286 2555286 defendant Taillour John welshman 614065 614065 Taillour, John, of Ekynton, welshman 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);