names

30 rows where place_id = 606304

✎ 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
3664749 1914923 1914923 defendant Schyngeler alias Holyngton John glover 606304 606304 Schyngeler alias Holyngton, John, of Ludlow, Shrops, glover 3
3664754 1914924 1914924 defendant Schyngeler alias Holyngton John glover 606304 606304 Schyngeler alias Holyngton, John, of Ludlow, Shrops, glover 3
3930857 2000660 2000660 defendant Shrockson Oliver carrier 606304 606304 Shrockson, Oliver, of Ludlow, Shrops, carrier 2
4579384 2225029 2225029 defendant Glover William   606304 606304 Glover, William, of Ludlow, Shrops 0
4694808 2263869 2263869 defendant Hardeley Henry gent 606304 606304 Hardeley, Henry, of Ludlow, Shrops, gent 0
4695884 2264197 2264197 defendant Pennesford John chapman 606304 606304 Pennesford, John, of Ludlow, Shrops, chapman 1
4695887 2264198 2264198 defendant Pennesford John chapman 606304 606304 Pennesford, John, of Ludlow, Shrops, chapman 1
4808660 2298874 2298874 defendant Dytch Geoffrey dyer 606304 606304 Dytch, Geoffrey, of Ludlow, Shrops, dyer 0
4845470 2310097 2310097 plaintiff Parys Thomas merchant 606304 606304 Parys, Thomas, of Ludlow, Shrops, merchant 0
4845570 2310124 2310124 defendant Moyle Robert merchant 606304 606304 Moyle, Robert, of Ludlow, Shrops, merchant 1
4989075 2353671 2353671 defendant Weleynet William walker 606304 606304 Weleynet, William, of Ludlow, Shrops, walker 0
5011637 2360258 2360258 defendant Osbarn Philip chapman 606304 606304 Osbarn, Philip, of Ludlow, Shrops, chapman 0
5011668 2360263 2360263 defendant Brome Roger dyer 606304 606304 Brome, Roger, of Ludlow, Shrops, dyer 3
5011676 2360264 2360264 defendant Brome Roger dyer 606304 606304 Brome, Roger, of Ludlow, Shrops, dyer 3
5135652 2396939 2396939 defendant Beaupe Peter esq 606304 606304 Beaupe, Peter, of Ludlow, Shrops, esq 0
5145517 2399833 2399833 defendant Bowdeler Gillian   606304 606304 Bowdeler, Gillian, of Ludlow, Shrops, widow, relict of John Bowdeler 1
5147176 2400312 2400312 defendant Pempere David merchant 606304 606304 Pempere, David, of Ludlow, Shrops, merchant 1
5155910 2402890 2402890 defendant Beaupe Peter esq 606304 606304 Beaupe, Peter, of Ludlow, Shrops, esq 0
5155913 2402891 2402891 defendant Beaupe Peter esq 606304 606304 Beaupe, Peter, of Ludlow, Shrops, esq 0
5155918 2402892 2402892 defendant Smyth John sheerman 606304 606304 Smyth, John, of Ludlow, Shrops, sheerman 2
5166972 2406072 2406072 defendant Pempere David merchant 606304 606304 Pempere, David, of Ludlow, Shrops, merchant 1
5169533 2406826 2406826 defendant Hunte Walter shoemaker 606304 606304 (Hunte, Walter, of Ludlow, Shrops, shoemaker 2
5180539 2410053 2410053 defendant Bowdeler Gillian widow & relict of John Bowdeler 606304 606304 Bowdeler, Gillian, of Ludlow, Shrops, widow & relict of John Bowdeler 1
5180541 2410054 2410054 defendant Bowdeler John (legal representative) 606304 606304 Bowdeler, John, of Ludlow, Shrops, administratrix of 0
5180542 2410054 2410054 defendant Bowdeler Gillian   606304 606304 Bowdeler, Gillian, of Ludlow, Shrops, widow, relict of John 1
5306078 2446804 2446804 defendant Morton Thomas baker 606304 606304 Morton, Thomas, of Ludlow, Shrops, baker 3
5381626 2469796 2469796 defendant Thlody John yeoman 606304 606304 Thlody, John, of Ludlow, Shrops, yeoman 2
5414045 2479135 2479135 defendant Stevenes Thomas merchant 606304 606304 Stevenes, Thomas, of Ludlow, Shrops, merchant 0
5459182 2492649 2492649 defendant Honybryge Walter draper 606304 606304 Honybryge, Walter, of Ludlow, Shrops, draper 0
5470823 2496202 2496202 defendant Gyneouse John walker 606304 606304 Gyneouse, John, of Ludlow, Shrops, walker 0

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