names

22 rows where place_id = 642365

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3867518 1979373 1979373 defendant Watte John husbandman 642365 642365 Watte, John, of Congesbury, husbandman 0
4548259 2215397 2215397 plaintiff Chery John   642365 642365 Chery, John, of Congesbury 0
4621227 2237627 2237627 defendant Duke William   642365 642365 Duke, William, of Congesbury 3
4624381 2238605 2238605 plaintiff Nevyle John   642365 642365 Nevyle, John, of Congesbury 0
4681571 2259848 2259848 defendant Malet William husbandman 642365 642365 Malet, William, of Congesbury, husbandman 0
4681573 2259849 2259849 defendant Malet William husbandman 642365 642365 Malet, William, of congesbury, husbandman 0
4697923 2264841 2264841 defendant Kene Robert   642365 642365 Kene, Robert, of Congesbury, vicar 0
4723993 2272803 2272803 plaintiff Dyngherst John   642365 642365 Dyngherst, John, of Congesbury 0
4763551 2284584 2284584 defendant Kene Robert   642365 642365 Kene, Robert, of Congesbury, vicar 0
4795399 2294717 2294717 defendant Mychell John husbandman 642365 642365 Mychell, John, of Congesbury, husbandman 3
4943588 2339962 2339962 defendant Clerke John husbandman 642365 642365 Clerke, John, of Congesbury, husbandman 2
4959237 2344731 2344731 defendant Nevyle John husbandman 642365 642365 Nevyle, John, of Congesbury, husbandman 0
4971960 2348550 2348550 defendant Smyth John smith 642365 642365 Smyth, John, of Congesbury, smith 0
5002208 2357551 2357551 defendant Duke Thomas husbandman 642365 642365 Duke, Thomas, of Congesbury, husbandman 1
5046462 2370583 2370583 defendant Noble John husbandman 642365 642365 Noble, John, of Congesbury, husbandman 0
5058792 2374195 2374195 defendant Smyth John smith 642365 642365 Smyth, John, of Congesbury, smith 1
5125226 2393855 2393855 defendant Austyn John husbandman 642365 642365 Austyn, John, of Congesbury, husbandman 0
5143812 2399325 2399325 defendant Austyn John husbandman 642365 642365 Austyn, John, of Congesbury, husbandman 0
5144282 2399482 2399482 defendant Chyppely John chaplain 642365 642365 Chyppely, John, of Congesbury, chaplain 0
5165186 2405560 2405560 defendant Chyppeley John chaplain 642365 642365 Chyppeley, John, of Congesbury, chaplain 0
5230307 2424482 2424482 defendant Clerke Henry husbandman 642365 642365 Clerke, Henry, of Congesbury, husbandman 2
5363242 2464157 2464157 defendant Dyke William laborer 642365 642365 Dyke, William, of Congesbury, laborer 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);