names

18 rows where place_id = 612391

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3693048 1924032 1924032 defendant Luddyk Thomas husbandman 612391 612391 Luddyk, Thomas, of Compton Chamberleyn, husbandman 0
4463478 2189273 2189273 defendant Coleman John   612391 612391 Coleman, John, of Compton Chamberleyn 0
4703625 2266513 2266513 defendant Cocel Roger husbandman 612391 612391 Cocel, Roger, of Compton Chamberleyn, husbandman 0
4703626 2266513 2266513 defendant Savage William husbandman 612391 612391 Savage, William, of Compton Chamberleyn, husbandman 1
4849343 2311273 2311273 defendant Martyn Thomas clerk 612391 612391 Martyn, Thomas, of Compton Chamberleyn, clerk 0
4849344 2311273 2311273 defendant S_yll Richard husbandman 612391 612391 S_yll, Richard, of Compton Chamberleyn, husbandman 1
4877796 2320019 2320019 defendant Santyll Richard husbandman 612391 612391 Santyll, Richard, of Compton Chamberleyn, husbandman 1
4995646 2355537 2355537 defendant Okeborn Walter husbandman 612391 612391 Okeborn, Walter, of Compton Chamberleyn, husbandman 0
4995647 2355537 2355537 defendant Okeborn Thomas laborer 612391 612391 Okeborn, Thomas, of Compton Chamberleyn, laborer 1
5099624 2386326 2386326 defendant Okeborne Walter husbandman 612391 612391 Okeborne, Walter, of Compton Chamberleyn, husbandman 0
5099625 2386326 2386326 defendant Okeborne Thomas husbandman 612391 612391 Okeborne, Thomas, of Compton Chamberleyn, husbandman 1
5099626 2386326 2386326 defendant Barbour Philip husbandman 612391 612391 Barbour, Philip, of Compton Chamberleyn, husbandman 2
5252819 2430994 2430994 defendant White John husbandman 612391 612391 White, John, of Compton Chamberleyn, husbandman 0
5307165 2447143 2447143 defendant Broklas Edmund husbandman 612391 612391 Broklas, Edmund, of Compton Chamberleyn, husbandman 0
5363348 2464190 2464190 defendant Smyth John (legal representative) 612391 612391 Smyth, John, of Compton Chamberleyn, executrix of 1
5479525 2498888 2498888 defendant Nutbeme William husbandman 612391 612391 Nutbeme, William, of Compton Chamberleyn, husbandman 0
5479526 2498888 2498888 defendant Nutbeme JOhn husbandman 612391 612391 Nutbeme, JOhn, of Compton Chamberleyn, husbandman 1
5494633 2503282 2503282 defendant Forde Richard husbandman 612391 612391 Forde, Richard, of Compton Chamberleyn, husbandman 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);