names

29 rows where place_id = 666321

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3980580 2017818 2017818 defendant Proyne Fulk yeoman 666321 666321 Proyne, Fulk, of Sturbridge, Worcs, yeoman 2
3981252 2018059 2018059 defendant Clare Robert yeoman 666321 666321 Clare, Robert, of Sturbridge, Worcs, yeoman 0
3981254 2018060 2018060 defendant Elkoc Thomas yeoman 666321 666321 Elkoc, Thomas, of Sturbridge, Worcs, yeoman 0
3995124 2023004 2023004 defendant Osburne John   666321 666321 Osburne, John, of Sturbridge, Worcs, scythe smith 1
4077766 2052341 2052341 defendant Harte Nicholas chapman 666321 666321 Harte, Nicholas, of Sturbridge, Worcs, chapman 0
4077768 2052342 2052342 defendant Harte Nicholas chapman 666321 666321 Harte, Nicholas, of Sturbridge, Worcs, chapman 0
4077770 2052343 2052343 defendant Wilson Edward yeoman 666321 666321 Wilson, Edward, of Sturbridge, Worcs, yeoman 0
4098132 2059659 2059659 defendant Archbolde Nicholas chapman 666321 666321 Archbolde, Nicholas, of Sturbridge, Worcs, chapman 0
4185284 2090362 2090362 defendant Goode Thomas   666321 666321 Goode, Thomas, of Sturbridge, Worcs, scythe smith 0
4196244 2094231 2094231 defendant Blackemore Richard tailor 666321 666321 Blackemore, Richard, of Sturbridge, Worcs, tailor 1
4196247 2094232 2094232 defendant Blackmore Richard tailor 666321 666321 Blackmore, Richard, of Sturbridge, Worcs, tailor 1
4217463 2101601 2101601 defendant Steward William yeoman 666321 666321 Steward, William, of Sturbridge, Worcs, yeoman 1
4219219 2102219 2102219 defendant Elcock Thomas yeoman 666321 666321 Elcock, Thomas, of Sturbridge, Worcs, yeoman 0
4228251 2105363 2105363 defendant Elcock Thomas yeoman 666321 666321 Elcock, Thomas, of Sturbridge, Worcs, yeoman 0
4260669 2116536 2116536 defendant Osborne Anthony (legal representative) 666321 666321 Osborne, Anthony, of Sturbridge, Worcs, carrier, executors of 0
4292177 2127273 2127273 defendant Elcoxe Thomas mercer 666321 666321 Elcoxe, Thomas, of Sturbridge, Worcs, yeoman, mercer 0
4295864 2128616 2128616 defendant Smythe Roger yeoman 666321 666321 Smythe, Roger, of Sturbridge, Worcs, yeoman 0
4297103 2129064 2129064 defendant Clare Gilbert yeoman 666321 666321 Clare, Gilbert, of Sturbridge, Worcs, yeoman 0
4298727 2129645 2129645 defendant Clare Gilbert yeoman 666321 666321 Clare, Gilbert, of Sturbridge, Worcs, yeoman 1
4304302 2131643 2131643 defendant Gregory Robert yeoman 666321 666321 Gregory, Robert, of Sturbridge, Worcs, yeoman 0
4304306 2131645 2131645 defendant Tyrer William clerk 666321 666321 Tyrer, William, of Sturbridge, Worcs, clerk 0
4310502 2133826 2133826 defendant Elcox Thomas yeoman 666321 666321 Elcox, Thomas, of Sturbridge, Worcs, yeoman 1
4310509 2133829 2133829 defendant Elcock Thomas yeoman 666321 666321 Elcock, Thomas, of Sturbridge, Worcs, yeoman 0
4310548 2133840 2133840 defendant Clare Gilbert innholder 666321 666321 Clare, Gilbert, of Sturbridge, Worcs, innholder 2
4312711 2134578 2134578 defendant Clare Gilbert yeoman 666321 666321 Clare, Gilbert, of Sturbridge, Worcs, yeoman 0
4315038 2135372 2135372 defendant Elcock Thomas yeoman 666321 666321 Elcock, Thomas, of Sturbridge, Worcs, yeoman 0
4327875 2139646 2139646 defendant Madsterd Richard mercer 666321 666321 Madsterd, Richard, of Sturbridge, Worcs, mercer 0
4340419 2143912 2143912 defendant Rock Josiah yeoman 666321 666321 Rock, Josiah, of Sturbridge, Worcs, yeoman 3
4344124 2145226 2145226 defendant Elcock Thomas yeoman 666321 666321 Elcock, Thomas, of Sturbridge, Worcs, yeoman 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);