names

32 rows where place_id = 621832

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3743798 1939944 1939944 defendant Long Lawrence husbandman 621832 621832 Long, Lawrence, of Alpheton, husbandman 1
3750723 1942149 1942149 defendant Long Lawrence husbandman 621832 621832 Long, Lawrence, of Alpheton, husbandman 3
3762680 1945964 1945964 defendant Long Lawrence husbandman 621832 621832 Long, Lawrence, of Alpheton, husbandman, son of Long, John, of Alpheton, husbandman 0
3773737 1949502 1949502 defendant Wyffyn Giles (legal representative) 621832 621832 Wyffyn, Giles, of Alpheton, husbandman, executors of 0
3902397 1991032 1991032 defendant Cowper William husbandman 621832 621832 Cowper, William, of Alpheton, husbandman 3
4028936 2034993 2034993 plaintiff Creme John yeoman 621832 621832 Creme, John, of Alpheton, yeoman 0
4306363 2132369 2132369 defendant Ryve William gent 621832 621832 Ryve, William, of Alpheton, gent 1
4306859 2132540 2132540 defendant Reve William gent 621832 621832 Reve, William, of Alpheton, gent 0
4331695 2140898 2140898 defendant Reve William gent 621832 621832 Reve, William, of Alpheton, gent 0
4341984 2144476 2144476 defendant Reve William gent 621832 621832 Reve, William, of Alpheton, gent 0
4386252 2160079 2160079 defendant Reve William gent 621832 621832 Reve, William, of Alpheton, gent 0
4392699 2162177 2162177 defendant Reve William gent 621832 621832 Reve, William, of Alpheton, gent 0
4771685 2287120 2287120 defendant Toneld John   621832 621832 Toneld, John, of Alpheton, wright 0
4772681 2287427 2287427 defendant Kaykyn William yeoman 621832 621832 Kaykyn, William, of Alpheton, yeoman 2
4796829 2295163 2295163 defendant Toneld John   621832 621832 Toneld, John, of Alpheton, wright 0
4884083 2321934 2321934 defendant Maykyn William husbandman 621832 621832 Maykyn, William, of Alpheton, husbandman 1
4889532 2323523 2323523 defendant Manwode Geoffrey husbandman 621832 621832 Manwode, Geoffrey, of Alpheton, husbandman 1
4932670 2336609 2336609 defendant Hauksywode Henry carpenter 621832 621832 Hauksywode, Henry, of Alpheton, carpenter 0
4938774 2338517 2338517 plaintiff Manwode John   621832 621832 Manwode, John, of Alpheton 1
4938778 2338517 2338517 plaintiff Bryght Robert   621832 621832 Bryght, Robert, of Alpheton 5
4938961 2338577 2338577 defendant Manwode Geoffrey husbandman 621832 621832 Manwode, Geoffrey, of Alpheton, husbandman 0
4959634 2344843 2344843 defendant Maykyn John husbandman 621832 621832 Maykyn, John, of Alpheton, husbandman 0
4959635 2344843 2344843 defendant Maykyn Maud widow 621832 621832 Maykyn, Maud, of Alpheton, widow 1
4983301 2351910 2351910 defendant Longe John husbandman 621832 621832 Longe, John, of Alpheton, husbandman 4
4986809 2352993 2352993 defendant Gent John carrier 621832 621832 Gent, John, of Alpheton, carrier 1
5023970 2363921 2363921 defendant Horwode Thomas weaver 621832 621832 Horwode, Thomas, of Alpheton, weaver 2
5215359 2420221 2420221 defendant Horwode William husbandman 621832 621832 Horwode, William, of Alpheton, husbandman 1
5236670 2426309 2426309 defendant Stoke William clerk 621832 621832 Stoke, William, of Alpheton, clerk 3
5279679 2439140 2439140 defendant Maykyn Thomas husbandman 621832 621832 Maykyn, Thomas, of Alpheton, husbandman 0
5343321 2458102 2458102 defendant Cokfeld Richard weaver 621832 621832 Cokfeld, Richard, of Alpheton, weaver 1
5596391 2533782 2533782 defendant Wyffyn Giles husbandman 621832 621832 Wyffyn, Giles, of Alpheton, husbandman 0
5605574 2536623 2536623 defendant Marchall John husbandman 621832 621832 Marchall, John, of Alpheton, 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);